Main tutorial

[lucky40990]

1- Let's start

2- Add in MS SQL 2005 the folowing Database
IRIS_MEMBERDB
IRIS_LOGDB
IRIS_GAMEDB
Add one user : irisdb password : ehdwjq10aks! Make sure this user have db_owner rights on the 3 database

Execute the script of Database in each database .

3- Create the 3 ODBC driver :
IRIS_MEMBERDB
IRIS_LOGDB
IRIS_GAMEDB
with user : irisdb password : ehdwjq10aks! ( SQL driver )

4- After this run : Installation00_DB.bat

5- in Database IRIS_MEMBERDB complete with the folowing :
TB_SERVER =>
IDX REGISTER_DATE NAME DECRIPTION STATUS APPLY
1 2010-1-1 0:00:00 SERVER1 SERVER1 0 0

6- Then run Installation01_BootAgent.bat , Installation02_IrisLoginSrv.bat , Installation03_IrisGameSrv.bat , Installation04_IrisLogDemon.bat

7- modify all .cfg and .txt with your ip

8- add account with the ADD_ACCOUNT_SCRIPT.txt script

9- run the server

Run01_BootAgent.bat
Run02_IrisLoginSrv.bat
Run03_IrisGameSrv.bat
Run04_IrisLogDemon.bat
ServerTool.exe

10- After started ServerTool.exe click on userIN to make userIN : ON

11- change the shurctut ip of client to your IP .

12- Start patch.reg

13- If you have a problem about Gamebryo Expired just restart your computer then restart your server and enjoy !

---------------------------
---------------------------
---------------------------
*[GM] cmd are :
/shot => CHEAT_COMM_SHOT
/in => CHEAT_COMM_IN
/speed => CHEAT_COMM_SPEEDUP
/ear => CHEAT_COMM_EAR
/hide => CHEAT_COMM_HIDE
/undead => CHEAT_COMM_UNDEAD
/info => CHEAT_COMM_INFO
/watch => CHEAT_COMM_WATCH
/kick => CHEAT_COMM_KICK
/recover => CHEAT_COMM_RECOVER
/rebirth => CHEAT_COMM_REBIRTH
/teleport => CHEAT_COMM_TELEPORT
/go => CHEAT_COMM_GO
/chase => CHEAT_COMM_CHASE
/move => CHEAT_COMM_MOVE
/call => CHEAT_COMM_CALL
/nochat => CHEAT_COMM_NO_CHAT
/allowchat => CHEAT_COMM_ALLOW_CHAT
/notice_server => CHEAT_COMM_NOTICE_SERVER
/notice_channel => CHEAT_COMM_NOTICE_CHANNEL
/notice_area => CHEAT_COMM_NOTICE_AREA
/removei => CHEAT_COMM_REMOVE_ITEM
/removem => CHEAT_COMM_REMOVE_MONSTER
/levelup => CHEAT_COMM_LEVELUP
/skillup => CHEAT_COMM_SKILLUP
/make => CHEAT_COMM_MAKE
/gold => CHEAT_COMM_GOLD
/summon => CHEAT_COMM_SUMMON
/remove => CHEAT_COMM_REMOVE
/kill => CHEAT_COMM_KILL
*Note : For use the gm cmd you need use the GM client.

 

[cupster]

can you explain more how to do these things please:

1. executing scripts and creating odbc driver

2. adding account with the ADD_ACCOUNT_SCRIPT.txt script

thanks! :

 

[1Word]

Thanks, but one question, can't it be changed to work on C:/ rather than D:/ ?

 

[jonnybravo]

of course it can

 

[1Word]

of course it can

Yah but

1- If you do not want any problem with your installation please install the server in D:\IRIS

However I'll play a bit later with the files and maybe try oppening a server.

Thanks

 

[darkknight]

I can't executing script
Error that
or some body make bak file to restore, I has some problem like executing script FLYFF SERVER game

 

[asd1234c]

how to change EXP,Drop,Quest Rate ? by manual
and how to adding item to cash bag my manual ? , I can manual add only normal Bag.

 

[l2runner]

Hi, if you don't mind me asking, i am somehow starting to learn ms sql 2005 but i cant figure out how to do this..

"Add one user : irisdb password : ehdwjq10aks! Make sure this user have db_owner rights on the 3 database"

Thanks!

Or even the said suggestion on previous post to put up a .bak for backup of the database it is a nice idea for those who can't run scripts..

 

[Kyokyonos]

3- Create the 3 ODBC driver :
IRIS_MEMBERDB
IRIS_LOGDB
IRIS_GAMEDB
with user : irisdb password : ehdwjq10aks! ( SQL driver )

Which driver? SQL Native Client or SQL Server?


I'm pretty much at a dead end with this-- when I try to log in I get this error which leads me to believe that the above step must be the problem.

Of course, I tried applying the patch to see what the error was all about, but copying over just one translated file would result in the client not working.

 

[aqualung]

If your using M$SQL 2005, select SQL Native Client....

AquaLung


.

 

[lucky40990]

Native client or SQL server ===> SQL server.
C:/ or D:/ ==> Both you can also install on C:/ without any problem .
how give db_owner ==> right click on the user u added ( irisdb ) then propriety then User mapping.

Cordialy,

 

[rickisme]

Plz help me

 

[l2runner]

Yup, Me too! Got the same output for my loginsrv... can't figure out how..

 

[l2runner]

Hi, I've managed to up the PTS using local host as the ip.. however i cant seem to see any Server from the choices of server. I've managed to get past from log in but no server in the choices.. thanks

 

[Kyokyonos]

I think he forgot to include the channel step for some reason on this post.

After you change all the .cfg files/ServerInfo.txt to your IP and after you add the row in TB_SERVER table in the IRIS_MEMBERDB database, you need to go to the TB_CHANNEL table and add a row for the channel. Use IPV4_To_INETD.htm to convert your IP for the INETNUM/IPV4 columns (127.0.0.1 = 2130706433)

And I think you have to do something with ServerTool-- can't really remember. I remember I couldn't log in, then I clicked something on it and I was able to get to character select and play.

If it still didn't work, try running the unistall files and re-installing. I think that might have helped me get ingame as well.

 

[cupster]

I can't executing script
Error that
or some body make bak file to restore, I has some problem like executing script FLYFF SERVER game

i'm having this same problem. it says script executed successfully but i don't see the tables in the databases. i'm sort of a newb with mssql 2005. appreciate any help thanks.

 

[ramispo]

please to those who manage to make it work
please make a detailed guide please

 

[GwynnBleiidd]

please create normal guide or video guide, i can install full server

 

[shiihong007]

hey guyz i m trying to make the server but when i try to query the sql databases i see many syntax errors i am using sql 2005 is there any way to fix this errors????

 

[InfernoViper]

Could someone help me with the gamersrv i cant seem to get it fixed.
I have put some Screenshots into the attachments.
All the cfg and the txt file has 127.0.0.1.