Little Proxy List Script 2.0 bug

[nux]

Hey everyone. I've gotten a few messages about why the category listings work properly on Proxy Sites - #1 Proxy List. I thought I'd make a public post about this, to save anyone else the head ache.

There is a bug in category.php that outputs all the proxies, no matter what category you select. This is a simple fix, and requires some minor editing of the category.php file.

Once open, goto the $sql command you will see something like this:

$sql = "SELECT id, proxy, hits, time, responsetime
FROM {$db_tp}proxy
ORDER BY time DESC
LIMIT $start, $cfg[per_page_1]";

Change it to:

$sql = "SELECT id, proxy, hits, time, responsetime
FROM {$db_tp}proxy
WHERE cat_id = $id
ORDER BY time DESC
LIMIT $start, $cfg[per_page_1]";

You're just adding the WHERE cat_id = $id

Hope that helps.

-nux