51

(4 replies, posted in Feature requests)

Hi, when you change the status of someone from member to moderator, you have to manually select in which forums he can moderate... When you've got 30 forums and you want to add 10 moderators, this can be quite painful tongue

A "select all" button which would check all the checkboxes would be welcome... Plus it should be only a few lines of javascript... Well, it's not very important, but it would be great smile

52

(62 replies, posted in News)

That's some good news. Make punbb rock!

Same problem here smile

54

(95 replies, posted in News)

Nice to ear that our patch got integrated smile Punbb's much, much, much more faster since we applied it wink

Smartys, it's useful as it will reduce the pagesize sent to the client, but i don't really see how it could possibly reduce cpu use...

4. Be sure to enable gzip compression. This will result in much smaller pages being served to compatible clients (just about every single somewhat modern browser), which not only improves performance but will also result in a lot of saved bandwidth. Please note though that for this to work with lighttpd, you should enable it in your php.ini file instead of using something like the module for apache.

This is the best way to use a LOT of CPU. Don't activate that.
We did this: http://punbb.org/forums/viewtopic.php?id=13208

And are working on Rickard's advice about it...

Up... Rickard, could we have your advice on this?

Hi, I am managing a quite big punbb forum (+- 500 000 posts). We have had recently some real performance problems, forum hits sometimes taking anormally long.

We searched a lonnnng time for the cause of the problem, tuning our fastcgi configuration, php environment vars, before stating the problem was the SQL server. I got help from some guys working at skyblog.com (understand: far more qualified than I am), and they stated the error was coming from the search queries.

After investigating the problem some time, they gave me that patch: http://www.skyblog.com/search.php.patch

Before yelling that it may break searches in some cases: we know it! As fas as I understood it, it may display inappropriate search results for posts that have been removed, moved, changed, whatever. But, still, have a look at the performance change:

http://waste.mandragor.org/mawu_cpu.png
http://waste.mandragor.org/mawu_slow.png
http://waste.mandragor.org/mawu_load.png

The patch was applied at 16h.

So, let's think about it: would there be one way to push that join out of the search query? Deleting that join would dramatically improve punbb's performance.

Anyway, even if some queries aren't as accurate as before and if the patch introduces some wrong-true results, I'm so happy these performances problems have ended, I wanted to share that with you!

I got some of these in my slow_queries.log, could you tell me what they are?

# Time: 060622 12:01:41
# User@Host: ubuntu_fr[ubuntu_fr] @ mawu-ubuntu.apinc.org [80.82.17.132]
# Query_time: 12  Lock_time: 0  Rows_sent: 30  Rows_examined: 85767
use ubuntu_fr;
SELECT t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id FROM forum_posts AS p INNER JOI
N forum_topics AS t ON t.id=p.topic_id WHERE t.id IN(41669,42011,42031,24379,27624,28508,36848,29075,29913,30432,30702,30780,30935,30900,31442,31650,316
54,44943,32056,32211,32369,32461,32507,32933,33001,33344,33705,33772,42072,34036,34693,34758,34812,34879,36086,34946,35338,35730,35658,35713,35838,35873
,35983,36053,36146,36556,37585,36641,36773,36998,37181,37203,37213,37228,37257,37286,37543,37374,37376,37425,37427,37717,42297,37789,37889,38062,38114,3
8117,38386,38453,38539,38639,38653,38720,38731,38828,38849,38852,38912,38921,38949,38989,39106,39493,39275,39248,39424,39536,39577,41716,39729,39870,397
92,39826,39885,39995,40038,40042,40066,40117,40094,41829,40143,40173,40228,40278,40384,40421,40551,40571,40574,40578,40685,40918,40642,40639,40718,40726
,40733,40750,40798,40863,41055,40994,40995,41027,41306,41077,41117,41125,41135,41206,43335,41239,41243,41283,42021,41314,41366,41379,41383,41388,41401,4
1412,41489,41420,41436,41447,41927,41679,41553,42026,41576,41586,41628,41630,41645,41667,41660,41712,41701,41798,41721,41739,41776,41786,41781,41925,418
06,41810,41815,41948,41861,41992,41909,41919,41933,41926,41928,41929,41931,41936,41937,41938,42183,41959,41961,41982,41971,41973,41976,41983,41986,41993
,41997,42056,42014,42032,42044,42045,42047,42051,42057,42069,42083,42114,42124,42125,42128,42166,42139,42142,42154,42158,42159,42161,42165,42182,42195,4
2200,42205,42413,42290,42339,42389,42417,42561,42575,42589,42646,42682,42753,42789,42795,42929,43061,43190,43344,43683,43680,43684,43879,43930,44031,440
35,44342,44425,44677,44840,44939,45039,45248,45281,45754,45957,46210,46271,46458,46604,43364,820,43177,1628,4086,4342,6277,7514,43174,8259,8966,41888,98
59,12140,12382,44297,41946,15369,15952,42015,16518,42030,42453,16940,42916,18393,43380,43455,19806,21445,22347,23479,23575,23789,44892,44891,24930,25274
,26628,26787,27603,28318,28735,43915,30611,46008,31814,31859,31960,32046,32066,32607,33118,33213,45244,33680,34022,34091,34100,34457,43154,35731,35785,4
5276,36075,44156,36490,36579,36788,36864,39081,39257,39287,46240,39355,39406,39420,39542,39628,39651,39739,40787,39775,40122,40400,40668,40513,40541,409
83,41005,41020,41063,41075,41193,41218,41226,42235,41347,42484,41517,41534,43639,41558,41964,41587,41592,41593,41658,41674,42084,41605,44584,42052,42391
,41676,43582,41744,41745,41823,41900,42140,41842,41862,41897,41910,41920,41941,44974,41958,46356,41974,42082,41998,42013,42004,42027,42036,42038,42075,4
2070,42118,42079,42833,42091,42100,42107,42111,42116,42119,42123,42130,42135,42152,42175,42300,42673,42245,42204,42192,42206,42221,42210,42461,42225,422
29,42232,42233,42269,42264,42272,42271,42287,42288,42295,42325,42304,42318,42337,42341,42346,42351,42367,42378,42502,42371,42382,42396,42400,42437,42435
,42426,42430,42431,43238,42462,42443,42496,42446,42459,42465,42471,42472,42490,42495,42851,42499,42500,42506,42513,42518,42837,42625,42542,42539,42540,4
2541,42557,42601,43173,42588,42605,42594,42599,42628,42621,42619,42708,42652,42655,42662,42788,42685,42687,42721,42714,42724,42727,42728,42762,42731,427
35,42736,42739,42743,42748,42765,42778,42784,42792,42794,42797,42804,42811,42814,42825,42832,42841,42948,42877,42860,42863,43658,42868,42881,42873,42882
,42898,42974,42926,42928,42931,42935,42939,42963,42947,42951,42954,46165,42965,42969,42973,42975,42978,42989,42985,45036,43382,43018,43021,43022,43031,4
3040,43037,43894,43043,43079,43042,43044,43047,43052,43060,43068,43072,43086,43074,43081,43087,43134,43102,43296,43114,43252,43170,43137,43178,43172,431
47,43149,43157,43226,43161,43167,43337,43188,43193,43199,43201,43212,43375,43248,46033,44166,43688,43241,43247,43256,43270,43273,43281,43283,43334,43294
,43333,43354,43302,43504,43303,43307,43317,43321,43323,43326,43338,43355,43363,43367,43385,43386,43417,43418,43426,43442,43428,43431,43441,44754,43494,4
3449,43457,43466,43467,43470,43476,43909,43773,43484,43485,43490,43493,44129,43513,43503,43511,43516,43524,43531,43533,43537,43539,43542,43543,43547,435
48,43553,43568,43570,44804,43579,43581,43586,43610,43590,43599,43651,43607,43608,43609,43641,43645,43647,43656,43664,43668,43672,43675,43678,43685,43686
,43782,43691,43695,43704,43716,43735,43711,43714,43719,43723,43724,43734,43922,43745,43757,43765,43791,43805,43806,43807,43809,43810,43813,43823,43832,43829,43839,43943,43903,45228,43875,44300,43878,43885,43887,43914,43931,43934,43936,43940,43944,43946,43956,43965,43970,43983,43984,44003,43993,44002,440
04,44038,44539,44016,44034,44037,44039,44040,44044,44055,44063,44065,44070,44083,44101,44113,44119,44153,44138,44140,44144,44147,44152,44157,44159,44176
,44163,44165,44179,44188,44185,44187,44241,44191,44204,44211,44213,44214,44218,44222,44223,44234,44301,44249,44251,44263,44276,44284,44298,44302,44308,4
4321,44326,44337,44347,44349,44360,45134,44376,44865,44398,44514,44397,44400,44475,44416,45139,44464,44602,44438,44453,44455,44456,44461,44463,44465,444
67,44489,44511,44500,44817,44501,44502,44505,44510,44702,44530,44566,44568,44569,44572,44580,44640,44603,44607,44609,44615,44630,44641,44658,44665,44681
,44753,44690,44693,44703,44711,44716,44735,44752,44749,44770,44771,44783,44785,44792,44795,44812,44816,44843,44841,44852,44854,44885,44886,44903,44912,4
4914,44920,44929,45848,44942,45126,44960,44958,45098,44978,44983,44989,44997,44998,45011,45016,45017,45024,45029,45031,45035,45163,45074,45075,45078,457
46,45082,45095,45106,45121,45172,45173,45313,45184,45188,45190,45194,45202,45347,45217,45235,45221,45230,45232,45234,45236,45239,45245,45551,45252,45255
,46284,45265,45270,45278,45295,45771,45307,45308,45310,45314,45315,45495,45321,45331,45341,45354,45369,45387,45389,45391,45396,45398,45858,45402,45410,4
5452,45438,45450,45458,45459,45463,45474,45480,45485,45486,45487,45489,45491,45499,45508,45516,45519,45524,45777,45642,45530,45534,45539,45544,45588,455
68,45576,45580,45617,45592,45593,45595,45611,45613,45631,45615,45618,45634,45640,45652,45653,45655,45660,45659,45690,45674,45780,45678,45681,45687,45683
,45695,45694,45697,45696,45763,45706,45711,45715,45721,45725,45727,45735,45741,45745,45750,45753,45772,45813,45801,45804,45811,45821,45817,45825,45815,4
5838,46417,45850,45859,45872,45884,45893,45894,45899,45964,45907,45909,45913,45932,45940,45952,45956,46027,45996,45997,46005,46010,46028,46030,46035,460
38,46053,46258,46071,46080,46083,46094,46115,46098,46100,46101,46102,46196,46106,46109,46118,46116,46123,46127,46137,46150,46156,46163,46167,46432,46178
,46189,46255,46211,46212,46213,46228,46317,46241,46265,46344,46270,46275,46276,46277,46282,46291,46426,46302,46313,46318,46401,46334,46336,46367,46342,4
6357,46485,46455,46398,46392,46468,46414,46413,46425,46427,46496,46430,46449,46497,46466,46474,46488,46507,46495,46501,46503,46504,46538,46505,46516,465
32,46551,46563,46571,46573,46577,46578,46581,46583,621,1690,2001,2121,5273,7257,7461,7809,8141,41796,10256,11628,12469,41914,12822,13040,13981,42064,148
12,15615,16901,42547,17956,18467,18656,18849,19409,19958,43535,20312,20333,21259,22599,22740,23085,23422,23636,44877,24451,25681,25684,25977,26551,26941
,28170,29086,29091,29094,29444,30093,30753,30829,31613,32697,33051,33433,33483,37979,33561,45191,34454,34481,34471,34576,34596,34817,35438,35752,35932,3
6145,36329,36674,37014,36941,37002,37058,37314,37860,38019,38095,38721,38797,39245,39266,39694,39740,39925,40070,40091,40348,46565,40509,40713,40868,409
48,41010,41059,41216,41298,41324,41354,41363,41947,41442,41459,41470,41702,44573,41653,41672,41698,41696,41707,41943,41787,41814,41821,41851,41833,41891
,41967,41969,42006,42012,42008,42022,42033,42086,42096,42115,42120,42137,42181,42178,42208,42202,42203,42227,42322,42265,42283,42291,42306,42311,46151,4
2334,42347,42372,42381,42397,42394,42405,42528,42436,42454,44381,42466,42489,42554,42514,42529,42577,42639,42651,42653,42669,42681,42717,42744,42694,427
09,42712,42720,42755,42764,42782,43412,42839,43109,42892,42857,42865,42867,42874,42878,42888,42910,42933,42964,44258,42991,42994,43000,43003,46586,43026
,43028,43046,43067,43869,43105,43113,43122,43148,43180,43191,43209,43673,43259,43422,43268,43291,43292,43300,43305,43312,43313,43315,43331,43341,43495,4
3402,43413,43451,43463,43474,43483,43491,43741,43505,43622,43550,43546,43635,43666,43708,44190,43727,43760,43780,43837,43847,43854,43897,43902,43916,439
45,43947,43975,45053,43978,43986,44011,44066,44074,44073,44075,44098,44112,44116,44127,44143,44168,44183,44196,45359,44202,44203,44210,44221,45136,44961
,44387,44361,44384,44386,44639,44406,44427,44434,44437,44448,44450,44460,44471,44522,44523,44526,44540,44610,44581,44613,44627,44617,44636,44655,44678,4
4664,44660,44720,44679,44685,44845,44686,44694,44831,44697,44698,44701,44766,44758,44786,44794,44813,45080,44818,44864,44871,44922,44941,44988,44975,449
94,44977,45382,45054,45086,45092,45096,45103,45157,45166,45161,45216,45240,45376,45197,45198,45209,45211,45272,45242,45249,45250,45284,45267,45294,46546
,45297,45303,45317,45564,45325,45921,45357,45367,45419,45383,45418,45429,45432,45444,45488,45503,45506,45538,45579,45616,45625,45637,45645,45663,45664,4
5673,45686,45693,45918,45704,45710,45712,45720,45775,45779,45800,45842,45831,45836,45898,45917,45937,45955,45960,45966,45983,46420,46018,46037,46025,460
60,46122,46121,46141,46142,46143,46158,46166,46169,46170,46176,46193,46200,46236,46289,46307,46316,46335,46347,46351,46358,46380,46389,46390,46395,46400
,46424,46442,46454,46459,46528,46477,46482,46494,46537,46602,46541,46548,46570,46575,46595,46597,46615,2,1963,2906,4696,41668,5976,41906,41752,8401,8444
,8549,8851,11696,12592,13132,43528,42010,15775,15890,16679,18965,21243,21571,44838,22968,23445,45127,24669,24762,25162,26307,45510,27527,27596,28445,330
48,32010,32484,33072,33618,33948,34008,45288,35643,36000,36180,36254,36630,36800,36801,36852,36930,37787,42914,39415,39887,39983,40241,40346,40352,42092,40606,40746,40875,40972,40993,41006,41070,41355,41482,41577,41637,41711,41709,41723,41827,41826,41873,41880,41932,41913,41934,41942,42121,41979,42088,4
2025,42246,42048,42053,42067,42081,42101,42076,42077,42087,42102,42109,42112,42131,42155,42151,42163,42162,42173,42164,42174,42180,42185,42193,42191,422
14,42220,42224,42231,42239,42240,42252,42248,42251,42256,42262,42270,42281,42274,42298,42309,42333,42364,42344,42345,42349,42360,42388,42401,42402,42407
,42432,42475,42483,42524,42585,43396,42606,42612,42626,42629,42638,42656,42827,42659,42660,42713,42779,42808,42823,42828,42834,42852,42862,42887,42897,4
2980,42983,43056,42995,43065,43071,43125,43094,43099,43117,43159,43187,43222,43225,43293,43342,43371,43374,43387,43926,43462,43544,43529,43612,43560,438
31,43606,43621,43676,43693,43949,43730,43737,43739,43767,43766,43797,43890,43900,43906,43912,43920,44283,43955,46261,43959,43988,43992,44001,44020,44032
,44094,44726,44084,44423,44250,44189,44232,44369,44248,44257,44266,44767,44305,44307,44318,44323,44328,44341,44345,44353,44395,44418,44391,44457,44407,4
4441,44806,44611,44503,44509,44555,44550,44695,44773,44901,44796,44868,44805,44811,44834,44836,44873,44928,44933,44945,44965,44946,44953,44973,44993,449
80,44982,45021,45052,45135,45141,45153,45177,45251,45293,45412,45426,45461,45462,45467,45533,45521,45537,45548,45563,45585,45599,45609,45607,45622,45623
,46031,45656,45776,45675,45722,45783,45737,46034,45961,45868,45809,45819,45852,45866,45890,46238,45924,45920,45988,45977,46004,46063,46131,46139,46252,4
6201,46207,46215,46256,46251,46411,46297,46324,46327,46445,46456,46475,46518,46523,46520,46531,46553,46584,46596,46613,5515,27379,27640,31452,36235,3857
8,38306,39263,39779,40612,41561,41506,41996,42020,42327,42249,42531,42533,42671,42679,42725,43100,43118,43171,43197,45761,43459,43508,43517,43792,43660,
43669,43895,43991,44161,44184,44413,44608,44824,45070,45922,45320,45346,45479,45647,46120,46187,46415,46428,46471,46481,46483,436,681,15339,19753,43794,
43815,21491,44080,44356,28431,31417,34828,46146,35453,37920,38399,39050,40004,40159,40422,40827,40976,41353,41662,41853,41896,41970,41975,42189,42041,42
029,42023,42050,42085,42104,42464,42197,42236,42244,42263,42267,42275,42284,42286,42310,42943,42340,42392,42398,42410,42576,42429,42452,42667,42470,4248
2,42486,42523,42530,42543,42553,42546,42570,42579,42591,42616,42617,42684,42704,42693,42700,42805,42738,42775,42843,42793,42990,42854,42875,43223,42924,
42941,42942,42961,42992,43004,43214,43142,43115,43124,43236,43128,43151,43160,43210,43213,43237,43251,43253,43306,43319,43340,43390,43392,43415,45442,43
452,43460,43468,43471,43479,43499,43502,43571,43594,43614,43663,43690,43729,43743,43796,43789,43908,43932,43958,43962,43972,44068,44104,44078,44093,4412
0,44154,44164,44172,44169,44180,44499,44293,44449,44408,44490,44543,44557,44605,44582,44595,44600,44623,44616,44622,44635,44651,44644,44657,44675,44724,
44737,44740,44789,44797,44826,44828,44833,44847,44869,44888,44904,44954,44955,44985,45405,45147,45144,45219,45229,45351,45350,45378,45393,46594,45774,45
468,45478,45560,45570,45670,45646,45803,45880,45904,45954,45971,45993,46036,46055,46078,46086,46088,46133,46124,46130,46135,46138,46159,46183,46205,4628
7,46310,46576,46368,46373,46391,46453,46479,46492,46506,46549,46567,200,43176,4223,7509,7626,16449,17597,21224,26565,46363,45925,27993,33790,37601,37482
,38076,38251,39744,43990,40445,40555,40745,41004,41038,41128,41139,41266,41331,41357,41432,41540,41620,41846,41963,41876,41878,41981,41989,42042,42068,4
2194,43357,42133,42156,42141,42215,42201,42242,42228,42230,42237,42254,42258,42259,43135,42276,42285,42302,42312,42313,42355,42356,42353,42354,42369,423
70,42517,42393,42406,42424,42414,42419,42448,42451,42481,42505,42492,42497,42508,42537,42551,42562,42558,42560,42568,42580,42678,42609,42614,42623,42631
,42643,42640,42654,43057,42732,42740,42759,42767,42802,42780,42855,42817,42820,42822,42876,42904,42909,42930,42923,42936,42944,42949,42956,42960,42962,4
2981,42997,43005,43017,43006,43058,43062,43063,43070,43095,43103,43133,43189,43145,43184,43221,43454,43203,43217,43219,43231,43282,46194,43359,43348,433
76,43384,43393,43394,43406,43408,43421,43433,43450,43453,43456,43549,43569,43591,43655,43692,43712,43886,43750,43772,43785,43818,43825,43870,43855,43867
,43871,44008,43999,45542,44049,44059,44110,44069,44849,44086,44096,44099,44109,44122,44676,44145,44175,44181,45223,44270,44230,44231,44253,44269,44330,4
4275,44281,44762,44292,44299,44338,44350,44351,44567,44374,44375,44382,44393,44403,44430,44556,44559,44620,44673,44764,45152,44736,44769,44778,44782,455
57,44793,44822,44853,44890,44910,44934,44972,44987,44996,45007,45015,45083,45150,45156,45243,45253,45311,45328,45455,45349,45517,45413,45407,45408,45425
,45456,45481,45482,45493,45501,45505,45635,46154,45915,45672,45702,45740,45743,45768,45795,45818,45834,45837,45839,45849,45844,45883,45934,45941,45974,4
5986,46042,46026,46047,46043,46077,46084,46092,46179,46112,46155,46177,46182,46221,46239,46233,46599,46285,46288,46295,46296,46320,46352,46407,46422,464
43,46444,46457,46472,46487,46515,46526,46545,46547,46552,46556,46557,46609,10177,13873,14863,21377,21919,24279,26803,29307,29861,31184,32404,33578,33836
,35715,41854,2046,7647,11766,15763,19424,19062,20519,22729,26942,28728,32719,36339,36679,38843,38899,39232,39985,40009,40353,40596,40628,40655,40898,410
60,41282,41502,41809,41585,41859,42007,42016,42073,42095,42132,42169,42301,42416,42442,42468,44682,42637,42573,42661,42702,42766,42986,43194,43023,43055
,43155,43255,43258,43264,43388,45206,43593,43389,43400,43736,43874,43963,44021,44036,44340,44433,44440,44535,44558,44560,44601,44715,44757,44858,44894,4
5169,44951,46104,45128,45164,45668,45333,45271,45286,45436,45445,45525,45562,45584,45586,45587,45784,45867,45919,45953,46000,46293,46147,46161,46175,463
64,46431,46579,46514,46529,46607,46622,1156,2518,41754,17101,19119,24199,29621,33077,33120,34068,34746,35712,37104,37259,38448,39624,39530,40131,44800,4
1220,41292,41277,41610,41991,41944,42074,45045,42438,42608,42773,42774,42809,43015,43054,43196,43330,43731,43808,43862,43899,43910,43952,44045,44092,441
05,44148,44252,44267,44273,44358,44481,44484,44570,45215,44688,44777,44779,44918,44971,45005,45110,45142,45264,45257,45263,45360,45380,45460,45665,45791
,45856,45905,45870,45929,45973,46022,46089,46157,46268,46230,46247,46321,46372,46383,46465,46489,46564,46616,107,158,226,1550,3790,3849,6357,41666,10060
,10966,12064,13278,16517,17043,17470,19798,19884,23137,23179,23567,23871,25128,26973,27463,32255,32971,33389,34707,34910,35196,36038,35561,35590,35774,3
6372,45649,37688,37930,38025,38867,38868,44378,40700,41203,41217,41368,41621,41652,41657,41661,41789,41836,41980,42054,42062,42136,42153,42282,42365,423
77,43267,42521,42583,42647,42677,42706,42846,42772,42906,42911,43010,43078,43083,43089,43254,43287,43556,43574,43589,43604,43637,43776,43836,43872,43880,43905,43933,43942,43953,43994,44041,45807,44158,44216,44228,44233,44238,44277,44355,44370,44401,44446,44466,44477,44492,44634,44632,44652,44710,44765,4
4935,44791,44825,44839,45633,45162,44884,44900,45091,45048,44957,45088,45338,45266,45371,45406,45441,45515,45540,45546,45578,45583,45767,46044,45728,457
55,45759,45802,45799,45827,45824,45855,45927,45958,45970,46052,46217,46224,46294,46306,46339,46348,46371,46379,46382,46484,46550,46574,46610,400,1117,11
99,1742,3087,4734,5193,5302,5901,5938,5978,7760,8539,8835,10744,10761,43227,11905,12257,41899,14283,14701,14941,42065,42017,15959,16289,16610,16631,1703
2,18838,18844,43438,19948,43534,20780,43800,21987,22739,22806,23055,23376,23593,24446,25626,25954,26172,26563,26647,26819,27336,27410,27995,28267,28801,
45744,29186,30434,30869,31206,31541,32137,32316,32618,32943,32777,32986,33266,33340,33632,34057,44334,34259,34854,34900,34942,35268,35269,35382,35546,35
548,35595,35608,36124,36887,36898,37125,37569,37458,37772,37864,37886,37943,38245,38534,38614,45336,38681,38713,43706,38768,38781,44324,38966,39082,3910
8,46470,39271,39486,39946,46264,40100,40124,40188,40203,46404,40343,40446,40479,40641,40657,40769,40791,40890,40909,41026,41118,41170,41175,41174,42117,
41538,45446,41332,41313,41424,41408,41453,41492,41514,41554,41579,43049,41614,41623,41697,41717,42350,41771,42680,41885,41894,41924,41915,41923,41935,41
962,41966,41972,42002,42040,42058,42060,42080,42110,42090,44087,42129,42150,42147,42399,42186,42188,42209,42211,42213,42217,42218,42222,42234,42261,4233
1,42289,42317,42319,42321,42328,42330,42366,42485,42380,42411,42404,44303,42870,42441,42445,42447,42469,42474,42511,42705,42510,42512,42515,42522,42525,
42534,42538,42545,42567,42571,42604,42574,42611,45116,42607,42615,42622,42658,42644,42650,42663,42665,42670,42674,42683,42691,42692,42690,42697,42699,42
703,42719,43027,42741,46097,42757,42838,42776,42781,42785,42790,42819,42799,42803,42806,42830,42829,42856,42864,42871,42879,44271,42900,42902,43130,4290
3,42913,42918,42927,43703,42932,42984,43873,42957,42971,43001,43121,43013,43014,43016,43033,43034,43036,43050,43053,43106,43110,43119,43120,43144,43150,
43158,43162,43175,43181,43183,43242,43205,43216,43230,43243,46032,43261,43262,43265,43277,43285,43288,43299,43398,43361,43401,43588,43365,43378,45332,43
399,43407,43409,43411,43643,43423,43424,43432,43434,43440,43443,44219,43465,43469,43481,43487,43616,43587,43520,43525,43536,43545,43572,43576,43583,4360
2,43629,43611,43618,43630,43632,43633,43640,43667,43671,43682,43694,43697,43702,43717,43718,43726,43740,43744,43748,43911,43783,43753,44009,43764,43770,
43774,43775,43790,43795,43828,43842,43804,43811,43812,43814,43816,43820,43821,43827,43830,43844,43845,43850,43852,43857,43860,43861,43865,43866,43893,43
904,43917,44017,43941,43961,44097,43969,43971,44061,43979,43995,43996,44005,44006,44007,44012,44013,44024,44030,44048,44050,44103,44123,44056,44095,4410
8,44114,44117,44132,44134,44139,44150,44142,44173,44174,44371,44193,44431,44197,44201,44209,44259,44224,44240,44242,44243,44244,44268,44278,44290,44286,
44316,44372,44311,44336,44462,44359,44388,44364,45224,44474,44390,44396,44405,44410,44424,44447,44480,44482,44488,44498,44863,44524,44527,44548,44542,44
544,44545,44561,44578,44565,44574,44612,44579,44596,44598,44604,44606,44621,44625,44721,44629,44647,44633,44638,44643,44650,45504,44653,44659,44861,4466
7,44823,44680,44687,44696,44699,44700,44705,44712,44932,44731,44734,44747,44738,44755,44756,44772,44774,44781,44776,44798,44799,44815,44827,44829,44832,
44835,44837,44906,44856,44908,44911,44921,44925,44931,44938,44950,44947,45117,44949,44952,44981,44966,44968,45608,44984,44995,45115,45000,45008,45038,45
059,45472,45084,45137,45090,45094,45113,45149,45124,45279,45130,45133,45143,45159,45155,45158,45160,45180,45183,45167,45168,45175,45186,45187,45196,4520
3,45205,45218,45213,45222,45277,45301,45258,45300,45302,45304,45309,45327,45329,45319,45782,45348,45365,45386,45366,45415,45375,45388,45394,45621,45390,
46020,45430,45422,45433,45601,45475,45470,45496,45497,45498,45500,45513,45556,45523,45529,45654,45531,45545,45547,45549,45566,45558,45559,45571,45602,45
581,45606,45603,45619,45717,45628,45644,45658,45793,45669,45689,45736,45701,45709,45714,45778,45765,46012,45876,45806,45814,45833,45851,45873,45877,4588
2,45888,45896,45901,45903,45908,46059,45931,45944,45965,45979,45980,45984,45987,45998,46002,46006,46007,46011,46017,46589,46023,46046,46049,46065,46074,
46081,46090,46091,46093,46099,46107,46110,46114,46153,46172,46199,46185,46190,46195,46197,46209,46218,46227,46237,46332,46260,46266,46281,46283,46292,46
299,46319,46325,46328,46354,46346,46361,46377,46448,46393,46394,46402,46403,46410,46498,46435,46437,46452,46539,46450,46460,46534,46490,46493,46511,4651
3,46533,46536,46542,46544,46555,46566,46561,46582,46593,46608,623,3441,3485,2458,4511,4630,6352,6392,7190,7457,8770,9147,9924,11117,13891,13931,41994,41
954,15166,15648,16182,17363,17463,18738,19533,19686,19984,20359,20679,43891,22614,23023,24030,24806,45207,26037,26055,45148,26702,27577,27171,27250,2744
3,28008,27779,27929,28026,28812,29169,29430,29776,29910,45612,30938,31354,31773,31668,32691,32798,33388,33503,33706,34340,34349,34412,34442,34543,34811,
35279,35445,35661,36637,40930,36988,37327,37590,37656,37823,42494,37881,42958,45384,38078,38232,38263,44586,38304,38795,38365,38424,38513,38894,38967,39
032,39208,39750,39867,39955,40132,40439,42122,40417,40502,45677,40519,40544,40576,40708,42257,41017,41509,41154,41791,41364,41429,41450,41446,41467,4152
2,41949,41570,41591,41594,41601,41611,41612,41619,41624,41740,41766,41777,41822,41819,41820,41849,41892,41916,41957,42000,42019,42024,42035,42039,42059,
42600,42063,42066,42071,42103,42093,42148,42268,42106,42149,42157,42338,42207,42266,42308,42303,42329,42326,42343,42423,45081,42359,42361,42363,42384,42
519,42434,42450,42478,43088,42584,42596,42696,42636,42686,42672,42675,43107,42707,42711,42715,42729,42730,42733,42760,42746,42754,42807,42815,42894,4284
0,42842,42848,42869,42872,42886,42890,42893,42905,42946,42966,43541,43008,43025,43029,43041,43051,43059,43073,43084,43104,43112,43195,43192,43228,43233,
43229,43240,43257,43679,43263,43271,43272,43274,43279,43284,43297,43301,43318,43328,43352,43350,43475,43625,43439,43444,43458,43482,43480,43628,43507,43
509,43756,43575,43598,43603,43619,43698,43646,43662,43710,43888,43781,43853,43787,43786,43822,43826,43838,43843,44399,43868,43889,44022,43954,46132,4396
0,43998,44010,44019,44033,44235,44042,44047,44058,44348,44076,44199,44208,44624,44236,44280,44287,44288,44312,44352,44366,44367,44368,44373,44383,44436,
44392,44411,44414,44419,44420,44422,44439,44472,44487,44495,44506,44507,44515,44517,44518,44519,44521,44520,44525,44529,44533,44538,44547,44549,44564,44
576,44587,44671,44626,44628,44649,44642,44646,44656,44668,44729,44719,44713,44717,44727,44748,44763,44780,44787,44788,44820,44860,44857,44866,44875,4487
9,44881,44883,44902,45330,44917,44930,45033,45326,45042,45004,44999,45037,45165,45046,45051,45085,45055,45077,45104,45109,45118,45119,45170,45181,45189,
45200,45195,45210,45254,45269,45259,45260,45262,45268,45273,45305,45322,45355,45385,45411,45552,45424,45632,45437,45447,45448,45476,45477,45527,45512,45
514,45543,45554,45567,45639,45582,45597,45684,45627,45643,46286,45692,46079,45723,45730,45724,45726,45732,45738,45739,45742,45781,45829,45816,45863,4583
0,45841,45865,45864,45875,45895,45906,45933,45978,45995,46014,45999,46003,46021,46056,46064,46073,46105,46173,46144,46186,46204,46206,46226,46232,46246,
46278,46262,46279,46436,46333,46349,46366,46375,46399,46406,46408,46409,46416,46439,46478,46508,46519,46525,46543,46559,46585,46590,46605,46606,46618,46620,761,1015,3321,4531,6842,7536,41751,41748,8855,41968,12367,41953,15590,15721,16181,17300,42917,18390,20144,20213,44071,44889,24777,24910,45174,27643,
27840,27888,28036,29017,31502,31580,32364,43430,34018,35083,35118,42787,35165,35220,35611,36083,37070,37107,43677,37644,41901,38372,38542,38668,39516,39
565,39706,40047,40249,40334,40546,40590,44192,41678,41249,41330,41460,41541,41659,41687,43349,41825,41905,42046,41995,42043,42113,42385,42167,42176,4231
5,42390,42420,42439,42456,42479,42487,42503,42535,42572,42593,42633,42635,42648,42688,42718,42777,42770,42768,42769,42800,42818,42847,42915,42976,42970,
43045,43841,43127,43141,43143,43156,43208,43801,43308,43298,43295,43289,43314,43310,43353,43381,43403,43592,43419,43523,43486,43512,43515,43538,43580,43
636,43585,43615,43597,43638,43650,45466,44151,43802,43840,43834,44085,44057,44029,44064,44090,44106,44245,44125,44131,44162,44344,44195,44237,44254,4511
2,44296,44320,44362,44760,44402,44404,44415,44802,44454,44426,44459,44478,44485,44504,44528,44532,44537,44552,44575,44589,44591,44631,44654,44743,44674,
44746,44830,44750,44751,44810,45747,44862,44915,44927,44916,44944,44986,45003,45012,45023,45028,45030,45093,45101,45192,45178,45193,45204,45208,45212,45
214,45247,45786,45256,45275,45290,45352,45358,45364,45550,45528,45399,45509,45471,45502,45535,45569,45605,45614,45624,46108,45671,45685,45729,45733,4577
3,45976,45832,45835,46188,45886,45891,45897,45900,45910,45930,45945,45972,45991,46015,46024,46062,46145,46160,46191,46202,46214,46225,46231,46269,46301,
46303,46315,46330,46331,46350,46355,46362,46365,46384,46397,46419,46476,46521,46568,46572,46588,46600,46621,1043,7682,11893,30852,34894,35570,39051,3726
2,37894,38944,39252,39753,40116,40477,40429,40650,41763,41839,41955,42455,42745,42756,43152,43198,43290,43526,44100,43778,43967,43966,43977,44015,44206,
44229,44592,44718,44895,45087,45097,45107,45427,45573,45604,45703,46162,46378,46433,23,2662,8899,42323,18850,22891,25045,27107,31406,33407,35151,36806,3
7108,43833,38794,40256,40637,42742,42374,46601,41874,41895,41960,43670,42247,42097,42108,42144,42170,42184,42238,42243,42280,42376,42357,42379,42460,424
67,42504,42507,42627,42771,42968,42993,43082,43111,43182,43339,43416,43500,43798,43763,43777,44215,43913,43973,43985,44239,44304,44322,44531,44898,45409
,44948,45047,45108,45808,45171,45434,45680,45572,45698,45981,46019,46096,46203,46337,46343,46418,46463,732,41952,44897,42613,30231,35508,42563,37988,406
63,40859,43901,41146,41336,42126,42216,42219,42223,42408,42457,42476,42509,42532,42548,42695,42634,42750,42796,42836,42853,42901,42934,43075,43358,43530
,43521,43657,43709,43876,43849,44027,44124,44205,44247,44445,44536,44551,44648,44669,44704,44940,45076,45111,45138,45403,45483,45638,45789,45916,45878,4
6076,46300,46592,46619,2962,4600,6446,6479,6512,6803,7799,7896,8523,10530,10852,13803,15913,41985,15557,16670,42037,16775,17087,18625,19768,20006,20145,
20437,20557,43951,21220,21812,23046,23433,23365,23689,26516,26844,27196,28888,29615,32575,33674,34185,35242,35225,35529,36750,38031,38411,39476,39521,40
040,40086,40703,41028,43788,41528,41956,41999,42171,42199,43410,42603,42649,43327,42749,42810,42812,42821,42907,43278,43085,43165,43169,43185,43204,4327
6,43448,43496,43518,43742,43846,43929,43968,43981,44121,44217,44429,44306,44339,44357,44380,44571,44976,45034,45049,45099,45125,45443,45316,45318,45401,
45414,45421,45454,45526,45594,45650,45679,45713,45845,45787,45810,45914,45949,46184,46267,46305,46326,46517,376,11625,29331,37501,33629,37572,38548,4016
9,40843,40849,41158,41167,41423,41767,41835,42003,42241,42292,42527,42549,42559,42578,42595,42858,42938,43577,43713,43858,43928,44126,44346,44389,44443,
44468,44663,44848,44855,44899,45073,45079,45145,45179,45397,45453,45923,45854,45935,45967,46054,46220,8111,44512,15057,43584,19713,20507,25742,28707,325
01,45435,33852,35227,42581,38058,38421,39052,39934,43372,40702,41263,42098,41889,42005,42018,42055,42138,42198,42226,42279,42273,42387,42375,42352,42415
,42433,42912,42488,42491,43069,42555,42556,42592,42602,42630,42632,42664,42676,42689,42723,42899,42885,42922,42937,42952,42977,43020,43009,43012,43522,4
3123,43153,43246,43202,44689,43224,43304,43336,43356,43351,43373,43436,43634,43532,43552,43687,43701,43707,43793,43819,43824,43851,43948,44018,44077,441
15,44225,44149,44264,44262,44310,44317,44432,44417,44645,44670,44672,44684,44691,44692,44846,44808,44936,44874,45009,45020,45027,45043,45132,46617,45220
,45226,45246,45469,45377,45420,45423,45484,45520,45575,45565,45629,45657,45662,45749,45752,45758,45769,45797,45794,45798,46164,45871,45911,45947,45975,4
5982,46039,46040,46072,46085,46168,46117,46462,46171,46192,46253,46249,46290,46314,46370,46387,46388,46421,46451,46438,46467,46469,46502,46591,46603,185
,43179,41454,2487,3803,10578,12828,13750,13769,14472,41987,16531,42324,19337,25166,45596,27407,28366,28396,28723,30819,31786,32790,34436,45963,43140,453
24,35123,35402,35858,42590,38308,38390,38734,38684,38811,38900,38909,39101,39168,42421,43652,40046,40470,40466,40515,40530,40535,40595,40675,40796,41054
,44081,41101,41150,41147,41169,41212,45682,41598,41603,41760,41779,41783,41866,42049,41907,41908,43997,42028,42061,43343,42105,42253,42255,42278,42296,4
2299,42307,42314,42332,42335,42383,42896,42362,42403,42422,42428,42440,42449,42734,42582,42544,42552,42566,43002,42597,42620,42618,42624,42641,42657,426
66,42668,42698,42710,42722,42737,42786,42791,42801,42816,42813,42884,42826,42831,42849,42866,42845,42861,42880,42972,42889,42908,42921,42950,42955,42979
,42982,42988,42998,42999,43038,43039,43048,43164,43090,43168,43139,43163,43206,43215,43218,43234,43235,43249,43266,43324,43275,43280,43488,43309,43320,4
3329,43332,43370,43395,43404,43600,43506,43429,43435,43437,43478,43557,43519,43561,43527,43559,43573,43595,43648,43624,43626,43907,43653,43674,43722,437
28,43733,43768,43769,43771,43799,45392,43864,43883,43892,43896,43918,43927,43937,43980,44025,44028,44051,44052,44062,44079,44102,44107,44111,44118,44130
,44128,44133,44135,44146,44167,44178,44486,44194,44220,44260,44265,44285,44294,44325,44335,44343,44354,44435,44562,44444,44442,44451,44452,44473,44493,4
4516,44513,44508,44534,44546,44577,44583,44588,44597,44637,44706,44759,44784,44969,46491,44913,45041,44872,45541,44882,44896,44907,44963,45001,45018,450
25,45044,45050,45056,45100,45114,45123,45131,45140,45151,45182,45225,45231,45237,45345,45274,45282,45289,45306,45335,45337,45339,45400,45342,45344,45353
,45356,45370,45374,45395,45439,45449,45465,45511,45522,45536,45553,45555,45676,45600,45574,45590,45591,45636,45661,45757,45688,45691,45707,45731,45756,4
5766,45788,45792,45812,45822,45847,45862,45869,45874,45881,45887,45889,45926,45951,45985,45990,45994,46061,46119,46113,46486,46148,46180,46219,46222,462
34,46248,46272,46308,46340,46374,46423,46434,46441,46464,46480,46554,46560,46562,4493,4904,5351,5641,6059,8781,13658,41951,15352,42919,44072,22166,44893,45846,29472,45298,36357,33834,35505,36726,36970,38500,38814,40061,42099,40163,40284,40416,41421,41463,41520,41688,41930,41977,44261,43383,42134,42143,4
2177,42179,42196,42212,42368,42260,42395,42425,42473,42498,43414,42758,42835,45323,42953,42987,43076,43098,43116,43129,43131,43136,43220,43245,43250,432
60,43360,43397,43498,43461,43489,43540,43699,43613,43623,43642,43665,43720,43725,43835,43882,43898,45040,43919,43957,44046,44014,44067,44054,44160,44200
,44212,44246,44295,44274,44282,45010,44412,44428,44469,44476,44491,45120,44683,44541,44666,44619,44742,44790,44880,44887,44923,44937,44964,44991,45022,4
5146,45154,45185,45201,45233,45241,45292,45312,45362,45372,45404,45416,45451,45473,45626,45764,46612,45716,45719,45762,45828,45853,45860,46041,46140,461
52,46259,46229,46257,46273,46280,46309,46311,46353,46369,46535,46580,17388,24999,30816,32408,34569,34674,35295,35334,36553,37307,40566,41990,42001,42516
,43101,44170,44409,44819,45019,45343,46359,41950,41988,22002,46069,27277,44332,44909,34749,34935,37681,37898,40146,40741,40643,41345,41548,41704,41729,4
1805,41881,41939,42146,42320,42305,42342,42348,42427,42463,42480,42493,44177,42520,42610,42642,43146,43091,43032,43024,43064,43092,43232,43311,43369,434
64,43715,43649,43681,43732,43747,43755,43817,43863,43923,43925,44207,44091,44141,44289,44313,44315,44327,44333,44385,44421,44458,44594,44844,44709,44745
,44761,44990,44801,44803,44850,44878,44967,44924,45013,44956,44970,45006,45032,45089,45105,45122,45238,45280,45291,45296,45363,45431,45699,45620,45630,4
5641,45790,45879,45938,45943,46009,46013,46048,46051,46066,46067,46068,46070,46075,46095,46216,46235,46323,46274,46312,46322,46329,46360,46440,46611,247
2,3341,7440,15655,16157,21213,23754,23916,25777,29756,31608,33379,35547,36747,41486,39512,40298,40840,40854,41144,45912,41689,41343,41556,41499,41816,41
978,41984,42009,42859,42089,42190,42293,42294,42386,42316,42358,42373,42409,42444,42536,42701,42564,42569,42587,42598,42716,42751,42824,42850,42844,4292
5,44962,43066,43211,43166,43186,43207,43377,43322,43286,43345,43346,43379,43391,43405,43578,43427,43446,43950,43477,43497,43551,43554,43620,43617,43644,
43803,43752,43754,43779,43848,43939,43924,43935,44775,43989,43964,43974,43987,44060,44379,44198,44226,44227,44272,44279,44291,44309,44314,44329,44331,44
394,44470,44479,44553,44483,44707,44618,44728,44723,44744,44807,44814,44821,44842,44979,45014,45057,45102,45176,45283,46136,45261,45334,45361,45368,4541
7,45457,45464,45494,45577,45507,45532,45610,45589,45648,45651,45700,45705,45748,45751,45770,45785,45820,45826,45840,45942,45857,45892,45885,46058,45968,
45969,45989,45992,46001,46045,46050,46057,46111,46134,46082,46128,46103,46149,46198,46250,46254,46338,46298,46304,46381,46446,46405,46429,46447,46522,46
499,46510,46524,46558,46569,46587,46598,6830,25724,45518,41965,36843,39079,40504,41797,41903,41922,42168,42550,42565,42586,42726,42747,42783,42940,43007
,43019,43420,43108,44053,43316,43325,43347,43362,43425,43447,43473,45561,43596,43661,43749,43784,43859,44043,44088,44171,44554,44870,44919,45299,45490,4
5718,45823,45959,46016,46223,46245,46341,46509,12464,41945,22853,25010,33092,37719,38125,40121,40589,40593,40839,40838,41002,41049,41052,45734,41452,419
11,41921,41940,44593,42078,42094,42160,42458,42477,42752,42761,42763,42895,42883,42945,42959,42996,43035,43093,43096,43097,43138,43132,43200,43244,43269
,43366,43368,43445,43472,43510,43601,43605,43654,43696,43700,43738,43746,43856,43877,43938,43982,44023,44136,44365,44319,44363,44563,44585,45129,44722,4
4732,44768,44851,44926,45227,45381,45285,45428,45598,45843,45796,45861,45939,45962,46181,46243,46242,46263,46345,46386,46412,46461,46512,46527,30382,306
38,31190,31320,32224,34806,36181,37502,39112,40261,43659,43705,44155,44905,45936,46396,10789,25325,29842,37964,38021,38363,40563,41228,42277,43126,42920
,42967,44859,44876,46125,46540,15990,30058,37679,38181,39144,39169,40449,40531,40810,41056,41508,41589,41912,42172,42250,42891,42412,43689,43751,43921,4
4255,44494,44959,45440,45708,46029,46126,46500,46614,54,227,1430,4002,5479,9885,13407,17092,17565,17896,23528,24608,25399,26839,26975,28434,29138,31342,
33306,34446,43080,38339,39447,40332,40333,41724,43976,44000,44182,44256) GROUP BY t.id, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster,
 t.num_replies, t.closed, t.forum_id ORDER BY t.last_post DESC LIMIT 0, 30;

Looks pretty bad, doesn't it? And you know what, it's getting worse sad
Which query is this? May there be one way to improve it?

I applied smarty's patch. Is this gonna be fixed in punbb's next version? :]

"It's a goldmine for Linux help site developers, if you can bear the pain of dealing with countless hordes of people in desperate pain and confusion."

That's just because you never tried Ubuntu... Ha ha ha tongue

BTW, it's not only the user appearing more than once in the user list, but his posts are displayed twice or more too... Do that fix it too?

I'm still having the problem (users appearing more than once in the user list, and their post being displayed more than once)... Are the fixes above safe?

Brand new! wink
http://forum.ubuntu-fr.org

We don't really have to complain about punbb's speed... It's fast, we're really pleased with it (can't say the same with dokuwiki, though)  Would be far better with a better mod installation system... i'm looking forward 1.3... the video i saw a while ago was really impressive wink

Punbb rockz!

66

(9 replies, posted in Feature requests)

*Up*

Would really love to see full utf8 support in punbb 1.3 too smile

Rickard > it is a quite big forum, we're almost alone on our server. Is pconnect still a bad idea anyway?

Hi,

  using punbb 1.2.10, with pconnect, in utf8 (i now know this is bad - waiting for 1.3 ^^).

  Using pconnect sometimes seems to cause viewtopic.php to display only the first topic of the forum. Reloading the page fixes the problem.
  I did not encounter that anymore since I disabled pconnect 2 days ago.
  Is this a punbb bug? Might it be a server configuration issue?

it really isn't that easy wink I wonder if hacking the check_cookie would be enough, if yes then that's great.... i should give it a try... but as far as I remember, it might get a bit more complicated than just that sad

Keeping a common auth system on a website that uses lots of scripts like punbb, dokuwiki, dotclear, really is a pain... Until now I never managed to get Punbb use a third party authentification system. Would it be possible to improve the authentification system so that punbb would be able to use login/passwords from another database? I'd love it smile

EDIT: sorry would probably better fit in the Requests forum.

71

(2 replies, posted in Feature requests)

I know this was initially in the list of the "i won't implement these"... Is there any hope?

See: http://img359.imageshack.us/img359/9746 … tre9rr.jpg

I have _no_ idea what the problem could be.

I added the Html directly in index.php... quite ugly but works.
Bye!

In fact I would like to include the <pun_announcement> only on the homepage of my forum, with the forum list. Well in fact I'd like to do something like :

if page == index.php
  include <pun_announcement>

in the include/template/main.tpl

Anyone got a clue on how I could do that?

75

(200 replies, posted in General discussion)

Well, because gmail is not enough....
http://www.hriders.com/web_page.cfm?web_pageID=38

1TB of free mail space -_-