vb.org Archive - Show Thread Enhancements

Page 3 of 5

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Show Thread Enhancements - [AJAX] Post Groan Hack (https://vborg.vbsupport.ru/showthread.php?t=255226)

Welshy2008

01-25-2011 01:44 PM

What on earth is the error below, and how do I correct it, Please?

Code:

Database error in vBulletin 4.0.7:



Invalid SQL:



SELECT post_groan.postid AS postid

FROM vbpost_groan AS post_groan

LEFT JOIN vbpost AS post USING (postid)

INNER JOIN vbthread AS thread ON(thread.threadid = post.threadid)

WHERE post_groan.userid = 5405

AND thread.forumid IN(68,3,4,75,19,77,62,78,50,34,5,6,32,27,10,29,30,70,74,11,33,71,9,16,24,13,15,69,64,17,18,67,51,61,40,41,52,14,53,54,55)

ORDER BY post.dateline DESC

LIMIT 1000;



MySQL Error : Table 'my_database.vbpost_groan' doesn't exist

Error Number : 1146

Request Date : Tuesday, January 25th 2011 @ 10:01:26 AM

Error Date : Tuesday, January 25th 2011 @ 10:01:26 AM

Script : http://www.myforum.com/post_groan.php?do=findgroans_user_gave&u=5405

Referrer : 

IP Address : 66.249.66.104

Username : Unregistered

Classname : vB_Database

MySQL Version :

BANDiT600

03-10-2011 01:33 PM

Thanks, works with 4.1.2

Phaedrus

03-16-2011 04:34 AM

Crap, they don't integrate like they did in 3.8... Whatever happened to Abe1?

Phaedrus

03-24-2011 12:55 AM

Okay... After many hours, I think I fixed it. They integrate and everything. If you are using the reputation option, use a negative number for groans as I didn't want to search out the right $reputation - $reputation(blah blah) string. It was just easier to use a minus sign in the settings. I didn't change any of the phrases. You get what you get...

:D

And yes, the author can take my fixes and improve upon them, anybody can use them and enjoy. Thanks/Groans integrate and act like pals on my site now. Man, there are a lot of groan/groans in that script and I had to use the right one in the right place...

BTW - Uninstall the previous version then install this one, for some reason overwriting causes one of the tables in the database to duplicate.

sulasno

03-24-2011 01:53 AM

thanks;
can you post the Thanks fixed as well ?

Phaedrus

03-24-2011 02:44 AM

I don't remember fixing that one. Was there something wrong with it? It's been a long few nights...

Phaedrus

03-24-2011 02:45 AM

I'm pretty sure that Thanks was right to begin with, Groans needed to be fixed for integration and a couple variable mismatches. Yeah, and it appears as if somebody already uploaded one for "4.1.2", the only fix necessary was to change the version maximum on the xml file though, so I hope he didn't change much of the code. I like the integration.

combs

03-30-2011 04:18 PM

Is there a way to stop people from groaning and saying thanks to the same post.

Also, a way to change the backgrounds of just the thanks/groans?

Phaedrus

04-02-2011 04:48 AM

Hold on... I'm testing an integrated groan/thanks on my board right now. I think I've finally solved some of the issues I was having previously with it and will upload it soon.

hoadiem

04-02-2011 11:16 PM

vb 4.1.2

how do i fix this issue:

Thanks: 2
Thanks 2 Times in 2 Posts0 ( where the 0 should be on Groans line)
Groans :
---------->Groaned 1 Time in 1 Post

should be looking like this:

Thanks: 2
Thanks 2 Times in 2 Posts
Groans : 0
Groaned 1 Time in 1 Post

All times are GMT. The time now is 11:19 AM.

Page 3 of 5

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01150 seconds Memory Usage 1,732KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: