/a/ - Avatar
Board stats: 2024 total posts, 56 threads
Navigation:
According to a Korean on 4chan in Book 4 Korra will hallucinate in ep 1, in ep 2 she will walk with metal bending, and in ep 3 Korra will be fine so the Red Lotus can attack her.
Also it will end with Korra and Mako getting together, also Asami will get with Bolin.
Itunes sales.
Not bad.
Its always done really well there. No surprise that remains true.
IGN Interview About the Finale, the Upcoming Korra Game and Book Four
http://uk.ign.com/articles/2014/08/25/the-legend-of-korra-game-release-date-and-new-mode-plus-what-to-expect-in-book-4?utm_campaign=ign+main+twitter&utm_source=twitter&utm_medium=social
Stuff revealed thus far,
The videogame will be released on October 21st/22nd....
message too long. Click here to view the full post.
>>118115
Doesn't have to be another jump into the future the way we see it. Just have it be like This is their happy medium for technological advancement. Just have like Star Wars it be more a change of style across the centuries than actual more technology.
The Book 4 trailer just hit 5 million views on youtube. :D
Pretty damn good for 6 days!
>>118115
I'd like to see some sort of scifi fantasy series a la Xenogears and Blade (not Saga though, that setting was crap). Doesn't have to be Avatar necessarily, but most series I see trying that are too heavily biased towards one or the other rather than striking a balance.
Seeing as the thread on the "old" board is locked, FIRST FOR SHYAMALAN!
Was there anything in the movie adaptation you liked?
Was there anything in the movie adaptation you preferred?
M. Night has a script for the sequel completed, what do you think he has/had planned?
Do you think the failure of TLA played in Nick's decision to pursue more seasons of LoK rather than produce an animated version of the search for Ursa?...
message too long. Click here to view the full post.
>>117742
, film was part of his downfall and he ended up being the scapegoat, dang that is sad. Maybe he can get another chance with the series with the success of Turtles.
You guys think Korra could defeat Stardust?
Funny thing, the SpongeBob comic did a homage/parody of Stardust.
http://comicsalliance.com/paul-karasik-r-sikoryak-fletcher-hanks-stardust-spongebob-squarepants-annual/
>>117943
//youtube.com/watch?v=e2DwVyCLW1k
So what do you guys think the villain(s) of season 4 will be like? Human? Spirit? A new Dark Avatar? Something new perhaps?
Just post whatever comes to mind whether they be final boss or mook. Have fun with this
We never did find out what those "leaked" x-rayish images that people prior to Season Three said were the villains did we?
>>117837
Someone on tumblr did some digging around with some photoshop and found that x rayish pic is from the scene when Zaheer announces the earth queens death to baa sing se with ming hua and p'li at his sides
An army of "peacemakers" from the spirit world that have come to instill order in those that have escaped to cause havoc on the material plane. However, with the spiritual and physical maiming of the Avatar, they decide that it's high time they took over for the good of all as both spirits and humans seem incapable of taking care of themselves.
Spirit-Human relations are a big part of the book. Neither side is laudable as Spirits are usually full of themselves to the point of conceit while Humans can be casually cruel. Last half of the season is basically both camps trying to overcome their differences and find a way to defend themselves against this powerful army that would judge them all.
A thought occurs.
What if Amon and the Equalists had decided to set up shop in Ba Sing Sei first, instead of Republic City? There is clearly a more prominent divide between rich and poor there, in addition to an actively malicious government as opposed to a merely inept/indifferent one like RC has? Hell, even when things were at their worst under Tarrlok, he never disappeared people in the middle of the night for being inconvenient either. Additionally, the Dai Li wouldn't be much good against Amon's powers for the most part either, so there's less chance of him being abducted before the movement could get going...
...Though on the other hand it appears that a level of indoctrination is in place in the city, as shown by Mako and Bolin's grandma praising the Earth Queen's statue, so maybe RC was a better target as its comparitively liberal setting allowed him to set up shop easier? Like, I don't think that the Equalists could get away with protesters in Ba Sing Sei, for example....
message too long. Click here to view the full post.
It would depend upon how many non-benders were in high positions. If the Earth Queen and most of the ministers were non-benders then Amon wouldn't be able to claim that benders are oppressing non-benders.
Though Amon could claim that rich non-benders are using benders to oppress poor non-benders and try to get the poor to support him by weakening the Dai Li the Earth Queen would probably respond much more harshly than the RC Council.
It was fitting for Noatak to try to succeed where his father had failed.
Zaheer has a message to send to Korra, and it's up to the Bending Bros to make like the Postal Service and deliver. But what is his message?! We'll find out in this penultimate week of Book 3 releases. Finale next week!
Check it out at 12 Noon EST on Nick.com (free with ads), the Nick mobile App (free with ads), Hulu Plus, Amazon Video, Google Play, and Xbox ($1.99 per episode).
For those with Amazon Video, they in fact did release last week's episode at 4AM EST again. So if any night owl east coasters want the ep it should be up by then if they hold to this pattern. West Coasters check out Amazon at 1AM local time. I was able to watch the last two episodes in High Def on my Wii U at 4AM and was able to avoid online spoilers :3
>>117802
"They took Tenzin. Oh I really hope its that. If he dies, it'll be something.
All of our heroes are in custody of separate forces! Everyone's making a bee-line back to Ba Sing Se, shit's about to get super fucking real!
What's in store this week? Find out at 12 Noon EST on Nick.com (free with ads), the Nick mobile App (free with ads), Hulu Plus, Amazon Video, Google Play, and Xbox ($1.99 per episode).
Amazon put up last week's episode at 4AM EST. I'm going to keep an eye out for another early release.
Just a warning: it looks like zaheerforthepeople is gearing up to leak another episode.
Our heroes are hot on the trail of that damn deceitful Aiwei, However away from the protection of Zaofu they put themselves at risk of the hunters becoming the hunted!
What's in store this week? Find out at 12 Noon EST on Nick.com (free with ads), the Nick mobile App (free with ads), Hulu Plus, Amazon Video, Google Play, and Xbox ($1.99 per episode).
>>117736
>accidentally
Anyone got a link to the leaked episode in high quality? I'm still planning on watching the episode when it comes out tomorrow but I want to know what happens before I get spoiled any worse than I already have.
I just came to the realization that Nickelodeon has a bunch of moras working for them.
Why does it have to be a this or that situation?
>Only on Television
>Book Three Continues Right Here on Nick.com/Korra...
message too long. Click here to view the full post.
>>117679
Combo of those that hated Korra because it violated their headcanon of post ATLA events, those that hated Korra because she was brown and/or a woman. Those that just hate action shows in general or because it wasn't the action show they wanted from Nick. Those that hated it because it ruined their headcanon for what they thought Amon would be. Cripes the amount of toxic bile especially just he plain hate for Korra herself. Like she was some personal affront to..something. Dunno how much of that leaked out to other places, but it just wasn't a nice place to talk about Korra.
But overall Nick needs to be slapped in the face for being so shit with their lack of a block for these shows. Did someone actually cut a insane deal that they had to air all those shows by themselves in a sea shows that don't fit!!! One episode of power rangers sandwiched between FOP and Spongebob, what madness is this? Nicktoons has a more coherent schedule, least they fucking air ATLA and its bookend by similar shows. I just don't understand.
Hell I'd gladly watch Nicktoons over Nickelodeon oh wait its not in any basic cable package (last I checked and that has been a few years since I gave a damn)
>>117681
>Combo of those that hated Korra because it violated their headcanon of post ATLA events
Except it really didn't. Like I said, autists.
>those that hated Korra because she was brown and/or a woman
Definitely autists.
>Those that just hate action shows in general or because it wasn't the action show they wanted from Nick....
message too long. Click here to view the full post.
Just so much hate. And now with Nick clearly being neglectful of their shows and just in it if the show can keep it together long enough to make a profit for them but otherwise uncaring and won't lift a finger to help. It's frustrating that Korra may make it to the final curtain but the franchise is dead since Nick just couldn't be asked to help in any capacity to make it successful. Unless Platinum brings a miracle boon, least we'll get games then.
Zaheer's crew is itchin' to start some trouble for our heroes! Shit's about to get real!
Who will be the one? Who will be the one to spark the digital and computer revolutions for their world? Will it be Varrick, one of his descendants, or perhaps someone different entirely?
Hm, I'd say probably Asami down the line with input from a lot of other people. Considering the first proper computer was built by Alan Turing and the other Bletchley Park folk in the 1940s, I'd say it's conceivable that the first computers'll be appearing within the Korra cast's lifetime, what with their pseudo-1920s aethetic and all.
From what we've seen of Asami thus far, she seems to be more of an engineer than a mathematician, so chances are a Turing-ish character* would be needed to at least start things on the road to getting a programmable digital computer.
*Computer scientists/theorists existed prior to and at the same time as Turing, though his work codified and extrapolated from existing work in such a way that he was able to lead to the creation of Colossus, the world's first digital computer.
Old Wounds & Original Airbenders are being served up for us this week. Looks like we might find out what's been the divide between the Beifong sisters.
The production crew has described Book 3 as being very "gritty and emotional", looks like a tidal wave of feels is approaching. Brace yourselves!
>>117599
As much as I genuinely like Korra, I am kind of psyched for what comes afterwards, if they decide to franchise it Star Trek style (so Airbender is to TOS, Korra is to TNG etc.). Will they go to the next Avatar in the cycle, and move their anime-influence from Miyazaki to stuff like Akira and Ghost in the Shell? Or will they go to one of the Avatars prior to Aang got go for the more old school fantasy stuff, like Wan's adventures?
I'd kind of like to see the adventures of the older Gaang, like Toph's time as a policewoman, Aang's time as Ghandi-Lincoln etc.
>>117602
Indeed a Series with Aang as he grows into a statesmen and leader or the next series with an Earthbender working to bring peace and maybe bring his people into the republic
Legend of Korra's first 2 episodes have names.
>The Legend of Korra : 201, A Breath of Fresh Air.
>The Legend of Korra : 202, Rebirth.
source;
http://cocatalog.loc.gov/cgi-bin/Pwebrecon.cgi?v1=16&ti=1,16&Search_Arg=korra&Search_Code=FT%2A&CNT=25&PID=qRrDi1uAOPn6hcY7q2Lp3JuAdex&SEQ=20140516230036&SID=1...
message too long. Click here to view the full post.
>>117436
I was referring to the 3 books when I said seasons. So book/season 3 would be Change.
>Since its June 27 premiere, The Legend of Korra has been troubled with low ratings. From as high as 1.5 million on the first episode to as low as 1.1 million on the fourth and fifth episodes, it was only a matter of time before episodes were either rescheduled or pulled completely.
>Now, the network has started pulling the episodes completely. After seven new episodes of Book Three’s 13 have aired, Nick has pulled one episode from this Friday as well as all four episodes from August 1 and 8.
http://www.nickandmore.com/2014/07/23/nickelodeon-pulls-five-legend-of-korra-premieres/
load average: array(3) { [0]=> float(0.11) [1]=> float(0.18) [2]=> float(0.17) }
total load time: 0.0148s
code time: 0.0076s;
query time: 0.0072s
code time percentage: 51.3514%
query time percentage: 48.6486%
queries: 4
memory usage: 1.44MB
memory peak: 1.54MB
Controls:
| section | string(5) "index" |
| pagenumber | string(1) "3" |
| ext | string(4) "html" |
| extendedparams | array(1) { ["board"]=> string(1) "a" } |
| lang | NULL |
Time log:
|
1679584637.7303: beginning 1679584637.73 - 0.000000 (0.000000s): script started 1679584637.730691 - 0.000391 (0.000391s): core files loaded 1679584637.730770 - 0.000470 (0.000079s): kobak\debug: setting up new instance 1679584637.730787 - 0.000487 (0.000017s): kobak\debug: finished setup 1679584637.730793 - 0.000493 (0.000006s): kobak\kcfg: setting up new instance 1679584637.730859 - 0.000559 (0.000066s): kobak\kcfg: finished setup 1679584637.730880 - 0.000580 (0.000021s): kobak\controls: setting up new instance 1679584637.730890 - 0.000590 (0.000010s): kobak\controls: finished setup 1679584637.730892 - 0.000592 (0.000002s): kobak\modules: setting up new instance 1679584637.730894 - 0.000594 (0.000002s): kobak\modules: finished setup 1679584637.730950 - 0.000650 (0.000056s): kobak\modules: loading module kobak 1679584637.730955 - 0.000655 (0.000005s): kobak\pages: setting up new instance 1679584637.730965 - 0.000665 (0.000010s): kobak\pages: finished setup 1679584637.730968 - 0.000668 (0.000003s): kobak\plugins: setting up new instance 1679584637.730971 - 0.000671 (0.000003s): kobak\plugins: finished setup 1679584637.731151 - 0.000851 (0.000180s): kobak\kobak: setting up new instance 1679584637.731157 - 0.000857 (0.000006s): kobak\kobak: finished setup 1679584637.731160 - 0.000860 (0.000003s): kobak\cache: setting up new instance 1679584637.731162 - 0.000862 (0.000002s): kobak\cache: finished setup 1679584637.731163 - 0.000863 (0.000001s): kobak\cache: loading cache file: kobak_cache 1679584637.731169 - 0.000869 (0.000006s): kobak\cache: checking cache file: kobak_cache 1679584637.731330 - 0.001030 (0.000161s): kobak\current: setting up new instance 1679584637.731335 - 0.001035 (0.000005s): kobak\current: finished setup 1679584637.731338 - 0.001038 (0.000003s): kobak\errors: setting up new instance 1679584637.731344 - 0.001044 (0.000006s): kobak\errors: finished setup 1679584637.731575 - 0.001275 (0.000231s): kobak\modules: finished loading module "kobak" 1679584637.731577 - 0.001277 (0.000002s): kobak\modules: finished loading 1 module(s) 1679584637.731580 - 0.001280 (0.000003s): kobak\current: creating default rewrite rules 1679584637.731581 - 0.001281 (0.000001s): kobak\current: starting validation of current section 1679584637.731588 - 0.001288 (0.000007s): kobak\plugins: checking actions for hook "before_validation" 1679584637.731608 - 0.001308 (0.000020s): kobak\plugins: finished running 1 actions for hook "before_validation" 1679584637.731612 - 0.001312 (0.000004s): kobak\current: finished validating section 1679584637.731616 - 0.001316 (0.000004s): kobak\current: finished validating prerequisites 1679584637.731620 - 0.001320 (0.000004s): kobak\current: finished validating optional inputs 1679584637.731638 - 0.001338 (0.000018s): kobak\plugins: checking actions for hook "validation" 1679584637.731648 - 0.001348 (0.000010s): KOBAK BBS: validating board 1679584637.731756 - 0.001456 (0.000108s): kobak\ban: query: querying posts 1679584637.731766 - 0.001466 (0.000010s): kobak\db: setting up new instance 1679584637.731769 - 0.001469 (0.000003s): kobak\db: Attempting to connect to database 1679584637.732407 - 0.002107 (0.000638s): kobak\db: Successfully connected to database 1679584637.732413 - 0.002113 (0.000006s): kobak\db: finished setup 1679584637.733079 - 0.002779 (0.000666s): KOBAK BBS: loading board specific plugins 1679584637.733349 - 0.003049 (0.000270s): KOBAK BBS: finished loading board specific plugins 1679584637.733363 - 0.003063 (0.000014s): KOBAK BBS: validating pagenumber 1679584637.733377 - 0.003077 (0.000014s): kobak\plugins: finished running 2 actions for hook "validation" 1679584637.733397 - 0.003097 (0.000020s): kobak\current: Template file found 1679584637.733399 - 0.003099 (0.000002s): kobak\current: setting up HTML vars 1679584637.733401 - 0.003101 (0.000002s): kobak\html: setting up new instance 1679584637.733416 - 0.003116 (0.000015s): kobak\html: finished setup 1679584637.733419 - 0.003119 (0.000003s): kobak\current: setting up per-page HTML vars 1679584637.733424 - 0.003124 (0.000005s): kobak\plugins: checking actions for hook "setup_html" 1679584637.733469 - 0.003169 (0.000045s): KOBAK BBS: finding thread starters 1679584637.733472 - 0.003172 (0.000003s): kobak\thread: query: start 1679584637.733477 - 0.003177 (0.000005s): kobak\thread: query: getting parents. 1679584637.734499 - 0.004199 (0.001022s): kobak\thread: query: parents queried. querying children. 1679584637.740265 - 0.009965 (0.005766s): kobak\thread: query: children query finished. building children post objects. 1679584637.740766 - 0.010466 (0.000501s): kobak\thread: query: children post objects done. looking up statistics. 1679584637.740774 - 0.010474 (0.000008s): kobak\thread: query: children post objects done. statistics done. building thread objects. 1679584637.740883 - 0.010583 (0.000109s): kobak\thread: query: thread objects built. 1679584637.740885 - 0.010585 (0.000002s): kobak\thread: query: setting up references/backlinks 1679584637.740926 - 0.010626 (0.000041s): kobak\post: get_posts: querying out-of-thread quotes 1679584637.741336 - 0.011036 (0.000410s): kobak\post: get_posts: applying quote backlinks to posts 1679584637.741459 - 0.011159 (0.000123s): kobak\thread: query: finished. 1679584637.741495 - 0.011195 (0.000036s): kobak\plugins: finished running 3 actions for hook "setup_html" 1679584637.741500 - 0.011200 (0.000005s): kobak\current: finished setting up all HTML vars 1679584637.741502 - 0.011202 (0.000002s): start rendering html 1679584637.741565 - 0.011265 (0.000063s): loading index 1679584637.741615 - 0.011315 (0.000050s): called header.php 1679584637.741669 - 0.011369 (0.000054s): kobak\plugins: checking actions for hook "header_meta" 1679584637.741749 - 0.011449 (0.000080s): kobak\plugins: finished running 4 actions for hook "header_meta" 1679584637.741893 - 0.011593 (0.000144s): kobak\cache: loading cache file: kobak_banners 1679584637.741899 - 0.011599 (0.000006s): kobak\cache: checking cache file: kobak_banners 1679584637.742177 - 0.011877 (0.000278s): rendering thread summary 118026 1679584637.742185 - 0.011885 (0.000008s): rendering reply 118026 1679584637.742262 - 0.011962 (0.000077s): kobak\kmedia: setting up new instance 1679584637.742267 - 0.011967 (0.000005s): kobak\kmedia: finished setup 1679584637.742305 - 0.012005 (0.000038s): rendering reply 118163 1679584637.742331 - 0.012031 (0.000026s): rendering reply 118164 1679584637.742348 - 0.012048 (0.000017s): rendering reply 118165 1679584637.742374 - 0.012074 (0.000026s): rendering thread summary 118149 1679584637.742381 - 0.012081 (0.000007s): rendering reply 118149 1679584637.742433 - 0.012133 (0.000052s): rendering reply 118151 1679584637.742472 - 0.012172 (0.000039s): rendering reply 118154 1679584637.742492 - 0.012192 (0.000020s): rendering thread summary 117901 1679584637.742495 - 0.012195 (0.000003s): rendering reply 117901 1679584637.742550 - 0.012250 (0.000055s): rendering reply 118116 1679584637.742570 - 0.012270 (0.000020s): rendering reply 118118 1679584637.742584 - 0.012284 (0.000014s): rendering reply 118130 1679584637.742600 - 0.012300 (0.000016s): rendering thread summary 117176 1679584637.742602 - 0.012302 (0.000002s): rendering reply 117176 1679584637.742647 - 0.012347 (0.000045s): rendering reply 117759 1679584637.742692 - 0.012392 (0.000045s): rendering reply 117958 1679584637.742736 - 0.012436 (0.000044s): rendering reply 117959 1679584637.742775 - 0.012475 (0.000039s): rendering thread summary 117935 1679584637.742785 - 0.012485 (0.000010s): rendering reply 117935 1679584637.742842 - 0.012542 (0.000057s): rendering reply 117947 1679584637.742882 - 0.012582 (0.000040s): rendering reply 117950 1679584637.742928 - 0.012628 (0.000046s): rendering reply 117951 1679584637.742960 - 0.012660 (0.000032s): rendering thread summary 117819 1679584637.742965 - 0.012665 (0.000005s): rendering reply 117819 1679584637.743060 - 0.012760 (0.000095s): rendering reply 117837 1679584637.743085 - 0.012785 (0.000025s): rendering reply 117839 1679584637.743104 - 0.012804 (0.000019s): rendering reply 117844 1679584637.743168 - 0.012868 (0.000064s): rendering thread summary 117429 1679584637.743173 - 0.012873 (0.000005s): rendering reply 117429 1679584637.743237 - 0.012937 (0.000064s): rendering reply 117434 1679584637.743255 - 0.012955 (0.000018s): rendering reply 117797 1679584637.743268 - 0.012968 (0.000013s): rendering reply 117806 1679584637.743289 - 0.012989 (0.000021s): rendering thread summary 117773 1679584637.743292 - 0.012992 (0.000003s): rendering reply 117773 1679584637.743339 - 0.013039 (0.000047s): rendering reply 117803 1679584637.743357 - 0.013057 (0.000018s): rendering reply 117804 1679584637.743385 - 0.013085 (0.000028s): rendering reply 117805 1679584637.743402 - 0.013102 (0.000017s): rendering thread summary 117741 1679584637.743411 - 0.013111 (0.000009s): rendering reply 117741 1679584637.743456 - 0.013156 (0.000045s): rendering reply 117770 1679584637.743479 - 0.013179 (0.000023s): rendering reply 117771 1679584637.743494 - 0.013194 (0.000015s): rendering reply 117772 1679584637.743510 - 0.013210 (0.000016s): rendering thread summary 117651 1679584637.743514 - 0.013214 (0.000004s): rendering reply 117651 1679584637.743569 - 0.013269 (0.000055s): rendering reply 117738 1679584637.743596 - 0.013296 (0.000027s): rendering reply 117739 1679584637.743617 - 0.013317 (0.000021s): rendering reply 117740 1679584637.743634 - 0.013334 (0.000017s): rendering thread summary 117649 1679584637.743636 - 0.013336 (0.000002s): rendering reply 117649 1679584637.743696 - 0.013396 (0.000060s): rendering reply 117681 1679584637.743727 - 0.013427 (0.000031s): rendering reply 117682 1679584637.743763 - 0.013463 (0.000036s): rendering reply 117683 1679584637.743781 - 0.013481 (0.000018s): rendering thread summary 117605 1679584637.743784 - 0.013484 (0.000003s): rendering reply 117605 1679584637.743821 - 0.013521 (0.000037s): rendering reply 117643 1679584637.743843 - 0.013543 (0.000022s): rendering reply 117647 1679584637.743879 - 0.013579 (0.000036s): rendering reply 117648 1679584637.743897 - 0.013597 (0.000018s): rendering thread summary 117620 1679584637.743900 - 0.013600 (0.000003s): rendering reply 117620 1679584637.743933 - 0.013633 (0.000033s): rendering reply 117621 1679584637.743969 - 0.013669 (0.000036s): rendering thread summary 117503 1679584637.743973 - 0.013673 (0.000004s): rendering reply 117503 1679584637.744014 - 0.013714 (0.000041s): rendering reply 117602 1679584637.744045 - 0.013745 (0.000031s): rendering reply 117603 1679584637.744062 - 0.013762 (0.000017s): rendering reply 117604 1679584637.744078 - 0.013778 (0.000016s): rendering thread summary 117184 1679584637.744081 - 0.013781 (0.000003s): rendering reply 117184 1679584637.744134 - 0.013834 (0.000053s): rendering reply 117439 1679584637.744153 - 0.013853 (0.000019s): rendering reply 117564 1679584637.744176 - 0.013876 (0.000023s): rendering reply 117565 1679584637.744342 - 0.014042 (0.000166s): called footer.php 1679584637.744639 - 0.014339 (0.000297s): kobak\plugins: checking actions for hook "footer_meta" 1679584637.744699 - 0.014399 (0.000060s): kobak\plugins: finished running 7 actions for hook "footer_meta" 1679584637.744700 - 0.014400 (0.000001s): completed rendering most of the html 1679584637.744746 - 0.014446 (0.000046s): starting debug 1679584637.745147 - 0.014847 (0.000401s): starting debug_t
|
SQL statistics:
| time taken: 0.00063705 | SELECT *, ( SELECT GROUP_CONCAT(DISTINCT `kobaboardban`.`boardid` ORDER BY `kobaboardban`.`boardid` SEPARATOR ',') FROM `kobaboardban` WHERE `banid` = `id` GROUP BY `banid` ) AS `active_boards` FROM `kobaban` WHERE ( (`iplong1` = '03ecd18a') OR (`iplong1` <= '03ecd18a' AND '03ecd18a' <= `iplong2`) ) AND `type` IN(-1,0,1,2,3) AND (`id` IN ( SELECT `banid` FROM `kobaboardban` WHERE `boardid` IN(12) ) OR `global` = 1) ORDER BY `type`,`expiration` DESC | no rows found or affected (prepared query) |
| time taken: 0.00100398 | SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid, s.total_posts, s.total_files, s.total_image, s.total_audio, s.total_video, s.total_swf, s.unique_ip, s.unique_user FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`, `pin`, `bumped`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid LEFT JOIN `kobapoststats` s on p.boardid = s.boardid and p.postid = s.threadid WHERE p.`boardid` = 12 AND p.`parentid` = 0 AND p.`deleted` = 0 ORDER BY `pin` desc, `bumped` desc LIMIT 30, 15 | no error |
| time taken: 0.00523496 | ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '118026' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '118149' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117901' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117176' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117935' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117819' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117429' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117773' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117741' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117651' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117649' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117605' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117620' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117503' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) UNION ALL ((SELECT p.*, r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid FROM `kobapost` p USE INDEX(`boardid`, `parentid`, `deleted`) LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid WHERE p.`boardid` = '12' AND p.`parentid` = '117184' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) | no error |
| time taken: 0.00037384 | SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE (`boardid` = 12 AND `postid` IN(117436,117599,117642,117679,117736,117742,117802,117945,117943,118115,118115,118153,118153)) AND `deleted` = 0 | no error |
actions:
| before_validation | actions: 1 | start: 1679584637.73159200 | end: 1679584637.73160500 | took (total): 0.000013 |
| footer_meta | actions: 7 | start: 1679584637.74464200 | end: 1679584637.74469600 | took (total): 0.000054 |
| header_meta | actions: 4 | start: 1679584637.74167300 | end: 1679584637.74174600 | took (total): 0.000073 |
| setup_html | actions: 3 | start: 1679584637.73342600 | end: 1679584637.74149100 | took (total): 0.008065 |
| validation | actions: 2 | start: 1679584637.73164000 | end: 1679584637.73337400 | took (total): 0.001734 |
Rewrite/redirect rules:
| Redirect | /^([a-z_\-0-9]*)\/0.html(?:\?.*)?$/ | $matches[1]\/ | 302 |
| Redirect | /^([a-z_\-0-9]*)\/1.html(?:\?.*)?$/ | $matches[1]\/ | 302 |
| Rewrite: | /^([a-z_\-0-9]*)\/(\d\w*)s.png$/ | /$matches[1]/thumbs/$matches[2]s.png | |
| Rewrite: | /^([a-z_\-0-9]*)\/?(?:\?.*)?$/ | index.php?section=index&board=$matches[1] | |
| Rewrite: | /^([a-z_\-0-9]*)\/([0-9]*)\.html(?:\?.*)?$/ | index.php?section=index&board=$matches[1]&pagenumber=$matches[2] | |
| Rewrite: | /^([a-z_\-0-9]*)\/catalog\.html(?:\?.*)?$/ | index.php?section=catalog&board=$matches[1] | |
| Rewrite: | /^([a-z_\-0-9]*)\/t([0-9]*)\.(html|json|rss)(?:\?.*)?$/ | index.php?section=thread&board=$matches[1]&thread=$matches[2]&ext=$matches[3] | |
| Rewrite: | /^([a-z_\-0-9]*)\/posts_feed\.rss$/ | index.php?section=posts_feed&board=$matches[1]&ext=rss | |
| Rewrite: | /^([a-z_\-0-9]*)\/threads_feed\.rss$/ | index.php?section=threads_feed&board=$matches[1]&ext=rss | |
| Rewrite: | /^latest_posts\.rss$/ | index.php?section=latest_posts&ext=rss | |
| Rewrite: | /^latest_threads\.rss$/ | index.php?section=latest_threads&ext=rss | |
| Rewrite: | /^latest_nsfw_posts\.rss$/ | index.php?section=latest_nsfw_posts&ext=rss | |
| Rewrite: | /^latest_nsfw_threads\.rss$/ | index.php?section=latest_nsfw_threads&ext=rss |
rules in htaccess format:
RewriteRule ^([a-z_\-0-9]*)\/0.html(?:\?.*)?$ $1/ [R=302,L,QSA] RewriteRule ^([a-z_\-0-9]*)\/1.html(?:\?.*)?$ $1/ [R=302,L,QSA] RewriteRule ^([a-z_\-0-9]*)\/(\d\w*)s.png$ /$1/thumbs/$2s.png [L,QSA] RewriteRule ^([a-z_\-0-9]*)/(?:\?.*)?$ index.php?section=index&board=$1 [L,QSA] RewriteRule ^([a-z_\-0-9]*)\/([0-9]*)\.html(?:\?.*)?$ index.php?section=index&board=$1&pagenumber=$2 [L,QSA] RewriteRule ^([a-z_\-0-9]*)\/catalog\.html(?:\?.*)?$ index.php?section=catalog&board=$1 [L,QSA] RewriteRule ^([a-z_\-0-9]*)\/t([0-9]*)\.(html|json|rss)(?:\?.*)?$ index.php?section=thread&board=$1&thread=$2&ext=$3 [L,QSA] RewriteRule ^([a-z_\-0-9]*)\/posts_feed\.rss$ index.php?section=posts_feed&board=$1&ext=rss [L,QSA] RewriteRule ^([a-z_\-0-9]*)\/threads_feed\.rss$ index.php?section=threads_feed&board=$1&ext=rss [L,QSA] RewriteRule ^latest_posts\.rss$ index.php?section=latest_posts&ext=rss [L,QSA] RewriteRule ^latest_threads\.rss$ index.php?section=latest_threads&ext=rss [L,QSA] RewriteRule ^latest_nsfw_posts\.rss$ index.php?section=latest_nsfw_posts&ext=rss [L,QSA] RewriteRule ^latest_nsfw_threads\.rss$ index.php?section=latest_nsfw_threads&ext=rss [L,QSA]Current time:
2023-03-23 08:17:17