[Help Question]

[raverking]

if someone wont mind, what control panel is fit for RAN GS EPX (Grayback's share)? the character has its own premium point whereas most of the rancp is account-based premium point, i want to bind them together, whereas if your character has 100 premium point it will show on control panel but almost here are account not character premium point

example : some rancp's are have this configuration on php's

[db4]dbo.UserInfo whereas Points=Points where username=user ( just an example ) <--this binds to account
but Ran GS has
[db2]dbo.ChaInfo whereas ChaPremiumPoint <--- this binds to only 1 character

 

[baby011528]

if someone wont mind, what control panel is fit for RAN GS EPX (Grayback's share)? the character has its own premium point whereas most of the rancp is account-based premium point, i want to bind them together, whereas if your character has 100 premium point it will show on control panel but almost here are account not character premium point

example : some rancp's are have this configuration on php's

[db4]dbo.UserInfo whereas Points=Points where username=user ( just an example ) <--this binds to account
but Ran GS has
[db2]dbo.ChaInfo whereas ChaPremiumPoint <--- this binds to only 1 character

you can make a list of character with point
example : [db2]select chaname,chapremiumpoint from chainfo where usernum=(select usernum from db4.dbo.userinfo where userid='testid') and CHADELETED <> 1
or get a sum of that

 

[raverking]

you can make a list of character with point
example : [db2]select chaname,chapremiumpoint from chainfo where usernum=(select usernum from db4.dbo.userinfo where userid='testid') and CHADELETED <> 1
or get a sum of that

is that the real php code?

 

[TanGzkie]

is that the real php code?

Hello !

they use another dbase to bind to an account through web only but no points on Dbo.Ranuser its called Userpoint if you want update it you need to code :

::CODE
UPDATE UserPoint SET UserPoint='$points' WHERE username='$usernane' and userpass='$userpass' md5 hashed..

and try to see parameters how they worked it out....





THIS PARAMETER BELOW BELONGS TO THE CUSTOM DBASE OF THERE CP...
GO
/****** Object: StoredProcedure [dbo].[sp_doEP2VP] Script Date: 04/27/2019 12:36:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_doEP2VP]
username char(20),
Get_vp int,
vps int,
retval int OUTPUT

AS
DECLARE
@currentEP int,
@currentVP int

SET NOCOUNT ON

SET retval = 0
SET @currentEP = 0
SET @currentVP = 0

SELECT @currentEP = Points FROM Points WHERE UserName username
SELECT @currentVP = VPoints FROM Points WHERE UserName username


-----------------------------------------------------------------
BEGIN
IF vps > @currentEP)
BEGIN
SET retval = 0 -- 0 = Not enough points
SELECT retval
RETURN retval
END
ELSE
BEGIN
UPDATE Points SET Points = Points - vps,VPoints = VPoints + Get_vp WHERE UserName = username
SET retval = 1 -- 1 = Success convert
SELECT retval
RETURN retval
END
END

SET NOCOUNT OFF
SELECT retval
RETURN retval



This code worked the points ....

 

[raverking]

Hello !

they use another dbase to bind to an account through web only but no points on Dbo.Ranuser its called Userpoint if you want update it you need to code :

::CODE
UPDATE UserPoint SET UserPoint='$points' WHERE username='$usernane' and userpass='$userpass' md5 hashed..

and try to see parameters how they worked it out....





THIS PARAMETER BELOW BELONGS TO THE CUSTOM DBASE OF THERE CP...
GO
/****** Object: StoredProcedure [dbo].[sp_doEP2VP] Script Date: 04/27/2019 12:36:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_doEP2VP]
@username char(20),
@Get_vp int,
@vps int,
@retval int OUTPUT

AS
DECLARE
@currentEP int,
@currentVP int

SET NOCOUNT ON

SET @retval = 0
SET @currentEP = 0
SET @currentVP = 0

SELECT @currentEP = Points FROM Points WHERE UserName @username
SELECT @currentVP = VPoints FROM Points WHERE UserName @username


-----------------------------------------------------------------
BEGIN
IF @vps > @currentEP)
BEGIN
SET @retval = 0 -- 0 = Not enough points
SELECT @retval
RETURN @retval
END
ELSE
BEGIN
UPDATE Points SET Points = Points - @vps,VPoints = VPoints + @Get_vp WHERE UserName = @username
SET @retval = 1 -- 1 = Success convert
SELECT @retval
RETURN @retval
END
END

SET NOCOUNT OFF
SELECT @retval
RETURN @retval



This code worked the points ....

no what i mean is the premium point is binded to every character not to the whole account which has the characters.

 

[TanGzkie]

Google is youre friend....
This code...
----------------------------------------------------

need to select sql :

select * from RanGame1.dbo.ChaInfo inner join RanUser.dbo.UserInfo on RanGame1.dbo.ChaInfo.UserNum = RanUser.dbo.UserInfo.UserNum
where RanUser.dbo.UserInfo.UserNum = '257' and RanGame1.dbo.ChaInfo.ChaDeleted <> 1


then use the update :

UPDATE
ChaInfo
SET
ChaInfo.ChaPremiumPoint = '1'
FROM
RanUser.dbo.UserInfo AS Table_A
INNER JOIN RanGame1.dbo.ChaInfo AS Table_B
ON Table_B.UserNum = Table_A.UserNum
WHERE
Table_A.ChaName = 'name'

 

[baby011528]

is that the real php code?

why you dont just modify from source code that move chainfo.chapremiumpoint to userinfo?
and it sure can read for all char in 1 account....

 

[raverking]

why you dont just modify from source code that move chainfo.chapremiumpoint to userinfo?
and it sure can read for all char in 1 account....

im not really pro at source code, i dont know where it is exactly to look

 

[baby011528]

im not really pro at source code, i dont know where it is exactly to look

im not really pro in php...i know asp as well & sql
source is just enough for me to open small server..

 

[raverking]

im not really pro in php...i know asp as well & sql
source is just enough for me to open small server..

where do i have to look in source to change the premiumpoint from rangame1 to ranuser?

 

[baby011528]

where do i have to look in source to change the premiumpoint from rangame1 to ranuser?

you can try to search it on source
something like chapremiumpoint for all the details
and try read on it..
i not really pro in source , for me i have to try many times just can done modify it...

 

[raverking]

you can try to search it on source
something like chapremiumpoint for all the details
and try read on it..
i not really pro in source , for me i have to try many times just can done modify it...

did, can't find it

 

[baby011528]

did, can't find it

what source that you using?

 

[Mustafa5]

use mssql_num_rows? or I am wrong? I forgot it already, once I find my old website, I will share it to you, for you to extract such code.

 

[raverking]

what source that you using?

EP10 by Grayback

use mssql_num_rows? or I am wrong? I forgot it already, once I find my old website, I will share it to you, for you to extract such code.

tried, i just not master on php coding. but i tried to connect it just by account, still showing 0 on website