01.09.2012, 13:07
Hello!
i scripted a register script using mysql, in that i have made total 20 functions like score, kill, deaths, level etc...
See the code
This list of functions are showing in the database but when a player register it is not saving in the database
And the main problem which i got understand is, till this much is saving when a player register
That means only 16 functions are saving and after i add, it wont save (It says rows = 0 in database) .I dont know why it is like that.
Please help me.
i scripted a register script using mysql, in that i have made total 20 functions like score, kill, deaths, level etc...
See the code
pawn Код:
stock MySQL_Register(playerid, passwordstring[])
{
new query[1500], pname[24], IP[15];
GetPlayerName(playerid, pname, 24);
GetPlayerIp(playerid, IP, 15);
//format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapons, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, RIB, unlimitedb, quickweapons, vgoto, playerfly, TP) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
mysql_query(query);
SendClientMessage(playerid, -1,"Info: You have been registered on this server!");
PlayerInfo[playerid][LoggedIn] = 1;
PlayerInfo[playerid][Registered] = 1;
return 1;
}
stock MySQL_Login(playerid)
{
new query[1500], pname[24], savingstring[1600];
GetPlayerName(playerid, pname, 24);
//format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,quickweapons, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz WHERE user = '%s'", pname);
format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, RIB, unlimitedb, quickweapons, vgoto, playerfly, TIP WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
mysql_fetch_field_row(savingstring, "registered"); PlayerInfo[playerid][Registered] = strval(savingstring);
mysql_fetch_field_row(savingstring, "loggedin"); PlayerInfo[playerid][LoggedIn] = strval(savingstring);
mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][Level] = strval(savingstring);
mysql_fetch_field_row(savingstring, "cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
mysql_fetch_field_row(savingstring, "cakes"); PlayerInfo[playerid][Cakes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "biscuits"); PlayerInfo[playerid][Biscuits] = strval(savingstring);
mysql_fetch_field_row(savingstring, "icecreams"); PlayerInfo[playerid][IceCreams] = strval(savingstring);
mysql_fetch_field_row(savingstring, "RIB"); PlayerInfo[playerid][RIB] = strval(savingstring);
mysql_fetch_field_row(savingstring, "unlimitedb"); PlayerInfo[playerid][Unlimitedb] = strval(savingstring);
mysql_fetch_field_row(savingstring, "quickweapons"); PlayerInfo[playerid][Quickweapon] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vgoto"); PlayerInfo[playerid][Vgoto] = strval(savingstring);
mysql_fetch_field_row(savingstring, "playerfly"); PlayerInfo[playerid][PlayerFly] = strval(savingstring);
mysql_fetch_field_row(savingstring, "TP"); PlayerInfo[playerid][TIP] = strval(savingstring);
}
mysql_free_result();
JustLogged[playerid] = 1;
PlayerInfo[playerid][LoggedIn] = 1;
SendClientMessage(playerid, -1,"Info: You have been logged-in!");
return 1;
}
stock GetName(playerid)
{
new pname[24];
GetPlayerName(playerid, pname, 24);
return pname;
}
And the main problem which i got understand is, till this much is saving when a player register
pawn Код:
mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
mysql_fetch_field_row(savingstring, "registered"); PlayerInfo[playerid][Registered] = strval(savingstring);
mysql_fetch_field_row(savingstring, "loggedin"); PlayerInfo[playerid][LoggedIn] = strval(savingstring);
mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][Level] = strval(savingstring);
mysql_fetch_field_row(savingstring, "cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
mysql_fetch_field_row(savingstring, "cakes"); PlayerInfo[playerid][Cakes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "biscuits"); PlayerInfo[playerid][Biscuits] = strval(savingstring);
mysql_fetch_field_row(savingstring, "icecreams"); PlayerInfo[playerid][IceCreams] = strval(savingstring);
mysql_fetch_field_row(savingstring, "RIB"); PlayerInfo[playerid][RIB] = strval(savingstring);
mysql_fetch_field_row(savingstring, "unlimitedb"); PlayerInfo[playerid][Unlimitedb] = strval(savingstring);
Please help me.