Thank Post MOD 0.4.0 + simple hide bbcode problem

[s1m0n33]

Hello, thank you for your help. At last I managed to get it to work, I just added this string in viewtopic:

Code: Alles auswählen

// Check if the topic viewer has posted in a topic
$unhide = false; 
if ($user->data['user_id'] != ANONYMOUS)
{
	$sql = "SELECT post_id, user_id 
		FROM " . THANKS_TABLE . "
		WHERE post_id = $post_id 
		AND user_id = " . $user->data['user_id']; 

	$result = $db->sql_query($sql);
	$unhide = $db->sql_affectedrows($result) ? true : false;
	$db->sql_freeresult($result);

Now I have a small problem: the author of a topic, if you hide the message can not see it. Also why can not thank himself, how can I fix this?

Thanks

[Mahony]

Hello
You must replace this code

Code: Alles auswählen

// Check if the topic viewer has posted in a topic
$unhide = false;
if ($user->data['user_id'] != ANONYMOUS)
{
   $sql = "SELECT user_id, post_id
      FROM " . THANKS_TABLE . "
      WHERE post_id = $topic_id
      AND user_id = " . $user->data['user_id'];

   $result = $db->sql_query($sql);
   $unhide = $db->sql_affectedrows($result) ? true : false;
   $db->sql_freeresult($result);
}

with

Code: Alles auswählen

// Check if the topic viewer has posted in a topic
$unhide = false;
if ($user->data['user_id'] != ANONYMOUS)
{
   // If moderator or admin, skip reply check, auto unhide
   if ($auth->acl_get('m_', $forum_id))
   {
      $unhide = true;
   }
   else if (already_thanked($post_id, $user->data['user_id']))
   {
      $unhide = true;
   }
   else
   {
   $sql = "SELECT poster_id, topic_id
      FROM " . POSTS_TABLE . "
      WHERE topic_id = $topic_id
      AND poster_id = " . $user->data['user_id'];

   $result = $db->sql_query($sql);
   $unhide = $db->sql_affectedrows($result) ? true : false;
   $db->sql_freeresult($result);
   }
}

best regards Mahony

[s1m0n33]

Hello, I made the changes but when I read a topic, I am facing a white page

[Mahony]

Hello
Please show me your viewtopic.php in the Pastebin

best regards Mahony

[s1m0n33]

Hello, I managed to run. Now the text is hidden, and only he who is grateful. But I have a problem, given that the topic can not thank himself, can not even see the hidden text that was posted. How can I fix this problem?

[Mahony]

Hello
What have you changed?
The author can normaly always see the hidden content.

best regards Mahony

[s1m0n33]

in the viewtopic, i write only this:

Code: Alles auswählen

// Check if the topic viewer has posted in a topic
$unhide = false; 
if ($user->data['user_id'] != ANONYMOUS)
{
   $sql = "SELECT post_id, user_id 
      FROM " . THANKS_TABLE . "
      WHERE post_id = $post_id 
      AND user_id = " . $user->data['user_id']; 

   $result = $db->sql_query($sql);
   $unhide = $db->sql_affectedrows($result) ? true : false;
   $db->sql_freeresult($result);
}

[Mahony]

Hello
You have to replace your code with this code

Code: Alles auswählen

// Check if the topic viewer has posted in a topic
$unhide = false;
if ($user->data['user_id'] != ANONYMOUS)
{
   // If moderator or admin, skip reply check, auto unhide
   if ($auth->acl_get('m_', $forum_id))
   {
      $unhide = true;
   }
   else if (already_thanked($post_id, $user->data['user_id']))
   {
      $unhide = true;
   }
   else
   {
   $sql = "SELECT poster_id, topic_id
      FROM " . POSTS_TABLE . "
      WHERE topic_id = $topic_id
      AND poster_id = " . $user->data['user_id'];

   $result = $db->sql_query($sql);
   $unhide = $db->sql_affectedrows($result) ? true : false;
   $db->sql_freeresult($result);
   }
}

best regards Mahony

[s1m0n33]

if i use this code i show a page white

[Mahony]

Hello
Take the thanks.php from here - > JUNIOR ADMIN 2.0.5 English + German + Bugfixes emc 2.0.5 and use this SQL-Command (in phpmyadmin)

Code: Alles auswählen

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `phpbb_thanks`;
CREATE TABLE `phpbb_thanks` (
  `post_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM;
SET FOREIGN_KEY_CHECKS = 1;

best regards Mahony