@opensidex("Besked Notifikation","on");



echo "

 ".$locale['014'].number_format(dbcount("(user_id)", "users", "user_status<='1'")).

 "\n";



echo "


 Antal tilmeldte: ".number_format(dbcount("(user_id)", "messages_options", "(user_id>'0' and pm_email_notify ='1')" )).

"\n";



if (isset($_POST['notify_all']))

{



//Delete records from messages_options that do not have a related record in users:

function user_exists($user_id) {

      global $db_prefix;

      return (dbresult(dbquery("SELECT COUNT(*) FROM ".$db_prefix."users WHERE user_id='".$user_id."'"),0) == 1);

   }

   $result = dbquery("SELECT * FROM ".$db_prefix."messages_options");

   while ($data = dbarray($result)) {

      if (!user_exists($data['user_id']) && $data['user_id'] != 0) {

         $result2 = dbquery("DELETE FROM ".$db_prefix."messages_options WHERE user_id='".$data['user_id']."'");

      }

   }



// Set pm_email _notify for all who already have a record in messages_options:

$updres = dbquery("UPDATE ".$db_prefix."messages_options SET pm_email_notify = '1'");



// Insert records for all the rest...:

$allusers = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_name");

while ($notifdata = dbarray($allusers))

{



echo $notifdata['user_id'];

echo hej;



if (dbcount("(user_id)", "messages_options", "user_id='".$notifdata['user_id']."'") == "0")

{

$notifres = dbquery("INSERT INTO ".$db_prefix."messages_options

(user_id, pm_email_notify, pm_save_sent, pm_inbox, pm_savebox, pm_sentbox)

VALUES ('".$notifdata['user_id']."', '1', '1', '0', '0', '0')");

}

}



redirect(FUSION_SELF.(FUSION_QUERY ? "?".FUSION_QUERY : ""));

}



echo "

 Tryk på knappen herunder for at tilmelde alle brugere til Besked Notifikation











\n";



@closesidex();