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 BuildPages(&$pages, $callback = null, $all = FALSE) { 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; } // Clear old build history $DB->Update('DELETE FROM `tx_build_history` WHERE `date_start` < DATE_ADD(?, INTERVAL -14 DAY)', array(MYSQL_NOW)); $DB->Update('INSERT INTO `tx_build_history` VALUES (?,?,?,?,?,?,?)', array(null, MYSQL_NOW, null, null, count($pages), 0, null)); $GLOBALS['build_history_id'] = $DB->InsertID(); if (!preg_match('~^\\d\\d\\d$~', $C['page_permissions'])) { $C['page_permissions'] = $GLOBALS['FILE_PERMISSIONS']; } else { $C['page_permissions'] = octdec('0' . $C['page_permissions']); } // Clear records of currently used galleries on these pages ClearUsedGalleries($pages, $all); // Process the clicklog ProcessClickLog(); // Cache icons if (!isset($GLOBALS['ICON_CACHE'])) { $GLOBALS['ICON_CACHE'] =& $DB->FetchAll('SELECT * FROM `tx_icons`', null, 'icon_id'); } // Cache categories by tag if (!isset($GLOBALS['CATEGORY_CACHE_TAG'])) { $GLOBALS['CATEGORY_CACHE_TAG'] =& $DB->FetchAll('SELECT * FROM `tx_categories` ORDER BY `name`', null, 'tag'); } // Cache categories by id if (!isset($GLOBALS['CATEGORY_CACHE_ID'])) { $GLOBALS['CATEGORY_CACHE_ID'] =& $DB->FetchAll('SELECT * FROM `tx_categories`', null, 'category_id'); $GLOBALS['CATEGORY_CACHE_ID'][''] = array('name' => $L['MIXED'], 'category_id' => 0); } // Cache sponsors by id if (!isset($GLOBALS['SPONSOR_CACHE'])) { $GLOBALS['SPONSOR_CACHE'] =& $DB->FetchAll('SELECT * FROM `tx_sponsors`', null, 'sponsor_id'); } // Clear data on galleries used during the previous build $DB->Update('UPDATE `tx_gallery_used` SET `this_build`=0,`new`=0'); // Remove galleries scheduled for deletion $result = $DB->Query('SELECT * FROM `tx_galleries` WHERE `date_deletion` <= ?', array(MYSQL_NOW)); while ($gallery = $DB->NextRow($result)) { DeleteGallery($gallery['gallery_id'], $gallery); } $DB->Free($result); // Delete old submitted galleries that are currently holding $result = $DB->Query('SELECT * FROM `tx_galleries` WHERE `status`=? AND `type`=? AND `date_displayed` <= SUBDATE(?, INTERVAL ? DAY)', array('holding', 'submitted', MYSQL_NOW, $C['submitted_hold'])); while ($gallery = $DB->NextRow($result)) { DeleteGallery($gallery['gallery_id'], $gallery); } $DB->Free($result); // Rotate permanent galleries from holding back to approved queue $DB->Update('UPDATE `tx_galleries` SET ' . "`status`='approved', " . "`date_displayed`=NULL, " . "`build_counter`=IF(?, 0, `build_counter`), " . "`used_counter`=IF(?, 0, `used_counter`), " . "`clicks`=IF(?, 0, `clicks`) " . "WHERE `status`='holding' AND `type`='permanent' AND `date_displayed` <= SUBDATE(?, INTERVAL ? DAY)", array(intval($C['reset_on_rotate']), intval($C['reset_on_rotate']), intval($C['reset_on_rotate']), MYSQL_NOW, $C['permanent_hold'])); // Count total thumbs and galleries $GLOBALS['_totals'] = $DB->Row("SELECT COUNT(*) AS `galleries`,SUM(`thumbnails`) AS `thumbnails` FROM `tx_galleries` WHERE `status` IN ('approved','used')"); $GLOBALS['_totals']['categories'] = count($GLOBALS['CATEGORY_CACHE_ID']) - 1; // Build each page foreach ($pages as $page) { $page_all = $DB->Row('SELECT * FROM `tx_pages` WHERE `page_id`=?', array($page['page_id'])); if ($page_all['locked'] && !$GLOBALS['override_page_lock']) { continue; } if ($callback) { call_user_func($callback, $page_all); } $DB->Update('DELETE FROM `tx_gallery_used_page`'); $DB->Update('DELETE FROM `tx_ads_used_page`'); $DB->Update('UPDATE `tx_build_history` SET `current_page_url`=? WHERE `history_id`=?', array($page_all['page_url'], $GLOBALS['build_history_id'])); BuildPage($page_all); $DB->Update('UPDATE `tx_build_history` SET `pages_built`=`pages_built`+1 WHERE `history_id`=?', array($GLOBALS['build_history_id'])); unset($page_all); unset($page); } // Mark newly selected galleries as used // Update counters for galleries used this build $DB->Update('UPDATE `tx_galleries` JOIN `tx_gallery_used` USING (`gallery_id`) SET ' . '`build_counter`=`build_counter`+1, ' . '`used_counter`=`used_counter`+1, ' . '`times_selected`=IF(`new`=1, `times_selected`+1, `times_selected`), ' . '`status`=?, ' . '`date_displayed`=IF(`new`=1, ?, `date_displayed`) ' . 'WHERE `this_build`=1', array('used', MYSQL_NOW)); // Move no longer used galleries to holding queue (or rotate back to approved if permanent holding period is 0) if ($C['permanent_hold'] == 0) { $DB->Update('UPDATE `tx_galleries` LEFT JOIN `tx_gallery_used` USING (`gallery_id`) SET ' . "`status`=IF(`type`='permanent', 'approved', 'holding'), " . "`date_displayed`=IF(`type`='permanent', NULL, `date_displayed`), " . "`date_approved`=IF(`type`='permanent', NULL, `date_approved`), " . "`date_scheduled`=IF(`type`='permanent', NULL, `date_scheduled`), " . "`build_counter`=IF(`type`='permanent', IF(?, 0, `build_counter`+1), `build_counter`+1), " . "`used_counter`=IF(`type`='permanent', IF(?, 0, `used_counter`), `used_counter`), " . "`clicks`=IF(`type`='permanent', IF(?, 0, `clicks`), `clicks`) " . "WHERE `status`='used' AND `page_id` IS NULL", array(intval($C['reset_on_rotate']), intval($C['reset_on_rotate']), intval($C['reset_on_rotate']), 'used')); } else { $DB->Update('UPDATE `tx_galleries` LEFT JOIN `tx_gallery_used` USING (`gallery_id`) SET `status`=?,`build_counter`=`build_counter`+1 WHERE `status`=? AND `page_id` IS NULL', array('holding', 'used')); } $DB->Update('UPDATE `tx_build_history` SET `date_end`=?,`current_page_url`=NULL WHERE `history_id`=?', array(gmdate(DF_DATETIME, TimeWithTz()), $GLOBALS['build_history_id'])); flock($fd, LOCK_UN); fclose($fd); @chmod("{$GLOBALS['BASE_DIR']}/data/_build_lock", 0666); }
function ProcessAccount(&$account, &$exception) { global $configuration, $exceptions, $penalties, $DB, $config_id, $history_id; $removed = FALSE; $message = ''; $penalty = 0x0; $reasons = array('connect' => "Connection error: {$account['http']->errstr}", 'forward' => "Redirecting URL: {$account['http']->response_headers['status']}", 'broken' => "Broken URL: {$account['http']->response_headers['status']}", 'blacklist' => "Blacklisted data: " . htmlspecialchars($account['blacklist_item'])); // Determine the most strict penalty based on the infractions that were found foreach ($exceptions as $key => $value) { if ($exception & $value && $configuration['action_' . $key] >= $penalty) { $message = $reasons[$key]; $penalty = intval($configuration['action_' . $key], 16); } } // Blacklist if ($penalty & $penalties['blacklist']) { $action = 'Blacklisted'; $removed = TRUE; AutoBlacklist($account); DeleteAccount($account['username'], $account); // Update history $DB->Update('UPDATE `tlx_scanner_history` SET `exceptions`=`exceptions`+1,`blacklisted`=`blacklisted`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['delete']) { $action = 'Deleted'; $removed = TRUE; DeleteAccount($account['username'], $account); // Update history $DB->Update('UPDATE `tlx_scanner_history` SET `exceptions`=`exceptions`+1,`deleted`=`deleted`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['disable']) { $action = 'Disabled'; // Disable account $DB->Update('UPDATE `tlx_accounts` SET `disabled`=1 WHERE `username`=?', array($account['username'])); // Update history $DB->Update('UPDATE `tlx_scanner_history` SET `exceptions`=`exceptions`+1,`disabled`=`disabled`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['report']) { $action = 'Unchanged'; // Update history $DB->Update('UPDATE `tlx_scanner_history` SET `exceptions`=`exceptions`+1 WHERE `history_id`=?', array($history_id)); } else { // Do nothing $exception = 0x0; return $removed; } } } } $DB->Update('INSERT INTO `tlx_scanner_results` VALUES (?,?,?,?,?,?,?)', array($config_id, $account['username'], $account['site_url'], $account['http']->response_headers['status'], gmdate(DF_DATETIME, TimeWithTz()), $action, $message)); return $removed; }
<?php if (!defined('TGPX')) { die("Access denied"); } $defaults = array('submit_ip' => $_SERVER['REMOTE_ADDR'], 'status' => 'active', 'date_added' => gmdate(DF_DATETIME, TimeWithTz()), 'date_modified' => '', 'clicks' => 0, 'ratings' => 0, 'rating_total' => 0, 'weight' => $C['gallery_weight'], 'allow_scan' => true, 'allow_preview' => true); if (!$editing) { $_REQUEST = array_merge($defaults, $_REQUEST); } $categories =& $DB->FetchAll('SELECT `name`,`category_id` FROM `tx_categories` ORDER BY `name`'); $sponsors =& $DB->FetchAll('SELECT `sponsor_id`,`name` FROM `tx_sponsors` ORDER BY `name`'); $icons =& $DB->FetchAll('SELECT * FROM `tx_icons` ORDER BY `identifier`'); $jscripts = array('includes/calendar.js'); $csses = array('includes/calendar.css'); include_once 'includes/header.php'; ?> <script language="JavaScript"> $(function() { $('#description').bind('keyup', function() { $('#charcount').html($(this).val().length); }); $('#description').trigger('keyup'); }); function searchUsers() { var term = $('#partner').val(); if( !term ) { alert('Please enter an e-mail address or username to search for');
/** * Get the current date and time with timezone offset */ function lxGetDate() { global $json; $date = gmdate($_REQUEST['dateonly'] ? DF_DATE : DF_DATETIME, TimeWithTz()); echo $json->encode(array('status' => JSON_SUCCESS, 'date' => $date, 'field' => $_REQUEST['field'])); }
define('ST_GREATER_EQ', 'greatereq'); define('ST_LESS', 'less'); define('ST_LESS_EQ', 'lesseq'); define('ST_EMPTY', 'empty'); define('ST_ANY', 'any'); define('ST_IN', 'in'); define('ST_NOT_IN', 'not_in'); define('ST_NOT_EMPTY', 'not_empty'); define('ST_NULL', 'null'); define('ST_NOT_MATCHES', 'not_matches'); define('ST_NOT_NULL', 'not_null'); // Other define('MYSQL_EXPIRES', '2000-01-01 00:00:00'); define('MYSQL_NOW', gmdate(DF_DATETIME, TimeWithTz())); define('MYSQL_CURDATE', gmdate(DF_DATE, TimeWithTz())); define('TIME_NOW', TimeWithTz()); define('RE_DATETIME', '~^\\d\\d\\d\\d-\\d\\d-\\d\\d \\d\\d:\\d\\d:\\d\\d$~'); define('JSON_SUCCESS', 'Success'); define('JSON_FAILURE', 'Failure'); // Blacklist types $GLOBALS['BLIST_TYPES'] = array('submit_ip' => 'Submitter IP', 'email' => 'E-mail Address', 'url' => 'Domain/URL', 'domain_ip' => 'Domain IP', 'word' => 'Word', 'html' => 'HTML', 'headers' => 'HTTP Headers', 'dns' => 'DNS Server'); // Image file extensions $GLOBALS['IMAGE_EXTENSIONS'] = array('', 'gif', 'jpg', 'png'); function ProcessHourlyStats() { global $DB, $C; $now = TIME_NOW; $datetime = gmdate('Y-m-d-G', $now); // Lock tables to prevent multiple updates $DB->Query('LOCK TABLES `tlx_stored_values` WRITE, `tlx_account_hourly_stats` WRITE, `tlx_ip_log_in` WRITE, `tlx_ip_log_out` WRITE, `tlx_ip_log_clicks` WRITE'); $last_updates = unserialize(GetValue('last_updates'));
<?php if (!defined('ToplistX')) { die("Access denied"); } $defaults = array('status' => 'active', 'date_added' => gmdate(DF_DATETIME, TimeWithTz()), 'ratings' => 0, 'ratings_total' => 0, 'return_percent' => $C['return_percent']); if (!$editing) { $_REQUEST = array_merge($defaults, $_REQUEST); } $categories =& $DB->FetchAll('SELECT `name`,`category_id` FROM `tlx_categories` ORDER BY `name`'); $icons =& $DB->FetchAll('SELECT * FROM `tlx_icons` ORDER BY `identifier`'); $jscripts = array('includes/calendar.js'); $csses = array('includes/calendar.css'); include_once 'includes/header.php'; ?> <script language="JavaScript"> $(function() { $('#description').bind('keyup', function() { $('#description_charcount').html($(this).val().length); }); $('#description').trigger('keyup'); $('#title').bind('keyup', function() { $('#title_charcount').html($(this).val().length); }); $('#title').trigger('keyup'); updateRating(); }); function updateRating() { var ratings = parseInt($('#ratings').val());
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 ProcessLink(&$link, &$scan_result, $exception) { global $configuration, $exceptions, $penalties, $DB, $config_id; $deleted = FALSE; $message = ''; $penalty = 0x0; $reasons = array('connect' => "Connection Error: {$scan_result['site_url']['error']}", 'forward' => "Redirecting URL: {$scan_result['site_url']['status']}", 'broken' => "Broken URL: {$scan_result['site_url']['status']}", 'blacklist' => "Blacklisted Data: " . htmlspecialchars($scan_result['blacklist_item']), 'norecip' => "No Reciprocal Link Found"); // Determine the most strict penalty based on the infractions that were found foreach ($exceptions as $key => $value) { if ($exception & $value && $configuration['action_' . $key] >= $penalty) { $message = $reasons[$key]; $penalty = intval($configuration['action_' . $key], 16); } } // Blacklist if ($penalty & $penalties['blacklist']) { $action = 'Blacklisted'; $deleted = TRUE; AutoBlacklist($link); DeleteLink($link['link_id'], TRUE, $link); } else { if ($penalty & $penalties['delete']) { $action = 'Deleted'; $deleted = TRUE; DeleteLink($link['link_id'], TRUE, $link); } else { if ($penalty & $penalties['disable']) { $action = 'Disabled'; // Don't re-disable a link if ($link['status'] != 'disabled') { $DB->Update('UPDATE lx_links SET status=? WHERE link_id=?', array('disabled', $link['link_id'])); // Update category link count $result = $DB->Query('SELECT category_id FROM lx_links JOIN lx_link_cats USING (link_id) WHERE lx_links.link_id=?', array($link['link_id'])); while ($category = $DB->NextRow($result)) { UpdateLinkCount($category['category_id']); } $DB->Free($result); } } else { if ($penalty & $penalties['report']) { $action = 'Unchanged'; } else { // Do nothing return FALSE; } } } } $DB->Update('INSERT INTO lx_scanner_results VALUES (?,?,?,?,?,?,?)', array($config_id, $link['link_id'], $link['site_url'], $scan_result['site_url']['status'], gmdate(DF_DATETIME, TimeWithTz()), $action, $message)); return $deleted; }
function ProcessGallery(&$gallery, &$scan, &$exception) { global $configuration, $exceptions, $penalties, $DB, $config_id, $history_id; $removed = FALSE; $message = ''; $penalty = 0x0; $reasons = array('connect' => "Connection error: {$scan['errstr']}", 'forward' => "Redirecting URL: {$scan['status']}", 'broken' => "Broken URL: {$scan['status']}", 'blacklist' => "Blacklisted data: " . htmlspecialchars($scan['blacklist_item']), 'norecip' => "No reciprocal link found", 'no2257' => "No 2257 code found", 'excessivelinks' => "Too many links found on the gallery: {$scan['links']}", 'thumbchange' => "Thumbnail count has changed from {$gallery['thumbnails_old']} to {$scan['thumbnails']}", 'pagechange' => "Page content has changed", 'content_server' => 'The gallery content is not hosted on the same server as the gallery', 'badformat' => 'The gallery format is not allowed in this category'); // Determine the most strict penalty based on the infractions that were found foreach ($exceptions as $key => $value) { if ($exception & $value && $configuration['action_' . $key] >= $penalty) { $message = $reasons[$key]; $penalty = intval($configuration['action_' . $key], 16); } } // Blacklist if ($penalty & $penalties['blacklist']) { $action = 'Blacklisted'; $removed = TRUE; AutoBlacklist($gallery); DeleteGallery($gallery['gallery_id'], $gallery); // Update history $DB->Update('UPDATE `tx_scanner_history` SET `exceptions`=`exceptions`+1,`blacklisted`=`blacklisted`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['delete']) { $action = 'Deleted'; $removed = TRUE; DeleteGallery($gallery['gallery_id'], $gallery); // Update history $DB->Update('UPDATE `tx_scanner_history` SET `exceptions`=`exceptions`+1,`deleted`=`deleted`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['disable']) { $action = 'Disabled'; // Don't re-disable a gallery if ($gallery['status'] != 'disabled') { //$DB->Update('UPDATE `tx_galleries` SET `status`=?,`admin_comments`=? WHERE `gallery_id`=?', array('disabled', $message, $gallery['gallery_id'])); $gallery['previous_status'] = $gallery['status']; $gallery['status'] = 'disabled'; $gallery['admin_comments'] = $message; } // Update history $DB->Update('UPDATE `tx_scanner_history` SET `exceptions`=`exceptions`+1,`disabled`=`disabled`+1 WHERE `history_id`=?', array($history_id)); } else { if ($penalty & $penalties['report']) { $action = 'Unchanged'; // Update history $DB->Update('UPDATE `tx_scanner_history` SET `exceptions`=`exceptions`+1 WHERE `history_id`=?', array($history_id)); } else { // Do nothing $exception = 0x0; return $removed; } } } } $DB->Update('INSERT INTO `tx_scanner_results` VALUES (?,?,?,?,?,?,?)', array($config_id, $gallery['gallery_id'], $gallery['gallery_url'], $scan['status'], gmdate(DF_DATETIME, TimeWithTz()), $action, $message)); return $removed; }
function DailyPartnerMaintenance() { global $DB, $C; $args = ParseCommandLine(); // Remove inactive partner accounts if (isset($args['remove-inactive']) && is_numeric($args['remove-inactive'])) { $min_last_submit = gmdate(DF_DATETIME, TimeWithTz() - $args['remove-inactive'] * 86400); $result = $DB->Query('SELECT * FROM `tx_partners` WHERE `date_last_submit` <= ? OR (`date_last_submit` IS NULL AND `date_added` <= ?)', array($min_last_submit, $min_last_submit)); while ($partner = $DB->NextRow($result)) { DeletePartner($partner['username'], $partner); } $DB->Free($result); } // Send an e-mail message to partner accounts that are inactive if (isset($args['email-inactive']) && is_numeric($args['email-inactive'])) { // Prepare the template $t = new Template(); $t->assign_by_ref('config', $C); $t->assign('inactive', $args['email-inactive']); // Determine the time range to select $start = gmdate(DF_DATE, strtotime('-' . $args['email-inactive'] . ' day', TimeWithTz())) . ' 00:00:00'; $end = gmdate(DF_DATE, strtotime('-' . $args['email-inactive'] . ' day', TimeWithTz())) . ' 23:59:59'; // Find matching partners $result = $DB->Query('SELECT * FROM `tx_partners` WHERE `date_last_submit` BETWEEN ? AND ? OR (`date_last_submit` IS NULL AND `date_added` BETWEEN ? AND ?)', array($start, $end, $start, $end)); while ($partner = $DB->NextRow($result)) { $t->assign_by_ref('partner', $partner); SendMail($partner['email'], 'email-partner-inactive.tpl', $t); } $DB->Free($result); } // Send an e-mail message to partner accounts that are expiring soon if (isset($args['email-expiring']) && is_numeric($args['email-expiring'])) { // Prepare the template $t = new Template(); $t->assign_by_ref('config', $C); // Determine the time range to select $start = gmdate(DF_DATE, strtotime('+' . $args['email-expiring'] . ' day', TimeWithTz())) . ' 00:00:00'; $end = gmdate(DF_DATE, strtotime('+' . $args['email-expiring'] . ' day', TimeWithTz())) . ' 23:59:59'; // Find matching partners $result = $DB->Query('SELECT * FROM `tx_partners` WHERE `date_end` BETWEEN ? AND ?', array($start, $end)); while ($partner = $DB->NextRow($result)) { $partner['date_end'] = strtotime($partner['date_end']); $t->assign_by_ref('partner', $partner); SendMail($partner['email'], 'email-partner-expiring.tpl', $t); } $DB->Free($result); } }