Codezwiz >> Forums >> General PHP Nuke Help >> Add many Downloads to the Download Module at once?

I was wondering if there is a script or a SQL statement that would allow me to add MANY(about 463) downloads at once to my download module on my website. If someone (Telli doesn't have to do everything lol) provide me with this and instructions, that would be great. I'm pretty desperate......

Im pretty sure i've seen a script that allows you to upload via FTP and select the download from a drop down in the downloads admin... for the life of me i cant remember where... try a google on it

You just don't know how many times have googled it. I can't find anything.

You could write something to read a file's contents and use the file name as the title and description. So you would create a folder on your FTP and upload all the downloads into it. Then your script would read that file and insert the new download.

Example:

$direct = 'files/themes/';
$putdirect = 'downloads/themes/';

if ($handle = opendir($direct)) {
while (false !== ($file = readdir($handle))) {
   if ($file != '.' and $file != '..' and is_dir($direct.$file)) {
      $filename = $file;
      $desc = $file;
      $category = '12';
      $filesize = @strlen(@file_get_contents($filename));
      $db->sql_query("INSERT INTO ".DB_PREFIX."_downloads_downloads VALUES (NULL, '$category', '0', '$file Theme', '$filename', '$desc', now(), '', 'no@nowhere.com', '', '', '', '', '', '$filesize', '1.0', 'http://www.phpnuke.org', '1')");
   }
}
}
closedir($handle);

The thing is Telli, I have no idea on where to start on writing a script.

I would need some help.

Originally posted by Mattdylan @ Sat Mar 14, 2009 2:13 pm:

The thing is Telli, I have no idea on where to start on writing a script. I would need some help.

I cannot get this script to work at all. It keeps coming out in code form when I try and run it.

?php
global $prefix, $dbi;
include_once("mainfile.php");
$url_downloads_folder = "http://guitarherocustoms.com/modules/charts4trunk/"; put the url to the directory with your downloads - you need the trailing slash!
$cat = 1; // the download category id (cid)
$description = "The offset of the chart is at the beginning of the file name of the chart. Visit the forums for guides on how to use this chart.";
$name = "Trunk Charts for you";
$email = "Unknown";
$the_hits = 0; // you can change this if you want
$filesize = 10000; // you can change this if you want
$version = "1"; // you can put something betwenn the quotes if you want, or leave them empty
$homepage = "http://www.guitarherocustoms.com";

$fp = @fopen("$url_downloads_folder","r");
if($fp) {
echo "success opening the $url_downloads$downloads_folder folder. ";

$i=0;
while (!feof ($fp)) {
$download_full_name = "";
$buffer = fgets($fp, 2048);
if (eregi("(<A HREF=")([^?])(.+)(">)",$buffer)) {
$download_full_name = eregi_replace("(.+)(<A HREF=")([^?])(.+)(">)(.+)","34",$buffer);
if(eregi("(.+)(.)(.+)",$download_full_name)) {
$i++;
$all_full_names .= "$download_full_name ";
$download_name_no_extension .= eregi_replace("(.+)(.)(.+)","1 ",$download_full_name);
$title = eregi_replace("(.+)(.)(.+)","1",$download_full_name);
$url = $url_downloads_folder.$download_full_name;
$the_sql_querys .= "insert into ".$prefix."_downloads_downloads values (NULL, '$cat', '0', '$title', '$url', '$description', now(), '$name', '$email', '$the_hits','','0','0','0', '$filesize', '$version', '$homepage'); ";
//sql_query("insert into ".$prefix."_downloads_downloads values (NULL, '$cat', '0', '$title', '$url', '$description', now(), '$name', '$email', '$the_hits','','0','0','0', '$filesize', '$version', '$homepage')", $dbi);
}
}
}
fclose ($fp);
echo "There were $i downloads found in $url_downloads_folder ";
echo "<table><tr><td>All download names with extension    $all_full_names</td>";
echo "<td>All download names no extension $download_name_no_extension</td></tr></table>";
}else {
echo "couldn't connect to $url_downloads_folder";
}
echo "$the_sql_querys";
?>

At the begining of your code it should start like:

<?php

Wow..... I feel like an idiot now.