예제 #1
0
       echo "error 2";
    }
    */
    //reset item.json
    emptyJsonItem();
    //reset livebid.json
    emptyJsonLiveBid();
}
//if item is absent load the next item to item.json
if (readJsonItem('i_id') == null) {
    //load next item info when the result is absent
    $query = "SELECT * FROM `items` WHERE `i_starttime` >= '{$curtime}' ORDER BY `i_starttime` LIMIT 1";
    $res = mysqli_query($link, $query);
    if (mysqli_num_rows($res) > 0) {
        emptyJsonItem();
        exportToJsonItem();
    }
}
//Query for Next Item
$next_sql = "SELECT i_name, i_imgpath, i_starttime FROM items WHERE (i_starttime > '{$curtime}') ORDER BY i_starttime LIMIT 1";
$next_result = mysqli_query($link, $next_sql);
if (!$next_result) {
    echo "unable to connect next_2";
}
if (mysqli_num_rows($next_result) > 0) {
    $next_itemPresent = true;
    $next_row = mysqli_fetch_assoc($next_result);
    $next_i_name = $next_row["i_name"];
    $next_i_imgpath = $next_row["i_imgpath"];
    $next_i_starttime = $next_row["i_starttime"];
}
예제 #2
0
function setitembefore()
{
    emptyJsonItem();
    exportToJsonItem();
}