[Help]Auto insert points

05/12/2017 11:28 deviling124#1
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!:handsdown:
05/12/2017 12:05 DretoNEX#2
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.
05/12/2017 12:47 deviling124#3
Quote:
Originally Posted by DretoNEX View Post
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 :D
05/12/2017 15:48 asdfRohan#4
#Rapported
05/14/2017 12:00 itdhos#5
Third party program is the best i can offer to you.
06/18/2019 08:56 molla121#6
Ex.
--rallystart1hr
declare @[Only registered and activated users can see links. Click Here To Register...]ount int
declare @[Only registered and activated users can see links. Click Here To Register...]d int
declare @[Only registered and activated users can see links. Click Here To Register...]point int
select @[Only registered and activated users can see links. Click Here To Register...]ount = [play_sec]
from TCharacterLogin
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id
select @[Only registered and activated users can see links. Click Here To Register...]d = [char_id]
from TCharacterLogin
where play_sec >= @[Only registered and activated users can see links. Click Here To Register...]ount

if @[Only registered and activated users can see links. Click Here To Register...]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, @[Only registered and activated users can see links. Click Here To Register...]d)
update RohanGame.dbo.TCharacterLogin set play_sec = play_sec - 3600 where char_id = @[Only registered and activated users can see links. Click Here To Register...]d
end
--rallyend1hr
06/21/2019 03:28 deviling124#7
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 :D