Add-On Releases - BFC-Download

ALL MODS HAVE GONE BACK TO STEVE M AS I AM NOT MEANT TO CODE LIKE I CURRENTLY AM DOING.

[Piratos]

Another error in Files Awaiting Approval

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT COUNT(file_id) as fcount FROM download WHERE moderated = '1';

MySQL Error : Unknown column 'moderated' in 'where clause'
Error Number : 1054
Request Date : Tuesday, April 28th 2009 @ 07:47:22 PM
Error Date : Tuesday, April 28th 2009 @ 07:47:23 PM
Script : http://www.xxx.com/admincp/download.php?do=modfiles
Referrer : http://www.xxx.com/admincp/index.php?do=nav
IP Address :
Username : Pir@tos
Classname : vb_database
MySQL Version : 5.0.51a-log

[Piratos]

/screen.php

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT stype,sdata FROM download_screenshots WHERE sid=;

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 '' at line 1
Error Number : 1064
Request Date : Tuesday, April 28th 2009 @ 07:51:14 PM
Error Date : Tuesday, April 28th 2009 @ 07:51:14 PM
Script : http://xxx.com/screen.php
Referrer :
IP Address :
Username : Pir@tos
Classname : vb_database
MySQL Version : 5.0.51a-log

[Piratos]

i updated usergroup permessions but still not see Upload file link

[Excalibur82]

Ok I got class right now, as soon as I get home from class I will get those 2 issues fixed and updated.

[Piratos]

Thank you bro, i ask if you make the main page display all the files, and remove [Download Area] navigation! and also add the upload files through the main page that's will be kool, like an Upload center ;-)

Kindest Regards,
Pir@tos

[Excalibur82]

Piratos: Great suggestions, I will implement those for next release.

[Piratos]

Thank you bro, i've many ideas and some templates to edit can make you mod the best


Regards

[Excalibur82]

Piratos: Don't be afraid to sign up at my site once it's open and submit all your ideas/suggestions.

[Piratos]

No worry bro with pleasure

[Excalibur82]

Piratos: Are you trying to access screen.php? If so you'll get that error as its trying to grab an id number but without one it errors out. Check to see if you can see the Upload File link now. Make sure you import the bfc_download product xml with Overwrite set to YES.

EDIT: Nevermind what I said above regarding the Upload File link. I know the problem, I'll release a fix for it once I've woke up.

Updated the zip file to fix your first error.