[HELP][ENGLISH]Some bugs

[glossypvp]

Hi, I have some problems with my databases

1..: Mount bug: Mounts are not functional, fully unusable.
2..: Skill-bug: I mean all buffs disappear when I log out
3..: CashShop: First the bug was stacking. For example If I buy a 10 pack item, I get only one. I have downloaded the fix, now it's messed up my CashShop, only a blank window comes when I open the CashShop, or it says no user info. (of course I have a backup, so ... I'm very lucky!)
4..: ChatBug: Local hoster admin can't see the chat, yes I have downloaded SkillArtz's bugfix (.reg file) but it did not helped.

Now I have these bugs ... somebody can help me?
SkillArtz, anyone?

Thanks

enlish only please, or use a translator

[RedSwag]

Originally Posted by glossypvp

Hi, I have some problems with my databases

1..: Mount bug: Mounts are not functional, fully unusable.
2..: Skill-bug: I mean all buffs disappear when I log out
3..: CashShop: First the bug was stacking. For example If I buy a 10 pack item, I get only one. I have downloaded the fix, now it's messed up my CashShop, only a blank window comes when I open the CashShop, or it says no user info. (of course I have a backup, so ... I'm very lucky!)
4..: ChatBug: Local hoster admin can't see the chat, yes I have downloaded SkillArtz's bugfix (.reg file) but it did not helped.

Now I have these bugs ... somebody can help me?
SkillArtz, anyone?

Thanks

enlish only please, or use a translator

Man before start a topic search ok ^^

1- Mount bug = haven't fix for it, wait...
2- Skill Bug = Download the fix here:

3- Try fix it again, i think u wrong how put patched TClient.exe in 4story folder and change your TCashItemBuy, is in TGLOBAL_GSP > Functions > TCashItemBuy and change for it:

Originally Posted by SkillartzHD

 Spoiler

ALTER PROCEDURE [dbo].[TCashItemBuy]
@dwCash INT OUTPUT,
@dwCashBonus INT OUTPUT,
@szPresent VARCHAR(50) OUTPUT,
@dwUserID INT,
@wCashItemID SMALLINT,
@dwMoney INT,
@bBuyType TINYINT,
@dwTarget INT
AS
 
DECLARE @nRet INT
DECLARE @bConsumType TINYINT            --구매 타입(0:자동, 1:캐쉬, 2:마일리지)
DECLARE @bMsgCode       TINYINT         --오류정보(0:오류 없음, 1:아이템이 없음, 2:캐쉬 포인트가 없음, 3:캐쉬가 부족)
DECLARE @dwPcBangID INT
DECLARE @dwRealTarget INT
DECLARE @szLoginIP VARCHAR(50)
DECLARE @dCurTime SMALLDATETIME
DECLARE @dSetTime SMALLDATETIME
DECLARE @wUseTime SMALLINT
DECLARE @bLocalCount INT
DECLARE @szItemID INT
 
SET @bConsumType = 0
SET @dwPcBangID  = 0
SET @szLoginIP = ''
SET @nRet = 0
SET @szPresent = ''
SET @dCurTime = GetDate()
SET @dwCash = 0
SET @dwCashBonus = 0
SET @wUseTime = 0
SET @bLocalCount = 0
 
 
SELECT @szPresent = szName, @wUseTime = wUseTime, @szItemID = wID FROM TCASHSHOPITEMCHART WHERE wID = @wCashItemID
IF(@@ROWCOUNT <> 1 OR @szPresent IS NULL)
BEGIN
        SET @szPresent = ''
        RETURN 1
END
 
SELECT @dwPcBangID = dwPcBangID, @szLoginIP = szLoginIP FROM TCURRENTUSER WHERE dwUserID = @dwUserID
 
-- TEST TABLE############################
SELECT @dwCash = dwCash, @dwCashBonus=dwBonus FROM TCASHTESTTABLE WHERE dwUserID = @dwUserID
IF(@@ROWCOUNT < 1 OR @dwCash<@dwMoney)
        RETURN 3
 
SET @dwCash = @dwCash - @dwMoney
UPDATE TCASHTESTTABLE SET dwCash = @dwCash WHERE dwUserID = @dwUserID
 
SELECT @bLocalCount = bCount FROM TCASHSHOPITEMCHART WHERE wID = @wCashItemID
IF(@@ROWCOUNT <> 1 OR @bLocalCount <= 0)
BEGIN
        SET @bLocalCount = 15
        RETURN 1
END
 
--######################################
--EXEC @nRet = [192.168.1.9,6121].FourStory_Cash.FourStory_Web.Fun_BuyTheItem @bConsumType, @wCashItemID, @dwUserID, @dwMoney, @dwPcBangID, @bBuyType, @dwTarget, @szLoginIP, @bMsgCode OUTPUT, @dwCash OUTPUT, @dwCashBonus OUTPUT
 
IF(@nRet = 0)
BEGIN
        SET @dSetTime = DATEADD(MINUTE, 60-DATEPART(MINUTE, @dCurTime), @dCurTime)
--      SET @dSetTime = DATEADD(HOUR, 24-DATEPART(HOUR, @dSetTime), @dSetTime) + 1
 
 
        IF(@bBuyType = 2)
                SET @dwRealTarget = @dwTarget
        ELSE
                SET @dwRealTarget = @dwUserID
 
        IF EXISTS(SELECT * FROM TCASHBONUSITEMCHART WHERE wCashItemID = @wCashItemID)
        BEGIN
                IF(@wUseTime > 0)
                        INSERT INTO TCASHITEMCABINETTABLE(
                                dwUserID, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bRefineCur, dEndTime,bGradeEffect,
                                bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
                                wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
                                dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6)
                        SELECT @dwRealTarget, CS.wItemID, CS.bLevel, @bLocalCount, CS.bGLevel, CS.dwDuraMax, CS.dwDuraCur, CS.bRefineCur, @dSetTime+wUseTime, bGradeEffect,
                                bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
                                wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
                                dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6
                        FROM TCASHSHOPITEMCHART AS CS INNER JOIN TCASHBONUSITEMCHART AS CB ON CS.wID = CB.wBonusItem WHERE CB.wCashItemID = @wCashItemID
                ELSE
                        INSERT INTO TCASHITEMCABINETTABLE(
                                dwUserID, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bRefineCur, dEndTime,bGradeEffect,
                                bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
                                wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
                                dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6)
                        SELECT @dwRealTarget, CS.wItemID, CS.bLevel, @bLocalCount, CS.bGLevel, CS.dwDuraMax, CS.dwDuraCur, CS.bRefineCur, 0,bGradeEffect,
                                bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
                                wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
                                dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6
                        FROM TCASHSHOPITEMCHART AS CS INNER JOIN TCASHBONUSITEMCHART AS CB ON CS.wID = CB.wBonusItem WHERE CB.wCashItemID = @wCashItemID
 
                UPDATE TCASHITEMCABINETTABLE SET dlID = 8718968878589280256+dwID WHERE dlID=0
                --UPDATE TCASHITEMCABINETTABLE SET bCount = @bLocalCount WHERE @wCashItemID = @szItemID
        END
END
 
RETURN @nRet

4- Chatbug = i Solved it creating a Virtual Machine in VMWare Player, search VMWare Player and download Windows Server 2008 R2 here:

[glossypvp]

Thanks.
About the chatbug, when I need to use hostname, for example in navicat, just use it normally (of course use database name) like if SQL server on my computer and not on a virtual machine?

I mean, if I install SQL server on a virtual machine can I use that if the server is running on my primary computer? Or do you recommend to install the full server on a virtual machine? (which will eat my ram :P)
So?

Edit:
SkilBug fix:
It says invaild procedure syntax (TLOGOUT)
And the cashshop says no user information.

ChatBug fixed.

Update:
And all mouns disappear when I log out. (I can use only a mount.)

I need to fix the mounts and cash bug

[RedSwag]

Originally Posted by glossypvp

Thanks.
About the chatbug, when I need to use hostname, for example in navicat, just use it normally (of course use database name) like if SQL server on my computer and not on a virtual machine?

I mean, if I install SQL server on a virtual machine can I use that if the server is running on my primary computer? Or do you recommend to install the full server on a virtual machine? (which will eat my ram :P)
So?

Edit:
SkilBug fix:
It says invaild procedure syntax (TLOGOUT)
And the cashshop says no user information.

ChatBug fixed.

Update:
And all mouns disappear when I log out. (I can use only a mount.)

I need to fix the mounts and cash bug

Chatbug fixed: you fixed it creating a virtual machine, if not please, say it to me
Mountbugs: we need wait a good man release it or the emu 4.3 :P
SkillBug: Search the fix of the skillartz hd in same thread and try it.
CashShop: Download this TClient.exe (in attached files) and paste it on your 4story folder

[glossypvp]

Edit:
It's working fine now, thanks.



I can't use SkillArtz's fix, it says invaild procedure syntax.

[RedSwag]

Originally Posted by glossypvp

Edit:
It's working fine now, thanks.



I can't use SkillArtz's fix, it says invaild procedure syntax.

But, how you fixed chatbug?, you tried use the Weom fix? and invalid procedure syntax, when you click on Save button? search error in code


how you fixed chatbug?
how you fixed chatbug?

[glossypvp]

Now the chat bug is annonying again
Btw I just did nothing then it fixed itself

About the TLOGOUT & TSAVECHAREND (I think it's the correct name) I used Weom's fix it was fine.