<? 
ignore_user_abort();
ini_set('max_execution_time',86400);

require "header.php"; 
if($_POST[dump]) {
	unset($arr);
	$arr = explode("\n",$_POST[dump]);
	foreach($arr as $key=>$value) {
		$k = explode('|',$value);
		if($_POST[select1]) { $import[$key][$_POST[select1]] = $k[0]; }
		if($_POST[select2]) { $import[$key][$_POST[select2]] = $k[1]; }
		if($_POST[select3]) { $import[$key][$_POST[select3]] = $k[2]; }
		if($_POST[select4]) { $import[$key][$_POST[select4]] = $k[3]; }
		if($_POST[select5]) { $import[$key][$_POST[select5]] = $k[4]; }
		if($_POST[select6]) { $import[$key][$_POST[select6]] = $k[5]; }
		if($_POST[select7]) { $import[$key][$_POST[select7]] = $k[6]; }
		if($_POST[select8]) { $import[$key][$_POST[select8]] = $k[7]; }
		if($_POST[select9]) { $import[$key][$_POST[select9]] = $k[8]; }
		if($_POST[select10]) { $import[$key][$_POST[select10]] = $k[9]; }
		if($_POST[select11]) { $import[$key][$_POST[select11]] = $k[10]; }
		if($_POST[select12]) { $import[$key][$_POST[select12]] = $k[11]; }
	}
	$counter = 0;
	$errors = 0;
	foreach($import as $i) {
		if($i[name]) { 
			$i = mysql_real_escape_array($i); 
			$tmp = mysql_query("SELECT * FROM paysites WHERE name LIKE '$i[name]'");
			if(mysql_num_rows($tmp) < 1) { 
				if(mysql_query("INSERT INTO paysites SET name = '$i[name]', user = '$_POST[submitter]', url = '$i[url]', ad0 = '$i[ad0]',  ad1 = '$i[ad1]',  ad2 = '$i[ad2]',  ad3 = '$i[ad3]',  ad4 = '$i[ad4]',  ad5 = '$i[ad5]',  ad6 = '$i[ad6]',  ad7 = '$i[ad7]',  ad8 = '$i[ad8]',  ad9 = '$i[ad9]'")) { 
					$counter++;
				} else {
					$errors++; 
				}
			} else {
				$errors++; 
			}
		} else {
			$errors++; 
		}
	}
	$message = "<p><strong>$counter paysites were added. $errors paysites were not added.</strong></p>"; 
	
}
?>
<div id="right_column">
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            <span><a href="paysites_csv.php">CSV Import</a></span>  
            </div>
        </div>
        <div id="right_bg">  
      		<h2>CSV<strong>Paysites</strong></h2>
            <? if($message) { echo $message; } else { ?>
            <p>Imports must be delimited by | (aka. pipes) only!</p>
            <p>Please note: Make sure you don't accidently put any linebreaks, as it will produce undesirable results with your import!<br />
            	<? } ?>
           	</p>
            <div id="index_left" style='width: 100%;'>            

<form id="form1" name="form1" method="post" action="">
  <p><strong>Import Format</strong>: <br />
  	<? for($i = 1; $i <= 12; $i++) { ?>
    <select name="select<? echo $i; ?>">
      <option value='' selected="selected">-</option>
	  <option value="name">name</option>
      <option value="url">url</option>      
      <option value="ad0">ad0</option>
      <option value="ad1">ad1</option>
	  <option value="ad2">ad2</option>
	  <option value="ad3">ad3</option>
	  <option value="ad4">ad4</option>
	  <option value="ad5">ad5</option>
	  <option value="ad6">ad6</option>
	  <option value="ad7">ad7</option>
	  <option value="ad8">ad8</option>
	  <option value="ad9">ad9</option>
    </select>
<? } ?>
  </p>
 
  <p><strong>Partner:</strong> <br />
     <select name="submitter" id="select">
            <? 
            $result = mysql_query("SELECT * FROM users ORDER BY username ASC");
            while($row =mysql_fetch_array($result)) {
                echo "<option value='$row[record_num]'>$row[username]</option>";
            }
            ?>	
            </select>	
  </p>

    <p><strong>Dump:</strong> <br />

    <textarea name="dump" style='width: 98%;' rows="10" id="dump" wrap='off'></textarea>

  </p>
  <input type='submit' name='submit' value='Submit' />
</form>
            </div>
        </div>
        <div id="right_bottom"></div>
        </div>
    </div>
</div>


<? require "footer.php"; ?>