Improved PM Folderview

TESTED ON 2.3.0 AND FOUND WORKING

What does it do?

You know it happens to me pretty often that my users wonder why they cannot receive any more pm's. the standard question "did you check your sent items folder?" is answered with the standard question "do i have a sent items folder?"...

to avoid that, this hack shows the user on the privatemessage mainpage which folders they have in a list with the ability to add a folder without having to switch to the folders template.

aditionally, i modified the pmgauge enhanced hack by WWW.TOTAL-IMPACT.COM aka princeton a little and included it.

so, its nothing special, but maybe some people like it.
note: im new to this, so the code might be very ugly...

instructions:

1) follow instructions.txt

Credits: The_Sisko, mystics and boofo for finding bugs and helping with the code

Please notice this add-on by matt that allows you to have the amount of messages in each folder displayed next to it. Working on 2.2.9 too.

NOTICE: If you installed the private messages backup hack by Cano2 which is found here, you will have to to change a bit in the instructions.txt:

where it says to find:

PHP Code:

  //get correct folder name
  if ($folderid=="0") { 


you will need to find the SECOND instance as the private message backup hack adds another instance of this code to the file.

NOTICE2: if you installed the PM Quota by Usergroup Hack by g-force2k2 that can be found here then the solution to make both work together is here

please click install if you use it, thank you

kreftt

[kreftt]

could i get the sourcecode for the page the screenshot was made from to kreftt[at]gmx.com please?

[chrisvonc]

Thank you very much. Email sent!

Chris

[ricker]

I didn't see any instructions on what/how to add the privfolder_pmgauge template. The actual percentage is not showing up, nor the bar. We do not have any other pm hacks, so it is not something else interfering. Thanks for the help.

[ricker]

Oops, sorry. Found pmgauge hack info in that thread. We added the template, so that should work. It doesn't. The problem we have is the add folder box is not showing up. I'm thinking it might be a tag issue with the add folder box code, and it's screwing up the pmgauge also. Any ideas?

[kreftt]

yes. tell me please where your site is or send me a screenshot of the pm page plus its sourcecode and the templates in question to kreftt@gmx.com

greetz

kreftt

[ricker]

Hmm, I tried it once more and I think we figured out that Dreamweaver is the cluprit. This hack works beautifully now -- and we won't be editing with Dreamweaver anymore. Thanks for your karma!

[kreftt]

although i always found dreamweaver to be a fantastic tool im happy it worked for you now.

greetz

kreftt

[Aaron1]

Strange bug i found, whenever someone sends you a PM who's on you're ignore list, it adds a message to your Inbox total messages. Although the PM gauge works well though.

Any clues how to solve that?

Cheers!

[Crank]

ok i have read this entire thread and found no solution to my erorr could anyone please help i had tried to add a folder to my PM section and i got the following erorr and now i cant even see my pm's it keeps giving me the erorr.

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT COUNT(*) AS foldermsgtotal FROM privatemessage WHERE userid=1 AND folderid=
mysql error: 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 '' at line 1

mysql error number: 1064

[kreftt]

@Aaron1

you have matt's addon installed which doesnt check for your ignorelist.
you have two queries in your private.php and private2.php.
replace these three as this:

1) this fixes the values for custom folders

PHP Code:

$msginfolder = $DB_site->query_first("SELECT COUNT(*) AS foldermsgtotal FROM privatemessage WHERE userid=$bbuserinfo[userid] AND folderid=$folder[folderid]"); 


with

PHP Code:

$msginfolder = $DB_site->query_first("SELECT COUNT(*) AS foldermsgtotal FROM privatemessage WHERE userid=$bbuserinfo[userid] AND folderid=$folder[folderid] $ignoreusers"); 


2)this fixes the values for the inbox

PHP Code:

$msgin_inbox = $DB_site->query_first("SELECT COUNT(*) AS inbox_msgtotal FROM privatemessage WHERE userid=$bbuserinfo[userid] AND folderid='0' $ignoreusers"); 


that SHOULD be it. if it doesnt work yet, put

PHP Code:

  $ignoreusers="";
  if (trim($bbuserinfo['ignorelist'])!="") {
    $ignoreusers='AND fromuserid<>'.implode(' AND fromuserid<>',explode(' ', trim($bbuserinfo['ignorelist'])));
  } 


in front of these queries.

greetz

kreftt