Module to export videos to dump file

ivatigoal · 2013-12-06 11:40:10

I need a module to export videos at a dump file. I did sent you an email with more details. Please answer asap

With Regards,

Eri · 2013-12-06 11:48:46

I have made one, save it at main directory

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

header("content-type:text/txt;charset=utf-8");
ob_start();
$total = $_GET['total'];
if ($total<2) {
 $total=50;
}
$db				= VF::factory('database');
$current_date	= date('Y-m-d');
$index			= array();
			
$sql= "SELECT v.video_id, v.title, v.slug, v.description, v.ext, v.duration,
                              v.thumb, v.add_time,
GROUP_CONCAT(DISTINCT vc.name) AS categories,
                              GROUP_CONCAT(DISTINCT t.name) AS tags
                       FROM #__video AS v
 INNER JOIN #__video_category AS c ON (c.video_id = v.video_id)
			                       INNER JOIN #__video_categories AS vc ON (vc.cat_id = c.cat_id)
                       INNER JOIN #__video_tags AS t ON (t.video_id = v.video_id)
                       WHERE v.status = 1
                       AND v.embed_code = ''
                       GROUP BY v.video_id
                       ORDER BY video_id DESC
                       LIMIT $total";
$videos = $db->get_rows($sql);                  
foreach ($videos as $video) {   
 $categories	= explode(',', $video['categories']);
    echo ''.$video['video_id'].'|'.e($video['title']).'|'.BASE_URL.'/'.$video['video_id'].'/'.$video['slug'].'/|'.e($video['categories']).'|'.$video['tags'].'|'.BASE_URL.'/media/videos/tmb/'.path($video['video_id']).'/'.$video['thumb'].'.jpg|',(int) $video['duration'],'|<![CDATA[ <iframe width="588" height="475" src="http://sitename.com/embed.php?id='.$video['video_id'].'" frameborder="0"></iframe> ]]>',"\n";

  
}

$content	= ob_get_contents();
ob_end_clean();
echo $content;
?>

ivatigoal · 2013-12-06 11:59:16

You mean create a .php file with that code and place it at the main directory? how to i run it after?

ivatigoal · 2013-12-06 12:10:50

By the way thank you for your help but i need it to do very specific things. Thank you anyway

bugfix · 2013-12-17 16:53:06

Hey Eri
Very interesting possibilities here for me. I would need to input the dump back to the db after editing
a quick tutorial on doing this would be of great help.
Thanks

Eri · 2013-12-17 18:27:35

bugfix wrote:

Hey Eri
Very interesting possibilities here for me. I would need to input the dump back to the db after editing
a quick tutorial on doing this would be of great help.
Thanks

You can edit with driectadmin from your control panel, no need to do this.

bugfix · 2013-12-17 19:09:07

Hey I understand that ,,, but in my case i have a migration with videos that are not classified correctly tag or category wise. Over 3000 need review. Seems like this is a good solution via this or a xml edit. Then upload to db

Adult Script Pro Community Forums

#1 2013-12-06 11:40:10

Module to export videos to dump file

#2 2013-12-06 11:48:46

Re: Module to export videos to dump file

#3 2013-12-06 11:59:16

Re: Module to export videos to dump file

#4 2013-12-06 12:10:50

Re: Module to export videos to dump file

#5 2013-12-17 16:53:06

Re: Module to export videos to dump file

#6 2013-12-17 18:27:35

Re: Module to export videos to dump file

#7 2013-12-17 19:09:07

Re: Module to export videos to dump file

Board footer