[SQL] auto free Silk/Hour based on the Online time (System)

[saxz]

nope, you didnt

look at the end of topic
you will see this
"""It's the bad of GlorySRO that I've created this one ;o"""
i dont lie

[Caipi]

#Realised the request, you can state your own schedule now + own rates at the new table

In case you are using the older version DROP everything and recreate it through the stated queries, I changed several parts

[hectormousa]

thanks caipi

[lemoniscool]

nice one like always :D

[Jangan]

god.. that took forever to understand what you were trying to do with the random time + character thing... arrg!! and i still don't get it? how the hell does that work exactly..


also.. very nice :O

[Caipi]

alter sro vt account -> table = _Insertnewchar? -> insert into the log char the information of the new character...

Hum? Dun get that, it adds everything automatically - you'd only need to create all those new tables and SP's and set your own rates at the config table -> that's it ^^

[Jangan]

Hum? Dun get that, it adds everything automatically - you'd only need to create all those new tables and SP's and set your own rates at the config table -> that's it ^^

yeah i saw... btw you should use the CGI_WebPurchaseSilk instead of just insert into sk_silk :P since it will log in game for people so they have a reference or something xD

[Caipi]

yeah i saw... btw you should use the CGI_WebPurchaseSilk instead of just insert into sk_silk :P since it will log in game for people so they have a reference or something xD

As soon as the Online time exceeds 59 minutes the silks will be added -> would turn out into a mess if you'd have a log of those ^^ they'll recognize it anyway

But feel free to edit it on the way you'd like to have it working

[Jangan]

really love this lol... i will use this ^.^
Perfection Network

if anyone wants my ranking script pm me...

[Caipi]

really love this lol... i will use this ^.^
Perfection Network

if anyone wants my ranking script pm me...

Glad to see that it's useful ^^

[safty0202]

alot of error in sql 2005 :(

[st0o0ry]

Thank You Caipi For that But i cant Set silk hour and random player silk .. so can u Give us more Example Pls !!

[safty0202]

guys this thing is dced u right ??

[Caipi]

guys this thing is dced u right ??

DC's doesn't make sense since it's based on a long procedure and doesn't return any specific value which could cause into dc'd




@ st0o0ry, what's the matter exactly? ^^ There's only one table where you can edit those rates, do it before creating the other tables/procedures

[Jangan]

seriously?? you people run private servers and have 0 knowledge of SQL? thats sad and depressing...

for people saying they get errors...

replace:

USE [USE SRO_VT_SHARDLOG]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_GetSilkperHour] /*by Caipi*/

@CharID int

with

USE [SRO_VT_SHARDLOG]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_GetSilkperHour] /*by Caipi*/

@CharID int

..... if you dont know what im saying.. then dont host a private server thanks...