phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] [ phpesp-Bugs-1410940 ] Accessing designer account admin logs you out

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

Bugs item #1410940, was opened at 2006-01-20 11:56
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1410940&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: blentz (blentz)
Assigned to: Nobody/Anonymous (nobody)
Summary: Accessing designer account admin logs you out

Initial Comment:
When logged in as a superuser with all ACL abilities, I
try to go and modify an existing designer. I can get as
far as the "Designers Account Administration" form, but
if I click *anything* i.e. Update/Cancel/Delete
buttons, Go back to Management Interface link, or even
manually try and go to /admin/manage.php, I am booted
out and am sent to the Management Login form with
"Incorrect User ID or Password, or your account has
been disabled/expired."

This makes changing or deleting an existing designer
impossible.

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

>Comment By: Matthew Gregg (greggmc)
Date: 2006-06-23 10:27

Message:
Logged In: YES 
user_id=14116

Are you using version 1.8.2 and do you have register_globals
on or off?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-06-23 10:09

Message:
Logged In: NO 

I'm having the same problem.  Can someone give me some 
instructions for how to install the patch.  Sorry, I'm a 
noob at this.  

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

Comment By: blentz (blentz)
Date: 2006-03-16 14:28

Message:
Logged In: YES 
user_id=997838

Please try to use the patch I attached to this bug report
back in January. It will fix your problem.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-16 13:47

Message:
Logged In: NO 

I am having the same issue... I am going to rrot out my bad 
account thru MySQL...  But you are right, we are unable to 
mod, del, and created account using phpESP.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-03 09:04

Message:
Logged In: NO 

Same Problem!

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

Comment By: blentz (blentz)
Date: 2006-01-23 23:21

Message:
Logged In: YES 
user_id=997838

I'm guessing you're both right; problem is that I have other
PHP applications on the system that require register_globals.

I've created a patch from the changes by R. Schroeder, can
be applied to the phpESP source tree using:

patch -p0 < phpESP-1.8.patch

Tested, corrects this bug. Perhaps this patch could be
incorporated into the next release, making the Administer
Respondants and Administer Designers work on systems with
register_globals?

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-01-23 19:50

Message:
Logged In: YES 
user_id=14116

I believe this bug is only present when register globals is
on(an unsupported configuration).   But I could be wrong.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-01-23 18:56

Message:
Logged In: NO 

Check around line 180 in admdesigner.inc. My modifications
are below to fix conflicting variable names. Similar fix
applies to admrespondent.

        /* load ACL */
        if(!empty($u) && !empty($r)) {
                $sql = "SELECT * FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE
username=$u AND realm=$r";
                $result =
execute_sql($sql,"",ADODB_FETCH_ASSOC);
                if($arr = fetch_row($result)) {
                        /*
                        foreach(array(
                                'username', 'realm',
'fname', 'lname', 'email',
                                'pdesign', 'pstatus',
'pdata', 'pall', 'pgroup', 'puser',
                                'disabled', 'expiration') as
$col)
                                { $$col = $arr[$col]; }
                        $u =& $username;
                        $r =& $realm;
                        */
                        // Ryan Schroeder - assign manually
to avoid conflicting with $username
                        $u = $arr['username'];
                        $r = $arr['realm'];
                        $fname = $arr['fname'];
                        $lname = $arr['lname'];
                        $email = $arr['email'];
                        $pdesign = $arr['pdesign'];
                        $pstatus = $arr['pstatus'];
                        $pdata = $arr['pdata'];
                        $pall = $arr['pall'];
                        $pgroup = $arr['pgroup'];
                        $puser = $arr['puser'];
                        $disabled = $arr['disabled'];
                        $expiration = $arr['expiration'];

                        if(intval($expiration) > 0) {
                                $ex_year  =
substr($expiration,0,4);
                                $ex_month =
substr($expiration,4,2);
                                $ex_day   =
substr($expiration,6,2);
                        } else {
                                $ex_year  = '';
                                $ex_month = '';
                                $ex_day   = '';
                        }
                } else {
                        $errstr .= mkerror(_('Account not
found.') .' ('.
                                ErrorMsg() .')');
                }
        }


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

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

[phpesp-dev] [ phpesp-Feature Requests-1010062 ] Groups/Realms

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

Feature Requests item #1010062, was opened at 2004-08-16 10:13
Message generated for change (Settings changed) made by axelseaa
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=1010062&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Aaron Axelsen (axelseaa)
Assigned to: Nobody/Anonymous (nobody)
>Summary: Groups/Realms

Initial Comment:
Right now, if the same user wants to be a member of
mult groups, or the admin of many different groups the
way to implement it is very sticky.  Could this
interface maybe be cleaned up a little?

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

>Comment By: Aaron Axelsen (axelseaa)
Date: 2006-06-19 13:30

Message:
Logged In: YES 
user_id=704595

The best solution to this will be to create another table
realms_access that contains username, realm, pdesign,
pstatus, pdata, pall, pgroup and puser.

This would also entail updateing several other aspects of
the application to reflect this.

Time permitting, I will try to submit a patch for this.

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

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

[phpesp-dev] [ phpesp-Bugs-1451543 ] Update / Del Designer Account Issue

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

Bugs item #1451543, was opened at 2006-03-16 10:41
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1451543&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.8
Status: Closed
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Update / Del Designer Account Issue

Initial Comment:
Greetings All:

1st off, thanks to phpESP for making the app...  Big 
help!  However, having a little issue.  

1: When I try to mod or del a designer account I get 
kicked out and back to the login page...  And it will 
do this with every superuser account.

I read that the globals should be set to "off"...  My 
Question is, where do I set the globals to off if they 
are not already???  Is this on the server in a PHP 
script or on MYSQL or in the phpESP progie?  

And do you think that this is my issue at all?

Thanx All.

Az

bc...@ti...

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-06-19 04:52

Message:
Logged In: NO 

how to modify the php.ini to solve the problem?

Thanks

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-16 14:31

Message:
Logged In: YES 
user_id=14116

It's a PHP setting.  Look for a php.ini somewhere on your
system.

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

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

[phpesp-dev] Respondent can view results instantly on submission

[Amy B. <bel...@ns...>]

Has anyone ever made a hack to allow respondents to see the results
right away?=20

=20

[phpesp-dev] [ phpesp-Bugs-1501802 ] Error populating text boxes -w- dates on act. mgmt screens

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

Bugs item #1501802, was opened at 2006-06-06 11:18
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=1501802&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error populating text boxes -w- dates on act. mgmt screens

Initial Comment:
On the manage accounts pages, when an account is 
selected -w- an expiry date, it is formatted 
incorrectly (day and month are being read from the 
wrong ordinal). Not sure if this is because of my 
environment (Win 2000 / PHP5 / Apache2) or what, but 
I've fixed the issue by replacing with the following 
in admdesigner.inc (line 193) and admrespondent.inc 
(line 167):

REPLACE:

$ex_year  = substr($expiration,0,4);
$ex_month = substr($expiration,4,2);
$ex_day   = substr($expiration,6,2);


WITH:

$ex_year  = substr($expiration,0,4);
$ex_month = substr($expiration,5,2);
$ex_day   = substr($expiration,8,2);

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

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

[phpesp-dev] [ phpesp-Feature Requests-1498756 ] Autologin in private survey by web link

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

Feature Requests item #1498756, was opened at 2006-06-01 03:08
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=1498756&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Autologin in private survey by web link

Initial Comment:
Hello,

Would it be possible in the future to use a web link 
in order to allow respondents autologin in private 
surveys ?

Example: http...survey.php?name=(survey name)&usr=
(user id)&pwd=(pwd for user id)

Thank you very much for your great work. It's simply 
the best opensource solution for surveys.

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

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

[phpesp-dev] [ phpesp-Feature Requests-816517 ] Cross-analysis of more than one question

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

Feature Requests item #816517, was opened at 2003-10-02 04:57
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=816517&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: data analysis
Group: None
Status: Open
Priority: 5
Submitted By: Del (delson)
Assigned to: Kon Angelopoulos (angek)
Summary: Cross-analysis of more than one question

Initial Comment:
Just wanted to flag that being able to select more than
one question in cross-analysis and limit the set being
returned by answers to those questions would be useful.

eg: Q1 is yes / no
Q2 is yes / no

Want to see ONLY those people who answered yes to Q1
and no to Q2.

Other than that, thanks for a fine piece of code.


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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-06-01 02:52

Message:
Logged In: NO 

And would it be possible to do such cross-analysis for n 
questions (ex. 4 questions or even more) ?

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

Comment By: Kon Angelopoulos (angek)
Date: 2004-05-09 23:25

Message:
Logged In: YES 
user_id=198398

I'm actually writing the code for this. I'll make the diff 
available for testing in the next couple of weeks.

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

Comment By: Kon Angelopoulos (angek)
Date: 2004-05-09 23:24

Message:
Logged In: YES 
user_id=198398

I'm actually writing the code for this. I'll make the diff 
available for testing in the next couple of weeks.

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

Comment By: Kon Angelopoulos (angek)
Date: 2004-05-09 23:23

Message:
Logged In: YES 
user_id=198398

I'm actually writing the code for this. I'll make the diff 
available for testing in the next couple of weeks.

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

Comment By: Kon Angelopoulos (angek)
Date: 2004-05-09 23:22

Message:
Logged In: YES 
user_id=198398

I'm actually writing the code for this. I'll make the diff 
available for testing in the next couple of weeks.

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

Comment By: Kon Angelopoulos (angek)
Date: 2004-05-09 23:21

Message:
Logged In: YES 
user_id=198398

I'm actually writing the code for this. I'll make the diff 
available for testing in the next couple of weeks.

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

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

[phpesp-dev] [ phpesp-Feature Requests-692877 ] mail group members when survey is activated

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

Feature Requests item #692877, was opened at 2003-02-25 05:22
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=692877&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Chad Bearden (ebeard)
Assigned to: Nobody/Anonymous (nobody)
Summary: mail group members when survey is activated

Initial Comment:
When a survey is activated it would useful to have an option to email all members of the groups that were assigned to this survey.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-06-01 02:45

Message:
Logged In: NO 

I would also add the following points:

- New section in the managing interface of phpesp giving 
access a space dedicated to the sending of recalls by mail.

- The possibility of choosing the survey for which it is 
necessary to send a recall by mail.

- The possibility of addressing in the mail at the same 
time as a bond of access to the study:

- the name of the user

- the password of the user

- a text field allowing to enter a message which will be 
sent with the recall.

- a field allowing to set the mail address of the person 
sending the message of recall



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

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

[phpesp-dev] [ phpesp-Bugs-1498228 ] gettext test fails even though support is 'real'

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

Bugs item #1498228, was opened at 2006-05-31 06:46
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=1498228&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: gettext test fails even though support is 'real'

Initial Comment:
As stated in docs/TRANSLATIONS:

--- Line 31 and 32
If the test fails, and support is 'Real,' please
send a bug report along with the entire system test page.
---

This is the output of admin/test.php:
---
PHP Information
Version: 4.4.0-3ubuntu2
OS: Linux
SAPI: apache
register_globals: No
magic_quotes_gpc: No
magic_quotes_runtime: No
safe_mode: No
open_basedir:

PHP Extensions
dBase: No
GD: Yes -- 2.0 or higher
GNU Gettext: Yes
LDAP: No
MySQL: Yes
PHP Extension Dir (compiled): /usr/lib/php4/20050606
PHP Extension Dir (run time): /usr/lib/php4/20050606

phpESP Settings
Expected ESP_BASE: /home/testbed/public_html/phpesp/
Expected base_url: blackbox.loopback.nu/~testbed/phpesp/
Loading phpESP.ini.php ...
ESP_BASE: /home/testbed/public_html/phpesp/
base_url: http://blackbox.loopback.nu/~testbed/phpesp/
Version: 1.8.1
Debug: No

phpESP Language Settings
GNU Gettext: Real
default_lang: en_US
current lang: en_US
available langs: da_DK, de_DE, el_GR, en_US, es_ES, fi, fi_FI, fr_FR, 
hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
(da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
GNU Gettext test: %%%% Gettext Test Failed
Catalog Open Test: Yes
PHP Session Test
session.save_path: /tmp/sessions
Counter: 2
---


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

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

[phpesp-dev] [ phpesp-Bugs-1311839 ] Can not add respondent

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

Bugs item #1311839, was opened at 2005-10-03 08:21
Message generated for change (Settings changed) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1311839&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
>Group: v1.8
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Neil (neilsourceforge)
>Assigned to: Matthew Gregg (greggmc)
Summary: Can not add respondent

Initial Comment:
I could not replicate this problem using the 'demo' site. 
Adding a respondent, using the instructions below, 
works on the demo site.

At my installation:
An attempt to add a respondent to their group from 
the 'Manage Respondent Accounts' page meets the 
response '[ This account does not have permission to 
access this group. ]'

This feedback is obtained when selecting the link 'Add a 
New Respondent'. When the same information is stored 
in a file and the link 'Bulk Upload Respondents' is 
selected the respondent is added. The developer's 
account is fully privileged with the following attributes:
Disabled   No
Design Surveys   Yes
Change Survey Status   Yes
Export Survey Data   Yes
Group Editor   Yes
Administer Designers   Yes
Administer Respondents   Yes

The fact that a respondent can be added using Bulk 
Upload implies it is not a permissions issue. Can 
anyone provide insight on how to correct this?


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

Comment By: Matthew Gregg (greggmc)
Date: 2006-04-24 14:36

Message:
Logged In: YES 
user_id=14116

I just fixed a bug relating to the expiration field that was
causing issues adding/editing designers/respondents.  I'm
not sure it's related to this bug, but it did cause problems
adding users.  I'll generate a new release shortly.

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

Comment By: Neil (neilsourceforge)
Date: 2006-04-11 15:04

Message:
Logged In: YES 
user_id=1181273

This request has been open since October of last year.

Developers can not add a single respondent and can not 
delete a respondent. They can Bulk Upload only.

A SuperUser account can delete single respondents but I 
would prefer each developer to manage their own respondents 
and not have to intervene.

Can this be fixed or can someone offer an explanation why a 
developer is told they do not have permission? Every 
attribute per developer has been allowed.

.../neil patterson

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

Comment By: Neil (neilsourceforge)
Date: 2006-01-24 09:15

Message:
Logged In: YES 
user_id=1181273

The test continues to fail with release 1.8.

.../neil patterson

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-01-23 19:48

Message:
Logged In: YES 
user_id=14116

This bug is marked 1.7.  Have you tried to reproduce this
with the current ESP version of 1.8?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-01-23 19:39

Message:
Logged In: NO 

there is a bug in admrespondent.inc and admdesigner.inc.
Look for my changes identified by //Ryan Schroeder

       /* delete user */
        if(isset($_POST['delete'])) {
                unset($_POST['submit']);
                $u = _addslashes($_POST['u']);
                $r = _addslashes($_POST['r']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];
                /* check acl */
                if($_SESSION['acl']['superuser'] == 'Y' ||
                        // Ryan Schroeder
                        in_array($theRealm,
$_SESSION['acl']['pgroup']) ||
                        auth_no_access(_('to access this
group'))) {
                        $sql = "DELETE FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE
username=$u AND realm=$r";
                        if(!execute_sql($sql) ||
affected_rows() < 1) {
                                /* unsucessfull -- abort */
                                $errstr .= mkerror(_('Cannot
delete account.') .' ('.
                                        ErrorMsg() .')');
                        }
                }
                if(empty($errstr)) {
                        include(esp_where('designers'));
                        return;
                }
        }

        /* submitted */
        if(isset($_POST['submit'])) {
                $u         = _addslashes($_POST['u']);
                $r         = _addslashes($_POST['r']);
                $password  = _addslashes($_POST['password']);
                $fname     = _addslashes($_POST['fname']);
                $lname     = _addslashes($_POST['lname']);
                $email     = _addslashes($_POST['email']);
                $pdesign   = _addslashes($_POST['pdesign']);
                $pstatus   = _addslashes($_POST['pstatus']);
                $pdata     = _addslashes($_POST['pdata']);
                $pall      = _addslashes($_POST['pall']);
                $pgroup    = _addslashes($_POST['pgroup']);
                $puser     = _addslashes($_POST['puser']);
                $disabled  = _addslashes($_POST['disabled']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];

.....

                /* new user */
        /* check acl */
        if($_SESSION['acl']['superuser'] == 'Y' ||
            // Ryan Schroeder
            in_array($theRealm, $_SESSION['acl']['pgroup']) ||
 


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

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

[phpesp-dev] [ phpesp-Bugs-1492751 ] Error in data from Ratings questions when responses emailed

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

Bugs item #1492751, was opened at 2006-05-22 00:29
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=1492751&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error in data from Ratings questions when responses emailed

Initial Comment:
Data shown in emailed copies of submitted surveys is
incremented by 1, eg if survey response is a rating of
5 (on a 1-5 rating scale) the response on the email
form is a 6. This occurrs for each possible rating
option, so 1's become 2; 2's become 3 etc.

The data in the downloaded CSV file is correct, it's
only the email data which is wrong.

Kyle
ky...@uc...

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

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

[phpesp-dev] Var $acl

[Denise <dm...@co...>]

New to the list ...

I'm using phpESP for a client in connection with a MDPro CMS portal.  Since
a stable module for phpESP hasn't been written yet to work in MDPro, I'm
using the postnuke mod "NukeWrapper" to view phpESP within the MDPro portal.

The client does not want users to need to log in a second time (when they
access the Management Interface) ... so I am looking for suggestions as to
how to make these two systems "play well together".

In the meantime can someone give me details on the $acl var and where it is
initiated?

Thanks,
Denise

[phpesp-dev] Database Structure

[Jeff P. <jph...@lm...>]

Hello everyone,=20

I was looking for some information or documentation on the table
structure of the Database for phpESP.

Are there any resources people might be able to point me towards that
will help/enable me to figure out

the details behind the database backend setup.

Thanks, Jeff Phillips

[phpesp-dev] [ phpesp-Bugs-1480092 ] mySQL and md5??

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

Bugs item #1480092, was opened at 2006-05-01 23:33
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=1480092&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: J Peterson (jpeter1491)
Assigned to: Nobody/Anonymous (nobody)
Summary: mySQL and md5??

Initial Comment:
Hello, first I have to say this is a great program.  
Thank you!

Here is my problem...  I manage a website that users 
have already registered for, and their passwords are 
md5 encrypted.  How can I change phpESP to read the 
md5 hash that I copied over from another table?  I've 
tried changing all 'PASSWORD($password)' to 'md5
($password)' to no avail.  I've looked all over the 
README files, FAQs, and searched the mail archives.  
Any other suggestions??  I really appreciate your 
help.

phpESP ver: 1.8.1
mySQL ver: 3.23.58

john [at] johnpetersonpictures [dot] com

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

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

[phpesp-dev] [ phpesp-Bugs-1311839 ] Can not add respondent

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

Bugs item #1311839, was opened at 2005-10-03 08:21
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1311839&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.7
Status: Open
Resolution: None
Priority: 5
Submitted By: Neil (neilsourceforge)
Assigned to: Nobody/Anonymous (nobody)
Summary: Can not add respondent

Initial Comment:
I could not replicate this problem using the 'demo' site. 
Adding a respondent, using the instructions below, 
works on the demo site.

At my installation:
An attempt to add a respondent to their group from 
the 'Manage Respondent Accounts' page meets the 
response '[ This account does not have permission to 
access this group. ]'

This feedback is obtained when selecting the link 'Add a 
New Respondent'. When the same information is stored 
in a file and the link 'Bulk Upload Respondents' is 
selected the respondent is added. The developer's 
account is fully privileged with the following attributes:
Disabled   No
Design Surveys   Yes
Change Survey Status   Yes
Export Survey Data   Yes
Group Editor   Yes
Administer Designers   Yes
Administer Respondents   Yes

The fact that a respondent can be added using Bulk 
Upload implies it is not a permissions issue. Can 
anyone provide insight on how to correct this?


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

>Comment By: Matthew Gregg (greggmc)
Date: 2006-04-24 14:36

Message:
Logged In: YES 
user_id=14116

I just fixed a bug relating to the expiration field that was
causing issues adding/editing designers/respondents.  I'm
not sure it's related to this bug, but it did cause problems
adding users.  I'll generate a new release shortly.

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

Comment By: Neil (neilsourceforge)
Date: 2006-04-11 15:04

Message:
Logged In: YES 
user_id=1181273

This request has been open since October of last year.

Developers can not add a single respondent and can not 
delete a respondent. They can Bulk Upload only.

A SuperUser account can delete single respondents but I 
would prefer each developer to manage their own respondents 
and not have to intervene.

Can this be fixed or can someone offer an explanation why a 
developer is told they do not have permission? Every 
attribute per developer has been allowed.

.../neil patterson

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

Comment By: Neil (neilsourceforge)
Date: 2006-01-24 09:15

Message:
Logged In: YES 
user_id=1181273

The test continues to fail with release 1.8.

.../neil patterson

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-01-23 19:48

Message:
Logged In: YES 
user_id=14116

This bug is marked 1.7.  Have you tried to reproduce this
with the current ESP version of 1.8?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-01-23 19:39

Message:
Logged In: NO 

there is a bug in admrespondent.inc and admdesigner.inc.
Look for my changes identified by //Ryan Schroeder

       /* delete user */
        if(isset($_POST['delete'])) {
                unset($_POST['submit']);
                $u = _addslashes($_POST['u']);
                $r = _addslashes($_POST['r']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];
                /* check acl */
                if($_SESSION['acl']['superuser'] == 'Y' ||
                        // Ryan Schroeder
                        in_array($theRealm,
$_SESSION['acl']['pgroup']) ||
                        auth_no_access(_('to access this
group'))) {
                        $sql = "DELETE FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE
username=$u AND realm=$r";
                        if(!execute_sql($sql) ||
affected_rows() < 1) {
                                /* unsucessfull -- abort */
                                $errstr .= mkerror(_('Cannot
delete account.') .' ('.
                                        ErrorMsg() .')');
                        }
                }
                if(empty($errstr)) {
                        include(esp_where('designers'));
                        return;
                }
        }

        /* submitted */
        if(isset($_POST['submit'])) {
                $u         = _addslashes($_POST['u']);
                $r         = _addslashes($_POST['r']);
                $password  = _addslashes($_POST['password']);
                $fname     = _addslashes($_POST['fname']);
                $lname     = _addslashes($_POST['lname']);
                $email     = _addslashes($_POST['email']);
                $pdesign   = _addslashes($_POST['pdesign']);
                $pstatus   = _addslashes($_POST['pstatus']);
                $pdata     = _addslashes($_POST['pdata']);
                $pall      = _addslashes($_POST['pall']);
                $pgroup    = _addslashes($_POST['pgroup']);
                $puser     = _addslashes($_POST['puser']);
                $disabled  = _addslashes($_POST['disabled']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];

.....

                /* new user */
        /* check acl */
        if($_SESSION['acl']['superuser'] == 'Y' ||
            // Ryan Schroeder
            in_array($theRealm, $_SESSION['acl']['pgroup']) ||
 


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

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

[phpesp-dev] [ phpesp-Bugs-1475519 ] Survey development centres each question

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

Bugs item #1475519, was opened at 2006-04-24 06:02
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=1475519&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Survey development centres each question

Initial Comment:
Just installed 1.8.1. I noticed while Previewing and 
Testing a survey under development that each question 
in the display is centred. After Activating, each 
question is left aligned, as expected. For my test I 
chose Mystic as the Theme.

.../neil patterson

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

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

[phpesp-dev] [ phpesp-Bugs-1311839 ] Can not add respondent

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

Bugs item #1311839, was opened at 2005-10-03 09:21
Message generated for change (Comment added) made by neilsourceforge
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1311839&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.7
Status: Open
Resolution: None
Priority: 5
Submitted By: Neil (neilsourceforge)
Assigned to: Nobody/Anonymous (nobody)
Summary: Can not add respondent

Initial Comment:
I could not replicate this problem using the 'demo' site. 
Adding a respondent, using the instructions below, 
works on the demo site.

At my installation:
An attempt to add a respondent to their group from 
the 'Manage Respondent Accounts' page meets the 
response '[ This account does not have permission to 
access this group. ]'

This feedback is obtained when selecting the link 'Add a 
New Respondent'. When the same information is stored 
in a file and the link 'Bulk Upload Respondents' is 
selected the respondent is added. The developer's 
account is fully privileged with the following attributes:
Disabled   No
Design Surveys   Yes
Change Survey Status   Yes
Export Survey Data   Yes
Group Editor   Yes
Administer Designers   Yes
Administer Respondents   Yes

The fact that a respondent can be added using Bulk 
Upload implies it is not a permissions issue. Can 
anyone provide insight on how to correct this?


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

Comment By: Neil (neilsourceforge)
Date: 2006-04-11 16:04

Message:
Logged In: YES 
user_id=1181273

This request has been open since October of last year.

Developers can not add a single respondent and can not 
delete a respondent. They can Bulk Upload only.

A SuperUser account can delete single respondents but I 
would prefer each developer to manage their own respondents 
and not have to intervene.

Can this be fixed or can someone offer an explanation why a 
developer is told they do not have permission? Every 
attribute per developer has been allowed.

.../neil patterson

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

Comment By: Neil (neilsourceforge)
Date: 2006-01-24 09:15

Message:
Logged In: YES 
user_id=1181273

The test continues to fail with release 1.8.

.../neil patterson

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-01-23 19:48

Message:
Logged In: YES 
user_id=14116

This bug is marked 1.7.  Have you tried to reproduce this
with the current ESP version of 1.8?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-01-23 19:39

Message:
Logged In: NO 

there is a bug in admrespondent.inc and admdesigner.inc.
Look for my changes identified by //Ryan Schroeder

       /* delete user */
        if(isset($_POST['delete'])) {
                unset($_POST['submit']);
                $u = _addslashes($_POST['u']);
                $r = _addslashes($_POST['r']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];
                /* check acl */
                if($_SESSION['acl']['superuser'] == 'Y' ||
                        // Ryan Schroeder
                        in_array($theRealm,
$_SESSION['acl']['pgroup']) ||
                        auth_no_access(_('to access this
group'))) {
                        $sql = "DELETE FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE
username=$u AND realm=$r";
                        if(!execute_sql($sql) ||
affected_rows() < 1) {
                                /* unsucessfull -- abort */
                                $errstr .= mkerror(_('Cannot
delete account.') .' ('.
                                        ErrorMsg() .')');
                        }
                }
                if(empty($errstr)) {
                        include(esp_where('designers'));
                        return;
                }
        }

        /* submitted */
        if(isset($_POST['submit'])) {
                $u         = _addslashes($_POST['u']);
                $r         = _addslashes($_POST['r']);
                $password  = _addslashes($_POST['password']);
                $fname     = _addslashes($_POST['fname']);
                $lname     = _addslashes($_POST['lname']);
                $email     = _addslashes($_POST['email']);
                $pdesign   = _addslashes($_POST['pdesign']);
                $pstatus   = _addslashes($_POST['pstatus']);
                $pdata     = _addslashes($_POST['pdata']);
                $pall      = _addslashes($_POST['pall']);
                $pgroup    = _addslashes($_POST['pgroup']);
                $puser     = _addslashes($_POST['puser']);
                $disabled  = _addslashes($_POST['disabled']);
                // Ryan Schroeder
                $theRealm = $_POST['r'];

.....

                /* new user */
        /* check acl */
        if($_SESSION['acl']['superuser'] == 'Y' ||
            // Ryan Schroeder
            in_array($theRealm, $_SESSION['acl']['pgroup']) ||
 


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

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

[phpesp-dev] [ phpesp-Bugs-1467924 ] Checkbox Question Export Data Bug Report

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

Bugs item #1467924, was opened at 2006-04-10 12:35
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=1467924&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: User
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Checkbox Question Export Data Bug Report

Initial Comment:
Just to let you know, we've had trouble with checkbox
questions in phpESP. The tool is not able to export the
data for a couple of our questions to csv, though it
can make use of it in its own survey results interface.

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

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

[phpesp-dev] [ phpesp-Bugs-1464014 ] gettext not supported

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

Bugs item #1464014, was opened at 2006-04-03 23:55
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=1464014&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: gettext not supported

Initial Comment:
Hello,

As indicated in docs/TRANSLATION I send you a bugreport
to signal a difficulty to use translations. 

It seems that all is Ok for the gettext configuration
but I only have english version.

Thanks to respond to ve...@ya...

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

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

[phpesp-dev] [ phpesp-Feature Requests-1445933 ] add 'line break" tag to break long questions/text

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

Feature Requests item #1445933, was opened at 2006-03-08 22:15
Message generated for change (Comment added) made by lexus78
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=1445933&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: gui
Group: None
Status: Open
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: add 'line break" tag to break long questions/text

Initial Comment:
be nice to have a "\n" feature (or newline feature) 
so that if you have a long introductory text or 
section header you can have a line break or two. 

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

Comment By: Lexus (lexus78)
Date: 2006-03-30 17:02

Message:
Logged In: YES 
user_id=1253202

From my experience you can easily enter HTML code in the
question texts.

Therefore it what you are looking for can be achieved by
writing <br />

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

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

[phpesp-dev] [ phpesp-Bugs-1459344 ] sql populate

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

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

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: v1.8
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: sql populate

Initial Comment:
#1064 - You have an error in your SQL syntax 
near 'CURRENT_TIMESTAMP,
    PRIMARY KEY(name)
)' at line 27 

Recurring errors when trying to poluate the db with 
mysql_populate.sql.

Fix one, another one pops up - most to do with 
timestamp.

Using phpMyAdmin 2.6.1 

I think this is perhaps more related to phpMyAdmin 
(apologies) than phpESP, but couldn't find anything 
on this problem elsewhere.

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-29 12:00

Message:
Logged In: YES 
user_id=14116

Fixed in CVS.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-29 09:11

Message:
Logged In: NO 

1.8.1 

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-28 20:51

Message:
Logged In: YES 
user_id=14116

What versin of phpESP are you using?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-28 09:41

Message:
Logged In: NO 

I'm installing it locally before uploading (not installing)
to server (which will be 5 - is phpESP 5-friendly? :)

PHP Information 
Version: 4.2.2 
OS: WINNT 
SAPI: apache2filter 
register_globals: No 
magic_quotes_gpc: Yes 
magic_quotes_runtime: No 
safe_mode: No 
open_basedir: 
 
PHP Extensions 
dBase: No 
GD: No 
GNU Gettext: No 
LDAP: No 
MySQL: Yes 
PHP Extension Dir (compiled): c:\php4 
PHP Extension Dir (run time): C:\FoxServ\php\extensions 
 
phpESP Settings 
Expected ESP_BASE: C:\FoxServ\www\adcritic\phpESP/ 
Expected base_url: localhost/adcritic/phpESP/ 
Loading phpESP.ini.php ...

Knew it was related to CURRENT_TIMESTAMP, but did not try 
removing the single quotes.  


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

Comment By: Sven Meyer (svenmeyer)
Date: 2006-03-28 07:50

Message:
Logged In: YES 
user_id=945200

I had the same problem using phpMyAdmin to populate a MySQL
5 database.
I succeded after removing the single quotes before and after
all occurences of CURRENT_TIMESTAMP.

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-27 10:44

Message:
Logged In: YES 
user_id=14116

Version of php and mysql?  Please post the output of test.php

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

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

[phpesp-dev] [ phpesp-Bugs-1459344 ] sql populate

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

Bugs item #1459344, was opened at 2006-03-27 06:51
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1459344&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: sql populate

Initial Comment:
#1064 - You have an error in your SQL syntax 
near 'CURRENT_TIMESTAMP,
    PRIMARY KEY(name)
)' at line 27 

Recurring errors when trying to poluate the db with 
mysql_populate.sql.

Fix one, another one pops up - most to do with 
timestamp.

Using phpMyAdmin 2.6.1 

I think this is perhaps more related to phpMyAdmin 
(apologies) than phpESP, but couldn't find anything 
on this problem elsewhere.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-29 06:11

Message:
Logged In: NO 

1.8.1 

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-28 17:51

Message:
Logged In: YES 
user_id=14116

What versin of phpESP are you using?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-28 06:41

Message:
Logged In: NO 

I'm installing it locally before uploading (not installing)
to server (which will be 5 - is phpESP 5-friendly? :)

PHP Information 
Version: 4.2.2 
OS: WINNT 
SAPI: apache2filter 
register_globals: No 
magic_quotes_gpc: Yes 
magic_quotes_runtime: No 
safe_mode: No 
open_basedir: 
 
PHP Extensions 
dBase: No 
GD: No 
GNU Gettext: No 
LDAP: No 
MySQL: Yes 
PHP Extension Dir (compiled): c:\php4 
PHP Extension Dir (run time): C:\FoxServ\php\extensions 
 
phpESP Settings 
Expected ESP_BASE: C:\FoxServ\www\adcritic\phpESP/ 
Expected base_url: localhost/adcritic/phpESP/ 
Loading phpESP.ini.php ...

Knew it was related to CURRENT_TIMESTAMP, but did not try 
removing the single quotes.  


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

Comment By: Sven Meyer (svenmeyer)
Date: 2006-03-28 04:50

Message:
Logged In: YES 
user_id=945200

I had the same problem using phpMyAdmin to populate a MySQL
5 database.
I succeded after removing the single quotes before and after
all occurences of CURRENT_TIMESTAMP.

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-27 07:44

Message:
Logged In: YES 
user_id=14116

Version of php and mysql?  Please post the output of test.php

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

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

[phpesp-dev] [ phpesp-Patches-1460571 ] Show Response Number in Thank You

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

Patches item #1460571, was opened at 2006-03-29 12:02
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=1460571&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Lexus (lexus78)
Assigned to: Nobody/Anonymous (nobody)
Summary: Show Response Number in Thank You

Initial Comment:
In one of our surveys respondents are allowed to come
back and see how their response is evaluated in context
to the other results. For this we show the response id
in the text of the thank you body.

In the thank_body text the string %rid% is replaced by
the response number.

This is achieved with the following modifications:


*) FILE: admin/include/funcs.inc

change
    function goto_thankyou($sid,$referer) {
to
    function goto_thankyou($sid,$referer,$rid) {

add 
    $thank_body = preg_replace("/%rid%/", $rid,
$thank_body);
right after
        if(empty($thank_body) && empty($thank_head)) {
            $thank_body =
$GLOBALS['ESPCONFIG']['thank_body'];
            $thank_head =
$GLOBALS['ESPCONFIG']['thank_head'];
        }


*) FILE: public/handler.php

change			goto_thankyou($sid,$HTTP_POST_VARS['referer']);
to
goto_thankyou($sid,$HTTP_POST_VARS['referer'],
$HTTP_POST_VARS['rid']);


PS: my code is based on phpESP 1.7.5
PPS: sorry for not providing a proper patch file

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

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

[phpesp-dev] [ phpesp-Feature Requests-1363389 ] Could teh thank-you text appear under the banner head

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

Feature Requests item #1363389, was opened at 2005-11-22 05:10
Message generated for change (Comment added) made by lexus78
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=1363389&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: survey format
Group: None
Status: Open
Priority: 5
Submitted By: James Crook (merlot02)
Assigned to: Nobody/Anonymous (nobody)
Summary: Could teh thank-you text appear under the banner head

Initial Comment:
When a survey is completed could the thank-you page
appear under the same banner and survey title that the
rest of the survey appears under? (If you're not
redirecting to a static thank-you page.)

I reckon it would look better, that's all.

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

Comment By: Lexus (lexus78)
Date: 2006-03-29 11:36

Message:
Logged In: YES 
user_id=1253202

I did a small patch which shows the banner from the CSS file
(.headerGraphic) also in the Thank You page.

I added <table class="headerGraphic"><tr><td
class="image"></td></tr></table>

FILE: admin/include/funcs.inc

FUNCTION: goto_thankyou($sid,$referer) 

BEFORE: <h2 class="thankhead"><?php echo($thank_head); ?></h2>

PS: I'm still using phpESP 1.7.5




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

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

[phpesp-dev] [ phpesp-Bugs-1459344 ] sql populate

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

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

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: v1.8
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: sql populate

Initial Comment:
#1064 - You have an error in your SQL syntax 
near 'CURRENT_TIMESTAMP,
    PRIMARY KEY(name)
)' at line 27 

Recurring errors when trying to poluate the db with 
mysql_populate.sql.

Fix one, another one pops up - most to do with 
timestamp.

Using phpMyAdmin 2.6.1 

I think this is perhaps more related to phpMyAdmin 
(apologies) than phpESP, but couldn't find anything 
on this problem elsewhere.

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

>Comment By: Matthew Gregg (greggmc)
Date: 2006-03-28 20:51

Message:
Logged In: YES 
user_id=14116

What versin of phpESP are you using?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-28 09:41

Message:
Logged In: NO 

I'm installing it locally before uploading (not installing)
to server (which will be 5 - is phpESP 5-friendly? :)

PHP Information 
Version: 4.2.2 
OS: WINNT 
SAPI: apache2filter 
register_globals: No 
magic_quotes_gpc: Yes 
magic_quotes_runtime: No 
safe_mode: No 
open_basedir: 
 
PHP Extensions 
dBase: No 
GD: No 
GNU Gettext: No 
LDAP: No 
MySQL: Yes 
PHP Extension Dir (compiled): c:\php4 
PHP Extension Dir (run time): C:\FoxServ\php\extensions 
 
phpESP Settings 
Expected ESP_BASE: C:\FoxServ\www\adcritic\phpESP/ 
Expected base_url: localhost/adcritic/phpESP/ 
Loading phpESP.ini.php ...

Knew it was related to CURRENT_TIMESTAMP, but did not try 
removing the single quotes.  


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

Comment By: Sven Meyer (svenmeyer)
Date: 2006-03-28 07:50

Message:
Logged In: YES 
user_id=945200

I had the same problem using phpMyAdmin to populate a MySQL
5 database.
I succeded after removing the single quotes before and after
all occurences of CURRENT_TIMESTAMP.

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

Comment By: Matthew Gregg (greggmc)
Date: 2006-03-27 10:44

Message:
Logged In: YES 
user_id=14116

Version of php and mysql?  Please post the output of test.php

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

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