PunBB Forums — Calendar Query

Re: Calendar Query

null@example.com (zaher) — Sat, 02 Oct 2004 10:00:29 +0000

Gizzmo,
Welcome to real world of programming

Re: Calendar Query

null@example.com (Gizzmo) — Sat, 02 Oct 2004 05:51:30 +0000

wow that will be hard to make, realy hard

Re: Calendar Query

null@example.com (ameenullah) — Fri, 24 Sep 2004 12:36:13 +0000

Gizzmo, can you create a calander, in which we can add birthday, anniversaries, and other important hints. and it should be unique.. only the particular user can view his/her calander.

something like peronalised..

Re: Calendar Query

null@example.com (Gizzmo) — Sat, 18 Sep 2004 21:33:28 +0000

i think it will too....well find out when someone tryes it on a different lang server

Re: Calendar Query

null@example.com (Gary13579) — Sat, 18 Sep 2004 21:30:45 +0000

youd think it would translate itself, depending on the server settings....

just to let you know, that means i have no clue

Re: Calendar Query

null@example.com (Gizzmo) — Thu, 16 Sep 2004 00:12:03 +0000

hey if the php code creats the month name do i have to put that in the lag pack or will it translate its self depnding on the php server?

Re: Calendar Query

null@example.com (Gizzmo) — Wed, 15 Sep 2004 23:07:39 +0000

yea, i might, i have a few things more i wana do to it, like set up a language pack and be able to see the count on the calendar page. thats gona be the tuff one, im stuck on that.

Re: Calendar Query

null@example.com (Gary13579) — Wed, 15 Sep 2004 22:46:29 +0000

so you gonna make this a mod and release it? hint hint....

Re: Calendar Query

null@example.com (Gizzmo) — Wed, 15 Sep 2004 14:01:20 +0000

thats a good idea would save on sql server load right wouldnt have to work so hard

Re: Calendar Query

null@example.com (zaher) — Tue, 14 Sep 2004 13:31:33 +0000

I agree with "Cuteseal"
put range by month (some math to calc starttime and endtime) and grouped by day
"group by (posted / 86400)"

Re: Calendar Query

null@example.com (cuteseal) — Tue, 14 Sep 2004 05:50:23 +0000

This is an example of what i'm talking about -- I used this to display number of topics and posts in the last 24 hours at the bottom of the forum index.

$lastday = time() - (24 * 60 * 60);
$result = $db->query('SELECT COUNT(*) FROM '.$db->prefix.'topics WHERE posted > '.$lastday)

Just put another AND clause to limit it to a date range.

Re: Calendar Query

null@example.com (cuteseal) — Tue, 14 Sep 2004 05:46:51 +0000

eek! can't you put the range into the SQL query so that you don't extract all topics? Just do the conversion to unix time before the query is performed, and then add it to the select statement.

ie. SELECT blah FROM blah WHERE posted > starttime AND posted < endtime

Re: Calendar Query

null@example.com (Gizzmo) — Tue, 14 Sep 2004 03:10:28 +0000

i got it to work, all i did was pull all info from the topics table and order it by posted, than convert the said date (at noon) to unix timestamp and minus the 2. than i would see if the number is between -43200 & 43200 and if soo it will show the topic.

i bet its alot of work for the SQL server on ever page load, but its the only way i could figure out.

Re: Calendar Query

null@example.com (zaher) — Mon, 13 Sep 2004 06:03:38 +0000

"posted" field is "unsigned int" not timestamp
you cant make

where month(posted) = 1
group by dayofmonth(posted)

i try "cast" but not worked?

Re: Calendar Query

null@example.com (zaher) — Mon, 13 Sep 2004 05:04:29 +0000

You want to count posts in every day, show it as calender?
and if click on day link will show links to posts in that day, as searching.

like yahoo groups, it's simple keep going and finish it .