Problem with database
#1

Hi guys.I have a problem with my server. Yesterday I had 2600 accounts on my database and the server didn't want to create anymore accounts on it. I CLEAR all the DB ( WIPE ) and now work. I don't know what s the problem.
Can you help me? Srry for my bad english
Reply
#2

Quote:

public OnPlayerRegister(playerid, password[])
{
if(IsPlayerConnected(playerid))
{
new playername3[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername3, sizeof(playername3));
new Str[200];
mysql_format(SQL,Str,sizeof(Str),"INSERT INTO `users` (`name`,`password`) VALUES ('%s','%s')",playername3,password);
mysql_tquery(SQL,Str,"","");
strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255);
PlayerInfo[playerid][pCash] = GetPlayerCash(playerid);
GetPlayerHealthEx(playerid,PlayerInfo[playerid][pHealth]);
if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
{
PlayerInfo[playerid][pPos_x] = 2246.6;
PlayerInfo[playerid][pPos_y] = -1161.9;
PlayerInfo[playerid][pPos_z] = 1029.7;
}
if(Spectate[playerid] != -1)
{
PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
}
new str[128];
mysql_format(SQL,str,128,"UPDATE users SET `pHealth`='%.1f' WHERE `name`='%s'",PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,str,"","");
ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STY LE_PASSWORD,"SERVER: Login","Welcome to the Urban-Play RPG Server.\n\nPlease enter your password below!","Login","Cancel");
return 1;
}
return 1;
}

Srry for double post
Reply
#3

Also post your Database or Table schema...
Reply
#4

that;s ok?
http://pastebin.com/aBS4D8VE
I deleted the accounts i swear is not a problem
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)