Ir para conteúdo

Adicionar Samples

Por M4G0
em Suporte Tibia OTServer

Featured Replies

Postado

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

 

Spoiler

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

 

Spoiler

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

 

Spoiler

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

 

Spoiler

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

 

Spoiler

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

 

Spoiler

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

Spoiler

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 por M4G0 (veja o histórico de edições)

[14:13:41] # Luuuuki ~ Absolute WAW: quebrou a cara, postou o comentário agradecendo
[14:13:43] # Luuuuki ~ Absolute WAW: ótimo caraq
[14:13:55] # Luuuuki ~ Absolute WAW: agr não vou dar moral pra você, o que foi vendido, foi entregue, e por sinal muito barato pra ajuda-lo
[14:14:01] # Luuuuki ~ Absolute WAW: e digo, essa atualização não vendo pra você
[14:14:08] # Luuuuki ~ Absolute WAW: Enorme abraço, evito contato.
[14:14:32] Marcos Meira: quebrei a cara pq confiei em vc
[14:14:40] Marcos Meira: e vc entrego um peck qualquer
[14:14:55] Marcos Meira: nem ferumbras quest tinha la nem nada
[14:15:17] Marcos Meira: e vc fico com o dinheiro
[14:15:18] Marcos Meira: eu fiz os itens monstro krailos tudo
[14:15:41] Marcos Meira: mais blz...
[14:16:33] Marcos Meira: nada melhor q o tempo, uma hora vc cai e vai enganar la da cadeia

 

LNetworks = Absolute =  Ladrão

 

Nunca Compre nada dele

  • Citar
  • Mention
    • 1 year later...

    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.

    Visitante
    Responder
    Ir para a lista de tópicos

    Quem Está Navegando 0

    • Nenhum usuário registrado visualizando esta página.

    Conteúdo Similar

    Estatísticas dos Fóruns

    • Tópicos 96.9k
    • Posts 519.6k

    Informação Importante

    Confirmação de Termo

    I accept