<?php

    $sql['host'] = '54.39.133.123:1433';
	$sql['user'] = 'sa';
	$sql['password'] = 'Vultr123';
	$sql['database'] = 'MuOnline';

	$con = mssql_connect($sql['host'],$sql['user'],$sql['password']) or die(mssql_get_last_message());
	mssql_select_db($sql['database'], $con) or die(mssql_get_last_message());

	$run = mssql_query("UPDATE PcPointData SET PcPoint = (PcPoint + 40) WHERE AccountID COLLATE DATABASE_DEFAULT IN (SELECT C.AccountID FROM Guildmember AS G INNER JOIN Character AS C ON G.Name = C.Name WHERE G.G_Name = (SELECT TOP 1 OWNER_GUILD FROM MuCastle_DATA))") or die(mssql_get_last_message());

	$run2 = mssql_query("UPDATE PcPointData SET PcPoint = (PcPoint + 40) WHERE AccountID COLLATE DATABASE_DEFAULT IN (SELECT C.AccountID FROM Guildmember AS G INNER JOIN Character AS C ON G.Name = C.Name WHERE G.G_Name IN (SELECT G_Name FROM Guild where G_Union > 0))") or die(mssql_get_last_message());

	if($run || $run2) {
		echo "Reward added!";
	} else {
		die(mssql_get_last_message());
	}