Store player informations with MySQL.

[ebusiangamers]

The problem is solved! Thanks IzNoGod!
Indeed all informations are uploaded/downloaded as string, I post the final version of the functions (that work):

		get_db_field(fieldname, vartype)
{
    if(isDefined(self.isbot))
        return undefined;
    
    if(fieldname == "user_guid")
        mysql_query(level.mysql_connection, "SELECT `"+fieldname+"` FROM `"+level.table+"` WHERE `user_name`= '"+self.name+"' LIMIT 1");
    else
        mysql_query(level.mysql_connection, "SELECT `"+fieldname+"` FROM `"+level.table+"` WHERE `user_guid`= '"+self.guid+"' LIMIT 1");
    r = mysql_store_result(level.mysql_connection);
    if(isdefined(r))
    {
        row = mysql_fetch_row(r);
        if(isdefined(row) && isdefined(row[0]))
        {
            mysql_free_result(r);
            if(vartype == "int")
                row[0] = (int)(row[0]);
            if(vartype == "float")
                row[0] = (float)(row[0]);
            return row[0];
        }
        mysql_free_result(r);
    }
    
    if(vartype == "int" || vartype == "float")
        return 0;
    else
        return undefined;

}  

set_db_field(fieldname, value) 
{
    if(isDefined(self.isBot))
        return;
    
    mysql_query(level.mysql_connection, "INSERT INTO `"+level.table+"`(`user_guid`, `"+fieldname+"`) VALUES ('"+self.guid+"', "+value+") ON DUPLICATE KEY UPDATE `"+fieldname+"`="+value+"");
    
    wait 0.05;
}

set_db_field_string(fieldname, value) 
{
    if(isDefined(self.isBot))
        return;
    
    mysql_query(level.mysql_connection, "INSERT INTO `"+level.table+"`(`user_guid`, `"+fieldname+"`) VALUES ('"+self.guid+"', '"+value+"') ON DUPLICATE KEY UPDATE `"+fieldname+"`='"+value+"'");
    wait 0.05;
} 
	

I want to learn to create something like CoDExtended or whatsoever, where should I start?

[serthy]

I want to learn to create something like CoDExtended or whatsoever, where should I start?

1. Grab a cold beer
2. Place your freshly wetted lips onto it and enjoy
3. Have some programming expirience in C and understand the basics (pointer arithmetics etc.) also know some CoD-Script (its kind of managed and simplified C)
4. have a look here:
   • [Tutorial] Add libcod support for your cod version.
   • [Tutorial] How to create your own libcod function
5. post some extensions on killtube.org

If you want to hook some other games/programs, you can also have a look at ollydbg etc. and watch some easy tutorials on how to simply bypass instructions etc. or inject some dll or have an API hook with 'detours' (windows)