require 'includes/master.inc.php';
$Auth->requireAdmin('login.php');
$nav = 'applications';
$app = new Application($_GET['id']);
if (!$app->ok()) {
redirect('index.php');
}
if (isset($_POST['btnSerial'])) {
if (strlen($_POST['serial']) > 0) {
$s = new Serial();
$s->app_id = $app->id;
$s->dt = dater();
$s->guid = $_POST['guid'];
$s->serial = $_POST['serial'];
$s->insert();
redirect('pirates.php?id=' . $app->id);
}
}
$db = Database::getDatabase();
$pirates = $db->getRows("SELECT * FROM pirates WHERE app_id = '{$app->id}' ORDER BY dt DESC");
$serial_count = $db->getValue("SELECT COUNT(*) from pirated_serials WHERE app_id = '{$app->id}'");
$serial_date = $db->getValue("SELECT dt FROM pirated_serials WHERE app_id = '{$app->id}' ORDER BY dt DESC LIMIT 1");
$serial_date = $serial_date ? time2str($serial_date) : 'never';
if (isset($_GET['feed']) && $_GET['feed'] == 'json') {
$serials = DBObject::glob('Serial', "SELECT * from pirated_serials WHERE app_id = '{$app->id}'");
$arr = array();
foreach ($serials as $s) {
$arr[] = array('dt' => $s->dt, 'guid' => $s->guid, 'serial' => $s->serial);
}
die(json_encode($arr));
