AJAX + PHP Maker Plugin

Chat about anything not covered in these forums, but keep it civil!

Post » Thu Oct 02, 2014 3:41 pm

Fimbul wrote:Also, unfortunately, the store still doesn't accept plugins as submissions...

If there's a plugin which allows me to communicate with mysql through C2 event system, I will shove the money to the seller's face no question asked. It would darn great if it has the similar feel of using array!

MP plugin is already usable as the "bridge" from client to server, if only there's another bridge to mysql, that would awesome!

C2_MP_client-->C2_MP_server-->mysql = imagine the possibility! Full feature multiplayer game purely in C2!
B
28
S
8
G
4
Posts: 553
Reputation: 4,924

Post » Thu Oct 02, 2014 3:52 pm

Your sql logic is meant to be server side to prevent security breaches and ppl fuxing with your database , don't throw money at anyone for a feature like this, you'd be putting you and your users at risk.
B
11
S
2
G
1
Posts: 202
Reputation: 1,580

Post » Thu Oct 02, 2014 4:00 pm

Noncentz705 wrote:Your sql logic is meant to be server side to prevent security breaches and ppl fuxing with your database , don't throw money at anyone for a feature like this, you'd be putting you and your users at risk.

You don't think a programmer capable of doing this would just RPC SQL calls from the client, right?

If I were to make something like this, I'd make a plugin with a certain set of actions that made AJAX calls to an API made in PHP. The API would then validate each field and only then execute the proper pre-built queries. This is why I said that you could make a startup to do this, instead of a plugin.
B
36
S
8
G
8
Posts: 532
Reputation: 6,903

Post » Thu Oct 02, 2014 4:33 pm

Noncentz705 wrote:Your sql logic is meant to be server side to prevent security breaches and ppl fuxing with your database , don't throw money at anyone for a feature like this, you'd be putting you and your users at risk.

Yes sql is meant to be on server side and C2 MP plugin is there to be use to make the "bridge", the concept is to create a C2 project as the host and run it in a browser on the server. Well it is a flimsy server but for a small scale game, I think this is acceptable as the code for the host is theoretically unreachable, I dont see any reason for hackers to put effort in screwing up the game for an imaginary profit.

My thought is, to be able to do this, I have to get a VPS at least and run the index.html (call it a lobby host) on a browser through remote connection. The silly setup that I have now is a very small C2 project that keep the highscore on the serverside webstorage. The client send an array.asjson instead of numerical variable, as to prevent cheating, then the lobby host just calculate the score and then send it to mysql on client behalf.

This webstorage data is not visible for me through normal means, so I set the browser to download the file asjson for every hour or every 30 minutes just to get data that I can read. This way I will have a continuous pile up of text/json file which I definitely think is not good, the data should be handled by mysql instead.
B
28
S
8
G
4
Posts: 553
Reputation: 4,924

Post » Thu Oct 02, 2014 4:51 pm

@DuckfaceNinja maybe look at firebase, it seems someone made a plugin for it as well.
B
11
S
2
G
1
Posts: 202
Reputation: 1,580

Post » Thu Oct 02, 2014 5:00 pm

Noncentz705 wrote:@DuckfaceNinja maybe look at firebase, it seems someone made a plugin for it as well.

Thanks for the suggestion! This is one of the situation in which I know what I want, but I don't know what I should be looking for.
B
28
S
8
G
4
Posts: 553
Reputation: 4,924

Post » Thu Oct 02, 2014 5:22 pm

Image ImageImage
B
169
S
50
G
170
Posts: 8,292
Reputation: 108,728

Post » Sat Oct 04, 2014 7:55 pm

newt wrote:https://www.npmjs.org/search?q=sql

Thanks for the link @Newt. Too bad I don't have the necessary skill yet to be able to use them. :(
B
28
S
8
G
4
Posts: 553
Reputation: 4,924

Post » Mon Nov 03, 2014 6:52 am

Noncentz705 wrote:@DuckfaceNinja maybe look at firebase, it seems someone made a plugin for it as well.


Thanks. Firebase is very powerful. It makes no server programming possible!
B
108
S
26
G
268
Posts: 4,456
Reputation: 150,247

Previous

Return to Open Topic

Who is online

Users browsing this forum: No registered users and 15 guests