My guides + databases + server files repack -V2!

[chumpywumpy]

Please note that i do no condone warez, illegal serials or "cracking" applications. These are all against RaGEZONE rules and my own principles. Everything here can be done using free software and therefore my guides will ONLY cover the free ways of doing things. DO NOT ask me for SQL2000 cracks, VMWare cracks or things like that as your requests will be ignored.

This release is designed to be used with the GP client + SAUR0N's client synch patch.

GP Client:
http://forum.ragezone.com/f459/shared-server-files-guides-gm-tools-424909

SAUR0N's client patch:
http://forum.ragezone.com/f459/sync-server-client-457455


Guides

MS SQL 2005 Express
A guide for installing MSSQL2005, configuring permissions and restoring the databases.
Download -> http://www.mediafire.com/download.php?mr5dlj8scbt
Download MSSQL2005 Express -> http://www.microsoft.com/sql/editions/express/default.mspx
* Extra credit to ChaosPower for telling me where the linked server settings were, i've just noticed i didn't credit you. Sorry :/

Centos 4.6 install guide (and VMWare notes) (unfinished)
This is a full guide even though it is unfinished. It will get you through the installation but it needs some polishing.
Download -> http://www.mediafire.com/download.php?yhx4v3phebi
Download Centos 4.x CD1 and CD2 -> www.centos.org
VMWare server 1.07 -> Part1 Part2 | Mirror

VMWare networking guide *new*
Settings for VMWare networking (both router and modem type connections) and some basic networking tips.
Download -> http://www.mediafire.com/download.php?zmczngdwmzm

Hamachi setup guide
A small guide on setting up Hamachi for a server.
Download -> http://www.mediafire.com/download.php?85xzfnymroo

Cabal server install guide (my repack v2 only)
How to install my server file repack.
Download -> http://www.mediafire.com/download.php?lhjiyngn2jn


Guide translations

* Deutsch (Komplett) von MisterMinister


Cabal server files

Note: This is old. See my sig for the latest version!

Cabal server repack v2
Contains tested and working files that have been reorganised for easier installation and reconfiguration.
v2 is old now. Go to http://forum.ragezone.com/f459/chumpys-server-repack-v2-5-a-501965/

* Lots of comments added to various files at different points
* Modified the install process for less manual copying
* Added WAN IP detection to cabal_config.sh, hopefully solving some problems :/
* Added alternate method to cabal_install.sh for Centos 5 thanks to grasshoper
* You now get a choice about cron process restart support
* Server files now use SAUR0N's client synch data
* Added TG lobby wait and duration to cabal_config.sh
* Added warmap d/c thanks to fabby
* Added patched GlobalMgrSvr (+keyfiles) thanks to youyou
* Added LogLvl and Max Users to cabal_config.sh
* Made TG work using cabal_config.sh to switch configs
* Added multiconfig switch idea using gen_config2.sh

Note: If you don't use SAUR0N's client synch patch then keep your original const.scp and product.scp.

Cabal databases (beta)
This is a complete set of working databases in MSSQL 2000 format (which means they will load in 2000 or later). They are the original databases with the player data stripped and a _few_ fixes applied (see below).

Database downloads
Account (9th Aug 2008) - http://www.mediafire.com/download.php?tsmm1ss1j5p
cabal_managerdb (9th Aug 2008) - http://www.mediafire.com/download.php?ph2rhmucjam
Cabal_stat (9th Aug 2008) - http://www.mediafire.com/download.php?2poidkz42jx
CabalCash (9th Aug 2008) - http://www.mediafire.com/download.php?owggajidxxa
Event (9th Aug 2008) - http://www.mediafire.com/download.php?2uyhnalbysc

Gamedb (9th Aug 2008) - http://www.mediafire.com/download.php?ej2mkyub0hc
xp_md5.dll - http://www.mediafire.com/download.php?nhjqyhja9oc

All databases in one single rar thanks to Inmetsu (note: all are 09/08/2008 copies)
Download -> http://rapidshare.com/files/136108929/chump_db_9.8.2008.rar

Database changelog
* Added init_accountdb and init_cashdb so you can easily clear all 3 main dbs
* Modified init_gamedb so it works with itemserialtable
* Added chatpresence/presence tables
+-> needs testing as i'm guessing the format
* Re-added several bits of table data that should not have been cleared
+-> New char data, imglist, itemserial table and some others
* Added a trigger to auto-force online accounts off line when logging in (the "already online" bug) thanks to xz3r0x.


More guides to follow

 

[jonathan3137]

Re: My guides + databases

EDIT: nvm, I read it again... "I don't want to include fixes"
Thanks for the release

 

[myliquid]

Re: My guides + databases

chumpywumpy do you know how to make we launcher not use internal.txt?

 

[chacina]

Re: My guides + databases

launcher dont use internal.txt, cabalmain.exe use...
check u internal.txt is ANSI

IP=IP_HERE
PORT=38101
IP_CHAT=IP_HERE
PORT_CHAT=38121

 

[0d3m0ns0]

Re: My guides + databases

_few_ fixes ( What Fixes ?

 

[myliquid]

Re: My guides + databases

launcher dont use internal.txt, cabalmain.exe use...
check u internal.txt is ANSI

IP=IP_HERE
PORT=38101
IP_CHAT=IP_HERE
PORT_CHAT=38121

i know launcher use cabalmain.exe and it call internal.txt for ip and port, i use ollydbg and search for name string and found internal.txt, breakly, husky..... but don't what to do with that....

 

[chumpywumpy]

Re: My guides + databases

@0d3m0ns0 - I have not actually noted which fixes (removing the need for gameserver, creating presence tables, the "already logged on" trigger) i have applied and i know these copies don't have everything i have applied to my main database. I plan on a little more testing on my own databases and then i will be updating them listing exactly what has been applied. It will either be later today or tomorrow i would think.

@myliquid - I have not bothered taking my hexing tools to any of the exes in any serious way yet. I have been looking for un-modded copies of the exes so i can compare and see what has been changed so i can figure out how to hex other ones, but i got sick of downloading random clients trying to find the versions i needed and my posts here for copies went unanswered.

I see little point in learning how to do minor edits like that yet as we don't actually know how to hex new copies which is far more important. To be honest i don't see any benefit of removing the need for internal.txt anyway as it is a convenience for me.

What we really need is a tool that gives you a list of fixes that you can choose from and then apply the patch. Ragnarok servers use this method for their sakexes (i used to be one of the people that made them) and it would be perfect for us too, however to make the diff file it all works from i need the unedited exes from a .22 client.

 

[q1q1we]

Re: My guides + databases

@chumpywumpy

for the databases , do i just replace or put it in the cabal databases folder???

Thank for this Release ^^

 

[chumpywumpy]

Re: My guides + databases

The databases are proper backups that need restoring and not attaching. The guide covers how to do this on SQL 2005 and it is pretty much the same for 2000.

To be honest i would not use the databases yet as i have stripped a lot of data out and applied some fixes, but i don't consider them well tested yet. If you are interested in testing them then that's fine but if you are setting up a new server i would use the copies that came with the sever files for now and use my ones only if you run into problems with missing tables or stored procedures.

 

[q1q1we]

Re: My guides + databases

Thank alot chumpywumpy ^^

I'll be looking forward for ur full Release

have a nice day

 

[chumpywumpy]

Re: My guides + databases

I have taken the database link off for now. If anyone has then do not use the account db as i have found 3 tables i cleared that should no be cleared and you won;t be able to create new chars. If you have installed the account database then either overwrite it witht he one that comes with the server files or post here and i will give you some sql queries to fix it.

I have tested the rest of them and they look ok. I am putting more fixes in now so i can put the links back up and then finish the server install guide and my server repack.

 

[Disconnect1]

Re: My guides + databases

I have taken the database link off for now. If anyone has then do not use the account db as i have found 3 tables i cleared that should no be cleared and you won;t be able to create new chars. If you have installed the account database then either overwrite it witht he one that comes with the server files or post here and i will give you some sql queries to fix it.

I have tested the rest of them and they look ok. I am putting more fixes in now so i can put the links back up and then finish the server install guide and my server repack.

Yea i was going to reply for that

Doesn`t work to create new char :/
Waiting for it...

 

[darkg32004]

Re: My guides + databases

This is a truly a great relief chumpy, keep up the gud work, thnx!!!:flag_schw

 

[chumpywumpy]

Re: My guides + databases

*Bump* Databases updated

EDIT: My server repack has been added too!

I won't nominate my own posts for stickies so if you think it should be please say or it won't get stickied.

 

[Inmetsu]

Re: My guides + databases + server files repack!

Forgive me if I intrude, but I packed the DB files up into one easy .rar for you. I thought they might be included in the full repack, but they're not >.~

http://rapidshare.com/files/136108929/chump_db_9.8.2008.rar

 

[SamkuS]

Re: My guides + databases + server files repack!

OMG i use u DB...i have big problem with connect chanel....i can enter in chanel...

 

[chumpywumpy]

Re: My guides + databases + server files repack!

Thanks Inmentsu! The reason i didn't put the databases in one file or include them in the server repack is because i'm guessing i will be updating certain databases quite a lot and listing them seperately allows me to put a date on each of them so you can tell when i update one. It saves having to download the whole lot again whenever i make a minor change

@SamkuS - You do know that everyone has the login bug don't you? These are clean copies of the databases i use myself so they should work fine. Keep trying as it can take me a few tries to get in and keep an eye on your logfiles in cause there are any errors in there.

Also remember that you need to set permissions on your databases to let whatever userid your server uses access them. I can't do that bit for you sadly.

 

[Inmetsu]

Re: My guides + databases + server files repack!

Thanks Inmentsu! The reason i didn't put the databases in one file or include them in the server repack is because i'm guessing i will be updating certain databases quite a lot and listing them seperately allows me to put a dat on each of them so you can tell when i update one. It saves having to download the whole lot again whenever i make a minor change

No problem, I did date the package just incase :3

 

[Just_Rytis]

Re: My guides + databases + server files repack!

What's new in what pached? What fixed? Thx!

 

[chumpywumpy]

Re: My guides + databases + server files repack!

The main post explains it. I have made several changes to the databases (other than emptying the old player data) and each change is listed under the database download link.

For the server repack i have changed the default config file from .ini to .cfg so they are always safe. The modified gen_config2.sh i included will put the configs in place and put the IP addresses and db user/pass in the right spots for you and will also do your odbc.ini. The reason for these changes is because the old gen_config wans't very good and running it a second time didn't work, now it does