MySQL как записать данные в таблицу
Привет ув.формучани меня зовут Гена сегодня я пришёл к вам на портал
чтобы найти ответ на свой вопрос надеюсь вы мне подскажите .
Вопрос: как записать данные в таблицу?
Я пытасю писать мод на MySQL все вроде нормально ну при создании лидерок я зашел в тупик в котором хожу 4 дня
проблема в том что при использовании команды /makeleader выдаться лидерка ну при выходи не сохраняется в БД
но если в самой БД поставить значения pLeader = 7 то все работает !
моя команда (Автор Unreal =) )
PHP код:
if(strcmp(cmd, "/makeleader", true) == 0){
if(IsPlayerConnected(playerid)){
tmp = strtok(cmdtext, idx);
if(!strlen(tmp)){
SendClientMessage(playerid, -1, "{AAC5E3}[!]Èñïîëüçóéòå: /makeleader [ID] [Íîìåð îðãàíèçàöèè]");return 1;}
new para1;
new level;
para1 = ReturnUser(tmp);
tmp = strtok(cmdtext, idx);
level = strval(tmp);
if(level > 10 || level < 0) { SendClientMessage(playerid, -1, ""); return 1; }
if (Player[playerid][pAdmin] >= 4){
if(IsPlayerConnected(para1)){
if(para1 != INVALID_PLAYER_ID){
GetPlayerName(para1, giveplayer, sizeof(giveplayer));
GetPlayerName(playerid, sendername, sizeof(sendername));
new otext[50];
if(level == 0){
SetPlayerSkin(para1, Player[para1][pModel]);
Player[para1][pRang] = 0;
Player[para1][pMember] = 0;
Player[para1][pLeader] = 0;
format(string, sizeof string, "{AAC5E3}[!]Âàñ óâîëèëè èç îðãàíèçàöèè", giveplayer);
SendClientMessage(para1, -1, string);
SetPlayerToTeamColor(para1);return 1;}
else if(level == 1) { Player[para1][pSkin] = 17; otext = "Ìýðèÿ San-Fiero"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 2) { Player[para1][pSkin] = 70; otext = "Centr Hospital"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 3) { Player[para1][pSkin] = 288; otext = "Police Deportament"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 4) { Player[para1][pSkin] = 286; otext = "F.B.I"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 5) { Player[para1][pSkin] = 61; otext = "Ìîðïåõè"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 6) { Player[para1][pSkin] = 120; otext = "Ykudza"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 7) { Player[para1][pSkin] = 98; otext = "Èòàëüÿíñêàÿ ìàôèÿ"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 8) { Player[para1][pSkin] = 126; otext = "Ðóññêàÿ ìàôèÿ"; Player[para1][pRang] = 10; } //Adm.prez
else if(level == 9) { Player[para1][pSkin] = 228; otext = "Ðàäèî"; Player[para1][pRang] = 10; } //Adm.prez
Player[para1][pLeader] = level;
Player[para1][pMember] = level;
format(string, sizeof(string), "{006600}Âû íàçíà÷èëè %s ðóêîâîäèòü îðãàíèçàöèåé <<%s>>", giveplayer,otext);
SendClientMessage(playerid, -1, string);
format(string, sizeof(string), "{006600}Àäìèíèñòðàòîð %s íàçíà÷èë âàñ ðóêîâîäèòü îðãàíèçàöèåé <<%s>>",sendername ,otext);
SendClientMessage(para1, -1, string);
format(string, sizeof(string), "{006600}Äîñòóïíû íîâûå êîìàíäû: /invite | /giverank",sendername ,otext);
SendClientMessage(para1, -1, string);
SetPlayerSkin(para1, Player[para1][pSkin]);
SetPlayerToTeamColor(para1);
SaveAccount(playerid);
Player[playerid][pJob] = 0;
}}}else{SendClientMessage(playerid, -1, "{AAC5E3}[!]Äàííàÿ êîìàíäà äàñòóïíà ñ 5 ðàíãà");}}
return 1;}
и Stock
PHP код:
stock SaveAccount(playerid)
{
new query_string[(21)+(15+11)+(19+MAX_PLAYER_NAME)+(17+30)+(11+3)+(10+3)+(9+1)+(11+1)+(16+12)+(11+1)+(10+1)+(10+4)+(10+4)+(10+4)+(10+4)+(10+4)] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `Name` = '%s',", query_string, Player[playerid][pName]);
format(query_string, sizeof(query_string), "%s `Password` = '%s',", query_string, Player[playerid][pKey]);
format(query_string, sizeof(query_string), "%s `Model` = '%i',", query_string, Player[playerid][pModel]);
format(query_string, sizeof(query_string), "%s `Char` = '%i',", query_string, Player[playerid][pChar]);
format(query_string, sizeof(query_string), "%s `Sex` = '%i',", query_string, Player[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `Admin` = '%i',", query_string, Player[playerid][pAdmin]);
format(query_string, sizeof(query_string), "%s `APassword` = '%s',", query_string, Player[playerid][pAKey]);
format(query_string, sizeof(query_string), "%s `Helper` = '%i',", query_string, Player[playerid][pHelper]);
format(query_string, sizeof(query_string), "%s `Money` = '%i'", query_string, Player[playerid][pMoney]);
format(query_string, sizeof(query_string), "%s `Leader` = '%i',", query_string, Player[playerid][pLeader]);
format(query_string, sizeof(query_string), "%s `Rang` = '%i',", query_string, Player[playerid][pRang]);
format(query_string, sizeof(query_string), "%s `Skin` = '%i',", query_string, Player[playerid][pSkin]);
format(query_string, sizeof(query_string), "%s `Member` = '%i',", query_string, Player[playerid][pMember]);
format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, Player[playerid][pID]);
mysql_function_query(connects, query_string, false, "", "");
RemovePlayerInfo(playerid);
return true;
}
Помогите плиззз!!!
