- 精华
- 阅读权限
- 100
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2009-8-15
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
本帖最后由 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
悲剧了`..
不知道客户端怎么改`..
郁闷啊`......
谁告诉我客户端应该改啥`... |
|