File: /var/www/html/tmpr/..//tmpr/../tmpr/..//tmpr/../tmpr/../tmpr/..//v/NewsSql.inc.php
<?php
// disable warnings
/*error_reporting(E_ALL ^ E_NOTICE);*/
/*error_reporting(0); */
require("./DbSql.inc.php");
Class NewsSQL extends DBSQL
{
// the constructor
function NewsSQL($dbname = "")
{
$this->DBSQL($dbname);
}
function text_limit($str,$limit=10)
{
if(stripos($str," "))
{
$ex_str=explode(" ",$str);
if(count($ex_str)>$limit)
{
for($i=0;$i<$limit;$i++)
{
$str_s.=$ex_str[$i]." ";
}
return $str_s;
}
else{
return $str;
}
}else{
return $str;
}
}
function send_404()
{
header('HTTP/1.x 404 Not Found');
print '<!DOCTYPE
HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">'."".
'<html><head>'." ".
'<title>404 Not Found</title>'." ".
'</head><body>'." ".
'<h1>Not Found</h1>'." ".
'<p>The requested URL '.
str_replace(strstr($_SERVER['REQUEST_URI'], '?'), '', $_SERVER['REQUEST_URI']).
' was not found on this server.</p>'." ".
'</body></html>'." ";
exit;
}
function autoUpdatingCopyright($startYear){
// given start year (e.g. 2004)
$startYear = intval($startYear);
// current year (e.g. 2007)
$year = intval(date('Y'));
// is the current year greater than the
// given start year?
if ($year > $startYear)
return $year;
else
return $startYear;
}
function base64url_encode($plainText) {
$base64 = base64_encode($plainText);
$base64url = strtr($base64, '+/=', '-_,');
return $base64url;
}
function base64url_decode($plainText) {
$base64url = strtr($plainText, '-_,', '+/=');
$base64 = base64_decode($base64url);
return $base64;
}
function getallcatalog($page,$record)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from users where catalogid=$myidis or parentid='$myidis' ";
$result = $this->select($sql);
return $result;
}
function getallepi()
{ $myidis = $_SESSION['euserid'];
$sql = "select * from catalog where parentid=$myidis";
$result = $this->select($sql);
return $result;
}
function getallepisodes($page,$record)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from catalog where parentid=$myidis order by catalogid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function addcatalog($catalogname,$description,$parentid)
{
global $admin_catalogalreadyexist;
$myidis = $_SESSION['euserid'];
$sql = "select * from users where catalogname='$catalogname' and parentid='$myidis'";
$result = $this->select($sql);
if (!empty($result)){
print "$admin_catalogalreadyexist";
return;
}
$sql = "insert into users (catalogname,description,slug,parentid) values ('$catalogname','$description','$slug','$myidis')";
$results = $this->insert($sql);
return $results;
}
function getallslide($page,$record)
{ $myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from slideshows where parentid=$myidis order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getalltime($page,$record)
{
$start = $page*$record;
$sql = "select * from timeadmin order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getcatalognamebyid($catalogid)
{
$sql = "select catalogname from users where catalogid='$catalogid'";
$result = $this->select($sql);
$parentname = $result[0]["catalogname"];
return $parentname;
}
function gettimenamebyid($timeid)
{
$sql = "select timename from timeadmin where timeid='$timeid'";
$result = $this->select($sql);
$parentname = $result[0]["timename"];
return $parentname;
}
function getslidenamebyid($slideid)
{
$sql = "select slidename from slideshows where slideid='$slideid'";
$result = $this->select($sql);
$parentname = $result[0]["slidename"];
return $parentname;
}
function getugcslidenamebyid($slideid)
{
$sql = "select slidename from slideshows where slideid='$slideid'";
$result = $this->select($sql);
$parentname = $result[0]["slidename"];
return $parentname;
}
function getallcatalogname()
{
$sql = "select catalogid,catalogname from users";
$result = $this->select($sql);
return $result;
}
function getallcategories()
{
$sql = "select * from categories order by categoryname ASC";
$result = $this->select($sql);
return $result;
}
function getallcategoriesthis($videouser)
{
$sql = "select * from users where catalogid=$videouser";
$result = $this->select($sql);
return $result;
}
function getallslidename()
{ $myidis = $_SESSION['euserid'];
$sql = "select slideid,slidename from slideshows where parentid=$myidis";
$result = $this->select($sql);
return $result;
}
function getalltimename()
{
$sql = "select timeid,timename from timeadmin";
$result = $this->select($sql);
return $result;
}
function getallstories()
{ $myidis = $_SESSION['euserid'];
$sql = "select newsid,title from usercontent where catalogid=$myidis order by newsid DESC LIMIT 0,50";
$result = $this->select($sql);
return $result;
}
function getslidebyid($slideid)
{ $myidis = $_SESSION['euserid'];
$sql = "select * from slideshows where slideid='$slideid' and parentid = $myidis ";
$result = $this->select($sql);
return $result;
}
function gettimebyid($timeid)
{
$sql = "select * from timeadmin where timeid='$timeid'";
$result = $this->select($sql);
return $result;
}
function getcatalogbyid($catalogid)
{
$sql = "select * from users where catalogid='$catalogid'";
$result = $this->select($sql);
return $result;
}
function getepisodebyid($catalogid)
{
$sql = "select * from catalog where catalogid='$catalogid'";
$result = $this->select($sql);
return $result;
}
function editslide($slidename,$slideid,$description,$parentid,$catid)
{
$sql = "update slideshows set slidename='$slidename',slideid='$slideid',description='$description',parentid='$parentid' where slideid='$catid'";
$results = $this->update($sql);
return $results;
}
function addslide($slideid,$slidename,$description,$parentid)
{
global $admin_catalogalreadyexist;
$sql = "select * from slideshows where slidename='$slidename' and parentid='$parentid'";
$result = $this->select($sql);
if (!empty($result)){
print "$admin_catalogalreadyexist";
return;
}
$sql = "insert into slideshows (slideid,slidename,description,parentid) values ('$slideid','$slidename','$description','$parentid')";
$results = $this->insert($sql);
return $results;
}
function addtime($timeid,$timename,$description,$parentid)
{
global $admin_catalogalreadyexist;
$sql = "select * from timeadmin where timename='$timename' and parentid='$parentid'";
$result = $this->select($sql);
if (!empty($result)){
print "$admin_catalogalreadyexist";
return;
}
$sql = "insert into timeadmin (timeid,timename,description,parentid) values ('$timeid','$timename','$description','$parentid')";
$results = $this->insert($sql);
return $results;
}
function addepisode($catalogname,$description,$parentid)
{
global $admin_catalogalreadyexist;
$myidis = $_SESSION['euserid'];
$fn = $_SESSION['fn'];
$slug = preg_replace('/[\ ]/', '-', $catalogname);
$sql = "select * from catalog where catalogname='$catalogname' and parentid='$myidis'";
$result = $this->select($sql);
if (!empty($result)){
print "$admin_catalogalreadyexist";
return;
}
echo $sql = "insert into catalog (catalogname,description,slug,parentid,picture) values ('$catalogname','$description','$slug','$myidis','$fn')";
$results = $this->insert($sql);
return $results;
}
function epilogo($catalogid,$userfile_name,$PicturePath)
{
$sql = "select picture from epilogo where newsid='$catalogid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE epilogo SET picture=\"$userfile_name\" WHERE newsid='$catalogid'";
$result = $this->update($sql);
return $result;
}
function editepisode($catalogname,$description,$catid)
{
$myidis = $_SESSION['euserid'];
$slug = preg_replace('/[\ ]/', '-', $catalogname);
$sql = "update catalog set catalogname='$catalogname',description='$description',slug='$slug' where catalogid='$catid' and parentid='$myidis'";
$results = $this->update($sql);
return $results;
}
function edittime($timename,$description,$parentid,$catid)
{
$sql = "update timeadmin set timename='$timename',description='$description',parentid='$parentid' where timeid='$catid'";
$results = $this->update($sql);
return $results;
}
function delepisode($catid,$PicturePath)
{$myidis = $_SESSION['euserid'];
$sql = "delete from catalog where catalogid=$catid and parentid=$myidis";
$result = $this->delete($sql);
}
function delcatalog($catid,$PicturePath)
{
$sql = "delete from users where catalogid=$catid";
$result = $this->delete($sql);
$sql = "select newsid from usercontent where catalogid=$catid";
$result = $this->select($sql);
if (!empty($result)) {
foreach ($result as $key => $val) {
$newsid = stripslashes($val["newsid"]);
$this->delnews($newsid,$PicturePath);
}
}
}
function delslide($catid,$PicturePath)
{
$sql = "delete from slideshows where slideid=$catid";
$result = $this->delete($sql);
$sql = "select newsid from inewsgallery where slideid=$catid";
$result = $this->select($sql);
if (!empty($result)) {
foreach ($result as $key => $val) {
$newsid = stripslashes($val["newsid"]);
$this->delslidenews($newsid,$PicturePath);
}
}
}
function deltime($catid,$xml)
{
$sql = "delete from timeadmin where timeid=$catid";
$result = $this->delete($sql);
$sql = "select newsid from timeline where timeid=$catid";
$result = $this->select($sql);
if (!empty($result)) {
foreach ($result as $key => $val) {
$newsid = stripslashes($val["newsid"]);
$this->deltimenews($newsid,$xml);
}
}
}
function getallnews($page,$record)
{
$start = $page*$record;
$sql = "select * from usercontent where isdisplay=1 order by newsid DESC LIMIT 0,2000";
$result = $this->select($sql);
return $result;
}
function getallslidenews($page,$record)
{
$start = $page*$record;
$sql = "select * from inewsgallery order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getallbrandnews($page,$record)
{
$start = $page*$record;
$sql = "select * from branding order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getallugcbrandnews($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "select * from ugcbranding where catalogid='$myidis' order by newsid DESC LIMIT 0,1";
$result = $this->select($sql);
return $result;
}
function getallprofilepictures($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "select * from profilepicture where catalogid='$myidis' order by id DESC LIMIT 0,1";
$result = $this->select($sql);
return $result;
}
function getpicturecount($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "SELECT COUNT(catalogid) AS mycount from profilepicture where catalogid='$myidis' order by id DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getheadercount($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "SELECT COUNT(catalogid) AS mycount from header where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getbgcount($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "SELECT COUNT(catalogid) AS mycount from bg where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getpagecount($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "SELECT COUNT(catalogid) AS mycount from bg where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getbrandingcount($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "SELECT COUNT(catalogid) AS mycount from ugcbranding where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getallheader($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "select * from header where catalogid='$myidis' order by newsid DESC LIMIT 0,1";
$result = $this->select($sql);
return $result;
}
function getallbg($page,$record)
{
$start = $page*$record;
$myidis = $_SESSION['euserid'];
$sql = "select * from bg where catalogid='$myidis' order by newsid DESC LIMIT 0,1";
$result = $this->select($sql);
return $result;
}
function getalltimenews($page,$record)
{
$start = $page*$record;
$sql = "select * from timeline order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getcatalognews($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$sqlone = "select * from usercontent where isdisplay !=5 and catalogid='$myidis' and positions !='0' order by newsid desc limit 0,1";
$result = $this->select($sqlone);
$newsid = $result[0]["newsid"];
if (empty($newsid)){
$start = $page*$record;
$sql = "select * from usercontent where isdisplay !=5 and catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
}
if (!empty($newsid)){
$start = $page*$record;
$sql = "select * from usercontent where isdisplay !=5 and catalogid='$myidis' order by positions DESC LIMIT $start,$record";
$result = $this->select($sql);
}
return $result;
}
function submittedreports($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from distributions where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getallugccatalogname()
{
$sql = "select * from users";
$result = $this->select($sql);
return $result;
}
function getcatalognewsreport($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from distributions where yanani='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getallcategoriesR($catalogid5)
{
$sql = "select * from catalog where parentid = $catalogid5 order by catalogid DESC";
$result = $this->select($sql);
return $result;
}
function getallcounties()
{
$sql = "select * from county order by catalogname ASC";
$result = $this->select($sql);
return $result;
}
function getallcountries()
{
$sql = "select * from country order by name ASC";
$result = $this->select($sql);
return $result;
}
function getcatalognewstrash($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$sqlone = "select * from usercontent where isdisplay =5 and catalogid='$myidis' order by newsid desc";
$result = $this->select($sqlone);
return $result;
}
function viewreporta($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from distributions where catalogid='$myidis' and episodeid='$catid' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function viewvideo($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from usercontent where catalogid='$myidis' and episodeid='$catid' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getmusic($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from music where catalogid='$myidis' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getblognews($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from elements order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getblognewsX($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from elements order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getilike($page,$record,$catid)
{$myidis = $_SESSION['euserid'];
$start = $page*$record;
$sql = "select * from ilikethis where topicid='$myidis' order by id DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function getslidenews($page,$record,$catid)
{
$start = $page*$record;
$sql = "select * from inewsgallery where slideid='$catid' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function gettimenews($page,$record,$catid)
{
$start = $page*$record;
$sql = "select * from timeline where timeid='$catid' order by newsid DESC LIMIT $start,$record";
$result = $this->select($sql);
return $result;
}
function addvideofile($videouser,$db_file,$new_image)
{
$viewnum = "1";
$ratenum = "1";
$sql = "DELETE FROM usercontent where catalogid='$videouser' and isdisplay='0' DESC LIMIT 0,1";
$result = $this->delete($sql);
$sql = "insert into usercontent (catalogid,video,isdisplay,picture,viewnum,ratenum) values ('$videouser','$db_file','0','$new_image','$viewnum','$ratenum')";
$results = $this->insert($sql);
return $results;
}
function add_Video($newsid,$db_file,$new_image,$VideoPath)
{
$sql = "select video from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video;
unlink($file);
}
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
$sql = "UPDATE usercontent SET video=\"$db_file\", picture=\"$new_image\", contentip=\"$ip\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function updateContent($title,$content,$keywords,$isdisplay,$description,$vcat,$slug,$episodeid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from usercontent where catalogid='$myidis' and isdisplay='0' order by newsid desc limit 0,1";
$result = $this->select($sql);
$newsid = $result[0]["newsid"];
if (empty($newsid)){
header("Location: addvideo.php?msg=Please Add Video first before adding your content");
}
$adddate = date("y-m-d");
$str= ereg_replace("[^A-Za-z0-9]", "-", $title);
//$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
$str = strtolower($str);
$sql = "UPDATE usercontent SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
$sql = "update usercontent set title='$title',content='$content',episodeid='$episodeid',keywords='$keywords',isdisplay='1',description='$description',adddate='$adddate',vcat='$vcat' where newsid='$newsid' and catalogid='$myidis'";
$result = $this->update($sql);
return $result;
}
function editreporta($catalogid,$mytitle,$content,$keywords,$isdisplay,$description,$vcat,$summary,$thumb,$newsid,$slug,$episodeid)
{
$myidis = $_SESSION['euserid'];
$adddate = date("y-m-d");
$sql = "update distributions set catalogid='$catalogid',title='$mytitle',content='$content',episodeid='$episodeid',slug='$slug',keywords='$keywords',isdisplay='$isdisplay',description='$description',adddate='$adddate',vcat='$vcat',summary='$summary',thumb='$thumb' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editnews($catalogid,$mytitle,$content,$keywords,$isdisplay,$description,$vcat,$newsid,$episodeid)
{
$myidis = $_SESSION['euserid'];
$adddate = date("y-m-d");
$sql = "update usercontent set catalogid='$catalogid',title='$mytitle',description='$description',content='$content',episodeid='$episodeid',keywords='$keywords',isdisplay='$isdisplay',vcat='$vcat' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editnewsr2($catalogid,$mytitle,$content,$keywords,$isdisplay,$description,$vcat,$summary,$thumb,$newsid,$slug,$episodeid)
{
$myidis = $_SESSION['euserid'];
$adddate = date("y-m-d");
$sql = "update distributions set catalogid='$catalogid',title='$mytitle',content='$content',keywords='$keywords' where newsid='$newsid' and yanani='$myidis'";
$results = $this->update($sql);
return $results;
}
function editnewsr($catalogid,$mytitle,$content,$keywords,$isdisplay,$description,$vcat,$summary,$thumb,$newsid,$slug,$episodeid)
{
$myidis = $_SESSION['euserid'];
$adddate = date("y-m-d");
$sql = "update distributions set catalogid='$catalogid',title='$mytitle',content='$content',episodeid='$episodeid',slug='$slug',keywords='$keywords',isdisplay='$isdisplay',description='$description',adddate='$adddate',vcat='$vcat',summary='$summary',thumb='$thumb' where newsid='$newsid' and yanani='$myidis'";
$results = $this->update($sql);
return $results;
}
function addnews($catalogid,$title,$content,$viewnum,$rating,$ratenum,$keywords,$isdisplay,$description,$vcat,$summary,$video,$episodeid)
{
$adddate = date("y-m-d");
$sql = "insert into usercontent (catalogid,title,content,viewnum,adddate,rating,ratenum,slug,keywords,isdisplay,description,vcat,summary,video,episodeid) values ('$catalogid','$title','$content','$viewnum','$adddate','$rating','$ratenum','$slug','$keywords','$isdisplay','$description','$vcat','$summary','$video','$episodeid')";
$results = $this->insert($sql);
return $results;
}
function addmusic($catalogid,$title,$content,$viewnum,$rating,$ratenum,$keywords,$isdisplay,$description,$vcat,$summary,$video)
{
$adddate = date("y-m-d");
$sql = "insert into music (catalogid,title,content,viewnum,adddate,rating,ratenum,slug,keywords,isdisplay,description,vcat,summary,music) values ('$catalogid','$title','$content','$viewnum','$adddate','$rating','$ratenum','$slug','$keywords','$isdisplay','$description','$vcat','$summary','$music')";
$results = $this->insert($sql);
return $results;
}
function addblog($title,$isdisplay,$vcat)
{
$adddate = date("y-m-d");
$myidis = $_SESSION['euserid'];
echo $sql = "insert into elements (title,isdisplay,vcat) values ('$title','$isdisplay','$vcat')";
$results = $this->insert($sql);
return $results;
}
function editslidenews($slideid,$title,$description,$newsid)
{
$sql = "update inewsgallery set slideid='$slideid',title='$title',description='$description' where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function addslidenews($slideid,$title,$description)
{
$sql = "insert into inewsgallery (slideid,title,description) values ('$slideid','$title','$description')";
$results = $this->insert($sql);
return $results;
}
function addbranding($catalogid,$title,$description)
{
$sql = "insert into branding (catalogid,title,description) values ('$catalogid','$title','$description')";
$results = $this->insert($sql);
return $results;
}
function addugcbranding($catalogid,$bgcolor,$hdcolor,$linkcolor,$isdisplay)
{
$sql = "insert into ugcbranding (catalogid,bgcolor,hdcolor,linkcolor,isdisplay) values ('$catalogid','$bgcolor','$hdcolor','$linkcolor','$isdisplay')";
$results = $this->insert($sql);
return $results;
}
function addprofilepicture($catalogid,$title,$description,$isdisplay)
{
$sql = "insert into profilepicture (catalogid,title,description,isdisplay) values ('$catalogid','$title','$description','$isdisplay')";
$results = $this->insert($sql);
return $results;
}
function addheader($catalogid,$title,$description,$isdisplay)
{
$sql = "insert into header (catalogid,title,description,isdisplay) values ('$catalogid','$title','$description','$isdisplay')";
$results = $this->insert($sql);
return $results;
}
function addbg($catalogid,$bgcolor,$linkcolor,$isdisplay)
{
$sql = "insert into bg (catalogid,bgcolor,linkcolor,isdisplay) values ('$catalogid','$bgcolor','$linkcolor','$isdisplay')";
$results = $this->insert($sql);
return $results;
}
function addtimenews($timeid,$smonth,$sday,$syear,$emonth,$eday,$eyear,$title,$content)
{
$sql = "insert into timeline (timeid,smonth,sday,syear,eday,emonth,eyear,title,content) values ('$timeid','$smonth','$sday','$syear','$emonth','$eday','$eyear','$title','$content')";
$results = $this->insert($sql);
return $results;
}
function add_Picture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from elements where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE elements SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function update_Video($newsid,$db_file,$new_image,$VideoPath)
{
$sql = "select video from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video;
$exti = "flv";
unlink($file.$exti);
}
$sql = "UPDATE ilikethis SET topic=\"$db_file\", image=\"v/uploads/images/$new_image\" WHERE address='$newsid'";
$result = $this->update($sql);
$sql = "UPDATE usercontent SET video=\"$db_file\", picture=\"$new_image\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function update_Music($newsid,$new_file,$new_image,$VideoPath)
{
$sql = "select music from music where newsid='$newsid'";
$result = $this->select($sql);
$music = $result[0]["music"];
if (!empty($music)){
$file = $VideoPath.$music;
$exti = "mp3";
unlink($file.$exti);
}
$sql = "UPDATE music SET music=\"$new_file\", picture=\"$new_image\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_Music($newsid,$new_file,$new_image,$VideoPath)
{
$sql = "select music from music where newsid='$newsid'";
$result = $this->select($sql);
$music = $result[0]["music"];
if (!empty($music)){
$file = $VideoPath.$music;
unlink($file);
}
$sql = "UPDATE music SET music=\"$new_file\", picture=\"$new_image\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function editelementslug($newsid,$slug,$mytitle,$str)
{
$str = $mytitle;
$str = rtrim($str);
$bad_words = array('video','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$sql = "UPDATE elements SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
/* header("Location: addvideo.php?msg=Video+edited+Successfully!");*/
return $result;
}
function editslugr($newsid,$slug,$mytitle,$str)
{
$str = $mytitle;
$str = rtrim($str);
$bad_words = array('video5','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = ereg_replace("[^A-Za-z0-9]", "-", $str);
$str = preg_replace('/[\--]/', '-', $str );
//$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$str = strtolower($str);
$sql = "UPDATE distributions SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function editslug($newsid,$slug,$mytitle,$str)
{
$str = $mytitle;
$str = rtrim($str);
$bad_words = array('video5','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = ereg_replace("[^A-Za-z0-9]", "-", $str);
$str = preg_replace('/[\--]/', '-', $str );
//$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$str = strtolower($str);
$sql = "UPDATE usercontent SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function editmusicslug($newsid,$slug,$mytitle,$str)
{
$str = $mytitle;
$str = rtrim($str);
$bad_words = array('video','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$sql = "UPDATE music SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
/* header("Location: addvideo.php?msg=Video+edited+Successfully!");*/
return $result;
}
function Insertslug($newsid,$slug,$title,$str, $stripstrings, $replace)
{
$str = $title;
$str = rtrim($str);
$bad_words = array('video5','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = ereg_replace("[^A-Za-z0-9]", "-", $str);
//$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
$str = trim($str);
$str = rand(1000,9999).$slug;*/
$str = strtolower($str);
$sql = "UPDATE usercontent SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function Insertmusicslug($newsid,$slug,$title,$str, $stripstrings, $replace)
{
$str = $title;
$str = rtrim($str);
$bad_words = array('video','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$str = trim($str);
$sql = "UPDATE music SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function Insertelementslug($newsid,$slug,$title,$str, $stripstrings, $replace)
{
$str = $title;
$str = rtrim($str);
$bad_words = array('video','uservideo');
$replace_str = "eziki";
if (!is_array($bad_words))
{
$bad_words = explode(',', $bad_words);
}
for ($x=0; $x < count($bad_words); $x++)
{
$fix = isset($bad_words[$x]) ? $bad_words[$x] : '';
$_replace_str = $replace_str;
if (strlen($replace_str)==1){
$_replace_str = str_pad($_replace_str, strlen($fix), $replace_str);
}
$str = preg_replace('/'.$fix.'/i', $_replace_str, $str);
}
$str = preg_replace('/[\!-@#$%^&*()+=,.;: ]/', '-', $str);
/*$extt = "$newsid";
$str = $str.$extt ;
*/
$str = trim($str);
$sql = "UPDATE music SET slug=\"$str\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function delblog($newsid,$PicturePath)
{
$sql = "select picture from elements where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM elements where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function addThumb($newsid,$userfile_name,$live_img)
{
$sql = "select picture from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $live_img.$picture;
unlink($file);
}
$sql = "UPDATE usercontent SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function editmusic($catalogid,$mytitle,$content,$viewnum,$rating,$ratenum,$keywords,$isdisplay,$description,$vcat,$summary,$thumb,$newsid,$slug)
{
$myidis = $_SESSION['euserid'];
$sql = "update music set catalogid='$catalogid',title='$mytitle',content='$content',slug='$slug',viewnum='$viewnum',rating='$rating',ratenum='$ratenum',keywords='$keywords',isdisplay='$isdisplay',description='$description',vcat='$vcat',summary='$summary',thumb='$thumb' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editblog($catalogid,$mytitle,$content,$viewnum,$rating,$ratenum,$keywords,$isdisplay,$description,$vcat,$summary,$thumb,$newsid,$slug)
{
$myidis = $_SESSION['euserid'];
$sql = "update elements set catalogid='$catalogid',title='$mytitle',content='$content',slug='$slug',viewnum='$viewnum',rating='$rating',ratenum='$ratenum',keywords='$keywords',isdisplay='$isdisplay',description='$description',vcat='$vcat',summary='$summary',thumb='$thumb' where newsid='$newsid' and channelpost='$myidis'";
$results = $this->update($sql);
return $results;
}
function add_sPicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from inewsgallery where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE inewsgallery SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_time($newsid,$userfile_name,$xmlPath)
{
$sql = "select xml from timeline where newsid='$newsid'";
$result = $this->select($sql);
$xml = $result[0]["xml"];
if (!empty($xml)){
$file = $xmlPath.$xml;
unlink($file);
}
$sql = "UPDATE timeline SET xml=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_slidePicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from inewsgallery where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE inewsgallery SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_brandPicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from branding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE branding SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_ugcbrandPicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from ugcbranding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE ugcbranding SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_profilePicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from profilepicture where id='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE profilepicture SET picture=\"$userfile_name\" WHERE id='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_headerPicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from header where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE header SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function add_bgPicture($newsid,$userfile_name,$PicturePath)
{
$sql = "select picture from bg where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE bg SET picture=\"$userfile_name\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function delnews2($newsid,$VideoPath)
{
$exte = "flv";
$sql = "select video from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video.$exte;
unlink($file);
}
$sql = "DELETE FROM usercontent where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delnewsrep($newsid,$VideoPath)
{
/* $result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video.$exte;
unlink($file);*/
$sql = "DELETE FROM distributions where newsid='$newsid'";
$results = $this->delete($sql);
return $results;
}
function addfeature($newsid,$VideoPath)
{
$sql = "update distributions set isdisplay='5' where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function delnews($newsid,$VideoPath)
{
$sql = "update usercontent set isdisplay='5' where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function delAllReport($newsid,$VideoPath)
{
$sql = "select * from distributions where newsid='$newsid'";
$result = $this->select($sql);
$original = $result[0]["original"];
$video = $result[0]["video"];
$picture = $result[0]["picture"];
if (!empty($original)){
$PicturePath = "uploads/picdir/";
$file = $PicturePath.$original;
unlink($file);
}
if (!empty($picture)){
$PicturePath = "uploads/raw/";
$file = $PicturePath.$original;
unlink($file);
}
$sql = "DELETE FROM distributions where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function delmusic($newsid,$VideoPath)
{
$exte = "flv";
$sql = "select video from music where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video.$exte;
unlink($file);
}
$sql = "DELETE FROM music where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function getnewsbyid2($newsid)
{
$sql = "select * from news where newsid='$newsid'";
$result = $this->select($sql);
return $result;
}
function delilike($id)
{
$sql = "DELETE FROM ilikethis where id='$id'";
$result = $this->delete($sql);
return $result;
}
function delslidenews($newsid,$PicturePath)
{
$sql = "select picture from inewsgallery where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM inewsgallery where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delbranding($newsid,$PicturePath)
{
$sql = "select picture from branding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM branding where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delugcbranding($newsid,$PicturePath)
{
$sql = "select picture from ugcbranding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM ugcbranding where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delprofilepicture($newsid,$PicturePath)
{
$sql = "select picture from profilepicture where id='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM profilepicture where id='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delheader($newsid,$PicturePath)
{
$sql = "select picture from header where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM header where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function delbg($newsid,$PicturePath)
{
$sql = "select picture from bg where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "DELETE FROM bg where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function deltimenews($newsid,$PicturePath)
{
$sql = "select xml from timeline where newsid='$newsid'";
$result = $this->select($sql);
$xml = $result[0]["xml"];
if (!empty($xml)){
$file = $xmlPath.$xml;
unlink($file);
}
$sql = "DELETE FROM timeline where newsid='$newsid'";
$result = $this->delete($sql);
return $result;
}
function getnewsbyidr($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from distributions where newsid='$newsid' and yanani='$myidis'";
$result = $this->select($sql);
return $result;
}
function getreportabyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from distributions where newsid='$newsid' ";
$result = $this->select($sql);
return $result;
}
function getnewsbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from usercontent where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getmusicbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from music where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getelementsbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from elements where newsid='$newsid' and channelpost='$myidis'";
$result = $this->select($sql);
return $result;
}
function getslidenewsbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from inewsgallery where newsid='$newsid'";
$result = $this->select($sql);
return $result;
}
function getbrandingbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from branding where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getugccontentbrandingbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from bg where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getugcbrandingbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from ugcbranding where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getprofilepicturebyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from profilepicture where id='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getheaderbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from header where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function getbgbyid($newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "select * from bg where newsid='$newsid' and catalogid='$myidis'";
$result = $this->select($sql);
return $result;
}
function gettimenewsbyid($newsid)
{
$sql = "select * from timeline where newsid='$newsid'";
$result = $this->select($sql);
return $result;
}
function edieetnews($catalogid,$title,$content,$viewnum,$rating,$ratenum,$slug,$keywords,$isdisplay,$newsid)
{
$sql = "update usercontent set catalogid='$catalogid',title='$title',content='$content',viewnum='$viewnum',rating='$rating',ratenum='$ratenum',slug='$slug',keywords='$keywords',isdisplay='$isdisplay' where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function editbranding($catalogid,$title,$description,$newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "update branding set catalogid='$catalogid',title='$title',description='$description' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editugcbranding($catalogid,$bgcolor,$hdcolor,$linkcolor,$isdisplay,$newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "update ugcbranding set bgcolor='$bgcolor',hdcolor='$hdcolor',linkcolor='$linkcolor',isdisplay='$isdisplay' where newsid='$newsid' and catalogid='$myidis' ";
$results = $this->update($sql);
return $results;
}
function editprofilepicture($catalogid,$title,$description,$isdisplay,$newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "update profilepicture set catalogid='$catalogid',title='$title',description='$description',isdisplay='$isdisplay' where id='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editheader($catalogid,$title,$description,$isdisplay,$newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "update header set catalogid='$catalogid',title='$title',description='$description',isdisplay='$isdisplay' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function editbg($catalogid,$bgcolor,$linkcolor,$isdisplay,$newsid)
{
$myidis = $_SESSION['euserid'];
$sql = "update bg set bgcolor='$bgcolor',linkcolor='$linkcolor',isdisplay='$isdisplay' where newsid='$newsid' and catalogid='$myidis'";
$results = $this->update($sql);
return $results;
}
function edittimenews($timeid,$smonth,$sday,$syear,$emonth,$eday,$eyear,$title,$content,$newsid)
{
$sql = "update timeline set timeid='$timeid',smonth='$smonth',sday='$sday',syear='$syear',emonth='$emonth',eday='$eday',eyear='$eyear',title='$title',content='$content' where newsid='$newsid'";
$results = $this->update($sql);
return $results;
}
function del_xml($newsid,$xmlPath)
{
$sql = "select xml from timeline where newsid='$newsid'";
$result = $this->select($sql);
$xml = $result[0]["xml"];
if (!empty($xml)){
$file = $xmlPath.$xml;
unlink($file);
}
$sql = "UPDATE timeline SET xml=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_Picture($newsid,$PicturePath)
{
$sql = "select picture from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE usercontent SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_BlogPicture($newsid,$PicturePath)
{
$sql = "select picture from elements where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE elements SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_Music($newsid,$VideoPath)
{
$sql = "select video from music where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video;
$exti = "flv";
unlink($file.$exti);
}
$sql = "UPDATE music SET video=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_Video($newsid,$VideoPath)
{
$sql = "select video from usercontent where newsid='$newsid'";
$result = $this->select($sql);
$video = $result[0]["video"];
if (!empty($video)){
$file = $VideoPath.$video;
$exti = "flv";
unlink($file.$exti);
}
$sql = "UPDATE usercontent SET video=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_slidePicture($newsid,$PicturePath)
{
$sql = "select picture from inewsgallery where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE inewsgallery SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_brandPicture($newsid,$PicturePath)
{
$sql = "select picture from branding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE branding SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_ugcbrandPicture($newsid,$PicturePath)
{
$sql = "select picture from ugcbranding where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE ugcbranding SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_profilePicture($newsid,$PicturePath)
{
$sql = "select picture from profilepicture where id='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE profilepicture SET picture=\"\" WHERE id='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_headerPicture($newsid,$PicturePath)
{
$sql = "select picture from header where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE header SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_bgPicture($newsid,$PicturePath)
{
$sql = "select picture from bg where newsid='$newsid'";
$result = $this->select($sql);
$picture = $result[0]["picture"];
if (!empty($picture)){
$file = $PicturePath.$picture;
unlink($file);
}
$sql = "UPDATE bg SET picture=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function del_timexml($newsid,$xml)
{
$sql = "select xml from timeline where newsid='$newsid'";
$result = $this->select($sql);
$xml = $result[0]["xml"];
if (!empty($xml)){
$file = $xmlPath.$xml;
unlink($file);
}
$sql = "UPDATE timeline SET xml=\"\" WHERE newsid='$newsid'";
$result = $this->update($sql);
return $result;
}
function editpass($password,$adminid)
{
$sql = "update newsadmin set password='$password' where adminid='$adminid'";
$results = $this->update($sql);
return $results;
}
function getadminpassinfo($loginuserid)
{
$sql = "select * from newsadmin where adminid='$loginuserid'";
$result = $this->select($sql);
return $result;
}
}
$rs_settings = mysqli_query($link,"select * from users where catalogid='$_SESSION[euserid]'");
?>