Cum pun un GM care ruleaza pe Mysql pe host

[HuZuM]

Am umploadat baza de date si cred k am facut bine legatura intre host si baza de date,dar cand intru in samp la mode imi apare Unknown.

[alexandruui]

da-mi pm cu id-u tau sa ti-l fac , si eu am avut gm-u asta .. rg... e plin de buguri ) !

S-ar putea sa fie din GM dar mai sigur din pluginuri.. Incearca sa si updatezi pluginurile .. Pe toate

[HuZuM]

Le-am updatat,cred k este din GM,asa cred eu

[alexandruui]

Le-am updatat,cred k este din GM,asa cred eu

Uitete in Gm si vezi acolo unde ai #include

Vezi daca ai in folderul Plugins toate ce scrie in Gm .. Poate sa fie in Gm in Plus un plugin.. Si trebuie sa il pui in folderul Plugins

[HuZuM]

Asta am in gm :

#include <a_samp> // 1

#include <sscanf2> // 2

#include <a_mysql> // 3

#include <foreach> // 4

#include <utils> // 5

#include <a_npc> // 6

#include <k_functions> // 7

#include <streamer> // 8

#include    <numbers> // 9

...si in folderul plugin am streamer.so mysql.so sscanf.so

[alexandruui]

Si aratami si in server.cfg tot ce ai

[HuZuM]

uite

echo Executing Server Config...

lanmode 0

rcon_password zxcvbnm

maxplayers 50

port 7777

hostname BestGaming[RPG]

gamemode0 rggm

filterscripts

plugins mysql.so sscanf.so streamer.so

announce 0

query 1

weburl www.sa-mp.com

onfoot_rate 40

incar_rate 40

weapon_rate 40

stream_distance 300.0

stream_rate 1000

maxnpc 10

logtimeformat [%H:%M:%S]

[RaZVaN ^ xD]

Adauga si plugin-ul nativechecker si revino cu server.log .

[HuZuM]

L-am adaugat si tot nu merge:(..am postat mai sus

[HuZuM]

Astes ma ajuti..k te astept de 2 saptamani ,ori postezi sa ma ajuti,ori sa te afli in treaba:(

[RaZVaN ^ xD]

Adauga si plugin-ul nativechecker si revino cu server.log .

[alexandruui]

Adauga si plugin-ul nativechecker si revino cu server.log .

L-a adaugat.. are problema cu mysql .. si libraria mysql.. Trebuie sa reinstaleze mysql

[HuZuM]

Am reinstalat dar vad k imi mai da 4 erori si nush ce tre sa ac:(

----------

Loaded log file: "server_log.txt".

----------

SA-MP Dedicated Server

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

v0.3e-R2, ©2005-2012 SA-MP Team

[23:19:36] filterscripts = ""  (string)

[23:19:36]

[23:19:36] Server Plugins

[23:19:36] --------------

[23:19:36]  Loading plugin: mysql.so

[23:19:36]  SA:MP MySQL Plugin v2.1.1 Loaded.

[23:19:36] [MySQL] Thread running. Threadsafe: Yes.

[23:19:36]  Loaded.

[23:19:36]  Loading plugin: sscanf.so

[23:19:36]

[23:19:36]  ===============================

[23:19:36]      sscanf plugin loaded.   

[23:19:36]    © 2009 Alex "Y_Less" Cole

[23:19:36]    0.3d-R2 500 Players "dnee"

[23:19:36]  ===============================

[23:19:36]  Loaded.

[23:19:36]  Loading plugin: streamer.so

[23:19:36]

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

[23:19:36]  Loaded.

[23:19:36]  Loading plugin: nativechecker.so

[23:19:36]  Loaded.

[23:19:36]  Loaded 4 plugins.

[23:19:36]

[23:19:36] Ban list

[23:19:36] --------

[23:19:36]  Loaded: samp.ban

[23:19:36]

[23:19:36]

[23:19:36] Filterscripts

[23:19:36] ---------------

[23:19:36]  Loaded 0 filterscripts.

[23:19:36]    Error: Function not registered: 'mysql_fetch_row_format'

[23:19:36]    Error: Function not registered: 'mysql_reconnect'

[23:19:36]    Error: Function not registered: 'mysql_fetch_field_row'

[23:19:36]    Error: Function not registered: 'mysql_debug'

[23:19:36] Script[gamemodes/rggm.amx]: Run time error 19: "File or function is not found"

[23:19:36] Number of vehicle models: 0

[HuZuM]

Spunetimi si mie ce trebuie sa fac k sa nu mai apara erorile>?

[alexandruui]

iati tot pachetul mysql.. si introdul tot . adica si fisierul mysql in pawno  -> plugins.. Trebuie sa il iei cu totul.. nu numai mysql.so sau mysql.dll

[HuZuM]

imi poti da tu site de unde sa iau tot pachetul te rog mult:\

[alexandruui]

http://forum.sa-mp.com/showthread.php?t=122983

Acum .. sper sa stii ceva engleza .. Te uiti cam pe la mijloc si dai de download

Citeste pas cu pas .. Ca sa intelegi ce ai gresit

P.S: Acolo explica tot.. Chiar si pentru host.. Iti da si un pachet special pentru host acolo

[HuZuM]

Nush ce sa downloadez ....sunt pfff,...:(

[HuZuM]

tot de pe siteul asta a downloadat si eu Static Linux Distributions (Use on Hosted Servers e.g. ServerFFS),si am  bagat in include ,plugin dar..tot 4 erori imi da

[alexandruui]

Ai citit asta?? :

How To Install:

    Windows:

        Download the plugin.

        Place the mysql.dll in your plugins folder, and move libmysql.dll to the same directory the server exe is.

        Open your server.cfg and add "mysql" to "plugins", if there is no "plugins" line, add one.

        Add mysql.inc to your /pawno/includes/ and add "#include <mysql>" to the top of your script.

    Linux:

        Download the plugin to your linux server.

        Place the mysql.so in your plugins folder.

        Open your server.cfg and add "mysql.so" to "plugins", if there is no "plugins" line, add one.

        On the PC that you compile your script on, add mysql.inc to your /pawno/includes/ and add "#include <mysql>" to the top of your script.

RESPECTA TOTI PASII !! .. !!!!!![ VEZI CA LINUX INSEAMNA HOSTU .. UNDE AI HOSTU .. EI MERG PE LINUX]!!!!!!

Sper ca intelegi engleza nu?

P.S: incearca sa downloadezi mysql pentru windows de acolo.. si aplica toate fisierele.. Si incearca la tine pe PC si vezi daca merge

[HuZuM]

Pe pc merge

[alexandruui]

Acum punel pe host.. Si urmeaza pasii de la Linux.. Pasii care ti i-am dat..  :cheesy:

[SkiZzo123]

Va rog frumos sa ma scuzati ca deschid un topic din 1900 toamna..

Dar am aceasi problema si nu stiu cum sa o rezolv..

Server_log

----------

Loaded log file: "server_log.txt".

----------

SA-MP Dedicated Server

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

v0.3z, ©2005-2014 SA-MP Team

[23:14:33]

[23:14:33] Server Plugins

[23:14:33] --------------

[23:14:33]  Loading plugin: mysql.so

[23:14:33]  Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)

[23:14:33]  Loading plugin: sscanf.so

[23:14:33]

[23:14:33]  ===============================

[23:14:33]      sscanf plugin loaded.   

[23:14:33]    © 2009 Alex "Y_Less" Cole

[23:14:33]    0.3d-R2 500 Players "dnee"

[23:14:33]  ===============================

[23:14:33]  Loaded.

[23:14:33]  Loading plugin: streamer.so

[23:14:33]

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

[23:14:33]  Loaded.

[23:14:33]  Loading plugin: Whirlpool.so

[23:14:33] 

[23:14:33]  ==================

[23:14:33] 

[23:14:33]  Whirlpool loaded

[23:14:33] 

[23:14:33]  ==================

[23:14:33] 

[23:14:33]  Loaded.

[23:14:33]  Loaded 3 plugins.

[23:14:33]

[23:14:33] Ban list

[23:14:33] --------

[23:14:33]  Loaded: samp.ban

[23:14:33]

[23:14:33]

[23:14:33] Filterscripts

[23:14:33] ---------------

[23:14:33]  Loading filterscript 'anti-fake-killer.amx'...

[23:14:33]

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

[23:14:33]  Anti Fake-Killer | Creation date: 01.12.2012 | Autor: DMC |

[23:14:33] ---------------------------------------------------------------

[23:14:33]  Loading filterscript 'anti-spam.amx'...

[23:14:33]

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

[23:14:33]  Anti Spam Flood | Creation date: 01.12.2012 | Autor: DMC |

[23:14:33] ---------------------------------------------------------------

[23:14:33]  Loading filterscript 'artificii.amx'...

[23:14:33]

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

[23:14:33]  Artificii | Creation date: 01.12.2012 | Autor: DMC |

[23:14:33] ---------------------------------------------------------------

[23:14:33]  Loading filterscript 'brad-de-craciun.amx'...

[23:14:33]

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

[23:14:33]  Brad de craciun | Creation date: 01.12.2012 | Autor: DMC |

[23:14:33] ---------------------------------------------------------------

[23:14:33]  Loading filterscript 'laser-la-arme.amx'...

[23:14:33]

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

[23:14:33]  Laser la arme | Creation date: 01.12.2012 | Autor: DMC |

[23:14:33] ---------------------------------------------------------------

[23:14:33]  Loading filterscript 'anti-flood.amx'...

[23:14:33]  Loading filterscript 'anti-boot.amx'...

[23:14:33]  Unable to load filterscript 'anti-boot.amx'.

[23:14:33]  Loading filterscript 'vae.amx'...

[23:14:33]  Loading filterscript 'basket.amx'...

[23:14:33]  Loaded 8 filterscripts.

[23:14:33] Script[gamemodes/xsz.amx]: Run time error 19: "File or function is not found"

[23:14:33] Number of vehicle models: 0

Imi spune exact ca la el la Gamemode: Unknown...

[monster010]

Iti pare la gamemode "Unknow" deoarece nu este bine pus/facut un plugin. Verfica la sange tot ce ar contine pluginurile tale.

PS: Daca ai serverul pe LINUX, pune in server.cfg la sfarsit .so (exmeplu: streamer.so)

=========================================================================================

Va rog frumos sa ma scuzati ca deschid un topic din 1900 toamna..

Dar am aceasi problema si nu stiu cum sa o rezolv..

Server_log

Imi spune exact ca la el la Gamemode: Unknown...

Ori nu ai xsz in folderul gamemodes, ori nu ai pus un plugin bine. Verifica bine.

[SkiZzo123]

Am inteles de la cnv ca trebuie host mySQL de la server.. nu din alta parte.. Sa nu fac reclama www.sa-mp.ro ofera servicii mySQL.. cica nu merge..

[monster010]

Trebuie definita baza mysql in gamemode

[pawn]

#define SQL_HOST "localhost"

#define SQL_USER "root"

#define SQL_PASS ""

#define SQL_DB "DB_NAME"

[/pawn]

Si alte linii........