[Help]Auto insert points

[deviling124]

Can i request of script that will give points every 5 mins?

ex.

Player 1 was online in 5 mins Player 1 will receive 1 points. Planing to make a free point mall but kinda noob xd

Thank you in advance!

[DretoNEX]

No offence but if you plan on making an item mall and you have no idea how to add some points thats not making thats copy pasting.

[deviling124]

Originally Posted by DretoNEX

No offence but if you plan on making an item mall and you have no idea how to add some points thats not making thats copy pasting.

I know how to use basic insert / update. making procedure is kinda hard for me.

Anw problem solve thank you kthxbai2 for this

[asdfRohan]

#Rapported

[itdhos]

Third party program is the best i can offer to you.

[molla121]

Ex.
--rallystart1hr
declare @ount int
declare @d int
declare @point int
select @ount = [play_sec]
from TCharacterLogin
where char_id = @_id
select @d = [char_id]
from TCharacterLogin
where play_sec >= @ount

if @ount >= 3600)
begin
INSERT INTO dbo.TEventItem (type, attr, stack, rank, equip_level, equip_dexterity, equip_intelligence, equip_strength, char_id) VALUES (4391040, 0x1A02001B01001901002501001701000D0100070100, 1, 0, 0, 0, 0, 0, @d)
update RohanGame.dbo.TCharacterLogin set play_sec = play_sec - 3600 where char_id = @d
end
--rallyend1hr

[deviling124]

It was posted 2 years ago xd and I already made it worked thank you for sharing it I hope it will help new ppl here