Adult Script Pro Community Forums

<?php
define('_VALID', true);
require 'libraries/bootstrap.php';


function build_csv($videos, $fields, $method)
{
	$columns	= array_flip(explode(',', $fields));
	$filter		= VF::factory('filter');
$access_key	= (isset($_GET['key'])) ? $filter->get('key', 'STRING', 'GET') : '';
if ($access_key == '') {
	die('Invalid access key (1)!');
}

$emodel		= VModel::load('export', 'video');
if (!$export = $emodel->get($access_key)) {
	die('Invalid access key (2)!');
}
	
	
	$main_url = "https://www.example.com";
	$output		= array();
	foreach ($videos as $video) {
		$video_id	= (int) $video['video_id'];
		$entry		= array();
		
		if (isset($columns['video_id'])) {
			$entry[$columns['video_id']] 	= $video_id;
		}
		
		if (isset($columns['url'])) {
			$entry[$columns['url']]			= video_view_url($video_id, $video['slug']."/?utm_source=".$export['csource']."&utm_medium=".$export['cmedium']."&utm_campaign=".$export['cexport']."", null, false, true);
		}
		
		if (isset($columns['title'])) {
			$entry[$columns['title']]		= $video['title'];
		}

		if (isset($columns['description'])) {
			$entry[$columns['description']]	= $video['description'];
		}		

		if (isset($columns['categories'])) {
			$entry[$columns['categories']]	= $video['categories'];
		}

		if (isset($columns['tags'])) {
			$entry[$columns['tags']]		= $video['tags'];
		}

		if (isset($columns['duration'])) {
			$entry[$columns['duration']]	= (int) $video['duration'];
		}

		if (isset($columns['add_date'])) {
			$entry[$columns['add_date']]	= date('Y-m-d H:i:s', $video['add_time']);
		}

		if (isset($columns['thumb'])) {
			$entry[$columns['thumb']]		= $main_url .''. THUMB_URL.'/'.path($video['video_id']).'/'.$video['thumb'].'.jpg';
		}

		if (isset($columns['thumbs'])) {
			$thumbs	= array();
			for ($thumb = 1; $thumb <= $video['thumbs']; $thumb++) {
				$thumbs[]					= $main_url .''. THUMB_URL.'/'.path($video['video_id']).'/'.$thumb.'.jpg';
			}
		
			$entry[$columns['thumbs']]		= implode(',', $thumbs);
		}

		if (isset($columns['embed'])) {
			$entry[$columns['embed']]		= ($video['embed_code'] != '') ? $video['embed_code'] : '<iframe src="'.BASE_URL.'/embed/'.$video_id.'/" width="100%" height="100%" frameborder="0" border="0" scrolling="no"></iframe>';
		}		
		
		ksort($entry);
		$output[]	= implode('|', $entry);
	}
	
			$date = date("Y-m-d");
			$p =  implode("\n", $output);
			$p =  file_put_contents('webmasters/CSV_export-'.$date.'.csv',$p);
			$p;
	 
			  // output headers so that the file is downloaded rather than displayed
		  header("Content-type: text/csv");
		  header("Content-disposition: attachment; filename = ".$main_url."/webmasters/CSV_export-".$date.".csv");
		  readfile("".$main_url."/webmasters/CSV_export-".$date.".csv");
			
}



$videos	= $emodel->videos($args);
if ($ext == 'xml') {
	$content	= build_xml($videos, $fields, $method);
} else {
	$content	= build_csv($videos, $fields, $method);
}

if ($export['cache_ttl'] > 0 and $timeline == 'all') {
	file_put_contents($cache_file, $content);
}

echo $content;

VF::close();