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.
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
Yes.
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
Also, remember the times of reputation?
More attachments to a like system poses the threat of getting out of hand
Offline
@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
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
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
So, where can i find the dump?
Offline
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
Will do tomorrow, going to bed now
Offline
Why did you choose username above on playerId?!
Everybody edits, but some edit more than others
Offline
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
Offline
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
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
Script is done!
(Will send relevent info to Diff now)
Offline
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
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
Offline
^ 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
Didn't N1KF just like, woot every old post in the Game/Forum Business section?
Offline
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 1732434557.2485 - Generated in 0.132 seconds, 13 queries executed - Memory usage: 1.77 MiB (Peak: 2.03 MiB) ]