twopeak
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Query posts made AFTER given date?For those interested:
I had a plugin that printed the sql that wordpress uses standard:
http://ww.wp.xz.cn/support/topic/159930?replies=1From this I built this query:
SELECT SQL_CALC_FOUND_ROWS wp_posts. * FROM wp_posts WHERE 1 =1 AND wp_posts.post_type = 'post' AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private' ) AND wp_posts.post_date >= CURDATE( ) ORDER BY wp_posts.post_date ASC LIMIT 0 , 10it seems to work at first sight!
Forum: Fixing WordPress
In reply to: Query posts made AFTER given date?http://codex.ww.wp.xz.cn/Displaying_Posts_Using_a_Custom_Select_Query
this should do it; however I didn’t have any luck yet at creating my sql; I’m terrible with joins and seemingly this is a must since version 2.3…
🙁Forum: Fixing WordPress
In reply to: Query posts made AFTER given date?I was trying to reach the same: the front page should show a small calendar with the 5 next gigs; and a full calendar shows all previous and future gigs.
I was trying to use this:
$string='monthnum>'.date('m').'&order=ASC&showposts=6'; query_posts($string);This works if I choose a specific year; it doesn’t work for monthnum.
Further this is not a solution because it will only ‘refresh’ itself once a month, not every day.In the database there’s a field called post_date
it must somehow be possible to alter the query somewhere; I’ll be searching into this.Forum: Fixing WordPress
In reply to: create separate submit pagebump; I’d like to make an easier submit page for computer challenged users.
I want a title; a story and 1 custom field;
all the rest should not be on the page at all.Forum: Themes and Templates
In reply to: a list of the categoriesfound out how to do it with the codex help of a page; by creating a page template.
Forum: Installing WordPress
In reply to: Disk Usageyes, the stats file of your webserver will help you (cpanel or some application like this).
The server logs that tell you who connects to what page might also be of service.I found one day that hackers uploaded loads of software on my server and through some system other people could download it.
Forum: Fixing WordPress
In reply to: post visibilityI think it would require an extra field in the database that decides what records have to be pulled from the database and what not…
Forum: Fixing WordPress
In reply to: post visibilityThat’s my problem, the solutions I found hide the posts, they don’t restrict access.
In phpbb for example, some forums only show up to those belonging to a certain group. The others have no knowledge about the forum.Forum: Fixing WordPress
In reply to: using header elsewherewhooami, I’m realising now I should have searched better.
Though this solution works great for pages already created, it doesn’t work for phpBB
So I started searching for easy solutions, but I can’t seem to find them on the forum.I’ve started fixing problems, like double functions by using the “function_exists()” function of php, but that doesn’t solve everything.
Basically the problem is that either I include the wordpress information before the phpbb information, meaning that every output started by wordpress, will give the “output already started” when phpbb tries to set headers (like cookies)
Or I do phpbb first, but then I seem to be making calls to wordpress functions in a wrong order (so some classes are being used without being defined)
It all seems very complicated :-p
Forum: Fixing WordPress
In reply to: using header elsewhereno, because if I add a static page in wordpress, it won’t be updated in the other places…
the most important thing is having the links to other pages.I was hoping to for example add in wordpress an external page to my pictures and then when I see my forum for example, this links gets dynamically added…
Maybe I should have gotten a cms, but that’s too complicated for the people who use the site every day.