Download
My Modified Files
Download
Oracle VirtualBox
Download
CentOS 5.8 DVD Full
Torrent
MSSQL 2008 R2 32/64bit both
Download Page
Client (TGCABAL Ep8)
Mirror Bayfilesr
Mirror Depositfiles
1.)MSSQL Installation:
This need 40GB free space around, until anyone dont creating clean db's!
-Download MSSQL 2008 R2
-Follow this guide!
Install and Configure SQL Server 2008 Express | Symantec Connect Community
!!! Install in Default Instance (not Named!!!!) and Mixed authenctication! (this will be a sa's password)
-Create a backup devices (database you find in full files /backupDB/ directory)
-Add Linked Server:
-If you are finished need to seen as:
2.)CentOS Installation
-Download VirtualBox and CentOS DVD
-Set your VM as you know! (Minimum 2 core, and 2GB of memory), if you have router set your Network to Bridged Network.
-Install CentOS (maybe can help this video: How to install CentOS 5 [www.techedze.com] - YouTube)
-copy the rpm folder (this you found in full server files) into /home then
Code:
yum install unixODBC openssl097a net-snmp-utils net-snmp-libs net-snmp lm_sensors gcc freetds dstat compat-libstdc++-33 compat-libstdc++-296
rpm -Uvh /home/rpm/cabal-server-ph-1.0-1.i386.rpm
-Use WinSCP for copying files to CentOS and copy from full server etc, home, usr directory (Do not modify anything!)
-Run this script in Terminal:
Code:
#!/bin/sh
chmod 0777 /etc/odbc.ini
chmod -R 0777 /etc/cabal
rm -f /usr/bin/GlobalDBAgent
rm -f /usr/bin/CashDBAgent
rm -f /usr/bin/PCBangDBAgent
rm -f /usr/bin/EventDBAgent
rm -f /usr/bin/DBAgent_*
rm -f /usr/bin/ChatNode_*
rm -f /usr/bin/WorldSvr_*
rm -f /usr/bin/AgentShop_*
rm -f /usr/bin/LoginSvr_*
rm -f /usr/bin/PartySvr_*
ln -sf /usr/bin/DBAgent /usr/bin/CashDBAgent
ln -sf /usr/bin/DBAgent /usr/bin/DBAgent_01
ln -sf /usr/bin/DBAgent /usr/bin/GlobalDBAgent
ln -sf /usr/bin/DBAgent /usr/bin/PCBangDBAgent
ln -sf /usr/bin/DBAgent /usr/bin/EventDBAgent
ln -sf /usr/bin/ChatNode /usr/bin/ChatNode_01
ln -sf /usr/bin/AgentShop /usr/bin/AgentShop_01
ln -sf /usr/bin/LoginSvr /usr/bin/LoginSvr_01
ln -sf /usr/bin/PartySvr /usr/bin/PartySvr_01
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_01
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_02
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_03
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_04
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_05
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_06
ln -sf /usr/bin/WorldSvr /usr/bin/WorldSvr_01_08
chmod 0777 /usr/bin/AuthDBAgent
chmod 0777 /usr/bin/RockAndRollITS
chmod 0777 /usr/bin/DBAgent*
chmod 0777 /usr/bin/GlobalDBAgent
chmod 0777 /usr/bin/GlobalMgrSvr
chmod 0777 /usr/bin/ChatNode*
chmod 0777 /usr/bin/CashDBAgent
chmod 0777 /usr/bin/PCBangDBAgent
chmod 0777 /usr/bin/EventDBAgent
chmod 0777 /usr/bin/EventMgrSvr
chmod 0777 /usr/bin/AgentShop*
chmod 0777 /usr/bin/LoginSvr*
chmod 0777 /usr/bin/PartySvr*
chmod 0777 /usr/bin/WorldSvr*
rm -f /etc/init.d/AuthDBAgent
rm -f /etc/init.d/RockAndRollITS
rm -f /etc/init.d/DBAgent*
rm -f /etc/init.d/GlobalDBAgent
rm -f /etc/init.d/GlobalMgrSvr
rm -f /etc/init.d/ChatNode*
rm -f /etc/init.d/CashDBAgent
rm -f /etc/init.d/PCBangDBAgent
rm -f /etc/init.d/EventDBAgent
rm -f /etc/init.d/EventMgrSvr
rm -f /etc/init.d/AgentShop*
rm -f /etc/init.d/LoginSvr*
rm -f /etc/init.d/PartySvr*
rm -f /etc/init.d/WorldSvr*
ln -sf /etc/init.d/cabal_server /etc/init.d/AuthDBAgent
ln -sf /etc/init.d/cabal_server /etc/init.d/RockAndRollITS
ln -sf /etc/init.d/cabal_server /etc/init.d/DBAgent_01
ln -sf /etc/init.d/cabal_server /etc/init.d/GlobalDBAgent
ln -sf /etc/init.d/cabal_server /etc/init.d/GlobalMgrSvr
ln -sf /etc/init.d/cabal_server /etc/init.d/ChatNode_01
ln -sf /etc/init.d/cabal_server /etc/init.d/CashDBAgent
ln -sf /etc/init.d/cabal_server /etc/init.d/PCBangDBAgent
ln -sf /etc/init.d/cabal_server /etc/init.d/EventDBAgent
ln -sf /etc/init.d/cabal_server /etc/init.d/EventMgrSvr
ln -sf /etc/init.d/cabal_server /etc/init.d/AgentShop_01
ln -sf /etc/init.d/cabal_server /etc/init.d/LoginSvr_01
ln -sf /etc/init.d/cabal_server /etc/init.d/PartySvr_01
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_01
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_02
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_03
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_04
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_05
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_06
ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_08
chmod 0777 /etc/init.d/AuthDBAgent
chmod 0777 /etc/init.d/RockAndRollITS
chmod 0777 /etc/init.d/DBAgent*
chmod 0777 /etc/init.d/GlobalDBAgent
chmod 0777 /etc/init.d/GlobalMgrSvr
chmod 0777 /etc/init.d/ChatNode*
chmod 0777 /etc/init.d/CashDBAgent
chmod 0777 /etc/init.d/PCBangDBAgent
chmod 0777 /etc/init.d/EventDBAgent
chmod 0777 /etc/init.d/EventMgrSvr
chmod 0777 /etc/init.d/AgentShop*
chmod 0777 /etc/init.d/LoginSvr*
chmod 0777 /etc/init.d/PartySvr*
chmod 0777 /etc/init.d/WorldSvr*
-extract my mofidied files into somewhere your windows and edit:
--etc/odbc.ini
MSSQLIP = Your MSSQL Server IP adress (3x each WorldSvr!!! If u forgot some, than you can't connect into channel!)
--etc/cabal/
---AuthDBAgent.ini, CashDBAgent.ini, DBAgent_01.ini, EventDBAgent.ini, GlobalDBAgent.ini, PCBangDBAgent.ini
MSSQLUSER = Your MSSQL user name, (default: sa)
MSSQLPW = Your MSSQL password
--WorldSvr_01_0x.ini x=1,2,3...
CENTOSIP = Your CentOS Ip
-Now copy these files into centos
-Type into console:
Code:
service cabal stop
wait until all finished and again:
Code:
service cabal stop
and if finished than write:
Code:
service cabal start
ENJOY!
3.)Client
-Download any TGCabalep8 link
-Create a file internal.txt
Code:
[MD5CHECK]
LANGUAGE_SKIP = 1
ALL_FILE_CHECK = 0
[server]
IP=CENTOSIP
PORT=38101
IP_CHAT=CENTOSIP
IP_PORT=38121
CMK=0
(check your centos firewall the ports are opened)
-start cabalmain.exe with breaklee
==SQL CLEANUP FROM x30unlimited post
Code:
here's some db cleanup scripts, credits to eRRoR and me for addin a few extra lines :P
CREATE PROCEDURE [dbo].[clean_account]
AS
BEGIN
TRUNCATE TABLE cabal_additional_dungeon_instance_table
TRUNCATE TABLE cabal_AlzEarnLock_table
TRUNCATE TABLE cabal_auth_table
TRUNCATE TABLE cabal_autoblock_log
TRUNCATE TABLE cabal_blockip_list
TRUNCATE TABLE cabal_blockuser_table
TRUNCATE TABLE cabal_bot_report_table
TRUNCATE TABLE cabal_character_count_table
TRUNCATE TABLE cabal_charge_auth
TRUNCATE TABLE cabal_freeip_list
TRUNCATE TABLE cabal_GM_ip_table
TRUNCATE TABLE cabal_hackuser_list
TRUNCATE TABLE cabal_otp_table
TRUNCATE TABLE cabal_permission_shop
TRUNCATE TABLE cabal_sub_password_table
TRUNCATE TABLE cabalapp_android_push_category
TRUNCATE TABLE cabalapp_android_push_message
TRUNCATE TABLE cabalapp_android_registration_id
TRUNCATE TABLE cabalapp_iphone_device_token
TRUNCATE TABLE cabalapp_iphone_lastlogin
TRUNCATE TABLE cabalapp_iphone_push_category
TRUNCATE TABLE cabalapp_iphone_push_message
TRUNCATE TABLE facebook_authcode
TRUNCATE TABLE facebook_event
TRUNCATE TABLE facebook_event_category
TRUNCATE TABLE facebook_event_log
TRUNCATE TABLE facebook_event_log_image
TRUNCATE TABLE facebook_userevent
TRUNCATE TABLE facebook_usermapping
TRUNCATE TABLE ipchecking
TRUNCATE TABLE Web_Log
TRUNCATE TABLE Web_Vote
TRUNCATE TABLE Web_Wall
END
CREATE PROCEDURE [dbo].[clean_cabalcash]
AS
BEGIN
TRUNCATE TABLE CashAccount
TRUNCATE TABLE CashChargeErrorLog
TRUNCATE TABLE CashLog
TRUNCATE TABLE CashLogType
TRUNCATE TABLE CashPremiumLog
TRUNCATE TABLE epoint_buy
TRUNCATE TABLE epoint_charge
TRUNCATE TABLE epoint_charge_transfer
TRUNCATE TABLE GiftCashLog
TRUNCATE TABLE MyCashItem
TRUNCATE TABLE npc_deleteCashLog
TRUNCATE TABLE PAYPAL_LOG
TRUNCATE TABLE VoucherDetails
TRUNCATE TABLE VoucherItemMaster
TRUNCATE TABLE VoucherMaster
END
CREATE PROCEDURE [dbo].[clean_cabalguild]
AS
BEGIN
TRUNCATE TABLE Guildboard
TRUNCATE TABLE GuildBoardComment
TRUNCATE TABLE GuildDetail
TRUNCATE TABLE GuildGuestBoard
TRUNCATE TABLE GuildInfo
TRUNCATE TABLE GuildMaster_Change_Log
TRUNCATE TABLE tempguild
END
CREATE PROCEDURE [dbo].[clean_netcafebilling]
AS
BEGIN
TRUNCATE TABLE Point
END
CREATE PROCEDURE [dbo].[clean_gamedb]
AS
BEGIN
TRUNCATE TABLE cabal_achievement_history
TRUNCATE TABLE cabal_achievement_open
TRUNCATE TABLE cabal_achievement_title
TRUNCATE TABLE cabal_achievement_title_shared
TRUNCATE TABLE cabal_agentshop_bookmark
TRUNCATE TABLE cabal_agentshop_done_table
TRUNCATE TABLE cabal_agentshop_pet_table
TRUNCATE TABLE cabal_agentshop_price_average
TRUNCATE TABLE cabal_agentshop_price_daily
TRUNCATE TABLE cabal_agentshop_sale_table
TRUNCATE TABLE cabal_alzSupply_table
TRUNCATE TABLE cabal_Assistant_table
TRUNCATE TABLE cabal_badwoard
TRUNCATE TABLE cabal_bbead_table
TRUNCATE TABLE cabal_character_table
TRUNCATE TABLE cabal_craft_table
TRUNCATE TABLE cabal_DungeonPoint_table
TRUNCATE TABLE cabal_DungeonRanking_Data_table
TRUNCATE TABLE cabal_DungeonRankingParty_table
TRUNCATE TABLE cabal_DungeonRankingSingle_table
TRUNCATE TABLE cabal_ems_userstate_table
TRUNCATE TABLE cabal_equipment_lock_table
TRUNCATE TABLE cabal_equipment_table
TRUNCATE TABLE cabal_event_partydg
TRUNCATE TABLE cabal_event_singledg
TRUNCATE TABLE cabal_event_special_character_data
TRUNCATE TABLE cabal_event_special_character_data_for_client
TRUNCATE TABLE cabal_Forcecalibur_Owner
TRUNCATE TABLE cabal_guildEnterLog_table
TRUNCATE TABLE cabal_GuildLord_WinnerRecord
TRUNCATE TABLE cabal_guildMaxCcu_table
TRUNCATE TABLE cabal_help_table
TRUNCATE TABLE cabal_instantWar_nationRewardWarResults
TRUNCATE TABLE Cabal_InstantWar_Penalty_table
TRUNCATE TABLE cabal_instantWar_results
TRUNCATE TABLE cabal_instantWar_statistics
TRUNCATE TABLE cabal_Inventory_table
TRUNCATE TABLE cabal_item_extend_table
TRUNCATE TABLE cabal_last_login_character
UPDATE cabal_itemserial_table SET SerialBgn = 0
TRUNCATE TABLE cabal_LordOfWar_point_table
TRUNCATE TABLE cabal_LordOfWar_Rank_table
TRUNCATE TABLE cabal_LordOfWar_table
TRUNCATE TABLE cabal_mail_notice_forward_table
DELETE FROM cabal_mail_notice_table
TRUNCATE TABLE cabal_mail_received_table
TRUNCATE TABLE cabal_mail_report_table
TRUNCATE TABLE cabal_mail_sent_pet_table
DELETE FROM cabal_mail_sent_table
DELETE FROM cabal_pet_table
TRUNCATE TABLE cabal_qddata_table
TRUNCATE TABLE cabal_questdata_table
TRUNCATE TABLE cabal_quickslot_table
TRUNCATE TABLE cabal_record_combo
TRUNCATE TABLE cabal_saved_buff_table
TRUNCATE TABLE cabal_skilllist_table
TRUNCATE TABLE cabal_sold_item_table
TRUNCATE TABLE cabal_soul_ability_table
TRUNCATE TABLE cabal_title_guild
TRUNCATE TABLE Cabal_Title_PlayHistory
TRUNCATE TABLE Cabal_Title_Show_Table
TRUNCATE TABLE Cabal_Title_Table
TRUNCATE TABLE cabal_title_viaserver_table
TRUNCATE TABLE cabal_tool_agentshop_auto_item_table
TRUNCATE TABLE cabal_tool_agentshop_auto_table
TRUNCATE TABLE cabal_tool_agentshop_log_table
TRUNCATE TABLE cabal_tool_agentshop_schedule_log_table
TRUNCATE TABLE cabal_tool_agentshop_search_item_table
TRUNCATE TABLE cabal_warehouse_ext_table
TRUNCATE TABLE cabal_warehouse_ext2_table
TRUNCATE TABLE cabal_warehouse_table
TRUNCATE TABLE cabal_WarExp_Table
TRUNCATE TABLE cabalapp_log_table
TRUNCATE TABLE chat_buddy_pr_message
TRUNCATE TABLE chat_buddy_table
TRUNCATE TABLE chat_buddygroup_table
TRUNCATE TABLE ChatBlacklist
TRUNCATE TABLE chg_mrank
TRUNCATE TABLE chg_srank
TRUNCATE TABLE deleted_cabal_achievement_title
TRUNCATE TABLE deleted_cabal_character_table
TRUNCATE TABLE deleted_cabal_inventory_table
TRUNCATE TABLE deleted_cabal_item_extend_table
TRUNCATE TABLE deleted_Cabal_Title_PlayHistory
TRUNCATE TABLE EVENT_LEVELUP_NEWCHAR_TABLE
TRUNCATE TABLE Guild
TRUNCATE TABLE guild_backup
TRUNCATE TABLE guild_level_limit
TRUNCATE TABLE guild_warehouse_log
TRUNCATE TABLE guild_warehouse_table
TRUNCATE TABLE GuildGroup
TRUNCATE TABLE GuildMember
TRUNCATE TABLE levelUpStepTable
TRUNCATE TABLE LevUpEventWinTable
TRUNCATE TABLE log_nation
TRUNCATE TABLE Mail
END
If you get something error with sql but server run than you can login.
if your cabalmaiin.exe erroring with item.enc than download this and extract into client/Data folder it will help.
!!! IgnoreClientVersion=1 in LoginSvr_01.ini provide that you can connect with any client. Later should modify the final client version and Magic Key !!!
UPDATE 2013.01.25:
-How check my centos can connect to mssql server?
-Run followings:
Code:
yum install nmap
after install use it! (MSSQLIP mean your mssql ip adress)
Code:
nmap -p T:1433 MSSQLIP
If you get result open than it's okay! Any other (closed/filtered) will be bad. Make your firewall sure!
-How to summon Vkalitan in LS4?
-Get a GM nation and write ingame:
Code:
/_summon 1 1799
Number of Drops = ForceCalibur drops number!
-Some instruction for cabal_character_table:
Code:
-CharacterIdx = Your Character Database ID! (need for lot of stored procedure!)
-Name = Character Name
-LEV = Character Level
-EXP = Current Experience points
-STR, DEX, INT = Your character base stats, you can modify free, but be aware if your stats too high may attack rate gone to 1 and you hit much miss
PNT = Free stat points
Rank = Your skill rank!
Alz = Your alz amount, never modify in this table because you will crash when you try log in to server.
WorldIdx, Position = That place where you logged out!
Style = You character styles and class ranks!
HP, MP = Encoded datas. This too should not modify! Same as with Alz editing.
SwdPNT, MagPNT = Your sword/magic skill points
WarpBField, MapBField = Ingame M (Map) maps and warps. Set to 2047 to get until porta inferno!
SP = Your current SP amount. Coded data... do not modify
PenalityExp = Your death penality exp amount
LogoutTime = When you logged out
RP = idk
Reputation = Honor Points amount (max. 2 000 000 000)
LoginTime = When you logged in
Playtime = Your ingame spent time in minute!
PKPenality = Is set your PK level! (i dont tested it yet)
Nation = Neutal, Procyon, Capella, GM (for GM need to add ip in DB too)
CreateDate = When you created the character
Login = Are you now logged in or no! (It will be bugged if server down! This cause your double login messeage)
GOOD LUCK FOR EVERYONE!
Credits:
Justin Bieber ^^ - For full server files
x30unlimited - For lots of tutorials
AkiSora - For just because :P
TmX - For Vkalitan GM command and using /_summon
PLACEHOLDER
DeXtR
Ragezone