|
You last visited: Today at 16:58
Advertisement
Release | SR Proxy the best way to protect your private server!
Discussion on Release | SR Proxy the best way to protect your private server! within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
08/26/2019, 16:13
|
#601
|
elite*gold: 0 
Join Date: May 2018
Posts: 244
Received Thanks: 119
|
Quote:
Originally Posted by zuleidy1201
hi isoline why not leave relog mode in clientts sbot and mbot how fix
|
he will move the project to "Open source" soon as he said
|
|
|
|
08/27/2019, 22:14
|
#602
|
elite*gold: 0
Join Date: Sep 2015
Posts: 327
Received Thanks: 55
|
better compiled new version
|
|
|
|
|
08/28/2019, 00:16
|
#603
|
elite*gold: 0
Join Date: Apr 2015
Posts: 103
Received Thanks: 14
|
when source code will be released, we're waiting isoline <3
|
|
|
|
|
08/29/2019, 19:31
|
#604
|
elite*gold: 0
Join Date: Apr 2019
Posts: 172
Received Thanks: 55
|
Guild limited / Union not work any help ?!
|
|
|
|
|
08/30/2019, 10:50
|
#605
|
elite*gold: 4
Join Date: Jun 2019
Posts: 125
Received Thanks: 35
|
Good job Bro
|
|
|
|
|
08/31/2019, 00:45
|
#606
|
elite*gold: 0
Join Date: Mar 2018
Posts: 268
Received Thanks: 34
|
how i can fix it ?
help
|
|
|
|
|
09/02/2019, 01:15
|
#607
|
elite*gold: 0
Join Date: May 2006
Posts: 667
Received Thanks: 348
|
Quote:
Originally Posted by nevet.S
when source code will be released, we're waiting isoline <3
|
When i'll be back from my vacation in a few weeks, it will still be the version that's attached in the main thread aka the free ver, its a few years old.
Quote:
Originally Posted by Rupprecht
Guild limited / Union not work any help ?!
|
It works, check your settings.
Quote:
Originally Posted by the mighty
Good job Bro
|
Thank you.
Quote:
Originally Posted by Old_School
how i can fix it ?
help
|
Make sure your cgi silk sp in account db is working as it should.
|
|
|
|
|
09/02/2019, 23:48
|
#608
|
elite*gold: 0
Join Date: Jul 2017
Posts: 43
Received Thanks: 8
|
How can i start this Proxy, can i start it after the starting of server, or befor???
Gesendet von meinem SM-A750FN mit Tapatalk
|
|
|
|
|
09/03/2019, 14:42
|
#609
|
elite*gold: 0
Join Date: May 2006
Posts: 667
Received Thanks: 348
|
Quote:
Originally Posted by TechnicVreak
How can i start this Proxy, can i start it after the starting of server, or befor???
Gesendet von meinem SM-A750FN mit Tapatalk
|
Read the guides i wrote in the main thread.
|
|
|
|
|
09/04/2019, 00:41
|
#610
|
elite*gold: 0
Join Date: Apr 2019
Posts: 172
Received Thanks: 55
|
Quote:
Originally Posted by Isoline*
When i'll be back from my vacation in a few weeks, it will still be the version that's attached in the main thread aka the free ver, its a few years old.
It works, check your settings.
Thank you.
Make sure your cgi silk sp in account db is working as it should.
|
nah not working ?!
|
|
|
|
|
09/04/2019, 03:09
|
#611
|
elite*gold: 0
Join Date: Sep 2015
Posts: 327
Received Thanks: 55
|
Quote:
Originally Posted by Rupprecht
nah not working ?!
|
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebPurchaseSilk] Script Date: 9/4/2019 1:08:23 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebPurchaseSilk]
@OrderID VARCHAR(25),
@UserID VARCHAR(25),
@PkgID INT,
@NumSilk INT,
@Price INT
as
DECLARE @UserJID INT
DECLARE @SilkRemain INT
--DECLARE @PointRemain INT
SET @UserJID = CGI.getUserJID(@UserID)
IF( @UserJID >= 0)
BEGIN
IF( not exists( SELECT OrderNumber from SK_SilkBuyList where OrderNumber = @OrderID))
BEGIN
BEGIN TRANSACTION
IF( not exists( SELECT * from SK_Silk where JID = @UserJID))
BEGIN
INSERT SK_Silk(JID,silk_own,silk_gift,silk_Point)VALUES(@UserJID,@NumSilk,0,0)
--INSERT Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,0,@NumSilk,@NumSilk,@PkgID,1,@OrderID,"User Purchase Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@NumSilk,@NumSilk,0,0)
END
ELSE
BEGIN
SET @SilkRemain = CGI.getSilkOwn(@UserJID)
UPDATE SK_Silk SET silk_own = silk_own + @NumSilk WHERE JID = @UserJID
--INSERT Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,0,@NumSilk,@SilkRemain + @NumSilk,@PkgID,1,@OrderID,"User Purchase Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@SilkRemain + @NumSilk,@NumSilk,0,0)
END
IF (@@error <> 0 or @@rowcount = 0)
BEGIN
SELECT Result = "FAIL"
ROLLBACK TRANSACTION
RETURN
END
SELECT Result = "SUCCESS"
COMMIT TRANSACTION
RETURN
END
ELSE --else if order
BEGIN
SELECT Result = "ORDEREXIST"
END
END
ELSE
BEGIN
SELECT Result = "NOUSER"
RETURN
END
SET QUOTED_IDENTIFIER OFF
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebGetTotalSilk] Script Date: 9/4/2019 1:09:15 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebGetTotalSilk]
as
DECLARE @own FLOAT
SET @own = 0
SELECT @own = sum(silk_own) FROM SK_Silk
IF( @@error <> 0 or @@rowcount = 0 or @own = 0 or @own IS null)
BEGIN
SELECT Result = -1
RETURN
END
ELSE
BEGIN
SELECT Result = @own
RETURN
END
SET QUOTED_IDENTIFIER OFF
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebRefundSilk] Script Date: 9/4/2019 1:09:55 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebRefundSilk]
@RefundID VARCHAR(25),
@UserID VARCHAR(25),
@Password VARCHAR(50),
@PkgID INT,
@NumSilk INT,
@Price INT
as
DECLARE @UserJID INT
DECLARE @SilkRemain INT
-- DECLARE @PointRemain INT
SET @UserJID = CGI.checkAuthUserPass(@UserID,@Password)
IF( @UserJID >= 0)
BEGIN
SET @UserJID = CGI.getUserJID(@UserID)
IF( not exists( SELECT OrderNumber from SK_SilkBuyList where OrderNumber = @RefundID))
BEGIN
SET @SilkRemain = CGI.getSilkOwn(@UserJID)
IF(@SilkRemain>=@NumSilk)
BEGIN
BEGIN TRANSACTION
UPDATE SK_Silk SET silk_own = silk_own - @NumSilk WHERE JID = @UserJID
--Insert Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,1,@NumSilk,@SilkRemain - @NumSilk,@PkgID,1,@RefundID,"User Refund Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@SilkRemain - @NumSilk,@NumSilk,0,1)
IF (@@error <> 0 or @@rowcount = 0)
BEGIN
SELECT Result = "FAIL"
ROLLBACK TRANSACTION
RETURN
END
SELECT Result = "SUCCESS"
COMMIT TRANSACTION
RETURN
END
ELSE
BEGIN
SELECT Result = "NOTENOUGH"
RETURN
END
END
ELSE
BEGIN
SELECT Result = "ORDEREXIST"
RETURN
END
END
ELSE
BEGIN
SELECT Result = "INVALIDUSER";
RETURN
END
|
|
|
|
|
09/04/2019, 12:22
|
#612
|
elite*gold: 0
Join Date: Mar 2016
Posts: 224
Received Thanks: 58
|
@Isoline pls help me
can hepl my thiss error? is only this and i have problem silk..
Get_LastOrderID operation has failed and returned 0 Object cannot be cast from DBNull to other types.
Help
|
|
|
|
|
09/04/2019, 14:04
|
#613
|
elite*gold: 0
Join Date: Apr 2019
Posts: 172
Received Thanks: 55
|
Quote:
Originally Posted by sigel123456789
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebPurchaseSilk] Script Date: 9/4/2019 1:08:23 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebPurchaseSilk]
@OrderID VARCHAR(25),
@UserID VARCHAR(25),
@PkgID INT,
@NumSilk INT,
@Price INT
as
DECLARE @UserJID INT
DECLARE @SilkRemain INT
--DECLARE @PointRemain INT
SET @UserJID = CGI.getUserJID(@UserID)
IF( @UserJID >= 0)
BEGIN
IF( not exists( SELECT OrderNumber from SK_SilkBuyList where OrderNumber = @OrderID))
BEGIN
BEGIN TRANSACTION
IF( not exists( SELECT * from SK_Silk where JID = @UserJID))
BEGIN
INSERT SK_Silk(JID,silk_own,silk_gift,silk_Point)VALUES(@UserJID,@NumSilk,0,0)
--INSERT Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,0,@NumSilk,@NumSilk,@PkgID,1,@OrderID,"User Purchase Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@NumSilk,@NumSilk,0,0)
END
ELSE
BEGIN
SET @SilkRemain = CGI.getSilkOwn(@UserJID)
UPDATE SK_Silk SET silk_own = silk_own + @NumSilk WHERE JID = @UserJID
--INSERT Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,0,@NumSilk,@SilkRemain + @NumSilk,@PkgID,1,@OrderID,"User Purchase Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@SilkRemain + @NumSilk,@NumSilk,0,0)
END
IF (@@error <> 0 or @@rowcount = 0)
BEGIN
SELECT Result = "FAIL"
ROLLBACK TRANSACTION
RETURN
END
SELECT Result = "SUCCESS"
COMMIT TRANSACTION
RETURN
END
ELSE --else if order
BEGIN
SELECT Result = "ORDEREXIST"
END
END
ELSE
BEGIN
SELECT Result = "NOUSER"
RETURN
END
SET QUOTED_IDENTIFIER OFF
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebGetTotalSilk] Script Date: 9/4/2019 1:09:15 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebGetTotalSilk]
as
DECLARE @own FLOAT
SET @own = 0
SELECT @own = sum(silk_own) FROM SK_Silk
IF( @@error <> 0 or @@rowcount = 0 or @own = 0 or @own IS null)
BEGIN
SELECT Result = -1
RETURN
END
ELSE
BEGIN
SELECT Result = @own
RETURN
END
SET QUOTED_IDENTIFIER OFF
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [CGI].[CGI_WebRefundSilk] Script Date: 9/4/2019 1:09:55 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [CGI].[CGI_WebRefundSilk]
@RefundID VARCHAR(25),
@UserID VARCHAR(25),
@Password VARCHAR(50),
@PkgID INT,
@NumSilk INT,
@Price INT
as
DECLARE @UserJID INT
DECLARE @SilkRemain INT
-- DECLARE @PointRemain INT
SET @UserJID = CGI.checkAuthUserPass(@UserID,@Password)
IF( @UserJID >= 0)
BEGIN
SET @UserJID = CGI.getUserJID(@UserID)
IF( not exists( SELECT OrderNumber from SK_SilkBuyList where OrderNumber = @RefundID))
BEGIN
SET @SilkRemain = CGI.getSilkOwn(@UserJID)
IF(@SilkRemain>=@NumSilk)
BEGIN
BEGIN TRANSACTION
UPDATE SK_Silk SET silk_own = silk_own - @NumSilk WHERE JID = @UserJID
--Insert Silk Own
INSERT SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES( @UserJID,0,1,@NumSilk,@SilkRemain - @NumSilk,@PkgID,1,@RefundID,"User Refund Silk from VDC-Net2E Billing System",GETDATE())
INSERT SK_SilkChange_BY_Web(JID,silk_remain,silk_offset,silk_type,reason) VALUES(@UserJID,@SilkRemain - @NumSilk,@NumSilk,0,1)
IF (@@error <> 0 or @@rowcount = 0)
BEGIN
SELECT Result = "FAIL"
ROLLBACK TRANSACTION
RETURN
END
SELECT Result = "SUCCESS"
COMMIT TRANSACTION
RETURN
END
ELSE
BEGIN
SELECT Result = "NOTENOUGH"
RETURN
END
END
ELSE
BEGIN
SELECT Result = "ORDEREXIST"
RETURN
END
END
ELSE
BEGIN
SELECT Result = "INVALIDUSER";
RETURN
END
|
i talk about guild/union limited not silk ?!
|
|
|
|
|
09/05/2019, 10:28
|
#614
|
elite*gold: 0
Join Date: Mar 2016
Posts: 224
Received Thanks: 58
|
Anyone can to help me error :
Get_LastOrderID operation has failed and returned 0 Object cannot be cast from DBNull to other types.
silk / h doesn't work, some players get silk / h but some players don't( I use vers 3.0 Proxy)
Help please ( no free)
|
|
|
|
|
09/05/2019, 18:00
|
#615
|
elite*gold: 0
Join Date: May 2006
Posts: 667
Received Thanks: 348
|
Quote:
Originally Posted by AligatorSniper
Anyone can to help me error :
Get_LastOrderID operation has failed and returned 0 Object cannot be cast from DBNull to other types.
silk / h doesn't work, some players get silk / h but some players don't( I use vers 3.0 Proxy)
Help please ( no free)
|
Sorry, i dont support the cracked version.
|
|
|
|
All times are GMT +1. The time now is 17:01.
|
|
