phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

DogCow, need one of your old mods


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
transm
Board Member



Joined: 28 Jun 2009

Posts: 13


flag
PostPosted: Fri Jul 17, 2009 12:16 am 
Post subject: DogCow, need one of your old mods

http://www.phpbb.com/community/viewtopic.php?f=16&t=574223

My viewforum is normally sorted by post_time (posts table) and the reason it's not the usual last_post_id from the topics table is because I sometimes add topics and posts that go back in time.

One particular forum (I also have a sub forum mod) normally takes about 15 seconds to load if it's not in the cache because it has tens of thousands of topics. I know it's the particular viewforum query causing the problem. I think it's because I'm sorting it using a field in the posts table and not the topics table because when I've tried any from the topics table, they are much faster.

With your hack I could just sort it by the topic_last_post_time but your download doesn't work so I don't have the actual hack and can't find it anywhere. I would also need to change one of netclectic's old mods that inserts posts into the forum but that shouldn't be hard, should it?
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Fri Jul 17, 2009 6:00 am 
Post subject: Re: DogCow, need one of your old mods

The download works for me, try again. icon_wink.gif
_________________
phpBB2 will never die, I hope!
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Fri Jul 17, 2009 2:30 pm 
Post subject: Re: DogCow, need one of your old mods

Here's the file: http://dserver.macgui.com/Viewforum_no_query_join_beta.zip
_________________
Moof! Email me: dog_cow@macgui.com
Inside Allerton Park Lincoln's Tomb, Oak Ridge Cemetery, Springfield IL Mac 512K Blog
Back to top
transm
Board Member



Joined: 28 Jun 2009

Posts: 13


flag
PostPosted: Fri Jul 17, 2009 2:37 pm 
Post subject: Re: DogCow, need one of your old mods

Thanks. I think it was just your site that was down for a few hours. I was trying last night for a while.
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Fri Jul 17, 2009 5:09 pm 
Post subject: Re: DogCow, need one of your old mods

transm wrote:
Thanks. I think it was just your site that was down for a few hours.

Well, that's annoying! icon_mad.gif

_________________
Moof! Email me: dog_cow@macgui.com
Inside Allerton Park Lincoln's Tomb, Oak Ridge Cemetery, Springfield IL Mac 512K Blog
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Fri Jul 17, 2009 5:34 pm 
Post subject: Re: DogCow, need one of your old mods

Dog Cow, you are a great guy! icon_wink.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0092 seconds using 15 queries. (SQL 0.0024 Parse 0.0002 Other 0.0066)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo