function get_headline($id, $type)
{
// GET HEADLINE OF COMMENTTYPE
if ($type == "ne") {
$res = mysql_fetch_array(safe_query("SELECT headline FROM `" . PREFIX . "news_contents` WHERE newsID='" . $id . "'"));
return '<a href="index.php?site=news_comments&newsID=' . $id . '">' . $res['headline'] . '</a>';
}
if ($type == "ga") {
$res = mysql_fetch_array(safe_query("SELECT name FROM " . PREFIX . "gallery_pictures WHERE picID='" . $id . "'"));
return '<a href="index.php?site=gallery&picID=' . $id . '">' . $res['name'] . '</a>';
}
if ($type == "de") {
$res = mysql_fetch_array(safe_query("SELECT clantag1,clantag2 FROM " . PREFIX . "demos WHERE demoID='" . $id . "'"));
return '<a href="index.php?site=demos&action=showdemo&demoID=' . $id . '">' . $res['clantag1'] . ' vs. ' . $res['clantag2'] . '</a>';
}
if ($type == "ar") {
$res = mysql_fetch_array(safe_query("SELECT title FROM " . PREFIX . "articles WHERE articlesID='" . $id . "'"));
return '<a href="index.php?site=articles&action=show&articlesID=' . $id . '">' . $res['title'] . '</a>';
}
if ($type == "cw") {
$res = mysql_fetch_array(safe_query("SELECT squad,opponent FROM " . PREFIX . "clanwars WHERE cwID='" . $id . "'"));
return '<a href="index.php?site=clanwars_details&cwID=' . $id . '">' . getsquadname($res['squad']) . ' vs. ' . $res['opponent'] . '</a>';
}
if ($type == "po") {
$res = mysql_fetch_array(safe_query("SELECT title FROM " . PREFIX . "polls WHERE pollID='" . $id . "'"));
return '<a href="index.php?site=polls&pollID=' . $id . '">' . $res['title'] . '</a>';
}
return '';
}
$bg1 = BG_1;
$bg2 = BG_2;
} else {
$bg1 = BG_3;
$bg2 = BG_4;
}
$date = date("d.m.y", $ds['date']);
$league = '<a href="' . $ds['leaguehp'] . '" target="_blank">' . $ds['league'] . '</a>';
$oppcountry = "[flag]" . $ds['oppcountry'] . "[/flag]";
$country = flags($oppcountry);
$opponent = '<a href="' . $ds['opphp'] . '" target="_blank"><b>' . $ds['opptag'] . '</b></a>';
$maps = $ds['maps'];
$hometeam = $ds['hometeam'];
$oppteam = $ds['oppteam'];
$server = $ds['server'];
$squad = '<a href="index.php?site=clanwars&action=showonly&id=' . $id . '&page=' . $page . '&sort=game&type=' . $type . '&only=squad"><b>' . getsquadname($ds['squad']) . '</b></a>';
if (file_exists('images/games/' . $ds['game'] . '.gif')) {
$pic = $ds['game'] . '.gif';
}
$game = '<a href="index.php?site=clanwars&action=showonly&id=' . $ds['game'] . '&page=' . $page . '&sort=game&type=' . $type . '&only=game"><img src="images/games/' . $pic . '" width="13" height="13" border="0" alt="" /></a>';
$homescr = array_sum(unserialize($ds['homescore']));
$oppscr = array_sum(unserialize($ds['oppscore']));
if ($homescr > $oppscr) {
$results = '<font color="' . $wincolor . '">' . $homescr . ':' . $oppscr . '</font>';
} elseif ($homescr < $oppscr) {
$results = '<font color="' . $loosecolor . '">' . $homescr . ':' . $oppscr . '</font>';
} else {
$results = '<font color="' . $drawcolor . '">' . $homescr . ':' . $oppscr . '</font>';
}
if (getanzcwcomments($ds['cwID'])) {
$details = '<a href="index.php?site=clanwars_details&cwID=' . $ds['cwID'] . '"><img src="images/icons/foldericons/newhotfolder.gif" alt="' . $_language->module['details'] . '" border="0" /> (' . getanzcwcomments($ds['cwID']) . ')</a>';
$error[] = $_language->module['wrong_security_code'];
} else {
$run = 1;
}
}
if (!count($error) and $run) {
$ergebnis = safe_query("SELECT userID FROM " . PREFIX . "squads_members WHERE joinmember='1' AND squadID='" . $squad . "'");
while ($ds = mysql_fetch_array($ergebnis)) {
$touser[] = $ds['userID'];
}
if ($touser[0] != "") {
$tmp_lang = new Language();
foreach ($touser as $id) {
$tmp_lang->set_language(getuserlanguage($id));
$tmp_lang->read_module('joinus');
$message = '[b]' . $tmp_lang->module['someone_want_to_join_your_squad'] . ' ' . mysql_real_escape_string(getsquadname($squad)) . '![/b]
' . $tmp_lang->module['nick'] . ' ' . $nick . '
' . $tmp_lang->module['name'] . ': ' . $name . '
' . $tmp_lang->module['age'] . ': ' . $age . '
' . $tmp_lang->module['mail'] . ': [email]' . $email . '[/email]
' . $tmp_lang->module['messenger'] . ': ' . $messenger . '
' . $tmp_lang->module['city'] . ': ' . $city . '
' . $tmp_lang->module['clan_history'] . ': ' . $clanhistory . '
' . $tmp_lang->module['info'] . ':
' . $info . '
';
sendmessage($id, $tmp_lang->module['message_title'], $message);
}
}
echo $_language->module['thanks_you_will_get_mail'];
function print_termine($tag, $month, $year)
{
global $wincolor;
global $loosecolor;
global $drawcolor;
global $userID;
global $_language;
$_language->read_module('calendar');
$pagebg = PAGEBG;
$border = BORDER;
$bghead = BGHEAD;
$bgcat = BGCAT;
$start_date = mktime(0, 0, 0, $month, $tag, $year);
$end_date = mktime(23, 59, 59, $month, $tag, $year);
unset($termin);
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "upcoming");
$anz = mysql_num_rows($ergebnis);
if ($anz) {
while ($ds = mysql_fetch_array($ergebnis)) {
if ($ds['type'] == "c") {
if ($ds['date'] >= $start_date && $ds['date'] <= $end_date) {
$date = date("d.m.Y", $ds['date']);
$time = date("H:i", $ds['date']);
$squad = getsquadname($ds['squad']);
$oppcountry = "[flag]" . $ds['oppcountry'] . "[/flag]";
$oppcountry = flags($oppcountry);
$opponent = $oppcountry . ' <a href="' . $ds['opphp'] . '" target="_blank">' . clearfromtags($ds['opptag']) . ' / ' . clearfromtags($ds['opponent']) . '</a>';
$maps = clearfromtags($ds['maps']);
$server = clearfromtags($ds['server']);
$league = '<a href="' . $ds['leaguehp'] . '" target="_blank">' . clearfromtags($ds['league']) . '</a>';
if (isclanmember($userID)) {
$warinfo = cleartext($ds['warinfo']);
} else {
$warinfo = $_language->module['you_have_to_be_clanmember'];
}
$players = "";
$announce = "";
$adminaction = '';
if (isclanmember($userID) or isanyadmin($userID)) {
$anmeldung = safe_query("SELECT * FROM " . PREFIX . "upcoming_announce WHERE upID='" . $ds['upID'] . "'");
if (mysql_num_rows($anmeldung)) {
$i = 1;
while ($da = mysql_fetch_array($anmeldung)) {
if ($da['status'] == "y") {
$fontcolor = $wincolor;
} elseif ($da['status'] == "n") {
$fontcolor = $loosecolor;
} else {
$fontcolor = $drawcolor;
}
if ($i > 1) {
$players .= ', <a href="index.php?site=profile&id=' . $da['userID'] . '"><font color="' . $fontcolor . '">' . getnickname($da['userID']) . '</font></a>';
} else {
$players .= '<a href="index.php?site=profile&id=' . $da['userID'] . '"><font color="' . $fontcolor . '">' . getnickname($da['userID']) . '</font></a>';
}
$i++;
}
} else {
$players = $_language->module['no_announced'];
}
if (issquadmember($userID, $ds['squad']) and $ds['date'] > time()) {
$announce = '• <a href="index.php?site=calendar&action=announce&upID=' . $ds['upID'] . '">' . $_language->module['announce_here'] . '</a>';
} else {
$announce = "";
}
if (isclanwaradmin($userID)) {
$adminaction = '<div align="right">
<input type="button" onclick="MM_openBrWindow(\'clanwars.php?action=new&upID=' . $ds['upID'] . '\',\'Clanwars\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=490\')" value="' . $_language->module['add_clanwars'] . '" />
<input type="button" onclick="MM_goToURL(\'parent\',\'index.php?site=calendar&action=editwar&upID=' . $ds['upID'] . '\');return document.MM_returnValue" value="' . $_language->module['edit'] . '" />
<input type="button" onclick="MM_confirm(\'' . $_language->module['really_delete'] . '\', \'calendar.php?action=delete&upID=' . $ds['upID'] . '\')" value="' . $_language->module['delete'] . '" /></div>';
} else {
$adminaction = '';
}
} else {
$players = $_language->module['access_member'];
}
$bg1 = BG_1;
$bg2 = BG_2;
$bg3 = BG_3;
$bg4 = BG_4;
eval("\$upcoming_war_details = \"" . gettemplate("upcoming_war_details") . "\";");
echo $upcoming_war_details;
}
} else {
if ($start_date <= $ds['date'] && $end_date >= $ds['date'] || $start_date >= $ds['date'] && $end_date <= $ds['enddate'] || $start_date <= $ds['enddate'] && $end_date >= $ds['enddate']) {
$date = date("d.m.Y", $ds['date']);
$time = date("H:i", $ds['date']);
$enddate = date("d.m.Y", $ds['enddate']);
$endtime = date("H:i", $ds['enddate']);
$title = clearfromtags($ds['title']);
$location = '<a href="' . $ds['locationhp'] . '" target="_blank">' . clearfromtags($ds['location']) . '</a>';
$dateinfo = cleartext($ds['dateinfo']);
$dateinfo = toggle($dateinfo, $ds['upID']);
$country = "[flag]" . $ds['country'] . "[/flag]";
$country = flags($country);
$players = "";
if (isclanmember($userID)) {
$anmeldung = safe_query("SELECT * FROM " . PREFIX . "upcoming_announce WHERE upID='" . $ds['upID'] . "'");
if (mysql_num_rows($anmeldung)) {
$i = 1;
while ($da = mysql_fetch_array($anmeldung)) {
if ($da['status'] == "y") {
$fontcolor = $wincolor;
} elseif ($da['status'] == "n") {
$fontcolor = $loosecolor;
} else {
$fontcolor = $drawcolor;
}
if ($i > 1) {
$players .= ', <a href="index.php?site=profile&id=' . $da['userID'] . '"><font color="' . $fontcolor . '">' . getnickname($da['userID']) . '</font></a>';
} else {
$players .= '<a href="index.php?site=profile&id=' . $da['userID'] . '"><font color="' . $fontcolor . '">' . getnickname($da['userID']) . '</font></a>';
}
$i++;
}
} else {
$players = $_language->module['no_announced'];
}
if (isclanmember($userID) and $ds['date'] > time()) {
$announce = '• <a href="index.php?site=calendar&action=announce&upID=' . $ds['upID'] . '">' . $_language->module['announce_here'] . '</a>';
} else {
$announce = '';
}
if (isclanwaradmin($userID)) {
$adminaction = '<div align="right"><input type="button" onclick="MM_goToURL(\'parent\',\'index.php?site=calendar&action=editdate&upID=' . $ds['upID'] . '\');return document.MM_returnValue" value="' . $_language->module['edit'] . '" /><input type="button" onclick="MM_confirm(\'' . $_language->module['really_delete'] . '\', \'calendar.php?action=delete&upID=' . $ds['upID'] . '\')" value="' . $_language->module['delete'] . '" /></div>';
} else {
$adminaction = '';
}
} else {
$players = $_language->module['access_member'];
$announce = '';
$adminaction = '';
}
$bg1 = BG_1;
$bg2 = BG_2;
$bg3 = BG_3;
$bg4 = BG_4;
eval("\$upcoming_date_details = \"" . gettemplate("upcoming_date_details") . "\";");
echo $upcoming_date_details;
}
}
}
} else {
echo $_language->module['no_entries'];
}
}
if ($ds['joinmember']) {
$join = '<select name="join[' . $ds['sqmID'] . ']"><option value="1" selected="selected">' . $_language->module['yes'] . '</option><option value="0">' . $_language->module['no'] . '</option></select>';
} else {
$join = '<select name="join[' . $ds['sqmID'] . ']"><option value="1">' . $_language->module['yes'] . '</option><option value="0" selected="selected">' . $_language->module['no'] . '</option></select>';
}
if ($ds['warmember']) {
$fight = '<select name="war[' . $ds['sqmID'] . ']"><option value="1" selected="selected">' . $_language->module['yes'] . '</option><option value="0">' . $_language->module['no'] . '</option></select>';
} else {
$fight = '<select name="war[' . $ds['sqmID'] . ']"><option value="1">' . $_language->module['yes'] . '</option><option value="0" selected="selected">' . $_language->module['no'] . '</option></select>';
}
$squads .= '<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td><b>' . $_language->module['squad'] . '</b></td>
<td><b>' . getsquadname($ds['squadID']) . '</b></td>
</tr>
<tr>
<td><b>' . $_language->module['position'] . '</b></td>
<td><input type="text" name="position[' . $ds['sqmID'] . ']" value="' . getinput($ds['position']) . '" size="60" />' . $activity . '</td>
</tr>
<tr>
<td><b>' . $_language->module['access_rights'] . '</b></td>
<td>' . $_language->module['joinus_admin'] . ': ' . $join . ' ' . $_language->module['fightus_admin'] . ': ' . $fight . '</td>
</tr>';
}
}
if (isnewsadmin($id)) {
$news = '<input type="checkbox" name="newsadmin" value="1" onmouseover="showWMTT(\'id1\')" onmouseout="hideWMTT()" checked="checked" />';
} else {
$news = '<input type="checkbox" name="newsadmin" value="1" onmouseover="showWMTT(\'id1\')" onmouseout="hideWMTT()" />';
echo '<br /><br />';
$headdate = '<a class="titlelink" href="index.php?site=awards&page=' . $page . '&sort=date&type=' . $type . '">' . $_language->module['date'] . ':</a>';
$headsquad = '<a class="titlelink" href="index.php?site=awards&page=' . $page . '&sort=squadID&type=' . $type . '">' . $_language->module['squad'] . ':</a>';
eval("\$awards_head = \"" . gettemplate("awards_head") . "\";");
echo $awards_head;
$n = 1;
while ($ds = mysql_fetch_array($ergebnis)) {
if ($n % 2) {
$bg1 = BG_1;
$bg2 = BG_2;
} else {
$bg1 = BG_3;
$bg2 = BG_4;
}
$date = date("d.m.Y", $ds['date']);
$squad = '<a href="index.php?site=members&action=showsquad&squadID=' . $ds['squadID'] . '&page=' . $page . '&sort=' . $sort . '&type=' . $type . '">' . getsquadname($ds['squadID']) . '</a>';
$award = cleartext($ds['award']);
$homepage = $ds['homepage'];
$rang = $ds['rang'];
if (isclanwaradmin($userID) || isnewsadmin($userID)) {
$adminaction = '<input type="button" onclick="MM_goToURL(\'parent\',\'index.php?site=awards&action=edit&awardID=' . $ds['awardID'] . '\');return document.MM_returnValue" value="' . $_language->module['edit'] . '" />
<input type="button" onclick="MM_confirm(\'really delete this award?\',\'index.php?site=awards&delete=true&awardID=' . $ds['awardID'] . '\')" value="' . $_language->module['delete'] . '" />';
} else {
$adminaction = '';
}
eval("\$awards_content = \"" . gettemplate("awards_content") . "\";");
echo $awards_content;
$n++;
}
eval("\$awards_foot = \"" . gettemplate("awards_foot") . "\";");
echo $awards_foot;
$results_1 = '<font color="' . $drawcolor . '">' . $homescr . '</font>';
$results_2 = '<font color="' . $drawcolor . '">' . $oppscr . '</font>';
}
if (isclanwaradmin($userID)) {
$adminaction = '<input type="button" style="margin-top:50px;" onclick="MM_openBrWindow(\'upload.php?cwID=' . $cwID . '\',\'Clanwars\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="' . $_language->module['upload_screenshot'] . '" />
<input type="button" onclick="MM_openBrWindow(\'clanwars.php?action=edit&cwID=' . $ds['cwID'] . '\',\'Clanwars\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="' . $_language->module['edit'] . '" />
<input type="button" onclick="MM_confirm(\'' . $_language->module['really_delete_clanwar'] . '?\',\'clanwars.php?action=delete&cwID=' . $ds['cwID'] . '\')" value="' . $_language->module['delete'] . '" />';
} else {
$adminaction = '';
}
$report = cleartext($ds['report']);
$report = toggle($report, $ds['cwID']);
if ($report == "") {
$report = "No Details Available.";
}
$squad = '' . getsquadname($ds['squad']) . '';
$opptag = getinput($ds['opptag']);
$oppteam = getinput($ds['oppteam']);
$server = getinput($ds['server']);
$hltv = getinput($ds['hltv']);
if (!empty($ds['hometeam'])) {
$array = unserialize($ds['hometeam']);
$n = 1;
foreach ($array as $id) {
if (!empty($id)) {
if ($n > 1) {
$hometeam .= ', <a href="index.php?site=profile&id=' . $id . '">' . getnickname($id) . '</a>';
$hometampic .= '<a href="index.php?site=profile&id=' . $id . '"><img src="images/avatars/' . getavatar($id) . '" alt="" style="margin-left:2px" /></a>';
} else {
$hometeam .= '<a href="index.php?site=profile&id=' . $id . '">' . getnickname($id) . '</a>';
$hometampic .= '<a href="index.php?site=profile&id=' . $id . '"><img src="images/avatars/' . getavatar($id) . '" alt="" style="margin-left:2px" /></a>';
# - Script runs under the GNU GENERAL PUBLIC LICENSE #
# - It's NOT allowed to remove this copyright-tag #
# -- http://www.fsf.org/licensing/licenses/gpl.html #
# #
# Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at), #
# Far Development by Development Team - webspell.org #
# #
# visit webspell.org #
# addon by esport-project.net #
# #
########################################################################
*/
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "awards ORDER BY date DESC LIMIT 0,4");
while ($ds = mysql_fetch_array($ergebnis)) {
$date = date("d.m.Y", $ds[date]);
$squad = '' . getsquadname($ds[squadID]) . '';
$award = cleartext($ds[award]);
$rangz = $ds['rang'];
if ($rangz == '1') {
$rang = '<img class="awards" src="images/awards/gold.png" alt="1st" title="1st" />';
} elseif ($rangz == '2') {
$rang = '<img class="awards" src="images/awards/silver.png" alt="2nd" title="2nd" />';
} elseif ($rangz == '3') {
$rang = '<img class="awards" src="images/awards/bronze.png" alt="3rd" title="3rd" />';
} elseif ($rangz == '4') {
$rang = '<img class="awards" src="images/awards/7th.png" alt="4th" title="4th" />';
} elseif ($rangz == '5') {
$rang = '<img class="awards" src="images/awards/7th.png" alt="5th" title="5th" />';
} elseif ($rangz == '6') {
$rang = '<img class="awards" src="images/awards/7th.png" alt="6th" title="6th" />';
} elseif ($rangz == '7') {
# #
# visit webspell.org #
# #
##########################################################################
*/
if (isset($site)) {
$_language->read_module('sc_upcoming');
}
$now = time();
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "upcoming WHERE date>= {$now} ORDER BY date LIMIT 0, " . $maxupcoming);
$n = 1;
while ($ds = mysql_fetch_array($ergebnis)) {
echo '<table width="100%" cellspacing="0" cellpadding="2">';
if ($ds['type'] == "c") {
$date = date("d.m.Y", $ds['date']);
$upsquad = getsquadname($ds['squad']);
if ($n % 2) {
$bg1 = BG_1;
$bg2 = BG_2;
} else {
$bg1 = BG_3;
$bg2 = BG_4;
}
$upurl = 'index.php?site=calendar&tag=' . date("d", $ds['date']) . '&month=' . date("m", $ds['date']) . '&year=' . date("Y", $ds['date']);
$opponent = $ds['opponent'];
eval("\$upcomingactions = \"" . gettemplate("upcomingactions") . "\";");
echo $upcomingactions;
} else {
$date = date("d.m.Y", $ds['date']);
$country = "[flag]" . $ds['country'] . "[/flag]";
$country = flags($country);
if ($anz) {
if (!isset($type)) {
$type = "DESC";
}
if ($type == "ASC") {
echo '<a href="index.php?site=challenge&type=DESC">' . $_language->module['sort'] . '</a> <img src="images/icons/asc.gif" width="9" height="7" border="0" alt="" /> ';
} else {
echo '<a href="index.php?site=challenge&type=ASC">' . $_language->module['sort'] . '</a> <img src="images/icons/desc.gif" width="9" height="7" border="0" alt="" /> ';
}
echo '<br /><br />';
$i = 0;
while ($ds = mysql_fetch_array($ergebnis)) {
$bg1 = $i % 2 ? BG_1 : BG_1;
$date = date("d.m.Y", $ds['date']);
$cwdate = date("d.m.Y - H:i", $ds['cwdate']);
$squad = getsquadname($ds['squadID']);
$oppcountry = "[flag]" . $ds['oppcountry'] . "[/flag]";
$country = flags($oppcountry);
$opponent = '<a href="' . $ds['opphp'] . '" target="_blank">' . clearfromtags($ds['opponent']) . '</a>';
$league = clearfromtags($ds['league']);
$map = clearfromtags($ds['map']);
$server = clearfromtags($ds['server']);
$info = cleartext($ds['info']);
$email = '<a href="mailto:' . mail_protect(cleartext($ds['email'])) . '">' . $ds['email'] . '</a>';
if (isset($ds['hp'])) {
if (!validate_url($ds['hp'])) {
$homepage = '';
} else {
$homepage = '<a href="' . $ds['hp'] . '" target="_blank"><img src="images/icons/hp.gif" border="0" width="14" height="14" alt="homepage" /></a>';
}
}
function print_cashbox($squadID, $id)
{
global $_language;
$_language->read_module('cash_box');
$bg1 = BG_1;
$bg2 = BG_2;
$pagebg = PAGEBG;
$border = BORDER;
$bghead = BGHEAD;
$bgcat = BGCAT;
global $wincolor;
global $loosecolor;
global $drawcolor;
global $userID;
if ($id) {
$squadergebnis = safe_query("SELECT squad FROM " . PREFIX . "cash_box WHERE cashID='" . $id . "'");
$dv = mysql_fetch_array($squadergebnis);
$squadID = $dv['squad'];
}
$costs_squad = '';
if ($squadID == 0) {
$usersquad = $_language->module['clan'];
} else {
$ergebnis_squad = safe_query("SELECT * FROM " . PREFIX . "cash_box_payed, " . PREFIX . "cash_box WHERE " . PREFIX . "cash_box_payed.payed='1' AND " . PREFIX . "cash_box_payed.cashID=" . PREFIX . "cash_box.cashID AND " . PREFIX . "cash_box.squad = '" . $squadID . "'");
$anz_squad = mysql_num_rows($ergebnis_squad);
$costs_squad = 0.0;
if ($anz_squad) {
while ($dss = mysql_fetch_array($ergebnis_squad)) {
$costs_squad += $dss['costs'];
}
}
$ergebnis_squad = safe_query("SELECT * FROM " . PREFIX . "cash_box WHERE squad='{$squadID}'");
$anz_squad = mysql_num_rows($ergebnis_squad);
if ($anz_squad) {
while ($dss = mysql_fetch_array($ergebnis_squad)) {
$costs_squad -= $dss['totalcosts'];
}
}
$costs_squad = ' (' . $costs_squad . ' euro)';
$usersquad = $_language->module['squad'] . ": " . getsquadname($squadID);
}
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "cash_box WHERE squad='" . $squadID . "' ORDER BY paydate DESC LIMIT 0,1");
echo '<br /><br /><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" width="180"><b>' . $usersquad . $costs_squad . '</b></td>
</tr>
<tr>
<td height="1" bgcolor="' . BG_1 . '" width="100%" colspan="4"></td>
</tr>
<tr><td height="15"></td></tr>';
echo '<tr>
<td valign="top" width="180">';
if (mysql_num_rows($ergebnis)) {
$ds = mysql_fetch_array($ergebnis);
if (!$id) {
$id = $ds['cashID'];
}
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "cash_box WHERE cashID='{$id}'");
$ds = mysql_fetch_array($ergebnis);
$date = date("d.m.Y", $ds['date']);
$paydate = date("d.m.Y", $ds['paydate']);
$bezahlen = safe_query("SELECT * FROM " . PREFIX . "cash_box_payed WHERE cashID='{$id}' AND payed='1' ");
$payed = mysql_num_rows($bezahlen);
$konto = cleartext($ds['konto']);
$usage = $ds['usedfor'];
if (iscashadmin($userID)) {
$adminaction = '<input type="button" onclick="MM_goToURL(\'parent\',\'index.php?site=cash_box&action=edit&id=' . $id . '\');return document.MM_returnValue" value="' . $_language->module['edit'] . '" /> <input type="button" onclick="MM_confirm(\'' . $_language->module['really_delete'] . '\', \'cash_box.php?delete=true&id=' . $id . '\')" value="' . $_language->module['delete'] . '" />';
}
eval("\$cash_box_usage = \"" . gettemplate("cash_box_usage") . "\";");
echo $cash_box_usage;
$all = safe_query("SELECT * FROM " . PREFIX . "cash_box WHERE squad='" . $squadID . "' ORDER BY paydate DESC");
echo '<br /><br />';
while ($ds = mysql_fetch_array($all)) {
echo '• <a href="index.php?site=cash_box&id=' . $ds['cashID'] . '&squad=' . $squadID . '"><b>' . $ds['usedfor'] . '</b></a><br />';
}
echo '</td><td width="10"> </td>
<td valign="top">';
$members = array();
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "user ORDER BY nickname");
while ($du = mysql_fetch_array($ergebnis)) {
if ($squadID == 0) {
if (isclanmember($du['userID'], $squadID)) {
$members[] = $du['userID'];
}
} else {
if (issquadmember($du['userID'], $squadID)) {
$members[] = $du['userID'];
}
}
}
eval("\$cash_box_head = \"" . gettemplate("cash_box_head") . "\";");
echo $cash_box_head;
if (count($members)) {
foreach ($members as $usID) {
$ergebnis = safe_query("SELECT * FROM " . PREFIX . "cash_box_payed WHERE userID='{$usID}' AND cashID='{$id}'");
$du = mysql_fetch_array($ergebnis);
$user = '******' . $usID . '"><b>' . getnickname($usID) . '</b></a>';
if ($du['payed']) {
$paydate = date("d.m.Y", $du['date']);
$payed = '<font color="' . $wincolor . '">' . $_language->module['paid'] . ': ' . $paydate . '</font>';
} else {
$payed = '<font color="' . $loosecolor . '">' . $_language->module['not_paid'] . '</font>';
}
if (iscashadmin($userID)) {
if ($du['costs']) {
$bg = BG_1;
$costs = $du['costs'];
} else {
$costs = "";
$bg = BG_2;
}
$payment = '<input type="text" size="7" name="payid[' . $usID . ']" value="' . $costs . '" dir="rtl" /> €';
} else {
if ($du['costs']) {
$costs = '<font color="' . $wincolor . '"><b>' . $du['costs'] . ' €</b></font>';
$bg = BG_1;
} else {
$costs = '<font color="' . $loosecolor . '">0.00 €</font>';
$bg = BG_2;
}
$payment = $costs;
}
eval("\$cash_box_content = \"" . gettemplate("cash_box_content") . "\";");
echo $cash_box_content;
}
}
if (iscashadmin($userID)) {
$admin = '<input type="hidden" name="id" value="' . $id . '" /><input type="submit" name="pay" value="' . $_language->module['update'] . '" />';
}
eval("\$cash_box_foot = \"" . gettemplate("cash_box_foot") . "\";");
echo $cash_box_foot;
} else {
echo $_language->module['no_entries'];
}
echo '</td></tr></table>';
}
$results_1 = '<font color="' . $drawcolor . '">' . $homescr . '</font>';
$results_2 = '<font color="' . $drawcolor . '">' . $oppscr . '</font>';
}
if (isclanwaradmin($userID)) {
$adminaction = '<input type="button" onclick="MM_openBrWindow(\'upload.php?cwID=' . $cwID . '\',\'Clanwars\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="' . $_language->module['upload_screenshot'] . '" />
<input type="button" onclick="MM_openBrWindow(\'clanwars.php?action=edit&cwID=' . $ds['cwID'] . '\',\'Clanwars\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="' . $_language->module['edit'] . '" />
<input type="button" onclick="MM_confirm(\'' . $_language->module['really_delete_clanwar'] . '?\',\'clanwars.php?action=delete&cwID=' . $ds['cwID'] . '\')" value="' . $_language->module['delete'] . '" />';
} else {
$adminaction = '';
}
$report = cleartext($ds['report']);
$report = toggle($report, $ds['cwID']);
if ($report == "") {
$report = "n/a";
}
$squad = '<a href="index.php?site=clanwars&action=showonly&only=squad&id=' . $ds['squad'] . '"><b>' . getsquadname($ds['squad']) . '</b></a>';
$opptag = getinput($ds['opptag']);
$oppteam = getinput($ds['oppteam']);
$server = getinput($ds['server']);
$hltv = getinput($ds['hltv']);
if (!empty($ds['hometeam'])) {
$array = unserialize($ds['hometeam']);
$n = 1;
foreach ($array as $id) {
if (!empty($id)) {
if ($n > 1) {
$hometeam .= ', <a href="index.php?site=profile&id=' . $id . '">' . getnickname($id) . '</a>';
} else {
$hometeam .= '<a href="index.php?site=profile&id=' . $id . '">' . getnickname($id) . '</a>';
}
$n++;
