Re: [Release] Database Management Plugin

Mmm, I just found something funny tongue
When running a query that returns a lot of columns (ie: select * from #__users) the columns go far beyond the background given by PunBB tongue

Re: [Release] Database Management Plugin

yeh i know but its not worth doing anything about

Re: [Release] Database Management Plugin

Bah, it looks ugly tongue
Find out what was used for the image scrolling and see if you can do something similar for this perhaps?

Re: [Release] Database Management Plugin

no theres no point, its just a little addon, for debug and modding purposes not really a major feature

30 (edited by Smartys 2005-02-06 02:39)

Re: [Release] Database Management Plugin

OK then, mind if I fix it and post it here for anyone interested? tongue

Edit: for anyone interested...

Find:
echo '</span></h2><div class="box"><div class="inbox"><table cellspacing="0"><thead><tr>';

Replace with
echo '</span></h2><div class="box"><div class="inbox"><div class="scrollbox"><table cellspacing="0"><thead><tr>';

Find:
echo '</tbody></table></div></div></div>';

Replace with:
echo '</tbody></table></div></div></div></div>';

And for anyone who wants to get rid of the extra "Go back"s

Find and delete the first 2 times it appears (first time is after $row_count is defined, second is in the first echo in a group of 5 after an elseif. The one inside the elseif can be deleted as well):
echo '<div><div class="linkst"><div class="inbox"><div><a href="javascript:history.go(-1)" />Go back</a></div></div></div>';

Re: [Release] Database Management Plugin

ok i'll include it in the next version tongue but i think i'll keep the go backs tongue never know i might get round to adding mysqli support this week

Re: [Release] Database Management Plugin

hmm your code doesn't work it leaves a huge whitespace tongue ok i've done it but a bit different

echo '</span></h2><div class="scrollbox" style="height: auto"><div class="box"><div class="inbox"><table cellspacing="0"><thead><tr>';

it looks better imo

goes a bit dodgy in IE now but what you gonna do

Re: [Release] Database Management Plugin

Really? It works perfectly fine in IE and Firefox...

Re: [Release] Database Management Plugin

which? mine or yours? if i do mine in IE it puts the scrollbar over the last row sad

Re: [Release] Database Management Plugin

ahh i see now they both work in FF perfectly but i'm not ure about IE yet, the reason they were dodgy before for me was because i was on 1.2 not 1.2.1 i think

Re: [Release] Database Management Plugin

ok, i've added the scroll you said and taken away some of the go backs wink, i've also added max-height i dunno if it will work in IE but its just an extra its not important. problem is in IE if it shows a horizontal scrollbar it puts it over the last row and then shows a vertical one as well sad anyway just testing mysqli now

Re: [Release] Database Management Plugin

Ok new version up for download wink

Re: [Release] Database Management Plugin

Mmm, I just realized that this doesn't have protection against a mod who knows the filename from using it...

Re: [Release] Database Management Plugin

Smartys wrote:

Mmm, I just realized that this doesn't have protection against a mod who knows the filename from using it...

Huh? That is done in admin_loader.php based on the filename.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

40 (edited by Smartys 2005-02-07 00:14)

Re: [Release] Database Management Plugin

Whoops, silly me smile
I really should pay more attention...

41

Re: [Release] Database Management Plugin

Connor, just tested the plugin, works great.

Re: [Release] Database Management Plugin

Rather large bug with this:
I just tried restoring a backup (full, no gzip). I start getting errors with the forum_perms table. When I checked it out, I realized the problem: Rickard made both forum_id and group_id primary keys, but the backup only had forum_id set as primary_key when it was creating the table (edit: it does the same with structure as well).

Re: [Release] Database Management Plugin

dang, well not my fault tongue i just stole the backup script, i'll look into it...

Re: [Release] Database Management Plugin

does it really matter its not like you are going to have everyone looking at the page and if you do you have some serious security problems tongue

Re: [Release] Database Management Plugin

Since it messes up forum permissions so they don't work, it is tongue

Re: [Release] Database Management Plugin

lol the most important part of the db plugin is that the backups work tongue

47 (edited by yelowpunk 2005-03-31 05:47)

Re: [Release] Database Management Plugin

Two things:

First of all, I get

DB Management Error wrote:

No file was uploaed or the upload failed, the database was not restored

Secondy, it's misspelled.

Thanks,

-Tim

p.s. I realize now that I probably need to add more info. Running 1.2.4, made database backups about a month ago, they didn't work with the DB management plugin I had then, still don't work with the (as of today) current version.

My DB got attacked, and I hoped that I would be able to get it running again, but all three backups (made two weeks apart from each other) will not work, .txt and .gzip format alike.

Re: [Release] Database Management Plugin

can you come to #punbb @ irc.quakenet.org or add me (connorhd@gmail.com) to your msn ?

49 (edited by Dexus 2005-04-05 09:17)

Re: [Release] Database Management Plugin

CREATE TABLE `forum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`forum_id`,`group_id`)
) TYPE=MyISAM;

goes to

CREATE TABLE forum_perms(
    group_id int(10) NOT NULL,
    forum_id int(10) NOT NULL,
    read_forum tinyint(1) DEFAULT '1' NOT NULL,
    post_replies tinyint(1) DEFAULT '1' NOT NULL,
    post_topics tinyint(1) DEFAULT '1' NOT NULL, 
    PRIMARY KEY (group_id)
);

where the hell is secondary key?

50 (edited by Smartys 2005-04-05 10:32)

Re: [Release] Database Management Plugin

Dexus wrote:
CREATE TABLE `forum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`forum_id`,`group_id`)
) TYPE=MyISAM;

goes to

CREATE TABLE forum_perms(
    group_id int(10) NOT NULL,
    forum_id int(10) NOT NULL,
    read_forum tinyint(1) DEFAULT '1' NOT NULL,
    post_replies tinyint(1) DEFAULT '1' NOT NULL,
    post_topics tinyint(1) DEFAULT '1' NOT NULL, 
    PRIMARY KEY (group_id)
);

where the hell is secondary key?

Smartys wrote:

Rather large bug with this:
I just tried restoring a backup (full, no gzip). I start getting errors with the forum_perms table. When I checked it out, I realized the problem: Rickard made both forum_id and group_id primary keys, but the backup only had forum_id set as primary_key when it was creating the table (edit: it does the same with structure as well).

You happen to have the primary key as group_id instead, but it's the same issue wink