function ConvertData()
{
global $C, $DB, $from_shell;
$errors = array();
if (!is_dir($_REQUEST['directory'])) {
$errors[] = "The directory " . htmlspecialchars($_REQUEST['directory']) . " does not exist on your server";
return DisplayMain($errors);
}
if (!is_file("{$_REQUEST['directory']}/agp.pl")) {
$errors[] = "The agp.pl file could not be found in the " . htmlspecialchars($_REQUEST['directory']) . " directory; make sure you have version 3.0.0 or newer installed";
return DisplayMain($errors);
}
if (!is_readable("{$_REQUEST['directory']}/agp.pl")) {
$errors[] = "The agp.pl file in the " . htmlspecialchars($_REQUEST['directory']) . " directory could not be opened for reading";
return DisplayMain($errors);
}
// Check version
$version_file_contents = file_get_contents("{$_REQUEST['directory']}/agp.pl");
if (preg_match('~\\$VERSION\\s+=\\s+\'(.*?)\'~', $version_file_contents, $matches)) {
list($a, $b, $c) = explode('.', $matches[1]);
$c = str_replace('-SS', '', $c);
if ($a < 3) {
$errors[] = "Your AutoGallery Pro installation is outdated ({$matches[1]}); please upgrade to version 3.0.0+";
return DisplayMain($errors);
}
} else {
$errors[] = "Unable to extract version information from agp.pl; your version of AutoGallery Pro is likely too old";
return DisplayMain($errors);
}
// Extract variables
$var_file_contents = file_get_contents("{$_REQUEST['directory']}/data/variables");
if ($var_file_contents === FALSE) {
$errors[] = "Unable to read contents of the variables file";
return DisplayMain($errors);
}
$vars = array();
if (preg_match_all('~^\\$([a-z0-9_]+)\\s+=\\s+\'(.*?)\';$~msi', $var_file_contents, $matches, PREG_SET_ORDER)) {
foreach ($matches as $match) {
$vars[$match[1]] = $match[2];
}
}
if (!isset($vars['ADMIN_EMAIL'])) {
$errors[] = "Unable to extract variable data from the AutoGallery Pro variables file";
return DisplayMain($errors);
}
if (!is_writable($C['font_dir'])) {
$errors[] = "Change the permissions on the TGPX fonts directory to 777";
return DisplayMain($errors);
}
if ($C['preview_dir'] == $vars['THUMB_DIR']) {
$errors[] = "The TGPX Thumbnail URL cannot be the same as the AutoGallery Pro Thumbnail URL";
return DisplayMain($errors);
}
if (!$from_shell) {
echo "<pre>";
}
// Copy fonts for validation codes
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Copying font files for verification codes...\n");
echo "Copying font files for verification codes...\n";
flush();
$fonts =& DirRead($vars['FONT_DIR'], '^[^.]');
foreach ($fonts as $font) {
@copy("{$vars['FONT_DIR']}/{$font}", "{$C['font_dir']}/{$font}");
}
// Copy thumbnail previews
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Copying thumbnail preview images...\n");
echo "Copying thumbnail preview images...\n";
flush();
$thumbs =& DirRead($vars['THUMB_DIR'], '\\.jpg$');
foreach ($thumbs as $thumb) {
@copy("{$vars['THUMB_DIR']}/{$thumb}", "{$C['preview_dir']}/t_{$thumb}");
@chmod("{$C['preview_dir']}/t_{$thumb}", 0666);
}
//
// Dump e-mail log
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting e-mail log...\n");
echo "Converting e-mail log...\n";
flush();
$emails = file("{$_REQUEST['directory']}/data/emails");
$DB->Update('DELETE FROM `tx_email_log`');
foreach ($emails as $email) {
$email = trim($email);
if (empty($email)) {
continue;
}
$DB->Update('REPLACE INTO `tx_email_log` VALUES (?)', array($email));
}
//
// Dump blacklist
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting blacklist...\n");
echo "Converting blacklist...\n";
flush();
$DB->Update('DELETE FROM `tx_blacklist`');
$types = array('submit_ip' => 'submitip', 'email' => 'email', 'url' => 'domain', 'domain_ip' => 'domainip', 'word' => 'word', 'html' => 'html', 'dns' => 'dns');
foreach ($types as $new_type => $old_type) {
$blist_items = file("{$_REQUEST['directory']}/data/blacklist/{$old_type}");
foreach ($blist_items as $html) {
$html = trim($html);
if (empty($html)) {
continue;
}
$regex = 0;
if (strpos($html, '*') !== FALSE) {
$regex = 1;
$html = preg_quote($html);
$html = str_replace('\\*', '.*?', $html);
}
$DB->Update('INSERT INTO `tx_blacklist` VALUES (?,?,?,?,?)', array(null, $new_type, $regex, $html, ''));
}
}
//
// Dump whitelist
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting whitelist...\n");
echo "Converting whitelist...\n";
flush();
$DB->Update('DELETE FROM `tx_whitelist`');
$wlist_items = file("{$_REQUEST['directory']}/data/blacklist/whitelist");
foreach ($wlist_items as $html) {
$html = trim($html);
if (empty($html)) {
continue;
}
$regex = 0;
if (strpos($html, '*') !== FALSE) {
$regex = 1;
$html = preg_quote($html);
$html = str_replace('\\*', '.*?', $html);
}
$DB->Update('INSERT INTO `tx_whitelist` VALUES (?,?,?,?,?,?,?,?,?,?)', array(null, 'url', $regex, $html, '', 1, 0, 0, 0, 0));
}
//
// Dump reciprocal links
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting reciprocal link settings...\n");
echo "Converting reciprocal link settings...\n";
flush();
$DB->Update('DELETE FROM `tx_reciprocals`');
IniParse("{$_REQUEST['directory']}/data/generalrecips", TRUE, $recips);
IniParse("{$_REQUEST['directory']}/data/trustedrecips", TRUE, $recips);
foreach ($recips as $identifier => $html) {
$regex = 0;
if (strpos($html, '*') !== FALSE) {
$regex = 1;
$html = preg_quote($html);
$html = str_replace('\\*', '.*?', $html);
}
$DB->Update('INSERT INTO `tx_reciprocals` VALUES (?,?,?,?)', array(null, $identifier, trim($html), $regex));
}
//
// Dump icons
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting icons...\n");
echo "Converting icons...\n";
flush();
$icons = array();
$DB->Update('DELETE FROM `tx_icons`');
IniParse("{$_REQUEST['directory']}/data/icons", TRUE, $icons_ini);
foreach ($icons_ini as $identifier => $html) {
$identifier = trim($identifier);
$html = trim($html);
if (empty($identifier) || empty($html)) {
continue;
}
$DB->Update('INSERT INTO `tx_icons` VALUES (?,?,?)', array(null, $identifier, trim($html)));
$icons[$identifier] = $DB->InsertID();
}
//
// Dump categories
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting categories...\n");
echo "Converting categories...\n";
flush();
$cat_format = array('Name', 'Type', 'Ext_Pictures', 'Ext_Movies', 'Min_Pictures', 'Min_Movies', 'Max_Pictures', 'Max_Movies', 'Size_Pictures', 'Size_Movies');
$categories = array();
$category_ids = array();
$DB->Update('DELETE FROM `tx_categories`');
$lines = file("{$_REQUEST['directory']}/data/dbs/categories");
foreach ($lines as $line) {
$line = trim($line);
if (empty($line)) {
continue;
}
$category = explode('|', $line);
foreach ($cat_format as $index => $key) {
$category[$key] = $category[$index];
}
$tag = CreateCategoryTag($category['Name']);
$categories[$category['Name']] = $tag;
$DB->Update('INSERT INTO `tx_categories` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array(null, $category['Name'], $tag, $category['Type'] != 'Movies' ? 1 : 0, $category['Ext_Pictures'], $category['Min_Pictures'], $category['Max_Pictures'], $category['Size_Pictures'], "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, null, $category['Type'] != 'Pictures' ? 1 : 0, $category['Ext_Movies'], $category['Min_Movies'], $category['Max_Movies'], $category['Size_Movies'], "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, null, -1, 0, null, null, null));
$category_ids[$category['Name']] = $DB->InsertID();
}
//
// Dump gallery data
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting gallery data...\n");
echo "Converting gallery data...\n";
flush();
$DB->Update('DELETE FROM `tx_galleries`');
$DB->Update('DELETE FROM `tx_gallery_fields`');
$DB->Update('DELETE FROM `tx_gallery_icons`');
$DB->Update('DELETE FROM `tx_gallery_previews`');
$DB->Update('ALTER TABLE `tx_galleries` AUTO_INCREMENT=0');
$DB->Update('ALTER TABLE `tx_gallery_previews` AUTO_INCREMENT=0');
$gal_format = array('Gallery_ID', 'Email', 'Gallery_URL', 'Description', 'Thumbnails', 'Category', 'Nickname', 'Submit_Date', 'Approve_Date', 'Display_Date', 'Display_Stamp', 'Confirm_ID', 'Account_ID', 'CPanel_ID', 'Submit_IP', 'Gallery_IP', 'Scanned', 'Links', 'Has_Recip', 'Page_Bytes', 'Icons');
$gal_dbs = array('unconfirmed' => 'unconfirmed', 'pending' => 'pending', 'approved' => 'used', 'archived' => 'used');
foreach (array_keys($categories) as $cat_name) {
$gal_dbs[preg_replace('~[^a-z0-9]~i', '', strtolower($cat_name))] = 'used';
}
foreach ($gal_dbs as $db => $status) {
$db_file = "{$_REQUEST['directory']}/data/dbs/{$db}";
if (is_file($db_file)) {
$lines = file($db_file);
foreach ($lines as $line) {
$line = trim($line);
if (empty($line)) {
continue;
}
$gallery = explode('|', $line);
foreach ($gal_format as $index => $key) {
$gallery[$key] = $gallery[$index];
}
if (!preg_match('!^http(s)?://[\\w-]+\\.[\\w-]+(\\S+)?$!i', $gallery['Gallery_URL'])) {
continue;
}
$has_thumb = is_file("{$vars['THUMB_DIR']}/{$gallery['Gallery_ID']}.jpg");
$DB->Update("INSERT INTO `tx_galleries` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", array(null, $gallery['Gallery_URL'], $gallery['Description'], null, $gallery['Thumbnails'], $gallery['Email'], $gallery['Nickname'], $C['gallery_weight'], 0, $gallery['Submit_IP'], $gallery['Gallery_IP'], null, 'submitted', FMT_PICTURES, $status, null, "{$gallery['Submit_Date']} 12:00:00", "{$gallery['Submit_Date']} 12:00:00", empty($gallery['Approve_Date']) ? null : "{$gallery['Approve_Date']} 12:00:00", null, empty($gallery['Display_Date']) ? null : "{$gallery['Display_Date']} 12:00:00", null, $gallery['Account_ID'], $gallery['CPanel_ID'], null, null, $gallery['Has_Recip'], $has_thumb ? 1 : 0, 1, 1, 0, 0, 0, null, MIXED_CATEGORY . " " . $categories[$gallery['Category']]));
$gallery_id = $DB->InsertID();
$gallery_info = array('gallery_id' => $gallery_id);
$insert = CreateUserInsert('tx_gallery_fields', $gallery_info);
$DB->Update('INSERT INTO `tx_gallery_fields` VALUES (' . $insert['bind_list'] . ')', $insert['binds']);
foreach (explode(',', $gallery['Icons']) as $icon_id) {
if (isset($icons[$icon_id])) {
$DB->Update('INSERT INTO `tx_gallery_icons` VALUES (?,?)', array($gallery_id, $icons[$icon_id]));
}
}
if (!empty($has_thumb)) {
$dimensions = $vars['THUMB_WIDTH'] . 'x' . $vars['THUMB_HEIGHT'];
$DB->Update('INSERT INTO `tx_gallery_previews` VALUES (?,?,?,?)', array(null, $gallery_id, '', $dimensions));
$preview_id = $DB->InsertID();
$gallery['Thumbnail_URL'] = "{$C['preview_url']}/{$preview_id}.jpg";
$DB->Update('UPDATE `tx_gallery_previews` SET `preview_url`=? WHERE `preview_id`=?', array($gallery['Thumbnail_URL'], $preview_id));
@rename("{$C['preview_dir']}/t_{$gallery['Gallery_ID']}.jpg", "{$C['preview_dir']}/{$preview_id}.jpg");
}
}
}
}
//
// Convert permanent gallery data
$perm_format = array('Permanent_ID', 'Gallery_URL', 'Category', 'Thumbnails', 'Description', 'Nickname', 'Location', 'Thumbnail_URL', 'Start_Date', 'Expire_Date');
$lines = file("{$_REQUEST['directory']}/data/dbs/permanent");
foreach ($lines as $line) {
$line = trim($line);
if (empty($line)) {
continue;
}
$gallery = explode('|', $line);
foreach ($perm_format as $index => $key) {
$gallery[$key] = $gallery[$index];
}
if (!preg_match('!^http(s)?://[\\w-]+\\.[\\w-]+(\\S+)?$!i', $gallery['Gallery_URL'])) {
continue;
}
$has_thumb = is_file("{$vars['THUMB_DIR']}/p{$gallery['Permanent_ID']}.jpg");
$DB->Update("INSERT INTO `tx_galleries` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", array(null, $gallery['Gallery_URL'], $gallery['Description'], null, $gallery['Thumbnails'], $C['from_email'], $gallery['Nickname'], $C['gallery_weight'], 0, $_SERVER['REMOTE_ADDR'], null, null, 'permanent', FMT_PICTURES, 'approved', null, MYSQL_NOW, MYSQL_NOW, MYSQL_NOW, null, null, null, null, 'AGP Import', null, null, 0, $has_thumb ? 1 : 0, 1, 1, 0, 0, 0, null, MIXED_CATEGORY . " " . $categories[$gallery['Category']]));
$gallery_id = $DB->InsertID();
$gallery_info = array('gallery_id' => $gallery_id);
$insert = CreateUserInsert('tx_gallery_fields', $gallery_info);
$DB->Update('INSERT INTO `tx_gallery_fields` VALUES (' . $insert['bind_list'] . ')', $insert['binds']);
foreach (explode(',', $gallery['Icons']) as $icon_id) {
if (isset($icons[$icon_id])) {
$DB->Update('INSERT INTO `tx_gallery_icons` VALUES (?,?)', array($gallery_id, $icons[$icon_id]));
}
}
if (!empty($has_thumb)) {
$DB->Update('INSERT INTO `tx_gallery_previews` VALUES (?,?,?,?)', array(null, $gallery_id, '', $vars['THUMB_WIDTH'] . 'x' . $vars['THUMB_HEIGHT']));
$preview_id = $DB->InsertID();
$gallery['Thumbnail_URL'] = "{$C['preview_url']}/{$preview_id}.jpg";
$DB->Update('UPDATE `tx_gallery_previews` SET `preview_url`=? WHERE `preview_id`=?', array($gallery['Thumbnail_URL'], $preview_id));
@rename("{$C['preview_dir']}/t_p{$gallery['Permanent_ID']}.jpg", "{$C['preview_dir']}/{$preview_id}.jpg");
}
}
//
// Dump partner data
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting partner accounts...\n");
echo "Converting partner accounts...\n";
flush();
$DB->Update('DELETE FROM `tx_partners`');
$DB->Update('DELETE FROM `tx_partner_fields`');
$DB->Update('DELETE FROM `tx_partner_icons`');
$DB->Update('DELETE FROM `tx_partner_confirms`');
$acct_format = array('Account_ID', 'Password', 'Email', 'Allowed', 'Auto_Approve', 'Recip', 'Blacklist', 'HTML', 'Icons');
$lines = file("{$_REQUEST['directory']}/data/dbs/accounts");
foreach ($lines as $line) {
$line = trim($line);
if (empty($line)) {
continue;
}
$partner = explode('|', $line);
foreach ($acct_format as $index => $key) {
$partner[$key] = $partner[$index];
}
$DB->Update('INSERT INTO `tx_partners` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array($partner['Account_ID'], sha1($partner['Password']), '', $partner['Email'], null, MYSQL_NOW, null, null, null, $partner['Allowed'], $C['gallery_weight'], null, 0, null, 0, 0, 0, 'active', null, null, 0, $partner['Recip'] ? 0 : 1, $partner['Auto_Approve'], 1, $partner['Blacklist'] ? 0 : 1));
$partner_info = array('username' => $partner['Account_ID']);
$insert = CreateUserInsert('tx_partner_fields', $partner_info);
$DB->Update('INSERT INTO `tx_partner_fields` VALUES (' . $insert['bind_list'] . ')', $insert['binds']);
foreach (explode(',', $partner['Icons']) as $icon_id) {
if (isset($icons[$icon_id])) {
$DB->Update('INSERT INTO `tx_partner_icons` VALUES (?,?)', array($partner['Account_ID'], $icons[$icon_id]));
}
}
}
// Update the stored thumbnail preview sizes
UpdateThumbSizes($vars['THUMB_WIDTH'] . 'x' . $vars['THUMB_HEIGHT']);
//
// Dump TGP page data
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting TGP pages...\n");
echo "Converting TGP pages...\n";
flush();
$build_order = 1;
$DB->Update('DELETE FROM `tx_pages`');
$DB->Update('ALTER TABLE `tx_pages` AUTO_INCREMENT=0');
$pages = GetPageList($vars, $categories);
foreach ($pages as $page) {
$template = file_get_contents($page['template']);
$template = trim(ConvertTemplate($template, $page['arch']));
$compiled = '';
$DB->Update('INSERT INTO `tx_pages` VALUES (?,?,?,?,?,?,?,?,?)', array(null, $page['file'], $page['url'], $page['category'] == 'Mixed' ? null : $category_ids[$page['category']], $build_order++, 0, null, $template, $compiled));
}
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "\nData conversion complete!");
echo "\nData conversion complete!\n";
if (!$from_shell) {
echo "</pre>";
}
}
function txCategoryEdit()
{
global $C, $DB;
VerifyPrivileges(P_CATEGORY_MODIFY);
$v =& ValidateCategoryInput();
if (!$v->Validate()) {
return $v->ValidationError('txShCategoryEdit');
}
UpdateThumbSizes();
// Bulk update
if (isset($_REQUEST['apply_all']) || isset($_REQUEST['apply_matched'])) {
$GLOBALS['message'] = 'All categories have been successfully updated';
$select = new SelectBuilder('*', 'tx_categories');
if (isset($_REQUEST['apply_matched'])) {
$search = array();
parse_str($_REQUEST['apply_matched'], $search);
$select->AddWhere($search['field'], $search['search_type'], $search['search'], $search['search_type'] != ST_EMPTY);
$GLOBALS['message'] = 'Matched categories have been successfully updated';
}
$result = $DB->Query($select->Generate(), $select->binds);
while ($category = $DB->NextRow($result)) {
$DB->Update('UPDATE `tx_categories` SET ' . '`pics_allowed`=?, ' . '`pics_extensions`=?, ' . '`pics_minimum`=?, ' . '`pics_maximum`=?, ' . '`pics_file_size`=?, ' . '`pics_preview_size`=?, ' . '`pics_preview_allowed`=?, ' . '`pics_annotation`=?, ' . '`movies_allowed`=?, ' . '`movies_extensions`=?, ' . '`movies_minimum`=?, ' . '`movies_maximum`=?, ' . '`movies_file_size`=?, ' . '`movies_preview_size`=?, ' . '`movies_preview_allowed`=?, ' . '`movies_annotation`=?, ' . '`per_day`=?, ' . '`hidden`=?, ' . '`meta_description`=?, ' . '`meta_keywords`=? ' . 'WHERE `category_id`=?', array(intval($_REQUEST['pics_allowed']), $_REQUEST['pics_extensions'], $_REQUEST['pics_minimum'], $_REQUEST['pics_maximum'], $_REQUEST['pics_file_size'], $_REQUEST['pics_preview_size'], intval($_REQUEST['pics_preview_allowed']), $_REQUEST['pics_annotation'], intval($_REQUEST['movies_allowed']), $_REQUEST['movies_extensions'], $_REQUEST['movies_minimum'], $_REQUEST['movies_maximum'], $_REQUEST['movies_file_size'], $_REQUEST['movies_preview_size'], intval($_REQUEST['movies_preview_allowed']), $_REQUEST['movies_annotation'], $_REQUEST['per_day'], intval($_REQUEST['hidden']), $_REQUEST['meta_description'], $_REQUEST['meta_keywords'], $category['category_id']));
}
$DB->Free($result);
} else {
$_REQUEST['name'] = trim($_REQUEST['name']);
$DB->Update('UPDATE `tx_categories` SET ' . '`name`=?, ' . '`pics_allowed`=?, ' . '`pics_extensions`=?, ' . '`pics_minimum`=?, ' . '`pics_maximum`=?, ' . '`pics_file_size`=?, ' . '`pics_preview_size`=?, ' . '`pics_preview_allowed`=?, ' . '`pics_annotation`=?, ' . '`movies_allowed`=?, ' . '`movies_extensions`=?, ' . '`movies_minimum`=?, ' . '`movies_maximum`=?, ' . '`movies_file_size`=?, ' . '`movies_preview_size`=?, ' . '`movies_preview_allowed`=?, ' . '`movies_annotation`=?, ' . '`per_day`=?, ' . '`hidden`=?, ' . '`meta_description`=?, ' . '`meta_keywords`=? ' . 'WHERE `category_id`=?', array($_REQUEST['name'], intval($_REQUEST['pics_allowed']), $_REQUEST['pics_extensions'], $_REQUEST['pics_minimum'], $_REQUEST['pics_maximum'], $_REQUEST['pics_file_size'], $_REQUEST['pics_preview_size'], intval($_REQUEST['pics_preview_allowed']), $_REQUEST['pics_annotation'], intval($_REQUEST['movies_allowed']), $_REQUEST['movies_extensions'], $_REQUEST['movies_minimum'], $_REQUEST['movies_maximum'], $_REQUEST['movies_file_size'], $_REQUEST['movies_preview_size'], intval($_REQUEST['movies_preview_allowed']), $_REQUEST['movies_annotation'], $_REQUEST['per_day'], intval($_REQUEST['hidden']), $_REQUEST['meta_description'], $_REQUEST['meta_keywords'], $_REQUEST['category_id']));
$GLOBALS['message'] = 'Category has been successfully updated';
}
$GLOBALS['added'] = true;
txShCategoryEdit();
}
