ZH - Global Variables

[Ziki]

This modification was brought to you by
KXDesign
http://www.kxdesign.com/


~Hack name
Global Variables

~Hack description
Allows you to use some variables in any template you want for example when adding $zhmemberstotal it will display the number of members you have in total.:cross-eyed:

~Hack options

On/Off
On/Off Members
On/Off Threads
On/Off Posts
On/Off Polls
On/Off Events
On/Off Smilies
On/Off Forums
On/Off Attachments


~Hack info
File uploads: 0
Template edits: 0
Templates: 0
File edits: 0
Plugins: 1
SQL Queries: 0
Phrases: 3
Settings: 1

Install time: 3 sec
Install level: Easy

~Hack installation

Step 1: Import Product


~Hack screenshots
None


~Hack copyright
This may not be distributed,released or claimed as your work without author's permission.

[Ziki]

Variables:

$zhmemberstotal >>>>> Number of members in total.
$zhthreadtotal >>>>> Number of threads in total.
$zhposttotal >>>>> Number of posts in total.
$zhpolltotal >>>>> Number of polls in total.
$zhsmilietotal >>>>> Number of smilies in total.
$zhforumtotal >>>>> Number of forums in total.
$zheventtotal >>>>> Number of events in total.
$zhattachmenttotal >>>>> Number of attachments in total.

[Surviver]

This is not goode for the Performace, ist adds 8 Queries to each page. (global).

If you have a slow Server or many members, this is not good for the Perforace ...

Greetings SUrviver

[Ziki]

Yes I know.

[Atakan KOC]

very poor...

My Forum : Session Timeout 900 seconds
Online User : 400 :(

[Xoligy]

Why not make the ability to turn each one on/off?

[Ziki]

Will do.Wait a minute,Great idea anyways :D

[Garyk]

very nice waitng for you to update it so you can turn things on and off

[Ziki]

1.0.1 released

Options for every variable edit so you can shutdown the query.

[Adrian Schneider]

This is what the datastore is for. Have these queries run via cron and store them in the datastore... no point running them on every page!

[Garyk]

just installed and i get this error when trying to install
Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO vb_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'zh_variables_onoff',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
10,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_members',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
20,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_threads',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
30,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_posts',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
40,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_forums',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_smilies',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
60,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_posts',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
70,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_events',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
80,
0,
1,
'',
0,
'zh_variablesX'
),
(
'zh_variables_attachments',
'zh_variables',
'1',
'1',
'boolean',
'yesno',
90,
0,
1,
'',
0,
'zh_variablesX'
);

MySQL Error : Duplicate entry 'zh_variables_posts' for key 1
Error Number : 1062
Date : Wednesday, December 13th 2006 @ 02:38:35 PM
Script : http://pspvert.net/forums/admincp/plugin.php?do=productimport
Referrer : http://pspvert.net/forums/admincp/plugin.php?do=productadd
Classname : vb_database

[Ziki]

UNinstall and import again

[Garyk]

i get the same error but when i go into vbulletin options i get the options for this mod im testing if the phrases work now

Edit: nope they dont work

[Ziki]

Oh OK wait will fix now

[Garyk]

Oh OK wait will fix nowthnx plz post abck when fixed

[Ziki]

1.0.2 released
small fix

[Ziki]

This is what the datastore is for. Have these queries run via cron and store them in the datastore... no point running them on every page!

I never used the datastore.I might remake it today or tommorow.

[SaN-DeeP]

nice idea Ziki thanks this might be useful
/me subscribes to thread.

[Ziki]

Why subscribing and not installing?

[SaN-DeeP]

Why subscribing and not installing?
cause I need this for my new board, which shall be launched on 1st Jan 2007 :)

[Ziki]

Oh.And if I didn't mention yet you can suggest some new variables

[katilkuzu]

thanx. *installed*...

[StrifeX]

I have a suggestion, maybe you can make a variable for displaying how many threads are in each forum.

Markup like $zhtotalforumposts[forumidhere]

How does that sound?

[Ziki]

taken into account

[StrifeX]

Well, working on it or not Ziki?

[Ziki]

Read my sig.

[D&Y]

Thanks Very Useful Hack Installed.