View Single Post
  #394  
Old 01-16-2002, 12:48 PM
WildWayz WildWayz is offline
 
Join Date: Oct 2001
Location: United Kingdom
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by fastforward

Line breaks work for me. I have also been unable to reproduce your other error. What platform are you on?

To verify that the script is sending things to usenet, run this query immediately after you post a thread. Substitute '$$newsgroup->{forumid}' with the forumid in which the thread was posted.
Code:
SELECT e.csig,
       b.email, 
       b.showemail, 
       b.signature, 
       a.threadid, 
       a.postusername, 
       a.title, 
       d.newsgroup 
  FROM thread AS a, 
       user AS b, 
       usergroup AS c, 
       usenet_group AS d, 
       userfield AS e 
  WHERE a.visible=1 
    AND forumid=$$newsgroup->{forumid} 
    AND a.postuserid=b.userid 
    AND b.usergroupid=c.usergroupid 
    AND b.userid=e.userid 
    AND a.isusenetpost=0 
    AND a.forumid=d.forum;
Hi ya

I am on RedHat 7.0, PHP4.1.0, MySQL 3.23.45

When I run the query, it doesn't like e.csig so I removed it and it outputted this....
Code:
email  showemail  signature  threadid  postusername  title  newsgroup  
james@dvd-critic.net 1 <center><table width="95%" height="10" bgcolor="#3... 353 James@DVD-Critic OT: Test post uk.media.dvd
--James
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01256 seconds
  • Memory Usage 1,765KB
  • 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
  • (2)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