Normal [RESOLVIDO] Error while saving player ajuda

[pokemaniacoloko 0]

Boa tarde eu to com um erro que não salva o personagem no ot..

 

Eu to usando esse otsever com o cliente dele http://www.tibiaking.com/forum/topic/57156-global-full-860-zao-war-system-cast-system/

com esse site http://www.tibiaking.com/forum/topic/16706-gesior-100-seguro-anti-injection/#comment-89283  

Com xampp-win32-1.6.5 e windows 10

 

Eu procurei aqui no fórum achei uns tópicos mais sem resultado.. Deste já agradeço a atenção e a ajudas de vcs ...

 

Editado Janeiro 5, 2016 por pokemaniacoloko (veja o histórico de edições)

[NewCore 53]

Vá na sua database e na opção sql e coloque isto:

 

ALTER TABLE  `players` ADD   `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

[Fir3element 625]

Complementando a query do NewCore:

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

 

[pokemaniacoloko 0]

Bom me desculpe mais eu sou completa mente leigo eu procurei e só achei uma database que tinha na pasta do meu ot n sei s era essa mais n tinha opção sql... Eu nem sei se to procurando no lugar certo... Se não for incomoda, vcs poderiam me falar o caminho q eu tenho q fazer até chegar na database..... ou e no localhost q tenho q mexer?????

Editado Janeiro 4, 2016 por pokemaniacoloko (veja o histórico de edições)

[NewCore 53]

Vá no localhost/phpmyadmin

 

Entre, selecione a database do seu ot, la encima tem as opções, selecione sql, coloque o comando e execute.

[pokemaniacoloko 0]

Não deu eu executei o comando q vcs me passaram mais mesmo assim o erro continua quando eu log no ot da esse erro

 

 

[19:36:54.102] mysql_real_query(): SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 8 AND `k`.`unjustified` = 1 AND `pd`.`date` >= 1451360214 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)
[19:36:54.117] Zica Mesmo has logged in.
[19:36:54.133] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'fefe123'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)
[19:36:54.133] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'fefe123'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)
[19:36:54.133] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'fefe123'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)
[19:36:54.149] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'fefe123'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054) 

 

Quando eu deslog o erro a muinto maior 

[NewCore 53]

ALTER TABLE `accounts` ADD `vip_time` INT( 11 ) NOT NULL DEFAULT '0';

 Add isso tb:

 

  ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

 

Editado Janeiro 4, 2016 por NewCore (veja o histórico de edições)

[pokemaniacoloko 0]

Mano virei seu fã deu todo certo aki meus rep ++

vc sabe como eu tiro ou edito aquela mensagem quando loga [For Your Informatiom]

eo que quer dizer??

 

 

Editado Janeiro 4, 2016 por pokemaniacoloko (veja o histórico de edições)

[Absolute 0]

27 minutos atrás, pokemaniacoloko disse:

Mano virei seu fã deu todo certo aki meus rep ++

vc sabe como eu tiro ou edito aquela mensagem quando loga [For Your Informatiom]

eo que quer dizer??

 

 

 

 

 

Não tem como saber o local exato para editar o script, veja no seu login.lua, welcome.lua na apsta creaturescripts/scripts está dentro de algo aí.

[pokemaniacoloko 0]

Firmesa duvidas Resolvidas...... Maus eu qui de novo e quando o play ta upano lv ou skill da esse erro

[ mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '0', '18', '19', '1451971487' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)
[21:25:43.699] mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '5', '17', '18', '1451971543' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)] 

 

Eu não sei se esse erro altera alguma coisa no ot o save dos play ou se é normal.. 

 

Editado Janeiro 4, 2016 por pokemaniacoloko (veja o histórico de edições)

[Absolute 0]

35 minutos atrás, pokemaniacoloko disse:

Firmesa duvidas Resolvidas...... Maus eu qui de novo e quando o play ta upano lv ou skill da esse erro

[ mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '0', '18', '19', '1451971487' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)
[21:25:43.699] mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '5', '17', '18', '1451971543' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)]

 

 

 

 

 

Insira no seu phpmyadmin:

CREATE TABLE `player_advances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `skill` int(11) DEFAULT NULL,
  `oldlevel` int(11) DEFAULT NULL,
  `newlevel` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cid` (`cid`),
  CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;  

 

[pokemaniacoloko 0]

Mano amanhã eu de dou meu rep q ja dei os 5 mais lvl mesmo deu certinho aki sem mais erros ate aki vale 

[ILex WilL 3]

[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','DV6MV-4KBJL-X1F3I-OGJZF'),(8,2,102,2173,1,'€\0\0charges\0\0\0','D19CC-NBUN5-J2NWS-NK3DN'),(8,3,103,10522,1,'','MJWBN-8HULV-X4BFF-TD0T8'),(8,4,104,2487,1,'','G9ZDF-82TNQ-58RHB-D1M3N'),(8,5,105,7366,1,'','QK539-TZPOE-O5S0K-5QITR'),(8,6,106,2519,1,'','MC8ZE-CXGS6-YB6CN-3WX90'),(8,7,107,2488,1,'','2NNR6-XZD44-1NODO-WZ1JI'),(8,8,108,2195,1,'','TW06J-PWP06-GEU90-G30X2'),(8,9,109,2124,1,'','48HQW-2LKJQ-VTRXV-3GX6N'),(8,10,110,7368,1,'','XRRCL-52ZSH-CL3HQ-DVPOJ'),(8,103,111,8472,1,'','OGF0K-RK1EV-LEHD7-ZB9YB'),(8,103,112,7618,1,'','EVPMJ-LOF83-GUWLF-UOS60'),(8,103,113,7620,1,'','4BMYK-Y42R2-NE88L-YRX0N'),(8,103,114,2789,50,'2','3GWFY-LR2LT-F6UZ6-9KKXF'),(8,103,115,2160,15,'','BRB1Z-LMTUR-CTUU7-W7QE8'),(8,103,116,5710,1,'','5RWLP-KBRRT-JZ3TT-LLYZG'),(8,103,117,2120,1,'','8O9SM-4TXVF-NHEN1-DQRE6') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','MTTU1-IC00Y-68KO3-QCHD9'),(8,2,102,2173,1,'€\0\0charges\0\0\0','8GOCQ-6BPCQ-SDF8R-7LSX5'),(8,3,103,10522,1,'','JBZH3-IQO3C-Z5T0J-LLNW3'),(8,4,104,2487,1,'','P302S-K22IN-YOZW2-JJT3O'),(8,5,105,7366,1,'','6WKZ7-W3MNZ-9LBB4-EBK4S'),(8,6,106,2519,1,'','MDYLG-S9TRD-3CTMW-FS4CK'),(8,7,107,2488,1,'','6TOCN-CK7OL-QR7NX-N3SLU'),(8,8,108,2195,1,'','0NKFW-HJBOV-0ZFBW-LIIV4'),(8,9,109,2124,1,'','SSMJE-3W3JG-NEBVU-P85BV'),(8,10,110,7368,1,'','6Q8GZ-T531P-8KG2L-S4V6J'),(8,103,111,8472,1,'','BHPTW-J2RF4-GLE94-DQLLQ'),(8,103,112,7618,1,'','I1CKE-4GI25-BNME7-XEE7R'),(8,103,113,7620,1,'','T3P47-OLWJY-GMNML-77BGU'),(8,103,114,2789,50,'2','FMD10-LOVGR-TY3EB-0VTOO'),(8,103,115,2160,15,'','NPT3E-VMMGV-8KSVY-EVO1C'),(8,103,116,5710,1,'','ECFX1-7G6TH-FIY6M-40H2S'),(8,103,117,2120,1,'','DGDHF-G9P0L-GF97Y-3CTH9') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','4ZSK2-V6W9S-8IJTX-JQX3W'),(8,2,102,2173,1,'€\0\0charges\0\0\0','XM4WF-UVSFX-M8IET-VXX1W'),(8,3,103,10522,1,'','PQYNH-DD5JE-S1I84-JJD6V'),(8,4,104,2487,1,'','KXPZM-ZW116-J47RB-VYCLE'),(8,5,105,7366,1,'','CM7X8-9S1TS-WFB9E-TEX24'),(8,6,106,2519,1,'','NX947-ZQY1F-PMKIV-BW8R8'),(8,7,107,2488,1,'','GFRMP-Y6S72-B41T3-MSXJ8'),(8,8,108,2195,1,'','IM5KI-53VCW-U7R2V-W4KNV'),(8,9,109,2124,1,'','QEF32-PUKSZ-P0BW8-FWLBH'),(8,10,110,7368,1,'','N5BI9-BS4FX-3XCVF-UROZ3'),(8,103,111,8472,1,'','WNV62-L22G0-S987N-UBI35'),(8,103,112,7618,1,'','DUIWH-BP486-GP8U1-T9KFT'),(8,103,113,7620,1,'','V0PO9-N5V2Q-KMMND-J1V04'),(8,103,114,2789,50,'2','QHU83-BTXLN-U9QZ8-9YV68'),(8,103,115,2160,15,'','VUPLG-4533P-I4HTN-L492N'),(8,103,116,5710,1,'','OUV0D-SBBVD-96BPR-XPVZZ'),(8,103,117,2120,1,'','T5KC1-SDW7F-WG2Q8-L5TS2') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] Error while saving player: Test One.
[7/6/2018 15:52:6] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial` FROM `player_items` WHERE `player_id` = 8 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:6] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial` FROM `player_depotitems` WHERE `player_id` = 8 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:7] Test One has logged in.

 

 

 

 

Estou com esse ERRO. Alguém poderia me ajuda? Agradeço....

[wallaceg15 1]

ALGUEM PODERIA ME AJUDAR
MEU SQL STUDIO NAO TA SALVANDO O CHAR, TA DANDO ISSO, E NAO MEXO COM XAMPP N 

 

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: player_items (SELECT "pid", "sid", "itemtype", "count", "attributes" FROM "player_items" WHERE "player_id" = 2 ORDER BY "sid" DESC)