Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:26:46 POSLE PODNE

Naslov: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:26:46 POSLE PODNE
Problem (error/warning): Kako da pokrenem sada mod kada dobijem nesto ovako, tacnije kada spojim MYSQL sa bazom? Prvi put mi je ovo da radim, cak sam i ovo jedva uradio! :D https://imgur.com/a/JWvXOd1
Deo skripte: //
Debug iz server_log (ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema (obavezno ako je ingame problem): //
Naslov: Odg: Oko MYSQL moda!
Poruka od: trifun poslato April 15, 2020, 23:28:04 POSLE PODNE
https://balkan-samp.com/forum/index.php?topic=24981.0
Naslov: Odg: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:29:22 POSLE PODNE
Citat: Trysha poslato April 15, 2020, 23:28:04 POSLE PODNE
https://balkan-samp.com/forum/index.php?topic=24981.0
To je sve uradjeno, ali kako sad da ga pokrenem?
Naslov: Odg: Oko MYSQL moda!
Poruka od: dazer poslato April 15, 2020, 23:35:20 POSLE PODNE
Citat: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:29:22 POSLE PODNE
To je sve uradjeno, ali kako sad da ga pokrenem?
Ako si spojio gm sa tom bazom, samo pokrenes server
Naslov: Odg: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:38:56 POSLE PODNE
Citat: Miki11 poslato April 15, 2020, 23:35:20 POSLE PODNE
Ako si spojio gm sa tom bazom, samo pokrenes server
https://imgur.com/a/04GxgrN
Naslov: Odg: Oko MYSQL moda!
Poruka od: trifun poslato April 15, 2020, 23:42:29 POSLE PODNE
Server Log ?
Naslov: Odg: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:45:35 POSLE PODNE
Citat: Trysha poslato April 15, 2020, 23:42:29 POSLE PODNE
Server Log ?
Isto je i u server logu... Da ne treba nesto datebase negde u server.cfg da se upise?
[pawn]
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[00:31:32] filterscripts = ""  (string)
[00:31:32]
[00:31:32] Server Plugins
[00:31:32] --------------
[00:31:32]  Loading plugin: crashdetect
[00:31:32]   CrashDetect plugin 4.19.4
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: mysql
[00:31:32]  >> plugin.mysql: R41-4 successfully loaded.
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: sscanf
[00:31:32]

[00:31:32]  ===============================

[00:31:32]       sscanf plugin loaded.     

[00:31:32]          Version:  2.8.1       

[00:31:32]    (c) 2012 Alex "Y_Less" Cole 

[00:31:32]  ===============================

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: streamer
[00:31:32]

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

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: pawnraknet
[00:31:32] Pawn.RakNet plugin v1.3.0 by urShadow has been loaded
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: pawncmd
[00:31:32] Pawn.CMD plugin v3.1.4 by urShadow loaded
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: CRP
[00:31:32]

[00:31:32] ______________________________________

[00:31:32]  Convert Rus To Pwn v0.1.1 loaded
[00:31:32] ______________________________________

[00:31:32]  By: Fro (c) Copyright <TBG> 2009-2011
[00:31:32] ______________________________________

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: regex
[00:31:32]


[00:31:32] ______________________________________


[00:31:32]  Regular Expression Plugin v0.2.1 loaded
[00:31:32] ______________________________________


[00:31:32]  By: Fro (c) Copyright <TBG> 2009-2011
[00:31:32] ______________________________________


[00:31:32]   Loaded.
[00:31:32]  Loaded 8 plugins.

[00:31:32]
[00:31:32] Filterscripts
[00:31:32] ---------------
[00:31:32]   Loaded 0 filterscripts.

[00:31:32] [Nex-AC] Îøèáêà ñîçäàíèÿ/îòêðûòèÿ nex-ac_settings.cfg!
[00:31:32] 
[00:31:32] --------------------------------------
[00:31:32]  Àíòè÷èò çàãðóæåí!
[00:31:32]  Âåðñèÿ àíòè÷èòà: 1.9.40
[00:31:32] 
[00:31:32] --------------------------------------

[00:31:32] Ïîäêëþ÷åíèå ê áàçå `datebase` íå óñïåøíî!
[00:31:32] Number of vehicle models: 0
[/pawn]
Naslov: Odg: Oko MYSQL moda!
Poruka od: trifun poslato April 15, 2020, 23:49:18 POSLE PODNE
Citat: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:45:35 POSLE PODNE
Isto je i u server logu... Da ne treba nesto datebase negde u server.cfg da se upise?
[pawn]
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[00:31:32] filterscripts = ""  (string)
[00:31:32]
[00:31:32] Server Plugins
[00:31:32] --------------
[00:31:32]  Loading plugin: crashdetect
[00:31:32]   CrashDetect plugin 4.19.4
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: mysql
[00:31:32]  >> plugin.mysql: R41-4 successfully loaded.
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: sscanf
[00:31:32]

[00:31:32]  ===============================

[00:31:32]       sscanf plugin loaded.     

[00:31:32]          Version:  2.8.1       

[00:31:32]    (c) 2012 Alex "Y_Less" Cole 

[00:31:32]  ===============================

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: streamer
[00:31:32]

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

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: pawnraknet
[00:31:32] Pawn.RakNet plugin v1.3.0 by urShadow has been loaded
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: pawncmd
[00:31:32] Pawn.CMD plugin v3.1.4 by urShadow loaded
[00:31:32]   Loaded.
[00:31:32]  Loading plugin: CRP
[00:31:32]

[00:31:32] ______________________________________

[00:31:32]  Convert Rus To Pwn v0.1.1 loaded
[00:31:32] ______________________________________

[00:31:32]  By: Fro (c) Copyright <TBG> 2009-2011
[00:31:32] ______________________________________

[00:31:32]   Loaded.
[00:31:32]  Loading plugin: regex
[00:31:32]


[00:31:32] ______________________________________


[00:31:32]  Regular Expression Plugin v0.2.1 loaded
[00:31:32] ______________________________________


[00:31:32]  By: Fro (c) Copyright <TBG> 2009-2011
[00:31:32] ______________________________________


[00:31:32]   Loaded.
[00:31:32]  Loaded 8 plugins.

[00:31:32]
[00:31:32] Filterscripts
[00:31:32] ---------------
[00:31:32]   Loaded 0 filterscripts.

[00:31:32] [Nex-AC] Îøèáêà ñîçäàíèÿ/îòêðûòèÿ nex-ac_settings.cfg!
[00:31:32] 
[00:31:32] --------------------------------------
[00:31:32]  Àíòè÷èò çàãðóæåí!
[00:31:32]  Âåðñèÿ àíòè÷èòà: 1.9.40
[00:31:32] 
[00:31:32] --------------------------------------

[00:31:32] Ïîäêëþ÷åíèå ê áàçå `datebase` íå óñïåøíî!
[00:31:32] Number of vehicle models: 0
[/pawn]
jesi li definisao bazu ?
#define SQL_DATA "[IME DATA BAZE]
Naslov: Odg: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 15, 2020, 23:54:06 POSLE PODNE
Citat: Trysha poslato April 15, 2020, 23:49:18 POSLE PODNE
jesi li definisao bazu ?
#define SQL_DATA "[IME DATA BAZE]
Nisam evo sta ima:
[pawn]// CONNECT
#define hosted

#if defined hosted
#define mysql_host           "localhost"
#define mysql_user           "root"
#define mysql_pass           ""
#define mysql_db               "datebase"

#endif

#if defined localhost

#define mysql_host           "localhost"
#define mysql_user           "root"
#define mysql_pass           ""
#define mysql_db               "datebase"

#endif
[/pawn]
Definisao sam i to, ali nece opet.
Naslov: Odg: Oko MYSQL moda!
Poruka od: Ukson Amigoss poslato April 15, 2020, 23:58:13 POSLE PODNE
Telefon sam i ne vidim bas dobro al koliko ki se cini ime baze nidi napisao kao sto je definisano u modu
Naslov: Odg: Oko MYSQL moda!
Poruka od: ʙᴜsᴛᴇʀ ᴄᴏɴɴᴇʟʟʏ poslato April 16, 2020, 00:01:10 PRE PODNE
Citat: n0nE poslato April 15, 2020, 23:58:13 POSLE PODNE
Telefon sam i ne vidim bas dobro al koliko ki se cini ime baze nidi napisao kao sto je definisano u modu
To brate moj, nije trebalo datebase vec sampbaza sa kojom sam definisao bazu... :D