Mysql Register System
#4

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:

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]);
Reply


Messages In This Thread
Mysql Register System - by MadafakaPro - 23.09.2013, 07:02
AW: Mysql Register System - by [AK]Nazgul - 23.09.2013, 14:40
Re: Mysql Register System - by MadafakaPro - 10.10.2013, 16:28
Re: Mysql Register System - by Patrick - 10.10.2013, 16:31

Forum Jump:


Users browsing this thread: 1 Guest(s)