[eyal282]

#define SQL_STATEMENT_NOT_EXPIRED(%1) ("(DurationMinutes != 0 AND TimestampGiven + (60 * DurationMinutes) < %1)")

I have this define. It doesn't work at all. How can I make it work? I spammed questions for google in other programming languages as well with no success. The parameter doesn't want to work inside a string.

[Dragokas]

#define SQL_STATEMENT_NOT_EXPIRED(%1) "DurationMinutes != 0 AND TimestampGiven + 60 * DurationMinutes < "...%1

public void OnPluginStart()
{
	PrintToServer(SQL_STATEMENT_NOT_EXPIRED("10"));
}

[eyal282]

Originally Posted by Dragokas #define SQL_STATEMENT_NOT_EXPIRED(%1) "DurationMinutes != 0 AND TimestampGiven + 60 * DurationMinutes < "...%1 public void OnPluginStart() { PrintToServer(SQL_STATEMENT_NOT_EXPIRED("10")); }

It appears it won't work with GetTime.

[Dragokas]

Surely, it requires you casting or format specifier.

Hack:

PHP Code:

#define SQL_STATEMENT_NOT_EXPIRED(%1) FormatInline("DurationMinutes != 0 AND TimestampGiven + 60 * DurationMinutes < %i", %1)

char[] FormatInline(const char[] format, any ...)
{
    static char buffer[1024];
    VFormat(buffer, sizeof(buffer), format, 2);
    return buffer;
}

public void OnPluginStart()
{
    PrintToServer(SQL_STATEMENT_NOT_EXPIRED(GetTime()));
}