I DO NOT SUPPORT THIS.
I ONLY THINK IT WILL BE USEFUL FOR SOME PEOPLE.
IRose installation
0°) Os:
The OS you should install is Windows Server 2003 (Standard, or Enterprise, r1 or r2 version).
Install Sp2 too.
Note:
If you are under Xp, you can't install some versions of mssql server 2000 and Game Server should fail quite often.
Vista should be fine.
I°) Installation of Ms SQL Server:
0°) What version?:
You "should" use Ms SQL Server 2000, you would have a lot less trouble.
1°) mssql 2000:
Install SQL Server 2000 and then sp 4 for it.
During install choose "Use the local System Account", then "Mixed Mode", with "sa" account and give it a password, it will be used then for configuration files later.
The default mssql port should be 1433 and tcp/ip should be authorized.
Note for sp4:
http://www.microsoft.com/downloads/d...displaylang=en
Take the version according to your server details, usually "SQL2000-KB884525-SP4-x86-ENU.EXE".
You can choose to install the sp4 using windows account login.
2°) mssql 2005 express edition:
It seems you can also use mssql server 2005 express edition
Visual Studio Express: Download
The microsoft .net framework 2 is needed:
http://www.microsoft.com/downloads/d...displaylang=en
Now it's not really a good idea, though if you enjoy pain.
a°) Installation:
Install everything.
Mixed mode and enter a password for "sa" user.
b°) configuration:
Launch "SQL Server Configuration Manager" and go to:
SQL Server 2005 Network Configuration -> Protocols for SQLEXPRESS.
-> Enable TCP/IP
-> Enable The IP(s) too
Don't forget to restart the mssql server.
Launch "SQL Server Surface Area Configuration", then "Surface Area Configuration for Services and Connections":
Launch "SQL Server Surface Area Configuration", then "Surface Area Configuration for Features":
In Ad Hoc Remote Queries, select "Enable OPENROWSET and OPENDATASOURCE support".
c°) tools:
Microsoft SQL Server Management Studio Express
Visual Studio Express: Download
d°) parameters:
Some parameters are needed, or you use the parameter system of 2005, or you use this sql query (see b°) ):
sp_configure 'show advanced options', 1;
CODE
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
3°) third party tools, MSSQL Maestro:
If you want to quickly and easily edit data and mssql data, give a try to MS SQL Maestro.
MSDE Tools - MSSQL Admin Tools - SQL Server Tools by SQL Maestro Group
II°) server files:
1°) server file and databases:
Install files in c:\SHO and create a folder c:\sho\databases.
Copy the server directories in the folder c:\sho (you should have then c:\sho\world server\, c:\sho\login server\, c:\sho\game server\).
The folder c:\sho\databases will be used for database seven_ORA later.
2°) srvDATA:
It will be used by world and game server later (when you launch them the first time or in the ini files).
Unzip the srvDATA in the folder c:\sho to have c:\sho\srvDATA.
Don't forget the language folder if it's not there... There should be some "*_ls.stb" files in there.
Don't use client files, it would be a really bad idea and you'll have some "debug assertion failed" with Game Server and World server loading those files.
In the end, you should have this:
Reduced 52%
Attached Image
183 x 206 (11.79K)
III°) installation of databases:
0°) hints:
When you connect yourself to the databases using tools, use the sa login and the according password.
1°) for mssql 2000:
Use "Enterprise manager" to create databases SHO and SHO_LOG.
Use tool from SQL Server 2000, "SQL Query Analyzer" to open the sql file "seven_ORA.sql" and execute it (right clic, execute), it will create table seven_ORA in the folder c:\SHo\databases\.
Open SHO.sql, change the password for the sa user and the IP for the Data Source (your server IP), there should be 3 replacements to be done.
Then ASSURE YOU have selected the database "SHO" in the combo list above and then execute the query.
Open SHO_LOG.SQL, be sure to have selected SHO_SQL database in the combo list and execute it.
[NOT MANDATORY] You can also create the SHO_MALL database, with this sql:
CODE
USE [master]
GO
/****** Object: Database [SHO_MALL] Script Date: 07/28/2007 18:13:08 ******/
CREATE DATABASE [SHO_MALL] ON PRIMARY
( NAME = N'SHO_MALL', FILENAME = N'Noob:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SHO_MALL.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'SHO_MALL_log', FILENAME = N'Noob:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SHO_MALL_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'SHO_MALL', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SHO_MALL].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SHO_MALL] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [SHO_MALL] SET ANSI_NULLS OFF
GO
ALTER DATABASE [SHO_MALL] SET ANSI_PADDING OFF
GO
ALTER DATABASE [SHO_MALL] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [SHO_MALL] SET ARITHABORT OFF
GO
ALTER DATABASE [SHO_MALL] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [SHO_MALL] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [SHO_MALL] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [SHO_MALL] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [SHO_MALL] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [SHO_MALL] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [SHO_MALL] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [SHO_MALL] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [SHO_MALL] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [SHO_MALL] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [SHO_MALL] SET ENABLE_BROKER
GO
ALTER DATABASE [SHO_MALL] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [SHO_MALL] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [SHO_MALL] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [SHO_MALL] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [SHO_MALL] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [SHO_MALL] SET READ_WRITE
GO
ALTER DATABASE [SHO_MALL] SET RECOVERY SIMPLE
GO
ALTER DATABASE [SHO_MALL] SET MULTI_USER
GO
ALTER DATABASE [SHO_MALL] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [SHO_MALL] SET DB_CHAINING OFF
2°) with express 2005:
Use SQL Server Management Studio Express and login as sa and password.
Do the same as mssql2000.
You can have some troubles (errors) with SHO.sql, it seems it's not important.
Put the charset for the tables in Korean.
If you got a creation table error, it could be a default charset error, so change it to Korean.
IV°) Create ODBC links:
1°) usually:
Go in Configuration Panel, administration tools, Data Source (ODBC).
In the "user datasource" (USER DSN) tab, make:
Add
Choose "SQL Server" if you have mssql 2000 server, it can have a different name for 2005 (SQL client).
----
seven_ORA
seven_ORA
Choose your serveur in the drop list.
Next
----
Select "use Windows NT authentification by ID network
Next
Select "change the default database by" seven_ORA
Next several times and "test" before final OK.
Do the same for SHO, SHO_LOG (using of course the good default databases).
Make one for SHO_MALL too, no need for default database though (or the SHO_MALL database if you created it).
In the end, you should have 4 sources:
seven_ORA
SHO
SHO_LOG
SHO_MALL
Reduced 79%
Attached Image
462 x 378 (45.04K)
Here is the details:
Reduced 79%
Attached Image
469 x 346 (61.61K)
Reduced 81%
Attached Image
507 x 357 (50.99K)
Reduced 81%
Attached Image
509 x 354 (57.9K)
Reduced 81%
Attached Image
511 x 354 (55.59K)
Reduced 81%
Attached Image
510 x 352 (59.27K)
2°) special 2005 case:
It seems there can be some difficulties to choose the server, you can try to force it seeing the server in "SQL Server Management Studio Express" and the server name.
It can be:
yourcomputer\SQLEXPRESS
There can be a lot of warning too using express 2005 when launching Game Server (conversion types).
V°) configuration files:
0°) IP:
/* Outdated? */
You should always wonder in the ini files which IP to give.
If you install all servers (login, world, game, mssql) on the same server and it's a dedicated one, it should be easy as the external IP (the one seen from internet side and used by your players to connect to your server) will be the same for all of the servers.
internet-------server (ls, ws, ls, mssql)
This is when you don't even have a local network (it's the case with some dedicated servers).
If you have another configuration, for example:
internet----router----server (ls, ws, ls, mssql) or
internet----router----server (ls, ws, ls) --local network-- server (mssql)
-> don't forget to forward the ports from the router to your computer (19000, 19001, 19005, 29000, 29100, 29200),
-> in the configuration files, you should use "local" IP from your local network to the connections between the different servers,
-> specify the external IP (from internet) in EditExtIP and EditClientIP when needed,
If you miss the IP, it'll be quite easy to see, you will have a "all server are under maintenance message" or "all the server are down".
a°) server in your local network, players outside:
For example in this case, the PC with server are in a local network, but the players are out your local network.
They use your external IP (your internet IP) to access your server. So the external IP in your configuration files is your internet one, the one used by your players.
It's logical since some of the servers have to listen from the good IP.
Player 1 ----->_________________________________________________ IP (World Server)
Player 2 -----> IP server (external) --[router]--> PC with all servers ---> IP (Game Server)
Player n ----->_________________________________________________ IP (Login Server)
For example, the external IP can be 98.32.1.3 and the internal IP 192.168.1.122.
So the links between servers can either be the localhost (127.0.0.1) or 192.168.1.122, but the external IP 98.32.1.3.
Check the FAQ, there is perhaps a trouble...
b°) server in your local network, as your players:
For example in this case, the PC with server are in a local network, and the players too.
So the external IP in your configuration files is the server one, the one used by your players.
It's logical since some of the servers have to listen from the good IP.
Player 1 ----->_____________________IP (World Server)
Player 2 -----> PC with all servers ---> IP (Game Server)
Player n ----->_____________________IP (Login Server)
For example, the internal IP is 192.168.1.122.
So the links between servers can either be the localhost (127.0.0.1) or 192.168.1.122, and the external IP 192.168.1.122.
c°) server is a dedicated server (directly on internet):
For example in this case, the PC with server is directly on the internet.
They use your external IP (your internet IP) to access your server. So the external IP in your configuration files is your internet one, the one used by your players.
It's logical since some of the servers have to listen from the good IP.
Player 1 ----->_____________________IP server (external) (World Server)
Player 2 -----> PC with all servers ---> IP server (external) (Game Server)
Player n ----->_____________________IP server (external) (Login Server)
For example, the external IP can be 98.32.1.3.
So in fact all IP should be 98.32.1.3.
1°) login server (SHO_LS.ini):
Nothing really fancy there, just give the server IP and some ports.
The password used everywhere is the one you used for the "sa" user (mysql 2000 or 2005).
The "GUMS" server is not used.
The DBIP is the database IP.
CODE
[FormLSCFG]
EditWaitTIME=10
EditDBIP=server_ip
EditClientPORT=29000
EditServerPORT=19000
EditLoginRIGHT=1
EditLimitUserCNT=1000
EditGumsIP=server_ip
EditGumsPORT=20000
CheckBoxGUMS=0
CheckBoxWS=0
EditPW=sa_password
2°) world server (SHO_WS.ini):
The password used everywhere is the one you used for the "sa" user (mysql 2000 or 2005).
CODE
[FormDataDIR]
EditDataDIR=C:\SHO\srvDATA
EditWaitTIME=10
ComboBoxLANG=8
item_0ComboBoxLANG=Korean
item_1ComboBoxLANG=English
item_2ComboBoxLANG=Japanese
item_3ComboBoxLANG=Chinese
item_4ComboBoxLANG=Reserved1
item_5ComboBoxLANG=Reserved2
item_6ComboBoxLANG=Reserved3
item_7ComboBoxLANG=Reserved4
SelectIndex=0
selIdx_ComboBoxLANG=1
[FormWSCFG]
EditZoneListenPORT=19005
EditWaitTIME=10
EditLoginServerIP=server_ip
EditLoginServerPORT=19000
EditLogServerPORT=3575
EditUserListenPORT=29100
EditExtIP=server_ip
EditWorldNAME=iRose
EditDBServerIP=server_ip
EditDBTableNAME=SHO
EditDBAccount=sa
EditDBPW=sa_password
EditLogAccount=sa
EditLogPW=sa_password
CheckBoxCreateCHAR=0
3°) game server (SHO_GS.ini):
The password used everywhere is the one you used for the "sa" user (mysql 2000 or 2005).
CODE
[FormDataDIR]
1EditDataDIR=C:\SHO\srvDATA
1EditWaitTIME=10
ComboBoxLANG=8
item_0ComboBoxLANG=Korean
item_1ComboBoxLANG=English
item_2ComboBoxLANG=Japanese
item_3ComboBoxLANG=Chinese
item_4ComboBoxLANG=Reserved1
item_5ComboBoxLANG=Reserved2
item_6ComboBoxLANG=Reserved3
item_7ComboBoxLANG=Reserved4
SelectIndex=0
EditDataDIR=C:\SHO\srvDATA
EditWaitTIME=10
selIdx_ComboBoxLANG=1
EditExtIP=server_ip
[FormDBCFG]
EditWaitTIME=10
EditDBIP=server_ip
EditDBName=SHO
EditDBUser=sa
EditDBPassword=sa_password
EditLogUser=sa
EditLogPassword=sa_password
EditMallUser=sa
EditMallPW=sa_password
EditWorldServerIP=server_ip
EditLoginWorldPORT=19005
EditLogServerIP=server_ip
EditLogServerPORT=19001
EditAccountServerIP=server_ip
EditAccountServerPORT=19001
EditExtIP=server_ip
[FormGSCFG]
EditWaitTIME=10
EditWorldNAME=Channel1
EditWorldIP=server_ip
EditClientPORT=29200
EditClientIP=server_ip
EditExtIP=server_ip
EditLowAGE=0
EditHighAGE=1300
EditChannelNO=2
EditMaxUSER=1750
ListViewZONE=48
item_0ListViewZONE=01B50100310043616E796F6E2043697 479206F66205A616E740D0A00D2
size_0ListViewZONE=28
item_1ListViewZONE=01B50100320043697479206F66204A7 56E6F6E20506F6C69730D0A00DF
size_1ListViewZONE=28
item_2ListViewZONE=01B501003300446F6C7068696E20497 36C616E640D0A004A
size_2ListViewZONE=23
item_3ListViewZONE=01B501003400C7D7B1B8B9E8B0E65BC 5B8C0CCC6B2BFEB5D0D0A0023
size_3ListViewZONE=27
item_4ListViewZONE=01B5010035004A756E6F6E204361727 4656C0D0A0088
size_4ListViewZONE=21
item_5ListViewZONE=01B5010036004372757361646572205 47261696E696E672043616D700D0A0
3A
size_5ListViewZONE=31
item_6ListViewZONE=01B5010038004C696F6E607320506C6 1696E730D0A00F2
size_6ListViewZONE=22
item_7ListViewZONE=01B501003900C1D6B3EDC4ABB8A3C5D A0D0A00A7
size_7ListViewZONE=19
item_8ListViewZONE=01B50200313000B8F0C7E8B0A120C3C ABFF80D0A003C
size_8ListViewZONE=21
item_9ListViewZONE=01B502003131004A756E6F6E20436C6 16E204669656C640D0A00DD
size_9ListViewZONE=26
item_10ListViewZONE=01B502003132004A756E6F6E20436C 616E204669656C640D0A00DE
size_10ListViewZONE=26
item_11ListViewZONE=01B502003133004A756E6F6E20436C 616E204669656C640D0A00DF
size_11ListViewZONE=26
item_12ListViewZONE=01B50200313500C5ACB7A3BEC6C1F6 C6AE0D0A00AF
size_12ListViewZONE=20
item_13ListViewZONE=01B50200313800C5B8C0CCC6B20D0A 00B9
size_13ListViewZONE=16
item_14ListViewZONE=01B50200313900C1D6B3EDC7E0BCBA BFF6C7C10D0A00CA
size_14ListViewZONE=22
item_15ListViewZONE=01B502003230004269727468204973 6C616E640D0A00A5
size_15ListViewZONE=22
item_16ListViewZONE=01B5020032310056616C6C6579206F 66204C7578656D20546F7765720D0A
0F0
size_16ListViewZONE=31
item_17ListViewZONE=01B50200323200416476656E747572 6572607320506C61696E730D0A00AD
size_17ListViewZONE=29
item_18ListViewZONE=01B50200323300427265657A792048 696C6C730D0A00C1
size_18ListViewZONE=22
item_19ListViewZONE=01B50200323400456C205665726C6F 6F6E204465736572740D0A0072
size_19ListViewZONE=27
item_20ListViewZONE=01B50200323500416E696D61204C61 6B650D0A00B9
size_20ListViewZONE=20
item_21ListViewZONE=01B50200323600466F72657374206F 6620576973646F6D0D0A0032
size_21ListViewZONE=26
item_22ListViewZONE=01B502003237004B656E6A69204265 6163680D0A001C
size_22ListViewZONE=21
item_23ListViewZONE=01B50200323800476F726765206F66 2053696C656E63650D0A0005
size_23ListViewZONE=26
item_24ListViewZONE=01B50200323900446573657274206F 662074686520446561640D0A0085
size_24ListViewZONE=28
item_25ListViewZONE=01B50200333100476F626C696E2043 61766520284231290D0A0011
size_25ListViewZONE=26
item_26ListViewZONE=01B50200333200476F626C696E2043 61766520284232290D0A0013
size_26ListViewZONE=26
item_27ListViewZONE=01B50200333300476F626C696E2043 61766520284233290D0A0015
size_27ListViewZONE=26
item_28ListViewZONE=01B5020033370053756E7368696E65 20436F6173740D0A00A0
size_28ListViewZONE=24
item_29ListViewZONE=01B5020033380053616E746120506C 616E65746F69640D0A00F1
size_29ListViewZONE=25
item_30ListViewZONE=01B502003430004772616E64204261 6C6C726F6F6D0D0A0077
size_30ListViewZONE=24
item_31ListViewZONE=01B50200343100476F626C696E2043 61766520284233290D0A0014
size_31ListViewZONE=26
item_32ListViewZONE=01B50200343200476F626C696E2043 61766520284233290D0A0015
size_32ListViewZONE=26
item_33ListViewZONE=01B502003531004D61676963204369 7479206F6620746865204575636172
D0A0035
size_33ListViewZONE=33
item_34ListViewZONE=01B502003532004D616E6120536E6F 776669656C64730D0A00F1
size_34ListViewZONE=25
item_35ListViewZONE=01B502003533004172756D69632056 616C6C65790D0A0025
size_35ListViewZONE=23
item_36ListViewZONE=01B502003534004372797374616C20 536E6F776669656C64730D0A0058
size_36ListViewZONE=28
item_37ListViewZONE=01B50200353500467265657A696E67 20506C61746561750D0A005F
size_37ListViewZONE=26
item_38ListViewZONE=01B50200353600466F72676F747465 6E2054656D706C6520284231290D0A
05D
size_38ListViewZONE=31
item_39ListViewZONE=01B50200353700466F72676F747465 6E2054656D706C6520284232290D0A
05F
size_39ListViewZONE=31
item_40ListViewZONE=01B50200353800B8B6BFEEC6BE20BF A1B7E7C4AB0D0A0068
size_40ListViewZONE=23
item_41ListViewZONE=01B502003539004C756E6120436C61 6E204669656C640D0A006F
size_41ListViewZONE=25
item_42ListViewZONE=01B502003631005265667567652058 6974610D0A004A
size_42ListViewZONE=21
item_43ListViewZONE=01B502003632005368616479204A75 6E676C650D0A00B5
size_43ListViewZONE=22
item_44ListViewZONE=01B50200363300B9E6C8B2C0C720BD A30D0A0058
size_44ListViewZONE=19
item_45ListViewZONE=01B50200363400C1A4B7C9C0C720B4 CB0D0A0044
size_45ListViewZONE=19
item_46ListViewZONE=01B50200363500BDC3C4EDC4EDC1F6 C7CFB0A8BFC10D0A0041
size_46ListViewZONE=24
item_47ListViewZONE=01B50200373000B9E8C6B2C1B82DC6 E4B5F0BFC20D0A00C5
size_47ListViewZONE=23
VI°) Launch sequence:
0°) login server crashing:
If this is the case (and in fact in any case), put the exe files in "windows 98 compatibility mode".
Reduced 82%
Attached Image
548 x 510 (57.08K)
It can crash when the World server connects to login server or a client connects to login server.
1°) servers:
Launch login server, then world server then game server (ls, ws, gs).
If the login server crashes when the world server connects to it or when a client connects to it, launch then:
first: login server
second: game server
third: world server
If this is the case, put the exe files in "windows 98 compatibility mode".
If you have an error "Connect failed to ACCOUNT server" for Game Server it's normal and it HAS to be.
Don't give the same port to ACCOUNTS and Login servers, there are NOT the sames !
2°) How to launch the client (protected or not):
Download the client from Ruff (for example). Install it, use TriggerDetect.exe to choose your video card, resolution and full screen or windowed mode.
Then Save and close the Ruff launcher at once.
For a secure link, use for example the ruff client and launch this using ruffprotect.exe by this command line in a .bat file:
ruffprotect.exe your_server_ip
Else for a non secure link, use the standard command line involving TRose.exe (you can use ruff or bratok client then) in a .bat file:
TRose.exe @TRIGGER_SOFT@ _server your_server_ip
If you have an error like "ERROR: Decode" in one of the server logs, it's because either the server waits for a secure link with client, or not.
So try to change the command you use wink.gif
VII°) accounts format:
1°) format:
Database seven_ORA, table dbo.userinfo:
CODE
Account: lmame //name of account (login name)
AID: 1 //seems it's the user number? can be let at 1
Email: test@test.com //email address
MailIsConfirm: 1 //very important, 0 if account not confirmed. You won't be able to login if at 0
//can be "true" on some mssql server or tools.
MD5PassWord: password //hashed in MD5
Right: 1 //user rights, see later for values.
memberinfo: 0 //default value
Most of the fields are not mandatory:
AllowBeta: 1
2°) power values for users:
for "Right" field:
0 = banned
1 = normal user
256 = GM 1
512 = GM 2
768 = GM 3
3°) other informations:
The informations on users (job, Zuly, level...) are on another table.
Database SHO, table tblGS_AVATAR.
VIII°) Some GM Commands explanations:
1°) [MOVE-TELEPORT] /mm id x y:
/mm mapid x y
mapid, check the value in the game server window.
x = x, BEWARE!! if you want to go to x value 5200, type 520 !
y = y, BEWARE!! if you want to go to y value 5200, type 520 !
See Excel files for mapid values.
2°) [ITEM] /item type itemid stats:
type = the family, like in osRose...
itemid = the item id (see the stl files for values)...
stats = if you want to add stats to your item (0 if none).
3°) [ADD-STATS/lvl] /set stat nb:
For example to be level 200:
/set lev 200
See the Excel files for additionnal commands (when released).
IX°) FAQ, main problems:
-> if you have login server crashing when the world server or a client connects, change the launch order:
1°) login server
2°) game server
3°) world server
And wait that game server (channel) connects to world server.
If this is the case (and in fact in any case), put the exe files in "windows 98 compatibility mode".
-> if when you login you have "account not confirmed":
Check that you have (in table "dbo.UserInfo" of seven_ORA) field "MailIsConfirm" at 1.
-> if when you log you have "can not connect to server, try later":
Check the External IP, there are some chances that the ecternal IP (the IP your players should connect to) is not the good one.
If it's correct, check the other faq.
-> If when you login (choose the channel) you have a message saying "all servers are under maintenance":
Or the server is down, or you have incorrect "Right" (or the user is banned).
Check the value "Right" (in table "dbo.UserInfo" of seven_ORA), 0 is Banned.
-> if you have a "debug assertion failed" when choosing the data folder:
It's because you have the wrong files from srvData, get the good ones.
-> Xp:
Game Server has some issues under XP, so sometimes you can't move in game or simply it won't launch completly.
It seems that most of the times it comes from anti-virus or firewall.
-> You see "ERROR: Decode" in the logs:
See VI°) 2°).
-> I got an error in Game Server window when trying to login "Exec ERROR in Sub_LoginACCOUNT(xxxxxxx):: SQLSTATE:42S02, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblGS_LogIN'. <<]Invalid object name 'tblGS_LogIN'. >>":
There is a chance you created your ODBC links in "System DSN"... You should delete them and put them in "USER DSN".
-> you got an error message in Game Server "Undefined Account server packet... Type[ 0x414 ], Size[ 15 ]" and client disconnects when choosing your character:
It's because you gave the same port number to ACCOUNTS and LOGIN servers.
It MUST NOT BE !! So put 19001 for Accounts server, as it's not needed. You'll get a "idd: Connect failed to ACCOUNT server " and it's the way it's meant to be !
-> You have Game Server going to 99% and crashing channel quite often:
Check you have a 32 bits OS, NOT a 64 bits OS!
-> you have a local network, you want that other players connect to it so you redirect your ports to your server, but it still fails:
Check the World Server IP in the "World' Tab of "Login Server" Window... Perhaps you'll see the local IP or your router IP.
This IP is given by login server to the client and so the client tryes to connect to this IP sad.gif
It seems Login tryes to detect World Server IP when this one connects to him, and sometimes it detects a wrong IP (like Router IP).
-> I got a weird error using Mssql Server 2005 in Game Server Window "La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure." or in English something like "conversion error from CHAR to DATETIME.....":
Check this:
http://www.microsoft.com/downloads/d...DisplayLang=en
It's the date format used the windows language which is not the good... This error does NOT appear with mssql 2000.
Doc done by lmame, vs 1.08.
2007/07/31.
Originally Posted by danilobk
