17.09.2013, 11:56
Код:
[18:54:21] [part] TESTTTTT_S has left the server (0:0) [18:54:21] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1) [18:54:21] [MySQL] Check /logs/querydump.log to review the query that threw the error. [18:54:21] Dumping query from 2013/9/17 (18:54:21) Description: 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 ' `Gioithieu` = 0, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `' at line 1 (index 0). Query: [18:54:21] UPDATE `accounts` SET `IP` = '192.168.1.104', `Registered` = 1, `ConnectedTime` = 0, `Sex` = 0, `Age` = 0, `Band` = 0, `PermBand` = 0, `Warnings` = 0, `Disabled` = 0, `Level` = 1, `AdminLevel` = 0, `DonateRank` = 0, `Respect` = 0, `Money` = 10000, `Bank` = 20000, `pHealth` = 100.00000, `pArmor` = 0.00000, `pSHealth` = 0.00000, `Int` = 0, `VirtualWorld` = 0, `Model` = 299, `Clothes` = 0, `SPos_x` = 0.00000, `SPos_y` = 0.00000, `SPos_z` = 4.88174, `SPos_r` = 0.99995, `BanAppealer` = 0, `PR` = 0, `ShopTech` = 0, `Undercover` = 0, `TogReports` = 0, `Radio` = 0, `RadioFreq` = 0, `UpgradePoints` = 0, `Origin` = 0, `Muted` = 0, `Crimes` = 0, `Accent` = 1, `CHits` = 0, `FHits` = 0, `Arrested` = 0, `Phonebook` = 0, `Coin` = 0, `Vang` = 0, `CuopVangTime` = 0, `SieuThiTime` = 0, `Dau` = 0, `Doibung` = 100, `Thucan` = 0, `LottoNr` = 0, `Fishes` = 0, `BiggestFish` = 0, `Job` = 0, `Job2` = 0, `Paycheck` = 15, `HeadValue` = 0, `JailTime` = 0, `WRestricted` = 0, `Materials` = 0, `Crates` = 0, `Pot` = 0, `Crack` = 0, `Leader [18:54:21] ` = 0, `Member` = 0, `Division` = 0, `Cuahang` = -1, `Cuahang2` = -1, `HtOnline` = 0, `BusinessType` = -1, `BusinessEnter` = -1, `Nguoigioithieu` = , `Gioithieu` = 0, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `BoxSkill` = 0, `LawSkill` = 0, `MechSkill` = 0, `TruckSkill` = 0, `DrugsSkill` = 0, `ArmsSkill` = 0, `SmugglerSkill` = 0, `FishSkill` = 0, `CheckCash` = 0, `Checks` = 0, `BoatLic` = 1, `FlyLic` = 0, `GunLic` = 1, `FishLic` = 1, `FishSkill` = 0, `FightingStyle` = 0, `PhoneNr` = 0, `Apartment` = -1, `Apartment2` = -1, `Renting` = -1, `CarLic` = 1 WHERE `id` = '53' [18:54:34] Incoming connection: 192.168.1.104:59354 [18:54:35] [join] Pro_ne has joined the server (0:192.168.1.104) [18:54:40] Pro ne has logged in. [18:54:49] [MySQL] Query Error - (ErrorID: 1065) (Handle: 1) [18:54:49] [MySQL] Check /logs/querydump.log to review the query that threw the error. [18:54:49] Dumping query from 2013/9/17 (18:54:49) Description: Query was empty (index 0). Query: [18:54:49] (null) [18:54:50] [part] Pro_ne has left the server (0:1) [18:54:50] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1) [18:54:50] [MySQL] Check /logs/querydump.log to review the query that threw the error. [18:54:50] Dumping query from 2013/9/17 (18:54:50) Description: 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 ' `Gioithieu` = 1, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `' at line 1 (index 0). Query: [18:54:50] UPDATE `accounts` SET `IP` = '192.168.1.104', `Registered` = 1, `ConnectedTime` = 0, `Sex` = 1, `Age` = 18, `Band` = 0, `PermBand` = 0, `Warnings` = 0, `Disabled` = 0, `Level` = 1, `AdminLevel` = 0, `DonateRank` = 0, `Respect` = 0, `Money` = 10000, `Bank` = 20000, `pHealth` = 100.00000, `pArmor` = 0.00000, `pSHealth` = 0.00000, `Int` = 0, `VirtualWorld` = 0, `Model` = 299, `Clothes` = 0, `SPos_x` = 1607.01599, `SPos_y` = -1510.82177, `SPos_z` = -21.24764, `SPos_r` = 0.99995, `BanAppealer` = 0, `PR` = 0, `ShopTech` = 0, `Undercover` = 0, `TogReports` = 0, `Radio` = 0, `RadioFreq` = 0, `UpgradePoints` = 0, `Origin` = 0, `Muted` = 0, `Crimes` = 0, `Accent` = 1, `CHits` = 0, `FHits` = 0, `Arrested` = 0, `Phonebook` = 0, `Coin` = 0, `Vang` = 0, `CuopVangTime` = 0, `SieuThiTime` = 0, `Dau` = 0, `Doibung` = 100, `Thucan` = 0, `LottoNr` = 0, `Fishes` = 0, `BiggestFish` = 0, `Job` = 0, `Job2` = 0, `Paycheck` = 9, `HeadValue` = 0, `JailTime` = 0, `WRestricted` = 0, `Materials` = 0, `Crates` = 0, `Pot` = 0, `Crack` = 0 [18:54:50] , `Leader` = 0, `Member` = 0, `Division` = 0, `Cuahang` = -1, `Cuahang2` = -1, `HtOnline` = 0, `BusinessType` = -1, `BusinessEnter` = -1, `Nguoigioithieu` = , `Gioithieu` = 1, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `BoxSkill` = 0, `LawSkill` = 0, `MechSkill` = 0, `TruckSkill` = 0, `DrugsSkill` = 0, `ArmsSkill` = 0, `SmugglerSkill` = 0, `FishSkill` = 0, `CheckCash` = 0, `Checks` = 0, `BoatLic` = 1, `FlyLic` = 0, `GunLic` = 1, `FishLic` = 1, `FishSkill` = 0, `FightingStyle` = 0, `PhoneNr` = 0, `Apartment` = -1, `Apartment2` = -1, `Renting` = -1, `CarLic` = 1 WHERE `id` = '54'
Код:
else if(dialogid == NGUOIGIOITHIEU)
{
if(response)
{
new query[356];
if( strfind( inputtext, "_", true) == -1 )
{
ShowPlayerDialog(playerid, NGUOIGIOITHIEU, DIALOG_STYLE_INPUT, "{FA002E}Error - Invalid Roleplay Name", "That is not a roleplay name\nPlease enter a proper roleplay name.\n\nExample: FristName_LastName", "Enter", "Skip");
return 1;
}
PlayerInfo[playerid][pGioithieu] += 1;
SendClientMessageEx(playerid, COLOR_LIGHTRED, "Cam on ban da dien vao tat ca thong tin, bay gio ban co the tien hanh huong dan!");
format(query, sizeof(query), "UPDATE `accounts` SET `Nguoigioithieu`='%s', `Gioithieu`=1 WHERE `id`=%d", inputtext, GetPlayerSQLId(playerid));
mysql_function_query(MainPipeline, string, true, "OnQueryFinish", "ii", LOADUSERDATA_THREAD, playerid);
