Exactly: it's too easy to confuse indices with the actual values (plus, the actual values become strings instead of numbers)
3,902 2007-03-05 22:50
Re: small pb when editing a post or a subject in table search_words (1 replies, posted in PunBB 1.2 bug reports)
I'm not sure it is a bug.
Before you delete a word from search_words, you have to ensure that it isn't being used in search_matches. In order to do that, you would need to check the entire search_matches table for the word you just deleted. So that's one extra select per word deleted and one extra delete for every word not found. Not exactly the most efficent, especially with larger search_words tables.
Rebuilding your search index will of course remove the extra words: I'm sure someone could also write a query to remove the unnecessary words as well.
I'll leave this here though for the other developers to look at. If they agree with me, they can move this to PunBB Discussion.
3,903 2007-03-05 22:36
Re: MySQL rows. (4 replies, posted in Feature requests)
Rickard would have to answer this, but I think it's because we're using numbers and enum is a set of strings (which can be confusing when you're storing numbers as strings: you can get tripped up and accidentally use the numerical indexes instead of the string numbers).
3,904 2007-03-05 22:08
Re: anyone up for a challenge? VB to PunBB conversion. (11 replies, posted in PunBB 1.2 discussion)
Doesn't the converter work fine?
3,905 2007-03-05 16:15
Re: Private message problem (20 replies, posted in PunBB 1.2 troubleshooting)
What steps from this topic have you tried so far?
3,906 2007-03-05 11:31
Re: What produces the 'message' page after registration? (8 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Which I assume is the file you're using this in. Plain PunBB will work fine with that. However, I realized reading your error that you hardcoded the path to your common footer in PunBB's footer.php, which is what's causing your error. 
3,907 2007-03-05 03:01
Re: What produces the 'message' page after registration? (8 replies, posted in PunBB 1.2 modifications, plugins and integrations)
I'm confused: if you have a forum set up at ./forum/, then you'll have ./forum/header.php, which will load fine 
3,908 2007-03-05 02:30
Re: Mass Private Messaging? (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
nickfzx wrote:
Oh, ok, is there a way to change this so it does trigger the notification mod?
If you code the mod into the plugin. However, you'll then have the issue of sending out too many emails at once.
3,909 2007-03-05 02:28
Re: Various Questions (3 replies, posted in PunBB 1.2 troubleshooting)
What part is confusing you?
3,910 2007-03-05 01:09
Re: Mass Private Messaging? (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
It will not trigger your notification mod, since your mod relies on code in send_message.php
3,911 2007-03-05 01:08
Re: What produces the 'message' page after registration? (8 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Why not just
define('PUN_ROOT', './forum/');
require PUN_ROOT.'include/common.php';3,912 2007-03-04 22:11
Re: No Login/Password Fields (13 replies, posted in PunBB 1.2 troubleshooting)
Paul meant at the bottom of whatever stylesheet your guests are seeing, but I don't think adding it to imports/base.css instead would hurt
A screenshot (and more information) would be nice though so we can fix the underlying issue
3,913 2007-03-04 22:08
Re: Various Questions (3 replies, posted in PunBB 1.2 troubleshooting)
I was wondering how to go about making usergroups different colors, like making one usergroup color red
http://www.punres.org/desc.php?pid=56
Also, is there any way to make a punbb portal or w/e on the main site?
http://wiki.punres.org/Miniportal
how do I go about editing the CSS to add a banner?
3,914 2007-03-04 12:36
Re: [Release] User Management Plugin (71 replies, posted in PunBB 1.2 modifications, plugins and integrations)
3,915 2007-03-02 14:18
Re: TWO questions. (10 replies, posted in PunBB 1.2 troubleshooting)
3,916 2007-03-02 11:35
Re: I Got A Big Problem (6 replies, posted in PunBB 1.2 troubleshooting)
Does your host support PHP?
3,917 2007-03-02 03:00
Re: [Solved] Login Integration with CakePHP (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Moved to Integration
Could CakePHP be the problem? Remember that for $pun_user to be used within a function it needs to be declared global in the function
3,918 2007-03-01 23:59
Re: Two users with usernames that look the same (5 replies, posted in PunBB 1.2 bug reports)
I've updated the subject to more accurately reflect the issue
3,919 2007-03-01 22:19
Re: Can anybody explain the basic idea behind password salt (11 replies, posted in Programming)
pedrotuga: So, do you want me to try and answer something else?
3,920 2007-03-01 20:43
Re: [Solved] Login Integration with CakePHP (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Mmm, I'm not sure what the issue is: could you provide a link to your site?
3,921 2007-03-01 17:35
Re: [Solved] Login Integration with CakePHP (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
What is $cookie_path in config.php set to?
3,922 2007-03-01 15:17
Re: Multiple users at the same IP adress (4 replies, posted in PunBB 1.2 troubleshooting)
// Check that someone from this IP didn't register a user within the last hour (DoS prevention)
$result = $db->query('SELECT 1 FROM '.$db->prefix.'users WHERE registration_ip=\''.get_remote_address().'\' AND registered>'.(time() - 3600)) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result))
message('A new user was registered with the same IP address as you within the last hour. To prevent registration flooding, at least an hour has to pass between registrations from the same IP. Sorry for the inconvenience.');3,923 2007-03-01 11:35
Re: Unified converter! (InvPB, miniBB, PhpBB, vBulletin & YabbSE) (105 replies, posted in PunBB 1.2 discussion)
It is on the downloads page...
3,924 2007-03-01 11:34
Re: Multiple users at the same IP adress (4 replies, posted in PunBB 1.2 troubleshooting)
Go to register.php, comment out the query that checks if a user has registered in the past hour 
3,925 2007-03-01 01:32
Re: Trying to install punbb forums (32 replies, posted in PunBB 1.2 troubleshooting)
I would change the prefix in the config file, it's easier than renaming the tables