<?php


/*DATABASE ACCESS*/
$db_host='localhost';
$db_user='nazwa_uzytkonika';
$db_pass="haslo";
$db_base="baza danych";
$db_prefix="wrm_";

/*CONNECTING TO DATABASE*/
@mysql_connect ($db_host,$db_user,$db_pass) or die("Ups! Baza nie łączy!");

@mysql_select_db ($db_base) or die("Ups! Baza nie łączy!");

//w teorii nie musisz uzywac tych segmentów, bo już jesteś połączony z bazą, ale dla pewności ; )

//IN-RAIDER DATE FUNCTION
setlocale(LC_TIME, "pl", "pl_PL", "polish");
function new_date($format, $timestamp, $tz) {
	$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return strftime($format, $timestamp);
}


//SELECTING RECORDS
$time = mktime(0,0,0);
$num = mysql_query("SELECT COUNT(raid_id) FROM `".$db_prefix."raids` WHERE `old`='0' AND `invite_time`>='".$time."';");
echo "<center>Nadchodzące raidy</center>";
if($num == 0) echo "Brak nadchodzących raidów";
else {
	//CREATING TABLE
		echo '
		<table width=100%>
		<tr>
			<td></td><td>Raid</td><td>Data</td><td>Godzina</td><td>Zapisz się!</td>
		</tr>';
	$sql = mysql_query("SELECT * FROM `".$db_prefix."raids` WHERE `old`='0' AND `invite_time`>='".$time."' LIMIT 0,3;");
	while($raid = @mysql_fetch_array($sql))
	{
		$query = mysql_query("SELECT * FROM `".$db_prefix."events` WHERE `event_id`='".$raid['event_id']."';") or die ("lol");
		$patch=mysql_fetch_array($query);
		echo '
		<tr>
			<td width="75"><img src="raider/'.$patch["icon_path"].'"></td><td>'.$raid["location"].'</td><td>'.new_date("%A, %e %B",$raid['start_time'],200).'</td><td>'.new_date("%R",$raid['invite_time'],200).'</td><td><a href="/raider/view.php?mode=view&raid_id='.$raid["raid_id"].'" target="_blank">fajeczka</a></td>
		</tr>';

	}

		echo '
		</table>';
}

?>