[v32] GlobalFull 11/12 - New Asuras, Falcons, Warzones 4,5,6 . (Updates Frequentes)

Postado Julho 21, 2016 8 anos

a compilação foi finalizada 10.96

porem ao tentar logar pelo mysql apresenta esses erros.

Por favor preciso de uma solução ou um banco de dados que funcione nessa nova versão obrigado mas uma vez

[Error - mysql_real_query] Query: SELECT `id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries` FROM `players` WHERE `name` = 'GoD SoMbrA'
Message: Unknown column 'skill_critical_hit_chance' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries` FROM `players` WHERE `name` = 'GoD BR'

Citar

Mention

Respostas 3.6k
Visualizações 566.7k
Created 10 anos10 anos
Última resposta 3 anos3 anos

Popular Days

Posted Images

Postado Julho 21, 2016 8 anos

50 minutos atrás, leandronetx disse:

a compilação foi finalizada 10.96

porem ao tentar logar pelo mysql apresenta esses erros.

Por favor preciso de uma solução ou um banco de dados que funcione nessa nova versão obrigado mas uma vez

[Error - mysql_real_query] Query: SELECT `id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries` FROM `players` WHERE `name` = 'GoD SoMbrA'
Message: Unknown column 'skill_critical_hit_chance' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skulltime`, `skull`, `town_id`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries` FROM `players` WHERE `name` = 'GoD BR'

5 horas atrás, hygashy disse:

Olá, quando vou logar na conta god/god na versão 10.96 dá um erro na coluna players e não loga.

o erro é esse: message: Unknow Column 'skill_critical_hit_chance' in field list

execute isso no SQL pra add as colunas na database

ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0

21 horas atrás, GabrielOak disse:

Entendi Jobs. Eu sei que parece ser meio chato, mas tem como me dar um norte de como resolver?

Procura em outras datapack esses bosses e troca, ou adiciona as spells deles. Por exemplo.

The Welter.xml

<?xml version="1.0" encoding="UTF-8"?>
<monster name="The Welter" nameDescription="The Welter" race="blood" experience="20000" speed="256" manacost="0">
   <health now="25000" max="25000"/>
   <look type="563" corpse="4283"/>
   <targetchange interval="2000" chance="5"/>
   <strategy attack="70" defense="10"/>
   <flags>
       <flag summonable="0"/>
       <flag attackable="1"/>
       <flag hostile="1"/>
       <flag illusionable="1"/>
       <flag convinceable="0"/>
       <flag pushable="0"/>
       <flag canpushitems="1"/>
       <flag canpushcreatures="1"/>
       <flag targetdistance="1"/>
       <flag staticattack="90"/>
       <flag runonhealth="300"/>
   </flags>
   <attacks>
       <attack name="melee" interval="2000" skill="90" attack="100"/>
       <attack name="poisoncondition" interval="2000" chance="17" length="8" spread="3" min="-500" max="-660">
           <attribute key="areaEffect" value="smallplants"/>
       </attack>
       <attack name="death" interval="2000" chance="14" length="8" spread="0" min="-200" max="-450">
           <attribute key="areaEffect" value="blacksmoke"/>
       </attack>
       <attack name="ice" interval="2000" chance="18" range="7" target="1" radius="4" min="-150" max="-270">
           <attribute key="shootEffect" value="ice"/>
           <attribute key="areaEffect" value="iceattack"/>
       </attack>
       <attack name="ice" interval="2000" chance="13" range="1" target="1" radius="1" min="-120" max="-230">
           <attribute key="shootEffect" value="ice"/>
           <attribute key="areaEffect" value="iceattack"/>
       </attack>
       <attack name="the welter paralyze" interval="2000" chance="9"/>
   </attacks>
   <defenses armor="27" defense="45">
       <defense name="healing" interval="2000" chance="32" min="250" max="600">
           <attribute key="areaEffect" value="blueshimmer"/>
       </defense>
       <defense name="healing" interval="2000" chance="12" radius="5" min="150" max="700">
           <attribute key="areaEffect" value="greenshimmer"/>
       </defense>
       <defense name="the welter summon2" interval="2000" chance="9"/>
       <defense name="the welter heal" interval="2000" chance="8"/>
   </defenses>
   <elements>
       <element icePercent="50"/>
       <element holyPercent="30"/>
       <element physicalPercent="-5"/>
       <element energyPercent="-10"/>
   </elements>
   <immunities>
       <immunity lifedrain="1"/>
       <immunity earth="1"/>
       <immunity paralyze="1"/>
       <immunity invisible="1"/>
   </immunities>
   <summons maxSummons="1">
       <summon name="egg2" interval="2000" chance="16"/>
       <summon name="spawn of the welter" interval="2000" chance="16"/>
   </summons>
   <voices interval="2000" chance="5">
       <voice sentence="FCHHHHH" yell="1"/>
       <voice sentence="HISSSS" yell="1"/>
   </voices>
   <loot>
       <item id="2195" chance="10000"/>
       <item id="21690" chance="5000"/>
       <item id="21691" chance="5000"/>
       <item id="2152" countmax="20" chance="100000"/>
       <item id="9971" chance="30000"/>
       <item id="10219" chance="50000" /> 
       <item id="21400" chance="5000"/>
       <item id="2197" chance="30000"/>
       <item id="2146" countmax="5" chance="50000"/>
       <item id="7632" chance="50000"/>
       <item id="2475" chance="5000"/>
       <item id="2476" chance="20000"/>
       <item id="2536" chance="20000"/>
       <item id="2498" chance="10000"/>
   </loot>
</monster>

Editado Julho 21, 2016 8 anos por Jobs (veja o histórico de edições)

Citar

Mention

GabrielOak reagiu a isso
1

Postado Julho 21, 2016 8 anos

10 minutos atrás, Jobs disse:

execute isso no SQL pra add as colunas na database

ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_critical_hit_damage_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_life_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount` int(10) unsigned NOT NULL DEFAULT 0
ALTER TABLE `players` ADD COLUMN `skill_mana_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT 0

Procura em outras datapack esses bosses e troca, ou adiciona as spells deles. Por exemplo.

The Welter.xml

Mostrar conteúdo oculto

<?xml version="1.0" encoding="UTF-8"?>
<monster name="The Welter" nameDescription="The Welter" race="blood" experience="20000" speed="256" manacost="0">
   <health now="25000" max="25000"/>
   <look type="563" corpse="4283"/>
   <targetchange interval="2000" chance="5"/>
   <strategy attack="70" defense="10"/>
   <flags>
       <flag summonable="0"/>
       <flag attackable="1"/>
       <flag hostile="1"/>
       <flag illusionable="1"/>
       <flag convinceable="0"/>
       <flag pushable="0"/>
       <flag canpushitems="1"/>
       <flag canpushcreatures="1"/>
       <flag targetdistance="1"/>
       <flag staticattack="90"/>
       <flag runonhealth="300"/>
   </flags>
   <attacks>
       <attack name="melee" interval="2000" skill="90" attack="100"/>
       <attack name="poisoncondition" interval="2000" chance="17" length="8" spread="3" min="-500" max="-660">
           <attribute key="areaEffect" value="smallplants"/>
       </attack>
       <attack name="death" interval="2000" chance="14" length="8" spread="0" min="-200" max="-450">
           <attribute key="areaEffect" value="blacksmoke"/>
       </attack>
       <attack name="ice" interval="2000" chance="18" range="7" target="1" radius="4" min="-150" max="-270">
           <attribute key="shootEffect" value="ice"/>
           <attribute key="areaEffect" value="iceattack"/>
       </attack>
       <attack name="ice" interval="2000" chance="13" range="1" target="1" radius="1" min="-120" max="-230">
           <attribute key="shootEffect" value="ice"/>
           <attribute key="areaEffect" value="iceattack"/>
       </attack>
       <attack name="the welter paralyze" interval="2000" chance="9"/>
   </attacks>
   <defenses armor="27" defense="45">
       <defense name="healing" interval="2000" chance="32" min="250" max="600">
           <attribute key="areaEffect" value="blueshimmer"/>
       </defense>
       <defense name="healing" interval="2000" chance="12" radius="5" min="150" max="700">
           <attribute key="areaEffect" value="greenshimmer"/>
       </defense>
       <defense name="the welter summon2" interval="2000" chance="9"/>
       <defense name="the welter heal" interval="2000" chance="8"/>
   </defenses>
   <elements>
       <element icePercent="50"/>
       <element holyPercent="30"/>
       <element physicalPercent="-5"/>
       <element energyPercent="-10"/>
   </elements>
   <immunities>
       <immunity lifedrain="1"/>
       <immunity earth="1"/>
       <immunity paralyze="1"/>
       <immunity invisible="1"/>
   </immunities>
   <summons maxSummons="1">
       <summon name="egg2" interval="2000" chance="16"/>
       <summon name="spawn of the welter" interval="2000" chance="16"/>
   </summons>
   <voices interval="2000" chance="5">
       <voice sentence="FCHHHHH" yell="1"/>
       <voice sentence="HISSSS" yell="1"/>
   </voices>
   <loot>
       <item id="2195" chance="10000"/>
       <item id="21690" chance="5000"/>
       <item id="21691" chance="5000"/>
       <item id="2152" countmax="20" chance="100000"/>
       <item id="9971" chance="30000"/>
       <item id="10219" chance="50000" /> 
       <item id="21400" chance="5000"/>
       <item id="2197" chance="30000"/>
       <item id="2146" countmax="5" chance="50000"/>
       <item id="7632" chance="50000"/>
       <item id="2475" chance="5000"/>
       <item id="2476" chance="20000"/>
       <item id="2536" chance="20000"/>
       <item id="2498" chance="10000"/>
   </loot>
</monster>

Amigo eu executei isso no phpmyadmin esse codigo e não funcionou como esta escrito.

se possivel envie um parck funcionando uma mysql um banco de dados que não esteja apresentando erros.

esteja perfeito. obrigado pela dica amigo porem ainda continua..

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance_tries` bigint(20) un' at line 2

Citar

Mention

Postado Julho 21, 2016 8 anos

2 minutos atrás, leandronetx disse:

Amigo eu executei isso no phpmyadmin esse codigo e não funcionou como esta escrito.

se possivel envie um parck funcionando uma mysql um banco de dados que não esteja apresentando erros.

esteja perfeito. obrigado pela dica amigo porem ainda continua..

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance_tries` bigint(20) un' at line 2

Adicione um por um cara, por exemplo.

 ALTER TABLE `players` ADD COLUMN `skill_critical_hit_chance` int(10) unsigned NOT NULL DEFAULT 0

Citar

Mention

Postado Julho 21, 2016 8 anos

15 minutos atrás, Jobs disse:

a questão do store dentro do jogo tem uma solução ?

para ele funcionar dentro do jogo.. e a pessoa compra com tibia coin ?

Citar

Mention

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

https://tibiaking.com/topic/36403-v32-globalfull-1112-new-asuras-falcons-warzones-456-updates-frequentes/

Seguidores

Ir para a lista de tópicos

Nenhum usuário registrado visualizando esta página.

[TFS 1.3] Otg Server - 11x / Otcv8 / Otc Menah / 12.40 (BASE CLEAN)
11.x

[TFS 1.3] Otg Server - 11x / Otcv8 / Otc Menah / 12.40 (BASE CLEAN)
Johncore · Outubro 26, 2023 1 ano
- 13x
- global
- johncore
- johncorex
- (e 8 mais)
  Tags:
  
  13x
  
  global
  
  johncore
  
  johncorex
  
  otg
  
  otg 1100
  
  otg global 11
  
  otg global 11x
  
  otg premium
  
  otg server
  
  otg server 1100
  
  otg server global
- 51 respostas
- 7280 visualizações
Johncore

Maio 1 Mai 1
Dragonsouls.com Map Full - compativel com Datapack Otg Server 11x 1.0.0
11.x

Dragonsouls.com Map Full - compativel com Datapack Otg Server 11x 1.0.0

Johncore · Fevereiro 28, 2024 1 ano
- dragonsoul
- dragonsouls
- dragonsouls map
- dragonsouls mapa
- (e 2 mais)
  Tags:
  
  dragonsoul
  
  dragonsouls
  
  dragonsouls map
  
  dragonsouls mapa
  
  dragonsouls otserv
  
  dragonsouls tibia
- 3 respostas
- 778 visualizações
Johncore

Março 5, 2024 1 ano
COMO POSSO IMPORTAR UMA CITY EMCIMA DE OUTRA CITY SEM PERDER AS HOUSES
11.x

COMO POSSO IMPORTAR UMA CITY EMCIMA DE OUTRA CITY SEM PERDER AS HOUSES

Dnzk21 · Janeiro 10, 2024 1 ano
- 2 respostas
- 521 visualizações
Dnzk21

Janeiro 12, 2024 1 ano
Cidade Arcadia 11.0
11.x

Cidade Arcadia 11.0
Johncore · Outubro 24, 2023 1 ano
- 7 respostas
- 3674 visualizações
Kazuya9629

Março 27, 2024 1 ano
.
11.x

.
Jaurez · Julho 11, 2017 7 anos
- 288 respostas
- 31880 visualizações
vitaoms

Novembro 2, 2019 5 anos

Tópicos 96.9k
Posts 519.6k

Respostas 3.6k
Visualizações 566.7k
Created 10 anos10 anos
Última resposta 3 anos3 anos

Entrar

[v32] GlobalFull 11/12 - New Asuras, Falcons, Warzones 4,5,6 . (Updates Frequentes)

Featured Replies

Top Posters In This Topic

Popular Days

Most Popular Posts

Qwizer

Johncore

Jobs

Posted Images

Participe da conversa

Quem Está Navegando 0

Conteúdo Similar

Estatísticas dos Fóruns

Top Posters In This Topic

Popular Days

Most Popular Posts

Qwizer

Johncore

Jobs

Posted Images

Informação Importante

Account

Navigation

Pesquisar