Return to links.php CVS log

Up to [mozdev] / kcms / src

*** empty log message ***

<?php
/*
+---------------------------------------------------------------+
|        kCMS 0.1.5
|        /links.php
|
|        kCMS.Kanaco.Com
|        optiK@kcms.kanaco.com
|
|        
|        
+---------------------------------------------------------------+
*/
require_once("set.php");

require_once(HEADERF);

if(IsSet($_POST['add_link']) && check_class($pref['link_submit_class'])){
        if($_POST['link_name'] && $_POST['link_url'] && $_POST['link_description']){
                $link_name = $aj -> formtpa($_POST['link_name'], "public");
                $link_url = $aj -> formtpa($_POST['link_url'], "public");
                $link_description = $aj -> formtpa($_POST['link_description'], "public");
                $link_button = $aj -> formtpa($_POST['link_button'], "public");
                $username = (defined('USERNAME')) ? USERNAME : LAN_LINKS_3;
                $submitted_link = $_POST['cat_name']."^".$link_name."^".$link_url."^".$link_description."^".$link_button."^".$username;
                $sql -> db_Insert("tmp", "'submitted_link', '".time()."', '$submitted_link' ");
                $ns -> tablerender(LAN_99, "<div style='text-align:center'>".LAN_100."</div>");
        }else{
                message_handler("ALERT", 5);
        }
}

if(e_QUERY == "submit" && check_class($pref['link_submit_class'])){

        if(!$LINK_SUBMIT_TABLE){
            if(file_exists(THEME."links_template.php")){
              require_once(THEME."links_template.php");
            }
          	else{
              require_once(e_BASE.$THEMES_DIRECTORY."templates/links_template.php");
            }
        }

        $link_submit_table_string .= parse_link_submit_table();

        $link_submit_table_start = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_SUBMIT_TABLE_START);
        $link_submit_table_end = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_SUBMIT_TABLE_END);
        $text .= $link_submit_table_start.$link_submit_table_string.$link_submit_table_end;

        $ns -> tablerender(LAN_92, $text);
        require_once(FOOTERF);
        exit;
}


if(e_QUERY == "" && $pref['linkpage_categories'] == 1){

        if(!$LINK_MAIN_TABLE){
           if(file_exists(THEME."links_template.php")){
              require_once(THEME."links_template.php");
            }
          	else{
              require_once(e_BASE.$THEMES_DIRECTORY."templates/links_template.php");
            }
        }

        $caption = LAN_61;
        $sql = new db; $sql2 = new db;
        $category_total = $sql -> db_Select("link_category", "*", "link_category_id != '1' ");
        $total_links = $sql2 -> db_Count("links", "(*)", "WHERE link_category!=1");

        while($row = $sql-> db_Fetch()){
        extract($row);

                $link_main_table_string .= parse_link_main_table($row);

        }
        $link_main_table_start = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_MAIN_TABLE_START);

        $LINK_MAIN_TOTAL = LAN_102." ".($total_links == 1 ? LAN_103 : LAN_104)." ".$total_links." ".($total_links == 1 ? LAN_65 : LAN_66)." ".LAN_105." ".$category_total." ".($category_total == 1 ? LAN_63 : LAN_62);
        $LINK_MAIN_SHOWALL = "<a href='".e_BASE."links.php?cat.all'>".LAN_67."</a>";

        $link_main_table_end = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_MAIN_TABLE_END);

        $text .= $link_main_table_start.$link_main_table_string.$link_main_table_end;

        $ns -> tablerender($caption, $text);

}else{

        $id = e_QUERY;
        $qs=explode(".",e_QUERY);
        if($qs[0] == "cat"){
                $category = $qs[1];
                unset($id);
        } elseif($qs[1] == "cat"){
                $category = $qs[2];
                $id=$qs[0];
        }

        if(isset($id)){
                $id = $qs[0];
                if($id){
                        $sql -> db_Update("links", "link_refer=link_refer+1 WHERE link_id='$id' ");
                        $sql -> db_Select("links", "*", "link_id='$id AND link_class!=255' ");
                        $row = $sql -> db_Fetch(); extract($row);
                                header("location:".$link_url);

                }
                $sql -> db_Select("link_category", "*", "link_category_id != '1' ");
        }
        if($category){
                if($category == "all"){
                        $sql -> db_Select("link_category", "*", "link_category_id != '1' ");
                }else{
                        $sql -> db_Select("link_category", "*", "link_category_id='$category'");
                }
        }

        if(!$LINK_CAT_TABLE){
           if(file_exists(THEME."links_template.php")){
              require_once(THEME."links_template.php");
            }
          	else{
              require_once(e_BASE.$THEMES_DIRECTORY."templates/links_template.php");
            }
        }

        $sql2 = new db;
        while(list($link_category_id, $link_category_name, $link_category_description) = $sql-> db_Fetch()){
                if($link_total = $sql2 -> db_Select("links", "*", "link_category ='$link_category_id' ORDER BY link_order ")){
                        unset($text, $link_cat_table_string);
                        $link_activ = 0;
                        while($row = $sql2-> db_Fetch()){
                                extract($row);
                                if(!$link_class || check_class($link_class)){
                                        $link_activ++;

                                        // Caption
                                        $caption = LAN_86." ".$link_category_name;
                                        if($link_category_description != ""){
                                                $caption .= " <i>[".$link_category_description."]</i>";
                                        }
                                        // Number of links displayed
                                        $caption .= " (<b title='".(ADMIN ? LAN_Links_2 : LAN_Links_1)."' >".$link_activ."</b>".(ADMIN ? "/<b title='".(ADMIN ? LAN_Links_1 : "" )."' >".$link_total."</b>" : "").") ";

                                        $link_cat_table_string .= parse_link_cat_table($row);

                                }
                        }
                        if($pref['link_submit'] && check_class($pref['link_submit_class'])){
                                $LINK_CAT_SUBMIT = "<a href='".e_SELF."?submit'>".LAN_101."</a>";
                        }

                        if($link_activ > 0){
                                $link_cat_table_start = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_CAT_TABLE_START);
                                $link_cat_table_end = preg_replace("/\{(.*?)\}/e", '$\1', $LINK_CAT_TABLE_END);
                                $text .= $link_cat_table_start.$link_cat_table_string.$link_cat_table_end;
                                $ns -> tablerender($caption, $text);
                        }
                        $link_activ = 0;
                }
        }
}

require_once(FOOTERF);



function parse_link_main_table($row){
                global $LINK_MAIN_TABLE, $sql;
                extract($row);

                $sql2 = new db;
                $total_links_cat = $sql2 -> db_Count("links", "(*)", " WHERE link_category=$link_category_id ");
                $LINK_MAIN_ICON = ($link_category_icon ? "<img src='".e_IMAGE."link_icons/$link_category_icon' alt='' style='vertical-align:middle;' />" : "<img src='".THEME."images/bullet2.gif' alt='' style='vertical-align:middle;' />");
                $LINK_MAIN_HEADING = (!$total_links_cat ? $link_category_name : "<a href='links.php?cat.".$link_category_id."'>".$link_category_name."</a>");
                $LINK_MAIN_DESC = $link_category_description;
                $LINK_MAIN_NUMBER = $total_links_cat." ".($total_links_cat == 1 ? LAN_65 : LAN_66)." ".LAN_64;

                return(preg_replace("/\{(.*?)\}/e", '$\1', $LINK_MAIN_TABLE));
}

function parse_link_submit_table(){
                global $LINK_SUBMIT_TABLE;

                $sql = new db;
                if($link_cats = $sql -> db_Select("link_category")){
                        $LINK_SUBMIT_CAT = "<select name='cat_name' class='tbox'>";
                                while(list($cat_id, $cat_name, $cat_description) = $sql-> db_Fetch()){
                                        if($cat_name != "Main"){
                                                $LINK_SUBMIT_CAT .= "<option value='$cat_id'>".$cat_name."</option>\n";
                                        }
                                }
                        $LINK_SUBMIT_CAT .= "</select>";
                }

                return(preg_replace("/\{(.*?)\}/e", '$\1', $LINK_SUBMIT_TABLE));
}

function parse_link_cat_table($row){
                global $LINK_CAT_TABLE, $sql, $pref, $aj, $category;
                extract($row);

                // Body
                if(isset($category)){
                        $link_append = "<a href='".e_SELF."?".$link_id.".cat.{$category}'>";
                } else {

                        switch ($link_open) {
                        case 1:
                                $link_append = "<a href='".e_SELF."?".$link_id."' rel='external'>";
                        break;
                        case 2:
                                $link_append = "<a href='".e_SELF."?".$link_id."'>";
                        break;
                        case 3:
                                $link_append = "<a href='".e_SELF."?".$link_id."'>";
                        break;
                        case 4:
                                $link_append = "<a href=\"javascript:open_window('".e_SELF."?".$link_id."')\">";
                        break;
                        default:
                                $link_append = "<a href='".e_SELF."?".$link_id."'>";
                        }

                }

                if($link_button){
                        $LINK_CAT_BUTTON = (strstr($link_button, "/") ? $link_append."\n<img style='border:0;' src='".$link_button."' alt='".$link_name."' /></a>" : $link_append."\n<img style='border:0' src='".e_IMAGE."link_icons/".$link_button."' alt='".$link_name."' /></a>");
                }else{
                        $LINK_CAT_BUTTON = $link_append."\n<img style='border:0;' src='".e_IMAGE."generic/blankbutton.png' alt='".$link_name."' /></a>";
                }
                $LINK_CAT_APPEND = $link_append;
                $LINK_CAT_NAME = $link_name;
                $LINK_CAT_URL = $link_url;
                $LINK_CAT_DESC = $aj -> tpa($link_description);
                $LINK_CAT_REFER = LAN_88." ".$link_refer;

                return(preg_replace("/\{(.*?)\}/e", '$\1', $LINK_CAT_TABLE));

}
?>