} // 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
