Server Help :: View topic - <C> ASSS SQL Query Module

Server Help

ASSS Custom Projects - <C> ASSS SQL Query Module

Cheese - Fri Mar 20, 2009 12:50 am
Post subject: <C> ASSS SQL Query Module

The SQL Query Module is simple:
It allows you to make a direct query to the database, basically turning Continuum into a SQL command line tool, which is incredibly useful.
Powers are limited by groupdef.
WARNING: This is powerful with no limits, meaning it can be dangerous in the wrong hands.
Source attached.

Initrd.gz - Mon Mar 23, 2009 7:30 pm
Post subject:

Hmm, I would think a program that lets you run python commands with ?py would have something similar for SQL...

Should be useful anyway.

Cheese - Mon Mar 23, 2009 11:55 pm
Post subject:

not that anyone would want it :D

what im wondering, though, is why asss doesnt simply return a set for queries instead of forcing a whole new function.... :S
would be much easier to use, and could let us put functions with queries inside them in a class...

Dr Brain - Tue Mar 24, 2009 6:27 am
Post subject:

Because the SQL query is asynchronous. You wouldn't want the server to stall for half a second while you check an alias... Everyone would lag out.

D1st0rt - Tue Mar 24, 2009 4:23 pm
Post subject:

Initrd.gz wrote:

Hmm, I would think a program that lets you run python commands with ?py would have something similar for SQL...

Should be useful anyway.

the ?rawquery command sort of does this on the alias table, letting you specify the where clause

Cheese - Tue Sep 22, 2009 3:07 pm
Post subject:

Update:
I might add that you can control these powers through your database user permissions, as this can change anything the zone is allowed to, as well as through groupdef limits...

Cheese - Tue Feb 23, 2010 2:47 am
Post subject:

recompiled for asss version 1.5

Cheese - Tue Apr 20, 2010 3:36 pm
Post subject:

known bugs:
will crash zone due to buffer overflow if response is longer than 256 chars.

will release fix soon...

Cheese - Fri Apr 23, 2010 8:47 pm
Post subject:

fix released.
module cleaned up.
files updated.