05.09.2014, 06:18
Код:
[23:07:29] [DEBUG] mysql_format - connection: 1, len: 2056, format: "SELECT * from `accounts` WHERE Fullname = '%e' LIMIT 1" [23:07:29] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * from `accounts` WHERE Fullname = 'The_Nerka' LIMIT 1", callback: "IsAccountRegistered", format: "i" [23:07:29] [DEBUG] CMySQLQuery::Execute[IsAccountRegistered] - starting query execution [23:07:29] [DEBUG] CMySQLQuery::Execute[IsAccountRegistered] - query was successfully executed within 1.272 milliseconds [23:07:29] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [23:07:29] [DEBUG] Calling callback "IsAccountRegistered".. [23:07:29] [DEBUG] cache_get_data - connection: 1 [23:07:29] [DEBUG] mysql_format - connection: 1, len: 2056, format: "SELECT * FROM `accounts` WHERE `Fullname` = '%e' LIMIT 1" [23:07:29] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Fullname` = 'The_Nerka' LIMIT 1", callback: "Loadplayerdata", format: "i" [23:07:29] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [23:07:29] [DEBUG] CMySQLQuery::Execute[Loadplayerdata] - starting query execution [23:07:29] [DEBUG] CMySQLQuery::Execute[Loadplayerdata] - query was successfully executed within 2.65 milliseconds [23:07:29] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [23:07:29] [DEBUG] Calling callback "Loadplayerdata".. [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "41479FC4C33E3B8C100BC71CC4B144C1F824C377F7660616A10D471BE130249AF3FC898A24BFABC98A20183CECD6110AB3E96EAB521B19E1B4B81BC232391BB5" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Fullname", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Fullname", data: "The_Nerka" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "PositionX", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PositionX", data: "1337.04" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "PositionY", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PositionY", data: "294.801" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "PositionZ", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PositionZ", data: "19.5547" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "PositionA", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PositionA", data: "335.656" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "Health", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Health", data: "100" [23:07:29] [DEBUG] cache_get_field_content_float - row: 0, field_name: "Armour", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Armour", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Interior", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Interior", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VirtualWorld", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VirtualWorld", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "AdminLevel", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "AdminLevel", data: "4" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "AdminKey", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "AdminKey", data: "88098" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "AdminTime", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "AdminTime", data: "42661" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VipLevel", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VipLevel", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VipKey", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VipKey", data: "65254" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VipTime", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VipTime", data: "42754" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Banned", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Banned", data: "0" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "BanReason", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "BanReason", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "BannedBy", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "BannedBy", data: "" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Warnings", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Warnings", data: "0" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Warning1Reason", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Warning1Reason", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Warning2Reason", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Warning2Reason", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Warning3Reason", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Warning3Reason", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "WarnedBy1", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "WarnedBy1", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "WarnedBy2", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "WarnedBy2", data: "" [23:07:29] [DEBUG] cache_get_field_content - row: 0, field_name: "WarnedBy3", connection: 1, max_len: 126 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "WarnedBy3", data: "" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Dead", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Dead", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "HospitalTime", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "HospitalTime", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Helper", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Helper", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Money", data: "25353" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "MoneyBank", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "MoneyBank", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Score", data: "686" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Skin", data: "191" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Hour", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Hour", data: "19" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Min", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Min", data: "45" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Sec", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Sec", data: "33" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Kills", data: "9" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deaths", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Deaths", data: "11" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kreditai", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Kreditai", data: "25561" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Taskai", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Taskai", data: "688" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "nLicenzija", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "nLicenzija", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Navigacija", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Navigacija", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Radijas", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Radijas", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Muted", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Muted", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "MutedTime", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "MutedTime", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PremiumTime", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PremiumTime", data: "12" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Telefonas", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Telefonas", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tinklas", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Tinklas", data: "2" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Numeris", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Numeris", data: "864116117" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "tBaterijosBukle", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "tBaterijosBukle", data: "58" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "tBaterija", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "tBaterija", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "tBukle", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "tBukle", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "tPakrovejas", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "tPakrovejas", data: "1" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon1", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon1", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon1a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon1a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon2", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon2", data: "24" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon2a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon2a", data: "67" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon3", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon3", data: "27" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon3a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon3a", data: "81" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon4", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon4", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon4a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon4a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon5", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon5", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon5a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon5a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon6", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon6", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon6a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon6a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon7", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon7", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon7a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon7a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon8", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon8", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon8a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon8a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon9", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon9", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon9a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon9a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon10", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon10", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon10a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon10a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon11", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon11", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon11a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon11a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon12", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon12", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weapon12a", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Weapon12a", data: "0" [23:07:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Gender", connection: 1 [23:07:29] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Gender", data: "2" [23:07:29] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Код:
forward SavePlayerData(playerid);
public SavePlayerData(playerid)
{
if(gIsPlayerLoggedIn[playerid] == 1)
{
if(gIsPlayerDead[playerid] == 1) { PlayerData[playerid][Dead] = 1; }
GetPlayerWeaponData(playerid, 1, PlayerData[playerid][Weapon1], PlayerData[playerid][Weapon1a]);
GetPlayerWeaponData(playerid, 2, PlayerData[playerid][Weapon2], PlayerData[playerid][Weapon2a]);
GetPlayerWeaponData(playerid, 3, PlayerData[playerid][Weapon3], PlayerData[playerid][Weapon3a]);
GetPlayerWeaponData(playerid, 4, PlayerData[playerid][Weapon4], PlayerData[playerid][Weapon4a]);
GetPlayerWeaponData(playerid, 5, PlayerData[playerid][Weapon5], PlayerData[playerid][Weapon5a]);
GetPlayerWeaponData(playerid, 6, PlayerData[playerid][Weapon6], PlayerData[playerid][Weapon6a]);
GetPlayerWeaponData(playerid, 7, PlayerData[playerid][Weapon7], PlayerData[playerid][Weapon7a]);
GetPlayerWeaponData(playerid, 8, PlayerData[playerid][Weapon8], PlayerData[playerid][Weapon8a]);
GetPlayerWeaponData(playerid, 9, PlayerData[playerid][Weapon9], PlayerData[playerid][Weapon9a]);
GetPlayerWeaponData(playerid, 10, PlayerData[playerid][Weapon10], PlayerData[playerid][Weapon10a]);
GetPlayerWeaponData(playerid, 11, PlayerData[playerid][Weapon11], PlayerData[playerid][Weapon11a]);
GetPlayerWeaponData(playerid, 12, PlayerData[playerid][Weapon12], PlayerData[playerid][Weapon12a]);
new Float:X, Float:Z, Float:Y, Float:A, Float:H, Float:Ar;
GetPlayerPos(playerid, X,Y,Z);
GetPlayerFacingAngle(playerid,A);
GetPlayerHealth(playerid, H);
GetPlayerArmour(playerid, Ar);
mysql_format(Mysql_users, query, sizeof(query), "UPDATE `"ZAIDEJU_LENTELE"` SET Fullname='%e', Password='%e', PositionX='%f', PositionY='%f', PositionZ='%f', PositionA='%f', Health='%f', Armour='%f', Interior='%d', VirtualWorld='%d', AdminLevel='%d', AdminKey='%d', AdminTime='%d', Banned='%d', BannedBy='%e', BanReason='%e'",\
PlayerData[playerid][Fullname],
PlayerData[playerid][Password],
X,
Y,
Z,
A,
H,
Ar,
GetPlayerInterior(playerid),
GetPlayerVirtualWorld(playerid),
PlayerData[playerid][AdminLevel],
PlayerData[playerid][AdminKey],
PlayerData[playerid][AdminTime],
PlayerData[playerid][Banned],
PlayerData[playerid][BannedBy],
PlayerData[playerid][BanReason]);
mysql_format(Mysql_users, query, sizeof(query), "%s, Warnings='%d', Warning1Reason='%e', Warning2Reason='%e', Warning3Reason='%e', WarnedBy1='%e', WarnedBy2='%e', WarnedBy3='%e', Dead='%d', HospitalTime='%d', Telefonas='%d', Tinklas='%d', Numeris='%d', tBaterija='%d', tBaterijosBukle='%d', tBukle='%d', tPakrovejas='%d'",\
query,
PlayerData[playerid][Warnings],
PlayerData[playerid][Warning1Reason],
PlayerData[playerid][Warning2Reason],
PlayerData[playerid][Warning3Reason],
PlayerData[playerid][WarnedBy1],
PlayerData[playerid][WarnedBy2],
PlayerData[playerid][WarnedBy3],
PlayerData[playerid][Dead],
PlayerData[playerid][HospitalTime],
PlayerData[playerid][Telefonas],
PlayerData[playerid][Tinklas],
PlayerData[playerid][Numeris],
PlayerData[playerid][tBaterija],
PlayerData[playerid][tBaterijosBukle],
PlayerData[playerid][tBukle],
PlayerData[playerid][tPakrovejas]);
mysql_format(Mysql_users, query, sizeof(query), "%s, Helper='%d', Money='%d', MoneyBank='%d', Score='%d', Skin='%d', Hour='%d', Min='%d', Sec='%d', Kills='%d', Deaths='%d', Kreditai='%d', Taskai='%d', nLicenzija='%d', Navigacija='%d', Radijas='%d',VipLevel='%d',VipKey='%d',VipTime='%d', Premium='%d', PremiumTime='%d'",\
query,
PlayerData[playerid][Helper],
GetPlayerMoney(playerid),
PlayerData[playerid][MoneyBank],
GetPlayerScore(playerid),
GetPlayerSkin(playerid),
PlayerData[playerid][Hour],
PlayerData[playerid][Min],
PlayerData[playerid][Sec],
PlayerData[playerid][Kills],
PlayerData[playerid][Deaths],
PlayerData[playerid][Kreditai],
PlayerData[playerid][Taskai],
PlayerData[playerid][nLicenzija],
PlayerData[playerid][Navigacija],
PlayerData[playerid][Radijas],
PlayerData[playerid][VipLevel],
PlayerData[playerid][VipKey],
PlayerData[playerid][VipTime],
PlayerData[playerid][Premium],
PlayerData[playerid][PremiumTime]);
mysql_format(Mysql_users, query, sizeof(query), "%s, Weapon1='%d', Weapon1a='%d', Weapon2='%d', Weapon2a='%d', Weapon3='%d', Weapon3a='%d', Weapon4='%d', Weapon4a='%d', Weapon5='%d', Weapon5a='%d', Weapon6='%d', Weapon6a='%d'",\
query,
PlayerData[playerid][Weapon1],
PlayerData[playerid][Weapon1a],
PlayerData[playerid][Weapon2],
PlayerData[playerid][Weapon2a],
PlayerData[playerid][Weapon3],
PlayerData[playerid][Weapon3a],
PlayerData[playerid][Weapon4],
PlayerData[playerid][Weapon4a],
PlayerData[playerid][Weapon5],
PlayerData[playerid][Weapon5a],
PlayerData[playerid][Weapon6],
PlayerData[playerid][Weapon6a]);
mysql_format(Mysql_users, query, sizeof(query), "%s, Weapon7='%d', Weapon7a='%d', Weapon8='%d', Weapon8a='%d', Weapon9='%d', Weapon9a='%d', Weapon10='%d', Weapon10a='%d', Weapon11='%d', Weapon11a='%d', Weapon12='%d', Weapon12a='%d', Gender='%d' WHERE Fullname='%e'",\
query,
PlayerData[playerid][Weapon7],
PlayerData[playerid][Weapon7a],
PlayerData[playerid][Weapon8],
PlayerData[playerid][Weapon8a],
PlayerData[playerid][Weapon9],
PlayerData[playerid][Weapon9a],
PlayerData[playerid][Weapon10],
PlayerData[playerid][Weapon10a],
PlayerData[playerid][Weapon11],
PlayerData[playerid][Weapon11a],
PlayerData[playerid][Weapon12],
PlayerData[playerid][Weapon12a],
PlayerData[playerid][Gender],
GetPlayersName(playerid));
mysql_tquery(Mysql_users, query, "", "");
}
}
Код:
forward Loadplayerdata(playerid);
public Loadplayerdata(playerid)
{
cache_get_field_content(0, "Password", PlayerData[playerid][Password], Mysql_users, 129);
cache_get_field_content(0, "Fullname", PlayerData[playerid][Fullname], Mysql_users, 126);
PlayerData[playerid][PositionX] = cache_get_field_content_float(0, "PositionX", Mysql_users);
PlayerData[playerid][PositionY] = cache_get_field_content_float(0, "PositionY", Mysql_users);
PlayerData[playerid][PositionZ] = cache_get_field_content_float(0, "PositionZ", Mysql_users);
PlayerData[playerid][PositionA] = cache_get_field_content_float(0, "PositionA", Mysql_users);
PlayerData[playerid][Health] = cache_get_field_content_float(0, "Health", Mysql_users);
PlayerData[playerid][Armour] = cache_get_field_content_float(0, "Armour", Mysql_users);
PlayerData[playerid][Interior] = cache_get_field_content_int(0, "Interior", Mysql_users);
PlayerData[playerid][VirtualWorld] = cache_get_field_content_int(0, "VirtualWorld", Mysql_users);
PlayerData[playerid][AdminLevel] = cache_get_field_content_int(0, "AdminLevel", Mysql_users);
PlayerData[playerid][AdminKey] = cache_get_field_content_int(0, "AdminKey", Mysql_users);
PlayerData[playerid][AdminTime] = cache_get_field_content_int(0, "AdminTime", Mysql_users);
PlayerData[playerid][VipLevel] = cache_get_field_content_int(0, "VipLevel", Mysql_users);
PlayerData[playerid][VipKey] = cache_get_field_content_int(0, "VipKey", Mysql_users);
PlayerData[playerid][VipTime] = cache_get_field_content_int(0, "VipTime", Mysql_users);
PlayerData[playerid][Banned] = cache_get_field_content_int(0, "Banned", Mysql_users);
cache_get_field_content(0, "BanReason", PlayerData[playerid][BanReason], Mysql_users, 126);
cache_get_field_content(0, "BannedBy", PlayerData[playerid][BannedBy], Mysql_users, 126);
PlayerData[playerid][Warnings] = cache_get_field_content_int(0, "Warnings", Mysql_users);
cache_get_field_content(0, "Warning1Reason", PlayerData[playerid][Warning1Reason], Mysql_users, 126);
cache_get_field_content(0, "Warning2Reason", PlayerData[playerid][Warning2Reason], Mysql_users, 126);
cache_get_field_content(0, "Warning3Reason", PlayerData[playerid][Warning3Reason], Mysql_users, 126);
cache_get_field_content(0, "WarnedBy1", PlayerData[playerid][WarnedBy1], Mysql_users, 126);
cache_get_field_content(0, "WarnedBy2", PlayerData[playerid][WarnedBy2], Mysql_users, 126);
cache_get_field_content(0, "WarnedBy3", PlayerData[playerid][WarnedBy3], Mysql_users, 126);
PlayerData[playerid][Dead] = cache_get_field_content_int(0, "Dead", Mysql_users);
PlayerData[playerid][HospitalTime] = cache_get_field_content_int(0, "HospitalTime", Mysql_users);
PlayerData[playerid][Helper] = cache_get_field_content_int(0, "Helper", Mysql_users);
PlayerData[playerid][Money] = cache_get_field_content_int(0, "Money", Mysql_users);
PlayerData[playerid][MoneyBank] = cache_get_field_content_int(0, "MoneyBank", Mysql_users);
PlayerData[playerid][Score] = cache_get_field_content_int(0, "Score", Mysql_users);
PlayerData[playerid][Skin] = cache_get_field_content_int(0, "Skin", Mysql_users);
PlayerData[playerid][Hour] = cache_get_field_content_int(0, "Hour", Mysql_users);
PlayerData[playerid][Min] = cache_get_field_content_int(0, "Min", Mysql_users);
PlayerData[playerid][Sec] = cache_get_field_content_int(0, "Sec", Mysql_users);
PlayerData[playerid][Kills] = cache_get_field_content_int(0, "Kills", Mysql_users);
PlayerData[playerid][Deaths] = cache_get_field_content_int(0, "Deaths", Mysql_users);
PlayerData[playerid][Kreditai] = cache_get_field_content_int(0, "Kreditai", Mysql_users);
PlayerData[playerid][Taskai] = cache_get_field_content_int(0, "Taskai", Mysql_users);
PlayerData[playerid][nLicenzija] = cache_get_field_content_int(0, "nLicenzija", Mysql_users);
PlayerData[playerid][Navigacija] = cache_get_field_content_int(0, "Navigacija", Mysql_users);
PlayerData[playerid][Radijas] = cache_get_field_content_int(0, "Radijas", Mysql_users);
PlayerData[playerid][Muted] = cache_get_field_content_int(0, "Muted", Mysql_users);
PlayerData[playerid][MutedTime] = cache_get_field_content_int(0, "MutedTime", Mysql_users);
PlayerData[playerid][Premium] = cache_get_field_content_int(0, "Premium", Mysql_users);
PlayerData[playerid][PremiumTime] = cache_get_field_content_int(0, "PremiumTime", Mysql_users);
// TELEFONU SISTEMA
PlayerData[playerid][Telefonas] = cache_get_field_content_int(0, "Telefonas", Mysql_users);
PlayerData[playerid][Tinklas] = cache_get_field_content_int(0, "Tinklas", Mysql_users);
PlayerData[playerid][Numeris] = cache_get_field_content_int(0, "Numeris", Mysql_users);
PlayerData[playerid][tBaterijosBukle] = cache_get_field_content_int(0, "tBaterijosBukle", Mysql_users);
PlayerData[playerid][tBaterija] = cache_get_field_content_int(0, "tBaterija", Mysql_users);
PlayerData[playerid][tBukle] = cache_get_field_content_int(0, "tBukle", Mysql_users);
PlayerData[playerid][tPakrovejas] = cache_get_field_content_int(0, "tPakrovejas", Mysql_users);
// TELEFONU SISTEMA
PlayerData[playerid][Weapon1] = cache_get_field_content_int(0, "Weapon1", Mysql_users);
PlayerData[playerid][Weapon1a] = cache_get_field_content_int(0, "Weapon1a", Mysql_users);
PlayerData[playerid][Weapon2] = cache_get_field_content_int(0, "Weapon2", Mysql_users);
PlayerData[playerid][Weapon2a] = cache_get_field_content_int(0, "Weapon2a", Mysql_users);
PlayerData[playerid][Weapon3] = cache_get_field_content_int(0, "Weapon3", Mysql_users);
PlayerData[playerid][Weapon3a] = cache_get_field_content_int(0, "Weapon3a", Mysql_users);
PlayerData[playerid][Weapon4] = cache_get_field_content_int(0, "Weapon4", Mysql_users);
PlayerData[playerid][Weapon4a] = cache_get_field_content_int(0, "Weapon4a", Mysql_users);
PlayerData[playerid][Weapon5] = cache_get_field_content_int(0, "Weapon5", Mysql_users);
PlayerData[playerid][Weapon5a] = cache_get_field_content_int(0, "Weapon5a", Mysql_users);
PlayerData[playerid][Weapon6] = cache_get_field_content_int(0, "Weapon6", Mysql_users);
PlayerData[playerid][Weapon6a] = cache_get_field_content_int(0, "Weapon6a", Mysql_users);
PlayerData[playerid][Weapon7] = cache_get_field_content_int(0, "Weapon7", Mysql_users);
PlayerData[playerid][Weapon7a] = cache_get_field_content_int(0, "Weapon7a", Mysql_users);
PlayerData[playerid][Weapon8] = cache_get_field_content_int(0, "Weapon8", Mysql_users);
PlayerData[playerid][Weapon8a] = cache_get_field_content_int(0, "Weapon8a", Mysql_users);
PlayerData[playerid][Weapon9] = cache_get_field_content_int(0, "Weapon9", Mysql_users);
PlayerData[playerid][Weapon9a] = cache_get_field_content_int(0, "Weapon9a", Mysql_users);
PlayerData[playerid][Weapon10] = cache_get_field_content_int(0, "Weapon10", Mysql_users);
PlayerData[playerid][Weapon10a] = cache_get_field_content_int(0, "Weapon10a", Mysql_users);
PlayerData[playerid][Weapon11] = cache_get_field_content_int(0, "Weapon11", Mysql_users);
PlayerData[playerid][Weapon11a] = cache_get_field_content_int(0, "Weapon11a", Mysql_users);
PlayerData[playerid][Weapon12] = cache_get_field_content_int(0, "Weapon12", Mysql_users);
PlayerData[playerid][Weapon12a] = cache_get_field_content_int(0, "Weapon12a", Mysql_users);
PlayerData[playerid][Gender] = cache_get_field_content_int(0, "Gender", Mysql_users);
SetSpawnInfo(playerid, 0, PlayerData[playerid][Skin], PlayerData[playerid][PositionX], PlayerData[playerid][PositionY], PlayerData[playerid][PositionZ], PlayerData[playerid][PositionA], PlayerData[playerid][Weapon1], PlayerData[playerid][Weapon1a], PlayerData[playerid][Weapon2], PlayerData[playerid][Weapon2a], PlayerData[playerid][Weapon3], PlayerData[playerid][Weapon3a]);
SetPlayerHealth(playerid, PlayerData[playerid][Health]);
SetPlayerArmour(playerid, PlayerData[playerid][Armour]);
GivePlayerMoney(playerid, PlayerData[playerid][Money]);
SetPlayerScore(playerid, PlayerData[playerid][Score]);
SetPlayerSkin(playerid, PlayerData[playerid][Skin]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon1], PlayerData[playerid][Weapon1a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon2], PlayerData[playerid][Weapon2a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon3], PlayerData[playerid][Weapon3a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon4], PlayerData[playerid][Weapon4a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon5], PlayerData[playerid][Weapon5a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon6], PlayerData[playerid][Weapon6a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon7], PlayerData[playerid][Weapon7a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon8], PlayerData[playerid][Weapon8a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon9], PlayerData[playerid][Weapon9a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon10], PlayerData[playerid][Weapon10a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon11], PlayerData[playerid][Weapon11a]);
GivePlayerWeapon(playerid, PlayerData[playerid][Weapon12], PlayerData[playerid][Weapon12a]);
return 1;
}