1

$sql = mysql_query("SELECT 'tipus', 'vid', 'title', 'uid', 'uploaded' FROM xbt_users AS videok WHERE uid OR tipus OR vid OR uploaded ") or die(mysql_error());

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

$sql = mysql_query("SELECT 'tipus', 'vid', 'title', 'uid', 'uploaded' FROM xbt_users AS videok WHERE uid OR tipus OR vid OR uploaded ") or die(mysql_error());
mysql_clear_var($_GET);
if(!isset($_GET['tipus']) || (!isset($torrent_categories[$_GET['tipus']]) && $_GET['tipus'] != 'all')) {
    $_GET['tipus'] = 'all';
}
section_begin("Saját feltöltéseim", 1);
if(mysql_num_rows($sql) == 0) {
echo "<p><center><font color='yellow'>Nincs még olyan videó, amit te magad töltöttél fel.</font></center></p>";
}
else {
echo "<div align=\"center\">$linebreak";
?>
<table class="tblcontent" width="700" border="1" cellpadding="0">
    <tr>
        <td class="tbl_colhead"><p class="tbl_colhead">Típus</p></td>
        <td class="tbl_colhead"><p class="tbl_colhead">Videó neve</p></td>
        <td class="tbl_colhead"><p class="tbl_colhead">Feltöltve</p></td>
    </tr>
<?
    while ($res = mysql_fetch_row($sql)) {
        if(strlen($res[5]) > $maxtorrentnamelength)
            $name_temp = substr($res[5], 0, $maxtorrentnamelength)."...";
        else
            $name_temp = $res[5];
?>
    <tr>
        <td class="tblcat" width="46"><p><a title="<?=$torrent_categories[$res[6]]['desc']?>" href="browse.php?tipus=<?php print $result['category']; ?>"><img src="kepek/<?=$res[6]?>.gif" alt="<?=$torrent_categories[$res[6]]['desc']?>" border="0"/></a></p></td>
        <td class="tblcell">  <a title="Videó megtekintése" href="video_details.php?vid=<? echo $row['vid']; ?>"><? echo $title; ?></a></td>
        <td class="tblcell"><p><?php print str_replace(' ','<br>',$result['uploaded']); ?></p></td>
    </tr>
 
 

1

$sql = mysql_query("SELECT a.fid, a.completed, UNIX_TIMESTAMP(a.ctime), a.name, a.tipus,  UNIX_TIMESTAMP(b.mtime) FROM xbt_files AS a LEFT JOIN xbt_files_users AS b ON b.info_hash = a.info_hash AND b.uid = $uid WHERE a.uploaded_by LIKE '%$nev|$uid%' ORDER BY a.ctime DESC");