Release | SR Proxy the best way to protect your private server!

Page 41 of 51 « First 313940 41 4243 Last »
08/26/2019 16:13 Hercules*#601
Quote:
Originally Posted by zuleidy1201 View Post
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 sigel123456789#602
better compiled new version
08/28/2019 00:16 nevet.S#603
when source code will be released, we're waiting isoline <3
08/29/2019 19:31 Rupprecht#604
Guild limited / Union not work any help ?!
08/30/2019 10:50 Disaster.#605
Good job Bro
08/31/2019 00:45 Old_School#606
[Only registered and activated users can see links. Click Here To Register...]


how i can fix it ?

help
09/02/2019 01:15 Isoline*#607
Quote:
Originally Posted by nevet.S View Post
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 View Post
Guild limited / Union not work any help ?!
It works, check your settings.
Quote:
Originally Posted by the mighty View Post
Good job Bro
Thank you.
Quote:
Originally Posted by Old_School View Post
[Only registered and activated users can see links. Click Here To Register...]


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 TechnicVreak#608
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 Isoline*#609
Quote:
Originally Posted by TechnicVreak View Post
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 Rupprecht#610
Quote:
Originally Posted by Isoline* View Post
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 sigel123456789#611
Quote:
Originally Posted by Rupprecht View Post
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 AligatorSniper#612
@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 Rupprecht#613
Quote:
Originally Posted by sigel123456789 View Post
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 AligatorSniper#614
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 Isoline*#615
Quote:
Originally Posted by AligatorSniper View Post
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.
Page 41 of 51 « First 313940 41 4243 Last »