} // end of parse_input_fields ////////////////////////////////////////////////////////////////////// // // Function : validate_user_info // // Purpose : Validate user information // // Inputs : (none) // // Output : appropriate info // // Returns : nothing // // Example : validate_user_info(); // // Notes : (none) // ////////////////////////////////////////////////////////////////////// static public void validate_user_info() { if (!data_fields.ContainsKey("username")) { send_response(1, "username was not specified", ""); } string user_name = data_fields["username"].ToLower(); if (!data_fields.ContainsKey("password")) { send_response(1, "password was not specified", ""); } string pass = data_fields["password"]; if (!user_index.ContainsKey(user_name)) { send_response(1, user_name + " is not a valid username", ""); } int u_index = user_index[user_name]; current_user = UsersList[u_index]; if (current_user.password != pass) { send_response(1, "Invalid password specified for " + user_name, ""); } if (current_user.status != "active") { send_response(1, user_name + " is no longer an active user", ""); } return; } // end of validate_user_info
} // end of send_response ////////////////////////////////////////////////////////////////////// // // Function : read_smart_users_table // // Purpose : read in the smart_users table // // Inputs : (none) // // Output : appropriate messages // // Returns : nothing // // Example : read_smart_users_table(); // // Notes : Program execution is terminated upon database error // ////////////////////////////////////////////////////////////////////// static public void read_smart_users_table() { MySqlConnection conn = null; MySqlDataReader rdr = null; try { conn = new MySqlConnection(connect_string); conn.Open(); string query = @"SELECT id,mod_date,username, aes_decrypt(password,'pizza') password,first_name, last_name,email,phone,priv_level,balance1,balance,status, ifnull(comment,'--') comment FROM smart_users order by username" ; MySqlCommand cmd = new MySqlCommand(query, conn); rdr = cmd.ExecuteReader(); int num_users = 0; while (rdr.Read()) { num_users += 1; int id = rdr.GetInt32(0); string mod_date = rdr.GetString(1); string u_name = rdr.GetString(2); string password = rdr.GetString(3); string first_name = rdr.GetString(4); string last_name = rdr.GetString(5); string email = rdr.GetString(6); string phone = rdr.GetString(7); int priv_level = rdr.GetInt32(8); int balance1 = rdr.GetInt32(9); int balance = rdr.GetInt32(10); total_balance += balance; string status = rdr.GetString(11); string comment = rdr.GetString(12); SmartUser new_u = new SmartUser() { id = id, mod_date = mod_date, username = u_name, password = password, first_name = first_name, last_name = last_name, email = email, phone = phone, priv_level = priv_level, balance1 = balance1, balance = balance, status = status, comment = comment }; UsersList.Insert(num_users - 1, new_u); user_index.Add(u_name, num_users - 1); uid_to_name.Add(id, u_name); } // WHILE over smart_user records } catch (MySqlException ex) { send_response(1, "Can't read users table", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } } // finally return; } // end of read_smart_users_table