I just remember the last section bit where Conan & Sonoko(?) forced to make emergency landing on some harbor(?). I think the real Pilot & Co-Pilot got poisoned by accident because they are kissing the victim hand without their gloves.
Hi guys, It's my first time using the spoiler markdown and I'm having problems with the newline. The text on the spoiler markdown looks like a big wall of text and I want to break it into paragraphs. The post I'm talking about is my answer to the question above.
@Keale yeh spoiler tags are annoying to break line. with quotes you can leave the line between 2 > blank and it'll work find. if you do that with spoilers it turns into a quote
Yeah. That was what I was trying at first, but I was getting frustrated that it was not working. I then glanced at the note on the side: > Leave two spaces at the end for the next line So I did that and voila, it worked! :)
@ʞɹɐzǝɹ jokes aside that user just keeps doing the wrong thing and not own up to it. you delete a second answer which should have been an edit to their original answer and do they do. delete their original answer and say you a bad mod
@ʞɹɐzǝɹ ahhh ok. i thought i remember Bella saying something about her sister having something to do with the plague and going though DeRoso's Castle it appears Yoko was claiming she was the cause
unless that girl was sick before being brought to the shrine
@ToshinouKyouko but atleast this time it was unrelated. last thing i remember that user did the last time they were here was spamming their question link by posting in the comments of questions which some had nothing to do with censorship
Here link to the video on coub
I tried finding the name using Google picture search, but no luck.
Please help to find the name, I don't know if it is a game or manga/anime.
I was watching this episode of Naruto here https://www.youtube.com/watch?v=_qkH4mxtsaw
I would like to know why the quality and style of the anime differs from the regular one?
Can anyone please explain?
Thanks
I think a good percentage of people here have computer related jobs :) dunno if there is a correlation there, but most of my friends who are good programmers are also anime fans
Nerds lol. I think of myself as a person who loves learning that's all. I always like learning new things that's why I'm up and around browsing different SE Networks when my boss is not looking :)
and now I'm currently stuck in a bug that's why I'm horsing around here :P
Continuing the "question got favorited multiple times by the same user" from yesterday, I found a meta discussion on this: meta.stackexchange.com/questions/197249/… and it seems SE doesn't know how to reproduce it
This SQL query shows that my Angel Beats! question is one out of only three on Anime & Manga that got double-favorited.
@Memor-X But I'm curious what the creationdate in votes does, the minimum creation date for my post is 2015-10-22 00:00:00 while the maximum is 2016-01-01 00:00:00
@Gao i think maybe it's only storing the date in a datetime field....or it's quite the stroke of luck for 2 of them to be favorited at exactly midnight
otherwise generally storing the datetime stamp for a row is just for debugging. sometimes you also have a modify date which gets altered by an update trigger while the create date remains untouched
@Gao since you have the post links maybe update the query to do a SELECT * and filter by PostId IN(the 3 post links you got). since your doing a group by i'm curious if the pairs are identical or not
btw I wrote this yesterday: data.stackexchange.com/anime/query/487568/… if anyone's interested. looks rather verbose and inefficient, but hey i'm just a beginner at writing sql. If you improve it please let me know
janbert's ones what what i was kinda expecting but Angelplayer's messes up the pattern, so i can't say that the javascript that's used to update the database fired twice
@Gao yeh, slightly odd that the duplicate is then aswell.....but since SE doesn't record the time i can't tell if there was an error and it defaulted to the start of 2016
it's for this reason that if your going to have a create date you should include time as well
@Gao likewise. the only thing i can think of which could cause this is whatever it uses to check if a question is favorited or not didn't work and when a user went to the question they saw it wasn't favorited and went to favorite it and because the check didn't work the first time it allows the insert
Man, why does SE auto save and increment revision number every time i change something and run it, without any option to delete it or turn this behavior off?
@Gao not exactly. that involves unfavoriting which would be a DELETE query. when you unfvaorite and go back to unfavorite again the delete query would do nothing. i just tried using the case to preserve a question as if it haddn't been favorited, went back to a cached version of my favorite list, unfavoirte and refavorite then go forward and favorite again and it didn't reault it the favoirte count being 2
i think also the script that executes the database query, determining if to use INSERT or DELETE must have failed aswell
ofcause without being able to see the code i can only speculate but maybe when we unfavoirte it inserts aswell and the DELETE ends up removing both
ie
insert into database
if already favorited
delete
end
the if statement could be calling a function that checks for the duplicates and then deletes if there was and the duplicates we are seeing is when there was a failure in that of some sort
@Memor-X isn't that bad design? the database shouldn't allow duplicate in the first place, so it doesn't even need a function to check, it would just fail if insert a duplicate, no?
you'll notice that all the duplicates have a unique id. assuming my speculation is right in how it favoirtes and unfavorites i assume the query you used before, grouping and filtering by count might be a similar to how the if statement checks
Well, I just asked someone if we're still unable to repro that. It's not a really pressing thing anyway, so I don't expect anyone to dive into that right away.
It is known that Franky is powered by cola in his stomach fridge, so if other liquids are used, his behaviour goes through drastic changes.
So far, I'm aware of two cases in Enies Lobby and one in the Future Kingdom, right before the Impel Down events.
Is someone able to provide a complete list?
Spoilers ahead!
In the Sparks Liner High ending of Heaven's Feel, Shirou ends up as a vegetable, since his mind has completely deteriorated.
However, since he was lying next to Saber, could his deteriorated brain have been repaired by Avalon? Avalon is supposed to have ultimate regenerative pro...
I just remember the last section bit where Conan & Sonoko(?) forced to make emergency landing on some harbor(?). I think the real Pilot & Co-Pilot got poisoned by accident because they are kissing the victim hand without their gloves.
Here link to the video on coub
I tried finding the name using Google picture search, but no luck.
Please help to find the name, I don't know if it is a game or manga/anime.
I was watching this episode of Naruto here https://www.youtube.com/watch?v=_qkH4mxtsaw
I would like to know why the quality and style of the anime differs from the regular one?
Can anyone please explain?
Thanks
It is known that Franky is powered by cola in his stomach fridge, so if other liquids are used, his behaviour goes through drastic changes.
So far, I'm aware of two cases in Enies Lobby and one in the Future Kingdom, right before the Impel Down events.
Is someone able to provide a complete list?
Spoilers ahead!
In the Sparks Liner High ending of Heaven's Feel, Shirou ends up as a vegetable, since his mind has completely deteriorated.
However, since he was lying next to Saber, could his deteriorated brain have been repaired by Avalon? Avalon is supposed to have ultimate regenerative pro...
