Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
So. 17.03.2013
01:36 Uhr
#1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/XXX/html/include/includes/func/db/mysql.php on line 71
So. 17.03.2013
12:45 Uhr
#3
Zitat geschrieben von Mairu
$erg = db_query("SELECT a.id,a.oid,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' ORDER BY a.datime");
if ( db_num_rows ( $erg ) == 0 ) {
echo '<tr class="Cmite"><td colspan="4"><i>There are no upcoming Matches!</i></td></tr>';
} else {
while ($row = db_fetch_assoc($erg) ) {
if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$row['page'] = get_opponent_details('homepage', $row['oid']);
$row['team'] = get_wargameimg($row['game']).' '.$row['team'];
$row['class'] = $class;
$row['gegner'] = get_opponent_details('name',$row['oid']);
$tpl->set_ar_out($row,1);
<?php
# Copyright Original Dateien und Einträge by: Manuel Staechele
# Support: www.ilch.de
# Profil Mod by: orsnipe
# Profil Mod Code by: orsnipe, IRvD, Lord|Schirmer & www.ilch.de/forum
# Profil Mod Copyright by: www.capfx.de
defined ('main') or die ( 'no direct access' );
$uid = $menu->get(2);
######### Zufalls Gallerybild
$randbild = '';
$res = db_query('SELECT id, endung FROM `prefix_usergallery` WHERE `uid` = "'.$uid.'" ORDER BY rand() LIMIT 5');
if (db_num_rows($res))
{
while ($row = db_fetch_assoc($res))
{
$randbild .= '<a target="_new" href="/include/images/usergallery/img_'.$row['id'].'.'.$row['endung'].'"><img class="bilderrahmen" src="include/images/usergallery/img_thumb_'.$row['id'].'.'.$row['endung'].'" border="2" width="80" height="60"></a> ';
}
}
else
{
$randbild = '<img src="include/images/profilmod/no_usergallery.jpg" border="0">';
}
########## Ende
#Hits hochzählen
if ($_SESSION['authid'] != $uid and !isset($_SESSION['visited_profils'][$uid])) {
$_SESSION['visited_profils'][$uid] = true;
db_query("UPDATE prefix_user SET hits = hits + 1 WHERE id = ".$uid);
}
#Ende
#Squadanzeige im Profil
function user_get_teams ($uid) {
$erg = db_query("SELECT b.name, c.name as posi
FROM `prefix_groupusers` a
LEFT JOIN `prefix_groups` b ON b.id = a.gid
LEFT JOIN `prefix_groupfuncs` c ON a.fid = c.id
WHERE a.uid = ".$uid);
if (db_num_rows($erg) > 0 ) {
while ($r = db_fetch_assoc($erg)) {
if ($class == '') { $class = ''; } else { $class = ''; }
$l .= '
<table width="100%" border="0" cellspacing="1" cellpadding="0" class="derrand">
<tr>
<td class="inhalthintergrund" width="70%" style="padding-left:15px;">'.$r['name'].'</td>
<td class="inhalthintergrund" width="30%" height="25" style="text-align:center;">'.$r['posi'].'</td>
</tr>
</table>
';
}
} else {
$l .= '<table width="100%" border="0" cellspacing="1" cellpadding="0" class="derrand">
<tr>
<td class="inhalthintergrund" height="25" style="padding-left:15px;">Ist in keinem Team</td>
</tr>
</table>
';
}
return ($l);
}
########## Ende
#letzte Besucher
$lastbes_anz = 3; //Bei höhere Anzahl muss ggf. in der Datenbank die Größe der Felder bzw der Typ geändert werden
if ($_SESSION['authid'] != $uid AND $_SESSION['authid'] != 0) {
$lb = db_fetch_object(db_query('SELECT last_bes, last_user_time FROM prefix_user WHERE id = '.$uid));
$lba = explode('#',$lb->last_bes);
$lbt = explode('#',$lb->last_user_time);
$i = array_search($_SESSION['authid'],$lba);
if ($i !== false) {
unset($lba[$i]); unset($lbt[$i]);
} elseif (count($lba) >= $lastbes_anz) {
$lba = array_slice($lba,0,$lastbes_anz-1);
$lbt = array_slice($lbt,0,$lastbes_anz-1);
}
array_unshift($lba,$_SESSION['authid']);
array_unshift($lbt,time());
$i_lb = implode('#',$lba);
$i_lbt = implode('#',$lbt);
db_query("UPDATE prefix_user SET last_bes = '$i_lb', last_user_time = '$i_lbt' WHERE id = $uid");
}
#Ende
#### punkte
if ( $row['posts'] != 0 AND userbwpoints($row['erstid']) > 0 ) {
$row['USERPOINTS'] = 'Punkte: '.userbwpoints($row['erstid']).'<br />';
} else {
$row['USERPOINTS'] = '';
}
#### ENDE
############### Gameicons Ausgabe #######################
$ausgabe = '';
$str = @db_result ( db_query ("SELECT `games` FROM prefix_user WHERE id = ".$uid) , 0 );
$gamesarr = explode("#", $str);
$style = 'float:left;width:px;height:100px;border:1px;border-bottom-left-radius: 5px;
border-top-left-radius: 5px;
border-bottom-right-radius: 5px;
border-top-right-radius: 5px;padding: 1px;-moz-box-shadow: 0px 2px 3px #000;
-webkit-box-shadow: 0px 1px 3px #000;
box-shadow: 0px 1px 3px #000;margin:1px;padding:0';
foreach($gamesarr as $value)
{
if (file_exists('include/images/wargames/'.$value) and !empty($value) )
{
$ausgabe .= '<img style="'.$style.'" onmouseover="Tip(\'<div align="center"><img style="width:180px;height:254px;border:none" src="include/images/spiele/'.$value.'"><br>'.substr($value,0,-4).'</div>\')" onmouseout="UnTip()" src="include/images/spiele/'.$value.'" alt="'.substr($value,0,-4).'" /> ';
} else {
$ausgabe .= '';
}
}
##################################################
############### Auszeichnung Ausgabe #######################
$ausgaben = '';
$str = @db_result ( db_query ("SELECT `auszeichnung` FROM prefix_user WHERE id = ".$uid) , 0 );
$auszeichnungarr = explode("#", $str);
$style = 'float:left;width:px;height:100px;border:1px;border-bottom-left-radius: 5px;
border-top-left-radius: 5px;
border-bottom-right-radius: 5px;
border-top-right-radius: 5px;padding: 1px;-moz-box-shadow: 0px 2px 3px #000;
-webkit-box-shadow: 0px 1px 3px #000;
box-shadow: 0px 1px 3px #000;margin:1px;padding:0';
foreach($auszeichnungarr as $value)
{
if (file_exists('include/images/profilmod/auszeichnung/'.$value) and !empty($value) )
{
$ausgaben .= '<img style="'.$style.'" onmouseover="Tip(\'<div align="center"><img style="width:180px;height:px;border:none" src="include/images/profilmod/auszeichnung/'.$value.'"><br>'.substr($value,0,-4).'</div>\')" onmouseout="UnTip()" src="include/images/profilmod/auszeichnung/'.$value.'" alt="'.substr($value,0,-4).'" /> ';
} else {
$ausgaben .= '';
}
}
##################################################
include('user_infos.php');
$abf8 = "SELECT * FROM prefix_online WHERE uid = '".$uid."'";
$erg8 = db_query($abf8);
$row8 = db_fetch_assoc($erg8);
if(isset($row8['uid'])){
$online = '<font color="#009900">online</font>';
}else{
$online = '<b>offline</b>';
}
### Skillausgabe
$row['SKILLS'] = '';
$ergS = db_query('SELECT * FROM `prefix_skill` ORDER BY pos, name DESC');
while ($rowS = db_fetch_object($ergS)) {
if ($rowS->cat == 1) {
$row['SKILLS'] .= '
<tr>
<td colspan="2" class="hintergrund" height="20"></td>
</tr>
<tr>
<td colspan="2" class="hintergrundhead" height="20">' . $rowS->name . ' von ' . $row['name'] . '</td>
</tr>';
} else {
$insert = @db_result(db_query("SELECT `insert` FROM prefix_skill_daten WHERE `skill_id` = '". $rowS->id ."' AND `user_id` = '".$uid."'"),0);
if (empty($insert) or $insert == '') { $insert = '0'; }
$row['SKILLS'] .= '
<tr class="inhalthintergrund">
<td height="25"> <img src="include/images/profilmod/skill.png" border="0" alt="skill" /> ' . $rowS->name . '</td>
<td width="200" valign="bottom" background="include/images/profilmod/skala.png">
<table border="0" cellpadding="0" cellspacing="0" width="200" height="12" align="left">
<tr class="balkenhintergrund">
<td height="10" valign="middle"><div style="min-width: 1px; width:'.$insert.'%; height:10px; background:#000 url(include/images/profilmod/skill_balken.png) repeat scroll 0% 0% ; text-align: center">
<div style="width:200px; height:8px; text-align:center"><span class="skillangabe">'.$insert.'%</span></div>
</td>
</tr>
</table>
</td>
</tr>';
}
}
### Skillausgabe Ende
$ar = array (
'NAME' => $row['name'],
'HITS' => $row['hits'],
'JOINED' => date('d.m.Y',$row['regist']),
'LASTAK' => date('d.m.Y - H:i',$row['llogin']),
'POSTS' => $row['posts'],
'postpday' => $postpday,
'AUSGABE' => $ausgabe,
'AUSGABEN' => $ausgaben,
'RANDBILD' => $randbild,
'STATUSTEXT' => $statustext,
'UID' => $uid,
'RANG' => userrang ($row['posts'],$uid),
'RANGGRAFIK' => $row['rang'],
'AVATA' => $avatar,
'ONLINE' => $online,
'USERTITEL' => $usertitel,
'HOMEPAGE' => $homepage,
'GESCHLECHT' => $geschlecht,
'GEBDATUM' => $gebdatum,
'ALTER' => $alter,
'WOHNORT' => $wohnort,
'LASTUSER' => last_user($uid),
'MICH' => bbcode($row['mich']),
'CLANLOGO' => $clanlogo,
'CNAME' => $cname,
'CTAG' => $ctag,
'CSEITE' => $cseite,
'STEAMPRO' => $steampro,
'SYSTEM' => $system,
'SOUND' => $sound,
'HDD' => $hdd,
'MONITOR' => $monitor,
'INET' => $inet,
'HEADSET' => $headset,
'BOARD' => $board,
'PROZESOR' => $prozesor,
'RAM' => $ram,
'GRAFIK' => $grafik,
'TASTA' => $tasta,
'MAUS' => $maus,
'CPUBILD' => $cpubild,
'GPUBILD' => $gpubild,
'POSTEN' => $posten,
'LOGINS' => $row['logins'],
### Skills ###
'SKILLS' => $row['SKILLS'],
'POSTS' => $row['posts'],
'NEWSPOSTS' => $row6['newsposts'],
'POSTPDAY' => $postpday,
'FORUMTOPICS' => $row4['forumtopics'],
'NEWSTOPICS' => $row5['newstopics'],
'FORUMPOSTS' => $row7['forumposts'],
'KOMS' =>$row['koms'],
'PMGESENDET' => @db_result(db_query("SELECT COUNT(id) FROM `prefix_pm` WHERE `sid` = '".$uid."'"),0),
'PMGE' => @db_result(db_query("SELECT COUNT(ID) FROM `prefix_pm`"),0),
'POSTSGE' => @db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
'POSTSU' => @db_result(db_query("SELECT COUNT(id) FROM `prefix_posts` WHERE `erst` = '".$row['name']."'"),0),
'NEWS' => @db_result(db_query("SELECT COUNT(news_id) FROM `prefix_news` WHERE `user_id` = '".$uid."'"),0),
'NEWSGE' => db_result(db_query("SELECT COUNT(news_id) FROM `prefix_news`"),0),
'TOPICS' => @db_result(db_query("SELECT COUNT(id) FROM `prefix_topics` WHERE `erst` = '".$row['name']."'"),0),
'TOPICSGE' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
'KOMGE' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_koms`"),0),
'KOMU' => db_result(db_query("SELECT COUNT(id) FROM prefix_koms WHERE name='".$row['name']."'"),0),
'POLLGE' => db_result(db_query("SELECT COUNT(poll_id) FROM prefix_poll WHERE recht = '2' "),0),
'POLLU' => db_result(db_query("SELECT COUNT(*) FROM prefix_poll WHERE recht = '2' AND text REGEXP '#".$uid."(#|$)'"),0),
'SHOUTGE' => db_result(db_query("SELECT COUNT(id) FROM prefix_shoutbox"),0),
'SHOUTU' => db_result(db_query("SELECT COUNT(id) FROM prefix_shoutbox WHERE nickname = '".$row['name']."'"),0),
'PMGES' => @db_result($pmGes,0),
'ANZBAL' => '<img src="/include/images/vote/votebalkenbox.gif" height="5" width="'.@round($pmGes/$pmGes *267).'" align="left" alt="">',
##############################
'NEXT' => $next,
'NEXTRANK' => $nextrank,
'POINTSLEFT' => $pointsleft,
'ERFAHRUNG' => $erfahrung,
'SIGNATUR' => bbcode($row['sig']),
'STAAT' => $staat,
'STERNZEICHEN' => $sternzeichen,
'GALLERIE_EINTRAEGE' => $gallery_eintraege,
'EMAIL' => $email,
'ICQ' => $icq,
'FACEBOOK' => $facebook,
'YOUTUBE' => $youtube,
'CD' => $cd,
'TWITTER' => $twitter,
'BATTLELOG' => $battlelog,
'GOOGLE' => $google,
'STEAM' => $steam,
'XFIRE' => $xfire,
'TEAMSPEAK' => $teamspeak,
'TEAMS' => user_get_teams ($uid),
);
$title = $allgAr['title'].' :: Users :: Details von '.$row['name'];
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> <a href=index.php?user-details-'.$uid.'>Details von '.$row['name']."</a>".$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$tpl = new tpl ( 'user/userdetails' );
$l = profilefields_show ( $uid );
$ar['rowspan'] = 4 + substr_count($l, '<tr><td class="');
$ar['profilefields'] = $l;
$tpl->set_ar_out($ar,0);
/*Freunde*/
$ges_ar = array ('wurstegal', 'maennlich', 'weiblich');
$dif = date('Y-m-d H:i:s', time() - 60);
$sql = db_query("SELECT a.fid as aktfid, b.id, b.name, IF(c.uptime > '$dif','online','offline') as status, b.avatar, b.geschlecht
FROM `prefix_friends` a
LEFT JOIN `prefix_user` b ON a.fid = b.id
LEFT JOIN `prefix_online` c ON a.fid = c.uid
WHERE a.uid = {$uid} ORDER BY b.recht ASC, c.uptime DESC");
if (db_num_rows($sql) > 0 ) {
while ($r = db_fetch_assoc($sql)) {
if (!is_numeric($r['geschlecht'])) { $r['geschlecht'] = 0; }
if (file_exists($r['avatar'])) { $r['AVATAR'] = '<img src="'.$r['avatar'].'" alt="User Pic" border="0" width="100" height="100" />'; }
elseif ($allgAr['forum_default_avatar']) { $r['AVATAR'] = '<img src="include/images/avatars/'.$ges_ar[$r['geschlecht']].'.jpg" alt="User Pic" width="100" height="100" border="0" />'; }
else { $r['avatar'] = ''; }
$r['FREUNDNAME'] = $r['name'];
$r['FREUNDID'] = $r['id'];
$tpl->set_ar_out($r,1);
}
} else {
echo '<tr><td class="Cmite">keine Freunde</td></tr>';
}
$tpl->out(2);
/*Freunde Ende*/
$design->footer();
?>
$uid = $menu->get(2);am Anfang der Datei durch:
$uid = intval($menu->get(2));
if (db_count_query('SELECT COUNT(`id`) FROM `prefix_user` WHERE `id` = ' . $uid) == 0) {
// User ist nicht (mehr) vorhanden
$title = $allgAr[ 'title' ] . ' :: Users :: User nicht gefunden ';
$hmenu = '<a class="smalfont" href="?user">Users</a><b> » </b>';
$design = new design($title, $hmenu, 1);
$design->header();
echo ' FEHLER: User nicht (mehr) vorhanden';
$design->footer(1);
}
So. 17.03.2013
15:53 Uhr
#5
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
function get_erg_liste($wid) {
$list = ''; $enar = array ( 'jpg', 'gif', 'png', 'jpeg');
$erg = db_query("SELECT * FROM prefix_warmaps WHERE wid = ".$wid);
$list .= '<div style="width: 100%;">';
while($row = db_fetch_assoc($erg) ) {
if ( $row['opp'] == $row['owp'] ) {
$farbe = 'FDFBB7'; #pat
$farbe2= 'orange';
} elseif ( $row['opp'] < $row['owp'] ) {
$farbe = 'C8E1B8'; #win
$farbe2= 'green';
} elseif ( $row['opp'] > $row['owp'] ) {
$farbe = 'D8B9B9'; #los
$farbe2= 'red';
}
foreach ($enar as $v) {
if(file_exists('include/images/warmaps/'.$row['map'].'.'.$v)) {
$row['map2'] = $row['map'].'.'.$v;
}
}
$list .= '<div style="float:left; width: 48%; margin: 2px;" class="Cmite">
<table><tr>';
$list .= '<td colspan="2"><img src="include/images/warmaps/'.$row['map2'].'" border="0" alt="'.$row['map'].'"/></td>';
$list .= '</tr><tr style="color: '.$farbe2.';" class="Cnorm">';
$list .= '<td style="text-align: center; font-size: 16px; width: 50%;"><strong>'.$row['owp'].'</strong></td>';
$list .= '<td style="text-align: center; font-size: 16px; width: 50%;"><strong>'.$row['opp'].'</strong></td>';
$list .= '</tr></table></div>';
}
$list .= '</div>';
return ($list);
}
function get_screen_liste($wid) {
$list = '<div>';
$enar = array ( 'jpg', 'gif', 'png', 'jpeg');
$erg = db_query("SELECT * FROM prefix_warmaps WHERE wid = ".$wid);
while($row = db_fetch_assoc($erg) ) {
foreach($enar as $v) {
if ( file_exists ( 'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v ) ) {
$row['mappics1'] = '<a href="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" target="_blank" style="padding:2px;"><img src="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" alt="Plant '.$row['mnr'].'" width="100" height="80" border="0" /></a>';
}
}
$row['mnr'] = $row['mnr'] + 1;
foreach($enar as $v) {
if ( file_exists ( 'include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v ) ) {
$row['mappics2'] = '<a href="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" target="_blank" style="padding:2px;"><img src="include/images/wars/'.$wid.'_'.$row['mnr'].'.'.$v.'" alt="Plant '.$row['mnr'].'" width="100" height="80" border="0" /></a>';
break;
}
}
$list .= $row['mappics1'].$row['mappics2'];
}
$list .= '</div>';
return ($list);
}
function lastwars_get_memberlist ( $id ) {
$l = '';
$erg = db_query("SELECT prefix_user.id,prefix_user.name,prefix_user.avatar FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = ".$id." WHERE wid = ".$id." ORDER BY prefix_user.name ASC");
while($r = db_fetch_assoc($erg)) {
$l .= '<div style="float:left; padding: 3px auto 3px auto; position: relative; background: #c0c0c0; margin: 1px;"><div><a href="index.php?user-details-'.$r['id'].'"><img src="'.$r['avatar'].'" alt=""/></a><div align="center" style="clear: left;">'.$r['name'].'</div></div></div>';
#$l .= '<a href="index.php?user-details-'.$r['id'].'">'.$r['name'].'</a>, ';
}
if(empty($l)) {
$l .= "- Kein Lineup eingetragen -";
}
//return (substr($l,0,-2));
return $l;
}
if ( $menu->get(2) == '' OR $menu->getA(2) == 'p' ) {
$title = $allgAr['title'].' :: Wars';
$hmenu = 'Wars';
$design = new design ( $title , $hmenu );
$design->header();
$ergWin = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "1"');
$anzWin = db_result($ergWin,0);
$ergLos = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "2"');
$anzLos = db_result($ergLos,0);
$ergPat = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE wlp = "3"');
$anzPat = db_result($ergPat,0);
$ergGes = db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3"');
$anzGes = db_result($ergGes,0);
if($anzGes == 0) {
$percentWin = 0;
$percentLos = 0;
$percentPat = 0;
} else {
$percentWin = round($anzWin / $anzGes * 100);
$percentLos = round($anzLos / $anzGes * 100);
$percentPat = round($anzPat / $anzGes * 100);
}
$tpl = new tpl ( 'wars.htm' );
$tpl->set_ar_out ( array('PATH' => $percentPat, 'WINH' => $percentWin, 'LOSH' => $percentLos, 'PAT' => $anzPat, 'WIN' => $anzWin, 'LOS' => $anzLos, 'GES' => $anzGes, 'TITLE'=> $allgAr['title'] ) , 0 );
$akttime = date('Y-m-d');
$class = '';
$erg = db_query("SELECT a.id,a.oid,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '".$akttime."' ORDER BY a.datime");
if ( db_num_rows ( $erg ) == 0 ) {
echo '<tr class="Cmite"><td colspan="4"><i>There are no upcoming Matches!</i></td></tr>';
} else {
while ($row = db_fetch_assoc($erg) ) {
if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$row['page'] = get_opponent_details('homepage', $row['oid']);
$row['team'] = get_wargameimg($row['game']).' '.$row['team'];
$row['class'] = $class;
$row['gegner'] = get_opponent_details('name',$row['oid']);
$tpl->set_ar_out($row,1);
}
}
$tpl->out(2);
$class = '';
if ( $menu->get(1) == '' ) {
$teams = dblistee ( '', "SELECT id,name FROM prefix_groups ORDER BY name");
$game= dblistee ('', "SELECT DISTINCT `game`,`game` FROM prefix_wars ORDER BY `game`" );
$mtype= dblistee ( '', "SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_wars ORDER BY `mtyp`" );
$tpl->set_ar_out ( array('tid' => $teams, 'game' => $game, 'typ' => $mtype ) , 3 );
} elseif ($menu->get(1) == 'last') {
$tpl->out(4);
$sqla='WHERE status = 3 ';
if(!empty($_POST['tid'])){
$sqla.= 'AND tid="'.$_POST['tid'].'" ';
}
if(!empty($_POST['wpl'])){
$sqla.= 'AND wlp="'.$_POST['wpl'].'" ';
}
if(!empty($_POST['spiel'])){
$sqla.= 'AND game="'.$_POST['spiel'].'" ';
}
if(!empty($_POST['typ'])){
$sqla.= 'AND mtyp="'.$_POST['typ'].'" ';
}
# seiten funktion
$limit = $allgAr['wars_last_limit']; // Limit
$page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 );
$MPL = db_make_sites ($page , "WHERE status = 3" , $limit , "?wars-last" , 'wars' );
$anfang = ($page - 1) * $limit;
# seiten funktion
$farbe1wlpar = array(1=>'C8E1B8',2=>'D8B9B9',3=>'FDFBB7');
$farbe2wlpar = array(1=>'00FF00',2=>'FF0000',3=>'FFFF00');
$farbe3wlpar = array(1=>'green',2=>'red',3=>'orange');
$erg = db_query("SELECT a.owp,a.opp,a.wlp,a.mtyp,a.game,a.id,a.oid,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y %H:%i') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id ".$sqla." ORDER BY a.datime DESC, id DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_assoc($erg) ) {
$row['erg'] = $row['owp'].':'.$row['opp'];
$row['farbe'] = $farbe1wlpar[$row['wlp']];
$row['farbe2'] = $farbe3wlpar[$row['wlp']];
$row['gegner'] = get_opponent_details('name', $row['oid']);
if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$row['page'] = get_opponent_details('homepage', $row['oid']);
$row['team'] = get_wargameimg($row['game']).' '.$row['team'];
$row['class'] = $class;
$tpl->set_ar_out($row,5);
}
$tpl->out(6);
echo $MPL;
}
$design->footer();
} elseif ( is_numeric($menu->get(2)) ) {
$_GET['mehr'] = escape($menu->get(2),'integer');
$erg = @db_query("SELECT
DATE_FORMAT(datime,'%d.%m.%Y') as datum,
tid, status, owp, opp, wlp,
DATE_FORMAT(datime,'%H:%i:%s') as zeit,
oid, wo, prefix_wars.`mod`, mtyp,
game, txt,mlink,lineupopp,tv,pw, prefix_wars.id,
name as team
FROM prefix_wars
left join prefix_groups ON prefix_wars.tid = prefix_groups.id
WHERE prefix_wars.id = ".$_GET['mehr']);
db_check_erg ($erg);
$row = db_fetch_assoc($erg);
## Gegnerdaten ##
$row['page'] = get_opponent_details('homepage', $row['oid']);
$row['gegner'] = get_opponent_details('name', $row['oid']);
$row['logo'] = get_opponent_details('logo', $row['oid']);
$row['land'] = get_opponent_details('land', $row['oid']);
## Gegnerlogo ##
if(empty($row['logo'])) {
$row['logo'] = 'include/images/clanlogos/na.gif';
}
## Teamlogo ##
$row['teamlogo'] = get_team_details('logo', $row['tid']);
if(empty($row['logo'])) {
$row['teamlogo'] = 'include/images/clanlogos/na.gif';
}
$row['txt'] = bbcode($row['txt']);
if ( $row['status'] == 2 ) {
# nextwars
$title = $allgAr['title'].' :: Wars :: Nextwars';
$hmenu = '<a href="?wars" class="smalfont">Wars</a><b> » </b>Nextwars';
$design = new design ( $title , $hmenu );
$design->header();
$tpl = new tpl ('wars_next');
$row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
$row['owp'] = "xx";
$row['opp'] = "xx";
if(has_right($allgAr['wars_matchlink_recht'])) {
$row['mlink'] = '<a href="'.$row['mlink'].'" style="font-size: 10px;" target="_blank" />Matchlink</a>';
} else {
$row['mlink'] = "";
}
if(has_right($allgAr['wars_server_recht'])) {
$row['wo'] = $row['wo'];
} else {
$row['wo'] = "<i>Keine Berechtigung</i>";
}
if(has_right($allgAr['wars_password_recht'])) {
$row['pw'] = $row['pw'];
} else {
$row['pw'] = "******";
}
if(has_right($allgAr['wars_tv_recht'])) {
$row['tv'] = $row['tv'];
} else {
$row['tv'] = "<i>Keine Berechtigung</i>";
}
$tpl->set_ar_out($row,0);
if ( $_SESSION['authright'] <= -2 ) {
# get benoetige member
$bm = substr($row['mod'],0,3); $needed = '';
for($i=0;$i<strlen($bm);$i++) {
if ( is_numeric($bm{$i}) ) {
$needed .= $bm{$i};
}
}
$uid = $_SESSION['authid'];
if ($menu->get(3) == 'delete') { $uid = $menu->get(4); }
$ck = db_count_query("SELECT COUNT(wid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid);
# eine zu bzw. absage loeschen
if ( $menu->get(3) == 'delete' AND ((has_right(array($row['tid'])) === true AND $uid == $_SESSION['authid']) OR is_siteadmin('wars')) AND $ck == 1) {
db_query("DELETE FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND uid = ".$uid );
$ck = 0;
}
$available = db_count_query("SELECT COUNT(uid) FROM prefix_warmember WHERE wid = ".$_GET['mehr']." AND aktion = 1");
$aout1 = array (
'needed' => $needed,
'available' => $available,
'id' => $_GET['mehr']
);
$tpl->set_ar_out($aout1,1);
if ( $ck == 0 AND has_right(array($row['tid'])) === true) {
if ( isset ($_POST['sub']) ) {
$aktion = ( $_POST['sub'] == 'zusagen' ? 1 : 0 );
$kom = escape($_POST['kom'],'string');
db_query("INSERT INTO prefix_warmember (uid,wid,aktion,kom) VALUES (".$_SESSION['authid'].",".$_GET['mehr'].",".$aktion.",'".$kom."')");
} else {
$tpl->out(2);
}
}
$class = '';
$aktionar = array ('<font style="color:#FF0000; background:#666666; font-weight:bold;">abgesagt</font>','<font style="font-weight:bold; color:#00FF00; background:#666666;">zugesagt</font>');
$erg1 = db_query("SELECT b.id as uid, b.name, a.aktion, a.kom FROM prefix_warmember a left join prefix_user b ON b.id = a.uid WHERE a.wid = ".$_GET['mehr']);
while ($row1 = db_fetch_assoc($erg1) ) {
if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$row1['class'] = $class;
$row1['aktion'] = $aktionar[$row1['aktion']];
if ( $row1['uid'] == $_SESSION['authid'] OR is_siteadmin('wars')) {
$row1['name'] = '<a href="index.php?wars-more-'.$_GET['mehr'].'-delete-'.$row1['uid'].'"><img src="include/images/icons/del.gif" border="0" title="löschen" /></a> '.$row1['name'];
}
$tpl->set_ar_out($row1,3);
}
}
$tpl->out(4);
} elseif ($row['status'] == 3) {
# lastwars
$row['memberliste'] = lastwars_get_memberlist($_GET['mehr']);
$wlpar = array(1=>'gewonnen',2=>'verloren',3=>'unentschieden');
$row['erg'] = $row['owp'].' zu '.$row['opp'];
$row['ergliste'] = get_erg_liste($_GET['mehr']);
$row['screenliste'] = get_screen_liste($_GET['mehr']);
if($row['screenliste'] == "<div></div>") {
$row['screenliste'] = "- Keine Screenshots vorhanden -";
}
if(empty($row['lineupopp'])) {
$row['lineupopp'] = "- Kein Lineup eingetragen -";
}
if(empty($row['txt'])) {
$row['txt'] = '<div style="text-align:center;">- Kein Bericht vorhanden -</div>';
}
$row['wlp'] = $wlpar[$row['wlp']];
$title = $allgAr['title'].' :: Wars :: Lastwars';
$hmenu = '<a href="?wars" class="smalfont">Wars</a><b> » </b>Lastwars';
$design = new design ( $title , $hmenu );
$design->header();
$tpl = new tpl ('wars_last');
$row['tag'] = ( empty($row['tag']) ? $row['gegner'] : $row['tag'] );
if($row['owp'] > $row['opp']) {
$row['owp'] = '<span style="color: green;">'.$row['owp'].'</span>';
$row['opp'] = '<span style="color: red;">'.$row['opp'].'</span>';
} elseif($row['owp'] < $row['opp']) {
$row['owp'] = '<span style="color: red;">'.$row['owp'].'</span>';
$row['opp'] = '<span style="color: green;">'.$row['opp'].'</span>';
} else {
$row['owp'] = '<span style="color: yellow;">'.$row['owp'].'</span>';
$row['opp'] = '<span style="color: yellow;">'.$row['opp'].'</span>';
}
if(has_right($allgAr['wars_matchlink_recht'])) {
$row['mlink'] = '<a href="'.$row['mlink'].'" style="font-size: 10px;" target="_blank" />Matchlink</a>';
} else {
$row['mlink'] = "";
}
if(has_right($allgAr['wars_server_recht'])) {
$row['wo'] = $row['wo'];
} else {
$row['wo'] = "<i>Keine Berechtigung</i>";
}
if(has_right($allgAr['wars_password_recht'])) {
$row['pw'] = $row['pw'];
} else {
$row['pw'] = "******";
}
if(has_right($allgAr['wars_tv_recht'])) {
$row['tv'] = $row['tv'];
} else {
$row['tv'] = "<i>Keine Berechtigung</i>";
}
$tpl->set_ar_out($row,0);
# kommentare fuer lastwars
if ($allgAr['wars_last_komms'] < 0 AND has_right ($allgAr['wars_last_komms'])) {
# aktion
if (isset ($_POST['kommentar_fuer_last_wars'])) {
$name = $_SESSION['authname'];
$text = escape($_POST['text'],'textarea');
db_query("INSERT INTO prefix_koms (name,cat,text,uid) VALUES ('".$name."','WARSLAST', '".$text."', ".$_GET['mehr']." )");
}
if (isset ($_GET['kommentar_fuer_last_wars_loeschen']) AND is_siteadmin('wars')) {
db_query("DELETE FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." AND id = ".$_GET['kommentar_fuer_last_wars_loeschen']);
}
# anzeigen
$tpl->out(1);
$class = '';
$erg = db_query("SELECT name,text,id FROM prefix_koms WHERE cat = 'WARSLAST' AND uid = ".$_GET['mehr']." ORDER BY id DESC");
while($r = db_fetch_assoc($erg)) {
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$r['text'] = bbcode($r['text']);
if (is_siteadmin('wars')) { $r['text'] .= '<a href="index.php?wars-more-'.$_GET['mehr'].'=0&kommentar_fuer_last_wars_loeschen='.$r['id'].'"><img src="include/images/icons/del.gif" title="löschen" alt="löschen" border="0"></a>'; }
$r['class'] = $class;
$tpl->set_ar_out($r,2);
}
$tpl->out(3);
}
}
$design->footer();
}
?>
MySQL Error: 1054 : Unknown column 'a.oid' in 'field list' in Query: SELECT a.id,a.oid,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM ic1_wars a left join ic1_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '2013-03-17' ORDER BY a.datime Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ wars.php:109 -- db_query(...) @ index.php:35 -- require_once(...) Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/XXX/html/include/includes/func/db/mysql.php on line 71
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/XXX/html/include/includes/func/db/mysql.php on line 71
echo mysql_error();unter Zeile 109 machen und schauen, was dir für ein Fehler ausgegeben wird.
So. 17.03.2013
16:05 Uhr
#7
Zitat geschrieben von Mairu
So. 17.03.2013
18:13 Uhr
#9
Zitat geschrieben von Mairu| Geschlossen | ||
 |
Zurück zu Fehlersuche und Probleme | |