Probleme mari mysql R5

andreiutzu961 · April 15, 2013

Deci nu inteleg dc nu se conecteaza la baza lui de date .. :|

server_log

[pawn]----------

Loaded log file: "server_log.txt".

----------

SA-MP Dedicated Server

----------------------

[23:17:03]

[23:17:03] Server Plugins

[23:17:03] --------------

[23:17:03] Loading plugin: mysql.so

[23:17:03]

> MySQL plugin R5 successfully loaded.

[23:17:03] Loaded.

[23:17:03] Loading plugin: streamer.so

[23:17:03]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[23:17:03] Loaded.

[23:17:03] Loading plugin: sscanf.so

[23:17:03]

[23:17:03] ===============================

[23:17:03] sscanf plugin loaded.

[23:17:03] 0.3d-R2 500 Players "dnee"

[23:17:03] ===============================

[23:17:03] Loaded.

[23:17:03] Loaded 3 plugins.

[23:17:03]

[23:17:03] Filterscripts

[23:17:03] ---------------

[23:17:03] Loading filterscript 'Turf.amx'...

[23:17:03] Unable to load filterscript 'Turf.amx'.

[23:17:03] Loading filterscript 'SObjects.amx'...

[23:17:03] 1823 Dynamic Objects Loaded in 2 ms ~

[23:17:03] Loading filterscript 'time.amx'...

[23:17:03] Loading filterscript 'animlist.amx'...

[23:17:03] Loading filterscript 'fireworks.amx'...

[23:17:03] Loading filterscript 'anti_fk_kill.amx'...

[23:17:03]

----------------------------------------

[23:17:03] Anti FakeKill Flood FilterScript by RuNix

[23:17:03] ----------------------------------------

[23:17:03] Loaded 5 filterscripts.

[23:17:04] Datele din mysqlinfo.cfg au fost incarcate cu succes !

[23:17:04] Datele necesare pentru conectare au fost incarcate

[23:17:04]

[23:17:04] ------------------------------------------------------------------

[23:17:04] MYSQL: Incearca conectarea la server ...

[23:17:04] MYSQL: Eroare de conexiune, reconectare ...

[23:17:04] MYSQL: Nu s-a reusit reconectarea la server, se inchide server-ul...

[23:17:04] ------------------------------------------------------------------

[23:17:04]

[23:17:04] ------------------------------------------------------------------

[23:17:04] MYSQL: Conexiunea pare moarta, reincercam...

[23:17:04]

[23:17:04] ------------------------------------------------------------------

[23:17:04] MYSQL: Incearca conectarea la server ...

[23:17:04] MYSQL: Eroare de conexiune, reconectare ...

[23:17:04] MYSQL: Nu s-a reusit reconectarea la server, se inchide server-ul...

[23:17:04] ------------------------------------------------------------------

[23:17:04]

[23:17:04] MYSQL: Nu s-a reusit reconectarea la server, inchidem server-ul...

[23:17:04] ------------------------------------------------------------------

[23:17:04]

[23:17:04] 0 Houses Loaded

[23:17:04] 0 Bizz Loaded

[23:17:04] 0 SBusinesses Loaded

[23:17:04] Stuff loaded

[23:17:04] 0 IRC Channels Loaded

[23:17:04] 0 factiuni incarcate

[23:17:04] Leaders loaded

[23:17:04] Families loaded

[23:17:04] 0 turfs Loaded

[23:17:04] Papers loaded

[23:17:04] 0 Vehicles Loaded

[23:17:04]

[23:17:04] ======== Statistici: ========

[23:17:04]

[23:17:04] Vehicles [ 660]

[23:17:04] Objects: [ 77]

[23:17:04] Pickups: [ 147]

[23:17:04] Menu's: [ 32]

[23:17:04] Textdraws: [1645]

[23:17:04]

[23:17:04] ==== Sfarsitul statisticii ====

[23:17:04]

[23:17:04] Time taken to execute OnGameModeInit: 17 miliseconds

[23:17:04]

[23:17:04] Next-Level RPG

[23:17:04] _____________________

[23:17:04]

[23:17:04] [PAWN]: Vehicle Models 128 | Vehicles 660

[23:17:04] Number of vehicle models: 128

[23:17:04] --- Server Shutting Down.

[23:17:04] Next-Level RPG

[23:17:04]

> MySQL plugin unloaded.

[23:17:04]

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[23:17:04]

[23:17:04] ===============================[/pawn]

mysql log

[pawn][Mon Apr 15 19:25:47 2013] -------------------------

[Mon Apr 15 19:25:47 2013] Logging Started

[Mon Apr 15 19:25:47 2013] -------------------------

[Mon Apr 15 19:28:01 2013] -------------------------

[Mon Apr 15 19:28:01 2013] Logging Started

[Mon Apr 15 19:28:01 2013] -------------------------

[/pawn]

[pawn] new arrCoords[4][64],strFromFl[128];

new File: file = fopen("mysqlinfo.cfg", io_read);

if (file)

{

fread(file, strFromFl);

split(strFromFl, arrCoords, '|');

strmid(MYSQLHost, arrCoords[0], 0, strlen(arrCoords[0]), 255);

strmid(MYSQLUsername, arrCoords[1], 0, strlen(arrCoords[1]), 255);

strmid(MYSQLPassword, arrCoords[2], 0, strlen(arrCoords[2]), 255);

strmid(MYSQLDatabase, arrCoords[3], 0, strlen(arrCoords[3]), 255);

print("Datele din mysqlinfo.cfg au fost incarcate cu succes !");

fclose(file);

}

else print("Fisierul mysqlinfo.cfg lipseste din directorul Scriptfiles !");

return 1;

}[/pawn]

Deci cum trebuie sa trec in scriptfiles in acel fisier mysqlinfo.cfg

Eu am trecut asa [pawn]localhost| numele la baza de date| si pass[/pawn] e bine ??

andreiutzu961 · April 16, 2013

scz de dublu post dar nimeni ....... ?

vbicompany · April 16, 2013

Ar trebui sa ai in gamemode asa ceva

[pawn]#define SQL_HOST "hostsql" // date MySQL

#define SQL_USER "user"

#define SQL_PASS "password"

#define SQL_DB "name datebase"[/pawn]

si verifica daca toate sunt setate corect .

andreiutzu961 · April 16, 2013

[pawn]

public LoadSQLInfo()

{

new arrCoords[4][64],strFromFl[128];

new File: file = fopen("mysqlinfo.cfg", io_read);

if (file)

{

fread(file, strFromFl);

split(strFromFl, arrCoords, '|');

strmid(MYSQLHost, arrCoords[0], 0, strlen(arrCoords[0]), 255);

strmid(MYSQLUsername, arrCoords[1], 0, strlen(arrCoords[1]), 255);

strmid(MYSQLPassword, arrCoords[2], 0, strlen(arrCoords[2]), 255);

strmid(MYSQLDatabase, arrCoords[3], 0, strlen(arrCoords[3]), 255);

print("Datele din mysqlinfo.cfg au fost incarcate cu succes !");

fclose(file);

}

else print("Fisierul mysqlinfo.cfg lipseste din directorul Scriptfiles !");

return 1;

}

[/pawn]

La mine nu e asa la mine sunt facute sa , salveze in [pawn]scriptfiles[/pawn] dar din pacate cand il pornesc el spune ca merg pornesc dar defapt nu isi fac , conecsiunea

Poate ca nu le-am scris bn ......

eu le-am asa trecute .......

[pawn]

localhost|user la baza|password |iar username |si aici numele la baza adica cum o am io trecuta in PC.

[/pawn]

Mie un baiat mi-a umblat acolo mai de mult si mi-a mers cred ca nu am aranjat bn eu .......

vbicompany · April 16, 2013

Vezi aici http://wiki.sa-mp.com/wiki/Mysql_tutorial

Sign In

Probleme mari mysql R5

Question

andreiutzu961

Link to comment

Share on other sites

4 answers to this question

Recommended Posts

andreiutzu961

Link to comment

Share on other sites

vbicompany

Link to comment

Share on other sites

andreiutzu961

Link to comment

Share on other sites

vbicompany

Link to comment

Share on other sites

Similar Content

problema mare

salut am o problema mare rau

Cerere sistem de salvare mysql.

Problema burned

Problema turf

Recently Browsing 0 members

Browse

Activity

Important Information