inc/libs/refback_functions.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 09/28/2008 *
   4  * ===================                          Last change: 09/28/2008 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : refback_functions.php                            *
   8  * -------------------------------------------------------------------- *
   9  * Short description : Functions for refback extension                  *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Funktionen fuer Refback-Erweiterung              *
  12  * -------------------------------------------------------------------- *
  13  * $Revision::                                                        $ *
  14  * $Date::                                                            $ *
  15  * $Tag:: 0.2.1-FINAL                                                 $ *
  16  * $Author::                                                          $ *
  17  * Needs to be in all Files and every File needs "svn propset           *
  18  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  19  * -------------------------------------------------------------------- *
  20  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  21  * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  22  * For more information visit: http://www.mxchange.org                  *
  23  *                                                                      *
  24  * This program is free software; you can redistribute it and/or modify *
  25  * it under the terms of the GNU General Public License as published by *
  26  * the Free Software Foundation; either version 2 of the License, or    *
  27  * (at your option) any later version.                                  *
  28  *                                                                      *
  29  * This program is distributed in the hope that it will be useful,      *
  30  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
  31  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
  32  * GNU General Public License for more details.                         *
  33  *                                                                      *
  34  * You should have received a copy of the GNU General Public License    *
  35  * along with this program; if not, write to the Free Software          *
  36  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
  37  * MA  02110-1301  USA                                                  *
  38  ************************************************************************/
  39
  40 // Some security stuff...
  41 if (!defined('__SECURITY')) {
  42         die();
  43 }
  44
  45 // Payback refback for refid and reduce it for current user
  46 function addRefbackPoints ($userid, $ref, $points, $ref_points) {
  47         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
  48         // Back ref depths
  49         $GLOBALS['refback_depth'][$userid][$ref] = $GLOBALS['ref_level'];
  50
  51         // Init points
  52         $return = $points;
  53
  54         // Get all ref levels
  55         $result_refs = SQL_QUERY("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level` > 0 ORDER BY `level` ASC",
  56                 __FUNCTION__, __LINE__);
  57
  58         // "Walk" through all level
  59         while ($content = SQL_FETCHARRAY($result_refs)) {
  60                 // Reset ref depths
  61                 // @TODO Try to rewrite the following unset()
  62                 unset($GLOBALS['ref_level']);
  63
  64                 // "Walk" through all refids
  65                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},ref={$ref},level={$content['level']},points={$points}<br />");
  66                 foreach (getArrayFromRefbackLevel($userid, $content['level']) as $refid) {
  67                         // Skip level zero or if both are the same
  68                         if ($userid == $refid) continue;
  69
  70                         // Get refback percents
  71                         $percents = getRefbackPercents($userid, $refid);
  72                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},ref={$ref},refid={$refid},points={$points},percents={$percents}<br />");
  73
  74                         // Some percents given?
  75                         if ($percents > 0) {
  76                                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):points={$points},perc={$content['percents']},percents={$percents},level={$content['level']}<br />");
  77                                 // Calculate points for refback
  78                                 $refback = $points * ($content['percents'] / 100) * ($percents / 100);
  79
  80                                 // Update refback table ('refid' and 'userid' must be exchanged!)
  81                                 SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `points`=`points`+%s WHERE `userid`=%s AND `refid`=%s LIMIT 1",
  82                                         array($refback, $refid, $userid), __FUNCTION__, __LINE__);
  83                                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):refback={$refback},userid={$userid},refid={$refid} - UPDATE! (".SQL_AFFECTEDROWS().")<br />");
  84
  85                                 // Add points again, but only directly
  86                                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):refback={$refback}<br />");
  87                                 addPointsDirectly(sprintf("refback:%s", $refid), $userid, $refback);
  88
  89                                 // Reduce points if refid is found
  90                                 if ($refid == $ref) {
  91                                         // Reduce points here!
  92                                         $return = $points * ($content['percents'] / 100) - $refback;
  93                                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):points={$return} - REDUCED<br />");
  94                                 } // END - if
  95                         } // END - if
  96                 } // END foreach
  97         } // END - while
  98
  99         // Free result
 100         SQL_FREERESULT($result_refs);
 101
 102         // Restore ref depth
 103         $GLOBALS['ref_level'] = $GLOBALS['refback_depth'][$userid][$ref];
 104
 105         // Return them
 106         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 107         return $return;
 108 }
 109
 110 // "Getter" for refback percents
 111 function getRefbackPercents ($userid, $ref) {
 112         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 113         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},ref={$ref}<br />");
 114         // Skip identical ids
 115         if ($userid == $ref) return 0;
 116
 117         // Default is zero
 118         $percents = '0';
 119
 120         // Get percents from database
 121         $result = SQL_QUERY_ESC("SELECT refback FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `refid`=%s LIMIT 1",
 122         array($ref, $userid), __FUNCTION__, __LINE__);
 123
 124         // Entry found? (Should be!)
 125         if (SQL_NUMROWS($result) == 1) {
 126                 // Fetch percents
 127                 list($percents) = SQL_FETCHROW($result);
 128                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):percents={$percents}<br />");
 129         } else {
 130                 // Debug log
 131                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>): NO ENTRY FOUND! :-(<br />");
 132                 logDebugMessage(__FUNCTION__, __LINE__, "userid={$userid},ref={$ref} - No entry found! :-(");
 133         }
 134
 135         // Free result
 136         SQL_FREERESULT($result);
 137
 138         // Return percents
 139         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 140         return $percents;
 141 }
 142
 143 // "Getter" for userid array which will return only one entry
 144 function getArrayFromRefbackLevel ($rid, $level) {
 145         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 146         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):rid={$rid},level={$level}<br />");
 147         // Init userids
 148         $userIds = array();
 149
 150         // Look for all
 151         $result = SQL_QUERY_ESC("SELECT
 152         `userid`
 153 FROM
 154         `{?_MYSQL_PREFIX?}_user_refs`
 155 WHERE
 156         `refid`=%s AND `level`=%s
 157 ORDER BY
 158         `userid` ASC",
 159                 array($rid, $level), __FUNCTION__, __LINE__);
 160
 161         // Entries found?
 162         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):numRows=".SQL_NUMROWS($result)."<br />");
 163         if (SQL_NUMROWS($result) > 0) {
 164                 // Add all
 165                 while ($content = SQL_FETCHARRAY($result)) {
 166                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):rid={$rid},level={$level},userid={$content['userid']}<br />");
 167                         $userIds[] = $content['userid'];
 168                 } // END - while
 169         } // END - if
 170
 171         // Free result
 172         SQL_FREERESULT($result);
 173
 174         // Return array
 175         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):rid={$rid},count()=".count($userIds)."<br />");
 176         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 177         return $userIds;
 178 }
 179
 180 // Update "refback table"
 181 function updateRefbackTable ($userid) {
 182         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 183         // Make it sure referal level zero (member him-/herself) is at least selected
 184         if (empty($GLOBALS['refback_level'])) $GLOBALS['refback_level'] = 1;
 185         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level={$GLOBALS['refback_level']}<br />");
 186
 187         // Init refid
 188         $GLOBALS['refback_refid'][$GLOBALS['refback_level']] = '0';
 189         $old = '0'; $minus = '0';
 190
 191         // Check for his referal
 192         $result_refid = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `refid`=%s ORDER BY `userid` ASC",
 193                 array(bigintval($userid)), __FUNCTION__, __LINE__);
 194
 195         // When no entry was updated then we have to create it here
 196         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):found=".SQL_NUMROWS($result_refid)."<br />");
 197         if (SQL_NUMROWS($result_refid) > 0) {
 198                 // Load all refids
 199                 while (list($GLOBALS['refback_refid'][$GLOBALS['refback_level']]) = SQL_FETCHROW($result_refid)) {
 200                         // Remmber userid
 201                         $GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']]] = $userid;
 202
 203                         // Refid set?
 204                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]}<br />");
 205                         if (($GLOBALS['refback_refid'][$GLOBALS['refback_level']] > 0) && ($GLOBALS['refback_refid'][$GLOBALS['refback_level']] != $userid) && (isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']]))) {
 206                                 // New userid?
 207                                 if ((isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']-1])) && (isset($GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']-1]]))) {
 208                                         // New userid!
 209                                         $old = $userid;
 210                                         $userid = $GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']-1]];
 211                                         $minus = 1;
 212                                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},old={$old},level={$GLOBALS['refback_level']},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]} - NEW UID!<br />");
 213                                 } // END - if
 214
 215                                 // Check existence
 216                                 $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`='%s' AND `refid`=%s LIMIT 1",
 217                                         array(bigintval($userid), $GLOBALS['refback_level'], bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])), __FUNCTION__, __LINE__);
 218
 219                                 // Do we have no entry?
 220                                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level={$GLOBALS['refback_level']},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]},minus={$minus},numRows=".SQL_NUMROWS($result)." - FOUND!<br />");
 221                                 if (SQL_HASZERONUMS($result)) {
 222                                         // Insert this level
 223                                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level={$GLOBALS['refback_level']},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]} - ADD!<br />");
 224                                         SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_refs` (`userid`,`level`,`refid`) VALUES (%s,%s,%s)",
 225                                                 array(bigintval($userid), $GLOBALS['refback_level'], bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])), __FUNCTION__, __LINE__);
 226
 227                                         // Move to next referal level and count his counter one up!
 228                                         $GLOBALS['refback_level']++; updateRefbackTable($GLOBALS['refback_refid'][($GLOBALS['refback_level'] - 1)]);
 229                                 } // END - if
 230
 231                                 // Do we have another level here?
 232                                 if ((($GLOBALS['refback_level']-$minus) > 0) && ($old > 0)) {
 233                                         // Restore old one
 234                                         $userid = $old;
 235
 236                                         // Shall we add this as well?
 237                                         $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`='%s' AND `refid`=%s LIMIT 1",
 238                                                 array(bigintval($userid), ($GLOBALS['refback_level']-$minus), bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])), __FUNCTION__, __LINE__);
 239
 240                                         // Do we have no entry?
 241                                         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level=".($GLOBALS['refback_level']-$minus).",ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]},numRows=".SQL_NUMROWS($result)." - BACK!<br />");
 242                                         if (SQL_HASZERONUMS($result)) {
 243                                                 // Insert this level
 244                                                 SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_refs` (`userid`,`level`,`refid`) VALUES (%s,%s,%s)",
 245                                                         array(bigintval($userid), ($GLOBALS['refback_level']-$minus), bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])), __FUNCTION__, __LINE__);
 246                                                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level=".($GLOBALS['refback_level']-$minus).",ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]} - RETURNED!<br />");
 247                                         } // END - if
 248                                 } // END - if
 249                         } // END - if
 250                 } // END - while
 251
 252                 // Free memory
 253                 SQL_FREERESULT($result_refid);
 254         } // END - if
 255
 256         // When he has a referal...
 257         if ((($GLOBALS['refback_refid'][$GLOBALS['refback_level']] == $userid) || ($GLOBALS['refback_refid'][$GLOBALS['refback_level']] == '0')) && (isExtensionInstalledAndNewer('cache', '0.1.2')) && (!isset($GLOBALS['refback_cached']))) {
 258                 // Remove cache here
 259                 //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']]} - CACHE!<br />");
 260                 if ($GLOBALS['cache_instance']->loadCacheFile('refback')) $GLOBALS['cache_instance']->removeCacheFile();
 261                 $GLOBALS['refback_cached'] = 1;
 262         } // END - if
 263
 264         // "Walk" back here
 265         $GLOBALS['refback_level']--;
 266         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level={$GLOBALS['refback_level']} - LEVEL!<br />");
 267
 268         // Fix empty refid
 269         if (!isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']-1])) $GLOBALS['refback_refid'][$GLOBALS['refback_level']-1] = '0';
 270         //* DEBUG: */ print(__FUNCTION__ . '(<font color="#0000aa">' . __LINE__."</font>):userid={$userid},level={$GLOBALS['refback_level']},ref={$GLOBALS['refback_refid'][$GLOBALS['refback_level']-1]} - BACK!<br />");
 271         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 272 }
 273
 274 // "Getter" for array for user refs in given level
 275 function getArrayFromRefbackUserRefs ($userid, $level) {
 276         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 277         // Default is no refs and no nickname
 278         $add = '';
 279         $refs = array();
 280
 281         // Do we have nickname extension installed?
 282         if (isExtensionActive('nickname')) {
 283                 $add = ", d.nickname";
 284         } // END - if
 285
 286         // Get refs from database
 287         $result = SQL_QUERY_ESC("SELECT
 288         r.id,
 289         r.refid,
 290         r.refback,
 291         r.points,
 292         d.status".$add.",
 293         d.joined,
 294         d.refid AS level_refid
 295 FROM
 296         `{?_MYSQL_PREFIX?}_user_refs` AS r
 297 LEFT JOIN
 298         `{?_MYSQL_PREFIX?}_user_data` AS d
 299 ON
 300         r.refid=d.userid
 301 WHERE
 302         r.userid=%s AND r.level=%s
 303 ORDER BY
 304         r.refid ASC",
 305                 array(bigintval($userid), bigintval($level)), __FUNCTION__, __LINE__);
 306
 307         // Are there some entries?
 308         if (SQL_NUMROWS($result) > 0) {
 309                 // Fetch all entries
 310                 while ($row = SQL_FETCHARRAY($result)) {
 311                         // Add row
 312                         $refs[$row['id']] = $row;
 313                 } // END - while
 314         } // END - if
 315
 316         // Free result
 317         SQL_FREERESULT($result);
 318
 319         // Return result
 320         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 321         return $refs;
 322 }
 323
 324 // "Getter" for refback entry
 325 function getArrayFromUserRefbackData ($id) {
 326         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 327         // Default data is nothing
 328         $data = array();
 329
 330         // Secure id number
 331         $id = bigintval($id);
 332
 333         // Get entry from database
 334         $result = SQL_QUERY_ESC("SELECT `id`, `userid`, `refid`, `refback`, `level`, `points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
 335                 array($id, getMemberId()), __FUNCTION__, __LINE__);
 336
 337         // Is there an entry?
 338         if (SQL_NUMROWS($result) == 1) {
 339                 // Fetch data
 340                 $data = SQL_FETCHARRAY($result);
 341         } // END - if
 342
 343         // Free result
 344         SQL_FREERESULT($result);
 345
 346         // Return entry
 347         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 348         return $data;
 349 }
 350
 351 // Update refback percents (but with some sanity-checks!
 352 function updateMemberRefbackPercents ($id, $percents) {
 353         //* DEBUG: */ print("----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n");
 354         // Default status is failed
 355         $status['message'] = getMessage('MEMBER_REFBACK_ERROR_GENERAL');
 356
 357         // Do some sanity-checks
 358         if (!isMember()) {
 359                 // No member!
 360                 $status['message'] = getMessage('MEMBER_REFBACK_ERROR_NO_MEMBER');
 361                 return $status;
 362         } elseif (''.$id.'' != ''.($id + 0).'') {
 363                 // No number!
 364                 $status['message'] = getMessage('MEMBER_REFBACK_ERROR_INVALID_ID_NUMBER');
 365                 return $status;
 366         } elseif (($percents < 0) || ($percents > 100)) {
 367                 // Percentage is not valid!
 368                 $status['message'] = getMessage('MEMBER_REFBACK_ERROR_INVALID_PERCENTAGE');
 369                 return $status;
 370         }
 371
 372         // Get ref entry
 373         $dummy = getArrayFromUserRefbackData($id);
 374
 375         // Is this valid?
 376         if (count($dummy) == 0) {
 377                 // id does not belong to user!
 378                 $status['message'] = getMessage('MEMBER_REFBACK_ERROR_ID_MISMATCH');
 379                 return $status;
 380         } // END - if
 381
 382         // Revert german commata
 383         $percents = convertCommaToDot($percents);
 384
 385         // Update entry
 386         SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `refback`='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
 387                 array($percents, $id, getMemberId()), __FUNCTION__, __LINE__);
 388
 389         // Entry updated?
 390         if (SQL_AFFECTEDROWS() < 1) {
 391                 // Entry not updated!
 392                 $status['message'] = getMessage('MEMBER_REFBACK_ERROR_NOT_UPDATED');
 393                 return $status;
 394         } // END - if
 395
 396         // Prepare email content
 397         $content = array(
 398                 'percents' => translateComma($percents),
 399                 'refid'    => $dummy['refid'],
 400                 'level'    => $dummy['level'],
 401                 'points'   => translateComma($dummy['points']),
 402         );
 403
 404         // Load member email template
 405         $mail = loadEmailTemplate('member_refback', $content, $dummy['refid']);
 406
 407         // Send email to user
 408         sendEmail($dummy['refid'], getMessage('MEMBER_REFBACK_SUBJECT'), $mail);
 409
 410         // Send admin notification
 411         sendAdminNotification(getMessage('ADMIN_REFBACK_SUBJECT'), 'admin_refback', $content, getMemberId());
 412
 413         // All fine!
 414         $status['ok'] = true;
 415
 416         // Return status array
 417         //* DEBUG: */ print("</li></ul>----------------------- <font color=\"#aa0000\">".__FUNCTION__." - EXIT</font> ------------------------<br />");
 418         return $status;
 419 }
 420 //
 421 ?>