Transform online hours in cash shop points

I simply couldn't find a good guide to help me with this so i managed to do it alone and now i want to share it with you.It's my first guide and i hope it's gonna go all right. So let's get started. I will show you how every hour played on mu will automatically be transformed in points for cash shop.

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

Code:

---

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 @cspoints int
    Set @ConnectStat = 0   
    Set @find_id = 'NOT'
    select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id
          where I.memb___id = @memb___id
    if( @find_id <> 'NOT' )   
    begin       
        SELECT @cspoints= cs_points FROM MEMB_INFO where memb___id = @memb___id
        update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate(), OnlineHours = @cspoints/10+(DATEDIFF(hh,ConnectTM,getdate()))
        where memb___id = @memb___id
        SELECT  @OnlineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @memb___id

        UPDATE [dbo].[MEMB_INFO]
        SET cs_points=(@OnlineHours * 10)
        WHERE memb___id = @memb___id

    end
end
GO

---

Click ok and you're done
Things you should know:
The code is set to give 10 points per hour . If you want to change that do the following:
change hh(hour)
in year-yy, yyyy
quarter-qq, q
monthmm- m
day-dd, d
week-wk, ww
minute-mi, n
second-ss, s
These are the symbols if you want to change them, and to change the number of cash shop points received, change the "10" in the code with the number you want to receive.

Hope I was of help. I only tested it on sql server 2000 windows xp, don't know for others. Sorry for my english and sorry if i did something wrong. GL :thumbup:

EDIT: for values higher than 1 you must change in MEMB_STAT the OnlineHours column to REAL NOT INT

Nice guide, thank you very much

ohh.if this works...will be great to keep people online

and how about for Sql 2005 Standard

i am sorry but i only knoow a few programing things, made this for my own server and posted the solution cuz i didn't find it anywhere else. If anyone else would like to test it on a different sql please post if it works for other players to see.

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'hh'.


Help plz

hehe thats a good idea to keep people online if they want something for free :d

@DooMDesigN - I think that works the same way for any MSSQL. I use MSSQL 2008 and was smoothly

---
@sqrobert - I also need this for some time now and I'm looking for. But I have a question: if it does not work and I want to remove this procedure, as I do? Or just make a backup of the contents of WZ_DISCONNECT_MEMB ?

Thank you for sharing.

i just want to ask..how it worked if i wanted to transform hours online to PCPOINTS?.

Can you please tell me how to include auto pkclear in this script?

Got this error.
Error 446: Cannot resolve collation conflict for equal to operation.
http://i165.photobucket.com/albums/u...itled-1-36.png

Quote:

---

Originally Posted by nickypunk001

Got this error.
Error 446: Cannot resolve collation conflict for equal to operation.
http://i165.photobucket.com/albums/u...itled-1-36.png

---

*bump

I got same error as well. but i rename cs_points to WCoin

Quote:

---

UPDATE [dbo].[MEMB_INFO]
SET cs_points=(@OnlineHours * 10)
WHERE memb___id = @memb___id

---

Here for save old points otherwise its remove before,

Quote:

---

UPDATE [dbo].[MEMB_INFO]
SET cs_points=cs_points + (@OnlineHours * 10)
WHERE memb___id = @memb___id

---

Thanks for this GUIDE keep it up!

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 :)

can we just go through to the some servers and get the console HTML, and make it as PHP or somewhat language to reconfigure?

i don't know if it is recommend or right to do but, it that possible to translate F12 CONSOLE into codes etc, demo testing like DREAM_WEAVER or JSQuery? etc? just asking mates. thank you

Hey mate its a great job, but as I can change the points for zen?

please help me :D

Code:

---

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 @cspoints int
    Set @Connectstat = 0   
    Set @Find_id = 'NOT'
    select @Find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id
          where I.memb___id = @memb___id
    if( @Find_id <> 'NOT' )   
    begin       
        SELECT @cspoints= CSPoints FROM MEMB_INFO where memb___id = @memb___id
        update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = @cspoints/10+(DATEDIFF(hh,ConnectTM,getdate()))
        where memb___id = @memb___id
        SELECT  @OnLineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @memb___id


UPDATE [dbo].[MEMB_INFO]
SET CSPoints= CSPoints +  @OnLineHours * 10)
WHERE memb___id = @memb___id

end
end
GO

---

is this code correct for 10 CSPoints/h, i have the CSPoints in MEMB_INFO
===========================

Code:

---

SELECT @cspoints= CSPoints FROM MEMB_INFO where memb___id = @memb___id
        update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = @cspoints/10+(DATEDIFF(hh,ConnectTM,getdate()))

---

isnt this gives accounts credits/10+online hours? so i have 5k cspoints and i will get for 1h 5000/10+1? lel?

how to config for 5 CSPoints/h?
=================
and can someone give a sql script for "OnlineHours" cuz i create if but i cannot unbind the "allow nulls"
i use SQL 2000

Column_name: OnlineHours, MEMB_STAT
Type: int
Allow Nulls: unchecked <-i cant uncheck it, says MEMB_STAT doesnt allow nulls
Default value: 0 <- done have this ??