phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] RFE 645277 - surveys in several languages

[Stefan C. <sch...@ea...>]

Dear you all,

I'd like to know if

- someone is working on it
- if not, has someone estimated the complexity
- if not, can someone help me to estimate it
- and, of course, can I do it (I ***MAY** have some funding to do it)

cheers, Stefan

[phpesp-dev] [ phpesp-Feature Requests-795508 ] Auto-Save Surveys in Survey Designer

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

Feature Requests item #795508, was opened at 2003-08-26 13:16
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=795508&group_id=8956

Category: gui
Group: None
Status: Open
Priority: 5
Submitted By: Michael McIntosh (xavian)
Assigned to: Nobody/Anonymous (nobody)
Summary: Auto-Save Surveys in Survey Designer

Initial Comment:
I suggest that surveys be auto-saved once the user 

goes past the GENERAL section of the survey designer. 

If they want to remove the survey later, it can easily be 

done via the management interface. 



I spent an hour this morning creating a survey and lost 

all my work because my web browser said the form data 

has expired when I accidentaly hit the back button 

instead of the proper link designer link. When I went 

back into the administrative interface to edit my survey, 

it wasn't there.



It seems that unless I goto the FINISH section in the 

Survey Designer it does not save my survey at ALL 

when I'm creating a new one. So, now when I create a 

survey I immediately goto the FINISH section to make 

sure it is saved.



Either the FINISH section should be renamed SAVE or it 

should handle things a bit more gracefully. If a person 

would sit down and do a survey all in one go, it might 

make more sense to call it finish, but I didn't select 

FINISH the first time round because I was still working 

on things. It wasn't "finished", it was a work in progress.



Michael McIntosh

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

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

Re: [phpesp-dev] OT: perl Class::DBI for php?

[Chad B. <ch...@be...>]

Yep I use that already.  Class::DBI is an oop abstraction over the DB 
interface.  It looks at all of the tables and create accessors methods. 
  What's more if you define relationships then it auto gets that stuff 
too.  for example

Survey->has_many(questions, Questions::DBI)
Question->might_have(choices, Choice::DBI)

Just pseudo code but you get the idea.

I've built an interface to phpESP using the Pear_DB package but it's 
very tedious...although workable.

Not everything is finished but it is being used.  My reports utilize 
Smarty so admins can create their own formats. I use Math_Stats to gen 
stats for numerical type questions like rankings, dates, etc...  I also 
create math stats for choice questions and just assume a rank of 1 for 
the first choice, 2 for second...etc.

If you are interested in any of my work I'll be happy to share.

chad.

On Friday, Aug 22, 2003, at 18:01 US/Eastern, James E. Flemer wrote:

> Chad Bearden wrote:
>> I've googled around the web for a pear plugin that duplicates perl's 
>> Class::DBI but can't find anything.  Anyone know of anything?  I'm 
>> interested after reading these articles on perl.com
>> http://www.perl.com/pub/a/2003/07/15/nocode.html
>> chad.
>
> There is PEAR::DB[1] which is intended to be the Pear equivaliant of 
> Perl DBI.  See more Pear packages here[2].
>
> [1] http://pear.php.net/package/DB
> [2] http://pear.php.net/packages.php
>
> -James
>

Re: [phpesp-dev] OT: perl Class::DBI for php?

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

Chad Bearden wrote:
> I've googled around the web for a pear plugin that duplicates perl's 
> Class::DBI but can't find anything.  Anyone know of anything?  I'm 
> interested after reading these articles on perl.com
> 
> http://www.perl.com/pub/a/2003/07/15/nocode.html
> 
> chad.

There is PEAR::DB[1] which is intended to be the Pear equivaliant of 
Perl DBI.  See more Pear packages here[2].

[1] http://pear.php.net/package/DB
[2] http://pear.php.net/packages.php

-James

[phpesp-dev] OT: perl Class::DBI for php?

[Chad B. <ch...@be...>]

I've googled around the web for a pear plugin that duplicates perl's 
Class::DBI but can't find anything.  Anyone know of anything?  I'm 
interested after reading these articles on perl.com

http://www.perl.com/pub/a/2003/07/15/nocode.html

chad.

Re: [phpesp-dev] little help -> off topic

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

hello! thanks for your answer! sorry for answering late :-)
i tried and tried! i think this or a similar querys will not work!
 i always get timeouts and on mysql.com i found a good note for JOIN:
 >>" This assumes that table2.id is declared NOT NULL"<<  -> null is
returned
and the cols are "null" or "UNSIGNED"

same situations if you want to find out which survey of a group(realm) or
generally  has no (0) response and/or want to sort the results as "ASC" to
see them first (i have so many survey that i´m starting to loose the
overview)
i think there is only a chance to get these information when pushing all
values in an array and sorting in it self (but take more power to load the
hole response table :-( (

kind regards
flobee

----- Original Message ----- 
From: "Luis Fagundes" <lfa...@fu...>
To: "flobee" <fl...@gm...>
Sent: Sunday, August 10, 2003 12:49 AM
Subject: Re: [phpesp-dev] little help -> off topic


> Hi!
> try this:
>
> SELECT t1.*, max(t2.submitted) as mysort FROM respondent as t1 LEFT JOIN
> response as t2 ON t1.username = t2.username WHERE t1.realm='$realm'
> GROUP BY t1.username
>
> with LEFT JOIN if a row is not found in t2, null is returned.
>
> []s
> Luis
>
> flobee wrote:
>
> >hello all!
> >i´m working on a little tool to get some extra statistic informations
about
> >the respondents and the usage...
> >i build a page with shows me the TOP lists of surverys, and respondents
> >
> >now i want the find out which respondent has not made or finished a
survey
> >to see it or to delete unused accounts (huge list!) but i really have
> >troubles to find a right and simple mysql query to check this. i already
ask
> >in some mysql-communitys but havn´t got any resonse yet :-(
> >
> >the query to show all respondents with the last survey (but missing users
> >with "no survey"):
> >
> >                  $sql = ("SELECT t1.* , max(t2.submitted) as mysort
> >                           FROM respondent AS t1 , response AS t2
> >                           WHERE t1.realm='$realm' AND t1.username =
> >t2.username
> >                           GROUP BY t1.username
> >                           ORDER BY mysort DSEC
> >                           LIMIT 0, 50
> >                         ");
> >
> >i dont´find an working query to include all respondents even thouse who
have
> >not submitted any survey!
> >mysql.com give an example but on my localhost i only get timeouts so that
i
> >can not find a good result/solution:
> >mysql> SELECT table1.* FROM table1
> >    ->        LEFT JOIN table2 ON table1.id=table2.id
> >    ->        WHERE table2.id IS NULL;
> >This example finds all rows in table1 with an id value that is not
present
> >in table2
> >
> >have you any idea to have a query which handle this!?
> >
> >kind regards
> >flobee
> >
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> >Data Reports, E-commerce, Portals, and Forums are available now.
> >Download today and enter to win an XBOX or Visual Studio .NET.
>
>http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> >_______________________________________________
> >phpESP-devel mailing list
> >php...@li...
> >https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> >
> >
> >
>
>

[phpesp-dev] Using TortoiseCVS to access the cvs for checkout only

[Rodney H. <rh...@co...>]

Has anyone used TortoiseCVS to access the CVS for phpESP?

I already have TortoiseCVS installed and use it for local development but
was hoping I would be able to use it to grab a fresh copy of the latest code
from CVS on SourceForge for phpESP.

Can't seem to get the instruction set working.

Thanks for any help/tips.
Rodney

[phpesp-dev] [ phpesp-Bugs-636539 ] language settings don't work

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

Bugs item #636539, was opened at 2002-11-11 02:35
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=636539&group_id=8956

Category: Admin
Group: v1.6
Status: Closed
Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: James Flemer (jimmerman)
Summary: language settings don't work

Initial Comment:
I set the default language to 'de', I browse phpESP
with language priority 'de', but phpESP is in english.



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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-08-19 04:55

Message:
Logged In: NO 

I'm using version 1.6.1 and am having similar problems to
those below in getting Japanese to work.  Is this problem
resolved only in CVS still (the last entry here was in
March, it would seem)?

Output from admin/test.php:

---
PHP Information

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

PHP Extensions

    * dBase: No
    * GD: Yes
    * GNU Gettext: Yes
    * LDAP: No
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib/php4/20010901
    * PHP Extension Dir (run time): /usr/lib/php4/20010901

phpESP Settings

    * Expected ESP_BASE: /var/www/cb/phpesp/
    * Expected base_url: http://localhost/cb/phpesp/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /var/www/cb/phpesp/
    * base_url: http://localhost/cb/phpesp/
    * Version: 1.6.1
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: en_US
    * current lang: ja_JP
    * 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

PHP Session Test

    * session.save_path: /tmp
    * Counter: 4
---

Thanks,

jrl.

lane (at) iges.or.jp


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

Comment By: James Flemer (jimmerman)
Date: 2003-03-11 17:55

Message:
Logged In: YES 
user_id=39444

Fixed in CVS.

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

Comment By: James Flemer (jimmerman)
Date: 2003-03-06 09:20

Message:
Logged In: YES 
user_id=39444

Try the latest CVS version (entire package, not just the
test script).  I'll do an RC3 this afternoon in case you
don't want to deal with cvs.

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

Comment By: Hakan Kuecuekyilmaz (hakan76)
Date: 2003-03-06 02:17

Message:
Logged In: YES 
user_id=727074

Hi,

moving locale/de to locale/de_DE and setting the browser
language 
to 'de_DE' (not 'de') solved the language problem.

thanks

-hakan

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-03-05 23:08

Message:
Logged In: NO 

Sorry, i have forget, to tell, that you have also to change the 
names of the folders in local to de_DE and so on.

regards 

Boris

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-03-05 23:05

Message:
Logged In: NO 

Hi,

I see, that you were still working on this.
I have had the same problem. I also have
the same output like the other guys.
So I tested a little bit with gettext and
found an interesting thing:
It seams to me, that gettext ignores setting 
like en or de for the different languages.
But if you use settings like de_DE or en_EN 
it works. So does it on my system. I just use it
now with phpESP and its working fine. The output from your 
test.php is still like hakan76´s, but I can change the 
languages.
I hope, that this could help someone else, too.

regards

Boris Hirschmann

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

Comment By: Hakan Kuecuekyilmaz (hakan76)
Date: 2003-03-05 22:52

Message:
Logged In: YES 
user_id=727074

Hi,

here is the output of the updated test.php:

----
PHP Information

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

PHP Extensions

    * dBase: No
    * GD: Yes
    * GNU Gettext: Yes
    * LDAP: No
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib/php4/20020429
    * PHP Extension Dir (run time): /usr/lib/php4/20020429

phpESP Settings

    * Expected ESP_BASE: /var/www/phpESP/
    * Expected base_url:
http://bwpc050.fht-esslingen.de:8080/phpESP/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /var/www/phpESP/admin/../
    * base_url: http://bwpc050.fht-esslingen.de:8080/phpESP/
    * Version: 1.6 RC2
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: de
    * current lang: de
    * GNU Gettext test: %%%% Gettext Test Failed
    * Catalog Open Test: Yes

PHP Session Test

    * session.save_path: /tmp
    * Counter: 2
------

bye

-hakan

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

Comment By: James Flemer (jimmerman)
Date: 2003-03-05 22:40

Message:
Logged In: YES 
user_id=39444

Try the latest test script, and see what it says for
"Catalog Open Test".  (Just replace the old test.php with
the one below.)

http://phpesp.sf.net/cvs/admin/test.php?rev=.

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

Comment By: Hakan Kuecuekyilmaz (hakan76)
Date: 2003-03-05 17:27

Message:
Logged In: YES 
user_id=727074

Here is the output of test.php:

------------
PHP Information

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

PHP Extensions

    * dBase: No
    * GD: Yes
    * GNU Gettext: Yes
    * LDAP: No
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib/php4/20020429
    * PHP Extension Dir (run time): /usr/lib/php4/20020429

phpESP Settings

    * Expected ESP_BASE: /var/www/phpESP/
    * Expected base_url:
http://bwpc050.fht-esslingen.de:8080/phpESP/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /var/www/phpESP/admin/../
    * base_url: http://bwpc050.fht-esslingen.de:8080/phpESP/
    * Version: 1.6 RC2
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: de
    * current lang: de
    * GNU Gettext test: %%%% Gettext Test Failed

PHP Session Test

    * session.save_path: /tmp
    * Counter: 3
-----------------------------

So the gettext test fails, any hints?

regards

-hakan

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

Comment By: James Flemer (jimmerman)
Date: 2003-03-05 15:59

Message:
Logged In: YES 
user_id=39444

Please paste or attach the output of the phpESP system test
page.  (http://...yourserver.../phpESP/admin/test.php)

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

Comment By: Hakan Kuecuekyilmaz (hakan76)
Date: 2003-03-05 14:41

Message:
Logged In: YES 
user_id=727074

Hi,

just installed phpESP-1.6RC2. The language settings still
not work for me. I set the default language to 'de' in the
config file. phpESP is still in english.

-hakan

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-02-22 14:25

Message:
Logged In: NO 

Hi,

here is the output from the script
http://phpesp.sf.net/files/status.php.txt when run on my server:

php version: 4.2.3
cwd: /home/hakan/.public_html/testing_scripts
register_globals: off
magic_quotes_gpc: on
magic_quotes_runtime: off
safe_mode: off
open_basedir:
mysql: loaded
gettext: loaded
browser languages: de, en;q=0.50

regards

-hakan

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

Comment By: James Flemer (jimmerman)
Date: 2003-02-22 13:02

Message:
Logged In: YES 
user_id=39444

Fixed in CVS.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-11-20 03:22

Message:
Logged In: NO 

Hello,

the output of the script seems to be ok. what else could be
the cause of the language problem?
any other hints?

-hakan

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-11-11 13:36

Message:
Logged In: NO 

php version: 4.2.3
cwd: /home/hakan/.public_html/testing_scripts
register_globals: off
magic_quotes_gpc: on
magic_quotes_runtime: off
safe_mode: off
open_basedir:
mysql: loaded
gettext: loaded
browser languages: de

seems all settings should be ok, any other ideas?

-hakan

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

Comment By: James Flemer (jimmerman)
Date: 2002-11-11 10:03

Message:
Logged In: YES 
user_id=39444

Is gettext installed and compiled for PHP? Please tell us
the output of this[1] script when run from your webserver.

[1] http://phpesp.sf.net/files/status.php.txt

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

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

Re: [phpesp-dev] [ phpesp-Bugs-789042 ] CSV Export field name clash 2

[Kon <ang...@ip...>]

Hmmm,

I've never had any probs with csv export and I have over 120 surveys
with thousands of responses.

I don't believe anyone is working on CSV export so please feel free to
contribute.


Kon


On Fri, 2003-08-15 at 22:29, Luis Fagundes wrote:
> SourceForge.net wrote:
> 
> >
> >I personally think the csv export stuff needs to be 
> >written from scratch again. Even when it works its very 
> >slow and hits the datbase way more than is really 
> >required if more complex sql was used.
> >
> >  
> >
> Is anyone working on CSV export? This part of phpESP have been causing 
> me some headaches (problems with quotes,
> speed and bad checkbox handling) and I'd like to work on that.
>  
> []s
> Luis
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel

Re: [phpesp-dev] [ phpesp-Bugs-789042 ] CSV Export field name clash 2

[Luis F. <lfa...@fu...>]

SourceForge.net wrote:

>
>I personally think the csv export stuff needs to be 
>written from scratch again. Even when it works its very 
>slow and hits the datbase way more than is really 
>required if more complex sql was used.
>
>  
>
Is anyone working on CSV export? This part of phpESP have been causing 
me some headaches (problems with quotes,
speed and bad checkbox handling) and I'd like to work on that.
 
[]s
Luis

[phpesp-dev] [ phpesp-Bugs-789042 ] CSV Export field name clash 2

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

Bugs item #789042, was opened at 2003-08-15 12:13
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=789042&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Paul Jackson (beachbum_boy)
Assigned to: Nobody/Anonymous (nobody)
Summary: CSV Export field name clash 2

Initial Comment:
The CSV doesn't deal with questions with the same 
name (as mentioned in another bug report). 

But further to this if there is many fields with the same 
name the time to do the CSV export grows exponentially 
because of the way it handles quotes is majorly broken.

Basically each field gets a pair of quotes on either side 
for the csv export but because it actually keeps using 
the same field it gets more and more. And further to this 
the quotes are replaced via an ereg-replace with 2 
quotes. So this is fine when you have only a couple of 
questions with the same name but someone on our 
system had 60. Now the time to run this becomes 
untenable.

To see an example of this check out the results and 
survey on the demo site called csv_test.

I personally think the csv export stuff needs to be 
written from scratch again. Even when it works its very 
slow and hits the datbase way more than is really 
required if more complex sql was used.

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

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

[phpesp-dev] auth? manage_auth() , secure things

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

hello all

is it possible that there is a little miss-configuration on the
authentification!?
i got some reports from some authors (designer accouns) having problems
staying loggend in.

while checking the loginsystem  (manage_auth()) i see some "if" statments
which will never act: like:
// see if ACL is cached
-> the "password" is never placed in the the session! , as "session array"
but not sticked in the session!
is the password forgotten to stick it in or do passwords have notthing to do
in the session cookie? im not sure about it
i think at least it can be sticked in when having an own server , right!?
else using the $server[PHP_AUTH_PW....!?

another secure request is that there should be a "time limit" on the login
procedure.
my ISP gave me the information that most hack attacts start which the
brutefoce on htaccess files. so with php its more simple!? and if you have
no log mecanism you don´t know what people exactly do when you see alot of
requests on your admin file like - http:// user : password @ sub . server .
tld / phpesp / myfile.php
or does the authentification do only work on webbrowsers?

kind regards flobee

Re: [phpesp-dev] Rank problem when answer not required (revisited)

[Paul B. <pbo...@sc...>]

James,

Thank you for your fast response.

No, unanswered questions are set to 0 because a value *is* required. 
Even when specified a NULL to put there, it becomes 0 because the table 
field properties require it to be NOT NULL. By default this is 0 in 
MySQL. This was originally from a 1.4 installation, but even in the 
1.6.1 archive it is still like that:

-- # answers to rank questions
CREATE TABLE response_rank (
	response_id	INT UNSIGNED NOT NULL,
	question_id	INT UNSIGNED NOT NULL,
	choice_id	INT UNSIGNED NOT NULL,
	rank		INT NOT NULL,
	PRIMARY KEY(response_id,question_id,choice_id)
);


Perhaps it would be nice to have a small additional ENUM field that sets 
wether a value is entered or none to avoid ambuigities (perhaps also for 
future other question types since it may also arise when for example an 
integer 0 would be a valid answer for a question).

Or is there already something like that that I overlooked (and with 
which I could recover the data for a large phd related survey)?

Thanks anyway for your development of phpesp which is still a very good 
package and used by a few collegues.

Regards

Paul

James Flemer wrote:


> 
> Paul,
> 
> Are you certain that unanswered questions are not NULL?  It's been a
> while since I looked at this, but I thought that's what was used for
> unanswered questions.  If it is not the case, I believe it should be.  A
>  NULL value makes more sense to me than a magic number.
> 
> -James

Re: [phpesp-dev] Rank problem when answer not required (revisited)

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

Quoting Paul Borgermans <pbo...@sc...>:

> Dear developers,
> 
> Regarding the possible problems with ranking questions and where
> answers 
> are not required, I have a small suggestion.
> 
> To distinguish between unanswered questions and rank 1 answers which
> 
> both become 0 when stored in the database and corrupt the results, a
> 
> "magic" number could be set as the default value in the database (say
> 
> -99999).
> 
>   => The statistics scripts for previewing the result can easily take
> 
> this into account, as well as statistical packages. It is also
> backwards 
> compatible with respect to existing results.
> 
> Any comments?
> 
> Regards
> 
> Paul

Paul,

Are you certain that unanswered questions are not NULL?  It's been a
while since I looked at this, but I thought that's what was used for
unanswered questions.  If it is not the case, I believe it should be.  A
 NULL value makes more sense to me than a magic number.

-James

[phpesp-dev] Rank problem when answer not required (revisited)

[Paul B. <pbo...@sc...>]

Dear developers,

Regarding the possible problems with ranking questions and where answers 
are not required, I have a small suggestion.

To distinguish between unanswered questions and rank 1 answers which 
both become 0 when stored in the database and corrupt the results, a 
"magic" number could be set as the default value in the database (say 
-99999).

  => The statistics scripts for previewing the result can easily take 
this into account, as well as statistical packages. It is also backwards 
compatible with respect to existing results.

Any comments?

Regards

Paul

Re: [phpesp-dev] help

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

Moni,

Please email the translated messages.po (the Hungarian one) to me.  I
will generate the necessary .mo file.

phpESP selects the language by your browser preferences.  Make sure
Hungarian is listed above any other language in your browser
configuration.  Also, check the phpESP test page output;  the gettext
test must pass for translation to work correctly.

-James

Quoting Monika Berze <mo...@pr...>:

> Hello,
> 
> I have a problem.
> 
> I'm Hungarian. I installed phpESP and I translated the messages.po
> file, but I don't know, what I have to do, that the text in the
> phpESP become Hungarian too. I read the /docs/TRANSLATION file and I
> made a hu_HU folder in the local folder and I copied the english
> message.po and message.mo file in this folder. I read, that I have to
> send a email to the developer list, but I don't know the email
> address... Could you help me! What can I do?
> 
> May my english is not perfect in this message, sorry...
> 
> I wait for your response.
> 
> bye 
> 
> Moni
> 


-James

[phpesp-dev] help

[Monika B. <mo...@pr...>]

Hello,

I have a problem.

I'm Hungarian. I installed phpESP and I translated the messages.po file, =
but I don't know, what I have to do, that the text in the phpESP become =
Hungarian too. I read the /docs/TRANSLATION file and I made a hu_HU =
folder in the local folder and I copied the english message.po and =
message.mo file in this folder. I read, that I have to send a email to =
the developer list, but I don't know the email address... Could you help =
me! What can I do?

May my english is not perfect in this message, sorry...

I wait for your response.

bye=20

Moni

[phpesp-dev] little help -> off topic

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

hello all!
i´m working on a little tool to get some extra statistic informations about
the respondents and the usage...
i build a page with shows me the TOP lists of surverys, and respondents

now i want the find out which respondent has not made or finished a survey
to see it or to delete unused accounts (huge list!) but i really have
troubles to find a right and simple mysql query to check this. i already ask
in some mysql-communitys but havn´t got any resonse yet :-(

the query to show all respondents with the last survey (but missing users
with "no survey"):

                  $sql = ("SELECT t1.* , max(t2.submitted) as mysort
                           FROM respondent AS t1 , response AS t2
                           WHERE t1.realm='$realm' AND t1.username =
t2.username
                           GROUP BY t1.username
                           ORDER BY mysort DSEC
                           LIMIT 0, 50
                         ");

i dont´find an working query to include all respondents even thouse who have
not submitted any survey!
mysql.com give an example but on my localhost i only get timeouts so that i
can not find a good result/solution:
mysql> SELECT table1.* FROM table1
    ->        LEFT JOIN table2 ON table1.id=table2.id
    ->        WHERE table2.id IS NULL;
This example finds all rows in table1 with an id value that is not present
in table2

have you any idea to have a query which handle this!?

kind regards
flobee

[phpesp-dev] [ phpesp-Bugs-783745 ] single quote breaks "add survey"

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

Bugs item #783745, was opened at 2003-08-05 20:32
Message generated for change (Comment added) made by logart
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=783745&group_id=8956

Category: SQL
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Stephen Lawrence (logart)
Assigned to: Nobody/Anonymous (nobody)
Summary: single quote breaks "add survey"

Initial Comment:
If I enter a single quote in either the name, title,
subtitle, etc. I get errors from the single quote being
in the insert statement.


[ Warning, error encountered. [ 1064: 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 'asdfasdf'', email='', theme='',
thanks_page='', thank_head='', ] ]

thanks

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

>Comment By: Stephen Lawrence (logart)
Date: 2003-08-07 14:30

Message:
Logged In: YES 
user_id=14468

I spent some time trying to figure out why the _addslashes
call does not function properly. I just could not quite put
my finger on it. I ended up just changing the _add/_strip to
use the normal add/strip functions and that worked, but I
would like to see it fixed permanently. 

Thanks.

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-07 13:54

Message:
Logged In: YES 
user_id=14116

It is designed to handle magic quotes on or off.   This
looks like a bug with that handling, that we need to fix.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-06 21:19

Message:
Logged In: YES 
user_id=14468

I added a .htaccess file with:

php_flag magic_quotes_gpc On

and it is working, but I thought the program was designed to
work with or without magic quotes?

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 23:15

Message:
Logged In: YES 
user_id=14116

I can't duplicate here.  Can you turn "magic_quotes_gpc" on
and try again?  This might be a bug with magic_quote handling.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-05 23:00

Message:
Logged In: YES 
user_id=14468

1.6.1

PHP Version 4.3.0

all magic's are off:

magic_quotes_gpc	Off	
magic_quotes_runtime	Off	
magic_quotes_sybase	Off

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 22:58

Message:
Logged In: YES 
user_id=14116

What version of ESP are you using?  Are magic quotes turned
on or off in php?

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

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

[phpesp-dev] [ phpesp-Bugs-783745 ] single quote breaks "add survey"

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

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

Category: SQL
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Stephen Lawrence (logart)
Assigned to: Nobody/Anonymous (nobody)
Summary: single quote breaks "add survey"

Initial Comment:
If I enter a single quote in either the name, title,
subtitle, etc. I get errors from the single quote being
in the insert statement.


[ Warning, error encountered. [ 1064: 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 'asdfasdf'', email='', theme='',
thanks_page='', thank_head='', ] ]

thanks

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

>Comment By: Matthew Gregg (greggmc)
Date: 2003-08-07 08:54

Message:
Logged In: YES 
user_id=14116

It is designed to handle magic quotes on or off.   This
looks like a bug with that handling, that we need to fix.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-06 16:19

Message:
Logged In: YES 
user_id=14468

I added a .htaccess file with:

php_flag magic_quotes_gpc On

and it is working, but I thought the program was designed to
work with or without magic quotes?

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 18:15

Message:
Logged In: YES 
user_id=14116

I can't duplicate here.  Can you turn "magic_quotes_gpc" on
and try again?  This might be a bug with magic_quote handling.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-05 18:00

Message:
Logged In: YES 
user_id=14468

1.6.1

PHP Version 4.3.0

all magic's are off:

magic_quotes_gpc	Off	
magic_quotes_runtime	Off	
magic_quotes_sybase	Off

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 17:58

Message:
Logged In: YES 
user_id=14116

What version of ESP are you using?  Are magic quotes turned
on or off in php?

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

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

[phpesp-dev] [ phpesp-Bugs-783745 ] single quote breaks "add survey"

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

Bugs item #783745, was opened at 2003-08-05 20:32
Message generated for change (Comment added) made by logart
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=783745&group_id=8956

Category: SQL
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Stephen Lawrence (logart)
Assigned to: Nobody/Anonymous (nobody)
Summary: single quote breaks "add survey"

Initial Comment:
If I enter a single quote in either the name, title,
subtitle, etc. I get errors from the single quote being
in the insert statement.


[ Warning, error encountered. [ 1064: 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 'asdfasdf'', email='', theme='',
thanks_page='', thank_head='', ] ]

thanks

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

>Comment By: Stephen Lawrence (logart)
Date: 2003-08-06 21:19

Message:
Logged In: YES 
user_id=14468

I added a .htaccess file with:

php_flag magic_quotes_gpc On

and it is working, but I thought the program was designed to
work with or without magic quotes?

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 23:15

Message:
Logged In: YES 
user_id=14116

I can't duplicate here.  Can you turn "magic_quotes_gpc" on
and try again?  This might be a bug with magic_quote handling.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-05 23:00

Message:
Logged In: YES 
user_id=14468

1.6.1

PHP Version 4.3.0

all magic's are off:

magic_quotes_gpc	Off	
magic_quotes_runtime	Off	
magic_quotes_sybase	Off

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 22:58

Message:
Logged In: YES 
user_id=14116

What version of ESP are you using?  Are magic quotes turned
on or off in php?

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

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

Re: [phpesp-dev] Mailing List Archives

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

It seems the SF list archives come and go as they please.  I have no 
intention of ever relying on them, which is why I have the mbox archives 
available as well (linked of main page).  Tho I just noticed the mbox 
one is stale (as of April 27 for the dev list).  I'll have to make sure 
my mbox collector is still subscribed.  Bah!

-James

Matthew Gregg wrote:
> Umm...  What happen to the mail list archives on SF?  They are all
> empty.  Did SF pull another one?
> 
> 

[phpesp-dev] [ phpesp-Bugs-783745 ] single quote breaks "add survey"

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

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

Category: SQL
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Stephen Lawrence (logart)
Assigned to: Nobody/Anonymous (nobody)
Summary: single quote breaks "add survey"

Initial Comment:
If I enter a single quote in either the name, title,
subtitle, etc. I get errors from the single quote being
in the insert statement.


[ Warning, error encountered. [ 1064: 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 'asdfasdf'', email='', theme='',
thanks_page='', thank_head='', ] ]

thanks

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

>Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 18:15

Message:
Logged In: YES 
user_id=14116

I can't duplicate here.  Can you turn "magic_quotes_gpc" on
and try again?  This might be a bug with magic_quote handling.

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

Comment By: Stephen Lawrence (logart)
Date: 2003-08-05 18:00

Message:
Logged In: YES 
user_id=14468

1.6.1

PHP Version 4.3.0

all magic's are off:

magic_quotes_gpc	Off	
magic_quotes_runtime	Off	
magic_quotes_sybase	Off

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 17:58

Message:
Logged In: YES 
user_id=14116

What version of ESP are you using?  Are magic quotes turned
on or off in php?

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

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

[phpesp-dev] Mailing List Archives

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

Umm...  What happen to the mail list archives on SF?  They are all
empty.  Did SF pull another one?


-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] [ phpesp-Bugs-783745 ] single quote breaks "add survey"

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

Bugs item #783745, was opened at 2003-08-05 20:32
Message generated for change (Comment added) made by logart
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=783745&group_id=8956

Category: SQL
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Stephen Lawrence (logart)
Assigned to: Nobody/Anonymous (nobody)
Summary: single quote breaks "add survey"

Initial Comment:
If I enter a single quote in either the name, title,
subtitle, etc. I get errors from the single quote being
in the insert statement.


[ Warning, error encountered. [ 1064: 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 'asdfasdf'', email='', theme='',
thanks_page='', thank_head='', ] ]

thanks

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

>Comment By: Stephen Lawrence (logart)
Date: 2003-08-05 23:00

Message:
Logged In: YES 
user_id=14468

1.6.1

PHP Version 4.3.0

all magic's are off:

magic_quotes_gpc	Off	
magic_quotes_runtime	Off	
magic_quotes_sybase	Off

log

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

Comment By: Matthew Gregg (greggmc)
Date: 2003-08-05 22:58

Message:
Logged In: YES 
user_id=14116

What version of ESP are you using?  Are magic quotes turned
on or off in php?

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

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