Total vBShout Shouts on Postbits and Member's Profile

[derekivey]

Total vBShout Shouts on Postbits and Member's Profile
Developers: derekivey (https://vborg.vbsupport.ru/member.php?u=81169)
Version: 1.0.0
vBulletin Version: 3.5.2
File Edits: 0
Template Edits: 3
New Phrases: 1 (1 Global Phrase)
Uses Plugins: Yes!
Difficulty: Easy

Description: This hack shows the total number of shouts a user has on the postbit templates, and the user's profile. This addon requires Zero Tolerance's (https://vborg.vbsupport.ru/member.php?u=48782) [AJAX] vBShout hack. (https://vborg.vbsupport.ru/showthread.php?t=93097)

*** Special Thanks to Zero Tolerance for making this great Shoutbox hack! ***

I have added screen shots of this hack in action below.

Please click https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=102920) If you installed this hack.

Thanks!

[Daniel]

Great modification, nicely done.

/me clicks install

[Tidy]

Installed And Working Perfectly on 3.5.2 Great Hack

/me Clicks Install

[The Chief]

Installed and works great!! Someone had to think about it, and you did, great job!!

*Clicks install

[Cyricx]

Hmm, a script to update someones shout posts would be awesome. That like checked the table and then updated the userfield.

It would only be needed for the first install, but would be very sweet to get things going.

[derekivey]

You would have to rewrite Zero Tolerence's hack a lot to do that. The number of shouts isn't stored in any tables. He just uses mysql's num_rows function I believe (which is what I used also for my addon I made).

[derekivey]

Installed And Working Perfectly on 3.5.2 Great Hack

* Tidy Clicks Install

Doesn't look like you clicked install :p

[Cyricx]

Not really, you'd just need a script to query the shouts by a userid, then update the shout field with the number of rows per userid.

Run the script once to "populate" it, and then from there on, your code will keep it going :)

*EDIT*

I think I found a way, found this post over on photopost

http://www.photopost.com/forum/showpost.php?p=1133368&postcount=46

With a script to do similiar for counting the number of photos a person has uploaded.

[Cyricx]

Ooohh I see how your doing it.

Okay, your doing it to count the rows each time. But then if you prune the shoutbox periodically to keep the space down, users shout count will go down too.. Hmm.

I'd rather fiddle with the code that adds to the post count and and have it add to a field called "shouts" in the user table. Then if you pruned it wouldn't affect their count.

[Snake]

Thanks but can you do for FORUMHOME page, too? Yes, for the board stats, that's what I mean.

[Mathiau]

^ to have something like "total shouts" ?

perhaps like

Total shouts today
this week
this year
?
Most shouts ever by X person

[YOimYO]

great addition ty :D

[Snake]

Thanks but can you do for FORUMHOME page, too? Yes, for the board stats, that's what I mean.

Well?

[derekivey]

Sorry, I don't quite understand what you mean. You want the number of shouts to be added to the box that shows the number of users, posts, threads etc?

[forumsoup.com]

Does this work with 3.5.3?

[derekivey]

Yes it does.

[Oddjob]

this works on 3.5.4 in case anyone wants to know.

[Baudman]

great addon thanks. :)

[Snake]

Thanks for the hack. I have it installed on my forums. :)

www.bonethugsforums.com

[Snake]

derek, is it possible to add the "X shouts per day" and "Last shout" features too, please? :) I'd really appreciate that.

[derekivey]

Sure. I will look into adding those. Also what do you mean by Last shout features?

[Snake]

Well mainly it should display the latest shout that user has made and that it links to it, just like the "Last post" on my forums.

http://www.bonethugsforums.com/memberslist/lil_ripsta.html

[Neo_Angelo]

Erm it replaces my Post with Shouts i don't get my post count showing, and i followed it correctly.

EDIT: nevermind i got it, *clicks install* awsome job ^_^

[PennylessZ28]

How many queries does this add?

[derekivey]

It adds one to showthread.php and one to member.php. I am currently looking into ways to make it add none.

[derekivey]

Actually I just noticed its one query per post on showthread.php. I am looking into making it only add no queries right now. I'll see what I can come up with and release a new version soon.

Derek

EDIT: Nevermind, I don't think it's possible to do that. I will leave it like it is for now, maybe I can figure it out later. They are really small queries so it shouldn't have much of an effect on performance...

[PennylessZ28]

Actually I just noticed its one query per post on showthread.php. I am looking into making it only add no queries right now. I'll see what I can come up with and release a new version soon.

Derek

EDIT: Nevermind, I don't think it's possible to do that. I will leave it like it is for now, maybe I can figure it out later. They are really small queries so it shouldn't have much of an effect on performance...

One query isn't bad, but one query per post could be an issue.

[derekivey]

Yup. I am thinking about adding a field to the user table called shouts and when you upgrade the hack maybe having it see how many shouts each user has and put that number in the newly created field, and edit the vBshout hack to increase it by one every time the user posts. Then it would add 0 queries to those pages. I'm still looking into this, it should work though.

[Polo]

too many queries for me lol, thanks for the hack, I'm pretty sure many will find it useful :)

[derekivey]

Once I get some time I'm going to find a way to get rid of all the queries. I will probably just add a column to the user table and have it update when they make a shout. I've just been so busy lately.

Derek

[Muellmann]

Works with 3.60 gold and with the new vbshout from vbhackers. :) thx!

[VTXCafe.com]

Great, installed.

I have a question, my site has the info in small boxes, I have the post working but can't get the shouts to work. Here is how the post are coded:

<if condition="$post['posts']"><div class="userinfo"><b>$vbphrase[posts]:</b> $post[posts]</div></if>

How should this be structured to show the shouts, I have tried but nothing shows up?

[derekivey]

Try adding this after it...

<div class="userinfo"><b>$vbphrase[vbshout_shouts]:</b> $totalshouts</div>

Derek

[FreshFroot]

Works with 3.60 gold and with the new vbshout from vbhackers. :) thx!
I'll try it out on 3.6.5 and hope it works :)

[iorkara]

Nice Thanks It also works on v3.6.5

[C2Systems]

will this work with the new Inferno vBShout?

I upgraded from VBShout 2.1 but its still like 2 separate shoutboxes and doesn't record the new shouts to the counter ....

[turbo.:R]

doesnt work in 3.7

[johnrizz]

Update would be great for 3.7! the effect it has on my forum is that it gives me an error when trying too view members profiles..... This is just an update to let ppl know if they wind up with the same error....

Fatal error: Call to a member function on a non-object in /home/XXXXXXXXXXXX/public_html/includes/functions.php(1385) : eval()'d code on line 13

[jilly]

it's not working for me on 3.7 either.