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

[bbantisoft]

Originally Posted by bilun4b2

You have Skype or YH i need you help @@, give me pls thx !

you only need port 30002 open and port forward to your COMPUTER IP and make sure u give the other person your INTERNET IP to add in the ServerList.ini.

tested and works with 4 realms..

[Krozo]

Originally Posted by bbantisoft

you only need port 30002 open and port forward to your COMPUTER IP and make sure u give the other person your INTERNET IP to add in the ServerList.ini.

tested and works with 4 realms..

thats good, now i know i dont need other port. PS you need WAN ip to give your partner/friend paying ur server. to get it.

[imrain01]

I found gm table and edited it.but when run sql it say error it's role in forbid db

[buriks]

LeRaz0r I am still trying to figure out how to add item to marketplace without having to change other items to get the item I want. I have edited just about everything else such events, npcs,and items etc. I have changed a lot of marketplace items also but it will not accept any changes to extend the marketplace past 450 items.

[troykangta]

Client


Pass Rar ?????

[bbantisoft]

Originally Posted by troykangta

Client


Pass Rar ?????

download this instead.

[cpenner]

Does anybody know anything about this stuff or how to fix it? LeagueData will not load.

ManagerServerR.exe log

 Spoiler

2012-07-28 16:08:33 lv2:MS:UpdateAccountStatToGACD
2012-07-28 16:08:34 lv1:MS:socket err:10061 -- CKManagerServerConnector::OnError -- CTcpSocket::Connect -- ::connect function return SOCKET_ERROR
2012-07-28 16:08:39 lv1:MS:socket err:10061 -- CKManagerServerConnector::OnError -- CTcpSocket::Connect -- ::connect function return SOCKET_ERROR
2012-07-28 16:08:44 lv1:MS:socket err:10061 -- CKManagerServerConnector::OnError -- CTcpSocket::Connect -- ::connect function return SOCKET_ERROR
2012-07-28 16:08:49 lv1:MS:socket err:10061 -- CKManagerServerConnector::OnError -- CTcpSocket::Connect -- ::connect function return SOCKET_ERROR
2012-07-28 16:08:54 lv1:MS:socket err:10061 -- CKManagerServerConnector::OnError -- CTcpSocket::Connect -- ::connect function return SOCKET_ERROR
2012-07-28 16:08:57 lv2:MS:err:64 CGateServerSession::OnError -- CIOCPSession::OnIOCompleteFailed
2012-07-28 16:08:57 lv2:MS:Gate: 1 disconnect
2012-07-28 16:08:58 lv2:MS:err:64 CLocalServerSession::OnError -- CIOCPSession::OnIOCompleteFailed

LocalSaveServer.exe log

 Spoiler

2012-07-28 16:08:30 lv3:LS:Memory [Global\ShareMem1] is opened , size : 104857600 , block size : 58923
2012-07-28 16:08:30 lv3:LS:Memory [Global\ShareMem2] is opened , size : 104857600 , block size : 58923
2012-07-28 16:08:30 lv3:LS:Memory [Global\ShareMem3] is opened , size : 104857600 , block size : 58923
2012-07-28 16:08:30 lv3:LS:Memory [Global\ShareMem4] is opened , size : 104857600 , block size : 58923
2012-07-28 16:08:37 lv2:LS:socket err:11001 -- CLogsrvConnector::OnError -- SetAddress failed! Addr:(ubuntu) Port:9008
2012-07-28 16:08:41 lv2:LS:socket err:11001 -- CLogsrvConnector::OnError -- SetAddress failed! Addr:(ubuntu) Port:9008
2012-07-28 16:08:46 lv2:LS:socket err:11001 -- CLogsrvConnector::OnError -- SetAddress failed! Addr:(ubuntu) Port:9008
2012-07-28 16:08:51 lv2:LS:socket err:11001 -- CLogsrvConnector::OnError -- SetAddress failed! Addr:(ubuntu) Port:9008
2012-07-28 16:08:56 lv2:LS:socket err:11001 -- CLogsrvConnector::OnError -- SetAddress failed! Addr:(ubuntu) Port:9008

And yes, the mysql socket location is set to /var/lib/mysql/mysql.sock

[Drmzindec]

Originally Posted by cpenner

Yes, people do seem to ignore a lot of questions. But it's fine, I'm sure if we ask enough we will get an answer. Like I asked 3 or 4 times now, does anybody know anything about socket errors or know what would prevent LeagueData from being loaded? All of my IP configs are correct, as are my MySQL/MSSQL login information.

MSSQL TCP/IP and port error would make this not load. Have you enabled and added you new ip? Without this it wont load.

Also ive noticed (I am also Guilty) that patience is a key tool for setting up this server, wait a while for things to load (Especially if your pc doesnt have good specs - Atleast 4gig Ram and 2.5Ghz dula core CPU).

I am still having problems adding items to the market place, anyone know how this works yet? I have changed it in so many places but it never loads. (Instead i added items i wanted to an npc). Regarding this, has anyone tried adding Hades' Feather (M) to the market? I cant find it in the item.slk list <-- (******* me off so bad!).

I will probably start coding and testing my register page today and when done i will share it.

[cpenner]

Originally Posted by Drmzindec

MSSQL TCP/IP and port error would make this not load. Have you enabled and added you new ip? Without this it wont load.

Also ive noticed (I am also Guilty) that patience is a key tool for setting up this server, wait a while for things to load (Especially if your pc doesnt have good specs - Atleast 4gig Ram and 2.5Ghz dula core CPU).

I am still having problems adding items to the market place, anyone know how this works yet? I have changed it in so many places but it never loads. (Instead i added items i wanted to an npc). Regarding this, has anyone tried adding Hades' Feather (M) to the market? I cant find it in the item.slk list <-- (Pissing me off so bad!).

I will probably start coding and testing my register page today and when done i will share it.

What new IP do you speak of, and what do you mean by enable? Enable as in open ports for the IP? Also, I'm a bit confused as to which of these IPs I should be using for Windows..

This is what I have been using, and is the IP given to Windows by my routers DHCP:

 Spoiler

(My Linux IP is 192.168.15.116)

But there is also this IP which seems to be linked to VirtualBox:

 Spoiler

My computer gets it's internet connection through a wireless connection, if that means anything.

Also, Hades' Feather (M) is 36473, and the male Hades' set is called Minos Outfit/Feather in item.slk. How I found this out:
1. Open /GameServer/Slk/Script/ItemScript.slk
2. Ctrl + F, and search for Hades' Blessing (M)
3. Column 'B' tells you the items script location in the 'GameServer' folder, in this case it is '/GameServer/Script/US/blessing_of_hades_52107.s'
4. Open 'blessing_of_hades_52107.s' and scroll to bottom to see the two rarest drops item IDs. (the two rarest drops being the outfit & feather)

If people are still needing to know about changing drop rates on things like Hades' Blessing for example, simply make the following changes and it should work:
blessing_of_hades_52107.s (original)

 Spoiler

//****************************************
//
// Copyright:PERFECT WORLD
// Modified:2010/01/22
// Author: ??
// TaskName:blessing_of_hades_52107.s
// TaskID:??????
//
//****************************************

function OnUseItem(){

$nullitem = GetPlayerInfo( -1, "nullitem", 0 )

$nullitem2 = GetPlayerInfo( -1, "nullitem", 1 )


//??????????
if $nullitem < 1
BC( "screen", "player", -1, "Insufficient space in your bag!" )
return
endif

//????????????
if $nullitem2 < 1
BC( "screen", "player", -1, "Insufficient space in your material bag!" )
return
endif



//???????
$del = SubPlayerInfo( -1, "item", 52107, 1 )



//??????????
if $del == 0

//?????? 5600
$no = RandomNumber(1, 10000)

if $no <= 5600
AddPlayerInfo( -1, "item", 5, 1 )
endif

//???? 1600
if $no > 5600
if $no <= 7200
AddPlayerInfo( -1, "item", 63365, 1 )
endif
endif

//?????? 1500
if $no > 7200
if $no <= 8700
AddPlayerInfo( -1, "item", 63422, 1 )
endif
endif

//????? 510
if $no > 8700
if $no <= 9210
AddPlayerInfo( -1, "item", 2222, 1 )
endif
endif

//?????? 300
if $no > 9210
if $no <= 9510
AddPlayerInfo( -1, "item", 20273, 1 )
endif
endif

//????? 300
if $no > 9510
if $no <= 9810
AddPlayerInfo( -1, "item", 64245, 1 )
endif
endif

//??????? 100
if $no > 9810
if $no <= 9910
AddPlayerInfo( -1, "item", 63558, 1 )
endif
endif

//????? 50
if $no > 9910
if $no <= 9960
AddPlayerInfo( -1, "item", 64246, 1 )
endif
endif

//????? 30
if $no > 9960
if $no <= 9990
AddPlayerInfo( -1, "item", 64247, 1 )
endif
endif

//????? ? 5
if $no > 9990
if $no <= 9995
AddPlayerInfo( -1, "item", 36473, 1 )
endif
endif

//????? ? 5
if $no > 9995
if $no <= 10000
AddPlayerInfo( -1, "item", 36471, 1 )
endif
endif


endif

}

blessing_of_hades_52107.s (modified)

 Spoiler

//****************************************
//
// Copyright:PERFECT WORLD
// Modified:2010/01/22
// Author: ??
// TaskName:blessing_of_hades_52107.s
// TaskID:??????
//
//****************************************

function OnUseItem(){

$nullitem = GetPlayerInfo( -1, "nullitem", 0 )

$nullitem2 = GetPlayerInfo( -1, "nullitem", 1 )


//??????????
if $nullitem < 1
BC( "screen", "player", -1, "Insufficient space in your bag!" )
return
endif

//????????????
if $nullitem2 < 1
BC( "screen", "player", -1, "Insufficient space in your material bag!" )
return
endif



//???????
$del = SubPlayerInfo( -1, "item", 52107, 1 )



//??????????
if $del == 0

//?????? 5600
$no = RandomNumber(1, 10000)

if $no <= 5600
AddPlayerInfo( -1, "item", 5, 1 )
endif

//???? 1600
if $no > 5600
if $no <= 7200
AddPlayerInfo( -1, "item", 63365, 1 )
endif
endif

//?????? 1500
if $no > 7200
if $no <= 8700
AddPlayerInfo( -1, "item", 63422, 1 )
endif
endif

//????? 510
if $no > 8700
if $no <= 9210
AddPlayerInfo( -1, "item", 2222, 1 )
endif
endif

//?????? 300
if $no > 9210
if $no <= 9510
AddPlayerInfo( -1, "item", 20273, 1 )
endif
endif

//????? 300
if $no > 9510
if $no <= 9810
AddPlayerInfo( -1, "item", 64245, 1 )
endif
endif

//??????? 100
if $no > 9810
if $no <= 9910
AddPlayerInfo( -1, "item", 63558, 1 )
endif
endif

//????? 50
if $no > 9910
if $no <= 9960
AddPlayerInfo( -1, "item", 64246, 1 )
endif
endif

//????? 30
if $no > 9960
if $no <= 9990
AddPlayerInfo( -1, "item", 64247, 1 )
endif
endif

//????? ? 5
if $no > 1
if $no <= 10000
AddPlayerInfo( -1, "item", 36473, 1 )
endif
endif

//????? ? 5
if $no > 1
if $no <= 10000
AddPlayerInfo( -1, "item", 36471, 1 )
endif
endif


endif

}

If you look at the bottom of the modified script, you'll see I set both Hades' Outfit and Hades' Feather to drop when any number between 1 and 10000 is generated. Seeing how the lowest number that can be generated is 1 and the highest is 10000, they will be dropped every time the box is open. I don't recommend using those specific chances as they could cause issues (dropping two items at the same time) but that's the idea of increasing their drop rates. If you wish to narrow the gap between numbers being generated, simply change this:

[B]$no = RandomNumber(1, 10000)
[/B]

To something like this (just an example):

[B]$no = RandomNumber(1, 500)[/B]

That would make it generate a number between 1-500 instead of 1-10000.

What the items like Blessings and Zodiac cards do is randomly generate a number between 1 and another number every time you open one. What item you get, as you can see in the script, is dependent on what number is generated. In Hades' Blessing (M)'s case, the Feather (very bottom) will only drop if it generates a number between 9995 and 10000. If you change the 'if $no >' line's value to the smallest possible number, then essentially you could make it so your players would get Hades' Feather every time they open it.


I'd appreciate it if somebody could try this and verify that it works. I have yet to get my server working so I can't try it myself, but it's only logical that it would work.

[Drmzindec]

I havent worked with my wireless IP yet but it should work the same.

In MSSQL configuration manager - Cant remember exactly what its called but when you search it in Win7 (SQL) you will see it has a red toolbox next to it. Open that and you will see SQL Server Network Configuration, select MSSQL (Not the express), then you will see on the right TCP/IP (This should be enable), right click and select settings, select IP Addresses.

You need to enable all of them, (I am in the office so cant see which of them i enabled), also the TCP Dynamic ports will say "0" remove that.

Now find your vmbox ip: "192.168.56.1" and change that to your linux ip, you will also need to find your linux mac address here and change it to your Linux mac address. (TIP: Your linux mac adress can also be found using ifconfig, it will show something like //66 at the end you need to change that in the mssql configuration manager to LINUXMACADDRESS%66).

TIP: In MSSQL Configuration manager, find your vmbox MAC address and change that to your linux mac address, if you cant find it then add it manually.

TIP: Open your router settings and add your own DHCP to the router: One for Windows and one for linux (It might show unknown) it just add it as that then. This will stop your ip from changing each time your pc connects.

Restart your whole PC after this. Also there is config file in the server files, you will see in the original files it has a ip adress commented out with a windows ip - (This needs to be your linux ip and you can remove the # to comment it in).

Open MSSQL and connect, if it connects you should be set and everything should work. If it fails (Well i removed all instances of MSSQL from my pc, espacially SQL 2005 as it causes problems and reinstalled it and then i did the steps above again and everything worked 100%).

And like i said before, be patient sometimes it takes 10min to load on my pc when i had 2gig ram. I updated my pc the moment i got it working. Now have an i5 3Ghz and 8gig ram, it loads in 1min.

Hopes this helps.

Thank you for the hades hints. I been looking for it and think my mind just melted after all the changes i made, I have a friend that is helping me look at the "graphics" for the files and according to him we will be able to create new maps, monsters, npc and a whole bunch of stuff since its a very simple setup.

Lastly if you dont get this working, can you pop all the files you are suppose to edit "Windows and Linux side" into a zip file for me and i will have a look at this for you.

And one more Question from my side for anyone that can answer me, how would i get people to connect to my server?

Do i have to forward a port on my Router? And what ports should i forward? And how would my node ins the server list look?

[antisg]

Originally Posted by imrain01

I found gm table and edited it.but when run sql it say error it's role in forbid db

upload the pic of error.

must start au in linux

[bilun4b2]

Anyone test my server please, online success ? I opened port 30002, and use my ip WAN in serverlist.

node server normal BOI-VietNam 113.169.255.14 30002 904 5

[MWO]

i have no idea how to make it work or how to edit this game ... i know how to make a MWO server by mysql and hamachi ... work very good and there you can modify items with Navicat Lite ( lvl , items ...etc) so with boi i have no idea

[Hackheaven]

I think...

ShopCommodity>market
ShopItem>npc shops

I have no idea what shopcomm is but it looks like its pulling a list of item ids maybe thats linked to shopcommodity

I have no idea hwy all the names are not in English but im going to test adding 1 item to the market with the name (think its name *Test*) and see if it works

[bilun4b2]

What ID of item Hypnos' Will ? who know tell me please. @@