NEWSolved Lite Setup

"; echo ""; echo "NEWSolved Lite Setup"; echo ""; echo ""; echo ""; echo ""; //----------------- Abfragen über Usereingaben - Form 0 ----------------- $inst0=$_POST['inst0']; if($inst0) { $language_name=$_POST['language_name']; if($language_name=="German") { $language_file="lang_de.php"; $language_aktiv="1"; require("settings/$language_file"); } if($language_name=="English") { $language_file="lang_en.php"; $language_aktiv="1"; require("settings/$language_file"); } } //----------------- Abfragen über Usereingaben - Form 1 ----------------- $back_0=$_POST['back_0']; if($back_0) { unset($inst0); unset($inst1); $language_name=$_POST['language_name']; $language_file=$_POST['language_file']; $language_aktiv=$_POST['language_aktiv']; require("settings/$language_file"); } $inst1=$_POST['inst1']; if($inst1) { $prefix=$_POST['prefix']; $db_type=$_POST['db_type']; $host=$_POST['host']; $db=$_POST['db']; $dbuser=$_POST['dbuser']; $dbpasswd=$_POST['dbpasswd']; $language_name=$_POST['language_name']; $language_file=$_POST['language_file']; $language_aktiv=$_POST['language_aktiv']; require("settings/$language_file"); echo "

"; if($host=="") { $error_log1.="".$lang_inst_error_host."!"; unset($inst1); $inst0_ok=1; } if($db=="") { $error_log1.="".$lang_inst_error_dbname."!"; unset($inst1); $inst0_ok=1; } if($dbuser=="") { $error_log1.="".$lang_inst_error_dbuser."!"; unset($inst1); $inst0_ok=1; } if($host!="" && $dbuser!="") { $connID=@mysql_pconnect($host, $dbuser, $dbpasswd); if ($connID) { if(mysql_select_db($db)==false){$error_log1.="".$lang_inst_error_dbno."!";unset($inst1);} $inst0_ok=1; } else { $error_log1.="".$lang_inst_error_dbset."!"; unset($inst1); $inst0_ok=1; } } echo "

"; } //----------------- Abfragen über Usereingaben - Form 2 ----------------- $back=$_POST['back']; if($back) { $inst0_ok=1; unset($inst1); unset($inst2); $language_name=$_POST['language_name']; $language_file=$_POST['language_file']; $language_aktiv=$_POST['language_aktiv']; require("settings/$language_file"); } $inst2=$_POST['inst2']; if($inst2) { $prefix=$_POST['prefix']; $db_type=$_POST['db_type']; $host=$_POST['host']; $db=$_POST['db']; $dbuser=$_POST['dbuser']; $dbpasswd=$_POST['dbpasswd']; $name=$_POST['name']; $password1=$_POST['password1']; $password2=$_POST['password2']; $mail=$_POST['mail']; $scriptpath=$_POST['scriptpath']; $loginsave=$_POST['loginsave']; $language_name=$_POST['language_name']; $language_file=$_POST['language_file']; $language_aktiv=$_POST['language_aktiv']; require("settings/$language_file"); echo "

"; if($name=="") { $error_log2.="".$lang_inst_error_user."!"; $inst1_ok=1; $inst_check_f=1; } if($password1=="") { $error_log2.="".$lang_inst_error_pw."!"; $inst1_ok=1; $inst_check_f=1; } if($password2=="") { $error_log2.="".$lang_inst_error_pwr."!"; $inst1_ok=1; $inst_check_f=1; } if($password1!=$password2) { $error_log2.="".$lang_inst_error_pwsame."!"; $inst1_ok=1; $inst_check_f=1; } if($mail=="") { $error_log2.="".$lang_inst_error_mail."!"; $inst1_ok=1; $mail_check=ok; $inst_check_f=1; } $mail=trim($mail); if (!(strstr($mail, "@") and strstr($mail, ".")) && empty($mail_check)) { $error_log2.="".$lang_inst_error_mailcheck."!"; $inst1_ok=1; $inst_check_f=1; } if ($inst_check_f!="1") { $ready=1; } else { $inst0="set"; $inst1="set"; unset($inst2); } echo "

"; } //------------------------------------------------------------------------------ echo "

"; //------------------------------------------------------------------------------ if($ready==1) { //----------------- Anlegen der config.php ----------------- if($host!="" && $db!="" && $dbuser!="") { $prefix="newsolvedlite"; if(substr($scriptpath,0,7)!="http://") { $scriptpath="http://".$scriptpath; } if(substr($scriptpath,-1)=="/") { $str_len=strlen($scriptpath); $str_len=$str_len-1; $scriptpath=substr($scriptpath,0,$str_len); } //db settings $datei=fopen("settings/config.php","w+"); fwrite($datei, "" ); fclose($datei); //----------------- DB Tabellen erstellen ----------------- include("settings/connect.php"); mysql_query("drop table $prefix"."_intern_login"); mysql_query("create table $prefix"."_intern_login(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "user varchar(30) NOT NULL,". "userid int(10) NOT NULL,". "userhash varchar(100) NOT NULL,". "expire int(11) NOT NULL,". "userip varchar(15) NOT NULL,". "usertime varchar(20) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_intern_login", mysql_error()); mysql_query("drop table $prefix"."_intern_users"); mysql_query("create table $prefix"."_intern_users(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "user varchar(30) NOT NULL,". "pw varchar(50) NOT NULL,". "mail varchar(50) NOT NULL,". "handy_nr varchar(20) NOT NULL,". "regdate date NOT NULL,". "groupid int(10) NOT NULL,". "news_in_send int(1) NOT NULL,". "news_in int(1) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_intern_users", mysql_error()); mysql_query("drop table $prefix"."_intern_groups"); mysql_query("create table $prefix"."_intern_groups(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "groupname varchar(250) NOT NULL,". "userlevel varchar(15) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_intern_groups", mysql_error()); mysql_query("drop table $prefix"."_entries"); mysql_query("create table $prefix"."_entries(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "name varchar(30) NOT NULL,". "mail varchar(50) NOT NULL,". "topic varchar(250) NOT NULL,". "cat varchar(250) NOT NULL,". "related_link1 varchar(250) NOT NULL,". "related_link2 varchar(250) NOT NULL,". "related_link3 varchar(250) NOT NULL,". "related_link4 varchar(250) NOT NULL,". "related_link5 varchar(250) NOT NULL,". "msg text NOT NULL,". "announce int(1) NOT NULL,". "date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_entries", mysql_error()); mysql_query("drop table $prefix"."_entries_queue"); mysql_query("create table $prefix"."_entries_queue(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "name varchar(30) NOT NULL,". "mail varchar(50) NOT NULL,". "topic varchar(250) NOT NULL,". "cat varchar(250) NOT NULL,". "related_link1 varchar(250) NOT NULL,". "related_link2 varchar(250) NOT NULL,". "related_link3 varchar(250) NOT NULL,". "related_link4 varchar(250) NOT NULL,". "related_link5 varchar(250) NOT NULL,". "msg text NOT NULL,". "announce int(1) NOT NULL,". "date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,". "date_post datetime DEFAULT '0000-00-00 00:00:00' NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_entries_queue", mysql_error()); mysql_query("drop table $prefix"."_entries_temp"); mysql_query("create table $prefix"."_entries_temp(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "name varchar(30) NOT NULL,". "mail varchar(50) NOT NULL,". "topic varchar(250) NOT NULL,". "cat varchar(250) NOT NULL,". "related_link1 varchar(250) NOT NULL,". "related_link2 varchar(250) NOT NULL,". "related_link3 varchar(250) NOT NULL,". "related_link4 varchar(250) NOT NULL,". "related_link5 varchar(250) NOT NULL,". "msg text NOT NULL,". "announce int(1) NOT NULL,". "date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_entries_temp", mysql_error()); mysql_query("drop table $prefix"."_comments"); mysql_query("create table $prefix"."_comments(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "id_news int(10) NOT NULL,". "name varchar(50) NOT NULL,". "mail varchar(50) NOT NULL,". "msg text NOT NULL,". "date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_comments", mysql_error()); mysql_query("drop table $prefix"."_ipsperre"); mysql_query("create table $prefix"."_ipsperre(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "ip int(15) NOT NULL,". "zeit int(20) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_ipsperre", mysql_error()); mysql_query("drop table $prefix"."_settings"); mysql_query("create table $prefix"."_settings(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". //--- Output/Allg --- "show_html int(1) NOT NULL,". "show_latestnews int(1) NOT NULL,". "show_bbcode int(1) NOT NULL,". "show_topic int(1) NOT NULL,". "show_date int(1) NOT NULL,". "show_dateformat int(2) NOT NULL,". "show_smilies int(1) NOT NULL,". "show_writer int(1) NOT NULL,". "show_mail int(1) NOT NULL,". "show_archiv int(1) NOT NULL,". "show_sites int(1) NOT NULL,". "show_date_above int(1) NOT NULL,". "show_dateformat_above int(1) NOT NULL,". "show_cat int(1) NOT NULL,". "show_cat_img int(1) NOT NULL,". "show_cat_filter int(1) NOT NULL,". "show_att_mail int(1) NOT NULL,". "show_att_print int(1) NOT NULL,". "show_att_com int(1) NOT NULL,". "show_att_mail_k int(1) NOT NULL,". "show_att_print_k int(1) NOT NULL,". "show_att_com_k int(1) NOT NULL,". "show_att_com_count int(1) NOT NULL,". "show_search int(1) NOT NULL,". "show_sendnews int(1) NOT NULL,". "show_new int(1) NOT NULL,". "linkdescr varchar(50) NOT NULL,". "intro_date varchar(50) NOT NULL,". "intro_editor varchar(50) NOT NULL,". "intro_cat varchar(50) NOT NULL,". "how_show_news int(1) NOT NULL,". "how_show_latestnews int(1) NOT NULL,". "number_news_letters int(6) NOT NULL,". "number_news int(5) NOT NULL,". "number_latestnews int(3) NOT NULL,". "complete_news int(1) NOT NULL,". "mail_after_com int(1) NOT NULL,". "target_sendnews int(1) NOT NULL,". "target_com int(1) NOT NULL,". "target_friendmail int(1) NOT NULL,". "target_mail int(1) NOT NULL,". "target_archiv int(1) NOT NULL,". "author_mail int(1) NOT NULL,". //--- Admin/Newsform --- "use_loginstuff int(1) NOT NULL,". "admin_number_links int(1) NOT NULL,". "admin_category int(1) NOT NULL,". "admin_write_html int(1) NOT NULL,". "admin_write_bbcode int(1) NOT NULL,". "admin_write_smilies int(1) NOT NULL,". "admin_write_announce int(1) NOT NULL,". "admin_write_queue int(1) NOT NULL,". "admin_write_user int(1) NOT NULL,". "admin_write_mail int(1) NOT NULL,". "admin_write_topic int(1) NOT NULL,". "admin_write_news int(1) NOT NULL,". "admin_write_upfile int(1) NOT NULL,". "admin_write_upimg int(1) NOT NULL,". "admin_edit_number int(3) NOT NULL,". //--- Datei Upload --- "admin_file_ext varchar(250) NOT NULL,". "admin_file_size int(10) NOT NULL,". "admin_img_ext varchar(250) NOT NULL,". "admin_img_size int(10) NOT NULL,". "admin_img_url varchar(250) NOT NULL,". "layout_scheme int(1) NOT NULL,". "layout_scheme_rss int(1) NOT NULL,". "layout_scheme_ticker int(1) NOT NULL,". "ns_active int(1) NOT NULL,". "ns_deactivemsg text NOT NULL,". "admin_loginsave int(1) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_settings", mysql_error()); mysql_query("drop table $prefix"."_layout"); mysql_query("create table $prefix"."_layout(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "main_width varchar(6) NOT NULL,". "o_width varchar(6) NOT NULL,". "m_width varchar(6) NOT NULL,". "l_width varchar(6) NOT NULL,". "u_width varchar(6) NOT NULL,". "latest_width varchar(6) NOT NULL,". "bgc_topic varchar(7) NOT NULL,". "bgc_datum varchar(7) NOT NULL,". "bgc_name varchar(7) NOT NULL,". "bgc_cat varchar(7) NOT NULL,". "bgc_msg varchar(7) NOT NULL,". "bgc_latest varchar(7) NOT NULL,". "bgc_body varchar(7) NOT NULL,". "bgi_topic varchar(250) NOT NULL,". "bgi_datum varchar(250) NOT NULL,". "bgi_name varchar(250) NOT NULL,". "bgi_cat varchar(250) NOT NULL,". "bgi_msg varchar(250) NOT NULL,". "bgi_latest varchar(250) NOT NULL,". "bgi_body varchar(250) NOT NULL,". "bold_topic int(1) NOT NULL,". "border_o varchar(7) NOT NULL,". "border_main varchar(7) NOT NULL,". "border_main_l varchar(7) NOT NULL,". "border_u varchar(7) NOT NULL,". "border_latest varchar(7) NOT NULL,". "tc_topic varchar(7) NOT NULL,". "tc_datum varchar(7) NOT NULL,". "tc_name varchar(7) NOT NULL,". "tc_msg varchar(7) NOT NULL,". "tc_links varchar(7) NOT NULL,". "tc_cat varchar(7) NOT NULL,". "tc_dateabove varchar(7) NOT NULL,". "tc_other varchar(7) NOT NULL,". "tc_att varchar(7) NOT NULL,". "tc_latest varchar(7) NOT NULL,". "ts_topic int(1) NOT NULL,". "ts_datum int(1) NOT NULL,". "ts_name int(1) NOT NULL,". "ts_msg int(1) NOT NULL,". "ts_links int(1) NOT NULL,". "ts_cat int(1) NOT NULL,". "ts_dateabove int(1) NOT NULL,". "ts_other int(1) NOT NULL,". "ts_att int(1) NOT NULL,". "ts_latest int(1) NOT NULL,". "distance_o varchar(6) NOT NULL,". "distance_u varchar(6) NOT NULL,". "distance_lm varchar(6) NOT NULL,". "distance_latest varchar(6) NOT NULL,". "distance_box int(2) NOT NULL,". "font_family varchar(25) NOT NULL,". "arrangement_latest int(2) NOT NULL,". "arrangement int(2) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_layout", mysql_error()); mysql_query("drop table $prefix"."_templates"); mysql_query("create table $prefix"."_templates(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "aktiv int(1) NOT NULL,". "template_name varchar(250) NOT NULL,". "template_header text NOT NULL,". "template_footer text NOT NULL,". "template_news text NOT NULL,". "template_com1 text NOT NULL,". "template_com2 text NOT NULL,". "template_mailto text NOT NULL,". "template_sendnews text NOT NULL,". "template_css text NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_templates", mysql_error()); mysql_query("drop table $prefix"."_newsticker"); mysql_query("create table $prefix"."_newsticker(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "bgcolor varchar(7) NOT NULL,". "placeholder varchar(250) NOT NULL,". "plholdercolor varchar(7) NOT NULL,". "fontcolor varchar(7) NOT NULL,". "fontsize int(2) NOT NULL,". "fontface varchar(25) NOT NULL,". "fontbold int(1) NOT NULL,". "link_on_topic int(1) NOT NULL,". "scrollspeed int(2) NOT NULL,". "getnews int(2) NOT NULL,". "target varchar(10) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_newsticker", mysql_error()); mysql_query("drop table $prefix"."_rss"); mysql_query("create table $prefix"."_rss(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "h_title varchar(250) NOT NULL,". "h_hpurl varchar(250) NOT NULL,". "h_description varchar(250) NOT NULL,". "h_language varchar(10) NOT NULL,". "h_img_url varchar(250) NOT NULL,". "h_mail varchar(250) NOT NULL,". "title int(1) NOT NULL,". "link int(1) NOT NULL,". "description int(1) NOT NULL,". "author int(1) NOT NULL,". "comments int(1) NOT NULL,". "numbernews int(3) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_rss", mysql_error()); mysql_query("drop table $prefix"."_wordfilter"); mysql_query("create table $prefix"."_wordfilter(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "badword varchar(250) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_wordfilter", mysql_error()); mysql_query("drop table $prefix"."_cat"); mysql_query("create table $prefix"."_cat(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "category varchar(250) NOT NULL,". "category_descr text NOT NULL,". "category_img varchar(100) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_cat", mysql_error()); mysql_query("drop table $prefix"."_smilies"); mysql_query("create table $prefix"."_smilies(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "smilie varchar(10) NOT NULL,". "file varchar(100) NOT NULL,". "aktiv int(1) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_smilies", mysql_error()); mysql_query("drop table $prefix"."_language"); mysql_query("create table $prefix"."_language(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "language_name varchar(100) NOT NULL,". "language_file varchar(50) NOT NULL,". "language_aktiv int(1) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_language", mysql_error()); mysql_query("drop table $prefix"."_log"); mysql_query("create table $prefix"."_log(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "logdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,". "userid int(10) NOT NULL,". "action varchar(250) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_log", mysql_error()); mysql_query("drop table $prefix"."_mail_sms"); mysql_query("create table $prefix"."_mail_sms(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "service_active int(1) NOT NULL,". "standard_topic varchar(250) NOT NULL,". "mail varchar(250) NOT NULL,". "username varchar(250) NOT NULL,". "password varchar(250) NOT NULL,". "server_adr varchar(250) NOT NULL,". "server_kind varchar(250) NOT NULL,". "server_port int(6) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_mail_sms", mysql_error()); mysql_query("drop table $prefix"."_mail_sms_filter"); mysql_query("create table $prefix"."_mail_sms_filter(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "filtered text NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_mail_sms_filter", mysql_error()); mysql_query("drop table $prefix"."_timelock"); mysql_query("create table $prefix"."_timelock(". "id int(10) not null AUTO_INCREMENT PRIMARY KEY,". "timestamp int(20) NOT NULL". ")")or error(__LINE__,__FILE__,"An error occurred while creating the table $prefix"."_timelock", mysql_error()); //--------------- Tabellen Inhalte erstellen --------------- $password=md5($password1); $date=date("Y-m-d H:i:s"); mysql_query("INSERT INTO $prefix"."_intern_users (user,pw,mail,regdate,groupid,news_in_send,news_in) VALUES ('$name','$password','$mail','$date','1','1','0')"); mysql_query("INSERT INTO $prefix"."_intern_groups (groupname,userlevel) VALUES ('Admin','xxxxxxxxxxxxxxx')"); mysql_query("INSERT INTO $prefix"."_timelock (timestamp) VALUES ('0')"); if($language_name=="German"){$lang_active_de="1";}else{$lang_active_de="0";} if($language_name=="English"){$lang_active_en="1";}else{$lang_active_en="0";} mysql_query("INSERT INTO $prefix"."_language (language_name,language_file,language_aktiv) VALUES ('German','lang_de.php','$lang_active_de')"); mysql_query("INSERT INTO $prefix"."_language (language_name,language_file,language_aktiv) VALUES ('English','lang_en.php','$lang_active_en')"); mysql_query("INSERT INTO $prefix"."_templates (aktiv,template_name,template_header,template_footer,template_news,template_com1,template_com2,template_mailto,template_sendnews,template_css) VALUES ('1','Standard','\n\n\n{css}\n\n','\n','{news_topic}\n{news_text}\n{news_date}\n{news_name}\n{news_mail}\n<br>{news_print}{news_com}{news_mailto}<br><br>','{com_aname}\n{com_amail}\n{com_adate}\n{com_acom}<br><br>','<center>\n<table>\n<tr><td width=\"80\">".$lang_inst_db_name.":</td><td>{com_name}</td></tr>\n<tr><td>".$lang_inst_db_mail.":</td><td>{com_mail}</td></tr>\n<tr><td valign=\"top\">".$lang_inst_db_com.":</td><td>{com_com}</td></tr>\n<tr><td height=\"22\"></td></tr>\n<tr><td></td><td>{com_button}</td></tr>\n</table>\n</center>','<center>\n<table>\n<tr><td width=\"120\">".$lang_inst_db_email.":</td><td>{mailto_email}</td></tr>\n<tr><td>".$lang_inst_db_yname.":</td><td>{mailto_yname}</td></tr>\n<tr><td>".$lang_inst_db_ymail.":</td><td>{mailto_ymail}</td></tr>\n<tr><td>".$lang_inst_db_subject.":</td><td>{mailto_subject}</td></tr>\n<tr><td valign=\"top\">".$lang_inst_db_info.":</td><td>{mailto_info}</td></tr>\n<tr><td height=\"14\"></td></tr>\n<tr><td></td><td>{mailto_button}</td></tr>\n</table>\n</center>','<center>\n<table>\n<tr><td width=\"120\">".$lang_inst_db_sname.":</td><td>{sendnews_name}</td></tr>\n<tr><td>".$lang_inst_db_smail.":</td><td>{sendnews_mail}</td></tr>\n<tr><td>".$lang_inst_db_stopic.":</td><td>{sendnews_topic}</td></tr>\n<tr><td>".$lang_inst_db_smsg.":</td><td>{sendnews_msg}</td></tr>\n<tr><td height=\"14\"></td></tr>\n<tr><td></td><td>{sendnews_button}</td></tr>\n</table>\n</center>','body\n{\nfont-family: Verdana;\nfont-size: 8pt;\nfont-weight:norm;\ncolor: #000000;\n}\ntd\n{\nfont-family: Verdana;\nfont-size: 8pt;\nfont-weight:norm;\ncolor: #000000;\n}\ntable\n{\nfont-family: Verdana;\nfont-size: 8pt;\nfont-weight:norm;\ncolor: #000000;\n}')"); mysql_query("INSERT INTO $prefix"."_newsticker (bgcolor,placeholder,plholdercolor,fontcolor,fontsize,fontface,fontbold,link_on_topic,scrollspeed,getnews,target) VALUES ('#FFFFFF','%2B%2B%2B','#999999','#000000','11','Verdana','1','1','2','10','_blank')"); mysql_query("INSERT INTO $prefix"."_rss (title,link,description,author,comments,numbernews) VALUES ('1','1','1','1','1','5')"); mysql_query("INSERT INTO $prefix"."_mail_sms (service_active) VALUES ('0')"); mysql_query("INSERT INTO $prefix"."_settings (show_html,show_latestnews,show_bbcode,show_topic,show_date,show_dateformat,show_smilies,show_writer,show_mail,show_archiv,show_sites,show_date_above,show_dateformat_above,show_cat,show_cat_img,show_cat_filter,show_att_mail,show_att_print,show_att_com,show_att_mail_k,show_att_print_k,show_att_com_k,show_att_com_count,show_search,show_sendnews,show_new,linkdescr,intro_date,intro_editor,intro_cat,how_show_news,how_show_latestnews,number_news_letters,number_news,number_latestnews,complete_news,mail_after_com,target_sendnews,target_com,target_friendmail,target_mail,target_archiv,author_mail,use_loginstuff,admin_number_links,admin_category,admin_write_html,admin_write_bbcode,admin_write_smilies,admin_write_announce,admin_write_queue,admin_write_user,admin_write_mail,admin_write_topic,admin_write_news,admin_write_upfile,admin_write_upimg,admin_edit_number,admin_file_ext,admin_file_size,admin_img_ext,admin_img_size,admin_img_url,layout_scheme,layout_scheme_rss,layout_scheme_ticker,ns_active,ns_deactivemsg,admin_loginsave) VALUES ('0','0','1','1','1','1','1','1','1','1','0','0','1','0','0','0','1','1','1','1','1','1','1','1','0','0','".$lang_inst_db_rl."','".$lang_inst_db_date.":','".$lang_inst_db_written.":','".$lang_inst_db_cat.":','0','1','400','10','10','1','0','0','0','0','0','0','0','1','0','0','0','1','1','1','1','1','1','1','1','1','1','10','zip|rar|ace','10240','gif|jpg|jpeg|png|bmp','2048','dl/images/','0','1','0','1','".$lang_inst_db_deactive."','$loginsave')"); mysql_query("INSERT INTO $prefix"."_layout (main_width,o_width,m_width,l_width,u_width,latest_width,bgc_topic,bgc_datum,bgc_name,bgc_cat,bgc_msg,bgc_latest,bgc_body,bgi_topic,bgi_datum,bgi_name,bgi_cat,bgi_msg,bgi_latest,bgi_body,bold_topic,border_o,border_main,border_main_l,border_u,border_latest,tc_topic,tc_datum,tc_name,tc_msg,tc_links,tc_cat,tc_dateabove,tc_other,tc_att,tc_latest,ts_topic,ts_datum,ts_name,ts_msg,ts_links,ts_cat,ts_dateabove,ts_other,ts_att,ts_latest,distance_o,distance_u,distance_lm,distance_latest,distance_box,font_family,arrangement_latest,arrangement) VALUES ('450px','450px','450px','160px','450px','200px','#F1F1F1','#F1F1F1','#FFFFFF','#FFFFFF','#F9F9F9','#F9F9F9','#FFFFFF','','','','','','','','1','#000000','#000000','#000000','#FFFFFF','#000000','#000000','#000000','#000000','#000000','#000000','#000000','#000000','#000000','#000000','#000000','11','11','11','11','11','11','11','11','11','11','0px','0px','5px','10px','1','Arial','4','1')"); mysql_query("INSERT INTO $prefix"."_smilies (smilie,file,aktiv) VALUES ( ':)','glad.gif','1'), ( ':-)','glad.gif','1'), ( ';)','wink.gif','1'), ( ';-)','wink.gif','1'), ( ':(','sad.gif','1'), ( ':-(','sad.gif','1'), ( ':super:','super.gif','1'), ( ':D','grin.gif','1'), ( ':-D','grin.gif','1'), ( ':lol:','lol.gif','1'), ( ':P','tongue.gif','1'), ( ':-P','tongue.gif','1'), ( ':ups:','ups.gif','1'), ( ':confuse:','confuse.gif','1'), ( ':angry:','angry.gif','1'), ( '8)','cool.gif','1'), ( '8-)','cool.gif','1'), ( ':gape:','gape.gif','1'), ( ':yes:','yes.gif','1'), ( ':no:','no.gif','1'), ( ':oehm:','oehm.gif','1'), ( ':awkward:','awkward.gif','1') "); //----------------- Installationsformular 3 ---------------- $inst0="set"; $inst1="set"; $inst2="set"; echo ""; } } //------ Tooltips ------- include("inc/admin_tooltips.php"); //----------------- Installationsformular 2 ----------------- if(($inst1 || $inst1_ok==1) && empty($inst2)) { $inst0="set"; $inst1="set"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo "

".$lang_inst_form_s3headline."

"; echo ""; echo "

"; echo ""; echo ""; if(!empty($error_log2)) { echo "

"; echo ""; echo ""; echo $error_log2; echo ""; echo ""; echo "

".$lang_inst_error_headline.":

"; } echo ""; echo ""; echo ""; echo ""; echo ""; $url_path=str_replace("\\","/",dirname(__FILE__)); $url_path=$_SERVER["SERVER_NAME"]."/".str_replace($_SERVER["DOCUMENT_ROOT"],"",$url_path); $url_path="http://".str_replace("//","/",$url_path); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

".$lang_inst_form_s3user.":
".$lang_inst_form_s3mail.":
".$lang_inst_form_s3pw.":
".$lang_inst_form_s3pwrepeat.":

".$lang_inst_form_s3path.":

".$lang_inst_form_s3cookies1.":	(".$lang_inst_form_s3cookies2.")
".$lang_inst_form_s3sessions1.":	(".$lang_inst_form_s3sessions2.")

"; echo "

"; } //----------------- Installationsformular 1 ----------------- if(($inst0 || $inst0_ok==1) && empty($inst1)) { $inst0="set"; echo ""; } //----------------- Installationsformular 0 ----------------- if(empty($inst0)) { echo "

"; echo ""; echo ""; echo ""; echo ""; echo "

Language - Configuration: Step 1

"; echo ""; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; //-------------------------------------------------------------------------------------------------- $file_config="settings/config.php"; $file_newsscript="newsscript.php"; ############################### $file_bin=substr(decbin(fileperms($file_config)), -9); $file_arr=explode(".", substr(chunk_split($file_bin, 1, "."), 0, 17)); $perms_config=""; $i=0; foreach ($file_arr as $this) { $file_char=($i%3==0 ? "r" : ($i%3==1 ? "w" : "x" )); $perms_config.=($this=="1" ? $file_char : "-") . ($i%3==2 ? " " : ""); $i++; } unset($file_bin);unset($file_arr);unset($file_char); //------------------------------------------------- $file_bin=substr(decbin(fileperms($file_newsscript)), -9); $file_arr=explode(".", substr(chunk_split($file_bin, 1, "."), 0, 17)); $perms_newsscript=""; $i=0; foreach ($file_arr as $this) { $file_char=($i%3==0 ? "r" : ($i%3==1 ? "w" : "x" )); $perms_newsscript.=($this=="1" ? $file_char : "-") . ($i%3==2 ? " " : ""); $i++; } ####################################################################################### if(substr($perms_config,1,1)!="w" || substr($perms_config,5,1)!="w" || substr($perms_config,9,1)!="w") { echo ""; $error_chmod="ok"; } else { echo ""; } //------------------------------------------------- if(substr($perms_newsscript,1,1)!="w" || substr($perms_newsscript,5,1)!="w" || substr($perms_newsscript,9,1)!="w") { echo ""; $error_chmod="ok"; } else { echo ""; } //-------------------------------------------------------------------------------------------------- echo "


	German
	English

	CHMOD for the file ".$file_config." must be set on \"777\"
	CHMOD for the file ".$file_config." is correct!
	CHMOD for the file ".$file_newsscript." must be set on \"777\"
	CHMOD for the file ".$file_newsscript." is correct!

"; echo ""; echo ""; echo "

"; if($error_chmod!="ok") { echo "\">"; } else { echo "You must set the right CHMODs to continue the installation. Explanation is in the readme.txt..."; } echo "

"; echo "