Optimization - functions.php

[David Rubin]

I Just thought I would point out you can do all of the below that is commented out with a single query. It is not a great idea to do more quries then are nessary because it adds load to the db server(or local host) and running quries require a request to be made to an external application.

I have added a fix this. see below.

## User Settings
/*
$query12 = mysql_query("SELECT username FROM user");
$username = mysql_result($query12, 0);

$query13 = mysql_query("SELECT password FROM user");
$password = mysql_result($query13, 0);

$query14 = mysql_query("SELECT lastlogin FROM user");
$lastlogin = mysql_result($query14, 0);

$query15 = mysql_query("SELECT lastip FROM user");
$lastip = mysql_result($query15, 0);
*/
//The above was replaced by one single query. Less load on the server.
$query_user = mysql_query("SELECT password,username,lastip,lastlogin FROM user");
$result_user= mysql_fetch_assoc($query_user);
$username =$result_user['username'];
$password =$result_user['password'];
$lastlogin=$result_user['lastlogin'];
$lastip =$result_user['lastip'];

[Dr Small (drsmall)]

Thanks for reporting this, drubin.
I have fixed the bug, and pushed the fix up to the development branch.