View Full Version : Forum home Counter
==========================
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
and delete it!
##############################
If you are getting errors about the my SQL table not working run this query:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
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.
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.
Yea I will update the mod.
Thanks! :-)
bonjurkes
04 Apr 2006, 22:20
any screen shot?
Ahh will add and Find a demo here:
http://www.sim2world.com/forum/
bonjurkes
04 Apr 2006, 22:40
You are the 29 user to vist the site.
Maybe some better english huh? :)
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
is it counts total visitors or unique ones?
You are the 29 user to vist the site.
Maybe some better english huh? :)
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
is it counts total visitors or unique ones?
yea that mite help :)
Total guests and users.
Borgs8472
04 Apr 2006, 23:29
Does this count from when you install it or from the very beginning?
Devil Woman
04 Apr 2006, 23:45
I recieved an sql error when I uploaded the product
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?
This error:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
I would try re-downloading the zip and then re-uploading the product I thought I had fixed prefixs.
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.
finn snor
05 Apr 2006, 21:40
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?
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
were cool..
I am using this one found here as it works real well.
http://www.vbulletin.org/forum/showthread.php?t=102363&highlight=%2F%2Fmodified+by+Feckie+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?
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Worked well m8, thanks for your help :)
try this:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
steadicamop
06 Apr 2006, 22:23
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.. :)
steadicamop
07 Apr 2006, 09:26
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 ;)
steadicamop
07 Apr 2006, 13:33
Yup no probs now ... just changed the phrase to something different :)
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
07 Apr 2006, 21:11
nope, cant geteither version to work....no table is installed, and the query posted here doesnt work....gettin syntax errors...
steadicamop
08 Apr 2006, 10:16
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.
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
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 ;)
csidlernet
21 Apr 2006, 12:16
/me thanks you for this hack
/me thanks you for this hack
well thanks for the install
The Fathom
28 Apr 2006, 12:23
I do not have a error but it is saying You are the . visitor of my site. Just a dot nothing more.
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
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
How many queries does this add? At least 2? ;)
How many queries does this add? At least 2? ;)
yep two
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. ;)
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
UPDATE: 1.0.3; Changed numbers from 1000 to 1,000
I am interested
PM me and I will show you what I've got so far. ;)
ok will do but can't right now.
finn snor
21 May 2006, 20:17
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:
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
21 May 2006, 21:44
any solution would be appriciated :)
Boofo, we still waiting for the add on.;)
@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.
I was sure I had replied to it. I will get with you shortly about it. I haven't forgotten.
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.
I just get
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
. It doesn't change or update.
:) try refreshing the page.
I just get
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
. It doesn't change or update.
Same here. Any ideas?
vBulletin® v3.6.12, Copyright ©2000-2012, Jelsoft Enterprises Ltd.