private void check() { string s = ""; DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username from regname where isreg = 0;"; dt = conn.ExecuteDataTable(sql); //conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { s += dt.Rows[i]["username"].ToString() + " 的状态为:"; bool isThisUserUnique = webutil.checkUsernameReg(dt.Rows[i]["username"].ToString()); if (isThisUserUnique) { s += " 可以使用 "; sql = "update regname set isused = 0 where username = '******';"; conn.ExecuteScalar(sql); } else { s += " 已被注册 "; sql = "update regname set isused = 1 where username = '******';"; conn.ExecuteScalar(sql); } SetText("\r\n" + s); } }
public void BindData() { this.pictureBox1.Image = webutil.getCaptcha(); if (this.pictureBox1.Image == null) { this.pictureBox1.Image = webutil.getCaptcha(); } string s = ""; DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username from regname where isreg = 0 and isused = 0 limit 1;"; dt = conn.ExecuteDataTable(sql); conn.ExecuteDataTable(sql); this.textBox_name.Text = dt.Rows[0]["username"].ToString(); string id = Guid.NewGuid().ToString(); pictureBox1.Image.Save(System.Environment.CurrentDirectory + "\\Image\\" + id + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg); string temp = Marshal.PtrToStringAnsi(OCRpart(System.Environment.CurrentDirectory + "\\Image\\" + id + ".jpg", -1, 0, 0, 110, 50)); string newStr = ""; for (int i = 0; i < temp.Length; i++) { int tmp = (int)temp[i]; if ((tmp >= 65 && tmp <= 90) || (tmp >= 97 && tmp <= 122)) { newStr += temp[i]; } } this.textBox_captcha.Text = newStr; if (newStr.Length != 4) { BindControl(); } }
/// <summary> /// 测试数据库连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Splash_Load(object sender, EventArgs e) { try { SqlLiteConn conn = new SqlLiteConn(); conn.getConn(); } catch (Exception ex) { MessageBox.Show("数据库迷之消失:" + ex.Message); } return; }
private void button3_Click(object sender, EventArgs e) { DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sqlUpdate = " update regname set isreg = 1 , isused = 1 where username = '******'"; conn.ExecuteScalar(sqlUpdate, null); string sql = "select username from regname where isreg = 0 and isused = 0 limit 1;"; dt = conn.ExecuteDataTable(sql); conn.ExecuteDataTable(sql); this.textBox_name.Text = dt.Rows[0]["username"].ToString(); }
private void checkOldUser() { string s = ""; DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select account from acfunolduser "; dt = conn.ExecuteDataTable(sql); conn.ExecuteDataTable(sql); for (int i = 118132; i < dt.Rows.Count; i++) { // s += dt.Rows[i]["account"].ToString() + " 的uid为:"; string usercardString = webutil.getUserInfo(dt.Rows[i]["account"].ToString()); if (!usercardString.Contains("用户被封禁") && !usercardString.Contains("用户不存在")) { string uid = ""; Root root = (Root)JsonConvert.DeserializeObject(usercardString, typeof(Root)); if (root != null) { uid = root.getuserjson().getUid(); if (uid == "" || uid == null) { MessageBox.Show("空"); return; } else { //{"userjson":{"currExp":61,"stows":1,"comments":65,"gender":1,"level":22,"sign":"人家真的不搞基的。。","follows":0,"lastLoginDate":"2015-04-26 15:01:46.0","avatar":"http://static.acfun.mm111.net/dotnet/artemis/u/cms/www/201504/26143138p36q.jpg","posts":1,"followed":0,"lastLoginIp":"113.90.21.*","fans":0,"uid":1292228,"regTime":"2015-04-25 22:10:44.0","nextLevelNeed":100,"comeFrom":"","name":"一个不搞基的男孩子","dTime":"","expPercent":22,"isFriend":0,"views":0},"success":true} //更新基本信息 string usersign = ""; if (root.getuserjson().getSign() != null) { usersign = root.getuserjson().getSign().Replace("\'", ""); } string sign = " sign='" + usersign + "',"; //sign = sign.Replace("\'", ""); sql = "update acfunolduser set userid = " + uid + ",id = " + i + ", currexp = " + root.getuserjson().getCurrExp() + ", level = " + root.getuserjson().getLevel() + " ,follows=" + root.getuserjson().getFollows() + " ,lastlogindate= '" + root.getuserjson().getLastLoginDate() + "',stows=" + root.getuserjson().getStows() + " ,comments=" + root.getuserjson().getComments() + " ,gender=" + root.getuserjson().getGender() + " ," + sign + " avatar='" + root.getuserjson().getAvatar() + "' ,posts=" + root.getuserjson().getPosts() + " ,followed=" + root.getuserjson().getFollowed() + " ,lastloginip='" + root.getuserjson().getLastLoginIp() + "' ,fans=" + root.getuserjson().getFans() + " ,regTime='" + root.getuserjson().getRegTime() + "' ,nextlevelneed=" + root.getuserjson().getNextLevelNeed() + " ,comefrom= '" + root.getuserjson().getComeFrom() + "',dtime='" + root.getuserjson().getDTime() + "' ,exppercent=" + root.getuserjson().getExpPercent() + " ,isfriend=" + root.getuserjson().getIsFriend() + " ,views=" + root.getuserjson().getViews() + " " + " where account = '" + dt.Rows[i]["account"].ToString() + "';"; conn.ExecuteScalar(sql); //更新uid s = uid; SetText("\n" + s); } } } } }
/// <summary> /// reg /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string mail = textBox_mail.Text.Trim(); webutil.regQianmo(mail, "153037"); label_STATUS.Text = "ok"; SqlLiteConn conn = new SqlLiteConn(); string sql = "INSERT INTO qianmo ( username , mail , password , nickname , id , userid , isactive , isnamereg ) VALUES ('" + mail + "', ' ', '153037', '', NULL, NULL, '0.0', '0.0');"; conn.ExecuteScalar(sql, null); button1.Enabled = false; button2.Enabled = false; button3.Enabled = true; button4.Enabled = false; }
private void checkIn() { MessageBox.Show("check in start"); DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username,userpassword from user ;"; dt = conn.ExecuteDataTable(sql); conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { string s = webutil.login(dt.Rows[i]["username"].ToString(), dt.Rows[i]["userpassword"].ToString()); string s1 = webutil.checkIn(webutil.cookiec); Thread.Sleep(20000); } MessageBox.Show("check in success!"); }
private void throwBananaStart() { MessageBox.Show("banana throw start"); DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username,userpassword,userid from user ;"; dt = conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { //string s = webutil.login(dt.Rows[i]["username"].ToString(), dt.Rows[i]["userpassword"].ToString()); string userid = dt.Rows[i]["userid"].ToString(); string s1 = webutil.throwBanana(acNo, banCount, userid, webutil.RestoreCookie(dt.Rows[i]["username"].ToString())); Thread.Sleep(1000); } MessageBox.Show("banana OK"); }
//检查是否被占用 private void button2_Click(object sender, EventArgs e) { label_STATUS.Text = "用户名可用性检测中"; DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username from regname ;"; dt = conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { if (webutil.checkQianmoName(dt.Rows[i]["username"].ToString())) { string sqlUpdate = " update regname set isused = 1 where username = '******'"; conn.ExecuteScalar(sqlUpdate, null); } } label_STATUS.Text = "用户名可用性检测完成"; }
/// <summary> /// 测试数据库连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Splash_Load(object sender, EventArgs e) { try { SqlLiteConn conn = new SqlLiteConn(); conn.getConn(); } catch (Exception ex) { MessageBox.Show("数据库迷之消失:" + ex.Message); } finally { string connstring = "Data Source=" + System.Environment.CurrentDirectory + "\\DB\\article.db"; System.Data.SQLite.SQLiteConnection.CreateFile(connstring); } return; }
/// <summary> /// 检查是否为第一次使用和是否有id记录 /// </summary> /// <returns></returns> public void checkUserId() { bool isUserIdRec = false; SqlLiteConn conn = new SqlLiteConn(); DataTable dt = conn.GetSchema(); if (dt.Rows.Count > 0) { //是否有记录 SQLiteParameter[] pars = new SQLiteParameter[] { new SQLiteParameter("", "") }; string sql = "select count() from user where id >0"; SQLiteDataReader r = conn.ExecuteReader(sql, pars); if (r.Read() && (r.GetInt32(0) > 0)) { r.Close(); isUserIdRec = true; } else { isUserIdRec = false; } } else { //空数据库初始化 string sql = @" DROP TABLE IF EXISTS 'main'.'user'; CREATE TABLE 'user' ( 'id' INTEGER NOT NULL, 'userid' INTEGER, 'username' TEXT NOT NULL, 'userpassword' TEXT NOT NULL, 'moni' REAL, PRIMARY KEY ('id') );"; conn.ExecuteNonQuery(sql); } if (!isUserIdRec) { login loginform = new login(); loginform.Show(); } }
/// <summary> /// 测试数据库连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataLoad() { try { SqlLiteConn conn = new SqlLiteConn(); conn.getConn(); } catch (Exception ex) { string dblocation = System.Environment.CurrentDirectory + "\\DB\\article.db"; string connstring = "Data Source=" + System.Environment.CurrentDirectory + "\\DB\\article.db"; //System.Data.SQLite.SQLiteConnection.CreateFile(dblocation); MessageBox.Show("数据库迷之消失:" + ex.Message); } finally { } return; }
/// <summary> /// reg /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { label_STATUS.Text = "Name set start"; string s = webutil.loginQianmo(textBox_mail.Text.Trim(), textBox_pwd.Text.Trim()); if (webutil.setQianmoName(textBox_name.Text.Trim(), webutil.cookiec)) { SqlLiteConn conn = new SqlLiteConn(); string sql = "update qianmo set nickname='" + textBox_name.Text + "',isnamereg =1.0 where username = '******';"; conn.ExecuteScalar(sql, null); string sqlUpdate = " update regname set isused = 1 where username = '******'"; conn.ExecuteScalar(sqlUpdate, null); label_STATUS.Text = "Name set ok"; BindData(); } else { MessageBox.Show("error!"); } }
/// <summary> /// reg /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string s = webutil.regNewUser(textBox_mail.Text.Trim(), textBox_name.Text.Trim(), textBox_pwd.Text.Trim(), textBox_invite.Text, textBox_captcha.Text.Trim(), webutil.cookiec); if (!s.Contains("false")) { string sqlInsert = "insert into user (username,userpassword,mailbox) values('" + textBox_name.Text + "','" + textBox_pwd.Text + "','" + textBox_mail.Text + "');"; SqlLiteConn conn = new SqlLiteConn(); string sqlUpdate = " update regname set isreg = 1 , isused = 1 where username = '******'"; conn.ExecuteScalar(sqlUpdate, null); conn.ExecuteScalar(sqlInsert, null); MessageBox.Show(s); BindControl(); this.textBox_mail.Text = ""; } else { MessageBox.Show(s); } }
public void BindData() { DataTable dtname = null; DataTable dtmail = null; SqlLiteConn conn = new SqlLiteConn(); string sqlname = "select username from regname where isreg = 0 and isused = 0 limit 1;"; string sqlmail = "select username from qianmo where isnamereg = 0 limit 1;"; dtname = conn.ExecuteDataTable(sqlname); dtmail = conn.ExecuteDataTable(sqlmail); if (dtname.Rows.Count == 0) { MessageBox.Show("error! username count is 0"); return; } else if (dtmail.Rows.Count == 0) { MessageBox.Show("error! mail count is 0"); return; } this.textBox_name.Text = dtname.Rows[0]["username"].ToString(); this.textBox_mail.Text = dtmail.Rows[0]["username"].ToString(); string id = Guid.NewGuid().ToString(); }