Author Topic: kukacs account?  (Read 11181 times)

tomreyn

  • MegaGlest Team
  • Airship
  • ********
  • Posts: 2,764
    • View Profile
    • MegaGlest - the free and open source cross platform 3D real-time strategy game
Re: kukacs acoount?
« Reply #25 on: 15 June 2010, 01:34:02 »
You'll have a table there where all the posts are in, and another table where his account credentials and personal settings are in (this part may be split up in two tables). If you can extract just this part of the dump then you don't need to roll back the complete forum for half a week. And I'd appreciate if you would not roll back the complete forum, not unless you make available to us a dump of the current state so we do can repost our recent posts.
atibox: Ryzen 1800X (8 cores @3.6GHz), 32 GB RAM, MSI Radeon RX 580 Gaming X 8G, PCI subsystem ID [1462:3417], (Radeon RX 580 chipset, POLARIS10) @3440x1440; latest stable Ubuntu release, (open source) radeon (amdgpu) / mesa video driver
atibox (old): Core2Quad Q9400 (4 cores @2.66GHz), 8 GB RAM, XFX HD-467X-DDF2, PCI subsystem ID [1682:2931], (Radeon HD 4670, RV730 XT) @1680x1050; latest stable Ubuntu release, (open source) radeon / mesa video driver
notebook: HP envy13d020ng
internet access: VDSL2+

· · · How YOU can contribute to MG · Latest development snapshot · How to build yourself · Megapack techtree · Currently hosted MG games · · ·

ultifd

  • Airship
  • ********
  • Posts: 4,443
  • The Glest Video Guy :) The one and only. :P
    • View Profile
    • My Youtube Channel
Re: kukacs acoount?
« Reply #26 on: 15 June 2010, 01:43:57 »
Quote
I personally doubt the board was hacked, since its been active for a long time, and we have a stable version of the board, not an RC. Titi mentioned something about the masterserver could allow access, but I'm not so sure about that since the board is password protected and I believe only jose and perhaps the rest of the glest team know the password.
Could be something before SMF...and somehow...but probably not? We hope?

Re: EDITS,
maybe try using tomreyn's solution? I would prefer if you didn't...(probably also bad for tomreyn as he was a new member recently...)  and etc. of course, we would all prefer not to...but...anyways I guess we should find another way? ...
has there even been a problem like this? on SMF at least?  :|
hmm...I hope all for the better, for kukac, the Glest Community, and everyone else...

Thanks.  :thumbup:

Omega

  • MegaGlest Team
  • Dragon
  • ********
  • Posts: 6,167
  • Professional bug writer
    • View Profile
    • Personal site
Re: kukacs acoount?
« Reply #27 on: 15 June 2010, 02:04:54 »
Well, here's what I can tell you off the bat:

-When a person is deleted, the unique modifier for their posts is deleted, changing it to guest. There is no way to restore it back to their modifier. I'm not sure if his modifier was reset to guest, and have no (known) way of checking, but I would assume, since the account was deleted, that it was. The only recovery for that is to restore the posts (would be nice if we can just restore the posts and his account, and let those tables overwrite, but none of the others. Depending on the SMF's table layout, this may not be possible. Not sure... :(
-I definately would not want to roll back the forum either.
-I would love to see what I can do with the tables, but I haven't got access to the MySQL stuff on the server. My adminship is just for the board, and not for glest.org itself, so I can't do anything there. It's up to the glest team if they can do anything about that.  :'(
-I will try and experiment with my backup by importing it into a dummy copy of the board offline, deleting an account, and seeing if I can recover it. If successful, then the glest team can apply it to the Glest board.
-Post count cannot be permanently faked, since it depends on the posts, and can be recalculated, its not a static number.
-For now, I've made Kukac's new account a moderator.

Still open to ideas. I checked the SMF forums and back was the only really mentioned way. For the most part, there wasn't many helpful replies there. :bomb:
Edit the MegaGlest wiki: http://docs.megaglest.org/

My personal projects: http://github.com/KatrinaHoffert

josepzin

  • Draco Rider
  • *****
  • Posts: 268
    • View Profile
    • José Zanni blog
Re: kukacs acoount?
« Reply #28 on: 15 June 2010, 07:03:13 »
What a hell...  :o
::. RetroInvaders .::::. My web .::

ultifd

  • Airship
  • ********
  • Posts: 4,443
  • The Glest Video Guy :) The one and only. :P
    • View Profile
    • My Youtube Channel
Re: kukacs acoount?
« Reply #29 on: 15 June 2010, 07:23:49 »
Well...I am still thinking...and thinking. I also think that sleep will help... me...to think?  :P
What a hell...  :o
Probably Kukac's reaction...  :(  ::)

Hmm...
I just (5 minutes ago realized "acoount" instead of account in the title...  ::)

josepzin

  • Draco Rider
  • *****
  • Posts: 268
    • View Profile
    • José Zanni blog
Re: kukacs acoount?
« Reply #30 on: 15 June 2010, 07:36:09 »
May be we can reasign the @kukac@ post to kukac user... :S
::. RetroInvaders .::::. My web .::

titi

  • MegaGlest Team
  • Airship
  • ********
  • Posts: 4,240
    • View Profile
    • http://www.titusgames.de
Re: kukacs account?
« Reply #31 on: 15 June 2010, 08:45:50 »
Maybe we should simply ask kukac if its ok for him to live with a new account.
He has the same rights and so on an he also can edit his old posts because he is a moderator.
The new account only has much less posts :) .
Try Megaglest! Improved Engine / New factions / New tilesets / New maps / New scenarios

kukac2

  • Guest
Re: kukacs account?
« Reply #32 on: 15 June 2010, 08:47:09 »
Epic number of posts, for something that trivial :)

Quote
he had around 700 posts i think and close to 800...

Does it have to do anything altogether? Gabbe, an account is not simply the matter of numbers of posts. It doesn't matter, if a mod has 40 or 9000 posts.

Quote
Yes, these are the facts, but what happened? Maybe the glest board is hacked? Or is it just his account?

I think, hacking my account is the last case solution :) If you hack a whole board, why would you only delete only one moderator's (and probably ace frog's) account? :D

Quote
If some one did it, it was ether Martino or Omega... I doubt they would do that on purpose...

I just imagined as one of them accidently (AcCiDeNtLy!!!) clicks on my delete account, and yes on the "Are you sure" panel :D

Quote
older than 2 weeks (28 days)

2 weeks are not 14 days?

FYI the account was just "recovered", since the old account had only the links to my posts, so what's the problem? It would be worse, if it wasn't deleted, but someone deleted every threads in my name...

Quote
The new account only has much less posts  .

I was proud to joined in 2005 :'(

Gabbe

  • Guest
Re: kukacs account?
« Reply #33 on: 15 June 2010, 13:30:10 »
Now new people will go like "Hey! why is that dude with 50 posts a mod!!?!?" lol.

ElimiNator

  • Airship
  • ********
  • Posts: 3,391
  • The MegaGlest Moder.
    • View Profile
Re: kukacs account?
« Reply #34 on: 15 June 2010, 16:48:05 »
Well I am glad your back on  :) Can't you change the time it says you joined and up your post count?
Get the Vbros': Packs 1, 2, 3, 4, and 5!

kukac2

  • Guest
Re: kukacs account?
« Reply #35 on: 15 June 2010, 16:57:05 »
As Omega stated above, post count is a calculated number, not a static one.

ElimiNator

  • Airship
  • ********
  • Posts: 3,391
  • The MegaGlest Moder.
    • View Profile
Re: kukacs account?
« Reply #36 on: 15 June 2010, 17:01:08 »
O, to bad, We could make a topic and you could post over and over again and after your done lock it!  :D ...
Get the Vbros': Packs 1, 2, 3, 4, and 5!

Gabbe

  • Guest
Re: kukacs account?
« Reply #37 on: 15 June 2010, 17:02:39 »
What then, kukacs spam section?

ElimiNator

  • Airship
  • ********
  • Posts: 3,391
  • The MegaGlest Moder.
    • View Profile
Re: kukacs account?
« Reply #38 on: 15 June 2010, 17:04:27 »
Yah, so he can can his post count back up.  :O
Get the Vbros': Packs 1, 2, 3, 4, and 5!

kukac2

  • Guest
Re: kukacs account?
« Reply #39 on: 15 June 2010, 17:06:19 »
(Vesszek meg, ha értem)

Why is that post count so important??? It does actually !@#$ing nothing!

Now look at it! I just wasted an another reply for you, wasting the precious free space. And did my account get any better?

Gabbe

  • Guest
Re: kukacs account?
« Reply #40 on: 15 June 2010, 17:07:58 »
It helps...rep...hairy cat PMed me first probably because i post like hell, and therefore i get reputation among new members.

Omega

  • MegaGlest Team
  • Dragon
  • ********
  • Posts: 6,167
  • Professional bug writer
    • View Profile
    • Personal site
Re: kukacs account?
« Reply #41 on: 15 June 2010, 18:39:34 »
Kukac has a point. Though I must admit I feel sorry for him. I would be outraged if my account were to be deleted. And it's true, that post count means nothing, however, other people might look for people by their post count, not their awesomeness value (where Kukac is only just behind me :O).

I must admit,
May be we can reasign the @kukac@ post to kukac user... :S
Please read my earlier reply:
-When a person is deleted, the unique modifier for their posts is deleted, changing it to guest. There is no way to restore it back to their modifier. I'm not sure if his modifier was reset to guest, and have no (known) way of checking, but I would assume, since the account was deleted, that it was. The only recovery for that is to restore the posts (would be nice if we can just restore the posts and his account, and let those tables overwrite, but none of the others. Depending on the SMF's table layout, this may not be possible. Not sure... :(

Another posibility that seems unlikely, but I have to ask (it happened to me once). Could anyone else have logged onto your computer and deleted your account? Most people leave their accounts logged in, and its pretty common to have friends/family/ENEMIES etc with easy access to your computer... I know an account on another site was once used by a friend when I left it plugged in. He ended up posting some spam, thinking it was funny... :o
Edit the MegaGlest wiki: http://docs.megaglest.org/

My personal projects: http://github.com/KatrinaHoffert

Trappin

  • Ornithopter
  • *****
  • Posts: 447
    • View Profile
    • MegaGlest Map Compendium
Re: kukacs account?
« Reply #42 on: 15 June 2010, 18:40:03 »
I just added 75 stars to my forum avatar. I am now fleet lord captain officer commander. My post count proves it!




-Archmage-

  • Moderator
  • Dragon
  • ********
  • Posts: 5,887
  • Make it so.
    • View Profile
    • My Website
Re: kukacs account?
« Reply #43 on: 15 June 2010, 19:47:06 »
Quote
I just added 75 stars to my forum avatar. I am now fleet lord captain officer commander. My post count proves it!

In your dreams. :|



Quote
I know an account on another site was once used by a friend when I left it plugged in. He ended up posting some spam, thinking it was funny... Shocked

Ouch.



Post count gives your appearance bulk, it's who you are, what you know, why you came from Mars, etc... that defines the core of your reputation.  :)
Egypt Remastered!

Proof: Owner of glest@mail.com

Trappin

  • Ornithopter
  • *****
  • Posts: 447
    • View Profile
    • MegaGlest Map Compendium
Re: kukacs account?
« Reply #44 on: 15 June 2010, 19:59:49 »
In your dreams.

You know what I dream about?

josepzin

  • Draco Rider
  • *****
  • Posts: 268
    • View Profile
    • José Zanni blog
Re: kukacs account?
« Reply #45 on: 15 June 2010, 22:23:16 »
I have check this option: "Require admin approval when member deletes account"
::. RetroInvaders .::::. My web .::

Gabbe

  • Guest
Re: kukacs account?
« Reply #46 on: 15 June 2010, 22:28:42 »
so i am not free to del my acc now? :P

josepzin

  • Draco Rider
  • *****
  • Posts: 268
    • View Profile
    • José Zanni blog
Re: kukacs account?
« Reply #47 on: 15 June 2010, 22:30:18 »
so i am not free to del my acc now? :P
no! :p
::. RetroInvaders .::::. My web .::

Gabbe

  • Guest
Re: kukacs account?
« Reply #48 on: 15 June 2010, 22:32:51 »
Too{good}bad lol, okay lock this now, it`s probably solved now right?

josepzin

  • Draco Rider
  • *****
  • Posts: 268
    • View Profile
    • José Zanni blog
Re: kukacs account?
« Reply #49 on: 15 June 2010, 22:44:35 »
I think it is solved (by now)...  :-\

I am doing a test in the database, it is posssible to change the messages of @kukca@ to kukac, i have changed one old message and it work :)

https://forum.megaglest.org/index.php?topic=4101.msg22152#msg22152
::. RetroInvaders .::::. My web .::