forum.vdsworld.com

[Teamgreentech]

Hi All, I am working on a project that requires sending info to a browser with login information that php needs to check against mysql database.

As the passwords are md5 encrypted I need to get the password encrypted on loginbutton event then pass the user name and encrypted password string to the browser so that php gets the correct info to compare with the users table in mysql.

This is simple if I just use the browser and load a login page but as the browser dialog element does not use TAB key to go to next input box it is a pain for users to mouse click everywhere..

Anyway the question is... has anyone tried to md5 encrypt with a dialog script ?

Thanks in advance for help / suggestions
Fletch - Teamgreentech

[LiquidCode]

VDS 5/6 had MD5 built in.

[Teamgreentech]

[LiquidCode]

No, not within VDS. But there are ways of getting the tab key to work if you are the one that created the web page, using java. I have not done it, but I know that it can be done.

[Teamgreentech]

[Teamgreentech]

Hi All, I looked at loads of javascripts to try and solve the Tab key usage to move around a form in VDSBrowser but nothing worked well at all so am trying a different tacked. I have created a form in VDS with Groups Elements and Checkboxes As we can tab through our VDS elements that is sweet but I need to find a way to identify which checkboxes have been selected and return the checkbox name. These will give me the tables and columns names in which I want to query in a mysql database and I can form the http string from here and send to a browser dialog.
Can any of you guys help me with example of how to do this. I assume I need to do some kind of repeat loop through the group elements to test there value and then get the names of the "Selected" Elements...

Much appriceate your help as always...

Andy - Team Green Tech

[Claz]

Hi Teamgreentech,

I'm not sure if I understand your problem well, but to me it seems there are 2 methods to do this:

1. Query each checkbox using @dlgtext() e.g. when closing the form.
2. Add a Click style to each checkbox, leading to Check...Click events and then query the status of the checkbox using @dlgtext().

Hope this helps a bit....

[Teamgreentech]

Hi Claz, thanks for your advice it is appreciated. I kinda went down that route earlier today but becuase I have up to 10 checkboxes in each group element it makes for a very long and uneligent bit of cold with some kind of repeat loop that will look at every checkbox in the group and determine if selected or not.....
I want to do something like this:

:OKBUTTON
Goto Checkgroup

:checkgroup
Repeat
%%var = @Selected elements in Group
Until not any more sellected elements in group to add to %%var

Using the click event was ok but one problem. Wen user unchecks the element the click event still add the element ID to my string that I'm trying to build...

Perhaps you can see another way to achieve this code solution

Regards
Andy - Teamgreentech

[LiquidCode]

The easiest way would be to have your check boxes numbered then use repeat until to get the values. Example:

[Teamgreentech]

Hi LiquidCode, many thanks for your advise. Definitely better than the way I was doing it up to this afternoon when I saw your reply

I had starteda include function that went through all the checkbox names and made for a very ugly solution ;-(

Is there a way to return the "title" of the element for example
CHECK1 title is INID rather that CHECK1
so that if CHECK1 is Selected I can get the title info back ? something like @title.....

Many thanks
Andy

[Teamgreentech]

Also I need to remove the last character in my string which is always an "&". how can I do this ?

[Aslan]

Teamgreentech, welcome to VDS

First I'm a bit confused as to what the issue is.
If this is a sudo form then I assume that you aren't actually posting anything until the form is completed in which Claz's answer should suffice. Since you the programmer already know what each check is for, just query all the checkboxes before posting.

[Teamgreentech]

Hi Aslan, many thanks for your input earlier today it is much appreciated.
I will try and explan further with some code included here also.....

The end result here is a string that can be write to a registry key containing all the information required for my query.php file to perform a mysql search against the columns rows and tables in the database.
Once My Script has got the search criteria and written it to the registry it creates a report.flag and closes the child window.

The Main_evloop looks for the existance of flags such as the once created above and takes the relevent action i.e goto :searchevent
:Searchevent
%%ReportQuery = http://%%net/Staff/Gui/query.php?@regread(HLM,SOFTWARE\TGTGMS,ReportQuery)
reads the relevent registry key and forms the URL and sends it to the browser. Happy Days we get some results back from Mysql....

My child window code for Report Form Code :

[Aslan]

I'm assuming that this is the part you're trying to figure out.

[Teamgreentech]

Indeed this is a challenge

The check boxes represent columns in a mysql datebase that a user may or may not choose to have selected in the query he or she is making. Thus we will have a fully customisable report form. We have already acheived this with a html form and php but would prefer everything through VDS as the dialogs look snappier and more professional than a simple web page + Users can use the tab key to travel between boxes if they so wish. This is not possible with webpages in vds browser

I thought of using the checkboxes as it is more visual for the user as they are reviewing their selections before commiting the report criteria. But I do agree a multi list might be a great alternative. can you offer up an example of coding to do this

BTW,Yes the TestCheck is a function and %X is what it returns, which is of course a string of Tables and Columns that have been selected.

Many thanks once again for your help Aslan
Best Regards
Andy - TGT