Please ask questions ONLY in this topic.

FAP is company that slaughters animals and turns their skin into overpriced products which are then sold to rich bastards! Help animal rights activists increase political awareness by hacking their mailing list.

Re: Please ask questions ONLY in this topic.

Post by conscience on Sat Aug 20, 2011 4:36 pm
([msg=61033]see Re: Please ask questions ONLY in this topic.[/msg])

Mem- wrote:I just dont understand how the email one works. Does it work like a table and the first column is just an integer that goes up by int+1. Where the second row is the email address is that correct?


Well, if I got your question right, then yes. We'll have something like
Code: Select all
ID  email
1   john@exampleDOTcom
2   mary@exampleDOTnet
3   iamthethirduser@trollDOTorg
4   etc@hackthissiteDOTorg


in this case, let's suppose id is an unsigned int and email is a string (VARCHAR(255)) for example.
also assume that we have another table:

Code: Select all
email                             name
john@exampleDOTcom             John Doe
iamthethirduser@trollDOTorg    Fuckin' Idiot
mary@exampleDOTnet              Mary Poppins
etc@hackthissiteDOTorg           Every Body


(sorry about DOTting, the parser complained about 'URLs')

In this case, for example, if you say SELECT * FROM email WHERE ID=2 UNION SELECT name FROM names WHERE email='etc@hackthissite.org' the query will not execute because the number of columns do not match.
Also, if you "select *" from both tables, the query will still fail due to the coulmn types (UNSIGNED INT vs. String) being different.

if you say SELECT * FROM email WHERE ID=2 UNION SELECT 0,name FROM names WHERE email='etc@hackthissite.org'
your query will execute and you'll get 2 rows:
Code: Select all
2   mary@example.net
0   Every Body



Keeping in mind that the query won't execute if the number of columns don't match, the number of columns can be found out easily by giving the appropriate garbage to the database. this way the website will display error/not display stuff if the columns count is wrong, otherwise, you'll see your garbage besides the normal result of your select.

I really hope my post is not spoilish... :oops:
Let him who has understanding recount the number of the beast, for it is a human number: His number is 0x029A.
conscience
Poster
Poster
 
Posts: 248
Joined: Thu Jan 08, 2009 9:05 pm
Location: 127.0.0.1
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by tyzoid on Thu Sep 15, 2011 6:47 pm
([msg=61582]see Re: Please ask questions ONLY in this topic.[/msg])

I got the list of emails, but when I go to pm the person (savethewales i believe) it says
Code: Select all
You are not authorised to send private messages.
tyzoid
New User
New User
 
Posts: 1
Joined: Thu Sep 15, 2011 3:30 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by mShred on Thu Sep 15, 2011 11:50 pm
([msg=61588]see Re: Please ask questions ONLY in this topic.[/msg])

tyzoid wrote:I got the list of emails, but when I go to pm the person (savethewales i believe) it says
Code: Select all
You are not authorised to send private messages.

Don't use the forums PMing system. Use the main site's.
Image

For those about to rock.
User avatar
mShred
Administrator
Administrator
 
Posts: 1613
Joined: Tue Jun 22, 2010 4:22 pm
Blog: View Blog (2)


Re: Please ask questions ONLY in this topic.

Post by icywing on Sat Sep 17, 2011 6:58 pm
([msg=61611]see Re: Please ask questions ONLY in this topic.[/msg])

ahh finally got it :D
icywing
New User
New User
 
Posts: 4
Joined: Sun Sep 11, 2011 7:18 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by xhacker99x on Wed Sep 21, 2011 3:13 pm
([msg=61708]see Re: Please ask questions ONLY in this topic.[/msg])

how do i get the list of emails/
xhacker99x
New User
New User
 
Posts: 5
Joined: Sun Sep 18, 2011 12:44 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by mShred on Wed Sep 21, 2011 4:04 pm
([msg=61715]see Re: Please ask questions ONLY in this topic.[/msg])

xhacker99x wrote:how do i get the list of emails/

Ya go here.. and do a duh hackity hackity.
But seriously we won't spoon feed you. Try reading through this thread.
Image

For those about to rock.
User avatar
mShred
Administrator
Administrator
 
Posts: 1613
Joined: Tue Jun 22, 2010 4:22 pm
Blog: View Blog (2)


Re: Please ask questions ONLY in this topic.

Post by AtomicSyntax on Wed Sep 28, 2011 10:21 pm
([msg=61941]see Re: Please ask questions ONLY in this topic.[/msg])

How or where do I send the list of e-mails to? When I try to send them through a Private Message, I get an error telling me that Private Messaging is not enabled. Help!!! :(
AtomicSyntax
New User
New User
 
Posts: 1
Joined: Mon Sep 26, 2011 9:24 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by mShred on Wed Sep 28, 2011 10:41 pm
([msg=61942]see Re: Please ask questions ONLY in this topic.[/msg])

AtomicSyntax wrote:How or where do I send the list of e-mails to? When I try to send them through a Private Message, I get an error telling me that Private Messaging is not enabled. Help!!! :(

Mother..
mShred wrote:Don't use the forums PMing system. Use the main site's.
Image

For those about to rock.
User avatar
mShred
Administrator
Administrator
 
Posts: 1613
Joined: Tue Jun 22, 2010 4:22 pm
Blog: View Blog (2)


Re: Please ask questions ONLY in this topic.

Post by Gorflow on Mon Nov 14, 2011 5:17 pm
([msg=62917]see Re: Please ask questions ONLY in this topic.[/msg])

I searched through many pages of this thread but couldn't find a lot of useful information. I think there is a big jump here from the other missions. I know the table name, but the syntax and placement of the SQL injection are very confusing, despite online resources.
Gorflow
New User
New User
 
Posts: 2
Joined: Mon Nov 14, 2011 4:37 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by Defience on Mon Nov 14, 2011 6:54 pm
([msg=62919]see Re: Please ask questions ONLY in this topic.[/msg])

Gorflow wrote:I searched through many pages of this thread but couldn't find a lot of useful information. I think there is a big jump here from the other missions. I know the table name, but the syntax and placement of the SQL injection are very confusing, despite online resources.


There's a way to find out how many columns there are as well. Try to find some information on that, it should help.
User avatar
Defience
Addict
Addict
 
Posts: 1265
Joined: Thu Jun 12, 2008 3:16 pm
Blog: View Blog (0)


PreviousNext

Return to (Real 4) Fischer's Animal Products

Who is online

Users browsing this forum: No registered users and 0 guests