Make btn img Image Creation Problem $basedir/images/$filename.png"; } // echo "$bg,$txt,$font,$fontsz,$filename,$x,$y,$shadow"; //echo "\nimg $txt $basedir/images/$filename.png\n"; imagedestroy($image); return "$filename.png"; } function button_create($nm){ include "global_generate.inc"; include "host.inc"; $nm1 = strtolower(str_replace(" ","_",trim($nm))); $filename = "btn_".$nm1.".png"; $filename1 = "btn_".$nm1; $filename2 = "btn_".$nm1."_over"; $menubtns[$nm][0]=$nm; $menubtns[$nm][1]=$filename; $menubtns[$nm][2]="$filename2.png"; if (!file_exists("$basedir/images/".$filename)){ // "
Button Not found images/".$filename; switch (true){ case (strlen($nm) < 9): $fontsz = 13; $basep = 22; break; case (strlen($nm) < 13): $fontsz = 13; $basep = 22; break; case (strlen($nm) < 18): $fontsz = 11; $basep = 21; break; default: $fontsz = 10; $basep = 20; } // echo "
file to create for :".$nm.":".$filename1.":"; make_btn_img("basebtn1.jpg",$nm,"arial",$fontsz,$filename1,10,$basep,false); } if (!(file_exists("$basedir/images/".$filename2.".png"))){ // "
Rollover Not found images/".$filename2.".png"; switch (true){ case (strlen($nm) < 9): $fontsz = 13; $basep = 22; break; case (strlen($nm) < 13): $fontsz = 13; $basep = 22; break; case (strlen($nm) < 18): $fontsz = 11; $basep = 21; break; default: $fontsz = 10; $basep = 20; } echo "
file to create for :".$nm.":".$filename1.":";
make_btn_img("basebtn2.jpg",$nm,"arial",$fontsz,$filename2,10,$basep,false);
}
// if ($x =!(file_exists("../images/".$filename)) || $y = !(file_exists("../images/".$filename2.".png"))){
// echo "
NOT EXISTS AFTER X=$x y=$y filename $nm $nm1 0:$filename 1:$filename1 2:$filename2";
// }
return $filename;
}
function add_maint($url,$st,$dt,$tag){
$SQLstr = "insert into h_maint (maint_url,maint_st_time,maint_status,maint_tag) values('$url','$dt','$st','$tag')";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
}
function include_file($fl){
//echo "inc $fl inc";
$tx = file_get_contents($fl);
return $tx;
}
function disp_adv($rw,$par_id,$actions){
global $sql, $imagedir,$types;
include "global_adv.inc";
load_adv($rw);
if ($adv_visible == 1 || $actions){
$ct++;
if ($ct % 2 == 0){
$cls = "";
} else {
$cls = "a";
}
$out2 .= "
Delete";
}
}
}
return $out2;
}
function rm_recurse($file) {
if (is_dir($file) && !is_link($file)) {
foreach(glob($file.'/*') as $sf) {
if ( !rm_recurse($sf) ) {
error_log("Failed to remove $sf\n");
return false;
}
}
return rmdir($file);
} else {
// echo "umlink $file";
return unlink($file);
}
}
function add_keyword_link($wrd,$id,$wgs,$pri,$typ){
global $notfounds,$halffounds;
if (strlen($wrd) > 1){
$SQLstr2 = "select * from h_word, h_word_groups, h_wg_words where word_word like '$wrd' and (wg_id = ".$wgs[0]." or wg_id = ".$wgs[1]." ) and word_id = wgw_word_id and wg_id = wgw_wg_id ";
// echo $SQLstr2;
$result2=MYSQL_QUERY("$SQLstr2");
while($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) {
$aid = $row2['wgw_id'];
if ($aid>0){
$pri = sprintf("%03d",$pri);
$SQLstr3="insert into h_links (link_primary_id, link_secondary_id,link_type,link_tag) values ('$id','$aid','$typ','$pri')";
// echo $SQLstr3;
$result3=MYSQL_QUERY("$SQLstr3");
}
}
if ($aid ==""){
// echo "$wrd";
$SQLstr2 = "select * from h_word where word_word like '$wrd' ";
//echo $SQLstr2;
$result2=MYSQL_QUERY("$SQLstr2");
while($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) {
$wid = $row2['word_id'];
}
if ($wid == ""){
echo "
$url_id ";
$notfounds[$wrd]++;
echo "$wrd not found anywhere
";
} else {
$halffounds[$wrd]++;
echo "
$url_id ";
echo " $wrd found not in $wgs[0] or $wgs[1]
";
}
}
}
}
function show_word_links($wid){
$SQLstr = "select w.word_id as wid, w.word_word as wrd, par.word_word as par from h_word w, h_wg_words, h_word_groups, h_word par where w.word_id = $wid and w.word_id = wgw_word_id and wgw_wg_id = wg_id and wg_word_id = par.word_id";
$result=MYSQL_QUERY("$SQLstr");
//echo "$SQLstr";
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$wid = $row['wid'];
$wrd = $row['wrd'];
$par = $row['par'];
return "$wrd parent=$par";
}
}
function process_keywords($kws,$url_id,$wgs,$typ){
global $notfounds,$halffounds;
//echo " $kws; ";
$SQLstr = "delete from h_links where link_type = '$typ' and link_primary_id = $url_id";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
$kywds = explode(";",$kws);
foreach($kywds as $ks){
if ($ks!="0"){
//echo $ks;
$prict++;
$k=explode(":",$ks);
add_keyword_link(trim($k[0]),$url_id,$wgs,$prict,$typ);
}
}
}
function link_all_url_to_wc2(){
global $notfounds,$halffounds;
$SQLstr = "select * from h_url ";
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$url_id = $row["url_id"];
$ct++;
// echo "
$ct ".$row['url_domain']; $kws = $row["url_adv_keywords"]; $wgs[0]= $row["url_word_group_id"]; $wgs[1]= $row["url_word_group_id2"]; process_keywords($kws,$url_id,$wgs,"wc2"); } //print_r($notfounds); echo "
$adv_nm link problem";
}
}
if (strlen($adv_logo_link) < 5) {
$adv_logo_link = $adv_link;
}
if (strlen($adv_banner_link) < 5) {
$adv_banner_link = $adv_link;
}
if ($adv_link_type==0) {
$adv_link_type = 100;
}
}
}
function get_adv($aid){
include "global_adv.inc";
$SQLstr = "select * from h_advertiser where adv_id = '$aid'";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_adv($row);
return true;
} else {
return false;
}
}
function load_wg($row){
include "global_wc.inc";
$wg_id= $row['wg_id'];
$wg_word_id = $row['wg_word_id'];
$wg_par_id= $row['wg_par_id'];
$wg_bg_img= $row['wg_bg_img'];
$wg_page_img= $row['wg_page_img'];
$wg_logo_img= $row['wg_logo_img'];
$wg_keywords= $row['wg_keywords'];
$wg_brands= $row['wg_brands'];
$wg_page= $row['wg_page'];
$wg_type= $row['wg_type'];
$wg_template= $row['wg_template'];
$wg_name= $row['word_word'];
}
function get_wg($id){
include "global_wc.inc";
$SQLstr = "select * from h_word_groups, h_word where wg_id = '$id' and wg_word_id =word_id";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_wg($row);
return true;
} else {
return false;
}
}
function load_pic($row){
global $types;
include "global_pic.inc";
$pic_id= $row['pic_id'];
$pic_name = $row['pic_name'];
$pic_desc= $row['pic_desc'];
$pic_size= $row['pic_size'];
$pic_height= $row['pic_height'];
$pic_width= $row['pic_width'];
$pic_location= $row['pic_location'];
$pic_add_dt= $row['pic_add_dt'];
$pic_item_id= $row['pic_item_id'];
$pic_item_type= $row['pic_item_type'];
}
function get_pic($id){
include "global_pic.inc";
$SQLstr = "select * from h_pictures where pic_id = '$id'";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_pic($row);
return true;
} else {
return false;
}
}
function load_aff($row){
global $types;
include "global_affiliate.inc";
$aff_id= $row['aff_id'];
$aff_name = $row['aff_name'];
$aff_desc= $row['aff_desc'];
$aff_strap= $row['aff_strap'];
$aff_version= $row['aff_version'];
$aff_logo= $row['aff_logo'];
$aff_lst_upd= $row['aff_lst_upd'];
$aff_adv_id= $row['aff_adv_id'];
$aff_program= $row['aff_program'];
$aff_program_id= $row['aff_program_id'];
$aff_block_prods= $row['aff_block_prods'];
}
function get_adv_from_mer($prod_merchant_id,$prod_source_id){
include 'global_adv.inc';
include 'global_affiliate.inc';
get_aff($prod_merchant_id,"program_id",$prod_source_id);
$SQLstr = "select * from h_links where link_type = 'adm' and link_secondary_id = $aff_id";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$aid = $row['link_primary_id'];
get_adv($aid);
}
function get_aff($id,$type,$program){
include "global_affiliate.inc";
$SQLstr = "select * from h_affiliate where aff_$type = '$id' ";
if ($program != ""){
$SQLstr .= " and aff_program ='$program'";
}
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_aff($row);
if ($aff_id > 0){
return true;
} else {
return false;
}
} else {
return false;
}
}
function load_prod($row){
global $types;
include "global_prod.inc";
include "global_template.inc";
$prod_id= $row['prod_id'];
$prod_name = utf8_encode($row['prod_name']);
$prod_link = urlencode($row['prod_link']);
//echo $temp_pub_prod.":". $types[$temp_pub_prod]['alpha4'].";";
// $deep_link = urlencode(str_replace("***prodlink***",$prod_link,$types[$temp_pub_prod]['alpha4']));
// $prod_link = "http://***domain***/shop.php?typ=2&ref=$deep_link:::".$row['prod_pub_adv'];
if (strlen($row['prod_desc']) > 512){
$prod_desc= utf8_encode(substr($row['prod_desc'],0,512)."...");
} else {
$prod_desc= utf8_encode($row['prod_desc']);
}
$prod_thumb= $row['prod_thumb'];
$prod_price= $row['prod_price'];
$prod_image= $row['prod_image'];
$prod_product_id= $row['prod_product_id'];
$prod_merchant_id= $row['prod_merchant_id'];
$prod_merchant_name= $row['prod_merchant_name'];
$prod_cat_id= $row['prod_cat_id'];
$prod_add_dt= $row['prod_add_dt'];
$prod_ibsn= $row['prod_ibsn'];
$prod_brand= $row['prod_brand'];
$prod_source_id= $row['prod_source_id'];
$prod_source_cat= $row['prod_source_cat'];
$prod_pub_cat= $row['prod_pub_cat'];
$prod_pub_adv= $row['prod_pub_adv'];
}
function get_prod($id){
include "global_prod.inc";
$SQLstr = "select * from h_products where prod_id = '$id'";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_prod($row);
if ($prod_id > 0){
return true;
} else {
return false;
}
} else {
return false;
}
}
function add_mer_adv($mer_id) {
include "global_adv.inc";
include "global_affiliate.inc";
$SQLstr = "select max(adv_id) as mid from h_advertiser ";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$nid = $row['mid']+1;
$adv_id = $nid;
get_aff($mer_id,"id","");
$SQLstr = "insert into h_advertiser (adv_id,adv_name, adv_keywords, adv_short_desc, adv_link_display,adv_page, adv_link, adv_type, adv_visible,";
$SQLstr .= " adv_my_ref, adv_logo2, adv_banner_img, adv_status,adv_priority,adv_program) values ($nid,";
$SQLstr .= " '".sq($aff_name)."', '','".sq($aff_desc)."', '".sq($aff_name)."', '', '$aff_link', '".ADVERTISER."', '1',";
$SQLstr .= " '$aff_program_id', '$aff_logo', '', '', '500','$aff_program')";
$result=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
// $nid++;
// $SQLstr = "insert into h_advertiser (adv_id,adv_name, adv_keywords, adv_short_desc, adv_link_display,adv_page, adv_link, adv_type, adv_visible,";
// $SQLstr .= " adv_my_ref, adv_logo_img, adv_banner_img, adv_status,adv_priority,adv_program) values ($nid,";
/// $SQLstr .= " '".sq($aff_name)."', '','".sq($aff_desc)."', '".sq($aff_name)."', '', '$aff_link', '".ADVERT."', '1',";
// $SQLstr .= " '$aff_program_id', '$aff_logo', '', '', '','$aff_program')";
// $result=MYSQL_QUERY("$SQLstr");
// add_link($adv_id,$nid,'ada');
add_link($adv_id,$mer_id,'adm');
return $adv_id;
}
function clone_adv_links($orig,$ads){
$primary = array ('awc','asc','ac1','as1');
$secondary = array ('adv');
foreach($ads as $adv_id){
foreach($primary as $type){
$SQLstr = "select * from h_links where link_type = '$type' and link_primary_id = '$orig'";
$result=MYSQL_QUERY("$SQLstr");
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$other = $row['link_secondary_id'];
//echo "($adv_id,$other,$type)";
add_link($adv_id,$other,$type);
}
}
foreach($secondary as $type){
$SQLstr = "select * from h_links where link_type = '$type' and link_secondary_id = '$orig'";
$result=MYSQL_QUERY("$SQLstr");
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$other = $row['link_primary_id'];
add_link($other,$adv_id,$type);
}
}
}
}
function clone_adv($orig_id,$par_id){
global $types;
include "global_adv.inc";
get_adv($orig_id);
switch ($adv_type){
case ADVERT:
$advertiser=false;
$clonelinks=true;
$mytype = ADVERT;
break;
case ADVERTISER:
// echo "par $par_id";
if ($par_id > 0) { //clone advertiser as advert.
$advertiser=false;
$clonelinks=false;
$mytype = ADVERT;
} else {
$advertiser=true;
$clonelinks=false;
$mytype = ADVERTISER;
$mytype2 = ADVERT;
}
break;
}
// echo ADVERTISER.";".ADVERT;
$SQLstr = "select max(adv_id) as mid from h_advertiser ";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$nid = $row['mid']+1;
$adv_id = $nid;
// if(!$advertiser){
$newads[]=$nid;
// }
$SQLstr = "insert into h_advertiser (adv_id,adv_name, adv_keywords, adv_short_desc, adv_link_display,adv_page, adv_link, adv_type, adv_visible,";
$SQLstr .= " adv_my_ref, adv_my_ref2, adv_my_ref3, adv_my_ref4, adv_my_ref5, adv_logo_img, adv_logo2,adv_logo3,adv_banner_img, adv_status,adv_priority,adv_banner_link,adv_logo_link,adv_program,adv_link_type) values ($nid,";
$SQLstr .= " '$adv_nm', '$adv_keywords','".sq($adv_short_desc)."', '$adv_link_display', '$adv_page', '$adv_link', '$mytype', '$adv_visible',";
$SQLstr .= " '$adv_my_ref', '$adv_my_ref2', '$adv_my_ref3', '$adv_my_ref4', '$adv_my_ref5', '$adv_logo_img', '$adv_logo2', '$adv_logo3', '$adv_banner_img', '$adv_status', '$adv_priority','$adv_banner_link','$adv_logo_link','$adv_program','$adv_link_type' )";
$result=MYSQL_QUERY("$SQLstr");
//echo "
$SQLstr";
if ($mytype==ADVERT){
// add_link($orig_id,$nid,'ada');
add_link($par_id,$nid,'ada');
}
if ($advertiser){ // add first advert
// $nid++;
// $newads[]=$nid;
// $SQLstr = "insert into h_advertiser (adv_id,adv_name, adv_keywords, adv_short_desc, adv_link_display,adv_page, adv_link, adv_type, adv_visible,";
// $SQLstr .= " adv_my_ref, adv_logo_img, adv_banner_img, adv_status,adv_priority,adv_banner_link,adv_logo_link,adv_program,adv_link_type) values ($nid,";
// $SQLstr .= " '$adv_nm Clone First Advert', '$adv_keywords','".sq($adv_short_desc)."', '$adv_link_display', '$adv_page', '$adv_link', '".ADVERT."', '$adv_visible',";
// $SQLstr .= " '$adv_my_ref', '$adv_logo_img', '$adv_banner_img', '$adv_status', '$adv_priority','$adv_banner_link','$adv_logo_link','$adv_program','$adv_link_type')";
//echo "
$SQLstr";
// $result=MYSQL_QUERY("$SQLstr");
// add_link($adv_id,$nid,'ada');
}
if ($orig_id>0){
clone_adv_links($orig_id,$newads);
}
return $adv_id;
}
function add_adv($par_id){
global $types;
$SQLstr = "select max(adv_id) as mid from h_advertiser ";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$nid = $row['mid']+1;
$SQLstr = "insert into h_advertiser (adv_id,adv_name, adv_keywords, adv_short_desc, adv_link_display,adv_page, adv_link, adv_type, adv_visible,";
$SQLstr .= " adv_my_ref, adv_my_ref2, adv_my_ref3, adv_my_ref4, adv_my_ref5, adv_logo_img, adv_logo2, adv_logo3, adv_banner_img, adv_status,adv_priority,adv_program,adv_banner_link,adv_logo_link,adv_link_type) values ($nid,";
$SQLstr .= " '".sq($_POST['adv_nm'])."', '".$_POST['adv_keywords']."','".sq($_POST['adv_short_desc'])."', '".$_POST['adv_link_display']."',";
$SQLstr .= " '".$_POST['adv_page']."', '".$_POST['adv_link']."', '".$_POST['adv_type']."', '".$_POST['adv_visible']."',";
$SQLstr .= " '".sq($_POST['adv_my_ref'])."', '".sq($_POST['adv_my_ref2'])."', '".sq($_POST['adv_my_ref3'])."', '".sq($_POST['adv_my_ref4'])."', '".sq($_POST['adv_my_ref5'])."', '".$_POST['adv_logo_img']."', '".$_POST['adv_logo2']."', '".$_POST['adv_logo3']."', '".$_POST['adv_banner_img']."', '".$_POST['adv_status']."', '".$_POST['adv_priority']."', '".$_POST['adv_program']."', '".$_POST['adv_banner_link']."', '".$_POST['adv_logo_link']."', '".$_POST['adv_link_type']."')";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
//here
if ($nid > 0 ){
$SQLstr = "select * from h_advertiser where adv_id = $par_id";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$par_type= $row['adv_type'];
switch ($par_type){
case ADVERT:
$SQLstr = "select * from h_links where link_type ='ada' and link_secondary_id = $par_id";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$wid = $row['link_primary_id'];
add_link($wid,$nid,'ada');
break;
case ADVERTISER:
add_link($par_id,$nid,'ada');
break;
}
for ($i=1;$i<3;$i++){
$ptype = $types[$par_type]['alpha'.$i];
$ctype = $types[ADVERT]['alpha'.$i];
$SQLstr = "select * from h_links where link_type ='$ptype' and link_primary_id = $par_id";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$wid = $row['link_secondary_id'];
add_link($nid,$wid,$ctype);
}
}
// echo "Advertiser Added ";
return $nid;
} else {
echo "Advertiser Add Failed";
return false;
}
}
function upd_adv($adv_id){
$SQLstr = "update h_advertiser set adv_name='".$_POST['adv_nm']."', adv_keywords='".$_POST['adv_keywords']."', adv_short_desc='".sq($_POST['adv_short_desc'])."', adv_link_display='".$_POST['adv_link_display']."', adv_program='".$_POST['adv_program']."', ";
$SQLstr .= " adv_page='".$_POST['adv_page']."', adv_link='".$_POST['adv_link']."', adv_type='".$_POST['adv_type']."', adv_visible='".$_POST['adv_visible']."', adv_website='".$_POST['adv_website']."', adv_priority='".$_POST['adv_priority']."',";
$SQLstr .= " adv_my_ref='".sq($_POST['adv_my_ref'])."', adv_my_ref2='".sq($_POST['adv_my_ref2'])."', adv_my_ref3='".sq($_POST['adv_my_ref3'])."', adv_my_ref4='".sq($_POST['adv_my_ref4'])."', adv_my_ref5='".sq($_POST['adv_my_ref5'])."', adv_logo_img='".$_POST['adv_logo_img']."', adv_logo2='".$_POST['adv_logo2']."', adv_logo3='".$_POST['adv_logo3']."', adv_banner_img='".$_POST['adv_banner_img']."', adv_logo_link='".$_POST['adv_logo_link']."', adv_banner_link='".$_POST['adv_banner_link']."', adv_status='".$_POST['adv_status']."', adv_link_type='".$_POST['adv_link_type']."' where adv_id = $adv_id ";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
// echo "Advertiser Updated ";
return true;
} else {
echo "Advertiser Update Failed";
return false;
}
}
function upd_advwgs($id,$f,$s){
$SQLstr = "update h_advertiser set adv_primary_wg_id = $f, adv_secondary_wg_id = $s where adv_id = $id";
$result=MYSQL_QUERY("$SQLstr");
// echo $SQLstr;
}
function upd_wgs($id,$f,$s){
$SQLstr = "update h_url set url_word_group_id = $f, url_word_group_id2 = $s where url_id = $id";
$result=MYSQL_QUERY("$SQLstr");
}
function chg_wg($id){
include "global_wc.inc";
$SQLstr = "update h_word_groups set wg_bg_img = '$wg_bg_img', wg_page_img = '$wg_page_img', wg_logo_img = '$wg_logo_img', wg_keywords= '$wg_keywords' , wg_brands= '$wg_brands' , wg_template= '$wg_template' where wg_id = $id";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
}
function get_wg_info($wg_id){
include "global_cat.inc";
$SQLstr = "select * from h_word where word_id = $wg_id ";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$tdcat = explode($row['word_td_cat_id'],":");
$cat_name = $row['word_word'];
}
function get_cat_info($ct_id){
include "global_cat.inc";
include "global_wc.inc";
$SQLstr = "select * from h_word, h_wg_words where wgw_id = $ct_id and word_id = wgw_word_id ";
$result=MYSQL_QUERY("$SQLstr");
if ($result){
get_wg($ct_id);
$row = mysql_fetch_array($result);
$cat_name = $row['word_word'];
$cat_disp = $row['word_text'];
$cat_word_id = $row['wgw_word_id'];
if ($cat_disp != ""){
$cat_name = $cat_disp;
} else {
$cat_name= ucfirst(trim(str_replace($odds,"",$row['word_word'])));
}
$cat_id= $row['wgw_id'];
$wgid = $row['wgw_wg_id'];
$cat_tdcat = explode(":",$row['word_td_cat_id']);
}
// get parent info
if ($wgid > 0){
$SQLstr = "select * from h_word, h_wg_words where word_id = $wgid and wgw_wg_id = $wgid and wgw_word_id = $wgid";
$result=MYSQL_QUERY("$SQLstr");
$row = mysql_fetch_array($result);
$cat_par_id= $row['wgw_id'];
$cat_par_name= ucfirst($row['word_word']);
$cat_tdcat = explode(":",$row['word_td_cat_id']);
}else {
$cat_par_id= $cat_id;
$cat_par_name= $cat_name;
}
//echo "cat td ".$cat_tdcat[0].$cat_tdcat[1];
}
function move_par_cat($catid,$parid,$type){
$SQLstr = "update h_category set cat_par_id = '$parid' , cat_type = '$type' where cat_id = $catid";
$result=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
}
function rename_cat($catid,$nm,$pr,$kw){
$SQLstr = "update h_category set cat_name = '$nm',cat_priority = '$pr' ,cat_keywords = '$kw' where cat_id = $catid";
$result=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
}
function add_sub_cat($nm,$par_id,$type){
$SQLstr = "insert into h_category (cat_par_id,cat_type,cat_name,cat_source_type) values (";
//gotcha//
$SQLstr .= "'$par_id','$type','$nm','67')";
$result=MYSQL_QUERY("$SQLstr");
//gotcha//
$SQLstr = "select * from h_category where cat_par_id = '$par_id' and cat_type = '$type' and cat_name ='$nm' and cat_source_type=67";
$result=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
$row = mysql_fetch_array($result);
//gotcha//
$SQLstr = "update h_category set cat_source_id = '".$row['cat_id']."' where cat_par_id = '$par_id' and cat_type = '$type' and cat_name ='$nm' and cat_source_type=67";
$result=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
}
function get_template($tmp_id){
include "global_template.inc";
if ($tmp_id == '') {
$tmp_id = 0;
}
$SQLstr = "select * from h_template where template_id = '$tmp_id'";
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_template($row);
return true;
} else {
return false;
}
}
function load_template($row) {
include "global_template.inc";
$temp_name = $row['template_name'];
$temp_id = $row['template_id'];
$temp_file = $row['template_file'];
$temp_page_file = $row['template_page_file'];
$temp_contact = $row['template_contact'];
$temp_css = $row['template_css'];
$temp_version = $row['template_version'];
$temp_page_type = $row['template_def_page'];
$temp_listing = $row['template_listing'];
$temp_advert = $row['template_advert'];
$temp_logos = $row['template_logos'];
$temp_menu = $row['template_menu'];
$temp_prod = $row['template_prod'];
$temp_static = $row['template_static'];
$temp_shop = $row['template_shop'];
$temp_pub_prod = $row['template_pub_prod'];
$temp_pub_prod2 = $row['template_pub_prod2'];
$temp_pub_prod_extra = $row['template_pub_prod_extra'];
$temp_max_ads = $row['template_max_ads'];
$temp_max_cat_ads = $row['template_max_cat_ads'];
$temp_max_prods = $row['template_max_prods'];
$temp_content_format= $row['template_content_format'];
$temp_max_pic_width = $row['template_max_pic_width'];
$temp_extra_pages = $row['template_extra_pages'];
$temp_extra_files = $row['template_extra_files'];
$temp_extension = $row['template_extension'];
$temp_directories = $row['template_directories'];
$temp_background = $row['template_background'];
$temp_logo = $row['template_logo'];
$temp_aboutus = $row['template_aboutus'];
$temp_robots = $row['template_robots'];
$temp_privacy = $row['template_privacy'];
$temp_pub_searches= $row['template_searches'];
$temp_searchbox= $row['template_searchbox'];
// $temp_rec_searches= $row['template_recsearch'];
//echo "temp $temp_background ";
}
function get_page($id){
include "global_page.inc";
if ($page_id == '') {
$page_id = 0;
}
$SQLstr = "select * from h_page where page_id = '$id'";
//echo $SQLstr;
$result=MYSQL_QUERY("$SQLstr");
if ($result) {
$row = mysql_fetch_array($result);
load_page($row);
return true;
} else {
return false;
}
}
function load_page($row) {
include "global_page.inc";
include "global_template.inc";
include "global_url.inc";
get_template($template);
$page_id = $row['page_id'];
$page_name = $row['page_name'];
$page_title = ucfirst($row['page_title']);
$page_meta_desc = $row['page_meta_desc'];
$page_meta_keywords = $row['page_meta_keywords'];
$page_template = $row['page_template'];
$page_template = $temp_content_format;
$page_type = $row['page_type'];
$page_strap = ucfirst($row['page_strap']);
$page_format = $row['page_format'];
$page_thumb = $row['page_thumb'];
$page_intro = $row['page_intro'];
//echo "$page_id: $page_format $page_template = $temp_content_format;";
$page_section_1 = html_entity_decode($row['page_section_1']);
$page_section_2 = html_entity_decode($row['page_section_2']);
$page_section_3 = html_entity_decode($row['page_section_3']);
$page_section_4 = html_entity_decode($row['page_section_4']);
$page_section_5 = html_entity_decode($row['page_section_5']);
$page_type_1 = $row['page_type_1'];
$page_type_2 = $row['page_type_2'];
$page_type_3 = $row['page_type_3'];
$page_type_4 = $row['page_type_4'];
$page_type_5 = $row['page_type_5'];
$page_base = $row['page_base'];
$page_priority = $row['page_priority'];
$page_visible = $row['page_visible'];
$page_adv_keywords = $row['page_adv_keywords'];
$page_prod_keywords = $row['page_prod_keywords'];
$page_pub_keywords = $row['page_pub_keywords'];
$page_singular = ucfirst($row['page_singular']);
$page_plural = ucfirst($row['page_plural']);
$page_menu = ucfirst($row['page_menu']);
$page_filename = strtolower($row['page_filename']);
$page_wordgroup = $row['page_wordgroup'];
if ($page_wordgroup > 0) {
$page_wordgroup2 = $row['page_wordgroup_2'];
$wgs[0] = $page_wordgroup;
$wgs[1] = $page_wordgroup2;
} else {
//echo "page strap $page_strap;";
$SQLstr ="select * from h_links,h_url where link_type = 'upg' and link_secondary_id = $page_id and url_id=link_primary_id";
$result=MYSQL_QUERY("$SQLstr");
if ($result){
$row2 = mysql_fetch_array($result);
$url_id = $row2['link_primary_id'];
if ($url_id > 0){
// echo "before $page_adv_keywords";
// if ($page_adv_keywords == "" || $page_adv_keywords == EMPTYKW){
$page_adv_keywords= $row2['url_adv_keywords'];
$wgs[0] = $row2['url_word_group_id'];
$wgs[1] = $row2['url_word_group_id2'];
// }
$page_wordgroup = $row2['url_word_group_id'];
$page_wordgroup2 = $row2['url_word_group_id2'];
}
}
}
process_keywords($page_adv_keywords,$page_id,$wgs,"wcp");
// echo "
after$page_adv_keywords"; } function get_url($url_id){ include "global_url.inc"; $SQLstr = "select * from h_url where url_id = '$url_id'"; $result=MYSQL_QUERY("$SQLstr"); if ($result) { $row = mysql_fetch_array($result); load_url($row); return true; } else { return false; } } function load_url($row) { include "global_url.inc"; global $types; $uid = $row['url_id']; $nm = treat($row['url_name']); $title = ucfirst(treat($row['url_title'])); $ug_id = $row['url_ug_id']; $url_status= $row['url_status']; $subtitle = ucfirst(treat($row['url_subtitle'])); $css = $row['url_css']; $word_group= $row['url_word_group_id']; $word_group2= $row['url_word_group_id2']; $dir = $row['url_dir']; $advct = $row['url_adv_count']; $html = $row['url_html']; $links = $row['url_links']; $dir = $row['url_dir']; $url_directories = $row['url_directories']; $head = $row['url_head']; $head_inserts = treat($row['url_head_inserts']); $foot = $row['url_foot']; $root = $row['url_root']; $keywords = treat($row['url_keywords']); $verify = treat($row['url_verify']); $prod_keywords = treat($row['url_prod_keywords']); $tdurl = $row['url_td_id']; $adv_keywords = treat($row['url_adv_keywords']); $pub_keywords = treat($row['url_pub_keywords']); $brand_keywords = treat($row['url_brand_keywords']); $desc = treat($row['url_description']); $page = $row['url_content_page']; $domain = strtolower($row['url_domain']); $reldt= $row['url_rel_dt']; if (strpos($domain,"www") ===false){ $domain = "www.".$domain; } $type = $row['url_type']; if ($types[$type]['alpha1'] == "showpages"){ $showpages = "ON"; } $template = $row['url_template']; $big_logo = $row['url_big_logo']; $small_logo = $row['url_small_logo']; $visible = $row['url_visible']; $insert1 = $row['url_insert1']; $insert2 = $row['url_insert2']; $insert3 = $row['url_insert3']; $insert4 = $row['url_insert4']; $insert5 = $row['url_insert5']; $insert6 = $row['url_insert6']; $insert7 = $row['url_insert7']; $insert8 = $row['url_insert8']; $insert9 = $row['url_insert9']; $insert10 = $row['url_insert10']; $ref1 = $row['url_ref1']; $ref2 = $row['url_ref2']; $ref3 = $row['url_ref3']; $ref4 = $row['url_ref4']; $ref5 = $row['url_ref5']; $columns = $row['url_columns']; } function upd_url_banner($url_id,$filename){ $SQLstr = "update h_url set url_big_logo='$filename' where url_id = $url_id "; //echo $SQLstr; $result=MYSQL_QUERY("$SQLstr"); if ($result) { // echo "Domain Updated"; } else { echo "Domain Update Failed"; return false; } } function upd_url_field($url_id,$field,$val){ $SQLstr = "update h_url set url_$field='$val' where url_id = $url_id "; //echo $SQLstr; $result=MYSQL_QUERY("$SQLstr"); if ($result) { // echo "Domain Updated"; } else { echo "Domain Update Failed"; return false; } } function upd_url($url_id){ $SQLstr = "update h_url set url_name='".$_POST['nm']."', url_title='".sq($_POST['title'])."', url_subtitle='".sq($_POST['subtitle'])."', url_css='".$_POST['css']."', url_dir='".$_POST['dir']."', url_directories='".$_POST['directories']."', url_keywords='".sq($_POST['keywords'])."', url_description='".sq($_POST['desc'])."',"; $SQLstr .= " url_content_page='".$_POST['page']."', url_domain='".$_POST['domain']."', url_type='".$_POST['type']."', url_visible='".$_POST['visible']."', url_td_id='".$_POST['tdurl']."', url_verify='".sq($_POST['verify'])."', "; $SQLstr .= " url_insert1='".$_POST['insert1']."', url_insert2='".$_POST['insert2']."', url_insert3='".$_POST['insert3']."', url_insert4='".$_POST['insert4']."', url_pub_keywords='".sq($_POST['pub_keywords'])."', "; $SQLstr .= " url_ref1='".$_POST['ref1']."', url_ref2='".$_POST['ref2']."', url_ref3='".$_POST['ref3']."', url_ref4='".$_POST['ref4']."', url_ref5='".$_POST['ref5']."', "; $SQLstr .= " url_insert5='".$_POST['insert5']."', url_insert6='".$_POST['insert6']."', url_insert7='".$_POST['insert7']."', url_insert8='".$_POST['insert8']."', "; $SQLstr .= " url_insert9='".$_POST['insert9']."', url_insert10='".$_POST['insert10']."', url_columns='".$_POST['columns']."', url_prod_keywords='".sq($_POST['prod_keywords'])."', "; $SQLstr .= " url_big_logo='".$_POST['big_logo']."', url_small_logo='".$_POST['small_logo']."', url_template='".$_POST['template']."', url_root='".$_POST['root']."', url_status='".$_POST['status']."', "; $SQLstr .= " url_word_group_id='".$_POST['word_group']."' , url_word_group_id2='".$_POST['word_group2']."', url_adv_keywords='".sq($_POST['adv_keywords'])."', url_brand_keywords='".sq($_POST['brand_keywords'])."', "; $SQLstr .= " url_ug_id = '".$_POST['ug_id']."', url_head_inserts= '".$_POST['head_inserts']."' where url_id = $url_id "; //echo $SQLstr; $result=MYSQL_QUERY("$SQLstr"); if ($result) { // echo "Domain Updated"; } else { echo "Domain Update Failed"; return false; } $kw = $_POST['adv_keywords']; $wgs[0] = $_POST['word_group']; $wgs[1] = $_POST['word_group2']; process_keywords($kw,$url_id,$wgs,"wc2"); $SQLstr = "select * from h_page, h_links where page_id = link_secondary_id and link_primary_id = '$url_id' and link_type = 'upg' and page_priority = '0'"; $result=MYSQL_QUERY("$SQLstr"); $row = mysql_fetch_array($result); $page_id = $row["page_id"]; $page_kw = $row["page_adv_keywords"]; if ($page_id > 0 && ($page_kw == "" || $page_kw == EMPTYKW)){ process_keywords($kw,$page_id,$wgs,"wcp"); } return true; } function add_url(){ include "global_url.inc"; $nm = $nm."(clone)"; $SQLstr = "insert into h_url (url_name) values('$nm')"; $result=MYSQL_QUERY("$SQLstr"); $SQLstr = "select * from h_url where url_name = '$nm'"; $result=MYSQL_QUERY("$SQLstr"); $row = mysql_fetch_array($result); return $row["url_id"]; } function write_file($f,$c) { global $actions; $somecontent = "Add this to the file\n"; if (!$handle = fopen($f, 'w')) { $actions .= "\nCannot open file ($filename)"; exit; } if (fwrite($handle, $c) === FALSE) { $actions .= "\nCannot write to file ($f)"; exit; } $actions .= "\nSuccess, file updated ($f)"; fclose($handle); } function dateDiff($dformat, $endDate, $beginDate){ if ($endDate!= "" && $beginDate != ""){ $date_parts1=explode($dformat, $beginDate); $date_parts2=explode($dformat, $endDate); $start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]); $end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]); return $end_date - $start_date; } else { return 0; } } function microtime_float() { list($usec, $sec) = explode(" ", microtime()); return ((float)$usec + (float)$sec); } function bold($s){ return "$s"; } function italic($s){ return "$s"; } function underline($s){ return "$s"; } function type_list($nm,$typ,$val){ $SQLstr = "select t.* from h_type t left join h_type pt on t.type_type = pt.type_id where pt.type_code ='$typ' order by t.type_show_order"; // echo "$val ".$SQLstr; $str = "