addresses ! [Module usage questions] - XOOPS Web Application System

addresses !

2004/4/4 16:13
szoszon
Just popping in
Posts: 3
Since: 2002/10/21

How add "otwarte"
Resized Image

I change
/modules/addresses/admin/index.php
Quote:

// ------------------------------------------------------------------------- //
// XOOPS - PHP Content Management System //
// <https://xoops.org/> //
// ------------------------------------------------------------------------- //
// 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("addresses_cat"),"cid","pid");

function addresses()
{
global $xoopsDB, $xoopsModule;
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
";
echo""
."
";
// Temporarily 'homeless' links (to be revised in admin.php breakup)
$result = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_broken")."");
list($totalbrokenaddresses) = $xoopsDB->fetchRow($result);
if($totalbrokenaddresses>0){
$totalbrokenaddresses = "$totalbrokenaddresses";
}
$result2 = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_mod")."");
list($totalmodrequests) = $xoopsDB->fetchRow($result2);
if($totalmodrequests>0){
$totalmodrequests = "$totalmodrequests";
}
$result3 = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_links")." where status=0");
list($totalnewaddresses) = $xoopsDB->fetchRow($result3);
if($totalnewaddresses>0){
$totalnewaddresses = "$totalnewaddresses";
}
echo " - "._MD_GENERALSET."";
echo "

";
echo " - "._MD_ADDMODDELETE."";
echo "

";
echo " - "._MD_LINKSWAITING." ($totalnewaddresses)";
echo "

";
echo " - "._MD_BROKENREPORTS." ($totalbrokenaddresses)";
echo "

";
echo " - "._MD_MODREQUESTS." ($totalmodrequests)";
$result=$xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_links")." where status>0");
list($numrows) = $xoopsDB->fetchRow($result);
echo "

";
printf(_MD_THEREARE,$numrows); echo "
";
echo"
";
xoops_cp_footer();
}

function listNewAddresses()
{
global $xoopsDB, $xoopsConfig, $myts, $eh, $mytree;
// List links waiting for validation
$linkimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/addresses/images/shots/");
$result = $xoopsDB->query("select lid, cid, title, adress, zip, city, country, phone, mobile, fax, contemail, opentime, url, otwarte, logourl, submitter from ".$xoopsDB->prefix("addresses_links")." where status=0 order by date DESC");
$numrows = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
";
echo""
."
";
echo "
"._MD_LINKSWAITING." ($numrows)

";
if ( $numrows > 0 ) {
while(list($lid, $cid, $title, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $url, $otwarte, $logourl, $submitterid) = $xoopsDB->fetchRow($result)) {
$result2 = $xoopsDB->query("select description from ".$xoopsDB->prefix("addresses_text")." where lid=$lid");
list($description) = $xoopsDB->fetchRow($result2);
$title = $myts->makeTboxData4Edit($title);
$adress = $myts->makeTboxData4Edit($adress);
$zip = $myts->makeTboxData4Edit($zip);
$city = $myts->makeTboxData4Edit($city);
$country = $myts->makeTboxData4Edit($country);
$phone = $myts->makeTboxData4Edit($phone);
$mobile = $myts->makeTboxData4Edit($mobile);
$fax = $myts->makeTboxData4Edit($fax);
$contemail = $myts->makeTboxData4Edit($contemail);
$opentime = $myts->makeTareaData4Edit($opentime);
$url = $myts->makeTboxData4Edit($url);
// $url = urldecode($url);
// $logourl = $myts->makeTboxData4Edit($logourl);
// $logourl = urldecode($logourl);
$otwarte = $myts->makeTareaData4Edit($otwarte);
$description = $myts->makeTareaData4Edit($description);
$submitter = XoopsUser::getUnameFromId($submitterid);
echo "\n";
echo "";
echo "\n";
echo "";
echo "\n";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";

echo "";

//echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
"._MD_SUBMITTER." \n";
echo "$submitter";
echo "
"._MD_SITETITLE." ";
echo "";
echo "
"._MD_CATEGORYC." ";
$mytree->makeMySelBox("title", "title", $cid);
echo "
"._MD_ADRESS." ";
echo "";
echo "
"._MD_ZIP." ";
echo "";
echo "
"._MD_CITY." ";
echo "";
echo "
"._MD_COUNTRY." ";
echo "";
echo "
"._MD_PHONE." ";
echo "";
echo "
"._MD_MOBILE." ";
echo "";
echo "
"._MD_FAX." ";
echo "";
echo "
"._MD_CONTEMAIL." ";
echo "";
echo "
"._MD_SITEURL." ";

echo "";
echo " [ "._MD_VISIT." ]";
echo "
"._MD_otwarte." ";
echo "";
echo "
"._MD_CATEGORYC." ";
//$mytree->makeMySelBox("title", "title", $cid);
//echo "
"._MD_OPENED." \n";
echo "$opentime\n";
echo "
"._MD_DESCRIPTIONC." \n";
echo "$description\n";
echo "
"._MD_SHOTIMAGE." \n";
//echo "\n";
echo "";
echo "
";
$shotdir = "".XOOPS_URL."/modules/addresses/images/shots/";
printf(_MD_SHOTMUST,$shotdir);
echo "
\n";
echo "
";
echo "";
echo "\n";
echo myTextForm("index.php?op=delNewLink&lid=$lid",_MD_DELETE); //ATTENTIE
echo "

";
}
} else {
echo ""._MD_NOSUBMITTED."";
}
echo"
";
xoops_cp_footer();
}

function addressesConfigMenu()
{
global $xoopsDB,$xoopsConfig, $myts, $eh, $mytree;
// Add a New Main Category
xoops_cp_header();
$linkimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/addresses/images/shots/");
echo "
"._MD_WEBLINKSCONF."
"; //ATTENTIE
echo ""
."
";
echo "
\n";
echo "
"._MD_ADDMAIN."

"._MD_TITLEC."
";
echo ""._MD_IMGURL."

";
echo "\n";
echo "";
echo "
";
echo"
";
echo "
";
// Add a New Sub-Category
$result=$xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_cat")."");
list($numrows)=$xoopsDB->fetchRow($result);
if ( $numrows > 0 ) {
echo""
."
";
echo "
";
echo "
"._MD_ADDSUB."

"._MD_TITLEC." "._MD_IN." ";
$mytree->makeMySelBox("title", "title");
# echo "
"._MD_IMGURL."
\n";
echo "

";
echo "
";
echo"
";
echo "
";
// If there is a category, add a New Adress !!

echo""
."
";
echo "
\n";
echo "
"._MD_ADDNEWLINK."

\n";
echo "\n";
echo "";
echo "\n";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";

echo "";

//echo "\n";
echo "\n";
echo "\n";
$shotdir = "".XOOPS_URL."/modules/addresses/images/shots/";
echo "\n";
echo "
"._MD_SITETITLE." ";
echo "";
echo "
"._MD_CATEGORYC." ";
$mytree->makeMySelBox("title", "title");
echo "
"._MD_ADRESS." ";
echo "";
echo "
"._MD_ZIP." ";
echo "";
echo "
"._MD_CITY." ";
echo "";
echo "
"._MD_COUNTRY." ";
echo "";
echo "
"._MD_PHONE." ";
echo "";
echo "
"._MD_MOBILE." ";
echo "";
echo "
"._MD_FAX." ";
echo "";
echo "
"._MD_CONTEMAIL." ";
echo "";
echo "
"._MD_SITEURL." ";
echo ""; //value=\"http://\"
echo "
"._MD_otwarte." ";
echo "";
echo "
"._MD_CATEGORYC." ";
//$mytree->makeMySelBox("title", "title");
echo "
"._MD_OPENED." \n";
echo "\n";
echo "
"._MD_DESCRIPTIONC." \n";
xoopsCodeTarea("description",60,8);
xoopsSmilies("description");
//echo "\n";
echo "
"._MD_SHOTIMAGE." \n";
//echo "";
echo "";
echo "
";
printf(_MD_SHOTMUST,$shotdir);
echo "
\n
";
echo "";
echo "\n";
echo "
";
echo"
";
echo "
";

// Modify Category
echo""
."
";
echo "

"._MD_MODCAT."

";
echo _MD_CATEGORYC;
$mytree->makeMySelBox("title", "title");
echo "

\n";
echo "\n";
echo "\n";
echo "
";
echo"
";
echo "
";
}
// Modify Address
$result2 = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_links")."");
list($numrows2) = $xoopsDB->fetchRow($result2);
if ( $numrows2 > 0 ) {
echo""
."
";
echo "
\n";
echo "
"._MD_MODLINK."

\n"; //SHINE need to change later
echo _MD_LINKID."\n";
echo "\n";
echo "

\n"; // SHINE need to change later
echo "
\n";
echo"
";
}
xoops_cp_footer();
}

function modLink()
{
global $xoopsDB, $HTTP_GET_VARS, $myts, $eh, $mytree, $xoopsConfig;
$linkimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/addresses/images/shots/");
$lid = $HTTP_GET_VARS['lid'];
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
";
echo""
."
";
$result = $xoopsDB->query("select cid, title, adress, zip, city, country, phone, mobile, fax, contemail, opentime, url, otwarte, logourl from ".$xoopsDB->prefix("addresses_links")." where lid=$lid") or $eh->show("0013");
echo "
"._MD_MODLINK."

";
list($cid, $title, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $url, $otwarte, $logourl) = $xoopsDB->fetchRow($result);
$title = $myts->makeTboxData4Edit($title);
$adress = $myts->makeTboxData4Edit($adress);
$zip = $myts->makeTboxData4Edit($zip);
$city = $myts->makeTboxData4Edit($city);
$country = $myts->makeTboxData4Edit($country);
$phone = $myts->makeTboxData4Edit($phone);
$mobile = $myts->makeTboxData4Edit($mobile);
$fax = $myts->makeTboxData4Edit($fax);
$contemail = $myts->makeTboxData4Edit($contemail);
$opentime = $myts->makeTareaData4Edit($opentime);
$url = $myts->makeTboxData4Edit($url);
// $url = urldecode($url);

$otwarte = $myts->makeTboxData4Edit($otwarte);

$logourl = $myts->makeTboxData4Edit($logourl);
// $logourl = urldecode($logourl);
$result2 = $xoopsDB->query("select description from ".$xoopsDB->prefix("addresses_text")." where lid=$lid");
list($description)=$xoopsDB->fetchRow($result2);
$GLOBALS['description'] = $myts->makeTareaData4Edit($description);
echo "";
echo "";
echo "";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";

echo "\n";

echo "";
echo "";
//echo "\n";
echo "\n";
$shotdir = "".XOOPS_URL."/modules/addresses/images/shots/";
echo "\n";
echo "
"._MD_LINKID." $lid
"._MD_SITETITLE."
"._MD_CATEGORYC." ";
$mytree->makeMySelBox("title", "title", $cid);
echo "
"._MD_ADRESS."
"._MD_ZIP."
"._MD_CITY."
"._MD_COUNTRY."
"._MD_PHONE."
"._MD_MOBILE."
"._MD_FAX."
"._MD_CONTEMAIL."
"._MD_SITEURL."
"._MD_otwarte."
"._MD_OPENED." ";
echo "$opentime";
echo "
"._MD_DESCRIPTIONC." ";
xoopsCodeTarea("description",60,8);
xoopsSmilies("description");
//echo "$description";
echo "
"._MD_CATEGORYC." ";
//$mytree->makeMySelBox("title", "title", $cid);
//echo "
"._MD_SHOTIMAGE." ";
//echo "
echo "";
echo "
";
printf(_MD_SHOTMUST,$shotdir);
echo "
";
echo "

\n";
echo ""; //SHINE need to change later
// echo " ";
//echo " ";
echo "\n";

echo "
\n";
echo myTextForm("index.php?op=delLink&lid=".$lid , _MD_DELETE); //SHINE need to change later
echo " \n";
echo myTextForm("index.php?op=addressesConfigMenu", _MD_CANCEL);
echo "
\n";
echo "
";

$result5=$xoopsDB->query("SELECT count(*) FROM ".$xoopsDB->prefix("addresses_votedata")." WHERE lid = $lid");
list($totalvotes) = $xoopsDB->fetchRow($result5);
echo "\n";
echo "\n";
// Show Registered Users Votes
$result5=$xoopsDB->query("SELECT ratingid, ratinguser, rating, ratinghostname, ratingtimestamp FROM ".$xoopsDB->prefix("addresses_votedata")." WHERE lid = $lid AND ratinguser >0 ORDER BY ratingtimestamp DESC");
$votes = $xoopsDB->getRowsNum($result5);
echo "\n";
echo "\n";
if ($votes == 0){
echo "\n";
}
$x=0;
$colorswitch="dddddd";
while(list($ratingid, $ratinguser, $rating, $ratinghostname, $ratingtimestamp)=$xoopsDB->fetchRow($result5)) {
// $ratingtimestamp = formatTimestamp($ratingtimestamp);
//Individual user information
$result2=$xoopsDB->query("SELECT rating FROM ".$xoopsDB->prefix("addresses_votedata")." WHERE ratinguser = '$ratinguser'");
$uservotes = $xoopsDB->getRowsNum($result2);
$useravgrating = 0;
while ( list($rating2) = $xoopsDB->fetchRow($result2) ) {
$useravgrating = $useravgrating + $rating2;
}
$useravgrating = $useravgrating / $uservotes;
$useravgrating = number_format($useravgrating, 1);
$ratingusername = XoopsUser::getUnameFromId($ratinguser);
echo "\n";
$x++;
if ( $colorswitch == "dddddd" ) {
$colorswitch="ffffff";
} else {
$colorswitch="dddddd";
}
}
// Show Unregistered Users Votes
$result5=$xoopsDB->query("SELECT ratingid, rating, ratinghostname, ratingtimestamp FROM ".$xoopsDB->prefix("addresses_votedata")." WHERE lid = $lid AND ratinguser = 0 ORDER BY ratingtimestamp DESC");
$votes = $xoopsDB->getRowsNum($result5);
echo "\n";
echo "
";
if ( $votes == 0 ) {
echo "";
}
$x=0;
$colorswitch="dddddd";
while ( list($ratingid, $rating, $ratinghostname, $ratingtimestamp)=$xoopsDB->fetchRow($result5) ) {
$formatted_date = formatTimestamp($ratingtimestamp);
echo "";
$x++;
if ( $colorswitch == "dddddd" ) {
$colorswitch="ffffff";
} else {
$colorswitch="dddddd";
}
}
echo "\n";
echo "
";
printf(_MD_TOTALVOTES,$totalvotes);
echo "

";
printf(_MD_USERTOTALVOTES,$votes);
echo "

" ._MD_USER." " ._MD_IP." " ._MD_RATING." " ._MD_USERAVG." " ._MD_TOTALRATE." " ._MD_DATE." " ._MD_DELETE."
" ._MD_NOREGVOTES."
".$ratingusername." ".$ratinghostname." $rating ".$useravgrating." ".$uservotes." ".$ratingtimestamp." ".myTextForm("index.php?op=delVote&lid=$lid&rid=$ratingid", "X")."

";
printf(_MD_ANONTOTALVOTES,$votes);
echo "

" ._MD_IP." " ._MD_RATING." " ._MD_DATE." " ._MD_DELETE."
" ._MD_NOUNREGVOTES."
$ratinghostname $rating $formatted_date ".myTextForm("index.php?op=delVote&lid=$lid&rid=$ratingid", "X")."

\n";
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("addresses_votedata"), $rid);
$xoopsDB->query($sql) or $eh->show("0013");
updaterating($lid);
redirect_header("index.php",1,_MD_VOTEDELETED);
exit();
}

function listBrokenAddresses()
{
global $xoopsDB, $eh;
$result = $xoopsDB->query("select * from ".$xoopsDB->prefix("addresses_broken")." group by lid order by reportid DESC");
$totalbrokenaddresses = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
"; //SHINE need to change later
echo""
."
";
echo "
"._MD_BROKENREPORTS." ($totalbrokenaddresses)

";

if ( $totalbrokenaddresses == 0 ) {
echo _MD_NOBROKEN;
} else {
echo "
"._MD_IGNOREDESC."

"._MD_DELETEDESC."

";
$colorswitch="dddddd";
echo "";
echo "

";
while ( list($reportid, $lid, $sender, $ip)=$xoopsDB->fetchRow($result) ) {
$result2 = $xoopsDB->query("select title, url, submitter from ".$xoopsDB->prefix("addresses_links")." where lid=$lid");
if ( $sender != 0 ) {
$result3 = $xoopsDB->query("select uname, email from ".$xoopsDB->prefix("users")." where uid=$sender");
list($uname, $email)=$xoopsDB->fetchRow($result3);
}
list($title, $url, $ownerid)=$xoopsDB->fetchRow($result2);
// $url=urldecode($url);
$result4 = $xoopsDB->query("select uname, email from ".$xoopsDB->prefix("users")." where uid='$ownerid'");
list($owner, $owneremail)=$xoopsDB->fetchRow($result4);
echo "";
if ( $email=='' ) {
echo "";
if ( $owneremail == '' ) {
echo "\n";

if ( $colorswitch == "#dddddd" ) {
$colorswitch="#ffffff";
} else {
$colorswitch="#dddddd";
}
}
echo "

Link Name " ._MD_REPORTER." " ._MD_LINKSUBMITTER." " ._MD_IGNORE." " ._EDIT." " ._MD_DELETE."
$title ".$sender." (".$ip.")";
} else {
echo " ".$uname." (".$ip.")";
}
echo " ".$owner."";
} else {
echo " ".$owner."";
}

echo " \n";
echo myTextForm("index.php?op=ignoreBrokenLinks&lid=$lid" , "X"); //SHINE need to change later
echo " \n";
echo myTextForm("index.php?op=modLink&lid=$lid" , "X"); //SHINE need to change later
echo " \n";
echo myTextForm("index.php?op=delBrokenLinks&lid=$lid" , "X"); //SHINE need to change later
echo "
";
}

echo"
";
xoops_cp_footer();
}

function delBrokenLinks() //SHINE need to change later
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$lid = $HTTP_GET_VARS['lid'];
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_broken"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_LINKDELETED);
exit();
}

function ignoreBrokenLinks() //SHINE need to change later
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_broken"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_BROKENDELETED);
exit();
}
//Shine: MODIFICATION REQUESTS VIEW WITHIN ADMINAREA
function listModReq()
{
global $xoopsDB, $xoopsConfig, $myts, $eh, $mytree, $xoopsModuleConfig;
//Catz edit from here
//Changed this to select all fields from the database, instead of listing them all as this creates an error for some reason. Not sure why but it does?
$result = $xoopsDB->query("SELECT * from ".$xoopsDB->prefix("addresses_mod")." order by requestid");
$totalmodrequests = $xoopsDB->getRowsNum($result);

xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
";
echo "
"._MD_USERMODREQ." ($totalmodrequests)
";

if ( $totalmodrequests > 0 ) {

$lookup_lid = array();
while ( list($requestid, $lid, $cid, $title, $url, $otwarte, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $logourl, $description, $submitterid)=$xoopsDB->fetchRow($result) ) {
$lookup_lid[$requestid] = $lid;
$result2 = $xoopsDB->query("select cid, title, adress, zip, city, country, phone, mobile, fax, contemail, opentime, url, otwarte, logourl, submitter from ".$xoopsDB->prefix("addresses_links")." where lid=$lid");
list($origcid, $origtitle, $origadress, $origzip, $origcity, $origcountry, $origphone, $origmobile, $origfax, $origcontemail, $origopentime, $origurl, $origotwarte, $origlogourl, $ownerid)=$xoopsDB->fetchRow($result2);
$result2 = $xoopsDB->query("select description from ".$xoopsDB->prefix("addresses_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);
//ingevoegd
$adress = $myts->makeTboxData4Show($adress);
$zip = $myts->makeTboxData4Show($zip);
$city = $myts->makeTboxData4Show($city);
$country = $myts->makeTboxData4Show($country);
$phone = $myts->makeTboxData4Show($phone);
$mobile = $myts->makeTboxData4Show($mobile);
$fax = $myts->makeTboxData4Show($fax);
$contemail = $myts->makeTboxData4Show($contemail);
$opentime = $myts->makeTareaData4Show($opentime);
$otwarte = $myts->makeTareaData4Show($otwarte);

// use original image file to prevent users from changing screen shots file
$origlogourl = $myts->makeTboxData4Show($origlogourl);
$logourl = $origlogourl;

$description = $myts->makeTareaData4Show($description);
$origdescription = $myts->makeTareaData4Show($origdescription);
if ( $owner == "" ) {
$owner="administration";
}
// VIEW ORIGINAL

echo "

";
//VIEW PROPOSEL
echo "

"._MD_ORIGINAL."

"._MD_SITETITLE." $origtitle

"._MD_ADRESS.": $origadress

"._MD_ZIP.": $origzip

"._MD_CITY.": $origcity

"._MD_COUNTRY.": $origcountry

"._MD_PHONE.": $origphone

"._MD_MOBILE.": $origmobile

"._MD_FAX.": $origfax

"._MD_CONTEMAIL.": $origcontemail

"._MD_SITEURL." $origurl

"._MD_otwarte." $origotwarte

"._MD_OPENED.": $origopentime

"._MD_CATEGORYC." $origcidtitle

"._MD_SHOTIMAGE." ";
if ( $xoopsModuleConfig['useshots'] && !empty($origlogourl) ) {
echo "";
} else {
echo " ";
}
echo "
"._MD_DESCRIPTIONC." $origdescription

"._MD_PROPOSED."

"._MD_SITETITLE." $title

"._MD_ADRESS." $adress

"._MD_ZIP." $zip

"._MD_CITY." $city

"._MD_COUNTRY." $country

"._MD_PHONE." $phone

"._MD_MOBILE." $mobile

"._MD_FAX." $fax

"._MD_CONTEMAIL." $contemail

"._MD_SITEURL." $url

"._MD_otwarte." $url

"._MD_OPENED." $opentime

"._MD_CATEGORYC." $cidtitle

"._MD_SHOTIMAGE." ";

if ( $xoopsModuleConfig['useshots'] == 1 && !empty($logourl) ) {
echo " $\"/\"$ ";
} else {
echo " ";
}
echo "

"._MD_DESCRIPTIONC." $description

";
if ( $submitteremail == "" ) {
echo "";
} else {
echo "";
}
if ( $owneremail == "" ) {
echo "";
} else {
echo "";
}
echo "\n";
echo "

"._MD_SUBMITTER."$submitter "._MD_SUBMITTER."".$submitter." "._MD_OWNER."".$owner." "._MD_OWNER."".$owner." \n";
// modview stops here. //
echo "
\n";
echo myTextForm("index.php?op=changeModReq&requestid=$requestid" , _MD_APPROVE);
echo " \n";
echo myTextForm("index.php?op=modLink&lid=$lookup_lid[$requestid]", _EDIT);
echo " \n";
echo myTextForm("index.php?op=ignoreModReq&requestid=$requestid", _MD_IGNORE);
echo "
\n";
echo "
";
}
} else {
echo _MD_NOMODREQ;
}

xoops_cp_footer();
}

function changeModReq()
{
global $xoopsDB, $HTTP_GET_VARS, $eh, $myts;
$requestid = $HTTP_GET_VARS['requestid'];
$query = "select lid, cid, title, adress, zip, city, country, phone, mobile, fax, contemail, opentime, url, otwarte, logourl, description from ".$xoopsDB->prefix("addresses_mod")." where requestid=".$requestid."";
$result = $xoopsDB->query($query);
while ( list($lid, $cid, $title, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $url, $otwarte, $logourl, $description)=$xoopsDB->fetchRow($result) ) {
if ( get_magic_quotes_runtime() ) {
$title = stripslashes($title);
$adress = stripslashes($adress);
$zip = stripslashes($zip);
$city = stripslashes($city);
$country = stripslashes($country);
$phone = stripslashes($phone);
$mobile = stripslashes($mobile);
$fax = stripslashes($fax);
$contemail = stripslashes($contemail);
$opentime = stripslashes($opentime);
$url = stripslashes($url);

$otwarte = stripslashes($otwarte);

$logourl = stripslashes($logourl);
$description = stripslashes($description);
}
$title = addslashes($title);
$adress = addslashes($adress);
$zip = addslashes($zip);
$city = addslashes($city);
$country = addslashes($country);
$phone = addslashes($phone);
$mobile = addslashes($mobile);
$fax = addslashes($fax);
$contemail = addslashes($contemail);
$opentime = addslashes($opentime);
$url = addslashes($url);

$otwarte = addslashes($otwarte);

$logourl = addslashes($logourl);
$description = addslashes($description);

$sql= sprintf("UPDATE %s SET cid = %u, title = '%s', adress = '%s', zip = '%s', city = '%s', country = '%s', phone = '%s', mobile = '%s', fax = '%s', contemail = '%s', opentime = '%s', url = '%s', otwarte = '%s', logourl = '%s', status = 2, date = %u WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $cid, $title, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $url, $otwarte, $logourl, time(), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("UPDATE %s SET description = '%s' WHERE lid = %u", $xoopsDB->prefix("addresses_text"), $description, $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE requestid = %u", $xoopsDB->prefix("addresses_mod"), $requestid);
$xoopsDB->query($sql) or $eh->show("0013");
}
redirect_header("index.php",1,_MD_DBUPDATED);
exit();
}

function ignoreModReq()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$sql = sprintf("DELETE FROM %s WHERE requestid = %u", $xoopsDB->prefix("addresses_mod"), $HTTP_GET_VARS['requestid']);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_MODREQDELETED);
exit();
}
//ADMIN MOD ADDRESS
function modLinkS() //SHINE need to change later
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$cid = $HTTP_POST_VARS["cid"];
if ( ($HTTP_POST_VARS["url"]) || ($HTTP_POST_VARS["url"]!="") ) {
// $url = $myts->formatURL($HTTP_POST_VARS["url"]);
// $url = urlencode($url);
$url = $myts->makeTboxData4Save($HTTP_POST_VARS["url"]);
}
$otwarte = $myts->makeTboxData4Save($HTTP_POST_VARS["otwarte"]);

$logourl = $myts->makeTboxData4Save($HTTP_POST_VARS["logourl"]); //Shine eerst disabled !!
$title = $myts->makeTboxData4Save($HTTP_POST_VARS["title"]);
$adress = $myts->makeTboxData4Save($HTTP_POST_VARS["adress"]);
$zip = $myts->makeTboxData4Save($HTTP_POST_VARS["zip"]);
$city = $myts->makeTboxData4Save($HTTP_POST_VARS["city"]);
$country = $myts->makeTboxData4Save($HTTP_POST_VARS["country"]);
$phone = $myts->makeTboxData4Save($HTTP_POST_VARS["phone"]);
$mobile = $myts->makeTboxData4Save($HTTP_POST_VARS["mobile"]);
$fax = $myts->makeTboxData4Save($HTTP_POST_VARS["fax"]);
$contemail = $myts->makeTboxData4Save($HTTP_POST_VARS["contemail"]);
$opentime = $myts->makeTareaData4Save($HTTP_POST_VARS["opentime"]);
$description = $myts->makeTareaData4Save($HTTP_POST_VARS["description"]);
$xoopsDB->query("update ".$xoopsDB->prefix("addresses_links")." set cid='$cid', title='$title', adress='$adress', zip='$zip', city='$city', country='$country', phone='$phone', mobile='$mobile', fax='$fax', contemail='$contemail', opentime='$opentime', url='$url', otwarte='$otwarte', logourl='$logourl', status=2, date=".time()." where lid=".$HTTP_POST_VARS['lid']."") or $eh->show("0013");
$xoopsDB->query("update ".$xoopsDB->prefix("addresses_text")." set description='$description' where lid=".$HTTP_POST_VARS['lid']."") or $eh->show("0013");
redirect_header("index.php",1,_MD_DBUPDATED);
exit();
}

function delLink() //SHINE need to change later
{
global $xoopsDB, $HTTP_GET_VARS, $eh, $xoopsModule;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_text"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_votedata"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $HTTP_GET_VARS['lid']);
// delete notifications
xoops_notification_deletebyitem ($xoopsModule->getVar('mid'), 'link', $HTTP_GET_VARS['lid']);

redirect_header("index.php",1,_MD_LINKDELETED); //SHINE need to change later
exit();
}

function modCat()
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh, $mytree;
$cid = $HTTP_POST_VARS["cid"];
xoops_cp_header();
echo "
"._MD_WEBLINKSCONF."
"; //SHINE need to change later
echo""
."
";
echo "
"._MD_MODCAT."

";
$result=$xoopsDB->query("select pid, title, imgurl from ".$xoopsDB->prefix("addresses_cat")." where cid=$cid");
list($pid,$title,$imgurl) = $xoopsDB->fetchRow($result);
$title = $myts->makeTboxData4Edit($title);
$imgurl = $myts->makeTboxData4Edit($imgurl);
echo "
"._MD_TITLEC."

"._MD_IMGURLMAIN."

";
echo _MD_PARENT." ";
$mytree->makeMySelBox("title", "title", $pid, 1, "pid");
//
echo "

";
echo " ";
echo "
";
echo"
";
xoops_cp_footer();
}

function modCatS()
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$cid = $HTTP_POST_VARS['cid'];
$pid = $HTTP_POST_VARS['pid'];
$title = $myts->makeTboxData4Save($HTTP_POST_VARS['title']);
if (empty($title)) {
redirect_header("index.php", 2, _MD_ERRORTITLE);
}
if ( ($HTTP_POST_VARS["imgurl"]) || ($HTTP_POST_VARS["imgurl"]!="") ) {
$imgurl = $myts->makeTboxData4Save($HTTP_POST_VARS["imgurl"]);
}
$xoopsDB->query("update ".$xoopsDB->prefix("addresses_cat")." set pid=$pid, title='$title', imgurl='$imgurl' where cid=$cid") or $eh->show("0013");
redirect_header("index.php",1,_MD_DBUPDATED);
}

function delCat()
{
global $xoopsDB, $HTTP_GET_VARS, $HTTP_POST_VARS, $eh, $mytree, $xoopsModule;
$cid = isset($HTTP_POST_VARS['cid']) ? intval($HTTP_POST_VARS['cid']) : intval($HTTP_GET_VARS['cid']);
$ok = isset($HTTP_POST_VARS['ok']) ? intval($HTTP_POST_VARS['ok']) : 0;
if ( $ok == 1 ) {
//get all subcategories under the specified category
$arr=$mytree->getAllChildId($cid);
$dcount=count($arr);
for ( $i=0;$i<$dcount;$i++ ) {
//get all links in each subcategory
$result=$xoopsDB->query("select lid from ".$xoopsDB->prefix("addresses_links")." where cid=".$arr[$i]."") or $eh->show("0013");
//now for each link, delete the text data and vote ata associated with the link
while ( list($lid)=$xoopsDB->fetchRow($result) ) {
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_text"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_votedata"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
xoops_comment_delete($xoopsModule->getVar('mid'), $lid);
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'link', $lid);
}
xoops_notification_deltebyitem($xoopsModule->getVar('mid'), 'category', $arr[$i]);

//all links for each subcategory is deleted, now delete the subcategory data
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("addresses_cat"), $arr[$i]);
$xoopsDB->query($sql) or $eh->show("0013");
}
//all subcategory and associated data are deleted, now delete category data and its associated data
$result=$xoopsDB->query("select lid from ".$xoopsDB->prefix("addresses_links")." where cid=".$cid."") or $eh->show("0013");
while ( list($lid)=$xoopsDB->fetchRow($result) ) {
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_text"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_votedata"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $lid);
// delete notifications
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'link', $lid);
}
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("addresses_cat"), $cid);
$xoopsDB->query($sql) or $eh->show("0013");
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'category', $cid);
redirect_header("index.php",1,_MD_CATDELETED);
exit();
} else {
xoops_cp_header();
xoops_confirm(array('op' => 'delCat', 'cid' => $cid, 'ok' => 1), 'index.php', _MD_WARNING);
xoops_cp_footer();
}
}

function delNewLink() //SHINE need to change later
{
global $xoopsDB, $HTTP_GET_VARS, $eh, $xoopsModule;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_links"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("addresses_text"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $HTTP_GET_VARS['lid']);
// delete notifications
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'link', $HTTP_GET_VARS['lid']);
redirect_header("index.php",1,_MD_LINKDELETED);
}

function addCat()
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$pid = $HTTP_POST_VARS["cid"];
$title = $myts->makeTboxData4Save($HTTP_POST_VARS["title"]);
if (empty($title)) {
redirect_header("index.php",2,_MD_ERRORTITLE);
exit();
}
if ( ($HTTP_POST_VARS["imgurl"]) || ($HTTP_POST_VARS["imgurl"]!="") ) {
// $imgurl = $myts->formatURL($HTTP_POST_VARS["imgurl"]);
// $imgurl = urlencode($imgurl);
$imgurl = $myts->makeTboxData4Save($HTTP_POST_VARS["imgurl"]);
}
$newid = $xoopsDB->genId($xoopsDB->prefix("addresses_cat")."_cid_seq");
$sql = sprintf("INSERT INTO %s (cid, pid, title, imgurl) VALUES (%u, %u, '%s', '%s')", $xoopsDB->prefix("addresses_cat"), $newid, $pid, $title, $imgurl);
$xoopsDB->query($sql) or $eh->show("0013");
if ($newid == 0) {
$newid = $xoopsDB->getInsertId();
}
global $xoopsModule;
$tags = array();
$tags['CATEGORY_NAME'] = $title;
$tags['CATEGORY_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewcat.php?cid=' . $newid;
$notification_handler =& xoops_gethandler('notification');
$notification_handler->triggerEvent('global', 0, 'new_category', $tags);
redirect_header("index.php",1,_MD_NEWCATADDED);
}

function addAddress() //SHINE need to change later
{
global $xoopsConfig, $xoopsDB, $myts, $xoopsUser, $xoopsModule, $eh, $HTTP_POST_VARS;
if ( ($HTTP_POST_VARS["url"]) || ($HTTP_POST_VARS["url"]!="") ) {
// $url=$myts->formatURL($HTTP_POST_VARS["url"]);
// $url = urlencode($url);
$url = $myts->makeTboxData4Save($HTTP_POST_VARS["url"]);
}

$otwarte = $myts->makeTboxData4Save($HTTP_POST_VARS["otwarte"]);

$logourl = $myts->makeTboxData4Save($HTTP_POST_VARS["logourl"]);
$title = $myts->makeTboxData4Save($HTTP_POST_VARS["title"]);
$adress = $myts->makeTboxData4Save($HTTP_POST_VARS["adress"]);
$zip = $myts->makeTboxData4Save($HTTP_POST_VARS["zip"]);
$city = $myts->makeTboxData4Save($HTTP_POST_VARS["city"]);
$country = $myts->makeTboxData4Save($HTTP_POST_VARS["country"]);
$phone = $myts->makeTboxData4Save($HTTP_POST_VARS["phone"]);
$mobile = $myts->makeTboxData4Save($HTTP_POST_VARS["mobile"]);
$fax = $myts->makeTboxData4Save($HTTP_POST_VARS["fax"]);
$contemail = $myts->makeTboxData4Save($HTTP_POST_VARS["contemail"]);
$opentime = $myts->makeTareaData4Save($HTTP_POST_VARS["opentime"]);
$description = $myts->makeTareaData4Save($HTTP_POST_VARS["description"]);
$submitter = $xoopsUser->uid();
$result = $xoopsDB->query("select count(*) from ".$xoopsDB->prefix("addresses_links")." where title='$title'"); //Original url='$url'
list($numrows) = $xoopsDB->fetchRow($result);
$errormsg = "";
$error = 0;
if ( $numrows > 0 ) {
$errormsg .= "
";
$errormsg .= _MD_ERROREXIST."
";
$error = 1;
}
// Check if Title exist
if ( $title == "" ) {
$errormsg .= "
";
$errormsg .= _MD_ERRORTITLE."
";
$error =1;
}

// Check if Description exist
// Disabled, cause admin should not be obligated to enter description
//if ( $description == "" ) {
// $errormsg .= "
";
// $errormsg .= _MD_ERRORDESC."
";
// $error =1;
//}
if ( $error == 1 ) {
xoops_cp_header();
echo $errormsg;
xoops_cp_footer();
exit();
}
if ( !empty($HTTP_POST_VARS['cid']) ) {
$cid = $HTTP_POST_VARS['cid'];
} else {
$cid = 0;
}

// SHINE: Did put own fields and gave them %s which correspondent with earlier lines
$newid = $xoopsDB->genId($xoopsDB->prefix("addresses_links")."_lid_seq");
$sql = sprintf("INSERT INTO %s (lid, cid, title, adress, zip, city, country, phone, mobile, fax, contemail, opentime, url, otwarte, logourl, submitter, status, date, hits, rating, votes, comments) VALUES (%u, %u, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %u, %u, %u, %u, %u, %u, %u)", $xoopsDB->prefix("addresses_links"), $newid, $cid, $title, $adress, $zip, $city, $country, $phone, $mobile, $fax, $contemail, $opentime, $url, $otwarte, $logourl, $submitter, 1, time(), 0, 0, 0, 0);
$xoopsDB->query($sql) or $eh->show("0013");
if ( $newid == 0 ) {
$newid = $xoopsDB->getInsertId();
}
$sql = sprintf("INSERT INTO %s (lid, description) VALUES (%u, '%s')", $xoopsDB->prefix("addresses_text"), $newid, $description);
$xoopsDB->query($sql) or $eh->show("0013");
$tags = array();
$tags['LINK_NAME'] = $title;
$tags['LINK_URL'] = XOOPS_URL . '/modules/'. $xoopsModule->getVar('dirname') . '/singlelink.php?cid=' . $cid . '&lid=' . $newid;
$sql = "SELECT title FROM " . $xoopsDB->prefix("addresses_cat") . " WHERE cid=" . $cid;
$result = $xoopsDB->query($sql);
$row = $xoopsDB->fetchArray($result);
$tags['CATEGORY_NAME'] = $row['title'];
$tags['CATEGORY_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewcat.php?cid=' . $cid;
$notification_handler =& xoops_gethandler('notification');
$notification_handler->triggerEvent('global', 0, 'new_link', $tags);
$notification_handler->triggerEvent('category', $cid, 'new_link', $tags);
redirect_header("index.php?op=addressesConfigMenu",1,_MD_NEWLINKADDED);
}

function approve()
{
global $xoopsConfig, $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$lid = $HTTP_POST_VARS['lid'];
$title = $HTTP_POST_VARS['title'];
$cid = $HTTP_POST_VARS['cid'];
if ( empty($cid) ) {
$cid = 0;
}
$description = $HTTP_POST_VARS['description'];
if (($HTTP_POST_VARS["url"]) || ($HTTP_POST_VARS["url"]!="")) {
// $url=$myts->formatURL($HTTP_POST_VARS["url"]);
// $url = urlencode($url);
$url = $myts->makeTboxData4Save($HTTP_POST_VARS["url"]);
}

$otwarte = $myts->makeTboxData4Save($HTTP_POST_VARS["otwarte"]);

$logourl = $myts->makeTboxData4Save($HTTP_POST_VARS["logourl"]);
$title = $myts->makeTboxData4Save($title);
$adress = $myts->makeTboxData4Save($HTTP_POST_VARS["adress"]);
$zip = $myts->makeTboxData4Save($HTTP_POST_VARS["zip"]);
$city = $myts->makeTboxData4Save($HTTP_POST_VARS["city"]);
$country = $myts->makeTboxData4Save($HTTP_POST_VARS["country"]);
$phone = $myts->makeTboxData4Save($HTTP_POST_VARS["phone"]);
$mobile = $myts->makeTboxData4Save($HTTP_POST_VARS["mobile"]);
$fax = $myts->makeTboxData4Save($HTTP_POST_VARS["fax"]);
$contemail = $myts->makeTboxData4Save($HTTP_POST_VARS["contemail"]);
$opentime = $myts->makeTareaData4Save($HTTP_POST_VARS["opentime"]);
$description = $myts->makeTareaData4Save($description);
$query = "update ".$xoopsDB->prefix("addresses_links")." set cid='$cid', title='$title', adress='$adress', zip='$zip', city='$city', country='$country', phone='$phone', mobile='$mobile', fax='$fax', contemail='$contemail', opentime='$opentime', url='$url', otwarte='$otwarte', logourl='$logourl', status=1, date=".time()." where lid=".$lid."";
$xoopsDB->query($query) or $eh->show("0013");
$query = "update ".$xoopsDB->prefix("addresses_text")." set description='$description' where lid=".$lid."";
$xoopsDB->query($query) or $eh->show("0013");
global $xoopsModule;
$tags=array();
$tags['LINK_NAME'] = $title;
$tags['LINK_URL'] = XOOPS_URL . '/modules/'. $xoopsModule->getVar('dirname') . '/singlelink.php?cid=' . $cid . '&lid=' . $lid;
$sql = "SELECT title FROM " . $xoopsDB->prefix("addresses_cat") . " WHERE cid=" . $cid;
$result = $xoopsDB->query($sql);
$row = $xoopsDB->fetchArray($result);
$tags['CATEGORY_NAME'] = $row['title'];
$tags['CATEGORY_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewcat.php?cid=' . $cid;
$notification_handler =& xoops_gethandler('notification');
$notification_handler->triggerEvent('global', 0, 'new_link', $tags);
$notification_handler->triggerEvent('category', $cid, 'new_link', $tags);
$notification_handler->triggerEvent('link', $lid, 'approve', $tags);
redirect_header("index.php",1,_MD_NEWLINKADDED);
}
if(!isset($HTTP_POST_VARS['op'])) {
$op = isset($HTTP_GET_VARS['op']) ? $HTTP_GET_VARS['op'] : 'main';
} else {
$op = $HTTP_POST_VARS['op'];
}
switch ($op) {
case "delNewLink":
delNewLink();
break;
case "approve":
approve();
break;
case "addCat":
addCat();
break;
case "addAddress":
addAddress();
break;
case "listBrokenAddresses":
listBrokenAddresses();
break;
case "delBrokenLinks":
delBrokenLinks();
break;
case "ignoreBrokenLinks":
ignoreBrokenLinks();
break;
case "listModReq":
listModReq();
break;
case "changeModReq":
changeModReq();
break;
case "ignoreModReq":
ignoreModReq();
break;
case "delCat":
delCat();
break;
case "modCat":
modCat();
break;
case "modCatS":
modCatS();
break;
case "modLink":
modLink();
break;
case "modLinkS":
modLinkS();
break;
case "delLink":
delLink();
break;
case "delVote":
delVote();
break;
case "addressesConfigMenu":
addressesConfigMenu();
break;
case "listNewAddresses":
listNewAddresses();
break;
case 'main':
default:
addresses();
break;
}
?>

Re: addresses !

2004/4/4 16:19
cuckston
Quite a regular
Posts: 268
Since: 2004/1/19

Sorry, but what are you trying to show here??

Re: addresses !

2004/4/4 16:54
Shine
Just can't stay away
Posts: 822
Since: 2002/7/22

If you want to add a new field you have to dig into every .php file, template, language file AND sql of this module.
Since this mod is a rewrite of the original mylinks module it shouldn't be to hard to see where and what should be done to add another field. Just take a good look on how the other addresses fields were added and do the same for the one you want to add.

Grtz., Shine

Stats
Goal:	$100.00
Due Date:	Jul 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

addresses !

"._MD_WEBLINKSCONF."

"._MD_WEBLINKSCONF."

"._MD_LINKSWAITING." ($numrows)

"._MD_WEBLINKSCONF."

"._MD_ADDMAIN."

"._MD_ADDSUB."

"._MD_ADDNEWLINK."

"._MD_MODCAT."

"._MD_MODLINK."

"._MD_WEBLINKSCONF."

"._MD_MODLINK."

"._MD_WEBLINKSCONF."

"._MD_BROKENREPORTS." ($totalbrokenaddresses)

"._MD_WEBLINKSCONF."

"._MD_USERMODREQ." ($totalmodrequests)

"._MD_WEBLINKSCONF."

"._MD_MODCAT."

";
$errormsg .= _MD_ERROREXIST."

";
$errormsg .= _MD_ERRORTITLE."

";
// $errormsg .= _MD_ERRORDESC."

Re: addresses !

Re: addresses !

Login

Search

Recent Posts

PHP 8.4.0 Alpha 1 released

Overview of the Composer packages in Admin

Re: xoops_getBaseDomain

xoops_getBaseDomain

Re: Test 3

Test 3

Re: Test2

Re: Test2

Re: Test2

Test2

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

"._MD_ORIGINAL."
"._MD_SITETITLE."	$origtitle
"._MD_ADRESS.":	$origadress
"._MD_ZIP.":	$origzip
"._MD_CITY.":	$origcity
"._MD_COUNTRY.":	$origcountry
"._MD_PHONE.":	$origphone
"._MD_MOBILE.":	$origmobile
"._MD_FAX.":	$origfax
"._MD_CONTEMAIL.":	$origcontemail
"._MD_SITEURL."	$origurl
"._MD_otwarte."	$origotwarte
"._MD_OPENED.":	$origopentime
"._MD_CATEGORYC."	$origcidtitle
"._MD_SHOTIMAGE."	"; if ( $xoopsModuleConfig['useshots'] && !empty($origlogourl) ) { echo ""; } else { echo " "; } echo "
"._MD_DESCRIPTIONC."	$origdescription
"._MD_PROPOSED."
"._MD_SITETITLE."	$title
"._MD_ADRESS."	$adress
"._MD_ZIP."	$zip
"._MD_CITY."	$city
"._MD_COUNTRY."	$country
"._MD_PHONE."	$phone
"._MD_MOBILE."	$mobile
"._MD_FAX."	$fax
"._MD_CONTEMAIL."	$contemail
"._MD_SITEURL."	$url
"._MD_otwarte."	$url
"._MD_OPENED."	$opentime
"._MD_CATEGORYC."	$cidtitle
"._MD_SHOTIMAGE."	"; if ( $xoopsModuleConfig['useshots'] == 1 && !empty($logourl) ) { echo " $\"/\"$ "; } else { echo " "; } echo "
"._MD_DESCRIPTIONC."	$description

addresses !

"._MD_WEBLINKSCONF."

"._MD_WEBLINKSCONF."

"._MD_LINKSWAITING." ($numrows)

"._MD_WEBLINKSCONF."

"._MD_ADDMAIN."

"._MD_ADDSUB."

"._MD_ADDNEWLINK."

"._MD_MODCAT."

"._MD_MODLINK."

"._MD_WEBLINKSCONF."

"._MD_MODLINK."

"._MD_WEBLINKSCONF."

"._MD_BROKENREPORTS." ($totalbrokenaddresses)

"._MD_WEBLINKSCONF."

"._MD_USERMODREQ." ($totalmodrequests)

"._MD_WEBLINKSCONF."

"._MD_MODCAT."

"; $errormsg .= _MD_ERROREXIST."

"; $errormsg .= _MD_ERRORTITLE."

"; // $errormsg .= _MD_ERRORDESC."

Re: addresses !

Re: addresses !

Login

Search

Recent Posts

Who's Online

Donat-O-Meter

Latest GitHub Commits

";
$errormsg .= _MD_ERROREXIST."

";
$errormsg .= _MD_ERRORTITLE."

";
// $errormsg .= _MD_ERRORDESC."