<?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
$abf
=
'SELECT * FROM prefix_user WHERE id = "'
.
$uid
.
'"'
;
$erg
= db_query(
$abf
);
$row
= db_fetch_assoc(
$erg
);
$user_name
=
$row
[
'name'
];
$abf2
=
"SELECT * FROM prefix_online"
;
$erg2
= db_query(
$abf2
);
$row2
= db_fetch_assoc(
$erg2
);
$recht
=
$row
[
'recht'
];
$abf3
=
"SELECT * FROM prefix_grundrechte WHERE id = "
.
$recht
.
""
;
$erg3
= db_query(
$abf3
);
$row3
= db_fetch_assoc(
$erg3
);
$abf4
=
"SELECT COUNT(*) AS forumtopics FROM prefix_topics WHERE erst = '$user_name'"
;
$erg4
= db_query(
$abf4
);
$row4
= db_fetch_assoc(
$erg4
);
$abf5
=
"SELECT COUNT(*) AS newstopics FROM prefix_news WHERE user_id = "
.
$uid
.
""
;
$erg5
= db_query(
$abf5
);
$row5
= db_fetch_assoc(
$erg5
);
$abf6
=
"SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'"
;
$erg6
= db_query(
$abf6
);
$row6
= db_fetch_assoc(
$erg6
);
$abf7
=
"SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'"
;
$erg7
= db_query(
$abf7
);
$row7
= db_fetch_assoc(
$erg7
);
$abf9
=
"SELECT COUNT(*) AS gallery_eintraege FROM prefix_usergallery WHERE uid = "
.
$uid
.
""
;
$erg9
= db_query(
$abf9
);
$row9
= db_fetch_assoc(
$erg9
);
if
(!
empty
(
$row
[
'icq'
])){
}
else
{
$icq
=
""
;
}
if
(
$row9
[
'gallery_eintraege'
] == 0){
$gallery_eintraege
=
"<span style=\"font-size:9px\"><i>keine Bilder</i></span>"
;
}
elseif
(
$row9
[
'gallery_eintraege'
] == 1){
$gallery_eintraege
=
"1 Bild vorhanden"
;
}
else
{
$gallery_eintraege
=
$row9
[
'gallery_eintraege'
].
" Bilder"
;
}
if
(!
empty
(
$row
[
'email'
]) &&
$row
[
'opt_mail'
] == 1){
$email
=
"<a href=\"mailto:"
.
$row
[
'email'
].
"\"><img src=\"include/images/profilmod/email.png\" border=\"0\" /></a>"
;
}
elseif
(!
empty
(
$row
[
'email'
]) &&
$row
[
'opt_mail'
] == 0){
$email
=
"<img src=\"include/images/profilmod/email.png\" border=\"0\" /></a>"
;
}
else
{
$email
=
"<img src=\"include/images/profilmod/keine_email.png\" border=\"0\" />"
;
}
if
(!
empty
(
$row
[
'homepage'
])){
$homepage
=
"<a href=\""
.
$row
[
'homepage'
].
"\" target=\"_blank\"><img src=\"include/images/icons/website_icon.png\" border=\"0\" /></a>"
;
}
else
{
$homepage
=
"<img src=\"include/images/icons/no_website_icon.png\" border=\"0\" /> <span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'cd'
])){
$cd
=
"<a href=\""
.
$row
[
'cd'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/cd.png\" border=\"0\" /></a>"
;
}
else
{
$cd
=
"<img src=\"include/images/profilmod/kein_cd.png\" border=\"0\" />"
;
}
if
(!
empty
(
$row
[
'facebook'
])){
$facebook
=
"<a href=\""
.
$row
[
'facebook'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/facebook.png\" border=\"0\" /></a>"
;
}
else
{
$facebook
=
""
;
}
if
(!
empty
(
$row
[
'youtube'
])){
$youtube
=
"<a href=\"http://www.youtube.com/user/"
.
$row
[
'youtube'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/youtube.png\" border=\"0\" /></a>"
;
}
else
{
$youtube
=
""
;
}
if
(!
empty
(
$row
[
'twitter'
])){
$twitter
=
"<a href=\""
.
$row
[
'twitter'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/twitter.png\" border=\"0\" /></a>"
;
}
else
{
$twitter
=
""
;
}
if
(!
empty
(
$row
[
'battlelog'
])){
}
else
{
$battlelog
=
""
;
}
if
(!
empty
(
$row
[
'google'
])){
$google
=
"<a href=\""
.
$row
[
'google'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/google.png\" border=\"0\" /></a>"
;
}
else
{
$google
=
""
;
}
if
(!
empty
(
$row
[
'xfire'
])){
$xfire
=
"<a href=\"http://www.xfire.com/profile/"
.
$row
[
'xfire'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/xfire.png\" border=\"0\" /></a>"
;
}
else
{
$xfire
=
""
;
}
if
(!
empty
(
$row
[
'teamspeak'
])){
$teamspeak
=
"<a href=\"ts3server://"
.
$row
[
'teamspeak'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/ts3.png\" border=\"0\" /></a>"
;
}
else
{
$teamspeak
=
""
;
}
if
(!
empty
(
$row
[
'staat'
])){
$staat
=
"<img src=\"include/images/flags/"
.
$row
[
'staat'
].
"\" border=\"0\" />"
;
}
else
{
$staat
=
"<img src=\"include/images/flags/na.gif\" border=\"0\" />"
;
}
#
##
### Steam Icon unter Profil
if
(!
empty
(
$row
[
'steam'
])){
$steam
=
"<a href=\"http://steamcommunity.com/id/"
.
$row
[
'steam'
].
"\" target=\"_blank\"><img src=\"include/images/profilmod/steam.png\" border=\"0\" /></a>"
;
}
else
{
$steam
=
""
;
}
#
##
### Steam Signatur
if
(!
empty
(
$row
[
'steam'
])){
$steampro
=
$row
[
'steam'
];
}
else
{
$steampro
=
$row
[
'steam'
];
}
$row
[
'koms'
] = db_count_query(
'SELECT COUNT(id) FROM `prefix_koms` WHERE name="'
.
$row
[
'name'
].
'"'
);
$pmge
= db_result(db_query(
"SELECT COUNT(ID) FROM `prefix_pm`"
),0);
$pmu
= db_result(db_query(
"SELECT COUNT(ID) FROM prefix_pm WHERE sid = '"
.
$uid
.
"'"
),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);
####################################################
$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);
####################################################
if
(!
empty
(
$row
[
'posten'
])){
$posten
=
"<img src=\"include/images/profilmod/posten/"
.
$row
[
'posten'
].
"\" border=\"0\" />"
;
}
else
{
$posten
=
"<img src=\"include/images/profilmod/posten/na.png\" border=\"0\" />"
;
}
$avatar
=
''
;
if
(
file_exists
(
$row
[
'avatar'
])) {
$avatar
=
'<img src="'
.
$row
[
'avatar'
].
'" align="center" border="0" width="120">'
;
}
elseif
(
$row
[
'avatar'
] ==
""
&&
$row
[
'geschlecht'
] ==
"1"
) {
$avatar
=
'<img src="include/images/avatars/gast.png" align="center" border="0" width="120">'
;
}
elseif
(
$row
[
'avatar'
] ==
""
&&
$row
[
'geschlecht'
] ==
"2"
) {
$avatar
=
'<img src="include/images/avatars/gast.png" align="center" border="0" width="120">'
;
}
else
{
$avatar
=
'<img src="include/images/avatars/gast.png" align="center" border="0" width="120">'
;
}
$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 ) );
$usertitel
=
$row3
[
'name'
];
if
(
$row2
[
'uid'
] ==
$uid
){
$online
=
'<b><span style="color:#009900;">online</span></b>'
;
}
else
{
$online
=
"<b>offline</b>"
;
}
if
(
$row
[
'geschlecht'
] == 1){
$geschlecht
=
'<span style="color:#0030ff">männlich</span>'
;
}
elseif
(
$row
[
'geschlecht'
] == 2){
$geschlecht
=
'<span style="color:#ff00c0">weiblich</span>'
;
}
else
{
$geschlecht
=
"unentschlossen"
;
}
if
(
$row
[
'gebdatum'
] !==
"0000-00-00"
){
$gebdatum
=
date
(
'd.m.Y'
,
strtotime
(
$row
[
'gebdatum'
]));
$tag
=
date
(
'd'
,
strtotime
(
$row
[
'gebdatum'
]));
$monat
=
date
(
'm'
,
strtotime
(
$row
[
'gebdatum'
]));
$jahr
=
date
(
'Y'
,
strtotime
(
$row
[
'gebdatum'
]));
$jetzt
=
mktime
(0,0,0,
date
(
"m"
),
date
(
"d"
),
date
(
"Y"
));
$geburtstag
=
mktime
(0,0,0,
$monat
,
$tag
,
$jahr
);
$alter
=
"("
.
intval
((
$jetzt
-
$geburtstag
) / (3600 * 24 * 365)).
")"
;
}
else
{
$gebdatum
=
"<span style=\"font-size:9px\"><i>Kein Datum angegeben</i></span>"
;
$alter
=
"<span style=\"font-size:9px\"><i>Kein Alter angegeben</i></span>"
;
}
function
Sternzeichen(
$t
,
$m
,
$j
) {
$tag
=
date
(
"d"
,
mktime
(0,0,0,
$m
,
$t
,
$j
));
$monat
=
date
(
"n"
,
mktime
(0,0,0,
$m
,
$t
,
$j
));
if
(
$tag
> 20 &&
$monat
== 3 ||
$tag
< 21 &&
$monat
== 4) {
$zeichen
=
"Widder"
;
}
if
(
$tag
> 20 &&
$monat
== 4 ||
$tag
< 21 &&
$monat
== 5) {
$zeichen
=
"Stier"
;
}
if
(
$tag
> 20 &&
$monat
== 5 ||
$tag
< 22 &&
$monat
== 6) {
$zeichen
=
"Zwillinge"
;
}
if
(
$tag
> 21 &&
$monat
== 6 ||
$tag
< 23 &&
$monat
== 7) {
$zeichen
=
"Krebs"
;
}
if
(
$tag
> 22 &&
$monat
== 7 ||
$tag
< 24 &&
$monat
== 8) {
$zeichen
=
"Löwe"
;
}
if
(
$tag
> 23 &&
$monat
== 8 ||
$tag
< 24 &&
$monat
== 9) {
$zeichen
=
"Jungfrau"
;
}
if
(
$tag
> 23 &&
$monat
== 9 ||
$tag
< 24 &&
$monat
== 10) {
$zeichen
=
"Waage"
;
}
if
(
$tag
> 23 &&
$monat
== 10 ||
$tag
< 23 &&
$monat
== 11) {
$zeichen
=
"Skorpion"
;
}
if
(
$tag
> 22 &&
$monat
== 11 ||
$tag
< 22 &&
$monat
== 12) {
$zeichen
=
"Schütze"
;
}
if
(
$tag
> 21 &&
$monat
== 12 ||
$tag
< 21 &&
$monat
== 1) {
$zeichen
=
"Steinbock"
;
}
if
(
$tag
> 20 &&
$monat
== 1 ||
$tag
< 20 &&
$monat
== 2) {
$zeichen
=
"Wassermann"
;
}
if
(
$tag
> 19 &&
$monat
== 2 ||
$tag
< 21 &&
$monat
== 3) {
$zeichen
=
"Fische"
;
}
return
"$zeichen"
;
}
if
(
$row
[
'gebdatum'
] !==
"0000-00-00"
){
$sternzeichen
= Sternzeichen(
$tag
,
$monat
,
$jahr
);
}
else
{
$sternzeichen
=
"<span style=\"font-size:9px\"><i>Unbekannt</i></span>"
;
}
if
(!
empty
(
$row
[
'wohnort'
])){
$wohnort
=
$row
[
'wohnort'
];
}
else
{
$wohnort
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'statustext'
])){
$statustext
=
$row
[
'statustext'
];
}
else
{
$statustext
=
"Kein Status Eingetragen"
;
}
if
(!
empty
(
$row
[
'cseite'
])){
$cseite
=
"<a href=\""
.
$row
[
'cseite'
].
"\" target=\"_blank\">hier entlang</a>"
;
}
else
{
$cseite
=
"<span style=\"font-size:9px\"><i>keine Clanseite</i></span>"
;
}
if
(!
empty
(
$row
[
'cname'
])){
$cname
=
$row
[
'cname'
];
}
else
{
$cname
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'ctag'
])){
$ctag
=
$row
[
'ctag'
];
}
else
{
$ctag
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'clanlogo'
])){
$clanlogo
=
"<img src=\"include/images/profilmod/clanlogos/"
.
$row
[
'clanlogo'
].
"\" width=\"100\" border=\"0\" />"
;
}
else
{
$clanlogo
=
"<img src=\"include/images/profilmod/clanlogos//na.png\" border=\"0\" />"
;
}
if
(!
empty
(
$row
[
'cpubild'
])){
$cpubild
=
"<img src=\"include/images/profilmod/cpubild/"
.
$row
[
'cpubild'
].
"\" border=\"0\" />"
;
}
else
{
$cpubild
=
"<img src=\"include/images/profilmod/cpubild/na.png\" border=\"0\" />"
;
}
if
(!
empty
(
$row
[
'gpubild'
])){
$gpubild
=
"<img src=\"include/images/profilmod/grafikbild/"
.
$row
[
'gpubild'
].
"\" border=\"0\" />"
;
}
else
{
$gpubild
=
"<img src=\"include/images/profilmod/grafikbild/na.png\" border=\"0\" />"
;
}
######## Profil erweit. #######
if
(!
empty
(
$row
[
'board'
])){
$board
=
$row
[
'board'
];
}
else
{
$board
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'prozesor'
])){
$prozesor
=
$row
[
'prozesor'
];
}
else
{
$prozesor
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'ram'
])){
$ram
=
$row
[
'ram'
];
}
else
{
$ram
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'grafik'
])){
$grafik
=
$row
[
'grafik'
];
}
else
{
$grafik
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'tasta'
])){
$tasta
=
$row
[
'tasta'
];
}
else
{
$tasta
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'maus'
])){
$maus
=
$row
[
'maus'
];
}
else
{
$maus
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'system'
])){
$system
=
$row
[
'system'
];
}
else
{
$system
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'sound'
])){
$sound
=
$row
[
'sound'
];
}
else
{
$sound
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'hdd'
])){
$hdd
=
$row
[
'hdd'
];
}
else
{
$hdd
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'monitor'
])){
$monitor
=
$row
[
'monitor'
];
}
else
{
$monitor
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'inet'
])){
$inet
=
$row
[
'inet'
];
}
else
{
$inet
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'headset'
])){
$headset
=
$row
[
'headset'
];
}
else
{
$headset
=
"<span style=\"font-size:9px\"><i>Keine Angabe</i></span>"
;
}
if
(!
empty
(
$row
[
'mich'
])){
$mich
=
$row
[
'mich'
];
}
else
{
$mich
=
"<span style=\"font-size:9px\"><i>Sorry - Hier wurden leider keine Angaben gemacht</span>"
;
}
######### ENDE ########
#
##
###
####Erfahrung/NächsterRang
if
(
$row
[
'posts'
] != 0)
{
$postar
=
array
(1,5,25,50,75,100,125,150,175,200,225,250,275,300,325,350,375,400,425,450,475,500,525,550,575,600,625,650,675,700,725,750,775,800,2500);
$postarnames
=
array
(Level_1,Level_2,Level_3,Level_4,Level_5,Level_6,Level_7,Level_8,Level_9,Level_10,Level_11,Level_12,Level_13,Level_14,Level_15,Level_16,Level_17,Level_18,Level_19,Level_20,Level_21,Level_22,Level_23,Level_24,Level_25,Level_26,Level_27,Level_28,Level_29,Level_30,Level_31,Level_32,Level_33,Level_34,Level_35);
$i
=0;
while
(
$postar
[
$i
] <
$row
[
'posts'
])
{
$next
=
round
(100/(
$postar
[
$i
+1]-
$postar
[
$i
])*(
$row
[
'posts'
]-
$postar
[
$i
]),2);
if
(
$postar
[
$i
+1] !=
$row
[
'posts'
]) {
$pointsleft
=
$postar
[
$i
+1] -
$row
[
'posts'
];
$nextrank
=
$postarnames
[
$i
+1]; }
else
{
$pointsleft
=
$postar
[
$i
+2] -
$row
[
'posts'
];
$nextrank
=
$postarnames
[
$i
+2]; }
$i
++;
}
}
else
{
$next
=
"0%"
;
}
$erfahrung
=
round
(100/350*
$row
[
'posts'
],2);
#### ende
###
##
#
?>