Most visitors online was 8830 , on 6 Feb 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!i already add them manually in dbo.ranshop but here in GM tool the function is not working.Anyone here know how to make topup vocher?? And whe i can get premium point and epoint? Thank You
Just add the item first bro ������
i already add them manually in dbo.ranshop but here in GM tool the function is not working.
FOr the top up i manually add them in Ranuser.
can you give me example? do you know how to add premium point cus i alwats failed to buy item shop
I Always fail buy itemshop
I found a problem on converting gametime points to vpoints:
I have 4 vpoints.. and i am going to convert gametime to vpoints it has 6 points to convert..but when done,. instead i have 10 vpoints.. i only have 8 points. where is the 2 points?
mssql_query("INSERT INTO ".RanUser.".dbo.TopUp (vocercode,pin,point) VALUES ('$vocercode','$pin','$totalpoint) ");
$vocercode = specialchars($_POST['code']);
$pin = specialchars($_POST['pin']);
$totalpoint = (int)$_POST[totalpoint'];
Use RanUser
DECLARE @nCodeCounter int, @nCodeGen int, @nCodeValue int, @nCodeCp int, @nCodeAgent int, @nCardFound int, @nCardType int, @nCardId varchar(50),@nCardCode varchar(50),@nCardPrice int
SET @nCodeCounter = 0
SET @nCodeGen = 10
SET @nCodeValue = 1100
SET @nCodeCp = 0
SET @nCardPrice = 0
SET @nCodeAgent = 0
SET @nCardFound = 0
SET @nCardType = 1
--dummy codes generate
WHILE @nCodeCounter < @nCodeGen
BEGIN
SET @nCardId = char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
SET @nCardCode = char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
SELECT @nCardFound = ID
FROM TopUp
WHERE Code = @nCardId
IF @nCardFound <> 0
BEGIN
continue
END
ELSE
BEGIN
INSERT INTO TopUp( Code, CodeValue, Pin)
values( @nCardId,@nCodeValue,@nCardCode)
END
SET @nCodeCounter = @nCodeCounter+1
END
SELECT * From TopUp
how can i activated TopUp Function?? i try to input with query and manual, but after that i try to insert code and pin in game i always got error massage "Top Up Error"
check stored procedure . gametimecvt .
-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[user_gametimecvt] Script Date: 10/30/2021 1:31:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[user_gametimecvt]
@szUserID varchar (33),
@nReturn int OUTPUT
AS
SET NOCOUNT ON
DECLARE
-- Declare variables used in error checking.
[USER=116066]ERROR[/USER]_var int,
[USER=349225]Row[/USER]count_var int,
[USER=77438]Nuser[/USER]Num int,
@nGameTime int,
@nGameTimeDiv int,
@nGameTimeRes int,
@vUserName varchar(33),
[USER=531890]Minute[/USER]s int,
@Total int,
@PMinutes int,
@PTotal int,
@wa int,
[USER=2000285344]sago[/USER]t int,
[USER=2000285344]sago[/USER]t1 int,
[USER=2000285344]sago[/USER]t2 int,
@after int,
@af1 int,
@af2 int,
@pafter int,
@BP int
--set your configuration here
SET @nGameTimeDiv = 60;
SET @nGameTimeRes = 2;
SELECT [USER=77438]Nuser[/USER]Num = UserNum , @vUserName = UserID , @nGameTime = PlayTime , @BP = UserPoint2 From UserInfo Where UserName = @szUserID
--calculate
SET [USER=531890]Minute[/USER]s = @nGameTime / @nGameTimeDiv;
SET @Total = [USER=531890]Minute[/USER]s
SET @PMinutes = @nGameTime/@nGameTimeDiv;
SET @PTotal = @PMinutes;
--conversion
SET @wa=@nGameTime/@nGameTimeDiv;
SET [USER=2000285344]sago[/USER]t=@wa;
SET [USER=2000285344]sago[/USER]t1 [USER=2000285344]sago[/USER]t*@nGameTimeDiv;
SET [USER=2000285344]sago[/USER]t2 [USER=2000285344]sago[/USER]t*@nGameTimeRes;
--FOR LOG
SET @after = @nGameTime - [USER=2000285344]sago[/USER]t1;
SET @af1=@after/@nGameTimeDiv
SET @af2=@af1;
SET @pafter = @BP + [USER=2000285344]sago[/USER]t2;
SELECT [USER=116066]ERROR[/USER]_var = [USER=116066]ERROR[/USER], [USER=349225]Row[/USER]count_var = [USER=349225]Row[/USER]COUNT
IF [USER=77438]Nuser[/USER]Num !=0
BEGIN
IF @nGameTime >= @nGameTimeDiv
BEGIN
-- update point
UPDATE dbo.UserInfo SET UserPoint2 = UserPoint2 + [USER=2000285344]sago[/USER]t2 , PlayTime = PlayTime - [USER=2000285344]sago[/USER]t1 WHERE UserName = @szUserID
SET @nReturn = [USER=77438]Nuser[/USER]Num
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
END
ELSE
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
SET NOCOUNT OFF
RETURN @nReturn
this is the result.
PHP:-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName> -- Add the parameters for the stored procedure here <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0> AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2> END GO
Code:USE [RanUser] GO /****** Object: StoredProcedure [dbo].[user_gametimecvt] Script Date: 10/30/2021 1:31:31 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[user_gametimecvt] @szUserID varchar (33), @nReturn int OUTPUT AS SET NOCOUNT ON DECLARE -- Declare variables used in error checking. [USER=116066]ERROR[/USER]_var int, [USER=349225]Row[/USER]count_var int, [USER=77438]Nuser[/USER]Num int, @nGameTime int, @nGameTimeDiv int, @nGameTimeRes int, @vUserName varchar(33), [USER=531890]Minute[/USER]s int, @Total int, @PMinutes int, @PTotal int, @wa int, [USER=2000285344]sago[/USER]t int, [USER=2000285344]sago[/USER]t1 int, [USER=2000285344]sago[/USER]t2 int, @after int, @af1 int, @af2 int, @pafter int, @BP int --set your configuration here SET @nGameTimeDiv = 60; SET @nGameTimeRes = 2; SELECT [USER=77438]Nuser[/USER]Num = UserNum , @vUserName = UserID , @nGameTime = PlayTime , @BP = UserPoint2 From UserInfo Where UserName = @szUserID --calculate SET [USER=531890]Minute[/USER]s = @nGameTime / @nGameTimeDiv; SET @Total = [USER=531890]Minute[/USER]s SET @PMinutes = @nGameTime/@nGameTimeDiv; SET @PTotal = @PMinutes; --conversion SET @wa=@nGameTime/@nGameTimeDiv; SET [USER=2000285344]sago[/USER]t=@wa; SET [USER=2000285344]sago[/USER]t1 [USER=2000285344]sago[/USER]t*@nGameTimeDiv; SET [USER=2000285344]sago[/USER]t2 [USER=2000285344]sago[/USER]t*@nGameTimeRes; --FOR LOG SET @after = @nGameTime - [USER=2000285344]sago[/USER]t1; SET @af1=@after/@nGameTimeDiv SET @af2=@af1; SET @pafter = @BP + [USER=2000285344]sago[/USER]t2; SELECT [USER=116066]ERROR[/USER]_var = [USER=116066]ERROR[/USER], [USER=349225]Row[/USER]count_var = [USER=349225]Row[/USER]COUNT IF [USER=77438]Nuser[/USER]Num !=0 BEGIN IF @nGameTime >= @nGameTimeDiv BEGIN -- update point UPDATE dbo.UserInfo SET UserPoint2 = UserPoint2 + [USER=2000285344]sago[/USER]t2 , PlayTime = PlayTime - [USER=2000285344]sago[/USER]t1 WHERE UserName = @szUserID SET @nReturn = [USER=77438]Nuser[/USER]Num RETURN @nReturn END ELSE BEGIN SET @nReturn = 0 RETURN @nReturn END END ELSE BEGIN SET @nReturn = 0 RETURN @nReturn END SET NOCOUNT OFF RETURN @nReturn
my problem is everytime i convert my gametime to vpoints it always -2 vpoints when added.
check your wGameTimeDiv & wGameTimeRes in source. source and sql query must be the same value.
your topup code is already use . change bused from 1 to 0
I see now it's fixed ..thanks
find namedisplay cpp, add new line bellow cdisplay setnameanyone share gm name color.?
if ( IsGM() )
{
if ( RANPARAM::bFeatureActivity && strBadge.GetLength() )
{
CBasicTextBox::STEXTMULTIWORDVEC vectext;
CString strTitle;
strTitle.Format( "<%s>", strBadge.GetString() );
CBasicTextBox::STEXTMULTIWORD word_title;
word_title.strWord = strTitle.GetString();
word_title.dwColor = NS_UITEXTCOLOR::ORNAGERED;
vectext.push_back( word_title );
CBasicTextBox::STEXTMULTIWORD word_name;
word_name.strWord = strName.GetString();
word_name.dwColor = NS_UITEXTCOLOR::ORNAGERED;
vectext.push_back( word_name );
m_pNameBox->AddMultiTextNoSplit( vectext );
}
else
{
m_pNameBox->AddTextNoSplit( strName, NS_UITEXTCOLOR::ORNAGERED );
}
}
public:
BOOL IsGM () { return (m_sDISP_INFO.m_bHideGMInfo); }
sir can you share no black background in Ingame name? tiafind namedisplay cpp, add new line bellow cdisplay setnameand for header :Code:if ( IsGM() ) { if ( RANPARAM::bFeatureActivity && strBadge.GetLength() ) { CBasicTextBox::STEXTMULTIWORDVEC vectext; CString strTitle; strTitle.Format( "<%s>", strBadge.GetString() ); CBasicTextBox::STEXTMULTIWORD word_title; word_title.strWord = strTitle.GetString(); word_title.dwColor = NS_UITEXTCOLOR::ORNAGERED; vectext.push_back( word_title ); CBasicTextBox::STEXTMULTIWORD word_name; word_name.strWord = strName.GetString(); word_name.dwColor = NS_UITEXTCOLOR::ORNAGERED; vectext.push_back( word_name ); m_pNameBox->AddMultiTextNoSplit( vectext ); } else { m_pNameBox->AddTextNoSplit( strName, NS_UITEXTCOLOR::ORNAGERED ); } }
Code:public: BOOL IsGM () { return (m_sDISP_INFO.m_bHideGMInfo); }
find this codesir can you share no black background in Ingame name? tia
CBasicLineBoxEx* pLineBox = new CBasicLineBoxEx;
pLineBox->CreateSub ( this, "BASIC_LINE_BOX_EX_NAME", UI_FLAG_XSIZE | UI_FLAG_YSIZE );
pLineBox->CreateBaseBoxName ( "BASIC_NAME_LINE_BOX" );
RegisterControl ( pLineBox );
m_pNameLineBox = pLineBox;
find this codeCode:CBasicLineBoxEx* pLineBox = new CBasicLineBoxEx; pLineBox->CreateSub ( this, "BASIC_LINE_BOX_EX_NAME", UI_FLAG_XSIZE | UI_FLAG_YSIZE ); pLineBox->CreateBaseBoxName ( "BASIC_NAME_LINE_BOX" ); RegisterControl ( pLineBox ); m_pNameLineBox = pLineBox;