phpmyedit-discuss — Discussion of existing and possible future usage/features of PHPMyEdit.

RE: [PHPMyEdit-Discuss] Translations needed

[Onno H. <o.h...@ka...>]

The Dutch version of the language is attached to the bug report.

I reported it as a new bug in the first place. Please ignore that.

-----Oorspronkelijk bericht-----
Van: php...@li...
[mailto:php...@li...] Namens hugues
bernard
Verzonden: woensdag 21 januari 2004 7:17
Aan: php...@li...
Onderwerp: [PHPMyEdit-Discuss] Translations needed


Hi all,

PME need your translation help !

a new feature was commited in the CVS in the past week :
fast moving between list pages. (see :
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnote
s)

This add 2 buttons (first page and last page) and a drop down to jump to
whatever page you want.

Because 3 new keys were put in the language files : ("First", "Last",
"Go to"), we need to have quick translations for all languages PME
currently supports, in order not to block upcomming 5.4 release.

You will find current language file here :
http://platon.sk/cvs/cvs.php/phpMyEdit/lang/

And you may upload the translated file in this bug report :
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnote
s

Please note that 'first' and 'last' must be translated according to the
context.

'start''s translation can be in some lang a better translation than the
one for 'first', for exemple.

Regards

Hugues



-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration See the
breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
Phpmyedit-discuss mailing list Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss

Re: [PHPMyEdit-Discuss] Translations needed

[Roberto C. - S. S. <rob...@fi...>]

Oh, yes, my friends.

Portuguese-Brazil updated too.

;o)

Regards.

Cohen

----- Original Message ----- 
From: <hbe...@gy...>
To: "Laurent Girard" <lau...@li...>
Cc: <php...@li...>
Sent: Wednesday, January 21, 2004 6:56 AM
Subject: Re: [PHPMyEdit-Discuss] Translations needed


> Well, French translation is already commited (I'm french ;-)
>
> You're translations are the one that where commited.
>
> Hugues
>
> Selon Laurent Girard <lau...@li...>:
>
> > The problem is that it depends of the context and I'm not sure I have
the
> > context. Have you got a sample of the page ?
> >
> > In French :
> >
> > First : Début
> > Last : Fin
> > Go to : Aller à [It can be many things in fact]
> > ----- Original Message -----
> > From: "hugues bernard" <hbe...@gy...>
> > To: <php...@li...>
> > Sent: Wednesday, January 21, 2004 7:17 AM
> > Subject: [PHPMyEdit-Discuss] Translations needed
> >
> >
> > > Hi all,
> > >
> > > PME need your translation help !
> > >
> > > a new feature was commited in the CVS in the past week :
> > > fast moving between list pages. (see :
> > >
> >
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes)
> > >
> > > This add 2 buttons (first page and last page) and a drop down to jump
to
> > > whatever page you want.
> > >
> > > Because 3 new keys were put in the language files : ("First", "Last",
"Go
> > > to"), we need to have quick translations for all languages PME
currently
> > > supports, in order not to block upcomming 5.4 release.
> > >
> > > You will find current language file here :
> > > http://platon.sk/cvs/cvs.php/phpMyEdit/lang/
> > >
> > > And you may upload the translated file in this bug report :
> > >
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes
> > >
> > > Please note that 'first' and 'last' must be translated according to
the
> > > context.
> > >
> > > 'start''s translation can be in some lang a better translation than
the
> > one
> > > for 'first', for exemple.
> > >
> > > Regards
> > >
> > > Hugues
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > The SF.Net email is sponsored by EclipseCon 2004
> > > Premiere Conference on Open Tools Development and Integration
> > > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> > > http://www.eclipsecon.org/osdn
> > > _______________________________________________
> > > Phpmyedit-discuss mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
> >
> >
>
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
>

Re: [PHPMyEdit-Discuss] Translations needed

[<hbe...@gy...>]

Well, French translation is already commited (I'm french ;-)

You're translations are the one that where commited.

Hugues

Selon Laurent Girard <lau...@li...>:

> The problem is that it depends of the context and I'm not sure I have the
> context. Have you got a sample of the page ?
> 
> In French :
> 
> First : Début
> Last : Fin
> Go to : Aller à [It can be many things in fact]
> ----- Original Message -----
> From: "hugues bernard" <hbe...@gy...>
> To: <php...@li...>
> Sent: Wednesday, January 21, 2004 7:17 AM
> Subject: [PHPMyEdit-Discuss] Translations needed
> 
> 
> > Hi all,
> >
> > PME need your translation help !
> >
> > a new feature was commited in the CVS in the past week :
> > fast moving between list pages. (see :
> >
> http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes)
> >
> > This add 2 buttons (first page and last page) and a drop down to jump to
> > whatever page you want.
> >
> > Because 3 new keys were put in the language files : ("First", "Last", "Go
> > to"), we need to have quick translations for all languages PME currently
> > supports, in order not to block upcomming 5.4 release.
> >
> > You will find current language file here :
> > http://platon.sk/cvs/cvs.php/phpMyEdit/lang/
> >
> > And you may upload the translated file in this bug report :
> > http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes
> >
> > Please note that 'first' and 'last' must be translated according to the
> > context.
> >
> > 'start''s translation can be in some lang a better translation than the
> one
> > for 'first', for exemple.
> >
> > Regards
> >
> > Hugues
> >
> >
> >
> > -------------------------------------------------------
> > The SF.Net email is sponsored by EclipseCon 2004
> > Premiere Conference on Open Tools Development and Integration
> > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> > http://www.eclipsecon.org/osdn
> > _______________________________________________
> > Phpmyedit-discuss mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
> 
> 

[PHPMyEdit-Discuss] Translations needed

[hugues b. <hbe...@gy...>]

Hi all,

PME need your translation help !

a new feature was commited in the CVS in the past week :
fast moving between list pages. (see :
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes)

This add 2 buttons (first page and last page) and a drop down to jump to
whatever page you want.

Because 3 new keys were put in the language files : ("First", "Last", "Go
to"), we need to have quick translations for all languages PME currently
supports, in order not to block upcomming 5.4 release.

You will find current language file here :
http://platon.sk/cvs/cvs.php/phpMyEdit/lang/

And you may upload the translated file in this bug report :
http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=33#bugnotes

Please note that 'first' and 'last' must be translated according to the
context.

'start''s translation can be in some lang a better translation than the one
for 'first', for exemple.

Regards

Hugues

[PHPMyEdit-Discuss] =?ISO-2022-JP?B?GyRCTCQ+NUJ6OS05cCIoGyhCICAbJEI6X0JwJVElPSUzGyhC?= =?ISO-2022-JP?B?GyRCJXMlbyE8JS8lOSU/JUMlVUpnPTgkTiQ0MEZGYiRHJDkhIxsoQg==?=

[<aaa...@fr...>]

未承諾広告※  関心の無い方にはお手数ですが削除をお願い申し上げます。
＊送信者：大野和子
＊事業者：AAA-network Co.,Ltd.
　東京都目黒区目黒3-4-16／ＴＥＬ：0120−77−5869
※当方からのメールがご迷惑な方には、お手数ですが『受信拒否』と表示
　して  mai...@3-...   までメールを返信して下さい。
※拒否メール受信後、3日以内にメールアドレスを除去致します。
※複数アドレスを受信拒否希望の方は、お手数ですが対象アドレスを全て
　メッセージ内に表示していただければ除去いたします。
  私どもは、他用・流出は一切いたしません。

★☆★　在宅（SOHO・パソコン)ワークスタッフ募集のご案内です　★☆★

◎余暇を利用して副収入を得られたら
◎どうしても家を空けられない
◎人間関係がうまくいかない
◎地方ということで仕事が思うようにならない
◎将来が不安なので、今のうちに
などとお考えの方

今後ますます日本経済状況は悪化し今となってはもう会社も社員を守って
くれないのが現実です。
今までの就業スタイルでは諦めるしかなかった主婦や高齢者の方々にも、
在宅ワークは大きなチャンスとして注目されています。
☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★

◎１日２〜３時間程度なら時間が取れる方であれば、初級レベルのデータ
入力のお仕事であれば4・5万前後の収入に成ります。それ以外にもお仕事
は有りますが良く聞かれるご質問として、
どのような仕事があるの？＝ＩＴ系以外の在宅で出来る仕事からもできま
す。私共は登録者が安定した副収入を取れるようにということを優先して
おり、その為、請け負う仕事をパソコンでの在宅ワーク以外に、手作業の
在宅ワークや派遣業務に至るまで幅広く取り揃えていき、皆様にバラつき
のないお仕事の情報提供にお応えして参ります。

将来安定に向けてご自身の技能を活用して、副収入を得る機会としてご案
内しております。
全くパソコン未経験の方でもやる気さえあればパソコン業務以外のお仕事
から副収入を得ていただけます。
業務は、誰でも出来る宛名書きから、データ入力・文章入力・HP作成・イ
ラスト・DTP・Flash画面作成等々まで幅広くあり、毎週さまざまなお仕事
情報を配信しております。

現在、20歳〜60歳の主婦・フリーター・会社員の方々が余暇を活用しなが
ら活躍しております。

★詳しくは下記ホームページで資料請求(無料)のうえご確認下さい★
〈資料請求の手順〉
1.　URL『http://www.3-aaa.net』へアクセス
2. 　『トップ』〜『資料請求』
3.　フォームに従って必要事項の入力
4.  このメールをご覧の方はエリアコード 『０１２』 を選択
5.  入力完了後『送信』してください。
 　
※この広告が３日以内に重複した場合は、決して悪意はございませんので
　ご容赦下さい。拒否者のアドレス除去は十分注意して参ります。
※代理店が数社あり、重複いたしましたらご容赦下さい。情報交換が不可
　能な為、ご迷惑をおかけして申し訳ございませんが、受信拒否希望の方
　はお手数ですが、各送信先に受信拒否として自動返信いただくか、着信
　拒否の設定をお願い申し上げます。

[PHPMyEdit-Discuss] Re: my new computer

[<czt...@gm...>]

<html>

<head>
<meta http-equiv=3D"Content-Language" content=3D"it">
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dwindows-=
1252">
<meta name=3D"GENERATOR" content=3D"Microsoft FrontPage 4.0">
<meta name=3D"ProgId" content=3D"FrontPage.Editor.Document">
<title>Nuova pagina 1</title>
</head>

<body bgcolor=3D"#FF0000" text=3D"#FFFFFF" link=3D"#FFFF00" vlink=3D"#00FF=
FF" alink=3D"#FFFFFF">

<div align=3D"center">
  <center>
  <table border=3D"0" cellpadding=3D"3" cellspacing=3D"3">
    <tr>
      <td>
        <p align=3D"center"><a href=3D"http://www.geocities.com/jeffrey943=
73/">
        <img border=3D"0" src=3D"http://www.geocities.com/solange58968/t05=
jpg"></a><br>
        <font face=3D"Arial Black" size=3D"2"><b><a href=3D"http://www.geo=
cities.com/woodwind21734/"><font color=3D"#FFFF00">
FOR YOU ONLY</font></a></b></font></td>
      <td><p><font face=3D"Arial Black" size=3D"2"><b><font color=3D"#FFFF=
FF">Hello
        friends,<br>
        </font></b></font><b><font face=3D"Arial Black" color=3D"#FFFFFF" =
size=3D"2">I
        do it just to satisfate my pleasure, not for money!</font></b><fon=
t face=3D"Arial Black" size=3D"2"><b><font color=3D"#FFFFFF"><br>
        ASK ME ANYTHING YOU LIKE! THERE
IS NO LIMIT!<br>
        <a href=3D"http://www.geocities.com/tentation20094/">
        TRY IF I AM ON LINE<br>
        </a>Meet me on line when you have time!</font></b></font><b><font =
face=3D"Arial Black" color=3D"#FFFFFF" size=3D"2"><br>
        Giusy85</font></b></p>
      </td>
    </tr>
  </table>
  </center>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><b><font face=3D"Arial Black" color=3D"#FFFFFF" size=3D"2">Are you not =
interested?<br>
</font><a href=3D"mailto:dzo...@gm..."><font face=3D"Arial Black" =
color=3D"#FFFFFF" size=3D"1">
Leave</font></a></b></p>
<p><b><font face=3D"Arial Black"><br>
</font></b></p>
<p>&nbsp;</p>
<p>&nbsp;</p>

</body>

</html>ko iavkm ahyz
mmzgq ixocii uczlhn  dku cyw
h  wik

Re: [PHPMyEdit-Discuss] TABs support in phpMyEdit

[Ondrej J. <ne...@po...>]

On Sat, 21 Jun 2003, Ondrej Jombik wrote:

> I believe some phpMyEdit users are already familiar with this feature
> request.
>
> http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=63
>
> With recent CVS version it is possible to use TABs (similar to these
> TABs, which can be found for example in Windows GUI). Just fetch new
> version from CVS and for some fields define:
>
> $opts['fdd']['col_name']['tab'] = 'Tab name goes here';
>
> I will appreciate any feedback concerning to this.

Several users discovered, that this feature does not work with MSIE
(Microsoft Internet Explorer). I will greatly appreciate any help with
fixing this problem on the metioned browser, since my possibilities of
accessing MSIE are very restricted.

Thanks!

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Nech operacia X na mnozine G tvori grupu, potom plati...  rundu!
    '`

[PHPMyEdit-Discuss] TABs support in phpMyEdit

[Ondrej J. <ne...@po...>]

I believe some phpMyEdit users are already familiar with this feature
request.

http://platon.sk/projects/bug_view_advanced_page.php?f_bug_id=63

With recent CVS version it is possible to use TABs (similar to these
TABs, which can be found for example in Windows GUI). Just fetch new
version from CVS and for some fields define:

$opts['fdd']['col_name']['tab'] = 'Tab name goes here';

I will appreciate any feedback concerning to this.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Ako sa do hory vola, tak sa zhori traktor!  (c) 1999 Rattkin/MFF
    '`

[PHPMyEdit-Discuss] Advanced table lookup -- joining three tables

[Ben L. <ben...@in...>]

I have added the ability to join three tables. The code additions are
minimal (ten lines of code right now, though that needs to increase). I've
posted a long message to the phpMyEdit board detailing how I did it:

http://platon.sk/forum/projects/viewtopic.php?t=103

Hopefully some folks will find this useful. Sincere thanks for this
wonderful application.

-- Ben

[PHPMyEdit-Discuss] LETHA Wants you

[Tory M. <p9f...@br...>]

<p>Told ya I would do it!!
<a href=3D"http://sc...@ww.../crammink"></p>
<p><img src=3D"http://st...@ww.../byot/tn4790/sierra.jpg=
?electrician"> </a></p>
<br>
<br>
<br>I got more.. if you are daring :)
<br>
<br>
<br>
<a href=3D"http://mo...@ww.../crammink/r.php">beam me of=
f scotty</a></font></td>


pkeblhxfv cb dxth q d
jxxf  ae 
ekowmkvgbyojfp
ty
 pj

Re: [PHPMyEdit-Discuss] now() date

[jim k. <jim...@ya...>]

the evaluation time of 
    'default'=>date('Y-m-d H:i:s')
is at _add/update_page_generation_ time, not submit time.

If the user requests a record for add or update and then doesn't 
submit the page for 15 minutes or a couple of days, it's going to 
be off by that much.  If you need very accurate information in 
this field, this won't work at all.

suggestions:
1. within existing framework, 
    a. if you want only insert time, then use a pre-insert trigger to set the time field
    b. if you want last updated times, then you could 
        - make the column definition be a timestamp
       or
        - use both pre-insert and pre-update trigger to set the time field
2. extend PME by adding an 'eval' field option.
    'eval'=>Array(
        'eval_time'=>'IU',        // I(nsert) and U(pdate)
        'expr'=>"date('Y-m-d H:i:s')",
        'expr_type'=>'sql'        // sql or php
    ),

where the expr is eval'd (security warning!) by either PHP or MySQL

--jim

--- Ondrej Jombik <ne...@po...> wrote:
> > I am trying to enter the current date and time into a date field.  Not
> > a timestamp field because, I don't want this field to change when the
> > record is updated.
> > The only approach I can think of, is to add a button or pulldown, on
> > the modify record page, when clicked it will add in a time.  When not
> > clicked it leaves the date field unmodified.
> 
> Try this, it works well for me with 5.3 and current CVS as well.
> 
> $ezin_opts['fdd']['datetime'] = array(
> 		'name'=>Platon::htmlspecialchars2('Date & Time'),
> 		'select'=>'T',
> 		'sort'=>true,
> 		'required'=>true,
> 		'mask'=>'%.10s',
> 		'default'=>date('Y-m-d H:i:s')
> 		);
> 
> This is rough paste from my phpMyEzin project files, however point on
> 'default' option above.
> 
> > I am trying to insert the now() command into the [fdd] area of the
> > field, although I haven't had good results, hence this post.
> 
> This will be _probably_ possible in 5.4... Something like:
> 
> $opts['fdd']['col_name']['sql|AC'] = 'NOW()';
> 
> --
>   _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
>  <_  \  Platon SDG - open source software development - http://platon.sk
>    `\|  This message was written with Pine, the fastest IMAP mail client
>     '`
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Re: [PHPMyEdit-Discuss] now() date

[Ondrej J. <ne...@po...>]

> I am trying to enter the current date and time into a date field.  Not
> a timestamp field because, I don't want this field to change when the
> record is updated.
> The only approach I can think of, is to add a button or pulldown, on
> the modify record page, when clicked it will add in a time.  When not
> clicked it leaves the date field unmodified.

Try this, it works well for me with 5.3 and current CVS as well.

$ezin_opts['fdd']['datetime'] = array(
		'name'=>Platon::htmlspecialchars2('Date & Time'),
		'select'=>'T',
		'sort'=>true,
		'required'=>true,
		'mask'=>'%.10s',
		'default'=>date('Y-m-d H:i:s')
		);

This is rough paste from my phpMyEzin project files, however point on
'default' option above.

> I am trying to insert the now() command into the [fdd] area of the
> field, although I haven't had good results, hence this post.

This will be _probably_ possible in 5.4... Something like:

$opts['fdd']['col_name']['sql|AC'] = 'NOW()';

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  This message was written with Pine, the fastest IMAP mail client
    '`

[PHPMyEdit-Discuss] now() date

[Jason <ok...@kd...>]

phpymyedit,

    I am trying to enter the current date and time into a date field.  Not a
timestamp field because, I don't want this field to change when the record
is updated.

The only approach I can think of, is to add a button or pulldown, on the
modify record page, when clicked it will add in a time.  When not clicked it
leaves the date field unmodified.

Has this been done before with phpmyedit?

I am trying to insert the now() command into the [fdd] area of the field,
although I haven't had good results, hence this post.

Thanks again for all your support and this excellent program

Jason

RE: [PHPMyEdit-Discuss] question about using triggers

[Ondrej J. <ne...@po...>]

> When you update a record, the last_update field gets updated
> automatically.

Yes, but take care: timestamp field will be updated only if data actually
change. If you submit the same data (in other words if you perform no
change), the timestamp field won't be updated.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  This message was written with Pine, the fastest IMAP mail client
    '`

RE: [PHPMyEdit-Discuss] question about using triggers

[Bailey, K. <kev...@me...>]

This is really easy using the built-in feature of MySQL.
Create a field with timestamp type

    last_update  timestamp(8)   Yes  NULL =20

and use this for you definition file.

$opts['fdd']['last_update'] =3D array(
	'name'=3D>'Last update',
	'select'=3D>'T',
	'type'=3D>'timestamp',
	'maxlen'=3D>8,
	'nowrap'=3D>false,
	'required'=3D>true,
	'options'=3D>'RVD',
	'sort'=3D>true
);


When you update a record, the last_update field gets updated =
automatically.


Kevin

Kevin Bailey
Network Engineer - Communications Services
Mentor Graphics   -  www.mentor.com
Wilsonville, OR  USA
e. kev...@me...





-----Original Message-----
From: Ondrej Jombik [mailto:ne...@po...]
Sent: Friday, April 11, 2003 8:49 AM
To: Thomas G=F6tz
Cc: php...@li...
Subject: Re: [PHPMyEdit-Discuss] question about using triggers


> now I want the 'date' field to be automatically updated whenever I =
make a
> change to one of the other entries via phpMyEdit. I guess this can be
> realized with a 'update_after' trigger. Could someone maybe show me =
an
> example of how this .inc file should look like ?

http://www.platon.sk/forum/projects/viewtopic.php?p=3D189#189

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - =
OJ812-RIPE
 <_  \  Platon SDG - open source software development - =
http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends =
are!
    '`



-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The =
debugger=20
for complex code. Debugging C/C++ programs can leave you feeling lost =
and=20
disoriented. TotalView can help you find your way. Available on major =
UNIX=20
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
Phpmyedit-discuss mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss

Re: [PHPMyEdit-Discuss] question about using triggers

[Ondrej J. <ne...@po...>]

> now I want the 'date' field to be automatically updated whenever I make a
> change to one of the other entries via phpMyEdit. I guess this can be
> realized with a 'update_after' trigger. Could someone maybe show me an
> example of how this .inc file should look like ?

http://www.platon.sk/forum/projects/viewtopic.php?p=189#189

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

[PHPMyEdit-Discuss] question about using triggers

[Thomas <tg...@bi...>]

Hi !

I have the following problem:

I have a table that has a 'date' field. Now I want to update this 'date'=20
field to the actual date/time whenever a change is made to an individual=
 entry.

e.g. I have the following fields in my table:

id
name
city
date


now I want the 'date' field to be automatically updated whenever I make a=20
change to one of the other entries via phpMyEdit.
I guess this can be realized with a 'update_after' trigger.

Could someone maybe show me an example of how this .inc file should look=
 like ?


Thomas G=F6tz

Lehrstuhl f=FCr Humangentik
AG Molekulare Ophtalmologie und Onkologie
Am Hubland
97074 W=FCrzburg
Germany
Tel.: +49 931 888-4094
Email: tg...@bi...=20

[PHPMyEdit-Discuss] phpMyEdit 5.3 release available!

[Ondrej J. <ne...@po...>]

Finally, long awaited phpMyEdit 5.3 is here! The most important features it
brings are CSS class names handling and new exhaustive DocBook documentation
(available for download and under Documentation link as well). For phpMyEdit
download check Download section [1] and click on Forum link to enter
phpMyEdit related discussions [2].

[1] http://platon.sk/projects/release_list_page.php?project_id=5
[2] http://platon.sk/forum/projects/?c=5

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Nech operacia X na mnozine G tvori grupu, potom plati...  rundu!
    '`

[PHPMyEdit-Discuss] notebook feature in phpmyedit

[Hugues B. <hbe...@gy...>]

Hi,

I just post a patch at
http://www.platon.sk/projects/bug_view_advanced_page.php?f_bug_id=63

which allow to display fields in several tab (say, a notebook)

It would be nice if some people could give it some testing.

Currently works (according to my test) with :
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030327
IE5 on Win2K.

PLease give me some feedback about this.

Regards

Hugues


-- 
Hugues Bernard <hbe...@gy...>
gynov.org

Re: [PHPMyEdit-Discuss] a trigger case is missing

[Hugues B. <hbe...@gy...>]

hi

On Wed, 2003-04-02 at 22:16, jim kraai wrote:
> you might be missing timing if you don't somehow lock the record from the time 
> the user requests it for editing to the time where the user submits the udpated 
> record
> 
> if not, any changes that come in via some third party while the user is editing 
> the record will be lost

You're right, here is the way I am doing it in the triggers.
(I have a field 'locktime' and and field 'lockIP' which are hidden)

[in my hacky "pre" trigger]
- testing if date("U")-locktime > 600 OR lockIP == host adress
if true :
	-updating lockIP with host address
	-updating locktime' with current date("U")
	-return true ("go on, it's OK")
else return false and go back to the view mode( With error prompt).

[in 'before' update trigger] (prevent bad use of Back Browser Button
- testing if date("U")-locktime > 600 OR lockIP == host adress
if true go on
else return false.

(Same rules should be apply to delete before trigger)

[in 'after' update trigger]
(release the lock)
cleaning lockIP
cleaning locktime.


Thanks for your feedback

Hugues

> 
> 
> --- Hugues Bernard <hbe...@gy...> wrote:
> > Hi,
> > 
> > Playing with triggers, it seems to me that one case is missing.
> > 
> > Let me explain :
> > 
> > Currently, before_update_triggers are called just before sending data to
> > the database.
> > It means that a user may have edited the record before the call.
> > 
> > The user won't be able to _commit_ the changes, but there is no way to
> > forbid record edition with current triggers.
> > 
> > I have tables with lot of fields and want to avoid the user doing his
> > stuff and then be notified (after clicking on the change or apply
> > button) that he can't, and that he'll have to try again later.
> > 
> > So, I added a [trigger][update][pre] = something.inc
> > and hack a bit the display_record function in order to include this file
> > _before_ the Change View.
> > 
> > A simple (but very useful, I think) use-case is to be able to prevent
> > the user to edit a record that is (for example) locked by another (using
> > extra time and IP fields in the table).
> > 
> > Sorry for bad english. I hope you'll understand what I mean.
> > 
> > Do you want a patch and sample use ?
> > Or am I missing something ?
> > 
> > Hugues
> > 
> > 
> > -- 
> > Hugues Bernard <hbe...@gy...>
> > gynov.org
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: ValueWeb: 
> > Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
> > No other company gives more support or power for your dedicated server
> > http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
> > _______________________________________________
> > Phpmyedit-discuss mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ValueWeb: 
> Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
> No other company gives more support or power for your dedicated server
> http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
-- 
Hugues Bernard <hbe...@gy...>
gynov.org

Re: [PHPMyEdit-Discuss] a trigger case is missing

[jim k. <jim...@ya...>]

you might be missing timing if you don't somehow lock the record from the time 
the user requests it for editing to the time where the user submits the udpated 
record

if not, any changes that come in via some third party while the user is editing 
the record will be lost


--- Hugues Bernard <hbe...@gy...> wrote:
> Hi,
> 
> Playing with triggers, it seems to me that one case is missing.
> 
> Let me explain :
> 
> Currently, before_update_triggers are called just before sending data to
> the database.
> It means that a user may have edited the record before the call.
> 
> The user won't be able to _commit_ the changes, but there is no way to
> forbid record edition with current triggers.
> 
> I have tables with lot of fields and want to avoid the user doing his
> stuff and then be notified (after clicking on the change or apply
> button) that he can't, and that he'll have to try again later.
> 
> So, I added a [trigger][update][pre] = something.inc
> and hack a bit the display_record function in order to include this file
> _before_ the Change View.
> 
> A simple (but very useful, I think) use-case is to be able to prevent
> the user to edit a record that is (for example) locked by another (using
> extra time and IP fields in the table).
> 
> Sorry for bad english. I hope you'll understand what I mean.
> 
> Do you want a patch and sample use ?
> Or am I missing something ?
> 
> Hugues
> 
> 
> -- 
> Hugues Bernard <hbe...@gy...>
> gynov.org
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ValueWeb: 
> Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
> No other company gives more support or power for your dedicated server
> http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com

[PHPMyEdit-Discuss] a trigger case is missing

[Hugues B. <hbe...@gy...>]

Hi,

Playing with triggers, it seems to me that one case is missing.

Let me explain :

Currently, before_update_triggers are called just before sending data to
the database.
It means that a user may have edited the record before the call.

The user won't be able to _commit_ the changes, but there is no way to
forbid record edition with current triggers.

I have tables with lot of fields and want to avoid the user doing his
stuff and then be notified (after clicking on the change or apply
button) that he can't, and that he'll have to try again later.

So, I added a [trigger][update][pre] = something.inc
and hack a bit the display_record function in order to include this file
_before_ the Change View.

A simple (but very useful, I think) use-case is to be able to prevent
the user to edit a record that is (for example) locked by another (using
extra time and IP fields in the table).

Sorry for bad english. I hope you'll understand what I mean.

Do you want a patch and sample use ?
Or am I missing something ?

Hugues


-- 
Hugues Bernard <hbe...@gy...>
gynov.org

[PHPMyEdit-Discuss] Re: Phpmyedit-discuss digest, Vol 1 #65 - 1 msg

[Julian R C B. <J.B...@dc...>]

Ondrej,

Thanks.

>It seems that it is not secure. You should think about checks when
>
>$this->savedelete == $this->labels['Delete'] or
>$this->morechange == $this->labels['Apply']  or
>$this->savechange == $this->labels['Save']
>
>The tests you are performing prevents only before record form
>displaying. You have to handle database manipulation actions (save,
>apply, delete) as well.

I want the user to be able to change the password (if they give the
correct old password).

To get to these input forms (Change, Copy or Delete) the user must
enter a password in an input field (that I have added) at the foot
of the Display table.  This must match the corresponding entry in
the password field for that record otherwise we just Display table.

I use a primary key 'Id' which is hidden (on all pages and forms) so
cannot be changed.

Currently I only allow Add/Change/Copy/Delete (not View, to avoid
handling Change from there): $opts['options'] = 'ACD'; not view.


So I think it is secure.  Or am I still missing something?

Thanks.

Julian

php...@li... wrote at 12:31 (GMT -0800) 28 March 2003 :
>Send Phpmyedit-discuss mailing list submissions to
>	php...@li...
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
>or, via email, send a message with subject or body 'help' to
>	php...@li...
>
>You can reach the person managing the list at
>	php...@li...
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Phpmyedit-discuss digest..."
>
>
>Today's Topics:
>
>   1. Re: per record password protection (Ondrej Jombik)
>
>--__--__--
>
>Message: 1
>Date: Wed, 26 Mar 2003 20:16:13 +0100 (CET)
>From: Ondrej Jombik <ne...@po...>
>Reply-To: Ondrej Jombik <ne...@po...>
>To: php...@li...
>Subject: Re: [PHPMyEdit-Discuss] per record password protection
>Organization: Platon software development group (http://www.platon.sk/)
>
>> >You should also note, that blocking user before displaying change or delete
>> >page is not complex solution anymore. You have to block particular action -
>> >record deletion and change in addition to blocking these pages. Otherwise
>> >your application will not be secure (since it will contain this ugly
>> >vulnerability).
>> I did not really follow this.  Do you think my code, above, is
>> insecure?
>
>It seems that it is not secure. You should think about checks when
>
>$this->savedelete == $this->labels['Delete'] or
>$this->morechange == $this->labels['Apply']  or
>$this->savechange == $this->labels['Save']
>
>The tests you are performing prevents only before record form
>displaying. You have to handle database manipulation actions (save,
>apply, delete) as well.
>
>--
>  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
> <_  \  Platon SDG - open source software development - http://platon.sk
>   `\|  UNIX is user friendly. It's selective about who its friends are!
>    '`
>
>
>
>--__--__--
>
>_______________________________________________
>Phpmyedit-discuss mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
>
>
>End of Phpmyedit-discuss Digest

-- 
War on Iraq. Not in my name. www.stopwar.org.uk
Julian Briggs, Director of IT, Department of Computer Science, 
University of Sheffield, Regent Court, 211 Portobello St, Sheffield S1 4DP, UK
Phone +44 (0) 114-222-1851. Fax +44 (0) 114-222-1810
j.b...@sh...  http://www.dcs.shef.ac.uk/~julian

Re: [PHPMyEdit-Discuss] per record password protection

[Ondrej J. <ne...@po...>]

> >You should also note, that blocking user before displaying change or delete
> >page is not complex solution anymore. You have to block particular action -
> >record deletion and change in addition to blocking these pages. Otherwise
> >your application will not be secure (since it will contain this ugly
> >vulnerability).
> I did not really follow this.  Do you think my code, above, is
> insecure?

It seems that it is not secure. You should think about checks when

$this->savedelete == $this->labels['Delete'] or
$this->morechange == $this->labels['Apply']  or
$this->savechange == $this->labels['Save']

The tests you are performing prevents only before record form
displaying. You have to handle database manipulation actions (save,
apply, delete) as well.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

Re: [PHPMyEdit-Discuss] per record password protection

[Julian R C B. <J.B...@dc...>]

Ondrej,

Thanks for your reply:

I have a demo workaround by editing phpMyEdit.class.php thus:

add next line after "if ($this->delete_enabled()) {" (line 1410)

echo ' Password: <input type="text" name="inputpassword" size=12 maxlength=12 value="changeme" >';

add next line after "/* Database connection */" (line 2778)

		/* Require password for change/delete (JRCB 20-mar-03) */
		if($this->operation == $this->labels['Change'] or	
		   $this->operation == $this->labels['Delete']){	
			$inputpassword = $this->pv['inputpassword'];
			$query = "select password from ".$this->tb." where id = ".$this->pv['rec'];
			$resource = $this->myquery($query);
			$row = mysql_fetch_row($resource);
			$password = $row[0];

			//echo "inputpassword: $inputpassword<br>";
			//echo "password: $password<br>";

			if($inputpassword != $password){
				echo "<h1>Enter a password and retry</h1>";
				$this->list_table();
				return false;
			} 
		} 

>You should also note, that blocking user before displaying change or delete
>page is not complex solution anymore. You have to block particular action -
>record deletion and change in addition to blocking these pages. Otherwise
>your application will not be secure (since it will contain this ugly
>vulnerability).

I did not really follow this.  Do you think my code, above, is
insecure?

Thanks

Julian

Ondrej Jombik wrote at 19:45 (GMT +0100) 20 March 2003 :
>> I manage the website for a small club.  I want to create an events
>> listing which members can update themselves, so they can
>> add/change/delete an event record.  They would set a password (for
>> that event) when adding an event and give the same password to
>> change or delete the event.
>> So far, I have added a line to add a password entry field to
>> phpMyEdit.class.php after the code to add the delete button to the
>> foot of the listing:
>
>I completelly understand what is the problem/requirement. You are right, it
>is currently not possible to do such thing with phpMyEdit and it is
>uncertain for future.
>
>The solution could be to have phpMyEdit extension for this. Extension will
>provide the same functionality as phpMyEdit, but it will also add particular
>password check where it is neccessary. The problem is, that currently I do
>not have enough time to work on this. I'm glad that I have at least time to
>work on 5.3 release.
>
>You should also note, that blocking user before displaying change or delete
>page is not complex solution anymore. You have to block particular action -
>record deletion and change in addition to blocking these pages. Otherwise
>your application will not be secure (since it will contain this ugly
>vulnerability).
>
>--
>  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
> <_  \  Platon SDG - open source software development - http://platon.sk
>   `\|  UNIX is user friendly. It's selective about who its friends are!
>    '`
>

-- 
War on Iraq. Not in my name. www.stopwar.org.uk
Julian Briggs, Director of IT, Department of Computer Science, 
University of Sheffield, Regent Court, 211 Portobello St, Sheffield S1 4DP, UK
Phone +44 (0) 114-222-1851. Fax +44 (0) 114-222-1810
j.b...@sh...  http://www.dcs.shef.ac.uk/~julian