LorDSG

Uite o eroare din server_log.txt poate te ajuta cu ceva. [03:26:25] Error in mysql_query: Duplicate entry '14' for key 1 [03:26:25] Error in mysql_query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Wrong,scuzati-ma va rog,am crezut ca este topicul facut de mine

Nu cred ca o sa-l gasesti pe net,putini oameni il au pe asta. A fost facut de cei de la echipa Star-Gaming prin 2010-2011 se numeste Star-Gaming (StarG.amx/StarG.pwn). Imi place foarte mult acest GM si as vrea sa rezolv acele chestii din cauza carora mi se opreste.

1. Da,am GM-ul pe MySql si este pornit MySql 2. Cu siguranta am eroare la sintaxa si de asta mi se inchide.(asa imi apare in server_log.txt,ceva de sintaxa).Ce pot face in cazul acesta ? 3. Tabelele din baza de date sunt facute cum trebuie,am avut grija sa nu aiba vreo problema. 4. Unde ma uit ce face acel query,eu ti-am dat linia in care este,dar nu stiu sigur unde sa ma uit sa-ti spun ce face.

Daca este hostat trebuie sa ii pui si DNS.

[pawn]public MySQLUpdatePlayerFlo(query[], sqlplayerid, sqlvalname[], Float:sqlupdateflo) { new query[128]; format(query, sizeof(query), "UPDATE players SET %s=%f WHERE id=%d", sqlvalname, sqlupdateflo, sqlplayerid); samp_mysql_query(query); new flotostr[32]; format(flotostr, sizeof(flotostr), "%f", sqlupdateflo); MySQLUpdatePlayerStr(query, sqlplayerid, sqlvalname, flotostr); return 1; }[/pawn] Dar problema cred ca este la acele functii OnVehicleDeath,OnPlayerStateChange si celalalte.Te poti uita daca este totul in regula la ele ? (doar daca ai timp,rabdare si vrei)

UP !

Scuza-ma ca te intreb,dar trebuie neaparat sa pun // ID x dupa ce adaug masinile ?

E un GameMode RolePlay..

Am rezolvat cu asta,dar inca imi arata in consola la GameCP acele erori de mai sus. Serverul se opreste atunci cand ma urc in vreo masina/motoreta/elicopter care este de vanzare.

Un warning care mi-l da la compilare [pawn]C:\Documents and Settings\LorD\My Documents\StarG.pwn(2803) : warning 219: local variable "query" shadows a variable at a preceding level[/pawn] La linia 2803 am asa : [pawn]public MySQLUpdatePlayerFlo(query[], sqlplayerid, sqlvalname[], Float:sqlupdateflo) { new query[128]; format(query, sizeof(query), "UPDATE players SET %s=%f WHERE id=%d", sqlvalname, sqlupdateflo, sqlplayerid); samp_mysql_query(query); new flotostr[32]; format(flotostr, sizeof(flotostr), "%f", sqlupdateflo); MySQLUpdatePlayerStr(query, sqlplayerid, sqlvalname, flotostr); return 1; }[/pawn] [pawn]new query[128];[/pawn] asta e la 2803

Da.Dar este unul cu /buycar , /buybike , /buyheli . Spune-mi ce linii sa-ti dau (in caz ca ai nevoie)

Cum pot face sa am ID-urile fixe la masini ? Mereu cand adaug niste masini noi pe server se schimba ID-urile la mai multe si mi se incurca masinile de la factiuni,rent etc.

Asta este din server_log: Connection to MySQL database: Successfull ! [03:36:00] MYSQL: Database connection established. [03:36:00] Number of vehicle models: 124 [03:36:00] Client ID: 95CDC8E80CA9EC50DDD4E09EA9CDC05CEE4C9849 [03:36:05] Error in mysql_query: Duplicate entry '14' for key 1 [03:36:05] Error in mysql_query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Rezolvat. Multumesc mult KAPSu ( + rep)

Cum pot seta ca atunci cand intra cineva pe server sa ii dea un anumit level ? Momentan este setat sa dea level 2 la toti cei care intra,cum fac sa le dea level 1 (normal)

Up,puteti sa verificati daca se poate din cauza carei linii imi da acele erori ?

Am rezolvat,am pus de la care la care ID sa fie masina de cumparat. [pawn]public IsAnOwnableCar(vehicleid) { if(vehicleid >= 187 && vehicleid <= 335) { return 1; } return 0; }[/pawn] Multumesc oricum KAPSu. P.S: new carsonserver = xxx; nu era pe niciunde in GM

De curand am intampinat niste probleme la GM-ul meu. Cand ma urc in unele masini (fie de la factiuni fie normale) imi apare textul acela cu "/buybike/heli/car" ... si nu ma lasa sa conduc masina respectiva decat daca execut acea comanda.

Asa este,mai aveam o bariera creata,dar problema este ca aceea nu apare decat dupa ce apas click in zona. O pot face in vreun fel sa apara odata ce pornesc serverul ?

De curand am creat o bariera la PD,dar am intampinat si o mica problema. Am facut ca bariera sa se deschida atunci cand apas "CLICK". Cand merg in preajma barierei si apas pe CLICK se intampla ceva ce nu trebuie. Uitati o imagine ca sa intelegeti despre ce spun: Poza Uitati si ce am facut: [pawn]new pdbarrier;[/pawn] [pawn]pdbarrier = CreateObject(968, 1544.69995, -1630.80005, 13.3, 0, 90, 90); // PD Barrier Closed[/pawn] [pawn] if((newkeys == KEY_FIRE)&&(IsACop(playerid))&&(PlayerToPoint(15, playerid,1540.0269,-1626.8246,13.1042))) { MoveObject(pdbarrier, 1544.69995, -1630.80005, 13.3, 0, 0, 90); SetTimer("BarrierClose",5000, 0); }[/pawn] [pawn]forward BarrierClose(playerid);[/pawn] [pawn]public BarrierClose(playerid) { MoveObject(pdbarrier, 1544.69995, -1630.80005, 13.3, 0, 90, 90) return 1; }[/pawn]

Done,multumesc mult. P.S. Am spus ca nu prea le am cu scriptingul nu ca nu stiu deloc )

Nu prea le am cu scripting-ul,imi poti sugera unde mai exact sa pun asta,daca vrei desigur ?

Nu imi arata niste linii anume la care ar fi problema. In GameCP arata doar asta Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnPlayerStateChange(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 301 but accessing an element at 384 Call stack (most recent call first): public OnPlayerStateChange() Script[gamemodes/StarG.amx]: During execution of OnPlayerStateChange(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 301 but accessing an element at 383 Call stack (most recent call first): public OnPlayerStateChange() Script[gamemodes/StarG.amx]: During execution of OnPlayerStateChange(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 301 but accessing an element at 316 Call stack (most recent call first): public OnPlayerStateChange() Script[gamemodes/StarG.amx]: During execution of OnPlayerStateChange(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 301 but accessing an element at 316 Call stack (most recent call first): public OnPlayerStateChange() Script[gamemodes/StarG.amx]: During execution of OnPlayerDisconnect(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 301 but accessing an element at 316 Call stack (most recent call first): public OnPlayerDisconnect() ####### SERVICE RESTART AT 2013-06-11 22:50 BY SERVER7 ####### --- Crashdetect v3.6.8 loaded Started server on 95.64.38.162:7777, with maxplayers: 100 lanmode is ON. Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() ####### SERVICE RESTART AT 2013-06-12 00:11 BY SERVER7 ####### --- Crashdetect v3.6.8 loaded Started server on 95.64.38.162:7777, with maxplayers: 100 lanmode is ON. Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse() Script[gamemodes/StarG.amx]: During execution of OnDialogResponse(): Script[gamemodes/StarG.amx]: Run time error 4: "Array index out of bounds" Additional information: Array max index is 95 but accessing an element at 255 Call stack (most recent call first): public OnPlayerLogin() public OnDialogResponse()

Are importanta unde il adaug ? Sau il pot pune oriunde ?