Playerworld SQL

Warcaptain · #1 07-11-2006, 06:22 AM

I would REALLLLLLLLLLLLLY like it if you (Stefan) could allow playerworlds to startup a SQL server for the game.

By that I mean a SQL server that allows the server (though serverside scripting and such) to access a mysql database through serverside functions. And would be nice to add a SQL button to the RC so we can load up a nice.. organized SQL viewer

This would be great for us people that want to use a more advanced item system that dont feel like trying to make an adhoc mudlib.

Anyone else with me on this?

Falados · #2 07-11-2006, 06:27 AM

Yes. SQL is just so much better for databases than homebrew solutions

KuJi · #3 07-11-2006, 07:38 AM

I THINK you were able to view SQL of PWS several yrs ago :o (like 6?)

Skyld · #4 07-11-2006, 10:32 AM

Quote:

Originally Posted by KuJi

I THINK you were able to view SQL of PWS several yrs ago :o (like 6?)

He does not mean that; he means each server having a database or so for which can be used to store data using gscript.

KuJi · #5 07-11-2006, 12:47 PM

Quote:

Originally Posted by Skyld

He does not mean that; he means each server having a database or so for which can be used to store data using gscript.

Alternative to the current databases where even /savenpcs 75% of the time dont work? :o

Skyld · #6 07-11-2006, 01:02 PM

Quote:

Originally Posted by KuJi

Alternative to the current databases where even /savenpcs 75% of the time dont work? :o

No. Take this example.

A PHP script can connect to a MySQL server and store/retrieve data. What Warcaptain is suggesting is a way for gscript to be able to do that.

Warcaptain · #7 07-11-2006, 04:33 PM

Exactly

Malinko · #8 07-12-2006, 05:11 AM

So then, Warcaptain can...

TAKE OVER THE WORLD!

*Gasp*

Falados · #9 07-12-2006, 06:09 AM

Not really to take over the world... Mostly just to be able to do away with nasty string-based items systems, avoid the convoluted mudlib, and also to bridge the gap between the gserver and the web [to do cool things like online stats and web-interface server maintenance, etc...]

It just makes sense to do database work in... well... a database =\

KuJi · #10 07-12-2006, 07:43 AM

Ahh, graal script interacting with mysql db's. Would actually be very useful

Warcaptain · #11 07-12-2006, 08:52 AM

Quote:

Originally Posted by KuJi

Ahh, graal script interacting with mysql db's. Would actually be very useful

Look at you, pretending to know stuff.

Anyways, Stefan!! REPLYYy!!

Raeiphon · #12 07-12-2006, 01:01 PM

It'd also mean that if you dont know how to protect SQL databases properly, people like me would have a field day running around and changing things.

KuJi · #13 07-12-2006, 01:10 PM

Quote:

Originally Posted by Warcaptain

Look at you, pretending to know stuff.

Anyways, Stefan!! REPLYYy!!

Actually.. I know enough php to understand what skylds talking about. kthx.

Malinko · #14 07-12-2006, 07:02 PM

Quote:

Originally Posted by Falados

Not really to take over the world... Mostly just to be able to do away with nasty string-based items systems, avoid the convoluted mudlib, and also to bridge the gap between the gserver and the web [to do cool things like online stats and web-interface server maintenance, etc...]

It just makes sense to do database work in... well... a database =\

Man, I read what people in the thread said.

Stop ruining fun of forums.

Warcaptain · #15 07-12-2006, 07:18 PM

It does not neccesarily need to be something accesable by any web browser.. (though that would be real nice for web stuff)

But my biggest need is for having a much easier accesable serverside database.

I doubt you would really be able to crack it unless there was unprotected onActionServersides.. but most of mine are very well protected.

Matt · #16 07-26-2006, 09:01 PM

I support this, it be pretty neat.

Admins · #17 07-27-2006, 12:56 PM

The problem is that before we can add this we need to update all machines installing a more recent version of Linux, and install databases on each machine. May be there should also be special functions for each SQL operation (select, insert, delete, update, replace) to have some way to prevent flooding. Question is also how creation of tables should work, or if there should be generic types of tables (predefined columns), but that would take away some freedom. Eventually creation and modification of table structure should be done via RC.

Skyld · #18 07-27-2006, 01:31 PM

Quote:

Originally Posted by Stefan

The problem is that before we can add this we need to update all machines installing a more recent version of Linux, and install databases on each machine. May be there should also be special functions for each SQL operation (select, insert, delete, update, replace) to have some way to prevent flooding. Question is also how creation of tables should work, or if there should be generic types of tables (predefined columns), but that would take away some freedom. Eventually creation and modification of table structure should be done via RC.

If you made some predefined tables and then allowed modification through a web-based interface and eventually RC, that'd be pretty neat.

KuJi · #19 07-27-2006, 04:33 PM

I am not really reading anything yall are saying, but with this would I be able to access my server directly via mysql? If so, I can add some modifications to my vbulletin and maybe make some feature where you can only create users of your character or something (on login, you can have up to 3 chars)

Hmm.

Falados · #20 08-17-2006, 03:36 AM

If scripts were able to connect to an offsite SQL Server, the need for a strict control system (and consequently, upgrading all the servers) could be avoided, as a temporary solution at least.

That way, people with offsite webservers would be able to utilize an already existing database, and also be able to access and modify the data to do cool things relating to that playerworld's website. (Such as statistics, and character creation, or whatnot)

**MysticalDragon** · #21 08-17-2006, 02:08 PM

Yes this would be a good idea I suggested this to stefan back in the begginning of 2005, mines was a bit different but same concept

Quote:

Originally Posted by Stefan

I have talked with unixmad, we can add such a thing, but only allow communication with the website and database belonging to playerworld graal.net webspace, will need to create one for Unholy Nation. For communicating with websites and databases of other VIP/playerworld websites on graal.net there need to be some configuration tool for deciding which playerworld can access it, so you cannot steal information from other playerworlds or modify the unholy nation guild thing, but if you enable it then you can even share information between servers.

http://forums.graalonline.com/forums...highlight=Hack