added mysql functionality and video views