Profile Enhancements - e-steki Karma version 2.2

e-steki Karma v2

I'm really excited to present the new, better from all aspects, version of my previous hack (the one that was in beta stage). I've spent numerous hours to make this, its my greatest modification so far, so I hope you like it!

What is it?
e-steki Karma is a powerful system to let users rate each other with a rating from -5 to +5. Each user's karma is a number, which is the average of all votes they have received. Refer to the Features section for more information.

What's the use?

1. Less flames. Users vent their spleens on rating the one that got on their nerves with a -5 and that's it.
2. Easier spotting of bad members/trolls by new users. This way, new users will not take seriously the bad members' posts and they won't get a bad idea about your forum, they will just think "oh nobody likes that guy anyway, he's not representative of the forum".
3. Users try to have a good behaviour because they know that otherwise their karma will decrease.
4. On a big board, it makes it easier for you to spot members that would perhaps make a good moderator (if they have a high karma value) or members that may need to get banned (if they have a very low karma value). You will also be able to judge how a ban will affect your other users, according to how much they like the soon-to-be-banned user (which is reflected in his karma value).
   

Features

The features in bold were added in the second version. Features in bold italics were enriched in version 2 but existed in version 1 partially.

Admin/Mod Features

1. Now compatible with vBulletin 3.6.8 (link to e-steki Karma 1.0 for 3.5.x).
2. Customizable via a lot of settings.
3. Much better and more safe coding than the previous version. Most of the code has been rewritten from scratch.
4. Great power about who will use the system, via the permission settings.
5. Maintenance section
6. Easier installation than version 1 (Only one template edit (placement of a small comment), the others that version 1 had are now performed via template hooks).
7. Fully phrased (exept for the AdminCP Maintenance section)
8. Users with karma administrative priviledges can see for every user who they rated and by whom they have been rated and remove any vote they wish (useful for karma flooding that some users perform to be in the stats).
9. Most of the bugs in the previous version are now fixed with the maintenance section addition.
10. The bug with the date of the last vote in the profile is now fixed.
11. Displaying the karma in the postbit is now done with no queries.
12. Users with karma administrative priviledges can see the IP of the rater in each vote
13. A nice, usable and extensive html manual instead of an ugly readme.txt ;-)

End user Features

1. Users that have the Karma turned off don't count at all for the system. their votes don't count in anything, and the votes others gave them before they turned it off also don't count at all. Those users also, can't see anything that has to do with the karma system, anywhere. It's like the karma does not exist for them and they don't exist for the karma. However, if they switch it on again, nothing is lost and they may continue from the point where they deactivated it.
2. Rating is now performed by clicking on an image, no form submitting required (saves one click)
3. There is a complete statistics page, with 7 tables that display various statistics.
4. The Karma of each user displays in the postbit (unless he has opted out of the Karma, is not permitted to use it, or the admin has turned off this feature) and users can rate him from there
   
5. In each member's profile they can see if they have previously rated them and what rating they gave.
6. They can view all the votes they have given in a separate page and remove some of them if they wish (or go to the member's profile and change them). Votes that are not active at the time are marked with an admin-controlled formatting. He can also sort the votes by date or rating (default sorting is controlled by the admin). In the same page, users with karma administrative priviledges can also view who rated each user (fully, with sorting, formatting and vote removal).
7. Controversy feature, via an admin customizable algorithm. Controversy for each user is displayed in their profile, as well as in the stats and is color-coded as well as descriptive.
8. Each user can view the percentages of the votes he (or every user, if set so by the admin) has received in a nice graph by clicking in the controversy value.

Don't forget to Mark as INSTALLED!
Important: Supported for only a few days after each release.
Installation/Upgrade instructions included in the zip.

Changelog
2.2.1: Important bugfixes
2.2: I don't remember as apparently, I forgot to add it to the changelog initially
2.1: fixed bugs, cached templates and added the feature of a popup menu rating form in the postbit.
2.0: Initial release

[Lea Verou]

Originally Posted by nosherwan9

Hello,
I am trying to uninstall but cant , getting this error now .

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP karmatotal;

MySQL Error : Can't DROP 'karmatotal'; check that column/key exists
Error Number : 1091
Date : Sunday, August 5th 2007 @ 10:15:29 AM
Script : http://www.domine.com/Forums/admincp...do=productkill
Referrer : http://www.domine.com/Forums/admincp...=userrating&s=
IP Address : xyz
Username : user
Classname : vb_database

Please helo.
How can uninstall ??
Thanks

Was it the first time that you tried to uninstall that you got that error?

[Lea Verou]

Added "is in beta stage" till the issues get resolved
And they WILL be resolved, this is a promise.

[TheBlackPoet]

a woman on a mission... gotta love it!!

[0tolerance]

I will install this on my Dev board and tell you of any errors i run into along the way, i think this is a massively awesome asset.. it will keep my users from ranting at each other on the forum and making each other look like fools

[Lea Verou]

These problems were caused because I was working on a backup of my actual board, so it had over 2000 members, a lot banned etc. I hadn't tested on a smaller board, and that's what caused most problems, for instance I hadn't taken into account that there might be no banned users, I took for granted that some existed.
lasto provided me access to his test forum, so I performed some tests and changes to my code and the issues seem to be resolved. I'm now going to cache some templates I had forgotten to cache, transfer the plugin changes to my product and then I will update the zip on the first post

You will be informed when the zip is updated with a new post.

[Lea Verou]

Zip updated.
Please tell me if it works so that I can send an update email.

[high]* Lea Verou prays it works (atheists are not supposed to pray, so you can understand how much anxiety I have atm )[/high]

[cynthetiq]

thanks for the update. I just installed it.

I don't get that error that everyone else has any longer, but now get this one:

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 201
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT karma FROM vb_user WHERE (userid=1 OR userid=1) AND karma=1 AND userid NOT IN () AND usergroupid NOT IN (0);

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 usergroupid NOT IN (0)' at line 1
Error Number : 1064
Date         : Monday, August 6th 2007 @ 03:25:31 AM
Script       : http://myforum.com/forum/member.php?u=1
Referrer     : 
IP Address   : 
Username     : Iorek
Classname    : vB_Database

[Lea Verou]

WTF? I thought I had fixed that! I'll have a look now :S

[Lea Verou]

Try this product file instead... (although I'm not so sure it will be fixed, I found a small thing I missed that could be causing that)
Do you get any errors in karma.php?
Do you have any banned users?
Any karma banned users?
Which are the restricted usergroups? The 0 I saw in the query? Guests are usergroup 1 btw, not 0.

[Khalid-B]

Originally Posted by Michelle

Was it the first time that you tried to uninstall that you got that error?

Hello,
Yes this is first time iam uninstalling but cannt.
I installed but its not work got DB error as i told you before so decided to uninstall ang again DB error as i told you .
Please help me thanks