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

[Boofo]

Originally Posted by teksigns

just trying to help !


im not a coder... if you have better way .....please post it .......

its only way i know to get job done .......

I didn't me that in a bad way. I was jusy saying that adding too many queries might not be a good idea to some poeple. Sorry if you took that wrong.

[teksigns]

Originally Posted by Boofo

I didn't me that in a bad way. I was jusy saying that adding too many queries might not be a good idea to some poeple. Sorry if you took that wrong.

np .....

i wish there was another way ..... but none i can think of without the extra
queries .......

[calvinnguyen]

Originally Posted by tnguy3n

Those no permission messages appear cuz you don't have "Thank You Option" enable for existing forums. Just run this following query (in either Admin CP or phpMyAdmin):

How can I clear #1060 - Duplicate column name 'showthanks'
to run
ALTER TABLE `forum` ADD `showthanks` INT(1) DEFAULT '0' NOT NULL;

again, because anytime I run it give me error as the message below.
Thanks tnguy3n

Error

SQL-query :

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

MySQL said:


#1060 - Duplicate column name 'showthanks'

[Boofo]

That error means that column is already there. You do not need to run that query again.

[calvinnguyen]

Originally Posted by Boofo

That error means that column is already there. You do not need to run that query again.

I don't know what the heck exactly wrong with my database. It keeps give me a message that:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


I HAVE READ THIS INTRUCTION FOR MANY TIMES EVEN I got sucessful when Run SQL query/queries on database.
From tnguy3n told me for his help, but it is still not working..
What is exactly wrong about it.

[tnguy3n]

Originally Posted by calvinnguyen

I don't know what the heck exactly wrong with my database. It keeps give me a message that:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


I HAVE READ THIS INTRUCTION FOR MANY TIMES EVEN I got sucessful when Run SQL query/queries on database.
From tnguy3n told me for his help, but it is still not working..
What is exactly wrong about it.

Run this query:

 UPDATE `forum` SET `showthanks` = '1', `showthanks_date` = '1' ;

[calvinnguyen]

Originally Posted by tnguy3n

Run this query:

 UPDATE `forum` SET `showthanks` = '1', `showthanks_date` = '1' ;

I run this query already, but the problem is the same.

[tnguy3n]

I tested this on my localhost and it seemed to work fine. I think I got that "No Permission Message" too, but then I updated that "thank you" option for forums (by running that query) and i got it to work.
(hey, i noticed you got the same last name as mine )

[VitroX]

Originally Posted by VitroX

this is a great hack.

how about adding the total pple who thank the thread starter?

something like:

5 Users already said Thank You!:

username1, username2, username3, username4, username5

it would fit better for my forum.

Thanks for your work!

How do I add a counter to show the total number of members who made the "Thanks"??

Thanks

[VBDev]

I'll do it Vitrox