<?php

$dbhost = "localhost";
$dbuser = "1234";
$dbpass = "1234";
$dbname = "1234";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname);

$qry = "SELECT * FROM ejabberdusers, WHERE added != 1";
$users = mysql_query($qry);

while($row = mysql_fetch_assoc($users)) {
        $username = $row['username'];
        $password = $row['password'];
        $exec = "/usr/sbin/ejabberdctl register ".$username." evsco.net ".$password;
        exec($exec);
        $exec2 = "/usr/sbin/ejabberdctl srg_user_add ".$username." evsco.net d00m evsco.net";
        exec($exec2);
        $fix = "UPDATE ejabberdusers SET added = 1 WHERE username = '".$username."' AND password = '".$password."'";
        mysql_query($fix);
}

mysql_close($conn);