On Fri, Apr 19, 2013 at 12:55 PM, <phpmyadmin-devel-request@lists.sourceforge.net> wrote:
Send Phpmyadmin-devel mailing list submissions to
        phpmyadmin-devel@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
or, via email, send a message with subject or body 'help' to
        phpmyadmin-devel-request@lists.sourceforge.net

You can reach the person managing the list at
        phpmyadmin-devel-owner@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Phpmyadmin-devel digest..."


Today's Topics:

   1. Re: Get some details about Refactoring: Designer/schema
      integration project idea (Michal ?iha?)
   2. CSV using LOAD DATA - format specific options (Kasun Chathuranga)
   3. Re: CSV using LOAD DATA - format specific options (Marc Delisle)
   4. Re: CSV using LOAD DATA - format specific options
      (Kasun Chathuranga)
   5. Re: CSV using LOAD DATA - format specific options
      (Kasun Chathuranga)
   6. Re: GSoC Project - AJAX Error Reporting (Abhishek Kandoi)


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

Message: 1
Date: Thu, 18 Apr 2013 10:44:57 +0200
From: Michal ?iha? <michal@cihar.com>
Subject: Re: [Phpmyadmin-devel] Get some details about Refactoring:
        Designer/schema integration project idea
To: Shamika Dharmasiri <shamikadineshdha@gmail.com>,
        phpmyadmin-devel@lists.sourceforge.net
Message-ID: <20130418104457.6c806770@nutt.cihar.com>
Content-Type: text/plain; charset="iso-8859-2"

Hi

Dne Thu, 18 Apr 2013 13:43:40 +0530
Shamika Dharmasiri <shamikadineshdha@gmail.com> napsal(a):

> Hi Michal,
> The demo server is with (Version information: 4.1-dev, latest stable
> version: 3.5.8)
> But my local PMA is with (Version information: 4.0.0-dev, latest stable
> version: 3.5.8)
> I have used this designer feature with previouse PMA versions.
> I don't find this  designer feature in my local copy.What may be the
> problem?

You need to enable configuration storage, see:

http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage

--
        Michal ?iha? | http://cihar.com | http://phpmyadmin.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available

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

Message: 2
Date: Thu, 18 Apr 2013 22:01:59 +0530
From: Kasun Chathuranga <chathuranga.jayaneththi@gmail.com>
Subject: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
        options
To: phpmyadmin-devel@lists.sourceforge.net
Message-ID:
        <CA+AgCPC-mQfrtgY9k-TL56Stmi7V5qYJe17sYKhsn7R-NNi_fQ@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

As indicated in the tracker I am working on fixing the bug #3879 [1] and
have submitted a pull request [2]

I noticed that in the latest version the interface does not allow changing
format specific options such as 'Columns separated with', 'Columns enclosed
with' etc in the import tab. However in the earlier versions these values
could be specified using the interface.

Is this change intentional or is it a regression?

--
Regards
Kasun Chathuranga

[1] https://sourceforge.net/p/phpmyadmin/bugs/3879/
[2] https://github.com/phpmyadmin/phpmyadmin/pull/267
-------------- next part --------------
An HTML attachment was scrubbed...

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

Message: 3
Date: Thu, 18 Apr 2013 12:39:51 -0400
From: Marc Delisle <marc@infomarc.info>
Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
        options
To: phpmyadmin-devel@lists.sourceforge.net
Message-ID: <517021D7.7070706@infomarc.info>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Kasun Chathuranga a ?crit :
> Hi all,
>
> As indicated in the tracker I am working on fixing the bug #3879 [1] and
> have submitted a pull request [2]
>
> I noticed that in the latest version the interface does not allow changing
> format specific options such as 'Columns separated with', 'Columns enclosed
> with' etc in the import tab. However in the earlier versions these values
> could be specified using the interface.
>
> Is this change intentional or is it a regression?

A regression: see [3].

[3] https://sourceforge.net/p/phpmyadmin/bugs/3883/


--
Marc Delisle
http://infomarc.info



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

Message: 4
Date: Thu, 18 Apr 2013 22:21:27 +0530
From: Kasun Chathuranga <chathuranga.jayaneththi@gmail.com>
Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
        options
To: phpmyadmin-devel@lists.sourceforge.net
Message-ID:
        <CA+AgCPAsAVQu+-k=uv8rVJjkguGyf90RFL84nHwtvhTyOyGn7Q@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

On Thu, Apr 18, 2013 at 10:09 PM, Marc Delisle <marc@infomarc.info> wrote:

> Kasun Chathuranga a ?crit :
> > Hi all,
> >
> > As indicated in the tracker I am working on fixing the bug #3879 [1] and
> > have submitted a pull request [2]
> >
> > I noticed that in the latest version the interface does not allow
> changing
> > format specific options such as 'Columns separated with', 'Columns
> enclosed
> > with' etc in the import tab. However in the earlier versions these values
> > could be specified using the interface.
> >
> > Is this change intentional or is it a regression?
>
> A regression: see [3].
>
> [3] https://sourceforge.net/p/phpmyadmin/bugs/3883/
>
>
> Thanks for the clarification. I will work on a fix.

--
Regards
Kasun Chathuranga
-------------- next part --------------
An HTML attachment was scrubbed...

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

Message: 5
Date: Thu, 18 Apr 2013 22:54:04 +0530
From: Kasun Chathuranga <chathuranga.jayaneththi@gmail.com>
Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
        options
To: phpmyadmin-devel@lists.sourceforge.net
Message-ID:
        <CA+AgCPC_67kkwP4kxHME2VPb=p=1uWCVduAY08rypDHerSAOYg@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

On Thu, Apr 18, 2013 at 10:21 PM, Kasun Chathuranga <
chathuranga.jayaneththi@gmail.com> wrote:

>
>
>
>
> On Thu, Apr 18, 2013 at 10:09 PM, Marc Delisle <marc@infomarc.info> wrote:
>
>> Kasun Chathuranga a ?crit :
>> > Hi all,
>> >
>> > As indicated in the tracker I am working on fixing the bug #3879 [1] and
>> > have submitted a pull request [2]
>> >
>> > I noticed that in the latest version the interface does not allow
>> changing
>> > format specific options such as 'Columns separated with', 'Columns
>> enclosed
>> > with' etc in the import tab. However in the earlier versions these
>> values
>> > could be specified using the interface.
>> >
>> > Is this change intentional or is it a regression?
>>
>> A regression: see [3].
>>
>> [3] https://sourceforge.net/p/phpmyadmin/bugs/3883/
>>
>>
>> Thanks for the clarification. I will work on a fix.
>
> Hi,

I have fixed the regression and updated my pull request [2].

Most of the format specific options are common to both CSV and CSV with
LOAD DATA. Hence, I have pulled the common code for generating these common
options to an abstract super class to avoid code duplication.

It would be great if you could review it.

--
Regards
Kasun Chathuranga

[2] https://github.com/phpmyadmin/phpmyadmin/pull/267
-------------- next part --------------
An HTML attachment was scrubbed...

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

Message: 6
Date: Fri, 19 Apr 2013 12:55:09 +0530
From: Abhishek Kandoi <abhikandoi2000@gmail.com>
Subject: Re: [Phpmyadmin-devel] GSoC Project - AJAX Error Reporting
To: phpmyadmin-devel@lists.sourceforge.net
Message-ID:
        <CABtPNt37CVwVdUs73K4=rpqO6=KuOdLvDsUSiTXhJhoVu05h0A@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

I was wondering if you can tell me about some of the shortcomings that you
found in my webapp.
I can teach me a lesson and I can learn something new from it and improve
in my future projects.


On Wed, Apr 17, 2013 at 3:07 AM, Abhishek Kandoi
<abhikandoi2000@gmail.com>wrote:

> On 4/16/13, Rouslan Placella <rouslan@placella.com> wrote:
> > On 04/15/2013 07:16 PM, Abhishek Kandoi wrote:
> >> Hi Rouslan,
> >>
> >> Thanks for replying. I was unable to reply properly using my SourceForge
> >> account.
> >   I have worked with a few mailing lists like Google Groups, but this
> > one seemed different to me.
> >   I didn't even get emails when you people replied on this thread
> > because I had my Digest Mode On,
> >   thus I didn't have an option to Reply to All.
> >>
> >> I will be formatting manually for this time only, as I have no email to
> >> reply to.
> >   (Didn't wanna spoil the reply format)
> >>
> >> Rouslan Placella wrote:
> >>
> >>> Hi Abhishek,
> >>>
> >>> have you got a live demo of this application that I could try?
> >>
> >> Yes, you can try it online at http://faceinbook.co.nr/flowork/home.html
> .
> >
> > Out of curiosity, was the app a college project?
> >
>
> No. I made it as an assignment given to me at SDSLabs(a group of like
> minded students developing open source) after a Lecture on basic PHP.
> I had to attend it although I knew everything that was taught. I have
> been using PHP for the past few years and I really enjoy it.
>
> > Also, I would like to hear from you about what you think are the
> > shortcomings of your implementation. Would you do anything differently
> > if you had to do it again from scratch?
> >
>
> According to me there are a few shortcomings in my implementation.
> If I had to develop it again from scratch, I would like to work on the
> following features:
>
> 1) Security implementation(escaping html) to prevent XSS attacks.
> 2) Adding Modularity to the code both on client-side and on server-side.
> 3) Limiting the number of unsuccessful  login attempts to prevent easy
> brute-force based account cracking.
> 4) Use of Enter button for Login In and Sign Up forms to enhance user
> experience(the current one lacks this UX feature).
> 5) Basic animations on deletion of a to-do.
> 6) Drag and drop functionality for deleting a to-do.
> 7) Responsive Design for the to-do list (the current one has too small
> images on a smartphone).
> 8) Using bcrypt instead of sha1 for password encryption.
> 9) Ability to nest to-do descriptions and summaries.
>
> I have these ideas in my mind for now. Will let you know more, if you
> are interested.
>
> >>> From your email, I'm getting the feeling that you didn't fully
> >>> understand where the different components of the system will reside...
> >>
> >> Yeah, I got it a bit wrong on the first go. But on reading the idea
> again
> >> I understood
> >   what exactly it is about.
> >>
> >>
> >>> The server-side component of this system will not be for the users of
> >>> phpMyAdmin or administrators of individual phpMyAdmin installations, it
> >>> will, instead, be used by the members of the phpMyAdmin development
> >>> team[0] to globally diagnose issues.
> >>
> >> I thought a client-side component for handling errors as well as one for
> > diagnosing issues was suggested. But actually the suggestion was for a
> > client-side
> > component for sending errors to a server-side component with the data
> > containing
> > nothing that concerns the user about his/her privacy. Thus there is no
> > need of encryption
> > as you said, because the data contains no sensitive information.
> >>
> >>
> >> And also as you wrote that there is no means to check if a request is
> >> valid,
> > and hence no need for checking for authentication.
> >>
> >>
> >> I would be happy to implement what you suggested about restricting the
> >> number
> > of requests per IP to prevent the defacing of the server-system. Also I
> > will be
> > more than pleased to work on the server-side part to allow the
> > phpMyAdmin developers
> > to analyze and diagnose the errors.
> >>
> >>
> >> Also to prevent the back-end from attacks such as DoS you suggested a
> >> global limit
> > on the number of requests. It seems easy to implement but will play an
> > important role
> > against DoS attacks.
> >>
> >>
> >> I will reply back after I work out a plan for the server-side interface
> > and functioning for comments from you all.
> >>
> >>
> >> Rouslan Placella wrote:
> >>
> >>> The wiki is pretty comprehensive on the matter. Do you have a more
> >>> specific question?
> >>
> >> Yes, is there a place where I can upload a draft of my application
> > for my mentor to review it? If not, is posting it to the mailing list
> fine?
> >
> > Not that I know of. You can post to the mailing list, but your draft
> > will be visible to other gsoc candidates.
>
> Ok. Thanks for the information.
>
> >
> > Bye,
> > Rouslan
> >
> >
>



--
Abhishek Kandoi
First Year, Computer Science and Engineering
Indian Institute of Technology Roorkee
About Me : about.me/kandoiabhi
-------------- next part --------------
An HTML attachment was scrubbed...

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

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter

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

_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


End of Phpmyadmin-devel Digest, Vol 81, Issue 25
************************************************


Thank you Michal.I manage to enable those features in phpmyadmin.I have a quick look at these files which participate with the designer and GUI editor.[

pmd_display_field.php,
pmd_general.php,
pmd_pdf.php,
pmd_relation_new.php,
pmd_relation_upd.php,
pmd_save_pos.php

schema_edit.php
schema_export.php
libraries/schema classes
].
There are many HTML tags mix with php tags and sql queries inside these files which reduces the understandability of the code which is really need some refactoring.



Shamika Dharmasiri
Faculty of Engineering
University Of Peradeniya