Forum home Counter

[DrewM]

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

What Does this do?
It adds a counter to your forum home.

UPGRADING
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:
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');


All Done

What will be added?

amount of users who visted on the calender

Update Log
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.

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

[DrewM]

First Post reserved

[klaush]

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

[DrewM]

Yea I will update the mod.

[klaush]

Yea I will update the mod.

Thanks! :-)

[bonjurkes]

any screen shot?

[DrewM]

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

[bonjurkes]

You are the 29 user to vist the site.

Maybe some better english huh? :)

<div align="center">You are the $count. visitor of my site. </div>


is it counts total visitors or unique ones?

[DrewM]

You are the 29 user to vist the site.

Maybe some better english huh? :)

<div align="center">You are the $count. visitor of my site. </div>


is it counts total visitors or unique ones?
yea that mite help :)

Total guests and users.

[Allan]

Error sql :(

[Borgs8472]

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

[Devil Woman]

I recieved an sql error when I uploaded the product

[DrewM]

Does this count from when you install it or from the very beginning?
The beginning
I recieved an sql error when I uploaded the product
Whats the error?

[Allan]

This error:

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

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

[DrewM]

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

[Allan]

Same error.

[DrewM]

hmmm I'll chect it out.

[osso12]

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

[DrewM]

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

[finn snor]

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

[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:
UPDATE forum_home_counter SET count = count X

[osso12]

were cool..
I am using this one found here as it works real well.
https://vborg.vbsupport.ru/showthread.php?t=102363&highlight=%2F%2Fmodified+by+Feckie+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]

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:
UPDATE `forum_home_counter` SET `count` = '60';

[bashy]

Worked well m8, thanks for your help :)


try this:
UPDATE `forum_home_counter` SET `count` = '60';

[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]

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 ?

[steadicamop]

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

[DrewM]

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]

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:
ALTER TABLE `forum_home_counter` CHANGE `count` `count` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

[Allan]

yea... just run this query:
SQL Query: (how to run queries (http://www.vbulletin.com/forum/showthread.php?t=18558))
ALTER TABLE `forum_home_counter` CHANGE `count` `count` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL



Thanks Larry ;)

[DrewM]

Alway welcome

[csidlernet]

/me thanks you for this hack

[DrewM]

* DrewM thanks you for this hack
well thanks for the install

[The Fathom]

I do not have a error but it is saying You are the . visitor of my site. Just a dot nothing more.

[Snake]

I like it!

[DrewM]

I do not have a error but it is saying You are the . visitor of my site. Just a dot nothing more.
weird that would mean the parse is not getting the data I'm totally sure I would suggest making sure that the plugin is active and that it contains the same code as the download.

Lil Ripsta; thanks

[wobbly]

I do not have a error but it is saying You are the . visitor of my site. Just a dot nothing more.

Thats all Im getting too. Not being VB literate I cant really understand your install details at all.

Upload - doesnt really explain anything if your at VB literacy zero like myself.

The way I see it,

upload means go to your manage products in cp and import it.

Then add that line in your footer and you should be there????

Am I correct?

P.S. Sorry for being so dumb

[Boofo]

How many queries does this add? At least 2? ;)

[DrewM]

How many queries does this add? At least 2? ;)
yep two

[Boofo]

yep two

If you're interested, I did one with 1 query that also gives you how many days have elapsed from the site start date. ;)

[DrewM]

If you're interested, I did one with 1 query that also gives you how many days have elapsed from the site start date. ;)
I am interested

[DrewM]

UPDATE: 1.0.3; Changed numbers from 1000 to 1,000

[Boofo]

I am interested

PM me and I will show you what I've got so far. ;)

[DrewM]

ok will do but can't right now.

[finn snor]

Im still looking forward to calendar views :bunny:

Would be cool if it worked on each event and the weekly calendar view *hint hint*
Ill even look into my donation account thinking about you if this can be done :bored:

[DrewM]

the calender views would be tough because the way this is written it just adds oneit doesn't save a date, I mite this more into a "tracker" so that it told the user and the date. then it could allow it.

[finn snor]

any solution would be appriciated :)

[Stop]

Boofo, we still waiting for the add on.;)

[DrewM]

@finn snor I will do this when I have some time.

@Stop Boofo hasn't replied to my last PM so I'm a little unsure.

[Boofo]

I was sure I had replied to it. I will get with you shortly about it. I haven't forgotten.

[DrewM]

I was sure I had replied to it. I will get with you shortly about it. I haven't forgotten.
oh, sorry for making you sound bad.

[oglsmm]

I just get
0, people including you have visted this site.
. It doesn't change or update.

[DrewM]

:) try refreshing the page.

[noj75]

I just get
0, people including you have visted this site.
. It doesn't change or update.

Same here. Any ideas?