use base_url also for rank
add default value for invisible column in database