Problema pornire srv

1Shot · February 7, 2019

Salut. cand incerc pornesc server-ul se inchide si imi da niste erori pe care nu stiu cum sa le rezolv...

Am incercat sa schimb plugin-urile dar degeaba...

Acestea sunt erorile din server_log:

[16:01:02] [debug] Server crashed while executing GM.amx
[16:01:02] [debug] AMX backtrace:
[16:01:02] [debug] #0 native mysql_connect () [72f1e4d0] from mysql.DLL
[16:01:02] [debug] #1 000c0c08 in ?? () at C:\Users\Remus\Desktop\GM\gamemodes\GM.pwn:1524
[16:01:02] [debug] #2 0002f144 in public L_AFK_OnGM () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\y_hooks/impl.inc:484
[16:01:02] [debug] #3 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #4 0001bcc4 in public SSCANF_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\AutoAFK.inc:47
[16:01:02] [debug] #5 000153b0 in public Itter_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\sscanf2.inc:205
[16:01:02] [debug] #6 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #7 000140e8 in public ScriptInit_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\y_iterate.inc:791
[16:01:02] [debug] #8 00012d08 in public PZone_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\internal\..\y_scriptinit.inc:171
[16:01:02] [debug] #9 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #10 00006ce8 in public OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\playerzone.inc:429

multumesc.

Banditul · February 7, 2019

Arata linia 1524 din GM.pwn sau aia e linia cu mysql_connect?

1Shot · February 7, 2019

Dap, este fix linia SQL = mysql_connect("localhost", "root", "baza", "");

SherKan · February 7, 2019

verifica daca versiunea de la plugin e aceeasi cu cea de la include,

1Shot · February 7, 2019

Da, sunt aceleasi tocmai ce le-am downloadat (toate cele 5 plugin-uri) ultimele versiuni , si le-am pus si in plugins si in pawno/include si am si compilat gm-ul...

SherKan · February 7, 2019

ce versiune de mysql folosesti?

Banditul · February 7, 2019

Daca e mysql r40+

SQL = mysql_connect("localhost", "root", "", "baza");

1Shot · February 7, 2019

R41-4

SherKan · February 7, 2019

eu am r41-4 si folosesc

SQL	= mysql_connect_file();

nu e nevoie sa compilez mereu cand modific numele/parola la baza de date sau hostul

SherKan · February 7, 2019

log-core.dll si libmariadb.dll trebuie puse in folderul principal in caz ca nu le-ai pus

1Shot · February 7, 2019

Defapt am gresit eu, aveam o versiune mai veche, am pus acum ultima versiune si imi apar erori cand compilez.........

C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(6998) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(6999) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7000) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7001) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7002) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7003) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7017) : warning 213: tag mismatch
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7019) : warning 202: number of arguments does not match definition
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7020) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7021) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7022) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7023) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7024) : error 017: undefined symbol "cache_get_field_content"

Edited February 7, 2019 by 1Shot

SherKan · February 7, 2019

uita-te la functiile din mysql pe wiki eu folosesc asta + cele asemanatoare

cache_get_value_int
cache_get_value_float
...

1Shot · February 7, 2019

9 minutes ago, Banditul said:
Daca e mysql r40+
SQL = mysql_connect("localhost", "root", "", "baza");

daca pun r41 imi da multe erori...

iar mysql acesta pe care il am acum nu stiu exact ce versiune este...cum pot vedea?

1Shot · February 7, 2019

Just now, SherKan said:
uita-te la functiile din mysql pe wiki eu folosesc asta + cele asemanatoare
cache_get_value_int
cache_get_value_float
...

nu ma pricep prea bine la mysql...mai bine las versiunea asta de mysql care este pusa...dar nu stiu exact ce versiune e

1Shot · February 7, 2019

12 minutes ago, Banditul said:
Daca e mysql r40+
SQL = mysql_connect("localhost", "root", "", "baza");
Daca pun asa cum ai spus, se deschide server-ul, dar imi apare:

[16:27:21] Server vehicles: 0
[16:27:21] Safezones: 0
[16:27:21] Houses: 0
[16:27:21] Clans: 0
[16:27:21] Clan zones: 0
[16:27:21] Bussines: 0
[16:27:21] Turfs: 0
[16:27:21] Factions: 0
[16:27:21] Jobs: 0
[16:27:21] Furnitures: 0
[16:27:21] Stuff Loaded
[16:27:21] Safes: 0
[16:27:21] Apartaments: 0
[16:27:23] Accesory loaded: 0

De ce apar toate 0 ? ...

SherKan · February 7, 2019

pune loadjobs() sau cum ai sa vad ce ar trebui modificat

1Shot · February 7, 2019

Aparea 0 pt. ca nu era bine cum am scris la mysql_connect...

Am mysql 39.4 sau ceva de genu... Nu inteleg de ce apar acele erori in serverlog si imi da crash...

SherKan · February 7, 2019

pune r41-4 eu ala folosesc si fara mysql_connect, eu am mysql_connect_file, documenteaza-te de pe wiki cum se foloseste

1Shot · February 7, 2019

trebuie sa stau sa redenumesc o gramade de functii daca bag r41...si nu am nici o garantie ca dupa aceea va merge...

1Shot · February 7, 2019

@Banditul Ma poti ajuta? Cu ce trebuie sa redenumesc aceste functii care au fost scoate in r40 ... ?

C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1687) : error 017: undefined symbol "mysql_store_result"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1688) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1690) : error 017: undefined symbol "mysql_free_result"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(15815) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(16343) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(16343) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(31315) : error 017: undefined symbol "mysql_get_field"

cum naiba rezolv eu astea...? cu ce sa le redenumesc...

Edited February 7, 2019 by 1Shot

SherKan · February 7, 2019

mysql_num_rows = cache_num_row

mysql_free_result ar fi cache_delete

celelalte nu stiu exact, eu parca le-am sters tot ce era legat de mysql_free, mysq_fect.. etc si am pus pe cache

Banditul · February 7, 2019

@1Shot arata functia respectiva sa iti fac un model

Avand in vedere functiile asa zice r34

1Shot · February 7, 2019

@Banditul Apare mysql R39.3 loaded...

Sunt vreo 7 functii care imi spune ca sunt "undefined":

Acestea sunt functiile undefined: mysql_store_result, mysql_num_rows, mysql_fetch_row, mysql_free_result, mysql_get_field, mysql_fetch_field_row, mysql_retrieve_row.

Cam astea ar fi scripturile:

	// Login
	format(szString,sizeof(szString),"SELECT * FROM users WHERE `name`='%s'",GetName(playerid));
	mysql_query(SQL,szString);
	mysql_store_result();
	if(mysql_num_rows()) PlayerAccount[playerid] = 1;
	else PlayerAccount[playerid] = 0;
	mysql_free_result();

	login[playerid] = SetTimerEx("LoginTimer", 30000, false,"d", playerid);
	CheckClassIP(playerid);

	mysql_query(SQL,str1);
	mysql_store_result();
	mysql_fetch_row(strid);
	intid = strval(strid);
	mysql_free_result();
	intid++;

			if(PlayerAccount[playerid] != 0) {
				new laston[64], field[128];
				format(field,128,"SELECT `lastOn`  FROM users WHERE `name`='%s'",GetName(playerid));
				mysql_query(SQL,field);
				mysql_store_result();
				if(mysql_retrieve_row()) mysql_fetch_field_row(laston, "lastOn");
				mysql_free_result();
				format(string, sizeof(string), "Bine ai revenit, %s!\nTasteaza in casuta de mai jos parola contului tau.\n\nUltima logare: {FFFFFF}%s",GetName(playerid),laston);
				ShowPlayerDialog(playerid, DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Logare", string,"Logare","Quit");

		mysql_get_field("ID", result);				BizzInfo[i][bID] = strval(result);
        mysql_get_field("Owned", result);			BizzInfo[i][bOwned] = strval(result);
        mysql_get_field("Owner", result);			strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
        mysql_get_field("Message", result);			strmid(BizzInfo[i][bMessage], result, 0, 100, 100);
   	    mysql_get_field("EntranceX", result);		BizzInfo[i][bEntranceX] = floatstr(result);

Edited February 7, 2019 by 1Shot

Banditul · February 7, 2019

mysql_format(SQL, szString,sizeof(szString),"SELECT `ID` FROM users WHERE `name`= '%e'",GetName(playerid)); //Nue e nevoie sa selectezi tot daca oricum nu folosesti nimic
new Cache:result =  mysql_query(SQL,szString);
new rows;
cache_get_row_count(rows);
if(rows) PlayerAccount[playerid] = 1;
else PlayerAccount[playerid] = 0;
cache_delete(result);

new Cache:result = mysql_query(SQL,str1);
cache_get_value_int(0, "field selectat folosind query de select", intid);
cache_delete(result);
intid++;


if(PlayerAccount[playerid] != 0) {
    new laston[64], field[128];
    mysql_format(SQL, field,128,"SELECT `lastOn` FROM users WHERE `name`='%e'",GetName(playerid));
    new Cache:result = mysql_query(SQL,field), rows;
    cache_get_row_count(rows);
    if(rows) cache_get_value(0, laston, "lastOn");
    cache_delete(result);
    format(string, sizeof(string), "Bine ai revenit, %s!\nTasteaza in casuta de mai jos parola contului tau.\n\nUltima logare: {FFFFFF}%s",GetName(playerid),laston);
    ShowPlayerDialog(playerid, DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Logare", string,"Logare","Quit");

//Aici imi lipsete contextul
for(new row = 0, rows = cache_num_rows(); row < rows; row++)

cache_get_value_int(row, "ID", BizzInfo[i][bID]);			
cache_get_value_int(row, "Owned", BizzInfo[i][bOwned]);			
cache_get_value(row, "Owner", BizzInfo[i][bOwner], MAX_PLAYER_NAME);			
cache_get_value(row, "Message", BizzInfo[i][bMessage], 200);// marimea bMessage in lco de 200			
cache_get_value_float(row, "EntranceX", BizzInfo[i][bEntranceX]);

1Shot · February 7, 2019

@Banditulmda, nu cred ca o sa fiu in stare sa modific toate liniile ca in modelul tau... sunt 7 erori diferite...dar se repeta...sunt vreo 30 de linii de erori...

totusi daca l-as lasa asa cum e pe r39.3 ... nu am cum sa il fac sa mearga?... de ce naiba imi da crash...

Banditul · February 7, 2019

Da stiu, e mult de munca sa convertesti tot sistemul pe r40+ dar uneori merita.

Incearca sa folosesti mysql r34 sau r39-6 si vezi daca iti mai da crash. E destul de ciudat faptul ca da crash la mysql_connect

Problema pornire srv

Question

33 answers to this question

Recommended Posts

Create an account or sign in to comment

Create an account

Sign in

Similar Content

Recently Browsing 0 members

Important Information