How do i connect my RMXP in a database like Access??

[joaoneto]

Hey guys, i read about to use a Win32Api declaration in the RMXP. Do you guys know if it's possible to connect in a database??

Thanx.

 

[Tohsaka]

It should be, however Win32API is generally used for mouse and keyboard input. It should be possible if you have a rb file that can read the database and call that rb file from RMXP. That's how I do it for SQL. Use a rb file and call it from RMXP to read from the SQL database.

 

[linkz0r]

But in the rb file you need to call Win32API, probably. Ruby is not capable to do it y default, and so the need of using Win32API or requiring new scripts.

BTW João Neto (xD), you could check the Netplay project, i think they´ve implemented a MySQL connection with RMXP, or it´s coming on in the next Netplay. I´m not sure though, the site is down and Me/Mr.Mo haven´t told us anything about ^^

 

[joaoneto]

I picture that if I bring up only one DLL with the connections & functions , I could perform this impossibility actual. I go study a little more above the working of the "Win32API", to see if with oneself that. Regarding Netplay , I am expecting also , as goes be the realization of all be able act a part a small doe Online what really it works.

 

[Mr.Mo]

But in the rb file you need to call Win32API, probably. Ruby is not capable to do it y default, and so the need of using Win32API or requiring new scripts.

BTW João Neto (xD), you could check the Netplay project, i think they´ve implemented a MySQL connection with RMXP, or it´s coming on in the next Netplay. I´m not sure though, the site is down and Me/Mr.Mo haven´t told us anything about ^^

Its coming in the next version and the site is up :p. It easy. I'll post the needed code when I get home.

 

[Me(tm)]

Ruby (not rgss) has build in mysql functions and gems to allow further acces.
Teh website is back up btw.

 

[Mr.Mo]

[No message]

 

[joaoneto]

Mr. Mo, you are the MAN. Thanx. But how i use this code?? i have some errors, please explain it.

 

[linkz0r]

You should also require the Socket library, as i can see there, or it won´t work.

 

[joaoneto]

Very cool. I'm Trying.

 

[Me(tm)]

You should also require the Socket library, as i can see there, or it won´t work.

Tue, plus this is a version for 4.0 or lower, to have it work with 5.x.x please install the gem.

 

[joaoneto]

What's GEM ??

 

[linkz0r]

Ruby Gems is a Package Manager for Ruby, and the libraries you download (the packages) are called gems. By default it comes with several Windows Pack installations, and if not you may download it and install. It´s cool, you can open the command shell and download new libraries from there just because of gems! xD It also adds some information about all the components you have installed in Ruby. But i guess the default installation still comes with the Socket class, as well as with many others like yaml, tcl/tk and more...

 

[Me(tm)]

Yes. The default coms with alot of socket type classes. You could look the folder up in your ruby directory. But yo will need the gem if you want 5.0 MySQL.

Either way, what are you trying to do, and the topic should be resolved now as the answer's yes.

 

[joaoneto]

Me and Mr.Mo, I'm really thanx for you. The Script of MySQL in the Netplay is a very usefull. Thanx.

 

[Chap]

Can someone please make me a demo? '^_^ I don't get it running..