DDraceNetwork - developer

ddnet-maps

[ddnet-maps:master] 1 new commit

856eea3 A Push it 2 - def-

@Tropo I made it look the same as the real layer -- maybe alpha shouldn't be copied?

@timakro weird, 6 seconds on ddnet.tw. could also be related to your mysql server settings?

06:39

can you explain plan?

06:40

MariaDB [teeworlds]> explain SELECT * FROM record_points t1 LEFT JOIN (SELECT Name FROM record_race GROUP BY Name) t2 ON t1.Name = t2.Name;
+------+-------------+-------------+-------+---------------+------+---------+-------------------+--------+--------------------------+
| id   | select_type | table       | type  | possible_keys | key  | key_len | ref               | rows   | Extra                    |
+------+-------------+-------------+-------+---------------+------+---------+-------------------+--------+--------------------------+
|    1 | PRIMARY     | t1          | ALL   | NULL          | NULL | NULL    | NULL              | 143874 |                          |
|    1 | PRIMARY     | <derived2>  | ref   | key0          | key0 | 67      | teeworlds.t1.Name |     10 |                          |
|    2 | DERIVED     | record_race | range | NULL          | Name | 66      | NULL              | 370082 | Using index for group-by |
+------+-------------+-------------+-------+---------------+------+---------+-------------------+--------+--------------------------+
3 rows in set (0.01 sec)

06:40

and SELECT Name from record_race GROUP BY Name is the same as SELECT distinct Name from record_race

@Bojidar Marinov ye i think that should fix the problem

bojidar-bg

[ddnet/ddnet] Pull request opened: #1244 Don't copy alpha when coloring the brush

This is to improve visibility when working with nearly-transparent layers. It shouldn't cause problems when working with partly-transparent layers.

@Tropo ok, submitted a PR -- you might test it if you feel like compiling from source

nah i dont even know how this works xd

@Deleted User https://forum.ddnet.tw/viewtopic.php?t=6601

def-

[ddnet/ddnet] Pull request closed: #1244 Don't copy alpha when coloring the brush