Re: [phpesp-dev] respondent interface

[flobee <fl...@gm...>]

yo!
i think the querys (1) must be worked out for "respondent_survey_results"
otherwise users could browse throught the hole database and can see all
single surveys-results even those which need authentification to get into it
:
public / respondent_survey_results.inc.php
~ 85:
        // load survey title (and other globals)
        $sql = "SELECT * FROM survey WHERE id='${sid}'";

should be something like this:
// load survey title (and other globals)  ++ but user specific
        $sql = "SELECT * FROM survey A, response R
                         WHERE A.id='${sid}'
                         AND A.realm = '$realm'  // Im not sure!!! one user
ONLY for one realm??
                         AND R.username = '$user'
                         AND R.survey_id ='${sid}'
                         AND R.complete ='Y'
                         ";
than extra check if result is empty (num rows < 1) = not found : echo "wrong
user, group?  or survey not complete";

or am i wrong?
actually it´s set to respondent_survey_results_navbar but you will get the
result

note: this is only for this respondent interface! the main version if fine
flobee

----- Original Message ----- 
From: "Chad Bearden" <ch...@be...>
To: "flobee" <fl...@gm...>
Cc: <php...@li...>
Sent: Tuesday, May 27, 2003 1:03 PM
Subject: Re: [phpesp-dev] respondent interface


Gosh.  Glad you like it.  I'm not familiar with the flash ui but will
give it a look.  Someone (maybe you) asked for an interface for a
respondent to change their password and this is a good idea.  Right now
I'm fooling with the "right" way to add management functions that
doesn't break the phpESP core releases.  Items on the agenda:

Better reporting
Being able to pull choices from a db table rather than enter them into
the questions interface.
Sorting choices when displayed in abc or numerical order.

chad.

On Saturday, May 24, 2003, at 17:16 US/Eastern, flobee wrote:

> i´m jealous (envious , grudging ) , cool script :-)   (don´t know the
> right
> word) :-o
> i build something similar but much more complicated (and out of phpesp
> file
> structure) ...
> just want to tell you: really good option!!
>
> your MOD could be good to start with a flash user interface  i´m
> thinking
> for a while to do one (as well a "survey-remote" tool (what i basicly
> do:
> flash)
> can have the tables and more limited results for the beginning - >
> because
> i´m still not sure how to handle huge result pages in flash.
> has anyone thinking about using flash? i remember somebody in this list
> showed something with graphs as an option for the results
> well , flash only or templates graphs for each question , question
> type as
> option to show the results , i could imagine would be a nice option.!
> let me know -> i´m not on that level yet to develop the php code for
> this
> project! but flash no problem, and php:  i´m lerning and learning :-)
> reference.: (no graphs but dynamic flash CMS system:
> www.deliciousgarden.com )
>
> kind regards flobee
>
>
> ----- Original Message -----
> From: "Chad Bearden" <ch...@be...>
> To: "flobee" <fl...@gm...>; <php...@li...>
> Sent: Wednesday, May 21, 2003 2:44 PM
> Subject: Re: [phpesp-dev] respondent interface
>
>
> Take a look at the code in
> phpESP/public/respondent_survey_results.inc.php  I think this may do
> what you want.  The code is just a hacked version of the
> survey_results.php code but limits to looking at just 1 result.  It
> also ignores answers that weren't checked.
>
> chad.
>
> On Wednesday, May 21, 2003, at 07:06 US/Eastern, flobee wrote:
>
>> yo! thats what i need in some ways! my post was in the same time than
>> you
>> update :-)
>> have you any idea if it is possible to get the postet
>> information/result
>> form a single repondent of a survey?
>> i´m not quite sure! if than, i think it must be a huge query, insn´t
>> it!?
>> kind regards
>> flobee
>> ----- Original Message -----
>> From: "Chad Bearden" <ch...@be...>
>> To: <php...@li...>
>> Sent: Tuesday, May 20, 2003 9:37 PM
>> Subject: [phpesp-dev] respondent interface
>>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>



-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
phpESP-devel mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/phpesp-devel