You are not logged in. Please login or register.
PunBB Forums → Programming → Calendar Query
well im tryin to make a calendar for punbb, witch will on the calendar page show how many posts made on a certon day, and on the view page will show thoes posts made that day, and i cant figure out how to go about doin that. could some one possibly help me.
well, learn php, if you dont already know it, then learn mysql, if you dont already know it.
im not sure, i havent spent much time on it, but look at the calendar functions in the php tutorial (the .chm from php.net)
i know how to do it with a simple query but iv looked at punbbs querys and i dont understand it. and i dont know how id decode the topic start date to be able to see if is for that day.
I need to find out how to show just the post made on the selected day. if that helps any
well, it keeps the date in the database, so just run a query to get all posts that day and display them. should be simple (hopefully)
Gizzmo, the posted column shows the date/time in epoch seconds. You need to convert the date range to epoch seconds and then retrieve the posts/topics where "posted" is within that range.
try php.net/date to give you an idea of the functions...
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 
.
"posted" field is "unsigned int" not timestamp
you cant make
where month(posted) = 1
group by dayofmonth(posted)i try "cast" but not worked?
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.
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
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.
I agree with "Cuteseal"
put range by month (some math to calc starttime and endtime) and grouped by day
"group by (posted / 86400)"
thats a good idea would save on sql server load right wouldnt have to work so hard
so you gonna make this a mod and release it? hint hint....
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.
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?
youd think it would translate itself, depending on the server settings....
just to let you know, that means i have no clue 
i think it will too....well find out when someone tryes it on a different lang server
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..
wow that will be hard to make, realy hard
Gizzmo,
Welcome to real world of programming 
PunBB Forums → Programming → Calendar Query
Powered by PunBB, supported by Informer Technologies, Inc.