iframe-proxy | Sunbelt Computer Software

43 lines (32 loc) · 1.69 KB

require_once("config.php");
$table = "(SELECT id, quest_abandon_time, quest_complete_time FROM " . $mysql_characters . ".quest_tracker) AS t1 ";
$table .= "JOIN (SELECT ID, LogTitle FROM " . $mysql_world . ".quest_template) AS t2 ";
$table .= "ON t1.id = t2.ID ";
$group_by = " GROUP BY t1.id ";
$primaryKey = 't1.id';
$columns = array(
    array( 'db' => 't1.id as id', 'name' => 'id', 'where' => 't1.id', 'dt' => 0 ),
    array( 'db' => 't2.LogTitle as title', 'name' => 'title', 'where' => 't2.LogTitle',  'dt' => 1,
		'formatter' => function( $data, $row ) {
            return '<a href="' . quest_url . $row['id'] . '" target="_blank">' . $row['title'] . '</a>';
        } ),
    array( 'db' => 'COUNT(t1.quest_abandon_time) AS abandoned_times', 'name' => 'abandoned_times', 'where' => '',   'dt' => 2 ),
    array( 'db' => 'COUNT(t1.quest_complete_time) AS completed_times', 'name' => 'completed_times', 'where' => '',     'dt' => 3 ),
    array( 'db' => 'MAX(t1.quest_abandon_time) AS last_abandoned', 'name' => 'last_abandoned', 'where' => 't1.quest_abandon_time',     'dt' => 4 ),
    array( 'db' => 'MAX(t1.quest_complete_time) AS last_completed', 'name' => 'last_completed', 'where' => 't1.quest_complete_time',     'dt' => 5)
$sql_details = array(
    'user' => $mysql_username,
    'pass' => $mysql_password,
    'db'   => $mysql_world,
    'host' => $mysql_host
$extra_where = '';
if (isset($_GET['abandoned_only']) && $_GET['abandoned_only'] == 1) {
    $extra_where = 'COUNT(t1.quest_abandon_time) > 0 AND COUNT(t1.quest_complete_time) = 0';
require( 'ssp.class.php' );
echo json_encode(
    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns, $group_by, $extra_where)

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

server_processing.php

Latest commit

History

server_processing.php

File metadata and controls