PM Status hack (pm folders on forumhome)

First of all, this is a modified version of the PM Gauge hack by Bald_Bouncer. Although i didn't use much of his code i suppose he deserve some credit
I tested this on 2.2.9 but it should work on earlier versions as well.
If you install this remember to click Install

What does this hack do?
This hack displays how many percent of your pm quota you use as well as displaying a "PM Status" which starts as Low , then changes to Normal then Critical and finally it changes to full when you're pm quota reaches its limit.
when the status goes "critical" the pm bar starts to blink

Version 1.1
Right under the pm status you'll find links to all your pm folders. Users wont forget to delete the pms in their "sent items" folder anymore, for sure.

Version 1.2
same as v1.1 but with fewer queries

v1 screenshots
v1.1 screenshot


I know this isn't much of a hack, but my members seem to like it anyway.. this is also my first hack. I guess it's a start, right?

UPGRADING:
v1.1: https://vborg.vbsupport.ru/attachmen...&postid=345294
v1.2: https://vborg.vbsupport.ru/attachmen...&postid=390598

[The_Wanderer]

Today at 07:22 PM Oblivion Knight said this in Post #31
Use v1.. It's only adding one query.
That's exactly what I thought about v1.1

Regards,
Oblivion Knight

yup.. that's why i let the v1 install file stay in the zip

feel free to edit v1.1 to use less queries though...

[The_Wanderer]

ok i updated it.. v1.2 features the same as v1.1 but it uses less queries

definetly worth a try, methinks

this was tested on my testforum and my forum, it should work

here's the upgrade file (it's also included in the zip on the first page)

[Alien]

What's "less" queries?

How many in total will it add to forumhome exactly?

-Jason

[Alien]

I believe v1 added one query, so this will add only 1 query maybe to the forumhome no matter how many folders a user has?

[drumsy]

My "Your Inbox is 8% full" went to 0% after I installed the upgrade to 1.2

[The_Wanderer]

uhm.. i think it adds 1 lol... i'll test it tomorrow, k?

EDIT: yeah it adds only 1 query nomatter how many folders you have

Today at 11:06 PM drumsy said this in Post #35
My "Your Inbox is 8% full" went to 0% after I installed the upgrade to 1.2

Sounds weird.. i'll try re-installing the hack tomorrow.. just to make sure everything works

[Alien]

Sounds great, I'll give it a test!

(I'll just wait a day in case there is a bug confirmed from above) lol

-Jason

[The_Wanderer]

i can now confirm that it works.. i tried re-installing it using the v1.2 install file, and everything worked fine..

i've changed nothing in the part of the code, that tells you how many % you've used.. :\
oh and it uses a total of 2 queries apparently.. I can't seem to figure a way for it to use only 1. Not yet at least
but still 2 is better than 4

[The_Wanderer]

for those of you who installed v1.2, you have to find and delete $ignoreusers near ORDER BY pmfolderid ASC

i'll update the install files included in the zip on the first page

[The General]

Great hack! Cheers!