[Release] CabalToolz v3.1

[Backo]

V3.1 Changelog:

Added widgets v1 to the backend
Added Frontend Local Cache for most used Data. So that website will never bug down anymore.
Removes all XML data retrieval directly from backend ( wtf was i thinking when i made that ^^ )
I'm also trying to clean up the Frontend.
Redid Character Hero Page
Redid Guild Page
Added Top Guilds to side bar
Modified the Signature Code just a little
Clean-up the Frontend files, they where very messy!

MSSQL QUERIES: (use only if you have never used CabalToolz before, upgrades from previous CabalToolz version to V3.1 do not need to do it again!)

This is for the Account database. changes for cabal_auth_table:

Use ACCOUNT; 
ALTER TABLE [dbo].[cabal_auth_table]  
ADD Gender int NULL ,  
Country int NULL ,  
Email varchar(100) NULL

This is for the GameDB table. it Adds the Resets column to the Cabal_character_table:

Use GameDB;  
ALTER TABLE [dbo].[cabal_character_table]  
ADD Resets int default 0

This is for the CabalCash Database. Adds two additional tables Webshop and Webshop Categories:

use CabalCash;  
CREATE TABLE [dbo].[WebShop](  
[int] IDENTITY(1,1) NOT NULL,  
[Name] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,  
[Description] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,  
[ItemIdx] [int] NOT NULL,  
[Options] [int] NOT NULL,  
[Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,  
[Cash] [int] NULL,  
[Alz] [int] NULL,  
[Category] [int] NOT NULL,  
[Available] [int] NOT NULL,  
[TimeLimit] [int] NOT NULL,  
[Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total]  DEFAULT ((0)))

CREATE TABLE [dbo].[WebShop_Category](  
[ID] [smallint] IDENTITY(1,1) NOT NULL,  
[Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,  
[Access] [smallint] NOT NULL)

Screen Shots:


New Character Page:

http://www.mmowebs.com/blog/wp-content/uploads/2010/02/character.jpg

New Guild Page:

http://www.mmowebs.com/blog/wp-content/uploads/2010/02/guilds.jpg


Downloads:


Backend: cabaltoolz_v3.1_backend.rar

Frontend (Theme: dark theme. Version: v3.1 with Cache System): cabaltoolz_v3.1_frontend.rar

Source: Cabaltoolz v3.1 Release | MMOwebs Project Blogs

All credits go to: john_d

 

[sexy_b0yy]

Мерси това ми трябваше