maicon17

Solução para esse problema: 1° No banco de dados do seu otserv apague a tabela player_skills. 2º Vá em SQL e dicione isto: CREATE TABLE `player_skills` ( `player_id` int(11) NOT NULL default '0', `skillid` tinyint(2) NOT NULL default '0', `value` int(10) unsigned NOT NULL default '0', `count` int(10) unsigned NOT NULL default '0', UNIQUE KEY `player_id_2` (`player_id`,`skillid`), KEY `player_id` (`player_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3° Novamente em SQL adicione isto: INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (2, 0, 10, 0), (2, 1, 10, 0), (2, 2, 10, 0), (2, 3, 10, 0), (2, 4, 10, 0), (2, 5, 10, 0), (2, 6, 10, 0), (3, 0, 10, 0), (3, 1, 10, 0), (3, 2, 10, 0), (3, 3, 10, 0), (3, 4, 10, 0), (3, 5, 10, 0), (3, 6, 10, 0), (4, 0, 10, 0), (4, 1, 10, 0), (4, 2, 10, 0), (4, 3, 10, 0), (4, 4, 10, 0), (4, 5, 10, 0), (4, 6, 10, 0), (5, 0, 10, 0), (5, 1, 10, 0), (5, 2, 10, 0), (5, 3, 10, 0), (5, 4, 10, 0), (5, 5, 10, 0), (5, 6, 10, 0), (6, 0, 10, 0), (6, 1, 10, 0), (6, 2, 10, 0), (6, 3, 10, 0), (6, 4, 10, 0), (6, 5, 10, 0), (6, 6, 10, 0), (7, 0, 45, 297), (7, 1, 45, 657), (7, 2, 45, 447), (7, 3, 128, 0), (7, 4, 128, 0), (7, 5, 44, 667), (7, 6, 10, 0), (8, 0, 10, 0), (8, 1, 10, 0), (8, 2, 10, 0), (8, 3, 10, 0), (8, 4, 10, 0), (8, 5, 10, 0), (8, 6, 10, 0), (9, 0, 10, 0), (9, 1, 10, 0), (9, 2, 10, 0), (9, 3, 10, 0), (9, 4, 10, 0), (9, 5, 10, 0), (9, 6, 10, 0), (10, 0, 10, 0), (10, 1, 10, 0), (10, 2, 10, 0), (10, 3, 10, 0), (10, 4, 10, 0), (10, 5, 10, 0), (10, 6, 10, 0), (11, 0, 10, 0), (11, 1, 10, 0), (11, 2, 10, 0), (11, 3, 10, 0), (11, 4, 10, 0), (11, 5, 10, 0), (11, 6, 10, 0), (12, 0, 10, 0), (12, 1, 10, 0), (12, 2, 10, 0), (12, 3, 10, 0), (12, 4, 10, 0), (12, 5, 10, 0), (12, 6, 10, 0), (13, 0, 10, 0), (13, 1, 10, 0), (13, 2, 10, 0), (13, 3, 10, 0), (13, 4, 10, 0), (13, 5, 10, 0), (13, 6, 10, 0), (14, 0, 10, 0), (14, 1, 10, 0), (14, 2, 10, 0), (14, 3, 10, 0), (14, 4, 10, 0), (14, 5, 10, 0), (14, 6, 10, 0), (15, 0, 10, 0), (15, 1, 10, 0), (15, 2, 10, 0), (15, 3, 10, 0), (15, 4, 10, 0), (15, 5, 10, 0), (15, 6, 10, 0), (16, 0, 10, 0), (16, 1, 10, 0), (16, 2, 10, 0), (16, 3, 10, 0), (16, 4, 10, 0), (16, 5, 25, 27828), (16, 6, 10, 0), (17, 0, 10, 0), (17, 1, 10, 0), (17, 2, 10, 0), (17, 3, 10, 0), (17, 4, 10, 0), (17, 5, 10, 0), (17, 6, 10, 0), (18, 0, 10, 0), (18, 1, 10, 0), (18, 2, 10, 0), (18, 3, 92, 116310255), (18, 4, 72, 1566), (18, 5, 85, 27884), (18, 6, 10, 0), (19, 0, 10, 0), (19, 1, 10, 0), (19, 2, 10, 0), (19, 3, 10, 0), (19, 4, 10, 0), (19, 5, 10, 0), (19, 6, 10, 0), (20, 0, 10, 0), (20, 1, 10, 0), (20, 2, 10, 0), (20, 3, 10, 0), (20, 4, 10, 0), (20, 5, 10, 0), (20, 6, 10, 0), (21, 0, 10, 0), (21, 1, 10, 0), (21, 2, 10, 0), (21, 3, 10, 0), (21, 4, 10, 0), (21, 5, 10, 0), (21, 6, 10, 0), (22, 0, 10, 0), (22, 1, 10, 0), (22, 2, 10, 0), (22, 3, 10, 0), (22, 4, 10, 0), (22, 5, 10, 0), (22, 6, 10, 0), (23, 0, 10, 0), (23, 1, 10, 0), (23, 2, 10, 0), (23, 3, 10, 0), (23, 4, 10, 0), (23, 5, 10, 0), (23, 6, 10, 0), (24, 0, 13, 7), (24, 1, 10, 0), (24, 2, 10, 0), (24, 3, 10, 0), (24, 4, 10, 0), (24, 5, 10, 0), (24, 6, 10, 0), (25, 0, 10, 0), (25, 1, 10, 0), (25, 2, 10, 0), (25, 3, 10, 0), (25, 4, 10, 0), (25, 5, 10, 0), (25, 6, 10, 0), (26, 0, 10, 0), (26, 1, 10, 0), (26, 2, 10, 0), (26, 3, 10, 0), (26, 4, 10, 0), (26, 5, 10, 0), (26, 6, 10, 0), (27, 0, 10, 0), (27, 1, 10, 0), (27, 2, 10, 0), (27, 3, 10, 0), (27, 4, 10, 0), (27, 5, 16, 23), (27, 6, 10, 0), (28, 0, 10, 0), (28, 1, 10, 0), (28, 2, 10, 0), (28, 3, 10, 0), (28, 4, 10, 0), (28, 5, 10, 0), (28, 6, 10, 0), (29, 0, 10, 0), (29, 1, 10, 0), (29, 2, 10, 0), (29, 3, 10, 0), (29, 4, 10, 0), (29, 5, 10, 0), (29, 6, 10, 0), (30, 0, 10, 0), (30, 1, 10, 0), (30, 2, 10, 0), (30, 3, 10, 0), (30, 4, 10, 0), (30, 5, 10, 0), (30, 6, 10, 0), (31, 0, 10, 0), (31, 1, 10, 0), (31, 2, 10, 0), (31, 3, 10, 0), (31, 4, 10, 0), (31, 5, 10, 0), (31, 6, 10, 0), (32, 0, 10, 0), (32, 1, 10, 0), (32, 2, 10, 0), (32, 3, 10, 0), (32, 4, 10, 0), (32, 5, 10, 0), (32, 6, 10, 0), (33, 0, 10, 0), (33, 1, 10, 0), (33, 2, 10, 0), (33, 3, 51, 0), (33, 4, 10, 0), (33, 5, 44, 127), (33, 6, 10, 0), (34, 0, 10, 0), (34, 1, 10, 0), (34, 2, 10, 0), (34, 3, 10, 0), (34, 4, 10, 0), (34, 5, 10, 0), (34, 6, 10, 0), (35, 0, 10, 0), (35, 1, 10, 0), (35, 2, 10, 0), (35, 3, 10, 0), (35, 4, 10, 0), (35, 5, 10, 0), (35, 6, 10, 0), (36, 0, 10, 0), (36, 1, 10, 0), (36, 2, 10, 0), (36, 3, 10, 0), (36, 4, 10, 0), (36, 5, 10, 0), (36, 6, 10, 0), (37, 0, 10, 0), (37, 1, 10, 0), (37, 2, 10, 0), (37, 3, 10, 0), (37, 4, 10, 0), (37, 5, 10, 0), (37, 6, 10, 0), (38, 0, 10, 0), (38, 1, 10, 0), (38, 2, 10, 0), (38, 3, 10, 0), (38, 4, 64, 2826), (38, 5, 10, 0), (38, 6, 10, 0), (39, 0, 10, 0), (39, 1, 10, 0), (39, 2, 10, 0), (39, 3, 10, 0), (39, 4, 10, 0), (39, 5, 10, 0), (39, 6, 10, 0), (40, 0, 10, 0), (40, 1, 10, 0), (40, 2, 10, 0), (40, 3, 10, 0), (40, 4, 10, 0), (40, 5, 10, 0), (40, 6, 10, 0), (41, 0, 10, 0), (41, 1, 10, 0), (41, 2, 10, 0), (41, 3, 10, 0), (41, 4, 10, 0), (41, 5, 10, 0), (41, 6, 10, 0), (42, 0, 10, 0), (42, 1, 10, 0), (42, 2, 10, 0), (42, 3, 10, 0), (42, 4, 10, 0), (42, 5, 10, 0), (42, 6, 10, 0), (43, 0, 10, 0), (43, 1, 10, 0), (43, 2, 10, 0), (43, 3, 10, 0), (43, 4, 10, 0), (43, 5, 10, 0), (43, 6, 10, 0), (44, 0, 10, 0), (44, 1, 10, 0), (44, 2, 10, 0), (44, 3, 10, 0), (44, 4, 10, 0), (44, 5, 10, 0), (44, 6, 10, 0), (45, 0, 10, 0), (45, 1, 10, 0), (45, 2, 10, 0), (45, 3, 10, 0), (45, 4, 10, 0), (45, 5, 10, 0), (45, 6, 10, 0), (46, 0, 10, 0), (46, 1, 10, 0), (46, 2, 10, 0), (46, 3, 10, 0), (46, 4, 10, 0), (46, 5, 10, 0), (46, 6, 10, 0), (47, 0, 10, 0), (47, 1, 10, 0), (47, 2, 10, 0), (47, 3, 10, 0), (47, 4, 10, 0), (47, 5, 10, 0), (47, 6, 10, 0), (48, 0, 10, 0), (48, 1, 10, 0), (48, 2, 10, 0), (48, 3, 10, 0), (48, 4, 10, 0), (48, 5, 10, 0), (48, 6, 10, 0), (49, 0, 10, 0), (49, 1, 10, 0), (49, 2, 10, 0), (49, 3, 10, 0), (49, 4, 10, 0), (49, 5, 10, 0), (49, 6, 10, 0), (50, 0, 10, 0), (50, 1, 10, 0), (50, 2, 10, 0), (50, 3, 10, 0), (50, 4, 10, 0), (50, 5, 10, 0), (50, 6, 10, 0), (51, 0, 15, 60), (51, 1, 10, 0), (51, 2, 10, 0), (51, 3, 10, 0), (51, 4, 10, 0), (51, 5, 10, 0), (51, 6, 10, 0), (52, 0, 16, 0), (52, 1, 10, 0), (52, 2, 10, 0), (52, 3, 10, 0), (52, 4, 10, 0), (52, 5, 10, 0), (52, 6, 10, 0), (53, 0, 50, 1890), (53, 1, 10, 0), (53, 2, 30, 88), (53, 3, 10, 0), (53, 4, 10, 0), (53, 5, 44, 2167), (53, 6, 10, 0), (54, 0, 10, 0), (54, 1, 10, 0), (54, 2, 10, 0), (54, 3, 10, 0), (54, 4, 10, 0), (54, 5, 10, 0), (54, 6, 10, 0), (55, 0, 10, 0), (55, 1, 10, 0), (55, 2, 10, 0), (55, 3, 10, 0), (55, 4, 10, 0), (55, 5, 10, 0), (55, 6, 10, 0), (56, 0, 10, 0), (56, 1, 10, 0), (56, 2, 10, 0), (56, 3, 10, 0), (56, 4, 10, 0), (56, 5, 10, 0), (56, 6, 10, 0), (57, 0, 10, 0), (57, 1, 10, 0), (57, 2, 10, 0), (57, 3, 10, 0), (57, 4, 10, 0), (57, 5, 10, 0), (57, 6, 10, 0), (58, 0, 10, 0), (58, 1, 10, 0), (58, 2, 10, 0), (58, 3, 10, 0), (58, 4, 10, 0), (58, 5, 10, 0), (58, 6, 10, 0), (59, 0, 10, 0), (59, 1, 10, 0), (59, 2, 10, 0), (59, 3, 10, 0), (59, 4, 10, 0), (59, 5, 10, 0), (59, 6, 10, 0), (60, 0, 10, 0), (60, 1, 10, 0), (60, 2, 10, 0), (60, 3, 10, 0), (60, 4, 10, 0), (60, 5, 10, 0), (60, 6, 10, 0), (61, 0, 10, 0), (61, 1, 10, 0), (61, 2, 10, 0), (61, 3, 10, 0), (61, 4, 10, 0), (61, 5, 10, 0), (61, 6, 10, 0), (62, 0, 10, 0), (62, 1, 10, 0), (62, 2, 10, 0), (62, 3, 10, 0), (62, 4, 10, 0), (62, 5, 10, 0), (62, 6, 10, 0), (63, 0, 10, 0), (63, 1, 10, 0), (63, 2, 10, 0), (63, 3, 10, 0), (63, 4, 10, 0), (63, 5, 10, 0), (63, 6, 10, 0), (64, 0, 10, 0), (64, 1, 10, 0), (64, 2, 10, 0), (64, 3, 10, 0), (64, 4, 10, 0), (64, 5, 10, 0), (64, 6, 10, 0), (65, 0, 10, 0), (65, 1, 10, 0), (65, 2, 10, 0), (65, 3, 10, 0), (65, 4, 10, 0), (65, 5, 10, 0), (65, 6, 10, 0), (66, 0, 10, 0), (66, 1, 10, 0), (66, 2, 10, 0), (66, 3, 10, 0), (66, 4, 10, 0), (66, 5, 10, 0), (66, 6, 10, 0), (67, 0, 10, 0), (67, 1, 10, 0), (67, 2, 10, 0), (67, 3, 10, 0), (67, 4, 10, 0), (67, 5, 10, 0), (67, 6, 10, 0), (68, 0, 10, 0), (68, 1, 10, 0), (68, 2, 10, 0), (68, 3, 10, 0), (68, 4, 10, 0), (68, 5, 10, 0), (68, 6, 10, 0), (69, 0, 10, 0), (69, 1, 10, 0), (69, 2, 10, 0), (69, 3, 10, 0), (69, 4, 10, 0), (69, 5, 10, 0), (69, 6, 10, 0), (70, 0, 10, 0), (70, 1, 10, 0), (70, 2, 10, 0), (70, 3, 10, 0), (70, 4, 10, 0), (70, 5, 10, 0), (70, 6, 10, 0); Pronto! Esse tipo de erro ocorre quando você tem alguma alteração nas vocações em sua pasta XML ou na própria data base inserindo uma tabela com erro ou com alguma informação ausente.

Estou tentando colocar 2 dias de premium account de graça para todo mundo que criar account nova no meu otserv que ainda vou abrir. No meu confg.php coloquei a tag: $config['site']['account_premdays'] = 2; // how many days receive new account Crio uma account nova e quando logo no otserv aparece na tela de login os dois dias de premium account, porém no site continua dizendo que ela está free account então eu deslogo o personagem e faço um novo login com a mesma conta então some os dois dias em vermelho e volta a aparecer Free account, como se não estivesse salvando, pois realmente não está salvando na account em minha Database, apenas aparece a mensagem quando loga a primeira vez. Mais quando uso uma premium scroll no jogo de 15 ou 30 dias por exemplo eu viro premium e aparece no site, mais ai não adianta de nada pois eu quero que a account comece já com premium. Uma coisa que notei foi que a data que expira não está contando tempo, pois em minha database os dias de premium são adicionados ao clicar na premium scroll e ela nos dá 15 ou 30 dias e vai aparecer esses valores na linha "premdays" e não uma data com numeros que nem na vip, por exemplo: "1239958" como se fosse uma data codificada. Isso é o que aparece quando faço login na conta do god por exemplo: Account Status: Premium Account, 135 dias restantes. (Premium time expira em 31/12/1969 21:02:15) o mesmo aparece para todas as accounts que crio! Ai está a linha de comando em meu accountmanagement.php: <tr style="background-color:'.$config['site']['darkborder'].';" ><td class="LabelV">Account Status:</td><td>'.$account_status.'<br><small>(Premium time expira em '.date("d/m/Y, G:i:s", $account_logged->getCustomField("premdays")).')</small></td></tr> quando eu altero o "premdays" para "vip_time" por exemplo aparece uma outra data diferente pois lá como eu informei antes não tem um número simples e sim uma sequência de números que representam uma quantidade. Eu precisava de uma forma de fazer o mesmo com a premdays ou uma forma mais fácil de colocar 2 dias de premium account para as novas accounts, é isso que estou pedindo, se alguém souber eu fico grato. accountmanagement.php