vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Profile Enhancements - e-steki Karma version 2.2 (https://vborg.vbsupport.ru/showthread.php?t=154264)

Lea Verou 08-10-2007 12:20 PM

Thanks for the donation cynthetiq, its my first donation ever, lol :)

Alfa1 08-10-2007 11:11 PM

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.

Lea Verou 08-11-2007 07:11 AM

Quote:

Originally Posted by Alfa1 (Post 1314841)
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.

What about the members that rated from the profile then?

Lea Verou 08-11-2007 07:31 AM

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.

dprundle 08-12-2007 07:36 AM

How do I turn it on for the other users? This happened to me.

Lea Verou 08-12-2007 08:16 AM

Quote:

Originally Posted by dprundle (Post 1315719)
How do I turn it on for the other users? This happened to me.

Run the following query:
Code:

UPDATE user SET karma=1 WHERE 1;
Add your table prefix in front of the word user in the query (for instance if your prefix is vb_ then it will be vb_user).

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.

RTFA 08-12-2007 12:35 PM

Quote:

Originally Posted by Michelle (Post 1311527)
You can help out on that by installing it on your test board and give me feedback on what happened ;)

Installed...no DB errors, but I dont see anything in the postbit or edit options page.

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? :confused:

Lea Verou 08-12-2007 03:28 PM

Quote:

Originally Posted by RTFA (Post 1315873)
Installed...no DB errors, but I dont see anything in the postbit or edit options page.

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? :confused:

Ensure that "$template_hook[postbit_userinfo_right_after_posts]" is in your postbit template.
If it is, provide me a screenshot of your main karma settings.

RTFA 08-12-2007 10:15 PM

I have that hook in my postbit...not anywhere else though. I found the option in the User Control panel.

http://img337.imageshack.us/img337/4...f6f8a66fo9.png
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]">
                        &nbsp;
                        <if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> &nbsp;</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>&nbsp;
                        </if>

                        <if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&amp;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> &nbsp;</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> &nbsp;</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%">&nbsp;</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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;userlist=buddy&amp;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 -->


EnIgMa1234 08-12-2007 10:54 PM

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


All times are GMT. The time now is 07:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01444 seconds
  • Memory Usage 1,872KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete