Moderator: Integra Moderator
=== Triggered rule ===
alert (msg:"smuggling Java.script inside an image"; headers_content:"image"; nocase; headers_re:"/^Content-Type.*image/mi"; body_re:"/<.script/i";)
"CaNNon";p="31185" wrote:=== Triggered rule ===
alert (msg:"smuggling Java..script inside an image"; headers_content:"image"; nocase; headers_re:"/^Content-Type.*image/mi"; body_re:"/<..script/i";)
Whats up buddy?
"__ChAnDLeR__";p="31400" wrote:"CaNNon";p="31185" wrote:=== Triggered rule ===
alert (msg:"smuggling Java...script inside an image"; headers_content:"image"; nocase; headers_re:"/^Content-Type.*image/mi"; body_re:"/<...script/i";)
Whats up buddy?
okay not sure what or where.. does this go to..
"MWE_001";p="31408" wrote:I found a nice thankyou mod that ads stats and all in a topic as to who thanked and all. It sure would have ben great had it not been for someone creating all the install docs on those no good for nothing videos. No player or codec that I can get for any player will ever play those.
I wish mod authors would just go the old fashioned route and create honest to god text documents.
    ################################################################ MOD Title]http://www.uzzisoft.com#[/url]# MOD Description: Allows registered users to thank a post which was posted by another user## MOD Version: 0.2.6#### Installation Level: Easy## Installation Time: 10 Minutes## Files To Edit: viewtopic.php##                 includes/functions_post.php##                 language/lang_english/lang_main.php##                 templates/Integra2/Integra2.cfg##                 templates/Integra2/viewtopic_body.tpl## Included Files: thanks.php##                 templates/Integra2/thanks.tpl##                 templates/Integra2/thanks_popup.tpl##                 templates/Integra2/images/lang_english/icon_thank.gif#### License: [url=http://opensource.org/licenses/gpl-license.php]http://opensource.org/licenses/gpl-license.php[/url] GNU General Public License v2################################################################ For security purposes, please check: [url=http://www.phpbb.com/mods/#]http://www.phpbb.com/mods/#[/url]# for the latest version of this MOD. Although MODs are checked## before being allowed in the MODs Database there is no guarantee## that there are no security problems within the MOD. No support## will be given for MODs not found within the MODs Database which## can be found at [url=http://www.phpbb.com/mods/#]http://www.phpbb.com/mods/#[/url]############################################################### Author Notes:####       A mod which allows you to thank a post that a user has posted.##       When the Thanks button is pressed a page is displayed saying they have successfully thanked the user for their post.##       You can choose whether that page should be a popup or not; by editing the $popup_enabled to 0 or 1 in viewtopic.php and thanks.php##       If set to 0, the page displayed will automatically be redirected to the post in 5 seconds.####       You can view the thanks given and thanks received by a user in the topic under their posts.##       You are also shown the users who have thanked the specific post.##       When the post has been deleted the thanked received for the poster is decreased as well as the thanks given by other users.################################################################## MOD History:####   2007-10-26 - Version 0.2.6##       - Updates thanks_given and thanked_received when posts are deleted####   2006-10-29 - Version 0.2.5a##       - Thanks icon updated####   2006-10-23 - Version 0.2.5##       - Bug Fix: Thanks button was sometimes displayed even though the user had thanked the post####   2006-10-22 - Version 0.2.4##       - Removes the thanks button from posts that the user has already thanked####   2006-10-21 - Version 0.2.3##       - Updated the way "Thanked 2 Times in 1 Posts" is displayed. Posts are now referred to the total number of posts that were thanked by other users instead of the user's total posts.####   2006-10-19 - Version 0.2.2##       - Bug Fix: Adjusted Thanked by row in viewtopic to wrap the users who thanked the post####   2006-10-19 - Version 0.2.1##       - Bug Fix: Moved Thanks icon back next to quote icon since the ICQ icon gets displayed over the thanks icon if the user has an ICQ number set (couldn't find a reasonable solution)##       ##   2006-09-27 - Version 0.2.0##       - Moved Thanks icon to right hand side of where Profile, PM, links are displayed##       - Made the username of people who thanked a user link to their profile##       - Be able to select whether the thanks should popup or be displayed on the same page####   2006-09-12 - Version 0.1.1##       - Bug Fix: Thanks received wasn't updating correctly####   2006-09-11 - Version 0.1.0##       - Initial Release (for phpBB 2.0.21)################################################################## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD##############################################################  ##-----[ SQL ]------------------------------------------# Change phpbb_posts and phpbb_users to your tables#ALTER TABLE `phpbb_posts` ADD `thanks_count` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';ALTER TABLE `phpbb_posts` ADD `thanks_from_user_id` TEXT NULL;ALTER TABLE `phpbb_users` ADD `user_thanks_received` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';ALTER TABLE `phpbb_users` ADD `user_thanks_given` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';  ##-----[ COPY ]------------------------------------------#copy root/thanks.php to thanks.phpcopy root/templates/Integra2/thanks.tpl to templates/Integra2/thanks.tplcopy root/templates/Integra2/thanks_popup.tpl to templates/Integra2/thanks_popup.tplcopy root/templates/Integra2/images/lang_english/icon_thank.gif to templates/Integra2/images/lang_english/icon_thank.gif  ##-----[ OPEN ]------------------------------------------#  viewtopic.php  ##-----[ FIND ]------------------------------------------#  $pagination = generate_pagination("viewtopic.$phpEx?". $pagination_printertopic . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&". $pagination_highlight . $pagination_finish_rel, $total_replies, $pagination_ppp, $start);##-----[ AFTER, ADD ]------------------------------------------#    //// Start Thank Post by User Mod//  // Set to 1 to use pop-ups instead of using the same window$popup_enabled = 0;  if ($popup_enabled == 1) {  $thanks_javascript ='<SCRIPT><Beginfunction></script>';}  //// End Thank Post by User Mod//    ##-----[ FIND ]------------------------------------------#      'FORUM_ID' => $forum_id,  ##-----[ BEFORE, ADD ]------------------------------------------#      'THANKS_JAVASCRIPT' => $thanks_javascript,##-----[ FIND ]------------------------------------------#  $search = '<a>' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '</a>';  ##-----[ AFTER, ADD ]------------------------------------------#            //        // Start Thank Post by User Mod        //          $thanks_img = '';          if ( ($userdata['session_logged_in']) && ($userdata['user_id'] != $poster_id) ) {              // Posts SQL            $sql = "SELECT thanks_from_user_id                    FROM " . POSTS_TABLE . "                    WHERE post_id = " . $postrow[$i]['post_id'];              if ( !($result = $db->sql_query($sql)) ) {              message_die(GENERAL_ERROR, "Could not obtain post information", '', __LINE__, __FILE__, $sql);            }              $post_row = $db->sql_fetchrow($result);            $db->sql_freeresult($result);              $already_thanked = 0;              if ($post_row['thanks_from_user_id'] != null) {                $thanked_users = explode("|",$post_row['thanks_from_user_id']);              $thanked_count = count($thanked_users);                // Loop through all users who thanked the post              for ($x = 0; $x < $thanked_count; $x++) {                  if ($thanked_users[$x] == $userdata['user_id']) {                    $already_thanked = 1;                  }              }            }              // If the user hasn't thanked this post            if ($already_thanked == 0) {              $temp_url = append_sid("thanks.$phpEx?p=" . $postrow[$i]['post_id']);              if ($popup_enabled == 1) {                  $thanks_img = '<a><img></a>';              }              else {                  $thanks_img = '<a><img></a>';              }            }        }          //        // End Thank Post by User Mod        //  ##-----[ FIND ]------------------------------------------#  $template->assign_block_vars('postrow', array(  ##-----[ BEFORE, ADD ]------------------------------------------#          //        // Start Thank Post by User Mod        //          // If the user isn't anonymous        if ($postrow[$i]['user_id'] != ANONYMOUS) {              // From Users SQL            $sql = "SELECT user_posts, user_thanks_given, user_thanks_received                    FROM " . USERS_TABLE . "                    WHERE user_id = " . $postrow[$i]['user_id'];              if ( !($result = $db->sql_query($sql)) ) {              message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);            }              $user_row = $db->sql_fetchrow($result);            $db->sql_freeresult($result);              // Thanked Posts SQL            $sql = "SELECT COUNT(thanks_count) AS thanks_count                    FROM " . POSTS_TABLE . "                    WHERE poster_id = " . $postrow[$i]['user_id'] . "                    AND thanks_count <> 0";              if ( !($result = $db->sql_query($sql)) ) {              message_die(GENERAL_ERROR, "Could not obtain posts information", '', __LINE__, __FILE__, $sql);            }              $thanked_post_count = $db->sql_fetchrow($result);            $db->sql_freeresult($result);              $thanks_given = $lang['Thanks_thanks'] . ': ' . $user_row['user_thanks_given'];            $thanks_received = $lang['Thanks_thanked_1'] . ' ' . $user_row['user_thanks_received'] . ' ' . $lang['Thanks_thanked_2'] . ' ' . $thanked_post_count['thanks_count'] . ' ' . $lang['Thanks_thanked_3'];          }        else {            $thanks_given = "";            $thanks_received = "";        }          //        // End Thank Post by User Mod        //  ##-----[ FIND ]------------------------------------------#          'POSTER_NAME' => $poster,  ##-----[ AFTER, ADD ]------------------------------------------#          'POSTER_THANKS_GIVEN' => $thanks_given,        'POSTER_THANKS_RECEIVED' => $thanks_received,##-----[ FIND ]------------------------------------------#  'EDIT' => $edit,  ##-----[ AFTER, ADD ]------------------------------------------#          'THANKS_IMG' => $thanks_img,##-----[ FIND ]------------------------------------------#          $template->assign_block_vars('postrow.switch_no_buddy_ignore', array());    }//-- fin mod : profile cp --------------------------------------------------------------------------  ##-----[ BEFORE, ADD ]------------------------------------------#            //        // Start Thank Post by User Mod        //          if ($postrow[$i]['thanks_count'] >= 1) {            $thanked_by = "";            $thanked_users = explode("|",$postrow[$i]['thanks_from_user_id']);          $thanked_count = $postrow[$i]['thanks_count'];            // Loop through all users who thanked the post          for ($x = 0; $x <thanked_count>sql_query($sql)) ) {                message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);              }                $user_row = $db->sql_fetchrow($result);              $db->sql_freeresult($result);                if ($x >= 1) { $thanked_by .= ", "; }                // Add user to thanked by list              $temp_url = "profile.$phpEx?mode=viewprofile&u=" . $user_row['user_id'];              $thanked_by .= '<a>' . $user_row['username'] . '</a>';          }            $template->assign_block_vars('postrow.thanks', array(                'L_THANKS_TEXT' => $lang['Thanks_thanked_by'],                'THANKS_USERS' => $thanked_by)          );        }          //        // End Thank Post by User Mod        //  ##-----[ OPEN ]---------------------------------#  includes/functions_post.php  ##-----[ FIND ]---------------------------------#  function delete_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id){    global $board_config, $lang, $db, $phpbb_root_path, $phpEx;    global $userdata, $user_ip;  ##-----[ AFTER, ADD ]---------------------------------#          //        // Start Thank Post by User Mod        //          // Thanked Listing SQL        $sql = "SELECT thanks_from_user_id, thanks_count, poster_id                FROM " . POSTS_TABLE . "                WHERE post_id = '$post_id'";          if ( !($result = $db->sql_query($sql)) ) {            message_die(GENERAL_ERROR, "Could not obtain posts information", '', __LINE__, __FILE__, $sql);        }          $post_thanks = $db->sql_fetchrow($result);        $db->sql_freeresult($result);          // If this post was thanked, then continue        if ($post_thanks['thanks_from_user_id']) {              $thanked_users = explode("|", $post_thanks['thanks_from_user_id']);              // Loop through all users who thanked the post            for ($i = 0; $i <count>sql_query($sql)) ) {                  message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);              }                $from_user_row = $db->sql_fetchrow($result);              $db->sql_freeresult($result);                $thanks_given = $from_user_row['user_thanks_given'] - 1;                // Update DB with the new thanks given              $update_sql = "UPDATE " . USERS_TABLE . "                              SET user_thanks_given = '" . $thanks_given . "'                              WHERE user_id = " . $from_user;                if ( !($result = $db->sql_query($update_sql)) ) {                  message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $update_sql);              }                // Remove 1 from the user who was thanked              $sql = "SELECT user_thanks_received                      FROM " . USERS_TABLE . "                      WHERE user_id = " . $to_user;                if ( !($result = $db->sql_query($sql)) ) {                  message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);              }                $to_user_row = $db->sql_fetchrow($result);              $db->sql_freeresult($result);                $thanks_received = $to_user_row['user_thanks_received'] - 1;                // Update DB with the new thanks given              $update_sql = "UPDATE " . USERS_TABLE . "                              SET user_thanks_received = '" . $thanks_received . "'                              WHERE user_id = " . $to_user;                if ( !($result = $db->sql_query($update_sql)) ) {                  message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $update_sql);              }            }        }          //        // End Thank Post by User Mod        //  ##-----[ OPEN ]---------------------------------#  templates/Integra2/Integra2.cfg  ##-----[ FIND ]---------------------------------#  $images['icon_edit'] = "$current_template_images/{LANG}/icon_edit.gif";  ##-----[ AFTER, ADD ]---------------------------------#  $images['icon_thank'] = "$current_template_images/{LANG}/icon_thank.gif";##-----[ OPEN ]------------------------------------------#  templates/Integra2/viewtopic_body.tpl  ##-----[ FIND ]------------------------------------------#  <script></script>    ##-----[ BEFORE, ADD ]---------------------------------#  {THANKS_JAVASCRIPT}  ##-----[ FIND ]------------------------------------------#  {postrow.QUOTE_IMG}  ##-----[ IN-LINE FIND ]------------------------------------------#  {postrow.QUOTE_IMG}  ##-----[ IN-LINE REPLACE WITH ]------------------------------------------#  {postrow.QUOTE_IMG} {postrow.THANKS_IMG}      ##-----[ FIND ]------------------------------------------#            </td>        </tr>        <END>##-----[ After, ADD ]------------------------------------------#        <BEGIN>        <tr>                <td>                  <table>                        <tr>                          <td><span>{postrow.thanks.L_THANKS_TEXT}: {postrow.thanks.THANKS_USERS}</span></td>                        </tr>                  </table>                </td>        </tr>        <END>##-----[ SAVE/CLOSE ALL FILES ]------------------------------------------## EoM   
#
#-----[ OPEN ]---------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]---------------------------------
#
?>
#
#-----[ BEFORE, ADD ]---------------------------------
#
//
// Start Thank Post by User Mod
//
$lang['Thanks_title'] = 'Thank User for Post';
$lang['Thanks_text'] = 'Thank this user for their post';
$lang['Thanks_thanked_by'] = 'Thanked by';
$lang['Thanks_thanks'] = 'Thanks';
$lang['Thanks_thanked_1'] = 'Thanked';
$lang['Thanks_thanked_2'] = 'Times in';
$lang['Thanks_thanked_3'] = 'Posts';
$lang['Thanks_not_logged_in'] = 'You aren't logged in.';
$lang['Thanks_no_post_specified'] = 'No post was specified.';
$lang['Thanks_no_such_post'] = 'Post doesn't exist.';
$lang['Thanks_anonymous'] = 'You can't thank an anonymous post.';
$lang['Thanks_self'] = 'You can't thank your own post.';
$lang['Thanks_already_thanked'] = 'You have already thanked this post.';
$lang['Thanks_success_1'] = 'Post by';
$lang['Thanks_success_2'] = 'in thread';
$lang['Thanks_success_3'] = 'has successfully been thanked.';
$lang['Thanks_success_back'] = 'Click here if you can't wait or if redirection is not supported by your browser';
$lang['Thanks_success_redirect'] = 'Redirecting to the topic/post you came from in 5 seconds.';
//
// End Thank Post by User Mod
//
"HelterSkelter";p="31409" wrote:
#
#-----[ FIND ]---------------------------------
#
$images['icon_edit'] = "$current_template_images/{LANG}/icon_edit.gif" width="$topic_iw" height="$topic_ih" class="imgtopic";
#
#-----[ AFTER, ADD ]---------------------------------
#
$images['icon_thank'] = "$current_template_images/{LANG}/icon_thank.gif" width="$topic_iw" height="$topic_ih" class="imgtopic";
##-----[ FIND ]------------------------------------------# 'POSTER_FROM' => $poster_from, ##-----[ AFTER, ADD ]------------------------------------------# 'POSTER_THANKS_GIVEN' => $thanks_given, 'POSTER_THANKS_RECEIVED' => $thanks_received,
# #-----[ OPEN ]------------------------------------------ # templates/subSilver/viewtopic_body.tpl # #-----[ FIND ]------------------------------------------ # <script></script> # #-----[ BEFORE, ADD ]--------------------------------- # {THANKS_JAVASCRIPT} # #-----[ FIND ]------------------------------------------ # <END> # #-----[ AFTER, ADD ]------------------------------------------ # <BEGIN> <tr> <td> <table> <tr> <td><span>{postrow.thanks.L_THANKS_TEXT}]------------------------------------------ # # EoM
Parse error]
here is that line in my file
[code] for ($x = 0; $x <thanked_count>sql_query($sql)) ) {
Parse error]
this is the line it is talking about
[code=php] for ($i = 0; $i <count>sql_query($sql)) ) { [/code]
when i try to goto a topic this is the error i get
[code=php]Parse error]
here is that line
[code=php] for ($x = 0; $x <thanked_count>sql_query($sql)) ) {
#
#-----[ OPEN ]---------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]---------------------------------
#
//
// That's all, Folks!
#
#-----[ BEFORE, ADD ]---------------------------------
#
//
// Start Thank Post by User Mod
//
$lang['Thanks_title'] = 'Thank User for Post';
$lang['Thanks_text'] = 'Thank this user for their post';
$lang['Thanks_thanked_by'] = 'Thanked by';
$lang['Thanks_thanks'] = 'Thanks';
$lang['Thanks_thanked_1'] = 'Thanked';
$lang['Thanks_thanked_2'] = 'Times in';
$lang['Thanks_thanked_3'] = 'Posts';
$lang['Thanks_not_logged_in'] = 'You aren't logged in.';
$lang['Thanks_no_post_specified'] = 'No post was specified.';
$lang['Thanks_no_such_post'] = 'Post doesn't exist.';
$lang['Thanks_anonymous'] = 'You can' thank an anonymous post.';
$lang['Thanks_self'] = 'You can't thank your own post.';
$lang['Thanks_already_thanked'] = 'You have already thanked this post.';
$lang['Thanks_success_1'] = 'Post by';
$lang['Thanks_success_2'] = 'in thread';
$lang['Thanks_success_3'] = 'has successfully been thanked.';
$lang['Thanks_success_back'] = 'Click here if you can't wait or if redirection is not supported by your browser';
$lang['Thanks_success_redirect'] = 'Redirecting to the topic/post you came from in 5 seconds.';
//
// End Thank Post by User Mod
//
//
// Start Thank Post by User Mod
//
$lang['Thanks_title'] = 'Thank User for Post';
$lang['Thanks_text'] = 'Thank this user for their post';
$lang['Thanks_thanked_by'] = 'Thanked by';
$lang['Thanks_thanks'] = 'Thanks';
$lang['Thanks_thanked_1'] = 'Thanked';
$lang['Thanks_thanked_2'] = 'Times in';
$lang['Thanks_thanked_3'] = 'Posts';
$lang['Thanks_not_logged_in'] = 'You aren't logged in.';
$lang['Thanks_no_post_specified'] = 'No post was specified.';
$lang['Thanks_no_such_post'] = 'Post doesn't exist.';
$lang['Thanks_anonymous'] = 'You can't thank an anonymous post.';
$lang['Thanks_self'] = 'You can't thank your own post.';
$lang['Thanks_already_thanked'] = 'You have already thanked this post.';
$lang['Thanks_success_1'] = 'Post by';
$lang['Thanks_success_2'] = 'in thread';
$lang['Thanks_success_3'] = 'has successfully been thanked.';
$lang['Thanks_success_back'] = 'Click here if you can't wait or if redirection is not supported by your browser';
$lang['Thanks_success_redirect'] = 'Redirecting to the topic/post you came from in 5 seconds.';
//
// End Thank Post by User Mod
//
##
## Installation Level: Easy
## Installation Time: 10 Minutes
## Files To Edit: viewtopic.php
## includes/functions_post.php
## language/lang_english/lang_main.php
## templates/subSilver/subSilver.cfg
## templates/subSilver/viewtopic_body.tpl
## Included Files: thanks.php
## templates/subSilver/thanks.tpl
## templates/subSilver/thanks_popup.tpl
## templates/subSilver/images/lang_english/icon_thank.gif
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
## A mod which allows you to thank a post that a user has posted.
## When the Thanks button is pressed a page is displayed saying they have successfully thanked the user for their post.
## You can choose whether that page should be a popup or not; by editing the $popup_enabled to 0 or 1 in viewtopic.php and thanks.php
## If set to 0, the page displayed will automatically be redirected to the post in 5 seconds.
##
## You can view the thanks given and thanks received by a user in the topic under their posts.
## You are also shown the users who have thanked the specific post.
## When the post has been deleted the thanked received for the poster is decreased as well as the thanks given by other users.
##
##############################################################
## MOD History:
##
## 2007-10-26 - Version 0.2.6
## - Updates thanks_given and thanked_received when posts are deleted
##
## 2006-10-29 - Version 0.2.5a
## - Thanks icon updated
##
## 2006-10-23 - Version 0.2.5
## - Bug Fix: Thanks button was sometimes displayed even though the user had thanked the post
##
## 2006-10-22 - Version 0.2.4
## - Removes the thanks button from posts that the user has already thanked
##
## 2006-10-21 - Version 0.2.3
## - Updated the way "Thanked 2 Times in 1 Posts" is displayed. Posts are now referred to the total number of posts that were thanked by other users instead of the user's total posts.
##
## 2006-10-19 - Version 0.2.2
## - Bug Fix: Adjusted Thanked by row in viewtopic to wrap the users who thanked the post
##
## 2006-10-19 - Version 0.2.1
## - Bug Fix: Moved Thanks icon back next to quote icon since the ICQ icon gets displayed over the thanks icon if the user has an ICQ number set (couldn't find a reasonable solution)
##
## 2006-09-27 - Version 0.2.0
## - Moved Thanks icon to right hand side of where Profile, PM, links are displayed
## - Made the username of people who thanked a user link to their profile
## - Be able to select whether the thanks should popup or be displayed on the same page
##
## 2006-09-12 - Version 0.1.1
## - Bug Fix: Thanks received wasn't updating correctly
##
## 2006-09-11 - Version 0.1.0
## - Initial Release (for phpBB 2.0.21)
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ]------------------------------------------
# Change phpbb_posts and phpbb_users to your tables
#
ALTER TABLE `phpbb_posts` ADD `thanks_count` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` ADD `thanks_from_user_id` TEXT NULL;
ALTER TABLE `phpbb_users` ADD `user_thanks_received` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` ADD `user_thanks_given` MEDIUMINT( 8 ) NOT NULL DEFAULT '0';
#
#-----[ COPY ]------------------------------------------
#
copy root/thanks.php to thanks.php
copy root/templates/subSilver/thanks.tpl to templates/subSilver/thanks.tpl
copy root/templates/subSilver/thanks_popup.tpl to templates/subSilver/thanks_popup.tpl
copy root/templates/subSilver/images/lang_english/icon_thank.gif to templates/subSilver/images/lang_english/icon_thank.gif
#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
$pagination = generate_pagination("viewtopic.$phpEx?". $pagination_printertopic . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&". $pagination_highlight . $pagination_finish_rel, $total_replies, $pagination_ppp, $start);
#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Start Thank Post by User Mod
//
// Set to 1 to use pop-ups instead of using the same window
$popup_enabled = 0;
if ($popup_enabled == 1) {
$thanks_javascript ='<SCRIPT>
<Begin>
</script>';
}
//
// End Thank Post by User Mod
//
#
#-----[ FIND ]------------------------------------------
#
'FORUM_ID' => $forum_id,
#
#-----[ BEFORE, ADD ]------------------------------------------
#
'THANKS_JAVASCRIPT' => $thanks_java.script,
#
#-----[ FIND ]------------------------------------------
#
$search = '<a>' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '</a>';
#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Start Thank Post by User Mod
//
$thanks_img = '';
if ( ($userdata['session_logged_in']) && ($userdata['user_id'] != $poster_id) ) {
// Posts SQL
$sql = "SELECT thanks_from_user_id
FROM " . POSTS_TABLE . "
WHERE post_id = " . $postrow[$i]['post_id'];
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain post information", '', __LINE__, __FILE__, $sql);
}
$post_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$already_thanked = 0;
if ($post_row['thanks_from_user_id'] != null) {
$thanked_users = explode("|",$post_row['thanks_from_user_id']);
$thanked_count = count($thanked_users);
// Loop through all users who thanked the post
for ($x = 0; $x < $thanked_count; $x++) {
if ($thanked_users[$x] == $userdata['user_id']) {
$already_thanked = 1;
}
}
}
// If the user hasn't thanked this post
if ($already_thanked == 0) {
$temp_url = append_sid("thanks.$phpEx?p=" . $postrow[$i]['post_id']);
if ($popup_enabled == 1) {
$thanks_img = '<a><img></a>';
}
else {
$thanks_img = '<a><img></a>';
}
}
}
//
// End Thank Post by User Mod
//
#
#-----[ FIND ]------------------------------------------
#
$template->assign_block_vars('postrow', array(
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Start Thank Post by User Mod
//
// If the user isn't anonymous
if ($postrow[$i]['user_id'] != ANONYMOUS) {
// From Users SQL
$sql = "SELECT user_posts, user_thanks_given, user_thanks_received
FROM " . USERS_TABLE . "
WHERE user_id = " . $postrow[$i]['user_id'];
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);
}
$user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// Thanked Posts SQL
$sql = "SELECT COUNT(thanks_count) AS thanks_count
FROM " . POSTS_TABLE . "
WHERE poster_id = " . $postrow[$i]['user_id'] . "
AND thanks_count <> 0";
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain posts information", '', __LINE__, __FILE__, $sql);
}
$thanked_post_count = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$thanks_given = $lang['Thanks_thanks'] . ': ' . $user_row['user_thanks_given'];
$thanks_received = $lang['Thanks_thanked_1'] . ' ' . $user_row['user_thanks_received'] . ' ' . $lang['Thanks_thanked_2'] . ' ' . $thanked_post_count['thanks_count'] . ' ' . $lang['Thanks_thanked_3'];
}
else {
$thanks_given = "";
$thanks_received = "";
}
//
// End Thank Post by User Mod
//
#
#-----[ FIND ]------------------------------------------
#
'POSTER_NAME' => $poster,
#
#-----[ AFTER, ADD ]------------------------------------------
#
'POSTER_THANKS_GIVEN' => $thanks_given,
'POSTER_THANKS_RECEIVED' => $thanks_received,
#
#-----[ FIND ]------------------------------------------
#
'EDIT' => $edit,
#
#-----[ AFTER, ADD ]------------------------------------------
#
'THANKS_IMG' => $thanks_img,
#
#-----[ FIND ]------------------------------------------
#
$template->assign_block_vars('postrow.switch_no_buddy_ignore', array());
}
//-- fin mod : profile cp --------------------------------------------------------------------------
#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Start Thank Post by User Mod
//
if ($postrow[$i]['thanks_count'] >= 1) {
$thanked_by = "";
$thanked_users = explode("|",$postrow[$i]['thanks_from_user_id']);
$thanked_count = $postrow[$i]['thanks_count'];
// Loop through all users who thanked the post
for ($x = 0; $x <thanked_count>sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);
}
$user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if ($x >= 1) { $thanked_by .= ", "; }
// Add user to thanked by list
$temp_url = "profile.$phpEx?mode=viewprofile&u=" . $user_row['user_id'];
$thanked_by .= '<a>' . $user_row['username'] . '</a>';
}
$template->assign_block_vars('postrow.thanks', array(
'L_THANKS_TEXT' => $lang['Thanks_thanked_by'],
'THANKS_USERS' => $thanked_by)
);
}
//
// End Thank Post by User Mod
//
#
#-----[ OPEN ]---------------------------------
#
includes/functions_post.php
#
#-----[ FIND ]---------------------------------
#
function delete_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id)
{
global $board_config, $lang, $db, $phpbb_root_path, $phpEx;
global $userdata, $user_ip;
#
#-----[ AFTER, ADD ]---------------------------------
#
//
// Start Thank Post by User Mod
//
// Thanked Listing SQL
$sql = "SELECT thanks_from_user_id, thanks_count, poster_id
FROM " . POSTS_TABLE . "
WHERE post_id = '$post_id'";
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain posts information", '', __LINE__, __FILE__, $sql);
}
$post_thanks = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// If this post was thanked, then continue
if ($post_thanks['thanks_from_user_id']) {
$thanked_users = explode("|", $post_thanks['thanks_from_user_id']);
// Loop through all users who thanked the post
for ($i = 0; $i <count>sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);
}
$from_user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$thanks_given = $from_user_row['user_thanks_given'] - 1;
// Update DB with the new thanks given
$update_sql = "UPDATE " . USERS_TABLE . "
SET user_thanks_given = '" . $thanks_given . "'
WHERE user_id = " . $from_user;
if ( !($result = $db->sql_query($update_sql)) ) {
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $update_sql);
}
// Remove 1 from the user who was thanked
$sql = "SELECT user_thanks_received
FROM " . USERS_TABLE . "
WHERE user_id = " . $to_user;
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain user information", '', __LINE__, __FILE__, $sql);
}
$to_user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$thanks_received = $to_user_row['user_thanks_received'] - 1;
// Update DB with the new thanks given
$update_sql = "UPDATE " . USERS_TABLE . "
SET user_thanks_received = '" . $thanks_received . "'
WHERE user_id = " . $to_user;
if ( !($result = $db->sql_query($update_sql)) ) {
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $update_sql);
}
}
}
//
// End Thank Post by User Mod
//
#
#-----[ OPEN ]---------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]---------------------------------
#
//
// That's all, Folks!
#
#-----[ BEFORE, ADD ]---------------------------------
#
//
// Start Thank Post by User Mod
//
$lang['Thanks_title'] = 'Thank User for Post';
$lang['Thanks_text'] = 'Thank this user for their post';
$lang['Thanks_thanked_by'] = 'Thanked by';
$lang['Thanks_thanks'] = 'Thanks';
$lang['Thanks_thanked_1'] = 'Thanked';
$lang['Thanks_thanked_2'] = 'Times in';
$lang['Thanks_thanked_3'] = 'Posts';
$lang['Thanks_not_logged_in'] = 'You aren't logged in.';
$lang['Thanks_no_post_specified'] = 'No post was specified.';
$lang['Thanks_no_such_post'] = 'Post doesn't exist.';
$lang['Thanks_anonymous'] = 'You can't thank an anonymous post.';
$lang['Thanks_self'] = 'You can't thank your own post.';
$lang['Thanks_already_thanked'] = 'You have already thanked this post.';
$lang['Thanks_success_1'] = 'Post by';
$lang['Thanks_success_2'] = 'in thread';
$lang['Thanks_success_3'] = 'has successfully been thanked.';
$lang['Thanks_success_back'] = 'Click here if you can't wait or if redirection is not supported by your browser';
$lang['Thanks_success_redirect'] = 'Redirecting to the topic/post you came from in 5 seconds.';
//
// End Thank Post by User Mod
//
#
#-----[ OPEN ]---------------------------------
#
templates/Integra2/Integra2.cfg
#
#-----[ FIND ]---------------------------------
#
$images['icon_edit'] = "$current_template_images/{LANG}/icon_edit.gif" width="$topic_iw" height="$topic_ih" class="imgtopic";
#
#-----[ AFTER, ADD ]---------------------------------
#
$images['icon_thank'] = "$current_template_images/{LANG}/icon_thank.gif" width="$topic_iw" height="$topic_ih" class="imgtopic";
#
#-----[ OPEN ]------------------------------------------
#
templates/Integra2/viewtopic_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<script></script>
#
#-----[ BEFORE, ADD ]---------------------------------
#
{THANKS_JAVASCRIPT}
#
#-----[ FIND ]------------------------------------------
#
{postrow.QUOTE_IMG}
#
#-----[ IN-LINE FIND ]------------------------------------------
#
{postrow.QUOTE_IMG}
#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------
#
{postrow.QUOTE_IMG} {postrow.THANKS_IMG}
#
#-----[ FIND ]------------------------------------------
#
</tr>
<END>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<BEGIN>
<tr>
<td>
<table>
<tr>
<td><span>{postrow.thanks.L_THANKS_TEXT}: {postrow.thanks.THANKS_USERS}</span></td>
</tr>
</table>
</td>
</tr>
<END>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
'POSTER_FROM' => $poster_from,
Registered users: App360MonitorBot, Bing [Bot], Google [Bot], Majestic-12 [Bot]