function tracker_allowed() { global $connection, $settings; require_once __DIR__ . '/once.db.connect.php'; require_once __DIR__ . '/function.mysqli.array.build.php'; $torrents = mysqli_array_build('SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`'); if (!$torrents) { tracker_error('No torrents allowed at this time.'); } else { return $torrents; } }
function tracker_allowed($connection, $settings) { require_once $settings['functions'] . 'function.mysqli.array.build.php'; $sql = 'SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`;'; $allowed_torrents = mysqli_array_build($connection, $sql); if (!$allowed_torrents) { // tracker_error('No torrents allowed at this time.'); return array(); } else { return $allowed_torrents; } }
<?php require_once $settings['functions'] . 'function.mysqli.array.build.php'; $select = 'SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`;'; $result = mysqli_array_build($connection, $select); if (!empty($result)) { echo 'Error: Empty query was not empty.' . PHP_EOL; $failure = true; } $insert = 'INSERT INTO `' . $settings['db_prefix'] . 'torrents` ( `info_hash` ) VALUES (\'__TEST_1__\'), (\'__TEST_2__\'), (\'__TEST_3__\');'; mysqli_query($connection, $insert); $result = mysqli_array_build($connection, $select); $count = count($result); if ($count != 3) { echo 'Error: Query for 3 items returned ' . $count . PHP_EOL; $failure = true; } $delete = 'DELETE FROM `' . $settings['db_prefix'] . 'torrents` WHERE `info_hash` LIKE \'__TEST_%\';'; mysqli_query($connection, $delete);