Jump to content
  • 0

Problema pornire srv


1Shot

Question

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.

Link to comment
Share on other sites

Recommended Posts

  • 0

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

Citat
Link to comment
Share on other sites

  • 0

ce versiune de mysql folosesti?

Citat
Link to comment
Share on other sites

  • 0

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

Citat
Link to comment
Share on other sites

  • 0

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

Citat
Link to comment
Share on other sites

  • 0

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 by 1Shot
Link to comment
Share on other sites

  • 0

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

cache_get_value_int
cache_get_value_float
...

 

Citat
Link to comment
Share on other sites

  • 0
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

Link to comment
Share on other sites

  • 0
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 ? ...

 

Link to comment
Share on other sites

  • 0

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

Citat
Link to comment
Share on other sites

  • 0

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

Citat
Link to comment
Share on other sites

  • 0

@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 by 1Shot
Link to comment
Share on other sites

  • 0

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

  • Upvote 1
Citat
Link to comment
Share on other sites

  • 0

@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 by 1Shot
Link to comment
Share on other sites

  • 0
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]);	

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.