Kavalero's personal page

<?php include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."user_fields.php";
include LOCALE.LOCALESET."photogallery.php";

$result = dbquery("SELECT * FROM ".$dbprefix."users WHERE userid=2304");
if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
opentable("Досье ".$data['username'].". <a target="blank" href="http://www.forum.newgalaxy.ru/index.php?act=Profile&CODE=showuser&MID=8570">[Data ".$data1['username']." on the forum]");
$comment = dbcount("(comment
id)", "comments", "commentname='".$data['userid']."'");
$screens = dbresult(dbquery("SELECT COUNT(photoid) FROM ".$dbprefix."photos WHERE userid='".$data['userid']."' AND albumid<>'10'"),0);

if ($screens == "") $screens = 0;

$blueprints = dbresult(dbquery("SELECT COUNT(photo
id) FROM ".$dbprefix."photos WHERE userid='".$data['userid']."' AND albumid='10'"),0);
$rating = dbcount("(ratingid)", "ratings", "ratinguser='".$data['userid']."'");
$vote = dbcount("(vote
id)", "pollvotes", "voteuser='".$data['user_id']."'");
$votesum = $vote + $rating;
include INCLUDES."levels.php";

echo "

";
echo "
";
echo "

";

if ($data['usergroups'] != "") {
$img = $data['user
groups'];
$zamena[1] = "/.1/";
$rep[1] = "1";
$zamena[2] = "/.2/";
$rep[2] = "2";
$zamena[3] = "/.3/";
$rep[3] = "3";

$imgtrue = pregreplace($zamena, $rep, $img);
echo "
";
}
if ($data['usermavatar'] != "0") {
$mavatar = "<img src='images/miniavatars/".$data[' user
mavatar border="0" alt="" title="Респект и уважуха ему, он за это заплатил!">";
} else {
$mavatar = "";
}
echo "".$mavatar." ".$data['user_name']."
".$level."

";

echo ($data['useravatar'] ? "<img src='".IMAGES."avatars/".$data[' useravatar alt='".$locale[' u017>" : "Нет аватара")."
";

echo "

";
if (!isset($userdata['userid']) || $data['userid'] != $userdata['userid']) {
echo "



";
}
echo "













Private:
<a href='messages.php?msgsend=".$data[' userid title="Послать приватное сообщение">ЛС

".$locale['u011']."
".($data['usericq'] ? $data['usericq'] : $locale['u048'])."

".$locale['u051'].":
";
if ($data['userhideemail'] != "1" || iADMIN) {
echo "<a href='mailto:".$data[' user
email>".trimlink($data['useremail'], 20)."";
} else {
echo "hidden";
}
echo "

WWW:
";
if ($data['userweb']) {
echo "".trimlink($data['userweb'], 20)."n";
} else {
echo "".$locale['u048']."";
}
echo "
";
echo "
";
echo " Nickname: ".$data['username']."

Rank: ".$level."

".$locale['u009']." ".($data['userlocation'] ? $data['userlocation'] : $locale['u048'])."

".$locale['u010']." ";
if ($data['userbirthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user
birthdate = explode("-", $data['userbirthdate']);
echo $months[number
format($userbirthdate['1'])]." ".numberformat($userbirthdate['2'])." ".$userbirthdate['0'];
} else {
echo $locale['u048'];
}
echo "

".$locale['u040']." ".showdate("longdate", $data['userjoined'])."

".$locale['u044']." ".($data['user
lastvisit'] != 0 ? showdate("longdate", $data['userlastvisit']) : $locale['u049'])."

".$locale['u042']." ".$comment."";
if (checkrights("C"))
if ($comment != "0") echo " <a href='administration/user
comments.php?userid=".$data[' userid target="blank">(all comments)";
echo "
Votes cast: ".$votesum."";
echo "
Screenshots submitted: ".$screens."";
if ($screens != "0") echo " (<a href='usersreenshots.php?user
id=".$data[' userid target="blank">view all)";
if ($data['userworks'] != "0") echo "
Works submitted: ".$data['user
works']."";
if ($blueprints != "") echo "
Blueprints submitted: ".$blueprints."";
echo "
n";
echo " Total ANR: ".$data['usersum']."";
if (iADMIN) echo " (<a href='".ADMIN."user
reports.php?userid=".$data[' userid target="blank">report)";
echo "
Wins:
1st place in the "NFS-Tuning" contest (season 1-Carbon)
2nd place in the "NFS-Tuning" contest (season 1-Carbon)
1st place in the "NFS-Tuning" contest (season 2-Carbon)";
echo "
n";
echo "
";
echo "

";
echo "";
echo "";
echo "";
if ($data['userworks'] != "0") {
echo "

User's most downloaded works
";
echo "";
$result2 = dbquery("SELECT downloadid,downloadcount,downloadtitle,downloadcat FROM ".DBPREFIX."downloads WHERE downloaduser='".$data[2484]."' ORDER BY downloadcount DESC LIMIT 5");
while ($data2 = dbarray($result2)) {
$cat
title = dbresult(dbquery("SELECT downloadcatname FROM ".$dbprefix."downloadcats WHERE downloadcatid=".$data2['downloadcat'].""),0);
echo "




";
}

echo "


<a href='downloads.php?view=".$data2[' downloadid target="blank">".$data2['downloadtitle']."
".$cattitle."(".$data2['downloadcount'].")"
";
}
opentable("Me and NFS");
echo "";
echo "";
echo "

I don't know what to write about, I'll probably write about what I'd like to see in a new NFS. I'll say right away that I'm not exactly a hardcore fan of the series. But racing simulators are one of my favorite genres of computer games. I started getting friendly with the PC relatively recently, about two years ago, but in that time I've managed to play a pretty decent number of racing games, from simulators like GTR to the simplest arcades. And every more or less decent game had its own thing: some won you over with realism, others with beautiful scenery... others with tuning. So I thought, wouldn't it be great if someday a game came out that combined all the best from other games! In principle I've already written about what I'd like to see in a new NFS, about why people love the old parts and don't much care for the new ones. Right now I'm playing the fourth part of this already cult series
High Stakes and I understand what the new parts are missing. They're missing the most important thing, I don't know how to say it properly, the "spirit of rivalry". In racing simulator games that should come first and foremost! And the main "thing" of the two Undergrounds was visual tuning, the whole point of the game boiled down to building the prettiest, ten-star car. The same can be said about Carbon. The only bright spot in Carbon for me is of course the ability to paint up a car like a devil by slapping 20 vinyls on it (if you do it properly you can create something), and the canyon races, which are honestly ruined by the overly arcade handling. ProStreet is just a raw and unfinished product that could have turned into a game that would stand on the same level as the old parts. Of the new parts, Most Wanted stands apart for me, or rather a bit to the side. Yes, sure, I won't argue, like Carbon it has the worst handling in the whole series, yes, it doesn't have the smartest plot (why would anyone chase some BMW if he has a fully tricked-out Lamborghini, Porsche and Aston Martin sitting in his garage). But still, there's something about it I like!
But in the same High Stakes, first place goes to beating your rival. In the new parts, the most interesting thing to do was to make the MOST beautiful car, hold out as long as possible in a chase with the cops, etc.; in the old parts, what was interesting was precisely beating your rival!!! Don't think that this is a fan of the old parts ranting here, no. When I bought myself a computer, they installed Most Wanted on it, and I remember I pulled off such chases, for an hour or even more! In Carbon, like in Underground, I liked tuning cars. But here's the problem: racing against rivals was somehow not that great; if I did finish races, it was to unlock a new vinyl or spoiler!
Anyway, fine, whoever wants to can agree, someone will think everything written is nonsense, the main thing isn't that but that at the start I wanted to write here what kind of new NFS I wanted to see!

What I see NFS as in the future.

Well, first of all I want a continuation of the "pop" street racing theme (1 the classics won't happen anymore, 2 it's hard to come up with anything else, 3 I just want it)
I want a city, but only a proper city, with a square, a subway, streets, and not just a bunch of roads! Or better yet, at least a tiiiny state (like in GTA only small). And most importantly, I'd want this city (state) to be alive, like buses running on schedule, people living (though how to do that without it turning into Carmageddon I have no idea), so that in the city center there's more traffic up to traffic jams, and less on the outskirts... It would be simply great to make, somewhere in this state, districts where you could lay out tracks from the old NFS games or at least very similar ones; I think all fans of the old parts would appreciate that.



I want a loooot of cars!!! But arranged so that they fit the theme. Like, for example, if the game is about street racing, then cars like Civics, Golfs, etc.; of course you can have a couple of Ferraris and similar cars, but then not the most powerful ones. A 914 Porsche could well have gone to a lucky racer from a kind grandpa. As for the claim that many cars will feel similar to drive, go play Test Drive Unlimited: almost a hundred cars and EACH one with its own character! I won't speak for Gran Turismo, haven't played it, but I've heard there are no fewer cars there and each car is individual too.



I want PROPER tuning (existing body kits, spoilers, rims...)! And such that in order for your car to truly be the best, you'd have to sit in the garage with the settings! It would be great if you could take the engine from one car and stuff it into another, and that would take real time, because of which, for example, you could miss a race. And parts in the car would wear out: if the engine overheated and burned out, then damn, you'd think twenty times about whether to put nitrous on the car or not! Well, and everything in the same spirit, figure out the rest yourselves... (to be honest I stole the idea from the game American Street Drag, though roughly the same idea is in the fourth part of NFS) Neon, window tinting and everything in that spirit is welcome, the main thing is that all of it doesn't affect completing the game. Like, put it on if you want, don't if you don't.

I want various types of races! Drift, drag, circuit plus their various variants like in ProStreet!!! But at the same time I'd want the car to behave the same everywhere, i.e. so that in drift it doesn't skid like crazy and on the circuit it doesn't rear up like in drag! I'd want races to be held not only on the road but like in the Fast and the Furious, for example on parking lots in high-rise buildings... and the opponent's level would depend on the bet you make, and most importantly that when you lose you lose money (parts, car). But racing on the street between traffic, that's not street racing. Street racing is something like the "Street X" races or URL like in Underground 2. Like, you're driving around seemingly not bothering anyone, but suddenly angry cops swoop in, and you don't want to go to jail, and off goes the scramble between traffic!

I want cops!!! It is street racing after all. And with everything listed above, these would be real chases!!! (I pictured the situation: I'm tearing around some district running from the cops, and at the same time I remember that, for example, at midnight a drawbridge will be raised. So I bolted to the bridge, jumped it, the cops didn't jump and fell behind! However, I suffered from that jump too. Suspension shot to hell, the tires died from that pressure too, and the cops managed to radio that I'm fleeing in that direction! Well, and I in my bucket of bolts as quickly as possible to some hideout! (BEAUTIFUL, DAMN!) Then "hitting" traffic would be critical too.

I'm tired of writing, there's already so damn much. In school my essays came out shorter than this... If you read it +


";
closetable();
opentable("Files from ".$data['username'].". <a target="blank" href="nfsmaster.php?cat=userworks&id=2304">[All files ".$data['username']."]");
if ($data['user
works'] != "0") {
echo "

The user's most downloaded works
";
echo "";
$result2 = dbquery("SELECT downloadid,downloadcount,downloadtitle,downloadcat FROM ".DBPREFIX."downloads WHERE downloaduser='".$data['userid']."' ORDER BY downloadcount DESC LIMIT 10");
while ($data2 = dbarray($result2)) {
$cattitle = dbresult(dbquery("SELECT downloadcatname FROM ".$dbprefix."downloadcats WHERE downloadcatid=".$data2['downloadcat'].""),0);
echo "



";
}

echo "


".$data2['downloadtitle']."
".$cattitle." (".$data2['download_count'].")
";
} else {
echo "
No files from the user
";
}
closetable();
opentable("Wallpapers from ".$data['user_name'].".");
echo "

Обоя от Kavalero
1240x1024

";
closetable();
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if (isset($photo) && !isNum($photo)) fallback(FUSIONSELF);
if (isset($album) && !isNum($album)) fallback(FUSION
SELF);
function checkImageExists($imagefile) {
if(file
exists($imagefile)) {
return $image
file;
}else{
return IMAGES."imagenotfound.jpg";
}
}

$result1 = dbquery("SELECT userid,username FROM ".$dbprefix."users WHERE userid=2304");
$data1 = dbarray($result1);

opentable("Screenshots from ".$data1['username'].". <a target="blank" href="usersreenshots.php?userid=2304">[All screenshots ".$data1['username']."]");
echo "

The user's latest screenshots.

";
$screens = dbresult(dbquery("SELECT COUNT(photoid) FROM ".$dbprefix."photos WHERE userid='".$data1['userid']."' AND albumid<>'10'"),0);
if ($screens > "0") {
$data=dbarray(dbquery(
"SELECT ta.*, COUNT(photo
id) as photocount, MAX(photodate) as maxdate, username
FROM ".$dbprefix."photoalbums AS ta
LEFT JOIN ".$dbprefix."photos USING (albumid)
LEFT JOIN ".$dbprefix."users USING (userid)
WHERE ta.albumid='".$album."' AND ta.albumid<>'10' GROUP BY albumid"
));
$piccnt=$screens;
$result = dbquery(
"SELECT tp.*, COUNT(comment
itemid) AS commentcount
FROM ".$dbprefix."photos AS tp LEFT JOIN ".$dbprefix."comments
ON photoid = commentitemid AND commenttype='P'
WHERE userid=2304 AND albumid<>'10' GROUP BY photoid
ORDER BY photo
date DESC LIMIT ".$rowstart.",4"
);
if(dbrows($result)>0){
echo "nn";
$imgcnt=0;
while($data=dbarray($result)){
$tot
votes = dbresult(dbquery("SELECT COUNT(ratingitemid) FROM ".$dbprefix."ratings WHERE ratingitemid='".$data['photoid']."' AND ratingtype='S'"),0);
$sum
vote = dbresult(dbquery("SELECT SUM(ratingvote) FROM ".$dbprefix."ratings WHERE ratingitemid='".$data['photoid']."' AND ratingtype='S'"),0);
if($totvotes){
$pc
rating = sprintf("%.1f", $sumvote/$totvotes);
$pctrating = "<span title="Оценка скриншота: $pcrating/$totvotes">";
}else {
$pct
rating = "";
}
$username = $data[2304];
$result2 = dbquery("SELECT * FROM ".$db
prefix."users WHERE userid=2304");
$data2 = dbarray($result2);
$data['photo
title'] = stripslashes($data['phototitle']);
echo "<td width='".round(100/$settings[' thumbs
perrow align="center" valign="top">
<a href="pictura.php?screen=$data[photo
id]" class="gallery" target="blank">
<img src='".checkImageExists(PHOTOS.$data[' photo
id width='".$settings[' thumbimagew height='".$settings[' thumbimageh title='".$data[' phototitle alt='".$locale['>


".$locale['414']."".($data['photo
views']==0?$locale['412']:$data['photoviews'])."

".($data['comment
count']==0?$locale['415']:"".$data['commentcount']." ".($data['commentcount']==1?$locale['416']:$locale['417']))."
".$pctrating." Total score: ".$data['photosum']."

";
if(++$imgcnt%$settings['thumbsperrow']==0) echo "
nn";
}
echo "
n
n";
}else{
echo "


".$locale['418']."


";
}
if ($piccnt != 0) echo "
".makePageNav($rowstart,$settings['thumbsperpage'],$piccnt,3,FUSIONSELF."?userid=$userid&")."
n";
} else {
echo "
User ".$data1['user_name']." has not submitted any screenshots
";
}

echo "

Best screenshots of the user.

";
$screens = dbresult(dbquery("SELECT COUNT(photoid) FROM ".$dbprefix."photos WHERE userid='".$data1['userid']."' AND albumid<>'10'"),0);
if ($screens > "0") {
$data=dbarray(dbquery(
"SELECT ta.*, COUNT(photo
id) as photocount, MAX(photodate) as maxdate, username
FROM ".$dbprefix."photoalbums AS ta
LEFT JOIN ".$dbprefix."photos USING (albumid)
LEFT JOIN ".$dbprefix."users USING (userid)
WHERE ta.albumid='".$album."' AND ta.albumid<>'10' GROUP BY albumid"
));
$piccnt=$screens;
$result = dbquery(
"SELECT tp.*, COUNT(comment
itemid) AS commentcount
FROM ".$dbprefix."photos AS tp LEFT JOIN ".$dbprefix."comments
ON photoid = commentitemid AND commenttype='P'
WHERE userid=2304 AND albumid<>'10' GROUP BY photoid
ORDER BY photo
sum DESC LIMIT ".$rowstart.",4"
);
if(dbrows($result)>0){
echo "nn";
$imgcnt=0;
while($data=dbarray($result)){
$tot
votes = dbresult(dbquery("SELECT COUNT(ratingitemid) FROM ".$dbprefix."ratings WHERE ratingitemid='".$data['photoid']."' AND ratingtype='S'"),0);
$sum
vote = dbresult(dbquery("SELECT SUM(ratingvote) FROM ".$dbprefix."ratings WHERE ratingitemid='".$data['photoid']."' AND ratingtype='S'"),0);
if($totvotes){
$pc
rating = sprintf("%.1f", $sumvote/$totvotes);
$pctrating = "<span title="Оценка скриншота: $pcrating/$totvotes">";
}else {
$pct
rating = "";
}
$username = $data[2304];
$result2 = dbquery("SELECT * FROM ".$db
prefix."users WHERE userid=2304");
$data2 = dbarray($result2);
$data['photo
title'] = stripslashes($data['phototitle']);
echo "<td width='".round(100/$settings[' thumbs
perrow align="center" valign="top">
<a href="pictura.php?screen=$data[photo
id]" class="gallery" target="blank">
<img src='".checkImageExists(PHOTOS.$data[' photo
id width='".$settings[' thumbimagew height='".$settings[' thumbimageh title='".$data[' phototitle alt='".$locale['>


".$locale['414']."".($data['photo
views']==0?$locale['412']:$data['photoviews'])."

".($data['comment
count']==0?$locale['415']:"".$data['commentcount']." ".($data['commentcount']==1?$locale['416']:$locale['417']))."
".$pctrating." Total score: ".$data['photosum']."

";
if(++$imgcnt%$settings['thumbsperrow']==0) echo "
nn";
}
echo "
n
n";
}else{
echo "


".$locale['418']."


";
}
if ($piccnt != 0) echo "
".makePageNav($rowstart,$settings['thumbsperpage'],$piccnt,3,FUSIONSELF."?userid=$userid&")."
n";
} else {
echo "
User ".$data1['user_name']." has not submitted any screenshots
";
}
closetable();
closetable();
?>