-
Posts
457 -
Joined
-
Last visited
-
Days Won
32
Content Type
Profiles
Forums
News
Documentation
Posts posted by s4uriK.Official
-
-
Logul mysql se afla in folder la server ( unde se afla si server.cfg). Se numeste mysql_log.txt. Deschide-l si pune tot din el aici.
Acuma iti dau linkul de la mysql_log de pe host
-
Arata-mi ce ai in mysql_log.
Poftim: http://pastebin.com/madKEvBJ
-
Sterge case:pLevel (cel pe care ti-am spus eu sa-l adaugi).
Dute la OnPlayerDisconnect si adauga linia asta : Update(playerid, pLevelx);
Am aceasta in gm la onplayerdisconnect
-
Sunt la servici, pune-mi un print screen cum te-am rugat.
Poftim: http://imgur.com/a/aXtdo
-
Arata-mi structura tabelului in care salvezi jucatorii in MySQL, mai specific, tabela users. ( Fa un print screen)
Poftim. Uita-te tu in ea sa vezi.
-
Adauga asta in functia Update, dupa ultimul "case".
case pLevel: { mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Level`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pNormalName]); mysql_tquery(SQL,var,"",""); }
Sa schimbi eventualele variable/numele coloanei level cu ce ai tu in GameMode/Database.
Tot nu merge. Deci mi-a eu cand imi cumpar level mi-a imi merge, dar ceilalti care intra si isi cumpara level, iar cand ies si intra din nou tot level 1 le da.
-
Ai creat gm-ul sa fim seriosi nimanui nu ii plac mincinosi.
Posteaza comanda buylevel
Nu pot rezolva aceasta problema. Multumesc de ajutor.
-
-
Arata mysql_log
Ti-am trimis PM cu el.
Puteti sa ma ajutati?
-
Schimba handle cu SQL.
Tot nu merge. Tot level 1 imi da cand intru inapoi.
-
Am adaugat dar imi da o eroare. uitati. http://imgur.com/e2ClzVu , aia cu handle.
-
La OnPlayerDisconnect.
Sa copii tot ce mi-ai dat si sa adaug la onplayerdisconnect?
-
Adauga asta
new saveQuery[1000]; format(saveQuery,1000,"UPDATE `users` SET `pLevel` = '%d' WHERE `name`='%s'",PlayerInfo[playerid][pLevel], namex); mysql_pquery(handle, saveQuery);
unde sa adaug acestea?
-
Dar nu pot rezolva acest bug. de asta si am nevoie de ajutorul tau. Te rog frumos ajuta-ma
-
Oricum acel gm a fost postat prima si prima data de mine pe www.pawn-team.ro si acuma va dati toti mare ca il aveti+ inside are dreptate, sunt mii de buguri. P.S: scuzati de reclama
-
Ce gamemode folosesti? Urca publicul OnPlayerDisconnect pe pastebin.com
Uiatati am pus: http://pastebin.com/bfhVDdW0
Folosesc gamemode bigzone cel creat de mine, dar nu pot reusi sa fac aceasta problema. Multumesc frumos pentru ajutor.
-
Cand ajung acasa voi urca. Sunt la scoala pe la 15:00 ajung acasa si urc. Multumesc frumos ca ma veti ajuta.
-
Problema intalnita (descriere): Deci, playerii primesc level, iar cand ies si intra inapoi au level 1.
Ero(area / rile) / warning-(ul / urile): Sunt mai multe chestii in gm. poate ma ajutati sau sa imi spuneti unde trebuie sa intru sa dau.
Liniile de cod / sursa / script-ul(obligatoriu): Pai in gm sunt multe chestii, multe scripturi cu level. poate stiti vreo chestie mica care trebuie facuta.
Imagini / Video (optional): -
Ati incercat sa rezolvati singur?: Am incercat dar nustiu ce sa fac -
KnowN Iti multumesc din tot sufletul esti un adevarat scripter. +1 si TC. Multumesc inca odata
-
Problema intalnita (descriere): la ora fixa nu se da paydayul. Serverul nu da paydayul si scriptul il am.
Ero(area / rile) / warning-(ul / urile): Nu-mi da paydayul la ora fixa
Liniile de cod / sursa / script-ul(obligatoriu):public SyncUp()
{
new string[128],
tmphour,
tmpminute,
tmpsecond,
hour,
minn,
sec;
gettime(hour,minn,sec);
gettime(tmphour, tmpminute, tmpsecond);
FixHour(tmphour);
tmphour = shifthour;
if ((tmphour > ghour) || (tmphour == 0 && ghour == 23))
{
format(string, sizeof(string), "SERVER: The time is now %d:00 hours",hour);
BroadCast(COLOR_WHITE,string);
ghour = tmphour;
PayDay();
if(hour == 20 || hour == 10 || hour == 22)
{
format(string, sizeof(string), "Lottery News: We have started the Lottery Election.");
OOCOff(COLOR_WHITE, string);
new rand = random(80);
if(rand < 77) { rand += 3; }
Lotto(rand);
}
if(hour == 22)
{
mysql_tquery(SQL,"UPDATE users SET FactionTime = FactionTime+1 WHERE Member > 0","","");
foreach(Player, i)
{
new escstr2[MAX_PLAYER_NAME],
result[500],
query[500];
GetPlayerName(i, escstr2, sizeof(escstr2));
format(query, sizeof(query), "SELECT `FactionTime` FROM users WHERE `name` = '%s'", escstr2);
mysql_store_result();
mysql_query(SQL,query);
if(mysql_retrieve_row())
{
mysql_fetch_field_row(result, "FactionTime"); PlayerInfo[pFactionTime] = strval( result );
}
mysql_free_result();
}
}
if(hour == 23)
{
new str[256];
for(new turf = 1; turf < sizeof(TurfInfo); turf++)
{
TurfInfo[turf][zTime] = 0;
mysql_format(SQL,str,sizeof(str),"UPDATE `turfs` SET `Time`='0' WHERE `ID`='%d'",turf);
mysql_tquery(SQL,str,"","");
}
}
if (realtime)
{
SetWorldTime(hour);
}
}
return 1;
}
Imagini / Video (optional):public PayDay()
{
new string[128],
str[256],
string3[128],
interest,
account[MAX_PLAYERS],
hour,
minn,
sec,
expamount,
rent[MAX_PLAYERS];
gettime(hour,minn,sec);
foreach(Player,i)
{
if(IsPlayerConnected(i))
{
if(PlayerInfo[pLevel] >= 0)
{
new wakaname[25];
GetPlayerName(i,wakaname,sizeof(wakaname));
if(MoneyMessage==1)
{
SendClientMessage(i, COLOR_LIGHTRED, "You failed to pay your debt, Jail time.");
new rand;
rand = random(sizeof(gRandomJailSpawns));
SetPlayerInterior(i, 6);
SetPlayerPos(i,gRandomJailSpawns[rand][0],gRandomJailSpawns[rand][1],gRandomJailSpawns[rand][2]);
PlayerInfo[pJailed] = 1;
ResetPlayerWeaponsEx(i);
ResetPlayerWeapons(i);
WantedPoints = 0;
PlayerInfo[pJailTime] = 240;
format(string, sizeof(string), "You are jailed for %d seconds. Bail: Unable", PlayerInfo[pJailTime]);
SendClientMessage(i, COLOR_LIGHTBLUE, string);
Update(i,pJailedx);
Update(i,pJailTimex);
TogglePlayerControllable(i, 0);
SetTimerEx("UnFreezeStation", 1000, false, "i", i);
}
new playername2[MAX_PLAYER_NAME];
GetPlayerName(i, playername2, sizeof(playername2));
new key = PlayerInfo[pPhousekey];
if(key != 999)
{
rent = HouseInfo[key][hRent];
if(rent > GetPlayerCash(i) && strcmp(playername2, HouseInfo[key][hOwner], false) == 0)
{
PlayerInfo[pPhousekey] = 999;
Update(i,pPhousekeyx);
}
HouseInfo[key][hTakings] += rent;
mysql_format(SQL,str,sizeof(str),"UPDATE `houses` SET `Takings`='%d' WHERE `ID`='%d'",HouseInfo[key][hTakings],key);
mysql_tquery(SQL,str,"","");
}
if(PlayerInfo[pPayDay] >= 5)
{
new tmpintrate;
if(PlayerInfo[pPremiumAccount] == 1)
{
tmpintrate = 2;
PlayerInfo[pPayDayHad] += 1;
if(PlayerInfo[pPayDayHad] >= 5)
{
PlayerInfo[pExp]++;
PlayerInfo[pPayDayHad] = 0;
SCM(i,COLOR_LIGHTBLUE,"You got 1 respect point bonus because you have premium account.");
}
new bonus = PlayerInfo[pPayCheck] / 2;
PlayerInfo[pPayCheck] += bonus;
}
else
{
tmpintrate = 1;
}
account = PlayerInfo[pAccount];
Tax += TaxValue;
PlayerInfo[pAccount] -= TaxValue;
new checks = PlayerInfo[pPayCheck],
ebill = (PlayerInfo[pLevel]*SBizzInfo[14][sbEntranceCost]/100);
PlayerInfo[pAccount] += checks;
interest = (PlayerInfo[pAccount]/1000)*(tmpintrate);
PlayerInfo[pExp] += 1;
PlayerInfo[pAccount] += interest;
SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------");
SendClientMessage(i, COLOR_WHITE, "Your paycheck has arrived; please visit the bank to withdraw your money.");
format(string, sizeof(string), "Paycheck: $%s | Bank balance: $%s | Bank interest: $%s | Tax: $%s (10 percent)", FormatNumber(checks), FormatNumber(PlayerInfo[pAccount]), FormatNumber(interest), FormatNumber(TaxValue));
SendClientMessage(i, COLOR_GREY, string);
format(string3, sizeof(string3), "Rent: $%s | Total earnings: $%d", FormatNumber(rent), checks-TaxValue);
SendClientMessage(i, COLOR_GREY, string3);
SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------");
/*if(GiftActiv > 0)
{
PlayerInfo[pGiftPoints] += 1;
SendClientMessage(i, COLOR_GREY, "Also you reward a 1 GiftPoint ");}*/
if(PlayerInfo[pAccount] >= ebill && key != 999 && strcmp(playername2, HouseInfo[key][hOwner], true) == 0)
{
PlayerInfo[pAccount] -= ebill;
SBizzInfo[14][sbTill] += ebill;
mysql_format(SQL,str,sizeof(str),"UPDATE `sbizz` SET `Till`='%d' WHERE `ID`='14'",SBizzInfo[14][sbTill]);
mysql_tquery(SQL,str,"","");
}
else
{
ebill = 0;
}
format(string, sizeof(string), "~y~payday");
GameTextForPlayer(i, string, 5000, 1);
PlayerInfo[pPayDay] = 0;
PlayerInfo[pPayCheck] = 0;
if(PlayerInfo[pCarLicT] > 0)
{
PlayerInfo[pCarLicT] -= 1;
}
if(PlayerInfo[pFlyLicT] > 0)
{
PlayerInfo[pFlyLicT] -= 1;
}
if(PlayerInfo[pBoatLicT] > 0)
{
PlayerInfo[pBoatLicT] -= 1;
}
if(PlayerInfo[pGunLicT] > 0)
{
PlayerInfo[pGunLicT] -= 1;
}
if(PlayerInfo[pRob] < 10)
{
PlayerInfo[pRob]++;
}
if(PlayerInfo[pFpunish] > 0)
{
PlayerInfo[pFpunish]--;
}
if(PlayerInfo[pSleeping] == 0)
{
PlayerInfo[pConnectTime] += 1;
}
if(IsACop(i))
{
PlayerInfo[pLawyer] += 1;
}
if(PlayerInfo[pLevel] == 1 || PlayerInfo[pLevel] == 2 || PlayerInfo[pLevel] == 3 || PlayerInfo[pLevel] == 4)
{
expamount = PlayerInfo[pLevel]*2;
if(PlayerInfo[pExp] >= expamount)
{
SCM(i,COLOR_LIGHTBLUE,"** You can use buylevel because you have necessary respect points.");
}
}
else if(PlayerInfo[pLevel] >= 5)
{
expamount = PlayerInfo[pLevel]*3;
if(PlayerInfo[pExp] >= expamount)
{
SCM(i,COLOR_LIGHTBLUE,"** You can use buylevel because you have necessary respect points.");
}
}
}
else
{
SendClientMessage(i, COLOR_LIGHTRED, "* You haven't played long enough to obtain a PayDay.");
}
}
}
}
for(new x = 0; x < MAX_GROUPS; x++)
{
DynamicFactions[x][fBank] += DynamicFactions[x][fPaydayMoney];
mysql_format(SQL,str,sizeof(str),"UPDATE `factions` SET `Bank`='%d' WHERE `ID`='%d'",DynamicFactions[x][fBank],x);
mysql_tquery(SQL,str,"","");
}
return 1;
}
Ati incercat sa rezolvati singur?: Am incercat dar nu reusesc. poate ma puteti ajuta voi. Multumesc frumos -
M-am decis sa pun gmul meu pe acest site.
****[THIS SCRIPT CONTAINS]:
- Dynamic Business System
- Family Dynamic System (Possibility of direct families of game creation liking)
- Dynamic GiftBox (Placing a gift -playerii can receive gifts from 5 to 5 hours of it)
- Fireworks System (cmd: / placefirework)
- Accessories System (possibility of buying accessories store / vip for character)
- Mapping Custom (Indoor / Outdoor)
- Radio system for cars
- Orders for custom admin
- Custom Jobs
- Creation of dynamic events
- Gates System (ability to create gates homes Player)
- Paintball System****[SERVER UPDATES]:
- Added command / window that can be used to open / close the windows of a vehicle
- Bbc radio added one (/ carradio + / bmusic + / hmusic)
- /Carradio: the number of listeners to a radio station appearing on a different column
- Command / members (which can be used by leaders) displays faction members orderly columns
- Fisherman: When a player is fishing rod in hand he appears; when a player exits the fishing animation (get in the car, hit the other players), it must use again / fish to fish
- On infernusurile police siren sounds just like normal police cars in the game****[SERVER FACTIONS]:
1.Los Santos Police Department
2.National Guard
3.Hitman Agency
4.FBI
5.News Reporters
6.Taxi LV
7.Grove Street
8.Ballas
9.The Russian Mafia
10.Los Vagos
11.Los Aztecas
12.School Instructors LV
13.Paramedic Department
14.The Rifa
15.Las Venturas Police Department
16.Taxi LS****[JOBS]:
1. Car Mechanic
2. Drug Dealer
3. Whore
4. Garbageman
5. Arms Dealer
6. Farmer
7. Trucker
8. Pizza Boy
9. DetectivePozele se gasesc in acel gamemode
Link Download Direct : http://www.fileshare.ro/e31881842Succes Cu EL
- 1
-
Salut as dori si eu acest panel daca se poate. am mare nevoie de el, va multumesc foarte frumos.
Link catre acel panel: http://sinceplay.ro/panel/ - scuzati nu fac reclama.
Va rog frumos poate ma ajutati.
Problema Level
in Arhivă probleme
Posted · Edited by s4uriK
Poftim am facut un screen cu mysql_log.html: http://imgur.com/ZfBTU2D
Poftim si server_log.txt
server_log.txt
Pe pastebin nu incape.