<?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
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
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$l
.=
'<td class="'
.
$class
.
'" width="70%">'
.
$r
[
'name'
].
'</td><td class="'
.
$class
.
'" width="30%">'
.
$r
[
'posi'
].
'</td></tr>'
;
}
}
else
{
$l
.=
'<td class="Cmite" width="10%">Keine Teams</td>'
;
}
return
(
$l
);
}
$uid
=
$menu
->get(2);
$abf
=
'SELECT * FROM prefix_user WHERE id = "'
.
$uid
.
'"'
;
$erg
= db_query(
$abf
);
$row
= db_fetch_assoc(
$erg
);
#Award Ausgabe
$awards
=
''
;
$ax
= 0;
$sqlA
= db_query(
"SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = "
.
$uid
.
" ORDER BY `time` ASC"
);
while
(
$rowA
= db_fetch_assoc(
$sqlA
))
{
$ax
++;
if
(
$ax
== 8) {
$awards
.=
"<br>"
;
$ax
= 0;}
$awards
.= (!
empty
(
$rowA
[
'bild'
]) ?
'<img style="width:100;height:100px;padding:1px;border:0px;" src="'
.
$rowA
[
'bild'
].
'" alt="'
.
$rowA
[
'wofur'
].
'" title="'
.
$rowA
[
'wofur'
].
'"/>'
:
$rowA
[
'wofur'
]);
}
$awards
=
'<b><b><br><div style="text-align:center;">'
.
$awards
.
'</div>'
;
function
get_last_user_wars(
$userid
,
$game
){
$s
=
''
;
$q
= db_query(
"SELECT `wid` FROM `prefix_warmember` WHERE uid = '"
.
$userid
.
"' AND aktion = '1' ORDER BY wid DESC LIMIT 20"
);
if
(db_num_rows(
$q
) > 0 ) {
$wids
=
array
();
while
(
$row
= db_fetch_object(
$q
)) {
$wids
[] =
$row
->wid;
}
$wids
= implode(
', '
,
$wids
);
}
if
( !
empty
(
$wids
) ) {
$erg
= db_query("SELECT id, gegner, tag, wlp, land, owp, opp
FROM prefix_wars
WHERE id IN (
$wids
) AND status =
'3'
AND game =
'".$game."'
");
if
(db_num_rows(
$erg
) > 0 ) {
while
(
$r
= db_fetch_assoc(
$erg
)) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$r
[
'tag'
] = (
empty
(
$r
[
'tag'
]) ?
$r
[
'gegner'
] :
$r
[
'tag'
] );
if
(
$r
[
'wlp'
] == 1) {
$bild
=
'include/images/icons/win.gif'
;
$color
=
'#558e3d'
;
}
elseif
(
$r
[
'wlp'
] == 2) {
$bild
=
'include/images/icons/los.gif'
;
$color
=
'#a91d1d'
;
}
elseif
(
$r
[
'wlp'
] == 3) {
$bild
=
'include/images/icons/pad.gif'
;
$color
=
'#f0770d'
;
}
$s
.=
'<td class="'
.
$class
.
'" width="1%"><img src="'
.
$bild
.
'" alt="" / ></td><td class="'
.
$class
.
'" width="99%"><div style="width:80%; float:left"><img src="include/images/flags/'
.
$r
[
'land'
].
'" alt="'
.
$r
[
'land'
].
'"/> <a href="index.php?wars-more-'
.
$r
[
'id'
].
'">'
.
$r
[
'tag'
].
'</a></div><div style="float:left; text-align:right; color:'
.
$color
.
'; width:20%;">'
.
$r
[
'owp'
].
':'
.
$r
[
'opp'
].
'</div></td></tr>'
;
}
}
else
{
$s
.=
'<td class="Cmite" width="10%">Keine Wars</td>'
;
}
}
else
{
$s
.=
'<td class="Cmite" width="10%">Keine Wars</td>'
;
}
return
(
$s
);
}
defined (
'main'
)
or
die
(
'no direct access'
);
$uid
=
$menu
->get(2);
$abf
=
'SELECT * FROM prefix_user WHERE id = "'
.
$uid
.
'"'
;
$erg
= db_query(
$abf
);
$row
= db_fetch_assoc(
$erg
);
$regsek
=
mktime
( 0,0,0,
date
(
'm'
),
date
(
'd'
),
date
(
'Y'
) ) -
$row
[
'regist'
];
$regday
=
round
(
$regsek
/ 86400);
$postpday
= (
$regday
== 0 ? 0 :
round
(
$row
[
'posts'
] /
$regday
, 2 ) );
$rp
=rangcount(
$row
[
'id'
],
$row
[
'posts'
],
$row
[
'cpoints'
],
$row
[
'fwarn'
]);
$row
[
'koms'
] = db_count_query(
'SELECT COUNT(id) FROM `prefix_koms` WHERE name="'
.
$row
[
'name'
].
'"'
);
if
(
empty
(
$row
[
'xfire'
]))
{
$xfire_online
=
''
;
$xfire_onlinet
=
''
;}
else
{
if
(
$allgAr
[
'xfire_online'
] ==
'1'
){
$xfire_onlinet
=
'X-Fire'
; }
else
{
$xfire_onlinet
=
''
; }
}
if
(
empty
(
$row
[
'steampro'
]))
{
$steam
=
''
; }
else
{
$steam
=
'<img src="include/steamprofile/spimage.php?id='
.
$row
[
'steampro'
].
'" />'
;
}
$row
[
'sig'
] = (
empty
(
$row
[
'sig'
]) ?
''
:
'<br /><hr style="width: 50%;" align="left">'
.bbcode(
$row
[
'sig'
]) );
$regsek
=
mktime
( 0,0,0,
date
(
'm'
),
date
(
'd'
),
date
(
'Y'
) ) -
$row
[
'regist'
];
$regday
=
round
(
$regsek
/ 86400);
$postpday
= (
$regday
== 0 ? 0 :
round
(
$row
[
'posts'
] /
$regday
, 2 ) );
if
(
$row
[
'posts'
] != 0)
{
$postar
=
array
(0,1,25,50,75,150,250,500,1000,2000,5000,7000,10000);
$i
=0;
while
(
$postar
[
$i
] <
$row
[
'posts'
])
{
$next
= 100/(
$postar
[
$i
+1]-
$postar
[
$i
])*(
$row
[
'posts'
]-
$postar
[
$i
]);
$i
++;
}
}
else
{
$next
=
"0"
;
}
$erfahrung
= 100/200000*
$row
[
'posts'
];
array
(0,1,25,50,75,150,250,500,1000,2000,5000,7000,10000);
$ar
=
array
(
'NAME'
=>
$row
[
'name'
],
'ROWSP'
=>10,
'JOINED'
=>
date
(
'd M Y'
,
$row
[
'regist'
]),
'LASTAK'
=>
date
(
'd M Y - H:i'
,
$row
[
'llogin'
]),
'POSTS'
=>
$row
[
'posts'
],
'postpday'
=>
$postpday
,
'RANG'
=> rangbild (
$rp
),
'SRANK'
=> spezrang (
$row
[
'id'
]),
'RECHT'
=> getlistrecht(
$row
[
'recht'
]),
'POINTS'
=>
$row
[
'cpoints'
],
'RPOINT'
=>
$rp
,
'STEAM'
=>
$steam
,
'XFIRE'
=>
$xfire_online
,
'XFIREt'
=>
$xfire_onlinet
,
'koms'
=>
$row
[
'koms'
],
'UID'
=>
$uid
,
'GAMES'
=> getteams(
$row
[
'id'
]),
'VERW'
=> verwarnstu(
$row
[
'fwarn'
],0),
'dze'
=>getmedal(1,
$row
[
'regist'
]),
'fze'
=>getmedal(2,
$row
[
'posts'
]),
'wze'
=>getmedal(3,
$row
[
'cpoints'
]),
'cme'
=>getmedal(4,
$row
[
'medal'
]),
'sig'
=>
$row
[
'sig'
],
'ERFAHRUNG'
=>
$erfahrung
,
'NEXT'
=>
$next
,
'AWARDS'
=>
$awards
,
);
$title
=
$allgAr
[
'title'
].
' :: Users :: Details von '
.
$row
[
'name'
];
$hmenu
=
$extented_forum_menu
.
'<a class="smalfont" href="?user">Users</a><b> » </b> Details von '
.
$row
[
'name'
].
$extented_forum_menu_sufix
;
$design
=
new
design (
$title
,
$hmenu
, 1);
$design
->header();
[b]
$tpl
=
new
tpl (
'user/userdetails'
); HATTE ES HIERFÜR EINGEFÜGT!!!!![/b]
$l
= profilefields_show (
$uid
);
$ar
[
'rowspan'
] = 4 + substr_count(
$l
,
'<tr><td class="'
);
$ar
[
'profilefields'
] =
$l
;
$tpl
->set_ar_out(
$ar
,0);
$tpl
->set_out(
'teams'
, user_get_teams(
$uid
),1);
$tpl
->set_out(
'Battlefield 2'
, get_last_user_wars(
$uid
,
'Battlefield 2'
),2);
$tpl
->set_out(
'Medal of Honor'
, get_last_user_wars(
$uid
,
'Medal of Honor'
),3);
$tpl
->set_out(
'Battlefield 3'
, get_last_user_wars(
$uid
,
'Battlefield 3'
),4);
$design
->footer();
?>