1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
[HELP-ME] input line too long (after substitutions)
CidadeNovaRP
High-roller
*****
Posts: 1,120
Threads: 33
Joined: Mar 2012
Reputation: 0
#1

12.05.2012, 14:43
ERRORS:
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(667) : error 075: input line too long (after substitutions)
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(66 : error 017: undefined symbol "player"
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(669) : warning 217: loose indentation
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(669) : error 017: undefined symbol "id"
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(669) : error 029: invalid expression, assumed zero
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(669) : error 029: invalid expression, assumed zero
C:\Users\LOJA\Desktop\Arquivos\Fort Carson RolePlay\gamemodes\GameMode.pwn(669) : fatal error 107: too many error messages on one line

CODE:
pawn Код:
public SalvarConta(playerid)
{
    new query[600];
    format(query, sizeof(query), "INSERT INTO dados (usuario, senha, email, level, respeito, dinheiro, banco, skin, adminlvl, premium, procurado, sexo, morto, celular, creditos, casa, idasaohospital, posx, posy, posz, organizacao, cargo) VALUES('%s', '%s', '%s', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i')", pDados[playerid][Usuario], pDados[playerid][Senha], pDados[playerid][EMail], pDados[playerid][Level],  pDados[playerid][Respeito],  pDados[playerid][Dinheiro],  pDados[playerid][Banco],  pDados[playerid][Skin],  pDados[playerid][AdminLvL], pDados[playerid][Premium], pDados[playerid][Procurado], pDados[playerid][Sexo], Morto[playerid], pDados[playerid][Celular],  pDados[playerid][Creditos],  pDados[playerid][Casa],  pDados[playerid][IdasAoHospital],  pDados[playerid][PosX],  pDados[playerid][PosY], pDados[playerid][PosZ], pDados[playerid][Organizacao], pDados[playerid][Cargo]);
    mysql_query(query);
    return 1;
}
Find
Reply
doreto
High-roller
*****
Posts: 1,676
Threads: 44
Joined: Aug 2010
Reputation: 0
#2

12.05.2012, 14:51
use strcat
Find
Reply
CidadeNovaRP
High-roller
*****
Posts: 1,120
Threads: 33
Joined: Mar 2012
Reputation: 0
#3

12.05.2012, 14:53
Quote:
Originally Posted by doreto
Посмотреть сообщение
use strcat
I've tried, but could not, could post an example?
Find
Reply
doreto
High-roller
*****
Posts: 1,676
Threads: 44
Joined: Aug 2010
Reputation: 0
#4

12.05.2012, 15:03
or you can make it like that. dont put everything on one line divide it on few lines

pawn Код:
forward SavePlayerData(playerid);
public SavePlayerData(playerid)
{
    new query[700];
    new Float:x, Float:y, Float:z;
    GetPlayerPos(playerid, x, y, z);
    format(query, 700, "UPDATE `players` SET `Origin` = '%d', `Sex` = '%d', `FirstLogin` = '%d', `Staff` = '%d' WHERE `username` ='%s' ", AccountInfo[playerid][pOrigin], AccountInfo[playerid][pSex], AccountInfo[playerid][pFirstLogin], AccountInfo[playerid][pStaff], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Mapper` = '%d', `PosX` = '%f', `PosY` = '%f', `PosZ` = '%f' WHERE `username` ='%s' ", AccountInfo[playerid][pMapper], x, y, z, ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Interior` = '%d', `SavePos` = '%d',`Member` = '%d' WHERE `username` ='%s' ",  GetPlayerInterior(playerid), AccountInfo[playerid][pSavePos], AccountInfo[playerid][pMember], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Rank` = '%d', `Bani` = '%d', `Warns` = '%d', `Age` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pRank], AccountInfo[playerid][pBani], AccountInfo[playerid][pWarns], AccountInfo[playerid][pAge], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `CarLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `GunLic` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pCarLic], AccountInfo[playerid][pFlyLic], AccountInfo[playerid][pBoatLic], AccountInfo[playerid][pGunLic], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `AccesDMV` = '%d', `UpgradeAge` = '%d', `Skin` = '%d', `Bilet` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pAccesDMV], AccountInfo[playerid][pUpgradeAge], AccountInfo[playerid][pSkin], AccountInfo[playerid][pBilet], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Ban` = '%d', `Job` = '%d', `JobEchipat` = '%d', `JobFinish` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pBan], AccountInfo[playerid][pJob], AccountInfo[playerid][pJobEchipat], AccountInfo[playerid][pJobFinish], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `JobPlata` = '%d', `JobTimed` = '%d', `JobTime` = '%d', `World` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pJobPlata], AccountInfo[playerid][pJobTimed], AccountInfo[playerid][pJobTime], AccountInfo[playerid][pWorld], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Muted` = '%d', `MuteTime` = '%d', `AmmuTrainTime` = '%d', `PistSkill` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pMuted], AccountInfo[playerid][pMuteTime], AccountInfo[playerid][pAmmuTrainTime], AccountInfo[playerid][pPistSkill], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `SilenSkill` = '%d', `DesertSkill` = '%d', `ShotgSkill` = '%d', `SmgSkill` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pSilenSkill], AccountInfo[playerid][pDesertSkill], AccountInfo[playerid][pShotgSkill], AccountInfo[playerid][pSmgSkill], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `AkSkill` = '%d', `M4Skill` = '%d', `Undite` = '%d', `Rame` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pAkSkill], AccountInfo[playerid][pM4Skill], AccountInfo[playerid][pUndite], AccountInfo[playerid][pRame], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `HouseKey` = '%d', `RentKey` = '%d', `CarKey` = '%d'` WHERE `username` ='%s' ",  AccountInfo[playerid][pPhousekey],  AccountInfo[playerid][pPrentkey], AccountInfo[playerid][pCarKey], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Scoala` = '%d', `Profil` = '%d', `Romana` = '%d', `RT1` = '%d', WHERE `username` ='%s' ",  AccountInfo[playerid][pScoala],  AccountInfo[playerid][pProfil],  AccountInfo[playerid][pRomana],  AccountInfo[playerid][pRT1], ReturnName(playerid));
    mysql_query(query);
    mysql_free_result();
}
Find
Reply
CidadeNovaRP
High-roller
*****
Posts: 1,120
Threads: 33
Joined: Mar 2012
Reputation: 0
#5

12.05.2012, 15:06
Quote:
Originally Posted by doreto
Посмотреть сообщение
or you can make it like that. dont put everything on one line divide it on few lines

pawn Код:
forward SavePlayerData(playerid);
public SavePlayerData(playerid)
{
    new query[700];
    new Float:x, Float:y, Float:z;
    GetPlayerPos(playerid, x, y, z);
    format(query, 700, "UPDATE `players` SET `Origin` = '%d', `Sex` = '%d', `FirstLogin` = '%d', `Staff` = '%d' WHERE `username` ='%s' ", AccountInfo[playerid][pOrigin], AccountInfo[playerid][pSex], AccountInfo[playerid][pFirstLogin], AccountInfo[playerid][pStaff], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Mapper` = '%d', `PosX` = '%f', `PosY` = '%f', `PosZ` = '%f' WHERE `username` ='%s' ", AccountInfo[playerid][pMapper], x, y, z, ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Interior` = '%d', `SavePos` = '%d',`Member` = '%d' WHERE `username` ='%s' ",  GetPlayerInterior(playerid), AccountInfo[playerid][pSavePos], AccountInfo[playerid][pMember], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Rank` = '%d', `Bani` = '%d', `Warns` = '%d', `Age` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pRank], AccountInfo[playerid][pBani], AccountInfo[playerid][pWarns], AccountInfo[playerid][pAge], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `CarLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `GunLic` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pCarLic], AccountInfo[playerid][pFlyLic], AccountInfo[playerid][pBoatLic], AccountInfo[playerid][pGunLic], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `AccesDMV` = '%d', `UpgradeAge` = '%d', `Skin` = '%d', `Bilet` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pAccesDMV], AccountInfo[playerid][pUpgradeAge], AccountInfo[playerid][pSkin], AccountInfo[playerid][pBilet], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Ban` = '%d', `Job` = '%d', `JobEchipat` = '%d', `JobFinish` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pBan], AccountInfo[playerid][pJob], AccountInfo[playerid][pJobEchipat], AccountInfo[playerid][pJobFinish], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `JobPlata` = '%d', `JobTimed` = '%d', `JobTime` = '%d', `World` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pJobPlata], AccountInfo[playerid][pJobTimed], AccountInfo[playerid][pJobTime], AccountInfo[playerid][pWorld], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Muted` = '%d', `MuteTime` = '%d', `AmmuTrainTime` = '%d', `PistSkill` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pMuted], AccountInfo[playerid][pMuteTime], AccountInfo[playerid][pAmmuTrainTime], AccountInfo[playerid][pPistSkill], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `SilenSkill` = '%d', `DesertSkill` = '%d', `ShotgSkill` = '%d', `SmgSkill` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pSilenSkill], AccountInfo[playerid][pDesertSkill], AccountInfo[playerid][pShotgSkill], AccountInfo[playerid][pSmgSkill], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `AkSkill` = '%d', `M4Skill` = '%d', `Undite` = '%d', `Rame` = '%d' WHERE `username` ='%s' ",  AccountInfo[playerid][pAkSkill], AccountInfo[playerid][pM4Skill], AccountInfo[playerid][pUndite], AccountInfo[playerid][pRame], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `HouseKey` = '%d', `RentKey` = '%d', `CarKey` = '%d'` WHERE `username` ='%s' ",  AccountInfo[playerid][pPhousekey],  AccountInfo[playerid][pPrentkey], AccountInfo[playerid][pCarKey], ReturnName(playerid));
    mysql_query(query);
    format(query, 700, "UPDATE `players` SET `Scoala` = '%d', `Profil` = '%d', `Romana` = '%d', `RT1` = '%d', WHERE `username` ='%s' ",  AccountInfo[playerid][pScoala],  AccountInfo[playerid][pProfil],  AccountInfo[playerid][pRomana],  AccountInfo[playerid][pRT1], ReturnName(playerid));
    mysql_query(query);
    mysql_free_result();
}
Thanks, I forgot the UPDATE function and are using INSERT INTO-q.
+ REP.
Find
Reply
doreto
High-roller
*****
Posts: 1,676
Threads: 44
Joined: Aug 2010
Reputation: 0
#6

12.05.2012, 15:08
Quote:
Originally Posted by CidadeNovaRP
Посмотреть сообщение
Thanks, I forgot the UPDATE function and are using INSERT INTO-q.
+ REP.
np im grad i can help you and ty for rep :P (thats you get rep,but by asking)
Find
Reply
CidadeNovaRP
High-roller
*****
Posts: 1,120
Threads: 33
Joined: Mar 2012
Reputation: 0
#7

12.05.2012, 17:51
( Последний раз редактировалось CidadeNovaRP; 12.05.2012 в 20:14. )
pawn Код:
new bool:solved;
solved = true;
if(solved == true) closetopic(topicid);
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help