aboutsummaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
Diffstat (limited to 'admin')
-rw-r--r--admin/cat_modify.php2
-rw-r--r--admin/cat_perm.php4
-rw-r--r--admin/configuration.php4
-rw-r--r--admin/group_perm.php2
-rw-r--r--admin/include/functions.php12
-rw-r--r--admin/include/isadmin.inc.php2
-rw-r--r--admin/user_list.php8
-rw-r--r--admin/user_modify.php2
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 ) );