My guides + databases + server files repack -V2!

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/share...m-tools-424909

SAUR0N's client patch:
http://forum.ragezone.com/f459/sync-...-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/edition...s/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/chump...v2-5-a-501965/

Quote:

---

Originally Posted by V2 Changes

* 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/13610892...b_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 :D

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

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

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

_few_ fixes ( What Fixes ?

Quote:

---

Originally Posted by chacina

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....

@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.

@chumpywumpy

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

Thank for this Release ^^

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.

Thank alot chumpywumpy ^^

I'll be looking forward for ur full Release

have a nice day :)

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.

Quote:

---

Originally Posted by chumpywumpy

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...

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

*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.

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/13610892...b_9.8.2008.rar