/** * Import Data */ function seyretImport() { global $Itemid, $option; $db = & JFactory::getDBO(); $app = & JFactory::getApplication(); $seyretcid = JRequest::getInt( 'seyretcid', -1 ); $category_id = JRequest::getInt( 'category_id', 0 ); $counter = 0; $db->SetQuery( 'SELECT count(*) FROM #__seyret_items' ); $seyret_old = $db->loadResult(); $db->SetQuery( 'SELECT count(*) FROM #__seyret_video' ); $seyret_new = $db->loadResult(); if ($seyret_old > 1) { if (!empty($seyretcid) && ($seyretcid !== -1)) { $where = " WHERE `catid` LIKE '%*".$seyretcid."*#%'"; } else { $where = ""; } // import categories $db->setQuery( "SELECT * FROM #__seyret_items".$where ); if ( !$db->query() ) { echo "<script> alert('".$db->getErrorMsg()."'); window.history.go(-1); </script>\n"; exit(); } $rows_seyret = $db->loadObjectList(); for ($i=0, $n=count($rows_seyret); $i < $n; $i++) { $row_seyret = $rows_seyret[$i]; $row = new hwdvids_video($db); if ($row_seyret->videoservertype == "localfile") { $_POST['video_id'] = "local,".$row_seyret->videoservercode.",".$row_seyret->picturelink; } else if ($row_seyret->videoservertype == "youtube") { $thumbnail = "http://img.youtube.com/vi/".$row_seyret->videoservercode."/default.jpg"; $_POST['video_id'] = "youtube.com,".$row_seyret->videoservercode.",".$thumbnail; } else if ($row_seyret->videoservertype == "dailymotion") { if (file_exists(JPATH_SITE.'/plugins/hwdvs-thirdparty/dailymotion.com.php')) { require_once(JPATH_SITE.'/plugins/hwdvs-thirdparty/dailymotion.com.php'); $url = hwd_vs_tools::get_final_url( $row_seyret->videourl ); $pos_http = strpos($url, "http"); if ($pos_http === false) { $url = 'http://www.dailymotion.com'.$url; } $tp = new hwd_vs_tp_dailymotionCom(); $result = $tp->dailymotionComProcessCode($url); $video_code = $result[1]; } else { continue; } $_POST['video_id'] = 'dailymotion.com,'.$video_code; } else if ($row_seyret->videoservertype == "blip.tv") { if (file_exists(JPATH_SITE.'/plugins/hwdvs-thirdparty/blip.tv.php')) { require_once(JPATH_SITE.'/plugins/hwdvs-thirdparty/blip.tv.php'); $url = hwd_vs_tools::get_final_url( $row_seyret->videourl ); $pos_http = strpos($url, "http"); if ($pos_http === false) { $url = 'http://blip.tv'.$url; } $tp = new hwd_vs_tp_blipTv(); $result = $tp->blipTvProcessCode($row_seyret->videourl); $video_code = $result[1]; } else { continue; } $_POST['video_id'] = 'blip.tv,'.$video_code; } else if ($row_seyret->videoservertype == "google") { if (file_exists(JPATH_SITE.'/plugins/hwdvs-thirdparty/google.php')) { require_once(JPATH_SITE.'/plugins/hwdvs-thirdparty/google.php'); $url = hwd_vs_tools::get_final_url( $row_seyret->videourl ); $pos_http = strpos($url, "http"); if ($pos_http === false) { $url = 'http://video.google.com'.$url; } $tp = new hwd_vs_tp_googleCom(); $result = $tp->googleComProcessCode($row_seyret->videourl); $video_code = $result[1]; } else { continue; } $_POST['video_id'] = 'google.com,'.$video_code; } else if ($row_seyret->videoservertype == "vimeo.com") { if (file_exists(JPATH_SITE.'/plugins/hwdvs-thirdparty/vimeo.com.php')) { require_once(JPATH_SITE.'/plugins/hwdvs-thirdparty/vimeo.com.php'); $url = hwd_vs_tools::get_final_url( $row_seyret->videourl ); $pos_http = strpos($url, "http"); if ($pos_http === false) { $url = 'http://vimeo.com'.$url; } $tp = new hwd_vs_tp_vimeoCom(); $result = $tp->vimeoComProcessCode($row_seyret->videourl); $video_code = $result[1]; } else { continue; } $_POST['video_id'] = 'vimeo.com,'.$video_code; } else { continue; } if (empty($row_seyret->playtime)) { $row_seyret->playtime = "00:00"; } $_POST['video_type'] = "seyret"; $_POST['title'] = $row_seyret->title; $_POST['description'] = $row_seyret->itemcomment; $_POST['category_id'] = $category_id; $_POST['tags'] = $row_seyret->videotags; $_POST['public_private'] = "public"; $_POST['allow_comments'] = 1; $_POST['allow_embedding'] = 1; $_POST['allow_ratings'] = 1; $_POST['video_length'] = $row_seyret->playtime; $_POST['date_uploaded'] = $row_seyret->addeddate; $_POST['approved'] = "yes"; $_POST['number_of_views'] = $row_seyret->hit; $_POST['user_id'] = $row_seyret->addedby; $_POST['published'] = $row_seyret->published; // bind it to the table if (!$row->bind($_POST)) { echo "<script type=\"text/javascript\">alert('".$row->getError()."');window.history.go(-1);</script>\n"; exit(); } // store it in the db if (!$row->store()) { echo "<script type=\"text/javascript\">alert('".$row->getError()."');window.history.go(-1);</script>\n"; exit(); } $counter++; // fix for view archive if ($row_seyret->hit > 0) { $views = new hwdvidslogs_archive($db); $_POST['videoid'] = $row->id; $_POST['views'] = $row->number_of_views; // bind it to the table if (!$views->bind($_POST)) { echo "<script> alert('".$views->getError()."'); window.history.go(-1); </script>\n"; exit(); } // store it in the db if (!$views->store()) { echo "<script> alert('".$views -> getError()."'); window.history.go(-1); </script>\n"; exit(); } } } } else { if (!empty($seyretcid) && ($seyretcid !== -1)) { $where = " WHERE `parentcat` LIKE '%*".$seyretcid."*#%'"; } else { $where = ""; } // import categories $db->setQuery( "SELECT * FROM #__seyret_video".$where ); if ( !$db->query() ) { echo "<script> alert('".$db->getErrorMsg()."'); window.history.go(-1); </script>\n"; exit(); } $rows_seyret = $db->loadObjectList(); for ($i=0, $n=count($rows_seyret); $i < $n; $i++) { $row_seyret = $rows_seyret[$i]; $row = new hwdvids_video($db); if ($row_seyret->videoservertype == "localfile") { continue; $_POST['video_id'] = "local,".$row_seyret->videoservercode.",".$row_seyret->picturelink; } else if ($row_seyret->videoservertype == "youtube") { if (file_exists(JPATH_SITE.'/plugins/hwdvs-thirdparty/youtube.php')) { require_once(JPATH_SITE.'/plugins/hwdvs-thirdparty/youtube.php'); $url = $row_seyret->videourl; $tp = new hwd_vs_tp_YoutubeCom(); $result = $tp->YoutubeComProcessCode($url); $video_code = $result[1]; $video_thumbnail = $tp->YoutubeComGetThumbnail($result); } else { continue; } $_POST['video_id'] = "youtube.com,$video_code,$video_thumbnail"; } else { continue; } if (empty($row_seyret->duration)) { $row_seyret->duration = "00:00"; } $_POST['video_type'] = "seyret"; $_POST['title'] = $row_seyret->videotitle; $_POST['description'] = $row_seyret->videodescription; $_POST['category_id'] = $category_id; $_POST['tags'] = $row_seyret->videotags; $_POST['public_private'] = "public"; $_POST['allow_comments'] = 1; $_POST['allow_embedding'] = 1; $_POST['allow_ratings'] = 1; $_POST['video_length'] = $row_seyret->duration; $_POST['date_uploaded'] = $row_seyret->addeddate; $_POST['approved'] = "yes"; $_POST['number_of_views'] = $row_seyret->hit; $_POST['user_id'] = $row_seyret->addedby; $_POST['published'] = $row_seyret->published; // bind it to the table if (!$row->bind($_POST)) { echo "<script type=\"text/javascript\">alert('".$row->getError()."');window.history.go(-1);</script>\n"; exit(); } // store it in the db if (!$row->store()) { echo "<script type=\"text/javascript\">alert('".$row->getError()."');window.history.go(-1);</script>\n"; exit(); } $counter++; // fix for view archive if ($row_seyret->hit > 0) { $views = new hwdvidslogs_archive($db); $_POST['videoid'] = $row->id; $_POST['views'] = $row->number_of_views; // bind it to the table if (!$views->bind($_POST)) { echo "<script> alert('".$views->getError()."'); window.history.go(-1); </script>\n"; exit(); } // store it in the db if (!$views->store()) { echo "<script> alert('".$views -> getError()."'); window.history.go(-1); </script>\n"; exit(); } } } } $msg = "Successully imported ".$counter." videos"; $app->enqueueMessage($msg); $app->redirect( JURI::root( true ) . '/administrator/index.php?option='.$option.'&task=import' ); }
/** * Outputs frontpage HTML * * @param string $option the joomla component name * @param array $rows array of video data * @param array $rowsfeatured array of featured video data * @param object $pageNav page navigation object * @param int $total the total video count * @return Nothing */ function archiveVotes() { $db = & JFactory::getDBO(); $db->SetQuery("SELECT count(*) FROM #__hwdvidslogs_votes WHERE date <= DATE_SUB(NOW(),INTERVAL 30 DAY)"); $count = $db->loadResult(); $text = $count." vote logs need to be archived\n"; if ( $count == 0 ) { return $text; } $db->SetQuery("SELECT * FROM #__hwdvidslogs_votes WHERE date <= DATE_SUB(NOW(),INTERVAL 30 DAY) LIMIT 0, 1000"); $rows = $db->loadObjectList(); if (count($rows) > 0) { for ($i=0, $n=count($rows); $i < $n; $i++) { $row = $rows[$i]; $db->SetQuery("SELECT count(*) FROM #__hwdvidslogs_archive WHERE videoid = ".$row->videoid); $total = $db->loadResult(); if ($total > 0) { $db->SetQuery("SELECT number_of_votes, sum_of_votes FROM #__hwdvidslogs_archive WHERE videoid = ".$row->videoid); $data = $db->loadObject(); $number_of_votes = $data->number_of_votes + 1; $sum_of_votes = $data->sum_of_votes + $row->vote; $rating = $sum_of_votes/$number_of_votes; $db->SetQuery("UPDATE #__hwdvidslogs_archive SET number_of_votes=".$number_of_votes.", sum_of_votes=".$sum_of_votes.", rating=".$rating." WHERE videoid = $row->videoid"); if ( !$db->query() ) { echo "<script> alert('".$db->getErrorMsg()."'); window.history.go(-1); </script>\n"; exit(); } } else { $row_new = new hwdvidslogs_archive($db); $_POST['videoid'] = $row->videoid; $_POST['number_of_votes'] = 1; $_POST['sum_of_votes'] = $row->vote; $_POST['rating'] = $row->vote; if (!$row_new->bind($_POST)) { echo "<script> alert('".$row_new->getError()."'); window.history.go(-1); </script>\n"; exit(); } if (!$row_new->store()) { echo "<script> alert('".$row_new -> getError()."'); window.history.go(-1); </script>\n"; exit(); } } $db->SetQuery("DELETE FROM #__hwdvidslogs_votes WHERE id = ".$row->id." AND date <= DATE_SUB(NOW(),INTERVAL 30 DAY)" ); if ( !$db->query() ) { echo "<script> alert('".$db->getErrorMsg()."'); window.history.go(-1); </script>\n"; exit(); } } } $text = "Successfully archived ".count($rows)." votes\n"; $db->SetQuery("SELECT count(*) FROM #__hwdvidslogs_votes WHERE date <= DATE_SUB(NOW(),INTERVAL 30 DAY)"); $count = $db->loadResult(); $text.= $count." vote logs need to be archived\n"; return $text; }
/** * save videos */ function savevideo() { global $option, $task; $app = & JFactory::getApplication(); $db = & JFactory::getDBO(); $row = new hwdvids_video($db); $requestarray = JRequest::get( 'default', 2 ); $rawDescription = trim($requestarray['description']); $id = Jrequest::getInt( 'id', '' ); $title = hwd_vs_tools::generatePostTitle(); $description = hwd_vs_tools::generatePostDescription($rawDescription); $tags = hwd_vs_tools::generatePostTags(); $views = Jrequest::getInt( 'views', '' ); if (!empty($views)) { $db->SetQuery("SELECT count(*) FROM #__hwdvidslogs_views WHERE videoid = ".$id); $unarchived_count = $db->loadResult(); $archived_count = $views - $unarchived_count; $db->SetQuery("SELECT count(*) FROM #__hwdvidslogs_archive WHERE videoid = ".$id); $total = $db->loadResult(); if ($total > 0) { $db->SetQuery("UPDATE #__hwdvidslogs_archive SET views = $archived_count WHERE videoid = ".$id); if ( !$db->query() ) { echo "<script> alert('".$db->getErrorMsg()."'); window.history.go(-1); </script>\n"; exit(); } } else { $row_new = new hwdvidslogs_archive($db); $_POST['id'] = null; $_POST['videoid'] = $id; $_POST['views'] = $archived_count; if (!$row_new->bind($_POST)) { echo "<script> alert('".$row_new->getError()."'); window.history.go(-1); </script>\n"; exit(); } if (!$row_new->store()) { echo "<script> alert('".$row_new -> getError()."'); window.history.go(-1); </script>\n"; exit(); } $_POST['id'] = $id; } } $password = Jrequest::getVar( 'hwdvspassword', '' ); if (!empty($password)) { $password = md5($password); $_POST['password'] = $password; } if ($_POST['public_private'] == "group") { $gtree_video = Jrequest::getVar( 'gtree_video', '' ); if (!empty($gtree_video)) { $_POST['password'] = $gtree_video; } } if ($_POST['public_private'] == "level") { $jacl_video = Jrequest::getVar( 'jacl_video', '' ); if (!empty($jacl_video)) { if (isset($jacl_video) && $jacl_video !== '') { $jacl_video = @implode(",", $jacl_video); } $_POST['password'] = $jacl_video; } } $_POST['title'] = $title; $_POST['description'] = $description; $_POST['tags'] = $tags; $_POST['category_id'] = JRequest::getInt( 'category_id', 0 ); // bind it to the table if (!$row -> bind($_POST)) { echo "<script> alert('" .$row -> getError() ."'); window.history.go(-1); </script>\n"; exit(); } // store it in the db if (!$row -> store()) { echo "<script> alert('" .$row -> getError() ."'); window.history.go(-1); </script>\n"; exit(); } $row->checkin(); include(JPATH_SITE.DS.'administrator'.DS.'components'.DS.'com_hwdvideoshare'.DS.'libraries'.DS.'maintenance_recount.class.php'); hwd_vs_recount::recountVideosInCategory($row->category_id); if ($task == "apply") { $app->enqueueMessage(_HWDVIDS_ALERT_VIDSAVED); $app->redirect( JURI::root( true ) . '/administrator/index.php?option=com_hwdvideoshare&task=editvidsA&hidemainmenu=1&cid='.$row->id ); } else { $app->enqueueMessage(_HWDVIDS_ALERT_VIDSAVED); $app->redirect( JURI::root( true ) . '/administrator/index.php?option='.$option.'&task=videos' ); } }