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 ant100 on Fri May 23, 2014 2:44 pm
([msg=80928]see Re: Please ask questions ONLY in this topic.[/msg])

I finally finished the challenge, but there was just one thing I feel I was missing. I knew a little about SQL, but I didn't know about the UNION ALL command. After reading about it, I used it properly and I got the emails. Problem was, I sort of guess the number of columns. It worked out, but I don't feel that was the point.

Reading the threads I discovered there was a way of finding out the number of columns with order by (hope this isn't a spoiler, it was posted before). But never understood how to do it, I googled it and everything but can't find the solution. I might be googling for the wrong keywords, since I can't find anything on my native language.

If maybe someone could explain me, or maybe point me to the correct article/information I would really really appreciate it. I'm not asking for the line of code that would make it work, but the explanation of how and why it works that way. If somebody feels like helping out an annoying noob, I'll be waiting. Thanks!
ant100
New User
New User
 
Posts: 8
Joined: Wed May 21, 2014 2:05 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by cyberdrain on Fri May 23, 2014 6:01 pm
([msg=80939]see Re: Please ask questions ONLY in this topic.[/msg])

Though mShred is more the SQL guy, I think I could explain that one. With a lot of SQL injection the idea is to generate errors. Clever use of the errors will make it possible to return the value of whatever variable you require, including the amount of columns. Normally the command is used to sort a query based on a certain column, as you already found out. Now if you try sorting based on a column that doesn't exist, an error will be returned. Using that knowledge you can determine the amounts of columns. You may PM me if you still don't understand or have any more questions not answered :)
Free your mind / Think clearly
User avatar
cyberdrain
Contributor
Contributor
 
Posts: 691
Joined: Sun Nov 27, 2011 1:58 pm
Blog: View Blog (0)


Re: Please ask questions ONLY in this topic.

Post by Jaggions on Sun Jun 01, 2014 3:54 pm
([msg=81141]see Re: Please ask questions ONLY in this topic.[/msg])

Hey guys, I'm a newbie here. I have completed all 11 basic missions and the first 3 realistic missions on my own in a few hours, but now I'm stuck on realistic mission 4. I have been thinking about the SQL code and trying for hours, and I've read all 43 pages of this thread, which was somewhat tiring. I still couldn't find the correct code, even if I have read all your hints and the webpages you linked in your posts.
Can you help me in some way please? I'm literally getting crazy! :cry:
Jaggions
New User
New User
 
Posts: 1
Joined: Sun Jun 01, 2014 3:45 pm
Blog: View Blog (0)


Previous

Return to (Real 4) Fischer's Animal Products

Who is online

Users browsing this forum: No registered users and 0 guests