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

 

Powered by Boardhost. Create a Free Forum