Postado Agosto 3, 2015 9 anos sempre quando eu entro no meu ot, (jogo, consigo itens e exp) e deslogo volta tudo (volta o lvl, os itens iniciais, os skills e etc) como se não tivesse salvado.. os erros são esse por favor ajuda ai, obrigado
Postado Agosto 3, 2015 9 anos Executa esse código na database: DROP TABLE IF EXISTS players; CREATE TABLE players ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR( 255 ) NOT NULL, world_id INTEGER NOT NULL DEFAULT '0', group_id INTEGER NOT NULL DEFAULT '1', account_id INTEGER NOT NULL, level INTEGER NOT NULL DEFAULT '1', vocation INTEGER NOT NULL DEFAULT '0', health INTEGER NOT NULL DEFAULT '100', healthmax INTEGER NOT NULL DEFAULT '100', experience INTEGER NOT NULL DEFAULT '0', lookbody INTEGER NOT NULL DEFAULT '10', lookfeet INTEGER NOT NULL DEFAULT '10', lookhead INTEGER NOT NULL DEFAULT '10', looklegs INTEGER NOT NULL DEFAULT '10', looktype INTEGER NOT NULL DEFAULT '136', lookaddons INTEGER NOT NULL DEFAULT '0', lookmount INTEGER NOT NULL DEFAULT '0', maglevel INTEGER NOT NULL DEFAULT '0', mana INTEGER NOT NULL DEFAULT '100', manamax INTEGER NOT NULL DEFAULT '100', manaspent INTEGER NOT NULL DEFAULT '0', soul INTEGER NOT NULL DEFAULT '0', town_id INTEGER NOT NULL, posx INTEGER NOT NULL DEFAULT '32369', posy INTEGER NOT NULL DEFAULT '32241', posz INTEGER NOT NULL DEFAULT '7', conditions BLOB NOT NULL, cap INTEGER NOT NULL DEFAULT '0', sex INTEGER NOT NULL DEFAULT '0', lastlogin INTEGER NOT NULL DEFAULT '0', lastip INTEGER NOT NULL DEFAULT '0', save BOOLEAN NOT NULL DEFAULT 'TRUE', skull INTEGER NOT NULL DEFAULT '0', skulltime INTEGER NOT NULL DEFAULT '0', rank_id INTEGER NOT NULL, guildnick VARCHAR( 255 ) NOT NULL DEFAULT '''', lastlogout INTEGER NOT NULL DEFAULT '0', blessings INTEGER NOT NULL DEFAULT '0', pvp_blessing BOOLEAN NOT NULL DEFAULT 'FALSE', balance INTEGER NOT NULL DEFAULT '0', stamina INTEGER NOT NULL DEFAULT '151200000', direction INTEGER NOT NULL DEFAULT '2', loss_experience INTEGER NOT NULL DEFAULT '100', loss_mana INTEGER NOT NULL DEFAULT '100', loss_skills INTEGER NOT NULL DEFAULT '100', loss_containers INTEGER NOT NULL DEFAULT '100', loss_items INTEGER NOT NULL DEFAULT '100', premend INTEGER NOT NULL DEFAULT '0', online INTEGER NOT NULL DEFAULT '0', marriage INTEGER NOT NULL DEFAULT '0', promotion INTEGER NOT NULL DEFAULT '0', deleted INTEGER NOT NULL DEFAULT '0', description VARCHAR( 255 ) NOT NULL DEFAULT '''', comment TEXT NOT NULL, create_ip INT( 11 ) NOT NULL DEFAULT '0', create_date INT( 11 ) NOT NULL DEFAULT '0', hide_char INT( 11 ) NOT NULL DEFAULT '0', signature TEXT NOT NULL, offlinetraining_time SMALLINT UNSIGNED NOT NULL DEFAULT '43200', offlinetraining_skill INT NOT NULL DEFAULT '-1', cast TINYINT( 4 ) NOT NULL DEFAULT '0', castViewers INT( 11 ) NOT NULL DEFAULT '0', castDescription VARCHAR( 255 ) NOT NULL, created INT( 11 ) NOT NULL DEFAULT '0', nick_verify INT( 11 ) NOT NULL DEFAULT '0', old_name VARCHAR( 255 ) NOT NULL DEFAULT '', worldtransfer INT( 11 ) NOT NULL DEFAULT '0', show_outfit TINYINT( 4 ) NOT NULL DEFAULT '1', show_eq TINYINT( 4 ) NOT NULL DEFAULT '1', show_bars TINYINT( 4 ) NOT NULL DEFAULT '1', show_skills TINYINT( 4 ) NOT NULL DEFAULT '1', show_quests TINYINT( 4 ) NOT NULL DEFAULT '1', stars INT( 10 ) NOT NULL DEFAULT '0', ip VARCHAR( 17 ) NOT NULL DEFAULT '0', UNIQUE ( name, deleted ), FOREIGN KEY ( account_id ) REFERENCES accounts ( id ) ); INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0); Caso não saiba como faça como manda na imagem: Esse também: DROP TABLE IF EXISTS killers; CREATE TABLE killers ( id INTEGER PRIMARY KEY, death_id INTEGER NOT NULL, final_hit BOOLEAN NOT NULL DEFAULT 'FALSE', unjustified BOOLEAN NOT NULL DEFAULT 'FALSE', war BIGINT NOT NULL DEFAULT '0', FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id ) ); E esse também: DROP TABLE IF EXISTS player_killers; CREATE TABLE player_killers ( kill_id INTEGER NOT NULL, player_id INTEGER NOT NULL, FOREIGN KEY ( kill_id ) REFERENCES killers ( id ), FOREIGN KEY ( player_id ) REFERENCES players ( id ) ); Editado Agosto 3, 2015 9 anos por Animal Pak (veja o histórico de edições)
Postado Agosto 3, 2015 9 anos Autor Executa esse código na database: DROP TABLE IF EXISTS players; CREATE TABLE players ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR( 255 ) NOT NULL, world_id INTEGER NOT NULL DEFAULT '0', group_id INTEGER NOT NULL DEFAULT '1', account_id INTEGER NOT NULL, level INTEGER NOT NULL DEFAULT '1', vocation INTEGER NOT NULL DEFAULT '0', health INTEGER NOT NULL DEFAULT '100', healthmax INTEGER NOT NULL DEFAULT '100', experience INTEGER NOT NULL DEFAULT '0', lookbody INTEGER NOT NULL DEFAULT '10', lookfeet INTEGER NOT NULL DEFAULT '10', lookhead INTEGER NOT NULL DEFAULT '10', looklegs INTEGER NOT NULL DEFAULT '10', looktype INTEGER NOT NULL DEFAULT '136', lookaddons INTEGER NOT NULL DEFAULT '0', lookmount INTEGER NOT NULL DEFAULT '0', maglevel INTEGER NOT NULL DEFAULT '0', mana INTEGER NOT NULL DEFAULT '100', manamax INTEGER NOT NULL DEFAULT '100', manaspent INTEGER NOT NULL DEFAULT '0', soul INTEGER NOT NULL DEFAULT '0', town_id INTEGER NOT NULL, posx INTEGER NOT NULL DEFAULT '32369', posy INTEGER NOT NULL DEFAULT '32241', posz INTEGER NOT NULL DEFAULT '7', conditions BLOB NOT NULL, cap INTEGER NOT NULL DEFAULT '0', sex INTEGER NOT NULL DEFAULT '0', lastlogin INTEGER NOT NULL DEFAULT '0', lastip INTEGER NOT NULL DEFAULT '0', save BOOLEAN NOT NULL DEFAULT 'TRUE', skull INTEGER NOT NULL DEFAULT '0', skulltime INTEGER NOT NULL DEFAULT '0', rank_id INTEGER NOT NULL, guildnick VARCHAR( 255 ) NOT NULL DEFAULT '''', lastlogout INTEGER NOT NULL DEFAULT '0', blessings INTEGER NOT NULL DEFAULT '0', pvp_blessing BOOLEAN NOT NULL DEFAULT 'FALSE', balance INTEGER NOT NULL DEFAULT '0', stamina INTEGER NOT NULL DEFAULT '151200000', direction INTEGER NOT NULL DEFAULT '2', loss_experience INTEGER NOT NULL DEFAULT '100', loss_mana INTEGER NOT NULL DEFAULT '100', loss_skills INTEGER NOT NULL DEFAULT '100', loss_containers INTEGER NOT NULL DEFAULT '100', loss_items INTEGER NOT NULL DEFAULT '100', premend INTEGER NOT NULL DEFAULT '0', online INTEGER NOT NULL DEFAULT '0', marriage INTEGER NOT NULL DEFAULT '0', promotion INTEGER NOT NULL DEFAULT '0', deleted INTEGER NOT NULL DEFAULT '0', description VARCHAR( 255 ) NOT NULL DEFAULT '''', comment TEXT NOT NULL, create_ip INT( 11 ) NOT NULL DEFAULT '0', create_date INT( 11 ) NOT NULL DEFAULT '0', hide_char INT( 11 ) NOT NULL DEFAULT '0', signature TEXT NOT NULL, offlinetraining_time SMALLINT UNSIGNED NOT NULL DEFAULT '43200', offlinetraining_skill INT NOT NULL DEFAULT '-1', cast TINYINT( 4 ) NOT NULL DEFAULT '0', castViewers INT( 11 ) NOT NULL DEFAULT '0', castDescription VARCHAR( 255 ) NOT NULL, created INT( 11 ) NOT NULL DEFAULT '0', nick_verify INT( 11 ) NOT NULL DEFAULT '0', old_name VARCHAR( 255 ) NOT NULL DEFAULT '', worldtransfer INT( 11 ) NOT NULL DEFAULT '0', show_outfit TINYINT( 4 ) NOT NULL DEFAULT '1', show_eq TINYINT( 4 ) NOT NULL DEFAULT '1', show_bars TINYINT( 4 ) NOT NULL DEFAULT '1', show_skills TINYINT( 4 ) NOT NULL DEFAULT '1', show_quests TINYINT( 4 ) NOT NULL DEFAULT '1', stars INT( 10 ) NOT NULL DEFAULT '0', ip VARCHAR( 17 ) NOT NULL DEFAULT '0', UNIQUE ( name, deleted ), FOREIGN KEY ( account_id ) REFERENCES accounts ( id ) ); INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0); Caso não saiba como faça como manda na imagem: Esse também: DROP TABLE IF EXISTS killers; CREATE TABLE killers ( id INTEGER PRIMARY KEY, death_id INTEGER NOT NULL, final_hit BOOLEAN NOT NULL DEFAULT 'FALSE', unjustified BOOLEAN NOT NULL DEFAULT 'FALSE', war BIGINT NOT NULL DEFAULT '0', FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id ) ); E esse também: DROP TABLE IF EXISTS player_killers; CREATE TABLE player_killers ( kill_id INTEGER NOT NULL, player_id INTEGER NOT NULL, FOREIGN KEY ( kill_id ) REFERENCES killers ( id ), FOREIGN KEY ( player_id ) REFERENCES players ( id ) ); Obrigado vou fazer pelo phpmyadmin porque eu uso mysql se der certo eu posto aqui ..
Postado Agosto 3, 2015 9 anos Solução Calma então se é por mysql os códigos são esses: DROP TABLE IF EXISTS `killers`; CREATE TABLE `killers` ( `id` INT NOT NULL AUTO_INCREMENT, `death_id` INT NOT NULL, `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `war` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `player_killers`; CREATE TABLE `player_killers` ( `kill_id` INT NOT NULL, `player_id` INT NOT NULL, FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `players`; CREATE TABLE `players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '10', `vocation` int(11) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '150', `healthmax` int(11) NOT NULL DEFAULT '150', `experience` bigint(20) unsigned NOT NULL DEFAULT '0', `lookbody` int(11) NOT NULL DEFAULT '0', `lookfeet` int(11) NOT NULL DEFAULT '0', `lookhead` int(11) NOT NULL DEFAULT '0', `looklegs` int(11) NOT NULL DEFAULT '0', `looktype` int(11) NOT NULL DEFAULT '136', `lookaddons` int(11) NOT NULL DEFAULT '0', `lookmount` int(11) NOT NULL DEFAULT '0', `maglevel` int(11) NOT NULL DEFAULT '0', `mana` int(11) NOT NULL DEFAULT '0', `manamax` int(11) NOT NULL DEFAULT '0', `manaspent` bigint(20) unsigned NOT NULL DEFAULT '0', `soul` int(10) unsigned NOT NULL DEFAULT '0', `town_id` int(11) NOT NULL DEFAULT '2', `posx` int(11) NOT NULL DEFAULT '32369', `posy` int(11) NOT NULL DEFAULT '32241', `posz` int(11) NOT NULL DEFAULT '7', `conditions` blob NOT NULL, `cap` int(11) NOT NULL DEFAULT '0', `sex` int(11) NOT NULL DEFAULT '0', `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0', `lastip` int(10) unsigned NOT NULL DEFAULT '0', `save` tinyint(1) NOT NULL DEFAULT '1', `skull` tinyint(1) unsigned NOT NULL DEFAULT '0', `skulltime` int(11) NOT NULL DEFAULT '0', `rank_id` int(11) NOT NULL DEFAULT '0', `guildnick` varchar(255) NOT NULL DEFAULT '', `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0', `blessings` tinyint(2) NOT NULL DEFAULT '0', `pvp_blessing` tinyint(1) NOT NULL DEFAULT '0', `balance` bigint(20) unsigned NOT NULL DEFAULT '0', `stamina` bigint(20) unsigned NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds', `direction` int(11) NOT NULL DEFAULT '2', `loss_experience` int(11) NOT NULL DEFAULT '100', `loss_mana` int(11) NOT NULL DEFAULT '100', `loss_skills` int(11) NOT NULL DEFAULT '100', `loss_containers` int(11) NOT NULL DEFAULT '100', `loss_items` int(11) NOT NULL DEFAULT '100', `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER', `online` tinyint(1) NOT NULL DEFAULT '0', `marriage` int(10) unsigned NOT NULL DEFAULT '0', `promotion` int(11) NOT NULL DEFAULT '0', `deleted` int(11) NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `comment` text NOT NULL, `create_ip` int(11) NOT NULL DEFAULT '0', `create_date` int(11) NOT NULL DEFAULT '0', `hide_char` int(11) NOT NULL DEFAULT '0', `signature` text NOT NULL, `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200', `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1', `cast` tinyint(4) NOT NULL DEFAULT '0', `castViewers` int(11) NOT NULL DEFAULT '0', `castDescription` varchar(255) NOT NULL, `created` int(11) NOT NULL DEFAULT '0', `nick_verify` int(11) NOT NULL DEFAULT '0', `old_name` varchar(255) NOT NULL DEFAULT '', `worldtransfer` int(11) NOT NULL DEFAULT '0', `show_outfit` tinyint(4) NOT NULL DEFAULT '1', `show_eq` tinyint(4) NOT NULL DEFAULT '1', `show_bars` tinyint(4) NOT NULL DEFAULT '1', `show_skills` tinyint(4) NOT NULL DEFAULT '1', `show_quests` tinyint(4) NOT NULL DEFAULT '1', `stars` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`deleted`), KEY `account_id` (`account_id`), KEY `group_id` (`group_id`), KEY `online` (`online`), KEY `deleted` (`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0);
Postado Agosto 4, 2015 9 anos Autor INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0); preciso também dos samples (1, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1), (2, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1), (3, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 1302858859, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1), (4, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1), (5, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1); tenho esses aqui em um documento, serve? e como faço pra colocar?nao achei ^^^^^^^^^^^^^^^^^^^^^^^ achei mais da esse erro >>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`id` , `name` , `world_id` , `group_id` , `account_id` , `level` , `vocation` , ' at line 1 Editado Agosto 4, 2015 9 anos por Characterevil (veja o histórico de edições)
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.