Trying to set up an online high score database...
Hey, folks!
I'm trying to set up an online high score database for a game. I'm using Jeff Vance's "Easy Online Score" tutorial and an internal test server.
While trying to use his example MMF file, I find I can't connect to my server (while I know I have with other MMF applications). I wonder if this may be because my server is using SQL Server 2005 instead of mySQL (as described in his tutorial).
Would there be a difference in which database application his example would work with?
Thanks for the input!
Most graciously...
RGBreality
Re: Trying to set up an online high score database...
His database application is on his webserver, and I'm not sure but I'd say SQL Server 2005 is not web based?
Re: Trying to set up an online high score database...
Hey, RickyRombo!
I think I understand... While I did change the server URL to point to my internal server, the MMF application cannot access the database because SQL Server 2005 is not Web based (meaning, it cannot be referenced online).
So, can MySQL Server and SQL Server 2005 run on the same computer without interfering with one another?
RGBreality
Re: Trying to set up an online high score database...
MySQL usually runs on a webhost.
See byethost.com for example
Re: Trying to set up an online high score database...
Hey, RickyRombo!
I wonder if I've run into another problem in setting up an online high-score database...
Jeff Vance uses PHP scripting, which is outside the scope of MMF2. It seems I would need to install PHP on my computer which is hosting the database. After reading a few tutorials online on how to do so (then get it set up with Internet Information Services), I've had no success.
I wonder if there are any other ways to set up an online high-score database which don't require PHP scripting? (His example LOOKED easy, but it seems he must have already had PHP installed on the computer which was hosting the SQL database).
(Since I'm doing this for my office, I don't have authorization to invest in a new Web service provider.)
Thank you for your feedback!
Most graciously...
RGBreality
Re: Trying to set up an online high score database...
If you use IIS (the Microsoft Web Server Based), then you can use ASP pages for contacting/parsing/establishing some actions TO the SQL SERVER, i think no?
Re: Trying to set up an online high score database...
You could put something together with the new Lacewing Webserver object. Maybe I (or someone) should make a high score example using that..
Re: Trying to set up an online high score database...
That would be great Jamie.
Marv
Re: Trying to set up an online high score database...
That online score tutorial by DavidN is brilliant! It's what got me interested in SQL.
Re: Trying to set up an online high score database...
Hey, folks!
That indeed would be great! I'm afraid coding ASP.NET is beyond my skill sets, so I wouldn't be able to do it myself. It would be interesting if the Lacewing object had something built into it to do that.
RGBreality
Re: Trying to set up an online high score database...
There's already a Lacewing Webserver Object...
Re: Trying to set up an online high score database...
Hey, LB!
What I meant to say is that it would be cool if that Lacewing Web server object had high scoring capability built into it.
RGBreality
Re: Trying to set up an online high score database...
Then that would defeat the whole purpose of the object... Sure it'd be cool, but not reasonable ;)