TheGodfather

up

Salut, primesc urmatoarea eroare pentru comanda /rpforall. ==================================================================== Error ID: 1065, Eroare: Query was empty Callback: gQuery: ==================================================================== YCMD:rpforall(playerid, params[], help) { new szMessage[180], rp; if(sscanf(params, "i", rp)) return SCM(playerid, COLOR_GREY, "Syntax: {FFFFFF}/rpforall <amount>"); if(PlayerInfo[playerid][pAdmin] < 6) return SCM(playerid, COLOR_GREY, "Nu esti autorizat sa folosesti aceasta comanda!"); foreach(Player, i) { if(IsPlayerConnected(i) && IsPlayerLogged == 1) { PlayerInfo[pExp] += rp; Update(i, pExp); format(szMessage, sizeof(szMessage), "* Administratorul {F03636}%s{FFFFFF} ti-a dat %d RP-uri ca bonus!",GetName(playerid), rp); SCM(i,COLOR_WHITE,szMessage); UpdateProgress(i); } } return true; }

up

Daca cumpar o masina, ii pun vip+, dupa o vand si cumpar orice alta masina, aceasta din urma o sa primeasca vip, si nu ar trebui. Las mai jos locurile in care pot sa fie probleme. In baza de date se updateaza corect toate valorile ------------------------------------------ function InsertVehicle(playerid, modelid, vip, rainbow, legendary, stage, temporar) { new idd = Iter_Free(PersonalVehicles); Iter_Add(MyVehicle[playerid], idd); Iter_Add(PersonalVehicles, idd); CarInfo[idd][Userid] = PlayerInfo[playerid][pSQLID]; CarInfo[idd][cID] = cache_insert_id(); CarInfo[idd][cModel] = modelid; CarInfo[idd][cValue] = 1; CarInfo[idd][cOnline] = playerid; if(CarInfo[idd][cModel] == 487 || CarInfo[idd][cModel] == 447) { new randspawn = random(sizeof(DealerCarPos1)); CarInfo[idd][cLocationx] = DealerCarPos1[randspawn][0]; CarInfo[idd][cLocationy] = DealerCarPos1[randspawn][1]; CarInfo[idd][cLocationz] = DealerCarPos1[randspawn][2]; CarInfo[idd][cAngle] = DealerCarPos1[randspawn][3]; } else if(CarInfo[idd][cModel] == 519) { new randspawn = random(sizeof(DealerCarPos2)); CarInfo[idd][cLocationx] = DealerCarPos2[randspawn][0]; CarInfo[idd][cLocationy] = DealerCarPos2[randspawn][1]; CarInfo[idd][cLocationz] = DealerCarPos2[randspawn][2]; CarInfo[idd][cAngle] = DealerCarPos2[randspawn][3]; } else { new randspawn = random(sizeof(DealerCarPos)); CarInfo[idd][cLocationx] = DealerCarPos[randspawn][0]; CarInfo[idd][cLocationy] = DealerCarPos[randspawn][1]; CarInfo[idd][cLocationz] = DealerCarPos[randspawn][2]; CarInfo[idd][cAngle] = DealerCarPos[randspawn][3]; } CarInfo[idd][cColorOne] = 1; CarInfo[idd][cColorTwo] = 1; strmid(CarInfo[idd][cOwner], PlayerInfo[playerid][pUsername], 0, strlen(PlayerInfo[playerid][pUsername]), 255); strmid(CarInfo[idd][cLicense], "NewCar", 0, 6, 255); CarInfo[idd][cAlarm] = 0; CarInfo[idd][cLock] = 0; CarInfo[idd][cRainBow] = false; CarInfo[idd][cLegendary] = 0; CarInfo[idd][cStage] = 0; for(new i = 0; i < 14; i++) CarInfo[idd][cMod] = 0; CarInfo[idd][cVip] = 0; CarInfo[idd][cNeon] = 0; CarInfo[idd][cFuel] = 100; CarInfo[idd][paintjob] = 3; CarInfo[idd][KM] = 0; CarInfo[idd][cPoints] = 5; CarInfo[idd][cTax] = 3000; CarInfo[idd][cTime] = gettime()+600; CarInfo[idd][cPoints] = 5; CarInfo[idd][cTax] = 50; saveCar(idd); gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE cars SET `MaxSpeed`='%d' WHERE ID=%d", GetVehicleMaxSpeed(CarInfo[idd][cModel]-400), CarInfo[idd][cID]); mysql_tquery(SQL, gQuery, "", ""); ------------------------------------------------- function InsertDsCars(playerid, modelid) { new idd = Iter_Free(PersonalVehicles); Iter_Add(MyVehicle[playerid], idd); Iter_Add(PersonalVehicles, idd); gQuery[0] = EOS; CP[playerid] = 53; CarInfo[idd][Userid] = PlayerInfo[playerid][pSQLID]; CarInfo[idd][cID] = cache_insert_id(); CarInfo[idd][cModel] = modelid; new randspawn = random(34); CarInfo[idd][cLocationx] = DealerCarPos[randspawn][0]; CarInfo[idd][cLocationy] = DealerCarPos[randspawn][1]; CarInfo[idd][cLocationz] = DealerCarPos[randspawn][2]; CarInfo[idd][cAngle] = DealerCarPos[randspawn][3]; CarInfo[idd][cOnline] = playerid; //test CarInfo[idd][cVip] = 0; CarInfo[idd][cNeon] = 0; //test mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE cars SET MaxSpeed='%d' WHERE ID=%d", GetVehicleMaxSpeed(CarInfo[idd][cModel]-400), CarInfo[idd][cID]); mysql_tquery(SQL, gQuery, "", ""); CarInfo[idd][cMaxSpeed] = GetVehicleMaxSpeed(CarInfo[idd][cModel]); CarInfo[idd][cColorOne] = DealerCarColor1[playerid]; CarInfo[idd][cColorTwo] = DealerCarColor2[playerid]; strmid(CarInfo[idd][cOwner], PlayerInfo[playerid][pUsername], 0, strlen(PlayerInfo[playerid][pUsername]), 255); CarInfo[idd][cValue] = DSModels[SelectedCar[playerid][DealerID[playerid]]][dPrice]; strmid(CarInfo[idd][cLicense], "NewCar", 0, 6, 255); CarInfo[idd][cAlarm] = 0; CarInfo[idd][cLock] = 0; CarInfo[idd][cRainBow] = false; CarInfo[idd][cLegendary] = 0; CarInfo[idd][cStage] = 0; for(new i = 0; i < 14; i++) CarInfo[idd][cMod] = 0; CarInfo[idd][paintjob] = 3; CarInfo[idd][KM] = 0; CarInfo[idd][cFuel] = 100; CarInfo[idd][cPoints] = 5; CarInfo[idd][cTax] = 3000; saveCar(idd); if(MyVehicleSpawn[playerid] != 5) SpawnPlayerCar(idd); DestroyVehicle(DealerCar[playerid]); TogglePlayerControllable(playerid, 1); SetCameraBehindPlayer(playerid); SetPlayerVirtualWorld(playerid,0); SetPlayerPosEx(false, playerid, 1487.0498,-2287.2930,13.7529); SetPlayerInterior(playerid, 0); new LastMoney[40]; format(LastMoney, 40, GetCashStr(playerid)); GivePlayerCash(playerid, 0, DSModels[SelectedCar[playerid][DealerID[playerid]]][dPrice]); gString[0] = EOS; format(gString, sizeof(gString), "Felicitari! Ai cumparat un %s pentru %s$.",aVehicleNames[modelid-400],FormatNumber(CarInfo[idd][cValue])); SCM(playerid, COLOR_MONEY, gString); format(gString, sizeof(gString), "%s si-a cumparat un %s[%d], (last money: $%s / new money: $%s)", GetName(playerid), aVehicleNames[modelid-400], idd, LastMoney, GetCashStr(playerid)); SendAdminMessage(COLOR_YELLOW, gString, 1); InsertLog(playerid, gString, LOG_CAR); finishAchievement(playerid, 1); return true; }

case DIALOG_UPSTAGE: { if(!response) return true; new idd = PersonalCar(playerid); if(CarInfo[idd][cStage] >= 3) return SCM(playerid, -1, "Acest vehicul este upgradat la stage maximum!"); if(PlayerInfo[playerid][pPremiumPoints] < StagePrice[0][CarInfo[idd][cStage]+1]) return SCM(playerid, -1, "Nu ai destule Premium Points."); if(IsABike(CarInfo[idd][Spawned])) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti upgrada acest vehicul!"); PlayerInfo[playerid][pPremiumPoints] -= StagePrice[0][CarInfo[idd][cStage]+1]; Iter_Add(IsSpeed, playerid); Update(playerid, pPremiumPointsx); SCMEx(playerid, COLOR_WHITE, "{227FC3}Tunning System: {FFFFFF}You upgraded your vehicle successfully to stage %d for %d premium points.", CarInfo[idd][cStage]+1, StagePrice[0][CarInfo[idd][cStage]+1]); mysql_format(SQL, string, sizeof(string), "UPDATE `cars` SET `Stage`='%d' WHERE `ID`='%d'", CarInfo[idd][cStage]+1, CarInfo[idd][cID]); mysql_tquery(SQL, string, "", ""); //test CarInfo[idd][cLegendary] = 1; SCM(playerid, COLOR_GREY, "Masina ta este premium deorece are sistemul stage."); mysql_format(SQL, string, sizeof(string), "UPDATE cars SET `Legendary`='1' WHERE `ID`='%d'", CarInfo[idd][cID]); mysql_tquery(SQL, string, "", ""); //test CarInfo[idd][cStage] ++; //testtttttt mysql_format(SQL, string, sizeof(string), "UPDATE cars SET `MaxSpeed`='%d' WHERE ID=%d", GetVehicleMaxSpeed(CarInfo[idd][cModel]-400)+StageSpeed[0][CarInfo[idd][cStage]]+5, CarInfo[idd][cID]); mysql_tquery(SQL, string, "", ""); //testtttttt format(string, sizeof(string), "Your vehicle is~y~ %s~n~~w~~h~Max. speed:~y~ %d km/h~n~~w~~h~Current stage:~y~ %d/3~w~~h~~n~boost: ~y~+%d km/h~w~~h~ / ~b~ %d km/h" ,aVehicleNames[GetVehicleModel(GetPlayerVehicleID(playerid))-400], CarInfo[idd][cMaxSpeed], CarInfo[idd][cStage],StageSpeed[0][CarInfo[idd][cStage]], CarInfo[idd][cMaxSpeed]+StageSpeed[0][CarInfo[idd][cStage]]); PlayerTextDrawSetString(playerid, StagePTD, string); } Am adaugat ce este intre //testtttttt si se updateaza corect viteza in baza de date, dar in joc tot pot sa merg cu cel putin 40km+ fata de aceasta

Am incercat si asa, tot nu merge if(legendary == 1) { CarInfo[idd][cLegendary] = 1; gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE cars SET `Legendary`='%d',`MaxSpeed`='%d+25' WHERE ID=%d", CarInfo[idd][cLegendary], GetVehicleMaxSpeed(CarInfo[idd][cModel]-400),CarInfo[idd][cID]); mysql_tquery(SQL, gQuery, "", ""); }

Am incercat asta, nu se updateaza in baza de date si masinile slabe tot prind 260+

Cum pot face ca daca o masina are sistemul premium, sa prinda viteza maxima a masinii+25km? Am incercat sa fac mai multe modificari aici, dar tot pot prinde +250 si cu tahoma. B-HOOD.pwn

De ex., am un infernus, alt player are unB-HOOD.pwn infernus, ambele cu stage 3/3. Al meu prinde 300+km iar al lui nu prinde mai mult de 209, nu stiu care ar fi problema. Mai jos este .pwn de la gm

Nu merge bine /find, cand e in hq la factiune sau clan hq. In rest la casa/biz merge ok. In poza asta trebuia sa imi puna cp unde scrie Los Santos ...

O sa incerc imediat comanda /find cu modificarile mentionate. case DIALOG_WANTED: { if(!response) return true; new id = SelectedPlayers[playerid][listitem]; if(PlayerInfo[id][pWantedLevel] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Acel player nu mai are wanted!"); ShowMDC(playerid, id); UsedFind[playerid] = 1; new Float:X,Float:Y,Float:Z; GetPlayerPos(id, X,Y,Z); SetPlayerCheckpointEx(playerid, X,Y,Z, 3.5); targetfind[playerid] = id; CP[playerid] = 53; format(string, sizeof(string), "* Punctul rosu a fost setat pe %s (%d) care se afla in zona %s.",GetName(id),id,GetPlayerZone(id)); SCM(playerid,COLOR_YELLOW,string); }

up

Salut, am o problema cu aceste 2 comenzi. Imi pune checkpoint gresit cand cineva se afla intr-o casa/hq/biz YCMD:wanted(playerid, params[], help) { if(!IsACop(playerid)) return SCM(playerid, COLOR_GREY, "Nu faci parte din factiunea politiei."); if(OnDuty[playerid] == 0) return SCM(playerid, COLOR_LGREEN, "Nu poti folosi aceasta comanda deoarece nu esti la datorie!"); new iString[1024],string[300],count = 0,online[50]; strcat(iString, "Name\tWanted level\tChased by\n"); if(IsPlayerConnected(playerid)) { foreach(Player,i) { if(PlayerInfo[pWantedLevel] >= 1) { SelectedPlayers[playerid][count] = i; string[0] = 0; format(string, sizeof(string), "%s (%d)\tWanted level %d\t%d cops\n",GetName(i),i,PlayerInfo[pWantedLevel],ChasedBy(i)); count++; strcat(iString,string); } } format(online, sizeof(online),"Wanted online: %d",count); if(count == 0) return SCM(playerid,COLOR_GREY, "Nu sunt suspecti conectati."); ShowPlayerDialog(playerid, DIALOG_WANTED, DIALOG_STYLE_TABLIST_HEADERS, online, iString , "Ok", "Exit"); } return 1; } YCMD:find(playerid, params[], help) { if(JobWorking[playerid] == 1) return 1; if(CP[playerid] != 0 || targetfind[playerid] != -1) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit"); new id,giveplayer[30],string[100]; if(PlayerInfo[playerid][pJob] != 6 && PlayerInfo[playerid][pMember] != 1 && PlayerInfo[playerid][pMember] != 2 && PlayerInfo[playerid][pMember] != 14 && !IsACop(playerid)) return SCM(playerid, COLOR_GREY, "Nu ai jobul 'Detective'."); if(sscanf(params, "u",id)) return SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/find <playerid/name>"); if(!IsPlayerConnected(id) || id == INVALID_PLAYER_ID) return SCM(playerid, COLOR_GREY, "Acel player nu este conectat."); if(Spectate[id] != 255) return SCM(playerid, COLOR_GREY, "Acel player este ocupat!"); if(id == playerid) return SCM(playerid, COLOR_GREY, "Nu poti folosi aceasta comanda asupra ta!"); if(togfind[id] == 1) return SCM(playerid,COLOR_GREY, "Acel player nu poate fi urmarit!"); if(GetPVarInt(id, "Undercover") == 1) return SCM(playerid, COLOR_GREY, "Acel player este ocupat!"); if(BizRobbed[playerid] != 0) return 1; if(togfind[id] == 1 && OnDuty[playerid] == 0 && PlayerHit[playerid] == -1) return SCM(playerid, COLOR_LGREEN, "Eroare: Acel player nu poate fi urmarit!"); UsedFind[playerid] = 1; GetPlayerName(id, giveplayer, sizeof(giveplayer)); new Float:X,Float:Y,Float:Z; GetPlayerPos(id, X,Y,Z); SetPlayerCheckpointEx(playerid, X,Y,Z, 3.5); targetfind[playerid] = id; CP[playerid] = 53; format(string, sizeof(string), "* Punctul rosu a fost setat pe %s (%d) care se afla in zona %s.",giveplayer,id,GetPlayerZone(id)); SCM(playerid,COLOR_YELLOW,string); for(new m; m < 2; m++) { if(PlayerInfo[playerid][pDailyMission][m] == 12) CheckMission(playerid, m); } return 1; }

Merge, multumesc pentru ajutor tuturor T/C

Nu mai pot da ban deloc cuiva care nu e on

Nu merge, am admin 7 si ma lasa sa dau ban unui admin 8, am verificat in baza de date

up

Ma lasa sa banez jucatori cu admin mai mare ca al meu

Acum ma lasa sa banez

Nu mai pot bana un jucator cu admin mai mare, nu imi arata mesaj in chat ca am banat pe x dar nici nu imi arata mesajul Nu poti bana un jucator...

YCMD:bano(playerid, params[], help) { new name[MAX_PLAYER_NAME]; if(PlayerInfo[playerid][pAdmin] < 1) return SCM(playerid,COLOR_WHITE,AdminOnly); if(DeelayCommand[playerid][0] != 0) return DeelayTime(playerid, 0); new giveplayerid[25],days,reason[128],string[128],cont; if(sscanf(params, "s[25]ds[128]", giveplayerid, days,reason)) return SCM(playerid,COLOR_GREY, "Syntax: {FFFFFF}/bano <name> <0 = permanent/days> <reason>"); if(FaceReclama(reason)) return RemoveFunction(playerid, reason); new userID = GetPlayerID(giveplayerid), padmin; if(userID != INVALID_PLAYER_ID) return SCM(playerid, COLOR_GREY, "Acel jucator este deja conectat!"); cont = MySQLCheckAccount(giveplayerid); if(cont == 0) return SCM(playerid,COLOR_ERROR,"Eroare:{FFFFFF} Acest cont nu a fost gasit in baza de date!"); GetPlayerName(playerid, name, sizeof name); new admin[180], szResult[180]; for(new i = 0; i < cache_num_rows(); i++) { //cache_get_value_int(i, "Admin", padmin); cache_get_field_content(i, "Admin", szResult); format(admin, 256, szResult); if(PlayerInfo[playerid][pAdmin] < padmin) return SCM(playerid, -1, "This player can not be banned."); if(days > 0) { new year,month,day; getdate(year, month, day); day += days; if(IsMonth31(month)) { if(day > 31) { month += 1; if(month > 12) { year += 1; while(day > 31) day -= 31; } else while(day > 31) day -= 31; } } else if(!IsMonth31(month)) { if(day > 30) { month += 1; if(month > 12) { year += 1; while(day > 30) day -= 30; } else while(day > 30) day -= 30; } } else if(!IsMonth31(month) && IsMonth29(year) && month == 2) { if(day > 29) { month += 1; if(month > 12) { year += 1; while(day > 29) day -= 29; } else while(day > 29) day -= 29; } } else if(!IsMonth31(month) && !IsMonth29(year) && month == 2) { if(day > 28) { month += 1; if(month > 12) { year += 1; while(day > 28) day -= 28; } else while(day > 28) day -= 28; } } DeelayCommand[playerid][0] = 10; if(days == 1) { format(string,128,"Offline: %s has been banned by %s for %d days, reason: %s",giveplayerid,name,days,reason); SCMTA(COLOR_LIGHTRED,string); } else if(days > 1) { format(string,128,"Offline: %s has been banned by %s for %d days, reason: %s",giveplayerid,name,days,reason); SCMTA(COLOR_LIGHTRED,string); } new szQuery[256]; mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `users` SET `BTemp`='1', `BYear`='%d', `BMonth`='%d', `BDay`='%d', `BBy`='%s', `BReason`='%s' WHERE `name`='%s'",year, month, day, name, reason, giveplayerid); mysql_tquery(SQL ,szQuery, "", ""); } else if(days == 0) { new szQuery[256]; mysql_format(SQL, szQuery,sizeof(szQuery),"UPDATE users SET `Banned`='1', `BBy`='%s', `BReason`='%s' WHERE `name`='%s'", GetName(playerid), reason, giveplayerid); mysql_tquery(SQL,szQuery, "", ""); mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE users SET `HelpedPlayers` = '%d', `HelpedPlayersToday`='%d' WHERE `ID` = '%d'", PlayerInfo[playerid][pHelpedPlayers], PlayerInfo[playerid][pHelpedPlayersToday], PlayerInfo[playerid][pSQLID]); mysql_tquery(SQL, szQuery, "", ""); if(strfind(reason, "Silent", true) != -1) { format(string, sizeof(string), "Silent: %s (offline) has been banned by %s, reason: %s", giveplayerid, GetName(playerid),reason); SendAdminMessage(COLOR_LIGHTRED, string, 1); } else { format(string, sizeof(string), "Offline: %s has been permanent banned by %s, reason: %s", giveplayerid, GetName(playerid),reason); SCMTA(COLOR_LIGHTRED, string); } } else return true; Banlog("Offline",giveplayerid,GetName(playerid),reason,days); PlayerInfo[playerid][pHelpedPlayers] += 2; PlayerInfo[playerid][pHelpedPlayersToday] += 2; new szQuery[256]; mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE users SET `HelpedPlayers` = '%d', `HelpedPlayersToday`='%d' WHERE `ID` = '%d'", PlayerInfo[playerid][pHelpedPlayers], PlayerInfo[playerid][pHelpedPlayersToday], PlayerInfo[playerid][pSQLID]); mysql_tquery(SQL, szQuery, "", ""); } return true; } Pot da ban unui admin cu lvl mai mare ca al meu

Cele 2 erori cu rows le-am rezolvat, mai am nevoie la cache_ [...]

Ok, imediat o sa incerc

Poftim StrikerM function MySQLCheckAccount(sqlplayersname[]) { gQuery[0] = EOS; new Cache: result; mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `name`='%s' LIMIT 1", sqlplayersname); mysql_query(SQL, gQuery); if(cache_num_rows() != 0) return true; cache_delete(result); return false; } Nu e nicio problema LucaPawnL