Server Help Forum Index Server Help
Community forums for Subgame, ASSS, and bots
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   StatisticsStatistics   RegisterRegister 
 ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin (SSL) 

Server Help | ASSS Wiki (0) | Shanky.com
<C> ASSS SQL Query Module

 
Post new topic   Reply to topic Printable version
 View previous topic  <perl> ChatnetBouncer Post :: Post <c> Small module to help testing...  View next topic  
Author Message
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Fri Mar 20, 2009 12:50 am    Post subject: <C> ASSS SQL Query Module Reply to topic Reply with quote

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 62 time(s)


Last edited by Cheese on Fri Apr 23, 2010 8:48 pm, edited 1 time in total
Back to top
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Initrd.gz
Seasoned Helper


Joined: Sep 18 2008
Posts: 134
Location: Over there --->
Offline

PostPosted: Mon Mar 23, 2009 7:30 pm    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Add User to Ignore List AIM Address
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Mon Mar 23, 2009 11:55 pm    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Dr Brain
Flip-flopping like a wind surfer


Age:38
Gender:Gender:Male
Joined: Dec 01 2002
Posts: 3502
Location: Hyperspace
Offline

PostPosted: Tue Mar 24, 2009 6:27 am    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Add User to Ignore List AIM Address Yahoo Messenger MSN Messenger
D1st0rt
Miss Directed Wannabe


Age:36
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Tue Mar 24, 2009 4:23 pm    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Add User to Ignore List Visit posters website
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Tue Sep 22, 2009 3:07 pm    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Tue Feb 23, 2010 2:47 am    Post subject: Reply to topic Reply with quote

recompiled for asss version 1.5



SQL Query Module for v1.5
By Cheese

sql.zip - 11.11 KB
File downloaded or viewed 47 time(s)
Back to top
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Tue Apr 20, 2010 3:36 pm    Post subject: Reply to topic Reply with quote

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

will release fix soon...
Back to top
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Cheese
Wow Cheese is so helpful!


Joined: Mar 18 2007
Posts: 1017
Offline

PostPosted: Fri Apr 23, 2010 8:47 pm    Post subject: Reply to topic Reply with quote

fix released.
module cleaned up.
files updated.
Back to top
View users profile Send private message Add User to Ignore List Visit posters website AIM Address
Display posts from previous:   
Post new topic   Reply to topic    Server Help Forum Index -> ASSS Custom Projects All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
View online users | View Statistics | View Ignored List


Software by php BB © php BB Group
Server Load: 630 page(s) served in previous 5 minutes.

phpBB Created this page in 0.503176 seconds : 36 queries executed (80.6%): GZIP compression disabled