Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php if (!defined('BASEPATH')) exit('No direct script access allowed');
- class Install extends CI_Controller {
- private $prefix = "";
- function __construct() {
- parent::__construct();
- }
- function index() {
- if(!$this->helper->dbready()) echo "db is not ready";
- }
- function database() {
- $this->load->dbforge();
- $this->prefix = $this->config->item("table_prefix");
- header('Content-type: text/html; charset=utf-8');
- /* ----------------------------------------- */
- /* ----------- Create User Table ----------- */
- /* ----------------------------------------- */
- $user_fields["ID"] = array("type"=>"TINYINT","constraint"=>2,"unsigned"=>true, "auto_increment"=>true);
- $user_fields["user_name"] = array("type"=>"VARCHAR","constraint"=>24);
- $user_fields["user_fullname"] = array("type"=>"VARCHAR","constraint"=>40);
- $user_fields["user_pass"] = array("type"=>"VARCHAR","constraint"=>32);
- $user_fields["user_email"] = array("type"=>"VARCHAR","constraint"=>24);
- $user_fields["user_level"] = array("type"=>"VARCHAR","constraint"=>16);
- $user_fields["user_last_seen"] = array("type"=>"DATETIME");
- $user_fields["is_active"] = array("type"=>"TINYINT","constraint"=>1,'default'=>1);
- $this->dbforge->add_field($user_fields);
- $this->dbforge->add_key('ID', TRUE);
- $this->dbforge->create_table($this->prefix . 'users', TRUE);
- /* ----------- Populate User Table ----------- */
- if( $this->db->table_exists($this->prefix."users") ):
- $query = $this->db->get($this->prefix."users");
- if( $query->num_rows() < 1 ):
- $userdata = array(
- array(
- "user_name" => "Lacej",
- "user_fullname" => "Laczkó Gábor",
- "user_pass" => md5("lacej123"),
- "user_email" => "lczkgbr@gmail.com",
- "user_level" => "superadmin",
- "user_last_seen" => date("Y-m-d H:i:s"),
- "is_active" => 1
- ),
- array(
- "user_name" => "Szityu",
- "user_fullname" => "Nagy Zsolt",
- "user_pass" => md5("szityu123"),
- "user_email" => "nagyzs@hulman.hu",
- "user_level" => "superadmin",
- "user_last_seen" => date("Y-m-d H:i:s"),
- "is_active" => 1
- ),
- array(
- "user_name" => "Racsi",
- "user_fullname" => "Racskó Zsolt",
- "user_pass" => md5("racsi123"),
- "user_email" => "racsko.zsolt@t-online.hu",
- "user_level" => "superadmin",
- "user_last_seen" => date("Y-m-d H:i:s"),
- "is_active" => 1
- ),
- array(
- "user_name" => "Egres",
- "user_fullname" => "Lakatos Anita",
- "user_pass" => md5("piszkenek"),
- "user_email" => "durerpress@gmail.com",
- "user_level" => "press",
- "user_last_seen" => date("Y-m-d H:i:s"),
- "is_active" => 1
- )
- );
- foreach($userdata as $data):
- $this->db->insert($this->prefix."users",$data);
- endforeach;
- else:
- echo "A '".$this->prefix."users' tábla kész!"."<br/>";
- endif;
- endif;
- /* ------------------------------------------------ */
- /* ----------- Create Data Fields Table ----------- */
- /* ------------------------------------------------ */
- $data_fields["ID"] = array("type"=>"TINYINT","constraint"=>2,"unsigned"=>true, "auto_increment"=>true);
- $data_fields["field_name"] = array("type"=>"VARCHAR","constraint"=>20);
- $data_fields["field_type"] = array("type"=>"VARCHAR","constraint"=>20);
- $data_fields["field_class"] = array("type"=>"VARCHAR","constraint"=>20);
- $data_fields["is_excerpt"] = array("type"=>"TINYINT","constraint"=>1,"unsigned"=>true);
- $data_fields["minimum_access_level"] = array("type"=>"TINYINT","constraint"=>1,"unsigned"=>true);
- $data_fields["created_at"] = array("type"=>"DATETIME");
- $data_fields["created_by"] = array("type"=>"VARCHAR","constraint"=>24);
- $data_fields["updated_at"] = array("type"=>"DATETIME");
- $data_fields["updated_by"] = array("type"=>"VARCHAR","constraint"=>24);
- $data_fields["order"] = array("type"=>"TINYINT","constraint"=>2);
- $this->dbforge->add_field($data_fields);
- $this->dbforge->add_key('ID', TRUE);
- $this->dbforge->create_table($this->prefix . 'fields', TRUE);
- /* ----------- Populate Data Fields Table ----------- */
- if( $this->db->table_exists($this->prefix."fields") ):
- $query = $this->db->get($this->prefix."fields");
- if( $query->num_rows() < 1 ):
- $fielddata = array(
- array(
- "field_name" => "Dátum",
- "field_type" => "text",
- "field_class" => "datetime",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Kapunyitás",
- "field_type" => "text",
- "field_class" => "",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Kezdés",
- "field_type" => "text",
- "field_class" => "",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Nagyterem",
- "field_type" => "textarea",
- "field_class" => "",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Kisterem",
- "field_type" => "textarea",
- "field_class" => "",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Gázsi",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 10,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Belépő",
- "field_type" => "text",
- "field_class" => "",
- "is_excerpt" => 1,
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Stílus",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Szervezők",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Beállás",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Porta",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Jegyszedő",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Nézőszám",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Italakció",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Színpadmester",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Világosító",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "DJ",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "VJ",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 5,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "BS szobaszám",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "BS pia",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "BS őrök",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "BS gyümölcskosár",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Máshol",
- "field_type" => "text",
- "field_class" => "",
- "minimum_access_level" => 7,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- ),
- array(
- "field_name" => "Megjegyzés",
- "field_type" => "textarea",
- "field_class" => "",
- "minimum_access_level" => 3,
- "created_at" => date("Y-m-d H:i:s"),
- "created_by" => "Install script"
- )
- );
- foreach($fielddata as $data):
- $this->db->insert($this->prefix."fields",$data);
- endforeach;
- else:
- echo "A '".$this->prefix."fields' tábla kész!"."<br/>";
- endif;
- endif;
- /* ------------------------------------------- */
- /* ----------- Create Events Table ----------- */
- /* ------------------------------------------- */
- $event_fields["ID"] = array("type"=>"INT","constraint"=>10,"unsigned"=>true, "auto_increment"=>true);
- $event_fields["user_id"] = array("type"=>"TINYINT","constraint"=>2,"unsigned"=>true);
- $event_fields["event_date"] = array("type"=>"DATE");
- $event_fields["event_status"] = array("type"=>"TINYINT","constraint"=>1,"unsigned"=>true);
- $event_fields["event_serialized"] = array("type"=>"TINYINT","constraint"=>1,"unsigned"=>true);
- $event_fields["created_at"] = array("type"=>"DATETIME");
- $event_fields["updated_at"] = array("type"=>"DATETIME");
- $event_fields["created_by"] = array("type"=>"VARCHAR","constraint"=>24);
- $event_fields["updated_by"] = array("type"=>"VARCHAR","constraint"=>24);
- $event_fields["is_active"] = array("type"=>"TINYINT","constraint"=>1);
- $this->dbforge->add_field($event_fields);
- $this->dbforge->add_key('ID', TRUE);
- $this->dbforge->create_table($this->prefix . 'events', TRUE);
- if( $this->db->table_exists($this->prefix."events") ):
- echo "A '".$this->prefix."events' tábla kész!"."<br/>";
- endif;
- /* ------------------------------------------------ */
- /* ----------- Create Event Data Table ----------- */
- /* ------------------------------------------------ */
- $event_data["event_id"] = array("type"=>"INT","constraint"=>10,"unsigned"=>true);
- $event_data["field_id"] = array("type"=>"TINYINT","constraint"=>2,"unsigned"=>true);
- $event_data["field_name"] = array("type"=>"VARCHAR","constraint"=>20);
- $event_data["field_value"] = array("type"=>"TEXT");
- $event_data["minimum_access_level"] = array("type"=>"TINYINT","constraint"=>1,"unsigned"=>true);
- $this->dbforge->add_field($event_data);
- $this->dbforge->create_table($this->prefix . 'data', TRUE);
- if( $this->db->table_exists($this->prefix."data") ):
- echo "A '".$this->prefix."data' tábla kész!"."<br/>";
- endif;
- }
- }
- /* End of file welcome.php */
- /* Location: ./application/controllers/welcome.php */
Add Comment
Please, Sign In to add comment