Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
OmnipotentEntity wrote:
So topic_replies holds $total_number_of_posts_in_thread - 1
I already know this.
This is what I use to fix the topics table whenever I do it.
$SQL = 'update topics t set'.
' topic_first_post_id=( select min(post_id) from posts p where p.topic_id=t.topic_id )'.
',topic_last_post_id=( select max(post_id) from posts p where p.topic_id=t.topic_id )'.
',topic_time=( select min(post_time) from posts p where p.topic_id=t.topic_id )'.
',topic_replies=( select count(post_id)-1 from posts p where p.topic_id=t.topic_id ) ';
print "$SQL;\n"; ForumExecute($SQL);
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
DeHackEd wrote:
Of course I do. It's needed for memcached, and microstorage uses it as of a few months ago to cache compressed data (the poor P166 couldn't keep up). You suggested I do this, didn't you?
It's just that I didn't expect you to remember a particular library memcached happens to use.
EDIT: Okay, added NAT checking to the tracker now.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
DeHackEd wrote:
You're using libevent, nice.
Yeah, libevent is nice. I'm surprised you know about it.
ZeXr0 wrote:
I don't know if it was that tracker, but it had been reported a couple of time that the tracker was either down, or users was unable to connect to the tracker. Still I was connected to other users but not the tracker itself.
The same has also been reported for the actual site. I suspect connection problems.
On the other hand, during development I have restarted the tracker several times with several minute long pauses.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Earlier this week I noticed that the BitTorrent tracker of Tasvideos is starting to reach noticeable CPU load levels. It is the standard BitTorrent tracker with only minor changes (doesn't forget obsolete movies, remembers useragents).
So I wrote my own.
http://bisqwit.iki.fi/source/bqtrack.html
This tracker was written with two goals in mind:
-- Compatible with the site code (including the way the "dstate" file is loaded and saved)
-- It is as fast as possible.
In particular, I couldn't care less about the http administration/statistics features, which seem to be what most other trackers seem to concentrate at.
I think I accomplished both goals suitably well. However, it has less features than the standard BitTorrent tracker. In particular, it has no NAT detection schemes whatsoever. I don't know how much that matters.
It has also been observed, that it reports significantly higher swarm member counts than the old tracker did -- likely somehow inflated. I have a theory why it could happen (doesn't detect abruptly dropped peers except from a timeout of 1 hour), but I don't know how the standard tracker avoids it.
Also, it occassionally dies from a "too many open file descriptors" error. I don't know how to effeciently avoid that either. (No, it does not leak resources.)
The tracker comes with General Public License, so if someone wants to try a hand at improving it, patches are welcome :)
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Hello and welcome and congratulations for your first submission.
Your movie has the right idea, but it is not very well optimized.
Here are some things I noticed in the first two stages.
― You avoided (some) enemies and it was very noticeable. Try to be faster and make the waits less noticeable.
― Do not bump into walls. Jump earlier.
― Walking is faster than jumping. You should minimize your jumps.
― You should jump into the pit to maximize the falling speed. It seems you learned this later, but you still weren't consistent.
― React faster. Don't stand still without a good reason.
― During zipping, you should jump here once. This puts Rockman lower, making the fall shorter.
― You should always be ready for the events of the next screen. Here, you land far from the edge. You should land closer to the edge. Now you had to walk longer than necessary.
― In Bubbleman fight, you should have manipulated the boss's behavior to avoid unnecessary delays. (Luck manipulation)
― Do not switch weapons during falling. It slows the falling speed.
― Are you aware of FinalFighter's ideas for speedrunning this game?
With these ideas, you should be able to make an improved movie.
However, this is not an accepted hack on this site. It may become one, if it proves popular enough. Currently it is not.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Heh, I'm amazed how much discussion this actually generated.
Yeah, adelikat is right, I should have posted it as a privmsg to the author instead of to this topic. I just thought it'd be a good way to inform the author as well as potential publication-doers at the same time.
Here's btw more of what I had in my mind when I posted that… warning… if anyone cares.
My concern is only about how it would appear if we announce on the site, "played by God's Hand". I have nothing against that person in particular. It's just that particular expression happens to have a connotation that I don't wish to have there.
I have nothing against pseudonyms, or such names appearing in fiction, but the "played by" line is supposed to be a fact (for us to have credibility), and if such an expression appears there, it looks too weird.
Re: JXQ, In communication, the responsibility to make a message understood is with the sender, not with the receiver. When we publish at this site, we are making a message. It is our responsibility to make it understood the right way. Hence, your "but there's a difference between intention and the looks" point is moot.
Also, for a person to be called with such a highly praiseful name like "God's Hand" ― this term in Japanese is used generally for people whose work appears to be really divine, i.e. on a completely different level than of mundane people.
Using such a name of oneself is nothing short of excessive egoism. Rude, in other words.
One could be called "God Hand" by others who consider the person to be really expert beyond any other experts. But one cannot call oneself "God Hand".
Of course the site is not decided by Japanese culture… but the name "God Hand" is influenced by Japanese culture (at least that's what I understand from the links by KaitouKid's provide).
But this was another tangent, it is not the reason for me to prohibit that name. After all, we also have "Arne The Great", "SuperNinja" and "Master Insan". Oh wait, the third hasn't submitted a movie. Anyway.
Re: JXQ, You do a great job in pointing fingers and blaming everyone for whatever character warts you recognize, or just generally making everyone look stupid. How productive is that?
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
KaitouKid wrote:
His name is fine.
It's nice that you don't carry any prejudice ;)
But what I posted in my first post of this thread, holds.
(I could also argue a flaw in your "I don't need" paragraph, but that's beside the point.)
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Very good outline, Zefiris.
I would like to make such a tutorial with video camera or something, but screenrecording + voiceover would probably suffice as well.
The key is editing.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
KaitouKid: Well, the point is clear. You are an atheist (or agnostic or whatever), and I am christian. :)
And you rant angrily and use words like "fuck" and "christ" in contexts where they don't belong to. And I frown at that kind of behavior.
That's how we both are.
Nothing new there.
So, enough of off-topic and more about this submission, mayhaps?
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Frame advance is like slow motion, except that the game progresses only when you press that button. When you press nothing, the game is completely on pause.
This way, you can accomplish feats like pressing A on every second frame (i.e. 30 fps autofire), and other frame precise inputs, that are impossible to perform at real time.
For example, in NES Mega Man 2, to zip through a wall, you will have to press Right+A, Right, Left and A (or something similar) on consequential frames, and if your timing is off, the trick fails. In real time playing, it is extremely unlikely that you hit the right timing, but when the game is slowed down, your chances will improve. At frame advance, you can get it right without failure, because the game will never run ahead without your explicit input.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
This has nothing to do with the movie itself, but I will refuse to have a player entry called "God Hand" on the site.
If the player wishes to have a movie published here, he needs to choose another name. (In addition to making an actual publish-worthy movie.)
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Deep Loner wrote:
Bisqwit wrote:
What practical joke were you referring to?
On this thread, anything between these two symbols: <> gets erased when the message is posted.
Oh, sorry, I ignored this thread for a while, didn't see your reply.
On this (off)topic, you should set it in your profile so that "disable HTML" is on by default, and uncheck "disable HTML" only if you're going to post HTML code that requires the browser to interpret it as HTML. I recommend this to everyone else, too.
Don't enable HTML markup in your posts unless you're actually going to use, HTML tags. Otherwise you will indeed experience the kind of phenomenon you described, because HTML tags begin with < and end with >.
Editor, Experienced Forum User, Published Author, Active player
(296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Xkeeper wrote:
In any case, I should probably take down all my "xkeeper.shacknet.nu:5" links, as there's an emulation-themed folder with ROMs in it...
I don't think knowing your server address is enough to figure out which precise URL leads to a repository of ROMs.
Edit: In any case, locking this thread.
― You avoided (some) enemies and it was very noticeable. Try to be faster and make the waits less noticeable.
― Do not bump into walls. Jump earlier.
― Walking is faster than jumping. You should minimize your jumps.
― You should jump into the pit to maximize the falling speed. It seems you learned this later, but you still weren't consistent.
― React faster. Don't stand still without a good reason.
― During zipping, you should jump here once. This puts Rockman lower, making the fall shorter.
― You should always be ready for the events of the next screen. Here, you land far from the edge. You should land closer to the edge. Now you had to walk longer than necessary.
― In Bubbleman fight, you should have manipulated the boss's behavior to avoid unnecessary delays. (Luck manipulation)
― Do not switch weapons during falling. It slows the falling speed.
― Are you aware of FinalFighter's ideas for speedrunning this game?
With these ideas, you should be able to make an improved movie.
However, this is not an accepted hack on this site. It may become one, if it proves popular enough. Currently it is not.
