Add-On Releases - PM notification when receiving reputation points

SK Reputation Notification v1.1.2

Updated to v1.1.2 - 2008-06-18

Notification system for reputation comments.
This modification sends a private message (PM) to the user whenever someone gives him/her a reputation comment.
User must first enable the function on the User CP => Edit Options page. It's off by default.

Created and tested on vBulletin 3.6.8
This mod uses the template hook - $template_hook[usercp_options_messaging]. Which is new since 3.6.8.
So it won't work in earlier versions without some editing on your own.

Two step installation.
Copy 1 file. Import the product.
See instructions in the attached zip file.

Version history:

• v1.1.2 - 2008-06-18
  Support for option 'Can See Who Left User Ratings'.
  - If user not allowed to see who left a reputation comment the sender of the notification PM will always be the specified user and not the actual user leaving a comment.
  - Also a different message will be used with no name included.
• v1.1.1 - 2008-04-19
  Added admin options so you can specify a specifik user as the sender of the notification PM.
• v1.1.0 - 2007-11-06
  First official release.
• v1.0.0
  First attempt. Not available.

/SK

[skhms]

Originally Posted by viper357

Any chance you could help me in getting this to work on 3.6.5? Please

It should work by editing the template Modify User Option Templates >> modifyoptions

Find:

$customfields[messaging]

Above it add:

$template_hook[usercp_options_messaging]

You must also edit the dependency tag in the product-file "product-sk_repnotif.xml".
Change

minversion="3.6.8"

to

minversion="3.6.5"

or whatever version you want to try. It should work on all 3.6 and probably even 3.5

/SK

[donna8284]

Thanks - worked on 3.6.4!

[GhoHan]

great mod. installed

[DoB Rhapsody]

This doesn't seem to work for me. I'm running 3.6.7 PL1 and seems that it didn't add any SQL tables and there is no indication of any new options. No errors during install.

[skhms]

Originally Posted by DoB Rhapsody

This doesn't seem to work for me. I'm running 3.6.7 PL1 and seems that it didn't add any SQL tables and there is no indication of any new options. No errors during install.

There is no new tables, the only change is an addition to the user table.

If no new option has been added to the User CP => Edit Option page I would guess that the $template_hook[usercp_options_messaging] hasn't been added correctly.
You must do that manually on v3.6.7. See previous post.

/SK

[viper357]

Originally Posted by skhms

If you are willing to do SQL queries you can enter this at the Maintenance > Execute SQL Query Page:

ALTER TABLE user ALTER sk_repnotif_options SET DEFAULT '1'

This will make the option active as default for new users.

To activate it for all current user, use this:

UPDATE user SET sk_repnotif_options = '1'

Don't forget to add in your table prefix as well.

As always, be careful and take backups before you mess with the database.

/SK

This is the first time I will be executing a SQL query, can you tell me where exactly I must add my table prefix in the above code? Thanks.

[skhms]

Originally Posted by viper357

This is the first time I will be executing a SQL query, can you tell me where exactly I must add my table prefix in the above code? Thanks.

Add it before the table name - user

ALTER TABLE table_prefixuser ALTER sk_repnotif_options SET DEFAULT '1'

UPDATE table_prefixuser SET sk_repnotif_options = '1'

/SK

[viper357]

Thanks for the help

[JustAskJulie]

Originally Posted by skhms

Add it before the table name - user

ALTER TABLE table_prefixuser ALTER sk_repnotif_options SET DEFAULT '1'

UPDATE table_prefixuser SET sk_repnotif_options = '1'

/SK

How do I know what my table prefix is?

[skhms]

Originally Posted by JustAskJulie

How do I know what my table prefix is?

Its in your config.php file (includes/config.php).
If you left it empty then you obviously don't need to add anything.

/SK