Problema baza de date

Marian Lucian · January 17, 2016

Buna si salutare tuturor , am si eu o problema am pus un gamemode si se conecteaza la baza de date dar cand intru in joc nu pot face cont , cum rezolv aceasta problema ?

Dau +1 la toti ce incearca sa ma ajute !

[12:18:17] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:17] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:20] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:20] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:23] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:23] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:24] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:24] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:25] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:25] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:26] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:26] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:28] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:28] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:29] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:29] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:30] [MySQL]: Un nou cont a fost creat in baza de date!(..)01
[12:18:30] [MySQL]: Un nou cont a fost creat in baza de date!(..)02
[12:18:31] [part] Tequilu has left the server (0:2)

Edited January 17, 2016 by Marian Lucian

Vespa97 · January 17, 2016

arata sys de reg

Marian Lucian · January 17, 2016

> MySQL plugin R6 successfully loaded.

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: sscanf.so
[12:34:23] 

[12:34:23]  ===============================

[12:34:23]       sscanf plugin loaded.     

[12:34:23]    (c) 2009 Alex "Y_Less" Cole

[12:34:23]    0.3d-R2 500 Players "dnee"

[12:34:23]  ===============================

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: streamer.so
[12:34:23] 

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

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: Whirlpool.so
[12:34:23]  
[12:34:23]  ==================
[12:34:23]  
[12:34:23]   Whirlpool loaded
[12:34:23]  
[12:34:23]  ==================
[12:34:23]  
[12:34:23]   Loaded.
[12:34:23]  Loaded 4 plugins.

[12:34:23] 
[12:34:23] Filterscripts
[12:34:23] ---------------
[12:34:23]   Loaded 0 filterscripts.

[12:34:23] [MYSQL]: Conectare la `tmpsbtzn_sampsrv` a avut succes!
[12:34:23] * Case citite: 0
[12:34:23] * Canale IRC citite: 10
[12:34:23] * Character killuri citite: 10
[12:34:23] * Ziare citite: 10
[12:34:23] * Bizzuri citite: 0
[12:34:23] * SBizzuri citite: 0
[12:34:23] * Teritorii citite: 0
[12:34:23] * Seifuri citite: 0
[12:34:23] * Masini personale citite: 0
[12:34:23] * DealerShips citite: 4
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * Pickup-uri citite: 45
[12:34:23]  
[12:34:23] -------------------------------
[12:34:23]            WORDFREND  RPG

Gireada · January 17, 2016

Aratane ce erori iti da in mysql_log

HeCt0r · January 17, 2016

ce gamemod este?

fă o poză la început unde este conectarea de la baza de date

Marian Lucian · January 17, 2016

Este gm BLOWN V3.0

ASTA ESTE SERVER_LOG.TXT

girada nu am mysql_log in filezila

Loaded log file: "server_log.txt".
----------

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

[12:34:23] filterscripts = ""  (string)
[12:34:23] 
[12:34:23] Server Plugins
[12:34:23] --------------
[12:34:23]  Loading plugin: mysql.so
[12:34:23] 

  > MySQL plugin R6 successfully loaded.

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: sscanf.so
[12:34:23] 

[12:34:23]  ===============================

[12:34:23]       sscanf plugin loaded.     

[12:34:23]    (c) 2009 Alex "Y_Less" Cole

[12:34:23]    0.3d-R2 500 Players "dnee"

[12:34:23]  ===============================

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: streamer.so
[12:34:23] 

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

[12:34:23]   Loaded.
[12:34:23]  Loading plugin: Whirlpool.so
[12:34:23]  
[12:34:23]  ==================
[12:34:23]  
[12:34:23]   Whirlpool loaded
[12:34:23]  
[12:34:23]  ==================
[12:34:23]  
[12:34:23]   Loaded.
[12:34:23]  Loaded 4 plugins.

[12:34:23] 
[12:34:23] Filterscripts
[12:34:23] ---------------
[12:34:23]   Loaded 0 filterscripts.

[12:34:23] [MYSQL]: Conectare la `tmpsbtzn_sampsrv` a avut succes!
[12:34:23] * Case citite: 0
[12:34:23] * Canale IRC citite: 10
[12:34:23] * Character killuri citite: 10
[12:34:23] * Ziare citite: 10
[12:34:23] * Bizzuri citite: 0
[12:34:23] * SBizzuri citite: 0
[12:34:23] * Teritorii citite: 0
[12:34:23] * Seifuri citite: 0
[12:34:23] * Masini personale citite: 0
[12:34:23] * DealerShips citite: 4
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * ID = 0 | Factiune = 0 | Alianta = 0
[12:34:23] * Pickup-uri citite: 45
[12:34:23]  
[12:34:23] -------------------------------
[12:34:23]            WORDFREND  RPG          
[12:34:23] -------------------------------
[12:34:23]      GameMode creator: lh-blog     
[12:34:23] 01/1/2016
[12:34:23] Number of vehicle models: 113
[13:00:01] The weather is changed.  [13:00:01]
[14:00:01] The weather is changed.  [14:00:01]

Edited January 17, 2016 by Marian Lucian

HeCt0r · January 17, 2016

vezi că ai în gm unde setezi baza de date

o altă conectare la baza de date unde scrii datele

ștergi /* și */

și le pui la datele de mai jos și scri acolo datele corecte.

/*=================================[DB]=================================*/
 #define SQL_HOST "ip" // date MySQL
 #define SQL_USER "user"
 #define SQL_PASS "pass"
 #define SQL_DB "db"
 
 #define GIFT_BOX 0 // 1 - activ | 0 - inactiv !

 /* #define SQL_HOST "localhost" // date MySQL
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "BLaZed" */

așa trebuie să arate

Marian Lucian · January 17, 2016

problema e ca nu se creaza conturile in baza de date , am facut un cont in baza de date si merge !

acum care e problema? dece nu creaza conturi in baza de date?

cineva sa ma ajute?

O fi din gamemode ?

oare asta sa nu fie pe 1 sau pe 0 ?


		if (newaccountsqlid != 1)

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

public OnPlayerRegister(playerid, password[]) 
{
	if(IsPlayerConnected(playerid))
	{
		MySQLCheckConnection();
		new playername3[MAX_PLAYER_NAME];
		GetPlayerName(playerid, playername3, sizeof(playername3));
		new newaccountsqlid = MySQLCreateAccount(playername3, password, playerid);
		if (newaccountsqlid != 0)
		{

Edited January 17, 2016 by Marian Lucian

Gireada · January 17, 2016

Pune

mysql_debug(1);

in functia ongamemodeinit

Marian Lucian · January 17, 2016

este 1 gireada !

Gireada · January 18, 2016

Si nu iti apare mysql log ?

Marian Lucian · January 18, 2016

Nu am in filezila mysql log deloc nuj ce drq sa ii fac!

Gireada · January 19, 2016

Pune in pastebin OnPlayerRegister adica partea mysql cu INSERT

Marian Lucian · January 19, 2016

Uitate tu putin prin el gireada si zimi care e problema !

Carbon.pwn

Marian Lucian · January 20, 2016

UP MA AJUTA CNV?

Marian Lucian · January 22, 2016

help?

Sign In

Problema baza de date

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Similar Content

Recently Browsing 0 members

Important Information