10.10.2013, 16:31
I don't really get what you mean, registering a player you should only Insert their Name, Password. on saving you need to use UPDATE not INSERT INTO
EDITED:
EDITED:
pawn Код:
//Registering//
new
string [ 128 ]
;
format(string, sizeof(string), "INSERT INTO `players` ( Name , Password ) VALUES ( '%s', '%s' )",
PlayerName( playerid ), PlayerTemp[ playerid ][ password ]);
mysql_query(string);
//Saving//
new
string [ 528 ] // change the string value if this is not enough.
;
format( string, sizeof ( string ), "UPDATE `players` SET `Money` = %i , `Bank` = %i , `Level` = %i ,`RPoints` = %i ,`Warns` = %i ,`Job` = %i ,`Banned` = %i , \
`Kills` = %i, `Deaths` = %i, `Faction` = %i, `LastIP` = '%s' , `rankname` = '%s' WHERE `Username` = '%s'",
PlayerTemp[playerid][sm], PlayerInfo[playerid][bank], PlayerInfo[playerid][playerlvl], PlayerInfo[playerid][rpoints], PlayerInfo[playerid][warns], PlayerInfo[playerid][job],
PlayerInfo[playerid][banned], PlayerInfo[playerid][kills], PlayerInfo[playerid][deaths] ,PlayerInfo[playerid][PTeamName], PlayerTemp[playerid][IP], PlayerInfo[playerid][rankname], PlayerName(playerid));
format( string, sizeof ( string ), "UPDATE `players` SET `groupID` = %i , `groupName` = '%s' , `groupLeader` = '%s'",
PlayerTemp[playerid][groupID], PlayerTemp[playerid][groupName], PlayerTemp[playerid][groupLeader]);