[Ajuda] Linha ENORME
#1

pawn Код:
format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',Sex='%d',Respeito='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',Paycheck='%d',HeadValue='%d',Jailed='%d',JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d',Gold='%d',ContractTime='%d',DetSkill='%d',SexSkill='%d',BoxSkill='%d',LawSkill='%d',MechSkill='%d',NewsSkill='%d',DrogasSkill='%d',CookSkill='%d',FishSkill='%d',pSHealth='%d',Team='%d',PhoneNr='%d',House='%d',Bizz='%d',Spawn='%d',SafeMaconha='%d',SafeCocaina='%d',SafeCrack='%d',NivelProcurado='%d',SafeMateriais='%d',CarLic='%d',FlyLic='%d',BoatLic='%d',Ajustado='%d',FishLic='%d',MV='%d',GunLic='%d',PayDay='%d',CDPlayer='%d',AlcoholPerk='%d',DrugPerk='%d',MiserPerk='%d',PainPerk='%d',TraderPerk='%d',Tutorial='%d',Avisos='%d',Married='%d',Luta='%d',Dorgado='%d',Dorgado2='%d',Doenca='%d',DiaLogin='%d',MesLogin='%d',AnoLogin='%d',HoraLogin='%d',MinutoLogin='%d',SegundoLogin='%d',Votei='%d',BlockTime='%d',Hospital='%d',HospitalTime='%d',MarriedTo='%d',PresoPor='%d',Work='%d' WHERE name='%s'",PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pVip],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pConta],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][Rufflesills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pEmprego],PlayerInfo[playerid][pSalario],PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrogas],PlayerInfo[playerid][pDrogas2],PlayerInfo[playerid][pDrogas3],PlayerInfo[playerid][pLider],PlayerInfo[playerid][pMembro],PlayerInfo[playerid][pAjustado],PlayerInfo[playerid][pCargo],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pMV],PlayerInfo[playerid][pGold],PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrogasSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPHousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pSafeDrogas],PlayerInfo[playerid][pSafeDrogas2],PlayerInfo[playerid][pSafeDrogas3],PlayerInfo[playerid][playerid],PlayerInfo[playerid][psMats],PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pAjustado],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut],PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pLuta],PlayerInfo[playerid][pDorgado],PlayerInfo[playerid][pDorgado],PlayerInfo[playerid][pDoenca],PlayerInfo[playerid][pLastDia],PlayerInfo[playerid][pLastMes],PlayerInfo[playerid][pLastAno],PlayerInfo[playerid][pLastHora],PlayerInfo[playerid][pLastMinuto],PlayerInfo[playerid][pLastSegundo],PlayerInfo[playerid][pVotou],PlayerInfo[playerid][pTimeBlock],PlayerInfo[playerid][pHosp],PlayerInfo[playerid][pHospTime],PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pPresoPor],PlayerInfo[playerid][pWorkFree],PlayerName(playerid));
Reply
#2

Tente assim:

pawn Код:
format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',\
    Sex='%d',Respeito='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',\
    Paycheck='%d',HeadValue='%d',Jailed='%d',JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d' WHERE name='%s'"
,
    PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pVip],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],
    PlayerInfo[playerid][pSex],PlayerInfo[playerid][pExp],PlayerName(playerid));
Reply
#3

usa esse '\' para string

pawn Код:
format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',Sex='%d',Respeito='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',Paycheck='%d',HeadValue='%d',Jailed='%d',JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d',Gold='%d',ContractTime='%d',DetSkill='%d',SexSkill='%d',BoxSkill='%d',LawSkill='%d',MechSkill='%d',NewsSkill='%d',DrogasSkill='%d',CookSkill='%d',FishSkill='%d',pSHealth='%d',Team='%d',PhoneNr='%d',House='%d',Bizz='%d',Spawn='%d',SafeMaconha='%d',SafeCocaina='%d',SafeCrack='%d',NivelProcurado='%d',SafeMateriais='%d',CarLic='%d',FlyLic='%d',BoatLic='%d',Ajustado='%d',FishLic='%d',MV='%d',GunLic='%d',PayDay='%d',CDPlayer='%d',AlcoholPerk='%d',DrugPerk='%d',MiserPerk='%d',PainPerk='%d',TraderPerk='%d',Tutorial='%d',Avisos='%d',Married='%d',Luta='%d',Dorgado='%d',Dorgado2='%d',Doenca='%d',DiaLogin='%d',MesLogin='%d',AnoLogin='%d',HoraLogin='%d',MinutoLogin='%d',SegundoLogin='%d',Votei='%d',BlockTime='%d',Hospital='%d',HospitalTime='%d',MarriedTo='%d',PresoPor='%d',Work='%d' WHERE name='%s'",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pVip],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pConta],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][Rufflesills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pEmprego],
PlayerInfo[playerid][pSalario],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrogas],
PlayerInfo[playerid][pDrogas2],
PlayerInfo[playerid][pDrogas3],
PlayerInfo[playerid][pLider],
PlayerInfo[playerid][pMembro],
PlayerInfo[playerid][pAjustado],
PlayerInfo[playerid][pCargo],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pMV],
PlayerInfo[playerid][pGold],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrogasSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pTeam],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPHousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pSafeDrogas],
PlayerInfo[playerid][pSafeDrogas2],
PlayerInfo[playerid][pSafeDrogas3],
PlayerInfo[playerid][playerid],
PlayerInfo[playerid][psMats],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pAjustado],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pLuta],
PlayerInfo[playerid][pDorgado],
PlayerInfo[playerid][pDorgado],
PlayerInfo[playerid][pDoenca],
PlayerInfo[playerid][pLastDia],
PlayerInfo[playerid][pLastMes],
PlayerInfo[playerid][pLastAno],
PlayerInfo[playerid][pLastHora],
PlayerInfo[playerid][pLastMinuto],
PlayerInfo[playerid][pLastSegundo],
PlayerInfo[playerid][pVotou],
PlayerInfo[playerid][pTimeBlock],
PlayerInfo[playerid][pHosp],
PlayerInfo[playerid][pHospTime],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pPresoPor],
PlayerInfo[playerid][pWorkFree],
PlayerName(playerid));
EDIT: @ReyMysterio: Desculpe, nгo atualizar a pбgina
Reply
#4

Observem:

pawn Код:
CallBack::MySQL_SaveAccount(playerid){
    format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',\
    Sex='%d',Respeito='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',\
    Paycheck='%d',HeadValue='%d',Jailed='%d',JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d' WHERE name='%s'"
,
    PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pVip],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],
    PlayerInfo[playerid][pSex],PlayerInfo[playerid][pExp],PlayerName(playerid));
    if(PlayerInfo[playerid][pVip] > 0 )
        SalvarVip(playerid);
    mysql_function_query(MysqlC,Query,false,"r@MySQL_SaveAccount","d",playerid);
    return 1;
}
CallBack::r@MySQL_SaveAccount(playerid)
    return printf("Conta do player %s salva com sucesso.",PlayerName(playerid));
Nгo estб salvando a conta... A mensagem "Conta do player %s salva com sucesso." nгo retorna.
Reply
#5

Porque UPDATE nгo precisa de criar callback.

Coloque apenas isso:

pawn Код:
CallBack::MySQL_SaveAccount(playerid){
    format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',\
    Sex='%d',Respeito='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',\
    Paycheck='%d',HeadValue='%d',Jailed='%d',JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d' WHERE name='%s'"
,
    PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pVip],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],
    PlayerInfo[playerid][pSex],PlayerInfo[playerid][pExp],PlayerName(playerid));
    if(PlayerInfo[playerid][pVip] > 0 )
        SalvarVip(playerid);
    mysql_function_query(MysqlC, Query, false, "", #, #);
    printf("Conta do player %s salva com sucesso.",PlayerName(playerid));
    return 1;
}
Reply
#6

Isso nгo tem nada haver, isso sу funciona para verificar se deu certo ou nгo.

No caso nгo deu certo.
Reply
#7

Tente alterar o "false" para "true"
Reply
#8

Nгo deu. Acho que vou dividir em dois...
Reply
#9

isso vai dar um lag gigantesco cara, recomendo que vocк reorganize essa atualizaзгo, pois todos os players fazendo isso ao mesmo tempo nгo vai dar certo, ainda mais com o server lotado
Reply
#10

@Bruno, isso й sу quando ele desloga, nгo da LAG nгo.

@post, put@quepario!! Passei o code errado. O certo era esse daqui:

pawn Код:
CallBack::MySQL_SaveAccount(playerid){
    format(Query,sizeof(Query),"UPDATE `users` SET Level='%d',AdminLevel='%d',HelpLevel='%d',LevelVip='%d',UpgradePoints='%d',ConnectedTime='%d',Sex='%d',Respeito='%d',\
        Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Emprego='%d',Paycheck='%d',HeadValue='%d',Jailed='%d',\
        JailTime='%d',Materiais='%d',Maconha='%d',Cocaina='%d',Crack='%d',Lider='%d',Member='%d',Ajustado='%d',Rank='%d',Char='%d',MV='%d',Gold='%d',ContractTime='%d',DetSkill='%d',\
        SexSkill='%d',BoxSkill='%d',LawSkill='%d',MechSkill='%d',NewsSkill='%d',DrogasSkill='%d',CookSkill='%d',FishSkill='%d',pSHealth='%d',Team='%d',PhoneNr='%d',House='%d',Bizz='%d',\
        Spawn='%d',SafeMaconha='%d',SafeCocaina='%d',SafeCrack='%d',NivelProcurado='%d',SafeMateriais='%d',CarLic='%d',FlyLic='%d',BoatLic='%d',Ajustado='%d',FishLic='%d',MV='%d',\
        GunLic='%d',PayDay='%d',CDPlayer='%d',AlcoholPerk='%d',DrugPerk='%d',MiserPerk='%d',PainPerk='%d',TraderPerk='%d',Tutorial='%d',Avisos='%d',Married='%d',Luta='%d',Dorgado='%d',\
        Dorgado2='%d',Doenca='%d',DiaLogin='%d',MesLogin='%d',AnoLogin='%d',HoraLogin='%d',MinutoLogin='%d',SegundoLogin='%d',Votei='%d',BlockTime='%d',Hospital='%d',HospitalTime='%d',\
        MarriedTo='%d',PresoPor='%d',Work='%d' WHERE name='%s'"
,PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pVip],
        PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],
        PlayerInfo[playerid][pConta],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][Rufflesills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],
        PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pEmprego],PlayerInfo[playerid][pSalario],PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailed],
        PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrogas],PlayerInfo[playerid][pDrogas2],PlayerInfo[playerid][pDrogas3],PlayerInfo[playerid][pLider],
        PlayerInfo[playerid][pMembro],PlayerInfo[playerid][pAjustado],PlayerInfo[playerid][pCargo],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pMV],PlayerInfo[playerid][pGold],
        PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],
        PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrogasSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],
        PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPHousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pSpawn],
        PlayerInfo[playerid][pSafeDrogas],PlayerInfo[playerid][pSafeDrogas2],PlayerInfo[playerid][pSafeDrogas3],WantedPoints[playerid],PlayerInfo[playerid][psMats],PlayerInfo[playerid][pCarLic],
        PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pAjustado],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pPayDay],
        PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],
        PlayerInfo[playerid][pTut],PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pLuta],PlayerInfo[playerid][pDorgado],PlayerInfo[playerid][pDorgado],PlayerInfo[playerid][pDoenca],
        PlayerInfo[playerid][pLastDia],PlayerInfo[playerid][pLastMes],PlayerInfo[playerid][pLastAno],PlayerInfo[playerid][pLastHora],PlayerInfo[playerid][pLastMinuto],PlayerInfo[playerid][pLastSegundo],
        PlayerInfo[playerid][pVotou],PlayerInfo[playerid][pTimeBlock],PlayerInfo[playerid][pHosp],PlayerInfo[playerid][pHospTime],PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pPresoPor],PlayerInfo[playerid][pWorkFree],PlayerName(playerid));
    mysql_function_query(MysqlC,Query,false,"r@MySQL_SaveAccount","d",playerid);
    return 1;
}
porйm ta dando erro.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)