function CommandLineBackup($filename)
{
global $C, $DB;
$filename = "{$GLOBALS['BASE_DIR']}/data/" . basename($filename);
$tables = array();
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
if ($C['mysqldump']) {
$command = "{$C['mysqldump']} " . "-u" . escapeshellarg($C['db_username']) . " " . "-p" . escapeshellarg($C['db_password']) . " " . "-h" . escapeshellarg($C['db_hostname']) . " " . "--opt " . escapeshellarg($C['db_name']) . " " . join(' ', array_keys($tables)) . " >" . escapeshellarg($filename) . " 2>&1";
exec($command);
} else {
DoBackup($filename, $tables);
}
StoreValue('last_backup', time());
}
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
define('ToplistX', TRUE);
require_once '../includes/common.php';
require_once 'includes/functions.php';
require_once "{$GLOBALS['BASE_DIR']}/includes/mysql.class.php";
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
$DB->Connect();
// Check consistency of last_updates
$last_updates = unserialize(GetValue('last_updates'));
if ($DB->Count('SELECT COUNT(*) FROM `tlx_daily_stats` WHERE `date_stats`=?', array($last_updates['daily']))) {
// Update the daily value
$today = gmdate('Y-m-d', TIME_NOW);
$last_updates['daily'] = $today;
StoreValue('last_updates', serialize($last_updates));
}
// Load table data
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $table_defs);
// Load existing tables
$tables = $DB->GetTables();
// Create the tlx_account_ranks table
if (!isset($tables['tlx_account_ranks'])) {
$DB->Update("CREATE TABLE IF NOT EXISTS `tlx_account_ranks` ( {$table_defs['tlx_account_ranks']} ) TYPE=MyISAM");
}
// Create the tlx_account_ranks table
if (!isset($tables['tlx_account_category_ranks'])) {
$DB->Update("CREATE TABLE IF NOT EXISTS `tlx_account_category_ranks` ( {$table_defs['tlx_account_category_ranks']} ) TYPE=MyISAM");
}
// Update the tlx_categories table
$columns = $DB->GetColumns('tlx_categories', TRUE);
function CommandLineBackup($filename)
{
global $C, $DB;
if (IsEmptyString($filename)) {
trigger_error('A filename must be supplied', E_USER_ERROR);
}
$filename = "{$GLOBALS['BASE_DIR']}/data/" . basename($filename);
$tables = array();
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
if (!$C['safe_mode'] && $C['mysqldump']) {
$command = "{$C['mysqldump']} " . "-u" . escapeshellarg($C['db_username']) . " " . "-p" . escapeshellarg($C['db_password']) . " " . "-h" . escapeshellarg($C['db_hostname']) . " " . "--opt " . escapeshellarg($C['db_name']) . " " . join(' ', array_keys($tables)) . " >" . escapeshellarg($filename) . " 2>&1";
shell_exec($command);
} else {
DoBackup($filename, $tables);
}
StoreValue('last_backup', MYSQL_NOW);
@chmod($filename, 0666);
}
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']}/tgpr.pl")) {
$errors[] = "The tgpr.pl file could not be found in the " . htmlspecialchars($_REQUEST['directory']) . " directory";
return DisplayMain($errors);
}
if (!is_readable("{$_REQUEST['directory']}/tgpr.pl")) {
$errors[] = "The tgpr.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']}/tgpr.pl");
if (preg_match('~\\$VERSION\\s+=\\s+\'(.*?)\'~', $version_file_contents, $matches)) {
list($a, $b, $c) = explode('.', $matches[1]);
if ($b < 2 || strpos($c, '-SS') === FALSE) {
$errors[] = "Your TGP Rotator installation is outdated; please upgrade to the very latest snapshot release (1.2.1-SS)";
return DisplayMain($errors);
}
} else {
$errors[] = "Unable to extract version information from tgpr.pl; your version of TGP Rotator is likely too old";
return DisplayMain($errors);
}
// Extract MySQL information
$mysql_file_contents = file_get_contents("{$_REQUEST['directory']}/data/variables");
if ($mysql_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', $mysql_file_contents, $matches, PREG_SET_ORDER)) {
foreach ($matches as $match) {
$vars[$match[1]] = $match[2];
}
}
if (!isset($vars['USERNAME']) || !isset($vars['DATABASE']) || !isset($vars['HOSTNAME'])) {
$errors[] = "Unable to extract MySQL database information from the variables file";
return DisplayMain($errors);
}
if (!is_writable("{$GLOBALS['BASE_DIR']}/annotations")) {
$errors[] = "Change the permissions on the TGPX annotations directory to 777";
return DisplayMain($errors);
}
if ($C['preview_dir'] == $vars['THUMB_DIR']) {
$errors[] = "The TGPX Thumbnail URL cannot be the same as the TGP Rotator Thumbnail URL";
return DisplayMain($errors);
}
$CONVERTDB = new DB($vars['HOSTNAME'], $vars['USERNAME'], $vars['PASSWORD'], $vars['DATABASE']);
$CONVERTDB->Connect();
$CONVERTDB->Update('SET wait_timeout=86400');
$columns = $CONVERTDB->GetColumns('tr_Galleries');
if (!in_array('Thumbnail_URL', $columns)) {
$errors[] = "Your TGP Rotator installation is outdated; please upgrade to the latest snapshot release";
return DisplayMain($errors);
}
if (!$from_shell) {
echo "<pre>";
}
// Copy annotations
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Copying annotation font files and images...\n");
echo "Copying annotation font files and images...\n";
flush();
$annotations =& DirRead($vars['ANNOTATION_DIR'], '^[^.]');
foreach ($annotations as $annotation) {
@copy("{$vars['ANNOTATION_DIR']}/{$annotation}", "{$GLOBALS['BASE_DIR']}/annotations/{$annotation}");
}
// 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 annotations
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting annotation settings...\n");
echo "Converting annotation settings...\n";
flush();
$annotations = array();
$DB->Update('DELETE FROM `tx_annotations`');
$result = $CONVERTDB->Query('SELECT * FROM `tr_Annotations`');
while ($annotation = $CONVERTDB->NextRow($result)) {
$DB->Update('INSERT INTO `tx_annotations` VALUES (?,?,?,?,?,?,?,?,?,?,?,?)', array(null, $annotation['Identifier'], strtolower($annotation['Type']), $annotation['String'], 0, $annotation['Font_File'], $annotation['Size'], $annotation['Color'], $annotation['Shadow'], $annotation['Image_File'], $annotation['Transparency'], $annotation['Location']));
$annotations[$annotation['Unique_ID']] = $DB->InsertID();
}
$CONVERTDB->Free($result);
//
// Dump categories
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting categories...\n");
echo "Converting categories...\n";
flush();
$categories = array();
$category_ids = array();
$DB->Update('DELETE FROM `tx_categories`');
$result = $CONVERTDB->Query('SELECT * FROM `tr_Categories`');
while ($category = $CONVERTDB->NextRow($result)) {
$tag = CreateCategoryTag($category['Name']);
$categories[$category['Name']] = $tag;
$DB->Update('INSERT INTO `tx_categories` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array(null, $category['Name'], $tag, empty($category['Pictures']) ? 0 : 1, $category['Pictures'], 10, 30, 12288, "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, $annotations[$category['Ann_Pictures']], empty($category['Movies']) ? 0 : 1, $category['Movies'], 5, 30, 102400, "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, $annotations[$category['Ann_Movies']], -1, 0, null, null, null));
$category_ids[$category['Name']] = $DB->InsertID();
}
$CONVERTDB->Free($result);
//
// Dump sponsors
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting sponsors...\n");
echo "Converting sponsors...\n";
flush();
$counter = 1;
$sponsors = array();
$DB->Update('DELETE FROM `tx_sponsors`');
$result = $CONVERTDB->Query('SELECT DISTINCT `Sponsor` FROM `tr_Galleries` WHERE `Sponsor`!=?', array(''));
while ($sponsor = $CONVERTDB->NextRow($result)) {
$sponsors[$sponsor['Sponsor']] = $counter;
$DB->Update("INSERT INTO `tx_sponsors` VALUES (?,?,?)", array($counter++, $sponsor['Sponsor'], null));
}
$CONVERTDB->Free($result);
//
// 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');
$result = $CONVERTDB->Query('SELECT * FROM `tr_Galleries` ORDER BY `Gallery_ID`');
$preview_sizes = array();
while ($gallery = $CONVERTDB->NextRow($result)) {
$DB->Update("INSERT INTO `tx_galleries` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", array(null, $gallery['Gallery_URL'], $gallery['Description'], $gallery['Keywords'], $gallery['Thumbnails'], $C['from_email'], null, $gallery['Weight'], $gallery['Clicks'], $_SERVER['REMOTE_ADDR'], null, !empty($gallery['Sponsor']) ? $sponsors[$gallery['Sponsor']] : null, 'permanent', strtolower($gallery['Type']), $gallery['Status'] == 'Pending' ? 'approved' : strtolower($gallery['Status']), $gallery['Status'] == 'Disabled' ? 'approved' : null, date(DF_DATETIME, TimeWithTz($gallery['Added'])), date(DF_DATETIME, TimeWithTz($gallery['Added'])), date(DF_DATETIME, TimeWithTz($gallery['Added'])), empty($gallery['Scheduled_Date']) ? null : "{$gallery['Scheduled_Date']} 00:00:00", empty($gallery['Display_Date']) ? null : "{$gallery['Display_Date']} 12:00:00", null, null, 'TGPR Convert', '', null, 0, empty($gallery['Thumbnail_URL']) ? 0 : 1, $gallery['Allow_Scan'], $gallery['Allow_Thumb'], $gallery['Times_Selected'], $gallery['Used_Counter'], $gallery['Build_Counter'], 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($gallery['Thumbnail_URL'])) {
$dimensions = '';
if (!empty($gallery['Thumb_Width']) && !empty($gallery['Thumb_Height'])) {
$dimensions = "{$gallery['Thumb_Width']}x{$gallery['Thumb_Height']}";
$preview_sizes[$dimensions] = TRUE;
}
$DB->Update('INSERT INTO `tx_gallery_previews` VALUES (?,?,?,?)', array(null, $gallery_id, '', $dimensions));
$preview_id = $DB->InsertID();
if (preg_match('~^' . preg_quote($vars['THUMB_URL']) . '~i', $gallery['Thumbnail_URL'])) {
$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");
}
}
}
$CONVERTDB->Free($result);
// Update the stored thumbnail preview sizes
$sizes = unserialize(GetValue('preview_sizes'));
if (!is_array($sizes)) {
$sizes = array();
}
$sizes = array_merge($sizes, array_keys($preview_sizes));
StoreValue('preview_sizes', serialize(array_unique($sizes)));
//
// 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');
$result = $CONVERTDB->Query('SELECT * FROM `tr_Pages` ORDER BY `Build_Order`');
while ($page = $CONVERTDB->NextRow($result)) {
$template = file_get_contents("{$_REQUEST['directory']}/data/pages/{$page['Page_ID']}");
$template = ConvertTemplate($template);
$compiled = '';
$page['Directory'] = preg_replace('~/$~', '', $page['Directory']);
$DB->Update('INSERT INTO `tx_pages` VALUES (?,?,?,?,?,?,?,?,?)', array(null, "{$page['Directory']}/{$page['Filename']}", $page['Page_URL'], $page['Category'] == 'Mixed' ? null : $category_ids[$page['Category']], $build_order++, 0, null, $template, $compiled));
}
$CONVERTDB->Free($result);
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "\nData conversion complete!");
echo "\nData conversion complete!\n";
if (!$from_shell) {
echo "</pre>";
}
}
function CreateTables()
{
global $t, $DB;
$DB = new DB($_REQUEST['db_hostname'], $_REQUEST['db_username'], $_REQUEST['db_password'], $_REQUEST['db_name']);
$DB->Connect();
$tables = array();
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
foreach ($tables as $name => $create) {
$DB->Update("CREATE TABLE IF NOT EXISTS {$name} ( {$create} ) TYPE=MyISAM");
}
$password = RandomPassword();
$domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']);
$t->assign('password', $password);
// Setup default user defined partner account fields
$columns = $DB->GetColumns('tx_partner_fields');
if (in_array('sample_url_1', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_1')) < 1) {
$DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_1','Sample URL 1','Text','size=\"80\"','',2,'','Sample URL 1 is not properly formatted',1,1,1,0,0)");
}
if (in_array('sample_url_2', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_2')) < 1) {
$DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_2','Sample URL 2','Text','size=\"80\"','',2,'','Sample URL 2 is not properly formatted',1,1,1,0,0)");
}
if (in_array('sample_url_3', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_3')) < 1) {
$DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_3','Sample URL 3','Text','size=\"80\"','',0,'','Sample URL 3 is not properly formatted',1,1,1,0,0)");
}
// Setup default category and initial thumbnail preview dimensions
$dimensions = array('180x150', '120x150');
$category = array('per_day' => '-1', 'pics_allowed' => 1, 'pics_extensions' => 'jpg,jpeg,bmp,png', 'pics_minimum' => 10, 'pics_maximum' => 30, 'pics_file_size' => 12288, 'pics_preview_allowed' => 1, 'pics_preview_size' => $dimensions[1], 'movies_allowed' => 1, 'movies_extensions' => 'avi,mpg,mpeg,rm,wmv,mov,asf', 'movies_minimum' => 5, 'movies_maximum' => 30, 'movies_file_size' => 102400, 'movies_preview_allowed' => 1, 'movies_preview_size' => $dimensions[0]);
StoreValue('default_category', serialize($category));
Storevalue('preview_sizes', serialize($dimensions));
// Setup administrator account
$DB->Update('DELETE FROM `tx_administrators` WHERE `username`=?', array('administrator'));
$DB->Update('INSERT INTO `tx_administrators` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', "webmaster@{$domain}", 'administrator', null, null, null, null, 0, 0, 0, 0, 0, null, null));
$DB->Disconnect();
}
function RebuildPages($callback = null)
{
global $DB, $C, $L;
// One at a time please
$wouldblock = FALSE;
$fd = fopen("{$GLOBALS['BASE_DIR']}/data/_build_lock", 'w');
flock($fd, LOCK_EX | LOCK_NB, $wouldblock);
if ($wouldblock) {
return;
}
if (!preg_match('~^\\d\\d\\d$~', $C['page_permissions'])) {
$C['page_permissions'] = $GLOBALS['FILE_PERMISSIONS'];
} else {
$C['page_permissions'] = octdec('0' . $C['page_permissions']);
}
// Cache items
$GLOBALS['ICON_CACHE'] =& $DB->FetchAll('SELECT * FROM `tlx_icons`', null, 'icon_id');
$GLOBALS['CATEGORY_CACHE'] =& $DB->FetchAll('SELECT * FROM `tlx_categories`', null, 'category_id');
// Count total thumbs and galleries
$GLOBALS['_total_accounts'] = $DB->Count("SELECT COUNT(*) FROM `tlx_accounts` WHERE `status`='active' AND `disabled`=0");
// Update the last rank information and clear the rank tables
$DB->Update('UPDATE `tlx_accounts` LEFT JOIN `tlx_account_ranks` USING (`username`) SET `last_rank`=`rank`');
$DB->Update('UPDATE `tlx_accounts` LEFT JOIN `tlx_account_category_ranks` USING (`username`) SET `last_category_rank`=`category_rank`');
$DB->Update('DELETE FROM `tlx_account_ranks`');
$DB->Update('DELETE FROM `tlx_account_category_ranks`');
// Build each page
$result = $DB->Query('SELECT * FROM `tlx_pages` ORDER BY `build_order`');
while ($page = $DB->NextRow($result)) {
if ($callback) {
call_user_func($callback, $page);
}
BuildPage($page);
}
$DB->Free($result);
StoreValue('last_rebuild', TIME_NOW);
flock($fd, LOCK_UN);
fclose($fd);
@chmod("{$GLOBALS['BASE_DIR']}/data/_build_lock", 0666);
}
function lxBackupDatabase()
{
global $DB, $C;
VerifyAdministrator();
CheckAccessList();
$filename = SafeFilename("{$GLOBALS['BASE_DIR']}/data/{$_REQUEST['filename']}", FALSE);
$tables = array();
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
$GLOBALS['message'] = 'Database backup is in progress, allow a few minutes to complete before downloading the backup file';
// Run mysqldump in the background
if ($C['allow_exec'] && !empty($C['mysqldump'])) {
$command = "{$C['mysqldump']} " . "-u" . escapeshellarg($C['db_username']) . " " . "-p" . escapeshellarg($C['db_password']) . " " . "-h" . escapeshellarg($C['db_hostname']) . " " . "--opt " . escapeshellarg($C['db_name']) . " " . join(' ', array_keys($tables)) . " >" . escapeshellarg($filename) . " 2>&1 &";
exec($command);
} else {
if ($C['allow_exec'] && !empty($C['php_cli'])) {
exec("{$C['php_cli']} cron.php --backup " . escapeshellarg($filename) . " >/dev/null 2>&1 &");
} else {
DoBackup($filename, $tables);
$GLOBALS['message'] = 'Database backup has been completed';
}
}
StoreValue('last_backup', time());
lxShDatabaseTools();
}
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']}/ags.pl")) {
$errors[] = "The ags.pl file could not be found in the " . htmlspecialchars($_REQUEST['directory']) . " directory";
return DisplayMain($errors);
}
if (!is_readable("{$_REQUEST['directory']}/ags.pl")) {
$errors[] = "The ags.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']}/ags.pl");
if (preg_match('~\\$VERSION\\s+=\\s+\'(.*?)\'~', $version_file_contents, $matches)) {
if ($matches[1] != '3.6.2-SS') {
$errors[] = "Your AutoGallery SQL installation is outdated ({$matches[1]}); please upgrade to version 3.6.2-SS";
return DisplayMain($errors);
}
} else {
$errors[] = "Unable to extract version information from ags.pl; your version of AutoGallery SQL is likely too old";
return DisplayMain($errors);
}
// Extract MySQL information
$mysql_file_contents = file_get_contents("{$_REQUEST['directory']}/data/variables");
if ($mysql_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', $mysql_file_contents, $matches, PREG_SET_ORDER)) {
foreach ($matches as $match) {
$vars[$match[1]] = $match[2];
}
}
if (!isset($vars['USERNAME']) || !isset($vars['DATABASE']) || !isset($vars['HOSTNAME'])) {
$errors[] = "Unable to extract MySQL database information from the variables file";
return DisplayMain($errors);
}
if (!is_writable("{$GLOBALS['BASE_DIR']}/annotations")) {
$errors[] = "Change the permissions on the TGPX annotations directory to 777";
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 SQL Thumbnail URL";
return DisplayMain($errors);
}
$CONVERTDB = new DB($vars['HOSTNAME'], $vars['USERNAME'], $vars['PASSWORD'], $vars['DATABASE']);
$CONVERTDB->Connect();
$CONVERTDB->Update('SET wait_timeout=86400');
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 annotations
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Copying annotation font files and images...\n");
echo "Copying annotation font files and images...\n";
flush();
$annotations =& DirRead($vars['ANNOTATION_DIR'], '^[^.]');
foreach ($annotations as $annotation) {
@copy("{$vars['ANNOTATION_DIR']}/{$annotation}", "{$GLOBALS['BASE_DIR']}/annotations/{$annotation}");
}
// 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', 'headers' => 'headers', 'dns' => 'dns');
foreach ($types as $new_type => $old_type) {
if (is_file("{$_REQUEST['directory']}/data/blacklist/{$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, $html, $regex));
}
//
// Dump 2257 code
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting 2257 search code...\n");
echo "Converting 2257 search code...\n";
flush();
$counter = 1;
$c2257s = file("{$_REQUEST['directory']}/data/2257");
$DB->Update('DELETE FROM `tx_2257`');
foreach ($c2257s 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_2257` VALUES (?,?,?,?)', array(null, "AGS Converted #{$counter}", $html, $regex));
$counter++;
}
//
// 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, $html));
$icons[$identifier] = $DB->InsertID();
}
//
// Dump annotations
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting annotation settings...\n");
echo "Converting annotation settings...\n";
flush();
$annotations = array();
$DB->Update('DELETE FROM `tx_annotations`');
$result = $CONVERTDB->Query('SELECT * FROM `ags_Annotations`');
while ($annotation = $CONVERTDB->NextRow($result)) {
$DB->Update('INSERT INTO `tx_annotations` VALUES (?,?,?,?,?,?,?,?,?,?,?,?)', array(null, $annotation['Identifier'], strtolower($annotation['Type']), $annotation['String'], 0, $annotation['Font_File'], $annotation['Size'], $annotation['Color'], $annotation['Shadow'], $annotation['Image_File'], $annotation['Transparency'], $annotation['Location']));
$annotations[$annotation['Unique_ID']] = $DB->InsertID();
}
$CONVERTDB->Free($result);
//
// Dump categories
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting categories...\n");
echo "Converting categories...\n";
flush();
$categories = array();
$category_ids = array();
$DB->Update('DELETE FROM `tx_categories`');
$result = $CONVERTDB->Query('SELECT * FROM `ags_Categories`');
while ($category = $CONVERTDB->NextRow($result)) {
$tag = CreateCategoryTag($category['Name']);
$categories[$category['Name']] = $tag;
$DB->Update('INSERT INTO `tx_categories` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array(null, $category['Name'], $tag, empty($category['Ext_Pictures']) ? 0 : 1, $category['Ext_Pictures'], $category['Min_Pictures'], $category['Max_Pictures'], $category['Size_Pictures'], "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, $annotations[$category['Ann_Pictures']], empty($category['Ext_Movies']) ? 0 : 1, $category['Ext_Movies'], $category['Min_Movies'], $category['Max_Movies'], $category['Size_Movies'], "{$vars['THUMB_WIDTH']}x{$vars['THUMB_HEIGHT']}", 1, $annotations[$category['Ann_Movies']], $category['Per_Day'], $category['Hidden'], null, null, null));
$category_ids[$category['Name']] = $DB->InsertID();
}
$CONVERTDB->Free($result);
//
// Dump sponsors
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting sponsors...\n");
echo "Converting sponsors...\n";
flush();
$counter = 1;
$sponsors = array();
$DB->Update('DELETE FROM `tx_sponsors`');
$result = $CONVERTDB->Query('SELECT DISTINCT `Sponsor` FROM `ags_Galleries` WHERE `Sponsor`!=?', array(''));
while ($sponsor = $CONVERTDB->NextRow($result)) {
$sponsors[$sponsor['Sponsor']] = $counter;
$DB->Update("INSERT INTO `tx_sponsors` VALUES (?,?,?)", array($counter++, $sponsor['Sponsor'], null));
}
$CONVERTDB->Free($result);
//
// 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');
$result = $CONVERTDB->Query('SELECT * FROM `ags_Galleries` ORDER BY `Gallery_ID`');
$preview_sizes = array();
while ($gallery = $CONVERTDB->NextRow($result)) {
$DB->Update("INSERT INTO `tx_galleries` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", array(null, $gallery['Gallery_URL'], $gallery['Description'], $gallery['Keywords'], $gallery['Thumbnails'], $gallery['Email'], $gallery['Nickname'], $gallery['Weight'], $gallery['Clicks'], $gallery['Submit_IP'], $gallery['Gallery_IP'], !empty($gallery['Sponsor']) ? $sponsors[$gallery['Sponsor']] : null, strtolower($gallery['Type']), strtolower($gallery['Format']), strtolower($gallery['Status']), $gallery['Status'] == 'Disabled' ? 'approved' : null, date(DF_DATETIME, TimeWithTz($gallery['Added_Stamp'])), date(DF_DATETIME, TimeWithTz($gallery['Added_Stamp'])), empty($gallery['Approve_Stamp']) ? null : date(DF_DATETIME, TimeWithTz($gallery['Approve_Stamp'])), empty($gallery['Scheduled_Date']) ? null : "{$gallery['Scheduled_Date']} 00:00:00", empty($gallery['Display_Date']) ? null : "{$gallery['Display_Date']} 12:00:00", empty($gallery['Delete_Date']) ? null : "{$gallery['Delete_Date']} 00:00:00", $gallery['Account_ID'], $gallery['Moderator'], $gallery['Comments'], null, $gallery['Has_Recip'], empty($gallery['Thumbnail_URL']) ? 0 : 1, $gallery['Allow_Scan'], $gallery['Allow_Thumb'], $gallery['Times_Selected'], $gallery['Used_Counter'], $gallery['Build_Counter'], 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($gallery['Thumbnail_URL'])) {
$dimensions = '';
if (!empty($gallery['Thumb_Width']) && !empty($gallery['Thumb_Height'])) {
$dimensions = "{$gallery['Thumb_Width']}x{$gallery['Thumb_Height']}";
$preview_sizes[$dimensions] = TRUE;
}
$DB->Update('INSERT INTO `tx_gallery_previews` VALUES (?,?,?,?)', array(null, $gallery_id, '', $dimensions));
$preview_id = $DB->InsertID();
if (preg_match('~^' . preg_quote($vars['THUMB_URL']) . '~i', $gallery['Thumbnail_URL'])) {
$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");
}
}
}
$CONVERTDB->Free($result);
//
// 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`');
$result = $CONVERTDB->Query('SELECT * FROM `ags_Accounts`');
while ($partner = $CONVERTDB->NextRow($result)) {
$DB->Update('INSERT INTO `tx_partners` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array($partner['Account_ID'], sha1($partner['Password']), '', $partner['Email'], null, MYSQL_NOW, $partner['Submitted'] > 0 ? MYSQL_NOW : null, empty($partner['Start_Date']) ? null : "{$partner['Start_Date']} 00:00:00", empty($partner['End_Date']) ? null : "{$partner['End_Date']} 23:59:59", $partner['Allowed'], round($partner['Weight']), null, 0, null, 0, $partner['Submitted'], $partner['Removed'], 'active', null, null, 0, $partner['Check_Recip'] ? 0 : 1, $partner['Auto_Approve'], $partner['Confirm'] ? 0 : 1, $partner['Check_Black'] ? 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]));
}
}
}
$CONVERTDB->Free($result);
// Update the stored thumbnail preview sizes
$sizes = unserialize(GetValue('preview_sizes'));
if (!is_array($sizes)) {
$sizes = array();
}
$sizes = array_merge($sizes, array_keys($preview_sizes));
StoreValue('preview_sizes', serialize(array_unique($sizes)));
//
// Dump TGP page data
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "Converting TGP pages...\n");
echo "Converting TGP pages...\n";
flush();
$build_order = 1;
$docroot_url = parse_url($vars['CGI_URL']);
$DB->Update('DELETE FROM `tx_pages`');
$DB->Update('ALTER TABLE `tx_pages` AUTO_INCREMENT=0');
$result = $CONVERTDB->Query('SELECT * FROM `ags_Pages` ORDER BY `Build_Order`');
while ($page = $CONVERTDB->NextRow($result)) {
$template = file_get_contents("{$_REQUEST['directory']}/data/html/{$page['Page_ID']}");
$template = ConvertTemplate($template);
$compiled = '';
$DB->Update('INSERT INTO `tx_pages` VALUES (?,?,?,?,?,?,?,?,?)', array(null, "{$vars['DOCUMENT_ROOT']}/{$page['Filename']}", "http://{$docroot_url['host']}/{$page['Filename']}", $page['Category'] == 'Mixed' ? null : $category_ids[$page['Category']], $build_order++, 0, null, $template, $compiled));
}
$CONVERTDB->Free($result);
FileAppend("{$GLOBALS['BASE_DIR']}/data/convert.log", "\nData conversion complete!");
echo "\nData conversion complete!\n";
if (!$from_shell) {
echo "</pre>";
}
}
function DoDatabaseBackup($args, $cli = FALSE)
{
global $DB, $C;
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
$sql_file = SafeFilename("{$GLOBALS['BASE_DIR']}/data/{$args['sql-file']}", FALSE);
$thumbs_file = empty($args['thumbs-file']) ? null : SafeFilename("{$GLOBALS['BASE_DIR']}/data/{$args['thumbs-file']}", FALSE);
$archive_file = empty($args['archive-file']) ? null : SafeFilename("{$GLOBALS['BASE_DIR']}/data/{$args['archive-file']}", FALSE);
$message = 'The database backup function has been started, please allow a few minutes for it to complete...';
// Running from the command line
if ($cli) {
$to_archive = array($sql_file);
if (!empty($C['mysqldump'])) {
$command = "{$C['mysqldump']} " . "-u" . escapeshellarg($C['db_username']) . " " . "-p" . escapeshellarg($C['db_password']) . " " . "-h" . escapeshellarg($C['db_hostname']) . " " . "--opt -Q " . escapeshellarg($C['db_name']) . " " . join(' ', array_keys($tables)) . " >" . escapeshellarg($sql_file);
shell_exec($command);
} else {
DumpSQLTables($sql_file, $tables);
}
if (!empty($args['thumbs-file'])) {
$to_archive[] = $thumbs_file;
DumpThumbnails($thumbs_file);
}
if (!empty($args['archive-file']) && !empty($C['tar']) && !empty($C['gzip'])) {
ArchiveFiles($archive_file, $to_archive);
foreach ($to_archive as $archived_file) {
@unlink($archived_file);
}
}
} else {
if ($C['shell_exec'] && !empty($C['php_cli'])) {
$command = "{$C['php_cli']} cron.php --backup " . "--sql-file=" . escapeshellarg($args['sql-file']) . " " . "--thumbs-file=" . escapeshellarg($args['thumbs-file']) . " " . "--archive-file=" . escapeshellarg($args['archive-file']) . " " . ">/dev/null 2>&1 &";
shell_exec($command);
} else {
DumpSQLTables($sql_file, $tables);
if (!empty($args['thumbs-file'])) {
DumpThumbnails($thumbs_file);
}
$message = 'The database backup has been completed';
}
}
StoreValue('last_backup', MYSQL_NOW);
return $message;
}
function CreateTables()
{
global $t, $DB;
$DB = new DB($_REQUEST['db_hostname'], $_REQUEST['db_username'], $_REQUEST['db_password'], $_REQUEST['db_name']);
$DB->Connect();
$tables = array();
IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables);
foreach ($tables as $name => $create) {
$DB->Update("CREATE TABLE IF NOT EXISTS {$name} ( {$create} ) TYPE=MyISAM");
}
$password = RandomPassword();
$domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']);
$t->assign('password', $password);
// Setup administrator account
$DB->Update('DELETE FROM `tlx_administrators` WHERE `username`=?', array('administrator'));
$DB->Update('INSERT INTO `tlx_administrators` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', "webmaster@{$domain}", 'administrator', null, null, null, null, 0, 0));
if (($last_updates = GetValue('last_updates')) === null) {
$last_updates = array();
$last_updates['daily'] = date('Y-m-d');
$last_updates['hourly'] = null;
StoreValue('last_updates', serialize($last_updates));
}
$DB->Update('INSERT INTO `tlx_skim_ratio` VALUES (0,0)');
$DB->Update('DELETE FROM `tlx_ip2country`');
$DB->Update('DELETE FROM `tlx_countries`');
$DB->Update('DELETE FROM `tlx_country_stats`');
$countries = file('../includes/countries.php');
foreach ($countries as $line) {
$DB->Update($line);
}
//$DB->Disconnect();
}
function txCategoryEditDefault()
{
global $C, $DB;
VerifyPrivileges(P_CATEGORY_MODIFY);
$v =& ValidateCategoryInput();
if (!$v->Validate()) {
return $v->ValidationError('txShCategoryEditDefault');
}
UpdateThumbSizes();
unset($_REQUEST['r']);
unset($_REQUEST['name']);
unset($_REQUEST['pics_preview_size_custom']);
unset($_REQUEST['movies_preview_size_custom']);
StoreValue('default_category', serialize($_REQUEST));
$GLOBALS['message'] = 'Default category settings have been saved';
$GLOBALS['added'] = true;
txShCategoryEditDefault();
}
