[HELP]MySql create account

[boban88]

hello i need help with my script.

I have register via MySql but when i use /reg on server than server answer me login sucessfull but DB is empty. My line:

mysql_query( database, "INSERT INTO accounts (log,pass,serial,name,points,money,wins,second,third,hunters,alevel,kills,score,playtime,deaths,matches,days,hours,minutes ) VALUES ('" .. username .. "','" .. password .. "', '" .. serial .. "', '" .. name .. "','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1' )" ) 

and i have this:

database = mysql_connect( "localhost", "root", "pass", "db" )  
if database then 
    outputDebugString ('Connect') 
else 
    outputDebugString ("Nothing") 
end 

and console answer me: Connect.

I have not idea why this not working. Thanks for every answer.

[xXMADEXx]

You should use the MTA SQL functions.

I'm not sure if mysql_query sends any errors, but in debugscript are there any errors or warnings?

[boban88]

no 0 errors 0 warnings and i need mysql and before 1 year this script works perfect i dont know why now is broken...

[xXMADEXx]

no 0 errors 0 warnings and i need mysql and before 1 year this script works perfect i dont know why now is broken...

Are you sure the accounts table exists in the database? If so, do all the columns match up?

Try using dbConnect/dbExec, they have better debugging features than the MySQL modules does.

[boban88]

here is DB 2 lines with name pass and log bul bul is tested via command INSERT but not from server. I create test.sql and import it to DB.

EDIT: here is screen normal http://opatrovatelka-no.sk/images/here.png

[boban88]

oh im idiot i fix it i have shuffled rows in command sry but thank you guy