Re: [Release] Database Management Plugin
Mmm, I just found something funny
When running a query that returns a lot of columns (ie: select * from #__users) the columns go far beyond the background given by PunBB
You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 modifications, plugins and integrations → [Release] Database Management Plugin
Mmm, I just found something funny
When running a query that returns a lot of columns (ie: select * from #__users) the columns go far beyond the background given by PunBB
yeh i know but its not worth doing anything about
Bah, it looks ugly
Find out what was used for the image scrolling and see if you can do something similar for this perhaps?
no theres no point, its just a little addon, for debug and modding purposes not really a major feature
OK then, mind if I fix it and post it here for anyone interested?
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>';
ok i'll include it in the next version but i think i'll keep the go backs never know i might get round to adding mysqli support this week
hmm your code doesn't work it leaves a huge whitespace 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
Really? It works perfectly fine in IE and Firefox...
which? mine or yours? if i do mine in IE it puts the scrollbar over the last row
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
ok, i've added the scroll you said and taken away some of the go backs , 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 anyway just testing mysqli now
Ok new version up for download
Mmm, I just realized that this doesn't have protection against a mod who knows the filename from using it...
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.
Whoops, silly me
I really should pay more attention...
Connor, just tested the plugin, works great.
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).
dang, well not my fault i just stole the backup script, i'll look into it...
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
Since it messes up forum permissions so they don't work, it is
lol the most important part of the db plugin is that the backups work
Two things:
First of all, I get
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.
can you come to #punbb @ irc.quakenet.org or add me (connorhd@gmail.com) to your msn ?
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?
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?
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
PunBB Forums → PunBB 1.2 modifications, plugins and integrations → [Release] Database Management Plugin
Powered by PunBB, supported by Informer Technologies, Inc.