Hello. Need help with mysql strcat.
#1

Hello

I have problem with this line could some one teach me how to use strcat on big mysql lines...

With best regards Scrillex.

pawn Код:
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "INSERT"
error 017: undefined symbol "INTO"
fatal error 107: too many error messages on one line
pawn Код:
mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`,);
            format(query, sizeof(query),`Leader`, `Member`, `Rank`, `JobID`, `StreetRank`, `HouseID`, `BussinesID`, `CarID`, `CarID2`, `DrivingLicense`, `FlyingLicense`, `HeliLicense`,);
            format(query, sizeof(query),`BoatLicense`, `ParasuteLicense`, `TPockets`, `TPocket2`, `JPocket`, `JPocket2`, `TV`, `Radio`, `Mp3Player`, `Computer`, `PhoneNumber`, `MaskID`,);
            format(query, sizeof(query),`PhoneBook`, `FightingSyle`, `WalkingStyle`, `Strenght`, `Fat`, `SkinID`, `Health`, `Armor`, `Weapon`, `Ammo`, `Weapon1`, `Ammo1`, `Weapon2`, `Ammo2`, );
            format(query, sizeof(query),`Weapon3`, `Ammo3`, `Weapon4`, `Ammo4`, `Weapon5`, `Ammo5`, `Weapon6`, `Ammo6`, `Weapon7`, `Ammo7`, `Weapon8`, `Ammo8`, `Weapon9`, `Ammo9`, `WeaponDealer`);
            format(query, sizeof(query),VALUES ('%e', '%e', '%e', 0, 0, 0, %f, %f, %f, %f, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, %f, %f, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"
, playername, Player[playerid][Password], playerip, SPAWN_X, SPAWN_Y, SPAWN_Z, SPAWN_A);
Reply


Messages In This Thread
Hello. Need help with mysql strcat. - by Scrillex - 23.12.2015, 21:45
Re: Hello. Need help with mysql strcat. - by Vince - 23.12.2015, 22:09
Respuesta: Hello. Need help with mysql strcat. - by Zume - 23.12.2015, 22:30
Re: Hello. Need help with mysql strcat. - by Scrillex - 23.12.2015, 22:44

Forum Jump:


Users browsing this thread: 1 Guest(s)