i have 0 database experience, but using this to learn, not trying to make a million pound game just something i can learn from.

So maybe i will try to learn MySQL.

Been trawling the forums looking at what is the better option between firebase and mysql but am still confused.

I want a log in system (username/password)

And a database of stats (mostly numbers)

So each user would log in and get their game profile/money/stats (some of this could be locally saved)

Game would be mostly text but players can attack each other whether online or offline therefore i'd need a database of players level/weapon/armour/health etc.. so when a button is clicked it would give a list of players at a certain level, and when attacked their stats would go against the attackers stats.

So basically my question is what would be the better option for storing these stats and retrieving them.

I've played around with RexRainbows firebase plugins, and got a login system working flawlessly but when it came to storing and retrieving player data i couldn't get it to work. so i will spend some time learning one of the two options but wanted a little advice on which would be better suited for my needs.

Thanks in advance.

Yeah sorry i'm pretty bad at explaining things, But that is exactly what i was after!!!!

Thanks a lot

Looking to make an online marketplace where users can buy and sell between themselves.

So if someone buys an item of the market the person selling it would recieve the in game currency.

The game itself will be mostly offline it would be more 'tranactions' that should appear as and when they are done.

For instance. user 1 has bought 100 coal from user 2 so user 2 has recieved 1000 credits for the sale of 1000 coal and the market listing is closed so others cannot buy the same item for the user it was sold from.

Or is user 8 attacked user 5 they would get a notification or attack and credit loss etc...

The game would have a lot of items and player stats which should be live(ish) and players should be able to check each others stats.

Would be mostly text based.

Is a mysql database what i'm looking for?

Been using consructs for years and thought i'd try something new.

I'm pretty useless at explaining things so hope that makes sense :)

Haha I do it all the time, realise the next day what I couldn't see for hours the night before xD

You have the last line of that set to rate of fire too, looks like it should be set to range

Kyatric : i've tried the different preview options and have the same problem with each,

So i have a project open, i click 'debug' which opens the debug preview window, i copy the address and paste it into an incognito browser window and it sticks loading.

This happens with both debug and the normal preview windows.

On start of layout: create object

Have that in a global event sheet and include the event sheet on every layout

Any offers on how to open multiple preview windows?

Seems to only open one up and if I try to copy/paste the link it just sticks loading.

Remote preview is no good to me as it takes too long and cannot use debug

Basically I want to have 2+ debug preview windows open like you can in C2.

Also there is a thread about multiple preview windows in the 'FAQ' but the replies do not work

and event, double click the sprite and under physics go compare velocity and then in the dropdown box there you can set to overall velocity, or whatever you may need.

Sorry I suck at explaning things

1am on a Saturday night my brain is...'elsewhere' xD

You could try setting it so it only applys the impulse if the sprite is moving below a certain speed,

Something like..

[ sprite.physics.overallvelocity < 100 ] Apply impulse 1 at X angle