Wiki

Version 10 (Max Goldberg, 05/17/2011 03:11 am)

1 3 Max Goldberg
h1. general todo stuff
2 3 Max Goldberg
3 3 Max Goldberg
4 3 Max Goldberg
h2. security/moderation
5 3 Max Goldberg
6 3 Max Goldberg
* verify that email confirmation is being enforced properly.
7 3 Max Goldberg
* make a note of gmail's alias system with <name>+<alias>@gmail.com
8 3 Max Goldberg
* possibly remove the unique email requirement since it doesn't stop anyone from making alts.
9 3 Max Goldberg
* ensure accounts on the deletion queue aren't able to use *any* part of the site.
10 4 Max Goldberg
11 4 Max Goldberg
12 4 Max Goldberg
13 4 Max Goldberg
14 4 Max Goldberg
h2. news cleanup
15 5 Max Goldberg
16 4 Max Goldberg
* go through the news one by one and:
17 4 Max Goldberg
> * check for broken links.
18 4 Max Goldberg
> * check for broken images.
19 4 Max Goldberg
> * verify html cleanliness. 
20 4 Max Goldberg
> * check layout is okay.
21 4 Max Goldberg
22 4 Max Goldberg
* check out encoding issues on http://ytmnd.com/news/98
23 9 Max Goldberg
* check out encoding issues on http://ytmnd.com/contests/6
24 6 Max Goldberg
25 6 Max Goldberg
26 8 Max Goldberg
h2. comments
27 8 Max Goldberg
* update this, from the top of comments.js
28 8 Max Goldberg
29 8 Max Goldberg
30 7 Max Goldberg
h2. misc
31 1 Max Goldberg
32 7 Max Goldberg
* cache private message counter.
33 7 Max Goldberg
* http://ytmnd.com/sites/random/profile
34 8 Max Goldberg
35 8 Max Goldberg
36 8 Max Goldberg
37 8 Max Goldberg
h2. 404's
38 8 Max Goldberg
39 8 Max Goldberg
"NetworkError: 404 Not Found - http://content.ytmnd.com/assets/images/lazytown_signature.png"
40 8 Max Goldberg
"NetworkError: 404 Not Found - http://content.ytmnd.com/sleeve_logo.png"
41 1 Max Goldberg
"NetworkError: 404 Not Found - http://content.ytmnd.com/assets/images/lazytown_signature.png"
42 1 Max Goldberg
"NetworkError: 404 Not Found - http://content.ytmnd.com/sleeve_logo.png"
43 10 Max Goldberg
44 10 Max Goldberg
45 10 Max Goldberg
h2. asset cleanup
46 10 Max Goldberg
47 10 Max Goldberg
mysql> select * from asset_information where internal_type='marker';
48 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+
49 10 Max Goldberg
| asset_id | internal_type | bit_rate | duration | sound_channels | sound_sample_rate | image_height | image_width | image_animated | image_frame_count | image_colors | image_loops |
50 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+
51 10 Max Goldberg
|  3214355 | marker        |     NULL |     NULL |           NULL |              NULL |            0 |           0 | n              |              NULL |            0 |        NULL |
52 10 Max Goldberg
|  3545003 | marker        |     NULL |     NULL |           NULL |              NULL |            0 |           0 | n              |              NULL |            0 |        NULL |
53 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+
54 10 Max Goldberg
2 rows in set (2.58 sec)
55 10 Max Goldberg
56 10 Max Goldberg
mysql> select * from asset_information where internal_type='generic';
57 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+
58 10 Max Goldberg
| asset_id | internal_type | bit_rate | duration | sound_channels | sound_sample_rate | image_height | image_width | image_animated | image_frame_count | image_colors | image_loops |
59 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+
60 10 Max Goldberg
|   202459 | generic       |     NULL |        0 |              1 |              8000 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
61 10 Max Goldberg
|   208217 | generic       |     NULL |   102330 |              2 |             44100 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
62 10 Max Goldberg
|   248626 | generic       |     NULL |        0 |              1 |              8000 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
63 10 Max Goldberg
|   267863 | generic       |     NULL |      650 |              1 |             22050 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
64 10 Max Goldberg
|   317482 | generic       |     NULL |     3150 |              2 |             44100 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
65 10 Max Goldberg
|   333037 | generic       |     NULL |        0 |              1 |              8000 |         NULL |        NULL | NULL           |              NULL |         NULL |        NULL |
66 10 Max Goldberg
+----------+---------------+----------+----------+----------------+-------------------+--------------+-------------+----------------+-------------------+--------------+-------------+