C][G GhostTown™

SQL Excute comamnds

5 posts in this topic

Was wondering if anyone is able to help me with 2 codes I would like to write up for my databse.

The first one is to reset all Territories due dates to say 4/25/2016

and the second is to add say 50k tabs and 1 respect to everyones account

Share this post


Link to post
Share on other sites
Advertisement

I know I have asked but still no reply, Anyone able to help me write something up?

I would hate to do this manually! 

Share this post


Link to post
Share on other sites
On 4/24/2016 at 3:52 PM, C][G GhostTown™ said:

add say 50k tabs and 1 respect to everyones account

UPDATE account SET money = money + 50000, score = score + 1;

This will take the players current money and add 50000, as well as, doing the same for respect. 

On 4/24/2016 at 3:52 PM, C][G GhostTown™ said:

reset all Territories due dates to say 4/25/2016

UPDATE territory SET last_paid_at = '2016-04-25 12:00:00'

The thing is about this one, Exile's database doesn't store the "date" when it is due, it stores the day it was created and last paid. The due date is dependent on your config, but you can easily adjust the time yourself. 

1 person likes this

Share this post


Link to post
Share on other sites
1 hour ago, WolfkillArcadia said:

UPDATE account SET money = money + 50000, score = score + 1;

This will take the players current money and add 50000, as well as, doing the same for respect. 


UPDATE territory SET last_paid_at = '2016-04-25 12:00:00'

The thing is about this one, Exile's database doesn't store the "date" when it is due, it stores the day it was created and last paid. The due date is dependent on your config, but you can easily adjust the time yourself. 

That's perfect!

Thank you for helping I appreciate it :)

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.