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 ...
:-(
You are not logged in. Please login or register.
PunBB Forums → Posts by lebel
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 ...
:-(
Why PM was not in this version ?
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
ok thx i will try
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)
hxxx://www.omplanete.com/forum/
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 ...
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
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
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
- in message_list.php, have a button "new PM" ...
YES especially NEW PM
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);?>
PunBB Forums → Posts by lebel
Powered by PunBB, supported by Informer Technologies, Inc.