vb.org Archive - Files List v3.01

Page 7 of 22

« First

Last »

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Files List v3.01 (https://vborg.vbsupport.ru/showthread.php?t=64734)

DWard

05-08-2004 07:01 PM

Quote:

Originally Posted by SmartGnome

I only changes the two templates and uploaded the new php file

Got this error now, the old version did work:

Code:

Database error in vBulletin 3.0.1:



Invalid SQL: SELECT * FROM vb3_attachment LEFT JOIN user ON (user.userid = attachment.userid) ORDER BY filename asc LIMIT 0, 30

mysql error: Table 'adfs_nl_-_vbgold.user' doesn't exist



mysql error number: 1146



Date: Saturday 08th of May 2004 09:55:28 PM

Script: http://anita.adfs.nl/forum/fileslist.php?

Referer: 

Username: SmartGnome

IP Address: 62.100.24.35

With the earlier version you gave me another filelist.php cause of same sort of probs.

Thanks Dan.

yer i see the problem, 2mins

DWard

05-08-2004 07:04 PM

OK, i updated the actual ZIP file, but there is the fileslist file:

DWard

05-08-2004 07:06 PM

tel me if that works plz

SmartGnome

05-08-2004 07:11 PM

Quote:

Originally Posted by DWard

tel me if that works plz

Great !! Works fine now with the usernames at the end :laugh:

Hope for the far future there will be also the forum title there :grins:

Tnx Dan

DWard

05-08-2004 07:48 PM

I'm working on it :)

DWard

05-08-2004 07:53 PM

SuperGnome... please do this when you have some free time, it makes sure the next button is all on one line in your fileslist page number block:

https://vborg.vbsupport.ru/showpost....3&postcount=40

Boofo

05-08-2004 07:55 PM

Quote:

Originally Posted by DWard

I'm working on it :)

DWard, I have fixed your file. You really had some things messed up in it, sorry to say. You CAN'T put table prefixes on userid variables. This:

PHP Code:


		
			
$attachment_data = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."attachment LEFT JOIN ".TABLE_PREFIX."user ON (".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."attachment.userid) ".$soundclips_filetypes." ORDER BY ".$sorttype." asc LIMIT " . ($minlimit-1) . ", $perpage");
}

Should be this:

PHP Code:


		
			
$attachment_data = $DB_site->query("
SELECT * FROM ".TABLE_PREFIX."attachment AS attachment
LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = attachment.userid) ".$soundclips_filetypes."
ORDER BY ".$sorttype." ASC
LIMIT " . ($minlimit-1) . ", $perpage");

And also, anytime you query more than one table in a query, ALL tables have to have the table AS table to it when someone has a table prefix in their db.

Here is the updated file.

DWard

05-08-2004 07:59 PM

I know its all over the place, it works, just need to get smartgnome to try out the new file to make sure it works, because the fixed file is how it was before i changed it, and supregnome had problems with that.

I promised everybody that I would get the cod out by 2night so I had to post it pretty much how it was :)

Boofo

05-08-2004 08:01 PM

Quote:

Originally Posted by DWard

That's because he has a table prefix and you need to use the table as table in queries with more than one table.

Natch

05-09-2004 04:49 AM

Quote:

Originally Posted by DWard

ATTACHMENT THUMBNAILS FOR IMAGES IN THE FILELIST
Preview for next version: http://www.collegepranks.co.uk/forums/fileslist.php

Wasn't this version going to include Thumbnailed Images ??

It's a great hack - but this was what I was waiting for (installed today and it's not there) ... I don't wanna +++++ (by any means) but was just wondering if it might have been an oversight ...

All times are GMT. The time now is 01:46 AM.

Page 7 of 22

« First

Last »

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

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