25.06.2012, 17:05
ok im working on some MySql project..
i have managed toconnect the server with my websites MySql
but now this
i debuged the print out from OnQueryFinish it all displays fine but then after i check the MySql database this is what comes up
i have managed toconnect the server with my websites MySql
but now this
pawn Код:
mysql_function_query(connectionHandle, "CREATE TABLE IF NOT EXISTS memmbers(Username VARCHAR(24), Money INT(20), Score INT(20), IP VARCHAR(16) , TOS VARCHAR(16) )",false,"OnQueryFinish","","");
new pname[24], IP[16];
GetPlayerName(playerid, pname, 24);
GetPlayerIp(playerid, IP, 16);
//dont worry about the TStr
mysql_function_query(connectionHandle,"INSERT INTO memmbers (Username, Money, Score, IP, TOS) VALUES ('%s','%d','%d','%s','%s')",false,"OnQueryFinish","siiss",pname,GetPlayerMoney(playerid), GetPlayerScore(playerid), IP,TStr);
Код:
Username Money Score IP TOS %s 0 0 %s 0