PHP Classes
Icontem

File: paint_bot.php


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Colin Sandy Pittendrigh  >  Site Bot  >  paint_bot.php  
File: paint_bot.php
Role: Class source
Content type: text/plain
Description: pages, static or dynamic
Class: Site Bot
Recursive-automic site buider: static OR dynamic
 

Contents

Class file image Download
<?php 
require_once "database.php";
require_once "page_config.inc";
require_once "database_config.inc";
require_once "copy_bot.php";
require_once "utils.php";

class pittpage
{
var $pp_menuwidth = "20%";

var $pp_dir_name;
var $pp_dir_id;
var $pp_parent_dir_id;
var $pp_filename;
var $pp_filename_nav;
var $pp_filename_disp;
var $pp_static_link;
var $pp_link_cnt;

var $pp_dynamic_link;
var $pp_url;
var $pp_url_nav;
var $pp_url_disp;

var $pp_printmode=0;
var $pp_show_navigation=0;
var $pp_phpself;

var $pp_dconn;
var $pp_document_root;
var $pp_filepath_to_output;
var $pp_page_title;
var $pp_page_type;
var $pp_layout;

var $pp_links = Array();
var $pp_link_comments = Array();
var $pp_global_links = Array();
var $pp_isGlobalKey = Array();

var $pp_target_types = Array();
var $pp_link_targets = Array();
var $pp_link_labels = Array();

var $pp_keywords_str = '';
var $pp_home_link = '';
var $pp_global_links_title = '';
var $pp_css_file_url = '';

var $pp_fp;


function pittpage($page_id, $mode)
{
global $sys_printmode, $sys_document_root, $sys_filepath_to_source, $sys_filepath_to_output;
global $sys_css_file_url, $sys_home_link, $sys_global_links_title, $sys_this_dir_path;

$this->pp_printmode=$sys_printmode;
$this->pp_document_root=$sys_document_root;
$this->pp_filepath_to_output = $sys_filepath_to_output;
$this->pp_css_file_url = $sys_css_file_url;
$this->pp_home_link = $sys_home_link;
$this->pp_global_links_title = $sys_global_links_title;

$this->main($page_id, $mode);
}

function  pprint($msg)
{
  $mmsg = $msg . "\n";

  if($this->pp_printmode > 0)
  {
    if(isset($this->pp_fp))
    fwrite($this->pp_fp, $mmsg);
    else
    {
      dbg( "no this pp_fp to print to");
      exit;
    }
  }
        else
    {
      echo "$mmsg";
    }
  }
  
  function getLinks()
  {
    $link_cnt = 0;
    /*
    if in dynamic mode, row['link'] is correct,
    else it's tricky, because of subdirectory links
    */
    $query =
    "select *
      from s_page, s_dir, s_link_list
      where s_dir.dir_id = s_link_list.dir_id
      and s_link_list.dir_id=$this->pp_dir_id 
            and s_link_list.page_id = s_page.page_id
            order by s_page.page_title";
    $lstmt = dbr_query($query);
    
    $kwflag=0;
    if(isset($lstmt) && mysql_numrows($lstmt) > 0)
    {
      while($row = mysql_fetch_array ($lstmt))
      {
        if(!$kwflag)
        {
            $kwflag++;
            $this->pp_keywords_str = $row['keywords_str'];
        }
        $dynamic_link = $row['dynamic_link'];
        $static_link = $row['static_link'];
        $target_type = $row['page_type'];
        $link_comment="";
        if(isset($row['link_comment']))
          $link_comment = $row['link_comment'];
        $label = $row['page_title'];

        if(isset($link_comment))
          $this->pp_link_comments[$label] = $link_comment;

        if($target_type == "url")
           $target = "_top";
        else
           $target = "_top";

        $is_dirpage = $row['is_dirpage'];

        $keyword = dispLabel($label);  
        if(!strstr($keyword,"skip"))  
               $this->pp_keywords_str .= "," . $keyword;
        if(!strstr($label,"skip"))
        {
          if($this->pp_printmode == 0)
          $link = $dynamic_link;
          else
          $link = $static_link;
        
          $this->pp_links[$label] = $link;
          if($is_dirpage != 1)
          $this->pp_target_types[$label] = $target_type;
          else
          $this->pp_target_types[$label] = "dir";
          $this->pp_link_targets[$label] = $target;
          $link_cnt++;
        }
      }
    }
    //echo $this->pp_keywords_str,"<br/>";
    /*
    else
    {
    dbg( "database query error...");
    exit;
    }
    */
  
    if(isset($keywords))  
       $this->pp_keywords_str .= $keywords;
    if(isset($lstmt)) mysql_free_result($lstmt);
    
    $this->pp_link_cnt = $link_cnt;
  }
  
  function mkLink($label)
  {
    $class = "lnkNavClr";
    
    if($this->pp_target_types[$label] == "lbl")
    {
      $tmp = $this->pp_links[$label];
    }
    else
    {
      $displabel = trim(dispLabel($label));
      if($this->pp_target_types[$label] == "dir")
      {
             $class = "lnkDirClr";
      }
      $tmp = "<a class=".$class." href=\"" . $this->pp_links[$label] . "\"";
      $tmp .= " target=\"".$this->pp_link_targets[$label]."\"> ";
      
      $tmp .= "<b>";
      //if($this->pp_target_types[$label] == "url")
       // $tmp .= $displabel . " url ";
      //else
        $tmp .= $displabel;
      
      $dbg = $label . ", " . $this->pp_links[$label] . ", " . $this->pp_target_types[$label];
      $tmp .= "</b></a>";
    }
    
    return $tmp;
  }
  
  function tmpLabel($str)
  {
    $tmpLabel = basename($str);
    $tmpLabel = ereg_replace ("\..*$", "", $tmpLabel);
    $tmpLabel = ereg_replace ("^.+-", " ", $tmpLabel);
    return($tmpLabel);
  }
  
  function getSuffix($str)
  {
    $tmp = basename($str);
    $tmpSuffix = ereg_replace ("^.*\.", "", $tmp);
    return($tmpSuffix);
  }
  
  
  
  function getLabel ($str)
  {
    $label = $this->tmpLabel($str);
    $label = ereg_replace("_", " " , $label);
    return ($label);
  }


   function getUpHref($dir_id)
   {
     $href=null;
    if($dir_id > 0)
    {
      $sql = "select * from s_page, s_dir, s_link_list
                        where s_dir.dir_id=$dir_id
                        and s_dir.dir_id = s_link_list.dir_id
                        and s_page.page_id = s_link_list.page_id
                        and s_page.dir_id = s_dir.dir_id
                        and s_page.is_dirpage=1";
    
      $stmt = dbr_query($sql);
      $row = dbr_fetch_array($stmt);
      $static_link = $row['static_link'];
        
      $page_id = $row['page_id'];
                        $title = $row['page_title'];
      //if(isset($stmt)) mysql_free_result($stmt);
    
      if($this->pp_printmode > 0 && isset($static_link))
         $href = $static_link;
      elseif(isset($page_id))
         $href = sprintf("%s/paint.php?page_id=%d target=\"_top\"", $_SERVER['PHP_SELF'], $page_id);

                  }
      return $href;
   }
  
   // usually $this->pp_dir_id... 
   function getUpLink($dir_id) 
   {
    $up_link = "";
    if($dir_id > 0)
    {
      $sql = "select * from s_page, s_dir, s_link_list
                        where s_dir.dir_id=$dir_id
                        and s_dir.dir_id = s_link_list.dir_id
                        and s_page.page_id = s_link_list.page_id
                        and s_page.dir_id = s_dir.dir_id
                        and s_page.is_dirpage=1";

      $stmt = dbr_query($sql);
      $row = dbr_fetch_array($stmt);
      $static_link = $row['static_link'];

      $page_id = $row['page_id'];
         $title = $row['page_title'];
      //if(isset($stmt)) mysql_free_result($stmt);

      if($this->pp_printmode > 0)
         $up = $static_link;
      else
         $up = sprintf("%s/paint.php?page_id=%d target=\"_top\"", $_SERVER['PHP_SELF'], $page_id);
      $up_link .= "<a class=\"lnkNavClr\" href=\"".$up."\" target=\"_top\"><b>".dispLabel($title)."</b></a>";
    }
     return($up_link);

   }

   function getParentId($dir_id)
   {
      $sql = "select parent_id from s_dir where dir_id='$dir_id'";
      $stmt = dbr_query($sql);
      $row = dbr_fetch_row($stmt);
      $parent_id=$row[0];
      return($parent_id);
   }

   function getPath()
   {
      $paths=Array();
      $parent_dir_id = $this->pp_dir_id;
      $dd="";
      while($parent_dir_id > 0)
      {
          $uplink = $this->getUpLink($parent_dir_id);
          if(isset($uplink))
                $paths[]=$uplink;
          $parent_dir_id = $this->getParentId($parent_dir_id);
      }
      $cnt = count($paths);
      $indent = " &nbsp; ";
      for($i=$cnt; $i>1; $i--)
      {
        $d = $paths[$i-1];
        $dd .= $indent . $d . "<br>";
        $indent .= " &nbsp; ";
      }
      return($dd);
   }


   function mkVerticalLinksArea()
    {
    $this->pprint ("<p class=\"scroll\"><table cellpadding=\"2\" cellspacing=\"2\" border=\"0\"><tr><td valign=\"middle\">");
    $this->pprint ("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">");
    $path = $this->getPath();
    if(isset($path) && $path !="" && $this->pp_show_navigation)
    {
     $this->pprint("<tr><td><h3>Navigation</h3></td></tr>");  
     $this->pprint("<tr><td>$path</td></tr>");
    }
    $title = $this->getLabel($this->pp_dir_name);
    ksort($this->pp_links);
    $lclstatus=0;
    while(list($key, $dontcare)=each($this->pp_links))
    {
      if($key != $this->pp_dir_name)
      {
       if($lclstatus==0)
       { 
    $this->pprint("<tr><td> <h3> $title </h3> </td></tr>");
          $lclstatus++;
       }
       $link = $this->mkLink($key);
       $link_comment = $this->pp_link_comments[$key];

       $dootoo=1;
       if(isset($this->pp_isGlobalKey[$key]) && $this->pp_isGlobalKey[$key]==1)
       {
           $dootoo = 0;
       }
       if($dootoo == 1)
           $this->pprint("<tr><td>&nbsp;".$link);

       if(isset($link_comment))
           $this->pprint($link_comment);

       $this->pprint("</td></tr>");
       }  
    }    
    
    $uplink = "";
    $tmp = null;
    if($this->pp_parent_dir_id > 0)
          $tmp = $this->getUpHref($this->pp_parent_dir_id);
    if(isset($tmp) && $this->pp_parent_dir_id > 0)
    {
       $uplink = sprintf("<a class=lnkNavClrBig href=\"%s\"><b>Up</b></a>",$tmp);
    }
    if(!isset($home_link))
        $home_link = "";
    if(isset($uplink) && ($home_link != $uplink))
    {
        $this->pprint("<tr><td>".$uplink."</td></tr>");
    }
    else
    {
        $this->pprint("<tr><td><b>Top</b></td></tr>");
    }

    $this->pprint("<tr><td> &nbsp; </td></tr>");
    $this->pprint("<tr><td>
<script type=\"text/javascript\"><!--
google_ad_client = \"pub-9963550438549427\";
google_ad_width = 120;
google_ad_height = 240;
google_ad_format = \"120x240_as\";
google_ad_type = \"text\";
google_ad_channel =\"\";
//--></script>
<script type=\"text/javascript\"
  src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">
</script>
    </td></tr>");
    $this->pprint("</table></td></tr></table>");
  }

  function mkLeftFrame()
  {
    $this->pprint("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
    $this->pprint("<html>");
    $this->mkHeader();
    $this->pprint("<body>");
    $this->pprint("<table class=fullWidthHeight cellpadding=\"0\" cellspacing=\"0\" border=\"0\">");
    $this->pprint("<tr valign=\"center\"><td>");
    $this->mkVerticalLinksArea();
    $this->pprint("</tr></table></body></html>");
  }
  
  function mkRightFrame()
  {
    if($this->pp_page_type == 'furl')
    {
      header("Location: $this->pp_url_disp");
    }
    //elseif($this->pp_page_type == 'html') { $this->mkHtmlArea(); }
    else
    {
      $this->pprint("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
      $this->pprint("<html>");
      $this->mkHeader();
      $this->pprint("<body>");
      
      $this->pprint ("<table class=fullWidthHeight cellpadding=\"0\" cellspacing=\"0\" border=\"0\">");
      $this->pprint ("<tr><td class=fullWidthHeight> &nbsp; &nbsp; </td> <td>");
      
      //if($this->pp_page_type == 'html') { $this->mkHtmlArea(); }
      
      $this->pprint("</td></tr>");
      $this->pprint("<tr><td align=center><a class=lnkNavClr href=\"http://montana-riverboats.com/SiteBot.html\" target=\"_top\"><font size=\"-1\">pages generated by <i>SiteBot</i></font></a></td></tr>");
      $this->pprint("</table>");
      $this->pprint("</body></html>");
    }
  }
  
  function mkTextArea()
  {
    $query = "select * from s_page, s_textfile, s_textfile_list
                 where '$this->pp_page_id' = s_page.page_id
                 and s_textfile_list.page_id = '$this->pp_page_id'
                 and s_textfile.textfile_id = s_textfile_list.textfile_id";
    
    $stmt = dbr_query($query);
    
    $row = mysql_fetch_array ($stmt);
    $srcfile = $row['srcfile'];
    $title = $row['page_title'];
    $static_link = $row['static_link'];
    if(isset($stmt)) mysql_free_result($stmt);
  
    if(file_exists($srcfile))
    {
      $this->pprint("<table class=fullWidthHeight border=\"0\" cellspacing=\"0\" cellpadding=12><tr><td>");
      $lines = Array();
      $lines = file($srcfile);
      $lcnt = count($lines);
      for($i=0; $i<$lcnt; $i++)
      {
        $this->pprint("$lines[$i]");
        if(!eregi("<br>=========",$lines[$i]))
        $this->pprint("<br>");
      }
    }
    
    $this->pprint("</td></tr></table>");
  }
  
  function mkHtmlFragmentArea()
  {
    $query = "select  *
                 from s_htmlfragment, s_htmlfragment_list , s_page
                 where 
                 s_page.page_id = '$this->pp_page_id'
                 and s_htmlfragment.htmlfragment_id = s_htmlfragment_list.htmlfragment_id
                 and s_htmlfragment_list.page_id = '$this->pp_page_id'";
    
    //echo "$query<br>";
    $stmt = dbr_query($query);
    
    $row = mysql_fetch_array ($stmt);
    $htmlfragment_id = $row['htmlfragment_id'];
                
                $srcfile = "";
                if(isset($row['srcfile']))
         $srcfile = $row['srcfile'];
    $page_title = $row['page_title'];
    $static_link = $row['static_link'];
    $base = basename($srcfile);
    if($stmt) 
                  mysql_free_result($stmt);
    
    if(file_exists($srcfile))
    {
      $this->pprint("<table class=fullWidthHeight border=\"0\" cellspacing=\"2\" cellpadding=12><tr><td> &nbsp; </td><td>");
      $lines = Array();
      $lines = file($srcfile);
      $lcnt = count($lines);
      for($i=0; $i<$lcnt; $i++)
      {
        $line = $lines[$i];
        $this->pprint("$line");
      }
    }
    
    $this->pprint("</td><td> &nbsp; </td></tr></table>");
  }
  
  function mkHtmlArea()
  {
    
    $query = "select *
    from s_page, s_htmlfile, s_htmlfile_list
    where s_htmlfile_list.page_id = '$this->pp_page_id'
    and s_htmlfile.htmlfile_id = s_htmlfile_list.htmlfile_id
    and s_page.page_id = s_htmlfile_list.page_id";
    
    //echo "$query<br>";
    $stmt = dbr_query($query);
    
    $row = mysql_fetch_array ($stmt);
    $htmlfile_id = $row['htmlfile_id'];
    $file = $row['file'];
    $page_id = $row['page_id'];
    $page_title = $row['page_title'];
    $srcpath = $row['srcpath'];
    $static_link = $row['static_link'];
    $page_title = $row['page_title'];
    $base = basename($file);
      if($stmt) mysql_free_result($stmt);
    
    $src = $srcpath . $file;
    $tlabel = $page_title . "_disp.html";
    $dest = $this->pp_document_root . dirname($static_link) . "/" .$tlabel;
    if($this->pp_printmode > 0)
    {
    if(file_exists($src))
    {
    $rslt = copy($src, $dest);
    if(!$rslt)
    {
    dbg("did not copy $src to $dest", "purple");
    }
    
    }
    }
    else
    
    if($this->pp_printmode == 0)
    header("Location: $url");
    
  }
  
  function show_caption($caption_file)
  {
                $fcontents = file($caption_file);
        $this->pprint("<table border=\"0\">");
          while (list ($line_num, $line) = each ($fcontents))
          {
            $dline = "<tr><td>" . $line . "</td></tr>";
            $this->pprint($dline);
          }
          $this->pprint("</table>");
  }
  
  function mkImageArea()
  {
    $query = "select * from s_image, s_image_list
                        where s_image_list.page_id = $this->pp_page_id
                        and s_image.image_id = s_image_list.image_id";
    
    //echo "$query<br>";
    $stmt = dbr_query($query);
    
    if(dbr_numrows($stmt) > 0)
    {
      $row = mysql_fetch_array ($stmt);
      $image_id = $row['image_id'];
      $image_filename = $row['filename'];
      $htmlpath = $row['htmlpath'];
      $image_title = $row['image_title'];
      $mime_type = $row['mime_type'];
      $caption_file = $row['caption_file'];
      if($stmt) mysql_free_result($stmt);
    }
    
    if(!isset($image_title))
    {
      $sql = "select max(image_id) from s_image";
      $rslt = dbr_query($sql);
      $row = dbr_fetch_row($rslt);
      $image_id = $row[3];
      
      $sql = "select * from s_image where image_id='$image_id'";
      $rslt = dbr_query($sql);
      $row = dbr_fetch_array($rslt);
      $htmlpath = $row['htmlpath'];
      $image_title = $this->pp_dir_name;
      $mime_type = $row['mime_type'];
                        $caption_file = $row['caption_file'];
    }


                if(stristr($image_title,"skip"))
                     $image_title = $this->pp_dir_name;  
    //$label = $image_title;
    $label = dispLabel($image_title);
    
    //$this->pprint("<table class=fullHeight border=\"0\">");
    $this->pprint("<table border=\"0\">");
  
  
    if(strstr($label,"skip"))
                        $dispLabel = "&nbsp;";
    $this->pprint("<tr><td align=\"left\">$label</td></tr>");
    if(isset($image_id))
       $this->pprint("<tr><td align=\"left\"><img src=\"" . $htmlpath . "\" alt=\"".$label."\" border=0></td></tr>");
    else
       $this->pprint("<tr><td>&nbsp;</td></tr>");
    
    if(isset($caption_file) && $caption_file != "")
    {
       $this->pprint("<tr><td align=\"left\">");
       $this->show_caption($caption_file);
       $this->pprint("</td></tr>");
    }
    
    $this->pprint("</table>");
  }


        function mkGlobalBox()
        {
          $sql = "select * from s_page where is_global=1";
          $stmt = dbr_query($sql);

    $home_link = sprintf("<td align=\"center\"><a class=\"blnkWhiteClr\" href=\"%s\"><b>Home</b></a></td>",$this->pp_home_link);
    $this->pprint ("<table class=\"box\" cellpadding=\"4\" cellspacing=\"4\"><tr>");
    $this->pprint($home_link);
      while($row = mysql_fetch_array ($stmt))
          {
               $tmp = $row['static_link'];
               $label = dispLabel($row['page_title']);
               $key = mkLabel($row['page_title']);
               $link = "<td align=\"center\"><a class=\"blnkWhiteClr\" href=\"".$tmp."\"><b>&nbsp; ". $label."</b></a></td>";
               $this->pprint($link);
               $this->pp_global_links[$key] = $link;
               $this->pp_isGlobalKey[$key] = 1;
          }
    $this->pprint ("</tr></table>");

        }

  
  function mkTwoFixedColumnsPage()
  {
    $this->pprint("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
    $this->pprint("<html>");
    $this->mkHeader();
    $this->pprint("<body>");
                $this->mkGlobalBox();

    $this->pprint("<table class=fullWidthHeight cellpadding=\"0\"");
    $this->pprint(" cellspacing=\"0\" border=\"0\">");
    $this->pprint("
                <tr>
                  <td class=navBkg width=\"" . $this->pp_menuwidth . "\" valign=\"top\">");
    $this->pprint($this->mkVerticalLinksArea());
    
    $this->pprint("   </td>
                  <td class=dispBkg align=center valign=\"top\">");
    
    if($this->pp_page_type == 'std_one_image' || $this->pp_page_type == 'blank')
    {
      $this->pprint( "<table class=fullWidthHeight border=\"0\"><tr><td valign=\"top\" align=\"left\">");
      $this->mkImageArea();
      $this->pprint("</td></tr></table>");
    }
    elseif($this->pp_page_type == 'text')
    $this->mkTextArea();
    
    elseif($this->pp_page_type == 'htm')
    $this->mkHtmlFragmentArea();
    
    
    $this->pprint("</td></tr></table>");
   
    $this->pprint("Keywords: ");  
    $this->pprint($this->pp_keywords_str);  
    $this->pprint("</body></html>");
  }
  
  function mkHeader()
  {
    $this->pprint("<head><title>$this->pp_page_title</title>");
    $this->pprint("<meta name=\"keywords\" content=\"$this->pp_keywords_str\">");
    $this->pprint("<link rel=\"stylesheet\" href=\""   . $this->pp_css_file_url    .   "\" type=\"text/css\">");
    $this->pprint("</head>");
  }
  
  function mkFrameset()
  {
    $this->mkHeader();
    $this->pprint("<html><head><title>Menu</title></head>");
    $this->pprint("<frameset cols=\"".$this->pp_menuwidth.",*\" frameborder=\"0\" border=\"10\" framespacing=\"0\">");
    
    if($this->pp_printmode > 0)
    {
      $msg = "<frame src=\"".$this->pp_url_nav."\" name=leftframe border=\"0\">\n";
      fwrite($this->pp_fp, $msg);
      
      $msg = "<frame src=\"".$this->pp_url_disp. "\" name=rightframe border=\"0\">\n";
      fwrite($this->pp_fp, $msg);
      
      $nav = new pittpage;
      $nav->main($this->pp_page_id, "leftframe");
      $disp = new pittpage;
      $disp->main($this->pp_page_id, "rightframe");
    }
    else
    {
      $this->pprint("<frame src=\"".$_SERVER['PHP_SELF']."?page_id=$this->pp_page_id&mode=leftframe\" name=\"leftframe\" border=\"0\">");
      $this->pprint("<frame src=\"" .  $this->pp_url_disp  .   "\" name=rightframe border=\"0\">");
    }
    
    $this->pprint("<noframes>");
    $this->pprint("NoFrames Processing:");
    $this->mkVerticalLinksArea();
    $this->pprint("</noframes>");
    $this->pprint("</frameset>");
    $this->pprint("</html>");
  }
  
  function mkFileName()
  {
    if( strstr($this->pp_page_type,"url"))
    {
      $ret = $this->pp_static_link;
      if(strstr($this->pp_static_link,"http"))
           $ret = stripHttpStuff($ret);
      if(strstr($ret, "."))
            {
            $ret = stripSuffix($this->pp_static_link);
            }
      $ret .= ".html";
            $ret = substr($ret,1);

    }
    else
    $ret = substr($this->pp_static_link,1);
    return $ret;
  }

        //xxxxxxxxxxxxxx  
  function main($page_id, $mode)
  {
    $this->pp_page_id = $page_id;
    $this->pp_phpself = $_SERVER['PHP_SELF'];
    
    $this->dconn = dbr_connect();
    
           
    if($mode == 'named')
    {
      // outter join including s_furl here, or do s_furl later with an if?
          $query = "select * from s_page, s_dir, s_link_list
                      where s_page.page_title='$page_id'
                      and s_link_list.dir_id = s_dir.dir_id 
                      and s_link_list.page_id = s_page.page_id
                      and s_page.dir_id=s_dir.dir_id";
    }
    else
    {
          $query = "select * from s_page, s_dir, s_link_list
                      where s_page.page_id='$page_id'
                      and s_link_list.dir_id = s_dir.dir_id 
                      and s_link_list.page_id = s_page.page_id
                      and s_page.dir_id=s_dir.dir_id";
    }
    
    $stmt = dbr_query($query);
    
    $row=mysql_fetch_array($stmt);
    if(!isset($row))
    {
      dbg( "null row on $this->pp_conn ... $stmt ... $query","green");
      dbg("bad main query == $query","green");
      exit;
    }
    
    $this->pp_parent_dir_id = $row['parent_id'];
    
    $this->pp_dir_id = $row['dir_id'];
    $this->pp_dir_name = $row['title'];
    
    $this->pp_page_title = mkLabel($row['page_title']);
    
    $this->pp_layout = $row['layout'];
    $this->pp_static_link = $row['static_link'];
    $this->pp_dynamic_link = $row['dynamic_link'];
    
    $pt = $row['page_type'];
    $this->pp_page_type = $pt;
      if($stmt) mysql_free_result($stmt);
    
    if($pt == "text" || $pt=="htm" || $pt=="std_one_image" || $pt=="furl" || $pt =="iframe")
    {
      if($this->pp_printmode > 0)
      {
        //tdbg("pp_layout: " . $this->pp_layout);
        //tdbg("pp_static_link: " . $this->pp_static_link);
        //tdbg("pp_dynamic_link: " . $this->pp_dynamic_link);
      }
      
      $this->getLinks();
      
      $this->pp_filename = $this->pp_document_root . $this->mkFileName();
      
      $this->pp_filename_nav = $this->pp_filepath_to_output . $this->putSubSuffix($this->pp_filename, "_nav");
      
      if($this->pp_printmode > 0)
      {
        //tdbg("filename: " . $this->pp_filename,"pink",2);
        //if($this->pp_layout == "frames")
         //tdbg("filename_nav: " . $this->pp_filename_nav,"red",2);
      }
      $dir = dirname($this->pp_static_link) . "/";
      
      if($this->pp_printmode > 0)
      {
        $this->pp_url = $this->pp_static_link;
      }
      else
      {
        $this->pp_url = $this->pp_phpself . "?page_id=" . $this->pp_page_id;
      }
      if($this->pp_layout == "std_two_frame")
      {
        $query = "select url from s_furl where page_id = $this->pp_page_id";
        $lstmt = dbr_query($query);
        $row = mysql_fetch_row($lstmt);
        $this->pp_url_disp = $row[0];
          if($lstmt) mysql_free_result($lstmt);
        
        if($this->pp_printmode > 0)
        {
          //tdbg($this->pp_filename, "purple");
          //tdbg($this->pp_filename_nav, "green");
          $this->pp_url_nav = "/" .  ereg_replace($this->pp_document_root,"", $this->pp_filename_nav);
        }
        else
        $this->pp_url_nav = $this->pp_phpself . "?page_id=" . $this->pp_page_id . "&mode=leftframe";
      }
      if($this->pp_layout == "std_iframe")
      {
        $query = "select url from s_iframe where page_id = $this->pp_page_id";
        $lstmt = dbr_query($query);
        $row = mysql_fetch_row($lstmt);
        $this->pp_url_disp = $row[0];
          if($lstmt) mysql_free_result($lstmt);
        
        if($this->pp_printmode > 0)
        {
          //tdbg($this->pp_filename, "purple");
          //tdbg($this->pp_filename_nav, "orange");
          $this->pp_url_nav = "/" .  ereg_replace($this->pp_document_root,"", $this->pp_filename_nav);
        }
        else
        $this->pp_url_nav = $this->pp_phpself . "?page_id=" . $this->pp_page_id . "&mode=leftframe";
      }
      
      if($this->pp_printmode > 0)
      {
        if($this->pp_layout == "frames")
        {
          //tdbg("url_nav: " . $this->pp_url_nav,"magenta",2);
          //tdbg("url_disp: " . $this->pp_url_disp,"green",2);
        }
        //tdbg("$this->pp_page_title links: $this->pp_link_cnt");
      }
    
            // furls (remote pages sucked in locally) are the only framesets  
      if($this->pp_layout == "std_two_frame" && !isset($mode))
        $mode = "mkframeset";
      elseif($this->pp_layout == "std_two_column")
        $mode = "columns";

/*
      if($mode == "columns" && $this->pp_link_cnt > 19)
      {
              if($pt ==   "std_one_image")
        $mode = "floatDisp";
      }
*/

      switch ($mode)
      {
        case "columns"    :
        if($this->pp_printmode > 0)
            $this->pp_fp = fopen($this->pp_filename, "w");
        $this->mkTwoFixedColumnsPage();
        return;
        case "leftframe"  :
        if($this->pp_printmode > 0)
        $this->pp_fp = fopen($this->pp_filename_nav, "w");
        $this->mkLeftFrame();
        return;
        case "rightframe" :
        if($this->pp_printmode > 0)
        $this->pp_fp = fopen($this->pp_filename_disp, "w");
        $this->mkRightFrame();
        return;
        case "mkframeset"   :
        if($this->pp_printmode > 0)
        $this->pp_fp = fopen($this->pp_filename, "w");
        $this->mkFrameset();
        return;
      }
    }
  }
  
  function putSubSuffix($filename, $subSuff)
  {
    $tmplabel = $this->tmpLabel($filename);
    if(strrpos($tmplabel,".") == true)
    $tmplabel = stripSuffix($tmplabel);
    
    $tmplabel .= $subSuff;
    $tmplabel .= ".html";
    
    return($tmplabel);
  }
}

?>

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products