+ Punker

Am rezolvat, puteti da

Nick-ul : [K]Punker. Problema : Houses/Props Poze / video : - Alte cuvinte : Dupa ce dau rr la server, toate casele si props zic ca sunt cumparate cand vrei sa le cumperi, cand ele defapt nu sunt. Acest lucru se intampla numai cand dau rr din consola .. GM ESS

Am rezolvat, puteti da

Am rezolvat cu primele 3 dar la gold am problema acuma, cand cumpar gold , nu imi baga temporar.... imi baga permanent

da , din ESS

Heii, cineva ON sa ma ajute ?

Nick-ul : [K]Punker. Problema : Nu stiu de ce nu pot cumpara de la buyvip ce trebe. Poze / video : case DIALOG_BUYVIP: { if(response) { switch(listitem) { case 0: { if(PlayerInfo[playerid][IsVipFree] == 1) return SendError(playerid, "You can buy this option only once time!"); //------------------------------------------------------ new sVip[35], AvaibleDays = 11; GQuery[0] = EOS; //------------------------------------------------------ PlayerInfo[playerid][pVIP] = 1, PlayerInfo[playerid][TVip] = 1; PlayerInfo[playerid][IsVipFree] = 0, PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400; //------------------------------------------------------ if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver"; else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold"; //------------------------------------------------------ format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]); mysql_tquery(DB_Connect, GQuery, "", ""); //------------------------------------------------------ Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~10 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4); //------------------------------------------------------ eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought VIP %s Free. (Temporary: 10 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog); } case 1: { if(PlayerInfo[playerid][Hours] < 10) return SendError(playerid, "Ai nevoie de minim 10 Ore pentru a cumpara VIP !"); if(PlayerInfo[playerid][Coins] < 5000) return SendError(playerid, "Ai nevoie de minim 5000 de Coins pentru a cumpara VIP !"); //------------------------------------------------------ new sVip[35], AvaibleDays = 21; GQuery[0] = EOS; //------------------------------------------------------ PlayerInfo[playerid][pVIP] = 1, PlayerInfo[playerid][TVip] = 1; PlayerInfo[playerid][Coins] -= 5000, PlayerInfo[playerid][Hours] -= 10; PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400; //------------------------------------------------------ if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver"; else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold"; //------------------------------------------------------ format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]); mysql_tquery(DB_Connect, GQuery, "", ""); //------------------------------------------------------ Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~20 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4); //------------------------------------------------------ eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought VIP %s. (Temporary: 20 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog); } case 2: { if(PlayerInfo[playerid][Hours] < 50) return SendError(playerid, "Ai nevoie de minim 50 de Ore pentru a cumpara VIP !"); if(PlayerInfo[playerid][Coins] < 10000) return SendError(playerid, "Ai nevoie de minim 10000 de Coins pentru a cumpara VIP !"); if(PlayerInfo[playerid][TVip] == 1) return PlayerInfo[playerid][VIPTime] = 0, PlayerInfo[playerid][TVip] = 0, PlayerInfo[playerid][pVIP] = 1; //------------------------------------------------------------ PlayerInfo[playerid][pVIP] = 1; PlayerInfo[playerid][Coins] -= 10000; PlayerInfo[playerid][Hours] -= 50; //------------------------------------------------------------ ShowPlayerDialog( playerid, DIALOG_EMPTY, DIALOG_STYLE_MSGBOX, "VIP {FF0000}Cumparat!", "{00FF00}Ai cumparat cu succes VIP Permanent!\n{00FF00}Scrie {FF0000}/VCMDS{00FF00} pentru a vedea comenzile de VIP!", "Ok", "" ); } case 3: { if(PlayerInfo[playerid][Hours] < 80) return SendError(playerid, "Ai nevoie de minim 80 ore pentru a cumpara Gold VIP !"); if(PlayerInfo[playerid][Coins] < 20000) return SendError(playerid, "Ai nevoie de minim 20000 de coins pentru a cumpara Gold VIP !"); //------------------------------------------------------ new sVip[35], AvaibleDays = 21; GQuery[0] = EOS; //------------------------------------------------------ PlayerInfo[playerid][pVIP] = 2, PlayerInfo[playerid][TVip] = 2; PlayerInfo[playerid][Coins] -= 20000, PlayerInfo[playerid][Hours] -= 80; PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400; //------------------------------------------------------ if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver"; else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold"; //------------------------------------------------------ format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]); mysql_tquery(DB_Connect, GQuery, "", ""); //------------------------------------------------------ Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~20 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4); //------------------------------------------------------ eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought Gold VIP %s. (Temporary: 20 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog); } } } return 1; } Alte cuvinte : De exemplu, nu pot lua nici free, nu pot lua temporar, iar daca am temporar, cand iau permanent nu dispare ala temporar si goldu sa nu mai zic...

nu merge cum ai zis. Daca il cumpar gold vip de la buyvip dispare toata linia cu VIP. Ajutor cineva ?...

Nick-ul : Rhaskos. Problema : VIP/GVIP Poze / video : Alte cuvinte : Am problema asta cu VIP si GVIP. Cand setez vip sau Gvip merge bine dar cand cumpar de la /buyvip dispare. Sa cumpar VIP Temp merge, iar dupa daca cumpar VIP Permanent (cand am temporar) nu dispare (Expire in.... days) de la stats. La GVIP, daca il cumpar de la buyvip imi duspare linia VIP de la stats Pozae ShowStats si /buyvip [Hidden Content]

Pai la BlackGamer cand l-a incercat i-a mers. Am vazut in topicul unde e postats Serverul .....

Nick-ul : Rhaskos. Problema : Nu mi se salveaza conturile in baza de date Poze / video : Alte cuvinte : Daca adaug coloala Bussines la "Accounts" imi da Server Unknown. Nu am cum sa adaug aia ... PLSS HELP

---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, (C)2005-2015 SA-MP Team [15:55:02] password = "" (string) [15:55:02] [15:55:02] Server Plugins [15:55:02] -------------- [15:55:02] Loading plugin: streamer.so [15:55:02] *** Streamer Plugin v2.7.5.2 by Incognito loaded *** [15:55:02] Loaded. [15:55:02] Loading plugin: mysql_static.so [15:55:02] >> plugin.mysql: R39-2 successfully loaded. [15:55:02] Loaded. [15:55:02] Loading plugin: sscanf.so [15:55:02] [15:55:02] =============================== [15:55:02] sscanf plugin loaded. [15:55:02] Version: 2.8.1 [15:55:02] (c) 2012 Alex "Y_Less" Cole [15:55:02] =============================== [15:55:02] Loaded. [15:55:02] Loaded 3 plugins. [15:55:03] [15:55:03] Filterscripts [15:55:03] --------------- [15:55:03] Loading filterscript 'UltraHost.amx'... [15:55:03] Loading filterscript 'streamermaps.amx'... [15:55:03] Loading filterscript 'PersonalCars.amx'... [15:55:03] Loading filterscript 'gangtxd.amx'... [15:55:03] - Gang Zone Editor v1.0b by Lorenc_ Loaded! [15:55:03] Loading filterscript 'TD_Editor.amx'... [15:55:03] Loading filterscript 'streamergangs.amx'... [15:55:03] Loaded 6 filterscripts. [15:55:04] 30138 - Objects. [15:55:04] MySQL: Connection to '127.0.0.1' established. [15:55:04] MySQL: Database 'port_2503' selected. [15:55:04] Number of vehicle models: 65 [15:55:04] Loaded 7 Gangs. [15:55:04] Loaded 7 Gang Teritories. [15:55:04] Loaded 7 Gang Checkpoints. [15:55:04] Loaded 97 Properties. [15:55:04] Loaded 1133 Houses. [15:56:40] [connection] 86.34.75.114:51189 requests connection cookie. [15:56:41] [connection] incoming connection: 86.34.75.114:51189 id: 0 [15:56:42] [join] Rhaskos. has joined the server (0:86.34.75.114) [15:56:50] ==================================================== [15:56:50] Error ID: 1054 Error: Unknown column 'Bussines' in 'field list' Callback: OnAccountCreated Query: INSERT INTO `Accounts` (`ID`, `Name`, `Password`, `IP`, `E-Mail`, `LoggedIn`, `RegisterDate`, `LastOn`, `Level`, `VIP`, `Cash`, `Score`, `Coins`, `Credits`, `Kills`, `Deaths`, `Hours`, `Minutes`, `Seconds`, `BestKillings`, `KillingSpree`, `FavSkin`, `UseSkin`, `House`, `Bussines`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, `Kicks`, `Bans`, `Jails`, `Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `Jailed`, `JailTime`, `Frozen`, `FreezeTime`, `Muted`, `MuteTime`, `RaceScore`, `StuntScore`, `DriftScore`, `GangID`, `GangRank`, `GangSkin`, `GangKills`, `GangDeaths`, `GangWarns`, `GangCaptures`, `GangPoints`, `Ignores`, `LottoNumber`, `C4`, `StatsNote`, `VIPTime`, `FreeVIP`, `TempVIP`, `RGSClan`, `RGSRank`, `AdmWarns`, `VIPWarns`, `KickW`) VALUES (0, 'Rhaskos.', 'mafiotu', '86.34.75.114', 'changeme', '1', '09/02/2017', '09/02/2017', '0', '15', '25000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '217', '1', '0', '0', ' ', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00:00', '0', '00:00', '0', '00:00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0/0/0/0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0') [15:56:50] ==================================================== [15:56:52] ==================================================== [15:56:52] Error ID: 1054 Error: Unknown column 'Bussines' in 'field list' Callback: Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '09/02/2017', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '15', Coins = '0', `Credits` = '0', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '0', `Seconds` = '10', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '0', `Negative` = '0', `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0', `RaceScore` = '0', `StuntScore` = '0', `DriftScore` = '0', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '0', `FreeVIP` = '1', `TempVIP` = '0', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0' [15:56:52] ==================================================== [15:56:54] [chat] [Rhaskos.]: sf [15:57:41] RCON (In-Game): Player #0 (Rhaskos.) failed login. [15:57:50] RCON (In-Game): Player #0 (Rhaskos.) has logged in. [16:02:54] [part] Rhaskos. has left the server (0:1) [16:02:54] ==================================================== [16:02:54] Error ID: 1054 Error: Unknown column 'Bussines' in 'field list' Callback: Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '09/02/2017', `Level` = '2', `VIP` = '1', `Cash` = '25000', `Score` = '15', Coins = '0', `Credits` = '1', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '6', `Seconds` = '12', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '0', `Negative` = '0', `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0', `RaceScore` = '0', `StuntScore` = '0', `DriftScore` = '0', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '1', `FreeVIP` = '1', `TempVIP` = '0', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0' [16:02:54] ==================================================== Asta imi da

Vreau ajutor sa il fac sa mearga. Stiu ca nu mai e cum era dar sa nu uitam cum a fost

Nick-ul : Rhaskos. Problema : Nu mi se salveaza conturile in baza de date Poze / video : SSR V9 server postata de anonymous Alte cuvinte : Am incercat pe un host gratuit de la ultr*****. totul a mers bine , am pus baza de date cum trebuie si nu se salveaza conturile. Nu stiu de ce. Am incercat si pe localhost si tot degeaba..