RMMV SQL Database Connection (Help)

Pharonix

Shadow Walker
Veteran
Joined
Apr 22, 2012
Messages
764
Reaction score
357
First Language
English
Primarily Uses
RMMV
Okay, First things First:

I have had trouble finding answers for this.


What I have

Node.js server running - Able to connect to local SQL server. Able to Run Select Insert and other queries.
SQL Server 2012 - I have SQL server 2012 running and can successfully retrieve and manipulate the data through node.js
Windows Server 2016 - I have a test server running with Server 2016 that I can successfully run the game on.

If it helps, I am able to get all 3 of this running on 1 Server. Server has 4 cores and 12 gb ram, I plan to allocate 4gb to SQL.
-------

What I need

A way for the game running on the 2016 server to run commands through node.

-------

I plan to keep this simple right now.

I want a bulletin board that pulls a random line from a table in a sql database.
After viewing the text, the player can choose to input a message of their own.
This adds it to the database with th


Table setup:

2 columns (plan on making it three):
ID
Text

-add later: Player Name

ID is numeric and always increments when a new line is inserted.
I plan to run a select statement, and return random text (Later Player Name)


For right now I just need help getting the game setup (Or just random javascript code I can run) so that this bulletin board can run the select statement to pull the text.

Please let me know if you need me to explain anything further in depth.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Latest Threads

Latest Posts

Latest Profile Posts

How many parameters is 'too many'??
Yay, now back in action Happy Christmas time, coming back!






Back in action to develop the indie game that has been long overdue... Final Fallacy. A game that keeps on giving! The development never ends as the developer thinks to be the smart cookie by coming back and beginning by saying... "Oh bother, this indie game has been long overdue..." How could one resist such? No-one c
So I was playing with filters and this looked interesting...

Versus the normal look...

Kind of gives a very different feel. :LZSexcite:
To whom ever person or persons who re-did the DS/DS+ asset packs for MV (as in, they are all 48x48, and not just x2 the pixel scale) .... THANK-YOU!!!!!!!!! XwwwwX

Forum statistics

Threads
105,847
Messages
1,016,972
Members
137,561
Latest member
JaCrispy85
Top