need some help with php

[hobey19]

first off, let me say that i know absolutely nothing about php at all. i found this script and uploaded it, and for the most part, everything works, except the calendar function, something i would like to get working. what i am hoping is someone on here will know how i can go about fixing this, as it appears the devs have not answered someone else's plea for help on the same issue.

here is the site: http://www.thirddegreepc.com/sharepo...me=Appointment

username: pcmech
password: pcmech

right now, its only viewer capabilities, but if someone who knows their way around this needs some more permissions, i would be happy to give those out on a pm basis.

here is where i downloaded it from: http://sourceforge.net/project/showf...kage_id=142556

i appreciate any help someone can give me. overall, i like what i see in this app, and it would be perfect if i could get the appointment module working

thanks
craig

[blue60007]

I assume this error is what you are referring to:

Fatal error: Call to a member function on a non-object in ....../module.php on line 116

You might take a look at that file and see what is located on that line...maybe it'll give you a clue as to what is wrong. Otherwise, I'm just taking a stab in the dark.

[hobey19]

yea, thats it. i took a look, but since i have no idea what i would even be changing, i am afraid to do anything

line 116 is:

if (($rs->RecordCount())>0)

the entire function is:

function getCheckItemFound($date) {
		global $db,$table_appointment;
		//$sql="SELECT * FROM $table_appointment WHERE usrId=$this->uid AND apmDateStart LIKE '$date%'";
		$datex=$date."000000";
		$sql="SELECT * FROM $table_appointment WHERE apmDateEnd >= '$datex' AND (apmDateStart LIKE '$date%' OR apmDateStart <= '$datex')AND usrId=$this->uid ";
		//WHERE
		//$db->debug=true;
		$rs=$db->Execute($sql);
		$this->rs=$rs;
		if (($rs->RecordCount())>0) {
		    return TRUE;
		} else {
			return false;
		}
	}

thanks for any help

craig

[faulkner132]

This, most likely, means the $rs is null. You could *try* changing the line to:

if (($rs) && ($rs->RecordCount())>0) {

I'm not sure if this will work, but you can give it a shot. This is really a question for the developers of the application.

[hobey19]

thanks faulkner, that fixed that problem, now when i try to add an appointment, it gives me an error saying "cannot add appointment." i thought we had it when that full calendar came right up with dates and everything.

there really aren't any error messages other than the one above. i am going to change the permissions on the user (pcmech, pcmech) so that you can add appts and what not, in case you want to mess around. otherwise, thanks for your help.

i have already emailed the devs, and i intend to install core 3, just in case that one is ok.

craig

[faulkner132]

Looks like there are a host of bugs with this program's release. Probably best to wait for the developers to release a patch rather than try to fix it yourself. If other people are posting the same problems you are having, the devs will take care of it.

[hobey19]

alright, thanks for your help. i will just be patient and wait

do you know of any other sharepoint clones like this? that is my ultimate goal, but other than this one, i don't know of any others

thanks
craig