D:\DOKUME~1\Krip\Desktop\samp\GAMEMO~1\pwn.pwn(7265) : error 075: input line too long (after substitutions) D:\DOKUME~1\Krip\Desktop\samp\GAMEMO~1\pwn.pwn(7266) : error 037: invalid string (possibly non-terminated string) D:\DOKUME~1\Krip\Desktop\samp\GAMEMO~1\pwn.pwn(7266) : error 017: undefined symbol "INSERT" D:\DOKUME~1\Krip\Desktop\samp\GAMEMO~1\pwn.pwn(7266) : error 017: undefined symbol "INTO" D:\DOKUME~1\Krip\Desktop\samp\GAMEMO~1\pwn.pwn(7266) : fatal error 107: too many error messages on one line
LINE 7265: new query[128]; LINE 7266: format(query, sizeof(query), "INSERT INTO players (Name, Password, Cash, Account, Admin, Level, Exp, Pupgrade, Kills, LJ, IJ, SR, WA, PEN, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, SHealth, Health, Pos_x, Pos_y, Pos_z, Int, Local, Team, Model, Pnumber, Phousekey, Pbiskey, Gang, Gleader, RealAdmin, TOS, Job, GLicense, DLicense, Resign, FLicense, CKey, Hotwire, Donation, CLicense, Strength, TLicense) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s', '%s', '%s','%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", playername2, PlayerInfox[playerid][pxPassword], PlayerInfox[playerid][pxCash],PlayerInfox[playerid][pxAccount],PlayerInfox[playerid][pxAdmin],PlayerInfox[playerid][pxLevel],PlayerInfox[playerid][pxExp],PlayerInfox[playerid][gxPupgrade],PlayerInfox[playerid][gxKills],PlayerInfox[playerid][gxLJ],PlayerInfox[playerid][gxIJ],PlayerInfox[playerid][gxSR],PlayerInfox[playerid][gxWA],PlayerInfox[playerid][gxPEN],PlayerInfox[playerid][gxGun1],PlayerInfox[playerid][gxGun2],PlayerInfox[playerid][gxGun3],PlayerInfox[playerid][gxGun4],PlayerInfox[playerid][gxGun5],PlayerInfox[playerid][gxGun6],PlayerInfox[playerid][gxAmmo1],PlayerInfox[playerid][gxAmmo2], PlayerInfox[playerid][gxAmmo3], PlayerInfox[playerid][gxAmmo4], PlayerInfox[playerid][gxAmmo5], PlayerInfox[playerid][gxAmmo6], PlayerInfox[playerid][gxSHealth], PlayerInfox[playerid][gxHealth],PlayerInfox[playerid][gxPos_x],PlayerInfox[playerid][gxPos_y],PlayerInfox[playerid][gxPos_z],PlayerInfox[playerid][gxInt],PlayerInfox[playerid][gxLocal],PlayerInfox[playerid][gxTeam], PlayerInfox[playerid][gxModel], PlayerInfox[playerid][gxPnumber], PlayerInfox[playerid][gxPhousekey], PlayerInfox[playerid][gxPbiskey], PlayerInfox[playerid][gxGang], PlayerInfox[playerid][gxGleader], PlayerInfox[playerid][gxRealadmin], PlayerInfox[playerid][gxTOS], PlayerInfox[playerid][gxJob], PlayerInfox[playerid][gxGLicense], PlayerInfox[playerid][gxDLicense], PlayerInfox[playerid][gxResign], PlayerInfox[playerid][gxFLicense], PlayerInfox[playerid][gxCKey], PlayerInfox[playerid][gxHotwire], PlayerInfox[playerid][gxDonation], PlayerInfox[playerid][gxCLicense], PlayerInfox[playerid][Strength], PlayerInfox[playerid][TLicense]); samp_mysql_query(query);
Originally Posted by [M2S
moe ]
that wouldnt work anyway as you define intergers as strings etc, but start by making query[256] instead of 128. |
new query[1024];
format(query, sizeof(query), "INSERT INTO players (Name, Password, Cash, Account, Admin, Level, Exp, Pupgrade, Kills, LJ, IJ, SR, WA, PEN, \
Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, SHealth, Health, Pos_x, Pos_y, Pos_z, Int, Local, \
Team, Model, Pnumber, Phousekey, Pbiskey, Gang, Gleader, RealAdmin, TOS, Job, GLicense, DLicense, Resign, FLicense, CKey, Hotwire, Donation, CLicense, Strength, TLicense) \
VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',\ '%s', '%s', '%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s',\'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s', '%s', '%s',\
'%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", \
playername2, PlayerInfox[playerid][pxPassword], PlayerInfox[playerid][pxCash],PlayerInfox[playerid][pxAccount],PlayerInfox[playerid][pxAdmin],\
PlayerInfox[playerid][pxLevel],PlayerInfox[playerid][pxExp],PlayerInfox[playerid][gxPupgrade],PlayerInfox[playerid][gxKills],\
PlayerInfox[playerid][gxLJ],PlayerInfox[playerid][gxIJ],PlayerInfox[playerid][gxSR],PlayerInfox[playerid][gxWA],\
PlayerInfox[playerid][gxPEN],PlayerInfox[playerid][gxGun1],PlayerInfox[playerid][gxGun2],PlayerInfox[playerid][gxGun3],\
PlayerInfox[playerid][gxGun4],PlayerInfox[playerid][gxGun5],PlayerInfox[playerid][gxGun6],\
PlayerInfox[playerid][gxAmmo1],PlayerInfox[playerid][gxAmmo2], PlayerInfox[playerid][gxAmmo3], PlayerInfox[playerid][gxAmmo4], PlayerInfox[playerid][gxAmmo5], PlayerInfox[playerid][gxAmmo6], \
PlayerInfox[playerid][gxSHealth], PlayerInfox[playerid][gxHealth],\
PlayerInfox[playerid][gxPos_x],PlayerInfox[playerid][gxPos_y],PlayerInfox[playerid][gxPos_z],\
PlayerInfox[playerid][gxInt],PlayerInfox[playerid][gxLocal],PlayerInfox[playerid][gxTeam], PlayerInfox[playerid][gxModel], PlayerInfox[playerid][gxPnumber], \
PlayerInfox[playerid][gxPhousekey], PlayerInfox[playerid][gxPbiskey], PlayerInfox[playerid][gxGang], PlayerInfox[playerid][gxGleader], PlayerInfox[playerid][gxRealadmin], PlayerInfox[playerid][gxTOS], PlayerInfox[playerid][gxJob], PlayerInfox[playerid][gxGLicense], \
PlayerInfox[playerid][gxDLicense], PlayerInfox[playerid][gxResign], PlayerInfox[playerid][gxFLicense], PlayerInfox[playerid][gxCKey], PlayerInfox[playerid][gxHotwire], PlayerInfox[playerid][gxDonation], \
PlayerInfox[playerid][gxCLicense], PlayerInfox[playerid][Strength], PlayerInfox[playerid][TLicense]);
samp_mysql_query(query);