[aRoach]

Well guys, I need some help about this:

pawn Код:

new Query[ 129 ];
format( Query, 129, "INSERT INTO `Banlist` VALUES('%s','%s','%s','%s','%s')", GetPlayerIpEx( u_P ), pName( u_P ), s_R, pName( playerid ), Date( ) );
db_query( g_dbKeptAlive, Query );

It doesn't put the information in the DB...

-----------

I've tried this too:

pawn Код:

new Query[ 129 ];
format( Query, 129, "INSERT INTO Banlist(`IP`, `Name`, `Reason`, `Admin`, `BanDate`) VALUES('%s', '%s', '%s', '%s', '%s')", GetPlayerIpEx( u_P ), pName( u_P ), s_R, pName( playerid ), Date( ) );
db_query( g_dbKeptAlive, Query );

-----------

So, please.. Help me!

[blank.]

In the debug output, does the query cut out?

[aRoach]

The same thing, when I try to do It in the SQL Manager with some random Values it Works...

[[MG]Dimi]

pawn Код:

new Query[ 129 ];
format( Query, 129, "INSERT INTO `Banlist` (`IP`, `Name`, `Reason`, `Admin`, `BanDate`) VALUES ('%s', '%s', '%s', '%s', '%s')", GetPlayerIpEx( u_P ), pName( u_P ), s_R, pName( playerid ), Date( ) );
db_query( g_dbKeptAlive, Query );

Column and Table name inside `` and values inside ' '. When using INSERT INTO you must define Columns in which to store values before giving values.

[aRoach]

The same thing, I've used this first but... no result..

[Edvin]

probably is the dialogid ... other function works on it?

[aRoach]

The dialog works fine lol...
And yes, the other functions works fine...

[blank.]

Quote:

Originally Posted by [MG]Dimi pawn Код: new Query[ 129 ]; format( Query, 129, "INSERT INTO `Banlist` (`IP`, `Name`, `Reason`, `Admin`, `BanDate`) VALUES ('%s', '%s', '%s', '%s', '%s')", GetPlayerIpEx( u_P ), pName( u_P ), s_R, pName( playerid ), Date( ) ); db_query( g_dbKeptAlive, Query ); Column and Table name inside `` and values inside ' '. When using INSERT INTO you must define Columns in which to store values before giving values.

That doesn't make any difference,
OP, does the query cut out on debug output?

[Edvin]

Oh, i got it xD

Try to increase the new Query ... in:

Код:

new Query[ 256 ];

Try now ^^, shut work now

[[MG]Dimi]

Quote:

Originally Posted by blank. That doesn't make any difference, OP, does the query cut out on debug output?

Trust me that it does since 90% of time MySQL (or SQLLite) return Error in SQL Synatx.