e-steki Karma BETA

New version for 3.6, with a lot more features, bugfixes and better coding!!

-------------------------------------------------------------------------------
Beware that this is still a BETA. This means, it may have bugs. If you want to help with the beta-testing phase, please mention what happened with this hack (if it works or not, if you encountered any bugs, if everything is ok etc) as detailed as possible.

I used quite a lot code from User Rating 1.0 by tnguy3n for this modification. Then I changed it a lot to fit my needs, and I think it's so changed that it could be released as a separate modification. I also got his permission for this

What does e-steki Karma have that User Rating 1.0 doesn't?
1. When a user votes someone for a second (or third, fourth etc) time, the new vote replaces the old instead of being added. I felt it was more fair this way.
2. There is a complete statistics page, with 7 tables that display various statistics
3. Ratings are from -5 to 5 instead of 1-10 and they are represented by images
4. The Karma of each user displays in the postbit (unless he has it turned off)
5. 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.
6. Since there are no comments, there is no possibility that the user gets a "you didn't complete all fields" error. In fact, even the phrase for it is removed.
7. The table is not placed where the hack author wants (above the footer in UR1) but where YOU want it (by inserting a small comment in the place that you want it in MEMBERINFO). This, however, means one more template change is involved.
8. There is no field that you should add via the userfield manager. This caused bugs in UR1 as you had to run a query to set all the checkboxes to 1 and new registrants had their karma turned off by default.
9. IP in who rated
10. Although they can't see who voted, they can see if they have rated a user and with what (see screenshot).


Why somebody may prefer User Rating 1.0 over e-steki Karma?
I have removed some of the user rating 1.0 features that I didn't need. Some of you may need them though, so pay a visit to User Rating's thread as well.
1. There are no comments in this hack. Nowhere. I've removed anything that has to do with comments.
2. There is no "anonymous voting". In my site, only admins see who has voted, so it's useless to us.
3. No template changes in UR1.
4. A little bit less queries and plugins (since there are less abilites in certain things) in UR1.
5. The "can rate himself" is off by default.
6. Only admins can see who voted. This is planned to be a usergroup permission in the future though.

Misc features
1. WOL location for stats
2. Fully phrased
3. Usergroup permissions

Why is it a beta?
1. Because the end product is the biggest modification I've worked on and there is a high chance I missed something
2. The permission for "Can view Stats" is not working sometimes.
3. I'm not sure how if the install code is going to give an error on an existing installation of e-steki Karma or UR1.

Planned features
1. Of course, bugfixes
2. Usergroup permission for who can see who voted. (currently only admins can see that.)
3. The stats line in memberinfo wont appear if the user does not have permission to view the stats.
4. Ignore specific usergroups from the karma (such as banned)
5. Suggest your own, as long as they keep the system as fair as possible. My main concern is that the system is fair and democratic, and this is why I made most of the changes.

Don't forget to click INSTALL if you use this or you will be damned to hell

[Vizionz]

Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now

[tnguy3n]

Originally Posted by Vizionz

Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now

It means you don't have karma column in user table. Re-import the product xml and choose Overwrite option to insert necesary data.

[Vizionz]

same thing after importing it again with overwrite

[Vizionz]

i cant even uninstall it now either

Invalid SQL:
ALTER TABLE usergroup DROP userratingday, DROP userratingperm;

MySQL Error : Can't DROP 'userratingday'. Check that column/key exists

then if i overwrite it again it says installed same errors try to uninstall and go through the same thing ovr and over

[Lea Verou]

Originally Posted by vissa

THANK YOU FOR YOUR BRILLIANT WORK!

Great mod! Will install once it gets ironed out a bit (or perhaps install on one of my smaller forums first). Ranked it a 5 * for now to show support.

You could install it in your test forum so that there are more beta-testers

IDEA 1: I've modified some ratings systems (like for photos) so that, for example, if there are more than 3 votes the lowest scored vote gets dropped (or the highest, etc). Or the lowest score gets a boost of one point. So if you have a user with 25 votes and 4.99 score (because of one bad vote) they rank higher than a user with 2 votes at 5.0. This could be customizable somehow.

Very nice, but can you think of an algorithm for that?

IDEA 2: The effects/weight of a karma vote could be modified by the voting member's stats in some way (like number of posts, registration date, their karma, etc). This would be a little more like the rep system, but not really because it is always an average with one vote per person. This would be a big change but would be a lot more accurate of "true karma."

Nah, I don't agree with this. It's not fair. For instance, how would you feel if in the elections your vote counted less than the president's?

QUICK QUESTION: Are the stats only visible to admins? If they are visible to everyone, it would be nice to be able to turn some sections on/off (though I probably could do this with template changes if you used templates for the display of stats).

There are usergroup permissions for the stats. However strangely enough they don't work all the time :ermm: After some tries though the permissions gets stored at last (one of the known issues)

[tnguy3n]

Originally Posted by Vizionz

i cant even uninstall it now either

Invalid SQL:
ALTER TABLE usergroup DROP userratingday, DROP userratingperm;

MySQL Error : Can't DROP 'userratingday'. Check that column/key exists

then if i overwrite it again it says installed same errors try to uninstall and go through the same thing ovr and over

Go to Maintenance -> Execute SQL Query, then run following queries (1 query a time).

ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0'

ALTER TABLE usergroup ADD userratingperm INT(10) NOT NULL DEFAULT '0'

CREATE TABLE IF NOT EXISTS userrating (voteid) int(10) NOT NULL DEFAULT '0'

ALTER TABLE user ADD karma SMALLINT(1) NOT NULL DEFAULT '1'

Then uninstall the product.

[Lea Verou]

Originally Posted by MissKalunji

Next question i dont want it to show has average 5 i want it show example

average 5 = 5 stars
average 4 = 4 stars etc

how can i do that?

In the postbit and memberinfo:
With conditionals that check $averating. But you will lose accuracy, as they will only show whole numbers.
You can put the actual rating as the alt text though
Also you can make half images, but I don't want to think about how complicated those conditionals will be :ermm:

[Lea Verou]

Originally Posted by tnguy3n

Go to Maintenance -> Execute SQL Query, then run following queries (1 query a time).
...
Then uninstall the product.

Thanks a lot for helping with the support
But why wouldn't those fields be installed? The install code is supposed to install those too

[Lea Verou]

Originally Posted by Vizionz

Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now

What exact error message do you get?
If you get "column karma does not exist" or something like that, your problem is what tnguy3n says.

[MissKalunji]

Originally Posted by Michelle

In the postbit and memberinfo:
With conditionals that check $averating. But you will lose accuracy, as they will only show whole numbers.
You can put the actual rating as the alt text though
Also you can make half images, but I don't want to think about how complicated those conditionals will be :ermm:

lol ok i guess im stuck to be using the numbers til i figure it out

thanks!