hettoo / chatsow

Resourceless Warsow chat client
1 stars 4 forks source link

H website #16

Open hettoo opened 10 years ago

QaleQ commented 10 years ago

Search engine for maps does not recognize - or _ as valid symbols, it seems.

hettoo commented 10 years ago

Done.

QaleQ commented 10 years ago

1 Would it be possible to be able to sort by two different columns manually? (first by one, then by the other)

2 Make PJ runs distinguishable (i.e. by making the times/scores red, or maybe a seperate toplist for them, like, next to the normal toplist)

3 Display oneliners somewhere?

hettoo commented 10 years ago

PJ times are already red. Perhaps you missed that change because I had stylesheets cached for a week, removed that now. Oneliner are also already displayed on the map detail page if they are set. Secondary sorting won't be possible manually in the near future with my system, but I'll be working on some logic to have it make more sense by default. Currently there is no secondary ordering at all.

QaleQ commented 10 years ago

Ah! :) Making scores red aswell as times would make things a bit clearer perhaps?

Maybe ordering by points first and date 2nd would be a clever way of sorting? No way to add timestamps to the dates btw? It would be great for backtracking to a specific map etc. (especially when you play around midnight) Listing the current recholder and time in the "maps" part would be a nice addition aswell! And maybe coloring 40/34/31 points in gold/silver/bronze colors, just to make it easier for nubs to figure out..

hettoo commented 10 years ago

Adding that record info is too inefficient, because it needs to be taken from another table which is very big and not optimized for that. I could request them manually for the displayed entries (so without sorting possibilities) someday, but for now I don't fancy 20 extra queries to an external server if the data is one click away. :p Didn't do the point coloring because it seems too much and doesn't combine really with the new red color for prejump points.

QaleQ commented 10 years ago

Makes sense :> Noticing small improvements pretty much all the time, the page is really coming together nicely :D I would suggest having the map name links direct to their corresponding page in the MGX part instead of downloading the pk3 directly when looking around the demos though.

hettoo commented 10 years ago

Thanks. I'll look at that soon. It would be better since the pk3 names there are not guaranteed to be correct (it just guesses the pk3 name equals the mapname). :p On the other hand it is very fast this way, not depending on an external database. Though perhaps that doesn't matter much.

QaleQ commented 10 years ago

I see, but yea, no, I don't think it'd matter if it's fast or not, especially if it's guaranteed to work properly with pk3's and makes the site easier for people to browse through :) Another idea is to put the name of the person the demo belongs to next to the time of the demo, when on map pages, i mean. Especially since the demo is not guaranteed to be someone's personal best, so you can't always find the corresponding time in the toplist below :)

Come to think of it, to make things less confusing, wouldn't it be a good idea to have the MGX page as the main page, and only have the ability to find demos in the corresponding map pages? Do people really go to the site, go to players and just download a random demo from someone? The more likely scenario is that they play a map or see a rec on a map that they can't beat/wanna see, and then download the demo for that specific map.. Right? This way we could get rid of having two different "player" and "maps" subpages.. Would make things a whole lot easier to understand, don't you think?

hettoo commented 10 years ago

Yeah, I was already thinking about merging them. This will probably mean removing the demo playerlist though, since I can't really link them to MGX players.

QaleQ commented 10 years ago

Yea that's what i meant :) merge maps from demos and mgx and only have the demo player names displayed next to the demo times on the maps pages, and nowhere else :)

QaleQ commented 10 years ago

Just a thought; I've noticed the play time, racing time and tries columns to be very inaccurate at times. Longer racing time than play time for instance, 0:000 in both columns, even when people have rec on that specific map, and tries count not getting any higher even when you play the map again etc. Not only are they inaccurate, but they (along with "skill" calculation) make some people hold out on playing as much and playing as well as they could, just to not ruin their stats.. People don't auth, don't join, or don't keep trying after they set a rec, just because they want low time played/few tries/high skill.. In conclusion, I see alot of negative sides to having this info printed on the page and, while I do see the upsides to having it aswell, it kind of gets ruined by the fact that they are not guaranteed to be accurate!

hettoo commented 10 years ago

Tries is the amount of tries before the personal record. As far as I know thisone is correct. I'm going to assume the same thing for racing time, so only leaving out playtime on the map detail pages for now. Really wouldn't know how those 0.000 times got there (can't find any atm btw).

There are also some maps which have 0.000 playtime, which is a racesow bug caused by the mapname being stripped from colorcodes before inserting a record, which should not be done. To fix this all servers have to be fixed at the same time while the database needs to be corrected, so this will have to wait. Causes no other harm atm, only those x^3 maps having their stats at x (which is not in the maplist) while the demo is at the page for x^3.

All map links now refer to the mgx map pages btw. Haven't gotten to that merging yet though.

QaleQ commented 10 years ago

I see, that's kind of silly tho? :P If you keep trying for an hour after you get prec but don't manage to improve, that's still relevant to the tries-info, wouldn't you say? Anyway, I still think it's got more potentially negative effects on the community than positive though!

There are quite a few 0.000 racing time bugs in the db.. If you go to any random player, sort by ascending racing time, you'll see 0.000 times with tries and often points connected to them..

Ah I see. This is not the case with the bug I was referring to though. Guess that should be looked soon tho, preferably the next time all server admins are on at the same time, perhaps?

Nice one :) Will you implement manual merging some time in the future btw? Or at least access for some admins or smth to be able to merge? Noticed there are 19 instances of myself in the db, and that's not uncommonly high either.. :P

QaleQ commented 10 years ago

1̶-̶ ̶W̶o̶u̶l̶d̶ ̶b̶e̶ ̶n̶i̶c̶e̶ ̶i̶f̶ ̶t̶h̶e̶ ̶l̶i̶v̶e̶ ̶p̶a̶g̶e̶ ̶d̶i̶s̶p̶l̶a̶y̶e̶d̶ ̶a̶c̶t̶u̶a̶l̶ ̶r̶e̶c̶ ̶a̶s̶w̶e̶l̶l̶,̶ ̶n̶o̶t̶ ̶j̶u̶s̶t̶ ̶b̶e̶s̶t̶ ̶d̶e̶m̶o̶ ̶t̶i̶m̶e̶.̶ 2- This guy "aLias" took a rec 2 days ago that never showed up under "latest records".. His time was set on the vVv server, if that matters. 3- I downloaded a pk3 from the site which turned out to be corrupt (pornstar-alcohol), but 2nd time i downloaded it worked fine, just thought I'd let you know.. 4- How about excluding players with 0 points from search? (would currently give us 142 pages worth of players, instead of 1639, haha) 5̶- ̶I̶f̶ ̶p̶o̶s̶s̶i̶b̶l̶e̶,̶ ̶s̶o̶r̶t̶ ̶p̶l̶a̶y̶e̶r̶s̶ ̶w̶i̶t̶h̶ ̶0̶ ̶p̶o̶i̶n̶t̶s̶ ̶b̶y̶ ̶t̶i̶m̶e̶ ̶i̶n̶s̶t̶e̶a̶d̶ ̶o̶f̶ ̶d̶a̶t̶e̶ ̶a̶s̶ ̶2̶n̶d̶ ̶s̶o̶r̶t̶i̶n̶g̶ ̶o̶r̶d̶e̶r̶?̶ ̶l̶o̶o̶k̶s̶ ̶k̶i̶n̶d̶ ̶o̶f̶ ̶w̶i̶e̶r̶d̶ ̶n̶o̶w̶ ̶(̶h̶t̶t̶p̶:̶/̶/̶i̶n̶c̶.̶m̶g̶x̶r̶a̶c̶e̶.̶n̶e̶t̶/̶m̶a̶p̶s̶/̶d̶e̶t̶a̶i̶l̶/̶4̶0̶9̶1̶/̶p̶o̶i̶n̶t̶s̶-̶/̶2̶ ̶f̶o̶r̶ ̶e̶x̶a̶m̶p̶l̶e̶)̶ ̶E̶D̶I̶T̶:̶ ̶c̶o̶m̶e̶ ̶t̶o̶ ̶t̶h̶i̶n̶k̶ ̶o̶f̶ ̶i̶t̶,̶ ̶a̶l̶w̶a̶y̶s̶ ̶s̶o̶r̶t̶i̶n̶g̶ ̶b̶y̶ ̶p̶o̶i̶n̶t̶s̶,̶ ̶t̶h̶e̶n̶ ̶t̶i̶m̶e̶,̶ ̶t̶h̶e̶n̶ ̶d̶a̶t̶e̶,̶ ̶w̶o̶u̶l̶d̶ ̶g̶i̶v̶e̶ ̶t̶h̶e̶ ̶a̶p̶p̶r̶o̶p̶r̶i̶a̶t̶e̶ ̶r̶e̶s̶u̶l̶t̶,̶ ̶w̶o̶u̶l̶d̶n̶'̶t̶ ̶i̶t̶?̶ 6̶-̶ ̶M̶a̶y̶b̶e̶ ̶c̶h̶a̶n̶g̶e̶ ̶t̶h̶e̶ ̶f̶o̶n̶t̶ ̶o̶f̶ ̶t̶h̶e̶ ̶t̶i̶m̶e̶s̶/̶t̶r̶i̶e̶s̶/̶p̶o̶i̶n̶t̶s̶ ̶t̶o̶ ̶o̶n̶e̶ ̶t̶h̶a̶t̶ ̶h̶a̶s̶ ̶t̶h̶e̶ ̶s̶a̶m̶e̶ ̶a̶m̶o̶u̶n̶t̶ ̶o̶f̶ ̶s̶p̶a̶c̶e̶ ̶f̶o̶r̶ ̶e̶a̶c̶h̶ ̶d̶i̶g̶i̶t̶,̶ ̶w̶o̶u̶l̶d̶ ̶m̶a̶k̶e̶ ̶i̶t̶ ̶e̶a̶s̶i̶e̶r̶ ̶t̶o̶ ̶r̶e̶a̶d̶ ̶(̶a̶t̶m̶ ̶s̶m̶t̶h̶ ̶l̶i̶k̶e̶ ̶7̶0̶3̶ ̶t̶a̶k̶e̶s̶ ̶a̶b̶o̶u̶t̶ ̶a̶s̶ ̶m̶u̶c̶h̶ ̶s̶p̶a̶c̶e̶ ̶a̶s̶,̶ ̶s̶a̶y̶,̶ ̶6̶1̶4̶1̶.̶.̶)̶ Looks good! Would be nice if you applied the font to tries aswell, and maybe points. So they follow the same pattern :) 7- Ugh, just noticed that PJ times count toward Gold/Silver/Bronze.. This does not feel appropriate at all :p 8- I was thinking, what if you were able to see which position a persons specific time had at best, and after that what position that time has now. Like, say I had a rec on a map, and two people beat that time, making it third, it would read 40 -> 31 (for example). I think this would be very interesting, but maybe hard to achieve? 9- How about adding diff between times? Like in the /top cmd 10- Would be nice if the server browser didn't force-open a new window when the warsow:// link is clicked

QaleQ commented 10 years ago

Dunno if this gets bumped if I just edit the last comment, cuz i've edited it like 5 times :P