X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2Fusermgmt.php;h=ec9a83e455d2e3d149848649acf3c6279043de43;hb=e57a97b3b360856cef56884815289531f3bb326f;hp=413e173d850e69ba06c8b00c72bdf0509a54162a;hpb=d30248bea653c6a0d4f784810dda00b660368941;p=brisk.git
diff --git a/web/usermgmt.php b/web/usermgmt.php
index 413e173..ec9a83e 100644
--- a/web/usermgmt.php
+++ b/web/usermgmt.php
@@ -47,6 +47,7 @@ require_once($G_base."Obj/brisk.phh");
require_once($G_base."Obj/user.phh");
require_once($G_base."Obj/auth.phh");
require_once($G_base."Obj/mail.phh");
+require_once($G_base."Obj/dbase_base.phh");
require_once($G_base."Obj/dbase_${G_dbasetype}.phh");
require_once($G_base."briskin5/Obj/briskin5.phh");
require_once($G_base."briskin5/Obj/placing.phh");
@@ -105,6 +106,11 @@ function main() {
exit;
}
+ $nocheck = FALSE;
+ if (isset($_GET['f_nocheck'])) {
+ $nocheck = TRUE;
+ }
+
if (isset($_GET['do']) && $_GET['do'] == 'newuser') {
if (isset($_POST['f_accept'])) {
$action = "accept";
@@ -228,15 +234,20 @@ SELECT usr.*, guar.login AS guar_login
break;
}
$usr_n = pg_numrows($usr_pg);
- $tab_lines = "";
+ $tab_lines = "
| User | Guar | Date |
";
for ($i = 0 ; $i < $usr_n ; $i++) {
$usr_obj = pg_fetch_object($usr_pg, $i);
- $tab_lines .= sprintf(" | %s | |
\n",
- $usr_obj->code, eschtml($usr_obj->login), eschtml($usr_obj->guar_login));
+ $tab_lines .= sprintf(" | %s | %s | %s |
\n",
+ $usr_obj->code, ($nocheck ? "" : "CHECKED"),
+ eschtml($usr_obj->login), eschtml($usr_obj->guar_login), $usr_obj->lintm);
}
?>
+
+
+Brisk: new imported users management.
+
New imported users management.
@@ -251,6 +262,123 @@ SELECT usr.*, guar.login AS guar_login
+ $value) {
+ if (substr($key, 0, 9) != "f_newuser")
+ continue;
+
+ $id = (int)substr($key, 9);
+ if ($id <= 0)
+ continue;
+
+ $res = FALSE;
+ do {
+ if (($bdb = BriskDB::create()) == FALSE) {
+ $status .= "1
";
+ break;
+ }
+ // retrieve list added users
+ $mai_sql = sprintf("
+SELECT mail.*, usr.email AS email
+ FROM %susers AS usr
+ JOIN %smails AS mail ON mail.ucode = usr.code
+ WHERE mail.ucode = %d AND mail.type = %d",
+ $G_dbpfx, $G_dbpfx, $id, MAIL_TYP_CHECK);
+ if (($mai_pg = pg_query($bdb->dbconn->db(), $mai_sql)) == FALSE) {
+ log_crit("retrieve mail failed");
+ $status .= "2
";
+ break;
+ }
+ $mai_n = pg_numrows($mai_pg);
+ if ($mai_n != 1) {
+ $status .= sprintf("Inconsistency for code %d, returned %d records, skipped.
",
+ $id, $mai_n);
+ break;
+ }
+ $mai_obj = pg_fetch_object($mai_pg, 0);
+ $mail = MailDBItem::MailDBItemFromRecord($mai_obj);
+
+ if (brisk_mail($mai_obj->email, $mail->subj, $mail->body_txt, $mail->body_htm) == FALSE) {
+ // mail error
+ $status .= sprintf("Send mail filed for user id %d
\n", $id);
+ break;
+ }
+ $res = TRUE;
+ } while(FALSE);
+ if ($res == FALSE) {
+ $status .= sprintf("Error occurred during resend action
");
+ break;
+ }
+ } // foreach
+ }
+
+ do {
+ if (($bdb = BriskDB::create()) == FALSE) {
+ log_crit("stat-day: database connection failed");
+ break;
+ }
+
+ // retrieve list added users
+ $usr_sql = sprintf("
+SELECT usr.*, guar.login AS guar_login
+ FROM %susers AS usr
+ JOIN %susers AS guar ON guar.code = usr.guar_code
+ WHERE ( (usr.type & (CAST (X'%x' as integer))) = (CAST (X'%x' as integer)) )
+ AND usr.disa_reas = %d;",
+ $G_dbpfx, $G_dbpfx,
+ USER_FLAG_TY_DISABLE, USER_FLAG_TY_DISABLE,
+ USER_DIS_REA_NU_MAILED);
+ if (($usr_pg = pg_query($bdb->dbconn->db(), $usr_sql)) == FALSE) {
+ log_crit("stat-day: select from tournaments failed");
+ break;
+ }
+ $usr_n = pg_numrows($usr_pg);
+ $tab_lines = " | User | Guar | Date |
";
+ for ($i = 0 ; $i < $usr_n ; $i++) {
+ $usr_obj = pg_fetch_object($usr_pg, $i);
+
+ $tab_lines .= sprintf(" | %s | %s | %s |
\n",
+ $usr_obj->code, ($nocheck ? "" : "CHECKED"),
+ eschtml($usr_obj->login), eschtml($usr_obj->guar_login), $usr_obj->lintm);
+ }
+ ?>
+
+
+
+Brisk: new mailed users management.
+
+
+ New mailed users management.
+
+
+
+
| User | Guar | Date | ";
for ($i = 0 ; $i < $usr_n ; $i++) {
$usr_obj = pg_fetch_object($usr_pg, $i);
- $tab_lines .= sprintf(" | %s | |
\n",
- $usr_obj->code, eschtml($usr_obj->login), eschtml($usr_obj->guar_login));
+ $tab_lines .= sprintf(" | %s | %s | %s |
\n",
+ $usr_obj->code, ($nocheck ? "" : "CHECKED"),
+ eschtml($usr_obj->login), eschtml($usr_obj->guar_login), $usr_obj->lintm);
}
?>
+
+
+Brisk: email verified user management.
+
E-mail verified user management.
@@ -386,4 +519,4 @@ SELECT usr.*, guar.login AS guar_login
main();
-?>
\ No newline at end of file
+?>