mysql - Update my PHP API -

-

firstly i've been told use outdated mysql, , should use mysqli, i'm not entirely sure how migrate over.

also, further explain api shows player stats when search name. reason in background it's querying url/0 , it's making page loading extremely slow.

anyhow here's api.php. give me example of mysqli?

<?php // epicmc cms api  $date1 = new datetime('now'); $date2 = new datetime('12/12/2014');  $difference = $date1->diff($date2)->days;  $link = mysql_connect("localhost", "username", "password"); mysql_select_db("database", $link); if ($_get['task'] == 'total') {     $get_db = 'database';     $result = mysql_query("select * $get_db", $link);      echo '{"task":"total","amount":"';     echo mysql_num_rows($result);     echo '"}'; } elseif ($_get['task'] == 'info') {     $get_player = $_get['player'];     $get_db     = 'simpleauth_players';     $result     = mysql_query("select * $get_db name = '" . mysql_real_escape_string($get_player) . "'", $link);     while ($data = mysql_fetch_array($result)) {         echo '{"task":"view","registered":"';         echo date('m/d/y h:i a', $data['registerdate']);         echo '","verified":"';         echo $data['verified'];         echo '","banned":"';         echo $data['banned'];         echo '","locked":"';         echo $data['locked'];         echo '","theme":"';         echo $data['theme'];         echo '","email":"';         echo $data['email'];         echo '","cover":"';         echo $data['cover'];         echo '","ip":"';         echo $data['lastip'];          echo '","lastlogin":"';         echo date('m/d/y h:i a', $data['logindate']);         echo '","ip":"';         echo $data['lastip'];         echo '"}';     } } elseif ($_get['task'] == 'stats') {     $get_player = $_get['player'];     $get_db     = 'player_stats';     $result     = mysql_query("select * $get_db name = '" . mysql_real_escape_string($get_player) . "'", $link);     while ($data = mysql_fetch_array($result)) {  if($data['skin'] == null){                                   $skin = $data['name'];                                   } else {                                   $skin = $data['skin'];                                   }          echo json_encode(array(             'task' => 'viewstats',             'skin' => $skin,             'deaths' => $data['deaths'],             'kills' => $data['kills'],             'joins' => $data['joins'],             'quits' => $data['quits'],             'kicked' => $data['kicked'],             'places' => $data['places'],             'breaks' => $data['breaks'],             'chats' => $data['chats'],               // ratio             'ratio' => $data['kills'] / $data['deaths']         ));     } } elseif ($_get['task'] == 'login') {     $get_user = $_get['user'];     $get_db   = 'simpleauth_players';     $result   = mysql_query("select * $get_db name = '" . mysql_real_escape_string($get_user) . "'", $link);     while ($data = mysql_fetch_array($result)) {         echo '{"task":"login","password":"';         echo $data['hash'];         echo '","lastip":"';         echo $data['lastip'];         echo '","timestamp":"';         echo $data['logindate'];         echo '"}';     } } else {     echo 'online'; } function hashme($player, $password) {     return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } ?>

basicaly database comes before queries here updated code: 

<?php // epicmc cms api  $date1 = new datetime('now'); $date2 = new datetime('12/12/2014');  $difference = $date1->diff($date2)->days;  $link = mysqli_connect("localhost", "username", "password", "database"); if ($_get['task'] == 'total') {     $get_db = 'database';     $result = mysqli_query($link, "select * $get_db");      echo '{"task":"total","amount":"';     echo mysqli_num_rows($result);     echo '"}'; } elseif ($_get['task'] == 'info') {     $get_player = $_get['player'];     $get_db     = 'simpleauth_players';     $result     = mysqli_query($link, "select * $get_db name = '" . mysqli_real_escape_string($link, $get_player) . "'");     while ($data = mysqli_fetch_array($result)) {         echo '{"task":"view","registered":"';         echo date('m/d/y h:i a', $data['registerdate']);         echo '","verified":"';         echo $data['verified'];         echo '","banned":"';         echo $data['banned'];         echo '","locked":"';         echo $data['locked'];         echo '","theme":"';         echo $data['theme'];         echo '","email":"';         echo $data['email'];         echo '","cover":"';         echo $data['cover'];         echo '","ip":"';         echo $data['lastip'];          echo '","lastlogin":"';         echo date('m/d/y h:i a', $data['logindate']);         echo '","ip":"';         echo $data['lastip'];         echo '"}';     } } elseif ($_get['task'] == 'stats') {     $get_player = $_get['player'];     $get_db     = 'player_stats';     $result     = mysqli_query($link, "select * $get_db name = '" . mysqli_real_escape_string($link, $get_player) . "'");     while ($data = mysqli_fetch_array($result)) {  if($data['skin'] == null){                                   $skin = $data['name'];                                   } else {                                   $skin = $data['skin'];                                   }          echo json_encode(array(             'task' => 'viewstats',             'skin' => $skin,             'deaths' => $data['deaths'],             'kills' => $data['kills'],             'joins' => $data['joins'],             'quits' => $data['quits'],             'kicked' => $data['kicked'],             'places' => $data['places'],             'breaks' => $data['breaks'],             'chats' => $data['chats'],               // ratio             'ratio' => $data['kills'] / $data['deaths']         ));     } } elseif ($_get['task'] == 'login') {     $get_user = $_get['user'];     $get_db   = 'simpleauth_players';     $result   = mysqli_query($link, "select * $get_db name = '" . mysqli_real_escape_string($link, $get_user) . "'");     while ($data = mysqli_fetch_array($result)) {         echo '{"task":"login","password":"';         echo $data['hash'];         echo '","lastip":"';         echo $data['lastip'];         echo '","timestamp":"';         echo $data['logindate'];         echo '"}';     } } else {     echo 'online'; } function hashme($player, $password) {     return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } ?>

Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more