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.
- Topics: Active | Unanswered
Pages: 1
#1 2011-06-12 13:11:01
- Eri
- Member
- Registered: 2011-03-18
- Posts: 977
Offline
#2 2011-06-12 22:55:40
Re: remove - from tags
Well to delete the description in all videos just make a php query that overwrites the field with blanks.
Offline
#3 2011-06-13 08:21:59
Re: remove - from tags
For the description:
UPDATE video SET description = '';The above will delete the description for all videos.
To remove the - from the tags (BACKUP FIRST!!!!!):
<?php
define('_VALID', true);
require 'libraries/bootstrap.php';
$db = VF::factory('database');
$db->query("SELECT tag_id, name FROM #__video_tags");
$tags = $db->fetch_rows();
foreach ($tags as $tag) {
$name = str_replace('-', ' ', $tag['name']);
$db->query("UPDATE #__video_tags
SET name = '".$db->escape($name)."'
WHERE tag_id = ".(int) $tag['tag_id']."
LIMIT 1");
}
VF::close();
?>Save the above in a .php file and then access it.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#5 2011-06-14 08:02:49
Re: remove - from tags
I think there is a bug somewhere, which once i finish with my exams i will try to fix. There shouldnt be any - in the tags, unless they remained from vshare.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1