Jimmi

Pai si cum sa fac acest log mai exact....

up

Daca vreau sa fac si eu la comanda /mdc istoricum crimelor trebuie sa fac log mysql?Si cum mai exact.Geva de genul vreau sa fac jos http://i.imgur.com/fxpiO9T.png

Mai raspunde cineva?

Mai raspunde cineva?

Serios?Upp

up

upppp

Problema intalnita (descriere):De ce atunci cand dau pe f4 si cand mor ma da in aer adica asa mai exact:[POZA MAI JOS] Ero(area / rile) / warning-(ul / urile):- Liniile de cod / sursa / script-ul(obligatoriu):Cred ca e de vina OnPlayerRequestClass Imagini / Video (optional):http://s21.postimg.org/ayl2a2493/sa_mp_035.png Ati incercat sa rezolvati singur?:Da cautand pe google dar nu inteleg eu cand am cautat cu F4 nu am gasit codul ce trebuie eliminat public OnPlayerRequestClass(playerid, classid) { if (RegistrationStep[playerid] == 0 && gPlayerLogged[playerid] != 1) { if (gPlayerAccount[playerid] != 0) { SetPlayerTime(playerid, 24, 0); TextDrawShowForPlayer(playerid, Textdraw2); SendClientMessage(playerid, COLOR_YELLOW2, "{0066FF}Los Santos: {FFFFFF}Bine ai venit pe PG-ZONE-RPG Romania."); SendClientMessage(playerid, COLOR_YELLOW2, "{0066FF}Los Santos: {FFFFFF}Echipa PG-ZONE saluta toti cetatenii Los Santos!"); InterpolateCameraPos(playerid, 1034.645874, -1631.084472, 118.365447, 1400.550781, -929.490905, 98.797058, 40000); InterpolateCameraLookAt(playerid, 1030.184936, -1632.479980, 116.589866, 1401.127441, -924.546997, 98.322418, 40000); gPlayerAccount[playerid] = 1; TextDrawShowForPlayer(playerid, Textdraw2); new loginname[64]; GetPlayerName(playerid,loginname,sizeof(loginname)); ShowPlayerDialog(playerid,12346,DIALOG_STYLE_PASSWORD,"{FFFFFF}Logare","{FFFFFF}Scrie {0066FF}parola contului tau {FFFFFF}mai jos:","Logare","Iesi"); } else { gPlayerAccount[playerid] = 0; TextDrawShowForPlayer(playerid, Textdraw2); new regname[64]; GetPlayerName(playerid,regname,sizeof(regname)); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{FFFFFF}Inregistrare","{FFFFFF}Scrie {0066FF}parola contului tau {FFFFFF}mai jos:","Inregistrare","Iesi"); } SetPlayerFacingAngle(playerid, 3.41); SetPlayerTime(playerid, 24, 0); InterpolateCameraPos(playerid, 1034.645874, -1631.084472, 118.365447, 1400.550781, -929.490905, 98.797058, 40000); InterpolateCameraLookAt(playerid, 1030.184936, -1632.479980, 116.589866, 1401.127441, -924.546997, 98.322418, 40000); SetPlayerPos(playerid, 1437.6957,-2266.6355,13.5469); TextDrawShowForPlayer(playerid, Textdraw2); PlayerInfo[playerid][pModel] = Peds[classid][0]; } return 1; }

Problema intalnita (descriere):Am rezolvat bug-ul la ds.Acuma iti da masina in baza de date.Dar pe server tot nu apare ca e ata.In baza de date in tabelul vehicles apare ca e a ta dar in players car1 nu si nici la /stats.La fel si cand ma urc in ea nu apare ca e a mea... Ero(area / rile) / warning-(ul / urile):- Liniile de cod / sursa / script-ul(obligatoriu): Imagini / Video (optional):- Ati incercat sa rezolvati singur?:Da, puteti verifica if(dialogid == 180 && PlayerInfo[playerid][pCar1] == 999) { PlayerInfo[playerid][pCar1] = idd; format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerInfo[playerid][pCar1], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat un vehicul! Valoare: %d | slot #1]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 181) { PlayerInfo[playerid][pCar2] = idd; format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat o motocicleta! Valoare: %d | slot #2]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 182) { PlayerInfo[playerid][pCar3] = idd; format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat o barca! Valoare: %d | slot #3]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 183) { PlayerInfo[playerid][pCar3] = idd; format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat un avion/elicopter! Valoare: %d | slot #3]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; }

Tc, multumes

Problema intalnita (descriere):Am facut un sistem de monitorizare staff.Am facut comanda /showstaffactvity si ca sa le resetez activitatea /resetstaffactivity dar /resetstaffactivity nu merge... Ero(area / rile) / warning-(ul / urile): [13:21:18] CMySQLHandler::Query(DELETE * FROM `logExecCmds` WHERE `Player` = 'Jimmi') - An error has occured. (Error ID: 1064, 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 '* FROM `logExecCmds` WHERE `Player` = 'Jimmi'' at line 1) [13:21:18] >> mysql_store_result( Connection handle: 1 ) [13:21:18] CMySQLHandler::StoreResult() - No data to store. [13:21:18] OnQueryError() - Called. [13:21:22] >> mysql_query( Connection handle: 1 ) Liniile de cod / sursa / script-ul(obligatoriu): Imagini / Video (optional): Ati incercat sa rezolvati singur?:Da CMD:resetstaffactivity(playerid, params[]) { if(IsPlayerConnected(playerid)) { new jucator,numejucator[32],query[128]; if(sscanf(params, "u", jucator)) return SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /resetstaffactivity [PlayerID/PartOfName]"); GetPlayerName(jucator, numejucator, sizeof(numejucator)); format(query, sizeof(query), "DELETE * FROM `logExecCmds` WHERE `Player` = '%s'", numejucator); mysql_query(query); mysql_store_result(); } return 1; }

Rezolvat.Multumesc

Nup.Daca imi dau helper si am si admin merge dar daca scot helperul nu mai merge.La fel si admin.Daca imi scot adminul si raman helper nu ami merge

Problema intalnita (descriere):Am trecut comanda /unfreeze pe zcmd+sccanf dar acuma cand ma duc in joc imi zice ca nu sunt admin chiar daca am admin maxim... Ero(area / rile) / warning-(ul / urile):Nu am... Liniile de cod / sursa / script-ul(obligatoriu): Imagini / Video (optional):- Ati incercat sa rezolvati singur?:Da CMD:unfreeze(playerid, params[]) { new playa; new sendername[MAX_PLAYER_NAME], string[256],giveplayername[MAX_PLAYER_NAME]; if(PlayerInfo[playerid][pAdmin] < 1 || PlayerInfo[playerid][pTrial] < 1) SendClientMessage(playerid, COLOR_GRAD1, "** Nu ai rangul administrativ necesar!"); else if(sscanf(params, "u", playa)) SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /unfreeze [playerid / part of name]"); else { if(playa != INVALID_PLAYER_ID && IsPlayerConnected(playa)) { GetPlayerName(playa, giveplayername, sizeof(giveplayername)); GetPlayerName(playerid, sendername, sizeof(sendername)); TogglePlayerControllable(playa, 1); format(string, sizeof(string), "{0066FF}[Info:] {FFFFFF}%s i-a dat unfreeze lui %s",sendername, giveplayername); IsFreezed[playa] = 0; format(string, sizeof(string), "{0066FF}[Info:] {FFFFFF}%s a primit unfreeze de la %s",playerid ,sendername); ABroadCast(COLOR_LIGHTRED,string,1); ExecCMD[playerid]++; } } SaveExecCMDS(playerid, "/unfreeze", ExecCMD[playerid]); return 1; }

Ma refer nu apare proprietarul AddStaticVehicle(vInfo[idd][vCariD],vInfo[idd][vPosX],vInfo[idd][vPosY],vInfo[idd][vPosZ],0,0,0);

Pai in baza de date imi arata ca imi da vehicull.

Se apind singure cand se face noapte.Diferenta dintre celalalte masini si astea e ca Matite a adagat girofarele alea in schimb la LSPD Car sunt adaugate din GTA

Se aprind automat cand se face negura.Asa sunt facute ele nu le poti modifica

Problema intalnita (descriere):Am facut un ds.Imi dadea multe erori la parametri dar le-am rezolvat.Ma duc in joc cumpar o masina/avion dar nu imi da masina... Ero(area / rile) / warning-(ul / urile):- Liniile de cod / sursa / script-ul(obligatoriu): if(GetPlayerCash(playerid) > VehDSpret[playerid]) { new CheckStock[128]; new result; new numarStoc; format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='%i'", VehDSmod[playerid]); result = mysql_query(CheckStock); mysql_store_result(); numarStoc = mysql_fetch_int(result); mysql_free_result(); if(numarStoc >= 1) { numarStoc--; format(CheckStock,sizeof(CheckStock),"UPDATE stocds SET stoc='%i' WHERE modelid='%i'", numarStoc, VehDSmod[playerid]); mysql_query(CheckStock); numarStoc = 0; new idd; mysql_query("SELECT * FROM `vehicles`"); mysql_store_result(); idd = mysql_num_rows()+1; mysql_free_result(); format(string, sizeof(string), "%s",ArIsim[VehDSmod[playerid]-400]); strmid(vInfo[idd][vOwner], sendername, 0, strlen(sendername), 999); new rand; rand = random(sizeof(VehicleSpawns)); new rand1; new rand2; rand1 = random(sizeof(FlySpawns)); rand2 = random(sizeof(BoatSpawns)); if(dialogid == 180) { vInfo[idd][vCariD] = VehDSmod[playerid]; vInfo[idd][vPrice] = VehDSpret[playerid]; vInfo[idd][vPosX] = VehicleSpawns[rand][0]; vInfo[idd][vPosY] = VehicleSpawns[rand][1]; vInfo[idd][vPosZ] = VehicleSpawns[rand][2]; } if(dialogid == 181) { vInfo[idd][vCariD] = VehDSmod[playerid]; vInfo[idd][vPrice] = VehDSpret[playerid]; vInfo[idd][vPosX] = VehicleSpawns[rand][0]; vInfo[idd][vPosY] = VehicleSpawns[rand][1]; vInfo[idd][vPosZ] = VehicleSpawns[rand][2]; } if(dialogid == 182) { vInfo[idd][vCariD] = VehDSmod[playerid]; vInfo[idd][vPrice] = VehDSpret[playerid]; vInfo[idd][vPosX] = BoatSpawns[rand2][0]; vInfo[idd][vPosY] = BoatSpawns[rand2][1]; vInfo[idd][vPosZ] = BoatSpawns[rand2][2]; } if(dialogid == 183) { vInfo[idd][vCariD] = VehDSmod[playerid]; vInfo[idd][vPrice] = VehDSpret[playerid]; vInfo[idd][vPosX] = FlySpawns[rand1][0]; vInfo[idd][vPosY] = FlySpawns[rand1][1]; vInfo[idd][vPosZ] = FlySpawns[rand1][2]; } vInfo[idd][vOwner] = 1; vInfo[idd][vVechime] = 0; AddStaticVehicle(vInfo[idd][vCariD],vInfo[idd][vPosX],vInfo[idd][vPosY],vInfo[idd][vPosZ],0,0,0); format(string, sizeof(string),"INSERT INTO vehicles (CarID, Model) VALUES (%d, %d)", idd, vInfo[idd][vCariD]); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vPosX='%f' WHERE CarID=%d", vInfo[idd][vPosX], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vPosY='%f' WHERE CarID=%d", vInfo[idd][vPosY], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vPosZ='%f' WHERE CarID=%d", vInfo[idd][vPosZ], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vPosA='%f' WHERE CarID=%d", vInfo[idd][vPosA], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Color1='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Color2='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Price ='%d' WHERE CarID=%d", vInfo[idd][vPrice], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Towed='0' WHERE CarID=%d", vInfo[idd][vTowed], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Owner='%s' WHERE CarID=%d", vInfo[idd][vOwner], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Plate='%s' WHERE CarID=%d", vInfo[idd][vPlate], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Locked='0' WHERE CarID=%d", vInfo[idd][vLocked], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Vechime='0' WHERE CarID=%d", vInfo[idd][vVechime], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET PlateModel='0' WHERE CarID=%d", vInfo[idd][vPlateMod], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET Registred='0' WHERE CarID=%d", vInfo[idd][vReg], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET PaintJ='0' WHERE CarID=%d", vInfo[idd][vPaintJ], idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod1='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod2='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod3='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod4='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod5='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod6='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod7='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod8='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod9='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod10='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod11='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod12='0' WHERE CarID=%d", idd); mysql_query(string); format(string, sizeof(string), "UPDATE vehicles SET vMod13='0' WHERE CarID=%d", idd); mysql_query(string); if(dialogid == 180 && PlayerInfo[playerid][pCar1] == 999) { PlayerInfo[playerid][pCar1] = idd; format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerInfo[playerid][pCar1], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat un vehicul! Valoare: %d | slot #1]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 181) { PlayerInfo[playerid][pCar2] = idd; format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat o motocicleta! Valoare: %d | slot #2]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 182) { PlayerInfo[playerid][pCar3] = idd; format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat o barca! Valoare: %d | slot #3]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } else if(dialogid == 183) { PlayerInfo[playerid][pCar3] = idd; format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]); mysql_query(string); GivePlayerMoneyEx(playerid, - VehDSpret[playerid]); new string1[128]; format(string1, sizeof(string1), "Felicitari! Ai achizitionat un avion/elicopter! Valoare: %d | slot #3]!", vInfo[idd][vPrice]); SendClientMessage(playerid, -1, string1); SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!"); return 1; } } else return SendClientMessage(playerid,COLOR_WHITE,"Aceasta masina nu mai este in stoc."); } else { SendClientMessage(playerid, -1, "Nu ai suficienti bani."); return 1; } } Imagini / Video (optional):[17:16:22] CMySQLHandler::Query(UPDATE vehicles SET Owner='nbought' WHERE CarID=1) - Successfully executed. [17:16:22] >> mysql_query( Connection handle: 1 ) Ati incercat sa rezolvati singur?:da

up

sunt functii din mysql r5 si trebuie inlocuite cu cele din r39-3 cu chache dar nu stiu cum..

da mai.Am r39-3 si ds l-am luat dintr-un fs de r5 si am nevoie de ajutor sa il trec pe 39-3

up

new CheckStock[128]; new result; new numarStoc; format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='%i'", VehDSmod[playerid]); result = mysql_query(CheckStock); mysql_store_result(); numarStoc = mysql_fetch_int(result); mysql_free_result(); printf("%i", numarStoc); if(numarStoc >= 1) { numarStoc--; format(CheckStock,sizeof(CheckStock),"UPDATE stocds SET stoc='%i' WHERE modelid='%i'", numarStoc, VehDSmod[playerid]); mysql_query(CheckStock); numarStoc = 0; new idd; mysql_query("SELECT * FROM `cars`"); mysql_store_result(); idd = mysql_num_rows()+1; mysql_free_result();mai sunt si mai jos