you mean this ?
Code:
init()
{
//get your host, user, pass, db, port here
level.JH_mysql = mysql_reuse_connection();
if(!isDefined(level.JH_mysql))
level.JH_mysql = initMySQL(host, user, pass, db, port);
initAsyncMySQL(host, user, pass, db, port);
}
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 "";
}
and in my gametype gsc ive got
Code:
Callback_StartGameType()
{
//MYSQL
maps\mp\gametypes\_mysql::init();
shouldn't that be initializing it ?
//////////////////////////////
Ive got STD folder in main
Heres My DB tables shouldnt be an issue
i get this error
Code:
*****@ubuntu:~/cod2$ ./startserver.sh
> [LIBCOD] Compiled for: CoD2 1.3
> [LIBCOD] Compiled Aug 4 2017 18:22:39 using GCC 4.8.4
> [PLUGIN LOADED]
CoD2 MP 1.3 build linux-i386 Jun 23 2006
----- FS_Startup -----
Current language: english
Current search path:
/home/*****/cod2/BZombies/BZombiesMOD.iwd (24 files)
/home/*****/cod2/BZombies
/home/*****/cod2/main/iw_15.iwd (85 files)
/home/*****/cod2/main/iw_14.iwd (4038 files)
/home/*****/cod2/main/iw_13.iwd (22624 files)
/home/*****/cod2/main/iw_12.iwd (1016 files)
/home/*****/cod2/main/iw_11.iwd (1462 files)
/home/*****/cod2/main/iw_10.iwd (1936 files)
/home/*****/cod2/main/iw_09.iwd (2142 files)
/home/*****/cod2/main/iw_08.iwd (2723 files)
/home/*****/cod2/main/iw_07.iwd (3384 files)
/home/*****/cod2/main/iw_06.iwd (990 files)
/home/*****/cod2/main/iw_05.iwd (928 files)
/home/*****/cod2/main/iw_04.iwd (698 files)
/home/*****/cod2/main/iw_03.iwd (26 files)
/home/*****/cod2/main/iw_02.iwd (40 files)
/home/*****/cod2/main/iw_01.iwd (16 files)
/home/*****/cod2/main/iw_00.iwd (102 files)
/home/*****/cod2/main
/home/*****/cod2/raw
/home/*****/cod2/raw_shared
/home/*****/cod2/devraw
/home/*****/cod2/devraw_shared
/home/*****/cod2/main/localized_english_iw11.iwd (1 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw10.iwd (414 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw09.iwd (98 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw08.iwd (8 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw07.iwd (1014 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw06.iwd (3110 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw05.iwd (5310 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw04.iwd (6240 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw03.iwd (6580 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw02.iwd (6404 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw01.iwd (5510 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw00.iwd (4764 files)
localized assets iwd file for english
File Handles:
----------------------
81687 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: ubuntu
IP: 127.0.1.1
--- Common Initialization Complete ---
fs_homepath is write protected.
fs_game is write protected.
net_port is write protected.
fs_basepath is write protected.
execing BZombiesServer.cfg
couldn't exec mysql.cfg
sv_cheats is write protected.
net_ip is write protected.
net_port is write protected.
'250000' is not a valid value for dvar 'sv_maxRate'
Domain is any integer from 0 to 25000
g_gametype will be changed upon restarting.
execing zombi3s.cfg
map_rotate...
"sv_mapRotation" is:"gametype zom map mp_carentan"
"sv_mapRotationCurrent" is:""
Setting g_gametype: zom.
Setting map: mp_carentan.
------ Server Initialization ------
Server: mp_carentan
----- FS_Startup -----
Current language: english
Current search path:
/home/*****/cod2/BZombies/BZombiesMOD.iwd (24 files)
/home/*****/cod2/BZombies
/home/*****/cod2/main/iw_15.iwd (85 files)
/home/*****/cod2/main/iw_14.iwd (4038 files)
/home/*****/cod2/main/iw_13.iwd (22624 files)
/home/*****/cod2/main/iw_12.iwd (1016 files)
/home/*****/cod2/main/iw_11.iwd (1462 files)
/home/*****/cod2/main/iw_10.iwd (1936 files)
/home/*****/cod2/main/iw_09.iwd (2142 files)
/home/*****/cod2/main/iw_08.iwd (2723 files)
/home/*****/cod2/main/iw_07.iwd (3384 files)
/home/*****/cod2/main/iw_06.iwd (990 files)
/home/*****/cod2/main/iw_05.iwd (928 files)
/home/*****/cod2/main/iw_04.iwd (698 files)
/home/*****/cod2/main/iw_03.iwd (26 files)
/home/*****/cod2/main/iw_02.iwd (40 files)
/home/*****/cod2/main/iw_01.iwd (16 files)
/home/*****/cod2/main/iw_00.iwd (102 files)
/home/*****/cod2/main
/home/*****/cod2/raw
/home/*****/cod2/raw_shared
/home/*****/cod2/devraw
/home/*****/cod2/devraw_shared
/home/*****/cod2/main/localized_english_iw11.iwd (1 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw10.iwd (414 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw09.iwd (98 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw08.iwd (8 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw07.iwd (1014 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw06.iwd (3110 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw05.iwd (5310 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw04.iwd (6240 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw03.iwd (6580 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw02.iwd (6404 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw01.iwd (5510 files)
localized assets iwd file for english
/home/*****/cod2/main/localized_english_iw00.iwd (4764 files)
localized assets iwd file for english
File Handles:
----------------------
81687 files in iwd files
------- Game Initialization -------
gamename: Call of Duty 2
gamedate: Jun 23 2006
******* script compile error *******
uninitialised variable 'port'
************************************
Sys_Error: Error during initialization:
script compile error
(see console for details)
> [PLUGIN UNLOADED]
*****@ubuntu:~/cod2$
if i change port to 3306 , it just shows uninitialised variable '3306' as so on