RSS embed Video import and Pornstars db specification needed

German-Porn-Tube · 2012-03-27 13:54:40

Hello

We are currently planning an offer with German actors from the amateur field.

For this purpose it is both a Pornstar dump and of course give the corresponding videos.

The Webmaster can be either read to all videos via RSS or per girl or niche.

The short videos will be released reff (30 sec - 90 sec)
The long videos (3,5 min - 1 h and more) can be for example be marketed - in the premium segment - with reff.

I need the specification of the read field of the ASP so that we can provide the required interface.

greatings

info@german-porn-tube.com

symtab · 2012-03-28 05:45:33

I dont understand what exactly you need. The database? OR?

German-Porn-Tube · 2012-03-28 17:22:26

Hello

I need four things:

First
a) Mass RSS import videos:
The fields that need an RSS feed to read videos?

b) Mass CSV import video (embeded)
Which fields nessesary a CSV file to be read?

Second
a) Pornstars RSS import:
Which fields are necessary to be able to read Pornstars?

b) Pornstar CSV import
Which fields are required to read a CSV file can be?

So looks like a source file would have.

We plan to provide these 4 files for ASP Webmaster.

regards

THS · 2012-03-28 18:12:06

I think you are saying you want to add RSS feeds to the default install of ASPro so you can allow other webmasters to read your site, i.e. be a pornhub/redtube. Is this correct?

German-Porn-Tube · 2012-03-28 18:15:01

right

yes i want to offer this feeds :-)

I wil be a external soloution for many scripts - but want to start with ASP :-)

symtab · 2012-03-28 18:44:53

Well....i'm still confused. You want us to provide you with the database columns so that you can use them in the tools? Or? The script itself does not offer such tools.

ful2fun.com · 2012-03-28 19:10:11

As Per My Understanding he Want to Offer This Tools Like Other Affiliates To Promote Its Site.

ful2fun.com
livesexpirates.com

THS · 2012-03-28 21:14:18

Symtab, right now the script does not offer this as I understand it (I may be wrong - your the dev).

What he wants is a RSS export feed that would allow other sites to import his data into their database for the videos and pornstars (export in CSV and RSS). He wants to use this script to setup a RedTube with all of those features, i.e. become a host and not a consumer as we all are.

German-Porn-Tube and Ful2Fun.com did I get this right?

German-Porn-Tube · 2012-03-28 22:22:11

THS and Ful2Fun - you right

i setup a host - where German Amateurs can load up her/his Videos for Tubemarketing and Webmaster can register and take this Videos and the Pornstar Database into there Tubes.

Is a external solution - now i must write the export Tool for ASP and must know witsh Filds are must be there.

This Videos where first exclusiv for ASP-Webmaster and then step by step to other Scripts ...

;-) with one Script we want to start ... thinking ASP ist the right for it.

THS · 2012-03-29 00:28:03

Well, it really depends on what you want to offer, but its going to come from the _video and _model tables and any dependent data you wish to include. I would say the best bet is to cruise through the data via phpMyAdmin and see what you want to offer. Anyway, here is the code for import on an ASP site. You would probably want to offer at a minimum these fields.

$this->db->query("INSERT INTO #__video
						                  SET user_id = ".$user_id.",
						                      title = '".$this->db->escape($values['title'])."',
						                      slug = '".$this->db->escape($slug)."',
						                      description = '".$this->db->escape($values['description'])."',
						                      type = '".$this->db->escape($type)."',
						                      embed_code = '".$this->db->escape($embed)."',
						                      url = '".$this->db->escape($url)."',
						                      sponsor = ".$sponsor.",
						                      add_date = '".date('Y-m-d h:i:s')."',
						                      add_time = ".time().",
						                      premium = '".$premium."',
						                      status = 5");

$this->db->query("INSERT INTO #__video_category
							                  SET video_id = ".$video_id.",
							                      cat_id = ".$cat_id);

$this->db->query("INSERT INTO #__video_tags
							                  SET video_id = ".$video_id.",
							                      name = '".$this->db->escape($tag)."'");

$this->db->query("INSERT INTO #__model_videos
								                  SET model_id = ".$model_id.",
								                      video_id = ".$video_id);

Don't forget your path to the thumbs.

German-Porn-Tube · 2012-03-29 00:35:52

ths - thanks!

symtab · 2012-03-29 07:09:29

You might find this useful:

$db->query("SELECT v.video_id, v.title, v.slug, v.duration, v.thumb, v.thumbs, u.username,
                   GROUP_CONCAT(DISTINCT t.name) AS tags,
                   GROUP_CONCAT(DISTINCT c.name) AS categories,
                   GROUP_CONCAT(DISTINCT m.name) AS models
            FROM #__video AS v
            LEFT JOIN #__video_category AS vc ON (vc.video_id = v.video_id)
            LEFT JOIN #__video_categories AS c ON (c.cat_id = vc.cat_id)
            LEFT JOIN #__video_tags AS t ON (t.video_id = v.video_id)
            LEFT JOIN #__model_videos AS mv ON (mv.video_id = v.video_id)
            LEFT JOIN #__model AS m ON (m.model_id = mv.model_id)
            LEFT JOIN #__user AS u ON (u.user_id = v.user_id AND u.status = '1')
            WHERE v.embed_code = ''
            AND v.status = 1
            GROUP BY v.video_id".$LIMIT);

Adult Script Pro Community Forums

#1 2012-03-27 13:54:40

RSS embed Video import and Pornstars db specification needed

#2 2012-03-28 05:45:33

Re: RSS embed Video import and Pornstars db specification needed

#3 2012-03-28 17:22:26

Re: RSS embed Video import and Pornstars db specification needed

#4 2012-03-28 18:12:06

Re: RSS embed Video import and Pornstars db specification needed

#5 2012-03-28 18:15:01

Re: RSS embed Video import and Pornstars db specification needed

#6 2012-03-28 18:44:53

Re: RSS embed Video import and Pornstars db specification needed

#7 2012-03-28 19:10:11

Re: RSS embed Video import and Pornstars db specification needed

#8 2012-03-28 21:14:18

Re: RSS embed Video import and Pornstars db specification needed

#9 2012-03-28 22:22:11

Re: RSS embed Video import and Pornstars db specification needed

#10 2012-03-29 00:28:03

Re: RSS embed Video import and Pornstars db specification needed

#11 2012-03-29 00:35:52

Re: RSS embed Video import and Pornstars db specification needed

#12 2012-03-29 07:09:29

Re: RSS embed Video import and Pornstars db specification needed

Board footer