/a/ - Avatar

Board stats: 2024 total posts, 56 threads

save file
image:140606677800.jpg(29kB , 332x363 , korrainterview2[1].jpeg)
I just had a dream where I was watching Book 4 of the series and out of nowhere it ended up with Korra being poisoned to death which shocked everyone besides the other characters. This also wasn't the final season as there was a Book 5 which showed a baby being born thus implying the new Avatar and confirming the previous one's death. While most of the book focused on the characters cooping without their friend, the new Avatar was put through the items test by the White Lotus Society and soon training with his earthbending.

This new Avatar is just as headstrong as Korra was leading to some interesting confrontations with the other characters, especially Tenzin who was probably devastated the most by the news of Korra's passing. Jinora doesn't believe the news so she does her spirit body trick to go see for herself. Suyin who was present with the other characters for whatever reason said she was currently in the infirmary of Zaofu. Then something weird happened, Jinora's spirit body was unable to pass through the walls of the building which lead her to come back only to hear Suyin say something about how the type of metal used for the walls of the city buildings were so strong that it can keep out spiritual energy. I think they even said it was a layer of platinum, lead, and silver for whatever reason leading to me questioning why the hell silver is always used for supernatural elements. Suyin tells Jinora to go through the flooring as it was constructed using very basic metal.

Next we see Jinora trying to get through to the infirmary by sinking into the ground trying to get passed the thick walls buried beneath until finally she was able to make it through only to see Avatar Korra laying their in bed motionless without her stomach expanding and disbanding. It was then Jinora knew the news were true. She took a moment to kneel beside her friend as she started to cry as she reached her hands out to Korra's before she returned to her body.
...
message too long. Click here to view the full post.
No.117557
Anonymous
>>117555
I hope this doesn't mean SJW are going to throw a fit about Bryke viewing brown people as low as dogs or some other ridiculous extrapolation.
No.117558
A New Spiritual Age
>>117557
>implying Tumblr are people
No.117559
Anonymous
>>117557
They kinda did back when book 1 was airing.
No.117553
A New Spiritual Age
Replies:>>117554
save file
image:140608215100.jpg(603kB , 1920x1080 , spirits10-648[1].jpg)
Why was this episode cute?
save file
image:140608224500.jpg(66kB , 1920x1080 , spirits10-1609[1].jpg)
>>117553
Posting in a cute thread.
save file
image:140608203400.jpg(732kB , 1920x1080 , spirits9-458[1].jpg)
Why does it feel like the relationship between Tenzin and Korra has advanced to that of Obi-Wan and Anakin?
They seem to be standing on equal ground now.

Did it take Korra learning about what it means to be the Avatar from Wan and Tenzin learning from his father to not be his father to make this happen?
save file
image:140270429800.jpg(444kB , 613x793 , 1383971394.rings1234_avatarball.jpg)
Does anyone still draw Avatar art?
No.117502
T4 was here
They sure do!
On /pco/~
No.117447
KORRA BOOK 3: EPISODES 4 AND 5 DISCUSSION THREADAnonymous
save file
image:140496050500.jpg(37kB , 766x428 , unintentional_metaphor.jpg)
July 11th, 2014: In Harm’s Way & The Metal Clan

Kai has found himself in deep doodoo and Korra has been okie-doked while trouble is brewing in the North Pole! What will happen next! We'll find out on Friday night.
No.117499
Bunker !OFOzVPOG0g
Aang took him on as his pupil maybe before he settled down into a family. I'd like to see what drove them apart. Could be a show in itself.
No.117500
Anonymous
>>117498
Didn't he get arrested 13 years ago? You'd think if he killed Aang they'd have done their damn best to capture him ASAP, not after he tried to off the next Avatar.
No.117501
Bunker !OFOzVPOG0g
I think maybe a Clone Wars type series could work quite well. if Z turns out to be someone Aang trained for a few years in his early adulthood.
Replies:>>117445
save file
image:140375515400.jpg(755kB , 1920x1080 , spirits10-1244[1].jpg)
> tfw you'd never go on a life changing spiritual journey much like Korra did
No.117444
Daniel FUCKING Murphy, Hitting Machine
>>117443


Had to post these while covering teh screen.

TAG YOUR FUCKING SPOILERS. NOT EVERYONE HAS SEEN OR WANTED TO SEE THE LEAKS IN SHITTY SUBTITLES.
...
message too long. Click here to view the full post.
Replies:>>117446
save file
image:140479774000.png(173kB , 383x287 , rf Korra WAT no text.png)
>>117300
But I am on a life-changing spiritual journey. My life is currently changing from crap to slightly less crap.
No.117446
Bunker !OFOzVPOG0g
>>117445
Best most of us can hope for really
save file
image:140376600800.jpg(255kB , 500x500 , The-Last-Airbender-and-The-Legend-of-Korra-Characters-avatar-the-legend-of-korra-34273380-500-500[1].jpg)
You know, for a show that didn't have enough time to go into character development much like it's parent did. After re-watching Books 1 and 2 in 2 days I am suddenly feeling like I'm going to miss these characters when the show concludes in Book 4. How is this possible?
No.117378
Anonymous
Replies:>>117404
>>117377
You apparently have very low standards for what counts as character development if you consider "Getting interested in one single case but not changing your personality even one iota" to be character development. And he was always interested in other people. C.f. how he went to his landlord's performance for no other reason than that his landlord wanted him there.
No.117404
EspanolBot
Replies:>>117405
>>117378

He DID change his personality though, he went from being invested mostly in himself (and bowling) to getting invested in other people, even ones that he really didn't have much of a stake in.

Would the Dude at the beginning of the movie be bothered to help the older Lebowski back into his wheelchair after they knock him onto the floor during the "Accusing Parlor" scene? In the beginning he was more concerned with getting a new carpet and possible some additional cash, later he gets invested for reasons other than just getting a paycheque.
No.117405
Anonymous
>>117404
>Would the Dude at the beginning of the movie be bothered to help the older Lebowski back into his wheelchair after they knock him onto the floor during the "Accusing Parlor" scene? In the beginning he was more concerned with getting a new carpet and possible some additional cash, later he gets invested for reasons other than just getting a paycheque.
Yes, he would. He was shown to be willing to do things just because they made other people happy or more comfortable in the beginning of the movie, when he went to his Landlord's show. The Dude was the same person from beginning to end, like *most* Coen Brothers protagonists--the Coen Brothers are one of the most clear modern examples of storytellers who understand that character development isn't necessary to a good movie.
save file
image:140392922300.png(157kB , 500x283 , tumblr_inline_n6vfpsvcCU1r525wt[1].png)
Oh yeah, this character is going to be a lot of fun.
No.117349
Daniel FUCKING Murphy, Hitting Machine
Replies:>>117354
>>117343

He got captured by The Dai motherfucking Li. He's going to go through some changes really quick. *Shudder*
No.117350
Anonymous
Does anyone else think Korra was reminded about what she learned of Avatar Wan upon meeting the boy?
No.117354
EspanolBot
>>117349

To good for 'em, I say! *waves cane in the air*
Replies:>>117313
save file
image:140368630200.jpg(411kB , 1920x1080 , Akira.street.scene_.jpg)
As the penultimate season of Legend of Korra approaches, it goes me wondering. If Bryke were to make a third Avatar series, what would it be like?

Would it continue the linear progression from the previous two shows, from the proto-steampunk world of Aang to the dieselpunk world of Korra to a possibly cyberpunk world of the Avatar that follows her? Or would they go backwards, as the Wan two-parter established that there is also a ton of potential in the Avatars prior to Aang and Korra that they could go with?

Personally, I think that considering the influence of Miyazaki in the prior seasons, particularly in Airbender, it would be interesting to see Akira and Ghost in the Shell influences in the Avatarverse. Plus it would fit with the logical progression of the series, with science and technology slowly surplanting the mystical as time marches on. And maybe it combines in odd ways, maybe new spirits emerge from the environment, so rather than like panda-spirits they end up with gremlin-ish things that adapted to intefere with machinery or something.
...
message too long. Click here to view the full post.
No.117313
Anonymous
>>117289
Avatar the Last Airbender wasn't steampunk at all.
The Legend of Korra would be the steampunk series by all definition of the word.
No.117317
Anonymous
>>117313
>all definitions

Really? LoK seems to definitely lack the 'punk' elements if you ask me.
save file
image:140385499400.png(918kB , 1280x720 , 13374602156.png)
>>117313

Airbender was starting to undergo an industrial revolution, with the introduction of increasing amount of steampowered devices, such as the Drill, that car thing Azula used in the Chase, the jetskis from the Painted Lady episode, the airships etc. etc. Thus they were heading into a world with steampunk technology, even if they weren't wearing the quasi-Victorian clothes that were associated with the genre (because people are lazy and assume that all steampunk is either American or English-based).

Legend of Korra was deliberately based in a world set in the 1920s and 30s, and the tech there had moved on from the steampowered stuff of Airbender (bypassing the bulk of its implimentation) and straight into a world powered by electricity and petrol (such as the radios, cars, mech, planes etc. etc.) The subgenre this is normally associated with is dieselpunk, and examples of this include Captain America: the First Avenger, Bioshock to an extent, the Rocketeer, Laputa: Castle in the Sky etc. etc. etc.
...
message too long. Click here to view the full post.
No.117191
Avatar AMV ThreadAnonymous
save file
image:140143684700.jpg(88kB , 900x654 , korra__s_breakdown_by_friedchicken365-d4yecx5.jpg)
Found this nice Korra AMV set to Portal 2's Exile/Villify

Legend of Korra AMV - Exile, Vilifyyoutube thumb

Pic semi-related
No.117277
Anonymous
Replies:>>117279
This song was from Portal 2?
No.117279
Avatar AMV Thread
>>117277

It played on several radios in areas where Rattman drew messages for Chell.
save file
image:140360876500.jpg(128kB , 893x587 , Legend-of-Korra[1].jpg)
Does anyone know of any good AMV tributes for Wan, Aang, and Korra?
Maybe even a good one dedicated to all three of them?

There should be something to honor the three Avatars who changed their world in big ways.
No.117260
Anonymous
Pic is unrelated.
No.117261
Anonymous
Oh and favorably any that use songs from the Kick-Ass (first one) soundtrack.

load average: array(3) { [0]=> float(0.21) [1]=> float(0.3) [2]=> float(0.39) }

total load time: 0.0181s

code time: 0.0069s;

query time: 0.0112s

code time percentage: 38.1215%

query time percentage: 61.8785%

queries: 4

memory usage: 1.16MB

memory peak: 1.2MB


Controls:

sectionstring(5) "index"
pagenumberstring(1) "4"
extstring(4) "html"
extendedparamsarray(1) { ["board"]=> string(1) "a" }
langNULL

Time log:

1679408655.2854: beginning

1679408655.28 - 0.000000 (0.000000s): script started

1679408655.285875 - 0.000475 (0.000475s): core files loaded

1679408655.285950 - 0.000550 (0.000075s): kobak\debug: setting up new instance

1679408655.285963 - 0.000563 (0.000013s): kobak\debug: finished setup

1679408655.285968 - 0.000568 (0.000005s): kobak\kcfg: setting up new instance

1679408655.286016 - 0.000616 (0.000048s): kobak\kcfg: finished setup

1679408655.286019 - 0.000619 (0.000003s): kobak\controls: setting up new instance

1679408655.286025 - 0.000625 (0.000006s): kobak\controls: finished setup

1679408655.286027 - 0.000627 (0.000002s): kobak\modules: setting up new instance

1679408655.286029 - 0.000629 (0.000002s): kobak\modules: finished setup

1679408655.286070 - 0.000670 (0.000041s): kobak\modules: loading module kobak

1679408655.286073 - 0.000673 (0.000003s): kobak\pages: setting up new instance

1679408655.286080 - 0.000680 (0.000007s): kobak\pages: finished setup

1679408655.286083 - 0.000683 (0.000003s): kobak\plugins: setting up new instance

1679408655.286085 - 0.000685 (0.000002s): kobak\plugins: finished setup

1679408655.286222 - 0.000822 (0.000137s): kobak\kobak: setting up new instance

1679408655.286226 - 0.000826 (0.000004s): kobak\kobak: finished setup

1679408655.286229 - 0.000829 (0.000003s): kobak\cache: setting up new instance

1679408655.286231 - 0.000831 (0.000002s): kobak\cache: finished setup

1679408655.286232 - 0.000832 (0.000001s): kobak\cache: loading cache file: kobak_cache

1679408655.286238 - 0.000838 (0.000006s): kobak\cache: checking cache file: kobak_cache

1679408655.286364 - 0.000964 (0.000126s): kobak\current: setting up new instance

1679408655.286369 - 0.000969 (0.000005s): kobak\current: finished setup

1679408655.286371 - 0.000971 (0.000002s): kobak\errors: setting up new instance

1679408655.286376 - 0.000976 (0.000005s): kobak\errors: finished setup

1679408655.286683 - 0.001283 (0.000307s): kobak\modules: finished loading module "kobak"

1679408655.286689 - 0.001289 (0.000006s): kobak\modules: finished loading 1 module(s)

1679408655.286694 - 0.001294 (0.000005s): kobak\current: creating default rewrite rules

1679408655.286698 - 0.001298 (0.000004s): kobak\current: starting validation of current section

1679408655.286707 - 0.001307 (0.000009s): kobak\plugins: checking actions for hook "before_validation"

1679408655.286733 - 0.001333 (0.000026s): kobak\plugins: finished running 1 actions for hook "before_validation"

1679408655.286738 - 0.001338 (0.000005s): kobak\current: finished validating section

1679408655.286744 - 0.001344 (0.000006s): kobak\current: finished validating prerequisites

1679408655.286749 - 0.001349 (0.000005s): kobak\current: finished validating optional inputs

1679408655.286753 - 0.001353 (0.000004s): kobak\plugins: checking actions for hook "validation"

1679408655.286780 - 0.001380 (0.000027s): KOBAK BBS: validating board

1679408655.286827 - 0.001427 (0.000047s): kobak\ban: query: querying posts

1679408655.286836 - 0.001436 (0.000009s): kobak\db: setting up new instance

1679408655.286839 - 0.001439 (0.000003s): kobak\db: Attempting to connect to database

1679408655.287428 - 0.002028 (0.000589s): kobak\db: Successfully connected to database

1679408655.287437 - 0.002037 (0.000009s): kobak\db: finished setup

1679408655.288135 - 0.002735 (0.000698s): KOBAK BBS: loading board specific plugins

1679408655.288392 - 0.002992 (0.000257s): KOBAK BBS: finished loading board specific plugins

1679408655.288407 - 0.003007 (0.000015s): KOBAK BBS: validating pagenumber

1679408655.288424 - 0.003024 (0.000017s): kobak\plugins: finished running 2 actions for hook "validation"

1679408655.288443 - 0.003043 (0.000019s): kobak\current: Template file found

1679408655.288446 - 0.003046 (0.000003s): kobak\current: setting up HTML vars

1679408655.288449 - 0.003049 (0.000003s): kobak\html: setting up new instance

1679408655.288463 - 0.003063 (0.000014s): kobak\html: finished setup

1679408655.288466 - 0.003066 (0.000003s): kobak\current: setting up per-page HTML vars

1679408655.288473 - 0.003073 (0.000007s): kobak\plugins: checking actions for hook "setup_html"

1679408655.288525 - 0.003125 (0.000052s): KOBAK BBS: finding thread starters

1679408655.288532 - 0.003132 (0.000007s): kobak\thread: query: start

1679408655.288542 - 0.003142 (0.000010s): kobak\thread: query: getting parents.

1679408655.289475 - 0.004075 (0.000933s): kobak\thread: query: parents queried. querying children.

1679408655.299112 - 0.013712 (0.009637s): kobak\thread: query: children query finished. building children post objects.

1679408655.299573 - 0.014173 (0.000461s): kobak\thread: query: children post objects done. looking up statistics.

1679408655.299583 - 0.014183 (0.000010s): kobak\thread: query: children post objects done. statistics done. building thread objects.

1679408655.299681 - 0.014281 (0.000098s): kobak\thread: query: thread objects built.

1679408655.299685 - 0.014285 (0.000004s): kobak\thread: query: setting up references/backlinks

1679408655.299725 - 0.014325 (0.000040s): kobak\post: get_posts: querying out-of-thread quotes

1679408655.300102 - 0.014702 (0.000377s): kobak\post: get_posts: applying quote backlinks to posts

1679408655.300232 - 0.014832 (0.000130s): kobak\thread: query: finished.

1679408655.300280 - 0.014880 (0.000048s): kobak\plugins: finished running 3 actions for hook "setup_html"

1679408655.300285 - 0.014885 (0.000005s): kobak\current: finished setting up all HTML vars

1679408655.300289 - 0.014889 (0.000004s): start rendering html

1679408655.300367 - 0.014967 (0.000078s): loading index

1679408655.300405 - 0.015005 (0.000038s): called header.php

1679408655.300414 - 0.015014 (0.000009s): kobak\plugins: checking actions for hook "header_meta"

1679408655.300494 - 0.015094 (0.000080s): kobak\plugins: finished running 4 actions for hook "header_meta"

1679408655.300636 - 0.015236 (0.000142s): kobak\cache: loading cache file: kobak_banners

1679408655.300645 - 0.015245 (0.000009s): kobak\cache: checking cache file: kobak_banners

1679408655.300971 - 0.015571 (0.000326s): rendering thread summary 117541

1679408655.300978 - 0.015578 (0.000007s): rendering reply 117541

1679408655.301051 - 0.015651 (0.000073s): kobak\kmedia: setting up new instance

1679408655.301059 - 0.015659 (0.000008s): kobak\kmedia: finished setup

1679408655.301147 - 0.015747 (0.000088s): rendering reply 117557

1679408655.301179 - 0.015779 (0.000032s): rendering reply 117558

1679408655.301199 - 0.015799 (0.000020s): rendering reply 117559

1679408655.301221 - 0.015821 (0.000022s): rendering thread summary 117553

1679408655.301225 - 0.015825 (0.000004s): rendering reply 117553

1679408655.301271 - 0.015871 (0.000046s): rendering reply 117554

1679408655.301317 - 0.015917 (0.000046s): rendering thread summary 117552

1679408655.301321 - 0.015921 (0.000004s): rendering reply 117552

1679408655.301368 - 0.015968 (0.000047s): rendering thread summary 117227

1679408655.301372 - 0.015972 (0.000004s): rendering reply 117227

1679408655.301419 - 0.016019 (0.000047s): rendering reply 117502

1679408655.301442 - 0.016042 (0.000023s): rendering thread summary 117447

1679408655.301446 - 0.016046 (0.000004s): rendering reply 117447

1679408655.301495 - 0.016095 (0.000049s): rendering reply 117499

1679408655.301526 - 0.016126 (0.000031s): rendering reply 117500

1679408655.301547 - 0.016147 (0.000021s): rendering reply 117501

1679408655.301577 - 0.016177 (0.000030s): rendering thread summary 117300

1679408655.301694 - 0.016294 (0.000117s): rendering reply 117300

1679408655.301749 - 0.016349 (0.000055s): rendering reply 117444

1679408655.301781 - 0.016381 (0.000032s): rendering reply 117445

1679408655.301819 - 0.016419 (0.000038s): rendering reply 117446

1679408655.302017 - 0.016617 (0.000198s): rendering thread summary 117308

1679408655.302023 - 0.016623 (0.000006s): rendering reply 117308

1679408655.302071 - 0.016671 (0.000048s): rendering reply 117378

1679408655.302095 - 0.016695 (0.000024s): rendering reply 117404

1679408655.302118 - 0.016718 (0.000023s): rendering reply 117405

1679408655.302145 - 0.016745 (0.000027s): rendering thread summary 117342

1679408655.302148 - 0.016748 (0.000003s): rendering reply 117342

1679408655.302202 - 0.016802 (0.000054s): rendering reply 117349

1679408655.302229 - 0.016829 (0.000027s): rendering reply 117350

1679408655.302247 - 0.016847 (0.000018s): rendering reply 117354

1679408655.302293 - 0.016893 (0.000046s): rendering thread summary 117289

1679408655.302297 - 0.016897 (0.000004s): rendering reply 117289

1679408655.302411 - 0.017011 (0.000114s): rendering reply 117313

1679408655.302437 - 0.017037 (0.000026s): rendering reply 117317

1679408655.302458 - 0.017058 (0.000021s): rendering reply 117320

1679408655.302533 - 0.017133 (0.000075s): rendering thread summary 117191

1679408655.302538 - 0.017138 (0.000005s): rendering reply 117191

1679408655.302587 - 0.017187 (0.000049s): rendering reply 117277

1679408655.302615 - 0.017215 (0.000028s): rendering reply 117279

1679408655.302639 - 0.017239 (0.000024s): rendering thread summary 117259

1679408655.302643 - 0.017243 (0.000004s): rendering reply 117259

1679408655.302689 - 0.017289 (0.000046s): rendering reply 117260

1679408655.302710 - 0.017310 (0.000021s): rendering reply 117261

1679408655.302880 - 0.017480 (0.000170s): called footer.php

1679408655.303158 - 0.017758 (0.000278s): kobak\plugins: checking actions for hook "footer_meta"

1679408655.303245 - 0.017845 (0.000087s): kobak\plugins: finished running 7 actions for hook "footer_meta"

1679408655.303248 - 0.017848 (0.000003s): completed rendering most of the html

1679408655.303279 - 0.017879 (0.000031s): starting debug

1679408655.303574 - 0.018174 (0.000295s): starting debug_t


1679408655.30405200: end


SQL statistics:

time taken: 0.00066900 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` = '12cd425d') OR (`iplong1` <= '12cd425d' AND '12cd425d' <= `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.00091004 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 45, 15 no error
time taken: 0.00925398 ((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` = '117541' 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` = '117553' 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` = '117552' 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` = '117227' 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` = '117447' 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` = '117300' 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` = '117308' 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` = '117342' 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` = '117289' 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` = '117191' 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` = '117259' AND p.`deleted` = '0' ORDER BY `postid` DESC LIMIT 3) ) no error
time taken: 0.00035501 SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE (`boardid` = 12 AND `postid` IN(117343,117377,117443,117498,117555)) AND `deleted` = 0 no error

actions:

before_validation actions: 1 start: 1679408655.28671100 end: 1679408655.28672900 took (total): 0.000018
footer_meta actions: 7 start: 1679408655.30316200 end: 1679408655.30324200 took (total): 0.000080
header_meta actions: 4 start: 1679408655.30041700 end: 1679408655.30049000 took (total): 0.000073
setup_html actions: 3 start: 1679408655.28847600 end: 1679408655.30027300 took (total): 0.011797
validation actions: 2 start: 1679408655.28675500 end: 1679408655.28841900 took (total): 0.001664

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-21 07:24:15