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 TheBlackPoet

i almost hate to bother you!!!!!

this is the new error:


Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE userrating (
`voteid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`raterid` int(10) NOT NULL default '0',
`ratername` varchar(50) NOT NULL default '',
`rating` int(10) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`dateline` int(10) NOT NULL default '0',
`ipaddress` varchar(25) NOT NULL default '',
PRIMARY KEY (`voteid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

MySQL Error : Table 'userrating' already exists
Error Number : 1050
Date : Sunday, August 5th 2007 @ 07:12:02 AM
Script : http://www.theblackpoet.com/forum/ad...=productimport
Referrer : http://www.theblackpoet.com/forum/ad...?do=productadd
IP Address : 70.246.27.95
Username : theblackpoet
Classname : vB_Database


when i delete it..., it gives me an error for karma column... but i dont have that table....... and then... my next error is this userrating again... i assume it installed it back....

the karma column is in the user table. Same for the karmatotal column.

[Lea Verou]

Originally Posted by nosherwan9

Hello,
I tried this karma.php file but still same error , here it is,



Thanks

You don't want to prevent any usergroup for participating in the karma? What about guests? Add usergroup 1 to the restricted usergroups list and this will most likely fix it.

[Khalid-B]

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

[lasto]

using the karma.php u added on last page gives this error

MySQL Error : Table 'custom.userrating' doesn't exist
Error Number : 1146
Date : Sunday, August 5th 2007 @ 12:08:43 PM

also trying to uninstall throws up exactly the same error as the post before me.

Afraid this hack does not work or something is badly missing.

[lasto]

also using the new plugin u posted above gives this error

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 71

Database error in vBulletin 3.6.8:

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

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 (1)' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 02:06:03 PM

[lasto]

BRB gonna try this on a fesh installed Board with HTTaccess (so i dont break licence agreement)

[lasto]

fresh install of vbulletin - no hacks installed at all
2 Users - 1 made when installing Vbulletin and another made for test purposes

going to karma.php brings up this error

Warning: Invalid argument supplied for foreach() in /karma.php on line 399

Warning: Invalid argument supplied for foreach() in /karma.php on line 407

Warning: Invalid argument supplied for foreach() in /karma.php on line 415

Warning: Invalid argument supplied for foreach() in /karma.php on line 422

Warning: Invalid argument supplied for foreach() in /karma.php on line 429

Warning: arsort() expects parameter 1 to be array, null given in /karma.php on line 437

Warning: Invalid argument supplied for foreach() in /karma.php on line 439

Warning: asort() expects parameter 1 to be array, null given in /karma.php on line 454

Warning: Invalid argument supplied for foreach() in /karma.php on line 456

Warning: arsort() expects parameter 1 to be array, null given in /karma.php on line 472

Warning: Invalid argument supplied for foreach() in /karma.php on line 474

Warning: array_count_values() [function.array-count-values]: The argument should be an array in /karma.php on line 491

Warning: Wrong parameter count for max() in /karma.php on line 494

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: array_count_values() [function.array-count-values]: The argument should be an array in /karma.php on line 575

Now going to look at member.php throws up another problem

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 71
Invalid SQL:
SELECT karma FROM user WHERE (userid=2 OR userid=1) AND karma=1 AND userid NOT IN () AND usergroupid NOT IN (1,3,4);

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 (1,3,4)' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 02:15:34 PM

So unsure wots going on but it aint working.Its a fresh installed board with only this hack added as a product and the command entered in memberinfo template.

[arco]

I've got the same problems as everyone else. Too bad, seems like it could be a very nice mod.

[ninjashoes]

pretty cool alternative to rep, these things can add alot to a forum

[Lea Verou]

Good morning everyone, just woke up.
I'll look into these errors shortly.

PS: I swear, it worked fine (and still does) in my test board!! , I don't know why it caused you so many errors And I feel so bad for that Is there anyone of those 27 people that clicked install that got it working?