AddisoN

/usr/lib32/libstdc++.so.6: version `GLIBCXX_3.4.19' not found (required by plugins/mysql.so)) Zice clar ca ii lipseste libstdc++.so.6 din acel folder. Pune acel fisier acolo si vezi daca merge

La inceputul gm-ul New PlayerWork [MAX_PLAYERS] //o poti folosi pt toate joburile nu trebuie sa mai faci altele if(strcmp(cmd, "/truck", true) == 0) { new vehicleid = GetPlayerVehicleID(playerid); if(vehicleid == truck[0] || vehicleid == truck[1] ||vehicleid == truck[1]) { if (PlayerWork [playerid]!=0)return SendClientMessage (playerid,-1,"muncesti deja"); If (!IsTrailerAttachedToVehicle(vehicleid)) return SCM (playerid,-1,"Nu ai remorca atasata"); PlayerWork[playerid]=1 truckCP[playerid] = 1; DisablePlayerCheckpoint(playerid); new rand = random(sizeof(RandomCP)); SetPlayerCheckpoint(playerid, RandomCP[rand][0], RandomCP[rand][1],RandomCP[rand][2], 5.0); } else { SendClientMessage(playerid,COLOR_GREY,"Nu esti intr-un TIR ."); } } Si la onplayerenterchecpoint faci iara verificarea sa vezi daca are atasata remorca. Cva de genu If (!IsTrailerAttachedToVehicle(vehicleid)) return SCM (playerid,-1,"Nu ai remorca atasata prin urmare nu vei fii platit"); GivePlayerMoney (playerid,bani);//linia asta se va executa doar daca are remorca //pui pe 0 playerwork PlayerWork [playerid]=0; TruckCP [playerid]=0;

fa asa: if (dialogid==DIALOG_HELP) { if (!response) return 1; if (listitem==0){instuctiuni} else if (listitem==1){instructiuni} //Continui tu cu cate cazuri ai. Si verifica ca sa nu ai cand jucatorul nu raspunde kick (playerid); }

Cauta in gm liniile de cod cu CreateVehicle, AddStaticVehicle si AddStaticVehicleEx

Am rezolvat problema am rescris sitemul de login/register si merge acum

if(dialogid==1) { new name[MAX_PLAYER_NAME],query[128]; if(response){ //a dat register if(strlen(inputtext)<6){//verific lungimea sirului ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Register","Introdu o parola care are cel putin 6 caractere","Register","Quit"); }//<6 else{//>=6 GetPlayerName(playerid,name,sizeof(name)); format(query,sizeof(query),"INSERT INTO players (nume,parola) VALUES (%s,%s)",name,inputtext); //mysql_function_query(dbhandle,query,false,"",""); mysql_tquery(dbhandle,query,"",""); ShowPlayerDialog(playerid,3,DIALOG_STYLE_MSGBOX,"Sex Caracter","Alege sexul dorit pentru caracterul tau","Barbat","Femeie"); } } else{ //a dat quit Kick(playerid); } } Pe acel site m.am si uitat si nu e prima data cand folsoesc baza de date MySQL. Codul de mai sus este bun?

am modificat si acum primesc aceasta eroare: [18:33:04] [plugins/mysql] mysql_connect: handle error: no database specified [18:33:04] [plugins/mysql] mysql_errno: invalid connection handle '1' App pe sa-mp wiki la functia mysqlconnect sunt altfel parametrii (const host[], const user[], const password[], const database[], MySQLOpt:option_id = MySQLOpt:0) , adik baza de date ultima EDIT: mysql_connect("127.0.0.1","root","samp","") se pare ca baza de date este ultima pentru ca spuen ca nu este specificata si doar acolo nu am trecut nimic intre ghilimele

if(dialogid==1) { new name[MAX_PLAYER_NAME],query[128]; if(response){ //a dat register if(strlen(inputtext)<6){//verific lungimea sirului ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Register","Introdu o parola care are cel putin 6 caractere","Register","Quit"); }//<6 else{//>=6 GetPlayerName(playerid,name,sizeof(name)); format(query,sizeof(query),"INSERT INTO players (nume,parola) VALUES (%s,%s)",name,inputtext); //mysql_function_query(dbhandle,query,false,"",""); mysql_tquery(dbhandle,query); ShowPlayerDialog(playerid,3,DIALOG_STYLE_MSGBOX,"Sex Caracter","Alege sexul dorit pentru caracterul tau","Barbat","Femeie"); } } else{ //a dat quit Kick(playerid); } } aici e o parte din sistemulde login/register si ar trebuii sa se creeze rand nou in baza de date ceea ce nu se intampla.

Am folosit si nu raporteaza nici o eroare. //variabile globale new MySQL:dbhandle //onplayerconnect dbhandle = mysql_connect("127.0.0.1","root","","samp"); if(mysql_errno() != 0) { printf("Conexiunea la baza de date %s a esuat ---> Server Inchis ~~~", db_db); SendRconCommand("exit"); } else { printf("Conexiunea la baza de date '%s' cu user-ul '%s' a reusit!!!", db_db, db_user); }

daca ma contectez la ea cum sa il respinga

nu a mers nici asa si am facut update la mysql r41-2, am reusit sa ma conectez la baza de date (si am si verificat cu mysql_errno) dar tot nu misca nimic. codul de la sistemul de login: public OnPlayerConnect(playerid) { new name[MAX_PLAYER_NAME],query[128],numrows/*,numfields*/; GetPlayerName(playerid,name,sizeof(name)); format(query,sizeof(query),"SELECT count(id) FROM players WHERE nume=%s",name); //mysql_function_query(dbhandle,query,false,"",""); mysql_tquery(dbhandle,query); //cache_get_data(numrows,numfields,dbhandle); cache_get_result_count(numrows); printf("Sunt %d conturi cu numele %s",numrows,name); if(numrows==0) { ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Register","Intro o parola pentru a te inregistra","Register","Quit"); } else{ ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Login","Introdu parola pentru a te loga","Login","Quit"); } return 1; } public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { if(dialogid==1) { new name[MAX_PLAYER_NAME],query[128]; if(response){ //a dat register if(strlen(inputtext)<6){//verific lungimea sirului ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Register","Introdu o parola care are cel putin 6 caractere","Register","Quit"); }//<6} else{//>=6 GetPlayerName(playerid,name,sizeof(name)); format(query,sizeof(query),"INSERT INTO players (nume,parola) VALUES (%s,%s)",name,inputtext); //mysql_function_query(dbhandle,query,false,"",""); mysql_tquery(dbhandle,query); ShowPlayerDialog(playerid,3,DIALOG_STYLE_MSGBOX,"Sex Caracter","Alege sexul dorit pentru caracterul tau","Barbat","Femeie"); } } else{ //a dat quit Kick(playerid); } } if(dialogid==3){ new name[MAX_PLAYER_NAME],query[128]; GetPlayerName(playerid,name,sizeof(name)); if(response){ format(query,sizeof(query),"UPDATE players SET sex=1 WHERE nume=%s",name); mysql_tquery(dbhandle,query); //mysql_function_query(dbhandle,query,false,"",""); ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Login","Introdu parola aleasa pentru a te loga","Login","Quit"); } else{ format(query,sizeof(query),"UPDATE players SET sex=2 WHERE nume=%s",name); mysql_tquery(dbhandle,query); //mysql_function_query(dbhandle,query,false,"",""); ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Login","Introdu parola aleasa pentru a te loga","Login","Quit"); } } if(dialogid==2){ new name[MAX_PLAYER_NAME],query[128]; GetPlayerName(playerid,name,sizeof(name)); if(response){ new numrows/*,numfields*/; format(query,sizeof(query),"SELECT COUNT(*) FROM players WHERE nume=%s AND parola=%s",name,inputtext); mysql_tquery(dbhandle,query); cache_get_result_count(numrows); //mysql_function_query(dbhandle,query,false,"",""); //cache_get_data(numrows,numfields,dbhandle); if(numrows==0){ ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD,"Login","Parola Gresita! \n Introdu parola pentru a te loga","Login","Quit"); } else{ SetPlayerPos(playerid,1743.1831,-1944.7471,13.5655); cache_get_value_index_int(0,4,pinfo[playerid][level]); cache_get_value_index_int(0,3,pinfo[playerid][sex]); cache_get_value_index_int(0,5,pinfo[playerid][money]); cache_get_value_index_int(0,6,pinfo[playerid][bizid]); cache_get_value_index_int(0,7,pinfo[playerid][houseid]); cache_get_value_index_int(0,8,pinfo[playerid][premium]); /*pinfo[playerid][level]=cache_get_field_content_int(0,"level",dbhandle); pinfo[playerid][money]=cache_get_field_content_int(0,"bani",dbhandle); pinfo[playerid][bizid]=cache_get_field_content_int(0,"bid",dbhandle); pinfo[playerid][houseid]=cache_get_field_content_int(0,"hid",dbhandle); pinfo[playerid][premium]=cache_get_field_content_int(0,"premium",dbhandle); pinfo[playerid][sex]=cache_get_field_content_int(0,"sex",dbhandle);*/ SetPlayerScore(playerid,pinfo[playerid][level]); GivePlayerMoney(playerid,pinfo[playerid][money]); SetPlayerSkin(playerid,0); } } else{ Kick(playerid); } } return 1; }

Am uitat sa precizez ca folosesc mysql r39 de la blueg. Nu am mai avut aceasta problema pana acum nici cand scriptam in php nici in pawno.

Primesc aceasta eroare cand deschid serverul in mysql_log : [ERROR] mysql_connect - empty connection data specified new dbhandle; #define db_host "127.0.0.1" #define db_user "root" #define db_pass "" #define db_db "samp" dbhandle=mysql_connect(db_host,db_user,db_pass,db_db);

[pawn][19:06:49] [ERROR] CMySQLQuery::Execute[] - (error #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 '', `color2`='0' WHERE `id`='12'' at line 1 [19:10:02] [ERROR] CMySQLQuery::Execute[] - (error #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 '', `color2`='87' WHERE `id`='12'' at line 1[/pawn] asta zice

tot nu merge pff

akm primesc erorile astea : G_M.pwn(591) : error 035: argument type mismatch (argument 1) G_M.pwn(591) : error 035: argument type mismatch (argument 2) asta e randul cu erorile: [pawn]mysql_format(query,sizeof(query),"UPDATE `cars` SET `color1`=%d', `color2`='%d' WHERE `id`='%d'",cInfo[c_c1],cInfo[c_c2],cInfo[db_id]);[/pawn]

k il am de tip int. dar dc nu face update?

Nu am mers nici asa ph0enix. Variabila din data de baza trebuie de tip int?

Nick: AddisoN Problem? întâlnit?: Folosec comanda carcolor, imi schimba culorile masinii dar daca dau restart nu face update in baza de date si gand intru din nou o gasesc neagra(in baza de date imi ramane mereu 0 la ambele culori) Erori / warnings: nu am in script Lini/script: - Ai incercat sa rezolvi singur ?:Da dar nu am reusit Asta e comanda creata de mine. [pawn]ocmd:carcolor(playerid, params[]) { for(new i=0; i<sizeof(cInfo);i++) { new incar = IsPlayerInAnyVehicle(playerid); new cowner = cInfo[owner]; new c1=cInfo[c_c1]; new c2=cInfo[c_c2]; if(!cowner) SCM(playerid,RED,"Nu ai masina!"); if(!incar) return SCM(playerid,RED,"Trebuie sa fii in masina!"); if(sscanf(params,"dD",c1,c2)) return SendClientMessage(playerid, -1, "INFO: /colorcar [color1] [color2]"); if(c1<0||c1>127)return SendClientMessage(playerid,RED,"Invalid id color one."); if(c2<0||c2>127)return SendClientMessage(playerid,RED,"invalid id color two."); new query[128],string[128]; format(query,sizeof(query),"UPDATE cars SET color1='%i',color2,='%i'WHERE id='%i'",cInfo[c_c1],cInfo[c_c2],cInfo[db_id]); mysql_function_query(dbhandle,query,false,"",""); format(string, sizeof(string), "You have change the vehicle's color 1 to %d and color 2 to %d!",c1,c2); SendClientMessage(playerid, RED, string); ChangeVehicleColor(cInfo[id_x],c1,c2); return 1; } return 1; }[/pawn] Multumesc anticipat!