if (!in_array($_FILES['image']['type'],$types_array))
{
echo "File type not allowed!";
}
exit;
{
// MySQL Connection Variables here.
$hostname = "--"; // default value but change this value as required.
$user = "----"; // change this to your username
$pass = "1-----tg"; // change this to your MySQL db password
$dbname = "---"; // Change this to your database name
$connection = mysql_connect("$hostname" , "$user" , "$pass");
$db = mysql_select_db($dbname , $connection) or die ("Cannot select db");
$date2 = date("jS M, Y h:iA");
$result=MYSQL_QUERY("INSERT INTO screenshots (filename, name, description, date)".
"VALUES ('$image','$member','$text','$date2')") or die ("Data not inserted into database");
$id= mysql_insert_id();
print "Your screenshot has been added. Click <a href='http://tibiagallery.co.uk/members/?acc=screenshots'>here</a> to see it.";
$result1=MYSQL_QUERY("UPDATE screenshots SET filename = $id WHERE id = $id");
$pointscheck = mysql_query("SELECT * FROM membership WHERE name = '$member'");
$points = mysql_fetch_array($pointscheck);
$point = $points['points'] + 1;
$addpoint = mysql_query("UPDATE membership SET points = '$point' WHERE name = '$member'");
MYSQL_CLOSE();
move_uploaded_file($_FILES['image']['tmp_name'], "".$uploads."/".$_FILES['image']['name']) or die ("Couldn't upload file!");