vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=231666)

BrightStar 07-28-2010 02:06 PM

Quote:

Database error in vBulletin 4.0.5:

Invalid SQL:

SELECT post_thanks.postid AS postid
FROM _forumpost_thanks AS post_thanks
LEFT JOIN _forumpost AS post USING (postid)
INNER JOIN _forumthread AS thread ON(thread.threadid = post.threadid)
WHERE post_thanks.userid = 29
AND thread.forumid IN(3,4,5,28,34,35,36,37,38,6,39,7,9,8,13,22,23,32, 43,42,40,41,10,11,12,18,29,19, 21,31,17,30,20,14,16,25,33,26,27,15,24)
ORDER BY post.dateline DESC
LIMIT 1000;

MySQL Error : Table 'homeforum_forum._forumpost_thanks' doesn't exist
Error Number : 1146
Request Date : Tuesday, July 27th 2010 @ 01:08:19 PM
Error Date : Tuesday, July 27th 2010 @ 01:08:19 PM
Script : http://www.homeforum.org/forum/post_...user_gave&u=29
Referrer :
IP Address : 195.62.212.79
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.90-community
Any idea how to fix the error after uninstalling this mod?

Thanks

coloradomoms 07-28-2010 06:38 PM

is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

djbaxter 07-28-2010 07:00 PM

Quote:

Originally Posted by coloradomoms (Post 2075896)
is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

Eewwwww..... :eek:

midnz 07-28-2010 08:04 PM

Quote:

Originally Posted by djbaxter (Post 2075905)
Eewwwww..... :eek:

http://img818.imageshack.us/img818/3642/giggle.gif

Quote:

Originally Posted by coloradomoms (Post 2075896)
is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

Yes but you'd have to go through each file and change all of the references from thanks to hugs before installing.
A mate of mine edited an earlier version of Post_Thanks to give us a Post_Lol hack on vB 3.6. I've tried to do the same with this current version of Post_Thanks but viewers were unable to view the username of those who had Lol'd their posts for some reason. Apart from that everything else worked as it should. I'm still trying to work it out for myself :confused:.

coloradomoms 07-28-2010 08:22 PM

I know, but I run a board for moms and we like to hug a lot. LOL

I tried it but it just changed all thanks to hugs, not installing it twice, just over writing it. Not a big deal. I tried installing the other thanks/like hack but it annihilated my admincp. Just got that back working and leaving it with this hack once for now.

Thanks!

sulasno 07-29-2010 12:47 AM

is it possible to run a query to determine who has given and receive 100 Thanks?

JIMBOND27 08-02-2010 02:24 AM

Would I be able to put the "thanks" on the right side of the posts, so it is more visible?

Afsoul 08-11-2010 07:25 PM

Quote:

Originally Posted by JIMBOND27 (Post 2077942)
Would I be able to put the "thanks" on the right side of the posts, so it is more visible?

Yeah I have the same thoughts with JIMBOND2, can we put the "thanks" on the right side of posts?:confused:

Thx before :)

vivamexico55 08-12-2010 09:46 PM

Getting an error on 4.06

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 12th 2010 @ 05:45:08 PM

Classname : vB_Database
MySQL Version : 5.0.85-community

Victor S 08-16-2010 06:48 AM

Quote:

Originally Posted by vivamexico55 (Post 2082906)
Getting an error on 4.06

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 12th 2010 @ 05:45:08 PM

Classname : vB_Database
MySQL Version : 5.0.85-community

It works fine on 4.0.5 for me. Can anyone else confirm that it actually breaks with 4.0.6...?


All times are GMT. The time now is 02:39 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03753 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete