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

[lasto]

Warning: implode() [function.implode]: Bad arguments. in /karma.php on line 125

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 129

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342

and thats putting a 0 in the main karma setting

Hate to say it but after messing it simply dont work on 3.6.8

also i loaded the new karma.php that u had on the previous page and here is the error i get now

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM userrating WHERE active=1 AND userid NOT IN () AND raterid NOT IN () ORDER BY `dateline` 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 raterid NOT IN () ORDER BY `dateline` DESC' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 12:32:08 AM

finally look what happens if i try to uninstall the product from the admincp

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 @ 12:39:04 AM

[Lea Verou]

Damn.
I'll try to fix this shortly.
For the time, disable the product.

[Lea Verou]

lasto, do you have any banned users? (not karma-banned, generally banned)

[Lea Verou]

Also, try putting a 0,0 instead of a 0 in that setting and tell me what happened

[TheBlackPoet]

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0', ADD userratingperm INT(10) NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'userratingday'
Error Number : 1060
Date : Sunday, August 5th 2007 @ 01:47:30 AM
Script : http://www.theblackpoet.com/xxxxxx/a...=productimport
Referrer : http://www.theblackpoet.com/xxxxx/ad...?do=productadd
IP Address : xxxxxxx
Username : xxxxxx
Classname : vB_Database


this is my error.. i go to import... and get this.....

[ged]

And I didn't have any of my templates changed.

[Lea Verou]

Originally Posted by TheBlackPoet

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0', ADD userratingperm INT(10) NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'userratingday'
Error Number : 1060
Date : Sunday, August 5th 2007 @ 01:47:30 AM
Script : http://www.theblackpoet.com/xxxxxx/a...=productimport
Referrer : http://www.theblackpoet.com/xxxxx/ad...?do=productadd
IP Address : xxxxxxx
Username : xxxxxx
Classname : vB_Database


this is my error.. i go to import... and get this.....

Which hacks that involve DB changes do you have? It's quite weird to have this.
Anyway, that column is not needed in v2, its from the install code of v1. It then gets removed with the install code of v2, so perhaps I should remove it completely.

[Lea Verou]

Originally Posted by ged

And I didn't have any of my templates changed.

Huh? What do you mean?

PS: Nice avatar

[TheBlackPoet]

Originally Posted by Michelle

Which hacks that involve DB changes do you have? It's quite weird to have this.
Anyway, that column is not needed in v2, its from the install code of v1. It then gets removed with the install code of v2, so perhaps I should remove it completely.

i was jacking around with that commune hack and broke my dbase/site.... im reinstalling all my hacks now... after having to uninstall them all one by one...

i havent really been having any dbase issues since i took all my hacks off and ran tools.php...

i dont know why this one would give me any trouble

[Lea Verou]

Originally Posted by TheBlackPoet

i was jacking around with that commune hack and broke my dbase/site.... im reinstalling all my hacks now... after having to uninstall them all one by one...

i havent really been having any dbase issues since i took all my hacks off and ran tools.php...

i dont know why this one would give me any trouble

Since you are a coder, you can edit the product xml and remove any queries about that column (userratingday) in the install/uninstall code, its not needed at all, it gets added and then removed during install, in order to have consistency with users having v1 (v1 needed that column).
It's weird though that you have such a column in your db..
If you can't do the above, tell me to upload a product xml without it.