lunia服务端。路尼亚战记。已经测验。端的内容无缺。需要高手弄出架设
本帖最后由 mzcc2009 于 2010-4-3 07:09 编辑
http://robotex.allprog.nl/renshou/luniaserver.rar
模拟器的路尼亚战记架设教程(不包括客户端)
经过不断努力终于把那个路尼亚战记模拟器的那端架设好了`…..“`
先说“我只架设好模拟器““客户端还在研究中`…..
““先安装MYSQL5.1
还有Navicat
用Navicat连接上MYSQL
创建一个名字为lunia_db的数据库 “…
在该数据库上点右键 再点console….这个选项
然后把分割线下面的文字粘贴并回车
————————————华丽的分割线复制下面的不要包括我—————————————————————-
— phpMyAdmin SQL Dump
— version 2.11.9.2
—
http://www.phpmyadmin.net
—
— Host: localhost
— Generato il: 15 Set, 2009 at 01:21 PM
— Versione MySQL: 5.0.67
— Versione PHP: 5.2.6
SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
—
— Database: `lunia_db`
—
— ——————————————————–
—
— Struttura della tabella `bank`
—
CREATE TABLE IF NOT EXISTS `bank` (
`id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(10) unsigned NOT NULL default ‘0’,
`nameid` int(11) unsigned NOT NULL default ‘0’,
`amount` int(10) unsigned NOT NULL default ‘0’,
`fort_refine` tinyint(2) unsigned NOT NULL default ‘0’,
`light_refine` tinyint(2) unsigned NOT NULL default ‘0’,
`identify` tinyint(3) unsigned NOT NULL default ‘1’,
`grade0` smallint(5) unsigned NOT NULL default ‘0’,
`grade1` smallint(5) unsigned NOT NULL default ‘0’,
`grade2` smallint(5) unsigned NOT NULL default ‘0’,
`grade3` smallint(5) unsigned NOT NULL default ‘0’,
`vault` tinyint(2) unsigned NOT NULL default ‘0’,
`position` tinyint(2) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
— ——————————————————–
—
— Struttura della tabella `char`
—
CREATE TABLE IF NOT EXISTS `char` (
`char_id` int(11) unsigned NOT NULL auto_increment,
`uid` int(11) unsigned NOT NULL default ‘0’,
`name` varchar(30) NOT NULL default ”,
`class` smallint(6) unsigned NOT NULL default ‘0’,
`stage_level` smallint(6) unsigned NOT NULL default ‘1’,
`pvp_level` smallint(6) unsigned NOT NULL default ‘1’,
`stage_exp` bigint(20) unsigned NOT NULL default ‘0’,
`pvp_exp` bigint(20) unsigned NOT NULL default ‘0’,
`money` int(11) unsigned NOT NULL default ‘0’,
`str` smallint(4) unsigned NOT NULL default ‘0’,
`dex` smallint(4) unsigned NOT NULL default ‘0’,
`vit` smallint(4) unsigned NOT NULL default ‘0’,
`int` smallint(4) unsigned NOT NULL default ‘0’,
`hp` mediumint(8) unsigned NOT NULL default ‘0’,
`mp` mediumint(6) unsigned NOT NULL default ‘0’,
`skill_point` smallint(4) unsigned NOT NULL default ‘0’,
`guild_id` int(11) unsigned NOT NULL default ‘0’,
`arms` int(11) unsigned NOT NULL default ‘0’,
`head` int(11) unsigned NOT NULL default ‘0’,
`body` int(11) unsigned NOT NULL default ‘0’,
`hand` int(11) unsigned NOT NULL default ‘0’,
`legs` int(11) unsigned NOT NULL default ‘0’,
`foot` int(11) unsigned NOT NULL default ‘0’,
`earring_1` int(11) unsigned NOT NULL default ‘0’,
`earring_2` int(11) unsigned NOT NULL default ‘0’,
`ring_1` int(11) unsigned NOT NULL default ‘0’,
`ring_2` int(11) unsigned NOT NULL default ‘0’,
`support_1` int(11) unsigned NOT NULL default ‘0’,
`support_2` int(11) unsigned NOT NULL default ‘0’,
`status` tinyint(4) NOT NULL default ‘0’,
`online` tinyint(2) NOT NULL default ‘0’,
PRIMARY KEY (`char_id`),
UNIQUE KEY `name` (`name`),
KEY `account_id` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=150018 ;
— ——————————————————–
—
— Struttura della tabella `charstage`
—
CREATE TABLE IF NOT EXISTS `charstage` (
`char_id` int(10) unsigned NOT NULL default ‘0’,
`stagehash` int(10) unsigned NOT NULL default ‘0’,
`level` tinyint(3) unsigned NOT NULL default ‘0’,
KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
— ——————————————————–
—
— Struttura della tabella `friends`
—
CREATE TABLE IF NOT EXISTS `friends` (
`char_id` int(11) NOT NULL default ‘0’,
`friend_id` int(11) NOT NULL default ‘0’,
KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
— ——————————————————–
—
— Struttura della tabella `inventory`
—
CREATE TABLE IF NOT EXISTS `inventory` (
`id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(10) unsigned NOT NULL default ‘0’,
`nameid` int(11) unsigned NOT NULL default ‘0’,
`amount` int(10) unsigned NOT NULL default ‘0’,
`fort_refine` tinyint(2) unsigned NOT NULL default ‘0’,
`light_refine` tinyint(2) unsigned NOT NULL default ‘0’,
`identify` tinyint(3) unsigned NOT NULL default ‘1’,
`grade0` smallint(5) unsigned NOT NULL default ‘0’,
`grade1` smallint(5) unsigned NOT NULL default ‘0’,
`grade2` smallint(5) unsigned NOT NULL default ‘0’,
`grade3` smallint(5) unsigned NOT NULL default ‘0’,
`Bag` tinyint(2) unsigned NOT NULL default ‘1’,
`Position` tinyint(2) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
— ——————————————————–
—
— Struttura della tabella `login`
—
CREATE TABLE IF NOT EXISTS `login` (
`uid` int(11) unsigned NOT NULL auto_increment,
`user_id` varchar(23) NOT NULL default ”,
`user_pass` varchar(32) NOT NULL default ”,
`charslot` tinyint(3) unsigned NOT NULL default ‘4’,
PRIMARY KEY (`uid`),
KEY `name` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000002 ;
INSERT INTO `login` (`uid`, `user_id`, `user_pass`, `charslot`) VALUES
(1, ‘s1’, ‘p1’, 0);
————————————–分割线“不要复制我————————————————
创建好数据库好点Navicat上的管理用户
新建一个用户名为luniaserver的用户“服务器为127.0.0.1
密码为空
然后改
服务端目录下的conf\\confgame_renshou
与conf\lobby_renshou
着两个conf文档中的IP为127.0.0.1
最后运行服务端下的
gate-server.exe
game-server.exe
lobby-server.exe
悲剧了`..
不知道客户端怎么改`..
郁闷啊`……
谁告诉我客户端应该改啥`…
没有回复内容