Author Topic: is it possible to connect blockland/vce to ms sql database? if so, how? (Read 1795 times)

DANBOII96 · October 17, 2012, 05:50:56 PM

I have just ordered a vpn ms server and I'm wondering if its possible to connect blockland or rather vce to a ms sql server. This would make saving items and client variables more reliable as it would be saved in a table so even if the games server wen't down the clients current data would still be on a seperate table, it would then be easy to keep a record of players who have joined, I't would also allow a website to be made where players can login and view their stats.

Can anyone help me with this?

Ad Bot · Advertisement

Kalphiter · October 17, 2012, 05:54:49 PM

I suggest using an API because interfacing MySQL's protocol with TS is too much work.

Kalphiter · October 17, 2012, 05:55:13 PM

Quote from: Kalphiter on October 17, 2012, 05:54:49 PM

I suggest using an API because interfacing MySQL's protocol with TS is too much work.

Use PHP or whatever on your website to interface with the DB and your server.

DANBOII96 · October 17, 2012, 05:57:35 PM

What about if you had the variables go to an application and then to an sql server and back again?

Kalphiter · October 17, 2012, 06:31:47 PM

That's what I was talking about, PHP and many languages have libraries for MySQL, you have no need to make one.

DANBOII96 · October 17, 2012, 06:40:39 PM

How would you go about this though, do you have any code that does this that I mind taking a look at, I know nothing of torque script and as for asp and php I know how to write data to database and draw data from a database but I wouldn't know how to go about this, If you can't be bothered or don't want to for what ever reason then that's alright I really don't mind.

Kalphiter · October 17, 2012, 06:45:22 PM

Torque is going to post and get data from PHP scripts you setup.

DANBOII96 · October 17, 2012, 06:50:06 PM

Ok, Is it possible to get this data and post this data using visual basic?

Kalphiter · October 17, 2012, 07:20:37 PM

You probably shouldn't do it that way because using a programming language designed for the web is better.

YayFun · October 18, 2012, 04:26:26 AM

Addons would be much better if Badspot added mysql support.

Chrono · October 18, 2012, 09:29:17 AM

Quote from: YayFun on October 18, 2012, 04:26:26 AM

Addons would be much better if Badspot added mysql support.

This.

Ephialtes · October 18, 2012, 09:33:23 AM

I think it's a bit of a pain in the ass to add to the engine. I know there's a GG resource to do it but if I recall right it was really really bad.

aludane · October 18, 2012, 12:07:06 PM

Ruby might be a good option. You'd have to build a TCP interface and download some decent ruby-gems that deal with database management but that's what I would do. It provides support for a number of database packages.

Brian Smithers · October 18, 2012, 12:32:05 PM

Quote from: Ephialtes on October 18, 2012, 09:33:23 AM

I think it's a bit of a pain in the ass to add to the engine. I know there's a GG resource to do it but if I recall right it was really really bad.

well can't badspot make it really really good :)

Chrono · October 18, 2012, 01:36:51 PM

Quote from: Ephialtes on October 18, 2012, 09:33:23 AM

I think it's a bit of a pain in the ass to add to the engine. I know there's a GG resource to do it but if I recall right it was really really bad.

I'm patient.

Not demanding it or expecting it tomorrow. If he wants to wait till next year to do it, fine. If he's not even going to touch it, fine.

It's one of those things where it's "wow that would be nice to have but i can live without it"

Would be nice though.