151
javier
Re: help with mysql query in latest downloads block
  • 2004/3/23 22:13

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


I forget a little detail :)

what happen when i have subcategorys, how i can make that?

ie:

files (category cid=9)----> themes (subcategory cid=15)
----> hacks (subcategory cid= 17)

graphics (category cid=x)-----> bla
-----> bla

currently the block show the latest files added to cid=9 but i want show the files from cid 9 and all his subcategorys ,cid 15 and 17

how i can make that? how will be the query?

thanks again and sorry for disturb you again with this

grettings :)



152
javier
Re: Mydownloads submit, remove the http:// ? i tried all.
  • 2004/3/23 22:04

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Quote:
Why can't you just type in for example
{XOOPS_URL}/files/file.zip?
or
yoursite.com/files/file.zip?


Because the site i have currently in proyect will have a large volume of upload/downloads
Xoops has not a integrated upload file script yet (except mydownloads rc1)
them i will use a external upload script,the user after fill the XOOPS submit form with the file details is redirected to these upload script.
and i modified mydownloads module to allow enlarge screenshots. (i already made this with XOOPS 1.3.x some years ago in my old site)

them in each user submited file,i have to fill 3 spaces in manual way every time,
the url file (with the internal location)
the small picture (internal location)
the big picture (internal location)

if i have to fill all the complete path every time,is too much work.
in my way i only have to add the folder and the filename.
ie: files/file.zip
files/small_image.jpg
files/big_image.jpg

the rest is added automaticly.

--------


Thanks ajaxbr :) you solve my problem :)
i only modified the admin files because the users will not add file urls.

-----

jusui:

is very similar to the way i using :)

in 2.0.6 is not neccesary add all the site url, if you put your files inside the mydownloads module,
if your file is in the root of the downloads module, you put only file.zip and will work fine too.
if you put your file inside a folder inside download root, will work too
tex/file.zip

the only problem is if your want change the relative path to the XOOPS root for example.

in my old site i was modified the path relative for my files, but im 2.0.6 is diferent or i not remember fine how i made that before :)

grettings, sorry for my poor english



153
javier
Mydownloads submit, remove the http:// ? i tried all.
  • 2004/3/23 15:10

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Hi,
i already removed all the http:// values in the fileurl from mydownloads module,
but every time i add a new file, it keep adding the http:// in the file url,
them i have to modify the file to remove that and ready.

I want remove these http:// because my files are in internal locations in my server.
ie: files/file.zip
and the submit always add the http://
ie:http://files/file.zip

the other question is,

currently i have my files in Xoopsurl/modules/mydownloads/files/file.zip

i want modify to

Xoopsurl/files/file.zip

i made these modifications some years ago in my old 1.3.x site,but now in XOOPS 2.0.6 i can´t

thanks in advance for your reply
grettings.



154
javier
Re: File Submissions Instead of URL
  • 2004/3/22 11:23

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


make a search in google as "php upload script tutorial" you will find alot of tutorials and resources.

take care of choose one with configurable control over the file extensions, (for only allow *.jpg,*.zip,etc not *.php,etc) because anybody can hack your site if upload a certain php file.
A good site with alot of free php scripts ishttp://www.hotscripts.com/

grettings






155
javier
Re: File Submissions Instead of URL
  • 2004/3/21 11:32

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


The module mydownloads RC1 has all that, but is a release candidate version, them is not recomendable for production sites,
anyways works fine,
search in the news,downloads for these module.

and exist a mydownload RC2 module in proyect too.

---
that´s you first option,
your second option is include in your site a external php upload script and after that collect all the files from the uploaded files folder.
the only thing you have to do, is fill the file url with your internal ubication after that.

that works very good in my old site (1.3.x based) the upload process had 2 steps,
the first one where the user fill the original mydownloads form with all the file details,
after that redirect the users to the uploader script page where they can upload the files to a folder.

grettings



156
javier
Re: help with mysql query in latest downloads block
  • 2004/3/17 16:26

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Thanks Dave,

yesterday after wrote the question i found the solution too, reading other XOOPS files,etc.

thanks anyways :)



157
javier
help with mysql query in latest downloads block
  • 2004/3/17 0:21

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


I added a new block to the download module, at the moment is a "latest downloads" clone block.
but i want modify to allow latest downloads by category, i know is very simple, only change a MySQL query.
but i don´t know much about mysql, them i need a little help.

Let me explain better, i will create one block x category, them i not need create code to set options from admin panel,etc.

I want show latest downloads from category 2 (cid=2)

the original query is

$result $xoopsDB->query("SELECT lid, cid, title, date, hits FROM ".$xoopsDB->prefix("mydownloads_downloads")." WHERE status>0 ORDER BY ".$options[0]." DESC",$options[1],0);


i want modify the query to only show downloads from a specific cid (cid=2)

thanks in advance , sorry for my poor english.






158
javier
Re: antidos module damage my site, i can´t enter.
  • 2004/3/13 20:43

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Thanks Stewdio!! that solve my problem

i ignore why the module ban my ip, all i made was install the module and when i wanted enter in the config option of the antidos module i get the white page.
now i can breathe again, thanks!

have a nice day.



159
javier
Re: antidos module damage my site, i can´t enter.
  • 2004/3/13 20:06

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Thanks for reply so fast, im really desesperate with this problem,

Stewdio: that was the first thing i made, delete all the xoops_antidos_ tables
but still not luck.

DonXoop:
its runing in my pc, i can´t enter from other ip, maybe exist a way to delete my ip from the db, where XOOPS save the bans ip in the db?

thanks again. :)



160
javier
antidos module damage my site, i can´t enter.
  • 2004/3/13 19:18

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Hi, plz i need some urgent help, i just finished development my site, i was ready for upload all the files to the server and put online,
but i decide install the antidos module in my local site copy,
now i can´t access to my site, all i get is a blank page,
the site works fine for weeks before install this module,
i can´t enter to admin section, i can´t enter any page or section inside the site.

the rest of my XOOPS projects sites inside the same server work fine.

plz help.

thanks in advance.

Javier




TopTop
« 1 ... 13 14 15 (16) 17 »



Login

Who's Online

191 user(s) are online (118 user(s) are browsing Support Forums)


Members: 0


Guests: 191


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits