Speedup admin area

Posted: Sun Feb 29, 2004 6:57 pm

Well i did but it takes big changes in the way your admin area works.
And you need to modify all your add-ons as well.

The problem:
A lot of nuke_authors queries are called.

Solution:

modify auth.php and change

Code:

$sql = "SELECT pwd FROM ".$prefix."_authors WHERE aid='$aid'";
if (!($result = $db->sql_query($sql))) {
echo "Selection from database failed!";
exit;
} else {
$row = $db->sql_fetchrow($result);
if($row[pwd] == $pwd && $row[pwd] != "") {
$admintest = 1;
}
}

into

Code:

$sql = "SELECT * FROM ".$prefix."_authors WHERE aid='$aid'";
if (!($result = $db->sql_query($sql))) {
echo "Selection from database failed!";
exit;
} else {
$admdata = $db->sql_fetchrow($result);
if ($admdata['pwd'] == $pwd && $admdata['pwd'] != "") {
$admintest = 1;
} else {
$admdata = array();
}
}

Now use $admdata everywhere you find a direction to $radminsuper and any other.
Also remove all sql queries that recieve radminsuper or any other radmin value.

This will reduce the admin pages with 1-xxx queries depending how much "links.*.php" and "modules/*.php" files call the query.

Use $admdata like this: $admdata['radminsuper']

Corporal Joined: Oct 29, 2003 Posts: 51

What's the improvement like ? Is it worth doing such a big change ?

Posted: Sun Mar 14, 2004 3:50 pm

No it's not worthy if you are already below 1 sec generations

Sergeant Joined: Jan 18, 2004 Posts: 129

that coded slowed down my admin area, alot