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]

lasto (and others with problems with karma.php) try this karma.php and tell me what happened.

[TheBlackPoet]

i took out the references.. and still had an error.. i could have done something wrong... and at this point i'm to chicken to risk losing the dbase again...... so, if you edited the xml, that would be fine with me... and appreciated.....

[Lea Verou]

Originally Posted by nosherwan9

i have installed some templete mods and some others as like ,, dream,s chatbox , colour legend , paypal, Ajax Reg , Cyb - Advanced Forum Statistics , Global Announcement , Latest 10 PM Admin Index , Referrer Statistics , ibProArcade for vBulletin and Global Announcement.
Thanks

Black poet, which of those do you have installed? (since you have the same bug)

[Lea Verou]

Originally Posted by TheBlackPoet

i took out the references.. and still had an error.. i could have done something wrong... and at this point i'm to chicken to risk losing the dbase again...... so, if you edited the xml, that would be fine with me... and appreciated.....

Ok, I will shortly
In the meantime, can you reply to my above question, so I can determine if there are any inconsistencies with a specific hack?

[TheBlackPoet]

Cyb Donate
Ajax Reg
Cyb - Advanced Forum Statistics,
ibProArcade

i have these hacks installed

[Lea Verou]

TheBlackPoet and anyone else with his problem, try the attached product instead of the original.

PS: Sorry for the delay, I had a problem on my forum with vba cmps 3.0 (btw DON'T upgrade to it its full of bugs better wait till its gold)

[Lea Verou]

Attachment in the previous post updated (I had forgotten something).
Black Poet, if you have the userrating table in your database,you should probably drop it, otherwise the install will give you a db error. Same goes with columns 'karma' and 'karmatotal' in user table if you have them.

[Lea Verou]

Black poet can you please tell me what happened because in less than half an hour I will be afk for a lot of hours so I will not be able to assist you?

[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....

[Khalid-B]

Originally Posted by Michelle

lasto (and others with problems with karma.php) try this karma.php and tell me what happened.

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

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 (7,8,16,38,59,64,323,340,372,559,576,738,999,1000, 1002,1163,1322,1701,2086,2120,2428,2509,2787,2953, 2971,3409,3660,4012,4049,4132,4970,5331) AND usergroupid NOT IN ();

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 ')' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 08:46:00 AM
Script : http://www.xxxxx.com/Forums/member.p...lastposter&f=x
Referrer : http://www.xxxxx.com/Forums/index.php
IP Address : xyz
Username : abc
Classname : vb_database

Thanks