Hello guys.
I thought i should share this package with the cabal community since my other project is going very slow, so here it is.
Not much to explain about it.
I added the queries here and also in the package.
Heres a screenie how it looks:
http://oi49.tinypic.com/2i8yvr4.jpg
Queries
CashAccount:
Resets:Code:USE [CabalCash]
GO
ALTER TABLE [dbo].[CashAccount] ADD VOTE INT NOT NULL DEFAULT ((0))
GO
ALTER TABLE [dbo].[CashAccount] ADD USED_VOTE INT NOT NULL DEFAULT ((0))
GO
ALTER TABLE [dbo].[CashAccount] ADD USED_CASH INT NOT NULL DEFAULT ((0))
GO
WebshopCode:USE [GAMEDB]
GO
ALTER TABLE [dbo].[cabal_character_table] ADD Resets int NOT NULL DEFAULT((0))
GO
Webshop Category:Code:USE [CabalCash]
GO
/****** Object: Table [dbo].[WebShop] Script Date: 11/11/2012 12:50:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WebShop](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
[Description] [varchar](200) NOT NULL,
[ItemIdx] [int] NOT NULL,
[Options] [int] NOT NULL,
[Image] [varchar](200) NOT NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL,
[VALUE] [int] NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[WebShop] ADD CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)) FOR [Total]
GO
ALTER TABLE [dbo].[WebShop] ADD CONSTRAINT [DF_WebShop_VALUE] DEFAULT ((0)) FOR [VALUE]
GO
Vote:Code:USE [CabalCash]
GO
/****** Object: Table [dbo].[WebShop_Category] Script Date: 11/11/2012 12:50:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) NOT NULL,
[Access] [smallint] NOT NULL
) ON [PRIMARY]
GO
Credits:Code:USE [CabalCash]
GO
/****** Object: Table [dbo].[toolz_vote] Script Date: 11/11/2012 12:51:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[toolz_vote](
[id] [int] IDENTITY(1,1) NOT NULL,
[userid] [nchar](10) NOT NULL,
[votedata] [text] NULL,
CONSTRAINT [PK_mutoolz] PRIMARY KEY CLUSTERED
(
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
john_d
TG Cabal (For the package :ott1:)
LocaSimon (For providing me the needed files to test the whole package)
Notes
1. Do not ask how to properly set it up. Everything you need to know is inside the config files so please take a look at it, also search the forums for v3 setup since its almost the same.
2. This version doesnt contains the Item Customizer since LocaSimon asked me to no release with this package.
Some important things:
1. I keept the cache system on false because else i had some issues with the news system(maybe others too i dont remember exactly)
2. Make sure that mod_rewrite is enabled on your webserver & and also curl for more performance(check config files you will see what i meant).
3. I forgot to mention before the bug with the aura changer. If you change aura from site then probably it will change the face style(maybe others too? i dont remember exactly) of your character.
To fix this you have to change the new style code in the "backend/cabal/user.heroes.php" but to be honest i never messed with that code so im not sure where exactly the problem lies.
Heres the code that needs to be fixed(?)
Feel free to post the fixed code and i will add it to the package also the credits. :shakehands:PHP Code:$newstyle = ($style['GenderNO'] * hexdec(4000000)) +
(($_GET['value']*2) * hexdec(200000)) +
($style['Hair'] * hexdec(20000)) +
($style['Hair_Color'] * hexdec(2000)) +
($style['Face'] * hexdec(100)) +
($style['Class_Rank'] * 8) +
$style['Class'];
Let me know if i missed out anything from the package or anyone from the credits :cool:
Have a nice day and have fun with the files.
Multiupload Mirror: Multiupload.nl - upload your files to multiple file hosting sites!
Mediafire Mirror: CabalToolz_v4.7z
