Search options (Page 73 of 77)

Cheers. That has sorted that error.

Getting one from the second line after it, (below), now.

$db->query('UPDATE '.$db->prefix.'users, '.$db->prefix.'post_counts SET num_posts=new_num WHERE id=poster_id') or error('Could not update post counts', __FILE__, __LINE__, $db->error());

The error message is:

Line: 125

PunBB reported: Could not update post counts

Database reported: ERROR: syntax error at or near "," at character 19

Thanks.

Matt

Would anyone happen to know the pgsql version of this line?

$db->query('CREATE TEMPORARY TABLE IF NOT EXISTS '.$db->prefix.'post_counts SELECT poster_id, count(*) as new_num FROM '.$db->prefix.'posts GROUP BY poster_id') or error('Creating temporary table failed', __FILE__, __LINE__, $db->error());

It throws a wobbler on trying to synchronise the post counts.

Cheers,

Matt

(Now banging head firmly on desk). That first part is the missing link. It always looks so simple when someone points out ones glaring exemption. I'll blame a slight misunderstanding of sessions on this one. I had tried a $_GET['action'] check thinking that would stop it renewing itself, but then it didn't carry over, (which is where I was losing the plot). I never even thought of trying something like the first section above. I feel such a muppet, (again), for misinterpreting something so simple in theory. (Now hurrying off to try it out). Thanks once again.

Right, I think I've grasped the basics now, through reading and experimentation. One question on the tmpfile that's created by the session in the tmpdir. Is there a session command to remove that tmpfile when you've finished with the session?

I can't say as I've actually any interest in using this mod personally, but for some reason it just piqued my curiosity as to how one could make a randomish choice thing work. Just been looking at the php documentation, and I am getting steadily more confused, but from what bit has sunk in so far, is a session pretty much along the same lines as an array?

It always sounds so understandable in ones own head, doesn't it? Here are the relevant parts from register.php:

    197                 $language = $pun_config['o_default_lang'];
    198         }
    199
-----------------------------------------------------
    200         // anti-spam code variable checked here. Customise to suit your needs.
    201         if ($_POST['spamcode'] != $answer) {
    202                 message("$register_failed");
    203         }
------------------------------------------------------
    204
    205         $timezone = round($_POST['timezone'], 1);
    206         $save_pass = (!isset($_POST['save_pass']) || $_POST['save_pass'] != '1') ? '0' : '1';

    332 <?php if ($pun_config['o_regs_verify'] == '1'): ?>                                              <label><strong><?php echo $lang_register['Confirm e-mail'] ?></strong><br />
    333                                                 <input type="text" name="req_email2" size="50" maxlength="50" /><br/>
</label>
    334 <?php endif; ?>                                 </div>
    335                                 </fieldset>
    336                         </div>
    337
------------------------------------------------------
    338 <div class="inform">
    339         <fieldset>
    340                 <legend>Spambot prevention</legend>
    341                 <div class="infldset">
    342                         <p><?php echo ("$question"); ?></p>
    343                         <p><?php echo ("$hint"); ?></p>
    344                         <input method="post" type="text" name="spamcode" size="10" maxlength="10" /><br/>
    345                 </div>
    346         </fieldset>
    347 </div>
-------------------------------------------------------
    348
    349                         <div class="inform">
    350                                 <fieldset>
    351                                         <legend><?php echo $lang_prof_reg['Localisation legend'] ?></legend>

The sections between the dotted lines are the new code. I've left extra code above/below as markers of placement. With that bottom section of code, if I add:

<?php
require PUN_ROOT.'include/user/register.php';
?>

just before it, that require will pull the variables required from that script. However, when it gets to the $_POST check back up the top of the register.php file, (that first block of code), the variables aren't carried over to that check. If I put the require at the top of register.php, the script would appear to be being called twice, as the random(ish) variables it produces don't match. So, the question being, how do I carry the variables over to the post check? That include/user/register.php is merely arrays with a rand call to set a value for $hint, $answer and $question, i.e:

$number = rand(1, 2);
$hint = $hints[$number];
$answer = $answers[$number];
$question = $questions[$number];

Have I managed to explain it okay this time?

Thanks again,

Matt

Cheers. I feel such a muppet now. Rechecked everything and found I'd neglected to add a require for the relevant lang file in the  forums.php file.

Sorted. Removed the icon type setting for closed topics and inserted the image in place of in viewforum.php.

But it's quicker to say emulation than writing the page or two's worth of text that they use to explain it.

To convert a M$ programme to *nix? If so, no.