[DEV] Pafiledb [DOWNLOAD MOD] 0.0.9d

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Locked
numarc
Registered User
Posts: 40
Joined: Mon Mar 24, 2003 10:18 am

Post by numarc »

Mhhh... I don't have this files :? The Download-Link for the Full-Packet is down ... does anybody has an Idea where I can download all the Files for this MOD (0.0.9b) :wink:

Thanks in advance :D
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

McLR wrote:
carloclaessen wrote:Click here for download

My server is moving so there can be a delay with the downloads or that they dont work at all, i have stalled them on the new server but there is still work on it!!!

tnx


This is the version I downloaded and installed.
numarc
Registered User
Posts: 40
Joined: Mon Mar 24, 2003 10:18 am

Post by numarc »

Fearless wrote:
McLR wrote:and when i uploaded some file i have an error when i entering the download page :

Code: Select all

Couldnt Query Files info

DEBUG MODE

SQL Error : 1054 Unknown column 'cat_last_file_time' in 'field list'

UPDATE phpbb_pa_cat SET cat_last_file_id = '1', cat_last_file_name = 'çãùåú ìôåøèì EZ', cat_last_file_time = '1062940941' WHERE cat_id IN (2)

Line : 292
File : /var/www/virtual/talkt.com/www/mods/pafiledb/includes/functions_pafiledb.php


Have you tried importing the corrected SQL file above ? A series of typos slipped in and one field was missing. Maybe there are some other things missing too that I have overlooked.

Basically, all I did was compare the update SQL files with the one used for a fresh installation to find out what was missing.


I've got the same error :cry:
numarc
Registered User
Posts: 40
Joined: Mon Mar 24, 2003 10:18 am

Post by numarc »

Yessss... I've got it 8) :wink:

Question: How can i delete the "Test Category"? Or how can I reName it? There's another problem... when I download a file, I get a "blank" Page with this error:

Code: Select all


[b]Not Found[/b]

The requested URL /100000000000test.jpg was not found on this server.
:wink:
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

For the moment you have to delete categories manually in the database I'm afraid (category information is stored in phpbb_pa_cat). You can probably rename the Test Category through the Admin Control Panel, though. Also, the upload function doesn't seem to be working properly. Read previous posts for more details. Linking to offsite http:// URLs, as long as they contain a file name at the end, should work.
numarc
Registered User
Posts: 40
Joined: Mon Mar 24, 2003 10:18 am

Post by numarc »

All right ... thank you very much! I think, this bugs will be fixed in the next Version? :D

Now, I linked a file with the URL (http://www.blabla.com/blabla/bla.wmv) ... everything is ok ... I don't get the "blank-site" ... but in the Categories overview ... ähm ... it don't show the file. It alway's shows "zero"...but there is a file in there :wink:

(sorry, my English is not perfect :D )
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

Yes, that information doesn't seem to be updated.
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

Here is my problems with the mod some is allready mentions:

1. When I approve a file in ACP the field file_dlurl in this tabel phpbb_pa_files get a wrong url. The wrong url is www.domain.com/100000000000 .
The URL should be. www.domain.com/[file_dir]/[unique_name]

2. when I go to this my_domain.com/dload.php the cell Files doesn´t show the actuel numbers of files.

3. when you email link to a friend the link is http://www.domain.com/dload.php?action=file&file_id=1 instead of http://www.domain.com/dload.php?action= ... &file_id=1
Last edited by Frold on Tue Sep 09, 2003 10:09 am, edited 1 time in total.
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

Frold wrote: 1. When I approve a file in ACP the field file_dlurl in this tabel phpbb_pa_files get a wrong url. The wrong url is www.domain.com/100000000000 .
The URL should be. www.domain.com/[file_dir]/[unique_name]


Apparently, the file name variable is being concatenated with MAX_FILE_SIZE. This is instead of the path + file name. This value is present as a constant in the following files of the project :

- pa_file_add.tpl.php
- pa_admin_file_add.tpl.php
- pa_admin_file_edit.tpl.php
- pa_file_add.tpl
- pa_admin_file_add.tpl
- pa_admin_file_edit.tpl

With the exception of pa_admin_file_upload.tpl that contains a similar but greater value.
Frold wrote: 3. when you email link to a friend the link is http://www.domain.com/dload.php?action=file&file_id=1 instead of http://www.domain.com/dload.php?action= ... &file_id=1


Here is a problem that appeared with the e-mail function. I compared the URLs that appear after a file has been rated or an e-mail has been sent :

Code: Select all

http://www.awebsite.com/phpBB2/dload.php?action=file&file_id=nn
http://www.awebsite.com/phpBB2/dload.php?action=file&id=nn
As you can see in the second link, the expression that's after the ampersand should be 'file_id'. I think the problem can be fixed as follows :

Change line 147 of pa_email.php :

Code: Select all

...
($lang['Click_return'], '<a href="' . append_sid('dload.'.$phpEx.'?action=file&id=' . $file_id) . '">', '</a>')
...
To :

Code: Select all

...
($lang['Click_return'], '<a href="' . append_sid('dload.'.$phpEx.'?action=file&file_id=' . $file_id) . '">', '</a>')
...
Newest files

Here is a message that appeared when I click on a date to see the files that have been added :

Code: Select all

Couldnt Query stat info

DEBUG MODE

SQL Error : 1064 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 ' 20) AND f1.file_approved = '1' GROUP BY f1.fi

SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name, COUNT(cm.comments_id) AS total_comments FROM phpbb_pa_files AS f1, phpbb_pa_cat AS c LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS cm ON f1.file_id = cm.file_id WHERE c.cat_id = f1.file_catid AND f1.file_id IN (, 20) AND f1.file_approved = '1' GROUP BY f1.file_id ORDER BY file_time DESC

Line : 206
File : /***/public_html/phpBB2/pafiledb/modules/pa_toplist.php
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

Fearless wrote:
Frold wrote:1. When I approve a file in ACP the field file_dlurl in this tabel phpbb_pa_files get a wrong url. The wrong url is www.domain.com/100000000000 .
The URL should be. www.domain.com/[file_dir]/[unique_name]


Apparently, the file name variable is being concatenated with MAX_FILE_SIZE. This is instead of the path + file name. This value is present as a constant in the following files of the project :

- pa_file_add.tpl.php
- pa_admin_file_add.tpl.php
- pa_admin_file_edit.tpl.php
- pa_file_add.tpl
- pa_admin_file_add.tpl
- pa_admin_file_edit.tpl

With the exception of pa_admin_file_upload.tpl that contains a similar but greater value.


But how did you fixet it?
Frold wrote:3. when you email link to a friend the link is http://www.domain.com/dload.php?action=file&file_id=1 instead of http://www.domain.com/dload.php?action= ... &file_id=1


Here is a problem that appeared with the e-mail function. I compared the URLs that appear after a file has been rated or an e-mail has been sent :

Code: Select all

http://www.awebsite.com/phpBB2/dload.php?action=file&file_id=nn
http://www.awebsite.com/phpBB2/dload.php?action=file&id=nn
As you can see in the second link, the expression that's after the ampersand should be 'file_id'. I think the problem can be fixed as follows :

Change line 147 of pa_email.php :

Code: Select all

...
($lang['Click_return'], '<a href="' . append_sid('dload.'.$phpEx.'?action=file&id=' . $file_id) . '">', '</a>')
...
To :

Code: Select all

...
($lang['Click_return'], '<a href="' . append_sid('dload.'.$phpEx.'?action=file&file_id=' . $file_id) . '">', '</a>')
...


Yes it fixed it! thanks!
Newest files

Here is a message that appeared when I click on a date to see the files that have been added :

Code: Select all

Couldnt Query stat info

DEBUG MODE

SQL Error : 1064 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 ' 20) AND f1.file_approved = '1' GROUP BY f1.fi

SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name, COUNT(cm.comments_id) AS total_comments FROM phpbb_pa_files AS f1, phpbb_pa_cat AS c LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS cm ON f1.file_id = cm.file_id WHERE c.cat_id = f1.file_catid AND f1.file_id IN (, 20) AND f1.file_approved = '1' GROUP BY f1.file_id ORDER BY file_time DESC

Line : 206
File : /***/public_html/phpBB2/pafiledb/modules/pa_toplist.php


I an error that looks like that one.
Couldnt Query stat info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 1) AND f1.file_approved = '1' GROUP BY f1.file_id ORD' at line 7

SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name, COUNT(cm.comments_id) AS total_comments FROM phpbb_pa_files AS f1, phpbb_pa_cat AS c LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS cm ON f1.file_id = cm.file_id WHERE c.cat_id = f1.file_catid AND f1.file_id IN (, 1) AND f1.file_approved = '1' GROUP BY f1.file_id ORDER BY file_time DESC

Line : 206
File : /hotel/studmed/WWW/pafiledb/modules/pa_toplist.php
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

More Errors

when clicking on link on the stats site http://www.domain.dk/dload.php?action=stats

all the links are off this kind:

Code: Select all

http://www.domain.dk/dload.php?action=file&id=2
instead of

Code: Select all

http://www.domain.dk/dload.php?action=file&file_id=2
The new file images have a wrong alt text

Code: Select all

alt="{ New file 	}"
Add one

Hey I would like that all files is auto aproved, how do I do that?
Mohd
Registered User
Posts: 263
Joined: Mon Jul 15, 2002 9:06 pm
Contact:

Post by Mohd »

my site is back
Visit My Site Mohd Web Site!
My Current mod is PaFileDb Integration 0.0.8
Demo: Click Here
No support via PM
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

NICE!!!

when will we see the next realese with fixed bugs?
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

That's nice to hear Mohd :) . Sorry, about the lengthy posts (and other things :roll:). Hope I didn't say anything that was complete nonsense. I'm quite excited about getting this mod to work and I just wanted to fix a few things to the point where some functions worked as they should.
Frold wrote:
Fearless wrote:
Frold wrote:1. When I approve a file in ACP the field file_dlurl in this tabel phpbb_pa_files get a wrong url. The wrong url is www.domain.com/100000000000 .
The URL should be. www.domain.com/[file_dir]/[unique_name]


Apparently, the file name variable is being concatenated with MAX_FILE_SIZE. This is instead of the path + file name. This value is present as a constant in the following files of the project :

- pa_file_add.tpl.php
- pa_admin_file_add.tpl.php
- pa_admin_file_edit.tpl.php
- pa_file_add.tpl
- pa_admin_file_add.tpl
- pa_admin_file_edit.tpl

With the exception of pa_admin_file_upload.tpl that contains a similar but greater value.


But how did you fixet it?


Hehe, I haven't actually got round to fixing it though I am slowly getting round to pinpointing where the problem is. I'm slow when it comes to weeding out bugs. This and other things will probably be fixed in the next release. It is said that, "all things come to those who have patience" :) .
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

Fearless wrote: It is said that, "all things come to those who have patience" :) .


Ohhh.... But I can´t wait... :lol:
Locked

Return to “[2.0.x] MODs in Development”