[zT KiNgKoNg]

pawn Код:

new EscapedText[64];
            mysql_real_escape_string(inputtext, EscapedText);
            format(Query,sizeof(Query),"INSERT INTO `Character_Data` (Character,Password,Ip,Gender,Age,OnHandCash,StaffLevel,HelperLevel,IsDonator,FactionID,FactionRank,FactionLeader,FactionBadge,GunLicenseDrivingLicense,HasBankAccount,BankBalance,ObtainedCredit,CreditBalance,OwnsHouse) VALUES('%s',md5('%s'),'0','0','0','0','0','0','0','0','0','0','None','0','0','0','0','0','0')",GetOriginalName(playerid),EscapedText);
            mysql_query(Query);
            mysql_free_result();

pawn Код:

[17:43:21] CMySQLHandler::Query(SELECT `Character` FROM `Character_Data` WHERE `Character` = 'Jason_Hall') - Successfully executed.

[17:43:21] >> mysql_store_result( Connection handle: 1 )

[17:43:21] CMySQLHandler::StoreResult() - Result was stored.

[17:43:21] >> mysql_num_rows( Connection handle: 1 )

[17:43:21] CMySQLHandler::NumRows() - Returned 0 row(s)

[17:43:21] >> mysql_free_result( Connection handle: 1 )

[17:43:21] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:43:25] >> mysql_real_escape_string( Connection handle: 1 )

[17:43:25] CMySQLHandler::EscapeString(7654); - Escaped 4 characters to 7654.

[17:43:25] >> mysql_query( Connection handle: 1 )

[17:43:25] CMySQLHandler::Query(INSERT INTO `Character_Data` (Character,Password,Ip,Gender,Age,OnHandCash,StaffLevel,HelperLevel,IsDonator,FactionID,FactionRank,FactionLeader,FactionBadge,GunLicenseDrivingLicense,HasBankAccount,BankBalance,ObtainedCredit,CreditBalance,OwnsHouse) VALUES('Jason_Hall',md5('7654'),'0','0','0','0','0','0','0','0','0','0','None','0','0','0','0','0','0')) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character,Password,Ip,Gender,Age,OnHandCash,StaffLevel,HelperLevel,IsDonator,Fac' at line 1)

[17:43:25] >> mysql_free_result( Connection handle: 1 )

[17:43:25] CMySQLHandler::FreeResult() - The result is already empty.

[17:43:26] >> mysql_query( Connection handle: 1 )

[17:43:26] CMySQLHandler::Query(UPDATE `Character_Data` SET `Gender` = '1'  WHERE `Character` = 'Jason_Hall') - Successfully executed.

[17:43:26] >> mysql_free_result( Connection handle: 1 )

[17:43:26] CMySQLHandler::FreeResult() - The result is already empty.

[17:43:26] >> mysql_query( Connection handle: 1 )

[17:43:26] CMySQLHandler::Query(UPDATE `Character_Data` SET `Age` = ''  WHERE `Character` = 'Jason_Hall') - Successfully executed.

[17:43:26] >> mysql_free_result( Connection handle: 1 )

[17:43:26] CMySQLHandler::FreeResult() - The result is already empty.

[17:43:26] >> mysql_query( Connection handle: 1 )

[17:43:26] CMySQLHandler::Query(SELECT * FROM `Character_Data` WHERE `Character` = 'Jason_Hall') - Successfully executed.

[17:43:26] >> mysql_store_result( Connection handle: 1 )

[17:43:26] CMySQLHandler::StoreResult() - Result was stored.

[17:43:26] >> mysql_fetch_row_format( Connection handle: 1 )

[17:43:26] >> mysql_free_result( Connection handle: 1 )

[17:43:26] CMySQLHandler::FreeResult() - Result was successfully free'd.

[zT KiNgKoNg]

Need help ASAP.

[WopsS]

pawn Код:

new EscapedText[64];
            mysql_real_escape_string(inputtext, EscapedText);
            format(Query,sizeof(Query),"INSERT INTO `Character_Data` (`Character`,`Password`,`Ip`,`Gender,Age`,`OnHandCash`,`StaffLevel`,`HelperLevel`,`IsDonator`,`FactionID`,`FactionRank`,`FactionLeader`,`FactionBadge`,`GunLicenseDrivingLicense`,`HasBankAccount`,`BankBalance`,`ObtainedCredit`,`CreditBalance`,`OwnsHouse`) VALUES('%s',md5('%s'),'0','0','0','0','0','0','0','0','0','0','None','0','0','0','0','0','0')",GetOriginalName(playerid),EscapedText);
            mysql_query(Query);
            mysql_free_result();

Try this!
But this

pawn Код:

GetOriginalName(playerid)

why you don't make with

pawn Код:

GetPlayerName

?