[naotem]

What's the solution?

Originally Posted by Caterpillar

TU Error comes from one file - announce.php - by this cyclopic MySQL query (lines 164-178)

  ($Query = mysql_query ('
                    SELECT t.id as tid, t.name, t.category, t.size, t.added, t.visible, t.banned, t.free, t.silver, t.doubleupload,
                    u.id as userid, u.enabled, u.uploaded, u.downloaded, u.usergroup, u.birthday, u.ip,
                    g.isbanned, g.candownload, g.canviewviptorrents, g.isvipgroup, g.canfreeleech, g.waitlimit, g.slotlimit,
                    c.vip as isviptorrent
                     FROM torrents t
                    INNER JOIN users u ON (u.passkey = ' . sqlesc ($passkey) . ')
                    INNER JOIN usergroups g ON (u.usergroup = g.gid)
                    LEFT JOIN categories c ON (t.category=c.id)
                    WHERE (t.info_hash = ' . sqlesc ($info_hash) . ' OR t.info_hash = ' . sqlesc (preg_replace ('' . '/ *$/s', '', $info_hash)) . ')
                    LIMIT 1') OR stop ($l['sqlerror'] . ' TU1'));
  if ((((!$Result = mysql_fetch_assoc ($Query) OR !$Tid = $Result['tid']) OR $Result['enabled'] != 'yes') OR !$Result['userid']))
  {
    stop ($l['tuerror']);
  }

Indents and linebreaks retained as is.


Banned Client detection -- OFF