WizAnnApp

You are not logged in. Would you like to login or register?

1/19/2015 8:59 am  #1


Resetting the pinned status of points

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.

 


Feel free to post enhancement requests for the apps, always looking for new ideas.

All the best
Alex
 

Board footera