Tech Tube SEO optimization automation - GoFuckYourself.com

BalzacVinaigrette · 09-30-2017, 12:20 AM

I've tried a couple of tube scripts. They work fine for publishing large numbers of videos. What they don't do is give a way to automate handling the video post's on-page SEO. That still has to be done by hand for each video.

I'm currently using WP-Script for WordPress.

Is there a way to automate at least some of the SEO for WordPress posts, or another tube script that does this?

Thanks!

B

magneto664 · 09-30-2017, 05:22 AM

cyberseo + yoast + custom fields.

Tube Ace · 10-25-2017, 02:16 PM

What do you mean by "has to be done by hand for each video"?

The on-page SEO is dependent on the theme you are using.

Barry-xlovecam · 10-26-2017, 03:07 AM

mysql -u********** -p********** -e "SELECT tags FROM xvideos WHERE MATCH (tags) against ('+Big +(Penis dick cock)' in boolean mode);" > /path/big-penis-tags-less~gay.csv

mysql -u********** -p********** -e "SELECT tags FROM seo.xvideos WHERE MATCH (tags) against (' +Cougar +MILF' in boolean mode);" >/path/tag-study/cougar-tags.csv

SELECT tags FROM seo.xvideos WHERE tags LIKE '%Buttplug%';" >/path/tag-study/buttplug-tags.csv

xvideos distributes a database of all their current data (still?) The database is over 4 million rows and doing these or similar queries is rather slow -- sometimes over 15 seconds here depending on the query's complexity.

Code:

mysql> SHOW CREATE TABLE xvideos;

| xvideos | CREATE TABLE `xvideos` (
  `url` char(50) NOT NULL,
  `performer` char(30) NOT NULL,
  `runtime` char(12) DEFAULT NULL,
  `thumb` char(120) DEFAULT NULL,
  `iframeCode` char(200) DEFAULT NULL,
  `tags` char(200) DEFAULT NULL,
  `category` char(60) DEFAULT NULL,
  KEY `category` (`category`(10)),
  FULLTEXT KEY `idx_1` (`category`),
  FULLTEXT KEY `idx_2` (`tags`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |

1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM  xvideos;
+----------+
| COUNT(*) |
+----------+
|  4543335 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT tags FROM seo.xvideos   WHERE tags LIKE '%girl%';
602301 rows in set (10.98 sec)

SELECT tags FROM seo.xvideos   WHERE category LIKE '%girl%';
169530 rows in set (1.68 sec)

SELECT tags FROM seo.xvideos   WHERE MATCH (tags) against (' +Cougar +MILF'  in boolean mode);
62322 rows in set (12.35 sec)

But this is of limited value as it is only filtering the word groups used as descriptive by the video's uploader and as such is very subjective. I don't think the costs of designing and developing an AI, or even a 'dumb-bot', schema and program code for the purpose of describing tube videos on traffic blogs and other sites would be worth the expense -- there is not that much money in it -- but it could be done probably.

09-30-2017, 12:20 AM	#1
BalzacVinaigrette Registered User Industry Role: Join Date: Oct 2015 Posts: 18	Tube SEO optimization automation I've tried a couple of tube scripts. They work fine for publishing large numbers of videos. What they don't do is give a way to automate handling the video post's on-page SEO. That still has to be done by hand for each video. I'm currently using WP-Script for WordPress. Is there a way to automate at least some of the SEO for WordPress posts, or another tube script that does this? Thanks! B __________________ Free Nasty Porn Videos at SleazeTubes.com Explosive Hardcore Bondage Porn at StripnStrangle.com

09-30-2017, 05:22 AM	#2
magneto664 God Bless You Industry Role: Join Date: Aug 2014 Location: Glasgow, $cotland Posts: 1,467	cyberseo + yoast + custom fields. __________________ magneto664 📧 gmail.com Adult Backlinks 💘Best Website Stats 💘 Best CDN for Adult Content My Fav: 👍Chaturbate 👍 Stripchat 👍 Dateprofits 👍 AdultFriendFinder

10-26-2017, 03:07 AM	#4
Barry-xlovecam It's 42 Industry Role: Join Date: Jun 2010 Location: Global Posts: 18,083	mysql -u******** -p****** -e "SELECT tags FROM xvideos WHERE MATCH (tags) against ('+Big +(Penis dick cock)' in boolean mode);" > /path/big-penis-tags-less~gay.csv mysql -u****** -p******** -e "SELECT tags FROM seo.xvideos WHERE MATCH (tags) against (' +Cougar +MILF' in boolean mode);" >/path/tag-study/cougar-tags.csv SELECT tags FROM seo.xvideos WHERE tags LIKE '%Buttplug%';" >/path/tag-study/buttplug-tags.csv xvideos distributes a database of all their current data (still?) The database is over 4 million rows and doing these or similar queries is rather slow -- sometimes over 15 seconds here depending on the query's complexity. Code: mysql> SHOW CREATE TABLE xvideos; \| xvideos \| CREATE TABLE `xvideos` ( `url` char(50) NOT NULL, `performer` char(30) NOT NULL, `runtime` char(12) DEFAULT NULL, `thumb` char(120) DEFAULT NULL, `iframeCode` char(200) DEFAULT NULL, `tags` char(200) DEFAULT NULL, `category` char(60) DEFAULT NULL, KEY `category` (`category`(10)), FULLTEXT KEY `idx_1` (`category`), FULLTEXT KEY `idx_2` (`tags`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 \| 1 row in set (0.00 sec) mysql> SELECT COUNT() FROM xvideos; +----------+ \| COUNT() \| +----------+ \| 4543335 \| +----------+ 1 row in set (0.00 sec) mysql> SELECT tags FROM seo.xvideos WHERE tags LIKE '%girl%'; 602301 rows in set (10.98 sec) SELECT tags FROM seo.xvideos WHERE category LIKE '%girl%'; 169530 rows in set (1.68 sec) SELECT tags FROM seo.xvideos WHERE MATCH (tags) against (' +Cougar +MILF' in boolean mode); 62322 rows in set (12.35 sec) But this is of limited value as it is only filtering the word groups used as descriptive by the video's uploader and as such is very subjective. I don't think the costs of designing and developing an AI, or even a 'dumb-bot', schema and program code for the purpose of describing tube videos on traffic blogs and other sites would be worth the expense -- there is not that much money in it -- but it could be done probably.

10-25-2017, 02:16 PM	#3
Tube Ace So Fucking Banned Industry Role: Join Date: Nov 2008 Location: with your dream girl Posts: 4,941	What do you mean by "has to be done by hand for each video"? The on-page SEO is dependent on the theme you are using.