fixed colors in d3lineplot; update to transactions in db