Nooby question.

[DcSelby]

Hi DevBest'ers,

I understand this is a rather nooby questions - but I need to know the answer to it, and where best to find it out!?

Basically - I was wondering how do you reset respects on a hotel, without having to flick through every single name?

Such a nooby question, but I urgently need to know, haha.

DcSelby

 

[Solar]

You could make a page in the admin panel and have the option to reset respect.
You will need to write this in PHP. The line would something like this..

MYSQL database information
UPDATE users SET respect = 0

Edit: Becareful though, make sure you backup the users table. UPDATE can sometimes get messy if you do not use it properly.

 

[DcSelby]

UPDATE user_stats SET DailyRespectPoint = '3'

Is the query I used for any one else's future use.

Credit to Solar.