<? 
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]; }
	}
	$counter = 0;
	$errors = 0;
	foreach($import as $i) {
		$i = mysql_real_escape_array($i); 
		if(mysql_query("INSERT INTO csv_import_photos (title, flv, thumb, `desc`, embed, keywords, lengthsec, paysite, default_paysite, hotlink, submitter,pornstars,local,plugurl) VALUES ('$i[title]', '$i[flv]', '$i[thumb]', '$i[desc]', '$i[embed]', '$i[keywords]', '$i[length]', '$i[paysite]', '$_POST[default_paysite]', '$_POST[ishotlinked]', '$_POST[submitter]','$i[pornstars]','$i[local]','$i[plugurl]')")) { 
			$counter++;
		} else {
			$errors++; 
		}
	}
	$message = "<p><strong>$counter videos added to import queue. $errors videos were not added.</strong></p>"; 
	if($counter > 0) {
		$pid = backgroundProcess("$php_path $basepath/admin/csv_photos_cron.php","csv_photo_log.txt");
		$message .= "<p>CSV Importer has been started as PID: $pid</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="csv_import.php">CSV Import</a></span>  
            </div>
        </div>
        <div id="right_bg">  
      		<h2>CSV<strong>Photos</strong></h2>
            <? if($message) { echo $message; } else { ?>
            <p>Imports must be delimited by | (aka. pipes) only!</p>
            <p>Please note: This will not work on 100% of galleries! It will fail on photo galleries that do not link directly to jpg files.<br />
            	<? } ?>
           	</p>
            <div id="index_left" style='width: 100%;'>            

<form id="form1" name="form1" method="post" action="">
  <p><strong>Import Format</strong>: <br />
    <select name="select1" id="select2">
       <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>
    <select name="select2" id="select3">
       <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>  
    <select name="select3" id="select4">
      <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>  
    <select name="select4" id="select5">
      <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>  
    <select name="select5" id="select6">
      <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>  
    <select name="select6" id="select7">
       <option value='' selected="selected">-</option>
       <option value="local">directory</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>  
    <select name="select7" id="select8">
       <option value='' selected="selected">-</option>
	  <option value="flv">url</option>
      <option value="title">title</option>      
      <option value="desc">desc</option>
      <option value="keywords">keywords</option>
      <option value="paysite">paysite</option>
      <option value="pornstars">pornstars</option>
    </select>
  </p>
  <p><strong>Default Paysite (Only used if no paysite is provided for video):</strong> <br />
    <select name='default_paysite' id="default_paysite">
          <?
        $rresult = mysql_query("SELECT * FROM paysites ORDER BY name ASC");
        while($rrow = mysql_fetch_array($rresult)) {
            if($row[paysite] == $rrow[record_num]) { $selected = 'selected'; } else { $selected = ''; }
            echo "<option $selected value='$rrow[record_num]'>$rrow[name]</option>";
        }
        ?>
    </select>
  </p>
  <p><strong>Submitter:</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"; ?>