//
// ------------------------------------------------------------------------- //
// Based on: //
// myPHPNUKE Web Portal System - http://myphpnuke.com/ //
// PHP-NUKE Web Portal System - http://phpnuke.org/ //
// Thatware - http://thatware.org/ //
// ------------------------------------------------------------------------- //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------- //
include '../../../include/cp_header.php';
if ( file_exists("../language/".$xoopsConfig['language']."/main.php") ) {
include "../language/".$xoopsConfig['language']."/main.php";
} else {
include "../language/english/main.php";
}
include '../include/functions.php';
include_once XOOPS_ROOT_PATH.'/class/xoopstree.php';
include_once XOOPS_ROOT_PATH."/class/xoopslists.php";
include_once XOOPS_ROOT_PATH."/include/xoopscodes.php";
include_once XOOPS_ROOT_PATH.'/class/module.errorhandler.php';
$myts =& MyTextSanitizer::getInstance();
$eh = new ErrorHandler;
$mytree = new XoopsTree($xoopsDB->prefix("mylinks_cat"),"cid","pid");
function mylinks()
{
global $xoopsDB, $xoopsModule;
xoops_cp_header();
echo "
";
echo " - "._MD_MODREQUESTS." ($totalmodrequests)";
$result=$xoopsDB->query("select count(*) from ".$xoopsDB->prefix("mylinks_links")." where status>0");
list($numrows) = $xoopsDB->fetchRow($result);
echo "
";
printf(_MD_THEREARE,$numrows); echo "
";
echo"
";
xoops_cp_footer();
}
function listNewLinks()
{
global $xoopsDB, $xoopsConfig, $myts, $eh, $mytree;
// List links waiting for validation
$linkimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/mylinks/images/shots/");
$result = $xoopsDB->query("select lid, cid, title, url, logourl, submitter from ".$xoopsDB->prefix("mylinks_links")." where status=0 order by date DESC");
$numrows = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
";
xoops_cp_footer();
}
function linksConfigMenu()
{
global $xoopsDB,$xoopsConfig, $myts, $eh, $mytree;
// Add a New Main Category
xoops_cp_header();
$linkimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/mylinks/images/shots/");
echo "
"._MD_WEBLINKSCONF."
";
echo "
"
."
";
echo "";
echo"
";
echo " ";
// Add a New Sub-Category
$result=$xoopsDB->query("select count(*) from ".$xoopsDB->prefix("mylinks_cat")."");
list($numrows)=$xoopsDB->fetchRow($result);
if ( $numrows > 0 ) {
echo"
"
."
";
echo "";
echo"
";
echo " ";
// If there is a category, add a New Link
echo"
"
."
";
echo "";
echo"
";
echo " ";
// Modify Category
echo"
"
."
";
echo "
";
echo"
";
echo " ";
}
// Modify Link
$result2 = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("mylinks_links")."");
list($numrows2) = $xoopsDB->fetchRow($result2);
if ( $numrows2 > 0 ) {
echo"
\n";
echo "";
$result5=$xoopsDB->query("SELECT count(*) FROM ".$xoopsDB->prefix("mylinks_votedata")." WHERE lid = $lid");
list($totalvotes) = $xoopsDB->fetchRow($result5);
echo "
\n";
echo "
";
printf(_MD_TOTALVOTES,$totalvotes);
echo "
\n";
// Show Registered Users Votes
$result5=$xoopsDB->query("SELECT ratingid, ratinguser, rating, ratinghostname, ratingtimestamp FROM ".$xoopsDB->prefix("mylinks_votedata")." WHERE lid = $lid AND ratinguser >0 ORDER BY ratingtimestamp DESC");
$votes = $xoopsDB->getRowsNum($result5);
echo "
";
xoops_cp_footer();
}
function delVote()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$rid = $HTTP_GET_VARS['rid'];
$lid = $HTTP_GET_VARS['lid'];
$sql = sprintf("DELETE FROM %s WHERE ratingid = %u", $xoopsDB->prefix("mylinks_votedata"), $rid);
$xoopsDB->query($sql) or $eh->show("0013");
updaterating($lid);
redirect_header("index.php",1,_MD_VOTEDELETED);
exit();
}
function listBrokenLinks()
{
global $xoopsDB, $eh;
$result = $xoopsDB->query("select * from ".$xoopsDB->prefix("mylinks_broken")." group by lid order by reportid DESC");
$totalbrokenlinks = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
";
xoops_cp_footer();
}
function delBrokenLinks()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$lid = $HTTP_GET_VARS['lid'];
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mylinks_broken"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mylinks_links"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_LINKDELETED);
exit();
}
function ignoreBrokenLinks()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mylinks_broken"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_BROKENDELETED);
exit();
}
function listModReq()
{
global $xoopsDB, $myts, $eh, $mytree, $xoopsModuleConfig;
$result = $xoopsDB->query("select requestid,lid,cid,title,url,logourl,description,modifysubmitter from ".$xoopsDB->prefix("mylinks_mod")." order by requestid");
$totalmodrequests = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
";
echo"
"
."
";
echo "
"._MD_USERMODREQ." ($totalmodrequests)
";
if ( $totalmodrequests > 0 ) {
echo "
";
$lookup_lid = array();
while ( list($requestid, $lid, $cid, $title, $url, $logourl, $description, $submitterid)=$xoopsDB->fetchRow($result) ) {
$lookup_lid[$requestid] = $lid;
$result2 = $xoopsDB->query("select cid, title, url, logourl, submitter from ".$xoopsDB->prefix("mylinks_links")." where lid=$lid");
list($origcid, $origtitle, $origurl, $origlogourl, $ownerid)=$xoopsDB->fetchRow($result2);
$result2 = $xoopsDB->query("select description from ".$xoopsDB->prefix("mylinks_text")." where lid=$lid");
list($origdescription) = $xoopsDB->fetchRow($result2);
$result7 = $xoopsDB->query("select uname, email from ".$xoopsDB->prefix("users")." where uid='$submitterid'");
$result8 = $xoopsDB->query("select uname, email from ".$xoopsDB->prefix("users")." where uid='$ownerid'");
$cidtitle=$mytree->getPathFromId($cid, "title");
$origcidtitle=$mytree->getPathFromId($origcid, "title");
list($submitter, $submitteremail)=$xoopsDB->fetchRow($result7);
list($owner, $owneremail)=$xoopsDB->fetchRow($result8);
$title = $myts->makeTboxData4Show($title);
$url = $myts->makeTboxData4Show($url);
// $url = urldecode($url);
// use original image file to prevent users from changing screen shots file
$origlogourl = $myts->makeTboxData4Show($origlogourl);
$logourl = $origlogourl;
// $logourl = urldecode($logourl);
$description = $myts->makeTareaData4Show($description, 0);
$origurl = $myts->makeTboxData4Show($origurl);
// $origurl = urldecode($origurl);
// $origlogourl = urldecode($origlogourl);
$origdescription = $myts->makeTareaData4Show($origdescription, 0);
if ( $owner == "" ) {
$owner="administration";
}
echo "
![](\"".XOOPS_URL."/modules/mylinks/images/shots/".$origlogourl."\")
";
} else {
echo " ";
}
echo "![\"/\"](\"".XOOPS_URL."/modules/mylinks/images/shots/".$logourl."\")
";
} else {
echo " ";
}
echo "