How to MySQL + COD2 ?

[suck000]

i get error when i try execute persistence.gsc !

		#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eventAddGetMoney(name,value)
{
    player = self' at line 68 
	

help please

[IzNoGoD]

no.
10characters

[suck000]

:/
10chars

[suck000]

		> [INFO] Compiled for: CoD2 1.0
Compiled: Apr 17 2016 11:35:22 using GCC 4.8.4
> [PLUGIN LOADED]
CoD2 MP 1.0 build linux-i386 Oct 24 2005
----- FS_Startup -----
Current search path:
/home/codserver/server/mod/zzz_all_rifles_v1.5.iwd (18 files)
/home/codserver/server/mod/oneshot.iwd (57 files)
/home/codserver/server/mod
/home/codserver/server/main/wawa.iwd (11 files)
/home/codserver/server/main/iw_14.iwd (4038 files)
/home/codserver/server/main/iw_13.iwd (22624 files)
/home/codserver/server/main/iw_12.iwd (1016 files)
/home/codserver/server/main/iw_11.iwd (1462 files)
/home/codserver/server/main/iw_10.iwd (1936 files)
/home/codserver/server/main/iw_09.iwd (2142 files)
/home/codserver/server/main/iw_08.iwd (2723 files)
/home/codserver/server/main/iw_07.iwd (3384 files)
/home/codserver/server/main/iw_06.iwd (990 files)
/home/codserver/server/main/iw_05.iwd (928 files)
/home/codserver/server/main/iw_04.iwd (698 files)
/home/codserver/server/main/iw_03.iwd (26 files)
/home/codserver/server/main/iw_02.iwd (40 files)
/home/codserver/server/main/iw_01.iwd (16 files)
/home/codserver/server/main/iw_00.iwd (102 files)
/home/codserver/server/main
/home/codserver/server/raw
/home/codserver/server/raw_shared
/home/codserver/server/devraw
/home/codserver/server/devraw_shared

File Handles:
----------------------
42211 files in iwd files
execing default_mp.cfg
couldn't exec language.cfg
execing config_mp_server.cfg
fs_homepath is write protected.
fs_game is write protected.
fs_basepath is write protected.
Opening IP socket: localhost:28960
Hostname: MyVPS
IP: 89.36.208.230
--- Common Initialization Complete ---
fs_homepath is write protected.
fs_game is write protected.
net_port is write protected.
fs_basepath is write protected.
execing server.cfg
net_ip is write protected.
net_port is write protected.
dedicated is read only.
map_rotate...

"sv_mapRotation" is:"gametype tdm map mp_toujane gametype tdm map mp_carentan gametype tdm map mp_trainstation gametype tdm map mp_decoy gametype tdm map mp_farmhouse gametype tdm map mp_burgundy gametype tdm map mp_brecourt gametype tdm map mp_railyard gametype tdm map mp_downtown gametype tdm map mp_leningrad gametype tdm map mp_dawnville gametype tdm map mp_matmata gametype tdm map mp_breakout"

"sv_mapRotationCurrent" is:""

Setting g_gametype: tdm.
Setting map: mp_toujane.
manymaps> map=mp_toujane sv_iwdNames:
manymaps> link src=/home/codserver/server/mod/Library/mp_toujane.iwd dst=/home/codserver/server/mod/mp_toujane.iwd
------ Server Initialization ------
Server: mp_toujane
----- FS_Startup -----
Current search path:
/home/codserver/server/mod/zzz_all_rifles_v1.5.iwd (18 files)
/home/codserver/server/mod/oneshot.iwd (57 files)
/home/codserver/server/mod
/home/codserver/server/main/wawa.iwd (11 files)
/home/codserver/server/main/iw_14.iwd (4038 files)
/home/codserver/server/main/iw_13.iwd (22624 files)
/home/codserver/server/main/iw_12.iwd (1016 files)
/home/codserver/server/main/iw_11.iwd (1462 files)
/home/codserver/server/main/iw_10.iwd (1936 files)
/home/codserver/server/main/iw_09.iwd (2142 files)
/home/codserver/server/main/iw_08.iwd (2723 files)
/home/codserver/server/main/iw_07.iwd (3384 files)
/home/codserver/server/main/iw_06.iwd (990 files)
/home/codserver/server/main/iw_05.iwd (928 files)
/home/codserver/server/main/iw_04.iwd (698 files)
/home/codserver/server/main/iw_03.iwd (26 files)
/home/codserver/server/main/iw_02.iwd (40 files)
/home/codserver/server/main/iw_01.iwd (16 files)
/home/codserver/server/main/iw_00.iwd (102 files)
/home/codserver/server/main
/home/codserver/server/raw
/home/codserver/server/raw_shared
/home/codserver/server/devraw
/home/codserver/server/devraw_shared

File Handles:
----------------------
42211 files in iwd files
------- Game Initialization -------
gamename: Call of Duty 2
gamedate: Oct 24 2005
----------------------
Game: G_SetupWeaponDef
----------------------

******* script compile error *******
unknown function: (file 'maps/mp/gametypes/_mysql.gsc', line 145)
        return mysql_real_escape_string(level.JH_mysql, string);
               *
************************************
Sys_Error: Error during initialization:
script compile error
(see console for details) 
	

i get this error when starting my server with mysql

_mysql.gsc file :

		init()
{
    //get your host, user, pass, db, port here
    level.JH_mysql = mysql_reuse_connection();
    if(!isDefined(level.JH_mysql))
        level.JH_mysql = initMySQL("localhost", "myuserhere", "mypasshere", "mydbhere", 3306);
    initAsyncMySQL("localhost", "myuserhere", "mypasshere", "mydbhere", 3306);
}

query(query)
{
    if(!isDefined(level.JH_mysql))
        return undefined;
    result = mysql_query(level.JH_mysql, query);
    resettimeout();
    if(result)
    {
        printf("Error in " + query + "\n");
        return undefined;
    }
    result = mysql_store_result(level.JH_mysql);
    rows = getRows(result);
    return rows;
}

queryNosave(query)
{
    if(!isDefined(level.JH_mysql))
        return undefined;
    result = mysql_query(level.JH_mysql, query);
    resettimeout();
    if(result)
    {
        printf("Error in " + query + "\n");
        return undefined;
    }
    return [];
}

getRows(result)
{
    if(!isDefined(result))
        return [];
    rowcount = mysql_num_rows(result);
    fields = [];
    field = mysql_fetch_field(result);
    while(isDefined(field))
    {
        fields[fields.size] = field;
        field = mysql_fetch_field(result);
    }
    rows = [];
    for(i = 0; i < rowcount; i++)
    {
        row = mysql_fetch_row(result);
        rows[rows.size] = [];
        for(j = 0; j < fields.size; j++)
            rows[rows.size - 1][fields[j]] = row[j];
    }
    mysql_free_result(result);
    return rows;
}

asyncQuery(query, function, args)
{
    id = mysql_async_createQuery(query);
    task = spawnstruct();
    task.query = query;
    task.invoker = self;
    task.function = function;
    task.args = args;
    level.JH_mysqlAsync["" + id] = task;
}

asyncQueryNosave(query, function, args)
{
    id = mysql_async_createQueryNosave(query);
    task = spawnstruct();
    task.query = query;
    task.invoker = self;
    task.function = function;
    task.args = args;
    level.JH_mysqlAsync["" + id] = task;
}

initAsyncMySQL(host, user, pass, db, port)
{
    mysql_async_initializer(host, user, pass, db, port, 4);
    level.JH_mysqlAsync = [];
    thread loopAsyncMySQL();
}

loopAsyncMySQL()
{
    while(true)
    {
        list = mysql_async_GetDoneList();
        for(i = 0; i < list.size; i++)
        {
            result = mysql_async_getResultAndFree(list[i]);
            if(!isdefined(result))
                continue;
            if(result == 0)
                result = undefined;
            task = "" + list[i];
            if(isDefined(level.JH_mysqlAsync[task]))
            {
                if(isDefined(level.JH_mysqlAsync[task].function))
                {
                    if(isDefined(level.JH_mysqlAsync[task].invoker))
                    {
                        rows = getRows(result);
                        level.JH_mysqlAsync[task].invoker thread [[level.JH_mysqlAsync[task].function]](rows, level.JH_mysqlAsync[task].args);
                    }
                    else if(isDefined(result))
                        mysql_free_result(result);
                }
                else if(isDefined(result))
                    mysql_free_result(result);
            }
            else if(isDefined(result))
                mysql_free_result(result);
            level.JH_mysqlAsync[task] = undefined;
        }
        wait .05;
    }
}

initMySQL(host, user, pass, db, port)
{
    mysql = mysql_init();
    ret = mysql_real_connect(mysql, host, user, pass, db, port);
    if(!ret)
    {
        printf("errno=" + mysql_errno(mysql) + " error= " + mysql_error(mysql) + "\n");
        mysql_close(mysql);
        return undefined;
    }
    return mysql;
}

stripString(string)
{
    if(isDefined(level.JH_mysql))
        return mysql_real_escape_string(level.JH_mysql, string);
    return "";
} 
	

I added _mysql to Callback_StartGameType already :

		thread map\mp\gametype\_mysql::init(); 
	

Am using mitch libcod and already mysqllibcod installed .. what is the problem !

[IzNoGoD]

You're using a libcod version thats compiled without mysql support it seems.

[suck000]

I downloaded a 2015-Jan-29 01:25:40 copy and placed it on libcod/bin folder , by the way am using mitch's libcod.

Also , that problem that i wrote earlier on disappeard right now when i replaced the 2015-Jan-29 01:25:40 libcod2_1_0 but i got a new one :S

		******* script compile error *******
unknown function: (file 'maps/mp/gametypes/_mysql.gsc', line 100)
            result = mysql_async_getResultAndFree(list[i]);
                     *
************************************
Sys_Error: Error during initialization:
script compile error
(see console for details) 
	

[IzNoGoD]

Yep, those are functions renamed by me in my own libcod. Rename it back to mysql_async_get_result_and_free

Same for other camelCase functions you find non-existing.

[suck000]

Am going to delete mitch libcod and install yours. It will work than right ?

[suck000]

No more mysql errors ! but i get unknown fuction in all my functions on _callbacksetup.gsc file :O

Am using iznogod libcod.

[IzNoGoD]

I never made my libcod publicly available, so I'm curious how you're running "my libcod"