View Single Post
  #48  
Old 08-31-2007, 07:38 PM
phill2003 phill2003 is offline
 
Join Date: Apr 2003
Posts: 217
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by yotsume View Post
Hi,

Nice start of a hack... It's off to a good start... that fact that you have to exclude categories for this to work is a super glitch in my book because I don't want any of my categories excluded!!!

So what I did to fix this is put a fake category number in and poof it works perfect! So if you have the problem with this error:

Unknown column 'xxx' in 'where clause'

Just put in: $cat_exclusions = '1,2' (line 11 in my file)

Then the module will work without that error and all categories will show comments.

This module looks pure ugly in my side columns in my CMPS. I have to have it in my center. I am working out how to set this up in a column that will not look pure ugly. I will post screen shots and how to do with clear instructions once I get it worked out.

Yep or it could be that I wanted to exclude cats from showing If you dont want to exclude anything just remove

Code:
$cat_exclusions = 'xxx,xxx';
from about line 10 and change

Code:
WHERE cat NOT IN ($cat_exclusions) AND comment != ''
to
Code:
WHERE comment != ''

But if you want to put false cat numbers in to fix a non existent problem go right ahead


Oh and as it looks pure ugly you probably wont want to use it so if thats the case you may want to release one you code so others can come and say to you

"Hey this is crap looks rubbish is not finished but i will use it anyway"
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01339 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete