Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

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

ivatigoal
Member
Registered: 2013-06-07
Posts: 367
Website

Module to export videos to dump file

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,


Analtube4u

Offline

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

Eri
Member
Registered: 2011-03-18
Posts: 977

Re: Module to export videos to dump file

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;
?>

Best Adult Affilitate Network:
ExoClick
Best Deals on Dedicated Servers - CDN
INXY

Offline

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

ivatigoal
Member
Registered: 2013-06-07
Posts: 367
Website

Re: Module to export videos to dump file

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


Analtube4u

Offline

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

ivatigoal
Member
Registered: 2013-06-07
Posts: 367
Website

Re: Module to export videos to dump file

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


Analtube4u

Offline

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

bugfix
Member
Registered: 2013-11-14
Posts: 15

Re: Module to export videos to dump file

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

Offline

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

Eri
Member
Registered: 2011-03-18
Posts: 977

Re: Module to export videos to dump file

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.


Best Adult Affilitate Network:
ExoClick
Best Deals on Dedicated Servers - CDN
INXY

Offline

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

bugfix
Member
Registered: 2013-11-14
Posts: 15

Re: Module to export videos to dump file

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

Offline

Board footer

Powered by FluxBB