Admin Admin
Mensagens : 161 Data de inscrição : 07/02/2010 Idade : 28 Localização : Serra Talhada
| Assunto: Database LinServ Modificada Com Monstros e NPC's Dom Mar 07, 2010 7:56 am | |
| A Pedido Do JoemCoy , Uma Database Com monstros e Etc... Código: -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net-- -- Servidor: localhost -- Tempo de Geração: Set 20, 2009 as 04:07 -- Versão do Servidor: 5.1.37 -- Versão do PHP: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Banco de Dados: `lindb` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `account` -- CREATE TABLE IF NOT EXISTS `account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `password` text NOT NULL, `email` text NOT NULL, `admin` int(1) NOT NULL DEFAULT '0', `online` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Extraindo dados da tabela `account` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `characters` -- CREATE TABLE IF NOT EXISTS `characters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accountid` text NOT NULL, `name` text NOT NULL, `clanname` text NOT NULL, `class` int(11) NOT NULL DEFAULT '0', `gender` int(11) NOT NULL DEFAULT '0', `lawful` int(11) NOT NULL DEFAULT '0', `hp` int(11) NOT NULL DEFAULT '0', `maxhp` int(11) NOT NULL DEFAULT '0', `mp` int(11) NOT NULL DEFAULT '0', `maxmp` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '0', `armor` int(11) NOT NULL DEFAULT '0', `str` int(11) NOT NULL DEFAULT '0', `dex` int(11) NOT NULL DEFAULT '0', `con` int(11) NOT NULL DEFAULT '0', `wis` int(11) NOT NULL DEFAULT '0', `cha` int(11) NOT NULL DEFAULT '0', `intel` int(11) NOT NULL DEFAULT '0', `locx` int(11) NOT NULL DEFAULT '0', `locy` int(11) NOT NULL DEFAULT '0', `exp` int(11) NOT NULL DEFAULT '0', `nutrition` int(11) NOT NULL DEFAULT '0', `weight` int(11) NOT NULL DEFAULT '0', `fireres` int(11) NOT NULL DEFAULT '0', `windres` int(11) NOT NULL DEFAULT '0', `airres` int(11) NOT NULL DEFAULT '0', `earthres` int(11) NOT NULL DEFAULT '0', `isgm` int(11) NOT NULL DEFAULT '0', `charclasslistid` int(11) NOT NULL DEFAULT '0', `mapid` int(11) NOT NULL DEFAULT '0', `heading` int(11) NOT NULL DEFAULT '0', `title` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Extraindo dados da tabela `characters` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `charitems` -- CREATE TABLE IF NOT EXISTS `charitems` ( `id` int(11) NOT NULL AUTO_INCREMENT, `belongid` int(11) NOT NULL DEFAULT '0', `itemid` int(11) NOT NULL DEFAULT '0', `wielded` int(11) NOT NULL DEFAULT '0', `ided` int(11) NOT NULL DEFAULT '0', `enchantlvl` int(11) NOT NULL DEFAULT '0', `amount` int(11) NOT NULL DEFAULT '0', `cursed` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Extraindo dados da tabela `charitems` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `exptable` -- CREATE TABLE IF NOT EXISTS `exptable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `level` int(11) NOT NULL DEFAULT '0', `exp` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ; -- -- Extraindo dados da tabela `exptable` -- INSERT INTO `exptable` (`id`, `level`, `exp`) VALUES (1, 1, 125), (2, 2, 300), (3, 3, 500), (4, 4, 750), (5, 5, 1296), (6, 6, 2401), (7, 7, 4096), (8, 8, 6561), (9, 9, 10000), (10, 10, 14641), (11, 11, 20736), (12, 12, 28561), (13, 13, 38416), (14, 14, 50625), (15, 15, 65536), (16, 16, 83521), (17, 17, 104976), (18, 18, 130321), (19, 19, 160000), (20, 20, 194481), (21, 21, 234256), (22, 22, 279841), (23, 23, 331776), (24, 24, 390625), (25, 25, 456976), (26, 26, 531441), (27, 27, 614656), (28, 28, 707281), (29, 29, 810000), (30, 30, 923521), (31, 31, 1048576), (32, 32, 1185921), (33, 33, 1336336), (34, 34, 1500625), (35, 35, 1679616), (36, 36, 1874161), (37, 37, 2085136), (38, 38, 2313441), (39, 39, 2560000), (40, 40, 2825761), (41, 41, 3111696), (42, 42, 3418801), (43, 43, 3748096), (44, 44, 4100625), (45, 45, 4829985), (46, 46, 6338401), (47, 47, 9833664), (48, 48, 19745853), (49, 49, 55810945), (50, 50, 91876037), (51, 51, 127941129), (52, 52, 164006221), (53, 53, 200071313), (54, 54, 236136405), (55, 55, 272201497), (56, 56, 308266589), (57, 57, 344331681), (58, 58, 380396773), (59, 59, 416461865), (60, 60, 452526956), (61, 61, 488592048), (62, 62, 524657140), (63, 63, 560722232), (64, 64, 596787324), (65, 65, 668917508), (66, 66, 741047692), (67, 67, 813177876), (68, 68, 885308060), (69, 69, 957438244), (70, 70, 1101698612), (71, 71, 1245958980), (72, 72, 1390219348), (73, 73, 1534479716), (74, 74, 1678740084), (75, 75, 1967260820), (76, 76, 2255781556), (77, 77, 2544302292), (78, 78, 2832823028), (79, 79, 3121343764), (80, 80, 3698385236), (81, 81, 4275426708), (82, 82, 4852468180), (83, 83, 5429509652), (84, 84, 6006551124), (85, 85, 7160634068); -- -------------------------------------------------------- -- -- Estrutura da tabela `monsterdb` -- CREATE TABLE IF NOT EXISTS `monsterdb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `templateid` int(11) NOT NULL DEFAULT '0', `name` text NOT NULL, `level` int(11) NOT NULL DEFAULT '0', `hp` int(11) NOT NULL DEFAULT '0', `mp` int(11) NOT NULL DEFAULT '0', `ac` int(11) NOT NULL DEFAULT '0', `str` int(11) NOT NULL DEFAULT '0', `con` int(11) NOT NULL DEFAULT '0', `dex` int(11) NOT NULL DEFAULT '0', `wis` int(11) NOT NULL DEFAULT '0', `intel` int(11) NOT NULL DEFAULT '0', `mr` int(11) NOT NULL DEFAULT '0', `lawful` int(11) NOT NULL DEFAULT '0', `element` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Extraindo dados da tabela `monsterdb` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `movetable` -- CREATE TABLE IF NOT EXISTS `movetable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `mapid` int(11) NOT NULL DEFAULT '0', `locx` int(11) NOT NULL DEFAULT '0', `locy` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Extraindo dados da tabela `movetable` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `serversettings` -- CREATE TABLE IF NOT EXISTS `serversettings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `servertime` double(50,0) NOT NULL DEFAULT '0', `clienttime` double(50,0) NOT NULL DEFAULT '0', `idsused` double NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Extraindo dados da tabela `serversettings` -- INSERT INTO `serversettings` (`id`, `servertime`, `clienttime`, `idsused`) VALUES (1, 0, 0, 10000); OBS: Ela Ja Contem As Tabelas Criadas , Mais Fica Ao Seu Criterio Criar Os Monstros e etc.. | |
|