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:
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.

First Post reserved

Nice idea, but you should work with prefixes to solve the problem with the mysql-error after installing the product:

Invalid SQL:
UPDATE forum_home_counter SET count = count + 1;

MySQL-Fehler : Table 'xxxx.forum_home_counter' doesn't exist
Fehler-Nr. : 1146

Yea I will update the mod.

Thanks! :-)

any screen shot?

Ahh will add and Find a demo here:
http://www.sim2world.com/forum/

You are the 29 user to vist the site.

Maybe some better english huh? :)


is it counts total visitors or unique ones?

yea that mite help :)

Total guests and users.

Error sql :(

Does this count from when you install it or from the very beginning?

I recieved an sql error when I uploaded the product

The beginning
Whats the error?

This error:

I would try re-downloading the zip and then re-uploading the product I thought I had fixed prefixs.

Same error.

hmmm I'll chect it out.

all it says was:
You are the user to vist the site.
Im uninstalling it till you get it fixed..
If you get it fixed send me an email to
teddy_scott2000@yahoo.com

Well I'm updating the mod tonight just wait I fixed the lang.

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

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?

sure next release this will be included.
yea go to SQl querys and run this query:
[sql]UPDATE forum_home_counter SET count = count X
[/sql]

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

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]

Worked well m8, thanks for your help :)

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.

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 ;)

Work now ?

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.

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

what are the errors?

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.

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

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]

Thanks Larry ;)

Alway welcome