<?
$username="";
$password="";
$database="";
$mos_prefix="";



$missing = array();
$mos_users_temp=array();
$mos_users=array();
$mos_core_acl_aro_temp=array();
$mos_core_acl_aro=array();
$handle=mysql_connect("localhost","$username","$password");
mysql_select_db("$database");
$result = mysql_query("SELECT id FROM {$mos_prefix}users");
while ($mos_users_temp[] = mysql_fetch_assoc($result)){
$mos_users[] = $mos_users_temp[count($mos_users_temp) - 1]['id'];
}

$result=mysql_query("SELECT value FROM {$mos_prefix}core_acl_aro");
while($mos_core_acl_aro_temp[] = mysql_fetch_assoc($result)){
$mos_core_acl_aro[] = $mos_core_acl_aro_temp[count($mos_core_acl_aro_temp) - 1]['value'];
}

foreach ($mos_users as $value)
{
    if(!in_array($value,$mos_core_acl_aro))
        $missing[]=$value;
}

/*print_r($missing);
print_r($mos_users);
print_r($mos_core_acl_aro);*/
foreach($missing as $value)
{
    $result=mysql_query("SELECT name FROM {$mos_prefix}users WHERE id=$value");
    $name=mysql_fetch_assoc($result);
    $result=mysql_query("INSERT into {$mos_prefix}core_acl_aro (value, name) VALUES ($value,'$name[name]')");
}


$aro_id_temp=array();
$aro_id=array();
$aro_id_temp2=array();
$aro_id2=array();
$missing=array();
$result=mysql_query("SELECT aro_id FROM {$mos_prefix}core_acl_aro");
while ($aro_id_temp[] = mysql_fetch_assoc($result)){
$aro_id[] = $aro_id_temp[count($aro_id_temp) - 1]['aro_id'];
}

$result=mysql_query("SELECT aro_id FROM {$mos_prefix}core_acl_groups_aro_map");
while ($aro_id_temp2[] = mysql_fetch_assoc($result)){
$aro_id2[] = $aro_id_temp2[count($aro_id_temp2) - 1]['aro_id'];
}

foreach ($aro_id as $value)
{
        if(!in_array($value,$aro_id2))
                $missing[]=$value;
}

foreach($missing as $value)
{
       $result=mysql_query("INSERT into mos_core_acl_groups_aro_map (group_id, aro_id) VALUES (18,$value)");
}

print "done";
?>