phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] [ phpesp-Bugs-1145732 ] totals in cross-tabs and report do not match

[SourceForge.net <no...@so...>]

Bugs item #1145732, was opened at 2005-02-21 21:50
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1145732&group_id=8956

Category: User
Group: v1.7
Status: Open
Resolution: None
Priority: 5
Submitted By: Mark Jansen (trombonefreakus)
Assigned to: Nobody/Anonymous (nobody)
Summary: totals in cross-tabs and report do not match

Initial Comment:
Both in version 1.6.1 and version 1.7 just downloaded,
I have different totals when viewing a cross-tabluated
result and a total result.

The crossed totals even have different total values
accross the questions, while the survey totals are
always lower than any crossed survey total.

So, I have a crossed result with a total numbers of
respondents of 1987 and one with 1967 respondents,
while the overall survey has 1952 responses.

How is this possible???

Does phpESP uses only the respondents who completed the
entire survey for the survey results, while using also
respondents who quitted before finishing the survey for
the crossed results??

I desperately need to know this, since I used the
software for quite an important survey.

Thanks!

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1145732&group_id=8956

[phpesp-dev] [ phpesp-Patches-1144741 ] invitations

[SourceForge.net <no...@so...>]

Patches item #1144741, was opened at 2005-02-20 12:14
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=308956&aid=1144741&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Jochen Staerk (jstaerk)
Assigned to: Nobody/Anonymous (nobody)
Summary: invitations

Initial Comment:

this patch (against 1.6.1) should contain my last 2
submissions (show-results-on-survey-completion and
hidden-multicopy-functionality) and a new, bigger
feature that I call invitations.

With invitations, you can invite a group to a survey.
The members of the group will receive an e-mail with
the URL to access the survey and their credentials. An
important feature is that phpESP then keeps track of
incoming responses, i.e. one can see on the status page
of the respective invitation when, and more importantly
if users have completed the survey.


A word of warning: Realms seems to be shallow in the
1.6.1 phpESP architecture (has that changed to 1.7? I
think there is a login-form now?). It seems as if both
user and realm are part of the primary key in the users
table, but due to http constraints, it can not be
determined which group a user belongs to when he/she
loggs in, so de facto the user name is the only primary
key. One might run into trouble if there are users in
different groups that share the same user name.

If user "A" group "A" is invited to Survey "A" and
another Username "A" in group "B" is also invited to
Survey "A", their participations would be recorded as
the identical user in both group A and B.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=308956&aid=1144741&group_id=8956

[phpesp-dev] [patch] corrected, invitations

[Jochen S. <js...@us...>]

Hi,

I'm sorry I used svn diff to create my first submission and important=20
new files are mission (seems like svn diff is rather diff -ru then diff=20
-ruN).

This is the corrected patch and it can be applied in your phpESP-path=20
with "patch -p0 < ../invitations.patch".

I know this will not be incorporated into 1.7 and I think this is a very=20
wise decision, anyway, if anybody wanted to tested it with a 1.6.1,=20
you'll need this patch/I'd welcome feedback.

--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

Re: [phpesp-dev] [patch] new feature: invitations

[Matthew G. <gr...@mu...>]

I'll consider the patches if they are against CVS Head.  1.6 is critical
bug fix only right now and 1.7 is almost out the door.

On Tue, 2005-02-15 at 11:02 +0100, Jochen Staerk wrote:
> Hi there,
> 
> this patch (against 1.6.1) should contain my last 2 submissions 
> (show-results-on-survey-completion and hidden-multicopy-functionality) 
> and a new, bigger feature that I call invitations.
> 
> With invitations, you can invite a group to a survey. The members of the 
> group will receive an e-mail with the URL to access the survey and their 
> credentials. An important feature is that phpESP then keeps track of 
> incoming responses, i.e. one can see on the status page of the 
> respective invitation when, and more importantly if users have completed 
> the survey.
> 
> 
> A word of warning: Realms seems to be shallow in the 1.6.1 phpESP 
> architecture (has that changed to 1.7? I think there is a login-form 
> now?). It seems as if both user and realm are part of the primary key in 
> the users table, but due to http constraints, it can not be determined 
> which group a user belongs to when he/she loggs in, so de facto the user 
> name is the only primary key. One might run into trouble if there are 
> users in different groups that share the same user name.
> 
> If user "A" group "A" is invited to Survey "A" and another Username "A" 
> in group "B" is also invited to Survey "A", their participations would 
> be recorded as the identical user in both group A and B.
> 
> Maybe I'll pull a CVS version and rewrite those features for 1.8 -- I 
> think 1.7 should not be destabilized by new features as it is already a 
> release candidate.
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] [patch] new feature: invitations

[Jochen S. <js...@us...>]

Hi there,

this patch (against 1.6.1) should contain my last 2 submissions=20
(show-results-on-survey-completion and hidden-multicopy-functionality)=20
and a new, bigger feature that I call invitations.

With invitations, you can invite a group to a survey. The members of the=20
group will receive an e-mail with the URL to access the survey and their=20
credentials. An important feature is that phpESP then keeps track of=20
incoming responses, i.e. one can see on the status page of the=20
respective invitation when, and more importantly if users have completed=20
the survey.


A word of warning: Realms seems to be shallow in the 1.6.1 phpESP=20
architecture (has that changed to 1.7? I think there is a login-form=20
now?). It seems as if both user and realm are part of the primary key in=20
the users table, but due to http constraints, it can not be determined=20
which group a user belongs to when he/she loggs in, so de facto the user=20
name is the only primary key. One might run into trouble if there are=20
users in different groups that share the same user name.

If user "A" group "A" is invited to Survey "A" and another Username "A"=20
in group "B" is also invited to Survey "A", their participations would=20
be recorded as the identical user in both group A and B.

Maybe I'll pull a CVS version and rewrite those features for 1.8 -- I=20
think 1.7 should not be destabilized by new features as it is already a=20
release candidate.

--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

[patch] Re: [phpesp-dev] [Fwd: phpesp suggestion]

[Jochen S. <js...@us...>]

James E. Flemer wrote:

> Any -devel people want to look into this?  Maybe you can just hit=20
> "reload" on your browser 50 times.  ;-)  Maybe it's just a few lines=20
> of change.  I've got no time to work on phpESP now, sorry.

Hi,

you can't just hit "reload" because you are redirected to the management=20
page. You CAN bookmark the link target of the survey you wish to copy=20
and then use this link 50 times, but that's rather ugly too.

My solutions is not very beautiful as well (although it's very short)=20
because it adds the functionality, but not the UI interface. It's again=20
a patch for Version 1.6.1. It processes an additional parameter, "nr",=20
if stated. To use this thing, one had to click on copy an existing=20
survey, right-click the survey he/she wants to copy and say "copy link=20
location" and then paste this link location, e.g.=20
"http://127.0.0.1/phpESP/admin/manage.php?where=3Dcopy&sid=3D32" with the=
=20
additional parameter in his location bar, like=20
"http://127.0.0.1/phpESP/admin/manage.php?where=3Dcopy&sid=3D32&nr=3D50".

The reason why I didn't do a UI interface is just that you select the=20
survey as a link in a table, so no form-related field can be attached.=20
Probably something like a select box of surveys and a simple input field=20
for the number of copies would be smoother, but I don't have time to=20
code that now and I don't know if this were accepted as a patch.


Besides:
 >The problem is to create a copy of the survey for each
 >group.

Do you know that you can grant access to a survey to several groups at a=20
time?

Copying surveys IMHO only makes sense if you make some changes to the=20
copy (because otherwise you could have used the original).

--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

[phpesp-dev] [Fwd: hungarian language .po file for phpESP]

[James E. F. <jf...@uv...>]

Just forwarding the PO file for this to -devel.

-------- Original Message --------
Subject: hungarian language .po file for phpESP
Date: Sun, 13 Feb 2005 00:41:38 +0100
From: Ziegler Attila <zap...@fr...>
Reply-To: zap...@fr...
To: jim...@us...

Hi,

first, thanks a lot for the survey package - it was very handy!

Second, here is the hungarian language file. I hope that it will
usefull.

All the best.

Zapverho
-- 
If you're forever chasing rainbows,
then every other pot of gold may go unnoticed.
. o .  Powered by - Debian 2.4.20-3-k7 i686 GNU/Linux
. .  o
o o o   http://zapverho.uw.hu/welcome.html

[phpesp-dev] [Fwd: phpesp suggestion]

[James E. F. <jf...@uv...>]

Any -devel people want to look into this?  Maybe you can just hit 
"reload" on your browser 50 times.  ;-)  Maybe it's just a few lines of 
change.  I've got no time to work on phpESP now, sorry.

-James

-------- Original Message --------
Subject: phpesp suggestion
Date: Wed, 9 Feb 2005 10:55:37 -0800 (PST)
From: Lars Jensen <je...@ph...>
To: jim...@us...

Hi  James,

First of all, thank you so much for phpESP - it is a wonderful project.

The reason I write to you is that I'm trying to test phpESP as a tool
for doing large scale student evaluations of instructors at our college
(I'm with a community college in Nevada). In my pursuit of this I have
run into this question, which is the only thing that is holding me up in
being able to implement the evaluation process for the college:

	It is possible to modify the survey_copy.inc script so that one
	can make multiple copies (N copies) of a survey?

It seems to me that this ought to be an easy thing to do, but I am no
programmer, and we don't have any php programmers at the college. With
the ability to easily create multiple copies of a survey, I would be
able though a relatively simple and automated process to set up large
scale evaluations using the model described below:

MODEL FOR SETTING UP EVALUATIONS FOR LARGE NUMBER OF CLASSES

The constraints are that evaluations must be confidential and secure.
This means that students must login with authentication and be able to
take the survey once. All classes would have the same survey. Students
must only be able to take a survey for the class they are registered
for.

In the model we envision we would set up a group for each class, and
make the students in the class group respondents for that group. It is
easy to put this info into the phpESP database using csv files with
phpmyadmin. The problem is to create a copy of the survey for each
group. If the survey_copy.inc script could be modified to create N
copies (where N can be as large as several hundred) then our problem would
basically go away. After N surveys have been created, we can use csv
files to rename the surveys, and reset the group the surveys belongs to,
and presto, we can use phpESp for confidential evaluations of a large
number of classes.

As mentioned above, my programming skills are not sufficient to do the
needed modification of survey_copy, but I think this would be a GREAT
added feature to phpESP, would be widely used among colleges and perhaps
other institutions.

Thank you so much for reading this. If you consider the suggestion
worthwhile, and decide to implement it, I would be happy to write a set
of detailed instructions, or a help file,  on our model.

This semester we are going to try out the model in small scale, for 50
classes or so, and we will use the present survey_copy and simply make
50 copies, one at a time through the phpESP management interface.

Sincerely,
Lars Jensen
Math Department
Truckee Meadows Community College
Reno, NV

--
Lars Jensen, TMCC/Vista B200, 7000 Dandini Blvd, Reno NV 89512-3999.
Internet: <je...@ph...>, www.tmcc.nevada.edu/~jensen/
Tel: 775.673.7113  FAX: 775.674.7592

Re: [phpesp-dev] phpESP Addon Plans

[Aaron A. <li...@fr...>]

I want to somehow figure out a way so that one user can be in more than 
one group without having to readd that user with the same username and 
same password and a new group.  It will probably require a new 
intersection table in the database or something along those lines.

Groups are something we use on a regular basis, so there has to be some 
way to make it a bit more user friendly.

Jochen Staerk wrote:

> Hi,
>
>>
>> 1) The ability to upload a style sheet and have it tied to the user 
>> account
>> 2) Attempt to better integrate groups
>>
> I've got a question to the latter one:
> 1) what exactly do you want to do and
> 2) i think the respondent table has a primary key on both username and 
> realm. i think this is difficult because http-authentification does 
> not support groups, that means that there may be no two users in 
> different groups with the same user name...?
>

-- 
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC -- http://www.modevia.com

[phpesp-dev] phpESP Addon Plans

[Aaron A. <li...@fr...>]

Hello,

I just thought i would set forth my ideas for what features i am going 
to add into phpesp, and see who is interested.  I am in the process of 
installing and configuring phpesp for server wide use from a shared 
hosting enviroment.  The server is running php 4.3.10 and mysql 4.1.8, 
and so far everything has installed with minor problems.  The mysql 
populate script does complain about the default timestamp values as 
being NONE.  Might be something to tidy up before the 1.7 release.  
Simply removing the default specifications fixed the problem

1) The ability to upload a style sheet and have it tied to the user account
2) Attempt to better integrate groups

-- 
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC -- http://www.modevia.com

Re: [phpesp-dev] [patch] show results on survey completion

[Matthew G. <gr...@mu...>]

At first glance it looks pretty good.  It'll need to be reworked to be
against 1.7 and include DB changes for Postgres and sqlite.

On Wed, 2005-02-02 at 17:09 +0100, Jochen Staerk wrote:
> Hi,
> I am sorry that the attached patch is against version 1.6.1. but that's 
> intention.
> 
> It adds a check box "Show results after participation" to the 
> general-tab of a survey. If this is checked, a survey will show it's 
> preliminary results on the "thank you" page. On the finish-tab there now 
> is a snippet how to integrate survey results into one's homepage. If the 
> user has a custom thank-you url (and show results checked), he/she will 
> be warned to manually integrate this into the custom thank-you page.
> 
> Please mail me what you think.
> 
> plain text document attachment (results.diff)
> Index: scripts/db/mysql_populate.sql
> ===================================================================
> --- scripts/db/mysql_populate.sql	(revision 1)
> +++ scripts/db/mysql_populate.sql	(working copy)
> @@ -94,6 +94,7 @@
>  	thanks_page	CHAR(255),
>  	thank_head	CHAR(255),
>  	thank_body	TEXT,
> +	show_results	ENUM('Y','N') NOT NULL DEFAULT 'N',
>  	changed		TIMESTAMP(14) NOT NULL DEFAULT '',
>  	PRIMARY KEY (id),
>  	UNIQUE(name)
> Index: admin/include/function/survey_update.inc
> ===================================================================
> --- admin/include/function/survey_update.inc	(revision 1)
> +++ admin/include/function/survey_update.inc	(working copy)
> @@ -37,11 +37,13 @@
>  		}
>  
>  		// create a new survey in the database
> -		$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body','info');
> +		$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body', 'show_results', 'info');
>  		foreach($fields as $f) {
>  			if(isset($HTTP_POST_VARS[$f])) {
>  				array_push($f_arr,$f);
> -				array_push($v_arr,"'"._addslashes($HTTP_POST_VARS[$f])."'");
> +				$value=$HTTP_POST_VARS[$f];
> +				if (is_array($value)) $value=implode(',',$value); // if value is e.g. a radio button, handle the array
> +				array_push($v_arr,"'"._addslashes($value)."'");
>  			}
>  		}
>  		array_push($f_arr,'owner');
> @@ -79,7 +81,7 @@
>  				return(0);
>  			}
>  
> -			$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body','info');
> +			$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body','show_results','info');
>  			$sql = "SELECT name FROM survey WHERE id='${survey_id}'";
>  			$result = mysql_query($sql);
>  			$name = mysql_result($result,0,0);
> @@ -100,7 +102,9 @@
>  
>  			// UPDATE the row in the DB with current values
>  			foreach($fields as $f) {
> -				array_push($f_arr,$f ."='" . _addslashes($HTTP_POST_VARS[$f]) . "'");
> +				$value=$HTTP_POST_VARS[$f];
> +				if (is_array($value)) $value=implode(',',$value); // if value is e.g. a radio button, handle the array
> +				array_push($f_arr,$f ."='" . _addslashes($value) . "'");
>  			}
>  			$sql = "UPDATE survey SET " . join(', ',$f_arr) . " WHERE id='${survey_id}'";
>  			$result = mysql_query($sql);
> Index: admin/include/tab/general.inc
> ===================================================================
> --- admin/include/tab/general.inc	(revision 1)
> +++ admin/include/tab/general.inc	(working copy)
> @@ -15,9 +15,10 @@
>  		$sql = "SELECT * FROM survey WHERE id='${sid}'";
>  		$result = mysql_query($sql);
>  		$survey = mysql_fetch_array($result,MYSQL_ASSOC);
> +		$survey['show_results']=array($survey['show_results']); // this is a check box and thus an array is required
>  		mysql_free_result($result);
>  	} else {
> -		$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body','info','public');
> +		$fields = array('name','realm','title','subtitle','email','theme','thanks_page','thank_head','thank_body','show_results','info','public');
>  	   	foreach ($fields as $f) {
>              if(!empty($HTTP_POST_VARS[$f]))
>  	    	    $survey[$f] = _stripslashes($HTTP_POST_VARS[$f]);
> @@ -110,6 +111,16 @@
>  	</tr>
>  	<tr><td colspan="2"><hr width="90%" size="0" color="#FFFFFF"></td></tr>
>  	<tr valign="top">
> +		<td><b><?php echo(_('Results')); ?></b></td>
> +		<td>
> +			<?php 
> +			  echo mkcheckbox('show_results', 'Y', $survey); 
> +			  echo "&nbsp;"._('Show results after participation'); 
> +			?><br>			
> +			</td>
> +	</tr>
> +	<tr><td colspan="2"><hr width="90%" size="0" color="#FFFFFF"></td></tr>
> +	<tr valign="top">
>  		<td><b><?php echo(_('Email')); ?></b></td>
>  		<td>
>              <?php echo mktext('email', 30, 0, $survey); ?><br>
> Index: admin/include/tab/finish.inc
> ===================================================================
> --- admin/include/tab/finish.inc	(revision 1)
> +++ admin/include/tab/finish.inc	(working copy)
> @@ -29,6 +29,32 @@
>  	include("<?php echo($ESPCONFIG['handler']); ?>");?&gt;
>  </tt></blockquote>
>  
> +
> +	<p><?php echo(_('To insert the results of this survey into your web page, copy the text
> +below, and paste it into the HTML of your page.')); ?></p>
> +
> +<blockquote><tt>
> +	&lt;?php $sid=<?php echo($HTTP_SESSION_VARS['survey_id']); ?>;
> +	$precision=1;
> +	$totals=1;
> +	$qid='';
> +	$cid='';
> +	
> +	include("<?php echo($ESPCONFIG['handler']); ?>");?&gt;
> +</tt></blockquote>
> +	
> +	<p>
> +	<?php 
> +		$sql = "SELECT thanks_page,show_results FROM survey WHERE id='".$HTTP_SESSION_VARS['survey_id']."'";
> +        	$result = mysql_query($sql);
> +        	list($thank_url,$show_results) = mysql_fetch_row($result);
> +        	mysql_free_result($result);
> +        	if (($show_results=='Y')&&(!empty($thank_url))) {
> +  			echo("<b>"._('You are required to do this manually in the confirmation page').", $thank_url.</b>");
> +		}
> +	?></p>
> +
> +
>  	<p><?php echo(_('Once activated you can also access the survey directly
>  from the following URL.')); ?></p>
>  <blockquote><tt>
> Index: admin/include/funcs.inc
> ===================================================================
> --- admin/include/funcs.inc	(revision 1)
> +++ admin/include/funcs.inc	(working copy)
> @@ -78,9 +78,9 @@
>      // redirect to thank you page for survey ID 'sid'
>      // exits PHP!
>      function goto_thankyou($sid,$referer) {
> -        $sql = "SELECT thanks_page,thank_head,thank_body FROM survey WHERE id='${sid}'";
> +        $sql = "SELECT thanks_page,thank_head,thank_body,show_results FROM survey WHERE id='${sid}'";
>          $result = mysql_query($sql);
> -        list($thank_url,$thank_head,$thank_body) = mysql_fetch_row($result);
> +        list($thank_url,$thank_head,$thank_body,$show_results) = mysql_fetch_row($result);
>          mysql_free_result($result);
>          if(!empty($thank_url)) {
>              if(!headers_sent()) {
> @@ -110,7 +110,8 @@
>  ?>
>  <h2 class="thankhead"><?php echo($thank_head); ?></h2>
>  <blockquote class="thankbody"><?php echo($thank_body); ?></blockquote>
> -<a class="returnlink" href="<?php echo($referer); ?>">Return</a>
> +<? if ($show_results=="Y") survey_results($sid); ?>
> +<a class="returnlink" href="<?php echo($referer); ?>"><?=_('return to the survey')?></a>
>  <?php
>          return;
>      }
> Index: public/handler.php
> ===================================================================
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] [patch] show results on survey completion

[Jochen S. <js...@us...>]

Hi,
I am sorry that the attached patch is against version 1.6.1. but that's=20
intention.

It adds a check box "Show results after participation" to the=20
general-tab of a survey. If this is checked, a survey will show it's=20
preliminary results on the "thank you" page. On the finish-tab there now=20
is a snippet how to integrate survey results into one's homepage. If the=20
user has a custom thank-you url (and show results checked), he/she will=20
be warned to manually integrate this into the custom thank-you page.

Please mail me what you think.

--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

Re: [phpesp-dev] is this line wrong?

[Jochen S. <js...@us...>]

Matthew Gregg wrote:

>It should be correct as it is.
> =20
>
... I'm sorry I am still not used to functions that modify the output=20
buffer without using functions. You are right and I am wrong.

--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

Re: [phpesp-dev] is this line wrong?

[Matthew G. <gr...@mu...>]

It should be correct as it is.

On Wed, 2005-02-02 at 13:33 +0100, Jochen Staerk wrote:
> Hi,
> 
> in public/handler.php I read
> 
>     // show results instead of show survey
>     // but do not allow getting results from URL or FORM
>     if(isset($results) && $results) {
>         // small security issue here, anyone could pick a QID to 
> crossanalyze
>         survey_results($sid,$precision,$totals,$qid,$cids);
>         return;
>     }
> 
> ... isn't a echo missing there right before survey_results? like
> 
>     // show results instead of show survey
>     // but do not allow getting results from URL or FORM
>     if(isset($results) && $results) {
>         // small security issue here, anyone could pick a QID to 
> crossanalyze
>         echo survey_results($sid,$precision,$totals,$qid,$cids);
>         return;
>     }
> 
> 
> Thanks for your help and of course for phpESP
> 
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] is this line wrong?

[Jochen S. <js...@us...>]

Hi,

in public/handler.php I read

    // show results instead of show survey
    // but do not allow getting results from URL or FORM
    if(isset($results) && $results) {
        // small security issue here, anyone could pick a QID to=20
crossanalyze
        survey_results($sid,$precision,$totals,$qid,$cids);
        return;
    }

... isn't a echo missing there right before survey_results? like

    // show results instead of show survey
    // but do not allow getting results from URL or FORM
    if(isset($results) && $results) {
        // small security issue here, anyone could pick a QID to=20
crossanalyze
        echo survey_results($sid,$precision,$totals,$qid,$cids);
        return;
    }


Thanks for your help and of course for phpESP


--=20
mit freundlichen Gr=FC=DFen
Jochen St=E4rk

www.usegroup.de			(home office)
Albigerstr. 22			Am Wald 3
55232 Alzey			55270 Ober-Olm

Tel: (06731)997997-5		(06131)584278-0
Fax: (06731)997997-6		(06131)584278-1
Mobil: (0177)4512645

[phpesp-dev] Road map of file structure

[Oleg U. <op...@co...>]

I've been using phpESP for a bit now, and I'd like to try my hand at 
playing around with modifying the code.  Does anyone have a "map" of the 
program that outlines how the different .php and .inc files relate to 
each other and the function of each?  I've figured out the major 
outline, but it's still difficult to figure out in which file a specific 
action happens (just one example: which file handles writing the 
completion time to the response DB?).

Thanks in advance for any help/advice.

Oleg Urminsky
Columbia University

[phpesp-dev] 406 Not Acceptable

[Tom K <tk...@gm...>]

Tried general-help with no luck. I am getting this error when-ever I
try to go to the "Manage Groups" link of the "Management Interface"
... 406 Not Acceptable



Everything else works fine as far as I can tell, but not the Manage Groups"


"Any" help greatly appreciated!

Tom K.


Here is my test.php:

 PHP Information

    * Version: 4.3.10
    * OS: Linux
    * SAPI: apache
    * register_globals: Yes
    * magic_quotes_gpc: Yes
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: No
    * GD: Yes -- bundled (2.0.28 compatible)
    * GNU Gettext: No
    * LDAP: No
    * MySQL: Yes
    * PHP Extension Dir (compiled):
/usr/local/lib/php/extensions/no-debug-non-zts-20020429
    * PHP Extension Dir (run time): ./

phpESP Settings

    * Expected ESP_BASE: /home/solveule/public_html/survey/
    * Expected base_url: http://www.solveulearn.com/survey/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /home/solveule/public_html/survey/
    * base_url: http://www.solveulearn.com/survey/
    * Version: 1.6.1
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Emulated
    * default_lang: en_US
    * current lang: en_US
    * available langs: fr_FR, it_IT, de_DE, pt_BR, ja_JP, da_DK,
en_US, nl_NL, el_GR, es_ES, pt_PT, sv_SE
      (da, de, el, en, es, fr, it, ja, nl, pt, sv)
    * GNU Gettext test: %%%% Gettext Test Failed
    * Catalog Open Test: Yes

PHP Session Test

    * session.save_path: /tmp
    * Counter: 1

Re: [phpesp-dev] Re: groups.inc

[Matthew G. <gr...@mu...>]

I'm guessing this * *SAPI: cgi * from the posted test.php may be the
problem.=20
On Mon, 2005-01-24 at 07:06 -0700, James E. Flemer wrote:
> Forwarding this to the phpESP-devel list...
>=20
> Lex Schraa wrote:
> > Hello James,
> >=20
> > I have a problem with phpesp.
> >=20
> > If want to manage groups I get:
> >=20
> > *Warning*: mysql_result(): supplied argument is not a valid MySQL res=
ult=20
> > resource in=20
> > */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* =
on=20
> > line *62*
> >=20
> > *Warning*: mysql_result(): supplied argument is not a valid MySQL res=
ult=20
> > resource in=20
> > */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* =
on=20
> > line *62*
> >=20
> > *Warning*: mysql_result(): supplied argument is not a valid MySQL res=
ult=20
> > resource in=20
> > */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* =
on=20
> > line *62*
> > =20
> > *Warning*: mysql_free_result(): supplied argument is not a valid MySQ=
L=20
> > result resource in=20
> > */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* =
on=20
> > line *80*
> >=20
> > If a run test.php I get:
> >=20
> > *PHP Information*
> >=20
> >     * *Version: 4.3.1 *
> >     * *OS: Linux *
> >     * *SAPI: cgi *
> >     * *register_globals: Yes *
> >     * *magic_quotes_gpc: Yes *
> >     * *magic_quotes_runtime: No *
> >     * *safe_mode: No *
> >     * *open_basedir: *
> >=20
> > *PHP Extensions*
> >=20
> >     * *dBase: No *
> >     * *GD: Yes -- bundled (2.0 compatible) *
> >     * *GNU Gettext: No *
> >     * *LDAP: No *
> >     * *MySQL: Yes *
> >     * *PHP Extension Dir (compiled):
> >       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
> >     * *PHP Extension Dir (run time):
> >       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
> >=20
> > *phpESP Settings*
> >=20
> >     * *Expected ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
> >     * *Expected base_url: http://www.kce.nu/evaluatie/ *
> >     * *Loading phpESP.ini.php ...*
> >     * *ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
> >     * *base_url: http://www.kce.nu/evaluatie *
> >     * *Version: 1.6.1 *
> >     * *Debug: No *
> >=20
> > *phpESP Language Settings*
> >=20
> >     * *GNU Gettext: Emulated *
> >     * *default_lang: nl_NL *
> >     * *current lang: nl_NL *
> >     * *available langs: da_DK, de_DE, el_GR, en_US, es_ES, fr_FR, it_=
IT,
> >       ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
> >       (da, de, el, en, es, fr, it, ja, nl, pt, sv) *
> >     * *GNU Gettext test: %%%% Gettext Test Failed *
> >     * *Catalog Open Test: Yes *
> >=20
> > *PHP Session Test*
> >=20
> >     * *session.save_path: /tmp *
> >     * *Counter: 1 *
> >=20
> > My server is of a provider. So I can=FFt change anything there other =
then=20
> > de phpesp configurationfiles by FTP.
> >=20
> > I can=FFt figure out what=FFs the reason my groups are giving this pr=
oblem.
> >=20
> > **/Lex Schraa/**
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>=20
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

Re: [phpesp-dev] Re: groups.inc

[Aaron A. <li...@fr...>]

Could this be due to a newer version of mysql than expected by phpesp?

James E. Flemer wrote:

> Forwarding this to the phpESP-devel list...
>
> Lex Schraa wrote:
>
>> Hello James,
>>
>> I have a problem with phpesp.
>>
>> If want to manage groups I get:
>>
>> *Warning*: mysql_result(): supplied argument is not a valid MySQL=20
>> result resource in=20
>> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc*=20
>> on line *62*
>>
>> *Warning*: mysql_result(): supplied argument is not a valid MySQL=20
>> result resource in=20
>> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc*=20
>> on line *62*
>>
>> *Warning*: mysql_result(): supplied argument is not a valid MySQL=20
>> result resource in=20
>> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc*=20
>> on line *62*
>> =20
>> *Warning*: mysql_free_result(): supplied argument is not a valid=20
>> MySQL result resource in=20
>> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc*=20
>> on line *80*
>>
>> If a run test.php I get:
>>
>> *PHP Information*
>>
>>     * *Version: 4.3.1 *
>>     * *OS: Linux *
>>     * *SAPI: cgi *
>>     * *register_globals: Yes *
>>     * *magic_quotes_gpc: Yes *
>>     * *magic_quotes_runtime: No *
>>     * *safe_mode: No *
>>     * *open_basedir: *
>>
>> *PHP Extensions*
>>
>>     * *dBase: No *
>>     * *GD: Yes -- bundled (2.0 compatible) *
>>     * *GNU Gettext: No *
>>     * *LDAP: No *
>>     * *MySQL: Yes *
>>     * *PHP Extension Dir (compiled):
>>       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
>>     * *PHP Extension Dir (run time):
>>       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
>>
>> *phpESP Settings*
>>
>>     * *Expected ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
>>     * *Expected base_url: http://www.kce.nu/evaluatie/ *
>>     * *Loading phpESP.ini.php ...*
>>     * *ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
>>     * *base_url: http://www.kce.nu/evaluatie *
>>     * *Version: 1.6.1 *
>>     * *Debug: No *
>>
>> *phpESP Language Settings*
>>
>>     * *GNU Gettext: Emulated *
>>     * *default_lang: nl_NL *
>>     * *current lang: nl_NL *
>>     * *available langs: da_DK, de_DE, el_GR, en_US, es_ES, fr_FR, it_I=
T,
>>       ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
>>       (da, de, el, en, es, fr, it, ja, nl, pt, sv) *
>>     * *GNU Gettext test: %%%% Gettext Test Failed *
>>     * *Catalog Open Test: Yes *
>>
>> *PHP Session Test*
>>
>>     * *session.save_path: /tmp *
>>     * *Counter: 1 *
>>
>> My server is of a provider. So I can=92t change anything there other=20
>> then de phpesp configurationfiles by FTP.
>>
>> I can=92t figure out what=92s the reason my groups are giving this pro=
blem.
>>
>> **/Lex Schraa/**
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>

--=20
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC -- http://www.modevi=
a.com

[phpesp-dev] Re: groups.inc

[James E. F. <jf...@uv...>]

Forwarding this to the phpESP-devel list...

Lex Schraa wrote:
> Hello James,
>=20
> I have a problem with phpesp.
>=20
> If want to manage groups I get:
>=20
> *Warning*: mysql_result(): supplied argument is not a valid MySQL resul=
t=20
> resource in=20
> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* on=
=20
> line *62*
>=20
> *Warning*: mysql_result(): supplied argument is not a valid MySQL resul=
t=20
> resource in=20
> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* on=
=20
> line *62*
>=20
> *Warning*: mysql_result(): supplied argument is not a valid MySQL resul=
t=20
> resource in=20
> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* on=
=20
> line *62*
> =20
> *Warning*: mysql_free_result(): supplied argument is not a valid MySQL=20
> result resource in=20
> */home/users/k/c/kcenu/www/evaluatie/admin/include/where/groups.inc* on=
=20
> line *80*
>=20
> If a run test.php I get:
>=20
> *PHP Information*
>=20
>     * *Version: 4.3.1 *
>     * *OS: Linux *
>     * *SAPI: cgi *
>     * *register_globals: Yes *
>     * *magic_quotes_gpc: Yes *
>     * *magic_quotes_runtime: No *
>     * *safe_mode: No *
>     * *open_basedir: *
>=20
> *PHP Extensions*
>=20
>     * *dBase: No *
>     * *GD: Yes -- bundled (2.0 compatible) *
>     * *GNU Gettext: No *
>     * *LDAP: No *
>     * *MySQL: Yes *
>     * *PHP Extension Dir (compiled):
>       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
>     * *PHP Extension Dir (run time):
>       /usr/local/lib/php/extensions/no-debug-non-zts-20020429 *
>=20
> *phpESP Settings*
>=20
>     * *Expected ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
>     * *Expected base_url: http://www.kce.nu/evaluatie/ *
>     * *Loading phpESP.ini.php ...*
>     * *ESP_BASE: /home/users/k/c/kcenu/www/evaluatie/ *
>     * *base_url: http://www.kce.nu/evaluatie *
>     * *Version: 1.6.1 *
>     * *Debug: No *
>=20
> *phpESP Language Settings*
>=20
>     * *GNU Gettext: Emulated *
>     * *default_lang: nl_NL *
>     * *current lang: nl_NL *
>     * *available langs: da_DK, de_DE, el_GR, en_US, es_ES, fr_FR, it_IT=
,
>       ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
>       (da, de, el, en, es, fr, it, ja, nl, pt, sv) *
>     * *GNU Gettext test: %%%% Gettext Test Failed *
>     * *Catalog Open Test: Yes *
>=20
> *PHP Session Test*
>=20
>     * *session.save_path: /tmp *
>     * *Counter: 1 *
>=20
> My server is of a provider. So I can=92t change anything there other th=
en=20
> de phpesp configurationfiles by FTP.
>=20
> I can=92t figure out what=92s the reason my groups are giving this prob=
lem.
>=20
> **/Lex Schraa/**

[phpesp-dev] [ phpesp-Bugs-1023933 ] Does not seem to work with PHP 5.0.1

[SourceForge.net <no...@so...>]

Bugs item #1023933, was opened at 2004-09-07 12:43
Message generated for change (Comment added) made by pneill
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 2
Submitted By: ChrisDavis (cxd101)
Assigned to: Nobody/Anonymous (nobody)
Summary: Does not seem to work with PHP 5.0.1

Initial Comment:
I recently installed phpESP 1.6 on my Apple PowerBook
G4, running OSX 10.3.5, with MySql 3.23.54, and PHP
5.0.1. After succesfully pasting the test.php screen,
login was not possible. When using the index.php
screen, a login window appeared. I would enter the ID
and PW, hit the enter button, and then the login window
would reappear - as if I was first entering the basic
login screen.

I then took phpESP and installed in on an older OSX
machine, running OSX 10.2, with MySql 3.23.54 and PHP
4.6.3 (4.x), and phpESP worked just fine!

So my belief is that version 1.6 is not capable of used
with PHP 5.0.1.

Regards!

----------------------------------------------------------------------

Comment By: Pat Neill (pneill)
Date: 2005-01-20 20:03

Message:
Logged In: YES 
user_id=413628

Experienced exact same problem.

php 5.01
mySQl 4.0.2.3
MacOS X 10.3.7

----------------------------------------------------------------------

Comment By: Matthew Gregg (greggmc)
Date: 2005-01-18 10:23

Message:
Logged In: YES 
user_id=14116

ESP hasn't been tested with PHP 5, if it works at all that's
excellent.  When my dev platform is updated to support PHP
5, work may be done to support it.

----------------------------------------------------------------------

Comment By: Scott Hannan (avanu)
Date: 2005-01-18 08:52

Message:
Logged In: YES 
user_id=575450

It is working for me.  However, I have all the backward 
compatibility stuff enabled.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

[phpesp-dev] [ phpesp-Bugs-1023933 ] Does not seem to work with PHP 5.0.1

[SourceForge.net <no...@so...>]

Bugs item #1023933, was opened at 2004-09-07 14:43
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
>Priority: 2
Submitted By: ChrisDavis (cxd101)
Assigned to: Nobody/Anonymous (nobody)
Summary: Does not seem to work with PHP 5.0.1

Initial Comment:
I recently installed phpESP 1.6 on my Apple PowerBook
G4, running OSX 10.3.5, with MySql 3.23.54, and PHP
5.0.1. After succesfully pasting the test.php screen,
login was not possible. When using the index.php
screen, a login window appeared. I would enter the ID
and PW, hit the enter button, and then the login window
would reappear - as if I was first entering the basic
login screen.

I then took phpESP and installed in on an older OSX
machine, running OSX 10.2, with MySql 3.23.54 and PHP
4.6.3 (4.x), and phpESP worked just fine!

So my belief is that version 1.6 is not capable of used
with PHP 5.0.1.

Regards!

----------------------------------------------------------------------

>Comment By: Matthew Gregg (greggmc)
Date: 2005-01-18 13:23

Message:
Logged In: YES 
user_id=14116

ESP hasn't been tested with PHP 5, if it works at all that's
excellent.  When my dev platform is updated to support PHP
5, work may be done to support it.

----------------------------------------------------------------------

Comment By: Scott Hannan (avanu)
Date: 2005-01-18 11:52

Message:
Logged In: YES 
user_id=575450

It is working for me.  However, I have all the backward 
compatibility stuff enabled.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

[phpesp-dev] [ phpesp-Bugs-1023933 ] Does not seem to work with PHP 5.0.1

[SourceForge.net <no...@so...>]

Bugs item #1023933, was opened at 2004-09-07 19:43
Message generated for change (Comment added) made by avanu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: ChrisDavis (cxd101)
Assigned to: Nobody/Anonymous (nobody)
Summary: Does not seem to work with PHP 5.0.1

Initial Comment:
I recently installed phpESP 1.6 on my Apple PowerBook
G4, running OSX 10.3.5, with MySql 3.23.54, and PHP
5.0.1. After succesfully pasting the test.php screen,
login was not possible. When using the index.php
screen, a login window appeared. I would enter the ID
and PW, hit the enter button, and then the login window
would reappear - as if I was first entering the basic
login screen.

I then took phpESP and installed in on an older OSX
machine, running OSX 10.2, with MySql 3.23.54 and PHP
4.6.3 (4.x), and phpESP worked just fine!

So my belief is that version 1.6 is not capable of used
with PHP 5.0.1.

Regards!

----------------------------------------------------------------------

Comment By: Scott Hannan (avanu)
Date: 2005-01-18 16:52

Message:
Logged In: YES 
user_id=575450

It is working for me.  However, I have all the backward 
compatibility stuff enabled.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1023933&group_id=8956

[phpesp-dev] [ phpesp-Bugs-1096917 ] SELECT name FROM question

[SourceForge.net <no...@so...>]

Bugs item #1096917, was opened at 2005-01-06 10:45
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1096917&group_id=8956

Category: SQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Chego huang (chego)
Assigned to: Nobody/Anonymous (nobody)
Summary: SELECT name FROM question

Initial Comment:
error SQL query at
\admin\include\function\survey_update.inc
line 142
$sql = "SELECT name FROM question WHERE 
survey_id=${survey_id} AND deleted = 'N'";

Please change
$sql = "SELECT name FROM ".$GLOBALS['ESPCONFIG']
['question_table']." WHERE survey_id=${survey_id} AND 
deleted = 'N'";

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1096917&group_id=8956

[phpesp-dev] Chinese translation [zh_TW]

[James E. F. <jf...@uv...>]

-------- Original Message --------
Subject: 	Language Translations
Date: 	Tue, 4 Jan 2005 06:57:37 +0800
From: 	Chego Huang <c....@ch...>
To: 	James Flemer <jf...@al...>



Hi,
I have translated your phpESP to Chinese language (Chinese (traditional)).
locale->zh_TW

Thank you for your good job.

Chego Huang <c....@ch...>