$sql="SELECT
u.user_id, u.user_uploaded, u.user_uploaded_self, u.user_downloaded, u.user_permissions, u.user_bonus, u.user_type, u.user_tracker_data,
tr.id, tr.seeders, tr.leechers, tr.times_completed, tr.added, tr.free, tr.size, tr.upload, tr.req_ratio, tr.req_upload, tr.poster_id, tr.unreg, tr.tsl_speed, tr.lastslspeed,
t.forb"
.($config['ppkbb_tcenable_snatchstat'] ? ", s.finished, s.bonus_count, s.id s_id" : '')."
FROM ".USERS_TABLE." u
LEFT JOIN " . TRACKER_TORRENTS_TABLE . " tr ON (tr.info_hash='{$info_hash}')
LEFT JOIN " . TOPICS_TABLE . " t ON (t.topic_id=tr.topic_id)"
.($config['ppkbb_tcenable_snatchstat'] ? " LEFT JOIN ".TRACKER_SNATCHED_TABLE." s ON (tr.id=s.torrent AND u.user_id=s.userid AND s.guests='0'" : '')
." WHERE u.user_passkey='{$passkey}' AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ") LIMIT 1";