Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

[MYSQL]Проблема с сохранением

Статус
В этой теме нельзя размещать новые ответы.
Crazy_M_Fix

Crazy_M_Fix

Умник
Приветствую ув форумчане!

Поставил на сервер пабликовский Bloody-Rp, на MySQL, и вроде все хорошо, но когда заходишь на сервер, вводишь данные и регистрируешься, а когда перезаходишь обратно на сервер, то происходит обратно регистрация. Одним словом, аккаунт не сохраняется. Просмотрел стоки загрузки и сохранения аккаунта, вроде все норм. Прошу, если не так трудно - помогите!

P.S. Debug откладка стоит

Код, если нужен

--- --- --- --- --- ---
​
PHP: 
stock SaveAccount(playerid){    if(PlayerLogged[playerid] == true)    {        new query[1800],src[700];        format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");        format(src,40,"namek='%s',",Account[playerid][namek]);strcat(query,src,sizeof(query));        format(src,40,"sname='%s',",Account[playerid][sname]);strcat(query,src,sizeof(query));        format(src,40,"Password='%s',",Account[playerid][Password]);strcat(query,src,sizeof(query));        format(src,40,"Email='%s',",Account[playerid][Email]);strcat(query,src,sizeof(query));        format(src,40,"Drug='%s',",Account[playerid][Drug]);strcat(query,src,sizeof(query));        format(src,40,"Level='%d',",Account[playerid][Level]);strcat(query,src,sizeof(query));        format(src,40,"Exp='%d',",Account[playerid][Exp]);strcat(query,src,sizeof(query));        format(src,40,"Pol='%d',",Account[playerid][Pol]);strcat(query,src,sizeof(query));        format(src,40,"Skin='%d',",Account[playerid][Skin]);strcat(query,src,sizeof(query));        format(src,40,"RabSkin='%d',",Account[playerid][RabSkin]);strcat(query,src,sizeof(query));        format(src,40,"Adminka='%d',",Account[playerid][Adminka]);strcat(query,src,sizeof(query));        format(src,40,"Frac='%d',",Account[playerid][Frac]);strcat(query,src,sizeof(query));        format(src,40,"Job='%d',",Account[playerid][Job]);strcat(query,src,sizeof(query));        format(src,40,"CarLic='%d',",Account[playerid][CarLic]);strcat(query,src,sizeof(query));        format(src,40,"PlaneLic='%d',",Account[playerid][PlaneLic]);strcat(query,src,sizeof(query));        format(src,40,"MotoLic='%d',",Account[playerid][MotoLic]);strcat(query,src,sizeof(query));        format(src,40,"BoatLic='%d',",Account[playerid][BoatLic]);strcat(query,src,sizeof(query));        format(src,40,"Money='%d',",Account[playerid][Money]);strcat(query,src,sizeof(query));        format(src,40,"Rang='%d',",Account[playerid][Rang]);strcat(query,src,sizeof(query));        format(src,40,"Mats='%d',",Account[playerid][Mats]);strcat(query,src,sizeof(query));        format(src,40,"Pdstars='%d',",Account[playerid][Pdstars]);strcat(query,src,sizeof(query));        format(src,40,"Jailed='%d',",Account[playerid][Jailed]);strcat(query,src,sizeof(query));        format(src,40,"JailedTime='%d',",Account[playerid][JailedTime]);strcat(query,src,sizeof(query));        format(src,40,"Ticket='%d',",Account[playerid][Ticket]);strcat(query,src,sizeof(query));        format(src,40,"Vipka='%d',",Account[playerid][Vipka]);strcat(query,src,sizeof(query));        format(src,40,"Tnomer='%d',",Account[playerid][Tnomer]);strcat(query,src,sizeof(query));        format(src,40,"Kazino='%d',",Account[playerid][Kazino]);strcat(query,src,sizeof(query));        format(src,40,"KRank='%d',",Account[playerid][KRank]);strcat(query,src,sizeof(query));        format(src,40,"Bank='%d',",Account[playerid][Bank]);strcat(query,src,sizeof(query));        format(src,40,"Kredit='%d',",Account[playerid][Kredit]);strcat(query,src,sizeof(query));        format(src,40,"Drugs='%d',",Account[playerid][Drugs]);strcat(query,src,sizeof(query));        format(src,40,"Dom='%d',",Account[playerid][Dom]);strcat(query,src,sizeof(query));        format(src,40,"Biz='%d',",Account[playerid][Biz]);strcat(query,src,sizeof(query));        format(src,40,"SBiz='%d',",Account[playerid][SBiz]);strcat(query,src,sizeof(query));        format(src,40,"Payday='%d',",Account[playerid][Payday]);strcat(query,src,sizeof(query));        format(src,40,"Telephone='%d',",Account[playerid][Telephone]);strcat(query,src,sizeof(query));        format(src,40,"Carid='%d',",Account[playerid][Carid]);strcat(query,src,sizeof(query));        format(src,40,"Winn='%d',",Account[playerid][Winn]);strcat(query,src,sizeof(query));        format(src,40,"PINcode='%d',",Account[playerid][PINcode]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot1='%d',",Account[playerid][Gunslot1]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot2='%d',",Account[playerid][Gunslot2]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot3='%d',",Account[playerid][Gunslot3]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot4='%d',",Account[playerid][Gunslot4]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot5='%d',",Account[playerid][Gunslot5]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot9='%d',",Account[playerid][Gunslot9]); strcat(query,src,sizeof(query));        format(src,40,"Gunslot10='%d',",Account[playerid][Gunslot10]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot1='%d',",Account[playerid][Ammoslot1]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot2='%d',",Account[playerid][Ammoslot2]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot3='%d',",Account[playerid][Ammoslot3]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot4='%d',",Account[playerid][Ammoslot4]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot5='%d',",Account[playerid][Ammoslot5]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot9='%d',",Account[playerid][Ammoslot9]); strcat(query,src,sizeof(query));        format(src,40,"Ammoslot10='%d',",Account[playerid][Ammoslot10]); strcat(query,src,sizeof(query));        format(src,40,"SDPistol='%d',",Account[playerid][SDPistol]); strcat(query,src,sizeof(query));        format(src,40,"Deagle='%d',",Account[playerid][Deagle]); strcat(query,src,sizeof(query));        format(src,40,"Mp5='%d',",Account[playerid][Mp5]); strcat(query,src,sizeof(query));        format(src,40,"Shotgun='%d',",Account[playerid][Shotgun]); strcat(query,src,sizeof(query));        format(src,40,"Ak47='%d',",Account[playerid][Ak47]); strcat(query,src,sizeof(query));        format(src,40,"M4a1='%d',",Account[playerid][M4a1]); strcat(query,src,sizeof(query));        format(src,40,"Sniper='%d',",Account[playerid][Sniper]); strcat(query,src,sizeof(query));        format(src,40,"Banned='%d',",Account[playerid][Banned]); strcat(query,src,sizeof(query));        format(src,40,"Mute='%d',",Account[playerid][Mute]); strcat(query,src,sizeof(query));        format(src,40,"MuteTime='%d',",Account[playerid][MuteTime]); strcat(query,src,sizeof(query));        format(src,40,"Warn='%d',",Account[playerid][Warn]); strcat(query,src,sizeof(query));        format(src,40,"Zavis='%d',",Account[playerid][Zavis]); strcat(query,src,sizeof(query));        format(src,40,"Cuffs='%d',",Account[playerid][Cuffs]); strcat(query,src,sizeof(query));        format(src,40,"Cheat='%d',",Account[playerid][Cheat]); strcat(query,src,sizeof(query));        format(src,40,"Sigar='%d',",Account[playerid][Sigar]); strcat(query,src,sizeof(query));        format(src,40,"Rpstat='%d',",Account[playerid][Rpstat]); strcat(query,src,sizeof(query));        format(src,40,"Seansov='%d',",Account[playerid][Seansov]); strcat(query,src,sizeof(query));        format(src,40,"Ogorod='%d',",Account[playerid][Ogorod]); strcat(query,src,sizeof(query));        format(src,40,"Watch='%d',",Account[playerid][Watch]); strcat(query,src,sizeof(query));        format(src,40,"Fishing='%d',",Account[playerid][Fishing]); strcat(query,src,sizeof(query));        format(src,40,"Fish='%d',",Account[playerid][Fish]); strcat(query,src,sizeof(query));        format(src,40,"Rukzak='%d',",Account[playerid][Rukzak]); strcat(query,src,sizeof(query));        format(src,40,"RegIp='%f',",Account[playerid][RegIp]); strcat(query,src,sizeof(query));        format(src,40,"Dir='%d',",Account[playerid][Dir]); strcat(query,src,sizeof(query));        format(src,40,"Achivok='%d',",Account[playerid][Achivok]); strcat(query,src,sizeof(query));        format(src,40,"Ubil='%d',",Account[playerid][Ubil]); strcat(query,src,sizeof(query));        format(src,40,"Umer='%d',",Account[playerid][Umer]); strcat(query,src,sizeof(query));        format(src,40,"Jails='%d',",Account[playerid][Jails]); strcat(query,src,sizeof(query));        format(src,40,"Millioner='%d',",Account[playerid][Millioner]); strcat(query,src,sizeof(query));        format(src,40,"CWinn='%d',",Account[playerid][CWinn]); strcat(query,src,sizeof(query));        new Float:health;        GetPlayerHealth(playerid,health);        if(health <= 10) health = 30;        format(src,40,"Health='%.0f'",health); strcat(query,src,sizeof(query));        format(src,40," WHERE idname='%i'",Account[playerid][idname]);strcat(query,src,sizeof(query));        mysql_query(query);    }    return true;}

PHP: 
stock LoadAccount(playerid){    format(stringg, sizeof(stringg), "SELECT * FROM "TABLE_ACCOUNT" WHERE namek = '%s'", sendername(playerid));    mysql_query(stringg);    mysql_store_result();    if(mysql_fetch_row_format(stringg))    {        sscanf(stringg, "p<|>is[32]s[32]s[35]s[25]s[32]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiifiiiiiiif",        Account[playerid][idname],// i      1        Account[playerid][namek],//s[32]        Account[playerid][sname],//s[32]        Account[playerid][Password],//s[35]        Account[playerid][Email],//s[25]        Account[playerid][Drug],//s[32]        Account[playerid][Level],//i         2        Account[playerid][Exp],//i            3        Account[playerid][Pol],//i          4        Account[playerid][Skin],//i         5        Account[playerid][RabSkin],//i      6        Account[playerid][Adminka], //i     7        Account[playerid][Frac], //i        8        Account[playerid][Job], //i         9        Account[playerid][CarLic], //i      10        Account[playerid][PlaneLic], //i    11        Account[playerid][MotoLic], //i     12        Account[playerid][BoatLic], //i     13        Account[playerid][Money], //i         14        Account[playerid][Rang], //i         15        Account[playerid][Mats],//i         16        Account[playerid][Pdstars],//i         17        Account[playerid][Jailed],//i         18        Account[playerid][JailedTime],//i   19        Account[playerid][Ticket],//i       20        Account[playerid][Vipka],//i         21        Account[playerid][Tnomer],//i         22        Account[playerid][Kazino],//i         23        Account[playerid][KRank],//i         24        Account[playerid][Bank], //i         25        Account[playerid][Kredit], //i      26        Account[playerid][Drugs], //i         27        Account[playerid][Dom], //i         28        Account[playerid][Biz], //i         29        Account[playerid][SBiz], //i        30        Account[playerid][Payday], //i      31        Account[playerid][Telephone], //i     32        Account[playerid][Carid],//i        33        Account[playerid][Winn],//i         34        Account[playerid][PINcode], //i     35        Account[playerid][Gunslot1], //i    36        Account[playerid][Gunslot2],//i     37        Account[playerid][Gunslot3],//i     38        Account[playerid][Gunslot4],//i     39        Account[playerid][Gunslot5],//i     40        Account[playerid][Gunslot9],//i     41        Account[playerid][Gunslot10],//i    42        Account[playerid][Ammoslot1],//i    43        Account[playerid][Ammoslot2],//i    44        Account[playerid][Ammoslot3],//i    45        Account[playerid][Ammoslot4],//i    46        Account[playerid][Ammoslot5],//i    47        Account[playerid][Ammoslot9],//i    48        Account[playerid][Ammoslot10],//i   49        Account[playerid][SDPistol], //i    50        Account[playerid][Deagle],//i       51        Account[playerid][Mp5],//i          52        Account[playerid][Shotgun],//i      53        Account[playerid][Ak47],//i         54        Account[playerid][M4a1],//i         55        Account[playerid][Sniper],//i       56        Account[playerid][Banned],//i       57        Account[playerid][Mute],//i         58        Account[playerid][MuteTime],//i     59        Account[playerid][Warn],//i         60        Account[playerid][Zavis],//i        61        Account[playerid][Cuffs],//i        62        Account[playerid][Cheat],//i        63        Account[playerid][Sigar],//i        64        Account[playerid][Rpstat],//i       65        Account[playerid][Seansov],//i      66        Account[playerid][Ogorod],//i       67        Account[playerid][Watch],//i        73        Account[playerid][Fishing],//i      74        Account[playerid][Fish],//i         75        Account[playerid][Rukzak],//i       76        Account[playerid][RegIp],//f        77        Account[playerid][Dir],//i            78        Account[playerid][Achivok],//i      79        Account[playerid][Ubil],//i         80        Account[playerid][Umer],//i         81        Account[playerid][Jails],//i        82        Account[playerid][Millioner],//i    83        Account[playerid][CWinn],//i        84        Account[playerid][Health]);//f      85        mysql_free_result();    }    if(Account[playerid][Banned] == 1)    {        ShowPlayerDialog(playerid,200,0,"{33CCFF}Ошибка","{FF6347}Простите, но вы были забанены.\nЕсли вы не согласны с баном и уверены, что администратор\nзабанил вас несправедливо, то напишите в {FFFFFF}Skype : delwap","X","");        SetTimerEx("Kickk",500,false,"i",playerid);        return true;    }    if(Account[playerid][Tnomer] == 0)    {        if(Account[playerid][Telephone] != 0)        {            new randphone = 1000 + random(89999);            Account[playerid][Tnomer] = randphone;        }    }    if(Account[playerid][Winn] == 1)    {        Account[playerid][Winn] = 0;        SendClientMessage(playerid, COLOR_NEWS,"Твой друг, которого ты пригласил на сервер поднял 4 уровень!");        SendClientMessage(playerid, COLOR_NEWS,"За это ты получаешь 100.000 $!");        Account[playerid][Money] += 100000;    }    if(Account[playerid][Money] <= 0) { Account[playerid][Money] = 0; }    GivePlayerMoney(playerid,Account[playerid][Money]);    GangZoneShowForPlayer(playerid, armyzona[0], COLOR_YELLOW2);    GangZoneShowForPlayer(playerid, armyzona[1], COLOR_YELLOW2);    GangZoneShowForPlayer(playerid, armyzona[2], COLOR_YELLOW2);    SetTimerEx("Gangz",5000,false,"i",playerid);    SetTimerEx("Mafz",5000,false,"i",playerid);    if(Account[playerid][Dom] != 0) { if(Account[playerid][Carid] != 0) Carhousespawn(playerid); }    if(Account[playerid][Carid] != 0) { if(VehInfo[Account[playerid][Carid]][vModel] == 508) Carhousespawn(playerid); }    SpawnPlayer(playerid);    return true;}

PHP: 
mysql_connect("localhost", "testuser", "testbase", "crack"); //стоит на VDS    mysql_debug(1);    mysql_set_charset("cp1251_general_ci");    mysql_query("SET NAMES 'cp1251'");    mysql_query("SET CHARACTER SET 'cp1251'");    if(mysql_ping() == 1) printf("Connection to the database was successful ");    else printf("Connection to the database is interrupted due to unforeseen errors");


---------- Post added at 13:19 ---------- Previous post was at 12:55 ----------

:)...

---------- Post added at 14:15 ---------- Previous post was at 13:19 ----------

плииз :DD

---------- Post added at 14:56 ---------- Previous post was at 14:15 ----------

Есть хорошие люди? :)
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу