1 Reply by horus

(121 replies, posted in PunBB 1.2 modifications, plugins and integrations)

Hi, it's quite perfect. I like this mod very much. I've installed it to my 1.2.11, it seems to work fine.

I translate in italian:

<?php

// Language definitions used in the mod "Move Post" 1.1.1

$lang_movepost = array(

'Mod move post'     =>  '[Move Post 1.1.1] - Sposta un messaggio',
'Intro'         =>  'Questo mod permette di spostare uno o più messaggi da un argomento ad un altro in qualsiasi forum. Consente in alternativa di creare un nuovo argomento dove spostare i messaggi.',

'Introduction'        =>  'Spiegazione',
'Create topic'        =>  'Crea un nuovo argomento',
'Move post'       =>  'Scegli l\'argomento di destinazione',

'Original topic'      =>  'Argomento originale:',
'Original forum'      =>  'Forum originale:',
'Select forum'        =>  'Scegli eventualmente un altro forum',
'Move all posts'      =>  'Sposta tutti i messaggi di questo argomento',

'Explain move all posts'    =>  'L\'argomento originale verrà cancellato.',
'Explain create topic'    =>  'Per creare un nuovo argomento, inserire un nuovo oggetto.',
'Explain move post'     =>  'Clicca sull\'argomento di destinazione.',

'Last'          =>  'Ultimo',
'Poster'          =>  'Inviato da',

'Bad topic'       =>  'Scelta errata',
'Bad new topic'     =>  'L\'oggetto non può essere vuoto',

'Mark move redirect'    =>  'Il messaggio è stato spostato nell\'argomento selezionato. Attendere prego …'

);

Just one thing: the mod doesn't update forum counts so in index.php you have wrong topics, posts and last posters. Some time ago i've modified admin_forum.php to include an update counts function so i use it but it will be a good idea to fix the mod.


my admin_forum.php (rownum is referred to my file, is only indicative)
approximately line 130, before

// Update forum positions
else if (isset($_POST['update_positions']))

i've added

// Update forum counts
else if (isset($_POST['update_counts']))
{
  $result = $db->query('select id from '.$db->prefix.'forums where redirect_url is null') or error('Unable to select forum', __FILE__, __LINE__, $db->error());
  while ($cur_forum = $db->fetch_assoc($result))
  {
    $counts = $db->query('select count(id) topics, sum(num_replies) replies from '.$db->prefix.'topics where forum_id='.$cur_forum['id']) or error('Unable to select forum', __FILE__, __LINE__, $db->error());
    $forum_counts = $db->fetch_assoc($counts);

    $db->query('update '.$db->prefix.'forums set num_topics='.$forum_counts['topics'].',num_posts='.($forum_counts['replies']+$forum_counts['topics']).' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $db->error());

    $counts = $db->query('select last_post,last_post_id,last_poster from '.$db->prefix.'topics where forum_id='.$cur_forum['id'].' order by last_post desc limit 1') or error('Unable to select forum', __FILE__, __LINE__, $db->error());
    $forum_counts = $db->fetch_assoc($counts);

    $db->query('update '.$db->prefix.'forums set last_post='.$forum_counts['last_post'].',last_post_id='.$forum_counts['last_post_id'].',last_poster="'.$forum_counts['last_poster'].'" WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $db->error());
  }

  redirect('admin_forums.php', 'Forum Counts Updated. Redirecting …');
}

and approximately line 469, before

</div>
  <div class="clearer"></div>
</div>
<?php

require PUN_ROOT.'footer.php';

i've added

<h2 class="block2"><span>Update Forum Counts</span></h2>
    <div class="box">
      <form id="upfcounts" method="post" action="admin_forums.php?action=updcounts">
        <p class="submittop"><input type="submit" name="update_counts" value="Update counters" tabindex="<?php echo ++$tabindex_count ?>" /></p>
      </form>
    </div>

Hope this help. Bye.

Go to forum: PunBB 1.2 modifications, plugins and integrations

2 Topic by horus

(1 replies, posted in PunBB 1.2 show off)

Hi, i finally decided to show off my punbb installation: http://www.aibsusa.it/forum/

I've added some mod (like easybbcode) and make myself others mods: smilies quick insert when writing post, local chat (not IRC), user title and rank.

Go to forum: PunBB 1.2 show off

3 Reply by horus

(224 replies, posted in PunBB 1.2 modifications, plugins and integrations)

I succesfully installed EasyPoll with some minor style modification.

The only important (for me) fix that i made is on edit.php

Line 39, I added t.question field in query

$result = $db->query('SELECT f.id AS fid, f.forum_name, f.moderators, f.redirect_url, fp.post_replies, fp.post_topics, t.id AS tid, t.subject, t.question, t.posted, t.closed, p.poster, p.poster_id, p.message, p.hide_smilies FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id 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 p.id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());

Line 129, I added an if clause

if ($cur_post['question'] != "")
    {
      redirect('viewpoll.php?pid='.$id.'#p'.$id, $lang_post['Edit redirect']);
    }
    else
    {
      redirect('viewtopic.php?pid='.$id.'#p'.$id, $lang_post['Edit redirect']);
    }

Hope this help.

Go to forum: PunBB 1.2 modifications, plugins and integrations

4 Reply by horus

(25 replies, posted in Feature requests)

I use this topic for a similar and (for me) better idea.

Instead of time limit I need answer limit: users can edit or delete theirs post until no one has answered, after this point every action on post will be denied.
I have a little forum but sometimes there are polemics, if after a reply first poster edits his post, all the discussion go out the window. To the contrary last post of each topic can be freely edited whitout damage.
I see this option on a phpbb forum where i'm a moderator, you can see mod release topic here.

I hope you can understand my request even if my english is only at school level (I'm italian).

Go to forum: Feature requests