I've got a problem with MySQL. I don't know what's wrong. After this MySQL is still the same. There's no players table.
.gsc script
PHP Code:
mysql = std\mysql::mysql_real_connect(std\mysql::mysql_init(), level.mysqlAdress, level.mysqlUser, level.mysqlPass, level.mysqlDb, level.mysqlPort)
std\mysql::mysql_query(mysql, "CREATE TABLE players (id int NOT NULL AUTO_INCREMENT, name varchar(30), score varchar(12), kills varchar(9), PRIMARY KEY(id))");
std\mysql::mysql_close(mysql);
.sh script
Code:
cd /home/cod4/zombie
LD_LIBRARY_PATH="/home/libcod/mysql" LD_PRELOAD="/home/libcod/libcod4_1_7.so" ./cod4x17a_lnxded +set dedicated "2" +set net_port "28961" +set fs_basepath "/home/cod4/zombie/" +set fs_game "mods/nlMod" +exec nlMod.cfg +map_rotate
Contents of /home/libcod:
Code:
root@blanco:/home/libcod# ls
libastar.so libcod2_1_2.so libcod2.so mysql
libcod1_1_5.so libcod2_1_3.so libcod4_1_7.so
Contents of /home/libcod/mysql:
Code:
root@blanco:/home/libcod/mysql# ls
libmysqlclient.a libmysqlclient.so libmysql.so.16
libmysqlclient_r.so libmysql.so libmysql.so.16.0.0