[RELEASE] BOI Server Files + Server Tools + GM tools

07/15/2012 16:50 axelcro#1
Preconfigured CentOS (VirtualBox image)

Quote:
[Only registered and activated users can see links. Click Here To Register...]
VirtualBox Network setting: Bridged network

MSSQL Database Tools + GM Tools

Quote:
[Only registered and activated users can see links. Click Here To Register...]
MSSQL 2008 R2 Database Backup

Quote:
[Only registered and activated users can see links. Click Here To Register...]
CentOS Username: root
CentOS Password: reverse

MSSQL Username: sa
MSSQL Password: 123456

MySQL Username: root
MySQL Password: game


CLIENT

Quote:
[Only registered and activated users can see links. Click Here To Register...]

START.BAT:

Quote:
windows
@echo off


Start /D Auagent run.bat
ping 1.1.1.1 -n 1 -w 1000
start /d DBServerSimulator ./DBServerSimulator.exe
ping 1.1.1.1 -n 1 -w 1000
start /D DetectCheatServer ./DetectCheatServer/DetectCheatServerR
ping 1.1.1.1 -n 1 -w 1000
start /D ServerGuarder ./ServerGuarder/ServerGuarder.exe
ping 1.1.1.1 -n 1 -w 1000
start /D GateServer ./GateServer/Gate
ping 1.1.1.1 -n 1 -w 1000
start /D ManagerServer ManagerServer/ManagerServerR
ping 1.1.1.1 -n 1 -w 1000
start /D LocalSaveServer LocalSaveServer/LocalSaveServerR
ping 1.1.1.1 -n 1 -w 1000
start /D ShareMemProc ./ShareMemProc/ShareMemProcR
ping 1.1.1.1 -n 1 -w 1000
start /D GameServer ./GameServer/Line.exe

STOP.BAT:

Quote:
@echo off

taskkill /f /im line.exe
taskkill /f /im compactau.exe
taskkill /f /im DBServerSimulator.exe
taskkill /f /im Gate.exe
taskkill /f /im LocalSaveServerR.exe
taskkill /f /im ManagerServerR.exe
taskkill /f /im ShareMemProcR.exe
taskkill /f /im Java.exe
taskkill /f /im DetectCheatServerR.exe
taskkill /f /im ServerGuarder.exe
taskkill /f /im cmd.exe


In linux config files:
Quote:
"192.168.1.100" = WINDOWS IP
"192.168.1.109" = LINUX IP

If anyone wanna generate a working password, here is a password generator page. Small but working :)

Quote:
[Only registered and activated users can see links. Click Here To Register...]

MSSQL QUERY for ACCOUNT CREATING (if u get error let me know, coz i made with a different version of MSSQL!)


Quote:
Quote:
Insert Into account
(id,creatime,name,passwd,usertype)
Values
(YOURID,'YYYY.MM.DD','NAME',PASSWORD,'1')


Quote:
Btw for CentOS image's MYSQL settings, credit goes to SHIJIEGAMES aka IMMORTALRED


[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


AUAGENT/RUN.BAT

Quote:
@echo off
start compactau.exe
"e:\program files\java\jre7\bin\java" -Xms512m -Xmx768m -cp jio.jar;log4j-1.2.9.jar;auagent.jar Auagent auagent.conf
Pause
e:\program files\java\jre7\bin\java > Change to your java directory!



AUAGENT.CONF


Quote:
[AuAgentServer]
zoneid = 904
aid = 9
type = tcp
port = 29250
address = WINDOWS IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
tcp_nodelay = 1
listen_backlog = 10
mtrace = /tmp/m_trace.link

[GameDBClient]
type = tcp
port = 29251
address = LINUX IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
tcp_nodelay = 1
;listen_backlog = 10
mtrace = /tmp/m_trace.link
cashfile = d:\cash_backup.data

[GAuthClient]
type = tcp
port = 29200
address = WINDOWS IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
;so_broadcast = 1
tcp_nodelay = 1
osec = 2
oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l
isec = 2
iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds
shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje

;if use certverify between au,1:use,0:not use,default use
issupport_cert = 0

[ThreadPool]
config = (1,1)(2,4)(3,2)
max_queuesize = 1048576
;prior_strict = 1

[SpeedLimit]
window = 20
high = 2

[TimeoutLimit]
;window > 60
window = 180
high = 200

[CouponLimit]
;GetUserCoupon limit
window = 300
high = 2

[CouponExchangeLimit]
;CouponExchange limit
window = 120
high = 2
COMPACTAU.CONF

Quote:
[GCompactAUServer]
type = tcp
port = 29200
address = WINDOWS IP
osec = 2
oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds
isec = 2
iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l
shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje
SERVER.INI

Quote:
[Default]
Version=0
ManagerServerIP=WINDOWS IP
ManagerServerPort=20021
ListenGatePort=40003
LineID=REALM NUMBER WHAT U WANT
ShowLoginIP=0

[LogServer]
Port = 9008
ServerIP = LINUX IP

[SharedMem]
SharedMemCount=1
SharedMemName1=Global\ShareMem1
SharedMemSize1=100
GATESERVER.INI

Quote:
[Default]
ManagerIP=WINDOWS IP
ManagerPort=21020
AuAgentIP=WINDOWS IP
AuAgentPort=29250
OnlineMax=5000

//Blablabla. Was chinese text here.
GatePort=30002

[LogServer]
ServerIP = LINUX IP
Port = 9008
LOCALSAVESERVER.INI

Quote:
[Network]
DBServerIP=WINDOWS IP
DBServerPort=21021
ManagerIP=WINDOWS IP
ManagerPort=21023

[Log]
//ČŐÖľµČĽ¶
LogLevel=4

//¸÷µČĽ¶ĘäłöŔŕĐÍ
Wrong=3
Warning=3
Normal=3
Debug=3


//ą˛ĎíÄÚ´ć
[SharedMem]
//ČËĘýĎŢÖĆ
BlockMax=3000
//±Ł´ćĽä¸ô
SaveInterval=1000
//GSĎěӦʱĽä
ResponseInterval=10000

//ą˛ĎíÄÚ´ćżéĘýÁż
SharedMemCount=4

SharedMemName1=Global\ShareMem1
SharedMemSize1=100

SharedMemName2=Global\ShareMem2
SharedMemSize2=100

SharedMemName3=Global\ShareMem3
SharedMemSize3=100

SharedMemName4=Global\ShareMem4
SharedMemSize4=100
MANAGERIP.INI

Quote:
[Default]
ManagerNum = 3
ManagerIP1 = WINDOWS
ManagerIP2 = WINDOWS
ManagerIP3 = WINDOWS
MANAGERSERVER.INI

Quote:
[Default]
LocalIP = 127.0.0.1
OnlineMax=1000
DefWallowOnlineTime = 10800
DefWallowOfflineTime = 18000
LootTimes=1.0
ExpTimes=1.0

[GameServer]
Port = 20021

[DBServer]
ServerIP = LINUX
#ListenPort = 21022 TW
#ListenPort = 21032 VN
ListenPort = 21042 US


[GateServer]
ServerIP = WINDOWS
Port = 21020

[LocalDBThread]
#DBListenPort = 21024 TW
#DBListenPort = 21034 VN
ServerIP = LINUX
DBListenPort = 21044 US
LocalListenPort = 21023

[NameServer]
ServerIP = LINUX
ServerPort = 50050
#ServerPort = 10080

[LogServer]
ServerIP = LINUX
Port = 9008

[DetectCheatServer]
ServerIP = WINDOWS
ServerPort = 55000

[GACD]
ServerIP = LINUX
ServerPort = 29705

[CardServer]
ServerIP = LINUX
ServerPort = 10080

If anyone missing ServerGuarder:

Quote:
[Only registered and activated users can see links. Click Here To Register...]
Put in your windows server folder and u can't get an error when start run.bat.


Config.ini

Quote:
[Default]
LocalIP = WINDOWS
ManagerConfig.ini

Quote:
<root>
<item name="Server Name (Or whatever u want)" IP="WINDOWS" />
</root>



Chinese tutorial video:


Quote:
[Only registered and activated users can see links. Click Here To Register...]
07/15/2012 17:05 kenisen#2
Thanks you very much axelcro. I love you ....
P/S: Next to me after you, I can't create character and my authe can't display GemeDB connect. How to fixit axel ?
07/15/2012 17:09 axelcro#3
Quote:
Originally Posted by kenisen View Post
Thanks you very much axelcro. I love you ....
Only like or poke me pls :D

Not at all ;)
07/15/2012 18:36 kenisen#4
In MSSQL we just need PassportBOI database or all of database in Window folder ?
07/15/2012 18:53 shijiegames#5
Quote:
Originally Posted by axelcro View Post
Preconfigured CentOS (VirtualBox image)



MSSQL Database Tools + GM Tools



MSSQL Username: sa
MSSQL Password: 123456

MySQL Username: root
MySQL Password: game

START.BAT:




STOP.BAT:





In linux config files:



I found the passwords format in MSSQL.

example:



If any1 know a query how to convert String (that's the input value) to Hexadecimal without be truncated, send me a PM or comment to this thread! Or .ASP developer! Thanks with pleasure!







[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


(I'm lv80 atm :D:D:D:D)


AUAGENT.CONF




COMPACTAU.CONF
Passwords are the same as all PWE games...

$password = "0x" . md5 ( $username . $password );
07/15/2012 19:29 coderzstas#6
axelcro, how gm tools working ????
07/15/2012 19:30 axelcro#7
Quote:
Originally Posted by coderzstas View Post
axelcro, how gm tools working ????
That is a very good question. I didn't use that yet.
07/15/2012 19:33 coderzstas#8
2nd question ))

do you know how to change drop and exp ? Or Edit character ?
07/15/2012 19:36 axelcro#9
Quote:
Originally Posted by coderzstas View Post
2nd question ))

do you know how to change drop and exp ? Or Edit character ?

Exp-drop > MANAGERSERVER.INI
Quote:
[Default]
LocalIP = 127.0.0.1
OnlineMax=2000
DefWallowOnlineTime = 10800
DefWallowOfflineTime = 18000
LootTimes=DROPRATE
ExpTimes=EXPRATE

Edit character: Mysql > Shengui > basetab_sg
07/15/2012 21:30 catalixxx#10
Ok im back from short vacation. Nice axel, it means you kinda did it. You gonna open a fun server i heard?:D
07/15/2012 21:41 coderzstas#11
Axelcro, do you now how to add zen,edit market ?
07/15/2012 21:45 Gasttozzz#12
Can u make video tutorial how to make it ? plsss
07/15/2012 22:01 axelcro#13
Quote:
Originally Posted by coderzstas View Post
Axelcro, do you now how to add zen,edit market ?
I can login with test account only. Wait guys pls! I'm not programmer, so i'm not too fast.
07/15/2012 22:11 Gasttozzz#14
Can u make video how to di it ? pls
07/15/2012 22:51 axelcro#15
Quote:
Originally Posted by Gasttozzz View Post
Can u make video how to di it ? pls
Can't u see what i told ya?