Apaguei meus Sample's sem saber da gravidade, "otservbr-global, canary client 13.20".

[mozart147 0]

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`, `Field`, `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 🥲

 

Editado 6 horas por mozart147