Self Whitelisting Help

[Chris2k]

hi

Basicly ive added a whitelist page on my site and ive added a self whitelisting form,box nd buton so people can add sites anytime, heres my code so far:


<?php

$connect = mysql_connect ("localhost", "user", "pass") or die ('Connection Fail!');

mysql_select_db("xtremedd_wcddl", $connect) or die ('lol');

$add = mysql_query("INSERT INTO wcddl_whitelist VALUES ('$addsiteurl')");

echo "Connected!"

?>

can some1 correct me..

Chris2k Reviewed by Chris2k on 7th Apr 2011. Self Whitelisting Help hi Basicly ive added a whitelist page on my site and ive added a self whitelisting form,box nd buton so people can add sites anytime, heres my code so far: <?php $connect = mysql_connect ("localhost", "user", "pass") or die ('Connection Fail!'); mysql_select_db("xtremedd_wcddl", $connect) or die ('lol'); Rating: 5

[CJ]

well lets go in algorithmic path...

• Check if that site is already whitelisted or not.
• If not whitelisted, chk the site for link back.
  If whitelisted display "Already in Whitelist".
• If linkback found, add to whitelist table
  If no link back, display "No Link Back"

lets code it....

$sitename = $_POST['sitename'];
$connect = mysql_connect ("localhost", "user", "pass") or die ('Connection Fail!');
mysql_select_db("xtremedd_wcddl", $connect) or die ('lol');
$x = mysql_query("select count(*) from wcddl_whitelist where sitename = ".trim($sitename));
if ($x==1)
{
  die ("Already Whitelisted");
}
elseif ($x==0)
{
  //curl_part to retrieve content from the said sitename & chk for link back 
  if($linkback==true)
  {
    $add = mysql_query("INSERT INTO wcddl_whitelist VALUES ('".$sitename."')");
    echo "Whitelisted!"
  }
  else
  {
    die('No Link Back');
  }
} 

This is just rough module, havent cheked it or anything. May be some mistakes which would be easy to rectify if u know some PHP Hope this helps

u have to still write in curl part in that code. where i have commented //curl_part

[Chris2k]

yes humour thats wot im aiming for m8.

__________________
Added after 1 Day 19 Hours:

ok here what i got;

<?php

$siteurl = $_POST['siteurl'];

$connect = mysql_connect ("localhost", "user", "p/w") or die ('Connection Fail!');

    mysql_select_db("xtremedd_wcddl", $connect) or die ('Database not found!');
    
    $check = mysql_query("select count(*) from wcddl_whitelist where url = ('$siteutl')");

    if ($check==1)
    {
    die ("Already Whitelisted");
    }
    elseif ($check==0)
{
    { 
    $add = mysql_query("INSERT INTO wcddl_whitelist (`url`) VALUES ('$siteurl')") or die ("Unable");
     
    echo "Connected!"
    }
}
?>

im gettin this error;


Parse error: syntax error, unexpected '}', expecting ',' or ';' in /home/xtremedd/public_html/addme.php on line 21

any1 can help?


updated with error

[CJ]

echo "Connected!"

add semicolon at end

[Chris2k]

did tht humour, now no error shows jus a blank page and the cccode isnt worrkin

[soft2050]

did tht humour, now no error shows jus a blank page and the cccode isnt worrkin

I haven't tried it yet.
But in ur edited php code. there's a error. Will install wcddl to check it.
On line 9

    $check = mysql_query("select count(*) from wcddl_whitelist where url = ('$siteutl')"); 

It should be:

    $check = mysql_query("select count(*) from wcddl_whitelist where url = ('$siteurl')"); 

Note: $siteutl to $siteurl

[Chris2k]

done it, here my final code;

<?php

$siteurl = $_POST['siteurl'];

$connect = mysql_connect ("localhost", "user", "p/w") or die ('Connection Fail!');

    mysql_select_db("xtremedd_wcddl", $connect) or die ('Database not found!');
    
    $check = mysql_query("select count(*) from wcddl_whitelist where url = ('$siteurl')") or die ("Already Whitelisted"); // Checks the whitelist to see if ur URL is already there.
    
    $add = mysql_query("INSERT INTO wcddl_whitelist (`url`) VALUES ('$siteurl')") or die ("Already Whitelisted");
     
    echo "You have been added to the whitelist!"
?>

now can some1 help medo, ccheck da sittte for linkback?

[CJ]

link back part should be easy, lets make a function to return true or false based on linkback

function linkback($link, $ururl) 
{ 
    $ch = curl_init($link); 
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
    curl_setopt($ch, CURLOPT_HEADER, 0); 
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); 
    curl_setopt($ch, CURLOPT_USERAGENT, 'Opera/9.80 (Windows NT 5.1; U; en) Presto/2.7.62 Version/11.01'); 
    $page = curl_exec($ch); 
    curl_close($ch);
    if (strpos($page,ururl)===false)
      return false;
    else
      return true
} 

[jomasaco]

I guess if the link back are commented will be accepted too
<!--LINK to Site--> //are accepted

Try always validate the users input data, never forget to safe the query's

$siteurl = $_POST['siteurl']; //need be in http 
$siteurl = parse_url(trim($siteurl)); //remove spaces split the url
$siteurl = $siteurl['host']; //get host
$siteurl = str_replace("www.","",$siteurl); //remove the www
$ipAddress = gethostbyname($siteurl);
if($ipAddress === $siteurl) //validate if real the site exists

INSERT INTO wcddl_whitelist (`url`) VALUES ('$siteurl')

INSERT INTO wcddl_whitelist (`url`) VALUES ('".mysql_real_escape_string($siteurl)."') //avoiding the sql injections are always an good idea 

[CJ]

^
Have u just copy pasted it or something, y would one need to know the IP ?

this part is helpful thou coz WCDDL saves hostname only

$siteurl = $_POST['siteurl']; //need be in http 
$siteurl = parse_url(trim($siteurl)); //remove spaces split the url
$siteurl = $siteurl['host']; //get host