= 2) { switch($_GET['step']) { case 'view': case 'site': if($_GET['id']) { $id = clean($_GET['id']); $site = mysql_fetch_array(mysql_query("SELECT * FROM `sites` WHERE `id` = '$id' AND `owner` = '{$info['id']}'")); if($site) { $main = $main . '

'; if($_GET['action'] == 'edit') { $name = clean($_POST['name']); $url = clean($_POST['url']); mysql_query("UPDATE `sites` SET `name` = '$name', `url` = '$url', `approved` = 'N' WHERE `id` = '$id'") or die(mysql_error()); $main = $main . ''; $site = mysql_fetch_array(mysql_query("SELECT * FROM `sites` WHERE `id` = '$id' AND `owner` = '{$info['id']}'")); } $main = $main . ''; if($_GET['action'] == 'delete' && $_GET['delete']) { $delete = clean($_GET['delete']); mysql_query("DELETE FROM `banners` WHERE `id` = '$delete' AND `site` = '$id'") or die(mysql_error()); unlink($bannerpath . $id . '-' . $delete . '.png'); } $banners = mysql_query("SELECT * FROM `banners` WHERE `site` = '$id'"); while($banner = mysql_fetch_array($banners)) { if($banner['approved'] == 'Y') { $color = 'green'; } else { $color = 'red'; } $main = $main . ''; } $main = $main . '

Site information.
Your site info has been updated.
Name:
Url (http://format)
(Check your link)
Warning: After updating your site will need approval again.
Banners
(Delete banner)
ApprovedNot approved
Your code (in PHP): <?php include(\'http://' . $_SERVER['HTTP_HOST'] . '/banner.php?id=' . $info['id'] . '\'); ?>
Email me for other options
(Add banner) | (Main)

'; //<object data="' . $_SERVER['HTTP_HOST'] . 'banner.php?id=' . $info['id'] . '" style="width:468px;height:60px" marginwidth="0" marginheight="0" scrolling="no" /> } } break; case 'banners': if($info['access'] > 3) { $main = $main . ''; if($_GET['action'] == 'submit') { $id = clean($_POST['id']); mysql_query("UPDATE `banners` SET `approved` = 'Y' WHERE `id` = '$id'") or die(mysql_error()); echo(''); } } break; break; case 'approve': if($info['access'] > 3) { if($_GET['approve'] == 'sites') { $main = $main . ''; } else { $main = $main . ''; } } break; case 'add': switch($_GET['add']) { case 'banner': if($_REQUEST['site'] && is_numeric($_REQUEST['site'])) { switch($_GET['action']) { case 'submit': if($_FILES['banner']['tmp_name'] || $_POST['banner']) { if($_FILES['banner']['name']) { $ban = $_FILES['banner']['tmp_name']; $ban2 = $_FILES['banner']['name']; } else { $ban = clean($_POST['banner']); $ban2 = clean($_POST['banner']); } $filext = explode('.', $ban2); $i = count($filext) - 1; $filext[$i] = strtolower($filext[$i]); if($filext[$i] == 'png' || $filext[$i] == 'jpg' || $filext[$i] == 'gif') { switch($filext[$i]) { case 'png': $image = imagecreatefrompng($ban); break; case 'jpg': $image = imagecreatefromjpeg($ban); break; case 'gif': $image = imagecreatefromgif($ban); break; } if(imagesx($image) > 0 && imagesy($image) > 0) { $banner = imagecreatetruecolor(468, 60); imagecopyresized($banner, $image, 0 , 0, 0, 0, 468, 60, imagesx($image), imagesy($image)); $site = clean($_POST['site']); $dir = opendir($bannerpath); $num = 0; while($files = readdir($dir)) { $file = explode('-', $files); if($file[0] == $site) { $num ++; } } $num++; imagepng($banner, $bannerpath . $site . '-' . $num . '.png'); imagedestroy($image); imagedestroy($banner); mysql_query("INSERT INTO `banners` (`site`, `number`) VALUES ('$site', '$num')"); email('RPG Top List ', 'billing@lotdhosting.com', 'banner added', '', ''); $main = $main . ''; } } } break; case 'new': $main = $main . ''; break; case 'import': $main = $main . ''; break; default: $main = $main . ''; break; } } break; case 'site': switch($_GET['action']) { case 'new': if($_GET['do']== 'submit') { $name = clean($_POST['name']); $url = clean($_POST['url']); $site = mysql_num_rows(mysql_query("SELECT * FROM `sites` WHERE `owner` = '{$info['id']}'")); $import = mysql_fetch_array(mysql_query("SELECT `id` FROM `sites` WHERE `url` = '{$game['url']}' AND `name` = '{$game['name']}'")); if(!$site) { $allowance = 100; } else { $allowance = 0; } if(!$import && $name && $url) { mysql_query("INSERT INTO `sites` (`name`, `url`, `owner`, `allowance`) VALUES ('$name', '$url', '{$info['id']}', $allowance)"); email('RPG Top List ', 'billing@lotdhosting.com', 'site added', '', ''); $main = $main . ''; } else { $main = $main . ''; } } else { $main = $main . ''; } break; case 'import': if($_GET['do']== 'submit') { $id = clean($_POST['id']); $game = mysql_fetch_array(mysql_query("SELECT * FROM `games` WHERE `id` = '$id'")); $import = mysql_fetch_array(mysql_query("SELECT `id` FROM `sites` WHERE `url` = '{$game['url']}' AND `name` = '{$game['name']}'")); $site = mysql_query("SELECT * FROM `sites` WHERE `owner` = '{$info['id']}'"); if(!$site) { $allowance = 100; } else { $allowance = 0; } if(!$import) { mysql_query("INSERT INTO `sites` (`name`, `url`, `owner`, `allowance`) VALUES ('{$game['name']}', '{$game['url']}', '{$game['ownerid']}', $allowance)"); $main = $main . ''; } else { $main = $main . ''; } } else { $main = $main . ''; } break; default: $main = $main . ''; break; } break; default: header('location:' . $_SERVER['PHP_SELF']); break; } break; default: if($_GET['id'] && $_GET['action'] == 'allowance' && is_numeric($_POST['allowance'])) { $id = clean($_GET['id']); $allowance = clean($_POST['allowance']); mysql_query("UPDATE `sites` SET `allowance` = '$allowance' WHERE `id` = '$id' AND `owner` = '{$info['id']}'"); } $main = $main . ''; break; } } else { $main = $main . 'Please get a developer account if you want to access our banner exchange.'; } include('footer.php'); ?>

Banner	Link	Site
Banner has been approved.
'; if($_GET['action'] == 'submit') { $id = clean($_GET['id']); mysql_query("UPDATE `sites` SET `approved` = 'Y' WHERE `id` = '$id'") or die(mysql_error()); $main = $main . ''; } $approve = mysql_query("SELECT * FROM `sites` WHERE `approved` = 'N'"); while($val = mysql_fetch_array($approve)) { $main = $main . ''; } $main = $main . ' Name Url Site has been approved. ' . $val['name'] . ' ' . $val['url'] . ' View banners Approve
'; if($_GET['action'] == 'submit') { $id = clean($_GET['id']); mysql_query("UPDATE `banners` SET `approved` = 'Y' WHERE `id` = '$id'") or die(mysql_error()); $main = $main . ''; } $approve = mysql_query("SELECT * FROM `banners` WHERE `approved` = 'N'"); while($val = mysql_fetch_array($approve)) { $site = mysql_fetch_array(mysql_query("SELECT * FROM `sites` WHERE `id` = '{$val['site']}'")); $main = $main . ''; } $main = $main . ' Banner Site Banner has been approved. ' . $site['url'] . ' View banners Approve
Added banner successfully. Click here to go back.
URL (http://):
Upload new banner Import already uploaded banner
Your site has been added. Please add your banners now then wait for approval. (Back)
Site already seems to exist.
Fill in your site\'s information below Name: Url (http:// format):
Your game has been imported. Please add your banners now then wait for approval. (Back)
Game already seems imported.
Choose game '; $games = mysql_query("SELECT * FROM `games` WHERE `ownerid` = '{$info['id']}'"); while($game = mysql_fetch_array($games)) { $main = $main . '' . $game['name'] . ''; } $main = $main . '
Add new site Import game listing
'; $sites = mysql_query("SELECT * FROM `sites` WHERE `owner` = '{$info['id']}'"); while($site = mysql_fetch_array($sites)) { if($site['approved'] == 'N') { $status = 'Awaiting approval, please make a sure a banner has been added.'; } elseif(!$site['allowance']) { $status = 'Paused'; } else { $status = 'Circulating'; } $totall += $site['allowance']; $main = $main . ''; } if($totall > 100 || $totall < 0) { $main = $main . ''; } $main = $main . ''; if($info['access'] > 3) { $main = $main . ''; } $main = $main . ' Sites Credits Credit Allowance (%) Status ' . $site['name'] . ' ' . $info['credits'] * ($site['allowance']/100) . ' ' . $status . ' Warning: Your total credit allowance needs to be between 0% and 100% to work, it is currently ' . $totall . '%. (Add site) (Approve banners) | (Approve sites)