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

4 answers to this question

Recommended Posts

andreiutzu961

vbicompany

andreiutzu961

vbicompany

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information