Crontab for empty log + quest give DM

[Elijah 0]

Hi,

 

I have two questions ^^

I need a crontab for empty this table :

 

 

I need crontab for So that I can automatically emptied.

 

 

And second question :

It's possible change this quest :

quest bo_is begin
	state start begin
		function give_bonus_cash(account, count)
			mysql_query("UPDATE account.account SET cash=cash+'"..count.."' WHERE id='"..account.."'")
			syschat("Vous recevez "..count.." marques.")
		end
		when 80014.use or 80015.use or 80016.use or 80017.use begin
			local tableByVnum = 
			{
				[80014] = 100,
				[80015] = 500,
				[80016] = 1000,
			}
			bourse_is.give_bonus_cash(pc.get_account_id(), tableByVnum[item.get_vnum()])
			pc.remove_item(item.get_vnum(), 1)
		end
	end
end

For change the mysql_querry ?

I need this quest, but not use mysql_query. It's possible ?

 

Thanks ^^

Edited August 15, 2022 by Metin2 Dev
Core X - External 2 Internal

[Denis 1627]

pc.charge_cash(cash) it's for coins I think so

[metin2team 816]

                -- syntax : pc.charge_cash(amount, charge_type)
                -- warning:     1. 'charge_type' : "cash"(default) | "mileage"
                --            2. 'amount' must be positive number.

                pc.charge_cash(1000, "cash")

[Elijah 0]

What ? It's possible put your system in my quest ? Thanks.

[Denis 1627]

quest bo_is begin
    state start begin
        when 80014.use or 80015.use or 80016.use or 80017.use begin
            local tableByVnum =
            {
                [80014] = 100,
                [80015] = 500,
                [80016] = 1000,
            }
            pc.charge_cash(tableByVnum[item.get_vnum()], "cash")
            pc.remove_item(item.get_vnum(), 1)
        end
    end
end

[astinasti 7]

Ther'is one error:

80017.use begin

local tableByVnum =
            {
                [80014] = 100,
                [80015] = 500,
                [80016] = 1000,
            }

80017 In tableByVnum not exist

[Elijah 0]

It's work for the quest ! Thanks you ! ;D

 

And for my second problem, Help me please ^^

I need a crontab for empty this table :

 

 

I need crontab for So that I can automatically emptied.

 

 

 

 

Edited August 15, 2022 by Metin2 Dev
Core X - External 2 Internal