Search found 485 matches

by JLA
Wed Aug 10, 2011 8:06 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Problem Query
Replies: 2
Views: 246

Re: Problem Query

It might help to split this into two queries. The first would look something like this: $sql = "SELECT p.post_id, t.topic_id FROM " . POSTS_TABLE . " p LEFT JOIN " . FUN_TABLE . " ON p.post_id = " . FUN_TABLE . ".post_id WHERE p.forum_id = $funforum AND p.post_approval = 1 AND " . FUN_TABLE . ".pos...
by JLA
Tue Aug 09, 2011 9:37 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Problem Query
Replies: 2
Views: 246

Problem Query

Having a problem with a query and I figure it should be able to be done better than this $sql = "SELECT p.post_id FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p LEFT JOIN " . FUN_TABLE . " ON p.post_id = " . FUN_TABLE . ".post_id WHERE p.forum_id = $funforum AND t.topic_type = " . POST_NORMAL . ...
by JLA
Tue Aug 09, 2011 1:58 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Clickable links - BBCode
Replies: 5
Views: 579

Re: Clickable links - BBCode

Thanks, we'll give this a try and report back.

And 4-seven: Yes, that is correct.
by JLA
Tue Aug 09, 2011 1:56 pm
Forum: phpBB Discussion
Topic: where to find programmer
Replies: 10
Views: 1243

Re: where to find programmer

O'Desk is good. The developers are held quite accountable and screenshots are taken randomly during their billable time. Every ten minutes isn't randomly ;-) Last time we used them, I believe it was timed intervals but was random during that period. Regardless, there was never a problem with any of...
by JLA
Tue Aug 09, 2011 5:58 am
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 43847

Re: [3.0.x] Tweaks for large forums

Ah, so there is a Tweaks thread for PHPBB3. Almost forgot about this. BTW - has anyone heard anything from Lanzer lately? For those who don't know, he was the main contributor for the PHPBB2 tweaks thread (that has seemed to vanish). One of the main things we've learned with PHPBB2 and the PHPBB3 bo...
by JLA
Tue Aug 09, 2011 5:47 am
Forum: [3.0.x] MODs in Development
Topic: [RC] Google +1 Button
Replies: 17
Views: 2114

Re: [RC] Google +1 Button

You might want to let some users know that if you add the +1 button to your site, you are going to be hit by the usual Google Web Preview Spider, etc. There is also a rouge Google Project called DOTS that running running off the same IP blocks (one is 74.125.X.X] and is absolutely hammering sites (s...
by JLA
Tue Aug 09, 2011 5:33 am
Forum: phpBB Discussion
Topic: PHPbb2 help
Replies: 4
Views: 1495

Re: PHPbb2 help

There are other support sites out there for those still using PHPBB2.

Try Google and search phpbb2 support.
by JLA
Tue Aug 09, 2011 5:31 am
Forum: phpBB Discussion
Topic: where to find programmer
Replies: 10
Views: 1243

Re: where to find programmer

O'Desk is good. The developers are held quite accountable and screenshots are taken randomly during their billable time.
by JLA
Tue Aug 09, 2011 5:28 am
Forum: General Discussion
Topic: Phpbb 2.x download?
Replies: 4
Views: 4405

Re: Phpbb 2.x download?

Have fun with it!
by JLA
Fri Jul 29, 2011 11:53 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Clickable links - BBCode
Replies: 5
Views: 579

Re: Clickable links - BBCode

Comments? No, but a question. What do you want exactly, and what should the result be? As I mentioned in the previous post Take the following (and similar variations with things such as rel="nofollow" or target="blank") if it appears in a post <a href="http://www.yahoo.com">Text<a> and have it chan...
by JLA
Fri Jul 29, 2011 6:47 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Clickable links - BBCode
Replies: 5
Views: 579

Clickable links - BBCode

Have some code that takes certain links and changes them For example if a link is entered into a post as http://www.yahoo.com The normal bbcode.php will change this to a clickable link. Our code goes further by appending the link and making that clickable http://xxxx.com/linker.php?url=http://www.ya...
by JLA
Mon Mar 23, 2009 6:41 pm
Forum: phpBB Discussion
Topic: Pagin DOGCOW - Thanks for your mod
Replies: 1
Views: 192

Pagin DOGCOW - Thanks for your mod

Just wanted to give an update regarding the MOD that DOGCOW posted sometime ago here http://www.phpbb.com/community/viewtopic.php?f=16&t=574223 We had been sitting on this for sometime as the script DOGCOW provide was ineffective at converting our board with over 18 million posts. We'll we finally w...
by JLA
Tue Jan 13, 2009 8:28 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Viewforum No Query Join
Replies: 35
Views: 17294

Re: [BETA] Viewforum No Query Join

We tried running the file via the command line as we do with various other functions on the site and for some reason it is saying it cannot run the file???? Well, I can tell you some potential, obvious reasons, but you might already know these: 1.) It probably needs a shebang at the top 2.) It prob...
by JLA
Tue Jan 13, 2009 7:59 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Viewforum No Query Join
Replies: 35
Views: 17294

Re: [BETA] Viewforum No Query Join

Is there a way you can output some code to use that can be run in a cron job that will do all of this via command prompt instead of web browser? PHP, as you may know, can be run from the command line, and thus, from a cron job. If you set a no expiry time limit, you may be able to get the script to...
by JLA
Tue Jan 13, 2009 6:31 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Viewforum No Query Join
Replies: 35
Views: 17294

Re: [BETA] Viewforum No Query Join

Hi again - we have gotten through to about 2230000 posts but due to some settings on our webserver for performance we are having a hard time getting through this via a browser. Is there a way you can output some code to use that can be run in a cron job that will do all of this via command prompt in...

Go to advanced search