Cool, I was never good at german, I just knew enough to use the hacking programs they made I have tried every possible combination of " I can think of, could the problem be something else?
[php]
<?php
define(NULL_KEY,"00000000-0000-0000-0000-000000000000");
$verified = "1";
$data = $_GET['data'];//gets the info after data= in the url and declares it $data
$key = file_get_contents('http://w-hat.com/name2key/?terse=1&name=' .urlencode( $data));
$link = mysql_connect("localhost", "ghtyrre_admin", "dbase") or die('Could not connect: ' . mysql_error());
mysql_select_db("bizcards_database") or die('Could not select database');
$query = "SELECT * FROM users WHERE username = '".$data."'" or die(mysql_error());
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
//find $data in the username section of the database, becuase it is a name if not found return error
//if found get the key from the same line, if the key matches $key write a 1 to the verify of the same line
if (!$result) {
echo "You have not registered this name with us";
}
if($key == NULL_KEY)
{
echo "Your name is not in the database Please contact Draco Kamachi";
}
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
if ($line['key'] != $key)
{
echo "NO MATCH"; //how can this happen
}
if ($line['key'] == $key)
{
echo "Account Verified";
$insert = 'UPDATE `users` SET `verified`=1 WHERE `username`="'.mysql_escape_string($data).'"';
VALUES ('".$verified."');
$add_member = mysql_query($insert) or die(mysql_error());
}
}
mysql_free_result($result);
mysql_close($link);
?>
[/php]
Here is the exact output less the file location including echos
Account Verified
Fatal error: Call to undefined function: values() in – on line 32