|
||||||
Views:
9,015,517 |
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search | 04-28-24 09:06 PM |
||||
Guest: Register | Login |
0 users currently in msg db 'Computer Address',0xa | 4 bots |
Main - msg db 'Computer Address',0xa - ABΔ, or Delta, an OOP messageboard attempt |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 368/1016 EXP: 2172417 Next: 41680 Since: 01-02-12 Last post: 4387 days Last view: 4358 days |
You should still use a background in the mobile theme, AMOLED screens have great colour reproduction. Just don't make it too detailed.
Also, it does not make sense to me, that the font size is changed below a certain resolution. Be aware that tablet displays are up to 2560x1600 in just about 25 cm. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 310/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
Why would you bring up tablets when I've just emphasized this is for phones?
Also, it's not the resolution that triggers the change, it's orientation. Holding your phone in landscape orientation makes it wide -- like a desktop computer. For tangentially related fun, check out the Noxico screenshot diary in both orientations on a phone and compare it to the view on a desktop computer. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 369/1016 EXP: 2172417 Next: 41680 Since: 01-02-12 Last post: 4387 days Last view: 4358 days |
Posted by KawaYou're right, on second thought, tablets have excellent zooming and high resolution. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 317/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
Folded the database into itself even more, removing the Last Post and Started By fields. Then I added them to the actual index page, including direct link ».
I'll update the rarchive when editpost is in. |
Arisotura |
| ||
Developer
pancakes Level: 83 Posts: 74/1868 EXP: 5414223 Next: 17998 Since: 01-05-12 From: France Last post: 686 days Last view: 225 days |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 346/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
It's really very simple. We I seriously haven't had to recalculate anything so far, and never will. Unlike in ABXD, which has a script for specifically that purpose. |
Arisotura |
| ||
Developer
pancakes Level: 83 Posts: 76/1868 EXP: 5414223 Next: 17998 Since: 01-05-12 From: France Last post: 686 days Last view: 225 days |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 348/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
Even so, I did say "roughly". Trade one thing for one other thing, but which is more taxing for the server: insert/update, which requires changing the table's files and various other kinds of bookkeeping, or a select subquery, which shouldn't make no change at all? And considering how much better the servers have gotten, does all of that even matter? |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 406/1016 EXP: 2172417 Next: 41680 Since: 01-02-12 Last post: 4387 days Last view: 4358 days |
I would say, keep the the code and the database as clean as possible, and conserve bandwidth. Server CPU's are really not an issue nowadays. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 381/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
That's basically what I'm doing already. Even the database tables' field names are adjusted for readability. |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 401/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
Post revisions
The post_text table right now: parent_post message revision where revision is coupled to posts.last_revision Suggested format: id parent_post message and remove posts.last_revision. WHAT? Grab the most recent revision for a post (say, #42) by subquery: ORDER BY id DESC LIMIT 0, 1
Grab revision N for the same like this: ORDER BY id ASC LIMIT N-1, 1
So basically grab revisions not by a "revision #" field, but by limit range. Example:
Final assembled query:
Instead of SELECT * FROM posts LEFT JOIN post_text ON post_text.parent_post = posts.id AND post_text.revision = posts.last_revision .
This is an actual thing, even though there's no "edit post" interface yet. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 472/1016 EXP: 2172417 Next: 41680 Since: 01-02-12 Last post: 4387 days Last view: 4358 days |
Mobile view still needs background.
I suggest ABDX at 3x zoom. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 517/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
Needs, bro? I don't think it needs a background. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 486/1016 EXP: 2172417 Next: 41680 Since: 01-02-12 Last post: 4387 days Last view: 4358 days |
Posted by KawaMobile sites are meant to be compact, not boring. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 533/2423 EXP: 8001720 Next: 51090 Since: 01-01-12 From: The Netherlands Last post: 2031 days Last view: 346 days |
It's allowed to be boring -- it's a work in progress.
Where "it" is Delta in general. |
Main - msg db 'Computer Address',0xa - ABΔ, or Delta, an OOP messageboard attempt |
Acmlmboard v2.5.5 (10/04/2020) © 2005-2024 Acmlm, Emuz, et al. |
MySQL - queries: 164, rows: 537/571, time: 0.054 seconds. |