[Erro] ACC Manager - Programação - xTibia - Sua comunidade de Tibia e OTServ

Vorkhon

Campones

INFOS

Grupo: Campones

Registrado: 27/08/20

Posts: 52

Postado em agosto 30, 2020

Estou com um problema quando vou criar um personagem. O ACC manager diz "Your character couldn't be created, please contact with staff.". A unica coisa que eu fiz foi alterar alguns nomes no Vocation.xml, antes disso ele funcionava bem. Eu uso o sistema do Baiak 8.6 Forgotten. Esse erro esta aparecendo: "sqlite3_prepare_v2(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "broadcasting" = 0, "viewers" = 0 WHERE "id" = 1 LIMIT 1)"

Vocations.xml

<?xml version="1.0" encoding="UTF-8"?>

<vocations>
<vocation id="0" name="None" description="none" needpremium="0" gaincap="5" gainhp="5" gainmana="5" gainhpticks="6" gainhpamount="10" gainmanaticks="6" gainmanaamount="10" manamultiplier="4.0" attackspeed="1500" soulmax="100" gainsoulticks="120" fromvoc="0" attackable="no">
<formula meleeDamage="1.0" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="2.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.0"/>
<skill id="2" multiplier="1.0"/>
<skill id="3" multiplier="1.0"/>
<skill id="4" multiplier="1.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="1" name="Mage" description="a mage" needpremium="0" gaincap="10" gainhp="5" gainmana="30" gainhpticks="1" gainhpamount="20" gainmanaticks="1" gainmanaamount="50" manamultiplier="1.1" attackspeed="1500" soulmax="100" gainsoulticks="120" fromvoc="1">
<formula meleeDamage="1.0" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.0"/>
<skill id="2" multiplier="1.0"/>
<skill id="3" multiplier="1.0"/>
<skill id="4" multiplier="1.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="2" name="Druid" description="a druid" needpremium="0" gaincap="10" gainhp="5" gainmana="30" gainhpticks="1" gainhpamount="20" gainmanaticks="1" gainmanaamount="50" manamultiplier="1.1" attackspeed="1500" soulmax="100" gainsoulticks="120" fromvoc="2">
  <formula meleeDamage="1.0" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.0"/>
<skill id="2" multiplier="1.0"/>
<skill id="3" multiplier="1.0"/>
<skill id="4" multiplier="1.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="3" name="Archer" description="a archer" needpremium="0" gaincap="20" gainhp="10" gainmana="15" gainhpticks="1" gainhpamount="70" gainmanaticks="1" gainmanaamount="70" manamultiplier="1.4" attackspeed="1500" soulmax="100" gainsoulticks="120" fromvoc="3">
<formula meleeDamage="1.5" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.2"/>
<skill id="1" multiplier="1.2"/>
<skill id="2" multiplier="1.2"/>
<skill id="3" multiplier="1.2"/>
<skill id="4" multiplier="1.1"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="4" name="Knight" description="a knight" needpremium="0" gaincap="25" gainhp="15" gainmana="5" gainhpticks="1" gainhpamount="5" gainmanaticks="1" gainmanaamount="2" manamultiplier="3.0" attackspeed="1500" soulmax="100" gainsoulticks="120" fromvoc="4">
<formula meleeDamage="1.5" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.1"/>
<skill id="1" multiplier="1.1"/>
<skill id="2" multiplier="1.1"/>
<skill id="3" multiplier="1.1"/>
<skill id="4" multiplier="1.4"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="5" name="Wizard" description="a wizard" needpremium="1" gaincap="10" gainhp="5" gainmana="30" gainhpticks="1" gainhpamount="100" gainmanaticks="1" gainmanaamount="200" manamultiplier="1.1" attackspeed="850" soulmax="200" gainsoulticks="15" fromvoc="1" lessloss="10">
<formula meleeDamage="2.0" distDamage="1.0" wandDamage="1.5" magDamage="1.5" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.0"/>
<skill id="2" multiplier="1.0"/>
<skill id="3" multiplier="1.0"/>
<skill id="4" multiplier="1.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="6" name="Summoner" description="a summoner" needpremium="1" gaincap="10" gainhp="5" gainmana="30" gainhpticks="100" gainhpamount="100" gainmanaticks="1" gainmanaamount="200" manamultiplier="1.1" attackspeed="850" soulmax="700" gainsoulticks="15" fromvoc="2" lessloss="10">
<formula meleeDamage="2.0" distDamage="1.0" wandDamage="1.5" magDamage="1.5" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.0"/>
<skill id="2" multiplier="1.0"/>
<skill id="3" multiplier="1.0"/>
<skill id="4" multiplier="1.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="7" name="Assassin" description="a assassin" needpremium="1" gaincap="20" gainhp="10" gainmana="15" gainhpticks="1" gainhpamount="140" gainmanaticks="1" gainmanaamount="140" manamultiplier="1.4" attackspeed="850" soulmax="200" gainsoulticks="15" fromvoc="3" lessloss="10">
<formula meleeDamage="2.5" distDamage="2.5" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.5" armor="1.5"/>
<skill id="0" multiplier="1.2"/>
<skill id="1" multiplier="1.2"/>
<skill id="2" multiplier="1.2"/>
<skill id="3" multiplier="1.2"/>
<skill id="4" multiplier="1.1"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="8" name="Berserker" description="a berserker" needpremium="1" gaincap="25" gainhp="15" gainmana="15" gainhpticks="1" gainhpamount="10" gainmanaticks="1" gainmanaamount="5" manamultiplier="3.0" attackspeed="1200" soulmax="200" gainsoulticks="15" fromvoc="4" lessloss="10">
<formula meleeDamage="3.0" distDamage="1.0" wandDamage="1.0" magDamage="1.0" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.1"/>
<skill id="1" multiplier="1.1"/>
<skill id="2" multiplier="1.5"/>
<skill id="3" multiplier="1.5"/>
<skill id="4" multiplier="1.1"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="9" name="Magus" description="an magus" needpremium="0" gaincap="10" gainhp="50" gainmana="250" gainhpticks="4" gainhpamount="400" gainmanaticks="2" gainmanaamount="1000" manamultiplier="1.1" attackspeed="350" soulmax="100" gainsoulticks="15" fromvoc="5" lessloss="30">
<formula meleeDamage="3.0" distDamage="1.0" wandDamage="2.0" magDamage="1.2" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="2.0"/>
<skill id="2" multiplier="2.0"/>
<skill id="3" multiplier="2.0"/>
<skill id="4" multiplier="2.0"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="10" name="Shapeshifter" description="a shapeshifter" needpremium="0" gaincap="10" gainhp="50" gainmana="250" gainhpticks="4" gainhpamount="400" gainmanaticks="2" gainmanaamount="1000" manamultiplier="1.1" attackspeed="350" soulmax="100" gainsoulticks="15" fromvoc="6" lessloss="30">
<formula meleeDamage="3.0" distDamage="1.0" wandDamage="2.0" magDamage="1.2" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.5"/>
<skill id="1" multiplier="1.8"/>
<skill id="2" multiplier="1.8"/>
<skill id="3" multiplier="1.8"/>
<skill id="4" multiplier="1.8"/>
<skill id="5" multiplier="1.5"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="11" name="Marksman" description="an marksman" needpremium="0" gaincap="20" gainhp="150" gainmana="150" gainhpticks="3" gainhpamount="700" gainmanaticks="3" gainmanaamount="700" manamultiplier="1.4" attackspeed="300" soulmax="100" gainsoulticks="15" fromvoc="7" lessloss="30">
<formula meleeDamage="3.1" distDamage="1.1" wandDamage="1.0" magDamage="1.1" magHealingDamage="1.0" defense="1.0" armor="1.0"/>
<skill id="0" multiplier="1.2"/>
<skill id="1" multiplier="1.2"/>
<skill id="2" multiplier="1.2"/>
<skill id="3" multiplier="1.2"/>
<skill id="4" multiplier="1.1"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

<vocation id="12" name="Paladin" description="a paladin" needpremium="0" gaincap="25" gainhp="20" gainmana="10" gainhpticks="8" gainhpamount="5" gainmanaticks="4" gainmanaamount="10" manamultiplier="3.0" attackspeed="1500" soulmax="100" gainsoulticks="15" fromvoc="8" lessloss="30">
<formula meleeDamage="1.2" distDamage="1.0" wandDamage="1.0" magDamage="1.1" magHealingDamage="1.0" defense="3.0" armor="2.0"/>
<skill id="0" multiplier="1.1"/>
<skill id="1" multiplier="1.5"/>
<skill id="2" multiplier="1.5"/>
<skill id="3" multiplier="1.1"/>
<skill id="4" multiplier="1.1"/>
<skill id="5" multiplier="1.1"/>
<skill id="6" multiplier="1.1"/>
</vocation>

</vocations>

Hudsin

Cavaleiro

INFOS

Grupo: Cavaleiro

Registrado: 03/03/07

Posts: 150

Gênero: Masculino

Char no Tibia: Kaball Madness

Postado em outubro 17, 2020

Se você souber onde está lançando esse comando SQL e estiver diretamente assim:

UPDATE "players" SET "broadcasting" = 0, "viewers" = 0 WHERE "id" = 1 LIMIT 1

Substitua por:

UPDATE "players" SET "broadcasting" = 0, "viewers" = 0 WHERE "id" IN (SELECT "id" FROM "players" WHERE "id" = 1 LIMIT 1)

Fonte: stackoverflow

Obs: Se a coluna id for uma chave primária da tabela players no banco de dados, esse LIMIT 1 é totalmente desnecessário e resolveria apenas o removendo do código.