mirror of
https://github.com/torrentpier/torrentpier.git
synced 2024-12-14 16:11:16 -08:00
248 lines
7.9 KiB
PHP
248 lines
7.9 KiB
PHP
<?php
|
||
/**
|
||
* TorrentPier – Bull-powered BitTorrent tracker engine
|
||
*
|
||
* @copyright Copyright (c) 2005-2024 TorrentPier (https://torrentpier.com)
|
||
* @link https://github.com/torrentpier/torrentpier for the canonical source repository
|
||
* @license https://github.com/torrentpier/torrentpier/blob/master/LICENSE MIT License
|
||
*/
|
||
|
||
/**
|
||
* Set/change quotas
|
||
*
|
||
* @param $mode
|
||
* @param $id
|
||
* @param $quota_type
|
||
* @param int $quota_limit_id
|
||
*/
|
||
function process_quota_settings($mode, $id, $quota_type, $quota_limit_id = 0)
|
||
{
|
||
$id = (int)$id;
|
||
$quota_type = (int)$quota_type;
|
||
$quota_limit_id = (int)$quota_limit_id;
|
||
|
||
if ($mode == 'user') {
|
||
if (!$quota_limit_id) {
|
||
$sql = 'DELETE FROM ' . BB_QUOTA . " WHERE user_id = $id AND quota_type = $quota_type";
|
||
} else {
|
||
// Check if user is already entered
|
||
$sql = 'SELECT user_id FROM ' . BB_QUOTA . " WHERE user_id = $id AND quota_type = $quota_type";
|
||
if (!$result = DB()->sql_query($sql)) {
|
||
bb_die('Could not get entry #1');
|
||
}
|
||
|
||
if (DB()->num_rows($result) == 0) {
|
||
$sql_ary = [
|
||
'user_id' => (int)$id,
|
||
'group_id' => 0,
|
||
'quota_type' => (int)$quota_type,
|
||
'quota_limit_id' => (int)$quota_limit_id
|
||
];
|
||
$sql = 'INSERT INTO ' . BB_QUOTA . ' ' . DB()->build_array('INSERT', $sql_ary);
|
||
} else {
|
||
$sql = 'UPDATE ' . BB_QUOTA . "
|
||
SET quota_limit_id = $quota_limit_id
|
||
WHERE user_id = $id
|
||
AND quota_type = $quota_type";
|
||
}
|
||
DB()->sql_freeresult($result);
|
||
}
|
||
|
||
if (!($result = DB()->sql_query($sql))) {
|
||
bb_die('Unable to update quota settings');
|
||
}
|
||
} elseif ($mode == 'group') {
|
||
if (!$quota_limit_id) {
|
||
$sql = 'DELETE FROM ' . BB_QUOTA . " WHERE group_id = $id AND quota_type = $quota_type";
|
||
if (!$result = DB()->sql_query($sql)) {
|
||
bb_die('Unable to delete quota settings');
|
||
}
|
||
} else {
|
||
// Check if user is already entered
|
||
$sql = 'SELECT group_id FROM ' . BB_QUOTA . " WHERE group_id = $id AND quota_type = $quota_type";
|
||
if (!$result = DB()->sql_query($sql)) {
|
||
bb_die('Could not get entry #2');
|
||
}
|
||
|
||
if (DB()->num_rows($result) == 0) {
|
||
$sql = 'INSERT INTO ' . BB_QUOTA . " (user_id, group_id, quota_type, quota_limit_id)
|
||
VALUES (0, $id, $quota_type, $quota_limit_id)";
|
||
} else {
|
||
$sql = 'UPDATE ' . BB_QUOTA . " SET quota_limit_id = $quota_limit_id
|
||
WHERE group_id = $id AND quota_type = $quota_type";
|
||
}
|
||
|
||
if (!DB()->sql_query($sql)) {
|
||
bb_die('Unable to update quota settings');
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
/**
|
||
* Sort multi-dimensional array
|
||
*
|
||
* @param array $sort_array
|
||
* @param string|int $key
|
||
* @param int $sort_order
|
||
* @return array
|
||
*/
|
||
function sort_multi_array(array $sort_array, $key, int $sort_order = SORT_ASC): array
|
||
{
|
||
$keys = array_column($sort_array, $key);
|
||
array_multisort($keys, $sort_order, $sort_array);
|
||
|
||
return $sort_array;
|
||
}
|
||
|
||
/**
|
||
* Returns size of the upload directory in human readable format
|
||
*
|
||
* @return string
|
||
*/
|
||
function get_formatted_dirsize()
|
||
{
|
||
global $lang, $upload_dir;
|
||
|
||
$upload_dir_size = 0;
|
||
|
||
if ($dirname = opendir($upload_dir)) {
|
||
while ($file = readdir($dirname)) {
|
||
if (
|
||
$file != 'index.php' &&
|
||
$file != '.htaccess' &&
|
||
!is_dir($upload_dir . '/' . $file) &&
|
||
!is_link($upload_dir . '/' . $file)
|
||
) {
|
||
$upload_dir_size += filesize($upload_dir . '/' . $file);
|
||
}
|
||
}
|
||
closedir($dirname);
|
||
} else {
|
||
return $lang['NOT_AVAILABLE'];
|
||
}
|
||
|
||
return humn_size($upload_dir_size);
|
||
}
|
||
|
||
/**
|
||
* Build SQL statement for the search feature
|
||
*
|
||
* @param $order_by
|
||
* @param $total_rows
|
||
* @return array
|
||
*/
|
||
function search_attachments($order_by, &$total_rows)
|
||
{
|
||
global $lang;
|
||
|
||
$where_sql = [];
|
||
|
||
// Author name search
|
||
$search_author = get_var('search_author', '');
|
||
if ($search_author) {
|
||
// Bring in line with 2.0.x expected username
|
||
$search_author = addslashes(html_entity_decode($search_author));
|
||
$search_author = stripslashes(clean_username($search_author));
|
||
|
||
// Prepare for directly going into sql query
|
||
$search_author = str_replace('*', '%', DB()->escape($search_author));
|
||
|
||
// We need the post_id's, because we want to query the Attachment Table
|
||
$sql = 'SELECT user_id FROM ' . BB_USERS . " WHERE username LIKE '$search_author'";
|
||
if (!($result = DB()->sql_query($sql))) {
|
||
bb_die('Could not obtain list of matching users (searching for: ' . $search_author . ')');
|
||
}
|
||
|
||
$matching_userids = '';
|
||
if ($row = DB()->sql_fetchrow($result)) {
|
||
do {
|
||
$matching_userids .= (($matching_userids != '') ? ', ' : '') . $row['user_id'];
|
||
} while ($row = DB()->sql_fetchrow($result));
|
||
|
||
DB()->sql_freeresult($result);
|
||
} else {
|
||
bb_die($lang['NO_ATTACH_SEARCH_MATCH']);
|
||
}
|
||
|
||
$where_sql[] = ' (t.user_id_1 IN (' . $matching_userids . ')) ';
|
||
}
|
||
|
||
// Search Keyword
|
||
$search_keyword_fname = get_var('search_keyword_fname', '');
|
||
if ($search_keyword_fname) {
|
||
$match_word = str_replace('*', '%', $search_keyword_fname);
|
||
$where_sql[] = " (a.real_filename LIKE '" . DB()->escape($match_word) . "') ";
|
||
}
|
||
|
||
$search_keyword_comment = get_var('search_keyword_comment', '');
|
||
if ($search_keyword_comment) {
|
||
$match_word = str_replace('*', '%', $search_keyword_comment);
|
||
$where_sql[] = " (a.comment LIKE '" . DB()->escape($match_word) . "') ";
|
||
}
|
||
|
||
// Search Download Count
|
||
$search_count_smaller = get_var('search_count_smaller', '');
|
||
$search_count_greater = get_var('search_count_greater', '');
|
||
if ($search_count_smaller != '') {
|
||
$where_sql[] = ' (a.download_count < ' . (int)$search_count_smaller . ') ';
|
||
} elseif ($search_count_greater != '') {
|
||
$where_sql[] = ' (a.download_count > ' . (int)$search_count_greater . ') ';
|
||
}
|
||
|
||
// Search Filesize
|
||
$search_size_smaller = get_var('search_size_smaller', '');
|
||
$search_size_greater = get_var('search_size_greater', '');
|
||
if ($search_size_smaller != '') {
|
||
$where_sql[] = ' (a.filesize < ' . (int)$search_size_smaller . ') ';
|
||
} elseif ($search_size_greater != '') {
|
||
$where_sql[] = ' (a.filesize > ' . (int)$search_size_greater . ') ';
|
||
}
|
||
|
||
// Search Attachment Time
|
||
$search_days_greater = get_var('search_days_greater', '');
|
||
if ($search_days_greater) {
|
||
$where_sql[] = ' (a.filetime < ' . (TIMENOW - ((int)$search_days_greater * 86400)) . ') ';
|
||
}
|
||
|
||
// Search Forum
|
||
$search_forum = get_var('search_forum', '');
|
||
if ($search_forum) {
|
||
$where_sql[] = ' (p.forum_id = ' . (int)$search_forum . ') ';
|
||
}
|
||
|
||
$sql = 'SELECT a.*, t.post_id, p.post_time, p.topic_id
|
||
FROM ' . BB_ATTACHMENTS . ' t, ' . BB_ATTACHMENTS_DESC . ' a, ' . BB_POSTS . ' p WHERE ';
|
||
|
||
if (count($where_sql) > 0) {
|
||
$sql .= implode('AND', $where_sql) . ' AND ';
|
||
}
|
||
|
||
$sql .= 't.post_id = p.post_id AND a.attach_id = t.attach_id ';
|
||
|
||
$total_rows_sql = $sql;
|
||
|
||
$sql .= $order_by;
|
||
|
||
if (!($result = DB()->sql_query($sql))) {
|
||
bb_die('Could not query attachments #1');
|
||
}
|
||
|
||
$attachments = DB()->sql_fetchrowset($result);
|
||
$num_attach = DB()->num_rows($result);
|
||
DB()->sql_freeresult($result);
|
||
|
||
if ($num_attach == 0) {
|
||
bb_die($lang['NO_ATTACH_SEARCH_MATCH']);
|
||
}
|
||
|
||
if (!($result = DB()->sql_query($total_rows_sql))) {
|
||
bb_die('Could not query attachments #2');
|
||
}
|
||
|
||
$total_rows = DB()->num_rows($result);
|
||
DB()->sql_freeresult($result);
|
||
|
||
return $attachments;
|
||
}
|