Projetos Open Source

Vou procurar, pois cassei muito pela task e todos são incompletos.. até baixei alguns globais 8.6 mas não são completos... tem um sistema bacana que tem o archvievements mas não possui o boss, e ele deu uma bugadinha no site os pontos estão contando errados e derrepente quando vc consegue um achievements ele fica aparecendo que vc tem 89281891291289 pontos..

82mateusroberto

OBS: Resolvido! Pessoal, boa noite no momento da postagem!   Então como no titulo fala acabei apagando meus Sample's da database e isso gerou diversos problemas e não consigo retorna-los por meio do SQL, meu servidor é um "otservbr-global, canary client 13.20" o comando que consegui estruturar pesquisando em diversos forum's foi o seguinte:   INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `blessings1`, `blessings2`, `blessings3`, `blessings4`, `blessings5`, `blessings6`, `blessings7`, `blessings8`, `onlinetime`, `deletion`, `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`, `skill_criticalhit_chance`, `skill_criticalhit_damage`, `skill_lifeleech_chance`, `skill_lifeleech_amount`, `skill_manaleech_chance`, `skill_manaleech_amount`, `manashield`, `max_manashield`, `xpboost_stamina`, `xpboost_value`, `marriage_status`, `marriage_spouse`, `bonus_rerolls`, `prey_wildcard`, `task_points`, `quickloot_fallback`, `lookmountbody`, `lookmountfeet`, `lookmounthead`, `lookmountlegs`, `lookfamiliarstype`, `isreward`, `istutorial`, `ismain`, `forge_dusts`, `forge_dust_level`, `randomize_mount`, `boss_points`, `created`, `hidden`, `comment`) VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, ''), (2, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, ''), (3, 'Sorcerer Sample', 0, 1, 1, 1, 1, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, ''), (4, 'Druid Sample', 0, 1, 1, 1, 2, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, ''), (5, 'Paladin Sample', 0, 1, 1, 1, 3, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, ''), (6, 'Knight Sample', 0, 1, 1, 1, 4, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '');   As colunas que a database me dá mediante o comando "DESC players;" são as seguintes:   id name group_id account_id level vocation health healthmax experience lookbody lookfeet lookhead looklegs looktype lookaddons maglevel mana manamax manaspent soul town_id posx posy posz conditions cap sex lastlogin lastip save skull skulltime lastlogout blessings blessings1 blessings2 blessings3 blessings4 blessings5 blessings6 blessings7 blessings8 onlinetime deletion 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 skill_criticalhit_chance skill_criticalhit_damage skill_lifeleech_chance skill_lifeleech_amount skill_manaleech_chance skill_manaleech_amount manashield max_manashield xpboost_stamina xpboost_value marriage_status marriage_spouse bonus_rerolls prey_wildcard task_points quickloot_fallback lookmountbody lookmountfeet lookmounthead lookmountlegs lookfamiliarstype isreward istutorial ismain forge_dusts forge_dust_level randomize_mount boss_points created hidden comment E o erro que aparece quando solto o comando lá no SQL é o: Mensagem do MySQL: http://localhost/phpmyadmin/themes/dot.gif #1136 - Contagem de colunas não confere com a contagem de valores na linha 1   Não queria ter que apagar toda a database para nao perder nada criado por isso meu "desespero" para tentar arrumar, help please 🥲