Spartan

Database Query Question

2 posts in this topic

Hello friends,

I know some of you are downright studs when it comes to working with SQL, but I'm just a beginner. Can I get some advice?

I'm looking to add a query like the one below to the exile.ini file so I can get the difference in minutes between last_connect_at in the account table and the current DATETIME when the database call is made for a given player.

[getDiffLastConnectedNow]
SQL1_1 = SELECT TIMESTAMPDIFF(MINUTE, last_connect_at, NOW()) FROM account WHERE uid = ?
Number of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1

Does this look right? Particularly, syntax-wise and is SQL1_INPUTS right?

Thanks in advance for any assistance.

Edited by Spartan
clarification

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.