phpesp-general — General discussion, questions, and annoucements about phpESP

Re: [phpesp-general] solved mine too :)

[Matthew G. <mat...@gm...>]

The #phpesp on freenode is the official channel if anyone is hanging around=
.

On 4/12/06, sean <sea...@gm...> wrote:
>
> doh! hadn't installed php I sheepishly admit - solved the other
> problem by using the CVS mysql_populate file.
>
> btw, is there a working irc channel?
>
> On 12/04/06, Joe Auty <jo...@ne...> wrote:
> > MySQL 4.1 and higher (I believe) creates different password hashes. I
> > basically had to do this table insert from within the version of
> > MySQL 3.x I'm using to create the row with a password hash that could
> > be understood:
> >
> > INSERT INTO designer (username, password, fname, lname, realm,
> > pdesign, pstatus, pdata, pall, pgroup, puser, disabled)
> >         VALUES ('root', PASSWORD('esp'), 'ESP', 'Superuser',
> 'superuser',
> > 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N');
> >
> >
> > Time will tell whether my changes to mysql_populate.sql will work
> > within 3.x. It might be wise to create a separate
> > mysql_populate_3.x.sql script and include that with the distribution.
> >
> >
> >
> >
> >
> >
> >
> >
> > -----------
> > Joe Auty
> > NetMusician: web publishing software for musicians
> > http://www.netmusician.org
> > jo...@ne...
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding
> territory!
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> > _______________________________________________
> > phpESP-general mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-general
> >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!

[phpesp-general] Management console authentication

[sean <sea...@gm...>]

I've had to disable management console authentication because no
user/pass combo worked, where are these set?

apologies for all the the dumb newb q's

[phpesp-general] solved mine too :)

[sean <sea...@gm...>]

doh! hadn't installed php I sheepishly admit - solved the other
problem by using the CVS mysql_populate file.

btw, is there a working irc channel?

On 12/04/06, Joe Auty <jo...@ne...> wrote:
> MySQL 4.1 and higher (I believe) creates different password hashes. I
> basically had to do this table insert from within the version of
> MySQL 3.x I'm using to create the row with a password hash that could
> be understood:
>
> INSERT INTO designer (username, password, fname, lname, realm,
> pdesign, pstatus, pdata, pall, pgroup, puser, disabled)
>         VALUES ('root', PASSWORD('esp'), 'ESP', 'Superuser', 'superuser',
> 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N');
>
>
> Time will tell whether my changes to mysql_populate.sql will work
> within 3.x. It might be wise to create a separate
> mysql_populate_3.x.sql script and include that with the distribution.
>
>
>
>
>
>
>
>
> -----------
> Joe Auty
> NetMusician: web publishing software for musicians
> http://www.netmusician.org
> jo...@ne...
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>

[phpesp-general] solved my problem

[Joe A. <jo...@ne...>]

MySQL 4.1 and higher (I believe) creates different password hashes. I  
basically had to do this table insert from within the version of  
MySQL 3.x I'm using to create the row with a password hash that could  
be understood:

INSERT INTO designer (username, password, fname, lname, realm,  
pdesign, pstatus, pdata, pall, pgroup, puser, disabled)
	VALUES ('root', PASSWORD('esp'), 'ESP', 'Superuser', 'superuser',  
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N');


Time will tell whether my changes to mysql_populate.sql will work  
within 3.x. It might be wise to create a separate  
mysql_populate_3.x.sql script and include that with the distribution.








-----------
Joe Auty
NetMusician: web publishing software for musicians
http://www.netmusician.org
jo...@ne...

[phpesp-general] How can I limit the number of times user can take survey?

[Priyanka N. <pri...@gm...>]

How can I limit the number of times user can take survey? The FAQ says I ca=
n
do that from Survey Access page. But I don't see any option " Max Login"
there. I made my survey private and allowed a group to use the survey. The
only options I see are Group, Max Response, Save/Restore,Back/Forward. I am
using phpESP v 1.8.1

Any input is appreciated!

Thanks,
-P

[phpesp-general] FATAL: Mysql extension not loaded. Aborting.

[sean <sea...@gm...>]

http://lists.voscur.org/surveys/admin/manage.php

what have I done wrong during phpesp installation

[phpesp-general] Re: MySQL 3.x?

[<sea...@gm...>]

I'm having the same problem but am running MySQL 4.x wouldn't know what to edit
in the populate.sql file though :(

[phpesp-general] MySQL 3.x?

[Joe A. <jo...@ne...>]

Hello,

The schema in the mysql_populate.sql file seems to be incompatible  
with the version of MySQL I'm stuck with. I tried making some changes  
to this to remove the pieces MySQL seems to dislike, and was able to  
get the slightly modified schema to allow for the creation of these  
tables. However, I cannot login - it isn't accepting the default  
username/password (root/esp). I'm assuming that the authentication  
method must be MySQL 4.x + only?

Are there any patches or any way of getting phpESP to work with MySQL  
3.x? Unfortunately, upgrading to a newer version o MySQL is not an  
option =(








-----------
Joe Auty
NetMusician: web publishing software for musicians
http://www.netmusician.org
jo...@ne...

[phpesp-general] phpnuke-port of phpESP

[Urs B. <urs...@we...>]

hello 


any news about the port of the phpESP? - i heard about a port of a dutch guy called Eric. 

He did a port - located at www.Nettrade.nl - are there any further attemts of porting over the phpESP to PHPNuke


thanks for the answer

regards
urs__baer

www.nettrade.nl/
_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192

Re: [phpesp-general] Using PHPESP on a different MySQL port

[Matthew G. <mat...@gm...>]

Hmm, should probably be added as an option in phpESP.ini.  You can try
adding the port to the "host" option in phpESP.ini, or you should be able t=
o
edit phpESP/admin/include/funcs.inc and add a port number to the
"dbconnected" line.

On 4/7/06, Larry Zoumas <lar...@on...> wrote:
>
> How does one use a different MySQL port than default 3306 with phpESP?
>
> I don't see that option in the configuration script.
>
> Changing the port on the server is sadly not an option.
>
> I am sure it is simple, but the answer is not coming to me.
>
> Thank you,
>
> <--------------------------->
> Larry Zoumas, Web Developer
>
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!

[phpesp-general] css/ template page width help

[Tina F. <tin...@tn...>]

Hello,


I was wondering under what section do I change the page with of my 
servey template?  Viewers are having to scroll over to read the 
complete question.

Thank you
Tina 
-- 

[phpesp-general] translation in other language

[MelC <ti...@ho...>]

Hello !

I'm looking for how to make a traduciton of the "submit survey" button =
on the form user are filling.

i've found the "submith survey" in the preview pane, but not the other =
one.

can someone tell me where it is coded in all those files ?

thanks !!

tiah.

Re: [phpesp-general] Using PHPESP on a different MySQL port

[McDonald, J. M. <ja...@Ja...>]

Try editing the phpESP.ini.php file directly... say around line 38. Try
changing 'localhost' to 'localhost:1234' to specify a specific port.

Might be worth a try?

J

Larry Zoumas wrote:
> How does one use a different MySQL port than default 3306 with phpESP?
> 
> I don't see that option in the configuration script.
> 
> Changing the port on the server is sadly not an option.
> 
> I am sure it is simple, but the answer is not coming to me.

[phpesp-general] Using PHPESP on a different MySQL port

[Larry Z. <lar...@on...>]

How does one use a different MySQL port than default 3306 with phpESP?

I don't see that option in the configuration script.

Changing the port on the server is sadly not an option.

I am sure it is simple, but the answer is not coming to me.

Thank you,

<--------------------------->
Larry Zoumas, Web Developer

Re: [phpesp-general] Formatting a

[Arif E. U. <emr...@ya...>]

I do not want to get e-mails from phpesp-general
group. Please help me...

Best Regards,

--- Adriano Castro <adr...@gm...>
wrote:

> How is it possible to format a survey's layout?
>
N¬HS^µéšŠX¬²š'²ŠÞu¼±<Âڂº.Öëy©"ž®*mŠx%jx.j­…«^ÆקvÆ©¦XœjبžÈ§¶Œm©Ýš†â•éžv&€¶×§vØ^–+ÞÁæÜjËZØèŠ{azšâ™ç^½éh¥ê஋©n·š’)àŠ{h¶¬ì¡Ø§‚׫®+h¯(m¶Ÿÿ±éZ²ëjY‚w­þÇ¥rg–y$‰õ×Oxḝn5ïmjõÛ^¸Ú˜i#àzw«jYšŠX§‚X¬¶˜i#àzw«jYb²Û,¢êÜyú+éÞ¶m¦Ïÿ–+-²Ê.­ÇŸ¢¸ë–+-³ùb²Ø§~é†—¬¦§z¶¥


.         
         ,\,\,/,/,
         \\ - - //
         (--O-O--)
-------oOOo-(_)-oOOo----------
     Arif  Emre  ÜNAL
 Tel:+90 (533) 568 59 65

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[phpesp-general] Formatting a

[Adriano C. <adr...@gm...>]

SG93IGlzIGl0IHBvc3NpYmxlIHRvIGZvcm1hdCBhIHN1cnZleSdzIGxheW91dD8K

[phpesp-general] How to get phpesp to run under a wrapper script

[Patricia B. <web...@pr...>]

Hello:

I have a wrapper script running in the same directory as phpESP.  
Basically, the wrapper script allows images to be uploaded under the  
correct username on the server rather than user "nobody". In order to  
use this wrapper I put the following lines in the .htaccess file:

Action application/x-pair-sphp4 /cgi-sys/php-cgiwrap/username/php4.cgi
AddType application/x-pair-sphp4 .php

These lines override the following directives:

AddType application/x-httpd-php .php

Now, when I go to http://www.mydomain.org/survey, the url changes into:

http://www.mydomain.org/cgi-sys/php-cgiwrap/username/admin/manage.php

It looks like the index.php file in the survey directory is checking  
the PHP script name that it is being called through .htaccess (which  
is returning
the php-cgiwrap script) and using this name as part of the URL that  
it is then directing to, which is somewhat unusual.

Does anyone have any ideas on how to fix this?

Thanks,

Tricia Barden

[phpesp-general] Export Data to CSV fails

[Christer B. <chr...@ho...>]

Hi,

My surveys is functioning well on my local computer. I can export data =
to CSV-files without problems.  I got problems when I try to export (not =
activated) data from my site at a web hotel. I got the message that the =
page is wrong.  Line one; sign 2; Mistake: an object was expected, Code =
0

http//www.spnvsg.net/PHPESP/admin/manage.php?where=3Dexport.

=20

On my local computer there is code after export.

=20

What to do?

      Best regards=20
    =20
      Christer Blomkvist =20
      =20
    =20
       =20
      =20
    =20
       =20
      =20
    =20
       =20
      =20
    =20
            =20
          =20
             =20
            =20
          =20
             =20
            =20
          =20
             =20
            =20
          =20
             =20
            =20
          =20
             =20

      =20

      =20

      =20

      =20
    =20

=20

=20

=20

=20

[phpesp-general] changing the scalar of rating scales

[<da...@op...>]

PHPESP's default for rating scales length is 5.
Has anyone written item models that allow 7 point rating scales
or models that allow users to select the length of rating scales

-- 
David Patrick Ryan, Ph.D.
Consultant in Distance Learning &Knowledge Translation
Dept. of Continuing Education, Faculty of Medicine, U of Toronto
Director of Education, Regional Geriatric Program of Toronto
Director, Openflows Networks Ltd. 
Email: da...@op...
Tel.: 416.535.0705

Re: [phpesp-general] phpESP 1.8.1 Initial Table Population SQL Error

[Matthew G. <mat...@gm...>]

This was recently fixed.  Grab the latest version of the populate file from
Sourceforce CVS.

On 3/29/06, McDonald, Jacob M. <ja...@ja...> wrote:
>
> db created correctly with the included SQL script.
>
> Next I tried to create the tables with the appropriate script, but I kept
> getting SQL errors:
>
> ERROR 1064 at line 24: You have an error in your SQL syntax.  Check the
> manual that corresponds to your MySQL server version for the right syntax
> to use near 'CURRENT_TIMESTAMP,
>         PRIMARY KEY(name)
> )' at line 4
>
> I have narrowed it down to the CURRENT_TIMESTAMP argument in all of the
> tables; for instance:
>
> CREATE TABLE realm (
>         name            CHAR(16) NOT NULL,
>         title           CHAR(64) NOT NULL,
>         changed         TIMESTAMP(14) DEFAULT CURRENT_TIMESTAMP,
>         PRIMARY KEY(name)
> );
>
> I have been reading the MySQL documentation and it seems that if the
> TIMESTAMP record/column is created as NULL it will automagically default
> to the current timestamp. The only other way I have been able to
> circumvent this error is to enclose CURRENT_TIMESTAMP in ' ', such as
> 'CURRENT_TIMESTAMP' but I don't think that will do what is intended.
>
> Does anyone have advice on how to resolve this error in the SQL script?
> Should I just replace DEFAULT CURRENT_TIMESTAMP with NULL?
>
> Jacob
>
>
>


--
D'oh!

[phpesp-general] phpESP 1.8.1 Initial Table Population SQL Error

[McDonald, J. M. <ja...@Ja...>]

db created correctly with the included SQL script.

Next I tried to create the tables with the appropriate script, but I kept
getting SQL errors:

ERROR 1064 at line 24: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'CURRENT_TIMESTAMP,
        PRIMARY KEY(name)
)' at line 4

I have narrowed it down to the CURRENT_TIMESTAMP argument in all of the
tables; for instance:

CREATE TABLE realm (
        name            CHAR(16) NOT NULL,
        title           CHAR(64) NOT NULL,
        changed         TIMESTAMP(14) DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY(name)
);

I have been reading the MySQL documentation and it seems that if the
TIMESTAMP record/column is created as NULL it will automagically default
to the current timestamp. The only other way I have been able to
circumvent this error is to enclose CURRENT_TIMESTAMP in ' ', such as
'CURRENT_TIMESTAMP' but I don't think that will do what is intended.

Does anyone have advice on how to resolve this error in the SQL script?
Should I just replace DEFAULT CURRENT_TIMESTAMP with NULL?

Jacob

[phpesp-general] login failing with mysql5

[Lisa H. <lis...@ya...>]

    We successfully used phpesp for a  couple years now. Upgraded to mysql 
mysql 5.0.19 yesterday...Using phpesp v1.24.2-and authentication is failing. No matter who logs in,  we get the 

      "Incorrect User ID or Password, or your account has been disabled/expired."
   
  Searched the archives of the mailing list, and saw to add this to the espdefault.inc file:
  
   // Formulate the query check whether user is authorized
        $sql = "SELECT * FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE
        username = "._addslashes($username)." AND
        password = ".db_crypt($password)." AND
        disabled = 'N' AND
        (expiration = '0000-00-00 00:00:00' OR expiration >
". sys_time_stamp().")";

  However, tried that, and still same error- saw something about password strings- but wasnt sure where this would go.
  We are using  php v.4.3.2 
   
  Any help appreciated!
   
  Lisa Pons
  University of Cincinnati Libraries

Re: [phpesp-general] Respondent authentication

[peter <pe...@si...>]

On Sun, 26 Mar 2006 19:25:28 -0800, Matthew P. Galvin wrote
[...]
> My big question is  . . . what do I do with this data once I have it 
> written to respondent?
> 
> I'd like to be able to immediately authenticate them against the respondent
> table and pass the user into the private survey.

At a guess, call the authentication module with the login data
and pipe the result back to the user.

///Peter

[phpesp-general] Respondent authentication

[Matthew P. G. <vid...@ho...>]

I'm working on a deployment of phpESP which needs to allow public users
(anyone in the county) to complete a survey only after they have provided
username, password, first name, last name, and email address.

There MUST be an easy way to do this, but I haven't found one.

I don't want to have to upload every possible user in the county (that was
already suggested to me), and then mail or email them all usernames and
password.

Survey is set up and tested, and published private. I have the html form
created, and have successfully created a validation script, which just
basically checks that they submitted real information in the input boxes.

I'm trying to write data from the form directly to the respondent table (any
insights on this greatly appreciated).

My big question is  . . . what do I do with this data once I have it written
to respondent?

I'd like to be able to immediately authenticate them against the respondent
table and pass the user into the private survey.

Any ideas how I accomplish this? PHP session or something? This seems pretty
straight forward and someone must have developed this already.

I'm pretty new to authentication and php in general, so please forgive me if
this is totally basic.
 
Thanks!
Matthew
vid...@ho...

[phpesp-general] phpESP on Windows IIS

[Adriano C. <adr...@gm...>]

Q2FuIHBocEVTUCBydW4gb24gYSBXaW5kb3dzIHN5c3RlbSBydW5uaW5nIElJUy9NeVNRTD8gV2hh
dCBhYm91dCBJSVMvTVNTUUw/CgpSZWdhcmRzLApBRAo=