Death and Birth from June 9

pein · 2019-06-06 21:10:29

2019-06-09
6002 deaths
so this is 24 hour period, some births are from previous day

had to split into parts of 1500 cause i had performance issues on loading
the table is ordered in time based sorting so those people lived different times anyway

deleted B and D cause no point of them, added in title
ordered columns so gender and coords are always same place

check it here:
https://ohol-test.weebly.com/

you can use filters in boxes like this:

https://i.imgur.com/WZvgcGJ.png

also you can order columns using the arrows on the top of header to sort ascending descending
for example if you write ">30 and <40" will show people who died during their 30 to 40 th birthday
if you write "miu" in ID will show all named members of miu family (sorry but some people don't have a name or database didn't had it yet in the time of making it)

i still don't know how to make a counter which wont sort, sorry for that, i found a solution but then there is no filter widget
if you copy using ctrl-a the whole page and paste it into google sheets, the filtered data will have colors and the rest is raw data so you can count it
like SID babies

if you hit space in the ID, then you find the properly named people (cause if you got family and last name it has space between)
be creative

you can search on your hash if you know it or a name to find your hash
you can search coordinates like -49*** means -49000 to -49999 etc.

used publicdata from http://publicdata.onehouronelife.com/pu … _names.txt
then pasted into google sheets for manual arranging
the tex manipulations were done with sublime text3
like converting the CSV to html (replace spaces with html tags)

the rest of the javascript and html is predefined so if i don't add columns, i can just make a new html table and it will work
but im tired after all this

the "highpeak" is part of the theme and the "test" button is part of the navigation menu

did the same thing in codepen io last time but seems they got some limitation on long test so i cannot save it, but weebly is a free site and the frame source works in weebly custom scripts so it's a workaround
still some ref links point to that scripts

maybe i need a filter reset button

Last edited by pein (2019-06-10 15:33:38)

Hstrike · 2019-06-10 01:31:23

Fantastic work, really like the sortability.

Sukallinen · 2019-06-10 07:11:52

tyvm <3

pein · 2019-06-10 12:50:39

now is easier next time as i saved the most of scripts and got used to arrayformulas
cleaning up the data still takes time

also now that i realize that is only 8 hours, kinda see no point of doing yesterday, maybe 2 days ago

Whatever · 2019-06-10 12:54:50

the logs show that the player cords are around -40k and -50k
recently jason made a commit that should spawn one eve in the center of the map (every 24 hours)
so i would assume that players would slowly migrate to the center of the map.
but maybe i understood the update wrong idk

pein · 2019-06-10 16:07:05

ok did a full day in it's place from June 9
split into 1500 each table, still having issues on loading it seems
tried separate table but seems separate pages might be better

because is based on the time this will group them time based so hopefully wont be that bad
put on submenu but shows dropdown
open new page ctrl+click and wait to load

also this is a gem after replaced killer id too

dammit Bart!

If you sort, you can even copy the whole page into google sheets, delete the top rows, and the empty ones from bottom and get something like this
https://docs.google.com/spreadsheets/d/ … sp=sharing

this is 6 hours of SID babies

Last edited by pein (2019-06-10 16:36:07)

One Hour One Life Forums

#1 2019-06-06 21:10:29

Death and Birth from June 9

#2 2019-06-10 01:31:23

Re: Death and Birth from June 9

#3 2019-06-10 07:11:52

Re: Death and Birth from June 9

#4 2019-06-10 12:50:39

Re: Death and Birth from June 9

#5 2019-06-10 12:54:50

Re: Death and Birth from June 9

#6 2019-06-10 16:07:05

Re: Death and Birth from June 9

Board footer