Jump to content

SpriteTV

Membru
  • Posts

    65
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by SpriteTV

  1. am gm bigzone dar adus intr`o stare mult avansata si facut pe include-uri. dar mai bagat rau inceata cu baza de date
  2. Salut am si eu problema urmatoare nu mi-se salveaza rob points-ul si nu inteleg care ar fi problema daca se poate sa ma ajute cineva. public PayDay() { new string[128], str[256], string3[256], interest, account[MAX_PLAYERS], hour, minn, sec, ye, mo, da, rent[MAX_PLAYERS], hourscount; gettime(hour,minn,sec); getdate(ye, mo, da); if(RestartTimer == 1) { SendClientMessageToAll(COLOR_YELLOW, "---- SERVER RESTART ----"); SendClientMessageToAll(COLOR_RED2, "The server will be restarted in 60 seconds."); foreach(new x : Player) { Update(x, pPayDayx); Update(x, pPayCheckx); Update(x, pFpunishx); Update(x, pConnectTimex); Update(x, pBank); Update(x, pCashx); Update(x, pExpx); Update(x, pJailTimex); Update(x, pLevelx); Update(x, pRob); } iGMXTick = 60; iGMXTimer = SetTimer("restartTimer", 1000, true); RestartTimer = 0; } foreach(new i : Player) { if(IsPlayerConnected(i)) { if(PlayerInfo[i][pLevel] >= 0) { new wakaname[25]; GetPlayerName(i,wakaname,sizeof(wakaname)); if(MoneyMessage[i]==1) { SendClientMessage(i, COLOR_LIGHTRED, "You failed to pay your debt, Jail time."); new rand; rand = random(sizeof(gRandomJailSpawns)); SetPlayerInterior(i, 6); SetPlayerPosEx(i,gRandomJailSpawns[rand][0],gRandomJailSpawns[rand][1],gRandomJailSpawns[rand][2]); PlayerInfo[i][pJailed] = 1; ResetPlayerWeaponsEx(i); ResetPlayerWeapons(i); WantedPoints[i] = 0; PlayerInfo[i][pJailTime] = 240; format(string, sizeof(string), "You are jailed for %d seconds. Bail: Unable", PlayerInfo[i][pJailTime]); SendClientMessage(i, COLOR_LIGHTBLUE, string); ResetPlayerCash(i); GivePlayerCash(i, 10000); Update(i, pCashx); Update(i,pJailedx); Update(i,pJailTimex); TogglePlayerControllable(i, 0); SetTimerEx("UnFreezeStation", 1000, false, "i", i); } new key = PlayerInfo[i][pPhousekey]; if(key != 999) { rent[i] = HouseInfo[key][hRent]; if(rent[i] > GetPlayerCash(i) && strcmp(PlayerInfo[i][pNormalName], HouseInfo[key][hOwner], false) == 0) { PlayerInfo[i][pPhousekey] = 999; Update(i,pPhousekeyx); } HouseInfo[key][hTakings] += rent[i]; mysql_format(SQL,str,sizeof(str),"UPDATE `houses` SET `Takings`='%d' WHERE `ID`='%d'",HouseInfo[key][hTakings],key); mysql_tquery(SQL,str,"",""); } new tmpintrate; if(PlayerInfo[i][pPremiumAccount] > 0) { tmpintrate = 2; new bonus = PlayerInfo[i][pPayCheck] / 2; PlayerInfo[i][pPayCheck] += bonus; } else { tmpintrate = 1; } account[i] = PlayerInfo[i][pAccount]; Tax += TaxValue; PlayerInfo[i][pAccount] -= TaxValue; new checks = PlayerInfo[i][pPayCheck]; PlayerInfo[i][pAccount] += checks; interest = (PlayerInfo[i][pAccount]/1000)*(tmpintrate); new finalinterest,stringore[128]; new Float:timee,Float:timee2; SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------"); SendClientMessage(i, COLOR_WHITE, "Your paycheck has arrived; please visit the bank to withdraw your money."); PlayerInfo[i][pConnectTime] += PlayerInfo[i][pPayDay] / 3600.0; timee = PlayerInfo[i][pPayDay] / 3600.0; timee2 = PlayerInfo[i][pPayDay] / 60.0; finalinterest = interest; if(PlayerInfo[i][pPayDay] > 1801) { PlayerInfo[i][pGiftTime] += 40; Update(i, pGiftTimex); SS(i,COLOR_LIGHTBLUE, "Ai primit 40 gift points pentru ca ai jucat 1801 secunde.","You recieved 40 gift points because you played 1801 seconds."); } else { PlayerInfo[i][pGiftTime] += 20; Update(i, pGiftTimex); SS(i,COLOR_LIGHTBLUE, "Ai primit 20 gift points pentru ca nu ai jucat 1801 secunde.","You recieved 20 gift points because you not played 1801 seconds."); } if(PlayerInfo[i][pMember] != 0) { PlayerInfo[i][pPaydayON]++; Update(i, pPaydayONx); } if(PlayerInfo[i][pLeader] > 0) { GivePlayerCash(i, 50000); format(string, sizeof(string), "Ai primit salariul de leader ($50000)."); format(stringore, sizeof(stringore), "You recieved the leader salary ($50000)."); SS(i, COLOR_LIGHTBLUE, string, stringore); } if(PlayerInfo[i][pHelper] > 0) { GivePlayerCash(i, 50000); format(string, sizeof(string), "Ai primit salariul de helper ($50000)."); format(stringore, sizeof(stringore), "You recieved the helper salary ($50000)."); SS(i, COLOR_LIGHTBLUE, string, stringore); } Update(i, pCashx); PlayerInfo[i][pPayDay] = 0; hourscount++; if(PlayerInfo[i][pLanguage] == 1) { format(stringore, sizeof(stringore), "You received %.2f hours played (%d minutes).",timee,floatround(timee2)); } else { format(stringore, sizeof(stringore), "Ai primit %.2f ore jucate (%d minute).",timee,floatround(timee2)); } SendClientMessage(i, COLOR_WHITE, stringore); if(PlayerInfo[i][pRob] < 20) { PlayerInfo[i][pRob]++; Update(i, pRob); } else { SS(i, COLOR_WHITE, "Nu ai primit niciun rob/free point pentru ca ai deja 20 rob/free points.", "No rob points for you! You have too many rob/free points. You can't store more than 20 rob/free points."); Update(i, pRob); } PlayerInfo[i][pExp] += 1; PlayerInfo[i][pAccount] += finalinterest; /*format(string, sizeof(string), "Paycheck: $%s | Bank balance: $%s | Bank interest: $%s | Tax: $%s (10 percent)", FormatNumber(checks), FormatNumber(PlayerInfo[i][pAccount]), FormatNumber(finalinterest), FormatNumber(TaxValue)); SendClientMessage(i, COLOR_GREY, string); format(string3, sizeof(string3), "Rent: $%s | Total earnings: $%d", FormatNumber(rent[i]), checks-TaxValue); SendClientMessage(i, COLOR_GREY, string3); SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------");*/ //PayDaYTD {2b87ff} format(string3, sizeof(string3), "PAYDAY:~n~Minute jucate: +%d~n~Paycheck: $%s ~n~ Bank balance: $%s ~n~ Bank interest: $%s ~n~ Tax: $%s (10 percent)~n~Rent: $%s | Total earnings: $%d",PlayerInfo[i][pPayDay]/60+1, FormatNumber(checks), FormatNumber(PlayerInfo[i][pAccount]), FormatNumber(finalinterest), FormatNumber(TaxValue), FormatNumber(rent[i]), checks-TaxValue); PlayerTextDrawSetString(i, PayDayTD, string3); PlayerTextDrawShow(i, PayDayTD); format(string, sizeof(string), "~y~payday"); GameTextForPlayer(i, string, 5000, 1); format(string, sizeof(string), "~g~payday"); GameTextForPlayer(i, string, 5000, 1); if(PlayerInfo[i][pRollPoints] < 100) PlayerInfo[i][pRollPoints] +=20, Update(i, pRollPointsx); format(string, sizeof(string), "Roll Points: %d/100", PlayerInfo[i][pRollPoints]); SCM(i, COLOR_LIGHTGREEN3, string); if(PlayerInfo[i][pCarLicT] > 0) { PlayerInfo[i][pCarLicT] -= 1; if(PlayerInfo[i][pCarLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de condus a expirat, poti merge la DMV pentru a obtine alta.","* Your driving licence was expired, you can go to the DMV to get another."); } if(PlayerInfo[i][pFlyLicT] > 0) { PlayerInfo[i][pFlyLicT] -= 1; if(PlayerInfo[i][pFlyLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de zburat a expirat, poti obtine alta contactand un instructor [/instructors].","* Your flying licence was expired, you can get antoher contacting a instructor [/instructors]."); } if(PlayerInfo[i][pBoatLicT] > 0) { PlayerInfo[i][pBoatLicT] -= 1; if(PlayerInfo[i][pBoatLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de barci a expirat, poti obtine alta contactand un instructor [/instructors].","* Your boat licence was expired, you can get antoher contacting a instructor [/instructors]."); } if(PlayerInfo[i][pGunLicT] > 0) { PlayerInfo[i][pGunLicT] -= 1; if(PlayerInfo[i][pGunLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de arme a expirat, poti obtine alta contactand un instructor [/instructors].","* Your weapon licence was expired, you can get antoher contacting a instructor [/instructors]."); } if(PlayerInfo[i][pFpunish] > 0) { PlayerInfo[i][pFpunish]--; } if(PlayerInfo[i][pFpunish] < 0) { PlayerInfo[i][pFpunish] = 0; } if(PlayerInfo[i][pCarLicSuspend] > 0) { PlayerInfo[i][pCarLicSuspend]--; Update(i, pCarLicSuspendx); if(PlayerInfo[i][pCarLicSuspend] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de condus a fost confiscata recent, acum poti merge iar la DMV pentru a obtine alta.","* Your driving licence was confiscated recently, now you can go to the DMV to get another."); } if(PlayerInfo[i][pGunLicSuspend] > 0) { PlayerInfo[i][pGunLicSuspend]--; Update(i, pGunLicSuspendx); if(PlayerInfo[i][pGunLicSuspend] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de arme a fost confiscata recent, acum poti contacta un instructor pentru a obtine alta [/instructors].","* Your weapon licence was confiscated recently, now you can get antoher contacting a instructor [/instructors]."); } PlayerInfo[i][pPayCheck] = 0; new month, day, inserted, dx; format(str, sizeof(str), "SELECT * FROM `timeplayed` WHERE `pid`='%d'", PlayerInfo[i][pSQLID]); new Cache: xd = mysql_query(SQL, str); if(cache_get_row_count() > 0) { for(new d, js = cache_get_row_count (); d != js; ++d) { month = cache_get_field_content_int(d, "month"); day = cache_get_field_content_int(d, "day"); if(day == da && month == mo) { inserted = 1; } } } else { mysql_format(SQL, str, sizeof(str), "INSERT INTO `timeplayed` (`pid`,`time`,`month`,`day`,`year`,`unixtime`) VALUES ('%d','%d','%s%d','%s%d','%d','%d')", PlayerInfo[i][pSQLID], OnlineTimeToday[i], ((mo < 10) ? ("0") : ("")), mo, ((da < 10) ? ("0") : ("")), da, ye, gettime()); mysql_tquery(SQL, str, "", ""); dx = 1; OnlineTimeToday[i] = 0; Update(i, pOnlineTimeTodayx); } cache_delete(xd); if(dx == 0) { if(inserted == 1) { mysql_format(SQL, str, sizeof(str), "UPDATE timeplayed SET time = time+%d WHERE month = %d AND day = %d AND pid = %d", OnlineTimeToday[i], mo, da, PlayerInfo[i][pSQLID]); mysql_tquery(SQL, str, "", ""); OnlineTimeToday[i] = 0; Update(i, pOnlineTimeTodayx); } else { mysql_format(SQL, str, sizeof(str), "INSERT INTO `timeplayed` (`pid`,`time`,`month`,`day`,`year`,`unixtime`) VALUES ('%d','%d','%s%d','%s%d','%d','%d')", PlayerInfo[i][pSQLID], OnlineTimeToday[i], ((mo < 10) ? ("0") : ("")), mo, ((da < 10) ? ("0") : ("")), da, ye, gettime()); mysql_tquery(SQL, str, "", ""); OnlineTimeToday[i] = 0; Update(i, pOnlineTimeTodayx); } } UpdateProgressBar(i); } } } format(str, sizeof(str), "INSERT INTO `toph` (`ponline`,`hour`) VALUES ('%d','%s%d:00')", GetOnLinePlayers(), ((hour < 10) ? ("0") : ("")), hour); mysql_query(SQL, str); mysql_query(SQL, "DELETE FROM `toph` ORDER BY `id` ASC limit 1"); format(str, sizeof(str), "SELECT * FROM `timeonline` WHERE m = %d AND y = %d",mo,ye); new Cache: result = mysql_query(SQL, str); if(cache_get_row_count() >= 1) { mysql_format(SQL,str,sizeof(str),"UPDATE timeonline SET hoursplayed = hoursplayed+%d WHERE m = %d AND y = %d",hourscount,mo,ye); mysql_tquery(SQL,str,"",""); } cache_delete(result); SetTimer("hidePayDay", 10000, false); return 1; }
  3. Daca mi-ai da si mie o rezolvare cum as putea salva bani am incercat cu update cashx dar degeaba Pai asa am facut l-am bagat in gamemode dar degeaba
  4. Stiu acest job dupa sa-mp.com doar ca lam implementat dar bani nu mi salveaza si am pus. UpdateCash si tot la fel.. Poate nu pun bine unde trebuie ai idee ?
  5. Am vazut fix dupa ce postai problema ms foarte mult mane. Ai tot respect-ul meu ti-am lasat un pm
  6. Primesc asta acu C:\Users\SpriteTV\Desktop\GameModeRPG\gamemodes\RP-RPG.pwn(38077) : error 001: expected token: ";", but found "-identifier-" C:\Users\SpriteTV\Desktop\GameModeRPG\gamemodes\RP-RPG.pwn(38114) : error 001: expected token: ";", but found "-identifier-" Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase 2 Errors. [Finished in 20.4s] Linile is astea BizzInfo[house][bLocked] = 0; HouseInfo[house][hHel] = 0;
  7. pai nu am de unde sa stiu boss..
  8. pai asta tu trebuie sa sti ca doar tu ai construit acest sistem ... nu noi eu m-am uitat peste tot nu i-am dat de rezolvare...
  9. Eu in partial am rezolvat probleme doar ca si eu am problemele astea. clan tagul nu ramene salvat, masiniile de la clan si banii dar in baza de date sunt daca setezi bani din baza de date la clan in joc arata ca ai 0 cand iei obiectele de la quest acestea nu dispar si ramane si minimap-ul ala galben dar nu vrea sa ofere ajutor. Restu le-am rezolvat eu dar astea nu am reusit sa le rezolv.... si la ajutor nici unu nu raspunde...
  10. Username :SpriteTV Problema întâlnită:primesc niste erori de la mysql dar nu inteleg care ii treaba. Detalii despre problemă:mysql_store_result mysql_retrieve_row mysql_fetch_field_row Ce ai încercat să faci înainte să postezi?: Nu am incercat ca nu cunosc bine problema ca nu le am cu mysql-ul chiar asa de bine. Cod sursa (recomandat pastebin.com) : erori. https://pastebin.com/vGiTq4rk comenzile.https://pastebin.com/vW8sN14k Alte detalii : help plz.
  11. pai singura functie pe care o am este asta public ClanUpdate(clanid, type) { new var[356]; switch(type) { case ClanSafex: { mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid); mysql_tquery(SQL,var,"",""); } } return 1; } Folosesc gm-ul bluffs v2 alui ionut. dar nu inteleg care ii treaba. Gen cat servar-ul ruleaza ok fara restar bani se incarc in in dialog si in baza de date. Dupa restart pe dialog nu mai apar bani. ma duc dau la un job ceva si bani care se iau din job se reseteaza in baza de date gen eu iau 300$ si in baza de date se pune 300$ dar ti-am spus dupa restart la fel face.
  12. rezolvat ms bro. erea de o functie facuta de mine aiurea poate imi poti oferi rezolvarea la clan seif ca acolo chiar nu am gasit rezolvarea pwp
  13. Bun sa zic ca in partial cred ca mi-am dat seama care ar fi problema. Daca nu dau restart la server raman bani apar tot-ul bine dar daca dau restart la server imi seteaza iara 0 cand dau sa vad bani dar in baza de date apar bani nu inteleg care ar fi problema... Dar dupa ce ma duc la un job si primesc bani aia in baza de date se seteaza bani de iam primit acu. dar eu am functia asta creata dar degeba. public ClanUpdate(clanid, type) { new var[356]; switch(type) { case ClanSafex: { mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid); mysql_tquery(SQL,var,"",""); } } return 1; }
  14. am doar mysql_tquery(SQL, "SELECT * FROM `clans`", "LoadClanInfo", ""); la LoadSystems
  15. le am puse bossule.. si la clan nu inteleg care ii problema..
  16. Username:SpriteTV Problema întălnită: primesc foarte multe erori in mysql_log dar nu inteleg dc si nu stiu de la ce ar putea fi erorile. Detalii despre problemă:https://pastebin.com/XtnUdvmG Ce ai încercat să faci înainte să postezi?: Am incercat sa modific loadfactions si load clan dar nu am rezolvat nimic. Cod sursă (recomandat pastebin.com) : Load functions si clan https://pastebin.com/8umU5XPF si erorile + https://pastebin.com/XtnUdvmG Alte detalii:Helpp myy pls.
  17. Bun sa zic ca in partial cred ca mi-am dat seama care ar fi problema. Daca nu dau restart la server raman bani apar tot-ul bine dar daca dau restart la server imi seteaza iara 0 cand dau sa vad bani dar in baza de date apar bani nu inteleg care ar fi problema... Dar dupa ce ma duc la un job si primesc bani aia in baza de date se seteaza bani de iam primit acu. public LoadClanInfo() { clanss = cache_num_rows(); for(new i = 1; i <= clanss; i++) { new x = i - 1; ClanInfo[i][cClanID] = cache_get_field_content_int(x, "clanID"); ClanInfo[i][cClanExpire] = cache_get_field_content_int(x, "clanExpire"); ClanInfo[i][cClanActive] = cache_get_field_content_int(x, "clanActive"); ClanInfo[i][cClanSlots] = cache_get_field_content_int(x, "clanSlots"); ClanInfo[i][cClanSeif] = cache_get_field_content_int(x, "clanSeif"); cache_get_field_content(x, "clanName", ClanInfo[i][cClanName], SQL, 130); cache_get_field_content(x, "clanColor", ClanInfo[i][cClanColor], SQL, 130); cache_get_field_content(x, "clanMOTD", ClanInfo[i][cClanMOTD], SQL, 130); cache_get_field_content(x, "clanTag", ClanInfo[i][cClanTag], SQL, 130); cache_get_field_content(x, "clanRankName7", ClanInfo[i][cClanRankName7], SQL, 130); cache_get_field_content(x, "clanRankName6", ClanInfo[i][cClanRankName6], SQL, 130); cache_get_field_content(x, "clanRankName5", ClanInfo[i][cClanRankName5], SQL, 130); cache_get_field_content(x, "clanRankName4", ClanInfo[i][cClanRankName4], SQL, 130); cache_get_field_content(x, "clanRankName3", ClanInfo[i][cClanRankName3], SQL, 130); cache_get_field_content(x, "clanRankName2", ClanInfo[i][cClanRankName2], SQL, 130); cache_get_field_content(x, "clanRankName1", ClanInfo[i][cClanRankName1], SQL, 130); LoadClanCar(i); } printf("[LOADING] %d clans loaded.", clanss); } public ClanUpdate(clanid, type) { new var[356]; switch(type) { case ClanSafex: { mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid); mysql_tquery(SQL,var,"",""); } } return 1; } case pClanDepx: { mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ClanDep`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pClanDep], PlayerInfo[playerid][pNormalName]); mysql_tquery(SQL,var,"",""); }
  18. Hmm pareza totala deja mai bagat in ceata...
  19. Salut am si eu o problema cu clan seif . Problema sta in felu urmator. Bani din cate vad mi urca in baza de date. Dar cand dau sa vad in joc bani clanului imi zice ca sunt 0. Si nu vad nimic gresit aici. case 4: { new strings[512],string2[256]; format(strings,sizeof(strings),"{FFFFFF}For deposit money in clan safe is necessary to work at server's jobs.\n{FFFFFF}10 percent of the money you earn will be deposited in clan safe.\n"); format(string2,sizeof(string2),"{FFFFFF}You don't loose money, the money added in clan safe are the server's money.\n{FFFFFF}Current balance: %s$.\n{FF0000}Nobody can take money from the safe box.",FormatNumber(ClanInfo[PlayerInfo[playerid][pClan]][cClanSeif])); strcat(strings, string2); ShowPlayerDialog(playerid, DIALOG_CLAN_SAFE, DIALOG_STYLE_MSGBOX, "Clan Safe Box",strings, "Ok", "Back"); }
  20. Salut ionut foarte frumos edit. Dar am si eu o problema si nu stiu sa o rezolv daca ma`i putea ajuta ti-s ramane dator toata viata. 1 CLAN-TAG-UL BANI DIN SAFEBOX SI MASINILE NU RAMAN SALVATE DUPA IESIREA DUPA SERVER mysql_log Logging started at 05:34, 16.08.2018 In callback "LoadDynamicFactions" Time Function Status Message 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin0") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin1") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin2") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin3") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin4") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin5") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin6") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin7") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin8") 05:34:54 cache_get_field_content_int ERROR invalid datatype 05:34:54 CMySQLResult::GetRowDataByName WARNING field not found ("Skin9") 05:34:54 cache_get_field_content_int ERROR invalid datatype Load LoadDynamicFactions public LoadDynamicFactions() { factionss = cache_num_rows(); new string[310]; for(new i = 1; i <= factionss; i++) { new f = i - 1; DynamicFactions[i][fID] = cache_get_field_content_int(f, "ID"); cache_get_field_content(f, "Name", DynamicFactions[i][fName], SQL, 130); DynamicFactions[i][fcX] = cache_get_field_content_float(f, "X"); DynamicFactions[i][fcY] = cache_get_field_content_float(f, "Y"); DynamicFactions[i][fcZ] = cache_get_field_content_float(f, "Z"); DynamicFactions[i][fceX] = cache_get_field_content_float(f, "eX"); DynamicFactions[i][fceY] = cache_get_field_content_float(f, "eY"); DynamicFactions[i][fceZ] = cache_get_field_content_float(f, "eZ"); DynamicFactions[i][fSafePos][0] = cache_get_field_content_float(f, "SafePos1"); DynamicFactions[i][fSafePos][1] = cache_get_field_content_float(f, "SafePos2"); DynamicFactions[i][fSafePos][2] = cache_get_field_content_float(f, "SafePos3"); DynamicFactions[i][fMats] = cache_get_field_content_int(f, "Mats"); DynamicFactions[i][fInterior] = cache_get_field_content_int(f, "Interior"); DynamicFactions[i][fVirtual] = cache_get_field_content_int(f, "Virtual"); DynamicFactions[i][fMapIcon] = cache_get_field_content_int(f, "MapIcon"); DynamicFactions[i][fLocked] = cache_get_field_content_int(f, "Locked"); DynamicFactions[i][fDrugs] = cache_get_field_content_int(f, "Drugs"); DynamicFactions[i][fBank] = cache_get_field_content_int(f, "Bank"); DynamicFactions[i][fPickupIDD] = cache_get_field_content_int(f, "PickupID"); cache_get_field_content(f, "Anunt", DynamicFactions[i][fAnn], SQL, 130); DynamicFactions[i][fWin] = cache_get_field_content_int(f, "Win"); DynamicFactions[i][fLost] = cache_get_field_content_int(f, "Lost"); DynamicFactions[i][fMaxMembers] = cache_get_field_content_int(f, "MaxMembers"); DynamicFactions[i][fMinLevel] = cache_get_field_content_int(f, "MinLevel"); DynamicFactions[i][fApplication] = cache_get_field_content_int(f, "Application"); cache_get_field_content(f, "Rank1", DynamicFactions[i][fRankName1], SQL, 130); cache_get_field_content(f, "Rank2", DynamicFactions[i][fRankName2], SQL, 130); cache_get_field_content(f, "Rank3", DynamicFactions[i][fRankName3], SQL, 130); cache_get_field_content(f, "Rank4", DynamicFactions[i][fRankName4], SQL, 130); cache_get_field_content(f, "Rank5", DynamicFactions[i][fRankName5], SQL, 130); cache_get_field_content(f, "Rank6", DynamicFactions[i][fRankName6], SQL, 130); cache_get_field_content(f, "Rank7", DynamicFactions[i][fRankName7], SQL, 130); for(new c; c < 10; c++) { new s[10]; format(s, sizeof(s),"Skin%d",c); FactionSkin[i][c] = cache_get_field_content_int(f, s); } switch(DynamicFactions[i][fLocked]) { case 0: format(string, sizeof(string), "%s's HQ", DynamicFactions[i][fName]); case 1: format(string, sizeof(string), "%s's HQ\n\n(locked)", DynamicFactions[i][fName]); } DynamicFactions[i][fPickupID] = CreateDynamicPickup(DynamicFactions[i][fPickupIDD], 23, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 0, -1, -1, 10); DynamicFactions[i][fLabelID] = CreateDynamic3DTextLabel(string, COLOR_COOLBLUE, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25.0); if(DynamicFactions[i][fMapIcon] != 0) CreateDynamicMapIcon(DynamicFactions[i][fceX],DynamicFactions[i][fceY],DynamicFactions[i][fceZ],DynamicFactions[i][fMapIcon],0,-1,-1,-1,750.0); //Bank format(string, sizeof(string), "%s\nGroup Safe", DynamicFactions[i][fName]); DynamicFactions[i][fSafePickupID] = CreateDynamicPickup(1274, 23, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 50); DynamicFactions[i][fSafeLabelID] = CreateDynamic3DTextLabel(string, COLOR_YELLOW, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 20.0); } printf("[LOADING] %d groups loaded.", factionss); return 1; }
  21. Iar cand uplodez baza de la comanda cu bizurile din baza original primesc urmatoarea eroare la incarcare SQL query: -- -- Dumping data for table `bizz` -- INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`, `Prices`) VALUES (1, 1, 'LegendSK', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 40000000, 500, 3702000, 0, 1, 0, 0, 0), (2, 1, 'MIRCESCU', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 40000000, 2500, 127500, 0, 2, 0, 7, 0), (3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 60000000, 500, 0, 0, 3, 0, 17, 0), (4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 1000, 0, 14, 0, 9, 0), (5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 40000000, 500, 0, 0, 3, 0, 2, 0), (6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 50000000, 500, [...] MySQL said: Documentation #1136 - Column count doesn't match value count at row 1
  22. Revin cu problema legata de /createbiz @Banditul problema este in felu urmator pub baza de date biz originala a sv nu mai merge comanda pun baza lui de date originala merge comanda. Baza de date + Originala a sv -- -- Table structure for table `bizz` -- CREATE TABLE `bizz` ( `ID` int(11) NOT NULL, `Owned` int(2) NOT NULL, `Owner` varchar(25) NOT NULL DEFAULT 'The State', `Message` varchar(50) NOT NULL, `EntranceX` float NOT NULL, `EntranceY` float NOT NULL, `EntranceZ` float NOT NULL, `ExitX` float NOT NULL, `ExitY` float NOT NULL, `ExitZ` float NOT NULL, `LevelNeeded` int(11) NOT NULL DEFAULT '15', `BuyPrice` int(11) NOT NULL DEFAULT '40000000', `EntranceCost` int(11) NOT NULL DEFAULT '5', `Till` int(11) NOT NULL, `Sbiz` int(2) NOT NULL, `Type` int(3) NOT NULL, `Locked` int(11) NOT NULL, `Interior` int(11) NOT NULL, `Virtual` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `bizz` -- INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`) VALUES (1, 1, 'LegendSK', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 40000000, 500, 3702000, 0, 1, 0, 0, 0), (2, 1, 'MIRCESCU', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 40000000, 2500, 127500, 0, 2, 0, 7, 0), (3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 60000000, 500, 0, 0, 3, 0, 17, 0), (4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 1000, 0, 14, 0, 9, 0), (5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 40000000, 500, 0, 0, 3, 0, 2, 0), (6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 50000000, 500, 0, 0, 3, 0, 1, 0), (7, 0, 'The State', 'Sex Shop', 1087.63, -923.003, 43.3906, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 500, 0, 4, 0, 3, 0), (8, 1, 'BoyManN_', 'Casino LV', 2019.6, 1007.68, 10.8203, 2015.45, 1017.09, 996.875, 15, 40000000, 500, 1000, 0, 5, 0, 10, 1), (9, 0, 'The State', 'GunShop LS', 1791.71, -1163.6, 23.8281, 316, -142, 1000, 15, 40000000, 500, 9400, 0, 2, 0, 7, 1), (10, 0, 'The State', '24/7', 1352.16, -1759.17, 13.5078, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 9550, 0, 6, 0, 18, 0), (11, 0, 'The State', '24/7', 999.932, -919.889, 42.3281, -31.0246, -91.3283, 1003.55, 15, 57000000, 500, 500, 0, 6, 0, 18, 1), (12, 0, 'The State', '24/7', 1833.14, -1842.5, 13.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 53450, 0, 6, 0, 18, 2), (13, 0, 'The State', '24/7', 1929.37, -1776.14, 13.5469, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 0, 0, 6, 0, 18, 3), (14, 0, 'The State', '24/7', 1315.7, -898.097, 39.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 8650, 0, 6, 0, 18, 4), (15, 0, 'The State', 'Burger Shot', 1199.38, -919.098, 43.1152, 363.134, -74.8469, 1001.51, 15, 45000000, 500, 800, 0, 7, 0, 10, 0), (16, 0, 'The State', 'Burger Shot', 810.737, -1616.19, 13.5469, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 500, 0, 7, 0, 10, 1), (17, 0, 'The State', 'Burger Shot', 2472.79, 2034.26, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 2), (18, 0, 'The State', 'Burger Shot', 1158.14, 2072.27, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 3), (19, 0, 'The State', 'Burger Shot', 2170.06, 2795.64, 10.8203, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 4), (20, 0, 'The State', 'Burger Shot', 1872.71, 2071.67, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 5), (21, 0, 'The State', 'Banca LV', 2194.99, 1676.89, 12.3672, 2306, -16, 27, 15, 40000000, 500, 0, 0, 1, 0, 0, 1), (22, 0, 'The State', 'GunShop LV', 2556.62, 2063.98, 11.0995, 316, -142, 1000, 15, 40000000, 500, 0, 0, 2, 0, 7, 2), (23, 0, 'The State', 'Sex Shop LV', 2515.95, 2297.69, 10.8203, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 0, 0, 4, 0, 3, 1), (24, 0, 'The State', '24/7', 2637.61, 1129.28, 11.1797, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 500, 0, 6, 0, 18, 5), (25, 0, 'The State', 'Gym LS', 2229.22, -1721.89, 13.5671, 772.112, -3.89865, 1000.73, 15, 40600000, 500, 0, 0, 8, 0, 5, 0), (26, 0, 'The State', 'Pizza', 2104.57, -1806.67, 13.5547, 372.54, -133.009, 1001.49, 15, 45000000, 500, 0, 0, 9, 0, 5, 6), (27, 0, 'The State', 'Banca LS', 1102.91, -1440.13, 15.7969, 2306, -16, 27, 15, 55000000, 500, 1000, 0, 1, 0, 0, 2), (28, 0, 'The State', 'Tasteaza [/ad] LvL 5', 1168.43, -1489.36, 22.757, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 1, 0, 0), (29, 0, 'The State', 'Binco', 2102.56, 2257.37, 11.0234, 207.738, -109.02, 1005.13, 15, 45000000, 500, 2500, 0, 11, 0, 15, 2), (30, 0, 'The State', 'Zip', 499.936, -1359.74, 16.2911, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 120000, 0, 11, 0, 18, 0), (31, 0, 'The State', 'Rent Car', 563.145, -1289.79, 17.2482, 0, 0, 0, 15, 40000000, 500, 1400, 1, 10, 1, 0, 0), (32, 0, 'The State', 'Zip', 1456.98, -1138.04, 23.9778, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 1000, 0, 11, 0, 18, 1), (33, 0, 'The State', 'Gas Station', 1941.6, -1764.74, 13.6406, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0), (34, 0, 'The State', 'PNS', 723.409, -463.627, 16.3359, 0, 0, 0, 15, 57000000, 500, 0, 1, 13, 1, 0, 0), (35, 0, 'The State', 'PNS', 2072.57, -1828.03, 13.5469, 0, 0, 0, 15, 50000000, 500, 1500, 1, 13, 1, 0, 0), (36, 1, 'Fiv3$eveN.)', 'PNS', 1034.7, -1028.1, 32.1016, 0, 0, 0, 15, 40000000, 500, 9000, 1, 13, 1, 0, 0), (37, 1, 'SpriteTv', 'PNS', 485.37, -1733.32, 11.094, 0, 0, 0, 15, 40000000, 500, 6500, 1, 13, 1, 0, 0), (38, 0, 'The State', 'Mod Shop', 1037.11, -1025.04, 32.1016, 0, 0, 0, 15, 68000000, 500, 3500, 1, 16, 1, 0, 0), (39, 0, 'The State', 'Mod Shop', 2650.33, -2021.76, 14.1766, 0, 0, 0, 15, 40000000, 500, 0, 1, 16, 1, 0, 0), (40, 0, 'The State', 'PNS', 1966.45, 2156.36, 10.8203, 0, 0, 0, 15, 40000000, 500, 1000, 1, 13, 1, 0, 0), (41, 0, 'The State', 'PNS', -94.1097, 1109.86, 19.7422, 0, 0, 0, 15, 40000000, 500, 0, 1, 13, 1, 0, 0), (42, 0, 'The State', 'Gas Station', 1012.9, -935.545, 42.1797, 0, 0, 0, 15, 40000000, 500, 2300, 1, 12, 1, 0, 0), (43, 0, 'The State', 'Gas Station', 701.554, -567.347, 16.1459, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0), (44, 0, 'The State', 'Gas Station', -78.6301, -1169.16, 2.1491, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0), (45, 0, 'The State', 'Gas Station', 2646.33, 1101.31, 10.9609, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0), (46, 0, 'The State', 'Gas Station', 2139.81, 2753.5, 10.8203, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0), (47, 0, 'The State', 'Gas Station', 2207.51, 2482.56, 10.8203, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0), (48, 0, 'The State', 'Gas Station', 1604.09, 2204.47, 10.8203, 0, 0, 0, 15, 50000000, 500, 0, 1, 12, 1, 0, 0), (49, 0, 'The State', 'Gas Station', 2122.56, 914.539, 10.8203, 0, 0, 0, 15, 40000000, 500, 1140, 1, 12, 1, 0, 0), (50, 0, 'The State', 'Gas Station', 638.368, 1683.78, 7.1875, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0), (51, 0, 'The State', 'Mod Shop', 2392.17, 1042.01, 10.8203, 0, 0, 0, 15, 350000000, 500, 0, 1, 16, 1, 0, 0), (52, 0, 'The State', 'CNN LV', 2079.2, 2045.07, 11.0579, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 0, 0, 0), (53, 0, 'The State', 'Binco', 2244.38, -1665.16, 15.4766, 207.738, -109.02, 1005.13, 15, 40000000, 500, 11500, 0, 11, 0, 15, 1), (54, 0, 'The State', 'Cluckin Bell', 172.527, 1176.09, 14.7645, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 0, 0, 14, 0, 9, 1); -- -------------------------------------------------------- Baza de date a comenzi din gm-ul nephrite. -- phpMyAdmin SQL Dump -- version 4.8.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 15, 2018 at 01:05 AM -- Server version: 10.1.34-MariaDB -- PHP Version: 7.2.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `bazadedate` -- -- -------------------------------------------------------- -- -- Table structure for table `bizz` -- CREATE TABLE `bizz` ( `ID` int(11) NOT NULL, `Owned` int(2) NOT NULL, `Owner` varchar(25) NOT NULL DEFAULT 'The State', `Message` varchar(50) NOT NULL, `EntranceX` float NOT NULL, `EntranceY` float NOT NULL, `EntranceZ` float NOT NULL, `ExitX` float NOT NULL, `ExitY` float NOT NULL, `ExitZ` float NOT NULL, `LevelNeeded` int(11) NOT NULL DEFAULT '15', `BuyPrice` int(11) NOT NULL DEFAULT '20000000', `EntranceCost` int(11) NOT NULL DEFAULT '5', `Till` int(11) NOT NULL, `Sbiz` int(2) NOT NULL, `Type` int(3) NOT NULL, `Locked` int(11) NOT NULL, `Interior` int(11) NOT NULL, `Virtual` int(11) NOT NULL, `Prices` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `bizz` -- ALTER TABLE `bizz` ADD PRIMARY KEY (`ID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bizz` -- ALTER TABLE `bizz` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Comanda CMD:createbiz(playerid, params[]) { if(PlayerInfo[playerid][pAdmin] < 6) return 1; new type, value, level, idd = bussines+1, Float: Pos[3], query[256]; if(sscanf(params, "iii", type, value, level)) { SCM(playerid, COLOR_GREY, "Syntax: {FFFFFF}/createbiz <type> <value> <level>"); SCM(playerid, COLOR_GREY, "(1) Banca, (2) Gun Shop, (3) Club, (4) Sex Shop, (5) Casino, (6) 24/7, (7) Burger Shot, (8) Gym"); SCM(playerid, COLOR_GREY, "(9) Pizza, (11) Binco, (12) Gas Station, (13) PNS*, (14) Cluckin Bell, (15) CNN, (16) Tuning*"); return 1; } if(type == 10 || type < 1) return SCM(playerid, COLOR_GREY, "Invalid type!"); GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]); switch(type) { case 1: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2306', '-16', '27', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 2306; BizzInfo[idd][bExitY] = -16; BizzInfo[idd][bExitZ] = 27; } case 2: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '316', '-142', '1000', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 316; BizzInfo[idd][bExitY] = -142; BizzInfo[idd][bExitZ] = 1000; } case 3: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-794.942', '490.782', '1376.2', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = -794.942; BizzInfo[idd][bExitY] = 490.782; BizzInfo[idd][bExitZ] = 1376.2; } case 4: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-100.403', '-24.3921', '1000.72', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = -100.403; BizzInfo[idd][bExitY] = -24.3921; BizzInfo[idd][bExitZ] = 1000.72; } case 5: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2015.45', '1017.09', '996.875', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 2015.45; BizzInfo[idd][bExitY] = 1017.09; BizzInfo[idd][bExitZ] = 996.875; } case 6: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-31.0246', '-91.3283', '1003.55', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = -31.0246; BizzInfo[idd][bExitY] = -91.3283; BizzInfo[idd][bExitZ] = 1003.55; } case 7: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '363.134', '-74.8469', '1001.51', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 363.134; BizzInfo[idd][bExitY] = -74.8469; BizzInfo[idd][bExitZ] = 1001.51; } case 8: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '772.112', '-3.89865', '1000.73', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 772.112; BizzInfo[idd][bExitY] = -3.89865; BizzInfo[idd][bExitZ] = 1000.73; } case 9: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '372.54', '-133.009', '1001.49', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 372.54; BizzInfo[idd][bExitY] = -133.009; BizzInfo[idd][bExitZ] = 1001.49; } case 11: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '207.738', '-109.02', '1005.13', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 207.738; BizzInfo[idd][bExitY] = -109.02; BizzInfo[idd][bExitZ] = 1005.13; } case 12: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); //case 13: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); case 14: { format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '364.942', '-11.0787', '1001.85', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); BizzInfo[idd][bExitX] = 364.942; BizzInfo[idd][bExitY] = -11.0787; BizzInfo[idd][bExitZ] = 1001.85; } case 15: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); case 16: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type)); } mysql_tquery(SQL, query, "", ""); format(query, sizeof(query), "UPDATE `bizz` SET `Virtual`='%d' WHERE `ID`='%d'", idd, idd); mysql_tquery(SQL, query, "", ""); BizzInfo[idd][bEntranceX] = Pos[0]; BizzInfo[idd][bEntranceY] = Pos[1]; BizzInfo[idd][bEntranceZ] = Pos[2]; BizzInfo[idd][bBuyPrice] = value; BizzInfo[idd][bLevelNeeded] = level; BizzInfo[idd][bVirtual] = idd; BizzInfo[idd][bType] = type; BizzInfo[idd][bInterior] = BizInteriorID(type); if(type >= 12 && type != 14) BizzInfo[idd][bSbiz] = 1; new PropertyString[256]; DestroyDynamic3DTextLabel(BizzLabel[idd]); format(PropertyString, sizeof(PropertyString),"{023d00}%s \n{EEEEEE}Business {023d00}#%d \n{0068CF}This Business is for sale(/buybusiness) ! \n {EEEEEE}Price: {023d00}%s \n{EEEEEE}Level: {023d00}%d %s",BizzInfo[idd][bMessage],idd,FormatNumber(BizzInfo[idd][bBuyPrice]),BizzInfo[idd][bLevelNeeded]); BizzLabel[idd] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFCC,BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0); CreateDynamicPickup(1239, 1, BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ]); pickups++; bussines++; if(BizzInfo[idd][bType] == 1) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],52,0,-1,-1,-1,750.0); //Bank if(BizzInfo[idd][bType] == 2) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],18,0,-1,-1,-1,750.0); //GunShop if(BizzInfo[idd][bType] == 3) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],49,0,-1,-1,-1,750.0); //Bars if(BizzInfo[idd][bType] == 4) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],38,0,-1,-1,-1,750.0); //Sex Shop if(BizzInfo[idd][bType] == 5) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],25,0,-1,-1,-1,750.0); //Casino if(BizzInfo[idd][bType] == 6) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],17,0,-1,-1,-1,750.0); //24/7 if(BizzInfo[idd][bType] == 7) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],10,0,-1,-1,-1,750.0); //Burger Shot if(BizzInfo[idd][bType] == 8) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],54,0,-1,-1,-1,750.0); //Gym if(BizzInfo[idd][bType] == 9) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],29,0,-1,-1,-1,750.0); //Pizza if(BizzInfo[idd][bType] == 10) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],51,0,-1,-1,-1,750.0); //Rent Car if(BizzInfo[idd][bType] == 11) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],45,0,-1,-1,-1,750.0); //Clothes if(BizzInfo[idd][bType] == 12) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],27,0,-1,-1,-1,750.0); //Gas Station if(BizzInfo[idd][bType] == 13) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],63,0,-1,-1,-1,750.0); //PNS if(BizzInfo[idd][bType] == 14) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],14,0,-1,-1,-1,750.0); //Cluckin Bell new string[128]; format(string, sizeof(string), "[@@ %d @@]%f, %f, %f, [$%s, %d lvl, %d int, %d type]", idd, Pos[0], Pos[1], Pos[2], FormatNumber(value), level, BizInteriorID(type), type); SCM(playerid, COLOR_YELLOW, string); return 1; } function BizInteriorID(type) { new x; switch(type) { case 1: x = 0; case 2: x = 7; case 3: x = 1; case 4: x = 3; case 5: x = 10; case 6: x = 18; case 7: x = 10; case 8: x = 5; case 9: x = 5; case 11: x = 15; case 12..13: x = 0; case 15..16: x = 0; case 14: x = 9; } return x; } Aveti si pentru mine o rezolvare va rog
  23. rezolvata problema multumesc mult. Problema erea ca trebuia sa adaug in baza de date ceva modificari. Tnx
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.