John_Rayder
Ученик
Переписал полностью регистрацию на mysql, все работает отлично, бд подключается, но проблема в том, что аккаунты не сохраняются, только регистрируются. При коннекте последующие изменения не записываются в бд. В чем проблема, помогите!
Вот сток сохранения:
Так же пробовал вот такое:
Но так и не помогло. Еще заметил, что этот сток вообще никак не реагирует (к примеру на ошибки). Сток подключен к моду через таймер
Вот сток сохранения:
PHP:
stock SavePlayer(playerid)
{
if(!gPlayerLogged[playerid] = 0) return 1;
mysql_format(connectionHandl,query,1024,"UPDATE `"TABLE_ACCOUNT"` SET ");
GetPlayerIp(playerid, ip, 16);
format(src,sizeof(src),"Ip='%s',",ip);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Name=%s,",PlayerInfo[playerid][pName]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Pass=%s,",password);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"DataReg=%s,",strdate);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Mail=%s,",PlayerInfo[playerid][pEmail]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Referal=%s,",PlayerInfo[playerid][pReferal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Jail=%d,",PlayerInfo[playerid][pJail]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"JailTime=%d,",PlayerInfo[playerid][pJailTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Patron=%d,",PlayerInfo[playerid][pPatron]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Detal=%d,",PlayerInfo[playerid][pDetal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Cash=%d,",PlayerInfo[playerid][pCash]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Skin=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"PayCheck=%d,",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Muted=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"MutedTime=%d,",PlayerInfo[playerid][pMutedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Number=%d,",PlayerInfo[playerid][pPnumber]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Health=%f,",PlayerInfo[playerid][pHealth]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Zakon=%d,",PlayerInfo[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE `Name`='%s'",PlayerInfo[playerid][pName]);
strcat(query,src,sizeof(query));
mysql_function_query(connectionHandl, query, false,"","");
return 1;
}
PHP:
mysql_format(connectionHandl,query,1024, "UPDATE "TABLE_ACCOUNT" SET (Name, Pass, Ip, DataReg, Sex, Model, Mail, Referal, Level, Admin, Wanted, Jail, JailTime, Exp, Patron, Detal, Cash, Skin, PayCheck, Warn, Muted, MutedTime, Number, Health, Sex, Zakon, Leader, Member, Rank) VALUES ('%s', '%s', '%e','%e', '%i', '%i', '%s', '%s', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%f', '%i', '%i', '%i', '%i')"
,PlayerInfo[playerid][pName], password, ip, strdate,PlayerInfo[playerid][pSex], PlayerInfo[playerid][pModel],PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pReferal],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pJail],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pPatron],PlayerInfo[playerid][pDetal],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pChar],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pMutedTime],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pZakon],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRank]);
mysql_function_query(connectionHandl, query, false,"","");
PHP:
SetTimer("SavePlayer", 2000, true);
