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 batemo on Mon Nov 18, 2013 1:24 pm
([msg=78235]see Re: Please ask questions ONLY in this topic.[/msg])

I was just able to find the right way to get the emails today. There is a little quirk in the UNION ALL command that I found out about in the forum and that's what really unlocked it for me. The number of columns for each result should be the same. Otherwise the query does not work. I hope I am not giving up too much info, I believe this is a technicality in SQL and people might not be aware of it (certainly took me a while to figure out).
batemo
New User
New User
 
Posts: 1
Joined: Mon Nov 18, 2013 1:19 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by osoleve on Tue Jan 14, 2014 11:21 pm
([msg=78948]see Re: Please ask questions ONLY in this topic.[/msg])

I figured it out! I solved it! I actually threw my hands up in the air when I saw I did it, I've been THAT frustrated. Best of all, I actually understand what I did to fix it!

My issue was how to address the inequality of columns in the two tables. Some earlier posts here kind of threw me off course, but I had a lightbulb moment. :D
osoleve
New User
New User
 
Posts: 1
Joined: Tue Jan 14, 2014 11:14 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by njpg on Tue Mar 04, 2014 3:35 am
([msg=79732]see Re: Please ask questions ONLY in this topic.[/msg])

Like many people it seems, I'm very puzzled why UNION doesn't work, but UNION ALL does. if we UNION SELECT 100,200,300,400;, we haven't introduced any duplicate rows, so there should be no difference between union and union all, but instead it just breaks everything and garbage is returned. Even if it somehow was a duplicate row, there's no reason that should break the existing rows.
njpg
New User
New User
 
Posts: 2
Joined: Tue Mar 04, 2014 3:25 am
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by simonsickle on Fri Mar 14, 2014 6:39 pm
([msg=79914]see Re: Please ask questions ONLY in this topic.[/msg])

So, injection was the way to go, which i disovered pretty early on. I just need to figure out how to message save the whales i suppose. Currently the forum isnt letting me
simonsickle
New User
New User
 
Posts: 2
Joined: Fri Mar 14, 2014 6:36 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by Adrasteia the Inescapable on Sun Mar 16, 2014 1:08 pm
([msg=79951]see Re: Please ask questions ONLY in this topic.[/msg])

simonsickle wrote:So, injection was the way to go, which i disovered pretty early on. I just need to figure out how to message save the whales i suppose. Currently the forum isnt letting me

HackThisSite has two separate message systems, you have to use the one that isn't connected to the forums.
Adrasteia the Inescapable
New User
New User
 
Posts: 33
Joined: Sun Mar 09, 2014 12:02 am
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by lostinmoscow on Thu Mar 27, 2014 3:17 pm
([msg=80044]see Re: Please ask questions ONLY in this topic.[/msg])

Does anyone else get logged out of HTS completely when trying to use a UNION SELECT query? Strangest thing...

Like, forcibly logged off. If I try to use @@version I'm logged off immediately. Bizarre.
lostinmoscow
New User
New User
 
Posts: 1
Joined: Thu Mar 27, 2014 3:15 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by A200K on Wed Apr 23, 2014 5:16 pm
([msg=80346]see Re: Please ask questions ONLY in this topic.[/msg])

My email did not appear in the mailing list when I clicked on 'add to list' :(
A200K
New User
New User
 
Posts: 4
Joined: Tue Apr 22, 2014 9:26 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by Adrasteia the Inescapable on Sun May 04, 2014 8:50 pm
([msg=80547]see Re: Please ask questions ONLY in this topic.[/msg])

A200K wrote:My email did not appear in the mailing list when I clicked on 'add to list' :(

Imagine if you solved it and it gave you the emails all the other HTS users had submitted while experimenting with the site. ;)
The database is fixed, you can't add anything to it.
Adrasteia the Inescapable
New User
New User
 
Posts: 33
Joined: Sun Mar 09, 2014 12:02 am
Blog: View Blog (0)


Re: Realistic 4-Nowhere to Post?

Post by xThePCCrackerX on Sun May 11, 2014 4:22 am
([msg=80639]see Re: Realistic 4-Nowhere to Post?[/msg])

Karate-Boy wrote:But can anyone help me how I get the e-mails?

Use SQL Injection

-- Sun May 11, 2014 4:24 am --

zombiesmurf wrote:I have the e-mails, but can't seem to find the user to which I need to send them...though I could just be blind and it's quite blatantly in front of me (I hope this is not the case)

The user is SaveTheWhales.You can private message the emails.Hope this helped! :D

-- Sun May 11, 2014 4:27 am --

Nobody wrote:What is this sorcery????:)

Idk
xThePCCrackerX
New User
New User
 
Posts: 2
Joined: Tue Mar 25, 2014 8:03 am
Blog: View Blog (0)


Re: Realistic 4-Nowhere to Post?

Post by cyberdrain on Thu May 15, 2014 10:15 am
([msg=80711]see Re: Realistic 4-Nowhere to Post?[/msg])

xThePCCrackerX wrote:-- Sun May 11, 2014 4:27 am --

Nobody wrote:What is this sorcery????:)

Idk


Haha, it's magic :) (clever use of quotes, I salute you sir/madam)
Free your mind / Think clearly
User avatar
cyberdrain
Contributor
Contributor
 
Posts: 814
Joined: Sun Nov 27, 2011 1:58 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