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.

[steadicamop]

Yup no probs now ... just changed the phrase to something different

[DrewM]

Originally Posted by steadicamop

Yup no probs now ... just changed the phrase to something different

Well looks like all the errors are fixed so I'll start working on some new things.

[Gizmo5h1t3]

nope, cant geteither version to work....no table is installed, and the query posted here doesnt work....gettin syntax errors...

[DrewM]

what are the errors?

[steadicamop]

It would appear for whatever reason, that the Product XML doesn't install the database table - now this may have something to do with it, I read you upgraded it to allow for table prefixes - which I don't have, and feel this may cause the issue, but am no expert in MySQL I just about understand it.

[DrewM]

Originally Posted by steadicamop

It would appear for whatever reason, that the Product XML doesn't install the database table - now this may have something to do with it, I read you upgraded it to allow for table prefixes - which I don't have, and feel this may cause the issue, but am no expert in MySQL I just about understand it.

I think Its some thing weird with products because some thing simmler happend with a mod I installed.

[Allan]

The meter jams in 999999, it's possible to go above ?

[DrewM]

yea... just run this query:
[sql]ALTER TABLE `forum_home_counter` CHANGE `count` `count` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL[/sql]

[Allan]

Originally Posted by Larrysw

yea... just run this query:
SQL Query: (how to run queries)
ALTER TABLE `forum_home_counter` CHANGE `count` `count` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

Thanks Larry

[DrewM]

Alway welcome