Home Upgrade Search Memberlist Extras Hacker Tools Award Goals Help Wiki Contact

[Janus] SQLi challenge #15

~ Tasks ~
- display version, nick name, user and database
- make statistics how many pages were added by each day and display list for days with more than two posted pages per day (newer post dates first - see proof picture)


~ Target ~
aHR0cDovL3d3dy5iYW5mZnZveWFnZXJpbm4uY29tL3BhZ2UucGhwP3BhZ2VJRD0xNDk=
(Base64 decode it using online decoder like https://www.base64decode.org/)


~ Proof ~
[img]http://img4.hostingpics.net/pics/672870challenge15.jpg[/img]


~ Rules ~
- use union select with pure DIOS (no group_concat, no substring_index, no flow control functions)
- command count() may be used only once in your syntax (repeated count() with limit is not allowed as you brake last rule)
- for statistics use only table columns, no local variables,
- don't ask for hints or solution
- your injection should work without knowing exact dates when each news is posted

Post your syntax to https://privnote.com (it is automatically destroyed after reading) and send me link to PM

Let's SQL knowledge be with you 👍


~ Solvers ~
-

Try also my other challenges for advanced injectors: 🎉
janus #1
janus #2
janus #3
janus #4
janus #5
janus #6
janus #7
janus #8
janus #9
janus #10
janus #11
janus #12
janus #13
janus #14
Janus - SQLi challenges for advanced injectors
Site Can Not Be Loaded 🙃
(Aug 13, 2016 09:49 PM)Inject0r Killer Wrote:  Site Can Not Be Loaded 🙃

Thanks for reporting 🤝

Target and POC updated.
Janus - SQLi challenges for advanced injectors
This Target Is Also not working 😏
Thanks for your report 🤝

Sorry, I won't update challenges from 2015 any more.
Janus - SQLi challenges for advanced injectors
🤭 Then why dont you post those solutions 😏 or share those queries in pm plz 🤝
(Sep 10, 2017 05:33 AM)Inject0r Killer Wrote:  🤭 Then why dont you post those solutions 😏 or share those queries in pm plz 🤝

I don't support copy/paste learning, because:
  • Hackbar is full of DIOS syntax named by people who are not original authors

  • People are using some syntax without understanding it.

  • On forum you have plenty of copy/paste challenges where people even don't understand what are they displaying in output 🤫

  • ...


All this because of copy/paste strategy. The best way of learning is by your own experiments.

This challenge tasks can be recreated on any SQLi vulnerable site where you have some news/pages/articles and date when each of them was posted. So tasks are still open, I just don't provide target URL (publicly) any more.
Janus - SQLi challenges for advanced injectors
thx m.r Janus you are right i understand some of them and some i am not understanding
some query i well try to understanding query know l know join,dios,alias,left join,on,in,or,and,benchmark,replace,insert,...etc because of you thx bro
(Sep 10, 2017 05:58 AM)JaNuS18 Wrote:  I don't support copy/paste learning, because:
  • Hackbar is full of DIOS syntax named by people who are not original authors

  • People are using some syntax without understanding it.

  • On forum you have plenty of copy/paste challenges where people even don't understand what are they displaying in output 🤫

  • ...


All this because of copy/paste strategy. The best way of learning is by your own experiments.

This challenge tasks can be recreated on any SQLi vulnerable site where you have some news/pages/articles and date when each of them was posted. So tasks are still open, I just don't provide target URL (publicly) any more.

Thats right 😝


Possibly Related Threads...
Thread / Author Replies Views Last Post
by GOD_SLAYERDec 24, 2022 12:16 PM 9 604 Dec 24, 2022 12:16 PM
Last Post: Skorp
by GOD_SLAYERAug 19, 2022 07:11 PM 0 166 Aug 19, 2022 07:11 PM
Last Post: GOD_SLAYER
by Berry WhiteApr 24, 2020 11:08 AM 4 508 Apr 24, 2020 11:08 AM
Last Post: ApertureSecurity