[Dujma]

I have a little problem. I'm trying to insert mysql function DATE_FORMAT but it doesn't work because pawno won't ignore the % character.

This is the string:

pawn Code:

format(query, sizeof(query), "INSERT INTO `"TABLE_BANS"` (`player`, `admin`, `reason`, `expireDate`, `expireTime`) VALUES ('%s', '%s', '%s', DATE_FORMAT(DATE_ADD(curdate(), INTERVAL %d DAY), '%d/%m/%Y'), curtime())",
  player,
  admin,
  reason,
  days);

But this part DATE_FORMAT(DATE_ADD(curdate(), INTERVAL %d DAY), '%d/%m/%Y') gets messed up and I have MySQL results like

Code:

37/m/Y

I tryed to add escape charater \ but it doesn't help... Does anyone has any idea how to solve this?

[Mikep.]

%d = Number.

Just put %d/%d/%d

What does curtime return? A string? If so use %s.

Read the wiki in future.

[Peter_Corneile]

https://sampwiki.blast.hk/wiki/Format

[yom]

Try with another % so it looks like '%%d' etc.

[Dujma]

Quote:

Originally Posted by ►Peter Corneile◄ https://sampwiki.blast.hk/wiki/Format

lol tnx

Quote:

Originally Posted by 0rb Try with another % so it looks like '%%d' etc.

Yea that was the solution.

Tnx guys.