326

(7 replies, posted in Feature requests)

Note to self: brute force aeroguy's account so he can't log in.

327

(30 replies, posted in PunBB 1.2 discussion)

You don't even need to look in your database; The prefix is stored in config.php (which you create after installing).

328

(30 replies, posted in PunBB 1.2 discussion)

Could you add something like this to config.php and replace with that instead?

define('INTEGRATED_PREFIX', 'whatever');

Maybe one of these editors can help you find/replace.

329

(30 replies, posted in PunBB 1.2 discussion)

FWIW, I count 16 files and 61 queries. (I don't think there are any mods included in those numbers.)

I thought about trying, but decided to wait for multiple moderator group code from 1.3. (Then I'll realize I'm still in over my head, so don't get excited. tongue)

331

(4 replies, posted in PunBB 1.2 discussion)

Hide the link? Edit the `generate_navlinks()` function (include/functions.php).

They can still access the page directly though, but mods can't really do much there? You might want to edit "admin_censoring.php" to only allow admins, and edit it's link in the function `generate_admin_menu()` (include/common_admin.php).

332

(2 replies, posted in Feature requests)

Would you include a link on the rules so they can continue with posting?

(Also, don't they have to read them before they sign up?)

333

(114 replies, posted in Programming)

For FTP on OS X, I like Transmit much better.

334

(3 replies, posted in PunBB 1.2 troubleshooting)

Um, what about the Flash demo?

335

(3 replies, posted in PunBB 1.2 discussion)

How about this?

http://www.punres.org/files.php?pid=60

Smartys, I edited yours as a learning experience; I added radio buttons for Inbox/Sent. smile

Edit: Of course, I also changed the query. tongue I gave Inbox a value of 0 and Sent a value of 1, and then used that value in the query.

Also, with the box column and one table, you could add support for multiple boxes, and the ability to move message between them.

337

(10 replies, posted in Feature requests)

I just move stuff to an "archive" forum. *shrugs*

Actually, I still get the same error.

The file `include/dblayer/common_db.php` will include the right file based on what database is being used. The other files in `include/dblayer` contain the actual DBLayer class for that particular database.

340

(29 replies, posted in PunBB 1.2 show off)

pogenwurst, your forum looks fine in Safari. smile

Might want to remove that from moderate.php as well.

342

(2 replies, posted in Feature requests)

Do you want the same thing as this guy? He was pointed here: Make non-readable forums visible in the index

343

(14 replies, posted in PunBB 1.2 troubleshooting)

header.php isn't looking in the right spot?

<link rel="stylesheet" type="text/css" href="style/<?php echo $pun_user['style'].'.css' ?>" />

344

(12 replies, posted in Feature requests)

Also, to risk stating the obvious, if signatures and avatars are disabled, then the "personality" section probably shouldn't appear in the menu.

345

(69 replies, posted in News)

You shouldn't have any HTML in that file.

346

(114 replies, posted in Programming)

TextMate on OS X.

347

(9 replies, posted in PunBB 1.2 troubleshooting)

That seemed to work fine on my test forum?

You should change the `<br>` to `<br />` though (because PunBB uses XHTML).

I missed that, thanks. smile

File: /home/httpd/vhosts/mydomain/httpdocs/forums/register.php
Line: 113

PunBB reported: Unable to fetch user info

Database reported: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (Errno: 1267)

I get an error from this line:

// Check that the username (or a too similar username) is not already registered
$result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE UPPER(username) = UPPER(\''.$db->escape($username).'\') OR UPPER(username) = UPPER(\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\')') or error('Unable to fetch user info ///02', __FILE__, __LINE__, $db->error());

I've changed everything to UTF-8 in MySQL, and I've added this to common_db.php:

$db->query("SET NAMES 'UTF8'");

I haven't had any other problems (or changes) since switching.

Edit: If I comment out this line, then I can register successfully.