vb.org Archive - Files List v3.01

Page 15 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)

Boofo

05-24-2004 07:00 PM

Quote:

Originally Posted by DWard

I'll bear it in mind for the next version, it should be easy to do (within reason) but if not, maybe somebody else can help you on that one. For the permission side of things, i'm not too familiar with at the moment.

You know, Dan, all you ever would have had to do was ask. I have helped you with straightening out the queries along the way and you never once gave even a simple thank you. I have no problem with lending a hand if you need it, you just need to ask and maybe even appreciate it once in a while. We could make this one hell of a hack. ;)

DWard

05-24-2004 07:08 PM

Quote:

Originally Posted by Boofo

Yer well cheers for the previous help, I'm just a bit taken with my other hack as well now, so its getting a bit difficult at the moment, what with coursework and everything.

Aurous

05-24-2004 07:54 PM

OK, my thanks to all of you who worked on this! Especially Scrub, who actually came up with this hack in the beginning. (Oh and not to forget, I was the one who actually asked for this hack :D)

Boofo, I got your PM, looking fwd to your help with my issue.

Thanks.

Aurous

DWard

05-24-2004 08:07 PM

Hopefully one day I will be good enough to create a hack from scratch, but I hope you will all agree I have developed the script of Scrubs very well?

I'm happy with myself so far, considering I have only had vBulletin for about 3 months.

Smitty

05-24-2004 08:20 PM

Quote:

Originally Posted by Ronin Six

Great work DWard!

Not sure if it's because I'm not logged in (do you have a test user I can log in as?), but I get errors when I try to sort by user.

I noticed that earlier today:

Code:

Database error in vBulletin 3.0.1:



Invalid SQL: 

        SELECT * FROM attachment AS attachment

        LEFT JOIN user AS user ON (user.userid = attachment.userid)

        INNER JOIN post AS post ON (attachment.postid = post.postid)

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

        INNER JOIN forum AS forum ON (thread.forumid = forum.forumid) WHERE filename LIKE '%.gif' OR filename LIKE '%.jpg' OR filename LIKE '%.jpe' OR filename LIKE '%.jpeg' OR filename LIKE '%.bmp' OR filename LIKE '%.png' OR filename LIKE '%.psd'

        ORDER BY username ASC

        LIMIT 0, 400

mysql error: Column: 'username' in order clause is ambiguous



mysql error number: 1052



Date: Monday 24th of May 2004 08:38:49 AM

Script: http://elsmar.com/Forums/fileslist.p...name&pageamt=4

Referer: http://elsmar.com/Forums/fileslist.p...name&pageamt=4

Username: Marc

Scrub

05-24-2004 08:55 PM

Coming along nicely DWard. ;). LOL

Boofo

05-24-2004 09:09 PM

Quote:

Originally Posted by DWard

Just remember, Dan, some of the best hacks ever released were done by more than one person. A little help once in a while doesn't hurt or take anything away from anyone. Sometimes others can spot the little things we miss. God knows I've missed my share of the little things and make more than my share of mistakes where soemone has helped me out. More often than not. ;)

DWard

05-25-2004 04:55 AM

BUG FIX FOR USERNAME SORT

Either download the zip from the first post and use the new fileslist.php file or open your fileslist.php and do this:

Find:

Code:

$sorttype = 'username';

Replace with:

Code:

$sorttype = 'user.username';

Smitty

05-31-2004 07:55 AM

Thanks for the fix! I really like this 'hack' and appreciate your sharing it.

Aurous

06-07-2004 07:45 PM

any luck with file permissions? I would like non-registered users to see the page but not be able to download the attachments. There should be a way to fix this. This will only help promote sites that deal with files and non-registered users can see what they will expect from the site before signing up!

All times are GMT. The time now is 07:36 AM.

Page 15 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.01278 seconds Memory Usage 1,745KB 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 (3)bbcode_code_printable (4)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: