Author |
Message |
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: 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. _________________ SSC Distension Owner
SSCU Trench Wars Developer
SQL Query Module
By Cheese
sql.zip - 12.31 KB
File downloaded or viewed 65 time(s)
Last edited by Cheese on Fri Apr 23, 2010 8:48 pm, edited 1 time in total |
|
Back to top |
|
|
Initrd.gz Seasoned Helper
Joined: Sep 18 2008 Posts: 134 Location: Over there ---> Offline
|
Posted: 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.
|
|
Back to top |
|
|
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: 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...
|
|
Back to top |
|
|
Dr Brain Flip-flopping like a wind surfer
Age:38 Gender: Joined: Dec 01 2002 Posts: 3502 Location: Hyperspace Offline
|
Posted: 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. _________________ Hyperspace Owner
Smong> so long as 99% deaths feel lame it will always be hyperspace to me
|
|
Back to top |
|
|
D1st0rt Miss Directed Wannabe
Age:36 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: 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 _________________
|
|
Back to top |
|
|
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: 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...
|
|
Back to top |
|
|
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: Tue Feb 23, 2010 2:47 am Post subject: |
|
|
|
|
recompiled for asss version 1.5
SQL Query Module for v1.5
By Cheese
sql.zip - 11.11 KB
File downloaded or viewed 50 time(s)
|
|
Back to top |
|
|
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: 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...
|
|
Back to top |
|
|
Cheese Wow Cheese is so helpful!
Joined: Mar 18 2007 Posts: 1017 Offline
|
Posted: Fri Apr 23, 2010 8:47 pm Post subject: |
|
|
|
|
fix released.
module cleaned up.
files updated.
|
|
Back to top |
|
|
|