Hi samuels,

well, I hope you are satisfied with me.
See what I´ve got. I hope it is it what you wanted.

# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 23. Februar 2004 um 21:44
# Server Version: 3.23.55
# PHP-Version: 4.3.1
# Datenbank: `xoops`
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_broken`
#

CREATE TABLE xoops_mydownloads_broken (
reportid int(5) NOT NULL auto_increment,
lid int(11) NOT NULL default '0',
sender int(11) NOT NULL default '0',
ip varchar(20) NOT NULL default '',
PRIMARY KEY (reportid),
KEY lid (lid),
KEY sender (sender),
KEY ip (ip)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_cat`
#

CREATE TABLE xoops_mydownloads_cat (
cid int(5) unsigned NOT NULL auto_increment,
pid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '1 2 3',
title varchar(50) NOT NULL default '',
imgurl varchar(150) NOT NULL default '',
PRIMARY KEY (cid),
KEY pid (pid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_downloads`
#

CREATE TABLE xoops_mydownloads_downloads (
lid int(11) unsigned NOT NULL auto_increment,
cid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '1 2 3',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
homepage varchar(100) NOT NULL default '',
version varchar(10) NOT NULL default '',
size int(8) NOT NULL default '0',
platform varchar(50) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
submitter int(11) NOT NULL default '0',
status tinyint(2) NOT NULL default '0',
date int(10) NOT NULL default '0',
hits int(11) unsigned NOT NULL default '0',
rating double(6,4) NOT NULL default '0.0000',
votes int(11) unsigned NOT NULL default '0',
comments int(11) unsigned NOT NULL default '0',
PRIMARY KEY (lid),
KEY cid (cid),
KEY status (status),
KEY title (title(40))
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_mod`
#

CREATE TABLE xoops_mydownloads_mod (
requestid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned NOT NULL default '0',
cid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
homepage varchar(100) NOT NULL default '',
version varchar(10) NOT NULL default '',
size int(8) NOT NULL default '0',
platform varchar(50) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
description text NOT NULL,
modifysubmitter int(11) NOT NULL default '0',
PRIMARY KEY (requestid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_text`
#

CREATE TABLE xoops_mydownloads_text (
lid int(11) unsigned NOT NULL default '0',
description text NOT NULL,
KEY lid (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xoops_mydownloads_votedata`
#

CREATE TABLE xoops_mydownloads_votedata (
ratingid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned NOT NULL default '0',
ratinguser int(11) NOT NULL default '0',
rating tinyint(3) unsigned NOT NULL default '0',
ratinghostname varchar(60) NOT NULL default '',
ratingtimestamp int(10) NOT NULL default '0',
PRIMARY KEY (ratingid),
KEY ratinguser (ratinguser),
KEY ratinghostname (ratinghostname),
KEY lid (lid)
) TYPE=MyISAM;


Thanks again, samuels.
Slowly, very slowly I get to know the system. )

Cheers
Marc

Ok, tables are perfect.
I've installed my module with a fresh local version of XOOPS 2.06 and I've detected some bugs modifying the downloads from user and admin sides.
I solved it, so download again (sorry ).

But I'm afraid 'cause I can't reproduce errors downloading the files. I have no problems downloading the files.
I'll made some more tests and I hope I'll find the bugs.

Please, try to modify a download and check if url is correct. If is correct i think is a bug in visit.php file.

Once more, sorry for the inconveniencies, I'm very glad with your help with tests.

You did great job up and working fine so far. users upload works just like expected.

This module is the greates

see it in action Spikes special ops

Good and bad news!
At first I like to thank you for your tremendous work.
Your module and your effort is great!!!
And yes, you solved some of the bugs. The Modifying works perfectly! Congratulations!

Well, isn´t there always a BUT.
Yes, I have to admit there is a but.
The upload to the upload-directory works fine. Any upload I do can be found in the upload-file. Super.
But there seems to be something wrong with the visit.php.

http://rsalpen.dyndns.org/modules/mydownloads/visit.php?cid=1&lid=3
By pressing the upload-link all I receive is the message that the site can´t be found.
But - the down/upload link directs to

http://rsalpen.dyndns.org/uploads/ToDO-Schule.doc!
I can´t even connect to the side directly although it seems to be the correct path. Mabye it´s got to to with the rights management. I´m testing it soon.

Thanks so far! Keep up the good work!

Marc

@oleman & @bapapapa
Thanks for spend your time debugging. Please if you find more bugs or features request let me know.

Hi Samuels,

Quote:

no, it got nothing to do with it. I changed everything to 777, the directory and the file itself. Nothing.
What I don´t understand is that I can´t connect to the uploaded file directly.

... a couple of minutes later ...

Well, It wooooooooorks!
I don´t know what I did, because I didn´t really change anything, but it works! Super Congratulations! You did it.

Well, it was about time... ...because it´s 1:22 AM and I´m getting tired after all those beers.

Maybe I can suggest some new features? lol

Thank you a thousend times and more
Cheers
Marc
Edit: I´ll translate it into German during the upcoming week.

I created an upload directory in my downloads module. and set it to 777

In admin settings uploads should go to modules/mydownloads/uploads

That way it keeps it seperate from any others that upload in the main upload directory

It seems to be working fine for me

also if you disallow direct linking you may get this message check that setting.

I did find that in mine but I just set it to no
and everything works fine

@oleman
Hi, thanks for your hints.

Quote:

Sorry, but I cannot find it.
All I see in the admin setting of mydownloads is:

Screen Shots Upload Directory
Category Image Upload Directory

Silly me can´t find the settings. Please help.

Cheers
Marc

@bapapapa
Perhaps oleman is talking about antileech function.

With this function people arent able to link your downloads, and its usefull for blocking leechers who want to steal your links.

Hi,

Quote:
Oh, yes! I understood that part of the suggestion.

Quote:

But I don´t know where to change the upload path to modules/mydownloads/uploads instead of modules/uploads.

I´m a very slow learner, but I´m still improving.

Marc