/**
* Shows all polls in system
*
* List all the polls on the system if no $pid is provided
*
* @return string HTML for poll listing
*
*/
function polllist()
{
global $_CONF, $_TABLES, $_USER, $_PO_CONF, $LANG25, $LANG_LOGIN, $LANG_POLLS;
$retval = '';
if (empty($_USER['username']) && ($_CONF['loginrequired'] == 1 || $_PO_CONF['pollsloginrequired'] == 1)) {
$retval = COM_startBlock($LANG_LOGIN[1], '', COM_getBlockTemplate('_msg_block', 'header'));
$login = new Template($_CONF['path_layout'] . 'submit');
$login->set_file(array('login' => 'submitloginrequired.thtml'));
$login->set_var('xhtml', XHTML);
$login->set_var('login_message', $LANG_LOGIN[2]);
$login->set_var('site_url', $_CONF['site_url']);
$login->set_var('lang_login', $LANG_LOGIN[3]);
$login->set_var('lang_newuser', $LANG_LOGIN[4]);
$login->parse('output', 'login');
$retval .= $login->finish($login->get_var('output'));
$retval .= COM_endBlock(COM_getBlockTemplate('_msg_block', 'footer'));
} else {
require_once $_CONF['path_system'] . 'lib-admin.php';
$header_arr = array(array('text' => $LANG25[9], 'field' => 'topic', 'sort' => true), array('text' => $LANG25[20], 'field' => 'voters', 'sort' => true), array('text' => $LANG25[3], 'field' => 'unixdate', 'sort' => true), array('text' => $LANG_POLLS['open_poll'], 'field' => 'is_open', 'sort' => true));
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$text_arr = array('has_menu' => false, 'title' => $LANG_POLLS['pollstitle'], 'instructions' => "", 'icon' => '', 'form_url' => '');
$query_arr = array('table' => 'polltopics', 'sql' => $sql = "SELECT *,UNIX_TIMESTAMP(date) AS unixdate, display " . "FROM {$_TABLES['polltopics']} WHERE 1=1", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSQL(), 'query' => '', 'query_limit' => 0);
$retval .= ADMIN_list('polls', 'plugin_getListField_polls', $header_arr, $text_arr, $query_arr, $defsort_arr);
}
return $retval;
}
function LIB_List($pi_name)
{
global $_CONF;
global $_TABLES;
global $LANG_ADMIN;
global $LANG09;
$lang_box_admin = "LANG_" . strtoupper($pi_name) . "_ADMIN";
global ${$lang_box_admin};
$lang_box_admin = ${$lang_box_admin};
$lang_box = "LANG_" . strtoupper($pi_name);
global ${$lang_box};
$lang_box = ${$lang_box};
$table = $_TABLES[strtoupper($pi_name) . '_def_group'];
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
//MENU1:管理画面
$url1 = $_CONF['site_admin_url'] . '/plugins/' . THIS_SCRIPT . '?mode=new';
$url2 = $_CONF['site_url'] . '/' . $pi_name . '/list.php';
$url5 = $_CONF['site_admin_url'] . '/plugins/' . THIS_SCRIPT . '?mode=export';
$url6 = $_CONF['site_admin_url'] . '/plugins/' . THIS_SCRIPT . '?mode=import';
$menu_arr[] = array('url' => $url1, 'text' => $lang_box_admin['new']);
$menu_arr[] = array('url' => $url2, 'text' => $lang_box['list']);
$menu_arr[] = array('url' => $url5, 'text' => $lang_box_admin['export']);
//$menu_arr[]=array('url' => $url6,'text' => $lang_box['export']);
$menu_arr[] = array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']);
$retval .= COM_startBlock($lang_box_admin['admin_list'], '', COM_getBlockTemplate('_admin_block', 'header'));
$function = "plugin_geticon_" . $pi_name;
$icon = $function();
$retval .= ADMIN_createMenu($menu_arr, $lang_box_admin['instructions'], $icon);
//ヘッダ：編集～
$header_arr[] = array('text' => $lang_box_admin['orderno'], 'field' => 'orderno', 'sort' => true);
$header_arr[] = array('text' => $LANG_ADMIN['edit'], 'field' => 'editid', 'sort' => false);
$header_arr[] = array('text' => $LANG_ADMIN['copy'], 'field' => 'copy', 'sort' => false);
$header_arr[] = array('text' => $lang_box_admin['group_id'], 'field' => 'group_id', 'sort' => true);
$header_arr[] = array('text' => $lang_box_admin['code'], 'field' => 'code', 'sort' => true);
$header_arr[] = array('text' => $lang_box_admin['name'], 'field' => 'name', 'sort' => true);
//
$text_arr = array('has_menu' => true, 'has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . "/plugins/" . THIS_SCRIPT);
//Query
$sql = "SELECT ";
$sql .= " group_id";
$sql .= " ,code";
$sql .= " ,name";
$sql .= " ,orderno";
$sql .= " FROM ";
$sql .= " {$table} AS t";
$sql .= " WHERE ";
$sql .= " group_id<>0";
//
$query_arr = array('table' => $table, 'sql' => $sql, 'query_fields' => array('group_id', 'code', 'name', 'orderno'), 'default_filter' => $exclude);
//デフォルトソート項目:
$defsort_arr = array('field' => 'orderno', 'direction' => 'ASC');
//List 取得
//ADMIN_list($component, $fieldfunction, $header_arr, $text_arr,
// $query_arr, $menu_arr, $defsort_arr, $filter = '', $extra = '', $options = '')
$retval .= ADMIN_list($pi_name, "LIB_GetListField", $header_arr, $text_arr, $query_arr, $defsort_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
function MAPS_displayOverlaysToAdd($mid)
{
global $_CONF, $_TABLES, $LANG_MAPS_1, $LANG_ADMIN;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_MAPS_1['overlay_label'], 'field' => 'o_name', 'sort' => false));
$sql = "SELECT\n\t m.mid, o.*, mo.*\n FROM {$_TABLES['maps_maps']} AS m, {$_TABLES['maps_overlays']} AS o\n\t\t\tLEFT JOIN {$_TABLES['maps_map_overlay']} AS mo\n\t\t\tON (o.oid = mo.mo_oid\n\t\t\tAND mo.mo_mid = {$mid})\n\t\t\tWHERE( m.mid = {$mid} AND mo.mo_id IS NULL)\n\t\t\t";
$query_arr = array('sql' => $sql);
$retval .= ADMIN_list('maps_overlaysToAdd', 'MAPS_getListField_maps_displayOverlaysToAdd', $header_arr, $text_arr, $query_arr, $defsort_arr);
return '<h2 style="margin-top:10px;">' . $LANG_MAPS_1['overlays_to_add'] . '</h2>' . $retval;
}
/**
* List all icons that the admin has access to
*
* @retun string HTML for the list
*
*/
function MAPS_listIcons()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG_MAPS_1;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
$header_arr = array(array('text' => $LANG_MAPS_1['id'], 'field' => 'icon_id', 'sort' => true), array('text' => $LANG_MAPS_1['icons'], 'field' => 'icon_name', 'sort' => true), array('text' => $LANG_MAPS_1['image'], 'field' => 'icon_image', 'sort' => false));
$defsort_arr = array('field' => 'icon_name', 'direction' => 'asc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/maps/icons.php');
$sql = "SELECT\n\t *\n FROM {$_TABLES['maps_map_icons']}\n\t\t\tWHERE 1=1";
$query_arr = array('sql' => $sql, 'query_fields' => array('icon_name'), 'default_filter' => '');
$retval .= ADMIN_list('icons', 'MAPS_getListField_icons', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
function _listUsers()
{
global $LANG28, $_CONF, $_TABLES, $LANG_ADMIN, $LANG_GF98;
USES_lib_admin();
$retval = '';
$header_arr = array(array('text' => $LANG_GF98['uid'], 'field' => 'uid', 'sort' => true), array('text' => $LANG28[3], 'field' => 'username', 'sort' => true), array('text' => $LANG28[4], 'field' => 'fullname', 'sort' => true), array('text' => $LANG28[7], 'field' => 'email', 'sort' => true), array('text' => $LANG_GF98['rating'], 'field' => 'rating', 'sort' => true));
$defsort_arr = array('field' => $_TABLES['users'] . '.uid', 'direction' => 'ASC');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/forum/userrating.php', 'help_url' => '');
$sql = "SELECT {$_TABLES['users']}.uid, username,fullname,email,status,rating FROM {$_TABLES['users']} LEFT JOIN {$_TABLES['ff_userinfo']} on {$_TABLES['users']}.uid={$_TABLES['ff_userinfo']}.uid";
$query_arr = array('table' => 'users', 'sql' => $sql, 'query_fields' => array($_TABLES['users'] . '.username', $_TABLES['users'] . '.email', $_TABLES['users'] . '.fullname'), 'default_filter' => " WHERE {$_TABLES['users']}.uid > 1");
$form_arr = array('bottom' => '<div style="text-align:center;padding:5px;"><input type="submit" value="submit" name="submit" /></div>');
$retval .= ADMIN_list('user', 'ADMIN_getListField_ratings', $header_arr, $text_arr, $query_arr, $defsort_arr, '', '', '', $form_arr);
return $retval;
}
/**
* Shows all polls in system
*
* List all the polls on the system if no $pid is provided
*
* @return string HTML for poll listing
*
*/
function polllist()
{
global $_CONF, $_TABLES, $_PO_CONF, $LANG25, $LANG_POLLS;
$retval = '';
if (COM_isAnonUser() && ($_CONF['loginrequired'] == 1 || $_PO_CONF['pollsloginrequired'] == 1)) {
$retval .= SEC_loginRequiredForm();
} else {
require_once $_CONF['path_system'] . 'lib-admin.php';
$header_arr = array(array('text' => $LANG25[9], 'field' => 'topic', 'sort' => true), array('text' => $LANG25[20], 'field' => 'voters', 'sort' => true), array('text' => $LANG25[3], 'field' => 'unixdate', 'sort' => true), array('text' => $LANG_POLLS['open_poll'], 'field' => 'is_open', 'sort' => true));
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$text_arr = array('has_menu' => false, 'title' => $LANG_POLLS['pollstitle'], 'instructions' => "", 'icon' => '', 'form_url' => '', 'form_url' => $_CONF['site_url'] . '/polls/index.php');
$query_arr = array('table' => 'polltopics', 'sql' => $sql = "SELECT *,UNIX_TIMESTAMP(created) AS unixdate, display " . "FROM {$_TABLES['polltopics']} WHERE 1=1", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSQL(), 'query' => '', 'query_limit' => 0);
$retval .= ADMIN_list('polls', 'plugin_getListField_polls', $header_arr, $text_arr, $query_arr, $defsort_arr);
}
return $retval;
}
/**
* Shows the form the admin uses to send Geeklog members a message. Right now
* you can only email an entire group.
*
* @return string HTML for the email form
*
*/
function list_hello()
{
global $_CONF, $_TABLES, $LANG_HELLO01;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
//Build header list
$header_arr = array(array('text' => $LANG_HELLO01['see_email'], 'field' => 'see_hello', 'sort' => false), array('text' => $LANG_HELLO01['id'], 'field' => 'hello_id', 'sort' => true), array('text' => $LANG_HELLO01['subjet'], 'field' => 'subject', 'sort' => true), array('text' => $LANG_HELLO01['creation'], 'field' => 'creation', 'sort' => true), array('text' => $LANG_HELLO01['group'], 'field' => 'email_group', 'sort' => true), array('text' => $LANG_HELLO01['quantity'], 'field' => 'quantity', 'sort' => true));
$defsort_arr = array('field' => $_TABLES['hello'] . '.hello_id', 'direction' => 'DESC');
$retval .= COM_startBlock($LANG28[11], '', COM_getBlockTemplate('_admin_block', 'header'));
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/hello/read_email.php', 'help_url' => '');
$sql = "SELECT {$_TABLES['hello']}.hello_id,subject,creation,email_group,quantity " . "FROM {$_TABLES['hello']} WHERE 1=1";
$query_arr = array('table' => 'hello', 'sql' => $sql, 'query_fields' => array('hello_id', 'subject', 'creation', 'email_group', 'quantity'), 'default_filter' => "");
$retval .= ADMIN_list('hello', 'HELLO_getListField_hello', $header_arr, $text_arr, $query_arr, $defsort_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
function PAYPAL_listRecurringPayments()
{
global $_CONF, $_TABLES, $LANG_PAYPAL_ADMIN, $LANG_ADMIN, $LANG_PAYPAL_1, $LANG_PAYPAL_PRO;
if (!file_exists($_CONF['path_data'] . '/paypal_data/proversion/proversion.php')) {
return $LANG_PAYPAL_PRO['pro_feature'];
}
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
$header_arr = array(array('text' => $LANG_PAYPAL_1['user_name'], 'field' => 'user_id', 'sort' => true), array('text' => $LANG_PAYPAL_1['profile_id'], 'field' => 'profileid', 'sort' => true), array('text' => $LANG_PAYPAL_1['recdate'], 'field' => 'recdate', 'sort' => true), array('text' => $LANG_PAYPAL_1['status'], 'field' => 'status', 'sort' => true));
$defsort_arr = array('field' => 'recdate', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/paypal/recurring_payments.php');
$sql = "SELECT\n\t r.*, u.username\n FROM \n\t\t\t {$_TABLES['paypal_recurrent']} as r\n\t\t\tLEFT JOIN\n\t\t\t\t{$_TABLES['users']} AS u \n\t\t\tON\n\t\t\t\tr.user_id = u.uid\n\t\t\tWHERE 1=1 \t\n\t\t\t";
$query_arr = array('sql' => $sql, 'query_fields' => array('r.user_id', 'r.profileid', 'r.recdate', 'r.status'));
$retval .= ADMIN_list('paypal_recurring', 'PAYPAL_getListField_paypal_recurring', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
/**
* Shows all polls in system
*
* List all the polls on the system if no $pid is provided
*
* @return string HTML for poll listing
*
*/
function POLLS_pollList()
{
global $_CONF, $_TABLES, $_USER, $_PO_CONF, $LANG25, $LANG_LOGIN, $LANG_POLLS;
$retval = '';
if (COM_isAnonUser() && ($_CONF['loginrequired'] == 1 || $_PO_CONF['pollsloginrequired'] == 1)) {
$retval .= SEC_loginRequiredForm();
} else {
USES_lib_admin();
$header_arr = array(array('text' => $LANG25[9], 'field' => 'topic', 'sort' => true), array('text' => $LANG25[20], 'field' => 'voters', 'sort' => true, 'align' => 'center'), array('text' => $LANG25[3], 'field' => 'unixdate', 'sort' => true, 'align' => 'center'), array('text' => $LANG_POLLS['open_poll'], 'field' => 'is_open', 'sort' => true, 'align' => 'center'));
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$text_arr = array('has_menu' => false, 'title' => $LANG_POLLS['pollstitle'], 'instructions' => "", 'icon' => '', 'form_url' => '');
$query_arr = array('table' => 'polltopics', 'sql' => $sql = "SELECT *,UNIX_TIMESTAMP(date) AS unixdate, display " . "FROM {$_TABLES['polltopics']} WHERE 1=1", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSQL(), 'query' => '', 'query_limit' => 0);
$retval .= ADMIN_list('polls', 'POLLS_getListField', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token = 'dummy');
}
return $retval;
}
function PAYPAL_listDownloads()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG_PAYPAL_1;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (DB_count($_TABLES['paypal_downloads']) == 0) {
$retval .= '<p>' . $LANG_PAYPAL_1['downloads_history_empty'] . '</p>';
}
$header_arr = array(array('text' => $LANG_PAYPAL_1['ID'], 'field' => 'id', 'sort' => true), array('text' => $LANG_PAYPAL_1['product_id'], 'field' => 'product_id', 'sort' => true), array('text' => $LANG_PAYPAL_1['filename_label'], 'field' => 'file', 'sort' => true), array('text' => $LANG_PAYPAL_1['date_time'], 'field' => 'dl_date', 'sort' => true), array('text' => $LANG_PAYPAL_1['user_id'], 'field' => 'user_id', 'sort' => true));
$defsort_arr = array('field' => 'id', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/paypal/downloads_history.php');
$sql = "SELECT\n\t *\n FROM {$_TABLES['paypal_downloads']}\n\t\t\tWHERE 1=1";
$query_arr = array('table' => 'paypal_downloads', 'sql' => $sql, 'query_fields' => array('id', 'product_id', 'file', 'dl_date', 'user_id'), 'default_filter' => COM_getPermSQL('AND', 0, 3));
$retval .= ADMIN_list('paypal', 'plugin_getListField_paypal_downloads', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
/**
* List all maps that the user has access to
*
* @retun string HTML for the list
*
*/
function MAPS_listmaps()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG_MAPS_1;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (DB_count($_TABLES['maps_maps']) == 0) {
return $retval = '';
}
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_MAPS_1['id'], 'field' => 'mid', 'sort' => true), array('text' => $LANG_MAPS_1['name'], 'field' => 'name', 'sort' => true), array('text' => $LANG_MAPS_1['active_field'], 'field' => 'active', 'sort' => true), array('text' => $LANG_MAPS_1['hidden_field'], 'field' => 'hidden', 'sort' => true));
$defsort_arr = array('field' => 'mid', 'direction' => 'asc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/maps/index.php');
$sql = "SELECT\n\t *\n FROM {$_TABLES['maps_maps']}\n\t\t\tWHERE 1=1";
$query_arr = array('table' => 'maps_maps', 'sql' => $sql, 'query_fields' => array('name', 'description'), 'default_filter' => COM_getPermSQL('AND', 0, 3));
$retval .= ADMIN_list('maps', 'plugin_getListField_maps', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
/**
* List all markers that the user has access to
*
* @retun string HTML for the list
*
*/
function MAPS_listMarkersAdmin()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG_MAPS_1;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (DB_count($_TABLES['maps_markers']) == 0) {
return $retval = '';
}
$header_arr = array(array('text' => $LANG_MAPS_1['id'], 'field' => 'mkid', 'sort' => true), array('text' => $LANG_MAPS_1['name'], 'field' => 'name', 'sort' => true), array('text' => $LANG_MAPS_1['map_label'], 'field' => 'mapname', 'sort' => true), array('text' => $LANG_MAPS_1['active_field'], 'field' => 'active', 'sort' => true), array('text' => $LANG_MAPS_1['hidden_field'], 'field' => 'hidden', 'sort' => true), array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false));
$defsort_arr = array('field' => 'modified', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/maps/markers.php');
$sql = "SELECT\n\t a.*, b.name as mapname\n FROM {$_TABLES['maps_markers']} AS a\n\t\t\tLEFT JOIN\n\t\t\t {$_TABLES['maps_maps']} AS b\n\t\t\tON a.mid = b.mid\n\t\t\tWHERE 1=1";
$query_arr = array('sql' => $sql, 'default_filter' => COM_getPermSQL('AND', 0, 3));
$retval .= ADMIN_list('markers', 'plugin_getListField_markers', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
/**
* Displays the list of ipn history from the log stored in the database
*
*/
function PAYPAL_listIPNlog()
{
global $_CONF, $_TABLES, $LANG_PAYPAL_1, $_USER;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (DB_count($_TABLES['paypal_ipnlog']) == 0) {
$retval .= '<p>' . $LANG_PAYPAL_1['ipnlog_empty'] . '</p>';
}
$header_arr = array(array('text' => $LANG_PAYPAL_1['ID'], 'field' => 'id', 'sort' => true), array('text' => $LANG_PAYPAL_1['IP_address'], 'field' => 'ip_addr', 'sort' => true), array('text' => $LANG_PAYPAL_1['date_time'], 'field' => 'time', 'sort' => true), array('text' => $LANG_PAYPAL_1['verified'], 'field' => 'verified', 'sort' => true), array('text' => $LANG_PAYPAL_1['txn_id'], 'field' => 'txn_id', 'sort' => true), array('text' => $LANG_PAYPAL_1['payment_status'], 'field' => 'payment_status', 'sort' => true), array('text' => $LANG_PAYPAL_1['purchaser'], 'field' => 'custom', 'sort' => true));
$defsort_arr = array('field' => 'id', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/paypal/ipnlog.php');
$sql = "SELECT * FROM {$_TABLES['paypal_ipnlog']} WHERE 1=1";
$query_arr = array('table' => 'paypal_ipnlog', 'sql' => $sql, 'query_fields' => array('id', 'ip_addr', 'time', 'verified', 'txn_id', 'ipn_data'), 'default_filter' => COM_getPermSQL('AND', 0, 3));
$retval .= ADMIN_list('paypal', 'plugin_getListField_paypal_IPNlog', $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
/**
* Build the admin list of pages
* @return string HTML content
*/
function EXP_adminList()
{
global $_CONF, $_TABLES, $LANG_ADMIN, $LANG_ACCESS, $_CONF_EXP, $LANG_EX00;
USES_lib_admin();
$retval = '';
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => 'Page ID', 'field' => 'exid', 'sort' => true), array('text' => 'Title', 'field' => 'title', 'sort' => true), array('text' => 'URL', 'field' => 'url', 'sort' => true), array('text' => 'Hits', 'field' => 'hits', 'sort' => true));
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/plugins/' . $_CONF_EXP['pi_name'] . '/edit.php?exid=0', 'text' => 'Add New'), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$defsort_arr = array('field' => 'exid', 'direction' => 'asc');
$header_str = $LANG_EX00['header'] . ' ' . $LANG_EX00['version'] . ' ' . $_CONF_EXP['pi_version'];
$retval .= COM_startBlock($header_str, '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, 'Administer External Pages', plugin_geticon_external());
$text_arr = array('has_extras' => true, 'form_url' => "{$_CONF['site_admin_url']}/plugins/{$_CONF_EXP['pi_name']}/index.php");
$query_arr = array('table' => 'external', 'sql' => "SELECT * FROM {$_TABLES['external']} ", 'query_fields' => array('title', 'url'), 'default_filter' => COM_getPermSql());
$retval .= ADMIN_list('external', 'EXP_getAdminListField', $header_arr, $text_arr, $query_arr, $defsort_arr, '', '', '', $form_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
function LIB_List($pi_name)
{
global $_CONF;
global $_TABLES;
global $LANG_ADMIN;
global $LANG09;
$lang_box_admin = "LANG_" . strtoupper($pi_name) . "_ADMIN";
global ${$lang_box_admin};
$lang_box_admin = ${$lang_box_admin};
$lang_box = "LANG_" . strtoupper($pi_name);
global ${$lang_box};
$lang_box = ${$lang_box};
$table = $_TABLES[strtoupper($pi_name) . '_def_field'];
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
//ヘッダ：編集～
$header_arr[] = array('text' => $lang_box_admin['orderno'], 'field' => 'orderno', 'sort' => true);
$header_arr[] = array('text' => $LANG_ADMIN['edit'], 'field' => 'editid', 'sort' => false);
$header_arr[] = array('text' => $LANG_ADMIN['copy'], 'field' => 'copy', 'sort' => false);
$header_arr[] = array('text' => $lang_box_admin['field_id'], 'field' => 'field_id', 'sort' => true);
$header_arr[] = array('text' => $lang_box_admin['name'], 'field' => 'name', 'sort' => true);
$header_arr[] = array('text' => $lang_box_admin['templatesetvar'], 'field' => 'templatesetvar', 'sort' => true);
//
$text_arr = array('has_menu' => true, 'has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . "/plugins/" . THIS_SCRIPT);
//Query
$sql = "SELECT ";
$sql .= " field_id";
$sql .= " ,name";
$sql .= " ,templatesetvar";
$sql .= " ,orderno";
$sql .= " ,type";
$sql .= " ,allow_display";
$sql .= " FROM ";
$sql .= " {$table} AS t";
$sql .= " WHERE ";
$sql .= " 1=1";
//
$query_arr = array('table' => $table, 'sql' => $sql, 'query_fields' => array('field_id', 'name', 'orderno', 'templatesetvar'), 'default_filter' => $exclude);
//デフォルトソート項目:
$defsort_arr = array('field' => 'orderno', 'direction' => 'ASC');
//List 取得
//ADMIN_list($component, $fieldfunction, $header_arr, $text_arr,
// $query_arr, $menu_arr, $defsort_arr, $filter = '', $extra = '', $options = '')
$retval .= ADMIN_list($pi_name, "LIB_GetListField", $header_arr, $text_arr, $query_arr, $defsort_arr);
return $retval;
}
function listpolls()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG25, $LANG_ACCESS;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
// writing the menu on top
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/plugins/polls/index.php?mode=edit', 'text' => $LANG_ADMIN['create_new']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= COM_startBlock($LANG25[18], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG25[19], plugin_geticon_polls());
// writing the actual list
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG25[9], 'field' => 'topic', 'sort' => true), array('text' => $LANG25[20], 'field' => 'voters', 'sort' => true), array('text' => $LANG_ACCESS['access'], 'field' => 'access', 'sort' => false), array('text' => $LANG25[3], 'field' => 'unixdate', 'sort' => true), array('text' => $LANG25[33], 'field' => 'is_open', 'sort' => true));
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'instructions' => $LANG25[19], 'form_url' => $_CONF['site_admin_url'] . '/plugins/polls/index.php');
$query_arr = array('table' => 'polltopics', 'sql' => "SELECT *,UNIX_TIMESTAMP(date) AS unixdate " . "FROM {$_TABLES['polltopics']} WHERE 1=1", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSql('AND'));
$retval .= ADMIN_list('polls', 'plugin_getListField_polls', $header_arr, $text_arr, $query_arr, $defsort_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* Displays the list of ipn history from the log stored in the database
*
*/
function PAYPAL_listTransactions()
{
global $_CONF, $_TABLES, $LANG_PAYPAL_1, $_USER;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (DB_count($_TABLES['paypal_ipnlog']) == 0) {
$retval .= '<p>' . $LANG_PAYPAL_1['ipnlog_empty'] . '</p>';
}
// Todo make mc_gross sortable (need a new field in paypal_purchases table
$header_arr = array(array('text' => $LANG_PAYPAL_1['date_time'], 'field' => 'time', 'sort' => true), array('text' => $LANG_PAYPAL_1['user_id'], 'field' => 'user_id', 'sort' => true), array('text' => $LANG_PAYPAL_1['gross_payment'], 'field' => 'mc_gross', 'sort' => false), array('text' => $LANG_PAYPAL_1['txn_id'], 'field' => 'txnid', 'sort' => true), array('text' => $LANG_PAYPAL_1['payment_status'], 'field' => 'status', 'sort' => true));
$defsort_arr = array('field' => 'time', 'direction' => 'desc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/paypal/purchase_history.php');
$sql = "SELECT i.txn_id AS txnid, i.ipn_data, i.time, u.username, u.uid, p.*\n\t\t\t\tFROM {$_TABLES['paypal_ipnlog']} AS i\n\t\t\tLEFT JOIN \n\t\t\t {$_TABLES['paypal_purchases']} AS p\n\t\t\tON\n\t\t\t i.txn_id = p.txn_id\n\t\t\tLEFT JOIN\n\t\t\t\t{$_TABLES['users']} AS u \n\t\t\tON\n\t\t\t\tp.user_id = u.uid\n\t\t\t\n\t\t\tWHERE 1 = 1 AND p.quantity <> ''\n\t\t\t\n\t\t\t";
$query_arr = array('sql' => $sql, 'default_filter' => 'GROUP BY i.txn_id', 'query_fields' => array('time', 'user_id', 'i.txn_id', 'p.status', 'u.username', 'i.ipn_data'));
$_SESSION['gross_total'] = 0;
//TODO $extra params to pass values to getListField
$retval .= ADMIN_list('paypal', 'PAYPAL_getListField_paypal_transactions', $header_arr, $text_arr, $query_arr, $defsort_arr, $filter = '', $extra = '', $options = '', $form_arr = '', $showsearch = true);
if ($_SESSION['gross_total'] > 0) {
$retval .= "<h2>Total page : {$_SESSION['gross_total']}</h2>";
}
return $retval;
}
function BB2_ban_list()
{
global $_CONF, $_USER, $_TABLES, $LANG_BAD_BEHAVIOR, $LANG_BB2_RESPONSE, $LANG_ADMIN;
$retval = '';
// writing the menu on top
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/plugins/bad_behavior2/ban.php?mode=add', 'text' => $LANG_BAD_BEHAVIOR['ban_ip']), array('url' => $_CONF['site_admin_url'] . '/plugins/bad_behavior2/index.php', 'text' => $LANG_BAD_BEHAVIOR['log_entries']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= COM_startBlock($LANG_BAD_BEHAVIOR['plugin_display_name'] . ' - ' . $LANG_BAD_BEHAVIOR['block_title_list'], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG_BAD_BEHAVIOR['ban_list_info'], $_CONF['site_url'] . '/bad_behavior2/images/bad_behavior2.png');
if (!empty($msg)) {
$retval .= COM_showMessage($msg, 'bad_behavior2');
}
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
$header_arr = array(array('text' => $LANG_BAD_BEHAVIOR['ip_address'], 'field' => 'ip', 'sort' => false, 'align' => 'left'), array('text' => $LANG_BAD_BEHAVIOR['type'], 'field' => 'type', 'sort' => true, 'align' => 'left'), array('text' => $LANG_BAD_BEHAVIOR['date'], 'field' => 'timestamp', 'sort' => true, 'align' => 'left'), array('text' => $LANG_BAD_BEHAVIOR['reason'], 'field' => 'reason', 'sort' => false, 'align' => 'left'));
$defsort_arr = array('field' => 'ip', 'direction' => 'asc');
$text_arr = array('no_data' => '', 'title' => "", 'form_url' => $_CONF['site_admin_url'] . '/plugins/bad_behavior2/ban.php', 'has_search' => true, 'has_limit' => true, 'has_paging' => true);
$actions = '<input name="deletebutton" type="image" src="' . $_CONF['layout_url'] . '/images/admin/delete.png' . '" style="vertical-align:text-bottom;" title="' . $LANG_BAD_BEHAVIOR['delete_info'] . '" onclick="return doubleconfirm(\'' . $LANG_BAD_BEHAVIOR['delete_confirm_1'] . '\',\'' . $LANG_BAD_BEHAVIOR['delete_confirm_2'] . '\');"' . '/> ' . $LANG_BAD_BEHAVIOR['delete'];
$option_arr = array('chkselect' => true, 'chkall' => true, 'chkfield' => 'id', 'chkname' => 'actionitem', 'chkactions' => $actions);
$query_arr = array('table' => 'bad_behavior2_ban', 'sql' => "SELECT id,INET_NTOA(ip) AS ip, type, reason, timestamp FROM {$_TABLES['bad_behavior2_ban']} WHERE 1=1", 'query_fields' => array('INET_NTOA(ip)'), 'default_filter' => '');
$token = SEC_createToken();
$form_arr = array('top' => '<input type="hidden" name="' . CSRF_TOKEN . '" value="' . $token . '"/>', 'bottom' => '<input type="hidden" name="mode" value="delete"/>');
$retval .= ADMIN_list('bad_behavior2_ban', 'BB2_getListField', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token, $option_arr, $form_arr);
return $retval;
}
/**
* Administer user registrations.
* This will appear in the admin area for administrators, and as part of
* the event detail for event owners. Owners can delete registrations.
*
* @param integer $rp_id Repeat ID being viewed or checked
* @return string HTML for admin list
*/
function EVLIST_adminRSVP($rp_id)
{
global $LANG_EVLIST, $LANG_ADMIN, $_TABLES, $_CONF, $_IMAGE_TYPE;
/*
+-------------------+----------+-------------------+-------+-------+-------+-----+------+------+
| tic_id | tic_type | ev_id | rp_id | fee | paid | uid | used | dt |
+-------------------+----------+-------------------+-------+-------+-------+-----+------+------+
| 20150209083155975 | 1 | 20150209081055236 | 7552 | 15.00 | 15.00 | 3 | 0 | 0 |
+-------------------+----------+-------------------+-------+-------+-------+-----+------+------+
1 row in set (0.00 sec)
*/
USES_lib_admin();
USES_evlist_class_repeat();
$Ev = new evRepeat($rp_id);
if ($Ev->rp_id == 0) {
return '';
}
DB_query("SET @tk_count = 0;");
$sql = "SELECT @tk_count := @tk_count +1 as tic_count,\n tk.dt, tk.tic_id, tk.tic_type, tk.rp_id, tk.fee, tk.paid,\n tk.uid, tk.used, tt.description, u.fullname,\n {$Ev->Event->options['max_rsvp']} as max_rsvp\n FROM {$_TABLES['evlist_tickets']} tk\n LEFT JOIN {$_TABLES['evlist_tickettypes']} tt\n ON tt.id = tk.tic_type\n LEFT JOIN {$_TABLES['users']} u\n ON u.uid = tk.uid\n WHERE tk.ev_id = '{$Ev->Event->id}' ";
$title = $LANG_EVLIST['pi_title'] . ': ' . $LANG_EVLIST['admin_rsvp'] . ' -- ' . COM_createLink($Ev->Event->Detail->title . ' (' . $Ev->date_start . ')', EVLIST_URL . '/event.php?eid=' . $rp_id);
$title .= ' <a href="' . $_CONF['site_admin_url'] . '/plugins/evlist/index.php?printtickets&eid=' . $Ev->ev_id . '" class="lgButton blue" target="_new">' . $LANG_EVLIST['print_tickets'] . '</a>';
$title .= ' <a href="' . $_CONF['site_admin_url'] . '/plugins/evlist/index.php?exporttickets&eid=' . $Ev->rp_id . '" class="lgButton blue">' . $LANG_EVLIST['export_list'] . '</a>';
if ($Ev->Event->options['use_reg'] == EV_RSVP_REPEAT) {
$sql .= " AND rp_id = '{$Ev->rp_id}' ";
}
$defsort_arr = array('field' => 'dt', 'direction' => 'ASC');
$text_arr = array('has_menu' => false, 'has_extras' => false, 'title' => $title, 'form_url' => EVLIST_URL . '/event.php?rp_id=' . $rp_id, 'help_url' => '');
$header_arr = array(array('text' => $LANG_EVLIST['rsvp_date'], 'field' => 'dt', 'sort' => true), array('text' => $LANG_EVLIST['name'], 'field' => 'fullname', 'sort' => false), array('text' => $LANG_EVLIST['fee'], 'field' => 'fee', 'sort' => false), array('text' => $LANG_EVLIST['paid'], 'field' => 'paid', 'sort' => false), array('text' => $LANG_EVLIST['ticket_num'], 'field' => 'tic_id', 'sort' => false), array('text' => $LANG_EVLIST['date_used'], 'field' => 'used', 'sort' => false), array('text' => $LANG_EVLIST['waitlisted'], 'field' => 'tic_count', 'sort' => false));
$options_arr = array('chkdelete' => true, 'chkfield' => 'tic_id', 'chkname' => 'delrsvp', 'chkactions' => '<input data-uk-tooltip name="tickdelete" type="image" src="' . $_CONF['layout_url'] . '/images/admin/delete.' . $_IMAGE_TYPE . '" style="vertical-align:text-bottom;" title="' . $LANG_ADMIN['delete'] . '" class="gl_mootip"' . ' onclick="return confirm(\'' . $LANG_EVLIST['conf_del_item'] . '\');" /> ' . $LANG_ADMIN['delete'] . ' ' . '<input data-uk-tooltip name="tickreset" type="image" src="' . $_CONF['site_url'] . '/evlist/images/reset.png' . '" style="vertical-align:text-bottom;" title="' . $LANG_EVLIST['reset_usage'] . '" class="gl_mootip"' . ' onclick="return confirm(\'' . $LANG_EVLIST['conf_reset'] . '\');" /> ' . $LANG_EVLIST['reset_usage'] . '<input type="hidden" name="ev_id" value="' . $rp_id . '"/>');
$query_arr = array('sql' => $sql);
$retval .= ADMIN_list('evlist', 'EVLIST_getField_rsvp', $header_arr, $text_arr, $query_arr, $defsort_arr, '', '', $options_arr);
return $retval;
}
/**
* Provide list of stories
*
* @param string $current_topic (optional) currently selected topic
* @return string HTML for the list of stories
*
*/
function liststories($current_topic = '')
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG09, $LANG_ADMIN, $LANG_ACCESS, $LANG24;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (empty($current_topic)) {
$current_topic = TOPIC_ALL_OPTION;
}
$seltopics = TOPIC_getTopicListSelect($current_topic, 2);
if (empty($seltopics)) {
$retval .= COM_showMessage(101);
return $retval;
}
if ($current_topic == TOPIC_ALL_OPTION) {
// Retrieve list of inherited topics
// $tid_list = TOPIC_getChildList(TOPIC_ROOT);
// Retrieve list of all topics user has access to (did not do inherit way since may not see all stories has access too)
$tid_list = TOPIC_getList(0, true, false);
if (empty($tid_list)) {
$retval .= COM_showMessage(101);
return $retval;
}
$excludetopics = " (tid IN ('" . implode("','", $tid_list) . "')) ";
} else {
// Retrieve list of inherited topics
$tid_list = TOPIC_getChildList($current_topic);
// Get list of blocks to display (except for dynamic). This includes blocks for all topics, and child blocks that are inherited
$excludetopics = " (ta.tid IN({$tid_list}) AND (ta.inherit = 1 OR (ta.inherit = 0 AND ta.tid = '{$current_topic}')))";
/*
$seltopics = COM_topicList('tid,topic', $current_topic, 1, true);
if (empty($seltopics)) {
$retval .= COM_showMessage(101);
return $retval;
}
*/
}
$filter = $LANG_ADMIN['topic'] . ': <select name="tid" style="width: 125px" onchange="this.form.submit()">' . $seltopics . '</select>';
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_ADMIN['copy'], 'field' => 'copy', 'sort' => false), array('text' => $LANG_ADMIN['title'], 'field' => 'title', 'sort' => true), array('text' => $LANG_ACCESS['access'], 'field' => 'access', 'sort' => false), array('text' => $LANG24[34], 'field' => 'draft_flag', 'sort' => true));
if ($_CONF['show_fullname'] == 1) {
$header_arr[] = array('text' => $LANG24[7], 'field' => 'fullname', 'sort' => true);
// author
} else {
$header_arr[] = array('text' => $LANG24[7], 'field' => 'username', 'sort' => true);
// author
}
$header_arr[] = array('text' => $LANG24[15], 'field' => 'unixdate', 'sort' => true);
// date
$header_arr[] = array('text' => $LANG_ADMIN['topic'], 'field' => 'tid', 'sort' => true);
$header_arr[] = array('text' => $LANG24[32], 'field' => 'featured', 'sort' => true);
if (SEC_hasRights('story.ping') && ($_CONF['trackback_enabled'] || $_CONF['pingback_enabled'] || $_CONF['ping_enabled'])) {
$header_arr[] = array('text' => $LANG24[20], 'field' => 'ping', 'sort' => false);
}
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/story.php?mode=edit', 'text' => $LANG_ADMIN['create_new']));
$menu_arr[] = array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']);
$form_arr = array('bottom' => '', 'top' => '');
$retval .= COM_startBlock($LANG24[22], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG24[23], $_CONF['layout_url'] . '/images/icons/story.' . $_IMAGE_TYPE);
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/story.php');
$sql = "SELECT {$_TABLES['stories']}.*, {$_TABLES['users']}.username, {$_TABLES['users']}.fullname, " . "UNIX_TIMESTAMP(date) AS unixdate FROM {$_TABLES['stories']} " . "LEFT JOIN {$_TABLES['users']} ON {$_TABLES['stories']}.uid={$_TABLES['users']}.uid " . "LEFT JOIN {$_TABLES['topic_assignments']} ta ON ta.type = 'article' AND ta.id = sid " . "WHERE 1=1 ";
if (!empty($excludetopics)) {
$excludetopics = 'AND ' . $excludetopics;
}
$query_arr = array('table' => 'stories', 'sql' => $sql, 'query_group' => "sid,{$_TABLES['users']}.username,{$_TABLES['users']}.fullname", 'query_fields' => array('title', 'introtext', 'bodytext', 'sid', 'tid'), 'default_filter' => $excludetopics . COM_getPermSQL('AND'));
// Add in topic filter so it is remembered with paging
$pagenavurl = '&tid=' . $current_topic;
$retval .= ADMIN_list('story', 'ADMIN_getListField_stories', $header_arr, $text_arr, $query_arr, $defsort_arr, $filter, '', '', $form_arr, true, $pagenavurl);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* Display a list of routes
*
* @return string HTML for the list
*/
function listRoutes()
{
global $_CONF, $_TABLES, $LANG_ADMIN, $LANG_ROUTER, $_IMAGE_TYPE, $securityToken;
require_once $_CONF['path_system'] . 'lib-admin.php';
// Writing the menu on top
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/router.php?mode=edit&rid=0', 'text' => $LANG_ADMIN['create_new']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$notice = $LANG_ROUTER[11];
if (!isset($_CONF['url_rewrite']) || empty($_CONF['url_rewrite'])) {
$notice .= ' ' . $LANG_ROUTER[18];
}
if (!isset($_CONF['url_routing']) || $_CONF['url_routing'] == Router::ROUTING_DISABLED) {
$notice .= ' ' . $LANG_ROUTER[19];
}
$retval = COM_startBlock($LANG_ROUTER[2], '', COM_getBlockTemplate('_admin_block', 'header')) . ADMIN_createMenu($menu_arr, $notice, $_CONF['layout_url'] . '/images/icons/router.' . $_IMAGE_TYPE);
$headerArray = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'rid', 'sort' => false), array('text' => $LANG_ROUTER[4], 'field' => 'method', 'sort' => true), array('text' => $LANG_ROUTER[5], 'field' => 'rule', 'sort' => true), array('text' => $LANG_ROUTER[6], 'field' => 'route', 'sort' => true), array('text' => $LANG_ROUTER[7], 'field' => 'priority', 'sort' => true));
$defaultSortArray = array('field' => 'priority', 'direction' => 'asc');
$textArray = array('has_extras' => false, 'title' => $LANG_ROUTER[1], 'form_url' => $_CONF['site_admin_url'] . '/router.php');
$queryArray = array('table' => 'routes', 'sql' => "SELECT * FROM {$_TABLES['routes']} WHERE (1 = 1) ", 'query_fields' => array('rule', 'route', 'priority'), 'default_filter' => COM_getPermSql('AND'));
$retval .= ADMIN_list('routes', 'ADMIN_getListFieldRoutes', $headerArray, $textArray, $queryArray, $defaultSortArray, '', $securityToken, '');
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
function SFS_adminList()
{
global $_CONF, $_USER, $_TABLES, $LANG_SFS, $LANG_ADMIN;
// force the query limit to 10 if user has not set a limit.
if (!isset($_GET['query_limit']) && !isset($_POST['query_limit'])) {
$_GET['query_limit'] = 10;
}
if (defined('DVLP_VERSION')) {
$block_title = '<strong>DEVELOPMENT TOGGLE ENABLED</strong> - ' . $LANG_SFS['title'];
} else {
$block_title = $LANG_SFS['title'];
}
$retval = COM_startBlock($block_title, '', COM_getBlockTemplate('_admin_block', 'header'));
$menu_arr = array(array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= ADMIN_createMenu($menu_arr, $LANG_SFS['instructions'], $_CONF['layout_url'] . '/images/icons/sfs.png');
$header_arr = array(array('text' => $LANG_SFS['uid'], 'field' => 'uid', 'align' => 'center'), array('text' => $LANG_SFS['username'], 'field' => 'username', 'align' => 'left'), array('text' => $LANG_SFS['email'], 'field' => 'email', 'align' => 'left'), array('text' => $LANG_SFS['remote_ip'], 'field' => 'remote_ip', 'align' => 'left'), array('text' => $LANG_SFS['sfs_status'], 'field' => 'status'));
$text_arr = array('no_data' => $LANG_SFS['no_data'], 'form_url' => $_CONF['site_admin_url'] . '/sfs.php', 'help_url' => '', 'has_limit' => true, 'has_search' => false, 'has_paging' => true);
$actions = '<input name="banbutton" type="image" src="' . $_CONF['layout_url'] . '/images/admin/delete.png' . '" style="vertical-align:text-bottom;" title="' . $LANG_SFS['action_text'] . '" onclick="return doubleconfirm(\'' . $LANG_SFS['confirm_one'] . '\',\'' . $LANG_SFS['confirm_two'] . '\');"' . '/> ' . $LANG_SFS['action_text'];
$actions .= ' <input name="delbutton" type="image" src="' . $_CONF['layout_url'] . '/images/admin/delete.png' . '" style="vertical-align:text-bottom;" title="' . $LANG_SFS['action_text_del'] . '" onclick="return doubleconfirm(\'' . $LANG_SFS['confirm_one_del'] . '\',\'' . $LANG_SFS['confirm_two_del'] . '\');"' . '/> ' . $LANG_SFS['action_text_del'];
$actions .= '<br /><br />';
$option_arr = array('chkselect' => true, 'chkall' => true, 'chkfield' => 'uid', 'chkname' => 'actionitem', 'chkactions' => $actions);
$query_arr = array('table' => 'users', 'sql' => "SELECT uid,username,email,status,remote_ip FROM {$_TABLES['users']} WHERE status <> 0 ", 'query_fields' => array('status'), 'default_filter' => "");
$token = SEC_createToken();
$form_arr = array('top' => '<input type="hidden" name="' . CSRF_TOKEN . '" value="' . $token . '"/>', 'bottom' => '<input type="hidden" name="userban" value="true"/>');
$defsort_arr = array('field' => 'regdate', 'direction' => 'DESC');
$retval .= ADMIN_list("sfs", "SFS_getListField", $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token, $option_arr, $form_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* Provide list of stories
*
* @param string $current_topic (optional) currently selected topic
* @return string HTML for the list of stories
*
*/
function liststories($current_topic = '')
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG09, $LANG_ADMIN, $LANG_ACCESS, $LANG24;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
if (empty($current_topic)) {
$current_topic = $LANG09[9];
}
if ($current_topic == $LANG09[9]) {
// "All"
$excludetopics = '';
$seltopics = '';
$topicsql = "SELECT tid,topic FROM {$_TABLES['topics']}" . COM_getPermSQL();
$tresult = DB_query($topicsql);
$trows = DB_numRows($tresult);
if ($trows > 0) {
$exclude = array();
for ($i = 0; $i < $trows; $i++) {
$T = DB_fetchArray($tresult);
$exclude[] = $T['tid'];
$seltopics .= '<option value="' . $T['tid'] . '"';
if ($current_topic == $T['tid']) {
$seltopics .= ' selected="selected"';
}
$seltopics .= '>' . $T['topic'] . '</option>' . LB;
}
$excludetopics = " (tid IN ('" . implode("','", $exclude) . "')) ";
} else {
$retval .= COM_showMessage(101);
return $retval;
}
} else {
$excludetopics = " tid = '{$current_topic}' ";
$seltopics = COM_topicList('tid,topic', $current_topic, 1, true);
if (empty($seltopics)) {
$retval .= COM_showMessage(101);
return $retval;
}
}
$alltopics = '<option value="' . $LANG09[9] . '"';
if ($current_topic == $LANG09[9]) {
$alltopics .= ' selected="selected"';
}
$alltopics .= '>' . $LANG09[9] . '</option>' . LB;
$filter = $LANG_ADMIN['topic'] . ': <select name="tid" style="width: 125px" onchange="this.form.submit()">' . $alltopics . $seltopics . '</select>';
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_ADMIN['copy'], 'field' => 'copy', 'sort' => false), array('text' => $LANG_ADMIN['title'], 'field' => 'title', 'sort' => true), array('text' => $LANG_ACCESS['access'], 'field' => 'access', 'sort' => false), array('text' => $LANG24[34], 'field' => 'draft_flag', 'sort' => true));
if ($_CONF['show_fullname'] == 1) {
$header_arr[] = array('text' => $LANG24[7], 'field' => 'fullname', 'sort' => true);
// author
} else {
$header_arr[] = array('text' => $LANG24[7], 'field' => 'username', 'sort' => true);
// author
}
$header_arr[] = array('text' => $LANG24[15], 'field' => 'unixdate', 'sort' => true);
// date
$header_arr[] = array('text' => $LANG_ADMIN['topic'], 'field' => 'tid', 'sort' => true);
$header_arr[] = array('text' => $LANG24[32], 'field' => 'featured', 'sort' => true);
if (SEC_hasRights('story.ping') && ($_CONF['trackback_enabled'] || $_CONF['pingback_enabled'] || $_CONF['ping_enabled'])) {
$header_arr[] = array('text' => $LANG24[20], 'field' => 'ping', 'sort' => false);
}
$defsort_arr = array('field' => 'unixdate', 'direction' => 'desc');
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/story.php?mode=edit', 'text' => $LANG_ADMIN['create_new']));
$menu_arr[] = array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']);
$retval .= COM_startBlock($LANG24[22], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG24[23], $_CONF['layout_url'] . '/images/icons/story.' . $_IMAGE_TYPE);
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/story.php');
$sql = "SELECT {$_TABLES['stories']}.*, {$_TABLES['users']}.username, {$_TABLES['users']}.fullname, " . "UNIX_TIMESTAMP(date) AS unixdate FROM {$_TABLES['stories']} " . "LEFT JOIN {$_TABLES['users']} ON {$_TABLES['stories']}.uid={$_TABLES['users']}.uid " . "WHERE 1=1 ";
if (!empty($excludetopics)) {
$excludetopics = 'AND ' . $excludetopics;
}
$query_arr = array('table' => 'stories', 'sql' => $sql, 'query_fields' => array('title', 'introtext', 'bodytext', 'sid', 'tid'), 'default_filter' => $excludetopics . COM_getPermSQL('AND'));
$retval .= ADMIN_list('story', 'ADMIN_getListField_stories', $header_arr, $text_arr, $query_arr, $defsort_arr, $filter);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* Display a list of all weblog directory services in the system
*
* @return string HTML for the list
*
*/
function listServices()
{
global $LANG_ADMIN, $LANG_TRB, $_CONF, $_IMAGE_TYPE, $_TABLES;
require_once $_CONF['path_system'] . 'lib-admin.php';
$retval = '';
$token = SEC_createToken();
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_TRB['service'], 'field' => 'name', 'sort' => true), array('text' => $LANG_TRB['ping_method'], 'field' => 'method', 'sort' => true), array('text' => $LANG_TRB['service_ping_url'], 'field' => 'ping_url', 'sort' => true), array('text' => $LANG_ADMIN['enabled'], 'field' => 'is_enabled', 'sort' => false));
$defsort_arr = array('field' => 'name', 'direction' => 'asc');
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/trackback.php?mode=editservice', 'text' => $LANG_ADMIN['create_new']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= COM_startBlock($LANG_TRB['services_headline'], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG_TRB['service_explain'], $_CONF['layout_url'] . '/images/icons/trackback.' . $_IMAGE_TYPE);
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/trackback.php', 'help_url' => getHelpUrl() . '#ping');
$query_arr = array('table' => 'pingservice', 'sql' => "SELECT * FROM {$_TABLES['pingservice']} WHERE 1=1", 'query_fields' => array('name', 'ping_url'), 'default_filter' => "", 'no_data' => $LANG_TRB['no_services']);
// this is a dummy variable so we know the form has been used if all services
// should be disabled in order to disable the last one.
$form_arr = array('top' => '<input type="hidden" name="' . CSRF_TOKEN . '" value="' . $token . '"' . XHTML . '>', 'bottom' => '<input type="hidden" name="serviceChanger" value="true"' . XHTML . '>');
$retval .= ADMIN_list('pingservice', 'ADMIN_getListField_trackback', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token, '', $form_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
if ($_CONF['trackback_enabled']) {
$retval .= freshTrackback();
}
if ($_CONF['pingback_enabled']) {
$retval .= freshPingback();
}
return $retval;
}
/**
* This function allows the batch deletion of users that are inactive
* It shows the form that will filter user that will be deleted
*
* @return string HTML Form
*/
function batchdelete()
{
global $_CONF, $_TABLES, $LANG_ADMIN, $LANG01, $LANG28, $_IMAGE_TYPE;
$retval = '';
if (!$_CONF['lastlogin']) {
$retval .= '<p>' . $_LANG28[55] . '</p>';
return $retval;
}
require_once $_CONF['path_system'] . 'lib-admin.php';
$usr_type = '';
if (isset($_REQUEST['usr_type'])) {
$usr_type = COM_applyFilter($_REQUEST['usr_type']);
}
if (!in_array($usr_type, array('phantom', 'short', 'old', 'recent'))) {
$usr_type = 'phantom';
}
$usr_time_arr = array();
// default values, in months
$usr_time_arr['phantom'] = 2;
$usr_time_arr['short'] = 6;
$usr_time_arr['old'] = 24;
$usr_time_arr['recent'] = 1;
$usr_time = '';
if (isset($_REQUEST['usr_time'])) {
// 'usr_time' is an array when clicking "Update List" but a single
// value when actually deleting users
if (is_array($_REQUEST['usr_time'])) {
$usr_time_arr = $_REQUEST['usr_time'];
} else {
$usr_time_arr[$usr_type] = (int) $_REQUEST['usr_time'];
}
}
$usr_time = $usr_time_arr[$usr_type];
// list of options for user display
// sel => form-id
// desc => title
// txt1 => text before input-field
// txt2 => text after input field
$opt_arr = array(array('sel' => 'phantom', 'desc' => $LANG28[57], 'txt1' => $LANG28[60], 'txt2' => $LANG28[61]), array('sel' => 'short', 'desc' => $LANG28[58], 'txt1' => $LANG28[62], 'txt2' => $LANG28[63]), array('sel' => 'old', 'desc' => $LANG28[59], 'txt1' => $LANG28[64], 'txt2' => $LANG28[65]), array('sel' => 'recent', 'desc' => $LANG28[74], 'txt1' => $LANG28[75], 'txt2' => $LANG28[76]));
$user_templates = COM_newTemplate($_CONF['path_layout'] . 'admin/user');
$user_templates->set_file(array('form' => 'batchdelete.thtml', 'options' => 'batchdelete_options.thtml', 'reminder' => 'reminder.thtml'));
$user_templates->set_var('usr_type', $usr_type);
$user_templates->set_var('usr_time', $usr_time);
$user_templates->set_var('lang_instruction', $LANG28[56]);
$user_templates->set_var('lang_updatelist', $LANG28[66]);
$num_opts = count($opt_arr);
for ($i = 0; $i < $num_opts; $i++) {
$selector = '';
if ($usr_type == $opt_arr[$i]['sel']) {
$selector = ' checked="checked"';
}
$user_templates->set_var('sel_id', $opt_arr[$i]['sel']);
$user_templates->set_var('selector', $selector);
$user_templates->set_var('lang_description', $opt_arr[$i]['desc']);
$user_templates->set_var('lang_text_start', $opt_arr[$i]['txt1']);
$user_templates->set_var('lang_text_end', $opt_arr[$i]['txt2']);
$user_templates->set_var('id_value', $usr_time_arr[$opt_arr[$i]['sel']]);
$user_templates->parse('options_list', 'options', true);
}
$user_templates->parse('form', 'form');
$desc = $user_templates->finish($user_templates->get_var('form'));
$header_arr = array(array('text' => $LANG28[37], 'field' => $_TABLES['users'] . '.uid', 'sort' => true), array('text' => $LANG28[3], 'field' => 'username', 'sort' => true), array('text' => $LANG28[4], 'field' => 'fullname', 'sort' => true));
switch ($usr_type) {
case 'phantom':
$header_arr[] = array('text' => $LANG28[14], 'field' => 'regdate', 'sort' => true);
$header_arr[] = array('text' => $LANG28[41], 'field' => 'lastlogin_short', 'sort' => true);
$header_arr[] = array('text' => $LANG28[67], 'field' => 'phantom_date', 'sort' => true);
$list_sql = ", UNIX_TIMESTAMP()- UNIX_TIMESTAMP(regdate) as phantom_date";
$filter_sql = "lastlogin = 0 AND UNIX_TIMESTAMP()- UNIX_TIMESTAMP(regdate) > " . $usr_time * 2592000 . " AND";
$sort = 'regdate';
break;
case 'short':
$header_arr[] = array('text' => $LANG28[14], 'field' => 'regdate', 'sort' => true);
$header_arr[] = array('text' => $LANG28[41], 'field' => 'lastlogin_short', 'sort' => true);
$header_arr[] = array('text' => $LANG28[68], 'field' => 'online_hours', 'sort' => true);
$header_arr[] = array('text' => $LANG28[69], 'field' => 'offline_months', 'sort' => true);
$list_sql = ", (lastlogin - UNIX_TIMESTAMP(regdate)) AS online_hours, (UNIX_TIMESTAMP() - lastlogin) AS offline_months";
$filter_sql = "lastlogin > 0 AND lastlogin - UNIX_TIMESTAMP(regdate) < 86400 " . "AND UNIX_TIMESTAMP() - lastlogin > " . $usr_time * 2592000 . " AND";
$sort = 'lastlogin';
break;
case 'old':
$header_arr[] = array('text' => $LANG28[41], 'field' => 'lastlogin_short', 'sort' => true);
$header_arr[] = array('text' => $LANG28[69], 'field' => 'offline_months', 'sort' => true);
$list_sql = ", (UNIX_TIMESTAMP() - lastlogin) AS offline_months";
$filter_sql = "lastlogin > 0 AND (UNIX_TIMESTAMP() - lastlogin) > " . $usr_time * 2592000 . " AND";
$sort = 'lastlogin';
break;
case 'recent':
$header_arr[] = array('text' => $LANG28[14], 'field' => 'regdate', 'sort' => true);
$header_arr[] = array('text' => $LANG28[41], 'field' => 'lastlogin_short', 'sort' => true);
$list_sql = "";
$filter_sql = "(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(regdate)) < " . $usr_time * 2592000 . " AND";
$sort = 'regdate';
break;
}
$header_arr[] = array('text' => $LANG28[7], 'field' => 'email', 'sort' => true);
$header_arr[] = array('text' => $LANG28[87], 'field' => 'num_reminders', 'sort' => true);
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/user.php', 'text' => $LANG28[11]), array('url' => $_CONF['site_admin_url'] . '/user.php?mode=importform', 'text' => $LANG28[23]), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$text_arr = array('has_menu' => true, 'has_extras' => true, 'title' => '', 'instructions' => $desc, 'icon' => $_CONF['layout_url'] . '/images/icons/user.' . $_IMAGE_TYPE, 'form_url' => $_CONF['site_admin_url'] . "/user.php?mode=batchdelete&usr_type={$usr_type}&usr_time={$usr_time}", 'help_url' => '');
$defsort_arr = array('field' => $sort, 'direction' => 'ASC');
$join_userinfo = "LEFT JOIN {$_TABLES['userinfo']} ON {$_TABLES['users']}.uid={$_TABLES['userinfo']}.uid ";
$select_userinfo = ", lastlogin as lastlogin_short {$list_sql} ";
$sql = "SELECT {$_TABLES['users']}.uid,username,fullname,email,photo,status,regdate,num_reminders{$select_userinfo} " . "FROM {$_TABLES['users']} {$join_userinfo} WHERE 1=1";
$query_arr = array('table' => 'users', 'sql' => $sql, 'query_fields' => array('username', 'email', 'fullname'), 'default_filter' => "AND {$filter_sql} {$_TABLES['users']}.uid > 1");
$listoptions = array('chkdelete' => true, 'chkfield' => 'uid');
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/user.php', 'text' => $LANG28[11]), array('url' => $_CONF['site_admin_url'] . '/user.php?mode=importform', 'text' => $LANG28[23]), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= COM_startBlock($LANG28[54], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $desc, $_CONF['layout_url'] . '/images/icons/user.' . $_IMAGE_TYPE);
$user_templates->set_var('lang_reminder', $LANG28[77]);
$user_templates->set_var('action_reminder', $LANG28[78]);
$user_templates->parse('test', 'reminder');
$form_arr['top'] = $user_templates->finish($user_templates->get_var('test'));
$token = SEC_createToken();
$form_arr['bottom'] = "<input type=\"hidden\" name=\"" . CSRF_TOKEN . "\" value=\"{$token}\"" . XHTML . ">";
$retval .= ADMIN_list('user', 'ADMIN_getListField_users', $header_arr, $text_arr, $query_arr, $defsort_arr, '', '', $listoptions, $form_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* Displays a list of topics
* Lists all the topics and their icons.
*
* @param string $token Security token to use in list
* @return string HTML for the topic list
*/
function listTopics($token)
{
global $_CONF, $_TABLES, $LANG27, $LANG_ACCESS, $LANG_ADMIN, $_SCRIPTS;
require_once $_CONF['path_system'] . 'lib-admin.php';
$_SCRIPTS->setJavaScriptFile('admin.topic', '/javascript/admin.topic.js');
$retval = '';
$retval .= COM_startBlock($LANG27[8], '', COM_getBlockTemplate('_admin_block', 'header'));
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/topic.php?mode=edit', 'text' => $LANG_ADMIN['create_new']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= ADMIN_createMenu($menu_arr, $LANG27[9], $_CONF['layout_url'] . "/images/icons/topic.png");
$header_arr[] = array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false);
$header_arr[] = array('text' => $LANG27[10], 'field' => 'sortnum', 'sort' => true);
$header_arr[] = array('text' => $LANG27[53], 'field' => 'image', 'sort' => false);
$header_arr[] = array('text' => $LANG27[3], 'field' => 'topic', 'sort' => false);
$header_arr[] = array('text' => $LANG27[2], 'field' => 'tid', 'sort' => true);
$header_arr[] = array('text' => $LANG27[52], 'field' => 'story', 'sort' => false);
$header_arr[] = array('text' => $LANG_ACCESS['access'], 'field' => 'access', 'sort' => false);
$header_arr[] = array('text' => $LANG27[33], 'field' => 'inherit', 'sort' => false);
$header_arr[] = array('text' => $LANG27[35], 'field' => 'hidden', 'sort' => false);
$defsort_arr = array('field' => 'sortnum', 'direction' => 'asc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/topic.php');
$query_arr = array('table' => 'topics', 'sql' => "SELECT * FROM {$_TABLES['topics']} WHERE 1=1 ", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSQL('AND'));
$retval .= ADMIN_list('topics', 'ADMIN_getListField_topics', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
/**
* List available plugins
*
* @param string $token Security token
* @return string formatted list of plugins
*
*/
function listplugins($token)
{
global $_CONF, $_TABLES, $LANG32, $LANG_ADMIN, $_IMAGE_TYPE;
require_once $_CONF['path_system'] . 'lib-admin.php';
$outcome = PLG_resolveDependencies();
$retval = '';
$header_arr = array(array('text' => $LANG32[59], 'field' => 'info_installed', 'sort' => false), array('text' => $LANG32[43], 'field' => 'pi_load', 'sort' => true), array('text' => $LANG32[16], 'field' => 'pi_name', 'sort' => true), array('text' => $LANG32[17], 'field' => 'pi_version', 'sort' => true), array('text' => $LANG32[50], 'field' => 'pi_dependencies', 'sort' => true), array('text' => $LANG_ADMIN['enabled'], 'field' => 'pi_enabled', 'sort' => true), array('text' => $LANG32[25], 'field' => 'delete', 'sort' => false));
$defsort_arr = array('field' => 'pi_load', 'direction' => 'asc');
$menu_arr = array(array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
// JS required by the delete feature
$retval .= '<script type="text/javascript">/* quick Javascript confirmation function */';
$retval .= 'function confirm_action(msg,url){if(confirm(msg)){location.href=url;}}';
$retval .= '</script>';
$retval .= COM_startBlock($LANG32[5], '', COM_getBlockTemplate('_admin_block', 'header'));
if ($outcome == false) {
$retval .= COM_showMessageText($LANG32[58]);
}
$retval .= ADMIN_createMenu($menu_arr, $LANG32[11], $_CONF['layout_url'] . '/images/icons/plugins.' . $_IMAGE_TYPE);
$text_arr = array('has_extras' => true, 'instructions' => $LANG32[11], 'form_url' => $_CONF['site_admin_url'] . '/plugins.php');
$query_arr = array('table' => 'plugins', 'sql' => "SELECT pi_name, pi_version, pi_gl_version, pi_load, " . "pi_enabled, pi_homepage FROM {$_TABLES['plugins']} WHERE 1=1", 'query_fields' => array('pi_name'), 'default_filter' => '');
// this is a dummy variable so we know the form has been used if all plugins
// should be disabled in order to disable the last one.
$form_arr = array('top' => '<div><input type="hidden" name="' . CSRF_TOKEN . '" value="' . $token . '"' . XHTML . '></div>', 'bottom' => '<div><input type="hidden" name="pluginenabler" value="true"' . XHTML . '></div>');
$retval .= ADMIN_list('plugins', 'ADMIN_getListField_plugins', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token, '', $form_arr, false);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
function mydownloads()
{
global $_CONF, $LANG_FM02, $_TABLES, $LANG_ADMIN;
$current_cat = 0;
if (isset($_REQUEST['cat'])) {
$current_cat = COM_applyFilter($_REQUEST['cat']);
}
$selcat = '';
$display = COM_siteHeader();
$display .= filemgmt_navbar();
$sql = "SELECT * FROM {$_TABLES['filemgmt_cat']} WHERE pid=0 ORDER BY title ASC";
$result = DB_query($sql);
while (($C = DB_fetchArray($result)) != NULL) {
$selcat .= '<option value="' . $C['cid'] . '"';
if ($C['cid'] == $current_cat) {
$selcat .= ' selected="selected"';
}
$selcat .= '>';
$selcat .= $C['title'] . '</option>';
$selcat .= _fm_getChildrenCat($C['cid'], 1, $current_cat);
}
$allcat = '<option value="0">' . _MD_ALL . '</option>';
$filter = _MD_CATEGORYC . ' <select name="cat" style="width: 125px" onchange="this.form.submit()">' . $allcat . $selcat . '</select>';
$header_arr = array(array('text' => $LANG_FM02['edit'], 'field' => 'edit', 'sort' => false), array('text' => $LANG_FM02['file'], 'field' => 'title', 'sort' => true), array('text' => $LANG_FM02['category'], 'field' => 'cat_name', 'sort' => true), array('text' => $LANG_FM02['version'], 'field' => 'version', 'sort' => true), array('text' => $LANG_FM02['size'], 'field' => 'size', 'sort' => true, 'align' => 'right'), array('text' => $LANG_FM02['date'], 'field' => 'date', 'sort' => true));
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/filemgmt/index.php?cat=' . (int) $current_cat, 'help_url' => '');
$defsort_arr = array('field' => 'date', 'direction' => 'DESC');
if ($current_cat != 0) {
$where = " c.cid=" . (int) $current_cat . " ";
} else {
$where = " 1=1 ";
}
$sql = "SELECT d.*,c.title AS cat_name FROM {$_TABLES['filemgmt_filedetail']} AS d LEFT JOIN {$_TABLES['filemgmt_cat']} as c ON d.cid=c.cid WHERE " . $where;
$query_arr = array('table' => 'filemgmt_filedetail', 'sql' => $sql, 'query_fields' => array('d.title'), 'default_filter' => '');
$display .= ADMIN_list('filelist', '_fm_getListField_forum', $header_arr, $text_arr, $query_arr, $defsort_arr, $filter);
$display .= COM_endBlock();
$display .= COM_siteFooter();
echo $display;
}
function PAGE_list()
{
global $_CONF, $_TABLES, $_IMAGE_TYPE, $LANG_ADMIN, $LANG_ACCESS, $LANG_STATIC;
USES_lib_admin();
$retval = '';
$menu_arr = array(array('url' => $_CONF['site_admin_url'] . '/plugins/staticpages/index.php?edit=x', 'text' => $LANG_ADMIN['create_new']), array('url' => $_CONF['site_admin_url'], 'text' => $LANG_ADMIN['admin_home']));
$retval .= COM_startBlock($LANG_STATIC['staticpagelist'], '', COM_getBlockTemplate('_admin_block', 'header'));
$retval .= ADMIN_createMenu($menu_arr, $LANG_STATIC['instructions'], plugin_geticon_staticpages());
$header_arr = array(array('text' => $LANG_ADMIN['edit'], 'field' => 'edit', 'sort' => false, 'align' => 'center'), array('text' => $LANG_ADMIN['copy'], 'field' => 'copy', 'sort' => false, 'align' => 'center'), array('text' => $LANG_STATIC['id'], 'field' => 'sp_id', 'sort' => true), array('text' => $LANG_ADMIN['title'], 'field' => 'sp_title', 'sort' => true), array('text' => $LANG_STATIC['head_centerblock'], 'field' => 'sp_centerblock', 'sort' => true, 'align' => 'center'), array('text' => $LANG_STATIC['writtenby'], 'field' => 'sp_uid', 'sort' => true), array('text' => $LANG_ACCESS['access'], 'field' => 'access', 'sort' => false, 'align' => 'center'), array('text' => $LANG_STATIC['date'], 'field' => 'unixdate', 'sort' => true, 'align' => 'center'), array('text' => $LANG_ADMIN['delete'], 'field' => 'delete', 'sort' => false, 'align' => 'center'), array('text' => $LANG_ADMIN['enabled'], 'field' => 'sp_status', 'sort' => true, 'align' => 'center'));
$defsort_arr = array('field' => 'sp_title', 'direction' => 'asc');
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_admin_url'] . '/plugins/staticpages/index.php');
// sql query which drives the list
$sql = "SELECT *,UNIX_TIMESTAMP(sp_date) AS unixdate " . "FROM {$_TABLES['staticpage']} WHERE 1=1 ";
$query_arr = array('table' => 'staticpage', 'sql' => $sql, 'query_fields' => array('sp_title', 'sp_id'), 'default_filter' => COM_getPermSQL('AND'));
// create the security token, and embed it in the list form
// also set the hidden var which signifies that this list allows for pages
// to be enabled/disabled via checkbox
$token = SEC_createToken();
$form_arr = array('top' => '<input type="hidden" name="' . CSRF_TOKEN . '" value="' . $token . '"/>', 'bottom' => '<input type="hidden" name="staticpageenabler" value="true"/>');
$retval .= ADMIN_list('static_pages', 'PAGE_getListField', $header_arr, $text_arr, $query_arr, $defsort_arr, '', $token, '', $form_arr);
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
$outputHandle = outputHandler::getInstance();
$outputHandle->addLinkScript($_CONF['site_url'] . '/javascript/admin.js', HEADER_PRIO_NORMAL, 'text/javascript');
return $retval;
}
$forum_select = '<select name="fid" id="fid" style="line-height:1.5em;width:25em;" onchange="this.form.submit();">' . LB;
foreach ($forumList as $category => $forums) {
if (count($forums) > 0) {
$target = 1;
$forum_select .= '<optgroup label="' . $category . '">' . LB;
foreach ($forums as $id => $name) {
$forum_select .= '<option value="' . $id . '"' . ($id == $forum_id ? ' selected="selected"' : '') . '>' . $name . '</option>' . LB;
}
$forum_select .= '</optgroup>' . LB;
}
}
$forum_select .= '</select>';
$T->set_var('forum_select', $forum_select);
$header_arr = array(array('text' => $LANG_GF03['select'], 'field' => 'select', 'sort' => false), array('text' => $LANG_GF01['TOPIC'], 'field' => 'subject', 'sort' => false), array('text' => $LANG_GF01['AUTHOR'], 'field' => 'author', 'sort' => false), array('text' => $LANG_GF01['DATE'], 'field' => 'date', 'sort' => false, 'nowrap' => true));
$text_arr = array('has_extras' => true, 'form_url' => $_CONF['site_url'] . '/forum/gettopic.php?fid=' . $forum_id . '&pid=' . $topic_parent_id . '&query_limit=20', 'help_url' => '', 'nowrap' => 'date');
$defsort_arr = array('field' => 'date', 'direction' => 'DESC');
$groups = array();
$usergroups = SEC_getUserGroups();
foreach ($usergroups as $group) {
$groups[] = $group;
}
$grouplist = implode(',', $groups);
$sql = "SELECT * FROM {$_TABLES['ff_topic']} WHERE pid=0 AND id<> " . (int) $topic_parent_id . " AND forum=" . (int) $forum_id;
$query_arr = array('table' => 'topic', 'sql' => $sql, 'query_fields' => array('subject', 'comment'), 'default_filter' => '');
$retval .= ADMIN_list('topics', '_ff_getListField_gettopic', $header_arr, $text_arr, $query_arr, $defsort_arr);
$T->set_var('topic_parent_id', $topic_parent_id);
$T->set_var('selection_page', $retval);
$T->parse('output', 'confirm');
$retval = $T->finish($T->get_var('output'));
echo $retval;
exit;