CabalToolz V3.1

[dordort]

Today, john_d has released his new CabalToolz version, that is not much diffrent from V3, but it is kind of "optimized" version. The newest CabalToolz, that really has a lot of a new cool features (CabalToolz V4) will be released soon, but right now only the "premium members" of john_d business are able to get it.

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 :p
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-conte.../character.jpg

New Guild Page:

http://www.mmowebs.com/blog/wp-conte.../02/guilds.jpg


Downloads:


Backend: http://www.mediafire.com/?ymrilkmy2nk

Frontend (Theme: dark theme. Version: v3.1 with Cache System): http://www.mediafire.com/?umz0ujjmjnv


Demo Link: http://www.mmowebs.com/cabaltoolzv3darktheme/


Source: http://www.mmowebs.com/blog/cabaltoolz-v3-1-release

[MentaL]

[cypher]

*poof* your up.

We kinda needed a sticky website.

[Cath22]

why not let john post it, it is his work. ;) hehehe peace but nice to hear john is still working on cabaltoolz.

[john_d]

yo...........

[P1MAX]

hello John_d

what about CabalToolv4 release ?????

thnks

[swetmary143]

Wow its cool but why the reg page button is not showing? Pls help thanks in advance all mods here... :)

[emi]

Wow its cool but why the reg page button is not showing? Pls help thanks in advance all mods here... :)

you will have to do it on your own,it's from dark theme...

[Thesnowman]

I have it set up... But look... it says:

Cannot connect to the database because: Access denied for user 'johnd_db'@'c-71-59-174-158.hsd1.wa.comcast.net' (using password: YES)

but its configured like this:

$_config['db_type'] = 'mssql';
$_config['Server'] = "127.0.0.1";
$_config['User'] = "cabaladmin";
$_config['Pass'] = "******";
$_config['DB'] = "ACCOUNT";
$_config['DB2'] = "GAMEDB";
$_config['DB3'] = "CabalCash";

Now its trying to connect with the johd_db name but not cabaladmin...

[Cath22]

the news page is not yet configured.

[emi]

I have it set up... But look... it says:

Cannot connect to the database because: Access denied for user 'johnd_db'@'c-71-59-174-158.hsd1.wa.comcast.net' (using password: YES)

but its configured like this:

$_config['db_type'] = 'mssql';
$_config['Server'] = "127.0.0.1";
$_config['User'] = "cabaladmin";
$_config['Pass'] = "******";
$_config['DB'] = "ACCOUNT";
$_config['DB2'] = "GAMEDB";
$_config['DB3'] = "CabalCash";

Now its trying to connect with the johd_db name but not cabaladmin...

in frontend,modules frontpage.php you will find this line:'johnd_db'@'c-71-59-174-158.hsd1.wa.comcast.net'
so edit everything there ip etc..
Note*:you have to have a vbulletin forum
and provide ip&all login details from database of vbulletin forum!
Note**:Phbb forum will not work

News page is finished!

[Thesnowman]

What about these errors:

Fatal error: Call to a member function children() on a non-object in C:\xampp\htdocs\homepage\modules\mod.servstats.php on line 29

and when i go to register or try to access userpanel the loading wheel just keeps spinning and spinning.

I edited the new module and i get this now:

Cannot connect to the database because: Access denied for user 'cabaladmin'@'localhost' (using password: YES)

But i know the details are right... and i know the db is on this pc...

[emi]

fatal error: Call to a member function children() on a non-object in C:\xampp\htdocs\homepage\modules\mod.servstats.php on line 29

delete your chache folder,also your tmp folder
if this doesnt solve your problem
in htacces add this line:php_value zend.ze1_compatibility_mode 0

Cannot connect to the database because: Access denied for user 'cabaladmin'@'localhost' (using password: YES)

this is from news page?

[Thesnowman]

fatal error: Call to a member function children() on a non-object in C:\xampp\htdocs\homepage\modules\mod.servstats.php on line 29

delete your chache folder,also your tmp folder
if this doesnt solve your problem
in htacces add this line:php_value zend.ze1_compatibility_mode 0

Cannot connect to the database because: Access denied for user 'cabaladmin'@'localhost' (using password: YES)

this is from news page?

Yes its from news server. But what im trying to say is when i try to load user panel the wheel just spins forever.

Wanna see: http://sunsetcabal.servegame.com/homepage/index.php

Feel free to look around. I dont think cabal toolz is connecting to my DB

[emi]

Yes its from news server. But what im trying to say is when i try to load user panel the wheel just spins forever.

Wanna see: http://sunsetcabal.servegame.com/homepage/index.php

Feel free to look around. I dont think cabal toolz is connecting to my DB

as i said before,the news thing won't work until you have a vbulletin forum with it's own database....
if you have a vbulletin forum edit in frontend/modules/frontpage
those lines:if ($dbh=mysql_connect("74.53.96.18", "johnd_db","db")) {
mysql_select_db("johnd_vb");

The thing with user control pannel,i see neither register or anything else,so i'm guessing it's Unable to connect Db2!Check again login details!

[Thesnowman]

The details are correct... And the login on mssql has all rights to all the cabal dbs