Warning page style included, you need to change the html to be in line with your style.
You will need to add extra tables to the database if you do not currently have them.
Blacklist SQL Queries:
ALTER TABLE wcddl_blacklist ADD COLUMN reason VARCHAR(255)
ALTER TABLE wcddl_blacklist ADD COLUMN dat VARCHAR(15) NOT NULL
ALTER TABLE wcddl_blacklist ADD COLUMN email varchar(50)
Whitelist Queries:
ALTER TABLE wcddl_whitelist ADD COLUMN reason VARCHAR(255)
ALTER TABLE wcddl_whitelist ADD COLUMN dat VARCHAR(15) NOT NULL
ALTER TABLE wcddl_whitelist ADD COLUMN email varchar(50)
Create a new file named wcddl_searchbw.php and paste the following in it and upload it to your modules folder:
<?php
/*BEGIN_INFO
Show if an Site are white/black Listed!<br>
by jomasaco.
END_INFO*/
if(!defined("WCDDL_GUTS"))
exit;
$modEnabled = true; //Change to false if don't use
if($modEnabled) {
$outbw = '<form action="'.$_SERVER['PHP_SELF'].'" method="post">
<fieldset>
<div class="legend">Check White/Black List:</div>
<div class="form_row">
<div class="form_value"><input type="text" size="32" class="text" value="http://" name="url" /></div>
<input class="button" type="submit" name="submit" value="Submit" />
</div></fieldset></form>';
if(!empty($_POST)) {
$surl = $_POST['url'];
$surl = parse_url(trim($surl)); //remove spaces split the url
$surl = $surl['host']; //get host
$surl = str_replace("www.","",$surl); //remove the www
if (!preg_match('#^[A-Z0-9.-]+\.[A-Z]{2,4}$#i', $surl)) //validate url
{
$outbw .= '<br /><div class="error"> Please enter a valid Site Url. <b>'.$surl.'</div></b>';
}
else { //blacklist
$sql = mysql_query("select * from wcddl_blacklist WHERE url = '".mysql_real_escape_string($surl)."'");
if(mysql_num_rows($sql) > 0) {
$outbw .= '<div class="error">'.$surl.' In <b>Blacklist</b><br />';
while ($row = mysql_fetch_array($sql)){
$outbw .= '<br/> Site Url: '.$row['url'];
$outbw .= '<br/> Date: '.date("d-m-y",$row['dat']);
$outbw .= '<br/> Reason: '.$row['reason'].'</div>';
}
}
else { //whitelist
$sql = mysql_query("select * from wcddl_whitelist WHERE url = '".mysql_real_escape_string($surl)."'");
if(mysql_num_rows($sql) > 0) {
$outbw .= '<div class="success">'.$surl.' In <b>Whitelist</b>.<br />';
while ($row = mysql_fetch_array($sql)){
$outbw .= '<br /> Date: '.date("d-m-y",$row['dat']);
$outbw .= '<br/> Site Url: '.$row['url'].'</div>';
}
}
else{
$outbw .= '<br /><div class="notice">'.$surl.' NOT In <b>Whitelist</b> or <b>Blacklist</b>.</div><br />';
}
}
}
}
//show the lists
//blacklist
$outbw .= '<div class="clearer"> </div>';
$outbw .= '<div class="post">
<div class="post_title text_center"><div class="error"><h1>BLACKLISTED</h1></div></div>
<div class="post_body">';
$color1 = " class=\"even\"";
$color2 = '';
$row_count = 0;
$getit = @mysql_query("SELECT * FROM wcddl_blacklist ORDER BY dat DESC limit 20");
$outbw .= '<br /><br /><table class="data_table"><tr><th>URL</th><th>DATE</th><th>REASON</th></tr>';
while ($row = mysql_fetch_array($getit)) {
$row_color = ($row_count % 2) ? $color1 : $color2;
$data = date("d-m-y",$row[dat]);
$outbw .='<tr'.$row_color.'>
<td><strong>'.$row['url'].'</strong></td><td>'.$data.'</td><td>'.$row['reason'].'</td>
</tr>';
$row_count++;
}
$outbw .= '</table>';
$outbw .= '</div></div>';
//whitelist
$outbw .= '<div class="post">
<div class="post_title text_center"><div class="success"><h1>WHITELISTED</h1></div></div>
<div class="post_body">';
$outbw .= '<div class="clearer"> </div>';
$getit = @mysql_query("SELECT * FROM wcddl_whitelist ORDER BY dat DESC limit 20");
$outbw .= '<br /><br /><table class="data_table"><tr><th>URL</th><th>DATE</th></tr>';
while ($row = mysql_fetch_array($getit)) {
$row_color = ($row_count % 2) ? $color1 : $color2;
$data = date("d-m-y",$row[dat]);
$outbw .= '<tr'.$row_color.'>
<td><strong>'.$row['url'].'</strong></td><td>'.$data.'</td>
</tr>';
$row_count++;
}
$outbw .= '</table>';
$outbw .= '</div></div>';
$core->setTemplateVar("searchbw",$outbw);
}
?>
Add the following where you would like it to show:
<?=$core->templateVar("searchbw")?>
I have updated the thread and it should work.
