Pimp the karma Plugin with shiny AJAX

pixelartist · Post by **pixelartist** » Sun Dec 10, 2006 7:08 pm

Hello,

i was going to pimp the karma plugin for different reasons, main reason .. to make it more attractiv for users to vote and get a better overview. So i finally got a nice AJAX Snippet of a voting System from MatsugaDesign (http://www.masugadesign.com/the-lab/scr ... ating-bar/).
I really like it and was goin to implement the code into serendipity. With this script it is just necessary to update the ID for each article in the database.
Garvin already did this with the karma plugin .. is there any information/doc about it? It could not be very difficult to merge these two scripts into one (already done from b2evolution - (http://manual.b2evolution.net/Plugins/starrating_plugin)! And if Garvin read this .. is there a chance to "pimp" the karma script in stead of developing a second nearly equal one?
Perhaps a button "Activate Ajax" or something would do it

P.S. For the ones who wont get the code and do it yourself ... here is an example - TestLink

carl_galloway · Post by **carl_galloway** » Mon Dec 11, 2006 6:07 am

If you manage to get this working, and if you read my request from last month where I asked for something similar you would be making a lot of people very happy. You could be in the running for some donations, but be sure to reply to the other thread as well so everyone knows what you've done.

Really looking forward to reading about your success with this. BTW, Garvin is on vacation at the moment so you might not get a reply from him for a few days.

pixelartist · Post by **pixelartist** » Mon Dec 11, 2006 11:06 am

and if you read my request from last month

That was the thread i was remembering as i tried to get through the code of the karma

Garvin did a hell of a job with this karma thing, it would be a lot easier if he just tuned his skript, instead of reinventing the whole thing again.
The script you can see at the example already do recognize different IPs and put them into the SQl Database, and already is able to run in serendipity with just a few modifications of the template and database.
I also sure i would be able to merge the karma Plugin and this one ... you just need to get the part of getting an unique ID for an article and create a new enty in the database .. also already done by Garvin .. but he is a pro and i am not

.
No need for an additional sql table or two very similar mods

Post by **garvinhicking** » Mon Dec 11, 2006 11:32 am

Hi!

Thanks for delving into code examples here.

Sadly my motivation for a karma-rating plugin is VERY VERY low. I am using it on my personal homepage and have found out that it's virtually useless and people just use it to degrade articles. So I currently have no belief that this plugin is helpful at all, which keeps me from working on nice and shiny Ajax approaches....

BUT this doesn't mean I wouldn't appreciate if someone took a stab at it. It's just that I see my free time currently better fit on other s9y tasks than this one. Hope this can be understood.

Maybe you, pixelartist, would want to have a go at it? The karma plugin might look obfuscated at first, but in reality it isn't.

I would of course answer to all questions you might face along the way.

Best regards,
Garvin

Post by **mattsches** » Mon Dec 11, 2006 2:49 pm

I'd also like to see the AJAX features built into the the pollbox plugin. Though I've never used this particular plugin, I'm thinking about a couple of uses of a AJAX-driven poll right now. Shouldn't be too hard, right? If anyone looks into this, please let me/us know.

pixelartist · Post by **pixelartist** » Mon Dec 11, 2006 7:23 pm

Sadly my motivation for a karma-rating plugin is VERY VERY low.

The karma plugin might look obfuscated at first, but in reality it isn't.

Hah .. got ya

. My problem is that alle my "skills" are self-educated - so i will try .. but i will need help. I think its just the ID we need to be generated .. so what about this?

Code: Select all


                    if (isset($serendipity['GET']['id'])) {
                        $entryid = (int)serendipity_db_escape_string($serendipity['GET']['id']);
                    } elseif (preg_match(PAT_COMMENTSUB, $_SERVER['REQUEST_URI'], $matches)) {
                        $entryid = (int)$matches[1];
                    } else {
                        $entryid = false;
                    }

                    if ($entryid && empty($serendipity['GET']['adminAction'])) {
                        $track_clicks  = serendipity_db_bool($this->get_config('visits_active', true));
                        if ($track_clicks) {
                            $sql = serendipity_db_query('UPDATE ' . $serendipity['dbPrefix'] . 'karma SET visits = visits + 1 WHERE entryid = ' . $entryid, true);
                            if (serendipity_db_affected_rows() < 1) {
                                serendipity_db_query("INSERT INTO {$serendipity['dbPrefix']}karma (entryid, points, votes, lastvote, visits) VALUES ('$entryid', 0, 0, 0, 1)");
                            }
                        }
                    }

                    if (!isset($serendipity['GET']['karmaId']) || !isset($serendipity['GET']['karmaVote'])) {
                        return;
                    }

                    $this->karmaId     = (int)$serendipity['GET']['karmaId'];
                    $this->karmaVoting = (int)$serendipity['GET']['karmaVote'];

IMHO is this the part in which the ID is generated. Do you attached every EntryID a KarmaID ? I took a look in the database but there is not for every entryID an entry - so you just build a karmaID if somebody has voted?

Post by **garvinhicking** » Tue Dec 12, 2006 10:59 am

Hi!

Thanks for having a stab at it

IMHO is this the part in which the ID is generated. Do you attached every EntryID a KarmaID ? I took a look in the database but there is not for every entryID an entry - so you just build a karmaID if somebody has voted?

This is actually the part where the Entry-ID is *fetched*. It is not generated, but the code above will check and return the current Entry-ID of an entry being displayed. The entry-id is used to associate a karma-rating to an entryid, as you have already figured out.

An entry into the karmatable will only be made after the first user casts a vote for an entry. That means you will only see karmaId entries for entries that have at least one vote.

KarmaId == EntryID!

HTH,
Garvin