diff options
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/cat_modify.php | 2 | ||||
| -rw-r--r-- | admin/cat_perm.php | 4 | ||||
| -rw-r--r-- | admin/configuration.php | 4 | ||||
| -rw-r--r-- | admin/group_perm.php | 2 | ||||
| -rw-r--r-- | admin/include/functions.php | 12 | ||||
| -rw-r--r-- | admin/include/isadmin.inc.php | 2 | ||||
| -rw-r--r-- | admin/user_list.php | 8 | ||||
| -rw-r--r-- | admin/user_modify.php | 2 |
8 files changed, 17 insertions, 19 deletions
diff --git a/admin/cat_modify.php b/admin/cat_modify.php index 69e90cbc8..2f08f8f81 100644 --- a/admin/cat_modify.php +++ b/admin/cat_modify.php @@ -99,7 +99,7 @@ if ( isset( $_POST['submit'] ) ) // checking users favorites $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ';'; $result = mysql_query( $query ); while ( $row = mysql_fetch_array( $result ) ) diff --git a/admin/cat_perm.php b/admin/cat_perm.php index 70a053ade..b571caeab 100644 --- a/admin/cat_perm.php +++ b/admin/cat_perm.php @@ -75,7 +75,7 @@ if ( isset( $_POST['submit'] ) ) $query.= ';'; mysql_query( $query ); $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ';'; $result = mysql_query( $query ); while ( $row = mysql_fetch_array( $result ) ) @@ -137,7 +137,7 @@ if ( mysql_num_rows( $result ) > 0 ) } //----------------------------------------------------------------------- users $query = 'SELECT id,username,status'; -$query.= ' FROM '.PREFIX_TABLE.'users'; +$query.= ' FROM '.USERS_TABLE; // only the webmaster can modify webmaster's permissions if ( $user['username'] != $conf['webmaster'] ) { diff --git a/admin/configuration.php b/admin/configuration.php index 4a594f391..733b8f1b9 100644 --- a/admin/configuration.php +++ b/admin/configuration.php @@ -217,7 +217,7 @@ if ( isset( $_POST['submit'] ) ) $query.= ';'; mysql_query( $query ); - $query = 'UPDATE '.PREFIX_TABLE.'users'; + $query = 'UPDATE '.USERS_TABLE; $query.= ' SET'; foreach ( $default_user_infos as $i => $default_user_info ) { if ( $i > 0 ) $query.= ','; @@ -257,7 +257,7 @@ else } $query = 'SELECT '.implode( ',', $default_user_infos ); - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= " WHERE username = 'guest'"; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); diff --git a/admin/group_perm.php b/admin/group_perm.php index 531717428..37deb5984 100644 --- a/admin/group_perm.php +++ b/admin/group_perm.php @@ -61,7 +61,7 @@ if ( isset( $_POST['submit'] ) ) } // checking users favorites $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ';'; $result = mysql_query( $query ); while ( $row = mysql_fetch_array( $result ) ) diff --git a/admin/include/functions.php b/admin/include/functions.php index 9a54e14e4..bb22b50ac 100644 --- a/admin/include/functions.php +++ b/admin/include/functions.php @@ -282,7 +282,7 @@ function delete_user( $user_id ) mysql_query( $query ); // destruction of the user - $query = 'DELETE FROM '.PREFIX_TABLE.'users'; + $query = 'DELETE FROM '.USERS_TABLE; $query.= ' WHERE id = '.$user_id; $query.= ';'; mysql_query( $query ); @@ -322,7 +322,7 @@ function delete_group( $group_id ) function check_favorites( $user_id ) { $query = 'SELECT status,forbidden_categories'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ' WHERE id = '.$user_id; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); @@ -852,7 +852,7 @@ function synchronize_all_users() $user_restrictions = array(); $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ';'; $result = mysql_query( $query ); while ( $row = mysql_fetch_array( $result ) ) @@ -901,7 +901,7 @@ function synchronize_group( $group_id ) $user_restrictions = array(); $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ', '.PREFIX_TABLE.'user_group'; $query.= ' WHERE group_id = '.$group_id; $query.= ' AND id = user_id'; @@ -926,7 +926,7 @@ function update_user_restrictions( $user_id ) $restrictions = get_user_all_restrictions( $user_id ); // update the users.forbidden_categories in database - $query = 'UPDATE '.PREFIX_TABLE.'users'; + $query = 'UPDATE '.USERS_TABLE; $query.= ' SET forbidden_categories = '; if ( count( $restrictions ) > 0 ) $query.= "'".implode( ',', $restrictions )."'"; @@ -950,7 +950,7 @@ function get_user_all_restrictions( $user_id ) global $page; $query = 'SELECT status'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ' WHERE id = '.$user_id; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); diff --git a/admin/include/isadmin.inc.php b/admin/include/isadmin.inc.php index 11545b700..2b053d7b1 100644 --- a/admin/include/isadmin.inc.php +++ b/admin/include/isadmin.inc.php @@ -28,8 +28,6 @@ include( './admin/include/functions.php' ); $isadmin = true; -include_once( './language/'.$user['language'].'/lang_admin.php' ); - if ( $user['status'] != 'admin' ) { echo '<div style="text-align:center;">'.$lang['access_forbiden'].'<br />'; diff --git a/admin/user_list.php b/admin/user_list.php index a340362aa..82bbeb86c 100644 --- a/admin/user_list.php +++ b/admin/user_list.php @@ -61,7 +61,7 @@ else if ( isset( $_POST['submit_add_user'] ) ) if ( isset ( $_GET['delete'] ) and is_numeric( $_GET['delete'] ) ) { $query = 'SELECT username'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ' WHERE id = '.$_GET['delete']; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); @@ -85,7 +85,7 @@ if ( isset ( $_GET['delete'] ) and is_numeric( $_GET['delete'] ) ) and $row['username'] != $conf['webmaster'] ) { $query = 'SELECT COUNT(*) AS nb_result'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ' WHERE id = '.$_GET['delete']; $query.= ';'; $row2 = mysql_fetch_array( mysql_query( $query ) ); @@ -131,7 +131,7 @@ else $vtp->setVar( $sub, 'users.form_action', $action ); $query = 'SELECT id,username,status,mail_address'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ' ORDER BY status ASC, username ASC'; $query.= ';'; $result = mysql_query( $query ); @@ -233,7 +233,7 @@ else { $mails = array(); $query = 'SELECT id,mail_address'; - $query.= ' FROM '.PREFIX_TABLE.'users'; + $query.= ' FROM '.USERS_TABLE; $query.= ';'; $result = mysql_query( $query ); while ( $row = mysql_fetch_array( $result ) ) diff --git a/admin/user_modify.php b/admin/user_modify.php index 3823c9ef6..f55a041a8 100644 --- a/admin/user_modify.php +++ b/admin/user_modify.php @@ -41,7 +41,7 @@ $display_form = true; // id in $_GET['user_id'] $query = 'select'; $query.= ' username,status,mail_address'; -$query.= ' from '.PREFIX_TABLE.'users'; +$query.= ' from '.USERS_TABLE; $query.= ' where id = '.$_GET['user_id']; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); |