View Single Post
  #74  
Old 03-27-2005, 11:45 PM
Joe Pimms Joe Pimms is offline
 
Join Date: Jan 2005
Location: Canada
Posts: 95
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by n_i_t_r_o_u_s
this is a great hack, is it possible to port it to 3.0.6?

here's the error i get when calling it up:

Database error in vBulletin 3.0.6:

Code:
Invalid SQL: 
		SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
			thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
			user.username, thread.open, attachment.userid
		FROM wwwtoke_attachment AS attachment
		LEFT JOIN wwwtoke_post AS post ON (post.postid = attachment.postid)
		LEFT JOIN wwwtoke_thread AS thread ON (post.threadid = thread.threadid)
		LEFT JOIN wwwtoke_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
		LEFT JOIN wwwtoke_user AS user ON (attachment.userid = user.userid)
		WHERE attachment.userid = 1
			AND ((forumid IN (,3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,14,15,21,22,23,24,25,26,27,28) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
		ORDER BY attachment.attachmentid DESC
		LIMIT 0, 10
	
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,

mysql error number: 1064
i get the same type of error to here is my error :
PHP Code:
Database error in vBulletin 3.0.7:

Invalid SQL
        
SELECT thread.forumidpost.postidpost.threadid AS p_threadidpost.title AS p_titlepost.dateline AS p_datelineattachment.attachmentid,
            
thread.title AS t_titleattachment.filenameattachment.counterattachment.filesize AS size, IF(thumbnail ''01) AS hasthumbnail,
            
user.usernamethread.openattachment.userid
        FROM attachment 
AS attachment
        LEFT JOIN post 
AS post ON (post.postid attachment.postid)
        
LEFT JOIN thread AS thread ON (post.threadid thread.threadid)
        
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid deletionlog.primaryid AND type 'post')
        
LEFT JOIN user AS user ON (attachment.userid user.userid)
        
WHERE attachment.userid 1
            
AND ((forumid IN (,1,2) AND thread.visible AND post.visible AND deletionlog.primaryid IS NULL) OR attachment.postid 0)
        
ORDER BY attachment.attachmentid DESC
        LIMIT 0
10
    
mysql error
You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlo

mysql error number: 1064 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01129 seconds
  • Memory Usage 1,798KB
  • 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
  • (1)bbcode_code
  • (1)bbcode_php
  • (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