ODBC Needed:
Tantra - for Tantra Login
BILL_CONN - for Premium Item
TantraGM - for GMTool
UserLogin - for Registration
MSSQL SERVER ADVANCE 2012 and MSSQL Management Tool - for Restoring/Creating/Modifying Tantra Database
Database Needed:
billcruxphil
Tantra
userlogin
Tantra has two ODBC (Tantra and TantraGM) for Game Data and Ranking
billcruxphi = BILL_CONN (ITEMSERV.EXE and Webmall)
userlogin = UserLogin (For DBSERV and login.php)
for billcruxphil database, you only need the dbo.tblUserInfo (for Item Mall/Webmall/Krishuna) and dbo.tblUser (for WebMall Item) Leave the rest you might need them when you want to modify everything from top-up cards to expiry date.
for userlogin database, you will only use dbo.tblAccount (This is for Player registration in the website and Player Verification of HTLauncher and HTSSetting.txl)
for Tantra database, use the dbo.tblAccount (this is updated link between your DBSRV.EXE and your Account Details and GMTool), dbo.tblCharacter_tribe (Usen in more filtered ranking), dbo.GameInfo00 to dbo.GameInfo05 (the table used by your caste system, Ranking and SQLDAEMON.EXE linking to dbo.TantraBackup00 to dboTantraBackup05 that each of this tables are inter-related with each other),
The result why there is no update on caste system is that, the Series of interlink between MSSQL tables are not tested, checked and updated. You have to do trial and error as to modify everything that records all the data in the game. with SQLDAEMON.EXE running, it automatically transmit the data from dbo.TantraBackup00 to dbo.GameInfo00 and Replicating manually to dbo.TantraBackup01 with dbo.GameInfo01 and up to 05. If this did not record anything, you know where to troubleshoot.
That's all I could share today. I just explained how MSSQL, ODBC, Game client and Web inter connects. To really understand MSSQL you have to understand how its data saved and retrieved from every table in the database. I will not elaborate more of it. You have to DoITYourself in order to make it work.
This is for the newbies who are too lazy to search for the posted answers.
Credits to infinium, yagamy, hetrojeneo, masteryuda, john torres and the developers of ragezone. Because this data posted in here are combined post of this developers.
