Time from mysql + lua

[ByLost 136]

Hello, guys.

I'm needing to do a quest to insert the time into the database.

I need you to enter the database when the query row, "time" column has a countdown of 23:59:59.
Is it possible?

[EnKor 42]

Does >> this <<  help?

 

quest

Spoiler

quest admin_painel begin
    state start begin
		when 40004.use with pc.is_gm() begin
			local count, value = mysql_direct_query("SELECT name FROM player.player WHERE id ='10009'; ")
			--mysql_direct_query("UPDATE account.account SET status = 'BLOCK', availDt = '0000-00-00 00:00:00' WHERE login = 'admin';")
			syschat("Leader: "..tostring(value[1].name).."")
		end
	end
end

 

 

[ByLost 136]

6 minutes ago, EnKor said:

Does >> this <<  help?

 

quest

  Hide contents

quest admin_painel begin
    state start begin
		when 40004.use with pc.is_gm() begin
			local count, value = mysql_direct_query("SELECT name FROM player.player WHERE id ='10009'; ")
			--mysql_direct_query("UPDATE account.account SET status = 'BLOCK', availDt = '0000-00-00 00:00:00' WHERE login = 'admin';")
			syschat("Leader: "..tostring(value[1].name).."")
		end
	end
end

 

 

 

That's about it. I need time to slow down when entering the query.

[EnKor 42]

 

???  that? ot this one?

 

Spoiler

when 9011.chat."delay test" begin
			say("asd")
			say("[DELAY value; 1000]. . . . . . . . . . .[/DELAY]")   --< <<<<<< This one?!
			say("asdasdasd")
		end
	

 

 

Edited May 18, 2021 by EnKor

[ByLost 136]

18 minutes ago, EnKor said:

 

???  that? ot this one?

 

  Hide contents

when 9011.chat."delay test" begin
			say("asd")
			say("[DELAY value; 1000]. . . . . . . . . . .[/DELAY]")   --< <<<<<< This one?!
			say("asdasdasd")
		end
	

 

 

no.. 
time('23:59:59') query for database not quest.
countdown query