Server side leaderboard get method problem on android devices

Unity Engine
,
1

so i have a small android project that uses a simple server side high-score function, i used the server side highscore sample from the unify community wiki: http://wiki.unity3d.com/index.php?title=Server_Side_Highscores

so the problem basically is this when i run the project on unity itself both the post and get method works, so i can post scores into the server and also grab them and show the top 10 scores from the database using GUIText.

but when i run the project on an actual Android device, i can post scores into the online database but the project can’t seem to display or show the top 10 scores from the database, so post method is working but get method won’t work when running the project from an actual android device

here are two images that show the problem, one image shows the game running on unity itself and it shows all the score and the other image shows the same game running on an actual android device but this time it won’t show the scores at all

project running on an actual android device.
https://www.facebook.com/photo.php?fbid=10200623909991315&set=pcb.531726193562580&type=1&relevant_count=2&ref=nf

project running on unity itself.
https://www.facebook.com/photo.php?fbid=10200623909191295&set=pcb.531726193562580&type=1&relevant_count=1&ref=nf

this is the code for my get method script:

var getScoreUrl = "ewoogaming.x10host.com/display.php";

function Awake()
{
	GetScores();
}

function GetScores()
{
	var hs_get = WWW(getScoreUrl);
	yield hs_get;
	
	if(hs_get.error)
	{
		print("Error getting scores: " + hs_get.error);
	}
	else
	{
		guiText.text = hs_get.text;
	}
}

and this is my display.php also i changed the password and the user and DB name:

<?php
    // Send variables for the MySQL database class.
    $database = mysql_connect('localhost', 'MyUser', 'MyPass') or die('Could not connect: ' . mysql_error());
    mysql_select_db('MyDB') or die('Could not select database');
 
    $query = "SELECT * FROM `scores` ORDER by `score` DESC LIMIT 10";
    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
    $num_results = mysql_num_rows($result);  
 
    for($i = 0; $i < $num_results; $i++)
    {
         $row = mysql_fetch_array($result);
         echo $row['name'] . "\t" . $row['score'] . "\n";
    }
?>

i really don’t know what the problem is, i don’t get any error both from the server and unity, so i really don’t know what is wrong with this, it will work perfectly while running on unity, but when i run it on the android device i can save scores but just can’t seem to display them, so i know it can connect cause i can write on the server the device just can’t read from the server…

2

Did you ever find out the problem?

3

yeah, i actually missed a line of code in my sql coding while creating a table for my dbase

4

With mine I am having a problem where it won’t let me log in unless I am on Wifi. Like it won’t download any files or anything. Would you know what causes that?

5

i’m sorry i’m not getting what you mean, to be clear this problem i encountered is on the mobile side. could you explain more the situation you’re having and i’ll try to help with all the best i can.

6

Mine works perfect on computer. Problem is on Android. I use server with php files for log in and create account and the info is store in a database. everything works perfect if I am on Wifi, but if I am on my data instead, (like if I am driving down a road). It won’t connect with my database. so i can’t create an account or login

7

ok, what hosting site are you using? i’m using x10hosting, what happened on my situation was during the creation of the table if you followed the samples on the unify community wiki, when creatin the table using that sql code i wasn’t able to include the code afer the closing bracket that was the reason why my server would appear on my computer but won’t appear on my android de ice it was the ‘type=isam’ that got me, when i tried doing the same method on a different project this tie iwas able to inckude all the codes it worked, maybe you should try checking on that, i’m fairly new to all of this so i’m not the expert regarding this matter especially on the login/logout of accoun i haven’t yet tacked that part.