27.05.2014, 19:42
I'ts made like this now, and it works just prfect!!
Is there any way to make it in less lines, i dont want to make 3000 lines for this.
Код HTML:
Saving:
format(query,sizeof(query),"UPDATE `userdata` SET `gender` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pGender], name);
mysql_query(query);
//
//dini_IntSet(file, "Level", PlayerInfo[playerid][pLevel]);//
//
format(query,sizeof(query),"UPDATE `userdata` SET `level` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pLevel], name);
mysql_query(query);
//
dini_IntSet(file, "Minutes", PlayerInfo[playerid][pMinutes]);
//dini_IntSet(file, "Hours", PlayerInfo[playerid][pHours]);
//
format(query,sizeof(query),"UPDATE `userdata` SET `hours` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pHours], name);
mysql_query(query);
Loading
//PlayerInfo[playerid][pGender] = dini_Int(file, "Gender");
format(query, sizeof(query), "SELECT `gender` FROM `userdata` WHERE `username` = '%s'", name);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
new temp[10];
mysql_fetch_row(temp);
PlayerInfo[playerid][pGender] = strval(temp);
}
mysql_free_result();
//PlayerInfo[playerid][pLevel] = dini_Int(file, "Level");
if(PlayerInfo[playerid][pLevel] == 0) PlayerInfo[playerid][pLevel] = 1;
format(query, sizeof(query), "SELECT `level` FROM `userdata` WHERE `username` = '%s'", name);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
new temp[10];
mysql_fetch_row(temp);
PlayerInfo[playerid][pLevel] = strval(temp);
}
mysql_free_result();

