::::: MySQL QUERY ERROR :::::';
$message .= '
SQL = '.$sql.'
';
$message .= '
'.mysql_error().'
';
$message .= '::::: END OF ERROR REPORT :::::';
$message .= '
';
$msg = mysql_error().' - '.$sql;
catchError(2,clearText($msg));
echo $message;
}
}
function catchError($type,$msg) {
}
//-------------------------------------------------------------//
function checkLevel($level,$e_mssg='Het level een getal moet zijn.') {
if (!empty($level))
{
if (!is_numeric($level))
{
$ERR = $e_mssg;
}
}
return $ERR;
}
function moneyConvert($price,$pre=1) {
if ($pre == 1) {
$pre = '€ ';
$pst = ''; }
elseif ($pre == 2) {
$pre = '';
$pst = ' €'; }
else {
$pre = '';
$pst = '';
}
$price = $pre.number_format($price, 2, ',', '.').$pst;
return $price;
}
function makeNumber($num) {
$newnum = number_format($num, 0, '', '.');
return $newnum;
}
function CountImages($ref,$id) {
$Sql = 'SELECT * FROM tblPhotos WHERE ph_ref = "'.$ref.'" AND ph_ref_id = "'.$id.'" ';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$cnt = mysql_num_rows($Res);
if ($cnt<1) {$cnt=''; }
echo $cnt;
}
function CountFiles($ref,$id) {
$Sql = 'SELECT * FROM tblFiles WHERE fl_ref = "'.$ref.'" AND fl_ref_id = "'.$id.'" ';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$cnt = mysql_num_rows($Res);
if ($cnt<1) {$cnt=''; }
echo $cnt;
}
function checkFiles($table,$what) {
$sql_cnt = 'SELECT * FROM '.$table.' WHERE '.$what ;
$res_cnt = mysql_query($sql_cnt) or die('Error while executing the query';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
while ($list = mysql_fetch_array($Res) ) {
if (!empty($list['art_title'])) echo '
'.$list['art_title'].'
';
echo '
';
//echo GetFirstImage('aid',$list['art_id'],$ImgPathS,'frstimg');
echo showMCE($list['art_msg']);
echo '
';
}
echo '
';
}
}
function GetMenuWidgets($mnu,$wgds,$lng) {
if(!empty( $wgds )) {
$arr = explode(',',$wgds);
foreach ($arr as $val) {
$Sql = 'SELECT * FROM tblArticle WHERE art_m_id IN ('.$val.') AND lang='.$lng.' AND art_type_id=1 AND art_active=1 ORDER BY art_m_id, art_level LIMIT 3';
$cnt = countRows($Sql);
if ($cnt > 0) {
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$w=0;
$t_wdg_old = '';
while ($list = mysql_fetch_array($Res) ){
$t_wdg = $mnu[$list['art_m_id']][$lng];
if($t_wdg != $t_wdg_old ) {
if($w!=0) echo '';
echo ''.$t_wdg.'
';
$w++;
}
if (!empty($list['art_title'])) echo '
'.$list['art_title'].'
';
echo '
';
//echo GetFirstImage('aid',$list['art_id'],$ImgPathS,'frstimg');
echo strwcut(showMCE($list['art_msg']),150);
echo '» '.READ_MORE.'';
echo '
';
$t_wdg_old = $t_wdg;
} //--- end while loop
echo '
';
} //--- end cnt>0
} //--- end foreach loop
} //--- end !empty
}
function GetModWidgets($mnu,$wgds,$lng,$path) {
if(!empty( $wgds )) {
$arr = explode(',',$wgds);
foreach ($arr as $val) {
$Sql = 'SELECT m_id, mod_widget FROM tblMenu, tblModules WHERE mod_id=m_mod_id AND m_active=1 AND mod_active=1 AND mod_id="'.$val.'" LIMIT 1';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$list = mysql_fetch_array($Res);
$t_wdg = $mnu[$list['m_id']][$lng];
//echo 'JAHOOORRR';
if (!empty($list['mod_widget'])) {
require($path.$list['mod_widget']);
}
} //--- end foreach loop
} //--- end !empty
}
//-------------------------------------
function GetSitePrefs() {
$Sql = 'SELECT * FROM tblSitePrefs LIMIT 1';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$list = mysql_fetch_array($Res);
return $list;
}
//-------------------------------------
function getMenuTitleId($mid,$lng) {
$Sql = 'SELECT * FROM tblMenuLang WHERE ml_m_id="'.$mid.'" AND ml_lang="'.$lng.'" LIMIT 1';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$list = mysql_fetch_array($Res);
return $list['ml_id'];
}
//-------------------------------------
function getMenuTitle($mid,$lng) {
$Sql = 'SELECT * FROM tblMenuLang WHERE ml_m_id="'.$mid.'" AND ml_lang="'.$lng.'" LIMIT 1';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$list = mysql_fetch_array($Res);
return $list['ml_title'];
}
//-------------------------------------
function UptMenuLang ($m_id, $lng, $ml_title) {
$ml_id = getMenuTitleId($m_id,$lng);
if ( $ml_id < 1 )
{
$sql = 'INSERT INTO tblMenuLang
(
ml_m_id,
ml_lang,
ml_title
)
VALUES
(
"'.$m_id.'",
"'.$lng.'",
"'.$ml_title.'"
)
';
}else{
$sql = '
UPDATE
tblMenuLang
SET
ml_m_id = "'.$m_id.'",
ml_lang = "'.$lng.'",
ml_title = "'.$ml_title.'"
WHERE
ml_id = "'.$ml_id.'"
LIMIT 1
';
}
if(!$add = mysql_query($sql)) { SqlError($sql); }
}
//-------------------------------------
function GetMenuArray() {
$mnu = array();
$Sql = 'SELECT * FROM tblMenuLang ORDER BY ml_m_id, ml_lang';
if(!$Res = mysql_query($Sql)) { SqlError($Sql); }
$oldmid = '';
while ($list = mysql_fetch_array($Res)) {
$mid = $list['ml_m_id'];
if ($oldmid != $mid) {
$mnu[$mid] = array();
}
$mnu[$mid][$list['ml_lang']] = $list['ml_title'];
$oldmid = $mid;
}
return $mnu;
}
//-----------------------------------------
function GetMenuAdmin($site=1,$mnu,$lng, $drag) {
$sql = 'SELECT * FROM tblMenu WHERE m_site = '.$site.' ORDER BY m_level';
$cnt = countRows($sql);
if ($cnt > 0) {
$drag == 1 ? $id = 'id="m_drag"' : $id = '';
echo ''."\n";
}
}
function GoToStartMenu() {
$sql = 'SELECT * FROM tblMenu LEFT JOIN tblModules ON (mod_id=m_mod_id) WHERE m_active=1 ORDER BY m_level LIMIT 1';
if(!$res = mysql_query($sql)) { SqlError($$sql); }
$list = mysql_fetch_array($res);
empty($list['mod_front_link']) ? $url = 'content.php?mnu='. $list['m_id'] : $url = $list['mod_front_link'].'?mnu='. $list['m_id'];
gotoUrl($url);
}
function GetRedirect($path='') {
$sql = 'SELECT * FROM tblMenu LEFT JOIN tblModules ON (mod_id=m_mod_id) WHERE m_active=1 ORDER BY m_level LIMIT 1';
if(!$res = mysql_query($sql)) { SqlError($$sql); }
$list = mysql_fetch_array($res);
empty($list['mod_front_link']) ? $url = 'content.php?mnu='. $list['m_id'] : $url = $list['mod_front_link'].'?mnu='. $list['m_id'];
return $path.$url;
}
function GetMenuFront($site,$mnu,$lng,$ul,$act=0,$showrel=true) {
$sql = 'SELECT * FROM tblMenu LEFT JOIN tblModules ON (mod_id=m_mod_id) WHERE m_site = '.$site.' AND m_show=1 AND m_active=1 ORDER BY m_level';
$cnt = countRows($sql);
if ($cnt > 0) {
!empty($ul) ? $uli = ' '.$ul : $uli = '';
echo '