1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Español/Spanish

Threaded Mode
Problema con string
GAlvaro14
Big Clucker
***
Posts: 86
Threads: 14
Joined: Mar 2013
Reputation: 0
#1

25.11.2014, 18:30
Hola, he hecho una consulta a lo grande para actualizar datos de una base de datos y obtengo estos errores:

error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "UPDATE"
error 017: undefined symbol "Users"
fatal error 107: too many error messages on one line


El cуdigo:

pawn Код:
format(Query, sizeof(Query), "UPDATE Users SET Password = '%s',AccountState = %i,SpawnUS = '%s',HoursPlaying = %i,DeathCount = %i,KilledCount = %i,Phone = %i, \
    House = %i,Car = %i,Faccion = %i,Rango = %i,GirlFriend = '%s',BolsillosUS = '%s',Habilidad = %i,Warn = %i,Ciudad = %i,Vida = %f,Chaleco = %f,Cansansio = %i, \
    Dinero = %i,Banco = %i,Jail = %i,Admin = %i,World = %i,Interior = %i,Skin = %i,Drogas = %i,Materiales = %i,Lata = %i,Ganzuas = %i,Alquiler = %i,Bombas = %i, \
    Sexo = %i,IdiomasUS = '%s',LicenciasUS = '%s',IsInJail = %i,Nacer = %i,TimeRequestBank = %i,MyBonus = %i,InTutorial = %i,Edad = %i,IsPlayerInHouse = %i, \
    TimeEquipo = %i,SpawnUSAmigo = %i,AmmoP = %i,IsPaga = %i,MyIP = '%s',Job = %i,MyStyleWalk = %i,Saldo = %i,LicenciaPesca = %i,IntermitentState = %i, \
    MyStyleTalk = %i,IsPlayerInBizz = %i,IsPlayerInGarage = %i, \
    WeaponSUS = '%s',AmmoSUS = '%s',AsignadosUS = '%s',BolsaUS = '%s',BolsaCUS = '%s',HaveBolsaUS = %i,IsPlayerInVehInt = %i,CarteraUS = '%s',CarteraCUS = '%s',CarteraTUS = '%s', \
    AccountBankingOpen = %i,CarteraIUS = '%s',IsPlayerInBank = %i,AlertSMSBank = %i,HorasWork = %i,CameraLogin = %i,Enfermedad = %i,Description = %i, \
    EnableDescription = %i,DescriptionString = '%s',DescriptionColor = %i,DescriptionSelect = %i,SpawnUSFac = %i,WantAudio = %i,ObjetosUS = '%s',ObjetosVisionUS = '%s', \
    TypePhone = %i WHERE Nombre = '%s'",

    PlayersData[playerid][Password],PlayersData[playerid][AccountState],PlayersData[playerid][SpawnUS],PlayersData[playerid][HoursPlaying],PlayersData[playerid][DeathCount],
    PlayersData[playerid][KilledCount],PlayersData[playerid][Phone],PlayersData[playerid][House],PlayersData[playerid][Car],PlayersData[playerid][Faccion],
    PlayersData[playerid][Rango],PlayersData[playerid][GirlFriend],BolsillosUS,PlayersData[playerid][Habilidad],PlayersData[playerid][Warn],
    PlayersData[playerid][Ciudad],PlayersData[playerid][Vida],PlayersData[playerid][Chaleco],PlayersData[playerid][Cansansio],PlayersData[playerid][Dinero],
    PlayersData[playerid][Banco],PlayersData[playerid][Jail],PlayersData[playerid][Admin],PlayersData[playerid][World],PlayersData[playerid][Interior],
    PlayersData[playerid][Skin],PlayersData[playerid][Drogas],PlayersData[playerid][Materiales],PlayersData[playerid][Lata],PlayersData[playerid][Ganzuas],
    PlayersData[playerid][Alquiler],PlayersData[playerid][Bombas],PlayersData[playerid][Sexo],IdiomasUS,LicenciasUS,
    PlayersData[playerid][IsInJail],PlayersData[playerid][Nacer],PlayersData[playerid][TimeRequestBank],PlayersData[playerid][MyBonus],PlayersData[playerid][InTutorial],
    PlayersData[playerid][Edad],PlayersData[playerid][IsPlayerInHouse],PlayersData[playerid][TimeEquipo],PlayersData[playerid][SpawnUSAmigo],PlayersData[playerid][AmmoP],
    PlayersData[playerid][IsPaga],PlayersData[playerid][MyIP],PlayersData[playerid][Job],PlayersData[playerid][MyStyleWalk],PlayersData[playerid][Saldo],
    PlayersData[playerid][LicenciaPesca],PlayersData[playerid][IntermitentState],PlayersData[playerid][MyStyleTalk],PlayersData[playerid][IsPlayerInBizz],
    PlayersData[playerid][IsPlayerInGarage],WeaponSUS,AmmoSUS,AsignadosUS,BolsaUS,
    BolsaCUS,PlayersData[playerid][HaveBolsaUS],PlayersData[playerid][IsPlayerInVehInt],CarteraUS,CarteraCUS,
    CarteraTUS,PlayersData[playerid][AccountBankingOpen],CarteraIUS,PlayersData[playerid][IsPlayerInBank],
    PlayersData[playerid][AlertSMSBank],PlayersData[playerid][HorasWork],PlayersData[playerid][CameraLogin],PlayersData[playerid][Enfermedad],
    PlayersData[playerid][Description],PlayersData[playerid][EnableDescription],PlayersData[playerid][DescriptionString],PlayersData[playerid][DescriptionColor],
    PlayersData[playerid][DescriptionSelect],PlayersData[playerid][SpawnUSFac],PlayersData[playerid][WantAudio],ObjetosUS,
    ObjetosVisionUS,PlayersData[playerid][TypePhone],PlayersData[playerid][Nombre]);
Find
Reply
Whyd
Huge Clucker
****
Posts: 415
Threads: 1
Joined: Sep 2012
Reputation: 0
#2

25.11.2014, 18:45
Hazlo en varias consultas o reduce el nъmero de variables a guardar o reducir la lнnea.
Find
Reply
jotajeda
High-roller
*****
Posts: 1,369
Threads: 47
Joined: Aug 2014
Reputation: 0
#3

25.11.2014, 18:49
Ordenalo un poquito mejor, se vй feo jejeje
Find
Reply
GAlvaro14
Big Clucker
***
Posts: 86
Threads: 14
Joined: Mar 2013
Reputation: 0
#4

25.11.2014, 19:11
Quote:
Originally Posted by jotajeda
Посмотреть сообщение
Ordenalo un poquito mejor, se vй feo jejeje
Que ъtil tu comentario.
Find
Reply
jotajeda
High-roller
*****
Posts: 1,369
Threads: 47
Joined: Aug 2014
Reputation: 0
#5

25.11.2014, 19:16
Quote:
Originally Posted by GAlvaro14
Посмотреть сообщение
Que ъtil tu comentario.
Algo asн jejeje

pawn Код:
format(Query, sizeof(Query), "UPDATE Users SET Password = '%s',AccountState = %i,SpawnUS = '%s',HoursPlaying = %i,DeathCount = %i,KilledCount = %i,Phone = %i, \
    House = %i,Car = %i,Faccion = %i,Rango = %i,GirlFriend = '%s',BolsillosUS = '%s',Habilidad = %i,Warn = %i,Ciudad = %i,Vida = %f,Chaleco = %f,Cansansio = %i, \
    Dinero = %i,Banco = %i,Jail = %i,Admin = %i,World = %i,Interior = %i,Skin = %i,Drogas = %i,Materiales = %i,Lata = %i,Ganzuas = %i,Alquiler = %i,Bombas = %i, \
    Sexo = %i,IdiomasUS = '%s',LicenciasUS = '%s',IsInJail = %i,Nacer = %i,TimeRequestBank = %i,MyBonus = %i,InTutorial = %i,Edad = %i,IsPlayerInHouse = %i, \
    TimeEquipo = %i,SpawnUSAmigo = %i,AmmoP = %i,IsPaga = %i,MyIP = '%s',Job = %i,MyStyleWalk = %i,Saldo = %i,LicenciaPesca = %i,IntermitentState = %i, \
    MyStyleTalk = %i,IsPlayerInBizz = %i,IsPlayerInGarage = %i, \
    WeaponSUS = '%s',AmmoSUS = '%s',AsignadosUS = '%s',BolsaUS = '%s',BolsaCUS = '%s',HaveBolsaUS = %i,IsPlayerInVehInt = %i,CarteraUS = '%s',CarteraCUS = '%s',CarteraTUS = '%s', \
    AccountBankingOpen = %i,CarteraIUS = '%s',IsPlayerInBank = %i,AlertSMSBank = %i,HorasWork = %i,CameraLogin = %i,Enfermedad = %i,Description = %i, \
    EnableDescription = %i,DescriptionString = '%s',DescriptionColor = %i,DescriptionSelect = %i,SpawnUSFac = %i,WantAudio = %i,ObjetosUS = '%s',ObjetosVisionUS = '%s', \
    TypePhone = %i WHERE Nombre = '%s'",

    PlayersData[playerid][Password],
    PlayersData[playerid][AccountState],
    PlayersData[playerid][SpawnUS],
    PlayersData[playerid][HoursPlaying],
    PlayersData[playerid][DeathCount],
    PlayersData[playerid][KilledCount],
    PlayersData[playerid][Phone],
    PlayersData[playerid][House],
    PlayersData[playerid][Car],
    PlayersData[playerid][Faccion],
    PlayersData[playerid][Rango],
    PlayersData[playerid][GirlFriend],
    BolsillosUS,
    PlayersData[playerid][Habilidad],
    PlayersData[playerid][Warn],
    PlayersData[playerid][Ciudad],
    PlayersData[playerid][Vida],
    PlayersData[playerid][Chaleco],
    PlayersData[playerid][Cansansio],
    PlayersData[playerid][Dinero],
    PlayersData[playerid][Banco],
    PlayersData[playerid][Jail],
    PlayersData[playerid][Admin],
    PlayersData[playerid][World],
    PlayersData[playerid][Interior],
    PlayersData[playerid][Skin],
    PlayersData[playerid][Drogas],
    PlayersData[playerid][Materiales],
    PlayersData[playerid][Lata],
    PlayersData[playerid][Ganzuas],
    PlayersData[playerid][Alquiler],
    PlayersData[playerid][Bombas],
    PlayersData[playerid][Sexo],
    IdiomasUS,
    LicenciasUS,
    PlayersData[playerid][IsInJail],
    PlayersData[playerid][Nacer],
    PlayersData[playerid][TimeRequestBank],
    PlayersData[playerid][MyBonus],
    PlayersData[playerid][InTutorial],
    PlayersData[playerid][Edad],
    PlayersData[playerid][IsPlayerInHouse],
    PlayersData[playerid][TimeEquipo],
    PlayersData[playerid][SpawnUSAmigo],
    PlayersData[playerid][AmmoP],
    PlayersData[playerid][IsPaga],
    PlayersData[playerid][MyIP],
    PlayersData[playerid][Job],
    PlayersData[playerid][MyStyleWalk],
    PlayersData[playerid][Saldo],
    PlayersData[playerid][LicenciaPesca],
    PlayersData[playerid][IntermitentState],
    PlayersData[playerid][MyStyleTalk],
    PlayersData[playerid][IsPlayerInBizz],
    PlayersData[playerid][IsPlayerInGarage],
    WeaponSUS,
    AmmoSUS,
    AsignadosUS,
    BolsaUS,
    BolsaCUS,
    PlayersData[playerid][HaveBolsaUS],
    PlayersData[playerid][IsPlayerInVehInt],
    CarteraUS,
    CarteraCUS,
    CarteraTUS,
    PlayersData[playerid][AccountBankingOpen],
    CarteraIUS,
    PlayersData[playerid][IsPlayerInBank],
    PlayersData[playerid][AlertSMSBank],
    PlayersData[playerid][HorasWork],
    PlayersData[playerid][CameraLogin],
    PlayersData[playerid][Enfermedad],
    PlayersData[playerid][Description],
    PlayersData[playerid][EnableDescription],
    PlayersData[playerid][DescriptionString],
    PlayersData[playerid][DescriptionColor],
    PlayersData[playerid][DescriptionSelect],
    PlayersData[playerid][SpawnUSFac],
    PlayersData[playerid][WantAudio],
    ObjetosUS,
    ObjetosVisionUS,
    PlayersData[playerid][TypePhone],
    PlayersData[playerid][Nombre]);
Find
Reply
GAlvaro14
Big Clucker
***
Posts: 86
Threads: 14
Joined: Mar 2013
Reputation: 0
#6

25.11.2014, 20:14
Quote:
Originally Posted by jotajeda
Посмотреть сообщение
Algo asн jejeje

pawn Код:
format(Query, sizeof(Query), "UPDATE Users SET Password = '%s',AccountState = %i,SpawnUS = '%s',HoursPlaying = %i,DeathCount = %i,KilledCount = %i,Phone = %i, \
    House = %i,Car = %i,Faccion = %i,Rango = %i,GirlFriend = '%s',BolsillosUS = '%s',Habilidad = %i,Warn = %i,Ciudad = %i,Vida = %f,Chaleco = %f,Cansansio = %i, \
    Dinero = %i,Banco = %i,Jail = %i,Admin = %i,World = %i,Interior = %i,Skin = %i,Drogas = %i,Materiales = %i,Lata = %i,Ganzuas = %i,Alquiler = %i,Bombas = %i, \
    Sexo = %i,IdiomasUS = '%s',LicenciasUS = '%s',IsInJail = %i,Nacer = %i,TimeRequestBank = %i,MyBonus = %i,InTutorial = %i,Edad = %i,IsPlayerInHouse = %i, \
    TimeEquipo = %i,SpawnUSAmigo = %i,AmmoP = %i,IsPaga = %i,MyIP = '%s',Job = %i,MyStyleWalk = %i,Saldo = %i,LicenciaPesca = %i,IntermitentState = %i, \
    MyStyleTalk = %i,IsPlayerInBizz = %i,IsPlayerInGarage = %i, \
    WeaponSUS = '%s',AmmoSUS = '%s',AsignadosUS = '%s',BolsaUS = '%s',BolsaCUS = '%s',HaveBolsaUS = %i,IsPlayerInVehInt = %i,CarteraUS = '%s',CarteraCUS = '%s',CarteraTUS = '%s', \
    AccountBankingOpen = %i,CarteraIUS = '%s',IsPlayerInBank = %i,AlertSMSBank = %i,HorasWork = %i,CameraLogin = %i,Enfermedad = %i,Description = %i, \
    EnableDescription = %i,DescriptionString = '%s',DescriptionColor = %i,DescriptionSelect = %i,SpawnUSFac = %i,WantAudio = %i,ObjetosUS = '%s',ObjetosVisionUS = '%s', \
    TypePhone = %i WHERE Nombre = '%s'",

    PlayersData[playerid][Password],
    PlayersData[playerid][AccountState],
    PlayersData[playerid][SpawnUS],
    PlayersData[playerid][HoursPlaying],
    PlayersData[playerid][DeathCount],
    PlayersData[playerid][KilledCount],
    PlayersData[playerid][Phone],
    PlayersData[playerid][House],
    PlayersData[playerid][Car],
    PlayersData[playerid][Faccion],
    PlayersData[playerid][Rango],
    PlayersData[playerid][GirlFriend],
    BolsillosUS,
    PlayersData[playerid][Habilidad],
    PlayersData[playerid][Warn],
    PlayersData[playerid][Ciudad],
    PlayersData[playerid][Vida],
    PlayersData[playerid][Chaleco],
    PlayersData[playerid][Cansansio],
    PlayersData[playerid][Dinero],
    PlayersData[playerid][Banco],
    PlayersData[playerid][Jail],
    PlayersData[playerid][Admin],
    PlayersData[playerid][World],
    PlayersData[playerid][Interior],
    PlayersData[playerid][Skin],
    PlayersData[playerid][Drogas],
    PlayersData[playerid][Materiales],
    PlayersData[playerid][Lata],
    PlayersData[playerid][Ganzuas],
    PlayersData[playerid][Alquiler],
    PlayersData[playerid][Bombas],
    PlayersData[playerid][Sexo],
    IdiomasUS,
    LicenciasUS,
    PlayersData[playerid][IsInJail],
    PlayersData[playerid][Nacer],
    PlayersData[playerid][TimeRequestBank],
    PlayersData[playerid][MyBonus],
    PlayersData[playerid][InTutorial],
    PlayersData[playerid][Edad],
    PlayersData[playerid][IsPlayerInHouse],
    PlayersData[playerid][TimeEquipo],
    PlayersData[playerid][SpawnUSAmigo],
    PlayersData[playerid][AmmoP],
    PlayersData[playerid][IsPaga],
    PlayersData[playerid][MyIP],
    PlayersData[playerid][Job],
    PlayersData[playerid][MyStyleWalk],
    PlayersData[playerid][Saldo],
    PlayersData[playerid][LicenciaPesca],
    PlayersData[playerid][IntermitentState],
    PlayersData[playerid][MyStyleTalk],
    PlayersData[playerid][IsPlayerInBizz],
    PlayersData[playerid][IsPlayerInGarage],
    WeaponSUS,
    AmmoSUS,
    AsignadosUS,
    BolsaUS,
    BolsaCUS,
    PlayersData[playerid][HaveBolsaUS],
    PlayersData[playerid][IsPlayerInVehInt],
    CarteraUS,
    CarteraCUS,
    CarteraTUS,
    PlayersData[playerid][AccountBankingOpen],
    CarteraIUS,
    PlayersData[playerid][IsPlayerInBank],
    PlayersData[playerid][AlertSMSBank],
    PlayersData[playerid][HorasWork],
    PlayersData[playerid][CameraLogin],
    PlayersData[playerid][Enfermedad],
    PlayersData[playerid][Description],
    PlayersData[playerid][EnableDescription],
    PlayersData[playerid][DescriptionString],
    PlayersData[playerid][DescriptionColor],
    PlayersData[playerid][DescriptionSelect],
    PlayersData[playerid][SpawnUSFac],
    PlayersData[playerid][WantAudio],
    ObjetosUS,
    ObjetosVisionUS,
    PlayersData[playerid][TypePhone],
    PlayersData[playerid][Nombre]);
їQuiйres un pin?
Find
Reply
jotajeda
High-roller
*****
Posts: 1,369
Threads: 47
Joined: Aug 2014
Reputation: 0
#7

25.11.2014, 20:23
Quote:
Originally Posted by GAlvaro14
Посмотреть сообщение
їQuiйres un pin?
Gracias.
Find
Reply
LiMPiTo
Huge Clucker
***
Posts: 221
Threads: 2
Joined: Apr 2011
Reputation: 0
#8

25.11.2014, 21:06
Un ejemplo, falta el resto..

pawn Код:
new QueryEx[128];
    
    Dinero = %i,Banco = %i,Jail = %i,Admin = %i,World = %i,Interior = %i,Skin = %i,Drogas = %i,Materiales = %i,Lata = %i,Ganzuas = %i,Alquiler = %i,Bombas = %i, \
    Sexo = %i,IdiomasUS = '%s',LicenciasUS = '%s',IsInJail = %i,Nacer = %i,TimeRequestBank = %i,MyBonus = %i,InTutorial = %i,Edad = %i,IsPlayerInHouse = %i, \
    TimeEquipo = %i,SpawnUSAmigo = %i,AmmoP = %i,IsPaga = %i,MyIP = '%s',Job = %i,MyStyleWalk = %i,Saldo = %i,LicenciaPesca = %i,IntermitentState = %i, \
    MyStyleTalk = %i,IsPlayerInBizz = %i,IsPlayerInGarage = %i, \
    WeaponSUS = '%s',AmmoSUS = '%s',AsignadosUS = '%s',BolsaUS = '%s',BolsaCUS = '%s',HaveBolsaUS = %i,IsPlayerInVehInt = %i,CarteraUS = '%s',CarteraCUS = '%s',CarteraTUS = '%s', \
    AccountBankingOpen = %i,CarteraIUS = '%s',IsPlayerInBank = %i,AlertSMSBank = %i,HorasWork = %i,CameraLogin = %i,Enfermedad = %i,Description = %i, \
    EnableDescription = %i,DescriptionString = '%s',DescriptionColor = %i,DescriptionSelect = %i,SpawnUSFac = %i,WantAudio = %i,ObjetosUS = '%s',ObjetosVisionUS = '%s', \
    TypePhone = %i WHERE Nombre = '%s'

    format(QueryEx, sizeof(QueryEx), "UPDATE Users SET Password = '%s',AccountState = %i,SpawnUS = '%s',HoursPlaying = %i,DeathCount = %i,KilledCount = %i,Phone = %i", PlayersData[playerid][Password],PlayersData[playerid][AccountState],PlayersData[playerid][SpawnUS],PlayersData[playerid][HoursPlaying],PlayersData[playerid][DeathCount], PlayersData[playerid][KilledCount],PlayersData[playerid][Phone]);
    strcat(Query, QueryEx);
    format(QueryEx, sizeof(QueryEx), "House = %i,Car = %i,Faccion = %i,Rango = %i,GirlFriend = '%s',BolsillosUS = '%s',Habilidad = %i,Warn = %i,Ciudad = %i,Vida = %f,Chaleco = %f,Cansansio = %i", PlayersData[playerid][House],PlayersData[playerid][Car],PlayersData[playerid][Faccion], PlayersData[playerid][Rango],PlayersData[playerid][GirlFriend],BolsillosUS,PlayersData[playerid][Habilidad],PlayersData[playerid][Warn], PlayersData[playerid][Ciudad],PlayersData[playerid][Vida],PlayersData[playerid][Chaleco],PlayersData[playerid][Cansansio]);
    strcat(Query, QueryEx);
    PlayersData[playerid][Dinero],
    PlayersData[playerid][Banco],PlayersData[playerid][Jail],PlayersData[playerid][Admin],PlayersData[playerid][World],PlayersData[playerid][Interior],
    PlayersData[playerid][Skin],PlayersData[playerid][Drogas],PlayersData[playerid][Materiales],PlayersData[playerid][Lata],PlayersData[playerid][Ganzuas],
    PlayersData[playerid][Alquiler],PlayersData[playerid][Bombas],PlayersData[playerid][Sexo],IdiomasUS,LicenciasUS,
    PlayersData[playerid][IsInJail],PlayersData[playerid][Nacer],PlayersData[playerid][TimeRequestBank],PlayersData[playerid][MyBonus],PlayersData[playerid][InTutorial],
    PlayersData[playerid][Edad],PlayersData[playerid][IsPlayerInHouse],PlayersData[playerid][TimeEquipo],PlayersData[playerid][SpawnUSAmigo],PlayersData[playerid][AmmoP],
    PlayersData[playerid][IsPaga],PlayersData[playerid][MyIP],PlayersData[playerid][Job],PlayersData[playerid][MyStyleWalk],PlayersData[playerid][Saldo],
    PlayersData[playerid][LicenciaPesca],PlayersData[playerid][IntermitentState],PlayersData[playerid][MyStyleTalk],PlayersData[playerid][IsPlayerInBizz],
    PlayersData[playerid][IsPlayerInGarage],WeaponSUS,AmmoSUS,AsignadosUS,BolsaUS,
    BolsaCUS,PlayersData[playerid][HaveBolsaUS],PlayersData[playerid][IsPlayerInVehInt],CarteraUS,CarteraCUS,
    CarteraTUS,PlayersData[playerid][AccountBankingOpen],CarteraIUS,PlayersData[playerid][IsPlayerInBank],
    PlayersData[playerid][AlertSMSBank],PlayersData[playerid][HorasWork],PlayersData[playerid][CameraLogin],PlayersData[playerid][Enfermedad],
    PlayersData[playerid][Description],PlayersData[playerid][EnableDescription],PlayersData[playerid][DescriptionString],PlayersData[playerid][DescriptionColor],
    PlayersData[playerid][DescriptionSelect],PlayersData[playerid][SpawnUSFac],PlayersData[playerid][WantAudio],ObjetosUS,
    ObjetosVisionUS,PlayersData[playerid][TypePhone],PlayersData[playerid][Nombre]);
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Español/Spanish