Hello to all. Just starting with corona and lua, and already a bit confused.

I want to make a football/soccer manager game, but an online version of it. Storing played games, league tables, cups and etc... I tough about using SQL Lite:
http://developer.anscamobile.com/reference/database

But reading API and forum posts, I can't use update, insert and etc. But in anycase, that wouldn't suite me. What I need is my database on some server, and when the game has been played, that it updates to database on that server.

Can I use network to create such a thing?
http://developer.anscamobile.com/reference/index/network

Or I will be better off using game network?
http://developer.anscamobile.com/reference/index/game-network

Any advice and a starting point would do.
Thx in advance for your replies :)

I can't help with the network side of things, but just a word of warning that you'd need a license to use real player and team names....I believe the FIFA license costs £1m a year.

I'm hoping to write a single-player sports management sim (probably not football, with Football Manager about there isn't much point), but whatever I do will have to have either fictional names or have them slightly mis-spelt :-/

I wish you good luck as there is definitely a gap in the market as most developers are put off by the licensing issue.

I know about licensing issue. Been playing PES/FIFA/CM/FM for 15 years now. I do not intend to use real names, and frankly, I don't need them.

You can't compete with FM and large gaming studios. But online manager could be a way to go, so I'm really gonna try for it :)

This is a great idea for a game and taking a non licensing approach is the right way to think about it. Plenty of game franchises use major sports as a game mechanic and do rather well. The Tecmobowl football(american football) games come to mind. Not to mention a ton of baseball games that create new teams for their games. I know the guys that made Football Manager at SI and their market is mind numbingly huge. Even as I type this workers down the street are building a huge soccer stadium here in Houston Texas.

I can't help you either with the server stuff actually, just throwing my 2cents in. I would imagine setting the game up as a server based platform that can run independently of a server and then plugging that stuff in towards the completion. Or perhaps hook it up to Facebook to login/select/invite friends much like the Zynga mobile games do. That way you can send their data from their own phones and let Facebook take care of the identities. Again, 2cents nothing from experience.

Definitely set it up with a massive localization parser as your user base is truly world wide.

Good luck with your idea/project Mileni, wish you all the success.

Thx for the tips and advices.
I know it's a huge market, but it's a market that is also hard to get thru. But I have (imho) a few great ideas that I personally think might just work out. I have been an admin for one website where we play soccer leagues. From fifa to manager style games.

And playing those games for 15+ years, I really belive that my idea will work out. Only problem is, don't know on what to focus on corona, since I'm newbie here.

That's the whole point of this topic, and hopefully, someone with some networking advices will show up :)

If your talking about update, insert and etc, on a local database you sure can.

I have some SQL Lite code where I create create database, tables, insert update etc..

If your talking about doing something over the web then you should think more about an HTML 5 set of mobile web pages or simply use an XML type webservice to interact with your data to upload / download.

Larry
DoubleSlashDesign.com