Разработка динамического сайта для предприятия

 

ПРИЛОЖЕНИЕ 2

     # Host     : localhost

     # Port     : 3306

     # Database : tochka

     SET FOREIGN_KEY_CHECKS=0;

     CREATE DATABASE `tochka`;

     USE `tochka`;

     #

     # Structure for the `menu` table :

     #

     CREATE TABLE `menu` (

       `id_menu` tinyint(4) NOT NULL auto_increment,

       `mname` varchar(255) NOT NULL default '',

       `parent_id` tinyint(4) default NULL,

       `content` text,

       `extpath` varchar(255) default NULL,

       `tmeta` text,

       `morder` tinyint(4) NOT NULL default '0',

       `title` varchar(255) default NULL,

       `is_umsg` tinyint(1) default NULL,

       `is_vertical` tinyint(1) default NULL,

       `topmsg` text,

       PRIMARY KEY  (`id_menu`),

       UNIQUE KEY `id_menu` (`id_menu`)

     ) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COMMENT='InnoDB free: 4096 kB';

     #

     # Structure for the `roles` table :

     #

     CREATE TABLE `roles` (

       `role_id` tinyint(4) NOT NULL auto_increment,

       `access` varchar(255) default NULL,

       PRIMARY KEY  (`role_id`),

       UNIQUE KEY `role_id` (`role_id`)

     ) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

     #

     # Structure for the `users` table :

     #

     CREATE TABLE `users` (

       `user_id` tinyint(4) NOT NULL auto_increment,

       `login` varchar(255) default NULL,

       `upwd` varchar(255) default NULL,

       PRIMARY KEY  (`user_id`),

       UNIQUE KEY `user_id` (`user_id`)

     ) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COMMENT='InnoDB free: 4096 kB';

     #

     # Structure for the `usrmsg` table :

     #

     CREATE TABLE `usrmsg` (

       `umsg_id` tinyint(4) NOT NULL auto_increment,

       `email` varchar(255) default NULL,

       `tmsg` text,

       `is_new` tinyint(1) default NULL,

       PRIMARY KEY  (`umsg_id`),

       UNIQUE KEY `umsg_id` (`umsg_id`)

     ) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COMMENT='InnoDB free: 4096 kB';

 

ПРИЛОЖЕНИЕ 3

class Page {

      var $Menu;

      var $Parent_id;

      var $Content;

      var $ExtPath;

      var $Meta;

      var $Title;

      var $Is_usmsg;

      var $Topmsg;

      var $Morder;

      var $Is_columned;

      function Page($menu_id)

      {

            $q=mysql_query("SELECT mname,parent_id,content,extpath,tmeta,title,is_umsg,topmsg,morder FROM menu WHERE (id_menu=$menu_id)");

            $qr=mysql_fetch_row($q);

            $this->Menu=$qr[0];

            $this->Parent_id=$qr[1];

            $this->Content=$qr[2];

            $this->ExtPath=$qr[3];

            $this->Meta=$qr[4];

            $this->Title=$qr[5];

            $this->Is_usmsg=$qr[6];

            $this->Topmsg=$qr[7];

            $this->Morder=$qr[8];

      }

      function IsChilds($menu_id)

      {

            $qc=mysql_query("select id_menu,mname,extpath from menu where parent_id=$menu_id");

            if (mysql_num_rows($qc)!=0) {$result=1; }

            else $result=0;

            return $result;

      }

      function ShowMenu($menuid,$parentid)

      {

            $amenu=mysql_query('select id_menu,mname,morder from menu where parent_id is null order by morder');

            if (!is_null($menuid)) {

                  while ($rw = mysql_fetch_array($amenu))

                  {

                        if (($menuid==$rw[0])||($parentid==$rw[0])) {

                              echo "<li><a href=\"index.php?id=$rw[0]\" class=\"active\">$rw[1]</a></li>";}

                        else { echo "<li><a href=\"index.php?id=$rw[0]\">$rw[1]</a></li>";}

                  }

            }

      } 

}