1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
<html>
<head>
<title>GRID TIP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT language='javascript'>
function cancel_profile(){
window.location = "gridtip.php?u_id="+form_user.UserID.value;
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" link='#000000' alink='#000000' vlink='#000000'>
<link href="shoutbox/style.css" rel="stylesheet" type="text/css" />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" width="33%"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">GRID TIP is best viewed in 1280x1024</font></td>
<td align="center" width="33%"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="admin/admin.php" target="_blank">admin</a>
| <a href="http://www.mamweb.at/gridtip_2007/" target="_blank">last season</a>
| <a href="members.php">members list</a></font></td>
<td align="right" width="33%"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<?PHP
// Original Script melbdate.php3 copyright (c) 2000 by Dean Kennedy, Terrabyte Communications
// Version 1.03 04 June 2006
// Free to use, modify and copy. You can safely delete all other commented lines and just leave the four line script
// Distributed under the terms of the GNU General Public License (GPL). There is NO WARRANTY, it is provided AS IS. Use it at your own risk.
// http://www.gnu.org/copyleft/gpl.html
$hourdiff = "0"; // hours difference between server time and local time
$serverdate = date("l, d F Y - H:i:s \h");
echo "<div align='right'>";
echo "Server Time: ";
print ("$serverdate");
print ("<BR>");
$timeadjust = ($hourdiff * 60 * 60);
$melbdate = date("l, d F Y - H:i:s \h",time() + $timeadjust);
echo "Local Time: ";
print ("$melbdate");
echo "</div>";
?>
</font>
</td>
</tr>
</table>
<p align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="7"><b><img src="images/raceflag-l.gif" width="85" height="60"> GRID
<i>TIP <img src="images/raceflag-r.gif" width="85" height="60"></i></b></font></p>
<?PHP
require("date_diff_f1.php");
mysql_pconnect("localhost", "admin", "mscmks71s11f132n") or die("Unable to connect to SQL server");
mysql_select_db("niki_2008") or die("Unable to select database");
?>
<table width="100%" border="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td bgcolor="#99CCFF"><font face="Verdana, Arial, Helvetica, sans-serif" size="3"><b>members
list </b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<?PHP
echo "<table width='100%' border='0'><tr><td width='25%'> <td width='20%'> </td><td width='130'> </td><td width=> </td></tr>";
$x=0;
$members=mysql_query("select u_pic, u_name, u_realname, u_nickname, u_nationality, u_favdriver, d_lname, d_fname, u_since from users left outer join drivers on u_favdriver=d_id order by u_name asc;");
while ($members_list=mysql_fetch_array($members)) {
$user_pic[$x]=$members_list['u_pic'];
$user_name[$x]=$members_list['u_name'];
$user_realname[$x]=$members_list['u_realname'];
$user_nickname[$x]=$members_list['u_nickname'];
$user_nationality[$x]=$members_list['u_nationality'];
$user_favdriver[$x]=$members_list['d_lname']." ".$members_list['d_fname'];
$user_since[$x]=$members_list['u_since'];
$x=$x+1;
}
for ($i=0;$i<$x;$i++)
{
echo "<tr><td rowspan='7'> </td><td rowspan='7' div align='center'><img src='images/".$user_pic[$i]."' border='1'></img></td>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>username:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_name[$i]."</b></td>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>realname:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_realname[$i]."</b>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>nickname:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_nickname[$i]."</b>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>nationality:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_nationality[$i]."</b></td>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>favourite driver:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_favdriver[$i]."</b></td>";
echo "<tr><td div align='right'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>GRID <i>TIPPER</i> since:</font></div></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$user_since[$i]."</b></td>";
echo "<tr><td> </td><td> </td><td> </td></tr>";
echo "<tr><td colspan='4'><HR></td></tr>";
echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
}
echo "</table>";
?>
</td>
</tr>
</table>
</body>
</html>
|