Re: mask attack - C# Discussion Boards

Re: calculating total time betweem time ranges

Richard Deeming3-Sep-14 2:18

3-Sep-14 2:18

Since you didn't post any details about the structure of your table, I had to make up an example. You'll want just the SELECT block; replace @Data with the name of your table, and replace TimeLogged and Action with your column names.

SQL

SELECT
    D1.NameOfYourActionColumn,
    Sum(DateDiff(second, D1.NameOfYourTimeLoggedColumn, D2.NameOfYourTimeLoggedColumn)) As DurationInSeconds
FROM
    NameOfYourTable As D1
    CROSS APPLY
    (
        SELECT TOP 1
            NameOfYourTimeLoggedColumn
        FROM
            NameOfYourTable As D2
        WHERE
            D2.NameOfYourActionColumn != D1.NameOfYourActionColumn
        And
            D2.NameOfYourTimeLoggedColumn>= D1.NameOfYourTimeLoggedColumn
        ORDER BY
            NameOfYourTimeLoggedColumn
    ) As D2
GROUP BY
    D1.NameOfYourActionColumn
;

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: calculating total time betweem time ranges

devil54e3-Sep-14 2:32

devil54e

3-Sep-14 2:32

it seems to work,
thank you very much

Message Closed

2-Sep-14 0:42

Group 11052377

2-Sep-14 0:42

Message Closed

Re: mask attack

Rob Philpott2-Sep-14 0:44

Rob Philpott

2-Sep-14 0:44

Who's zip file is it?

Give up, you don't stand a chance.

Regards,
Rob Philpott.

Re: mask attack

Group 110523772-Sep-14 1:03

Group 11052377

2-Sep-14 1:03

zip folder

Re: mask attack

Chris Quinn2-Sep-14 3:02

Chris Quinn

2-Sep-14 3:02

Jennifer Lawrence's

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: mask attack

Manfred Rudolf Bihy2-Sep-14 0:56

Manfred Rudolf Bihy

2-Sep-14 0:56

There is a tool I've heard about, but have not yet been able to verify if it really works.
It's called Ultimate CrIP Zacker, or something. Poke tongue | ;-P

Cheers!

"I had the right to remain silent, but I didn't have the ability!"

Ron White, Comedian

Re: mask attack

Dave Kreskowiak2-Sep-14 1:54

Dave Kreskowiak

2-Sep-14 1:54

Sorry but you're NEVER going to get help with this in any legitimate forum such as CP.

We have no idea who this ZIP file belongs to and we're not going to post any information that can be used to crack it as we're not going to be party to stealing someones information, even if it isn't you that's doing it. It could be some other schmuck who's Googling around trying to find information on how to do it themselves.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: mask attack

Eddy Vluggen2-Sep-14 2:57

Eddy Vluggen

2-Sep-14 2:57

With that argumentation, we should REALLY stop explaining how sql-injection works.

Ban the bobby tables comic!

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: mask attack

Richard Deeming2-Sep-14 3:22

Richard Deeming

2-Sep-14 3:22

There's a significant difference between giving a detailed explanation of how to pick a lock, and explaining to someone that if they leave their door open, someone will come in and steal their stuff. Poke tongue | ;-P

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: mask attack

Eddy Vluggen2-Sep-14 3:25

Eddy Vluggen

2-Sep-14 3:25

Glad you agree the comic should be banned.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: mask attack

Richard Deeming2-Sep-14 3:45

Richard Deeming

2-Sep-14 3:45

But I don't.

In this analogy, "detailed instructions for picking a lock" is equivalent to "here's how to brute-force a password".

"Unlocked door => stolen stuff" is equivalent to "you've got a well-known and easily exploitable security vulnerability in your code, here's how it works, and here's how you fix it".

It's hard enough to get some people to take SQLi seriously. If you're not allowed to explain how it works, and you just have to rely on saying "bad stuff will happen", nobody will pay any attention until it's too late.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: mask attack

Eddy Vluggen2-Sep-14 7:36

Eddy Vluggen

2-Sep-14 7:36

Richard Deeming wrote:
But I don't.

I know

A password on a zip-file is not a lock. It's not a door in a house - it'd be more someone elses locked box, inside your house.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: mask attack

Dave Kreskowiak2-Sep-14 4:23

Dave Kreskowiak

2-Sep-14 4:23

I don't see it that way.

A SQL Injection question is more about telling the programmer (and I use that term lightly!) how to defend against the attack and produce higher quality code.

This is just a brute force, "crack a password so I can break in and get the data" question with no benefits to the quality or strength of his non-existent code.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: mask attack

OriginalGriff2-Sep-14 5:59

OriginalGriff

2-Sep-14 5:59

I disagree.
I'm pretty sure that the first thing you should be told when you start any computing course is exactly how to perform an SQL injection attack, with examples, and encouraged to try it out as often as possible. Free T shirts with the instructions on would be good.

That way, the problem would die. Because no systems would dare be left open to it, and no tutor could possibly ignore it or not know about it enough to teach students the Right Way to do things. Because there is the problem: tutors who don't know enough, and don't teach about security in any meaningful way.

Forget seatbelts in cars to reduce injuries in an accident, reduce the number of damn accidents by making drivers aware of how dangerous they are! Laugh | :laugh:

You looking for sympathy?
You'll find it in the dictionary, between sympathomimetic and sympatric
(Page 1788, if it helps)

Re: mask attack

Eddy Vluggen2-Sep-14 3:00

Eddy Vluggen

2-Sep-14 3:00

It's explained on the Wikipedia, and there are links to software that implements such.

I would link to the wikipedia, but I'm afraid that some members will ask for a book-burning.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: mask attack

Manfred Rudolf Bihy2-Sep-14 3:07

Manfred Rudolf Bihy

2-Sep-14 3:07

I gave OP the name of a program that will do what he wants.
If he'll get the words straightened out of course.

Cheers!

"I had the right to remain silent, but I didn't have the ability!"

Ron White, Comedian

pin it to whatever version of VS you have - windows 8.1

jojoba201-Sep-14 23:04

jojoba20

1-Sep-14 23:04

Hi,
I have VS2013 and VS2008.
now i only have Recent and Pinned List just for VS 2013.
How can i have that for VS 2008 version also.
In other workd :
pin it to whatever version of VS you have

Re: pin it to whatever version of VS you have - windows 8.1

Richard MacCutchan2-Sep-14 0:36

Richard MacCutchan

2-Sep-14 0:36

jojoba20 wrote:
How can i have that for VS 2008 version also.

You need to manually add the items to VS2013.

Re: pin it to whatever version of VS you have - windows 8.1

jojoba202-Sep-14 4:27

jojoba20

2-Sep-14 4:27

but i wanna ho have VS2008 project into jump list vs2008 and
VS2013 projects to jump list VS2013 .
not in VS selector.

thanks in advanced!

Re: pin it to whatever version of VS you have - windows 8.1

Richard MacCutchan2-Sep-14 7:39

Richard MacCutchan

2-Sep-14 7:39

jojoba20 wrote:
i wanna ho have

is not English, but I assume you are trying to say "I want to have". However, the remainder of your question makes no real sense so I cannot offer any suggestions.

Populate Checkboxlist from Database, and Populate second checkboxlist from selected values in first checkboxlist, all with databases

Member 1004319229-Aug-14 18:21

Member 10043192

29-Aug-14 18:21

hello friends, some here know how i can, populate checkboxlist from database, and populate second checkboxlist with values selected in first checkboxlist, first control should be populate second, I work at asp.net c#, thanks for all, thanks for read this, thanks for all your help.

Re: Populate Checkboxlist from Database, and Populate second checkboxlist from selected values in first checkboxlist, all with databases

Richard MacCutchan29-Aug-14 23:00

Richard MacCutchan

29-Aug-14 23:00

Member 10043192 wrote:
I work at asp.net

Then perhaps the ASP.NET forum[^] would be a better place for your question.

Re: Populate Checkboxlist from Database, and Populate second checkboxlist from selected values in first checkboxlist, all with databases

Kornfeld Eliyahu Peter30-Aug-14 9:06

Kornfeld Eliyahu Peter

30-Aug-14 9:06

You forgot to mention when you need the working code?

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Re: Populate Checkboxlist from Database, and Populate second checkboxlist from selected values in first checkboxlist, all with databases

V.31-Aug-14 8:10

31-Aug-14 8:10

look into the topic linked lists.
Basically you need to have a link in the database to begin with and load that link with the object in the checkboxlist. When you need to populate the second list based on the selection of the first you pass the foreign key and select the values corresponding to that.

Foreign key can be a number, guid or a category name eg...

V.

(MQOTD rules and previous solutions)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.