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; }