[BETA] Database Explorer v1.0.1

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Get Involved
princexxx
Registered User
Posts: 82
Joined: Fri May 09, 2008 2:10 pm

Re: [BETA] Database Explorer v1.0.0 Beta

Post by princexxx » Sat Jul 05, 2008 3:00 am

Ok wait for a min.........

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.0 Beta

Post by opalelement » Sat Jul 05, 2008 6:59 pm

New official page: cancelled
Last edited by opalelement on Sun Jul 13, 2008 1:50 pm, edited 1 time in total.

User avatar
david63
Registered User
Posts: 16328
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [BETA] Database Explorer v1.0.0 Beta

Post by david63 » Wed Jul 09, 2008 9:32 pm

Links do not work :( :(
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.0 Beta

Post by opalelement » Wed Jul 09, 2008 11:23 pm

Sigh... stupid hosting.

Try the download link again.

User avatar
david63
Registered User
Posts: 16328
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [BETA] Database Explorer v1.0.0 Beta

Post by david63 » Thu Jul 10, 2008 7:06 am

opalelement wrote:Try the download link again.
Thanks - it worked.

This is an excellent concept although I am not sure that it will replace phpMyAdmin for me - but it does have some good uses.

Just a few initial observations/suggestions that you may (or may not) already be considering or be aware of.

1. When displaying the contents of a table the ability to sort would be desirable.
2. There needs to be paging - both to make it easier to read and to reduce server load.
3. Ideally the field names in the header bar need to be as per the database (normally lower case) as I can see users copying and pasting and getting errors. Remember *nix is case sensitive.
4. The export option does not work.
5. The needs to be a specific permission to use this option.
6. The ability to click on the entry in the first row to allow you to change the data would also be very useful.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.0 Beta

Post by opalelement » Thu Jul 10, 2008 1:51 pm

david63 wrote:
opalelement wrote:Try the download link again.
Thanks - it worked.

This is an excellent concept although I am not sure that it will replace phpMyAdmin for me - but it does have some good uses.

Just a few initial observations/suggestions that you may (or may not) already be considering or be aware of.

1. When displaying the contents of a table the ability to sort would be desirable.
2. There needs to be paging - both to make it easier to read and to reduce server load.
3. Ideally the field names in the header bar need to be as per the database (normally lower case) as I can see users copying and pasting and getting errors. Remember *nix is case sensitive.
4. The export option does not work.
5. The needs to be a specific permission to use this option.
6. The ability to click on the entry in the first row to allow you to change the data would also be very useful.
1. Sort is going to be added soon, I had thought about that but had not implemented it yet.
2. Pagining has already been suggested and is in the wait list.
3. When copied and pasted the text will retain its original case, as it is just a css appearance. However, I will keep that in mind.
4. The export option was to be made, but I forgot about it until the day after I released it. Export now works and will be relased along with the next version, which should be out in a few days.
5. Suggestion noted
6. I will see what I can do about an edit feature, such as in phpMyAdmin.

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.1

Post by opalelement » Sun Jul 13, 2008 5:00 am

Updated to version 1.0.1

See first post for changelog

Max13
Registered User
Posts: 23
Joined: Wed Jun 06, 2007 3:15 pm
Contact:

Re: [BETA] Database Explorer v1.0.1

Post by Max13 » Sun Jul 13, 2008 10:43 am

Hi,

"/lang/en/mods/info_acp_sql.php" => Mods version is 1.0.0 instead of 1.0.1 (for the 1.0.1).

Good luck, I love your mod =P

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.1

Post by opalelement » Sun Jul 13, 2008 1:39 pm

Thanks, that reminds me. I need to change it in the install.xml too.

Max13
Registered User
Posts: 23
Joined: Wed Jun 06, 2007 3:15 pm
Contact:

Re: [BETA] Database Explorer v1.0.1

Post by Max13 » Sun Jul 13, 2008 1:46 pm

I saw something else...

Instead of using "Back" and "To results" and "{L_SEL...}", I think you should use {L_BACK} which already exist in phpbb files, {L_RESULTS} and add it to the lang files, and {L_SELECT} which already exist too... It will reduce your code (1 line =P) and it will be better for translator.

Do you allow me to translate it in french ?

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.1

Post by opalelement » Mon Jul 14, 2008 12:34 am

At the moment I am only interested in keeping it in English, as it makes it easier for updates and support. In the future I might start looking at other languages.

Anyasha
Registered User
Posts: 704
Joined: Mon Aug 07, 2006 4:02 am
Name: Anyasha

Re: [BETA] Database Explorer v1.0.1

Post by Anyasha » Mon Nov 03, 2008 5:58 am

I'm not seeing it in my ACP. Can someone please tell me what tab it's under?
Kiss me, I'm Polish!

User avatar
Sunka
Registered User
Posts: 566
Joined: Wed Mar 26, 2008 2:48 pm
Location: Croatia, Zvoneca

Re: [BETA] Database Explorer v1.0.1

Post by Sunka » Mon Nov 03, 2008 4:22 pm

interesting MOD

princexxx
Registered User
Posts: 82
Joined: Fri May 09, 2008 2:10 pm

Re: [BETA] Database Explorer v1.0.1

Post by princexxx » Tue Mar 17, 2009 6:32 am

Hey can any update this Mod to latest version as it giving me error's!
And please add a Drop table Button in next version!

opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [BETA] Database Explorer v1.0.1

Post by opalelement » Tue Mar 17, 2009 1:20 pm

What kind of errors?

I don't really work on this much but I still give support. The DB explorer is more for viewing and occasionally running a query, a drop table button would make it too easy to mess up the board. You could accidentally click and erase all your users. If you want to drop a table just type it into the query box.

Allowed queries with displayed data:
SHOW
SELECT
DESCRIBE

Allowed queries with only success/fail info:
INSERT
DELETE
TRUNCATE
UPDATE
CREATE TABLE
DROP TABLE
ALTER TABLE

Disallowed queries:
CREATE DATABASE
DROP DATABASE
ALTER DATABASE
GRANT
REVOKE

Locked

Return to “[3.0.x] MODs in Development”