Forum home Counter

==========================
Forum Home Counter
By Larrysw
==========================

[high]What Does this do?[/high]
It adds a counter to your forum home.

[high]UPGRADING[/high]
Upload the product

Open the FORUMHOME templeate
##############################
Find:

<div align="center"><phrase 1="$count">$vbphrase[counter]</phrase> </div>

and delete it!
##############################

If you are getting errors about the my SQL table not working run this query:
[sql]CREATE TABLE prefix_forum_home_counter (
`count` varchar(6) NOT NULL default '',
PRIMARY KEY (`count`)
) TYPE=MyISAM;
INSERT INTO prefix_forum_home_counter VALUES ('0');
[/sql]

All Done

[high]What will be added?[/high]

• amount of users who visted on the calender

[high]Update Log[/high]
1.0.4; No more edits.
1.0.3; Changed numbers from 1000 to 1,000.
1.0.2; Fixed the the install, the text on forum home.
1.0.1; Fixed to work with table prefixs.

[high]*Support Info[/high]
Support is only given to those who click install! It's a simple request.

[bashy]

Hi, This works fine for me
Is there away to change the strating amount of users...

It started at 0 and i need to put in a amount of my own?
How do i do this please?

[DrewM]

Can this be made to show the number of visitors in the Calendar ? say in the weekly view ?

sure next release this will be included.

Hi, This works fine for me
Is there away to change the strating amount of users...

It started at 0 and i need to put in a amount of my own?
How do i do this please?

yea go to SQl querys and run this query:
[sql]UPDATE forum_home_counter SET count = count X
[/sql]

[osso12]

were cool..
I am using this one found here as it works real well.
https://vborg.vbsupport.ru/showthrea...+Jan+18th+2006

[bashy]

Didnt work for me m8

Got an error:

SQL query:

UPDATE forum_home_counter SET count = count584254

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '584254' at line 1

Any advice?

[DrewM]

Originally Posted by bashy

Didnt work for me m8

Got an error:

SQL query:

UPDATE forum_home_counter SET count = count584254

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '584254' at line 1

Any advice?

try this:
[sql]UPDATE `forum_home_counter` SET `count` = '60';[/sql]

[bashy]

Worked well m8, thanks for your help

Originally Posted by Larrysw

try this:
[sql]UPDATE `forum_home_counter` SET `count` = '60';[/sql]

[steadicamop]

Would be great if this worked - for whatever reason it doesn't add the table in the database, tried to create it manaually but just didn't work - bit of a led down.

[NiTRoN]

i tried the 1.02 one still came up with the sql error.. had to manaully create table by running the query below

CREATE TABLE vbulletin_forum_home_counter (
`count` varchar(6) NOT NULL default '',
PRIMARY KEY (`count`)
) TYPE=MyISAM;
INSERT INTO vbulletin_forum_home_counter VALUES ('0');

keep in mind my table prefixes are vbulletin_ adjust yours accordingly


If you want to change the starting count number.. just change last 0 to whatever number you want.

also I placed <div align="center"><phrase 1="$count">$vbphrase[counter]</phrase> </div>
on bottom of adv_portal_foot template so it only show on my main portal page..

[steadicamop]

Originally Posted by NiTRoN

i tried the 1.02 one still came up with the sql error.. had to manaully create table by running the query below

CREATE TABLE vbulletin_forum_home_counter (
`count` varchar(6) NOT NULL default '',
PRIMARY KEY (`count`)
) TYPE=MyISAM;
INSERT INTO vbulletin_forum_home_counter VALUES ('0');

keep in mind my table prefixes are vbulletin_ adjust yours accordingly


If you want to change the starting count number.. just change last 0 to whatever number you want.

also I placed <div align="center"><phrase 1="$count">$vbphrase[counter]</phrase> </div>
on bottom of adv_portal_foot template so it only show on my main portal page..

Thanks, that did the trick, was trying to suss out the MySQL code but got so stressed I just left it - if anything that's probably easier

[Allan]

Work now ?