Official Everybody Edits Forums
Do you think I could just leave this part blank and it'd be okay? We're just going to replace the whole thing with a header image anyway, right?
You are not logged in.
- Topics: Active | Unanswered
#1 2016-05-02 11:46:07, last edited by Napakeun (2016-05-15 16:41:42)
- Napakeun
- Formerly goodsmile
- From: Slo
- Joined: 2015-02-22
- Posts: 619
[Suggestion] Posts: Wooted , Posts: Saved
On the upper right corner there is
Topics: Subscriptions | Posted | New | Active | Unanswered
I know it only shows topics, but I had an idea that there would be another link "Wooted" that shows all posts that you wooted. The woot is usually given to players that find that post useful/funny/it shows a sign of agreement, in many cases it acts as a like button. So it would be good idea, to save all your wooted posts in one place so it's easier to find them?
In the addition to the main idea, a Save button:
Offline
- Wooted by: (6)
#2 2016-05-02 13:35:13
- Anatoly
- Guest
Re: [Suggestion] Posts: Wooted , Posts: Saved
Yes.
#4 2016-05-02 19:15:10
- Different55
- Forum Admin
- Joined: 2015-02-07
- Posts: 16,575
Re: [Suggestion] Posts: Wooted , Posts: Saved
Not really possible due to the way woots work (serialized array instead of its own table). It'd be unbearably slow.
"Sometimes failing a leap of faith is better than inching forward"
- ShinsukeIto
Offline
- Wooted by:
#5 2016-05-02 22:03:24
- dragonranger
- Member
- Joined: 2015-03-21
- Posts: 1,162
Re: [Suggestion] Posts: Wooted , Posts: Saved
Also, remember the times of reputation?
More attachments to a like system poses the threat of getting out of hand
Offline
#6 2016-05-03 14:09:33
- Napakeun
- Formerly goodsmile
- From: Slo
- Joined: 2015-02-22
- Posts: 619
Re: [Suggestion] Posts: Wooted , Posts: Saved
@Different55
Aw that sucks :/
@dragonranger
My suggestion has nothing to do with reputation points or anything like that. I just mentioned a woot is very much like a like, but that doesn't matter here at all. Main purpose of this is to save a post with a woot to view it later.
Offline
#7 2016-05-03 17:15:22
- AlphaJon
- Member
- From: Who knows
- Joined: 2015-07-21
- Posts: 1,297
Re: [Suggestion] Posts: Wooted , Posts: Saved
Not really possible due to the way woots work (serialized array instead of its own table). It'd be unbearably slow.
Can I make an attempt at converting the whole woot arrays into a proper table? (A sample of just the column containing the woot data would be enough, along with postID).
Offline
- Wooted by: (2)
#8 2016-05-03 18:29:02
- Different55
- Forum Admin
- Joined: 2015-02-07
- Posts: 16,575
Re: [Suggestion] Posts: Wooted , Posts: Saved
Different55 wrote:Not really possible due to the way woots work (serialized array instead of its own table). It'd be unbearably slow.
Can I make an attempt at converting the whole woot arrays into a proper table? (A sample of just the column containing the woot data would be enough, along with postID).
Sure, that'd be great. I'll dump woots when I get home.
"Sometimes failing a leap of faith is better than inching forward"
- ShinsukeIto
Offline
#9 2016-05-04 23:14:59
- AlphaJon
- Member
- From: Who knows
- Joined: 2015-07-21
- Posts: 1,297
Re: [Suggestion] Posts: Wooted , Posts: Saved
So, where can i find the dump? 
Offline
#10 2016-05-04 23:55:41
- Different55
- Forum Admin
- Joined: 2015-02-07
- Posts: 16,575
Re: [Suggestion] Posts: Wooted , Posts: Saved
it's stored in a serialized PHP array that has their user ID and their username.
"Sometimes failing a leap of faith is better than inching forward"
- ShinsukeIto
Offline
#11 2016-05-05 00:47:54
- AlphaJon
- Member
- From: Who knows
- Joined: 2015-07-21
- Posts: 1,297
Re: [Suggestion] Posts: Wooted , Posts: Saved
Will do tomorrow, going to bed now 
Offline
#12 2016-05-05 11:37:59
- Zumza
- Member
- From: root
- Joined: 2015-02-17
- Posts: 4,656
Re: [Suggestion] Posts: Wooted , Posts: Saved
Why did you choose username above on playerId?!
Everybody edits, but some edit more than others
Offline
#13 2016-05-05 13:02:15
- TaskManager
- Formerly maxi123
- From: i really should update this
- Joined: 2015-03-01
- Posts: 9,465
Re: [Suggestion] Posts: Wooted , Posts: Saved
it's stored in a serialized PHP array that has their user ID and their username.
lol N1KF's wootspam is real in that topic
Offline
#14 2016-05-05 14:55:17
- Kaleb
- Formerly Kaleb123
- From: California of America
- Joined: 2015-02-19
- Posts: 1,263
Offline
#15 2016-05-05 16:43:45
- Different55
- Forum Admin
- Joined: 2015-02-07
- Posts: 16,575
Re: [Suggestion] Posts: Wooted , Posts: Saved
Why did you choose username above on playerId?!
I'm not sure what you mean
"Sometimes failing a leap of faith is better than inching forward"
- ShinsukeIto
Offline
#16 2016-05-05 17:09:47, last edited by Zumza (2016-05-05 17:10:10)
- Zumza
- Member
- From: root
- Joined: 2015-02-17
- Posts: 4,656
Re: [Suggestion] Posts: Wooted , Posts: Saved
Well, idk, but I suppose when somebody wants to change their username that array would be heavily modified while if woots were assigned to *userId instead, the array won't suffer any.
Everybody edits, but some edit more than others
Offline
#17 2016-05-05 18:18:35
- AlphaJon
- Member
- From: Who knows
- Joined: 2015-07-21
- Posts: 1,297
Re: [Suggestion] Posts: Wooted , Posts: Saved
Script is done!
(Will send relevent info to Diff now)
Offline
#18 2016-05-05 19:13:49
- Different55
- Forum Admin
- Joined: 2015-02-07
- Posts: 16,575
Re: [Suggestion] Posts: Wooted , Posts: Saved
Well, idk, but I suppose when somebody wants to change their username that array would be heavily modified while if woots were assigned to *userId instead, the array won't suffer any.
True, but since it's a serialized array and not a table, you'd have to query the database for all those usernames which would be pretty slow. Now that it'll be its own table, it does just store the user ID and it's a lot cheaper to get usernames.
"Sometimes failing a leap of faith is better than inching forward"
- ShinsukeIto
Offline
#19 2016-05-05 19:23:53
- AlphaJon
- Member
- From: Who knows
- Joined: 2015-07-21
- Posts: 1,297
Re: [Suggestion] Posts: Wooted , Posts: Saved
BTW congrats N1KF for his 34606 woots, followed by Xfrogman43 with 11550 woots, out of a total of 138605 woots.
You make a third of the whole woot database together!
Offline
#20 2016-05-07 01:50:07
- hummerz5
- Member
- From: wait I'm not a secret mod huh
- Joined: 2015-08-10
- Posts: 5,853
Offline
#21 2016-05-07 03:49:01
- Xfrogman43
- Member
- From: need to find a new home
- Joined: 2015-02-15
- Posts: 4,174
Re: [Suggestion] Posts: Wooted , Posts: Saved
^ don't forget my post of random things related to woots from a few months back. I had a few nice tables, too.
And I threw out frog and n1kf from most of the tables because ... really.
What about anch? wow rude
thanks zoey aaaaaaaaaaaand thanks latif for the avatar
Offline
#23 2016-05-07 19:43:08
- 0176
- Member
- From: Brazil
- Joined: 2021-09-05
- Posts: 3,174
Re: [Suggestion] Posts: Wooted , Posts: Saved
Didn't N1KF just like, woot every old post in the Game/Forum Business section?
Offline
#25 2016-05-15 16:46:28, last edited by Napakeun (2016-05-15 18:24:26)
- Napakeun
- Formerly goodsmile
- From: Slo
- Joined: 2015-02-22
- Posts: 619
Re: [Suggestion] Posts: Wooted , Posts: Saved
In the addition to the main idea maybe also add a Save button:
Nothing complicated, probably unnecessery. Basically you have 2 folders where you save the posts, one is called "Wooted" and other "Saved".
That's how reddit has it, only instead of word woot it's upvote.
Offline
[ Started around 1732756864.9967 - Generated in 0.079 seconds, 16 queries executed - Memory usage: 1.78 MiB (Peak: 2.03 MiB) ]