function sc_search($query = '', $limit = 0)
{
$results = get_results($query, 'soundcloud');
$results = sort_results($results, $query, 'title');
if (empty($results) || !is_array($results)) {
return null;
}
$result = $results[0];
$ret = new stdClass();
$ret->title = $result->title;
$ret->url = $result->stream_url . '?client_id=' . CLIENT_ID;
$ret->score = $result->score;
//we care because we will run compare it against other service's scores
return $ret;
}
function get_tags($return_type = '')
{
$output = '';
//get results from DB
$tags = get_results();
//Do we have a return type and is $tags an array like expected
if ($return_type != '' && is_array($tags) && $tags != '') {
if ($return_type == 'styles') {
$output .= '<style type="text/css">';
$tag_counter = 1;
//Build output
foreach ($tags as $tag) {
$output .= '.map a.tag_' . $tag_counter . ' { ';
//$output .= 'border:1px solid #000;';
$output .= 'background:url(images/tag_hotspot_62x62.png) no-repeat;';
$output .= 'top:' . $tag['y1'] . 'px;';
$output .= 'left:' . $tag['x1'] . 'px;';
//$output .= 'width:'.$tag['width'].'px;';
//$output .= 'height:'.$tag['height'].'px;';
$output .= 'width:62px;';
$output .= 'height:62px;';
$output .= '}';
$tag_counter++;
}
$output .= '</style>';
} else {
if ($return_type == 'map') {
$tag_counter = 1;
foreach ($tags as $tag) {
$output .= '<li><a class="tag_' . $tag_counter . '" title="' . $tag['title'] . '"><span><b>' . $tag['title'] . '</b></span></a></li>';
$tag_counter++;
}
} else {
if ($return_type == 'list') {
$title_counter = 1;
foreach ($tags as $tag) {
$output .= '<li><a href="#" class="title" id="tag_' . $title_counter . '">' . $tag['title'] . '</a> (<a href="includes/function.php?delete=true&id=' . $tag['id'] . '">Delete</a>)</li>';
$title_counter++;
}
}
}
}
}
return $output;
$output = '';
}
function main()
{
if (empty($_REQUEST['page'])) {
die('Page required.');
}
//TODO: mysql-php field type mapping... keep ints as ints!
// $start = microtime();
// echo microtime() - $start;
$results = get_results($_REQUEST['domain'], $_REQUEST['page']);
if (!function_exists('json_encode')) {
require_once 'JSON.php';
$json = new Services_JSON();
$output = $json->encode($results);
} else {
$output = json_encode($results);
}
$callback = $_REQUEST['callback'] . "({$output})";
header('Content-type: text/javascript');
print $callback;
}
/**
*
* @param type $params['id_poll']
* @param type $params['one_poll_place']
* @return html
*/
function show_poll_place($id_poll, $one_poll_place)
{
$CI =& get_instance();
$CI->load->model('Polls_model');
$id_user = $CI->session->userdata('user_id');
$denied_polls = $CI->Polls_model->get_denied_polls($id_user);
// Show precise poll
if ($id_poll) {
// Check polls existence
if ($CI->Polls_model->is_exists($id_poll)) {
// If current user may pass the poll
if (!in_array($id_poll, $denied_polls)) {
return get_form($id_poll, $one_poll_place);
} else {
// Template will decide whether to show results or just a text message
if ($one_poll_place || $CI->Polls_model->show_results($id_poll)) {
return get_results($id_poll, $one_poll_place);
}
// else show random poll
}
}
//else show random poll
} elseif ($one_poll_place) {
return false;
}
// If we reached here, show random poll
// Get language and user type
$language = $CI->pg_language->current_lang_id;
$user_type = $CI->session->userdata("user_type");
// Pick a random poll...
$id_poll_rnd = $CI->Polls_model->get_random_id(null, $language, $user_type, $denied_polls);
if ($id_poll_rnd) {
return get_form($id_poll_rnd, $one_poll_place);
} else {
// ...or results
$id_poll_rnd = $CI->Polls_model->get_random_id(true);
if ($id_poll_rnd) {
return get_results($id_poll_rnd, $one_poll_place);
}
}
}
echo "<font style='color:red'>X-frame-options not enabled</font><br>";
}
}
function build_results(&$header)
{
// Builds HTML table to display ALL headers;
echo "<p><h3>Full header results</h3>";
echo "<table><tr><th>Name</th><th>Value</th>";
foreach ($header as $headerValue) {
$headerSplit = explode(": ", $headerValue);
echo "<tr><td>" . $headerSplit[0] . "</td>";
echo "<td>" . $headerSplit[1] . "</td></tr>";
}
echo "</table>";
}
get_results();
secure_header($header);
build_results($header);
?>
<p>
<form action="headers.php" method="POST">
<input class="btn" type="submit" name="reset" value="reset">
</form>
<?php
} else {
?>
<!-- This will display upon initial load or resetting page. -->
<h2>Enter domain:</h2>
<form action="headers.php" method="POST">
<input type="text" name="domain">
<input class="btn" type="submit" name="submit" value="submit">
function mobile_get_recent_games($player_id, $oR3DCQuery)
{
try {
$dbh = CSession::$dbh;
// Select the player's games which have been completed. Games are ordered by the most recent move made.
$query = <<<qq
SELECT
\t`game`.*
FROM (
\tSELECT
\t\tMAX(`time`) as 'lastmovetime', `game_id` as 'gameid'
\tFROM
\t\t`move_history`
\tGROUP BY
\t\t`game_id`
\t) as subq, `game`
WHERE
\t`game_id` = `gameid` AND
\t(`w_player_id` = ? OR `b_player_id` = ?) AND
\t(`completion_status` <> "A" AND `completion_status` <> "I")
ORDER BY
\t`lastmovetime` DESC
LIMIT
\t5
qq;
$stmt = $dbh->prepare($query);
$stmt->bind_param('ii', $player_id, $player_id);
if ($stmt->execute()) {
$results = get_results($stmt);
foreach ($results as $result) {
$next_move = $result['next_move'];
$completion_status = $result['completion_status'];
$game_id = $result['game_id'];
$start_time = $result['start_time'];
$w_player_id = $result['w_player_id'];
$b_player_id = $result['b_player_id'];
$initiator = $result['initiator'];
echo "<GAMES>\n";
echo "<STATUS>C";
echo "</STATUS>\n";
echo "<COMPLETIONSTATUS>";
echo $completion_status;
echo "</COMPLETIONSTATUS>\n";
$gametypecode = $oR3DCQuery->GetGameTypeCode($game_id);
$strGameType = "GT_NORMAL_GAME";
switch ($gametypecode) {
case 2:
$strGameType = "GT_PASV_RT_GAME";
break;
case 3:
$strGameType = "GT_ACTIVE_RT_GAME";
break;
}
echo "<GAMETYPE>";
echo $strGameType;
echo "</GAMETYPE>\n";
$oR3DCQuery->GetGamePlayTypeInfoForMobile($game_id);
$oR3DCQuery->TimedGameStatsForMobile($game_id);
echo "<TIMECREATED>";
echo $start_time;
echo "</TIMECREATED>\n";
echo "<DESCRIPTION>";
echo $oR3DCQuery->GetUserIDByPlayerID($ConfigFile, $w_player_id);
echo " VS ";
echo $oR3DCQuery->GetUserIDByPlayerID($ConfigFile, $b_player_id);
echo "</DESCRIPTION>\n";
echo "<INITIATOR>";
echo $initiator;
echo "</INITIATOR>\n";
echo "<WHITE>";
echo $w_player_id;
echo "</WHITE>\n";
echo "<BLACK>";
echo $b_player_id;
echo "</BLACK>\n";
echo "<NEXTMOVE>";
echo $next_move;
echo "</NEXTMOVE>\n";
echo "<GAMEID>";
echo $game_id;
echo "</GAMEID>\n";
echo "<GAMEFEN>";
echo $oR3DCQuery->GetFEN3('', $game_id);
echo "</GAMEFEN>\n";
echo "</GAMES>\n";
}
}
} catch (mysqli_sql_exception $e) {
echo "<ERROR>Database Error</ERROR>\n";
}
}
<?php
include "config.php";
if (isset($_POST['mode']) && $_POST['mode'] != "") {
$mode = strtoupper($_POST['mode']);
} else {
$mode = '';
}
switch ($mode) {
case 'LOGIN':
$login = $_POST['login'];
$password = $_POST['password'];
$query = "SELECT id, login, password, name FROM contact WHERE login = '******' AND password = '******'";
if (!($result = get_results($query))) {
echo "<p style=\"color:#FF0000\">The user name or password does not exist or is incorrect.<br />Query: {$query}<br />MySQL Error: " . mysql_error() . "</p>";
} else {
$row = $result[0];
// just want first (and only) result row
$_SESSION['name'] = $row['name'];
$_SESSION['id'] = $row['id'];
header("Location: " . DEFAULT_PAGE);
exit;
}
default:
include "header.php";
?>
<form action="<?php
echo $me;
?>
" method="post">
<input type="hidden" name="mode" value="login">
public static function distinct_post_terms(array $posts, $fields = '')
{
$ids = array();
foreach ($posts as $post) {
if (is_numeric($post)) {
$ids[] = absint($post);
} elseif (is_a($post, 'WP_Post')) {
$ids[] = $post->ID;
} elseif (is_a($post, 'PostController')) {
$ids[] = $post->id;
}
}
if (empty($ids)) {
return array();
}
global $wpdb;
$ids = implode(',', $ids);
$query = "\n SELECT DISTINCT t.term_id, t.name, t.slug, t.term_group\n\n FROM `wp_terms` as t\n JOIN `wp_term_taxonomy` as tax ON t.term_id = tax.term_id\n JOIN `wp_term_relationships` as rel ON tax.term_taxonomy_id = rel.term_taxonomy_id\n\n WHERE rel.object_id IN ({$ids});\n ";
switch ($fields) {
case 'raw':
return get_results($query, OBJECT_K);
case 'ids':
return get_col($query);
default:
$results = get_results($query);
foreach ($results as &$result) {
$result = self::get_controller($result);
}
return $results;
}
}
echo GuiHelper::link('sini', 'logout.php');
?>
<form action='actions/do_log_answers.php' method='POST'>
<h3>Query:</h3>
<p><?php
echo GuiHelper::textarea('query', $query);
?>
</p>
<p><?php
echo GuiHelper::submit_button('try', 'try');
?>
<?php
echo GuiHelper::submit_button('save', 'save');
?>
</p>
</form>
<?php
get_results($query);
?>
</body>
</html>
function show_unit_row($unit, $class, $level, $is_answer)
{
global $breakdown, $breakdown_cat;
global $rownum, $course_id;
$a = $is_answer ? " (answer)" : "";
$j = $rownum++ % 2;
echo "<tr class=row{$j}>";
if ($breakdown && $breakdown_cat) {
echo "\n\t\t\t<td><br></td>\n\t\t\t<td><br></td>\n\t\t";
} else {
$c = class_name($class);
echo "\n\t\t\t<td><b>" . spaces($level) . "{$unit->name}</b></td>\n\t\t\t<td>{$c} {$a}</td>\n\t\t";
}
if ($breakdown) {
if ($breakdown_cat) {
echo "<td>{$breakdown_cat}</td>\n";
} else {
echo "<td>Total</td>\n";
}
}
switch ($class) {
case "BoltLesson":
$mode = BOLT_MODE_LESSON;
$views = get_views($unit, $mode);
$n = count($views);
$out = outcomes($views);
$t = avg_time($views);
echo "<td>{$n}</td>";
$n = get_nquestions($unit, $mode);
if ($n) {
echo "<td><a href=bolt_map.php?action=questions&course_id={$course_id}&name={$unit->name}&mode={$mode}" . filter_url() . ">{$n}</a></td>\n";
} else {
echo "<td>0</td>\n";
}
echo outcome_graph($out, 200);
echo empty_cell();
echo time_graph($t, 200);
break;
case "BoltExercise":
$mode = $is_answer ? BOLT_MODE_ANSWER : BOLT_MODE_SHOW;
$views = get_views($unit, $mode);
$n = count($views);
$out = outcomes($views);
$t = avg_time($views);
echo "<td>{$n}</td>";
$n = get_nquestions($unit, $mode);
if ($n) {
echo "<td><a href=bolt_map.php?action=questions&course_id={$course_id}&name={$unit->name}&mode={$mode}>{$n}</a></td>\n";
} else {
echo "<td>0</td>\n";
}
echo outcome_graph($out, 200);
if ($is_answer) {
echo empty_cell();
} else {
$results = get_results($unit);
$score = avg_score($results);
echo score_graph($score, 200);
}
echo time_graph($t, 200);
break;
case "BoltExerciseSet":
$xr = get_xset_results($unit);
$n = count($xr);
echo "<td>{$n}</td>";
echo empty_cell();
echo empty_cell();
$score = avg_score($xr);
echo score_graph($score, 200);
echo empty_cell();
break;
default:
echo empty_cell();
echo empty_cell();
echo empty_cell();
echo empty_cell();
echo empty_cell();
}
echo "</tr>\n";
}
<?php
// for simple user registration
if(!$_POST['username']) echo ' <b>Please enter a username.</b><br>';
else{
mysqli_query($mysqli_link,"select username from ".config::$_['table_prefix']." where username ='******'username'] . "';");
if(mysqli_affected_rows($mysqli_link) > 0) echo '<b>'.$_POST['username'].' username exists, please select another.</b><br>';
elseif(!$_POST['pass'] || !$_POST['pass_confirm']) echo '<b>Please enter a password and confirmation</b><br>';
elseif($_POST['pass'] != $_POST['pass_confirm']) echo '<b>Passwords do not match please re-enter and try again.</b><br>';
elseif(!$_POST['email']) echo '<b>Please enter an email address.</b><br>';
// defaults to userlevel 5
else {
get_results("INSERT INTO `".config::$_['table_prefix']."users` ( `username`, `full_name`, `password`, `usergroup`, `email`) VALUES ( '".$_POST['username']."', '".$_POST['fullname']."', '".md5($_POST['pass'])."', '5', '".$_POST['email']."');",1);
echo '<h2> Thank you for registering!</h2>';
}
}
// report sucess somewhere .... possibly send email out to user ? do a registration confirmation link to avoid abuse ?
private function queryEntriesParent($entry_parent)
{
if ($this->queryEntriesParentQuery === null) {
$this->queryEntriesParentQuery = $this->parentQuery;
$this->queryEntriesParentQuery->appendCondition("`{$this->column_parent}` = '%d'");
$this->queryEntriesParentQuery = $this->queryEntriesParentQuery->getQuery();
}
return get_results(sprintf($this->queryEntriesParentQuery, (int) $entry_parent), $this->className);
}
<?php
include "functions.php";
include "header.php";
if (!($dbh = db_connect('tc8401_classdb', 'tc8401_dbuser', 'simple'))) {
exit('Error connecting to database.');
}
$query = "SELECT * FROM contact";
$result = get_results($query, 'A', true);
/*
echo "<div>";
print_results($result);
echo "</div>";
*/
echo "<div>" . print_results2($result, true) . "</div>";
/*
echo "<pre>" . print_r($result, true) . "</pre>";
reset ($result);
*/
include "footer.php";
if (!$result) {
echo "<p>There was a problem updating the database.<br />MySQL Error: " . mysql_error() . "</p>";
} else {
echo "<p>Subscription was added successfully.</p>";
}
}
}
$query = "SELECT subs.id, name FROM subs, c_to_s WHERE subs.id = s_id AND c_id = '{$_SESSION['id']}'";
if (!($result = get_results($query))) {
echo "<p>No Subscriptions Found.</p>";
} else {
echo "<h2>Available Subscriptions:</h2>";
print_results1($result);
}
$query = "SELECT subs.id, name FROM subs WHERE NOT EXISTS (SELECT * FROM c_to_s WHERE subs.id = s_id AND c_id = '{$_SESSION['id']}')";
if (!($all_subs = get_results($query))) {
echo "<p>No additional subscriptions are available.</p>";
} else {
echo "<form action=\"{$me}?mode=add\" method=\"post\"><select name=\"subs\">";
foreach ($all_subs as $row) {
echo "<option value=\"{$row['id']}\">{$row['name']}</option>";
}
echo "</select> <input type=\"submit\" name=\"butSubmit\" value=\"Add\" /></form>";
}
?>
<?php
include "footer.php";
$search_keywords_filter = "";
}
// FINAL SQL
$sql = "SELECT `wp_product_list`.*, `wp_product_brands`.`name` as brand, `wp_product_brands`.`id` as brandid, `wp_product_categories`.`name` as kategoria, `wp_product_list`.`category` as category_id, `wp_product_files`.`width`, `wp_product_files`.`height` FROM `wp_product_list`, `wp_product_brands`, `wp_product_categories`,`wp_product_files` WHERE `wp_product_list`.`active`='1' " . $cartoonid_filter . $brandid_filter . $categoryid_filter . $exclude_category_sql . $colorfilter . $approved_or_not . $min_points_filter . " AND wp_product_files.id = wp_product_list.file AND `wp_product_list`.`visible`='1' " . $search_keywords_filter . " AND `wp_product_brands`.`id` = `wp_product_list`.`brand` AND `wp_product_list`.`category` = `wp_product_categories`.`id` {$orderBy} LIMIT " . $offset . "," . $items_on_page;
// FINAL sql FOR ТЕМА ДНЯ
if ($category == '777') {
$sql = "SELECT `wp_product_list`.*, `wp_product_brands`.`id` as brandid, `wp_product_brands`.`name` as brand, `wp_item_category_associations`.`category_id`, `wp_product_categories`.`name` as kategoria FROM `wp_product_list`,`wp_item_category_associations`, `wp_product_brands`, `wp_product_categories` WHERE `wp_product_list`.`id` = `wp_item_category_associations`.`product_id` AND `wp_product_list`.`tema_dnya_approved` = '1' AND `wp_product_brands`.`id` = `wp_product_list`.`brand` AND `wp_item_category_associations`.`category_id` = `wp_product_categories`.`id` AND wp_product_list.id = (select id from tema_dnya where DATETIME = DATE( NOW( ) ) ) LIMIT 1 UNION SELECT `wp_product_list`.*, `wp_product_brands`.`id` as brandid, `wp_product_brands`.`name` as brand, `wp_item_category_associations`.`category_id`, `wp_product_categories`.`name` as kategoria FROM `wp_product_list`,`wp_item_category_associations`, `wp_product_brands`, `wp_product_categories` WHERE `wp_product_list`.`active`='1' AND `wp_item_category_associations`.`category_id` != '666' AND `wp_product_list`.`approved` = '1' AND `wp_product_list`.`tema_dnya_approved` = '1' AND `wp_product_list`.`visible`='1' AND `wp_product_list`.`id` = `wp_item_category_associations`.`product_id` AND `wp_product_brands`.`id` = `wp_product_list`.`brand` AND `wp_item_category_associations`.`category_id` = `wp_product_categories`.`id` AND `wp_item_category_associations`.`category_id`='777' AND `wp_product_categories`.`id`=777 and wp_product_list.id not in (SELECT id FROM tema_dnya WHERE DATETIME = DATE( NOW( ) ) )";
}
// COUNT total number of images for this query
$sql_count_total = "SELECT COUNT(`wp_product_list`.id) as count FROM `wp_product_list`, `wp_product_brands`, `wp_product_categories` WHERE `wp_product_list`.`active`='1' " . $cartoonid_filter . $brandid_filter . $categoryid_filter . $exclude_category_sql . $colorfilter . $approved_or_not . " AND `wp_product_list`.`visible`='1' " . $search_keywords_filter . " AND `wp_product_brands`.`id` = `wp_product_list`.`brand` AND `wp_product_list`.`category` = `wp_product_categories`.`id`";
//todo $searchdonebutnothingfound???
if (!$searchdonebutnothingfound) {
$count = get_results($sql_count_total);
$totalitems = $count[0]['count'];
}
$rrr = get_results($sql);
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
$licontent = '';
while ($row = mysql_fetch_array($result)) {
//dimensions
$width = $row['width'];
$height = $row['height'];
$_size_warning = "";
if ($width < 800 or $height < 800) {
$_size_warning = "<div style='font-size:1em;'><a style='color:red;' href='" . SITEURL . "?page_id=771'>Внимание! Размеры файла<br />ограничивают применение!</a></div>";
}
$_size = $width . "px X " . $height . "px;";
$_x_sm = round($width / 300 * 2.54, 1);
function vote_request()
{
try {
$list1 = "LISTA ZA GRADSKO/OPĆINSKO VIJEĆE";
$list11 = 35;
//"LISTA ZA GRADSKO/OPĆINSKO VIJEĆE";
$list2 = "ŽUPANIJSKA SKUPŠTINA";
$list3 = "ZAMJENIK ŽUPANA IZ REDA N.M.";
$list4 = "GRADSKA SKUPŠTINA GRADA ZAGREBA";
scraperwiki::attach("liste");
$query = 'zupanija from liste."područja" where grad_opcina="' . $_GET['city'] . '"';
$county = scraperwiki::select($query);
if ($county == null || $county[0]['zupanija'] != $_GET['county']) {
$_GET['page'] = 'auth';
return false;
}
$query = 'lista, izvor, kandidati from liste."' . $county[0]['zupanija'] . '" where grad_opcina="' . $_GET['city'] . '" or grad_opcina is null';
$data = scraperwiki::select($query);
$votes = array();
for ($i = 0; $i < count($data); $i++) {
$list = "";
foreach ($data[$i] as $key => $value) {
if ($key == "lista") {
$list = $value;
} else {
if ($key == "izvor") {
continue;
} else {
if ($key == "kandidati") {
$list = trim($list);
$len = strlen($list);
if ($len == strlen($list1) || $len == $list11 || $len == strlen($list2) || $len == strlen($list4)) {
if (isset($_GET['lista' . $i])) {
$vote = $_GET['lista' . $i];
$l = substr($vote, 8);
if (isset($_GET['lista' . $i . 'kandidat' . $l])) {
$vote = $_GET['lista' . $i . 'kandidat' . $l];
if ($vote != "") {
$votes[$list] = $l . '.' . $vote;
}
}
}
} else {
$len = strlen($list);
if ($len == strlen($list3)) {
if (!isset($_GET['manjina']) || $_GET['manjina'] == "") {
continue;
}
$minor = strtolower($_GET['manjina']);
$minor[strlen($minor) - 1] = 'e';
if (strpos($value, $minor) == -1) {
continue;
}
}
if (isset($_GET['lista' . $i])) {
$vote = $_GET['lista' . $i];
$l = substr($vote, 8);
if ($l != "") {
$votes[$list] = $l;
}
}
}
}
}
}
}
}
if (!isset($_GET['time'])) {
$votes['BIRAČ'] = hash("sha512", $_GET['boi'] . $_GET['prezime'] . $_GET['oib'] . $_GET['ime'] . $_GET['mbg']);
} else {
$votes['BIRAČ'] = $_GET['time'];
}
$votes['GRAD'] = $_GET['city'];
$votes['ŽUPANIJA'] = $_GET['county'];
scraperwiki::save_sqlite(array('BIRAČ'), $votes);
get_results();
return true;
} catch (Exception $e) {
$_GET['page'] = 'auth';
return false;
}
}
/**
* User input is handled here
*/
$longopts = array("term::", "location::");
$options = getopt("", $longopts);
$term = $options['term'] ?: 'lunch';
$location = $options['location'] ?: '渋谷駅';
// query_api($term, $location);
//get_results($term, $location);
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
if (isset($_GET['storeId'])) {
$business = get_business(urlencode($_GET['storeId']));
$business = json_decode($business);
$ar = [];
$ar[] = $business;
echo json_encode($ar);
} else {
if (isset($_GET['place'])) {
$location = $_GET['place'];
echo get_results($term, $location);
} else {
echo get_results($term, $location);
}
}
break;
case 'POST':
break;
case 'DELETE':
break;
}
function build_result($array, $pager)
{
//define some vars
$result = $array['search']['results']['subtitle'];
$base = get_base($array['search']['base']);
$time = get_results($array['search']['results']);
//print the content
if (count($result) == 0) {
print "<div align=\"center\"><h2>No result found</h2></div>";
} else {
?>
<table width="55%" style="border-collapse:collapse;" border="1" cellspacing="0" cellpadding="5">
<tr>
<td colspan="9" align="right">Search took <font class="releasename">
<?php
echo $time["searchtime"];
?>
s</font>, Items found <font class="releasename">
<?php
echo $time["itemsfound"];
?>
</font></td>
</tr>
<tr>
<td align="left" colspan="4" width="100%">Movie name</td>
<td nowrap="nowrap" align="center">Added</td>
<td nowrap="nowrap" align="center"><img src="imgs/icon-files.gif" width="12" height="12" alt=" " title="CDs" /></td>
<td nowrap="nowrap" align="center"><img src="imgs/icon-format.gif" width="12" height="13" alt=" " title="Format" /></td>
<td nowrap="nowrap" align="center"><img src="imgs/icon-upper.gif" width="15" height="17" alt=" " title="Uploader" /></td>
</tr>
<?php
$count = $time["itemsfound"] == 1 ? 1 : count($result);
for ($i = 0; $i < $count; $i++) {
$movie = $count == 1 ? get_details($result) : get_details($result[$i]);
?>
<tr>
<td align="center" nowrap="nowrap"><img src="flag/<?php
echo $movie["iso639"];
?>
.gif" width="18" height="12" border="0" alt="<?php
echo $movie["language"];
?>
" title="<?php
echo $movie["language"];
?>
" /></td>
<td align="left" colspan="2" width="100%"><a href="<?php
echo $base . $movie["detail"];
?>
" target="_blank">
<?php
echo $movie["movie"];
?>
</a>
<?php
echo $movie["releasename"] ? "<br/><font class=\"releasename\">" . $movie["releasename"] . "</font>" : "";
?>
</td>
<td nowrap="nowrap" align="center"><a href="<?php
echo $base . $movie["download"];
?>
" target="blank"><img src="imgs/icon-download.gif" width="12" height="12" border="0" alt=" " title="download" /></a></td>
<td nowrap="nowrap" align="center"><?php
echo str_replace(" ", "<br/>", $movie["subadddate"]);
?>
</td>
<td nowrap="nowrap" align="center"><?php
echo $movie["files"];
?>
</td>
<td nowrap="nowrap" align="center"><?php
echo $movie["format"];
?>
</td>
<td nowrap="nowrap" align="center"><?php
echo $movie["user"] == "" ? "Unknown" : $movie["user"];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo $time["itemsfound"] > 40 ? "<br/><div align=\"center\">" . pager($time["itemsfound"], $pager) . "</div>" : "";
?>
<?php
}
}
break;
}
}
fclose($fp);
if ($count >= RESULT_LIMIT) {
break;
}
}
}
return $return;
}
if (!empty($_POST) && !empty($_POST['q'])) {
set_time_limit(0);
//不限定脚本执行时间
$q = strip_tags(trim($_POST['q']));
$results = get_results($q);
$count = count($results);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>郴州高职院学生查询</title>
<link rel="stylesheet" type="text/css" href="css/default.css" />
<style type="text/css">
body,td,th{
color: #FFF;
}
a:link{
color: #0C0;
About:
Autor: Raul Perusquia <*****@*****.**>
Created: 23 September 2014 16:10:50 BST, Nottingham, UK
*/
require_once 'common.php';
require_once 'ar_common.php';
if (!isset($_REQUEST['tipo'])) {
$response = array('state' => 405, 'msg' => 'Non acceptable request (t)');
echo json_encode($response);
exit;
}
$tipo = $_REQUEST['tipo'];
switch ($tipo) {
case 'get_results':
$data = prepare_values($_REQUEST, array('fork_key' => array('type' => 'key')));
get_results($data);
break;
case 'list_results':
$data = prepare_values($_REQUEST, array('fork_key' => array('type' => 'key'), 'callback' => array('type' => 'string')));
list_results($data);
break;
default:
$response = array('state' => 404, 'msg' => 'Operation not found');
echo json_encode($response);
}
function list_results($data)
{
global $mysqli;
$fork_key = $data['fork_key'];
$sql = sprintf("select * from `Result Dimension` where `Fork Key`=%d", $fork_key);
$res = $mysqli->query($sql);
$attachment_pro = get_at_pro_index($meta_field->meta_key);
$action[$loc]->meta['_attachments_pro'][$attachment_pro[1]][$attachment_pro[0]] = utf8_encode($meta_field->meta_value);
unset($attachment_pro);
// if the end of the meta_key is numeric, then its an attachments pro key.. this could bite me later..
// step one filter the string to only show numeric
} else {
$action[$loc]->meta[$meta_field->meta_key] = utf8_encode($meta_field->meta_value);
}
}
if ($tags) {
$action[$loc]->tags = clean_result($tags, 'tag');
}
}
}
}
} elseif ($action = get_results($query) && $directive[0] == 'categories') {
$action = clean_result($action, 'slug');
}
if (isset($_GET['stats'])) {
$action['stats'] = sprintf("%.4f", (double) array_sum(explode(' ', microtime())) - $start_time) * 1000 . "ms, using " . round(memory_get_usage() / 1024) . " k / and {$queries} queries ";
}
header('Content-type: application/json; charset=utf-8', true, 200);
echo isset($_GET['embed']) ? 'var wp_api=' . json_encode($action) . ';' : json_encode($action);
}
}
}
function get_at_pro_index($string, $counter = 0)
{
// this is finished when it returns an array with the 'index' and the 'fieldname' for the key value
// give string .. could reduce this to a single tenery operator..
if ($sub_string = substr($string, -1) && is_numeric($sub_string)) {
function process_params()
{
$post_funcs = explode(',', POST_FUNCS);
foreach ($post_funcs as $func) {
if (!GET_EMPTY($func)) {
// Process parametrized functions
switch ($func) {
case 'rate':
update_rating(GET('file'), GET('rate'), SESSION());
break;
// break for file/rate, return for all others
// break for file/rate, return for all others
case 'search':
//move down
//move down
case 'q':
get_results(GET('category'), GET('subcategory'), GET('sort'), GET('q', GET('search', '')), '', GET('order'), GET('commentsearch'));
return;
// default: // do nothing
}
// Process built-in functions
switch ($func . ":" . GET($func)) {
case 'comment:add':
require "./comment_file.php";
return;
case 'content:add':
require "./add_file.php";
return;
case 'content:update':
require "./edit_file.php";
return;
case 'content:delete':
require "./delete_file.php";
return;
case 'account:settings':
require "./user_settings.php";
return;
case 'action:show':
show_file(GET("file"), SESSION());
return;
case 'action:register':
require "./register.php";
return;
case 'action:browse':
// Browsing by category seems is currently only supported "browse" option
if (!GET_EMPTY('category')) {
get_results(GET('category'), GET('subcategory'), GET('sort'), '', '', GET('order'));
return;
} else {
if (!GET_EMPTY('user')) {
get_results(GET('category'), GET('subcategory'), GET('sort'), '', GET('user'), GET('order'));
return;
}
}
// default: // do nothing
}
}
}
// All else fails, show the "Latest Uploads" page
get_latest();
}
<li> and you can always ask us a question using <a class="headline-link" href="http://shop.nusphere.com/contact_us/index.php "> NuSphere Contact Us Form</a></li>
</ul>
</div>
<!-- Begin System INFO -->
<div class="text_desc">
<h1> What did I find out about your system </h1>
<p>
I assume that you placed me in the root directory of your web server
and on your PhpED machine pointed your browser to me - like this: <i><URL of your web site></i>/dbg-wizard.php
</p>
<p>
I see that:
<ul class="plain">
<?php
get_results($rslt, $notices, $env, $dbg_instructions, $proj_settings);
foreach ($rslt as $value) {
$cap = $value['caption'];
echo "<li>{$cap} " . print_value($value) . "</li>\n";
}
?>
</ul>
<?php
$i = 1;
foreach ($notices as $value) {
echo "<font color='red'><strong>{$i}. </strong>{$value}</font><br>\n";
$i++;
}
if ($env['platform_errmsg']) {
echo "<font color='red'><strong>{$i}. </strong>{$env['platform_errmsg']}</font><br>\n";
echo "Please consult with <a href='http://www.nusphere.com/products/debugging_php.htm'>this table</a> regarding supported platforms.";
/**
* Get data as CSV file
*
* @param string $db_name
* @param integer $version
*
* @return string data
*/
public function getCsvData($db_name = '', $version = '', $tmpFile = '')
{
if (!$db_name || !$version) {
return false;
}
mb_internal_encoding('UTF-8');
// component path for "com_dataviewer"
$dv_com_path = PATH_CORE . DS . 'components' . DS . 'com_dataviewer';
require_once $dv_com_path . DS . 'dv_config.php';
require_once $dv_com_path . DS . 'lib' . DS . 'db.php';
require_once $dv_com_path . DS . 'modes' . DS . 'mode_dsl.php';
require_once $dv_com_path . DS . 'filter' . DS . 'csv.php';
$dv_conf = get_conf(NULL);
$dd = get_dd(NULL, $db_name, $version);
$dd['serverside'] = false;
$sql = query_gen($dd);
$result = get_results($sql, $dd);
ob_start();
filter($result, $dd, true);
$csv = ob_get_contents();
ob_end_clean();
if ($csv && $tmpFile) {
$handle = fopen($tmpFile, 'w');
fwrite($handle, $csv);
fclose($handle);
return true;
}
return $csv;
}
$cmds = array("CMD" => "Put", "PROGRAM" => "blastn", "DATABASE" => "nr", "QUERY" => $gi);
$html = post('http://www.ncbi.nlm.nih.gov/blast/Blast.cgi', $cmds);
//echo $html;
$rid = '';
$rtoe = 0;
if (preg_match('/^ RID = (?<rid>.*)$/m', $html, $m)) {
$rid = $m['rid'];
}
if (preg_match('/^ RTOE = (?<rtoe>.*)$/m', $html, $m)) {
$rtoe = (int) $m['rtoe'];
}
if ($rid != '') {
echo "Request RID={$rid}\n";
echo "Estimated time to completion={$rtoe}\n";
sleep($rtoe);
$xml = get_results($rid);
file_put_contents('tmp/' . $rid . '.xml', $xml);
echo $xml;
// Convert GBIF XML to Javascript for Google Maps
$xp = new XsltProcessor();
$xsl = new DomDocument();
$xsl->load('blast2fasta.xsl');
$xp->importStylesheet($xsl);
$dom = new DOMDocument();
$dom->loadXML($xml);
$xpath = new DOMXPath($dom);
$fasta = $xp->transformToXML($dom);
echo $fasta;
file_put_contents('tmp/' . $rid . '.fas', $fasta);
}
}
function view($dd = false)
{
global $com_name, $html_path, $dv_conf;
$name = $dd['dv_id'];
$document = App::get('document');
dv_add_script('util.js');
/* jQuery */
dv_add_script('jquery.js');
/* Bootstrap */
dv_add_script('bootstrap/bootstrap.js');
dv_add_css('bootstrap/css/bootstrap.css');
/* jQuery-UI */
dv_add_script('jquery-ui/jquery-ui.min.js');
dv_add_css('jquery-ui/smoothness/jquery-ui.min.css');
dv_add_css('font-awesome/css/font-awesome.css');
dv_add_script('excanvas.js');
dv_add_script('jquery-datatables/jquery.dataTables.min.js');
dv_add_css('jquery-datatables/css/jquery.dataTables_themeroller.css');
dv_add_css('jquery-datatables/css/jquery.dataTables_dv.css');
dv_add_script('datatables.plugins.js');
dv_add_script('jqplot/jquery.jqplot.min.js');
dv_add_script('jqplot/plugins.dev');
dv_add_css('jqplot/jquery.jqplot.css');
dv_add_script('spreadsheet.js');
dv_add_css('spreadsheet.css');
dv_add_script('dv-spreadsheet-charts.js');
dv_add_script('dv-spreadsheet-charts-dl.js');
dv_add_script('dv_custom_views.js');
dv_add_css('dv_custom_views.css');
dv_add_script('jquery.lazyload.min.js');
if (isset($dd['show_maps'])) {
dv_add_script('/leaflet/leaflet.js');
dv_add_css('/leaflet/leaflet.css');
dv_add_script('dv_maps.js');
}
dv_add_script('jquery.dv.js');
$dv_conf['settings']['view']['id'] = $dd['dv_id'];
$dv_conf['settings']['view']['type'] = 'spreadsheet';
$dv_conf['settings']['data_url'] = "index.php?option=com_{$com_name}&task=data&db=" . $dd['db_id']['id'] . '&dv=' . $dd['dv_id'];
$dv_conf['settings']['view_url'] = "/dataviewer/view/{$dd['db_id']['id']}/{$dd['dv_id']}/";
// Get the list of IDs if any
$rec_ids = Request::getVar('id', '');
if ($rec_ids != '') {
$dv_conf['settings']['data_url'] .= '&id=' . htmlentities($rec_ids);
$dv_conf['settings']['view_url'] .= '?id=' . htmlentities($rec_ids);
} else {
$dv_conf['settings']['view_url'] .= '?dv_first=1';
}
// Version
$version = isset($dd['version']) ? "&v={$dd['version']}" : '';
$dv_conf['settings']['data_url'] .= $version;
$dv_conf['settings']['view_url'] .= $version;
if ($dd) {
$dv_conf['settings']['show_filter_options'] = isset($dd['filter_options']) ? $dd['filter_options'] : true;
$custom_field_url = '';
$custom_field = Request::getVar('custom_field', false);
if ($custom_field) {
$custom_field_url = '&custom_field=' . $custom_field;
}
// Custom views
$custom_view = Request::getVar('custom_view', false);
$custom_view_url = '';
if ($custom_field) {
$custom_view_url = '&custom_view=' . $custom_field;
}
// overrides
$dv_conf['settings']['limit'] = isset($dd['display_limit']) ? $dd['display_limit'] : $dv_conf['settings']['limit'];
$dv_conf['settings']['hide_data'] = isset($dd['hide_data']);
$dv_conf['settings']['serverside'] = isset($dd['serverside']) && $dd['serverside'] ? true : false;
if (!isset($dd['customizer']) && isset($dv_conf['customizer'])) {
$dd['customizer'] = $dv_conf['customizer'];
}
if (isset($dd['customizer']) && $dd['customizer'] === false) {
unset($dd['customizer']);
}
$dv_conf['settings']['serverside'] = isset($dd['serverside']) && $dd['serverside'] ? true : false;
$sql = query_gen($dd);
$res = get_results($sql, $dd);
// Customizer View
$hide_str = '';
$group_by = '';
$show_customizer = true;
if (isset($dd['customizer'])) {
if (isset($dd['customizer']['show_table']) && !$dd['customizer']['show_table']) {
$hide_str = 'display: none;';
}
if (isset($dd['customizer']['show_customizer']) && !$dd['customizer']['show_customizer']) {
$show_customizer = false;
}
if (isset($dd['group_by'])) {
$arr = explode(',', $dd['group_by']);
foreach ($arr as $a) {
$a = trim($a);
$lbl = isset($dd['cols'][$a]['label']) ? $dd['cols'][$a]['label'] : $a;
$group_by .= '<div class="dv_customizer_group_by_item_div" style="padding: 3px; margin: 5px; border: 1px #EEE solid;"><input type="checkbox" checked="checked" class="dv_customizer_group_by_item" value="' . $a . '" /> <label style="cursor: pointer;">' . str_replace('<br />', ' ', $lbl) . '</label></div>';
}
}
}
$f_data = filter($res, $dd);
$d_arr = json_decode($f_data, true);
if (isset($dd['show_maps'])) {
$document->addScript('//maps.google.com/maps/api/js?sensor=false');
}
$help_file = false;
if (isset($dv_conf['help_file_base_path'])) {
$help_file = $dv_conf['help_file_base_path'] . $name . '/' . $name . '-help.html';
if (!file_exists(JPATH_BASE . $help_file)) {
$help_file = false;
}
}
$return = '';
if (isset($dd['return']) && isset($dd['return']['raw'])) {
$return = $dd['return']['raw'];
} elseif (isset($dd['return'])) {
$return = '<span id="dv_return_link" style="font-size: 1.1em; margin-left: 10px; padding-top: 12px;"><a href="' . $dd['return']['url'] . '"><strong>' . $dd['return']['label'] . '</strong></a></span>';
}
// Filtered Views
$filter = Request::getVar('filter', false);
$filted_view = array();
$filted_view_str = '';
if ($filter !== false) {
$dv_conf['settings']['data_url'] .= '&filter=' . $filter;
$dv_conf['settings']['filters']['fv_vals'] = $filter;
$ff = explode('||', $filter);
foreach ($ff as $f) {
$f = explode('|', $f);
$filted_view[$f[0]] = $f[1];
}
}
?>
<a name="dv_top"></a>
<div id="dv-spreadsheet">
<?php
if (!Request::getVar('show_table_only', false)) {
?>
<div id="dv_title" style="margin: 0;">
<h2 class="ui-corner-all" style="display: inline-block;">
<i class="icon-table"></i>
<?php
print $dd['title'];
?>
</h2>
<h4 id="dv_return_link_container" style="display: inline-block; margin: 0;"><?php
print $return;
?>
</h4>
</div>
<div id="dv-spreadsheet-toolbar" class="ui-corner-top">
<?php
if (!isset($dd['top_menu']['download']['show']) || $dd['top_menu']['download']['show'] != false) {
?>
<button class="btn btn-mini dv-btn-download" data-format="csv" title="Download Data as a spreadsheet">
<i class="icon-download"> </i >
<span class="lbl">Download</span>
</button>
<?php
}
?>
<?php
if (!isset($dd['top_menu']['fullscreen']['show']) || $dd['top_menu']['fullscreen']['show'] != false) {
?>
<button id="dv-btn-fullscreen" class="btn btn-mini" title="Fullscreen" data-screen-mode=''>
<i class="icon-fullscreen"> </i >
<span class="lbl">Fullscreen</span>
</button>
<?php
}
?>
<?php
if (isset($dd['filters']) && count($dd['filters']) > 0) {
?>
<button id="dv-btn-filters" class="btn btn-mini" title="Filter Dialog">
<i class="icon-filter"> </i >
<span class="lbl">Filter Dialog</span>
</button>
<?php
}
?>
<button id="dv-btn-filter-clear-all" class="btn btn-mini" title="Click this to clear all the column filters and the global search">
<i class="icon-remove-circle"> </i >
<span class="lbl">Clear Filters</span>
</button>
<?php
if (!isset($dd['top_menu']['no_wrap']['show']) || $dd['top_menu']['no_wrap']['show'] != false) {
?>
<button id="dv-btn-no-wrap" class="btn btn-mini" title="Disable text wrapping for all cells." data-current="normal">
<i class="icon-text-width"> </i >
<span class="lbl">No-Wrap</span>
</button>
<?php
}
?>
<?php
if (isset($dd['custom_charts']) || isset($dd['charts_list'])) {
?>
<button id="dv-spreadsheet-charts" class="btn btn-mini" title="Display charts">
<i class="icon-bar-chart"> </i >
<span class="lbl">Charts</span>
</button>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<button id="dv-spreadsheet-maps" class="btn btn-mini" title="Display Maps">
<i class="icon-map-marker"></i >
<span class="lbl">Maps</span>
</button>
<?php
}
?>
<?php
if (isset($dd['customizer'])) {
?>
<button id="dv-customizer-btn" class="btn btn-mini" title="Enables users to select a sub-set of columns to view.">
<i class="icon-edit"> </i >
<span class="lbl">Customize DataView</span>
</button>
<?php
}
?>
</div>
<div style="display: none;">
<span id="dv_top_toolbar" class="ui-corner-top" style="padding: 3px 5px 3px 3px; margin: 0; border-style: inset; border-bottom-width: 0px;">
<?php
if ($help_file) {
?>
<button id="dv_show_help">Help</button>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<input type="checkbox" id="dv_maps" class="dv_panel_btn" /><label for="dv_maps">Map</label>
<?php
}
?>
<?php
if (isset($dd['customizer']) && $show_customizer) {
?>
<input type="checkbox" id="" class="dv_panel_btn" /><label for="dv-customizer-btn"></label>
<?php
} elseif (isset($dd['customizer'])) {
?>
<input type="checkbox" id="dv-customizer-btn" class="dv_panel_btn" /><label for="dv-customizer-btn">Customize View</label>
<?php
}
?>
</span>
</div>
<?php
if (isset($dd['custom_charts']) || isset($dd['charts_list'])) {
?>
<div id="dv_charts_panel" style="display: none; clear: both; width: 860px; height: 380px; padding: 5px 10px 10px 5px; margin-top: 0; border: 1px solid #DDD; background: #EEE;" class="ui-corner-bottom dv_top_pannel">
<button id="dv_pdcharts_download_btn" class="btn btn-mini btn-success" title="Download chart as an image" style="float: right; z-index: 1; margin: 3px;">
<i class="icon-download"> </i >
<span class="lbl">Download Chart</span>
</button>
<button id="dv_pdcharts_draw_btn" class="btn btn-mini btn-info" title="Reload charts" style="float: right; z-index: 1; margin: 3px;">
<i class="icon-repeat"> </i >
<span class="lbl">Reload</span>
</button>
<div style="float:left; height: 380px; width: 245px;">
<div id="dv_charts_control_panel" style="padding: 0 5px; ">
<?php
if (isset($dd['charts_list'])) {
?>
<select id="dv_chart_name" style="width: 100%;">
<?php
$pd_id = 0;
foreach ($dd['charts_list'] as $cl) {
?>
<option value="<?php
print $pd_id;
?>
"><?php
print $cl['title'];
?>
</option>
<?php
$pd_id++;
}
?>
</select>
<div id="dv_chart_desc" class=" ui-widget-content ui-corner-all" style="margin-top: 10px; font-size: 0.9em; border-style: inset; padding: 2px; overflow: auto; height: 340px;"></div>
<?php
}
?>
</div>
</div>
<div id="dv_charts_preview_chart" style="height:100%; width:auto; margin-left: 248px;" class="ui-widget-content ui-corner-all">
</div>
</div>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<div id="dv_maps_panel" style="position: relative; display: none; clear: both; width: 800px; height: 300px; padding: 3px 5px 3px 5px; margin-top: 0;" class="ui-widget ui-widget-header ui-corner-bottom dv_top_pannel">
<button class="btn btn-inverse btn-mini" title="Click here to reload the map" id="dv_map_reload" style="float: left;">
<i class="icon-refresh"></i > Reload Map
</button>
<div style="float: right;">
<button data-format="kml" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in KML format">
<i class="icon-download"></i > KML
</button>
<button data-format="kmz" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in KMZ format">
<i class="icon-download"></i > KMZ
</button>
<button data-format="shp" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in SHP format">
<i class="icon-download"></i > SHP
</button>
</div>
<div id="dv_maps_canvas" style="position: absolute; top: 30px; bottom: 8px; left: 5px; right: 8px;" class="ui-widget-content ui-corner-all"></div>
</div>
<?php
}
?>
<?php
if (isset($dd['customizer'])) {
?>
<?php
$full_list = '';
$selected = '';
foreach ($dd['cols'] as $id => $prop) {
if (!isset($prop['hide']) || isset($prop['hide']) && $prop['hide'] != 'hide') {
if (!isset($prop['label'])) {
$prop['label'] = $id;
}
$col_label = str_replace('<br />', ' ', $prop['label']);
$col_label = str_replace('<hr />', ' / ', $col_label);
if (isset($prop['units']) && $prop['units'] != '') {
$col_label = $col_label . ' <small>[' . $prop['units'] . ']</small>';
} elseif (isset($prop['unit']) && $prop['unit'] != '') {
$col_label = $col_label . ' <small>[' . $prop['unit'] . ']</small>';
}
if (isset($dd['customizer']['selected']) && in_array($id, $dd['customizer']['selected'])) {
$first_col = true;
$selected .= '<li data-dv-id="' . $id . '">' . $col_label . '</li>';
} else {
$full_list .= '<li data-dv-id="' . $id . '">' . $col_label . '</li>';
}
}
}
?>
<div id="dv_customizer_panel" style="display: none; clear: both; padding: 5px 10px 10px 5px; margin-top: 0;" class="ui-widget ui-widget-header ui-corner-bottom dv_top_pannel">
<div id="dv_customizer_content" style="height:100%; width:auto;" class="ui-widget-content ui-corner-all">
<div id="dv_customizer_group_by" title="Customizer Group Rows" style="display: none; width: 500px; height: 350px;">
<p>You can use this option to group rows of the views by certain fields to reduce duplicate rows</p>
<div id="dv_customizer_group_by_list"><?php
print $group_by;
?>
</div>
</div>
<p id="dv_customizer_title_container" style="padding-left: 10px;">
New Title: <input id="dv_customizer_view_title" value="<?php
print $dd['title'];
?>
" type="text" style="width: 550px;" />
<input id="dv_customizer_group_by_btn" data-view-url="<?php
print $dv_conf['settings']['view_url'];
?>
" value="Group By [Reduce Duplicates]" type="button" style="display: none; padding: 2px;" />
<input id="dv_customizer_launch_view_btn" data-view-url="<?php
print $dv_conf['settings']['view_url'];
?>
" value="Launch Custom View" type="button" style="display: none; padding: 2px;" />
</p>
<table border="0">
<tr id="dv_customizer_lists_top">
<td style="width: 400px;">Full Columns List</td>
<td style="width: 400px;">Custom List</td>
</tr>
<tr>
<td>
<div class="dv_customizer_lists" style="overflow: auto;">
<ul id="dv_customizer_full_list" class="dv_customizer_col_lists">
<?php
print $full_list;
?>
</ul>
</div>
</td>
<td>
<div class="dv_customizer_lists" style="overflow: auto;">
<ul id="dv_customizer_selected" class="dv_customizer_col_lists">
<?php
print $selected;
?>
</ul>
</div>
</td>
</tr>
</table>
</div>
</div>
<?php
}
?>
<div id="more_information" style="display: none; min-width: 300px;"></div>
<?php
if ($help_file) {
?>
<div id="dv_help_dialog" style="display: none;">
<iframe src="<?php
print $help_file;
?>
" id="modalIframeId" width="100%" height="100%" marginWidth="0" marginHeight="0" frameBorder="0" scrolling="auto" title="Help">IFRAMES not supported by the browser</iframe>
</div>
</div>
<?php
}
?>
<?php
}
//Table Only
?>
<div id="dv-spreadsheet-container" style="margin: 0px; padding; 0px; <?php
print $hide_str;
?>
">
<table id="dv-spreadsheet-tbl" style="margin-top: 0;">
<?php
print '<thead></thead><tfoot><tr>';
$colid = 0;
foreach ($dd['cols'] as $id => $conf) {
if (!isset($conf['hide'])) {
$label = isset($conf['label']) ? $conf['label'] : $id;
$label = str_replace('<br />', ' ', $label);
$label = html_entity_decode(strip_tags($label), ENT_QUOTES, 'UTF-8');
$title = '';
$filter_msg = '';
if ($dv_conf['settings']['serverside']) {
$filter_msg = " \n\nThe dropdown list only shows a limited number of available options. \n\nIf you don't see what you want on the list, please enter a filter text in the text box and then press Enter to bring up more results to match your text.";
} else {
$filter_msg = "\t\n\nClick on the search box to list all the entries in the column";
}
if (isset($conf['filter_hint'])) {
$filter_hint = $conf['filter_hint'];
} else {
if ($d_arr['field_types'][$id] == 'number' || $d_arr['field_types'][$id] == 'numrange') {
$filter_hint = "Enter a number to filter this column by.";
$filter_hint .= " \n\nFollowing filter options are also supported,";
$filter_hint .= "\t\nRange filtering - ( e.g. 15.7 to 25 )";
$filter_hint .= "\t\nLess than, greater than ( e.g. <100 ), (e.g. >25)";
$filter_hint .= "\t\nLess than or equal, greater than or equal ( e.g. <=-12.5 ), (e.g. >=0.3)";
$filter_hint .= "\t\nEqual, not equal and ignore pattern ( e.g. =-2.55 ), ( e.g. !=-2.55 ), ( e.g. !55 )";
} elseif ($d_arr['field_types'][$id] == 'datetime') {
$filter_hint = "Enter a date to filter this column by.";
$filter_hint .= "\t\nRange filtering - ( e.g. 2011-01-25 to 2011-03-25 )";
$filter_hint .= "\t\nLess than, greater than ( e.g. <2011-03-25 ), (e.g. >2011-01-25)";
$filter_hint .= "\t\nLess than or equal, greater than or equal ( e.g. <=2011-03-25 ), (e.g. >=2010-03-25)";
$filter_hint .= "\t\nEqual, not equal and ignore pattern ( e.g. =2009-01-17 ), ( e.g. !=2009-01-17 ), ( e.g. !2009-01 )";
} else {
$filter_hint = "Enter a word or a phrase to filter this column by.";
$filter_hint .= " \n\nFollowing filter options are also supported,";
$filter_hint .= "\t\nExact matches, use '=' ( e.g. =keyword)";
$filter_hint .= "\t\nTo ignore a specific word, use '!=' ( e.g. !=keyword)";
$filter_hint .= "\t\nTo ignore a pattern, use '!' ( e.g. !keyword )";
}
}
$title = $filter_hint . $filter_msg;
if (isset($conf['type']) && $conf['type'] == 'image') {
print '<th><input title="' . $title . '" type="text" placeholder="' . $label . '" disabled=disabled /></th>';
} elseif (isset($filted_view[$id])) {
print '<th><input type="text" placeholder="' . $filted_view[$id] . '" disabled=disabled style="background: yellow;" /></th>';
} else {
print '<th><input title="' . $title . '" type="text" placeholder="' . $label . '" class="search_init" style="background: #FFF;" /><span class="dv-col-clear-filter" style="margin-left: -15px; color: #FFF; cursor: pointer;"><i class="icon-remove-sign"></i></span></th>';
}
}
$colid++;
}
print '</tr></tfoot>';
?>
</table>
</div>
<?php
// Filter dialog show/hide parameter
$dv_show_filters = 'false';
$path = explode('/', Request::path());
if (isset($path[5]) && $path[5] == 'filter_dialog') {
$dv_show_filters = 'true';
}
//Legacy support
if (Request::getVar('show_filters', 'false') === 'true') {
$dv_show_filters = 'true';
}
?>
<!-- Start: Dialog boxes -->
<div id="truncated_text_dialog" style="display: none; overflow: auto;" title="Full Text"></div>
<div id="dv_filters_dialog" title="<?php
print $dd['title'];
?>
: Filters">
<div id="dv_filters_tabs">
<ul></ul>
</div>
</div>
<!-- End: Dialog boxes -->
<script>
dv_data = <?php
print $f_data;
?>
;
dv_settings = <?php
print json_encode($dv_conf['settings']);
?>
;
dv_show_filters = <?php
print $dv_show_filters;
?>
;
dv_settings.show_charts = <?php
print Request::getInt('show_chart', 'undefined');
?>
;
dv_show_customizer = <?php
print $show_customizer ? 'true' : 'false';
?>
;
var dv_show_maps = <?php
print Request::getString('show_map', 'undefined');
?>
;
</script>
<form style="display: none;" id="dv-spreadsheet-dl" method="POST"
action="<?php
print $dv_conf['settings']['data_url'];
?>
&nolimit=true<?php
print $custom_view_url . $custom_field_url;
?>
">
</form>
</div>
<?php
}
}
function task_data($db_id)
{
global $dv_conf;
$dd = get_dd($db_id);
if (!authorize($dd)) {
print '<br /><p class="error">Sorry, you are not authorized to view this page.</p>';
return;
}
$filter = strtolower(Request::getVar('type', 'json'));
$file = JPATH_COMPONENT . DS . "filter/{$filter}.php";
if (file_exists($file)) {
require_once $file;
}
if ($dd) {
$link = get_db();
$sql = query_gen($dd);
$res = get_results($sql, $dd);
print filter($res, $dd);
exit(0);
} else {
print print "<p class=\"error\">Invalid Request</p>";
exit(1);
}
}
