[SOLVED] Script installer

[stelthius]

Hey guys, ive built my script installer, and then my script updater, im having a issue with the script updater, it always ads a second admin user is there anyway i could add in a check to see if there is already a username admin if so dont add a new username admin.

 

 

$admin_pass = md5($_POST['admin_pass']);
$query18 = "INSERT INTO `users` (`user_id`, `username`, `password`, `session_id`, `login_ip`, `last_activity`, `user_level`, `email_address`) VALUES
(1, '".$_POST['admin_user']."', '".$admin_pass."', 'NIL', 'NIL', 'NIL', '9', '".$_POST['admin_pass']."');";

 

With regards.

[Daniel0]

Well, yeah just run a query selecting users with that username. If the result set is empty the user doesn't exist and you can run your insertion query.

[stelthius]

Ah i was curious if it would be wise to throw in a if statement to check to see if admin existed if not add him but if he does dont add him as the installer runs multiple queries, thanks Dan

[stelthius]

So basicly i could do something like

 

 

     $query="SELECT * FROM users WHERE admin = '$admin'";
     $result=mysql_query($query) or die ("Query failed");

// This is the part were im stuck how would i go about adding in the admin is there code

if (  ) {
// Do nothing carry on finishing the query executions
} else {
$admin_pass = md5($_POST['admin_pass']);
        $query18 = "INSERT INTO `users` (`user_id`, `username`, `password`, `session_id`, `login_ip`, `last_activity`, `user_level`, `email_address`) VALUES
(1, '".$_POST['admin_user']."', '".$admin_pass."', 'NIL', 'NIL', 'NIL', '9', '".$_POST['admin_pass']."');
}

 

 

Sorry for the messy code was just threw together to try get an idea.

[Daniel0]

if (!mysql_num_rows(mysql_query("SELECT * FROM users WHERE username='admin' LIMIT 1"))) {
// insert user
}

[stelthius]

Ahhh so i dont need my top query in there at all thanks dan.

[Daniel0]

Well yeah, but I just consolidated it into a single statement.

[stelthius]

Yeah sorry i meant i dont need it in there if i do it how you did in the example code, thanks Dan