Codezwiz >> Forums >> BBtoNuke Mods Help >> Combine Thank you mod Hide Mod

Hey im trying to make the thank you mod found [ Register or login to view links on this board.]
and the hide mod found [ Register or login to view links on this board.] work together.
The hide mod makes it to where you can hide links in a post and a guest or member has to reply to the post to see the link, i want them to be able to click the thank you button and see the content aswell as reply to the post.

The help i need is with combining these sql queries the first is the original query from the hide mod the second is the query i edited to make it work with the thank you button i want the member to see the hidden link whether they hit the thank you button or they reply so i need both these queries.

the hide query

$valid = FALSE;
if( $userdata['session_logged_in'] ) {
$sql = "SELECT p.poster_id, p.topic_id
FROM " . POSTS_TABLE . " p
WHERE p.topic_id = $topic_id
AND p.poster_id = " . $userdata['user_id'];
$resultat = $db->sql_query($sql);
$valid = $db->sql_numrows($resultat) ? TRUE : FALSE;}

No takers on this

Sorry i dont understand what your trying to do. You just need this query joined?

Yes i need both queries joined

Try this one:

$valid = FALSE;
if( $userdata['session_logged_in'] ) {
   $sql = "SELECT p.poster_id, p.topic_id, t.user_id, t.topic_id FROM " . POSTS_TABLE . " AS p LEFT JOIN nuke_bbthanks AS t ON p.poster_id = t.user_id WHERE p.topic_id = $topic_id AND p.poster_id = " . $userdata['user_id'];
   $resultat = $db->sql_query($sql);
   $valid = $db->sql_numrows($resultat) ? TRUE : FALSE;
}

Telli that didn't work is it possible to run both queries?

The hide mod works by someone replying to a post and viewing the hidden content
So the query for this is

$valid = FALSE;
if( $userdata['session_logged_in'] ) {
$sql = "SELECT p.poster_id, p.topic_id
FROM " . POSTS_TABLE . " p
WHERE p.topic_id = $topic_id
AND p.poster_id = " . $userdata['user_id'];
$resultat = $db->sql_query($sql);
$valid = $db->sql_numrows($resultat) ? TRUE : FALSE;}

open
modules/Forums/viewtopic.php

Find:
$thanked = TRUE;

After add:
$valid = TRUE;

USE THIS IM SURE 99% work i use this on my site and work both of them

Thanks that worked out perfect.

Sorry to open back this old topic but it sounded interesting !

Well, it wud be really nice of u if u cud somehow give a little new shape to this mod.

Basically, the hide mod hides the post until the user posts a reply to that topic.
And Thanks Mod (didnt work on my phpnuke 7.9) adds a button to thank a user for his/her post.

I wud be highly thankful if u cud somehow make a change that in order to see the hidden content, the user must ONLY PRESS THE THANKS BUTTON and the reply part is not necessary!

PS: im using BBcode Mod Box as the one on this site.

Please try to c if u can do a little change !

Thanks !