Cosmetical isuue in block-ScrollingSentinel.php

New Member Joined: Oct 30, 2004 Posts: 21

Problems is around tablenames.

Find:

Code:




$result = $db->sql_query("SELECT ip_addr, reason FROM $prefix"._nsnst_blocked_ips." ORDER BY date DESC LIMIT 30");


while (list($ip_addr, $ip_reason) = $db->sql_fetchrow($result)) {


  if((is_admin($admin) AND $ab_config['display_link']==1) OR ((is_user($user) OR is_admin($admin)) AND $ab_config['display_link']==2) OR $ab_config['display_link']==3) {


    $lookupip = str_replace("*", "0", $ip_addr);


    $content .= "<b><big>&middot;</big></b>&nbsp;<a href=\"".$ab_config['lookup_link']."$lookupip\" target=\"_blank\">$ip_addr</a>\n";


  } else {


    $content .= "<b><big>&middot;</big></b>&nbsp;$ip_addr\n";


  }


  if((is_admin($admin) AND $ab_config['display_reason']==1) OR ((is_user($user) OR is_admin($admin)) AND $ab_config['display_reason']==2) OR $ab_config['display_reason']==3) {


    $result2 = $db->sql_query("SELECT reason FROM $prefix"._nsnst_blockers." WHERE blocker='$ip_reason'");


    list($reason) = $db->sql_fetchrow($result2);


    $reason = str_replace("Abuse-","",$reason);


    $content .= "&nbsp;-&nbsp;$reason\n";


  }


  $content .= "<br />\n";


}

Replace

Code:




$result = $db->sql_query("SELECT ip_addr, reason FROM ".$prefix."_nsnst_blocked_ips ORDER BY date DESC LIMIT 30");


while (list($ip_addr, $ip_reason) = $db->sql_fetchrow($result)) {


  if((is_admin($admin) AND $ab_config['display_link']==1) OR ((is_user($user) OR is_admin($admin)) AND $ab_config['display_link']==2) OR $ab_config['display_link']==3) {


    $lookupip = str_replace("*", "0", $ip_addr);


    $content .= "<b><big>&middot;</big></b>&nbsp;<a href=\"".$ab_config['lookup_link']."$lookupip\" target=\"_blank\">$ip_addr</a>\n";


  } else {


    $content .= "<b><big>&middot;</big></b>&nbsp;$ip_addr\n";


  }


  if((is_admin($admin) AND $ab_config['display_reason']==1) OR ((is_user($user) OR is_admin($admin)) AND $ab_config['display_reason']==2) OR $ab_config['display_reason']==3) {


    $result2 = $db->sql_query("SELECT reason FROM ".$prefix."_nsnst_blockers WHERE blocker='$ip_reason'");


    list($reason) = $db->sql_fetchrow($result2);


    $reason = str_replace("Abuse-","",$reason);


    $content .= "&nbsp;-&nbsp;$reason\n";


  }


  $content .= "<br />\n";


}