From 69fa9339de18c80b7f8fb3a9eda808c33ec84f15 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sun, 15 Jan 2006 00:29:56 +0000 Subject: [PATCH] r714: OKAY, this is the last of the TABLE_PREFIX bugs --- admin/language.php | 4 ++-- admin/user.php | 6 +++--- attachment.php | 2 +- search.php | 2 +- 4 files changed, 7 insertions(+), 7 deletions(-) diff --git a/admin/language.php b/admin/language.php index 3fa6019..9964963 100644 --- a/admin/language.php +++ b/admin/language.php @@ -40,8 +40,8 @@ if ($_REQUEST['do'] == 'kill') $admin->error($lang->string('You cannot delete the default language. Please select another language to be the default language and then delete this one.')); } - $db->query("DELETE FROM language WHERE languageid = " . intval($bugsys->in['languageid'])); - $db->query("DELETE FROM localization WHERE languageid = " . intval($bugsys->in['languageid'])); + $db->query("DELETE FROM " . TABLE_PREFIX . "language WHERE languageid = " . intval($bugsys->in['languageid'])); + $db->query("DELETE FROM " . TABLE_PREFIX . "localization WHERE languageid = " . intval($bugsys->in['languageid'])); build_languages(); $admin->redirect('language.php?do=modify'); } diff --git a/admin/user.php b/admin/user.php index 7cbb479..b33f19f 100644 --- a/admin/user.php +++ b/admin/user.php @@ -48,9 +48,9 @@ if ($_REQUEST['do'] == 'kill') } } - $db->query("DELETE FROM user WHERE userid = $user[userid]"); - $db->query("DELETE FROM favourite WHERE userid = $user[userid]"); - $db->query("DELETE FROM useractivation WHERE userid = $user[userid]"); + $db->query("DELETE FROM " . TABLE_PREFIX . "user WHERE userid = $user[userid]"); + $db->query("DELETE FROM " . TABLE_PREFIX . "favourite WHERE userid = $user[userid]"); + $db->query("DELETE FROM " . TABLE_PREFIX . "useractivation WHERE userid = $user[userid]"); $admin->redirect('user.php'); } diff --git a/attachment.php b/attachment.php index 76fff06..eaf6ef4 100755 --- a/attachment.php +++ b/attachment.php @@ -82,7 +82,7 @@ if ($_POST['do'] == 'insert') // insert an attachment $db->query(" - INSERT INTO attachment + INSERT INTO " . TABLE_PREFIX . "attachment (bugid, filename, mimetype, filesize, attachment, description, dateline, userid) VALUES diff --git a/search.php b/search.php index b6b6977..6a5d782 100644 --- a/search.php +++ b/search.php @@ -98,7 +98,7 @@ if ($_REQUEST['do'] == 'process') { // force email or name?? make a distinction? // more elegant way to do this? probably - $user = $db->query_first("SELECT * FROM user WHERE email LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "' OR displayname LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "%'"); + $user = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE email LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "' OR displayname LIKE '%" . str_replace('%', '\%', $bugsys->in['reporter']) . "%'"); if ($user['userid']) { $querybuild['reporter'] = "AND bug.userid = $user[userid] OR comment.userid = $user[userid]"; -- 2.22.5