Register | Login
Views: 19364387
Main | Memberlist | Active users | ACS | Commons | Calendar | Online users
Ranks | FAQ | Color Chart | Photo album | IRC Chat
11-02-05 12:59 PM
2 users currently in General Chat: Ailure, Dark Vampriel | 1 guest
Acmlm's Board - I2 Archive - General Chat - Acmlm Hacker is... Mewthree9000 | | Thread closed
Pages: 1 2 3 4Add to favorites | "RSS" Feed | Next newer thread | Next older thread
User Post
KawaiiImoto-e

Hammer Brother
Level: 49

Posts: 61/1068
EXP: 852917
For next: 30966

Since: 03-15-04
From: In my own little complicated dreamworld

Since last post: 16 days
Last activity: 4 days
Posted on 03-16-04 07:42 PM Link
Originally posted by Tuvai
Yes, but let's just say Acmlm's Board was poorly put together in the beginning. The thing that caused the posts table to grow so big were the post layouts. Since the beginning posts layouts were stored along with EVERY posts somebody made, with the purpose that old layouts were stored as soon as a user got a new one.

It only recently got changed, as far as I know. After 3 years.


Na.. but the postlayouts are still stored. maybe somwhere else, but they are still stored.
Tuvai
Permanently banned for account hacking.
Level: 24

Posts: 50/211
EXP: 74894
For next: 3231

Since: 03-15-04

Since last post: 566 days
Last activity: 339 days
Posted on 03-16-04 07:44 PM Link
Originally posted by KawaiiImoto-e
Originally posted by Tuvai
Yes, but let's just say Acmlm's Board was poorly put together in the beginning. The thing that caused the posts table to grow so big were the post layouts. Since the beginning posts layouts were stored along with EVERY posts somebody made, with the purpose that old layouts were stored as soon as a user got a new one.

It only recently got changed, as far as I know. After 3 years.


Na.. but the postlayouts are still stored. maybe somwhere else, but they are still stored.
Yes, they are obviously stored. But the way they're SUPPOSED to be stored is for example in the users table (where all other information such as user ID, email address, etcetera), that way it will only need to be stored once, instead of being stored sepparately along with every post made.
KawaiiImoto-e

Hammer Brother
Level: 49

Posts: 62/1068
EXP: 852917
For next: 30966

Since: 03-15-04
From: In my own little complicated dreamworld

Since last post: 16 days
Last activity: 4 days
Posted on 03-16-04 07:45 PM Link
Originally posted by Tuvai
Originally posted by KawaiiImoto-e
Originally posted by Tuvai
Yes, but let's just say Acmlm's Board was poorly put together in the beginning. The thing that caused the posts table to grow so big were the post layouts. Since the beginning posts layouts were stored along with EVERY posts somebody made, with the purpose that old layouts were stored as soon as a user got a new one.

It only recently got changed, as far as I know. After 3 years.


Na.. but the postlayouts are still stored. maybe somwhere else, but they are still stored.
Yes, they are obviously stored. But the way they're SUPPOSED to be stored is for example in the users table (where all other information such as user ID, email address, etcetera), that way it will only need to be stored once, instead of being stored sepparately along with every post made.


No, no, I mean, they are still stored for every post.
Edit yours, and see.
Tuvai
Permanently banned for account hacking.
Level: 24

Posts: 51/211
EXP: 74894
For next: 3231

Since: 03-15-04

Since last post: 566 days
Last activity: 339 days
Posted on 03-16-04 07:49 PM Link
Yup, I noticed; thought it already had been changed but I was wrong apperantly.

I highly recommend to Acmlm to change that as soon as possible though, obviously it's not a good thing for the database to store something along with EVERY post, while it can be stored just once.

ALL other boards out there do that, and there's a reason for it, an obvious one.
Xeolord

- B l u e s -
Power Metal > All
Level: 81

Posts: 172/3418
EXP: 4884196
For next: 108653

Since: 03-15-04
From: Yeah

Since last post: 15 hours
Last activity: 15 hours
Posted on 03-16-04 08:09 PM Link
I think it's like that in 1.8, my SQL files for posts are extremely long in length.

But yeah, like everyone said, the files got erased, not hacked.
Tuvai
Permanently banned for account hacking.
Level: 24

Posts: 55/211
EXP: 74894
For next: 3231

Since: 03-15-04

Since last post: 566 days
Last activity: 339 days
Posted on 03-16-04 08:22 PM Link
Originally posted by Xeogred
I think it's like that in 1.8, my SQL files for posts are extremely long in length.

But yeah, like everyone said, the files got erased, not hacked.
Yup, 1.8 and below still store post layouts along with posts, don't know about 1.9 though as I never used that copy.
Xeolord

- B l u e s -
Power Metal > All
Level: 81

Posts: 180/3418
EXP: 4884196
For next: 108653

Since: 03-15-04
From: Yeah

Since last post: 15 hours
Last activity: 15 hours
Posted on 03-16-04 08:24 PM Link
Originally posted by Tuvai
Originally posted by Xeogred
I think it's like that in 1.8, my SQL files for posts are extremely long in length.

But yeah, like everyone said, the files got erased, not hacked.
Yup, 1.8 and below still store post layouts along with posts, don't know about 1.9 though as I never used that copy.


Hopefully not, I usually have trouble restoring a backup of posts into MySQL. Usually blanks out.
Chaos Force

Panser
Level: 29

Posts: 90/332
EXP: 147860
For next: 25

Since: 03-15-04

Since last post: 21 days
Last activity: 4 hours
Posted on 03-16-04 10:10 PM Link
heh, I highly doubt anyone hacked it. It was just an error on Overclocked side...
macks

Level: 45

Posts: 44/900
EXP: 659955
For next: 209

Since: 03-15-04
From: Sweden

Since last post: 1 day
Last activity: 22 hours
Posted on 03-16-04 10:12 PM Link
I've always liked the fact that the layouts are stored somewhere so that you can see all the old and crappy layouts people had back when they wre n00bs

But of course, I would understand if they changed that.
gnkkwinrrul

Dry Bones
Level: 39

Posts: 32/647
EXP: 402054
For next: 2717

Since: 03-15-04
From: LYKEOMGIMFROMSOMEPLACE????

Since last post: 81 days
Last activity: 40 days
Posted on 03-16-04 10:19 PM Link
Why would someone want to hack the site? It would basically prove no purpose...
HyperLamer
<||bass> and this was the soloution i thought of that was guarinteed to piss off the greatest amount of people

Sesshomaru
Tamaranian

Level: 118

Posts: 37/8210
EXP: 18171887
For next: 211027

Since: 03-15-04
From: Canada, w00t!
LOL FAD

Since last post: 2 hours
Last activity: 2 hours
Posted on 03-16-04 10:22 PM Link
Worst. Layout. Ever. Ah, looks better with black text.
It could have been a hacker that deleted the DB, but I kinda doubt it. Maybe a virus that got detected by the AV after hitting a few files. Personally though, I think it was a glitch. Maybe a server screwup, maybe something went wrong in the board's code, made the database start growing really friggin fast, and the server deleted it. All I know's it wasn't deliberate. (I emailed them about it, and they said they'd never heard of it happening.)

I would like to know WTF happened though...


(edited by HyperHacker on 03-16-04 01:22 PM)
Kwan
Doesn't have a valid sized userpic. ||bass will be pissed :((((((((
Level: 50

Posts: 88/1137
EXP: 937111
For next: 10206

Since: 03-15-04
From: Durkadurkastan!

Since last post: 22 days
Last activity: 2 days
Posted on 03-16-04 10:23 PM Link
Tell her to hack this one. You know. Just to prove it.
Legion
banning people for no reason sure is fun
Level: 101

Posts: 82/5657
EXP: 10399737
For next: 317938

Since: 03-15-04
From: The Crossroads is under attack!

Since last post: 5 days
Last activity: 5 days
Posted on 03-16-04 10:36 PM Link
I could have SWORE we confirmed it was Ninja AE already. What now?
Acmlm

Torosu
heh
Level: 51

Posts: 115/1173
EXP: 981994
For next: 31944

Since: 03-15-04
From: Somewhere that isn't outside of Sherbrooke, Québec, Canada

Since last post: 39 days
Last activity: 3 hours
Posted on 03-16-04 10:37 PM Link
Well, this is what I'm currently suspecting:

- PHPMyAdmin was restricted by IP, but one of the changes in the IP list apparently broke the restriction and everyone could get in (and of course, I didn't notice since it just let me in like it normally does)
- For some weird reason, PHPMyAdmin could show up in search results in Yahoo, even though the URL for it was nowhere to be seen on any page
- Maybe someone found it there, got in, and felt like deleting everything just because he could

I know for sure it's not the admins at ZTNet who did it, because one of them emailed me and didn't know either how it happened (he's the one who restored the 4 month backup) ...

Oh well, the restart made the board clean again and easier to upgrade, so there'll at least be some good coming from it


As for the way post layouts were stored:
- Beginning: everything is in one single field
- 1.7: headers and signatures are in separate fields for posts, allowing them to be disabled
- 1.9: post layouts are stored in a separate table, and only once (per layout) no matter how many times you use it, but this was only implemented for posts
- 1.92: same, but now it also works in private messages and announcements

A lot of the space in the old database was the post layouts from old versions of the board
kitty
Come on babe, pet the pussy ;)
Level: 70

Posts: 125/2449
EXP: 2962406
For next: 53405

Since: 03-15-04
From: Scranton, PA, USA

Since last post: 3 hours
Last activity: 3 hours
Posted on 03-16-04 10:52 PM Link
Originally posted by Legion
I could have SWORE we confirmed it was Ninja AE already. What now?
OMG NINJA AE, POKEMONLOVER, AND MANDA GOT TOGETHER WITH TIKAL AND HACKED TEH BORED! OMGOMGOMG!

Truth be told, at this point, I don't care how it happened. We started anew and we're going to be a lot tougher on morons. I like how it's starting thus far.
KawaiiImoto-e

Hammer Brother
Level: 49

Posts: 64/1068
EXP: 852917
For next: 30966

Since: 03-15-04
From: In my own little complicated dreamworld

Since last post: 16 days
Last activity: 4 days
Posted on 03-16-04 10:53 PM Link
Originally posted by Acmlm
Well, this is what I'm currently suspecting:

- PHPMyAdmin was restricted by IP, but one of the changes in the IP list apparently broke the restriction and everyone could get in (and of course, I didn't notice since it just let me in like it normally does)
- For some weird reason, PHPMyAdmin could show up in search results in Yahoo, even though the URL for it was nowhere to be seen on any page
- Maybe someone found it there, got in, and felt like deleting everything just because he could

I know for sure it's not the admins at ZTNet who did it, because one of them emailed me and didn't know either how it happened (he's the one who restored the 4 month backup) ...

Oh well, the restart made the board clean again and easier to upgrade, so there'll at least be some good coming from it


As for the way post layouts were stored:
- Beginning: everything is in one single field
- 1.7: headers and signatures are in separate fields for posts, allowing them to be disabled
- 1.9: post layouts are stored in a separate table, and only once (per layout) no matter how many times you use it, but this was only implemented for posts
- 1.92: same, but now it also works in private messages and announcements

A lot of the space in the old database was the post layouts from old versions of the board


Faszinating how much space plain Text can use.
kitty
Come on babe, pet the pussy ;)
Level: 70

Posts: 127/2449
EXP: 2962406
For next: 53405

Since: 03-15-04
From: Scranton, PA, USA

Since last post: 3 hours
Last activity: 3 hours
Posted on 03-16-04 11:01 PM Link
Imoto: There's a difference between a post which shows a lot of effort to convey an idea, and one that does not. There are good points Acmlm made in that post you didn't get, I guess
KawaiiImoto-e

Hammer Brother
Level: 49

Posts: 66/1068
EXP: 852917
For next: 30966

Since: 03-15-04
From: In my own little complicated dreamworld

Since last post: 16 days
Last activity: 4 days
Posted on 03-16-04 11:05 PM Link
Originally posted by Yiffy Kitten
Imoto: There's a difference between a post which shows a lot of effort to convey an idea, and one that does not. There are good points Acmlm made in that post you didn't get, I guess


I get the good points, but didn't feel to reply to them.

I just stated that Text can use much space. If you copy it a tousend fold, everything small can grow big.

It may be that someone played with adressbar of his or her browser to get into PHPAdmin.
kitty
Come on babe, pet the pussy ;)
Level: 70

Posts: 128/2449
EXP: 2962406
For next: 53405

Since: 03-15-04
From: Scranton, PA, USA

Since last post: 3 hours
Last activity: 3 hours
Posted on 03-16-04 11:10 PM Link
It isn't that his text is big, it's that yours is tiny

Note: You may need IE or a browser that actually understands image headers to view that as a jpeg and not a text document (Right click: Save as tiny.jpg if you must)
KawaiiImoto-e

Hammer Brother
Level: 49

Posts: 67/1068
EXP: 852917
For next: 30966

Since: 03-15-04
From: In my own little complicated dreamworld

Since last post: 16 days
Last activity: 4 days
Posted on 03-16-04 11:15 PM Link
In plain Text: My font is too small?

EDIT: Better?


(edited by KawaiiImoto-e on 03-16-04 02:17 PM)
Pages: 1 2 3 4Add to favorites | "RSS" Feed | Next newer thread | Next older thread
Acmlm's Board - I2 Archive - General Chat - Acmlm Hacker is... Mewthree9000 | | Thread closed


ABII


AcmlmBoard vl.ol (11-01-05)
© 2000-2005 Acmlm, Emuz, et al



Page rendered in 0.017 seconds.