selecting calendar events

[Jakeman]

The new WHERE clause produces this error, oddly enough

Parse error: parse error in /server path here... on line 223

Fatal error: Call to undefined function: msc_portal_events() in /server path here... on line 10

msc_portal_events is the name of the function that contains this query. When I remove the WHERE clause or use a different clause, the function is defined again. Something is fubar with your last WHERE clause.

I appreciate your help with this problem.

Re: your thread
I just checked the mod forum and there is already a thread about your problem posted in there. Hopefully Firefly will get to it soon.

[futureal]

That's weird. When I run it through a MySQL command line it works OK. Let me play around with it a bit and I'll see if I can come up with a fix...

[futureal]

I can run this query on my vBulletin table:

PHP Code:

SELECT * FROM calendar_events WHERE (UNIX_TIMESTAMP(CONCAT(CURRENT_DATE, " 00:00:00"))+86400) >= UNIX_TIMESTAMP(eventdate); 


...and it works.

I'm not sure what would be producing an error, since those are all valid MySQL expressions.

[futureal]

Oh.

I just figured it out, I think. I failed to comprehend that the error you were getting was a parse error.

Make sure to escape the quotes inside the query. So in vBulletin code, for example, it would look something like:

PHP Code:

$DB_site->query("SELECT * FROM calendar_events WHERE (UNIX_TIMESTAMP(CONCAT(CURRENT_DATE, ' 00:00:00'))+86400) >= UNIX_TIMESTAMP(eventdate)"); 


Now that should work.

[Jakeman]

It's working now. And it also considers the time offset of the logged in user.

Here is the final code:

PHP Code:

$msc_date = vbdate("Y-m-d",$ourtimenow);
$msc_date = $msc_date . " 00:00:00";

...

WHERE (UNIX_TIMESTAMP('$msc_date')) <= UNIX_TIMESTAMP(calendar_events.eventdate)

... 


[futureal]

Cool, glad it works!

[Jakeman]

The final product... http://www.mscclan.com/ (events in the left column)

It was part of my event signup system I have been making.

[futureal]

Cool, looks good.

Makes me want to bust out Diablo II again. Haven't played it for like a year! haha

[Jakeman]

I have a level 99 tank, mf, dueling sorceress.