Outros Adicionar Samples

[M4G0 11]

Tive problema com os Samples pesquisei mas não solucionei o problema com a pesquisa, mais serviu de base para achar o caminho, então compartilho com vocês não é muita coisa mais...

execute no seu phpmyadmin>sql

 

 

Account Manager

 

  Mostrar conteúdo oculto

INSERT INTO `Nome Da Sua Tabela`.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('1', 'Account Manager', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

Rook Sample

 

  Mostrar conteúdo oculto

INSERT INTO ` Nome Da Sua Tabela `.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('2', 'Rook Sample', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

Sorcerer Sample

 

  Mostrar conteúdo oculto

INSERT INTO ` Nome Da Sua Tabela `.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('3', 'Sorcerer Sample', '1', '1', '8', '1', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

 

Druid Sample

 

  Mostrar conteúdo oculto

INSERT INTO ` Nome Da Sua Tabela `.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('4', 'Druid Sample', '1', '1', '8', '2', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

 

Paladin Sample

 

  Mostrar conteúdo oculto

INSERT INTO ` Nome Da Sua Tabela `.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('5', 'Paladin Sample', '1', '1', '8', '3', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

 

Knight Sample

 

  Mostrar conteúdo oculto

INSERT INTO ` Nome Da Sua Tabela `.`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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `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`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('6', 'Knight Sample', '1', '1', '8', '4', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');

 

Colunas contidas na minha tabela Players

  Mostrar conteúdo oculto

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      
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      
deleted      
description      
comment      
create_ip      
create_date      
hide_char      
cast

 

 

As Informação segue na mesma sequencia das colunas, Exemplo:

 

id = ID do char
name   = Nome Sample blabla
group_id = Grupo 1 player    
account_id = ID da Conta    
level = como ja diz o level do char
vocation = Vocação 0 None, 1 Sorcerer, 2 Druid, 3 Pala, 4 Kina

 

e assim por diante.

Editado Maio 30, 2016 por M4G0 (veja o histórico de edições)

[rodrygosos 7]

Topico antigos, mas muito util, funciona perfeitamente em qualquer gesior. Parabéns pelo conteúdo.