[Release] Database Management Plugin (Page 1 of 4)

I was wondering if someone would make this plugin, thanks a lot, makes things a lot easier when it comes to backing up the forum. I've tested optimize tables (it said it worked, but I didn't do db checks to see if this was the case).

I've also created a backup (using gzip compression), made a post and restored via the back up to see if it works, and it does. I don't know if I should try deleting my db and trying to restore via the backup from that or if I should wait until a problem arises that I need to use it though.

Anyway, thanks for the plugin, very helpful.

will it use alll tables in the database with the $db->prefix ?

hmm.. I see the problem ... but if ppl can select what other tables they want, then I suppose it will work fine with the attachment mod

going to take a look on it when I'm done on my mod (it kind of takes up most of my free time )

ok i'm still testing but i've improved the additional tables bit alot, now what it does is:
1. No db prefix - will list up to 15 tables otherwise it shows the text box for additional tables
2. db prefix - lists the tables as checkboxes but cuts off after 15 tables, i'm just looking at this i might make it display the tex box for over 15 if it can be done easily

also the sql query box will hopefully do any query now i'll try to upload the new one tonight

Some ideas for the SQL query thing:
- If you run a select and it returns no data, return a "No data found" message.
- Center the returned values

A bug:

SELECT * FROM #__online;
update #__online set user_id=user_id;

This returns the select and then, at the bottom, gives the queries that have been run (both).

update #__online set user_id=user_id;
SELECT * FROM #__online;

This only returns the select, it doesn't list the queries done.

And something that should be clarified:

SELECT * FROM #__online where user_id = 3

entered works fine

SELECT * FROM #__online where user_id = 3
SELECT * FROM #__online where user_id = 3

gives SQL Error

SELECT * FROM #__online where user_id = 3;SELECT * FROM #__online where user_id = 3;

Executes both queries.

You should mention that if you want to run multiple queries you need to add a ; to the end of each query

i think i'll leave it how it is, it will now backup punbb and in alot of cases allow you to backup mods by simply ticking boxes, if you want more then theres phpmyadmin ;)

done

i don't think they should be centered

fixed added queries done to the end of all outputs

as for the multiple queries as long as you put a ; at the end of each query (except the last one which you either can or cannot it doesn't matter) it will work ;) thanks for all the input

thats what i said, you need a ; at the end of each query except the last one which doen't matter (i'm talking about it after the changes i've made btw)

Ah, yes, it works after upgrading it

But here's a bug:

Additional tables None detected

I have several extra tables in my database

Another bug: Above the first query is a Go back link, below it and above the Queries Done is a Go back link and below the Queries Done is a Go back link.

And finally:

SELECT * FROM #__online where user_id="</div>"

Even though that's a fake example (user_id is numerical) the HTML in it messes up the view of the page slightly

Edited it just now

Ah, that explains it

Connorhd:  Great plugin.  Very useful. I like the option for backing up other tables in the db that are not part of the core app.  I found one teeny weenie error.  The word ?Optimise? is spelled Optimize.  It appears both in the submit button and the successful message.  .  Believe me, I am not spelling genius.  I just thought that since this was something many people would use that you would want to change it. 

Awesome job!

ahhhh thoZe people from LeedZ again

Great job btw!

@ Connorhd

Why do you want to stick to a dialect? English is the language, British English is the original.