SourceBans

Bug #71

Wrong query in 'nodemo' search

Added by Jannik Hartung 209 days ago. Updated 203 days ago.

Status:

Closed

Start:

06/10/2008

Priority:

Urgent

Due date:

Assigned to:

Olly Ginger

% Done:

100%

Category:

Web Panel

Target version:

1.1.1

Estimated time:

0.02 hours

Description

I'm sorry, I forgot to use ".DB_PREFIX." instead of my testing "sb" .. the "_" is missing in /pages/page.banlist.php in lines 172+173:

case "nodemo":
      $where = "WHERE BA.aid = '".$value."' AND NOT EXISTS (SELECT DM.demid FROM ".DB_PREFIX."_demos AS DM WHERE DM.demid = BA.bid)";
      $ban_where = "WHERE aid = '".$value."' AND NOT EXISTS (SELECT DM.demid FROM ".DB_PREFIX."_demos AS DM WHERE DM.demid = bid)";
break;