Working well so far Xenon :D

Seems to be loading well all round IMO :D

A little bit off-topic, but its funny to see when your looking at the forumbits from cache_forumhome table before and after a Zlib compression

Before:

<table bgcolor="#0A293E" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr align="center">
<td bgcolor="#1D6AA0"><smallfont> </smallfont></td>
<td bgcolor="#1D6AA0" width="80%" align="left"><smallfont color="#EEEEFF"><b>Forum</b>
</smallfont></td><td bgcolor="#1D6AA0"><smallfont color="#EEEEFF"><b>Posts</b>
</smallfont></td><td bgcolor="#1D6AA0" width="160" nowrap><smallfont color="#EEEEFF">
<b>Last Post</b></smallfont></td>
<td bgcolor="#1D6AA0" width="20%"><smallfont color="#EEEEFF"><b>New Post</b>
</smallfont></td>

Turning into something like this:
After:

sCãGZBçC֣ϤS0~p¼êJ5eµÃy¯£^üËÆ ñѪØGfÃ.oËÉ^,ÿ3ÊÈ
nð±¬ñqÏñ±|ôø¸,^j„<„¬äFÈ3>b!ëg÷|ò ¯¥¦/A¯œ{”Ä›_?–ëæ‘àc¥¶U|¬(d®=Þ
0V40î90VŽ—„I]K¡k)î/–þsh%ÐõÒºŽB×Qhª¿yªïä¦úiHºŽ°??� �?ãì¹@áø%ú:÷„ðâ‘
Í'Â*²–øç'úVµQÞ.Ñw”û½—\êŸ!©ÝÐ}G� �ý=§ûÎÑÓý¹P©S`‡ƒ‹µµqñôâxÍì×� �TŠe¤‡F6
Ÿü²k‰æ*˜XoT¶[<QS®Rh' µ]`bMcâžcbMcâL˜ÔÙ/ýZ’ýº[\ ¸9 :ñ¥_:ñ¥ þ
ƾû£ï@êfvoÖZ

:classic:

*hehe* ^^ I agree ;) Its a pain in phpMyAdmin as it causes and error if you click on the edit or delete link. However this is a small price to pay IMO if the compression saves a worthwhile amount of space.

@Aaron: 1 querie fluctuations are normal, whenever you login into your board after the cookietimeout of your last visit :)

@boofo: well that one can't work with the hack, because you'd combine dynamical content with cached content.....
to get it back on working correctly you'll lose the cacheing features of my hack :)

@NTDLR: ahh, good to hear :)

@Aaron: of course, the first version saves the forumbits in plain html into the db, the new one uses a compression function before savein into db :)

Decisions...decisions...ok, I can forgo that hack for now (at least until I can figure a way around it). How about the extra threadviews problem, "buddy"? :)

Can you share the script, please?

Oops :)

Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE postusername='d' jam-man' AND open!='10' mysql error: You have an error in your SQL syntax near 'jam-man' AND open!='10'' at line 1

mysql error number: 1064

Date: Saturday 21st of December 2002 09:57:26 PM
Script: http://www.housequake.com/forum/foru...fo&userid=1645
Referer: http://www.housequake.com/

Whats that? Weird?

No problem its very simple

Open notepad. Paste this inside:

Save as: whateveryoulike.php
Upload & voila!

Ok, that's almost like the one I am using now. Only mine is phpinfo(32). I guess I will have to look closer at it. Thanks! :)

@Boofo: you're welcome, i only wished all coding was that simple :)

@Xenon: I don't think my problem is related to year hack, because it has something to do with illegal user names; The quote marks seem non allowed? But why do i get a database error for that... But its the first time i get this error.

----

One more thing, is that extra querie i have (yep i never got that marvelous 20 queries back again) due to that Zlib addition?

Can someone please check their forumjump and tell me if all of their forums are showing up? Mine is blank on the forums and I need to see if it is this hack or Velocd's Similar threads hack doing it. Thanks! :)

I checked your site Boofo, and your forumjump looks good, and seem to have all the forums from your board. I can't check my forum, because i disabled it...

@boofo:
you have a forumjump on forumhome?
hmm, it's a hack, so you have to look where the creating line is :)
if it's inside of the if-clause you have to take it out from it, same thing as with the latest xx threads....

also the extra threadviews are no problem of my hack boofo, it just reads em out of the DB, so if the ammount is incorect it is saved wrong in thread table..

@Aaron: the extra querie cannot be produced by the zlib inclusion :)
Also your error, has nothing to do with my hack, but i can say whats the problem: somewhere you have $bbuserinfo[username] or something like, but you have to use addslashes($bbuserinfo[username])

Sorry about that. It turned out it wasn't your hack causing the problem. It is Velocd's Similar Threads Hack causing it. And the totalviews problem is still there after un-installing your hack (just for testing purposes). I will re-install it once I figure out the totalviews problem. Again, sorry for my over-zealousness (the wife told me that word. She said it means "studness". :))

Did you check it while viewing a thread or just a forum? It works good in the forums, it's while viewing a thread (posts) that the forum titles are gone from the forumjump drop down listing. :)

Damn, why the hell is my browser redirecting me to Boofo's avatar when i click attachment link? :surprised:

lool, no idea it works perfect here ;)

It works beautifully!

/me clicks Install

How would I go about optimizing the forum display? Is there any way to optimize thread view?

OK thanks, but hey, thats looking for a needle in a haystack! :-)
My homesite gave me 52 results on a search pattern! But which one needs the addslashes?

Forumhome works great Xenon! Now the rest of the forum pages :)

Yes it looked all good! Btw you got a fast webserver. Everything runs smoothly. I wish my site was like that!

Hmm I'll try my own on forumdisplay, it shouldn't be too awful hard....

Xenon:

Great hack. I look forward to seeing what you can do to optimize showthread.

Parker

Yes, great Hack!

You have an error in your SQL syntax near '\'0\',
lastpost int(10) unsigned NOT NULL default \'0\',
lastupdate int(10) un' at line 2

Any ideas?

@DVD: a bit more information would be nice.....
Where do you get this error, which file, line and so on...

Am I missing something? I installed the latest version of the hack, and my index page looks indentical, doesn't load any quicker, and doesn't use any more or any less queries. Also, how do I know if I'm using the cached version, and how do I force a cache update? :confused:

Well, you won't see any difference, visually ;)
it just reduces the querie ammount if it reads from the cache.

The cache would be updated, whenever a new post is made, that's also how you force an update ;)

so if you've installed the newest version, go to forumhome, you'll have about 19 queries (normally) then just do a reload, without a new post has been made, and the qurey ammount should be about 14.
if you don't have the effect, you have probably made a mistake while installing

I have a problem, it could be related to this hack. But i am not sure. After trying to optimize the forumhomepage, i was advised to move 'The Latest XX Threads Hack' after the '} // if $cacheupdate' line. But now the hack is not working properly anymore, it does show, but the problem now is, that it also shows topics from a private forum.

What do you think of this? Is this a cache related problem? Or just the fact because i moved it below the specified line?

yes, that's a problem. These two hacks don't work together properly. It's because the viewingpermissions are just read out from the db when the cache is updated, but it won't if the script reads from the cache. That is one of the queries which are reduced when reading from cache :)

i don't know the hack of latest XX but maybe, you can add the threadinfo into the cache also, so it should be working :)

as said, i can't code such workarounds for other hacks whil beta-phase but maybe i find a way after the full release :)

By adding a new mod to the forum it will not be displayed on forumhome Xenon :confused:

I installed it slowly as per the instructions. Though I noted a faster load, the queries were always at 23 for logged in users, and 16 for logged out users. Is it possible that the template recording the number of queries made is also cached?

@nuno: Yes you are right, just make a new post that there is a new mod and you'll see next time on forumhome he will be displayed ;)

it just won't display him as long as the script reads out from the cache :)

@MartynJ: Hmm, maybe a bug with a hack you've installed.
The newest version works perfect on all my test boards (hacked and unhacked)
can you create a test account so i can see it on your board ;)

Done and fixed :)

Hmm, sounds very simple but how do i do that? :)
Well i guess, there will be more hacks that might have some trouble with your optimize(cache) hack?

Well for now i have uninstalled the latest XX threads hack, because i was forced to choose between speed and functionality. Yes, i have chosen speed, but hey! I got 19 queries now! :)

Seems not to work :(

Sometimes it says 13 queries, and sometimes it sasy 34, sometimes it says 32, and sometimes when i refresh t says 13. Whats wrong?

That's just the cache doing it's job, caching ;)
Oddly enough i get 15 queries for logged out users and 12 for logged in, what's the catch? :confused:

@Drk: if your qureies change so strong, the hack is working perfectly ;)
as nuno said, that's caching :)

@nuno: hmm, the caching is optimized for logged in users, it should also work for most of the logged out ones, but, i have to optimize that part i think ;)

@Aaron: yes it's easy i think, i'll help you when i've more time so i can look into TECKs hack ;)
I think speed was the better chose ;)

This is great :)
Great job Xenon