photo total on VB index page

[cognaccola]

Hi,

I want to have a $totalphotos add to the bottom of the vbulletin index page
where it says
Threads: 123467, Posts: 500, Members: 94049, photos:$totalphotos

How do I do this?

I've been looking for it on photopost forums, photodev, vbulletin.org nowhere to find this.

Vbulletin.org has some kind of script that adds lots of stats of the forum itself but nothing of photopost.

Thanks for helping out

[Chuck S]

you would need to add a query in the vb index to grab the totalphotos and define it

[cognaccola]

How would this look like?

[Chuck S]

Open up your vb files or photopost files to see how a mysql query is structured

You can ask hacking questions at http://www.photopostdev.com

[cognaccola]

Ok and watch it sit for let's say 1 year?

As I've told i've been looking on dev, vbulletin.org and this forum, and the ones the ones close to what I want dated somewhere back jan 2004 and were still unanswered.

Some effort on your side would be very much appreciated as always....

[Chuck S]

Here is the forum guidelines for our How Do I forum

http://www.photopost.com/members/for...d.php?t=111057

As stated we do not answer hacking questions. That is one thing I do strictly adhere to. We officially as a company do not support hacking

I gave you a very big hint above and thats about the extent of my help when someone asks how to modify the code.

[cognaccola]

That's not hacking that's improving...lol

[cognaccola]

But I could ask a general php mysql question to a connaiseur like you right?

Well let's assume we have wanted to bring out a number on a php page from a database table id count? how would you approach it?

[cognaccola]

adding following line to the inc_features.php (must be used ofcourse free included as of PP 4.86 )

$photoquery = "SELECT COUNT(id) FROM {$pp_db_prefix}photos";
$totalphotos = mysql_query($photoquery);

Gave me something like this Photos: Resource id #19

[cognaccola]

found it

Posted solution over here
http://www.photopostdev.com/showthre...=4905#post4905

[Michael P]

The last few weeks have been unusually busy for us - a huge influx of new customers, several new updates and a new BETA - while it doesn't excuse any shortness on our part, ir should explain why we are trying to stay focused on those customers who have problems that need our attention.

PhotoPostDev.Com is a forum that I haven't really figured out what to do with yet; I didn't want an "Ask Mike" forum like we tried before, but the level of activity seems to be largely by those who need help - not from those offering to help. Maybe that will change with time, but seems like its better to have it than not right now.

Your contribution, and others, can make it a useful resource and I hope more people will get involved on the development side.

[cognaccola]

Originally Posted by cognaccola

found it

Posted solution over here
http://www.photopostdev.com/showthre...=4905#post4905

Hello Michael,

Since this was a neat hack (showed number of views and pics on a vbulletin index page) is it possible to get this one somewhere on this forum?

Thanks