Transform online hours in cash shop points

Is there any guide for transforming online hours to PC points?

How to transform online hours in webshop credits?
Help Please!

For Webshop Credits and PCPoints, it's actually quite similar.
Assuming you are using MUCore, the location of Webshop Credits should locate at MEMB_CREDITS, thus, you add these lines:

under the declaration:

Code:

---

declare @credits int

---

Under Selection:

Code:

---

SELECT @credits= credits FROM MEMB_CREDITS where memb___id = @uid
Under Calculation of Online Hours ->CSPoints
        UPDATE [dbo].[MEMB_CREDITS]
        SET credits= credits + (@OnlineHours * 10)
        WHERE memb___id = @uid

---

PCPoints are similar, assuming you are using the TitanTech Packages, it should be located at SCFPCPoints under Characters table:
declare @SCFPCPoints int
SELECT @SCFPCPoints= SCFPCPoints FROM Character where AccountID = @uid
UPDATE [dbo].[Character]
SET SCFPCPoints= SCFPCPoints + (@OnlineHours * 1)
WHERE AccountID = @uid

These should work.

Notice that the commands must go to their sections! If you paste them together there WILL be an error. My Completed scripts are here:

Code:

---

BEGIN TRANSACTION

SET NOCOUNT ON
        Declare  @find_id varchar(10)
        declare @OnlineHours real
        declare @SCFVipMoney int
        declare @SCFPCPoints int
        declare @credits int

        SELECT @SCFVipMoney= SCFVipMoney FROM MEMB_INFO where memb___id = @uid
        SELECT @SCFPCPoints= SCFPCPoints FROM Character where AccountID = @uid
        SELECT @credits= credits FROM MEMB_CREDITS where memb___id = @uid

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET DisConnectTM = (getdate()), connectstat = 0,OnlineHours = @SCFVipMoney/10+(DATEDIFF(hh,ConnectTM,getdate())) WHERE memb___id = @uid
        SELECT  @OnlineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @uid

        UPDATE [dbo].[MEMB_INFO]
        SET SCFVipMoney= SCFVipMoney + (@OnlineHours * 1)
        WHERE memb___id = @uid

        UPDATE [dbo].[Character]
        SET SCFPCPoints= SCFPCPoints + (@OnlineHours * 1)
        WHERE AccountID = @uid

        UPDATE [dbo].[MEMB_CREDITS]
        SET credits= credits + (@OnlineHours * 0)
        WHERE memb___id = @uid
End

---

Again, don't outright copy it! No two databases are the same!

[QUOTE=nemoma;7109161]For Webshop Credits and PCPoints, it's actually quite similar.
Assuming you are using MUCore, the location of Webshop Credits should locate at MEMB_CREDITS, thus, you add these lines:

under the declaration:

Code:

---

declare @credits int

---

Under Selection:

Code:

---

SELECT @credits= credits FROM MEMB_CREDITS where memb___id = @uid
Under Calculation of Online Hours ->CSPoints
        UPDATE [dbo].[MEMB_CREDITS]
        SET credits= credits + (@OnlineHours * 10)
        WHERE memb___id = @uid

---

[/QUTE]

where will I add this? In Table or Stored Procedure?

any additional and clear guidelines?

http://i165.photobucket.com/albums/u...itled-1-36.png

how is possible to fix this error
I use 4.5 files

Quote:

---

Originally Posted by nemoma

For Webshop Credits and PCPoints, it's actually quite similar.
Assuming you are using MUCore, the location of Webshop Credits should locate at MEMB_CREDITS, thus, you add these lines:

under the declaration:

Code:

---

declare @credits int

---

Under Selection:

Code:

---

SELECT @credits= credits FROM MEMB_CREDITS where memb___id = @uid
Under Calculation of Online Hours ->CSPoints
        UPDATE [dbo].[MEMB_CREDITS]
        SET credits= credits + (@OnlineHours * 10)
        WHERE memb___id = @uid

---

PCPoints are similar, assuming you are using the TitanTech Packages, it should be located at SCFPCPoints under Characters table:
declare @SCFPCPoints int
SELECT @SCFPCPoints= SCFPCPoints FROM Character where AccountID = @uid
UPDATE [dbo].[Character]
SET SCFPCPoints= SCFPCPoints + (@OnlineHours * 1)
WHERE AccountID = @uid

These should work.

Notice that the commands must go to their sections! If you paste them together there WILL be an error. My Completed scripts are here:

Code:

---

BEGIN TRANSACTION

SET NOCOUNT ON
        Declare  @find_id varchar(10)
        declare @OnlineHours real
        declare @SCFVipMoney int
        declare @SCFPCPoints int
        declare @credits int

        SELECT @SCFVipMoney= SCFVipMoney FROM MEMB_INFO where memb___id = @uid
        SELECT @SCFPCPoints= SCFPCPoints FROM Character where AccountID = @uid
        SELECT @credits= credits FROM MEMB_CREDITS where memb___id = @uid

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET DisConnectTM = (getdate()), connectstat = 0,OnlineHours = @SCFVipMoney/10+(DATEDIFF(hh,ConnectTM,getdate())) WHERE memb___id = @uid
        SELECT  @OnlineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @uid

        UPDATE [dbo].[MEMB_INFO]
        SET SCFVipMoney= SCFVipMoney + (@OnlineHours * 1)
        WHERE memb___id = @uid

        UPDATE [dbo].[Character]
        SET SCFPCPoints= SCFPCPoints + (@OnlineHours * 1)
        WHERE AccountID = @uid

        UPDATE [dbo].[MEMB_CREDITS]
        SET credits= credits + (@OnlineHours * 0)
        WHERE memb___id = @uid
End

---

Again, don't outright copy it! No two databases are the same!

---

hello mates can you help me with this: http://forum.ragezone.com/f193/php-s...points-934064/

the server we used is TitanTech Package. no custom
custom item has been disabled!
yes i knew we used SCF.cfg. as the server configuration which is connected to the database!
pls i need your help, at the moment i knew some of it.

support muserver season 2 ?

don`t work :( Did all the instructions. script adds 2,210 points for reconnet

My online hours fields are empty. How to turn them to count whne player is online?

Nice guide will try this also

i change for enemy web, web credits:

Step 1
First enter Start -> All programs-> Sql server -> enterprise manager ->DATABASE->MuOnline-> Tables
Here look for MEMB_STAT , right click and chose Design Table and create a new column like the following:
Column_name: OnlineHours
Type: int
Allow Nulls: unchecked
Default value: 0

Step 2
Same location in MuOnline enter Stored Procedures and find WZ_DISCONNECT_MEMB. Douable click on it and replace the actual code with this one

CREATE PROCEDURE [dbo].[WZ_DISCONNECT_MEMB] @memb___id varchar(10)
AS
Begin
set nocount on
Declare @Find_id varchar(10)
Declare @Connectstat tinyint
declare @OnLineHours real
declare @Credits int
Set @Connectstat = 0
Set @Find_id = 'NOT'
select @Find_id = S.memb___id from MEMB_STAT S INNER JOIN EW_CREDITS I ON S.memb___id = I.memb___id
where I.memb___id = @memb___id
if( @Find_id <> 'NOT' )
begin
SELECT @Credits= credits FROM EW_CREDITS where memb___id = @memb___id
update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = @Credits/10+(DATEDIFF(hh,ConnectTM,getdate()))
where memb___id = @memb___id
SELECT @OnLineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @memb___id

UPDATE [dbo].[EW_CREDITS]
SET credits= @OnLineHours * 10)
WHERE memb___id = @memb___id

end
end
GO


work only on ENEMY WEB!

its not working season 6

can you webshop credits?

script

online hours = WCoins plss!

im using titantech

plss :)