<?php /** * Created by PhpStorm. * User: Yu * Date: 2015/4/9 * Time: 23:44 */ require_once "rank_api.php"; echo "DELETE FROM rank;\r\nINSERT INTO rank(id, pre_wealth, cur_wealth, name)\r\n SELECT users.id, users.pre_wealth, users.cur_wealth, users.name FROM users\r\n ORDER BY users.cur_wealth DESC LIMIT 0, 5;\r\nUPDATE rank SET ratio = (rank.cur_wealth - rank.pre_wealth)/rank.pre_wealth WHERE 1;\r\n\r\nDELETE FROM rank_ratio;\r\nINSERT INTO rank_ratio(id, name, ratio, cur_wealth)\r\n SELECT users.id, users.name, (users.cur_wealth - users.pre_wealth) / users.pre_wealth AS GRADE, users.cur_wealth FROM users\r\n ORDER BY GRADE DESC LIMIT 0, 5;\r\n"; load_rank_lists(dbConnect());
} function need_refresh($conn) { $res = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM status")); date_default_timezone_set('PRC'); if (time() - strtotime($res['last_refresh']) > 60) { //echo "test:".(time() - strtotime($res['last_refresh'])); return 1; } else { return 0; } } $connection = dbConnect(); if (need_refresh($connection) == 1) { load_market($connection); load_rank_lists($connection); set_last_refresh($connection); } else { } //SHOULD JUMP TO HOME PAGE HERE //TODO $res = mysqli_query($connection, "SELECT name, price, goods_id FROM " . MARKET_TABLE . " WHERE place_id = 3"); $n = mysqli_num_rows($res); $arr = array(); for ($i = 0; $i < $n; $i++) { $row = mysqli_fetch_array($res); $name = $row['name']; $price = $row['price']; $goods_id = $row['goods_id']; $a = array('name' => $name, 'price' => $price, 'goods_id' => $goods_id); array_push($arr, $a);