26

(300 replies, posted in PunBB 1.2 discussion)

Connorhd wrote:

because Rickard did not want to add it - http://punbb.org/about.php

ok even if this function is very important for a big forum ...
:-(

27

(300 replies, posted in PunBB 1.2 discussion)

Why PM was not in this version ?

28

(33 replies, posted in Feature requests)

Rickard wrote:

lebel: One thing you could try is to convert the online table to the table type MyISAM. You can do this through e.g. phpMyAdmin. I'm not sure it will help, but give it a go.

Nice forum BTW. It should be on PunBBig smile

ok thx i will try wink

29

(33 replies, posted in Feature requests)

analogue wrote:

mysql_stat();

Uptime: 13111
Threads: 20
Questions: 6210748
Slow queries: 1379
Opens: 69319
Flush tables: 1
Open tables: 4095 Queries per second avg: 473.705

No crash...

ouais ok mais tu as combien d'utilisateurs qui se connectent en même temps ?

My website is about football team. When there 's match, 100 users connects to the forum at the same time. And all the time MySQL crash (& the server too)

30

(33 replies, posted in Feature requests)

hxxx://www.omplanete.com/forum/

31

(33 replies, posted in Feature requests)

I have check it. The problem come from user table (more than 15.500 users now). When there's more than 80 users online, MySQL crash.
I search a solution to reduce this table but i don't know how if i want to keep all users ...

32

(33 replies, posted in Feature requests)

I need to reduce size of two tables of my database (posts and topics).
So i have create 2 other tables:
- archive_topics => id, subject
- archive_posts => topic_id, poster, message, date

the SELECT with INNER JOIN in the page viewtopic CRASH my server because my forum is too big

then now, no inner join for the archive with these 2 new tables

PS: excuse my bad english

33

(33 replies, posted in Feature requests)

archive would be a good option
i have a big forum (more than 14.000 users) and a table posts 55Mo
my server crash many times when there are more than 80 users online

archive topic out of table posts and table forum would be great

n|oa wrote:

I get this error when I try to make a new post..

"Unable to fetch group info."

same thing

PLEASEEEE HELP

Warning: in_array() [function.in-array]: Wrong datatype for second argument in xxx/forum/search.php on line 157

Warning: in_array() [function.in-array]: Wrong datatype for second argument in xxx/forum/search.php on line 159

I'm in 1.1.5
I don't find the problem ...

works for 1.1.5 ?

it seems all users see the topics of the forum admin ...

for NEW MP try that:

Modify message_send.php

DELETE lines 159-160
if (isset($_GET['id']))
{

DELETE lines 190-191-192
}
else
message($lang_common['Bad request']);

REPLACE
if (empty($id))
message($lang_common['Bad request']);
       
BY THAT
if (!empty($id)){
     $result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE id='.$id) or error('Unable to fetch message info', __FILE__, __LINE__, $db->error());
     if (!$db->num_rows($result))
     message($lang_common['Bad request']);
     list($username) = $db->fetch_row($result);
}



modify message_list.php

MODIFY line 52
add your button NEW PM
with href "message_send.php"

again more easy the bbcode button

modify post.php

BEFORE
<table class="punspacer" cellspacing="1" cellpadding="4">
    <tr>
        <td><b><a href="index.php"><?php echo pun_htmlspecialchars($pun_config['o_board_title']) ?></a> / <?php echo $forum ?><?php if (isset($subject)) echo ' / '.pun_htmlspecialchars($subject) ?></b></td>
    </tr>
</table>

ADD
function button_bbcode(){
$button_bbcode=array('b', 'i', 'u', 'url', 'img', 'quote');
    $data="\n\n<table cellspacing=\"1\" cellpadding=\"3\">\n<tr>\n";
    for ($i=0; $i<count($button_bbcode); $i++){
        $value=$button_bbcode[$i];
        $data.="<td align=\"center\"><input type=\"button\" class=\"punbutton\" value=\"" . strtoupper($value) . "\" onClick=\"Javascript:insert_bbcode('[$value]','[/$value]');\"></td>";
    }
    $data.="</tr>\n</table>\n";
    return $data;
}


ADD the javascript function
function insert_bbcode(bbopen,bbclose){
    var txtarea = document.getElementById("req_message");
    theSelection = document.selection.createRange().text;
    if (!theSelection) {
        txtarea.value += typeformat = bbopen + bbclose;
        txtarea.focus();
        return;
    }else{
        document.selection.createRange().text = bbopen + theSelection + bbclose;
        txtarea.focus();
        theSelection = '';
        return;
    }
}       


BEFORE
<textarea name="req_message" rows="20" cols="70" tabindex="<?php echo $cur_index++ ?>">

ADD
<? echo button_bbcode();?>



modify your CSS template file *.css
ADD
.punbutton { border:1px solid #B8B8B8; background-color: #FFF; font-size: 11px; font-family: verdana, helvetica, sans-serif; vertical-align: middle; padding:2px; font-weight: bold; }

the same button css than jacobswell

Rod wrote:

- in message_list.php, have a button "new PM" ...

YES especially NEW PM

Rod wrote:

Requests of the users of my punBB :
- Have a link in top pour go directly in PM without waiting for a new PM

There is a link to go directly, non ???

I had more than 300.000 posts (250Mo for the database) and the script time out with apache since 30 minutes ...

script only for little database ...

Chacmool,

can u confirme it for 1.1.5 ?

thx

For smileys only, i make another script more easy ...
the only thing is to add and remove some lines in post.php

AFTER
require $pun_root.'include/common.php';
PASTE
require $pun_root.'include/parser.php';


REMOVE ALL OTHER LINES WITH
require $pun_root.'include/parser.php';


AFTER
    if (!$cookie['is_guest'])
        $focus_element = (isset($_GET['fid'])) ? 'req_subject' : 'req_message';
    else
        $focus_element = 'req_username';

    require $pun_root.'header.php';

    $cur_index = 1;

[/b]ADD[/b]
<?
function pun_smileys($smiley_img, $smiley_text){
    $data="\n\n<table cellspacing=\"1\" cellpadding=\"3\" align=\"center\">\n";
    for ($i=0; $i<count($smiley_text); $i++){
        if ($j==0) $data.="<tr>";
        $data.="<td align=\"center\"><img src=\"img/smilies/" . $smiley_img[$i] . "\" alt=\"" . $smiley_text[$i] . "\" onclick=\"insertsmileys('" . $smiley_text[$i] . "')\"></td>";
        if (($j==2) || ($i==count($smiley_text))){
            $data.="</tr>\n";
            $j=0;
        }else{   
            $j++;
        }
    }
    $data.="</table>\n";
    return $data;
}
?>

<script language="JavaScript" type="text/JavaScript">
function insertsmileys(text) {
    var txtarea = document.getElementById("req_message");
   
    text = ' ' + text + ' ';
    if (txtarea.createTextRange && txtarea.caretPos) {
        var caretPos = txtarea.caretPos;
        caretPos.text = caretPos.text.charAt(caretPos.text.length - 1) == ' ' ? caretPos.text + text + ' ' : caretPos.text + text;
        txtarea.focus();
    } else {
        txtarea.value  += text;
        txtarea.focus();
    }
}
</script>


BEFORE
<a href="help.php#bbcode" target="_blank"><?php echo $lang_common['BBCode'] ?></a>: <?php echo ($pun_config['p_message_bbcode'] == '1') ? $lang_common['on'] : $lang_common['off']; ?>  <br>
ADD
<?php echo pun_smileys($smiley_img, $smiley_text);?>