Yes I have used the scripts produced in the setup program and uploaded them to my public folder. I am not using a folder to contain any of them at the moment, they are just on the root. I will change that once it is working, as I imagine it is rather easier to hack that way.
When I setup the scripts using the program included I had to switch to my sql admin etc and set up the database first. Then I went back and put in the appropriate data. I think the file setup is okay because the PC version is working perfectly. I have Moon Snaker running fine on PC with the online score, just the android one hangs.
It's definitely something odd with the code I think, I have been playing with a snippet posted ages ago by Marco Bruti, and that from initial tests seems to be connecting on the droid. But it seems to have put in several records at once, so will need to look at it more closely, no idea why at the min.
At least I'm getting practise at the web side of things lol. I have made and deleted that database a few times now when it gets a bit too large from my tests.
Perhaps the snippet marco posted would be a better bet?
host$="mysite.com" //no http
sNameData$ = GetCurrentDate() + getdevicename() + GetCurrentTime() //Name to be sent
sScoreData$ = str(random(100,20000)) //Score to be sent
connection=createHTTPConnection()
SetHTTPHost(connection,host$,0 )
httpStatus=GetHTTPFile( connection, "getscores.php","highscore.dat")
while (GetHTTPFileComplete(connection)=0)
httpFileProgressStatus=GetHTTPFileProgress(connection)
sync()
endwhile
oldhiscoreFile=OpenToRead("highscore.dat")
if (getFileSize(oldhiscoreFile)=0)
print("No Internet Connection or Server Unavailable")
sync()
sleep(1000)
exit
endif
`SendHTTPRequest(connection, "/KillThatBandit/ktb_set_hi.php?level="+str(lv)+"&score="+strtime(newscore#,3),"")
GetHTTPFile( connection,"savescores.php", "check.dat", "name=" + sNameData$ + "&score=" + sScoreData$ )
deleteHTTPConnection(connection)
That's pretty much the same as his original, I just remmed out his http commands and put in mine from the earlier snippet. It seems a lot simpler than the original code I posted though, just not tested it much yet.
Perhaps the fact I have used gethttpfile at the end, rather than the remmed line above, has caused the multiple entries?
Edit - Sorted the multiple entry problem out by the looks. So far the code above is working better, now to test it with repeated use and then transfer to the game hopefully!