Graal Forums  

Go Back   Graal Forums > Development Forums > NPC Scripting > Code Gallery
Reload this Page SQL Explorer
FAQ Members List Calendar Today's Posts

Reply
Page 3 of 4 12 3 4
 
Thread Tools Search this Thread Display Modes
  #31  
Old 03-28-2010, 10:48 PM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Quote:
Originally Posted by xAndrewx View Post
Hmm, I seem to be having some problems deleting a row from a table, I used the exact same code as you have posted but it seems to not find the table correctly... any suggestions?
Are you using the table display (right click > delete row) or through a script (or the "Execute SQL" tab)?
__________________
Reply With Quote
  #32  
Old 03-28-2010, 10:52 PM
salesman salesman is offline
Finger lickin' good.
salesman's Avatar
Join Date: Nov 2008
Location: Colorado
Posts: 1,865
salesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud of
Quote:
Originally Posted by xAndrewx View Post
Hmm, I seem to be having some problems deleting a row from a table, I used the exact same code as you have posted but it seems to not find the table correctly... any suggestions?
If you're not getting any errors, and your tables are configured properly, then the list just might not be refreshing.

I don't know if it was intentional or not, but with the newer version it doesn't update the list every time you make a change. I had the same problem thinking it wasn't deleting rows properly but closing the tabs, refreshing, and then reopening showed me that the row was actually deleted.

Edit: Hmm, I just tested and I'm actually having the same problem. Refreshing doesn't help, and the row is not deleted via right-click delete!
Reply With Quote
  #33  
Old 03-28-2010, 11:12 PM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Sorry about that, I've attached a fixed version and I'll get the first post updated soon.

The only changes are the fixes for duplicating and deleting rows.
Attached Files
File Type: txt SQL_Explorer_2_1_1.txt (84.1 KB, 286 views)
__________________
Reply With Quote
  #34  
Old 03-28-2010, 11:13 PM
xAndrewx xAndrewx is offline
Registered User
xAndrewx's Avatar
Join Date: Sep 2004
Posts: 5,260
xAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud of
Ah, so it's not just me *phew

thanks @ Chris, I thought I'd done something wrong

It's an amazing tool, I'd rep+++++++++++++++++++++++++ infinity!!

Works a charm- lovely thank you
__________________
Reply With Quote
  #35  
Old 03-28-2010, 11:50 PM
Switch Switch is offline
o.o
Switch's Avatar
Join Date: Jan 2007
Location: Philadelphia
Posts: 3,038
Switch has a spectacular aura about
Send a message via MSN to Switch
External GUIs look so ugly.
But nice update.
__________________
Oh squiggly line in my eye fluid. I see you lurking there on the peripheral of my vision.
But when I try to look at you, you scurry away.
Are you shy, squiggly line?
Why only when I ignore you, do you return to the center of my eye?
Oh, squiggly line, it's alright, you are forgiven.
Reply With Quote
  #36  
Old 07-23-2011, 06:16 AM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
I'm releasing version 2.2 of SQL Explorer (thanks Tig for updating the original post).



New Features:
  • Added a "Databases" tab that lets you easily view information about the databases you've configured and provides a convenient button to defragment it. The NPC-server will need r databases/*.db for database size to show.
  • Added the ability to select multiple rows (this is currently not fully working on the Mac client, but may work better on other platforms) and right-click to delete multiple rows at a time.
  • The rights system has been removed. Instead, there is a check to make sure the account using SQL explorer is in staff= in server options and has NC. The latter can be disabled, the former cannot.
  • Numbers are now formatted nicely with commas (thanks Jer).

Bugfixes:
  • Now using escapestring2 for user input to prevent quotations and backslahes from being entered incorrectly.
  • Dialog windows only open externally if you have SQL explorer set to external now (before they always opened externally).

Warnings to Upgraders:
The rights system has been removed. SQL Explorer is not meant to be given out as a staff right, which is what the former system was promoting. Now, access is limited to those in staff= in server options and who have the NPC-Control right. The latter can be disabled near the top of the script, but I don't recommend it.

SQL Explorer is no longer tested with Graal v5. If you're still using it, you should consider switching to v6.


Images for the databases tab are downloaded from the Wiki if you don't already have them. This means that, in theory, Stefan could tell when you open SQL Explorer and don't have the images downloaded. If for some reason you want to hide from him, you can download the images yourself and place them in your images folder.

You can find the new version of SQL Explorer here.

As always, suggestions and bug reports are welcome .
__________________
Last edited by cbk1994; 07-23-2011 at 06:58 AM..
Reply With Quote
  #37  
Old 07-23-2011, 06:21 AM
WhiteDragon WhiteDragon is offline
Banned
Join Date: Feb 2007
Posts: 1,002
WhiteDragon is a splendid one to beholdWhiteDragon is a splendid one to beholdWhiteDragon is a splendid one to beholdWhiteDragon is a splendid one to beholdWhiteDragon is a splendid one to behold
Excellent.
Reply With Quote
  #38  
Old 07-23-2011, 08:24 AM
xAndrewx xAndrewx is offline
Registered User
xAndrewx's Avatar
Join Date: Sep 2004
Posts: 5,260
xAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud ofxAndrewx has much to be proud of
Good stuff
__________________
Reply With Quote
  #39  
Old 07-23-2011, 08:44 AM
Tricxta Tricxta is offline
The Muffin Man
Tricxta's Avatar
Join Date: Oct 2010
Location: Australia
Posts: 563
Tricxta is a jewel in the roughTricxta is a jewel in the rough
very nice! rep+
__________________
Quote:
Originally Posted by Crono View Post
No look at it, Stefan is totally trolling Thor. Calling Classic a "playerworld" (something it's not supposed to be) is the ultimate subtle insult to a true fan.

It's genius.
Reply With Quote
  #40  
Old 07-23-2011, 05:12 PM
fatcat123 fatcat123 is offline
Levels Artist
fatcat123's Avatar
Join Date: Aug 2010
Location: Wisconsin
Posts: 70
fatcat123 is an unknown quantity at this point
This is amazing =o
rep++
Reply With Quote
  #41  
Old 08-01-2011, 09:11 AM
Emera Emera is offline
Delterian Hybrid
Emera's Avatar
Join Date: Mar 2011
Location: Newcastle Upon-Tyne
Posts: 1,704
Emera is a jewel in the roughEmera is a jewel in the rough
The link that states the new versions of SQL can always be found at the specified link, is broken and gives me an error when trying to connect.
HTML Code:
Not Found

The requested URL /sqlexplorer/ was not found on this server.

Apache/2.2.19 (Ubuntu) Server at code.graalcenter.org Port 80
If you could fix this, it would be great!
__________________
Reply With Quote
  #42  
Old 08-01-2011, 10:22 AM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Quote:
Originally Posted by Emera View Post
The link that states the new versions of SQL can always be found at the specified link, is broken and gives me an error when trying to connect.
HTML Code:
Not Found

The requested URL /sqlexplorer/ was not found on this server.

Apache/2.2.19 (Ubuntu) Server at code.graalcenter.org Port 80
If you could fix this, it would be great!
My server's down at the moment. You can use this direct link for now.

edit: code.graalcenter.org is back up
__________________
Last edited by cbk1994; 08-01-2011 at 11:45 AM..
Reply With Quote
  #43  
Old 08-01-2011, 05:35 PM
salesman salesman is offline
Finger lickin' good.
salesman's Avatar
Join Date: Nov 2008
Location: Colorado
Posts: 1,865
salesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud of
the database info is off-center
but i still love you
__________________
Reply With Quote
  #44  
Old 11-16-2012, 07:20 AM
Cubical Cubical is offline
Banned
Join Date: Feb 2007
Posts: 1,348
Cubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant future
The raw file link on this no longer works
Reply With Quote
  #45  
Old 11-16-2012, 11:56 PM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Quote:
Originally Posted by Cubical View Post
The raw file link on this no longer works
Sorry, should be fixed now. Bug in my pastebin site.
__________________
Reply With Quote
Reply
Page 3 of 4 12 3 4

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 11:48 AM.

Contact Us - Graal - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Copyright (C) 1998-2019 Toonslab All Rights Reserved.