Automatic 'Thank you' Hack

Total hack's description : http://www.vbulletindev.net/forums/h...hack&hackid=49

Site : http://www.vbulletindev.net/forums


You can set in wanted forums with this hack, an option which displays in a special post of a thread, the list of members who clicked the 'Thank you' button. So, instead of having a lot of posts saying : 'Great', 'Big thx ' ... you only have one post.

The postbit (legacy or not) automatically adapts itself too.

The phrase to thank the thread creator change if there is one user or more which clicks the button, so the verb is always correct
There is an other option too in Forum manager, to set if you want to see at which date the 'Thank you' button was clicked by the member.

Hack requested by boofo


Eventual bugs :Correct with it

[teksigns]

Originally Posted by VBDev

I'll do it Vitrox

cool !


cant wait

[calvinnguyen]

Originally Posted by VBDev

@calvin : where do you get this no_permission screen ? If you have it when you click the button Thanks, it's coz you are not logged in
Prefix : look in your config.php, $prefix=... you have to add in my SQL queries, the prefix before tables name

I update the zip

I had run those 3 below got sucessful, but still got no_permission screen like you said above.
What do you mean add ,$prefix = ' '; to my SQL?

even I add this: $prefix = ' '; before tables name . It is still not going. I had no ideas what is exactly wrong to cause this problem. I love this hack, but I am not lucky to use it. :disappointed:


ALTER TABLE `forum` ADD `showthanks` INT(1) DEFAULT '0' NOT NULL;

ALTER TABLE `forum` ADD `showthanks_date` INT(1) DEFAULT '0' NOT NULL;

CREATE TABLE `thanks` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` INT(10) NOT NULL,
`username` VARCHAR(50) NOT NULL,
`date` INT(10) NOT NULL,
`threadid` INT(10) NOT NULL
);

[Mone']

Originally Posted by VBDev

I'll do it Vitrox

exellent :squareeyed:

[Boofo]

VBDev, buddy, are you still working on this hack?

[VBDev]

No, I'm finishing an other one, 'hidden text password protected' in post

I take a look for this counter in the evening

[VBDev]

@ calvin : I've exactly the same problem ... this no_permission page, really strange, the var $foruminfo[showthanks] doesn't seen working

I correct it before doing the counter


If you have this no_permission problem, replace the code to add in newreply.php with :

PHP Code:

// ############################### Than you hack Grog6 ###############################
if ($_REQUEST['do'] == 'thanks')
{
    globalize($_REQUEST, array('threadid' => INT));
    $forum=$DB_site->query_first("SELECT showthanks FROM ". TABLE_PREFIX ."forum WHERE forumid='$foruminfo[forumid]'");
    if ($forum[showthanks]==0 || $bbuserinfo[userid]==0)
     print_no_permission();
    else
    {
        $verif=$DB_site->query_first("SELECT userid FROM ". TABLE_PREFIX ."thanks WHERE threadid='$threadid' AND userid='$bbuserinfo[userid]'");
    if ($verif[userid]==$bbuserinfo[userid])
     eval(print_standard_error('error_already_thanks'));
    else
        {
        $DB_site->query("
        INSERT INTO ". TABLE_PREFIX ."thanks
        (userid, username, date, threadid)
        VALUES ('$bbuserinfo[userid]', '" . addslashes($bbuserinfo[username]) . "', " . TIMENOW . ", '$threadid')");
        $url = "showthread.php?$session[sessionurl]t=$threadid";
    eval(print_standard_redirect('redirect_thanks'));
        }
    }
} 


And code to add in functions_showthread.php with :

PHP Code:

         // thank you hack grog6
        $cmpt=1;
        $grumpf=$DB_site->query_first("SELECT showthanks FROM ". TABLE_PREFIX ."forum WHERE forumid='$forum[forumid]'");
    
        if ($grumpf[showthanks] == 1 && $post[postcount]==1)
        {
        $thanks=$DB_site->query("SELECT * FROM ". TABLE_PREFIX ."thanks WHERE threadid='$thread[threadid]' ORDER BY username");
        $nb=$DB_site->num_rows($thanks);
        if ($nb>0)
           {
               while($thank=$DB_site->fetch_array($thanks))
               {
                if ($cmpt<$nb)
                 $virg=",";
                else $virg="";
                if ($forum[showthanks_date]==0)
                $liste_user = $liste_user." <a href=\"member.php?u=$thank[userid]\">$thank[username]</a>$virg ";
                else
                {
                 $date_thank = vbdate($vboptions['dateformat'], $thank['date'], true);
                 $liste_user = $liste_user." <a href=\"member.php?u=$thank[userid]\">$thank[username]</a> ($date_thank)$virg ";
                }
               $date=$thank[date];
               $cmpt++;
              }
               // format date/time
            $post['postdate'] = vbdate($vboptions['dateformat'], $date, true);
            $post['posttime'] = vbdate($vboptions['timeformat'], $date);
               // user profil field
               $username = "<b><font size=\"3\">$vbphrase[thanks_bot]</font></b>";
               if ($nb<=1)
                $thank_phrase = construct_phrase($vbphrase[thanks_1_install], $post[musername]);
               else $thank_phrase = construct_phrase($vbphrase[thanks_x_install], $post[musername]);
               if ($vboptions[legacypostbit]=="000")
                eval('$thanks_post .= " ' . fetch_template('thanks_postbit') . '";');
               else eval('$thanks_post = " ' . fetch_template('thanks_postbit_legacy') . '";');
             }
        }
        // thank you hack grog6 


[VBDev]

To add a counter, in functions_showthread.php, replace :

PHP Code:

$thanks=$DB_site->query("SELECT * AS nb FROM ". TABLE_PREFIX ."thanks WHERE threadid='$thread[threadid]' ORDER BY username"); 


with

PHP Code:

$thanks=$DB_site->query("SELECT *, COUNT(userid) AS nb FROM ". TABLE_PREFIX ."thanks WHERE threadid='$thread[threadid]' GROUP BY userid ORDER BY username"); 


Add a phrase in your phrase manager thanks_nb :

{1} people have clicked the THANKS button

ANd in your new postbit template

Add :

 
<phrase 1="$thank[nb]">$vbphrase[thanks_nb]</phrase>

[teksigns]

not sure im understanding where to put this :

ANd in your new postbit template

Add :

Code:

<phrase 1="$thank[nb]">$vbphrase[thanks_nb]</phrase>

looking through the code ... does $nb var not already contain the count of thanks
because of line:

$nb=$DB_site->num_rows($thanks);

[Boofo]

The number of people who clicked the link doesn't show up for me. Just the phrase without the number. I even changed the phrase 1 to $thanks[nb] as it should be and the number still does not show up.

[teksigns]

Originally Posted by Boofo

The number of people who clicked the link doesn't show up for me. Just the phrase without the number. I even changed the phrase 1 to $thanks[nb] as it should be and the number still does not show up.

from what i can see:

you shoudnt need to replace :

$thanks=$DB_site->query("SELECT * AS nb FROM ". TABLE_PREFIX ."thanks WHERE threadid='$thread[threadid]' ORDER BY username");

do the other steps though ....


and change the phrase line like this :

<phrase 1="$nb">$vbphrase[thanks_nb]</phrase>