Failed sending email :: PHP :: en SMTP

diedhert · Bericht door **diedhert** » 01 jan 2007, 17:40

Ik heb de MOD Account Activation overview staan (http://www.phpbbhacks.com/download/483).

Als ik de lijst Inactive users gebruik, kan ik een voor een personen verwijderen. Als ik er echter meerdere tegelijkertijd wil deleten, krijg ik de volgende fout.

Failed sending email :: PHP ::

DEBUG MODE

Line : 234
File : emailer.php

Vroeger heeft dit wel nog gewerkt.

Ik heb op wiki gelezen dat het iets te maken heeft met SMTP of zo. Als ik in confirguratie SMTP op yes zet, maar in de SMTP server address (en login en paswoord) niets want dat weet ik niet ... krijg ik een andere fout (misschien logisch dus).

Dus ... hoe weet je wat daar moet staan ?

Bericht door **Paul** » 01 jan 2007, 18:03

Even het hele wiki artikel lezen

diedhert · Bericht door **diedhert** » 01 jan 2007, 18:31

Ik heb de smtp address gevonden van de plaats waar de site en het forum opstaat.

Ik krijg nu volgende foutmelding.

Ran into problems sending Mail. Response: 535 Error: authentication failed

DEBUG MODE

Line : 132
File : smtp.php

Nochthans is login en paswoord 100% zeker juist ingevuld ....

Als ik die van mijn ISP (telenet) neem, krijg ik

Ran into problems sending Mail. Response: 503 Error: authentication not enabled

DEBUG MODE

Line : 126
File : smtp.php

Iemand een idee wat fout is ?

vreemd genoeg: als ik mijn forum op Subsilver zet (standaard stijl), dan werkt alles zonder problemen !!!!!!! (dus die initiële fout - eerste melding - heb ik daar niet).

aswnl · Bericht door **aswnl** » 01 jan 2007, 22:49

diedhert schreef:Failed sending email :: PHP ::

DEBUG MODE

Line : 234
File : emailer.php

Dezelfde fout komt op mijn forum na de upgrade naar 2.0.22 regelmatig voor - alleen niet bij het zenden van emails, maar simpelweg bij het plaatsen van een posting. Het vreemde is echter: de fout komt niet altijd voor. Waarschijnlijk alleen bij replies op postings waarvan de gebruiker de email-notification aan heeft staan.

Waar kan ik dat wiki-bericht dat Paul bedoelt precies vinden ?

aswnl · Bericht door **aswnl** » 01 jan 2007, 23:01

Laat maar, ik heb de wiki al gevonden.

Wel achterlijk dat dit nu niet meer werkt, daar waar het tot op heden altijd prima werkte

diedhert · Bericht door **diedhert** » 01 jan 2007, 23:17

ik heb op phpbb.com gelezen dat het een probleem is van de MOD ....

Ramon Fincken · Bericht door **Ramon Fincken** » 01 jan 2007, 23:43

weet je welke versie je hebt "toevallig" ?

ik heb een custom fix voor de inactive users list ( admin )

diedhert · Bericht door **diedhert** » 02 jan 2007, 07:57

de versie weet ik niet, maar de bestanden in het Zip filtje dateren van 14/09/2004.

Ramon Fincken · Bericht door **Ramon Fincken** » 02 jan 2007, 09:27

ik heb er een die wat meer info laat zien ( ook website ) en geen email verstuurt als je iemand delete.
Dit omdat
a) de persoon toch inactief is
b) je vaak te maken hebt met niet bestaande servers en/of cashette servers

diedhert · Bericht door **diedhert** » 02 jan 2007, 11:17

heel tof heel tof ... maar zou je die kunnen doormailen, of zeggen waar ze ergens te vinden is ?

Ramon Fincken · Bericht door **Ramon Fincken** » 05 jan 2007, 14:11

/admin/admin_users_inactive.php

Code: Selecteer alles

<?php
/***************************************************************************
 *                            admin_users_inactive.php
 *                            -------------------
 *   begin                : Tuesday, Sep 19, 2003
 *   copyright            : (C) 2003 Sko22
 *   email                : sko22@quellicheilpc.it
 *
 *   $Id: admin_users_inactive.php,v 1.1.8 2005/03/14 10:30:30 sko22
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if ( !empty($setmodules) )
{
   $filename = basename(__FILE__);
   $module['Users']['Users_Inactive'] = $filename;

   return;
}


     


//
// Load default header
//
$phpbb_root_path = './../';
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
require($phpbb_root_path . 'includes/emailer.'.$phpEx);

//
// Set default email variables
//
$script_name = preg_replace('/^\/?(.*?)\/?$/', '\1', trim($board_config['script_path']));
$script_name = ( $script_name != '' ) ? $script_name . '/profile.'.$phpEx : 'profile.'.$phpEx;
$server_name = trim($board_config['server_name']);
$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
$server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';
$server_url = $server_protocol . $server_name . $server_port . $script_name;

//
// Set default color variables
//
$alert_color = "#00FF00";
$alert_color2 = "#FFFF00";
$alert_color3 = "#FFCC00";
$alert_color4 = "#FF9900";
$alert_color5 = "#FF6600";
$alert_color_over = "#FF0000";
 
//Beginning Inactive Users

$lang['Users_Inactive'] = 'Inactive Users';
$lang['Users_Inactive_Explain'] = 'If in "Enable account activation" you have selected "User" or "Admin", in this list you will have the Users who have never been activated.<br /><br />By clicking on "Contact" you will send a contact e-mail to all the selected Users.<br />By clicking on "Activate" you will activate all the selected Users.<br />By clicking on "Delete" you will send an e-mail and delete all the selected Users.';
$lang['UI_Check_None'] = '"Enable account activation" is on <b>None</b>.';
$lang['UI_Check_User'] = '"Enable account activation" is on <b>User</b>';
$lang['UI_Check_Admin'] = '"Enable account activation" is on <b>Admin</b>.';
$lang['UI_Check_Recom'] = '%sChange it%s.';
$lang['UI_Removed_Users'] = 'Removed Users';
$lang['UI_User'] = 'User';
$lang['UI_Registration_Date'] = 'Registration Date';
$lang['UI_Last_Visit'] = 'Last Visit';
$lang['UI_Active'] = 'Active';
$lang['UI_Email_Sents'] = 'Email Sents';
$lang['UI_Last_Email_Sents'] = 'Last Email';
$lang['UI_CheckColor'] = 'Check';
$lang['UI_CheckAll'] = 'Check All';
$lang['UI_UncheckAll'] = 'Uncheck All';
$lang['UI_InvertChecked'] = 'Invert Checked';
$lang['UI_Contact_Users'] = 'Contact';
$lang['UI_Delete_Users'] = 'Delete';
$lang['UI_Activate_Users'] = 'Activate';
$lang['UI_select_user_first'] = 'You must to select a User before';
$lang['UI_return'] = 'Click %sHere%s to return to the Inactive Users';
$lang['UI_Deleted_Users'] = 'The Users has been removed';
$lang['UI_Activated_Users'] = 'The Users has been actived';
$lang['UI_Alert_Days'] = "days";
$lang['UI_with_zero_messages'] = "with zero messages";
$lang['UI_Alert_Every'] = "Every";
$lang['UI_Alert_UpTo'] = "Up to";
$lang['UI_Alert_Over'] = "Over";

//End Inactive Users

if(!isset($HTTP_POST_VARS['inactive_users_do']))
{

   $alert_days = ( !empty($HTTP_POST_VARS['alert_days']) ) ? ( intval($HTTP_POST_VARS['alert_days']) != 0 ? intval($HTTP_POST_VARS['alert_days']) : 5 ) : 5;
   $zero_messages = isset( $HTTP_POST_VARS['zero_messages'] ) ? "checked" : "";

   $template->set_filenames(array(
      'body' => 'admin/user_inactive_body.tpl')
   );

   //
   //Select Inactive Users
   //
   $sql_zero_messages = ( $zero_messages == "checked" ) ? 'OR user_posts = 0' : '' ;
   $sql = "SELECT user_id, username, user_lastvisit, user_regdate, user_posts, user_email, user_website, user_active, user_inactive_emls, user_inactive_last_eml FROM " . USERS_TABLE . " WHERE ( user_active = 0 AND user_actkey <> '' $sql_zero_messages ) AND user_id <> " . ANONYMOUS . " AND user_level = 0 ORDER BY user_regdate ASC";

   if( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain list of inactive users', '', __LINE__, __FILE__, $sql);
   }

   $i = 0;
   while( $row = $db->sql_fetchrow($result) )
   {
      $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

      // 60s*60m*24h*Xgg*
      $past_days = time() - $row['user_regdate'];
      switch ($past_days) {
         case ( $past_days <=  (60*60*24*$alert_days) ):
            $row_class_alert = $alert_color;
            $id_name = "alert";
         break;
         
         case ( $past_days <=  (60*60*24*$alert_days*2) ):
            $row_class_alert = $alert_color2;
            $id_name = "alert2";
         break;
         
         case ( $past_days <=  (60*60*24*$alert_days*3) ):
            $row_class_alert = $alert_color3;
            $id_name = "alert3";
         break;
         
         case ( $past_days <=  (60*60*24*$alert_days*4) ):
            $row_class_alert = $alert_color4;
            $id_name = "alert4";
         break;
         
         case ( $past_days <=  (60*60*24*$alert_days*5) ):
            $row_class_alert = $alert_color5;
            $id_name = "alert5";
         break;

         default:
            $row_class_alert = $alert_color_over;
            $id_name = "alert_over";
      }

      $last_user_visit = ( $row['user_lastvisit'] == 0 ) ?  "- -" : create_date($lang['DATE_FORMAT'], $row['user_lastvisit'], $board_config['board_timezone']);
      $last_email_sents = ( $row['user_inactive_last_eml'] == 0 ) ? "- -" : create_date($lang['DATE_FORMAT'], $row['user_inactive_last_eml'], $board_config['board_timezone']);

      $email_uri = ( $board_config['board_email_form'] ) ? append_sid("profile.$phpEx?mode=email&" . POST_USERS_URL .'=' . $row['user_id']) : 'mailto:' . $row['user_email'];

      $template->assign_block_vars("Table_InactiveUsers", array(
         "ROW_CLASS" => $row_class,
         "ROW_CLASS_ALERT" => $row_class_alert,
         "NUMBER" => $i +1,
         
         "USERNAME" => $row['username'],
         "EMAIL_IMG" => $row['user_email'].'<br /><a href="' . $email_uri . '"><img src="../' . $images['icon_email'] . '" alt="' . $row['user_email'] . '" title="' . $row['user_email'] . '" border="0" /></a><br/><span style="font-size: 7pt">'.$row['user_website'].'</span>',

         "USER_REGDATE" => create_date($lang['DATE_FORMAT'], $row['user_regdate'], $board_config['board_timezone']),
         "USER_LASTVISIT" => $last_user_visit,
         "USER_ACTIVE" => ( $row['user_active'] != 0 ) ? $lang['Yes'] : $lang['No'],
         "USER_POSTS" => $row['user_posts'],
         "USER_EMAIL_SENTS" => $row['user_inactive_emls'],
         "USER_LAST_EMAIL_SENTS" => $last_email_sents,
         
         'U_USERNAME' => append_sid('admin_users.' . $phpEx . '?mode=edit&username=' . $row['username']),

         "S_SELECT_TABLE" => "<input type=\"checkbox\" id=\"" . $id_name . "\" name=\"selected_usr[]\" value=\"" . $row['user_id'] . "\">"
         )
      );

      $i++;
   }

   if ( $i != 0 )
   {
      $js_script = "
      <script language=\"JavaScript\">
      // I have copied and modified a script of phpMyAdmin.net
      <!--
      function setCheckboxes(the_form, do_check)
      {
      var elts = (typeof(document.forms[the_form].elements['selected_usr[]']) != 'undefined') 
      ? document.forms[the_form].elements['selected_usr[]'] 
      : document.forms[the_form].elements = '';

      var elts_cnt  = (typeof(elts.length) != 'undefined') ? elts.length : 0;

      if (elts_cnt) {
         for (var i = 0; i < elts_cnt; i++) {
            if (do_check == \"invert\"){
            elts[i].checked == true ? elts[i].checked = false : elts[i].checked = true;
            } else {
            elts[i].checked = do_check;
            }
            } // end for
         } else {
            elts.checked = do_check;
         } // end if... else

      return true;
   }

   function selColor(the_form, color)
   {
      var ids = document.forms[the_form].elements[color].length;
      for (var i = 0; i < ids; i++)
      {
         document.forms[the_form].elements[color][i].checked = true;
      }
   }
   //-->
   </script>";
}
else
{
   $js_script = "
   <script language=\"JavaScript\">
   <!--
   function setCheckboxes(the_form, do_check)
   {

   }
   //-->
   </script>";
}

//
//Check Enable account activation
//
switch ( $board_config['require_activation'] ) {
    case 0:
        $check_enable_account_activation = $lang['UI_Check_None'];
        $recom_acc_act = sprintf($lang['UI_Check_Recom'], "<a href=\"" . append_sid("admin_board.php") . "\">", "</a>");
        break;
    case 1:
        $check_enable_account_activation = $lang['UI_Check_User'];
        break;
    case 2:
        $check_enable_account_activation = $lang['UI_Check_Admin'];
        break;
}



$template->assign_vars(array(
   "L_USERS_INACTIVE" => $lang['Users_Inactive'],
   "L_CHECK_ENABLE_ACCOUNT_ACTIVATION" => $check_enable_account_activation,
   "L_RECOM_ACC_ACTIV" => $recom_acc_act,
   "L_REMOVED_USERS" => $lang['UI_Removed_Users'],
   "L_USERS_INACTIVE_EXPLAIN" => $lang['Users_Inactive_Explain'],
   "L_USER" => $lang['UI_User'],
   "L_EMAIL" => $lang['Email'],
   "L_REGISTRATION_DATE" => $lang['UI_Registration_Date'],
   "L_LAST_VISIT" => $lang['UI_Last_Visit'],
   "L_ACTIVE" => $lang['UI_Active'],
   "L_POSTS" => $lang['Posts'],
   "L_EMAIL_SENTS" => $lang['UI_Email_Sents'],
   "L_LAST_EMAIL_SENTS" => $lang['UI_Last_Email_Sents'],
   "L_CHECKCOLOR" => $lang['UI_CheckColor'],
   "L_CHECKALL" => $lang['UI_CheckAll'],
   "L_UNCHECKALL" => $lang['UI_UncheckAll'],
   "L_INVERTCHECKED" => $lang['UI_InvertChecked'],
   "L_CONTACT_USERS" => $lang['UI_Contact_Users'],
   "L_DELETE_USERS" => $lang['UI_Delete_Users'],
   "L_ACTIVATE_USERS" => $lang['UI_Activate_Users'],
   "L_ALERT_DAYS" => $lang['UI_Alert_Days'],
   "L_WITH_ZERO_MESSAGES" => $lang['UI_with_zero_messages'],
   "L_ALERT_EVERY" => $lang['UI_Alert_Every'],
   "L_ALERT_UPTO" => $lang['UI_Alert_UpTo'],
   "L_ALERT_OVER" => $lang['UI_Alert_Over'],
   "L_POST" => $lang['Post'],

   "REMOVED_USERS" => $board_config['removed_users'],

   "ALERT_COLOR" => $alert_color,
   "ALERT_COLOR2" => $alert_color2,
   "ALERT_COLOR3" => $alert_color3,
   "ALERT_COLOR4" => $alert_color4,
   "ALERT_COLOR5" => $alert_color5,
   "ALERT_COLOR_OVER" => $alert_color_over,

   "ALERT_DAYS" => $alert_days,
   "ALERT_DAYS2" => $alert_days*2,
   "ALERT_DAYS3" => $alert_days*3,
   "ALERT_DAYS4" => $alert_days*4,
   "ALERT_DAYS5" => $alert_days*5,
   "ALERT_DAYS_OVER" => (($alert_days*5)+1),

   "JS_SCRIPT" => $js_script,

   "S_ALERT_DAYS" => $alert_days,
   "S_ZERO_MESSAGES" => $zero_messages,
   "S_INACTIVE_ACTION" => append_sid('admin_users_inactive.' . $phpEx)
   )
);

$template->pparse('body');

} 

else
   
{

switch ($HTTP_GET_VARS['mode']) {

   
   case "contact":
   
   if ( $HTTP_POST_VARS['selected_usr'] != "")
   {
   
   $date = time();

   //
   //Contact to Inactive Users
   //
   foreach ($HTTP_POST_VARS['selected_usr'] as $to_userdata)
   {

      //
      //Update email sends to Inactive Users
      //
      $sql = "UPDATE " . USERS_TABLE . " SET user_inactive_emls = user_inactive_emls+1, user_inactive_last_eml = $date WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;
      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not update emails sends to inactive users', '', __LINE__, __FILE__, $sql);
      }

      //
      //Email to send to Inactive Users
      //
      $sql = "SELECT username, user_lang, user_email, user_actkey FROM " . USERS_TABLE . " WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;

      if ( $result = $db->sql_query($sql) )
      {
         $userdata = $db->sql_fetchrow($result);
         $emailer = new emailer($board_config['smtp_delivery']);

      if ( substr($board_config['version'], -1) <= 4)
         { 
            $email_headers = "From: " . $board_config['board_email'] . "\nReturn-Path: " . $board_config['board_email'] . "\n";
            $emailer->extra_headers($email_headers);
         }
         else 
         {
            $emailer->from($board_config['board_email']);
            $emailer->replyto($board_config['board_email']);
         }

         $emailer->use_template('user_inactive_contact', $userdata['user_lang']);
         $emailer->email_address($userdata['user_email']);
                     
         $emailer->assign_vars(array(
            "USERNAME" => $userdata['username'], 
            "SITENAME" => $board_config['sitename'],
            "EMAIL_SIG" => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '',
            "U_ACTIVE_REGISTRATION" => $server_url . '?mode=activate&' . POST_USERS_URL . '=' . $to_userdata . '&act_key=' . $userdata['user_actkey'],            
            "U_ACTIVATE2"=> $server_url . '?mode=activate&' . POST_USERS_URL . '=' . $to_userdata . '&act_key=' . $userdata['user_actkey'] .'&eow='.$userdata['user_actkey']           
            )
            );

            $emailer->send();
            $emailer->reset();

      } else {

      message_die(GENERAL_ERROR, 'Could not sends emails to inactive users', '', __LINE__, __FILE__, $sql);

      }
   }

      $message = $lang['Message_sent']  . "." . 
         "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
         "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);

      } 
      
      else 
      
      {
      
      $message = $lang['UI_select_user_first']  . "." .
      "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
      "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);
      
      }

      break;



   case "activate":
   
   if ( $HTTP_POST_VARS['selected_usr'] != "")
   {
   
   //
   //Activate Users
   //
   foreach ($HTTP_POST_VARS['selected_usr'] as $to_userdata)
   {

      $sql = "UPDATE " . USERS_TABLE . " SET user_active = 1, user_actkey = '' WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql_update);
      }

      //
      //Email to send to Inactive Users
      //
      $sql = "SELECT username, user_lang, user_email FROM " . USERS_TABLE . " WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;

      if ( $result = $db->sql_query($sql) )
      {
         $userdata = $db->sql_fetchrow($result);
         $emailer = new emailer($board_config['smtp_delivery']);

      if ( substr($board_config['version'], -1) <= 4)
         { 
            $email_headers = 'From: ' . $board_config['board_email'] . "\nReturn-Path: " . $board_config['board_email'] . "\n";
            $emailer->extra_headers($email_headers);
         }
         else 
         {
            $emailer->from($board_config['board_email']);
            $emailer->replyto($board_config['board_email']);
         }

         $emailer->use_template('admin_welcome_activated', $userdata['user_lang']);
         $emailer->email_address($userdata['user_email']);
                  
         $emailer->assign_vars(array(
            'SITENAME' => $board_config['sitename'], 
            'USERNAME' => $userdata['username'],
            'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '')
         );
         $emailer->send();
         $emailer->reset();

      } else {

      message_die(GENERAL_ERROR, 'Could not sends emails to activate users', '', __LINE__, __FILE__, $sql);

      }

   }

      $message = $lang['UI_Activated_Users']  . "." . 
         "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
         "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);

      } 
      
      else 
      
      {
      
      $message = $lang['UI_select_user_first']  . "." .
      "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
      "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);
      
      }

      break;



   case "delete":
      
      if ( $HTTP_POST_VARS['selected_usr'] != "")
      {
      
      //
      //Delete Inactive Users
      //
      $rem_users = 0;
      foreach ($HTTP_POST_VARS['selected_usr'] as $to_userdata)
      {
         
      //
      //Email to send to Inactive Users
      //
      $sql = "SELECT username, user_lang, user_email FROM " . USERS_TABLE . " WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;

      if ( $result = $db->sql_query($sql) )
      {
         $userdata = $db->sql_fetchrow($result);
         $emailer = new emailer($board_config['smtp_delivery']);

      if ( substr($board_config['version'], -1) <= 4)
         { 
            $email_headers = 'From: ' . $board_config['board_email'] . "\nReturn-Path: " . $board_config['board_email'] . "\n";
            $emailer->extra_headers($email_headers);
         }
         else 
         {
            $emailer->from($board_config['board_email']);
            $emailer->replyto($board_config['board_email']);
         }
/*
         $emailer->use_template('user_inactive_delete', $userdata['user_lang']);
         $emailer->email_address($userdata['user_email']);
                     
         $emailer->assign_vars(array(
            'USERNAME' => $userdata['username'], 
            'SITENAME' => $board_config['sitename'],
            'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '',
            'U_REGISTER' => $server_protocol . $server_name . $server_port . $script_name . "?mode=register"
            )
            );

            $emailer->send();
*/
            $emailer->reset();

      } else {

      message_die(GENERAL_ERROR, 'Could not sends emails to inactive users', '', __LINE__, __FILE__, $sql);

      }

      $sql = "DELETE FROM " . USERS_TABLE . " WHERE user_id=$to_userdata AND user_id <> " . ANONYMOUS ;
      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not delete inactive users', '', __LINE__, __FILE__, $sql);
      }

         $sql = "SELECT g.group_id
            FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g  
            WHERE ug.user_id = $to_userdata 
               AND g.group_id = ug.group_id 
               AND g.group_single_user = 1";
         if( !($result = $db->sql_query($sql)) )
         {
            message_die(GENERAL_ERROR, 'Could not obtain group information for this user', '', __LINE__, __FILE__, $sql);
         }

         $row = $db->sql_fetchrow($result);
         
         $sql = "UPDATE " . POSTS_TABLE . "
            SET poster_id = " . DELETED . ", post_username = '$username' 
            WHERE poster_id = $to_userdata";
         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not update posts for this user', '', __LINE__, __FILE__, $sql);
         }

         $sql = "UPDATE " . TOPICS_TABLE . "
            SET topic_poster = " . DELETED . " 
            WHERE topic_poster = $to_userdata";
         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not update topics for this user', '', __LINE__, __FILE__, $sql);
         }
         
         $sql = "UPDATE " . VOTE_USERS_TABLE . "
            SET vote_user_id = " . DELETED . "
            WHERE vote_user_id = $to_userdata";
         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not update votes for this user', '', __LINE__, __FILE__, $sql);
         }
         
         $sql = "SELECT group_id
            FROM " . GROUPS_TABLE . "
            WHERE group_moderator = $to_userdata";
         if( !($result = $db->sql_query($sql)) )
         {
            message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
         }
         
         while ( $row_group = $db->sql_fetchrow($result) )
         {
            $group_moderator[] = $row_group['group_id'];
         }
         
         if ( count($group_moderator) )
         {
            $update_moderator_id = implode(', ', $group_moderator);
            
            $sql = "UPDATE " . GROUPS_TABLE . "
               SET group_moderator = " . $userdata['user_id'] . "
               WHERE group_moderator IN ($update_moderator_id)";
            if( !$db->sql_query($sql) )
            {
               message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
            }
         }

         $sql = "DELETE FROM " . USERS_TABLE . "
            WHERE user_id = $to_userdata";
         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete user', '', __LINE__, __FILE__, $sql);
         }

         $sql = "DELETE FROM " . USER_GROUP_TABLE . "
            WHERE user_id = $to_userdata";
         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete user from user_group table', '', __LINE__, __FILE__, $sql);
         }

         $sql = "DELETE FROM " . GROUPS_TABLE . "
            WHERE group_id = " . $row['group_id'];

         if(isset($row['group_id']))         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);
         }

         $sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
            WHERE group_id = " . $row['group_id'];
         if(isset($row['group_id']))         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);
         }

         $sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "
            WHERE user_id = $to_userdata";
         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete user from topic watch table', '', __LINE__, __FILE__, $sql);
         }
         
         $sql = "DELETE FROM " . BANLIST_TABLE . "
            WHERE ban_userid = $to_userdata";
         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not delete user from banlist table', '', __LINE__, __FILE__, $sql);
         }

         $sql = "SELECT privmsgs_id
            FROM " . PRIVMSGS_TABLE . "
            WHERE privmsgs_from_userid = $to_userdata 
               OR privmsgs_to_userid = $to_userdata";
         if ( !($result = $db->sql_query($sql)) )
         {
            message_die(GENERAL_ERROR, 'Could not select all users private messages', '', __LINE__, __FILE__, $sql);
         }

         // This little bit of code directly from the private messaging section.
         while ( $row_privmsgs = $db->sql_fetchrow($result) )
         {
            $mark_list[] = $row_privmsgs['privmsgs_id'];
         }
         
         if ( count($mark_list) )
         {
            $delete_sql_id = implode(', ', $mark_list);
            
            $delete_text_sql = "DELETE FROM " . PRIVMSGS_TEXT_TABLE . "
               WHERE privmsgs_text_id IN ($delete_sql_id)";
            $delete_sql = "DELETE FROM " . PRIVMSGS_TABLE . "
               WHERE privmsgs_id IN ($delete_sql_id)";
            
            if ( !$db->sql_query($delete_sql) )
            {
               message_die(GENERAL_ERROR, 'Could not delete private message info', '', __LINE__, __FILE__, $delete_sql);
            }
            
            if ( !$db->sql_query($delete_text_sql) )
            {
               message_die(GENERAL_ERROR, 'Could not delete private message text', '', __LINE__, __FILE__, $delete_text_sql);
            }
         }
      $rem_users++;
      }

      $new_rem_users = intval($board_config['removed_users']) + $rem_users;
      $sql = "UPDATE " . CONFIG_TABLE . " SET config_value = '" . $new_rem_users . "' WHERE config_name = 'removed_users' ";

      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not update config table', '', __LINE__, __FILE__, $sql);
      }

      $message = $lang['UI_Deleted_Users'] . "." .
      "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
      "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);
      
      } 
      
      else 
      
      {
      
      $message = $lang['UI_select_user_first']  . "." .
      "<br /><br />" . sprintf($lang['UI_return'], "<a href=\"" . append_sid("admin_users_inactive.$phpEx?mode=modify") . "\">", "</a>")   .
      "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>")   ;

      message_die(GENERAL_MESSAGE, $message);
      
      }

      break;
}


}

include('./page_footer_admin.'.$phpEx);

?>

Failed sending email :: PHP :: en SMTP

Failed sending email :: PHP :: en SMTP

Re: Failed sending email :: PHP :: en SMTP