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

07/30/2012 02:10 bbantisoft#676
Quote:
Originally Posted by bilun4b2 View Post
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.. :D
07/30/2012 02:21 Krozo#677
Quote:
Originally Posted by bbantisoft View Post
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.. :D
thats good, now i know i dont need other port. PS you need WAN ip to give your partner/friend paying ur server. [Only registered and activated users can see links. Click Here To Register...] to get it.
07/30/2012 03:17 imrain01#678
I found gm table and edited it.but when run sql it say error it's role in forbid db
07/30/2012 05:45 buriks#679
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.
07/30/2012 07:31 troykangta#680
Client
[Only registered and activated users can see links. Click Here To Register...]

Pass Rar ?????
07/30/2012 07:52 bbantisoft#681
Quote:
Originally Posted by troykangta View Post
Client
[Only registered and activated users can see links. Click Here To Register...]

Pass Rar ?????
download this instead.
[Only registered and activated users can see links. Click Here To Register...]
07/30/2012 08:45 cpenner#682
Does anybody know anything about this stuff or how to fix it? LeagueData will not load.

ManagerServerR.exe log
LocalSaveServer.exe log

And yes, the mysql socket location is set to /var/lib/mysql/mysql.sock
07/30/2012 09:25 Drmzindec#683
Quote:
Originally Posted by cpenner View Post
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 <-- (Pissing me off so bad!).

I will probably start coding and testing my register page today and when done i will share it.
07/30/2012 10:41 cpenner#684
Quote:
Originally Posted by Drmzindec View Post
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:

But there is also this IP which seems to be linked to VirtualBox:
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)
blessing_of_hades_52107.s (modified)
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:
Code:
[B]$no = RandomNumber(1, 10000)
[/B]
To something like this (just an example):
Code:
[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.
07/30/2012 11:21 Drmzindec#685
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?
07/30/2012 12:11 antisg#686
Quote:
Originally Posted by imrain01 View Post
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
07/30/2012 12:41 bilun4b2#687
Anyone test my server please, online success ? I opened port 30002, and use my ip WAN in serverlist.
Quote:
node server normal BOI-VietNam 113.169.255.14 30002 904 5
07/30/2012 14:09 MWO#688
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
07/30/2012 14:40 Hackheaven#689
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
07/30/2012 14:57 bilun4b2#690
What ID of item Hypnos' Will ? who know tell me please. @@