Fixes in changing URLs in surfbar extension. Resolves #40/#41

[mailer.git] / inc / modules / admin / what-list_unconfirmed.php

diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index 605130d63debc995f090fb2187ebf41694338363..ba8c54288a4bb9a0e53068752527022f76880678 100644 (file)
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -36,7 +36,7 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
        require($INC);
 } elseif (!EXT_IS_ACTIVE("mailid")) {
-       ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "mailid"));
+       addFatalMessage(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "mailid"));
        return;
 }
 
@@ -109,10 +109,10 @@ if ($listed)
                //
                $result = SQL_QUERY_ESC("SELECT DISTINCT l.userid, u.status, u.surname, u.family, u.gender, u.email
 FROM "._MYSQL_PREFIX."_user_links AS l
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS u
+LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS u
 ON l.userid=u.userid
 WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
- array($col, $ID, bigintval($max)),__FILE__, __LINE__);
+                       array($col, $ID, bigintval($max)),__FILE__, __LINE__);
                $unconfirmed = SQL_NUMROWS($result);
                define('__LIST_UNCO_UNCONFIRMED', $unconfirmed);
 
@@ -130,7 +130,7 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
                                        'uid'    => $uid,
                                        'link'   => $LINK,
                                        'id'     => $ID,
-                                       'email'  => "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".TRANSLATE_GENDER($gender)." ".$sname." ".$fname."</A>",
+                                       'email'  => "<a href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".TRANSLATE_GENDER($gender)." ".$sname." ".$fname."</a>",
                                        'status' => TRANSLATE_STATUS($status),
                                );
 
@@ -138,7 +138,7 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
                                $OUT .= LOAD_TEMPLATE("admin_list_unconfirmed_row", true, $content);
                                $SW = 3 - $SW;
                        }
-                       $OUT .= "</TABLE>\n";
+                       $OUT .= "</table>\n";
 
                        // Free memory
                        SQL_FREERESULT($result);