Changeset 858 in ExiteCMS for trunk/administration/adverts.php

Timestamp:

09/29/07 21:51:40 (5 years ago)

Author:

hverton

Message:

Added language selection and language detection
When adding a new member as sponsor, the member will be added to the 'Sponsors' user_group
Added missing index.php to the new cache directories

Location:

trunk

Files:

• . (modified) (1 prop)
• administration/adverts.php (modified) (3 diffs)

trunk

@@ -1 +1 @@
 Copy of config.php
+config.backup.php
 config.php

@@ -1 +1 @@
 Copy of config.php
+config.backup.php
 config.php

trunk/administration/adverts.php

@@ -84 +84 @@
                                 $action = "list";
                             }
-                        } 
+                        }
                     } else {
                         $errormessage = $locale['921']; // ad not found in the database
@@ -106 +106 @@
     switch($action) {
         case "add":
-            if (isNum($_POST['new_sponsor'])) $result = dbquery("UPDATE ".$db_prefix."users SET user_sponsor = '1' WHERE user_id = '".$_POST['new_sponsor']."'");
+            if (isNum($_POST['new_sponsor'])) {
+                $result = dbquery("UPDATE ".$db_prefix."users SET user_sponsor = '1' WHERE user_id = '".$_POST['new_sponsor']."'");
+                // add the new sponsor to the sponsors usergroup
+                $result = dbquery("SELECT group_id FROM ".$db_prefix."user_groups WHERE group_ident = 'wE01'");
+                if ($result) {
+                    $data = dbarray($result);
+                    $result = dbquery("SELECT user_groups FROM ".$db_prefix."users WHERE user_id = '".$_POST['new_sponsor']."'");
+                    if ($result) {
+                        $data2 = dbarray($result);
+                        $result = dbquery("UPDATE ".$db_prefix."users SET user_groups = '".$data2['user_groups'].".".$data['group_id']."' WHERE user_id = '".$_POST['new_sponsor']."'");
+                    }
+                }
+            }
             $action = "list";
             break;
@@ -240 +252 @@
             $result = dbquery("DELETE FROM ".$db_prefix."adverts WHERE adverts_userid = '$id'");
             $result = dbquery("UPDATE ".$db_prefix."users SET user_sponsor = '0' WHERE user_id = '$id'");
+
+            // remove the sponsor to the sponsors usergroup
+            $result = dbquery("SELECT group_id FROM ".$db_prefix."user_groups WHERE group_ident = 'wE01'");
+            if ($result) {
+                $group_id = dbarray($result);
+                $group_id = '.'.$group_id['group_id'];
+                $result = dbquery("SELECT user_groups FROM ".$db_prefix."users WHERE user_id = '$id'");
+                if ($result) {
+                    $data2 = dbarray($result);
+                    $result = dbquery("UPDATE ".$db_prefix."users SET user_groups = '".str_replace($group_id, '', $data2['user_groups'])."' WHERE user_id = '$id'");
+                }
+            }
+
             $errortitle = $locale['476'];
             $errormessage = $locale['910'];

@@ -1 +1 @@
 Copy of config.php
+config.backup.php
 config.php