|
| IP: |
n/a |
| Rang: |
  |
| Registrierung: |
22.02.2006, 10:35 |
| Homepage: |
http://www.kvhansa.de |
| Wohnort: |
Stralsund |
| |
Fortgeschritten mit 111 Punkte, 81 Beiträge |
|
SQL: 1
2
3
| sql_qry("CREATE TABLE `".TB_ADD_FIELDS."` ( `id` int(10) unsigned NOT NULL auto_increment, `field_name` varchar(20) NOT NULL default '', `field_type` enum('string','int','enum') NOT NULL default 'string', `field_values` varchar(255) NOT NULL default '', `field_len` mediumint(3) unsigned NOT NULL default '0', `info_name` varchar(50) NOT NULL default '', `info_show` enum('details','both') NOT NULL default 'both', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_ADMINS."` ( `id` int(10) unsigned NOT NULL auto_increment, `user_name` varchar(30) NOT NULL default '', `user_pw` varchar(32) NOT NULL default '', `user_status` enum('admin','mod') NOT NULL default 'admin', `user_email` varchar(255) NOT NULL default '', `user_access` int(10) unsigned NOT NULL default '0', `enable_email_notification` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("INSERT INTO `".TB_ADMINS."` (`id`, `user_name`, `user_pw`, `user_status`, `user_email`, `user_access`, `enable_email_notification`) VALUES (1, '".$_POST['firstlogin']."', '".md5($_POST['firstpw'])."', 'admin', '".$_POST['first_email']."', 0, 0)"); $DB->sql_qry("CREATE TABLE `".TB_BADWORDS."` ( `id` int(10) unsigned NOT NULL auto_increment, `word_search` varchar(50) NOT NULL default '', `word_replace` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_BANLIST."` ( `id` int(10) unsigned NOT NULL auto_increment, `ban_string` varchar(100) NOT NULL default '', `ban_type` enum('ip','name','email') NOT NULL default 'ip', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_CATS."` ( `id` int(10) unsigned NOT NULL auto_increment, `parent_id` int(10) unsigned NOT NULL default '0', `cat_sort` int(10) unsigned NOT NULL default '0', `cat_name` varchar(100) NOT NULL default '', `cat_description` varchar(255) NOT NULL default '', `cat_picture` varchar(255) NOT NULL default '', `cat_type` enum('contains_cats','contains_pics') NOT NULL default 'contains_pics', `pic_num` int(10) unsigned NOT NULL default '0', `hit_num` int(10) unsigned NOT NULL default '0', `com_num` int(10) unsigned NOT NULL default '0', `last_pic_date` int(10) NOT NULL default '0', `last_pic_id` int(10) unsigned NOT NULL default '0', `last_com_date` int(10) NOT NULL default '0', `last_com_pid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_COMMENTS."` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `user_name` varchar(30) NOT NULL default '', `comment_text` text NOT NULL, `comment_date` int(10) unsigned NOT NULL default '0', `user_ip` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_CONFIG."` ( `theme` tinyint(2) unsigned NOT NULL default '0', `enable_comments` tinyint(1) unsigned NOT NULL default '0', `enable_rating` tinyint(1) unsigned NOT NULL default '0', `enable_smileys` tinyint(1) unsigned NOT NULL default '0', `enable_bbcode` tinyint(1) unsigned NOT NULL default '0', `enable_badwords` tinyint(1) unsigned NOT NULL default '0', `enable_top10` tinyint(1) unsigned NOT NULL default '0', `enable_search` tinyint(1) unsigned NOT NULL default '0', `badwords_highlight` enum('none','bold','italic','underline','red','orange','blue') NOT NULL default 'none', `badwords_method` enum('each','all') NOT NULL default 'each', `badwords_default` varchar(50) NOT NULL default '', `script_width` smallint(4) unsigned NOT NULL default '0', `script_titel` varchar(100) NOT NULL default '', `resize_method` enum('upload','afterwards','off') NOT NULL default 'upload', `resize_width` smallint(4) unsigned NOT NULL default '0', `resize_height` smallint(4) unsigned NOT NULL default '0', `resize_proportion` enum('both','height','width') NOT NULL default 'both', `anzahl_neb` int(3) NOT NULL default '0', `default_order` enum('picture_name','date','hits','rating','comments') NOT NULL default 'date', `default_ad` enum('ASC','DESC') NOT NULL default 'ASC', `default_bps` smallint(3) unsigned NOT NULL default '0', `language` tinyint(2) unsigned NOT NULL default '0', `topx_show` varchar(5) NOT NULL default '', `topx_count` tinyint(3) unsigned NOT NULL default '0', `topx_show_pics` tinyint(1) unsigned NOT NULL default '0', `spam_vote_on` tinyint(1) unsigned NOT NULL default '0', `spam_vote_time` mediumint(5) unsigned NOT NULL default '0', `spam_click_on` tinyint(1) unsigned NOT NULL default '0', `spam_click_time` mediumint(5) unsigned NOT NULL default '0', `enable_popup` tinyint(1) unsigned NOT NULL default '0', `popup_size_x` smallint(4) unsigned NOT NULL default '0', `popup_size_y` smallint(4) unsigned NOT NULL default '0', `overview_description` tinyint(1) unsigned NOT NULL default '0', `banlist_num` int(10) unsigned NOT NULL default '0', `add_fields_num` int(10) unsigned NOT NULL default '0', `index_path` varchar(255) NOT NULL default '', `enable_saveas` tinyint(1) unsigned NOT NULL default '0', `bbcode_mode` enum('simple','advanced') NOT NULL default 'simple', `category_insert_mode` enum('top','bottom') NOT NULL default 'bottom', `enable_random_pics` tinyint(1) unsigned NOT NULL default '0', `random_pic_num` tinyint(2) unsigned NOT NULL default '0', `random_pics_per_line` tinyint(2) unsigned NOT NULL default '0', `timezone` decimal(2,1) NOT NULL default '1.0', `enable_gzip` tinyint(1) unsigned NOT NULL default '0', `picture_rating_sort` enum('avg','total','rate_num') NOT NULL default 'avg', `email_sender_address` varchar(255) NOT NULL default '', `comments_display_order` enum('asc','desc') NOT NULL default 'asc', `show_all_categories` tinyint(1) unsigned NOT NULL default '0', `cookie_domain` varchar(100) NOT NULL default '', `cookie_path` varchar(100) NOT NULL default '', `comments_parse_urls` tinyint(1) unsigned NOT NULL default '0' ) TYPE=MyISAM;"); $DB->sql_qry("INSERT INTO `".TB_CONFIG."` (`theme`, `enable_comments`, `enable_rating`, `enable_smileys`, `enable_bbcode`, `enable_badwords`, `enable_top10`, `enable_search`, `badwords_highlight`, `badwords_method`, `badwords_default`, `script_width`, `script_titel`, `resize_method`, `resize_width`, `resize_height`, `resize_proportion`, `anzahl_neb`, `default_order`, `default_ad`, `default_bps`, `language`, `topx_show`, `topx_count`, `topx_show_pics`, `spam_vote_on`, `spam_vote_time`, `spam_click_on`, `spam_click_time`, `enable_popup`, `popup_size_x`, `popup_size_y`, `overview_description`, `banlist_num`, `add_fields_num`, `index_path`, `enable_saveas`, `bbcode_mode`, `category_insert_mode`, `enable_random_pics`, `random_pic_num`, `random_pics_per_line`, `timezone`, `enable_gzip`, `picture_rating_sort`, `email_sender_address`, `comments_display_order`, `show_all_categories`, `cookie_domain`, `cookie_path`) VALUES (1, 1, 1, 1, 1, 0, 1, 1, 'italic', 'all', '*censored*', 100, 'Picturesolution v2.12', 'upload', 200, 150, 'height', 2, 'date', 'DESC', 6, 3, '013', 5, 1, 1, 86400, 1, 1800, 1, 800, 600, 0, 0, 0,'', 1, 'simple', 'top', 1, 4, 4, 1.0, 0, 'avg', 'admin@yourgallery.de', 'desc', 1, '', '/');"); $DB->sql_qry("CREATE TABLE `".TB_IP."` ( `ip` varchar(50) NOT NULL default '', `datum` int(10) NOT NULL default '0', `pic_id` int(10) NOT NULL default '0', `ip_action` enum('vote','hit') NOT NULL default 'vote' ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_LANGS."` ( `id` smallint(3) unsigned NOT NULL auto_increment, `lang_folder` varchar(20) NOT NULL default '', `lang_name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM"); $DB->sql_qry("INSERT INTO `".TB_LANGS."` (`id`, `lang_folder`, `lang_name`) VALUES (1, 'ger_sie', 'Deutsch (Sie-Version)')"); $DB->sql_qry("INSERT INTO `".TB_LANGS."` (`id`, `lang_folder`, `lang_name`) VALUES (2, 'en', 'English')"); $DB->sql_qry("INSERT INTO `".TB_LANGS."` (`id`, `lang_folder`, `lang_name`) VALUES (3, 'ger_du', 'Deutsch (Du-Version)')"); $DB->sql_qry("CREATE TABLE `".TB_PICS."` ( `id` int(10) unsigned NOT NULL auto_increment, `cat_id` int(10) unsigned NOT NULL default '0', `picture_name` varchar(100) NOT NULL default '', `picture_path` varchar(255) NOT NULL default '', `picture_thumb_path` varchar(255) NOT NULL default '', `picture_date` int(10) unsigned NOT NULL default '0', `description` text NOT NULL, `comment_num` int(10) unsigned NOT NULL default '0', `rate_num` int(10) unsigned NOT NULL default '0', `rate_points_total` int(10) unsigned NOT NULL default '0', `hit_num` int(10) unsigned NOT NULL default '0', `active` tinyint(1) unsigned NOT NULL default '0', `add_blub` varchar(10) NOT NULL default '', `add_bla` int(3) unsigned NOT NULL default '0', `add_achja` enum('a','b','c') NOT NULL default 'a', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_SESSIONS."` ( `session_id` varchar(32) NOT NULL default '', `user_id` int(10) unsigned NOT NULL default '0', `user_ip` varchar(15) NOT NULL default '', `current_time` int(10) NOT NULL default '0' ) TYPE=MyISAM;"); $DB->sql_qry("CREATE TABLE `".TB_SMILEYS."` ( `id` int(10) unsigned NOT NULL auto_increment, `pfad_smiley` varchar(255) NOT NULL default '', `replace_prim` varchar(15) NOT NULL default '', `replace_sec` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('happy.gif', '=)', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('frown.gif', ':-(', ':(');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('evil.gif', ':evil:', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('eek.gif', ':o', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('crying.gif', ':cry:', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('cool.gif', '8-)', '8)');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('confused.gif', ':confused:', ':??:');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('biggrin.gif', ':-O', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('mad.gif', ':x', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('pleased.gif', ':pleased:', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('rolleyes.gif', ':roll:', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('smile.gif', ':-)', ':)');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('tongue.gif', ':-P', ':P');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('wink.gif', ';-)', ';)');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('exclamation.gif', '(!)', ':!:');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('question.gif', '(?)', ':?:');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('shock.gif', ':shock:', '');"); $DB->sql_qry("INSERT INTO `".TB_SMILEYS."` (`pfad_smiley`, `replace_prim`, `replace_sec`) VALUES ('bigsmile.gif', ':D', '');"); $DB->sql_qry("CREATE TABLE `".TB_THEMES."` ( `id` smallint(3) unsigned NOT NULL auto_increment, `theme_folder` varchar(20) NOT NULL default '', `theme_name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM"); $DB->sql_qry("INSERT INTO `".TB_THEMES."` (`id`, `theme_folder`, `theme_name`) VALUES (1, 'default', 'Default')"); $DB->sql_close(); ?>
Die Installation wurde erfolgreich abgeschlossen. Bitte lösche die Datei "install.php" jetzt
Gehe zu Picturesolution | Diese Meldung kommt, wenn die Installation durch ist. Ist das ok. so? Deine anderen Tipps haben nicht funktioniert. Er macht auch nicht mal Anstalten die Tabellen zu installieren. Habe die Files alle aus eurem Download.
Dieser Beitrag wurde insgesamt 1 mal editiert. Das letzte mal 04.08.2009, 18:28 von th_hst.
|
|
Thema: "Fehlermeldung bei der Installation von PS 2.12"
[ Seite 1 2 ]
th_hst , 03.08.2009, 19:55
Hatte das Problem füher schon einmal und Niels hat da irgendwas gemacht, ich weiß
