RE: [PHP-DB] Wait Statement... ?

2004-07-21 Thread Daevid Vincent
Uhmmm.. how effective is a brute force attack where you can only try one combination per second? It's going to take you a while to get through that dictionary. How determined are you ;-) Our product has a brute force attacker in it, and for some protocols, we have to wait a few seconds

RE: [PHP-DB] Wait Statement... ?

2004-07-21 Thread Daevid Vincent
I like this idea of longer sleeps for each fail in theory, but it becomes moot if you only allow 3 failed attempts. -Original Message- From: Tim Van Wassenhove [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 3:37 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Wait

[PHP-DB] Query returns duplicate rows

2004-07-21 Thread Brock Jimmy D Contr 74 MDSS/SGSI
My query is returning duplicates rows. table: elements elementId standardId elementtext category mcode linenum table: scores scoreId taskId scores Here's my query: SELECT distinct elementtext,cateogy,mcode,linenum,scores,scoreId FROM elements, scores WHERE scores.taskId='12' AND

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
On Wed, 21 Jul 2004 16:29:37 -0400, Brock Jimmy D Contr 74 MDSS/SGSI [EMAIL PROTECTED] wrote: My query is returning duplicates rows. table: elements elementId standardId elementtext category mcode linenum table: scores scoreId taskId scores Here's my query: SELECT distinct

RE: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Brock Jimmy D Contr 74 MDSS/SGSI
These two tables do not have a relation, so there is nothing to join. Basically, what I'm trying to is this: Users need to score elements. The elements are assoicatied with standards. A standard may have 1 to 29 elements associated with it. For users to score the elements they need to see the

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
On Wed, 21 Jul 2004 17:09:35 -0400, Brock Jimmy D Contr 74 MDSS/SGSI [EMAIL PROTECTED] wrote: These two tables do not have a relation, so there is nothing to join. Basically, what I'm trying to is this: Users need to score elements. The elements are assoicatied with standards. A standard may

Re: [PHP-DB] Wait Statement... ?

2004-07-21 Thread Shah
Well, everyone is in big discussion about this, so i figure i'll toss in my worthless 2 cents. Say your users have a password of like 8 characters, Brutus (used for brute forcing) will tell someone trying to gain access that they'll have better luck asking the person. So the only real threat

[PHP-DB] search form w/ multiple fields

2004-07-21 Thread Vincent Jordan
I have a form with firstname, lastname, phone, and email fields. I would like to search the database and return results to the same page in an iframe. I want to be able to search my just one or multiple. For example I can search by firstname with value of john and it will return all john rows in