35 lines
1.0 KiB
PHP
Executable File
35 lines
1.0 KiB
PHP
Executable File
<?php
|
|
|
|
$event_name = 'USNationalChampionship2007';
|
|
$dir = opendir("/home/users/web/b2373/pow.fti/htdocs/bobsleighphotos/images/bobsleighphotos/$event_name");
|
|
|
|
while (false !== ($filename = readdir($dir)))
|
|
{
|
|
if($filename != '.' and $filename != '..')
|
|
{ $files[] = $filename; }
|
|
}
|
|
|
|
sort($files);
|
|
|
|
mysql_connect("mysql09.powweb.com",'fti','friend3');
|
|
mysql_select_db("bobsleighphotos");
|
|
|
|
$res = mysql_query("SELECT pa.products_attributes_id,p.products_image
|
|
FROM zc_products_attributes pa, zc_products p
|
|
WHERE p.products_id > 1307
|
|
AND p.products_id = pa.products_id;");
|
|
|
|
while($prod = mysql_fetch_assoc($res))
|
|
{
|
|
$image = str_replace('bobsleighphotos/','',$prod['products_image']);
|
|
mysql_query("INSERT INTO zc_products_attributes_download
|
|
(products_attributes_id,products_attributes_filename,
|
|
products_attributes_maxdays,products_attributes_maxcount)
|
|
VALUES({$prod['products_attributes_id']},'$image',7,2);");
|
|
|
|
if(mysql_error()) { print ": ".mysql_error()."<br />"; }
|
|
}
|
|
|
|
print "Done!";
|
|
|
|
?>
|