- Регистрация
- 22 Фев 2012
- Сообщения
- 21
- Лучшие ответы
- 0
- Репутация
- 0
Приветствую
решил покопаться в одном из старых модов, не спрашивайте почему)
Так вот с горем пополам и бутылкой пива, решаю "что то"
Но наткнулся на вот такую ошибку...
Запускаю локально самп сервер.
К бд коннект есть.
Захожу на сервер, регистрируюсь, выхожу, в БД аккаунта нет((
Я конечно профан,но очень хочется разобраться...
решил покопаться в одном из старых модов, не спрашивайте почему)
Так вот с горем пополам и бутылкой пива, решаю "что то"
Но наткнулся на вот такую ошибку...
Запускаю локально самп сервер.
К бд коннект есть.
Захожу на сервер, регистрируюсь, выхожу, в БД аккаунта нет((
Я конечно профан,но очень хочется разобраться...
C:
public OnPlayerRegister(playerid, password[])
{
if(IsPlayerConnected(playerid))
{
new string[256];
format(string,sizeof(string),"%s",date("%yyyy-%mm-%dd %hh:%ii:%ss",gettime()));
mysql_real_escape_string(string, string);
format(string, sizeof(string), "INSERT INTO `users` (`Name`, `Key`, `DataReg`) VALUES ('%s', '%s', '%s')", Name(playerid), password, string);
mysql_query(string);
PlayerInfo[playerid][pId] = mysql_insert_id();
SPD(playerid,332,DIALOG_STYLE_INPUT," ","{"#cWHITE"}Введите ник игрока пригласившего Вас на сервер\nЕсли такого игрока нет, нажмите 'Пропуск'","Ok","Пропуск");
}
return true;
C:
public OnPlayerLogin(playerid, password[])
{
new query[128];
new sqlpass[64];
new resultik[256];
new val[128];
strmid(sqlpass,password,0,17,17);
format(query, sizeof(query), "SELECT * FROM `users` WHERE `Key` = '%s' AND `Id` = '%i'", sqlpass, PlayerInfo[playerid][pId]);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1)
{
while(mysql_fetch_row_format(resultik, "|"))
{
mysql_fetch_field_row(val, "Id"); PlayerInfo[playerid][pId] = strval( val );
mysql_fetch_field_row(val, "Name"); strmid(PlayerInfo[playerid][pName], val, 0, strlen(val), 255);
mysql_fetch_field_row(val, "Level"); PlayerInfo[playerid][pLevel] = strval( val );
mysql_fetch_field_row(val, "AdminLevel"); PlayerInfo[playerid][pAdmin] = strval( val );
mysql_fetch_field_row(val, "HelperLevel"); PlayerInfo[playerid][pHelper] = strval( val );
mysql_fetch_field_row(val, "Donate"); PlayerInfo[playerid][pDonate] = strval( val );
mysql_fetch_field_row(val, "ServerStatus"); PlayerInfo[playerid][pStatus] = strval( val );
mysql_fetch_field_row(val, "Registered"); PlayerInfo[playerid][pReg] = strval( val );
mysql_fetch_field_row(val, "Sex"); PlayerInfo[playerid][pSex] = strval( val );
mysql_fetch_field_row(val, "Age"); PlayerInfo[playerid][pAge] = strval( val );
mysql_fetch_field_row(val, "Origin"); PlayerInfo[playerid][pOrigin] = strval( val );
mysql_fetch_field_row(val, "Muted"); PlayerInfo[playerid][pMuted] = strval( val );
mysql_fetch_field_row(val, "Respect"); PlayerInfo[playerid][pExp] = strval( val );
mysql_fetch_field_row(val, "Money"); PlayerInfo[playerid][pCash] = strval( val );
mysql_fetch_field_row(val, "Bank"); PlayerInfo[playerid][pAccount] = strval( val );
mysql_fetch_field_row(val, "Crimes"); PlayerInfo[playerid][pCrimes] = strval( val );
mysql_fetch_field_row(val, "Kills"); PlayerInfo[playerid][pKills] = strval( val );
mysql_fetch_field_row(val, "Deaths"); PlayerInfo[playerid][pDeaths] = strval( val );
mysql_fetch_field_row(val, "Phonebook"); PlayerInfo[playerid][pPhoneBook] = strval( val );
mysql_fetch_field_row(val, "Fishes"); PlayerInfo[playerid][pFishes] = strval( val );
mysql_fetch_field_row(val, "Job"); PlayerInfo[playerid][pJob] = strval( val );
mysql_fetch_field_row(val, "Paycheck"); PlayerInfo[playerid][pPayCheck] = strval( val );
mysql_fetch_field_row(val, "HeadValue"); PlayerInfo[playerid][pHeadValue] = strval( val );
mysql_fetch_field_row(val, "Jailed"); PlayerInfo[playerid][pJailed] = strval( val );
mysql_fetch_field_row(val, "JailTime"); PlayerInfo[playerid][pJailTime] = strval( val );
mysql_fetch_field_row(val, "Materials"); PlayerInfo[playerid][pMats] = strval( val );
mysql_fetch_field_row(val, "Drugs"); PlayerInfo[playerid][pDrugs] = strval( val );
mysql_fetch_field_row(val, "LevelDost"); PlayerInfo[playerid][pLevelDost] = strval( val );
mysql_fetch_field_row(val, "DrugsDost"); PlayerInfo[playerid][pDrugsDost] = strval( val );
mysql_fetch_field_row(val, "FishDost"); PlayerInfo[playerid][pFishDost] = strval( val );
mysql_fetch_field_row(val, "GonkaDost"); PlayerInfo[playerid][pGonkaDost] = strval( val );
mysql_fetch_field_row(val, "ZonaDost"); PlayerInfo[playerid][pZonaDost] = strval( val );
mysql_fetch_field_row(val, "AmmoDost"); PlayerInfo[playerid][pAmmoDost] = strval( val );
mysql_fetch_field_row(val, "PaintDost"); PlayerInfo[playerid][pPaintDost] = strval( val );
mysql_fetch_field_row(val, "MexDost"); PlayerInfo[playerid][pMexDost] = strval( val );
mysql_fetch_field_row(val, "MusorDost"); PlayerInfo[playerid][pMusorDost] = strval( val );
mysql_fetch_field_row(val, "SuDost"); PlayerInfo[playerid][pSuDost] = strval( val );
mysql_fetch_field_row(val, "PrestDost"); PlayerInfo[playerid][pPrestDost] = strval( val );
mysql_fetch_field_row(val, "DuelDost"); PlayerInfo[playerid][pDuelDost] = strval( val );
mysql_fetch_field_row(val, "MeshokDost"); PlayerInfo[playerid][pMeshokDost] = strval( val );
mysql_fetch_field_row(val, "TaxiDost"); PlayerInfo[playerid][pTaxiDost] = strval( val );
mysql_fetch_field_row(val, "RaceMoneyDost"); PlayerInfo[playerid][pRaceMoneyDost ] = strval( val );
mysql_fetch_field_row(val, "ProdsDost"); PlayerInfo[playerid][pProdsDost] = strval( val );
mysql_fetch_field_row(val, "TaxDost"); PlayerInfo[playerid][pTaxDost] = strval( val );
mysql_fetch_field_row(val, "PeregonDost"); PlayerInfo[playerid][pPeregonDost] = strval( val );
mysql_fetch_field_row(val, "Lomka"); PlayerInfo[playerid][pLomka] = strval( val );
mysql_fetch_field_row(val, "Dm"); PlayerInfo[playerid][pDonateMoney] = strval( val );
mysql_fetch_field_row(val, "Leader"); PlayerInfo[playerid][pLeader] = strval( val );
mysql_fetch_field_row(val, "Member"); PlayerInfo[playerid][pMember] = strval( val );
mysql_fetch_field_row(val, "FWarns"); PlayerInfo[playerid][pFWarns] = strval( val );
mysql_fetch_field_row(val, "FMember"); PlayerInfo[playerid][pFMember] = strval( val );
mysql_fetch_field_row(val, "FamMember"); PlayerInfo[playerid][pFamMember] = strval( val );
mysql_fetch_field_row(val, "Rank"); PlayerInfo[playerid][pRank] = strval( val );
mysql_fetch_field_row(val, "Char"); PlayerInfo[playerid][pChar] = strval( val );
mysql_fetch_field_row(val, "CharSlot1"); PlayerInfo[playerid][pCharSlot1] = strval( val );
mysql_fetch_field_row(val, "CharSlot2"); PlayerInfo[playerid][pCharSlot2] = strval( val );
mysql_fetch_field_row(val, "CharSlot3"); PlayerInfo[playerid][pCharSlot3] = strval( val );
mysql_fetch_field_row(val, "CharSlot4"); PlayerInfo[playerid][pCharSlot4] = strval( val );
mysql_fetch_field_row(val, "CharSlot5"); PlayerInfo[playerid][pCharSlot5] = strval( val );
mysql_fetch_field_row(val, "CharSlot6"); PlayerInfo[playerid][pCharSlot6] = strval( val );
mysql_fetch_field_row(val, "CharSlot7"); PlayerInfo[playerid][pCharSlot7] = strval( val );
mysql_fetch_field_row(val, "CharSlot8"); PlayerInfo[playerid][pCharSlot8] = strval( val );
mysql_fetch_field_row(val, "CharSlot9"); PlayerInfo[playerid][pCharSlot9] = strval( val );
mysql_fetch_field_row(val, "CharSlot10"); PlayerInfo[playerid][pCharSlot10] = strval( val );
mysql_fetch_field_row(val, "CharSlot11"); PlayerInfo[playerid][pCharSlot11] = strval( val );
mysql_fetch_field_row(val, "DetSkill"); PlayerInfo[playerid][pDetSkill] = strval( val );
mysql_fetch_field_row(val, "SexSkill"); PlayerInfo[playerid][pSexSkill] = strval( val );
mysql_fetch_field_row(val, "LawSkill"); PlayerInfo[playerid][pLawSkill] = strval( val );
mysql_fetch_field_row(val, "MechSkill"); PlayerInfo[playerid][pMechSkill] = strval( val );
mysql_fetch_field_row(val, "JackSkill"); PlayerInfo[playerid][pJackSkill] = strval( val );
mysql_fetch_field_row(val, "CarSkill"); PlayerInfo[playerid][pCarSkill] = strval( val );
mysql_fetch_field_row(val, "NewsSkill"); PlayerInfo[playerid][pNewsSkill] = strval( val );
mysql_fetch_field_row(val, "DrugsSkill"); PlayerInfo[playerid][pDrugsSkill] = strval( val );
mysql_fetch_field_row(val, "FishSkill"); PlayerInfo[playerid][pFishSkill] = strval( val );
mysql_fetch_field_row(val, "pSHealth"); PlayerInfo[playerid][pSHealth] = floatstr( val );
mysql_fetch_field_row(val, "pHealth"); PlayerInfo[playerid][pHealth] = floatstr( val );
mysql_fetch_field_row(val, "Local"); PlayerInfo[playerid][pLocal] = strval( val );
mysql_fetch_field_row(val, "PhoneNr"); PlayerInfo[playerid][pPnumber] = strval( val );
mysql_fetch_field_row(val, "House"); PlayerInfo[playerid][pPhousekey] = strval( val );
mysql_fetch_field_row(val, "Bizz"); PlayerInfo[playerid][pPbiskey] = strval( val );
mysql_fetch_field_row(val, "CarLic"); PlayerInfo[playerid][pCarLic] = strval( val );
mysql_fetch_field_row(val, "FlyLic"); PlayerInfo[playerid][pFlyLic] = strval( val );
mysql_fetch_field_row(val, "BoatLic"); PlayerInfo[playerid][pBoatLic] = strval( val );
mysql_fetch_field_row(val, "FishLic"); PlayerInfo[playerid][pFishLic] = strval( val );
mysql_fetch_field_row(val, "GunLic"); PlayerInfo[playerid][pGunLic] = strval( val );
mysql_fetch_field_row(val, "Gun1"); PlayerInfo[playerid][pGun1] = strval( val );
mysql_fetch_field_row(val, "Gun2"); PlayerInfo[playerid][pGun2] = strval( val );
mysql_fetch_field_row(val, "Gun3"); PlayerInfo[playerid][pGun3] = strval( val );
mysql_fetch_field_row(val, "Gun4"); PlayerInfo[playerid][pGun4] = strval( val );
mysql_fetch_field_row(val, "Ammo1"); PlayerInfo[playerid][pAmmo1] = strval( val );
mysql_fetch_field_row(val, "Ammo2"); PlayerInfo[playerid][pAmmo2] = strval( val );
mysql_fetch_field_row(val, "Ammo3"); PlayerInfo[playerid][pAmmo3] = strval( val );
mysql_fetch_field_row(val, "Ammo4"); PlayerInfo[playerid][pAmmo4] = strval( val );
mysql_fetch_field_row(val, "PayDay"); PlayerInfo[playerid][pPayDay] = strval( val );
mysql_fetch_field_row(val, "CDPlayer"); PlayerInfo[playerid][pCDPlayer] = strval( val );
mysql_fetch_field_row(val, "AlcoholPerk"); PlayerInfo[playerid][pAlcoholPerk] = strval( val );
mysql_fetch_field_row(val, "DrugPerk"); PlayerInfo[playerid][pDrugPerk] = strval( val );
mysql_fetch_field_row(val, "MiserPerk"); PlayerInfo[playerid][pMiserPerk] = strval( val );
mysql_fetch_field_row(val, "PainPerk"); PlayerInfo[playerid][pPainPerk] = strval( val );
mysql_fetch_field_row(val, "TraderPerk"); PlayerInfo[playerid][pTraderPerk] = strval( val );
mysql_fetch_field_row(val, "MuteTime"); PlayerInfo[playerid][pMuteTime] = strval( val );
mysql_fetch_field_row(val, "Warnings"); PlayerInfo[playerid][pWarns] = strval( val );
mysql_fetch_field_row(val, "Fuel"); PlayerInfo[playerid][pFuel] = strval( val );
mysql_fetch_field_row(val, "CarKey2"); PlayerInfo[playerid][pCarKey2] = strval( val );
mysql_fetch_field_row(val, "VehKey"); PlayerInfo[playerid][pVehKey] = strval( val );
mysql_fetch_field_row(val, "CarKey"); PlayerInfo[playerid][pCarKey] = strval( val );
mysql_fetch_field_row(val, "Married"); PlayerInfo[playerid][pMarried] = strval( val );
mysql_fetch_field_row(val, "DayTax"); PlayerInfo[playerid][pDayTax] = strval( val );
mysql_fetch_field_row(val, "WarnTime"); PlayerInfo[playerid][pWarnTime] = strval( val );
mysql_fetch_field_row(PlayerInfo[playerid][pEmail], "Email");
mysql_fetch_field_row(PlayerInfo[playerid][pInvite], "Invite");//By Viktor
mysql_fetch_field_row(val, "EmailReg"); PlayerInfo[playerid][pEmailReg] = strval( val );
mysql_fetch_field_row(val, "ChangeName"); PlayerInfo[playerid][pChangeName] = strval( val );
mysql_fetch_field_row(val, "CarNumber"); PlayerInfo[playerid][pCarNumber] = strval( val );
mysql_fetch_field_row(val, "pDataReg"); PlayerInfo[playerid][pDataReg] = strval( val );
mysql_fetch_field_row(val, "VipTime"); PlayerInfo[playerid][pVipTime] = strval( val );
mysql_fetch_field_row(val, "DeathsP"); PlayerInfo[playerid][pDeathsP] = strval( val );
mysql_fetch_field_row(val, "KillsP"); PlayerInfo[playerid][pKillsP] = strval( val );
mysql_fetch_field_row(val, "Forum"); PlayerInfo[playerid][pForum] = strval( val );
mysql_fetch_field_row(val, "Sigars"); PlayerInfo[playerid][pSigars] = strval( val );
mysql_fetch_field_row(val, "Zhiga"); PlayerInfo[playerid][pZhiga] = strval( val );
mysql_fetch_field_row(val, "fMute"); PlayerInfo[playerid][pfMute] = strval( val );
mysql_fetch_field_row(val, "Uron"); PlayerInfo[playerid][pUron] = strval( val );
//mysql_fetch_field_row(val, "Veh"); PlayerInfo[playerid][pVeh] = strval( val );
mysql_fetch_field_row(val, "Car"); PlayerInfo[playerid][pCars] = strval( val );
mysql_fetch_field_row(val, "MarriedTo"); strmid(PlayerInfo[playerid][pMarriedTo], val, 0, strlen(val), 255);
mysql_fetch_field_row(val, "FreeCar"); PlayerInfo[playerid][pFreeCar] = strval( val );
mysql_fetch_field_row(val, "GiveExp"); PlayerInfo[playerid][pGiveExp] = strval( val );
//mysql_fetch_field_row(val, "Online_Hours"); PlayerInfo[playerid][pOnline_Hours] = strval( val );
mysql_fetch_field_row(val, "Text"); PlayerInfo[playerid][pText] = strval( val );
mysql_fetch_field_row(val, "lhelper"); PlayerInfo[playerid][plhelper] = strval( val );
//mysql_fetch_field_row(val, "PersID"); PlayerInfo[playerid][pPid] = strval( val );
}
mysql_free_result();
}
else
{
new stringer[56];
if(GetPVarInt(playerid, "wrongPass") == 1) return SendClientMessage(playerid,COLOR_RED,"Âû 3 ðàçà ââåëè íåâåðíûé ïàðîëü, Âû êèêíóòû ñ ñåðâåðà"), Kick(playerid);
SetPVarInt(playerid, "wrongPass", GetPVarInt(playerid, "wrongPass")-1);
format(stringer, sizeof(stringer), "Black-Streets RPG: Íåâåðíûé ïàðîëü, îñòàëîñü %d ïîïûòîê(è)",GetPVarInt(playerid, "wrongPass"));//ïåðåíåñòè
send(playerid,COLOR_RED,stringer);
send(playerid, COLOR_RED, "Black-Streets RPG: Íåâåðíûé ïàðîëü, åñëè Âû 3 ðàçà ââåäåòå ïàðîëü íå âåðíî, òî Âû áóäåòå êèêíóòû");
return 1;
}
CancelSelectTextDraw(playerid);
if(WelcomeToLoginDraw[playerid] != PlayerText:INVALID_TEXT_DRAW) PlayerTextDrawDestroy(playerid, WelcomeToLoginDraw[playerid]), WelcomeToLoginDraw[playerid] = PlayerText:INVALID_TEXT_DRAW;
for(new i,s = sizeof(BlackFONRGRPG); i < s; i++) TextDrawHideForPlayer(playerid, BlackFONRGRPG[i]);
for(new i,s = sizeof(LoginDraw); i < s; i++) TextDrawHideForPlayer(playerid, LoginDraw[i]);
TextDrawHideForPlayer(playerid, RegisterDraw[2]);
new name[MAX_PLAYER_NAME];
new newt[MAX_PLAYERS];
new string[138];
ResetPlayerMoney(playerid);
PlayerInfo[playerid][pMuteTime] = 0;
PlayerInfo[playerid][pMuted] = 0;
GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
gPlayerLogged[playerid] = 1;
SetSpawnInfo(playerid, 0, random(300), 10.0, 10.0, 3.0, 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
HealthSpawn(playerid);
for(new i; i < 2; i++) TextDrawShowForPlayer(playerid, ClockDraw[i]);
newt[playerid] = 0;
GetPlayerName(playerid,name,sizeof(name));
if(PlayerInfo[playerid][pLevel] == 20) { PlayerInfo[playerid][pSHealth] = PlayerInfo[playerid][pSHealth] + 20.0; }
if(PlayerInfo[playerid][pDuelDost] == 100) { PlayerInfo[playerid][pSHealth] = PlayerInfo[playerid][pSHealth] + 20.0; }
SetTimerEx("TextDrawW",5000,0,"%d",playerid);
format(string, sizeof(string), "{49FF00}-{"#cWHITE"} Äîáðî ïîæàëîâàòü, {01F5B4}%s",PlayerInfo[playerid][pName]);//{b3f9b0}
send(playerid,0xFFFFFFFF,string);
if(PlayerInfo[playerid][pDonate] >= 1)
{
format(string, sizeof(string), "- Âû âîøëè êàê {FFBC00}VIP {"#cWHITE"}èãðîê {FFBC00}[%d lvl], VIP {"#cWHITE"}äåéñòâèòåëåí äî {FFBC00}%s {"#cWHITE"}(ñåãîäíÿ: %s)",PlayerInfo[playerid][pDonate],date("%yyyy-%mm-%dd",PlayerInfo[playerid][pVipTime]),date("%yyyy-%mm-%dd",gettime()));
send(playerid, 0xFFFFFFFF,string);
}
if(PlayerInfo[playerid][pLeader] >= 1)
{
format(string, sizeof(string), "{49FF00}-{"#cWHITE"} Âû âîøëè êàê ëèäåð îðãàíèçàöèè {FFFF00}¹%d {"#cWHITE"} | Ïàíåëü ëèäåðà: {FFFF00}/lpanel",PlayerInfo[playerid][pLeader]);
send(playerid, 0xFFFFFFFF,string);
}
if(PlayerInfo[playerid][pAdmin] >= 1)
{
format(string, sizeof(string), "{49FF00}-{"#cWHITE"} Âû âîøëè êàê àäìèíèñòðàòîð {C15250}%d {"#cWHITE"}óðîâíÿ | Êîìàíäû àäìèíèñòðàöèè: {C15250}/ah",PlayerInfo[playerid][pAdmin]);
send(playerid, 0xFFFFFFFF,string); // 00d8ff
}
if(PlayerInfo[playerid][pDonate] >= 1)
{
if(gettime() >= PlayerInfo[playerid][pVipTime])
{
PlayerInfo[playerid][pDonate] = 0;
PlayerInfo[playerid][pVipTime] = 0;
}
}
if(PlayerInfo[playerid][pWarns] > 0)
{
if(gettime() >= PlayerInfo[playerid][pWarnTime])
{
PlayerInfo[playerid][pWarnTime] = 0;
PlayerInfo[playerid][pWarns] = 0;
send(playerid,COLOR_WHITE,"Ñ Âàøåãî àêêàóíòà ñáðîøåíû âñå ïðåäóïðåæäåíèÿ");
}
}
if(PlayerInfo[playerid][pCars] > 0)
{
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid,playername,sizeof(playername));
caridhouse[playerid] = CreateVehicle(400, 0.0, 0.0, 0.0, 0.0, 0, 0, 5600);
DestroyVehicle(caridhouse[playerid]);
CarLoad(caridhouse[playerid], PlayerInfo[playerid][pCars]);
caridhouse[playerid] = CreateVehicle(CarInfo[caridhouse[playerid]][cModel], CarInfo[caridhouse[playerid]][cPosX], CarInfo[caridhouse[playerid]][cPosY], CarInfo[caridhouse[playerid]][cPosZ], CarInfo[caridhouse[playerid]][cPosR], CarInfo[caridhouse[playerid]][cColor1], CarInfo[caridhouse[playerid]][cColor2], 5600);
LockCar(caridhouse[playerid]);
LoadCarTuning(playerid);
format(string,sizeof(string),"BS %d RPG", CarInfo[caridhouse[playerid]][cID]);//òåñòðóåì
SetVehicleNumberPlate(caridhouse[playerid], string);
format(string, sizeof(string), "Owner: {FFFFFF}%s\n{9ACD32}ID: {FFFFFF}%d{9ACD32}", playername, CarInfo[caridhouse[playerid]][cID]);//03.02.2014 íà âñåõ êàðàõ òåïåðü Owner, ID êðàñíûì öâåòîì
vehicle3Dtext[caridhouse[playerid]] = Create3DTextLabel( string, 0xFF0000AA, 0.0, 0.0, 0.0, 10.0, 0, 1 );
Attach3DTextLabelToVehicle( vehicle3Dtext[caridhouse[playerid]], caridhouse[playerid], 0.0, 0.0, 1.0);//ñäåëàòü íîìåðà íà ëè÷. àâòî ÷åðåç âèï è äîáàâèòü owner, id ê ïîêóïêå êàðà ÷åðåç äîíàò
}
if(PlayerInfo[playerid][pText] == 1) return send(playerid, COLOR_WHITE, "Âàø äîì áûë ïðîäàí çà íåóïëàòó íàëîãîâ");
if(PlayerInfo[playerid][pText] == 2) return send(playerid, COLOR_WHITE, "Âàø áèçíåñ áûë ïðîäàí çà íåóïëàòó íàëîãîâ");
PlayerInfo[playerid][pText] = 0;
// if(PlayerInfo[playerid][pLevel] >= 3) { if(PlayerInfo[playerid][pEmailReg] == 0) return send(playerid, COLOR_LIGHTRED,"[Âíèìàíèå] {"#cWHITE"}Íà Âàøåì àêêàóíòå íå óêàçàí E-Mail àäðåñ, ïîäðîáíîñòè: /menu - Áåçîïàñíîñòü"); }
// if(PlayerInfo[playerid][pLevel] >= 5) { if(PlayerInfo[playerid][pForum] == 0) return send(playerid, COLOR_LIGHTRED,"[Âíèìàíèå] {"#cWHITE"}Âû ìîæåòå çàðåãèñòðèðîâàòü àêêàóíò íà ôîðóìå, ïîäðîáíîñòè: /menu - Ðåãèñòðàöèÿ íà ôîðóìå"); }
if(PlayerInfo[playerid][pPhousekey] != 255)
{
new h = PlayerInfo[playerid][pPhousekey];
SetPlayerMapIcon(playerid,35,HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],35,0);
}
// DateProp(playerid);
new strstrstr[256];
if(PlayerInfo[playerid][pPbiskey] != MAX_BIZ)
{
if(PlayerInfo[playerid][pPbiskey] >= 100)
{
format(strstrstr,sizeof(strstrstr),"%s",SBizzInfo[PlayerInfo[playerid][pPbiskey]-100][sbOwner]);
if(!strcmp(strstrstr,PlayerInfo[playerid][pName],true)){}
else{PlayerInfo[playerid][pPbiskey] = MAX_BIZ;}
}
else
{
format(strstrstr,sizeof(strstrstr),"%s",BizzInfo[PlayerInfo[playerid][pPbiskey]][bOwner]);
if(!strcmp(strstrstr,PlayerInfo[playerid][pName],true)){}
else{PlayerInfo[playerid][pPbiskey] = MAX_BIZ;}
}
}
return true;
}
C:
public OnPlayerSave(playerid)
{
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid] == 1)
{
new string[3113];
if(PlayerInfo[playerid][pOnline_Hours] > 0) //????
{
format(string,128,"SELECT * FROM `online_players` WHERE `Name`='%s' LIMIT 1",Name(playerid));
mysql_query(string);
mysql_store_result();
new online_player_in_table = mysql_num_rows();
mysql_free_result();
if(online_player_in_table < 1)
{
format(string,128,"UPDATE `online_players` (`Name`,`Online_Hours`) VALUES ('%s','%d')",Name(playerid),PlayerInfo[playerid][pOnline_Hours]);
mysql_query(string);
}
else
{
// ? format(string,128,"UPDATE `online_players` SET Online_Hours = Online_Hours+%d WHERE `Name`='%s' LIMIT 1",PlayerInfo[playerid][pOnline_Hours],Name(playerid));
// mysql_query(string);
format(string,128,"UPDATE `online_players` SET `Online_Hours` = '%d' WHERE `Name`='%s' LIMIT 1",PlayerInfo[playerid][pOnline_Hours],Name(playerid));
mysql_query(string);
}
}
GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
new name[24];
mysql_real_escape_string(Name(playerid), name);
new marriedto[48];
mysql_real_escape_string(PlayerInfo[playerid][pMarriedTo], marriedto);
new invite[21];
mysql_real_escape_string(PlayerInfo[playerid][pInvite], invite);//By Viktor
new string2[32],strstre[32];
format(strstre,sizeof(strstre),"%s",date("%yyyy-%mm-%dd %hh:%ii:%ss",gettime()));
mysql_real_escape_string(strstre, string2);
format(string, sizeof(string), "UPDATE `users` SET `Level`='%d',`AdminLevel`='%d',`HelperLevel`='%d',`Donate`='%d',`ServerStatus` = '%d'", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pDonate], PlayerInfo[playerid][pStatus]);
format(string, sizeof(string), "%s, `Registered`='%d',`Sex`='%d',`Age`='%d',`Origin`='%d',`Muted` = '%d'", string, PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pMuted]);
format(string, sizeof(string), "%s, `Respect`='%d',`Money`='%d',`Bank`='%d',`Crimes`='%d',`Kills` = '%d'", string, PlayerInfo[playerid][pExp], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills]);
format(string, sizeof(string), "%s, `Deaths`='%d',`Phonebook`='%d',`Fishes`='%d',`Job`='%d',`Paycheck` = '%d'", string, PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck]);
format(string, sizeof(string), "%s, `HeadValue`='%d',`Jailed`='%d',`JailTime`='%d',`Materials`='%d',`Drugs` = '%d'", string, PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs]);
format(string, sizeof(string), "%s, `LevelDost`='%d',`DrugsDost`='%d',`FishDost`='%d',`GonkaDost`='%d',`ZonaDost` = '%d'", string, PlayerInfo[playerid][pLevelDost], PlayerInfo[playerid][pDrugsDost], PlayerInfo[playerid][pFishDost], PlayerInfo[playerid][pGonkaDost], PlayerInfo[playerid][pZonaDost]);
format(string, sizeof(string), "%s, `AmmoDost`='%d',`PaintDost`='%d',`MexDost`='%d',`MusorDost`='%d',`SuDost` = '%d'", string, PlayerInfo[playerid][pAmmoDost], PlayerInfo[playerid][pPaintDost], PlayerInfo[playerid][pMexDost], PlayerInfo[playerid][pMusorDost], PlayerInfo[playerid][pSuDost]);
format(string, sizeof(string), "%s, `PrestDost`='%d',`DuelDost`='%d',`MeshokDost`='%d',`TaxiDost`='%d',`RaceMoneyDost` = '%d'", string, PlayerInfo[playerid][pPrestDost], PlayerInfo[playerid][pDuelDost], PlayerInfo[playerid][pMeshokDost], PlayerInfo[playerid][pTaxiDost], PlayerInfo[playerid][pRaceMoneyDost]);
format(string, sizeof(string), "%s, `ProdsDost`='%d',`TaxDost`='%d',`PeregonDost`='%d',`Dm`='%d',`Leader`='%d',`Member` = '%d'", string, PlayerInfo[playerid][pProdsDost], PlayerInfo[playerid][pTaxDost], PlayerInfo[playerid][pPeregonDost], PlayerInfo[playerid][pDonateMoney], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pMember]);
format(string, sizeof(string), "%s, `FWarns`='%d',`FMember`='%d',`FamMember`='%d',`Rank`='%d',`Char` = '%d'", string, PlayerInfo[playerid][pFWarns], PlayerInfo[playerid][pFMember], PlayerInfo[playerid][pFamMember], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar]);
format(string, sizeof(string), "%s, `CharSlot1`='%d',`CharSlot2`='%d',`CharSlot3`='%d',`CharSlot4`='%d',`CharSlot5` = '%d'", string, PlayerInfo[playerid][pCharSlot1], PlayerInfo[playerid][pCharSlot2], PlayerInfo[playerid][pCharSlot3], PlayerInfo[playerid][pCharSlot4], PlayerInfo[playerid][pCharSlot5]);
format(string, sizeof(string), "%s, `CharSlot6`='%d',`CharSlot7`='%d',`CharSlot8`='%d',`CharSlot9`='%d',`CharSlot10` = '%d'", string, PlayerInfo[playerid][pCharSlot6], PlayerInfo[playerid][pCharSlot7], PlayerInfo[playerid][pCharSlot8], PlayerInfo[playerid][pCharSlot9], PlayerInfo[playerid][pCharSlot10]);
format(string, sizeof(string), "%s, `CharSlot11`='%d',`DetSkill`='%d',`SexSkill`='%d',`LawSkill`='%d',`MechSkill` = '%d'", string, PlayerInfo[playerid][pCharSlot11], PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pLawSkill], PlayerInfo[playerid][pMechSkill]);
format(string, sizeof(string), "%s, `JackSkill`='%d',`CarSkill`='%d',`NewsSkill`='%d',`DrugsSkill`='%d',`FishSkill` = '%d'", string, PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pCarSkill], PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pFishSkill]);
format(string, sizeof(string), "%s, `pSHealth`='%f',`pHealth`='%f',`Local`='%d',`PhoneNr`='%d',`House` = '%d'", string, PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pPhousekey]);
format(string, sizeof(string), "%s, `Bizz`='%d',`CarLic`='%d',`FlyLic`='%d',`BoatLic`='%d',`FishLic` = '%d'", string, PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic]);
format(string, sizeof(string), "%s, `GunLic`='%d',`Gun1`='%d',`Gun2`='%d',`Gun3`='%d',`Gun4` = '%d'", string, PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4]);
format(string, sizeof(string), "%s, `Ammo1`='%d',`Ammo2`='%d',`Ammo3`='%d',`Ammo4`='%d',`PayDay` = '%d'", string, PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pPayDay]);
format(string, sizeof(string), "%s, `CDPlayer`='%d',`AlcoholPerk`='%d',`DrugPerk`='%d',`MiserPerk`='%d',`PainPerk` = '%d'", string, PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk]);
format(string, sizeof(string), "%s, `TraderPerk`='%d',`MuteTime`='%d',`Warnings`='%d',`Fuel`='%d',`CarKey2` = '%d'", string, PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pMuteTime], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pCarKey2]);
format(string, sizeof(string), "%s, `CarKey`='%d',`VehKey`='%d',`Married`='%d',`DayTax`='%d',`WarnTime` = '%d'", string, PlayerInfo[playerid][pCarKey], PlayerInfo[playerid][pVehKey], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pDayTax], PlayerInfo[playerid][pWarnTime]);
format(string, sizeof(string), "%s, `Email`='%s',`Invite`='%s',`EmailReg`='%d',`ChangeName`='%d',`CarNumber` = '%d'", string, PlayerInfo[playerid][pEmail], invite, PlayerInfo[playerid][pEmailReg], PlayerInfo[playerid][pChangeName], PlayerInfo[playerid][pCarNumber]);
format(string, sizeof(string), "%s, `VipTime`='%d',`DeathsP`='%d',`KillsP`='%d',`Forum`='%d',`Sigars` = '%d',`Lomka` = '%d'", string, PlayerInfo[playerid][pVipTime], PlayerInfo[playerid][pDeathsP], PlayerInfo[playerid][pKillsP], PlayerInfo[playerid][pForum], PlayerInfo[playerid][pSigars], PlayerInfo[playerid][pLomka]);
format(string, sizeof(string), "%s, `Zhiga`='%d',`fMute`='%d',`Uron`='%d',`Car`='%d',`FreeCar`='%d',`LastOnline`='%s'", string, PlayerInfo[playerid][pZhiga], PlayerInfo[playerid][pfMute], PlayerInfo[playerid][pUron], PlayerInfo[playerid][pCars], PlayerInfo[playerid][pFreeCar], string2);
format(string, sizeof(string), "%s, `MarriedTo`='%s',`GiveExp`='%d',`Text`='%d',`lhelper`='%d'", string, marriedto, PlayerInfo[playerid][pGiveExp], PlayerInfo[playerid][pText], PlayerInfo[playerid][plhelper]);//`Veh`='%d' - перед FreeCar
format(string, sizeof(string), "%s WHERE `Id`='%i' LIMIT 1", string, PlayerInfo[playerid][pId]);
mysql_query(string);
}
}
return true;
}
Последнее редактирование: