<?php
defined (
'main'
)
or
die
(
'no direct access'
);
$list
=
"1"
; # anzahl der Nextwars
die
aufgelistet werden sollen
echo
'<table width="100%" border="0" cellpadding="2" cellspacing="0">'
;
$akttime
=
date
(
'Y-m-d'
);
$erg
= @db_query(
"SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as time,tag,`mod`,gegner, id, game FROM prefix_wars WHERE status = 2 AND datime >= '"
.
$akttime
.
"' ORDER BY datime,id DESC LIMIT $list"
);
if
( @db_num_rows(
$erg
) == 0 ) {
}
else
{
while
(
$row
= @db_fetch_object(
$erg
) ) {
$mod
=
''
;
$row2
[
'reg'
]=
''
;
$hat
=
'haben'
;
$row
->tag = (
empty
(
$row
->tag) ?
$row
->gegner :
$row
->tag );
$mod
=
explode
(
'on'
,
$row
->mod);
$result
= db_query(
"SELECT COUNT(*)as reg FROM prefix_warmember WHERE wid = "
.
$row
->id.
" AND aktion = 1"
) ;
$row2
= db_fetch_assoc(
$result
);
if
(
$row2
[
'reg'
]<=1){
$hat
=
'hat'
;}
echo
'<tr><td>'
.get_wargameimg(
$row
->game).
'</td></tr><tr>'
;
echo
'<td><a class="nextwars" href="index.php?wars-more-'
.
$row
->id.
'">'
;
echo
$row
->time.
' - '
.
$row
->tag.
'</a></td></tr><tr><td>Es '
.
$hat
.
' sich '
.
$row2
[
'reg'
].
' von '
.
$mod
[
'0'
].
' angemeldet.</td></tr>'
;
}
}
$timej
=
date
(
'Y-m-d H:i:s'
);
$erg
= @db_query(
"SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as wartime, DATE_FORMAT(datime,'%d') as tag, DATE_FORMAT(datime,'%s') as sek, DATE_FORMAT(datime,'%i') as min, DATE_FORMAT(datime,'%H') as stu, datime, status, id FROM prefix_wars WHERE status = '2' and datime >= '"
.
$timej
.
"' order by datime ASC limit 1"
);
if
( mysql_num_rows(
$erg
) == 0 ) {
echo
'<tr><td align="center">kein War geplant</td></tr>'
;
}
else
{
$row
= mysql_fetch_object(
$erg
);
echo
'<tr><td align="center"><u>Es geht los in:</u></td></tr>'
;
echo
'<tr><td><form name="countdownform"><input class="Chead" size="22" name="countdowninput" readonly="readonly" /></form></td></tr>'
;
}
echo
'</table>'
;
?>
<script type=
"text/javascript"
>
var
jahr=2222, monat=3, tag=<?php
echo
$row
->tag; ?>, stunde=<?php
echo
$row
->stu; ?>, minute=<?php
echo
$row
->min; ?>, sekunde=<?php
echo
$row
->sek; ?>;
var
zielDatum=
new
Date
(jahr,monat-1,tag,stunde,minute,sekunde);
function
countdown() {
startDatum=
new
Date
();
if
(startDatum<=zielDatum) {
var
jahre=0, monate=0, tage=0, stunden=0, minuten=0, sekunden=0;
if
(startDatum<zielDatum) {
while
(startDatum<zielDatum) {
if
(startDatum.setFullYear(startDatum.getFullYear()+1)<=zielDatum) jahre++;
}
startDatum.setFullYear(startDatum.getFullYear()-1);
}
var
restTage=0;
var
m=startDatum.getMonth();
if
(m==1-1|| m==3-1||m==5-1||m==7-1||m==8-1||m==10-1||m==12-1)
restTage=31-startDatum.
getDate
();
else
if
(m==4-1|| m==6-1||m==9-1||m==11-1) restTage=30-startDatum.
getDate
();
else
if
(m==2-1) {
if
(startDatum.getFullYear()% 4==0 && (startDatum.getFullYear()% 100!=0
|| startDatum.getFullYear()% 400==0))
restTage=29-startDatum.
getDate
();
else
restTage=28-startDatum.
getDate
();
}
var
startTag=startDatum.
getDate
();
var
zielTag=zielDatum.
getDate
();
startDatum.setDate(1);
zielDatum.setDate(1);
if
(startDatum<zielDatum) {
while
(startDatum<zielDatum) {
if
(startDatum.setMonth(startDatum.getMonth()+1)<=zielDatum) monate++;
}
startDatum.setMonth(startDatum.getMonth()-1);
}
if
(startDatum.getMonth()==zielDatum.getMonth()) {
if
(startTag<=zielTag) startDatum.setDate(startTag);
else
{
monate--;
tage=restTage+1;
}
}
else
{
startDatum.setMonth(startDatum.getMonth()+1);
if
(startTag>=zielTag) tage=restTage+1;
else
{
monate++;
startDatum.setDate(startTag);
}
}
zielDatum.setDate(zielTag);
restTage=Math.
floor
((zielDatum-startDatum)/(24*60*60*1000));
startDatum.setTime(startDatum.getTime()+restTage*24*60*60*1000);
tage+=restTage;
stunden=Math.
floor
((zielDatum-startDatum)/(60*60*1000));
startDatum.setTime(startDatum.getTime()+stunden*60*60*1000);
minuten=Math.
floor
((zielDatum-startDatum)/(60*1000));
startDatum.setTime(startDatum.getTime()+minuten*60*1000);
sekunden=Math.
floor
((zielDatum-startDatum)/1000);
(tage!=1)?tage=tage+
" T | "
:tage=tage+
" Tag, "
;
(stunden!=1)?stunden=stunden+
" ST | "
:stunden=stunden+
" St "
;
(minuten!=1)?minuten=minuten+
" M | "
:minuten=minuten+
" Minute und "
;
if
(sekunden<10) sekunden=
"0"
+sekunden;
(sekunden!=1)?sekunden=sekunden+
" S"
:sekunden=sekunden+
" Sekunde"
;
document.countdownform.countdowninput.value=
tage+stunden+minuten+sekunden;
setTimeout(
"countdown()"
,200);
}
else
document.countdownform.countdowninput.value=
"0 Jahre, 0 Monate, 0 Tage, 0 Stunden, 0 Minuten und 00 Sekunden"
;
}
function
addEvent(elm, evType, fn, useCapture)
{
if
(elm.addEventListener){
elm.addEventListener(evType, fn, useCapture);
return
true;
}
else
if
(elm.attachEvent){
var
r = elm.attachEvent(
"on"
+evType, fn);
return
r;
}
else
{
alert(
"Handler could not be removed"
);
}
}
addEvent(window,
"load"
, countdown);
</script>