SA-MP Forums Archive
Weird Bug for mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Weird Bug for mysql (/showthread.php?tid=554988)


Weird Bug for mysql - DavidLuango - 06.01.2015

I'm currently facing the bug that I've never faced before.

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "database"

is my DB connect information. But for some reason gamemode works completely fine and was working fine until last night.

So when I register in-game (The account gets saved) I don't know where but it does. But it doesnt get saved in my localhost but some other database.
Because when I relog ig says my account is registered and asks me to login.

Anyone has faced this type of situation? if so please assist me. Thank you.

Re: Weird Bug for mysql - DavidLuango - 06.01.2015

Anyone?

Re: Weird Bug for mysql - Sew_Sumi - 06.01.2015

How do you know it's not being saved on your localhost?

Re: Weird Bug for mysql - cyberlord - 06.01.2015

i think if u are using some1 gm it might by saved in script file in db or ini dile

Re : Weird Bug for mysql - MCZOFT - 06.01.2015

from my knowledge in mysql .. go to register dialog and tell me what is there after it

you'll see something like

INSET INTO ... where 'username' ......


if you dident find it , try Debuging your MYSQL mode

comment the info of your database

PHP код:
/#define SQL_HOST "127.0.0.1"
//#define SQL_USER "root"
//#define SQL_PASS    ""
//#define SQL_DB "database" 
compile , if he told you there is an error or something .... go under
PHP код:
public OnGameModeInit() 
search for your MYSQL_connect it's formed like this mysql_connect(host,user,pass,db); if it's correct , debug the register system by commenting the lines each one to see where is the bug


otherwise , if you're using a gamemode of someone from samp .. tell me the name i can test it with u

Re: Re : Weird Bug for mysql - DavidLuango - 07.01.2015

Quote:
Originally Posted by MCZOFT
Посмотреть сообщение
from my knowledge in mysql .. go to register dialog and tell me what is there after it

you'll see something like

INSET INTO ... where 'username' ......


if you dident find it , try Debuging your MYSQL mode

comment the info of your database

PHP код:
/#define SQL_HOST "127.0.0.1"
//#define SQL_USER "root"
//#define SQL_PASS    ""
//#define SQL_DB "database" 
compile , if he told you there is an error or something .... go under
PHP код:
public OnGameModeInit() 
search for your MYSQL_connect it's formed like this mysql_connect(host,user,pass,db); if it's correct , debug the register system by commenting the lines each one to see where is the bug


otherwise , if you're using a gamemode of someone from samp .. tell me the name i can test it with u
My gamemode is one hundered percent made off scratch.

I know that my accounts are saving in some other host because - 1. When I register and relog it asks me to login instead of registering.

My DB info is exactly localhost, it doesn't work

Re: Weird Bug for mysql - DavidLuango - 07.01.2015

Any solution guys?