The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
e-steki Karma version 2.2 Details »» | |||||||||||||||||||||||||
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?
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 FeaturesDon'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 Show Your Support
|
Comments |
#162
|
|||
|
|||
Thanks for the donation cynthetiq, its my first donation ever, lol
|
#163
|
||||
|
||||
How about a function to see which member has received the most karma points in the last month? Either in Calendar month or as in last 30 days.
Another feature that would be nice is member that received most karma points in a certain (sub)forum. That would make it easier to ID potential moderator for a (sub)forum. |
#164
|
|||
|
|||
What about the members that rated from the profile then?
|
#165
|
|||
|
|||
A bug was found that turned the karma off to most members, instead of only those that hadn't visited the site for X days (if that setting was set to on). You are strongly advised to re-download the zip and replace karma_cron.php.
If anyone was affected by this bug, ask me for information on how to turn it on for the other members. |
#166
|
|||
|
|||
How do I turn it on for the other users? This happened to me.
|
#167
|
|||
|
|||
Run the following query:
Code:
UPDATE user SET karma=1 WHERE 1; This will turn it on for ALL users. To turn it off for those who haven't visited for the amount of days specified, run the new cron. Also, please don't PM me for support issues unless I told you so or there is a special reason for that. |
#168
|
|||
|
|||
Quote:
I am sure it is because I dont have a hook installed in the right place. What exactly is a "hook" is that like a DB querry? And in order for this to work which ones do I need and EXACTLY where should I put them? Please list? |
#169
|
|||
|
|||
Quote:
If it is, provide me a screenshot of your main karma settings. |
#170
|
|||
|
|||
I have that hook in my postbit...not anywhere else though. I found the option in the User Control panel.
Shot at 2007-08-12 This is my Postbit template Code:
$template_hook[postbit_start] $template_hook[postbit_userinfo_right_after_posts] <table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"> <tr> <td class="thead" $post[scrolltothis]> <div class="normal" style="float:$stylevar[right]"> <if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> </if> <if condition="$show['reputationlink']"> <span id="reputationmenu_$post[postid]"><a href="reputation.php?$session[sessionurl]p=$post[postid]" rel="nofollow" id="reputation_$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/reputation.gif" alt="<phrase 1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase>" border="0" /></a></span> <if condition="$show['popups']"><script type="text/javascript"> vbrep_register("$post[postid]")</script></if> </if> <if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a> </if> <if condition="$show['reportlink']"><a href="report.php?$session[sessionurl]p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/report.gif" alt="$vbphrase[report_bad_post]" border="0" /></a> </if> $post[iplogged] <if condition="$show['inlinemod']"> <input type="checkbox" name="plist[$postid]" id="plist_$postid" style="vertical-align:middle; padding:0px; margin:0px 0px 0px 5px" value="$post[checkbox_value]" /> </if> </div> <div class="normal"> <!-- status icon and date --> <a name="post$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif" alt="$post[statustitle]" border="0" /></a> <if condition="!$show['announcement']"> $post[postdate]<if condition="!$show['detailedtime']">, $post[posttime]</if> <else /> <phrase 1="$post[startdate]" 2="$post[enddate]">$vbphrase[x_until_y]</phrase> </if> $post[firstnewinsert] <!-- / status icon and date --> </div> </td> </tr> <tr> <td class="alt2" style="padding:0px"> <!-- user info --> <table cellpadding="0" cellspacing="$stylevar[cellpadding]" border="0" width="100%"> <tr> <if condition="$show['avatar']"><td class="alt2"><a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$post[avatarurl]" $post[avwidth] $post[avheight] alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a></td></if> <td nowrap="nowrap"> <div id="postmenu_$post[postid]"> <if condition="$show['profile']"> <a class="bigusername" href="member.php?$session[sessionurl]u=$post[userid]">$post[musername]</a> $post[onlinestatus] <script type="text/javascript"> vbmenu_register("postmenu_$post[postid]", true); </script> <else /> $post[musername] </if> </div> <if condition="$post['usertitle']"><div class="smallfont">$post[usertitle]</div></if> <if condition="$post['rank']"><div class="smallfont">$post[rank]</div></if> $template_hook[postbit_userinfo_left] </td> <td width="100%"> </td> <td valign="top" nowrap="nowrap"> <div class="smallfont"> <if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if> <if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if> <if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if> <div> $vbphrase[posts]: $post[posts] </div> <if condition="$show_p_tdob"> <div> $vbphrase[tdob_time_on_board]: <if condition="$post['timeonboard'] >= 1"><if condition="$show['timespentyears']">$timeboardspent[year] <if condition="$timeboardspent[year] == 1">$vbphrase[year]<else />$vbphrase[years]</if>, </if><if condition="$show['timespentmonths']">$timeboardspent[month] <if condition="$timeboardspent[month] == 1">$vbphrase[month]<else />$vbphrase[months]</if>, </if><if condition="$show['timespentweeks']">$timeboardspent[week] <if condition="$timeboardspent[week] == 1">$vbphrase[week]<else />$vbphrase[weeks]</if>, </if><if condition="$show['timespentdays']">$timeboardspent[day] <if condition="$timeboardspent[day] == 1">$vbphrase[day]<else />$vbphrase[days]</if> $vbphrase[tdob_and] </if>$timeboardspent[hour]:<if condition="$timeboardspent[min]<10">0$timeboardspent[min]<else />$timeboardspent[min]</if>:<if condition="$timeboardspent[sec]<10">0$timeboardspent[sec]<else />$timeboardspent[sec]</if> $vbphrase[hours]<else />$vbphrase[tdob_nodata]</if> </div> </if> <!-- START POSTING FREQUENCY MOD --> <div>Posting Frequency <table border="0" cellpadding="0" cellspacing="0"> <tr onmouseover="this.title='$post[posts] posts ($post[postsperday] posts per day)'"> <td><img border="0" src="images/polls/bar-l.gif" width="4" height="17"></td> <td width="100" background="images/polls/bar-bk.gif"><img border="0" src="images/polls/bar.gif" width="$post[frequency]" height="17"></td> <td><img border="0" src="images/polls/bar-r.gif" width="4" height="17"></td> </tr> </table> </div> <!-- END POSTING FREQUENCY MOD --> <if condition="$show['infraction']"><div>$vbphrase[infractions]: $post[warnings]/$post[infractions] ($post[ipoints])</div></if> <if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: <span id="reppower_$post[postid]_$post[userid]">$post[reppower]</span> </if><div><span id="repdisplay_$post[postid]_$post[userid]">$post[reputationdisplay]</span></div></if> $template_hook[postbit_userinfo_right] <div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div> </div> </td> </tr> </table> <!-- / user info --> </td> </tr> <tr> <td class="alt1" id="td_post_$post[postid]"> <!-- message, attachments, sig --> $template_hook[postbit_messagearea_start] <if condition="$show['messageicon'] OR $post['title']"> <!-- icon and title --> <div class="smallfont"> <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if> <if condition="$post['title']"><strong>$post[title]</strong></if> </div> <hr size="1" style="color:$stylevar[tborder_bgcolor]" /> <!-- / icon and title --> </if> <!-- message --> <div id="post_message_$post[postid]">$post[message]</div> <!-- / message --> <if condition="$show['attachments']"> <!-- attachments --> <div style="padding:$stylevar[cellpadding]px"> <if condition="$show['thumbnailattachment']"> <fieldset class="fieldset"> <legend>$vbphrase[attached_thumbnails]</legend> <div style="padding:$stylevar[formspacer]px"> $post[thumbnailattachments] </div> </fieldset> </if> <if condition="$show['imageattachment']"> <fieldset class="fieldset"> <legend>$vbphrase[attached_images]</legend> <div style="padding:$stylevar[formspacer]px"> $post[imageattachments] </div> </fieldset> </if> <if condition="$show['imageattachmentlink']"> <fieldset class="fieldset"> <legend>$vbphrase[attached_images]</legend> <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0"> $post[imageattachmentlinks] </table> </fieldset> </if> <if condition="$show['otherattachment']"> <fieldset class="fieldset"> <legend>$vbphrase[attached_files]</legend> <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0"> $post[otherattachments] </table> </fieldset> </if> <if condition="$show['moderatedattachment']"> <fieldset class="fieldset"> <legend>$vbphrase[attachments_pending_approval]</legend> <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0"> $post[moderatedattachments] </table> </fieldset> </if> </div> <!-- / attachments --> </if> $template_hook[postbit_signature_start] <if condition="$post['signature']"> <!-- sig --> <div> __________________<br /> $post[signature] </div> <!-- / sig --> </if> $template_hook[postbit_signature_end] <if condition="$show['postedited']"> <!-- edit note --> <div class="smallfont"> <hr size="1" style="color:$stylevar[tborder_bgcolor]" /> <em> <phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>. <if condition="$post['edit_reason']">$vbphrase[reason]: $post[edit_reason]</if> </em> </div> <!-- / edit note --> </if> <div style="margin-top: 10px" align="$stylevar[right]"> <!-- controls --> <if condition="$post['editlink']"> <img style="display: none" id="progress_$postid" src="$stylevar[imgdir_misc]/progress.gif" alt="$vbphrase[loading_editor_please_wait]" /> <a href="$post[editlink]" name="vB::QuickEdit::$post[postid]"><img src="$stylevar[imgdir_button]/edit.gif" alt="$vbphrase[edit_delete_message]" border="0" /></a> </if> <if condition="$post['forwardlink']"> <a href="$post[forwardlink]"><img src="$stylevar[imgdir_button]/forward.gif" alt="$vbphrase[forward_message]" border="0" /></a> </if> <if condition="$post['replylink']"> <a href="$post[replylink]" rel="nofollow"><img src="$stylevar[imgdir_button]/<if condition="$post['forwardlink']">reply_small<else />quote</if>.gif" alt="$vbphrase[reply_with_quote]" border="0" /></a> </if> <if condition="$show['multiquote_post']"> <a href="$post[replylink]" rel="nofollow" onclick="return false"><img src="$stylevar[imgdir_button]/multiquote_<if condition="$show['multiquote_selected']">on<else />off</if>.gif" alt="$vbphrase[multi_quote_this_message]" border="0" id="mq_$post[postid]" /></a> </if> <if condition="$show['quickreply'] AND !$show['threadedmode']"> <a href="$post[replylink]" rel="nofollow" id="qr_$post[postid]" onclick="return false"><img src="$stylevar[imgdir_button]/quickreply.gif" alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a> </if> <if condition="$show['moderated']"> <img src="$stylevar[imgdir_misc]/moderated.gif" alt="$vbphrase[moderated_post]" border="0" /> </if> <if condition="$show['deletedpost']"> <img src="$stylevar[imgdir_misc]/trashcan.gif" alt="$vbphrase[deleted_post]" border="0" /> </if> <if condition="$show['redcard']"> <a href="infraction.php?$session[sessionurl]do=view&p=$post[postid]"><img src="$stylevar[imgdir_button]/redcard.gif" alt="$vbphrase[received_infraction]" border="0" /></a> <else /> <if condition="$show['yellowcard']"> <a href="infraction.php?$session[sessionurl]do=view&p=$post[postid]"><img src="$stylevar[imgdir_button]/yellowcard.gif" alt="$vbphrase[received_warning]" border="0" /></a> </if> </if> $template_hook[postbit_controls] <!-- / controls --> </div> <!-- message, attachments, sig --> </td> </tr> </table> $template_hook[postbit_end] <!-- post $post[postid] popup menu --> <div class="vbmenu_popup" id="postmenu_$post[postid]_menu" style="display:none;"> <table cellpadding="4" cellspacing="1" border="0"> <tr> <td class="thead">$post[username]</td> </tr> <if condition="$show['profile']"> <tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$post[userid]">$vbphrase[view_public_profile]</a></td></tr> </if> <if condition="$show['pmlink']"> <tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]do=newpm&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[send_private_message_to_x]</phrase></a></td></tr> </if> <if condition="$show['emaillink']"> <tr><td class="vbmenu_option"><a href="sendmessage.php?$session[sessionurl]do=mailmember&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[send_email_to_x]</phrase></a></td></tr> </if> <if condition="$show['homepage']"> <tr><td class="vbmenu_option"><a href="$post[homepage]"><phrase 1="$post[username]">$vbphrase[visit_xs_homepage]</phrase></a></td></tr> </if> <if condition="$show['search']"> <tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=finduser&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[find_all_posts_by_x]</phrase></a></td></tr> </if> <if condition="$post['userid'] AND $show['member']"> <tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&userlist=buddy&u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr> </if> $template_hook[postbit_user_popup] </table> </div> <!-- / post $post[postid] popup menu --> |
#171
|
|||
|
|||
karmatest.php give a db error
Invalid SQL: SELECT userrating.voteid as voteid, userrating.userid as userid, userrating.raterid as raterid, userrating.ratername as ratername, userrating.rating as rating, userrating.active as active, userrating.dateline as dateline, userrating.ipaddress as ipaddress FROM vb_userrating AS userrating INNER JOIN vb_user AS user ON ( userrating.raterid = user.userid AND user.karma =1) WHERE userrating.userid = AND user.karma = 1 AND user.usergroupid NOT IN (1,3,4) AND ((1186962797-user.lastactivity)/86400<=30) ORDER BY userrating.rating 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 user.karma = 1 AND user.usergroupid NOT IN (1,3,4) AND ((1186962797-user' at line 5 Error Number : 1064 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|