2,051

(7 replies, posted in PunBB 1.2 discussion)

Looks like a CSS bug.

Hrmm, I suppose your MySQL version doesn't support UTF8.

Change

$db->query("UPDATE `".$db->prefix."config` SET `conf_value` = '" . $indexing . "' WHERE CONVERT( `conf_name` USING utf8 ) = 'o_links_indexing' LIMIT 1") or error("Links Code error: ",__FILE__, __LINE__, $db->error());

to

$db->query("UPDATE `".$db->prefix."config` SET `conf_value` = '" . $indexing . "' WHERE `conf_name` = 'o_links_indexing' LIMIT 1") or error("Links Code error: ",__FILE__, __LINE__, $db->error());

Well, just add target="_blank" if you want to use it =/ It actually is annoying for IE users, because those poor persons don't have tabs wink

minis: enable debug mode, so I can see the error

WHy on earth would someone subscribe with a different email? =/

Guests still can't subscribe and the user's email isn't updated, no. First thing won't work with this setup, and the second thing is just plain stupid to do tongue

replace

if(isset($_POST['sub']))
{
    $email = $db->escape($_POST['email']);
    $db->query("UPDATE ".$db->prefix."users SET newsletter='true' WHERE email='$email' AND id='".$pun_user['id']."'") or die(mysql_error());
    redirect($_SERVER['PHP_SELF'], "Subscribed");
}
if(isset($_POST['unsub']))
{
    $email = $db->escape($_POST['email']);
    $db->query("UPDATE ".$db->prefix."users SET newsletter='false' WHERE email='$email' AND id='".$pun_user['id']."'") or die(mysql_error());
    redirect($_SERVER['PHP_SELF'], "Unsubscribed");
}

with

if(isset($_POST['sub']))
{
    $email = $db->escape($_POST['email']);
    $db->query("UPDATE ".$db->prefix."users SET newsletter='true' WHERE id='".$pun_user['id']."'") or die(mysql_error());
    redirect($_SERVER['PHP_SELF'], "Subscribed");
}
if(isset($_POST['unsub']))
{
    $email = $db->escape($_POST['email']);
    $db->query("UPDATE ".$db->prefix."users SET newsletter='false' WHERE id='".$pun_user['id']."'") or die(mysql_error());
    redirect($_SERVER['PHP_SELF'], "Unsubscribed");
}

Indeed not, I put that in as an extra check wink
The email entered must match the email stored in the DB, else nothing happens wink

I think the solution to that is somewhere on PunRes smile

Normally guests shouldn't be allowed to sign up =/
Newsletter.php

if($pun_user['is_guest'])
    message($lang_common['No view']);

So no, they can't =/

2,061

(13 replies, posted in PunBB 1.2 troubleshooting)

In the forum options, disallow it wink

2,062

(20 replies, posted in PunBB 1.2 troubleshooting)

phpBB uses links, not uploaded files wink
The image gallery mod might be good for you tho.

2,063

(20 replies, posted in PunBB 1.2 troubleshooting)

=/ I didn't say in here, I just said you shouldn't use an url in the upload box tongue (people tend to do that)

2,064

(20 replies, posted in PunBB 1.2 troubleshooting)

A browser issue maybe?
Oh, and don't enter URLs tongue

Check the language files wink

Ok, found it, sorry =P
Leave the part I told you in, and just remove this:

 AND fp.read_forum IS NULL OR fp.read_forum=1

You could probably leave out the first thing too, as it's only used for this check.

2,067

(6 replies, posted in Programming)

True.

lol, 10 is a hell of a reason hcgtv! big_smile

For your first thing: you'd need to alter the big query on index.php. I think you'll need to leave out this piece:

LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].')

Then, about the security. First thing ofcourse is to always use the latest version. Then to check your mods for possible security holes.

2,070

(8 replies, posted in PunBB 1.2 discussion)

Hrmm... too bad sad

I'd actually see it as a bug, as it's a feature not working...

2,071

(8 replies, posted in PunBB 1.2 discussion)

Can't you just put a link somewhere, that everyone can see, that goes to this page: post.php?fid=
And after fid= you just put the id of your application forum. Normally it should allow posting, so it should work...

Ah, like that tongue

Gotta think extra on that to do it easily ^^

Well, I found it was quite easy =P

This is the code I used (boxed with a nice header):

        <?php
        $result = $db->query("SELECT id, forum_name, moderators FROM ".$db->prefix."forums WHERE moderators IS NOT NULL");
        while($row = $db->fetch_assoc($result))
        {
            echo '<div class="box">', '<h2><a href="'.PUN_ROOT.'viewforum.php?id='.$row['id'].'">'.$row['forum_name'].'</a></h2>';
            $mods = unserialize($row['moderators']);
            foreach($mods as $key => $value)
                echo '<a href="'.PUN_ROOT.'profile.php?id='.$value.'">'.$key.'</a>, ';
            echo '</div>', '<br />';
        }
?>

Look in viewforum.php smile

Yeah smile