[BETA] Database Explorer v1.0.1

[princexxx]

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

[opalelement]

New official page: cancelled

[david63]

Links do not work

[opalelement]

Sigh... stupid hosting.

Try the download link again.

[david63]

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.

[opalelement]

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]

Updated to version 1.0.1

See first post for changelog

[Max13]

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]

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

[Max13]

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]

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]

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

[Sunka]

interesting MOD

[princexxx]

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]

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