Offline
There are times were you want to unpin a lot of points so they can be pinned again, this can only be done via a script here is two examples.
this unpins all points that have not been pointed
update tblpoints set pinned=0 where pstatus_type=1
this unpins all points that have not been pointed and is greater than 50 times asked
update tblpoints set pinned=0 where pstatus_type=1 and times_asked > 50
either of these command must be entered into the maintance/advanced box and the execute button pressed, this is not reversable so make sure you are happy you want to do this first, you can always take a backup of your database in the maintance screen first.