![]() |
Thanks for the donation cynthetiq, its my first donation ever, lol :)
|
How about a function to see which member has received the most karma points in the last month? Either in Calendar month or as in last 30 days.
Another feature that would be nice is member that received most karma points in a certain (sub)forum. That would make it easier to ID potential moderator for a (sub)forum. |
Quote:
|
A bug was found that turned the karma off to most members, instead of only those that hadn't visited the site for X days (if that setting was set to on). You are strongly advised to re-download the zip and replace karma_cron.php.
If anyone was affected by this bug, ask me for information on how to turn it on for the other members. |
How do I turn it on for the other users? This happened to me.
|
Quote:
Code:
UPDATE user SET karma=1 WHERE 1; This will turn it on for ALL users. To turn it off for those who haven't visited for the amount of days specified, run the new cron. Also, please don't PM me for support issues unless I told you so or there is a special reason for that. |
Quote:
I am sure it is because I dont have a hook installed in the right place. What exactly is a "hook" is that like a DB querry? And in order for this to work which ones do I need and EXACTLY where should I put them? Please list? :confused: |
Quote:
If it is, provide me a screenshot of your main karma settings. |
I have that hook in my postbit...not anywhere else though. I found the option in the User Control panel.
http://img337.imageshack.us/img337/4...f6f8a66fo9.png Shot at 2007-08-12 This is my Postbit template Code:
$template_hook[postbit_start] |
karmatest.php give a db error
Invalid SQL: SELECT userrating.voteid as voteid, userrating.userid as userid, userrating.raterid as raterid, userrating.ratername as ratername, userrating.rating as rating, userrating.active as active, userrating.dateline as dateline, userrating.ipaddress as ipaddress FROM vb_userrating AS userrating INNER JOIN vb_user AS user ON ( userrating.raterid = user.userid AND user.karma =1) WHERE userrating.userid = AND user.karma = 1 AND user.usergroupid NOT IN (1,3,4) AND ((1186962797-user.lastactivity)/86400<=30) ORDER BY userrating.rating DESC; 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 'AND user.karma = 1 AND user.usergroupid NOT IN (1,3,4) AND ((1186962797-user' at line 5 Error Number : 1064 |
All times are GMT. The time now is 07:41 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|