- Регистрация
- 5 Май 2013
- Сообщения
- 1,479
- Лучшие ответы
- 0
- Репутация
- 382
Помогите пожалуйста! У меня при дисконнекте с сервера все отлично сохраняет, но если я выключу и включу мод то у меня сохранит только: Ник, ключ, лвл, а переменную тест, и деньги не сохраняет
PHP:
#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <zcmd>
#include <sscanf2>
#define mysql_host "localhost"
#define mysql_db "new"
#define mysql_user "root"
#define mysql_pass ""
#define COLOR_WHITE 0xFFFFFFAA
#include "../include/gl_common.inc"
#include <foreach>
new connectionHandle;
enum pInfo
{
Key[128],
Level[60],
Money,
Test
};
new PlayerInfo[MAX_PLAYERS][pInfo];
#define send(%0,%1) SendClientMessage(%0, -1, %1)
#if defined FILTERSCRIPT
public OnFilterScriptInit()
{
return 1;
}
public OnFilterScriptExit()
{
return 1;
}
#else
main()
{
}
#endif
public OnGameModeInit()
{
connectionHandle = mysql_connect(mysql_host, mysql_user, mysql_db, mysql_pass);
if(mysql_ping() != 1) print("MySQL ñîåäèíåíèå, false.");
SetGameModeText("Blank Script");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
public OnGameModeExit()
{
SaveAccounts();
mysql_close(connectionHandle);
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}
public OnPlayerConnect(playerid)
{
new str[128];
mysql_real_escape_string(Name(playerid), Name(playerid));
format(str, sizeof(str),"SELECT `Name` FROM `Accounts` WHERE `Name` = '%s'", Name(playerid));
mysql_function_query(connectionHandle, str, true, "OnPlayerRegCheck","d", playerid);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
SaveKey(playerid);
SaveMoney(playerid);
SaveTest(playerid);
return 1;
}
public OnPlayerSpawn(playerid)
{
if(!GetPVarInt(playerid, "Logged")) return true;
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
if(!GetPVarInt(playerid, "Logged")) return true;
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp("/mycommand", cmdtext, true, 10) == 0)
{
// Do something here
return 1;
}
return 0;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
SetMoney(playerid, PlayerInfo[playerid][Money]);
SetPlayerScore(playerid, PlayerInfo[playerid][Level]);
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case 1:
{
if(!strlen(inputtext))return ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Ðåãèñòðàöèÿ","____________________________________________\nÄîáðî ïîæàëîâàòü íà ñåðâåð!\nÂàø àêêàóíò íå çàðåãèñòðèðîâàí!\n\nÂâåäèòå ïàðîëü:\n____________________________________________","Äàëåå","Îòìåíà");
OnPlayerRegister(playerid,inputtext);
return 1;
}
case 2:
{
if(!strlen(inputtext))return ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Àâòîðèçàöèÿ","____________________________________________\nÇäðàâñòâóéòå!\n\nÂû çàðåãèñòðèðîâàíû!\nÂâåäèòå ïàðîëü:\n____________________________________________","Âõîä","Îòìåíà");
OnPlayerLogin(playerid,inputtext);
return 1;
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
stock Name(i) { new pl[24]; GetPlayerName(i, pl, 24); return pl; }
forward OnPlayerRegCheck(playerid);
public OnPlayerRegCheck(playerid)
{
if(IsPlayerConnected(playerid))
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Àâòîðèçàöèÿ","\n____________________________________________\nÇäðàâñòâóéòå!\n\nÂû çàðåãèñòðèðîâàíû!\nÂâåäèòå ïàðîëü:\n____________________________________________","Âõîä","Îòìåíà");
else
ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Ðåãèñòðàöèÿ","____________________________________________\nÄîáðî ïîæàëîâàòü íà ñåðâåð!\nÂàø àêêàóíò íå çàðåãèñòðèðîâàí!\n\nÂâåäèòå ïàðîëü:\n____________________________________________","Äàëåå","Îòìåíà");
}
return 1;
}
stock OnPlayerRegister(p, password[])
{
new str[128];
format(str, sizeof(str), "INSERT INTO `accounts` (`Name`, `Key`) VALUES ('%s', '%s')", Name(p), password);
mysql_function_query(connectionHandle, str, false, "RegisterCallback","d", p);
return 1;
}
forward RegisterCallback(playerid);
public RegisterCallback(playerid)
{
send(playerid,"Ðåãèñòðàöèÿ ïðîøëà óñïåøíî!");
PlayerInfo[playerid][Level] = 1;
PlayerInfo[playerid][Money] = 0;
SetPVarInt(playerid,"Logged", 1), SpawnPlayer(playerid);
return 1;
}
stock SaveKey(playerid)
{
new src[128],query[256];
format(query,sizeof(query),"UPDATE 'accounts' SET ");
format(src,sizeof(src),"UPDATE `Accounts` SET `Key` = '%d'", PlayerInfo[playerid][Key]);
format(src,sizeof(src)," WHERE `Name`='%s'",Name(playerid));
strcat(query,src,sizeof(query));
mysql_query(src, -1, 0, connectionHandle);
return true;
}
stock SaveLevel(p)
{
if(GetPVarInt(p,"Logged") > 0)
{
new str[128];
format(str,sizeof(str),"UPDATE `Accounts` SET `Level` = '%d'", PlayerInfo[p][Level]);
format(str, sizeof(str),"%s WHERE `Name` = '%s'", str, Name(p));
mysql_query(str, -1, 0, connectionHandle);
}
return 1;
}
stock SaveMoney(p)
{
if(GetPVarInt(p,"Logged") > 0)
{
new str[128];
format(str,sizeof(str),"UPDATE `Accounts` SET `Money` = '%d'", PlayerInfo[p][Money]);
format(str, sizeof(str),"%s WHERE `Name` = '%s'", str, Name(p));
mysql_query(str, -1, 0, connectionHandle);
}
return 1;
}
stock SaveTest(p)
{
if(GetPVarInt(p,"Logged") > 0)
{
new str[128];
format(str,sizeof(str),"UPDATE `Accounts` SET `Test` = '%d'", PlayerInfo[p][Test]);
format(str, sizeof(str),"%s WHERE `Name` = '%s'", str, Name(p));
mysql_query(str, -1, 0, connectionHandle);
}
return 1;
}
stock OnPlayerLogin(i, password[])
{
new str[128];
format(str, sizeof(str),"SELECT * FROM `accounts` WHERE `Name` = '%s' AND `Key` = '%s'", Name(i), password);
mysql_function_query(connectionHandle, str, true, "LoginCallback","ds", i, password);
return 1;
}
forward LoginCallback(i, password[]);
public LoginCallback(i, password[])
{
new rows, fields, string[144], maximum[128];
cache_get_data(rows, fields);
if(!rows)
{
if(GetPVarInt(i, "wrongPass") == 2) return send(i,"Âû ââåëè 3 ðàçà íåâåðíûé ïàðîëü, ïîýòîìó áûëè êèêíóòû ñåðâåðîì."), Kick(i);
SetPVarInt(i, "wrongPass", GetPVarInt(i, "wrongPass")+1);
format(string, sizeof(string), "Íåâåðíûé ïàðîëü(îñòàëîñü %i/3)\nÂâåäèòå ïàðîëü:", 3 - GetPVarInt(i, "wrongPass"));
ShowPlayerDialog(i, 2, DIALOG_STYLE_PASSWORD, "Àâòîðèçàöèÿ", string, "Âõîä", "Îòìåíà");
return 1;
}
cache_get_field_content(0, "Level", maximum), PlayerInfo[i][Level] = strval(maximum);
SetPVarInt(i, "Logged", 1);
send(i, "Âû óñïåøíî àâòîðèçîâàëèñü!");
SpawnPlayer(i), SaveKey(i), SaveMoney(i), SaveTest(i);
return 1;
}
stock GiveMoney(playerid, amount)
{
PlayerInfo[playerid][Money] += amount;
GivePlayerMoney(playerid, amount);
}
//------------------------------------------------------------------------------
stock SetMoney(playerid, amount)
{
PlayerInfo[playerid][Money] = amount;
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid, amount);
}
stock SaveAccounts()
{
foreach(Player, i)
{
if(!IsPlayerConnected(i)) continue;
SaveKey(i);
SaveLevel(i);
SaveMoney(i);
SaveTest(i);
}
return 1;
}
CMD:g(playerid, params[])
{
if(GetPVarInt(playerid, "Logged") == 0) return 1;
if(sscanf(params, "ud", params[0],params[1])) return SendClientMessage(playerid, COLOR_WHITE, "Ââåäèòå: /givemoney [id èãðîêà] [êîë-âî äåíåã]");
if(!IsPlayerConnected(params[0])) return SendClientMessage(playerid, COLOR_WHITE, "Èãðîê íå â ñåòè!");
if(params[1] > 10000000 || params[1] < 1) return SendClientMessage(playerid, COLOR_WHITE, "Êîë-âî äåíåã îò 1 äî 10000000!");
GiveMoney(params[0], params[1]);
return 1;
}
CMD:b(playerid)
{
PlayerInfo[playerid][Test] ++;
return true;
}