";
echo count($arr) . " Pictures in the database
";
if (is_array($arr)) {
$filelist = array_diff_assoc($filelist,$arr);
}
echo "After filtering " . count($filelist) . " pictures will be added
";
}
function populatealbums()
{
global $filelist, $counter;
$lim = $_POST['hardlimit'] > 0 ? $_POST['hardlimit'] : getrandmax();
foreach ($filelist as $filename => $aid)
{
if ($counter < $lim)
{
set_time_limit(180);
//echo "$filename - $aid
";
addpic($aid, $filename);
$filelist = array_diff_assoc($filelist, array($filename => $aid));
usleep($_POST['sleep'] * 1000);
$counter++;
}
}
}
function createcategory($parent, $name)
{
global $CONFIG;
$sql = "SELECT cid " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE name='" . addslashes($name) . "' AND parent=" . (INT)$parent . " LIMIT 1";
$result = db_query($sql);
if (mysql_num_rows($result)) {
echo "category already exists : $name
";
$row = mysql_fetch_row($result);
$cid = $row[0];
} else {
db_query("INSERT INTO {$CONFIG['TABLE_CATEGORIES']} (pos, parent, name) VALUES ('10000', '$parent', '" . addslashes($name) . "')");
echo "created category $name
";
$cid = mysql_insert_id();
}
flush();
return $cid;
}
function createalbum($category, $title)
{
global $CONFIG;
$sql = "SELECT aid " . "FROM {$CONFIG['TABLE_ALBUMS']} " . "WHERE title='" . addslashes($title) . "' AND category=" . (INT)$category . " LIMIT 1";
$result = db_query($sql);
if (mysql_num_rows($result)) {
echo "album already exists : $title
";
$row = mysql_fetch_row($result);
$aid = $row[0];
} else {
db_query("INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, pos) VALUES ('".(INT)$category."', '" . addslashes($title) . "', '10000')");
echo "created album $title
";
$aid = mysql_insert_id();
}
flush();
return $aid;
}
function addpic($aid, $pic_file)
{
global $CONFIG;
$pic_file = str_replace('./' . $CONFIG['fullpath'], '', $pic_file);
$dir_name = dirname($pic_file) . "/";
$file_name = basename($pic_file);
if ( (strncmp($file_name,$CONFIG['thumb_pfx'],strlen($CONFIG['thumb_pfx'])) != 0 ) && ( strncmp($file_name,$CONFIG['normal_pfx'],strlen($CONFIG['normal_pfx'])) != 0) ) {
$sane_name = str_replace('%20', '_', $file_name);
$sane_name = preg_replace('/[^a-zA-Z0-9\.\-_]/', '_', $sane_name);
$sane_name = preg_replace('/[^a-zA-Z0-9\.\-_]/', '_', $sane_name);
while ( strpos($sane_name,'__') !== FALSE ) {
$sane_name = str_replace('__', '_', $sane_name);
}
$c = 0;
$sane_name2 = $sane_name;
$sql = "SELECT pid " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE filepath='" . addslashes($dir_name) . "' AND filename='" . addslashes($sane_name) . "' " . "LIMIT 1";
$result = db_query($sql);
$extra = strstr($pic_file, $sane_name) ? '' : " (as $sane_name)";
if (mysql_num_rows($result)) {
echo "Picture '$pic_file' already added$extra
";
} else {
while (($sane_name != $file_name) && file_exists("./" . $CONFIG['fullpath'] . $dir_name . $sane_name))
{
$c++;
$sane_name = $c . '_' . $sane_name2;
}
$source = "./" . $CONFIG['fullpath'] . $dir_name . $file_name;
rename($source, "./" . $CONFIG['fullpath'] . $dir_name . $sane_name);
if (add_picture($aid, $dir_name, $sane_name, $file_name)) {
echo "Picture '$pic_file' added$extra
";
} else {
echo "Picture '$pic_file' failed$extra
";
}
}
flush();
ob_end_flush();
} else {
echo "Skipping thumb or normale pics
";
}
}
function reload()
{
global $filelist, $counter;
if (count($_POST) == 0) exit();
$remaining = countup($filelist);
$filelist = base64_encode(serialize($filelist));
$auto = (isset($_POST['auto']) && $_POST['auto']) ? 'checked = "checked"' : '';
$js = ($_POST['auto'] && $remaining) ? '' : '';
$counter = $counter ? "$counter files added" : "structure created";
$directory = isset($_POST['directory']) ? $_POST['directory'] : '';
$sleep = isset($_POST['sleep']) ? $_POST['sleep'] : '1000';
$hardlimit = isset($_POST['hardlimit']) ? $_POST['hardlimit'] : '0';
if (!connection_aborted()) echo <<< EOT
$counter, $remaining files to add.
$js
EOT;
}
function countup($array)
{
$result = 0;
foreach ($array as $a)
$result += is_array($a) ? countup($a) : count($a);
return $result;
}
if (isset($_POST['filelist'])){
$filelist = unserialize(base64_decode($_POST['filelist']));
$counter = 0;
populatealbums();
} elseif (isset($_POST['start'])) {
$data = dir_parse('./albums/' . $_POST['directory']);
if (!$_POST['directory']) {
echo 'Using root Category
';
$parent=0;
} else {
$sql = "SELECT cid " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent='0' AND name='" . $_POST['directory'] . "' " . "LIMIT 1";
$result = db_query($sql);
if (mysql_num_rows($result)) {
echo "Root category already exists : " . $_POST['directory'] . "
";
$row = mysql_fetch_row($result);
$cid = $row[0];
} else {
db_query("INSERT INTO {$CONFIG['TABLE_CATEGORIES']} (pos, parent, name) VALUES ('10000', '0', '{$_POST['directory']}')");
echo 'Created root category
';
$cid = mysql_insert_id();
}
}
flush();
createstructure($data, $cid, './albums/' . $_POST['directory']);
cleanupfilelist();
} else {
echo <<< EOT
EOT;
}