BuNiCu-RP

Uite, am reusit sa rezolv sa iti faca si restrictie pe statuete ! Tiki Quest - Pawn ! Tiki Quest - SQL

@Mister - ce i-ai oferit tu, nu il ajuta. Mane tu ai nevoie sa ii faci in onplayer login un public din care sa preia ce este in db... Gen cum ai la OnPlayerLoad (); adica sa verifice daca x a intrat in xtiki si sa ii returneze 1;

http://imgur.com/a/kp1kK

Uite ceva de genul trebuie sa ai tu un tabel: CREATE TABLE `tabel_tau`.`tiki` (`PlayerName` VARCHAR(32) NOT NULL, `Tiki1` INT(11) NULL DEFAULT '-1', `Tiki2` INT(11) NOT NULL DEFAULT '-1', `Tiki3` INT(11) NOT NULL DEFAULT '-1', `Tiki4` INT(11) NOT NULL DEFAULT '-1', `Tiki5` INT(11) NOT NULL DEFAULT '-1', `Tiki6` INT(11) NOT NULL DEFAULT '-1', `Tiki7` INT(11) NOT NULL DEFAULT '-1', `Tiki8` INT(11) NOT NULL DEFAULT '-1', `Tiki9` INT(11) NOT NULL DEFAULT '-1', `Tiki10` INT(11) NOT NULL DEFAULT '-1' ) ENGINE = InnoDB;

Pai cum adica? Ai un tabel in baza de date, unde sa se salveze si de unde sa se incarce?

Posteaza aici cum ai definita conexiunea cu baza de date, nu ma intreseaza parola sau alte detalii ! Trebuie sa ai ceva de genul: cHandle = mysql_connect("host", "user", "db", "pass");, sql = mysql_connect("host", "user", "db", "pass");

Uite un mic exemplu, nu sunt sigur ca este si functionabil. new pickup_tiki[25]; #define pTikix1 0 #define pTikix2 1 #define pTikix3 2 #define pTikix4 3 #define pTikix5 4 #define pTikix6 5 #define pTikix7 6 #define pTikix8 7 #define pTikix9 8 #define pTikix10 9 #define pTikix11 10 #define pTikix12 11 // [...] public OnGameModeInit() { pickup_tiki[0] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #1 pickup_tiki[1] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #2 pickup_tiki[2] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #3 pickup_tiki[3] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #4 pickup_tiki[4] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #5 pickup_tiki[5] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #6 return 1; } forward UpdateTiki(playerid, type); public UpdateTiki(playerid, type) { switch(type) { case pTikix1: // Tiki #1 { new str[128]; mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1); mysql_query(cHandle, str); } case pTikix2: // Tiki #2 { new str[128]; mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1); mysql_query(cHandle, str); } } } public OnPlayerPickUpPickup(playerid, pickupid) { if(pickupid == pickup_tiki[0]) { SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (1/25)."); UpdateTiki(playerid, pTikix1); } else if(pickupid == pickup_tiki[1]) { SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (2/25)."); UpdateTiki(playerid, pTikix2); } else if(pickupid == pickup_tiki[2]) { SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (3/25)."); UpdateTiki(playerid, pTikix3); } else if(pickupid == pickup_tiki[3]) { SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (4/25)."); UpdateTiki(playerid, pTikix4); } return 1; }

Ce sistem folosesti? YSI, DINI? Sau ce mai e nou acuma

Urmeaza sa faci asa: Cand intra in tiki #2 - sa ii arate mesajul iar mysql sa salveze: mysql_format(conn, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name`='%e' AND TIKI='%d' ", pTikix); mysql_query(conn, str); Sper ca ai inteles !

Poftim, sper sa iti fie de ajutor ! #include <zmcd> #define GPP GetPlayerPos // Ai nevoie de publicul ProxDetector .. stock GUName(playerid) { new s[MAX_PLAYER_NAME+1]; GetPlayerName(playerid, s, sizeof(s)); return s; } CMD:som(playerid, params[]) { new str[255], cmdL[32], getID, Float:ppos[3]; if(sscanf(params, "s[32]u", cmdL, getID)) return SCM(playrid, -1, "USAGE: /som [type (Wanted, Contrasens, ETC)] [PartOfName/ID]"); GPP(playerid, ppos[0], ppos[1], ppos[2]); if(!strcmp(cmdL, "wanted", false)) { if(IsPlayerInRangeOfPoint(getID, 10.0, ppos[0], ppos[1], ppos[2])) // Verifica daca politistul este in raza suspectului si trimite mesajul ! { if(PlayerData[pFaction] == 1 && PlayerData[pMember] == 1 && InPlayerIn) { format(str, sizeof(str), "[Rank] %s: %s esti suspect cu wanted, te predai?", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } else if(PlayerData[pFaction] == 2 && PlayerData[pMember] == 2) { format(str, sizeof(str), "[Rank] %s: %s esti suspect cu wanted, te predai?", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } else if(PlayerData[pFaction] == 2 && PlayerData[pMember] == 3) { format(str, sizeof(str), "[Rank] %s: %s esti suspect cu wanted, te predai?", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } } else SCM(playerid, -1, "Suspectul este prea departe de tine !"); } if(!strcmp(cmdL, "contrasens", false)) { if(IsPlayerInRangeOfPoint(getID, 10.0, ppos[0], ppos[1], ppos[2])) // Verifica daca politistul este in raza suspectului si trimite mesajul ! { if(PlayerData[pFaction] == 1 && PlayerData[pMember] == 1 && InPlayerIn) { format(str, sizeof(str), "[Rank] %s: %s esti urmarit, trage pe dreapta !", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } else if(PlayerData[pFaction] == 2 && PlayerData[pMember] == 2) { format(str, sizeof(str), "[Rank] %s: %s esti urmarit, trage pe dreapta !", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } else if(PlayerData[pFaction] == 2 && PlayerData[pMember] == 3) { format(str, sizeof(str), "[Rank] %s: %s esti urmarit, trage pe dreapta !", GUName(playerid), GUName(getID)); ProxDetector(10.0, playerid, str, -1, -1, -1, -1, -1); } } else SCM(playerid, -1, "Suspectul este prea departe de tine !"); } return 1; }

Salut, incearca asa: if(newstate == PLAYER_STATE_DRIVER) { for(new i = 0; i < CourierVeh; i++) { if(!IsPlayerInVehicle(playerid, CourierVeh[i]) && PI[playerid][Job] != 2) { SCM(playerid, COLOR_ERROR, "Aceste vehicule pot fi conduse doar de cei care detin meseria de curier!"); RemovePlayerFromVehicle(playerid); } } }

Destul de frumos, calumea 8/10

Dai pe un cont steam, sau pe un cont b-zone?

@NoNamed - asa ceva am vazut la un clip de pe mta, poate de asta ti se pare cunoscut

UP !!

new bool:unwanted[CAR_AMOUNT]; foreach (Player, i) { if(IsPlayerInAnyVehicle(i)) { unwanted[GetPlayerVehicleID(i)] = true; } } for(new car = 0; car <= sizeof(DMVCar); car++) { if(!unwanted[car]) PutPlayerInVehicle(i, car, 0); }

Multumesc, da este facut de mine, insa cu ajutor, sunt incepator ... am avut nevoie de scriptul pentru masurarea vitezi atat, restu e doar de mine facut

Salut, m-am gandit sa incerc si eu sa fac un speedometer, sa vad ce imi iese. Sper sa va placa ideea mea. Codul este creat de mine insa cu putin ajutor celor de la sa-mp.com Si cateva imagini: http://imgur.com/a/e3fuX Codul si scriptul aici: http://pastebin.com/vzFgjmNx +1 Daca iti place

Destul de frumos, insa mai trebuie aranjat ;)

Descriere produs: Vand cont B-ZONE (RPG1) Level 9, cu putina avere Preţ: 25 lei paysafecard Alte detalii: Astept Pm pentru alte detalii despre cont !

Nu merge. Puteti da T/C am renuntat la sistem !

Unde sa folosesc strcat?

Uite tot scriptul, degeaba pun valori mari, tot 1 linie imi arata, si la reporturi total imi arata 4 ... http://pastebin.com/pFvJF8R7

Problema intalnita (descriere): Nu imi afiseaza in dialog decat 1 lini in loc de 10... sau in functie de reporturi Ero(area / rile) / warning-(ul / urile): N/A Liniile de cod / sursa / script-ul(obligatoriu): mai jos Imagini / Video (optional): -- Ati incercat sa rezolvati singur?: da [spoiler]CMD:reports(playerid, params[]) { if(!IsPlayerConnected(playerid)) return SendClientMessage(playerid, COLOR_BLUE, "[SERVER ERROR]: Nu esti conectat !"); if(IsPlayerConnected(playerid)) { new head[128], size[255]; for(new xf = 0; xf < totalReports; xf++) { if(RData[xf][rStatus] == 1) { format(size, sizeof(size),"ID\tPlayer\tStatus\t\n%d\t%s\t%d\n", RData[xf][rID], RData[xf][rPlayer], RData[xf][rStatus]); } printf("Total read reports: %d", totalReports); } format(head, sizeof(head), "%d New Reports", totalReports); ShowPlayerDialog(playerid, D_REPORT_MANAGER2, DIALOG_STYLE_TABLIST_HEADERS, head, size, "Select", "Close"); SendClientMessage(playerid, COLOR_HIGHLIGHT, size); } return 1; }[/spoiler]