RGSS MYSQL

[S S Muu]

I was just reading the forum and then i found this:
http://www.rmxp.org/forums/showthread.php?t=14032

if i understood right that means you can access MySQL from RGSS BUT i could not get it to work...

Help is appreciated!

 

[S S Muu]

B - Bring
U - Up
M - My
P - Post

 

[Chap]

I'd really like to know this, too.

 

[S S Muu]

BUMP

 

[rataime]

I don't see what is wrong with Mr.Mo's post. You just have to remove the ' require "socket"' line, and use goldenaura's socket script (found in Netplay plus, for example).

By the way, using mysql directly in rmxp is a bad idea. A simple packet sniffer would reveal the user/password, allowing the player to change both his variables and other players' variables.

 

[Chap]

Allright, what I did was taking the socket class from NP+, and I've implented it into my project. I did the same with the script of Mr.Mo in that other topic.

What I did next was making a new class, like:

class Test
def main
@db_server = "server24.hosting2go.nl"
    @db_user = "prive"
    @db_password = "prive"
    @db_name = "RMXP"
    @@_mysql = Mysql.new(@db_server,@db_user,@db_password,@db_name)
    @@_mysql.query("INSERT INTO characters VALUES ('hallo');")
end
end

I called that script through a call script event, (@meh = Test.new)...

But nothing happened... Anything wrong? =/

 

[S S Muu]

replace "main" with "initialize"