Advanced File Archive Beta

[erdem]

What it does ?
This hack is integration of pafiledb to vbulletin.
Its complete new code. Nothing imported from pafiledb.
Currently this hack is working without any problem.
But there is some little template issues and other things mentioned at " Known Issues " section.

Install this hack to your test machine.
And test it for every stiuations.

Current Version : 1.0 Final

UPDATE : Final Released! Discussions/Support on this hack will be in https://vborg.vbsupport.ru/showthread.php?s=&threadid=45454 Please visit this url for anything related with this hack. Beta Support Ended.

Features :
-> Search (via date, via viewcount, via name and more)
-> Letter view
-> Perpage display
-> Subcats
-> User file submissions
-> Forum per category
-> Thread per program (if category forum selected)
-> Custom userfields
-> Moderate files
-> Easy admin panel
-> Archive stats
-> Installer - UnInstaller
-> And more :p

How to use ?
- Upload filesadmin.php to your forum admin dir.
- Upload files.php to your forum dir.
- Access filesadmin.php and then click install.
- Add categories , files , custom fields.

Feature Requests :
Current version is in feature freeze mode.
So i need feedback from this version.

What i want from you?
Allright i want full system test from testers.
Full feedback.
Security check.
Functions check.
Speed check.
Does it f*ck server ?
And so ..

Screen Shots?
Sorry i cant provide a test server cuz i have only one license ;)
anyway here is some screen shots : https://vborg.vbsupport.ru/attachment.php?s=&postid=318089

Greetz
Erdem
:bunny:

[Chris M]

Sounds good!:)

I might install it later on my test boards;)

Satan

[erdem]

allright ...
admin panel is alittle complicated but ermm once you learn it , it will be easy to navigate ..
also pls report everything on this ..
greetz

[Crinos]

SO how do we "install" this? Just create an /adfa folder in the server, upload the files, and run it?

[Dean C]

Screenies?

Regards

- miSt

[SaintDog]

I would be very interested if I knew what it looked like ;). Please post a few screenshots, it could be the next part of vBulletinTemplates, PaFileDB is a pain to update when you have so much to add.

[madhouse]

Just tested it on my local machine and truthfully I think I will be waiting for this to be improved.

Dont like the idea really to have to go to another admin file and login to make changes to it.

Here is the first error i got from it...

[erdem]

Originally posted by Crinos
SO how do we "install" this? Just create an /adfa folder in the server, upload the files, and run it?

upload filesadmin.php to ur forum admin dir.
files.php to your forum main dir.
then access filesadmin.php from browser.
it has its own installer and uninstaller ..

screen shots will be here ..
greetz

[Velocd]

Interesting ;)

I'll await the screens until I consider an installation.

[erdem]

allrigt here some of the screens ...

[erdem]

any report?
idea or anything?
;)

[erdem]

allright ..
status update :
file submissions , category additions become easier with dropdown menus . You can easly add files and cats with those dropdown menus ..

also i will add stats page to script . top 10 files , most viewed , last added and so ..

i will post new zip when its ready ..
till then any error?

[The Ghost]

hey, sounds very good, i searched long for that......

I wait until the file is really ready.....

thx in advance!

[iLLiMeNTaL]

I get the same error as mentioned above with the login thing. Dont even know how to get into the script, cause even if i login it doesnt allow me to look at anything the script offers.

[erdem]

Originally posted by iLLiMeNTaL
I get the same error as mentioned above with the login thing. Dont even know how to get into the script, cause even if i login it doesnt allow me to look at anything the script offers.

hi ...
try reuploading corrected files ...
to view files you have to be logged in ..

also login to ur admin panel than access filesadmin.php via $bburl/admin/filesadmin.php

create cats , subcats files than try to access again ..

greetz

[uaealam]

i can't login to view any cat

!!!

[erdem]

beta 2 submitted ..
redownload the zip file ..
greetz

[Limpkinw]

When I submit through the admin CP all seems well, however when I submit from files.php and approve i get the following

Invalid SQL: SELECT * FROM files WHERE fileid= AND open=1
mysql error: You have an error in your SQL syntax near 'AND open=1' at line 1

mysql error number: 1064

Date: Monday 04th of November 2002 11:30:06 AM
Script: http://www.limpkinw.com/forum/forum/files.php?action=viewfile&f=
Referer: http://www.limpkinw.com/forum/showthread.php?s=&threadid=839
Am I not approving the files correctly?

Also it seems as if in the file "edit" feature of admin CP that it has the submitter and the thread mixed up.

Also upon editting a file it submits a new thread instead of editing the previous, seems well not right?

Good work just giving ya feedback!

[Limpkinw]

Limpkinw.Com - File Archive
Limpkinw.Com - File Archive Message !
You reach this page because of an error.
The error can be;
-> You cannot add a file to our database. You have to be active user to be able to add a file to our database. Login below, or if you are not a registered member, click Register Now to begin the registration process.
-> You try to access not-existing file/cat.
-> The category you browse into is empty.
-> You dont have access to view cat/file.
If you are logged in, you might have to first activate your account via the activation code you receive in your emailbox on signup, please activate your account first.


When trying to browse an empty catagory I get the above error and a login prompt. Perhaps a better response would be a template state the catagory is empty.

Great work I really hope this one turn out well I need it!

[erdem]

Originally posted by Limpkinw
Limpkinw.Com - File Archive
Limpkinw.Com - File Archive Message !
You reach this page because of an error.
The error can be;
-> You cannot add a file to our database. You have to be active user to be able to add a file to our database. Login below, or if you are not a registered member, click Register Now to begin the registration process.
-> You try to access not-existing file/cat.
-> The category you browse into is empty.
-> You dont have access to view cat/file.
If you are logged in, you might have to first activate your account via the activation code you receive in your emailbox on signup, please activate your account first.


When trying to browse an empty catagory I get the above error and a login prompt. Perhaps a better response would be a template state the catagory is empty.


Great work I really hope this one turn out well I need it!

allright its a silly wrong userpermission coding ..
i fixed it ..
redownload the file and install ..
also some more bugs fixed again ..
u have to login to view cats files and hole script..

greetz

[erdem]

Originally posted by Limpkinw
When I submit through the admin CP all seems well, however when I submit from files.php and approve i get the following

Invalid SQL: SELECT * FROM files WHERE fileid= AND open=1
mysql error: You have an error in your SQL syntax near 'AND open=1' at line 1

mysql error number: 1064

Date: Monday 04th of November 2002 11:30:06 AM
Script: http://www.limpkinw.com/forum/forum/files.php?action=viewfile&f=
Referer: http://www.limpkinw.com/forum/showthread.php?s=&threadid=839
Am I not approving the files correctly?

Also it seems as if in the file "edit" feature of admin CP that it has the submitter and the thread mixed up.

Also upon editting a file it submits a new thread instead of editing the previous, seems well not right?

Good work just giving ya feedback!

allright ...
you have to access filesadmin.php from your admin panel ... than click install if you didnt installed yet .. but i think first uninstall , if you installed it b4 , than choose install.
after that add files cats and so ..

greetz

[Limpkinw]

I still receice a login prompt when visiting files.php while logged in if I have no files in the file area yet.

And files uploaded through files.php when approved only give the following as a link

http://www.limpkinw.com/forum/files.php?action=viewfile&f=

Missing the file number at the end.

[erdem]

this is a error msg man :)
it covers all the errors in one message window :)
you have to have atleast one file or cat to view that category ..

greetz

[Limpkinw]

I really am not trying to be a pain I just want this to work :)

The following screenshot is what appears when I approve a file trough moderate.

Notice how the thread has no "thread starter" and "last post by" is blank.

I am not sure this is an error, just asking is this right?

[erdem]

allright progy still have permission errors ..
i mean i can view the cat archive :)
urs @ : http://www.limpkinw.com/forum/files.php

also some sanity check errors at admin panel ..
i will look into them also ..

other than what u think on script ?
usage and uhmm overview ..
greetz

[erdem]

Originally posted by Limpkinw
I really am not trying to be a pain I just want this to work :)

The following screenshot is what appears when I approve a file trough moderate.

Notice how the thread has no "thread starter" and "last post by" is blank.

I am not sure this is an error, just asking is this right?

download new zip file ...
i think u have old one ..
i noticed that also and updated zip file :)
greetz

[Limpkinw]

I think I have the latest version I will retry the download. I think this will be one of the best hacks for me personally as my forum was originally developed for distribution of programs.

Thank you!

[erdem]

uhmm there is a naughty permission error ..and this makes me sick!
anyway the admin panel should be fixed ..
i will re-re-recheck again ..

[Limpkinw]

I still receive both errors on the admin cp when approving a file.
Am I approving incorrectly?

Error #1

http://www.limpkinw.com/forum/forum/files.php?action=viewfile&f=
(No file number)

Error #2
No Posted By

[erdem]

Originally posted by Limpkinw
I still receive both errors on the admin cp when approving a file.
Am I approving incorrectly?

Error #1

http://www.limpkinw.com/forum/forum/files.php?action=viewfile&f=
(No file number)

Error #2
No Posted By

nope you are right after some couple of tests i figured out the errors ..
pls wait for beta 3 ..
uhh i made real bad mistake :(
anyway i hope it will be done soon ..

greetz

[Limpkinw]

If you need any help testing let me know...it is up in current format on my board. Just put it back up.

[erdem]

Beta 3 released ..
Upload corrected files and re-test the hack ..
All the code issues should be resolved now ..
Any feedback on templates/codes/bug reports will be great
Tnx
Erdem

[erdem]

if anyone gets login prompt problem ...

open files.php :

find$bbuserinfo[usergroupid]
and replace all occurance with$bbuserinfo['usergroupid']

and than retry ...
greetz

[erdem]

Originally posted by erdem
if anyone gets login prompt problem ...
open files.php :
find$bbuserinfo[usergroupid]
and replace all occurance with$bbuserinfo['usergroupid'] and than retry ...
greetz

allright zip updated u dont need to edit code from now ..
currently it checks for if users logged in .. else it show error message ..

i need testers for beta 3 ..
i need all types of reports to release final edition soon ..

greetz

[Limpkinw]

This version is pretty good still testing some stuff out...one suggestion, make the "link" for files clickable.

One bug...When editing files already approved the link for the thread seems to disapear.

Will give more feedback upon arrival.

[erdem]

Originally posted by Limpkinw
This version is pretty good still testing some stuff out...one suggestion, make the "link" for files clickable.

One bug...When editing files already approved the link for the thread seems to disapear.

Will give more feedback upon arrival.

your suggestion can be made via :
open files.php;
find :$fileurl=$myrow["fileurl"];
replace with :$fileurl=$myrow["fileurl"];
if($fileurl==""){$fileurl="Download URL Not Available";}else{$fileurl="<a href=\"$fileurl\">$fileurl</a>";}

i will check the bug report ..

[erdem]

Originally posted by Limpkinw
One bug...When editing files already approved the link for the thread seems to disapear.

i need more info on this ...
i didnt get anything like this :surprised:

[erdem]

Originally posted by erdem


i need more info on this ...
i didnt get anything like this :surprised:

bug found and resolved ...
open filesadmin.php;
find : (line 1222+- in doef function)
$threadid=0;
replace with :$threadid=$filepo;
greetz

[erdem]

one more bug found and fixed ..
bug fixed version zipped and the file at first post renewed ..

greetz

[Limpkinw]

New version looks really good...I'm starting to run out of bugs lol. I think soon enough its gonna be past beta.

Will give feedback.

[erdem]

yep i think so but as you see i got some silly errors ..
and i dont want to see any at final phase ;)

anyway tnx for ur help ..
keep on testing ;)

[Limpkinw]

I found adding the following to my admin/index.php was very helpful. Nothing fancy but helpful.

After

makenavoption("New Posts","../mod/moderate.php?action=posts","<br>");
makenavoption("New Attachments","../mod/moderate.php?action=attachments");
makenavselect("Moderation","<hr>");
// *************************************************


Add


//File Manager
makenavoption("Manage Custom Fields","filesadmin.php?action=cfview","<br>");
makenavoption("Add Custom Field(s)","filesadmin.php?action=addcf","<br>");
makenavoption("Manage Catagories","filesadmin.php?action=catview","<br>");
makenavoption("Add Catagorie(s)","filesadmin.php?action=addcat","<br>");
makenavoption("Manage Files","filesadmin.php?action=fileview","<br>");
makenavoption("Moderate File(s)","filesadmin.php?action=mfiles","<br>");
makenavoption("Add File(s)","filesadmin.php?action=addfile","<br>");
makenavselect("File Manager","<hr>");
//End File Manager
// *************************************************


Hope that's right :)

[erdem]

it seems right ;)
i thought posting that via final release would be good .. anyway :)

any other bug ?
test in every condition ..

[Limpkinw]

I am trying to get some users to "upload" files so i can moderate them.

Will let you know any results.
So far its very good.

[Graphics]

i luv this hack and i am not going to install onmy forums until you got the final released

[erdem]

allright it seems the Beta 4 will be the last release before final.
i need a template fixer ..
as i have two known visual problem :
-> in admin panel ; there is an space between main cat and its first subcat ..
-> in file view ; (if the file has a thread) there is a unwanted row height at the "rate thread drop-down" row.

after fixing template issues and final test i will release final ...
greetz

[Limpkinw]

Because I did not want to drop my files database (even though it is small) I tried to do a manual edit of these templates.
However, I can not find them. Are they hidden in an area other than templates?

Thanks!

[erdem]

for fixing the rate file template :

open file_threadexist template:
find :
<form action="threadrate.php" method="get">
replace with:
<form style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px" action="threadrate.php" method="get">

the other silly spaces between cats-subcats visual problem in admin cp can not be resolved ..
atleast i couldnt find any solution ;)

anyway that isnt a bug or problem ..

i think its time to release final ...
im on last tests ..
report anything you got as a error or so ...

greetz

[erdem]

Final Released !
From Now Discussions on this file will be at

https://vborg.vbsupport.ru/showthread.php?s=&threadid=45454

Thread Closed
Greetz
:bunny: