function newpoints_shop_admin_stats()
{
global $form, $db, $lang, $mybb;
newpoints_lang_load("newpoints_shop");
echo "<br />";
// table
$table = new Table();
$table->construct_header($lang->newpoints_shop_item, array('width' => '30%'));
$table->construct_header($lang->newpoints_shop_username, array('width' => '30%'));
$table->construct_header($lang->newpoints_shop_price, array('width' => '20%', 'class' => 'align_center'));
$table->construct_header($lang->newpoints_shop_date, array('width' => '20%', 'class' => 'align_center'));
$query = $db->simple_select('newpoints_log', '*', 'action=\'shop_purchase\'', array('order_by' => 'date', 'order_dir' => 'DESC', 'limit' => intval($mybb->settings['newpoints_shop_lastpurchases'])));
while ($stats = $db->fetch_array($query)) {
$data = explode('-', $stats['data']);
$item = newpoints_shop_get_item($data[0]);
$table->construct_cell(htmlspecialchars_uni($item['name']));
$link = build_profile_link(htmlspecialchars_uni($stats['username']), intval($stats['uid']));
$table->construct_cell($link);
$table->construct_cell(newpoints_format_points($data[1]), array('class' => 'align_center'));
$table->construct_cell(my_date($mybb->settings['dateformat'], intval($stats['date']), '', false) . ", " . my_date($mybb->settings['timeformat'], intval($stats['date'])), array('class' => 'align_center'));
$table->construct_row();
}
if ($table->num_rows() == 0) {
$table->construct_cell($lang->newpoints_error_gathering, array('colspan' => 4));
$table->construct_row();
}
$table->output($lang->newpoints_stats_lastpurchases);
}
function hook_newpoints_do_shop_start()
{
global $mybb, $db, $lang, $cache, $theme, $header, $templates, $plugins, $headerinclude, $footer, $options, $inline_errors;
if ($mybb->get_input('shop_action') == 'buy_sticky') {
$do = false;
} elseif ($mybb->get_input('shop_action') == 'do_buy_sticky') {
$do = true;
} else {
return false;
}
if ($do) {
$plugins->run_hooks('newpoints_shop_do_buy_sticky_start');
} else {
$plugins->run_hooks('newpoints_shop_buy_sticky_start');
}
if (!($item = newpoints_shop_get_item($mybb->get_input('iid', 1)))) {
error($lang->newpoints_shop_invalid_item);
}
if (!($cat = newpoints_shop_get_category($item['cid']))) {
error($lang->newpoints_shop_invalid_cat);
}
if (!newpoints_shop_check_permissions($cat['usergroups'])) {
error_no_permission();
}
if (!$item['visible'] || !$cat['visible']) {
error_no_permission();
}
if (!$item['buy_sticky'] || $item['buy_sticky_time'] < 1) {
error_no_permission();
}
$myitems = @unserialize($mybb->user['newpoints_items']);
if (!$myitems) {
error($lang->newpoints_shop_inventory_empty);
}
$key = array_search($item['iid'], $myitems);
if ($key === false) {
error($lang->newpoints_shop_selected_item_not_owned);
}
$this->load_language();
if ($do) {
// ~~~ @ https://github.com/PaulBender/Move-Posts/blob/master/inc/plugins/moveposts.php#L217 //
if ($db->table_exists('google_seo')) {
$regexp = "{$mybb->settings['bburl']}/{$mybb->settings['google_seo_url_threads']}";
if ($regexp) {
$regexp = preg_quote($regexp, '#');
$regexp = str_replace('\\{\\$url\\}', '([^./]+)', $regexp);
$regexp = str_replace('\\{url\\}', '([^./]+)', $regexp);
$regexp = "#^{$regexp}\$#u";
}
$url = $mybb->get_input('threadurl');
$url = preg_replace('/^([^#?]*)[#?].*$/u', '\\1', $url);
$url = preg_replace($regexp, '\\1', $url);
$url = urldecode($url);
$query = $db->simple_select('google_seo', 'id', "idtype='4' AND url='{$db->escape_string($url)}'");
$redeemtid = $db->fetch_field($query, 'id');
}
$realurl = explode('#', $mybb->get_input('threadurl'));
$mybb->input['threadurl'] = $realurl[0];
if (substr($mybb->get_input('threadurl'), -4) == 'html') {
preg_match('#thread-([0-9]+)?#i', $mybb->get_input('threadurl'), $threadmatch);
preg_match('#post-([0-9]+)?#i', $mybb->get_input('threadurl'), $postmatch);
if ($threadmatch[1]) {
$parameters['tid'] = $threadmatch[1];
}
if ($postmatch[1]) {
$parameters['pid'] = $postmatch[1];
}
} else {
$splitloc = explode('.php', $mybb->get_input('threadurl'));
$temp = explode('&', my_substr($splitloc[1], 1));
if (!empty($temp)) {
for ($i = 0; $i < count($temp); $i++) {
$temp2 = explode('=', $temp[$i], 2);
$parameters[$temp2[0]] = $temp2[1];
}
} else {
$temp2 = explode('=', $splitloc[1], 2);
$parameters[$temp2[0]] = $temp2[1];
}
}
if ($parameters['pid'] && !$parameters['tid']) {
$query = $db->simple_select('posts', '*', "pid='" . (int) $parameters['pid'] . "'");
$post = $db->fetch_array($query);
$redeemtid = $post['tid'];
} elseif ($parameters['tid']) {
$redeemtid = $parameters['tid'];
}
$thread = get_thread($redeemtid);
// ~~~ //
if (!$thread['tid'] || !$thread['visible'] || $thread['deletetime']) {
error($lang->newpoints_buy_sticky_redeem_error_invalid);
}
if ($thread['sticky']) {
error($lang->newpoints_buy_sticky_redeem_error_alreadystickied);
}
if ($thread['closed']) {
error($lang->newpoints_buy_sticky_redeem_error_closedthread);
}
if ($thread['uid'] != $mybb->user['uid']) {
error($lang->newpoints_buy_sticky_redeem_error_wronguser);
}
// We need more extensive permission checkings here late on..
require_once MYBB_ROOT . 'inc/class_moderation.php';
$moderation = new Moderation();
$lang->load('moderation');
$moderation->stick_threads($thread['tid']);
log_moderator_action(array('fid' => $thread['fid'], 'tid' => $thread['tid']), $lang->sprintf($lang->mod_process, $lang->stuck));
newpoints_log('buy_sticky', $mybb->settings['bburl'] . '/' . get_thread_link($thread['tid']), $mybb->user['username'], $mybb->user['uid']);
$rundate = TIME_NOW + $item['buy_sticky_time'] * 86400;
$did = $db->insert_query("delayedmoderation", array('type' => $db->escape_string('stick'), 'delaydateline' => (int) $rundate, 'uid' => (int) $mybb->user['uid'], 'tids' => (int) $thread['tid'], 'fid' => (int) $thread['fid'], 'dateline' => TIME_NOW, 'inputs' => $db->escape_string(my_serialize(array('new_forum' => (int) $thread['fid'], 'method' => 'move', 'redirect_expire' => '')))));
$plugins->run_hooks('moderation_do_delayedmoderation');
// remove item from our inventory
unset($myitems[$key]);
sort($myitems);
$db->update_query('users', array('newpoints_items' => serialize($myitems)), "uid='" . (int) $mybb->user['uid'] . "'");
$plugins->run_hooks('newpoints_shop_do_buy_sticky_end');
$message = $lang->sprintf($lang->newpoints_buy_sticky_redeem_done, my_date('relative', $rundate, '', 2));
redirect($mybb->settings['bburl'] . '/newpoints.php?action=shop&shop_action=myitems', $message, $lang->newpoints_buy_sticky_redeem_done_title);
} else {
$lang->newpoints_shop_action = $lang->newpoints_buy_sticky_redeem_title;
$item['name'] = htmlspecialchars_uni($item['name']);
global $shop_action, $data, $colspan;
$colspan = 2;
$shop_action = 'do_buy_sticky';
$fields = '<input type="hidden" name="iid" value="' . $item['iid'] . '">';
$data = "<td class=\"trow1\" width=\"50%\"><strong>" . $lang->newpoints_buy_sticky_redeem_thread . ":</strong><br /><small>" . $lang->newpoints_buy_sticky_redeem_message . "</small></td><td class=\"trow1\" width=\"50%\"><input type=\"text\" class=\"textbox\" name=\"threadurl\" value=\"\"></td>";
$plugins->run_hooks('newpoints_shop_buy_sticky_end');
$page = eval($templates->render('newpoints_shop_do_action'));
output_page($page);
}
exit;
}