/** * 加载apache网站列表 */ public void load_apache_web() { dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; try { string sql = "select * from apacheweblist order by id desc"; SQLiteDataReader reader = DbHelperSQLite.ExecuteReader(sql); int count = dataGridView1.RowCount; if (count > 0) { for (int i = 0; i < count; i++) { dataGridView1.Rows.Clear(); } } while (reader.Read()) { DataGridViewRow row = new DataGridViewRow(); int index = this.dataGridView1.Rows.Add(row); this.dataGridView1.Rows[index].Cells[0].Value = reader["id"]; this.dataGridView1.Rows[index].Cells[1].Value = reader["domain"]; this.dataGridView1.Rows[index].Cells[2].Value = reader["port"]; this.dataGridView1.Rows[index].Cells[3].Value = reader["type"]; this.dataGridView1.Rows[index].Cells[4].Value = "编辑"; this.dataGridView1.Rows[index].Cells[5].Value = "删除"; } } catch (Exception ep) { } }
/** * 加载mysql数据库列表 */ public void load_mysql_list() { dataGridView2.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; try { string sql = "select * from `mysql` order by id desc"; SQLiteDataReader reader = DbHelperSQLite.ExecuteReader(sql); int count = dataGridView2.RowCount; if (count > 0) { for (int i = 0; i < count; i++) { dataGridView2.Rows.Clear(); } } while (reader.Read()) { Console.WriteLine(12321); DataGridViewRow row = new DataGridViewRow(); int index = this.dataGridView2.Rows.Add(row); this.dataGridView2.Rows[index].Cells[0].Value = reader["id"]; this.dataGridView2.Rows[index].Cells[1].Value = reader["dbname"]; this.dataGridView2.Rows[index].Cells[2].Value = reader["dbuser"]; this.dataGridView2.Rows[index].Cells[3].Value = reader["dbpass"];; this.dataGridView2.Rows[index].Cells[4].Value = "改密"; this.dataGridView2.Rows[index].Cells[5].Value = "删除"; this.dataGridView2.Rows[index].Cells[6].Value = "导入"; } }catch (Exception ep) { } }
private string recordID(string query, int passCount) { query = StringHelper.ReplaceBadSQL(query); string result = string.Empty; using (IDataReader dr = DbHelperSQLite.ExecuteReader(query)) { while (dr.Read()) { if (passCount < 1) { result += "," + dr.GetInt32(0); } passCount--; } } return(result.Substring(1)); }
public void setApacheConf(string domain, string domain2, string webindex, string port, string path, int https) { string rewrite = this.textBox5.Text; string gzip = checkBox2.Checked ? @" <IfModule deflate_module> SetOutputFilter DEFLATE DeflateCompressionLevel 6 AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript AddOutputFilter DEFLATE css|js|txt|xml|rss|html|htm Header append Vary User-Agent env=!dont-vary SetEnvIfNoCase Request_URI .(?:gif|jpe?g|png|bmp|tif|ico|eot|svg|ttf|woff)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:exe|t?gz|zip|7z|bz2|sit|rar|bin|iso)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:pdf|doc|docx|xls|xlsx|ppt|pptx)$ no-gzip dont-vary SetEnvIfNoCase Request_URI .(?:mov|flv|avi|mp3|mp4|rm|webm|ogv)$ no-gzip dont-vary </IfModule>" : ""; string proxy = checkBox4.Checked ? @" <Proxy *> Order deny,allow Allow from all </Proxy> ProxyPass " + this.textBox10.Text + @" " + this.textBox9.Text + @" ProxyPassReverse " + this.textBox10.Text + @" " + this.textBox9.Text + @"" : ""; string php_cgi = this.comboBox2.Text.Equals("PHP") ? @" FcgidInitialEnv PHPRC """ + Application.StartupPath.Replace("\\", "/") + @"/soft/php/php7.0.9nts/"" AddHandler fcgid-script .php FcgidWrapper """ + Application.StartupPath.Replace("\\", "/") + @"/soft/php/php7.0.9nts/php-cgi.exe"" .php " : ""; string conf = @" <VirtualHost *:" + port + @"> DocumentRoot """ + path + @""" ServerName " + domain + @" " + domain2 + @" ServerAlias " + php_cgi + @" " + gzip + @" " + proxy + @" <Directory """ + path + @"""> Options FollowSymLinks ExecCGI AllowOverride All Order allow,deny Allow from all Require all granted DirectoryIndex " + webindex + @" </Directory> </VirtualHost>"; string httpsconf = @" <VirtualHost *:443> DocumentRoot """ + path + @""" ServerName " + domain + @" " + domain2 + @" ServerAlias " + php_cgi + @" SSLEngine on SSLProtocol TLSv1 TLSv1.1 TLSv1.2 SSLCipherSuite HIGH:MEDIUM:!aNULL:!MD5 SSLCertificateFile """ + Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\ca.pem" + @""" SSLCertificateKeyFile """ + Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\private.key" + @""" " + proxy + @" <Directory """ + path + @"""> Options FollowSymLinks ExecCGI AllowOverride All Order allow,deny Allow from all Require all granted DirectoryIndex " + webindex + @" </Directory> </VirtualHost> "; if (this.checkBox3.Checked) { conf = conf + httpsconf; try { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain); System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\ca.pem", this.textBox6.Text, new System.Text.UTF8Encoding(false)); System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\ssl\\" + domain + @"\private.key", this.textBox8.Text, new System.Text.UTF8Encoding(false)); } catch (Exception ep) { Form1.form1.writeLog("创建HTTPS证书文件失败"); MessageBox.Show("创建HTTPS证书文件失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } try { System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\vhosts\\" + domain + "_" + port + ".conf", conf, new System.Text.UTF8Encoding(false)); string listen = "Listen 443\n"; string sql = "select * from apacheweblist group by port"; SQLiteDataReader reader = DbHelperSQLite.ExecuteReader(sql); while (reader.Read()) { listen += "listen " + reader["port"] + "\n"; } System.IO.File.WriteAllText(Application.StartupPath + "\\soft\\apache\\Apache24\\conf\\vhosts\\Listen.conf", listen, new System.Text.UTF8Encoding(false)); } catch (Exception e) { Form1.form1.writeLog("创建网站配置文件失败"); MessageBox.Show("创建网站配置文件失败!请删除后重试", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } string subPath = this.textBox3.Text.Trim(); if (false == System.IO.Directory.Exists(subPath)) { try { System.IO.Directory.CreateDirectory(subPath); } catch (Exception e) { Form1.form1.writeLog("创建根目录失败"); MessageBox.Show("创建根目录失败,请自行创建", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (!rewrite.Equals("")) { try { if (false == System.IO.Directory.Exists(subPath)) { System.IO.Directory.CreateDirectory(subPath); } System.IO.File.WriteAllText(this.textBox3.Text.Trim() + "\\.htaccess", rewrite, new System.Text.UTF8Encoding(false)); } catch (Exception e) { Form1.form1.writeLog("生成网站伪静态文件失败"); MessageBox.Show("生成网站伪静态文件失败!请自行创建", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }