Skripta koju koristim: NLRPG Mod
Detaljan opis problema: Jednostavno ne mogu da povezem sa mysql databazom.Dakle iz phpmyadmina sam napravio databazu,importovao sql,povezao sa gamemodom,kompilovao,i daje istu gresku.
Evo deo loga..
SA-MP Dedicated Server
----------------------
v0.3d-R2, (C)2005-2011 SA-MP Team
[17:14:49] filterscripts = "" (string)
[17:14:49]
[17:14:49] Server Plugins
[17:14:49] --------------
[17:14:49] Loading plugin: nativechecker.so
[17:14:49] Loaded.
[17:14:49] Loading plugin: streamer.so
[17:14:49]
*** Streamer Plugin v2.6.1 by Incognito loaded ***
[17:14:49] Loaded.
[17:14:49] Loading plugin: sscanf.so
[17:14:49]
[17:14:49] ===============================
[17:14:49] sscanf plugin loaded.
[17:14:49] (c) 2009 Alex "Y_Less" Cole
[17:14:49] 0.3d-R2 500 Players "dnee"
[17:14:49] ===============================
[17:14:49] Loaded.
[17:14:49] Loading plugin: regex.so
[17:14:49]
[17:14:49] ______________________________________
[17:14:49] Regular Expression Plugin v0.2.0 loaded
[17:14:49] ______________________________________
[17:14:49] By: Fro (c) Copyright <TBG> 2009-2011
[17:14:49] ______________________________________
[17:14:49] Loaded.
[17:14:49] Loading plugin: Whirlpool.so
[17:14:49]
[17:14:49] ==================
[17:14:49]
[17:14:49] Whirlpool loaded
[17:14:49]
[17:14:49] ==================
[17:14:49]
[17:14:49] Loaded.
[17:14:49] Loading plugin: MapAndreas.so
[17:14:49] Loaded.
[17:14:49] Loading plugin: mysql.so
[17:14:49] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[17:14:49] Loaded 6 plugins.
[17:14:49]
[17:14:49] Ban list
[17:14:49] --------
[17:14:49] Loaded: samp.ban
[17:14:49]
[17:14:49]
[17:14:49] Filterscripts
[17:14:49] ---------------
[17:14:49] Loaded 0 filterscripts.
[17:14:49] Error: Function not registered: 'Streamer_CallbackHook'
[17:14:49] Error: Function not registered: 'SSCANF_Init'
[17:14:49] Error: Function not registered: 'SSCANF_Join'
[17:14:49] Error: Function not registered: 'SSCANF_Leave'
[17:14:49] Error: Function not registered: 'TextDrawSetSelectable'
[17:14:49] Error: Function not registered: 'SelectTextDraw'
[17:14:49] Error: Function not registered: 'CancelSelectTextDraw'
[17:14:49] Error: Function not registered: 'mysql_debug'
[17:14:49] Error: Function not registered: 'Streamer_VisibleItems'
[17:14:49] Error: Function not registered: 'MapAndreas_Init'
[17:14:49] Error: Function not registered: 'mysql_query'
[17:14:49] Error: Function not registered: 'CreateDynamicObject'
[17:14:49] Error: Function not registered: 'CreateDynamicPickup'
[17:14:49] Error: Function not registered: 'CreateDynamic3DTextLabel'
[17:14:49] Error: Function not registered: 'mysql_close'
[17:14:49] Error: Function not registered: 'MoveDynamicObject'
[17:14:49] Error: Function not registered: 'MapAndreas_FindZ_For2DCoord'
[17:14:49] Error: Function not registered: 'mysql_reconnect'
[17:14:49] Error: Function not registered: 'mysql_ping'
[17:14:49] Error: Function not registered: 'WP_Hash'
[17:14:49] Error: Function not registered: 'regex_match'
[17:14:49] Error: Function not registered: 'mysql_real_escape_string'
[17:14:49] Error: Function not registered: 'sscanf'
[17:14:49] Error: Function not registered: 'mysql_store_result'
[17:14:49] Error: Function not registered: 'mysql_num_rows'
[17:14:49] Error: Function not registered: 'mysql_free_result'
[17:14:49] Error: Function not registered: 'mysql_fetch_row_format'
[17:14:49] Error: Function not registered: 'mysql_fetch_int'
[17:14:49] Error: Function not registered: 'mysql_connect'
[17:14:49] Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[17:14:49] Error: Function not registered: 'DestroyDynamicPickup'
[17:14:49] Script[gamemodes/NLRPGv3.amx]: Run time error 19: "File or function is not found"
[17:14:49] Number of vehicle models: 0
Slika mysql
(http://img853.imageshack.us/img853/6233/6becea654bb84a41beb71d3.png)
Otaj mod je ovdje zabranjen tako da ce ti lockat temu problem ti je jesil mjenjo ovo
#define MYSQL_HOST "localhost" // kucni host a placeni ima IP
#define MYSQL_USER "root" // ime korisnika baze, na xamppu i localu je to uvijek "root" a na kupljenom hostu, kreirate sami usera i bazu
#define MYSQL_PASS "" // PASWORD baze, na localhostu nema passworda za mysql baze, a naravno na kupljenom stavite koji želite
#define MYSQL_DB "test" //IME baze
Jesam promenio sam u gamemodu.
I compilovao.
Posto vidim da je kucni a ne placeni server onda jednostavno skines Wamp ili xamp
Mod: http://www.4shared.com/rar/YrmxPMyq/Burek.html?
test.sql importujes na phpmyadmin i to je to
i pokrenes otaj mod gore
tako da ti nece imati problema
Ma ja hocu na serveru da pokrenem,na kucnom mi radi :)
Eh,onda imas placenu WEBHost
domenu itd..
Cpanel odes u phpmyadmin
Crate datebase Name stavi "test"
importujes Test
u postavkama u phpmyadminu popravis IP Servera stavis ime DB
Password i sve to
onda posto je masina linux od Hosta
uradis ovo
pitas hostera koja je masina CentOs,Debian ili Unbunt(mislim da sam pogresno napiso unbunt)
i trazis plugine nadjes u server.cf postavis sve plugine .so
i moraju biti updateovani plugini
u NL modu streamer nije pravi tako da ga moras updateovati jer ti se kapije lete .
Sscanf
mysql r6 je zadnji plugin sve mi se cini
streamer sscanf regex Whirlpool mysql MapAndreas Audio //Audio i netreba ali eto
Sve ti pluginovi ti trebaju svi ti moraju stojat
streamer sscanf.so regex.so Whirlpool.so mysql.so MapAndreas.so
Moraju biti updatevani ako nisu nema nista onda 8)
CitatFailed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[17:14:49] Loaded 6 plugins.
vidi vidi eto
Update sve plugine što imaš, skini svaki .so ako je Linux server. Nakon toga bi trebalo proraditi , ako je baza dobro spojena. :)