-
Notifications
You must be signed in to change notification settings - Fork 0
/
showuser.php
executable file
·107 lines (94 loc) · 2.74 KB
/
showuser.php
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
<?php
include('includes/includes.php');
$vuser = $_GET['userid'];
$vname = bd_getUsername($vuser);
$query = "select website,joined from users where userID=$vuser";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$website = stripslashes($row['website']);
$joined = $row['joined'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>
<?php echo "$wikilang_user $vname - wikisubtitles.net"; ?>
</title>
</head>
<body>
<?php
include('header.php');
?>
<table width="90%" border="0">
<tr><td class="titulo" colspan="4">
<?php echo $vname; ?>
</td></tr>
<tr>
<td ><img src="/images/invisible.gif" width="50" height="5"/></td>
<td class="NewsTitle"><?php echo $wikilang_account_creation; ?></td>
<td><?php echo $joined; ?></td>
<td> </td>
</tr>
<tr>
<td ><img src="/images/invisible.gif" width="50" height="5"/></td>
<td class="NewsTitle"><?php echo $wikilang_website; ?></td>
<td><?php echo "<a href=\"$website\">$website</a>"; ?></td>
<td> </td>
</tr>
<?php
$query = "select distinct(subID) from files where author=$vuser";
$result = mysql_query($query);
$total_created = mysql_affected_rows();
?>
<tr>
<td ><img src="/images/invisible.gif" width="50" height="5"/></td>
<td class="NewsTitle"><?php echo $wikilang_files_create; ?></td>
<td><?php echo "$total_created"; ?></td>
<td> </td>
</tr>
<?php
while ($row=mysql_fetch_assoc($result))
{
$myID = $row['subID'];
$titulo = bd_getTitle($myID);
$url = bd_getUrl($myID);
echo '<tr>
<td ><img src="'.$SCRIPT_PATH.'images/invisible.gif" width="50" height="5"/></td>
<td> </td>
<td><img src="'.$SCRIPT_PATH.'images/package.png" width="16" height="16"/> <a href="'.$url.'">'.$titulo.'</a></td>
<td> </td>
</tr>';
}
$query = "select distinct(subID) from subs where authorID=$vuser and version>0";
$result = mysql_query($query);
$total_created = mysql_affected_rows();
?>
<tr>
<td ><img src="/images/invisible.gif" width="50" height="5"/></td>
<td class="NewsTitle"><?php echo $wikilang_files_edited; ?></td>
<td><?php echo "$total_created"; ?></td>
<td> </td>
</tr>
<?php
while ($row=mysql_fetch_assoc($result))
{
$myID = $row['subID'];
$titulo = bd_getTitle($myID);
$url = bd_getUrl($myID);
echo '<tr>
<td ><img src="'.$SCRIPT_PATH.'images/invisible.gif" width="50" height="5"/></td>
<td> </td>
<td><img src="'.$SCRIPT_PATH.'images/package.png" width="16" height="16"/> <a href="'.$url.'">'.$titulo.'</a></td>
<td> </td>
</tr>';
}
?>
</table>
<?php
include('footer.php');
bbdd_close();
?>
</body>
</html>