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

[modog1545]

Caipi you say i got this error becz i use sql05 .. now i use sql08 and i have same error ?!

Msg 156, Level 15, State 1, Procedure _GetRandomTime, Line 14
Incorrect syntax near the keyword 'CONVERT'.
Msg 137, Level 15, State 2, Procedure _GetRandomTime, Line 19
Must declare the scalar variable "@BasicDate". 

[hellangel2]

If You wanna really Shared your Experience, WHY DONT ADD QUERYS FOR SQL 2005 ?

So, u cant see much Friends Use SQL 2005 and Wanna Do ur work too...

Make sure do ur best , or do nothing !!!

Its my Opinion !!


Then, if possible, ADD QUERYS TO 2005 TOO !!

[Caipi]

If You wanna really Shared your Experience, WHY DONT ADD QUERYS FOR SQL 2005 ?

So, u cant see much Friends Use SQL 2005 and Wanna Do ur work too...

Make sure do ur best , or do nothing !!!

Its my Opinion !!


Then, if possible, ADD QUERYS TO 2005 TOO !!

Cut the crap, it's supposed to work in MSSQL '08, I didn't check its compatibility for '05.
If you're not even able to change the declaration part of variables (You can't declare and set variables in '05 at once) then you better stop to work with these files.

[hellangel2]

Cut the crap, it's supposed to work in MSSQL '08, I didn't check its compatibility for '05.
If you're not even able to change the declaration part of variables (You can't declare and set variables in '05 at once) then you better stop to work with these files.

I know that Very Well my friend ..

SO IF U WAS ASK ABOUT TAKE

FOR SQL 2005:

USE SRO_VT_SHARD
GO

CREATE PROCEDURE _GetRandomTime /*by Caipi*/

@TodaysDate datetime,
@EndDate datetime OUTPUT

AS BEGIN

SET @EndDate = GETDATE();

WHILE (@EndDate <= GETDATE())
    BEGIN
                
DECLARE @BasicDate varchar(12), @Hour varchar(2), @Minutes varchar(2), @Seconds varchar(2);
                

        SET @EndDate = CONVERT(DATETIME,@BasicDate + ' ' + @Hour + ':' + @Minutes + ':' + @Seconds)
    END

END 

SO On..



THE QUEST IS:

This site is for ONE TEACH OTHERS, and no for ASK IF can't work with filles, to stop ...

IF YOU DONT HAVE PACIENCE TO TEACH.. BETTER DONT POST ...

[RevoLand]

I know that Very Well my friend ..

SO IF U WAS ASK ABOUT TAKE

FOR SQL 2005:

USE SRO_VT_SHARD
GO

CREATE PROCEDURE _GetRandomTime /*by Caipi*/

@TodaysDate datetime,
@EndDate datetime OUTPUT

AS BEGIN

SET @EndDate = GETDATE();

WHILE (@EndDate <= GETDATE())
    BEGIN
                
DECLARE @BasicDate varchar(12), @Hour varchar(2), @Minutes varchar(2), @Seconds varchar(2);
                

        SET @EndDate = CONVERT(DATETIME,@BasicDate + ' ' + @Hour + ':' + @Minutes + ':' + @Seconds)
    END

END 

SO On..



THE QUEST IS:

This site is for ONE TEACH OTHERS, and no for ASK IF can't work with filles, to stop ...

IF YOU DONT HAVE PACIENCE TO TEACH.. BETTER DONT POST ...

Stop flaming on Caipi MORON !
And forum rules rule 1

1. Always show respect towards each other. Flames and personal attacks are not welcome at RaGEZONE. This includes but not limited to; racism, xenophobia, etc.

[hellangel2]

Stop flaming on Caipi MORON !
And forum rules rule 1

Iam Don't Flaming, only do my opinion... ITS IREGULAR ? IF U ARE SO GOOD, THEN LOOK AHEAD ON TOPIC AND SEE MUCH REALLY FLAMING!!!


So on .. Iam Stop See TOPIC Right Now ....

[Caipi]

Iam Don't Flaming, only do my opinion... ITS IREGULAR ? IF U ARE SO GOOD, THEN LOOK AHEAD ON TOPIC AND SEE MUCH REALLY FLAMING!!!


So on .. Iam Stop See TOPIC Right Now ....

Yo you're here in the Release section, it ain't a Guide one - such brainless people like you make me regret that I've even posted it. Get yo an english book and check what "release" essentially means. Dun complain just because you're a friggin lazy bum, you could've also simply downloaded mssql 2008 instead of bitching about the incompatibility of the queries in the '05 version.

[hellangel2]

Yo you're here in the Release section, it ain't a Guide one - such brainless people like you make me regret that I've even posted it. Get yo an english book and check what "release" essentially means. Dun complain just because you're a friggin lazy bum, you could've also simply downloaded mssql 2008 instead of bitching about the incompatibility of the queries in the '05 version.

THIS IS A FLAMING :)

Alhead Use SQL 2008 R2 and Soon Update to 2012 ... But iam ask for others, no me !!!!

[Caosfox]

is not a silkroad vital procedure, is an add-on.. say thx caipi even release it
how to convert from ms sql 2008 to other version, please google about ms sql sites/guides.

in other hand, if i release a proc and i have sql 2008r2, i must install 2005, 2000, 2012, 1e25 version of sql to make the same proc over and over again?

dont like the proc? dont use it
the proc dont work? fix it
you tried to fix it and you cant? then ask for help... and so far i dont even see you trying

[hellangel2]

Thats right, why for me WORK, but i ask for others..

Iam Alhead THX CAIPI -- If he come in my house, i will do for he a CAIPIrinha.... From Brazil :)

[Chaparim]

Hey Caipi,

I am exec all querys With Sucess and all tablet and Procedures have now on my database and working ... So, in _OnlineOffline Tablet, Collum "esilk" and "tminutes" alhead counting silks and time BUT DON'T APPERS FOR PLAYES IN GAME ...

Why ?

I beliver is a easy step ...

[waleedtiger]

nice realase

[Chaparim]

Someone Can Ask me ... Is only execute querys ?

[neisser1]

Yo you're here in the Release section, it ain't a Guide one - such brainless people like you make me regret that I've even posted it. Get yo an english book and check what "release" essentially means. Dun complain just because you're a friggin lazy bum, you could've also simply downloaded mssql 2008 instead of bitching about the incompatibility of the queries in the '05 version.

friend, how I can create the table _AddLogChar please help

[Sorry007]

Caipi I Love you BIG THX for tis