I don't think the convertor even has a delete statement in it, so I don't see how that's possible
7,126 2005-05-09 18:58
Re: Unified converter! (InvPB, miniBB, PhpBB, vBulletin & YabbSE) (105 replies, posted in PunBB 1.2 discussion)
7,127 2005-05-09 17:22
Re: Banning Guests (3 replies, posted in PunBB 1.2 bug reports)
Nope, not yet, I'll email you when I get home
7,128 2005-05-09 10:46
Re: Unable to insert search index words (6 replies, posted in PunBB 1.2 troubleshooting)
Well, I saw something similar to this at a game I modded. A table used to crash every so often for seemingly no particluar reason. The admin thought the problem might have been some corrupted MySQL libraries, but he was too lazy to re-install it, since we were moving to a new server. We moved and haven't had a problem since
Basically, if this is on a server you control, think about re-installing MySQL and seeing if that helps.
7,129 2005-05-09 10:38
Re: README: About feature requests (71 replies, posted in Feature requests)
Definable user groups and post previews are in the original post
7,130 2005-05-08 22:09
Re: Heaps of strange things (13 replies, posted in PunBB 1.2 troubleshooting)
YES! I know what the problem with this is I think!
I had a problem like this on a board of mine. I think the issue was with mod_cache not being configured properly or something along those lines.
I'm taking a look at the HTTP requests and that seems to be exactly what's happening: the action of whatever happened before is being cached and re-played over and over./
7,131 2005-05-07 22:08
Topic: Make database stats "more accurate" (1 replies, posted in Feature requests)
Dunno exactly how this ports over to anything other then MySQL, but I'll suggest it anyway
Current code:
$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());
My suggestion
$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'` LIKE "'.$db_prefix.'%"') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());
That way, if there is a prefix, we only fetch the stats for the board we're looking at.
Oh, I forgot to say why this is good
It helps people running multiple things from one database (be it multiple PunBB installs or anything) see how much space PunBB is actually taking up. I know I have a CVS version of PHPBB 3.0 in the database with PunBB, and it threw my stats off a lot
7,132 2005-05-07 21:53
Re: Banning Guests (3 replies, posted in PunBB 1.2 bug reports)
And in the area of other odd developments, go manipulation of forms to make it so admins can't read the board!
Obviously, neither of these are very serious (you'd need admin access to do any of them, and hopefully you don't have untrustworthy admins) but are probably worth fixing (if a hacker gets admin, locking out all Guests and then messing up all the group stats would be annoying to say the least: of course, if you have the DB plugin they could do much worse).
7,133 2005-05-07 21:46
Topic: Banning Guests (3 replies, posted in PunBB 1.2 bug reports)
Mmm, I just found out that you can ban the Guest account.
And I do mean ban, I don't mean turn off their ability to read the board
7,134 2005-05-07 20:08
Re: Remember "Subscribe to this topic" checkbox (69 replies, posted in Feature requests)
Some people "set it and forget it"
Lets take these forums as an example.
There are close to 3500 posters. Lets say Rickard had a giant thread that everyone was supposed to post in once. Imagine the server having to send out over 1k emails every time someone posted.
And subscriptions are already able to be set by the admins
7,135 2005-05-07 19:38
Re: Remember "Subscribe to this topic" checkbox (69 replies, posted in Feature requests)
For threads/forums with few posters maybe.
For threads/forums with many posters that have auto-subscribe on... that means every time someone posts in that thread everyone who is subscribed needs to be informed.
7,136 2005-05-07 19:08
Re: Remember "Subscribe to this topic" checkbox (69 replies, posted in Feature requests)
Oh... well, then, GO FOR IT!!! I mean, heck, if the process will only add more emails to the sytem, but not resources during every post / pageview then it should totally be a user defined option.
Erm, who said that?
I said the option to auto-subscribe would be a user table thing. I didn't mention the fact that it would have to send all the emails as well.
7,137 2005-05-07 18:45
Re: Remember "Subscribe to this topic" checkbox (69 replies, posted in Feature requests)
auto subscribe would be in the user table, and so would be grabbed every pageview anyway
7,138 2005-05-07 16:17
Re: How to run php from main.tpl (4 replies, posted in PunBB 1.2 troubleshooting)
7,139 2005-05-07 01:27
Re: Sharing A User Database (4 replies, posted in PunBB 1.2 modifications, plugins and integrations)
It depends on how photopost's database is set up.
7,140 2005-05-07 00:00
Re: I can't login! No users can log in - (8 replies, posted in PunBB 1.2 bug reports)
Give us your site URL so we can check it out?
7,141 2005-05-06 23:26
Re: Recent Posts (10 replies, posted in Feature requests)
No, no other changes
and thanks
7,142 2005-05-06 22:56
Re: Recent Posts (10 replies, posted in Feature requests)
search.php (for last 72 hrs):
FIND
else if ($action == 'show_24h')
{
$result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.(time() - 86400)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
$num_hits = $db->num_rows($result);
if (!$num_hits)
message($lang_search['No recent posts']);
}
Replace with
else if ($action == 'show_24h')
{
$result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.(time() - 259200)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
$num_hits = $db->num_rows($result);
if (!$num_hits)
message($lang_search['No recent posts']);
}
7,143 2005-05-06 22:54
Re: I can't login! No users can log in - (8 replies, posted in PunBB 1.2 bug reports)
All the .php files in the cache folder can be deleted.
What's your site?
7,144 2005-05-06 17:42
Re: anonymous posting/ no login required (4 replies, posted in General discussion)
7,145 2005-05-06 15:54
Re: language packs (2 replies, posted in Programming)
Well, the way IC does it is to have an array storing the data: take a look at it
7,146 2005-05-06 10:34
Re: PunBB reported: Unable to connect to MySQL server. (1 replies, posted in PunBB 1.2 troubleshooting)
I keep getting this error when I tried to install PunBB:
An error occured on line 55 in ***/include/dblayer/mysql.php.
PunBB reported: Unable to select database. MySQL reported: Access denied for user: ****@localhost' to database '***'
I'm sure I had filled in everything correctly. And if I make a slight change to the info I filled in, I would get this:
An error occured on line 58 in file ***/include/dblayer/mysql.php.
PunBB reported: Unable to connect to MySQL server. MySQL reported: Access denied for user: ***@localhost' (Using password: YES)
Can someone please help?
The first error means you're entering a valid login/pass, but you're not allowed access to that table.
The second means you're entering an invalid login/pass
7,147 2005-05-06 10:33
Re: Remember "Subscribe to this topic" checkbox (69 replies, posted in Feature requests)
They're bloat, pure and simple
1. Would lead to a lot of stress on the mailserver of a larger board due to the amount of emails it would have to send every time someone posted. Imagine a 1k post thread with just as many subscribers.
2. Similar to above, would send out a HUGE amount of emails on a regular basis.
3. There's a digest mod for 1.1.5 I'm planning on updating to work for 1.2.5
7,148 2005-05-05 21:57
Re: Simply the best Flash anim' for Webmasters who have a FORUM :) (3 replies, posted in General discussion)
rofl
7,149 2005-05-05 21:49
Re: Prevent moderators deleting posts made by admins (2 replies, posted in Feature requests)
Add an extra query to the page based on p.poster, not that hard, although I don't see why you need it
7,150 2005-05-05 16:13
Re: subscribe.. (9 replies, posted in Feature requests)
OK, to force people to subscribe:
FIND:
$subscribe = isset($_POST['subscribe']) ? 1 : 0;
REPLACE WITH
$subscribe = isset($_POST['subscribe']) ? 1 : 1;
Quick and dirty hack