|
You last visited: Today at 14:02
Advertisement
[FIX]Skill Bug
Discussion on [FIX]Skill Bug within the 4Story forum part of the MMORPGs category.
04/21/2013, 12:39
|
#1
|
elite*gold: 0 
Join Date: Oct 2010
Posts: 546
Received Thanks: 152
|
[FIX]Skill Bug
Put it in TSAVECHARDATAEND
Code:
ALTER PROCEDURE [dbo].[TSaveCharDataEnd]
@dwCharID INT
AS
DECLARE @dwUserID INT
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TINVENTABLE WHERE dwCharID = @dwCharID
DELETE TCABINETTABLE WHERE dwCharID = @dwCharID
DELETE TITEMUSEDTABLE WHERE dwCharID = @dwCharID
DELETE TEXPITEMTABLE WHERE dwCharID = @dwCharID
INSERT INTO TINVENTABLE SELECT * FROM TTEMPINVENTABLE WHERE dwCharID = @dwCharID
INSERT INTO TCABINETTABLE SELECT * FROM TTEMPCABINETTABLE WHERE dwCharID = @dwCharID
INSERT INTO TITEMUSEDTABLE SELECT * FROM TTEMPITEMUSEDTABLE WHERE dwCharID = @dwCharID
INSERT INTO TEXPITEMTABLE SELECT * FROM TTEMPEXPITEMTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
Put it in TLOGOUT in tgame
Code:
/* LOGOUT PROCESS
========================================================
PARAMETER
========================================================
@dwUserID INT
========================================================
RETURN VALUE
========================================================
0 : SUCCESS
1 : NO USER
========================================================
PROCESS
========================================================
--1. Check TCURRENTUSER table
--2. Delete user from TCURRENTUSER
--3. Update log data
*/
ALTER PROCEDURE [dbo].[TLogout]
@dwUserID INT,
@dwCharID INT
AS
DECLARE @nResult INT
DECLARE @bLevel TINYINT
DECLARE @dwExp INT
DECLARE @dwPlayTime INT
DECLARE @dwGold INT
DECLARE @dwSilver INT
DECLARE @dwCooper INT
DECLARE @bWorldID TINYINT
DECLARE @dCurDate SMALLDATETIME
SET @bLevel = 0
SET @dwExp = 0
SET @dwGold = 0
SET @dwSilver = 0
SET @dwCooper = 0
SET @dCurDate = GetDate()
IF(@dwCharID <> 0)
BEGIN
SELECT @bLevel = bLevel, @dwExp = dwEXP, @dwGold=dwGold, @dwSilver=dwSilver, @dwCooper=dwCooper FROM TCHARTABLE WHERE dwCharID = @dwCharID
EXEC TUpdateActiveChar @dwCharID
UPDATE TCHARTABLE SET dLogoutDate = @dCurDate WHERE dwCharID=@dwCharID
EXEC @nResult = TGLOBAL_GSP.dbo.TLogout @dwUserID, @dwCharID, @bLevel, @dwExp
IF(@nResult = 0)
BEGIN
SELECT @bWorldID = bWorld+1 FROM TDBITEMINDEXTABLE
EXEC TGLOBAL_GSP.dbo.TUpdateCharMoney @bWorldID, @dwCharID, @dwGold, @dwSilver, @dwCooper
END
END
EXEC TGLOBAL_GSP.DBO.TPcBangLogout @dwUserID, @dwPlayTime OUTPUT
/*
IF(@dwGuildID <> 0 AND @dwPlayTime <> 0)
BEGIN
INSERT INTO TGUILDPLAYLOG(dwGuildID, dwUserID, dwCharID, dwPlayTime) VALUES(@dwGuildID, @dwUserID, @dwCharID, @dwPlayTime)
UPDATE TGUILDTABLE SET dwPlayTime = dwPlayTime + @dwPlayTime WHERE dwID = @dwGuildID
END
*/
-- DELETE TITEMTABLE WHERE @dwCharID = dwOwnerID AND bOwnerType=0 AND wItemID = 7605
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TITEMTABLE WHERE dwOwnerID = @dwCharID AND bOwnerType = 0 AND bStorageType <> 2
DELETE TITEMTABLE WHERE dlID IN(SELECT dlID FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID)
INSERT INTO TITEMTABLE(
dlID, bStorageType, dwStorageID, bOwnerType, dwOwnerID, bItemID, 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 * FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID
DELETE TSKILLTABLE WHERE dwCharID = @dwCharID
INSERT INTO TSKILLTABLE SELECT * FROM TTEMPSKILLTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
|
|
|
|
04/21/2013, 13:17
|
#2
|
elite*gold: 0
Join Date: Aug 2011
Posts: 659
Received Thanks: 658
|
It's for skill(bar) bug or skill (buff) disappearing bug?
|
|
|
|
|
04/21/2013, 13:41
|
#3
|
elite*gold: 0
Join Date: Oct 2010
Posts: 546
Received Thanks: 152
|
for skill bar
|
|
|
|
|
04/21/2013, 13:53
|
#4
|
Moderator
elite*gold: 26
Join Date: Dec 2010
Posts: 2,628
Received Thanks: 1,812
|
It's exactly the same like this:
|
|
|
|
|
04/21/2013, 13:58
|
#5
|
elite*gold: 0
Join Date: Oct 2010
Posts: 546
Received Thanks: 152
|
a eu ... sorry
I have edited the post
|
|
|
|
|
04/21/2013, 17:19
|
#6
|
elite*gold: 0
Join Date: Nov 2011
Posts: 391
Received Thanks: 471
|
Quote:
Originally Posted by julianjl
Put it in TSAVECHARDATAEND
Code:
ALTER PROCEDURE [dbo].[TSaveCharDataEnd]
@dwCharID INT
AS
DECLARE @dwUserID INT
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TINVENTABLE WHERE dwCharID = @dwCharID
DELETE TCABINETTABLE WHERE dwCharID = @dwCharID
DELETE TITEMUSEDTABLE WHERE dwCharID = @dwCharID
DELETE TEXPITEMTABLE WHERE dwCharID = @dwCharID
INSERT INTO TINVENTABLE SELECT * FROM TTEMPINVENTABLE WHERE dwCharID = @dwCharID
INSERT INTO TCABINETTABLE SELECT * FROM TTEMPCABINETTABLE WHERE dwCharID = @dwCharID
INSERT INTO TITEMUSEDTABLE SELECT * FROM TTEMPITEMUSEDTABLE WHERE dwCharID = @dwCharID
INSERT INTO TEXPITEMTABLE SELECT * FROM TTEMPEXPITEMTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
Put it in TLOGOUT in tgame
Code:
/* LOGOUT PROCESS
========================================================
PARAMETER
========================================================
@dwUserID INT
========================================================
RETURN VALUE
========================================================
0 : SUCCESS
1 : NO USER
========================================================
PROCESS
========================================================
--1. Check TCURRENTUSER table
--2. Delete user from TCURRENTUSER
--3. Update log data
*/
ALTER PROCEDURE [dbo].[TLogout]
@dwUserID INT,
@dwCharID INT
AS
DECLARE @nResult INT
DECLARE @bLevel TINYINT
DECLARE @dwExp INT
DECLARE @dwPlayTime INT
DECLARE @dwGold INT
DECLARE @dwSilver INT
DECLARE @dwCooper INT
DECLARE @bWorldID TINYINT
DECLARE @dCurDate SMALLDATETIME
SET @bLevel = 0
SET @dwExp = 0
SET @dwGold = 0
SET @dwSilver = 0
SET @dwCooper = 0
SET @dCurDate = GetDate()
IF(@dwCharID <> 0)
BEGIN
SELECT @bLevel = bLevel, @dwExp = dwEXP, @dwGold=dwGold, @dwSilver=dwSilver, @dwCooper=dwCooper FROM TCHARTABLE WHERE dwCharID = @dwCharID
EXEC TUpdateActiveChar @dwCharID
UPDATE TCHARTABLE SET dLogoutDate = @dCurDate WHERE dwCharID=@dwCharID
EXEC @nResult = TGLOBAL_GSP.dbo.TLogout @dwUserID, @dwCharID, @bLevel, @dwExp
IF(@nResult = 0)
BEGIN
SELECT @bWorldID = bWorld+1 FROM TDBITEMINDEXTABLE
EXEC TGLOBAL_GSP.dbo.TUpdateCharMoney @bWorldID, @dwCharID, @dwGold, @dwSilver, @dwCooper
END
END
EXEC TGLOBAL_GSP.DBO.TPcBangLogout @dwUserID, @dwPlayTime OUTPUT
/*
IF(@dwGuildID <> 0 AND @dwPlayTime <> 0)
BEGIN
INSERT INTO TGUILDPLAYLOG(dwGuildID, dwUserID, dwCharID, dwPlayTime) VALUES(@dwGuildID, @dwUserID, @dwCharID, @dwPlayTime)
UPDATE TGUILDTABLE SET dwPlayTime = dwPlayTime + @dwPlayTime WHERE dwID = @dwGuildID
END
*/
-- DELETE TITEMTABLE WHERE @dwCharID = dwOwnerID AND bOwnerType=0 AND wItemID = 7605
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TITEMTABLE WHERE dwOwnerID = @dwCharID AND bOwnerType = 0 AND bStorageType <> 2
DELETE TITEMTABLE WHERE dlID IN(SELECT dlID FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID)
INSERT INTO TITEMTABLE(
dlID, bStorageType, dwStorageID, bOwnerType, dwOwnerID, bItemID, 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 * FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID
DELETE TSKILLTABLE WHERE dwCharID = @dwCharID
INSERT INTO TSKILLTABLE SELECT * FROM TTEMPSKILLTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
|
#CloseRequest Fix has already made several times was
|
|
|
|
|
04/21/2013, 17:31
|
#7
|
elite*gold: 0
Join Date: Oct 2010
Posts: 546
Received Thanks: 152
|
develop your small server and fool me peace
|
|
|
|
|
04/21/2013, 17:36
|
#8
|
elite*gold: 0
Join Date: Mar 2011
Posts: 306
Received Thanks: 156
|
Quote:
Originally Posted by julianjl
Put it in TSAVECHARDATAEND
Code:
ALTER PROCEDURE [dbo].[TSaveCharDataEnd]
@dwCharID INT
AS
DECLARE @dwUserID INT
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TINVENTABLE WHERE dwCharID = @dwCharID
DELETE TCABINETTABLE WHERE dwCharID = @dwCharID
DELETE TITEMUSEDTABLE WHERE dwCharID = @dwCharID
DELETE TEXPITEMTABLE WHERE dwCharID = @dwCharID
INSERT INTO TINVENTABLE SELECT * FROM TTEMPINVENTABLE WHERE dwCharID = @dwCharID
INSERT INTO TCABINETTABLE SELECT * FROM TTEMPCABINETTABLE WHERE dwCharID = @dwCharID
INSERT INTO TITEMUSEDTABLE SELECT * FROM TTEMPITEMUSEDTABLE WHERE dwCharID = @dwCharID
INSERT INTO TEXPITEMTABLE SELECT * FROM TTEMPEXPITEMTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
Put it in TLOGOUT in tgame
Code:
/* LOGOUT PROCESS
========================================================
PARAMETER
========================================================
@dwUserID INT
========================================================
RETURN VALUE
========================================================
0 : SUCCESS
1 : NO USER
========================================================
PROCESS
========================================================
--1. Check TCURRENTUSER table
--2. Delete user from TCURRENTUSER
--3. Update log data
*/
ALTER PROCEDURE [dbo].[TLogout]
@dwUserID INT,
@dwCharID INT
AS
DECLARE @nResult INT
DECLARE @bLevel TINYINT
DECLARE @dwExp INT
DECLARE @dwPlayTime INT
DECLARE @dwGold INT
DECLARE @dwSilver INT
DECLARE @dwCooper INT
DECLARE @bWorldID TINYINT
DECLARE @dCurDate SMALLDATETIME
SET @bLevel = 0
SET @dwExp = 0
SET @dwGold = 0
SET @dwSilver = 0
SET @dwCooper = 0
SET @dCurDate = GetDate()
IF(@dwCharID <> 0)
BEGIN
SELECT @bLevel = bLevel, @dwExp = dwEXP, @dwGold=dwGold, @dwSilver=dwSilver, @dwCooper=dwCooper FROM TCHARTABLE WHERE dwCharID = @dwCharID
EXEC TUpdateActiveChar @dwCharID
UPDATE TCHARTABLE SET dLogoutDate = @dCurDate WHERE dwCharID=@dwCharID
EXEC @nResult = TGLOBAL_GSP.dbo.TLogout @dwUserID, @dwCharID, @bLevel, @dwExp
IF(@nResult = 0)
BEGIN
SELECT @bWorldID = bWorld+1 FROM TDBITEMINDEXTABLE
EXEC TGLOBAL_GSP.dbo.TUpdateCharMoney @bWorldID, @dwCharID, @dwGold, @dwSilver, @dwCooper
END
END
EXEC TGLOBAL_GSP.DBO.TPcBangLogout @dwUserID, @dwPlayTime OUTPUT
/*
IF(@dwGuildID <> 0 AND @dwPlayTime <> 0)
BEGIN
INSERT INTO TGUILDPLAYLOG(dwGuildID, dwUserID, dwCharID, dwPlayTime) VALUES(@dwGuildID, @dwUserID, @dwCharID, @dwPlayTime)
UPDATE TGUILDTABLE SET dwPlayTime = dwPlayTime + @dwPlayTime WHERE dwID = @dwGuildID
END
*/
-- DELETE TITEMTABLE WHERE @dwCharID = dwOwnerID AND bOwnerType=0 AND wItemID = 7605
SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
BEGIN TRAN SAVECHAREND
DELETE TITEMTABLE WHERE dwOwnerID = @dwCharID AND bOwnerType = 0 AND bStorageType <> 2
DELETE TITEMTABLE WHERE dlID IN(SELECT dlID FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID)
INSERT INTO TITEMTABLE(
dlID, bStorageType, dwStorageID, bOwnerType, dwOwnerID, bItemID, 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 * FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID
DELETE TSKILLTABLE WHERE dwCharID = @dwCharID
INSERT INTO TSKILLTABLE SELECT * FROM TTEMPSKILLTABLE WHERE dwCharID = @dwCharID
COMMIT TRAN SAVECHAREND
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
|
repost... repost everywhere 
|
|
|
|
|
04/23/2013, 20:15
|
#9
|
elite*gold: 0
Join Date: Jan 2011
Posts: 64
Received Thanks: 22
|
works it?
|
|
|
|
|
04/23/2013, 20:18
|
#10
|
elite*gold: 120
Join Date: Apr 2012
Posts: 1,982
Received Thanks: 2,463
|
#closerequest
|
|
|
|
 |
Similar Threads
|
[tutorial] fussion [GM]ghostmode+teleportation;Skill speed,Skill range hack
03/05/2014 - Dekaron PServer Hacks, Bots, Cheats & Exploits - 275 Replies
Ok..this is my first tutorial..today i will show you how to make ghostmode+teleportation hack,Skill speed hack,Skill range hack,Wall Hack,Mana consumation hack..
The programs that you need is :
Cheat engine 5.4/5.5 version
Microsoft excell 2003 or try with newest version..maybe will work again
1. ghostmode+teleport hack
firtst step is open (launch) your dekaron..without login!
next open your Cheat Engine and you will see in the left corner one little PC that glow..press on it and...
|
Suche s.17 Körpkerkrieger mit Aura P und noch G skill gebe imba Skill Wasu lvl 82
06/27/2012 - Metin2 Trading - 0 Replies
Hey leute ich tausche meinen blank wasu blaues reich s.17 Skills : vzk P rüssi g4 furcht g3 degenwirbel m6 gegen einen Körperkrieger ab lvl 75 mit mindestenss aura P und noch einem P / g skill
Wer interrese hat schreibt drunter
Der wasu hat eine vielzahl von itemshop sachen in dem acc sowie segenskugeln etc
|
Crossfire No Skill Move Philippine Only Can Download This Cheat No SKill Click me
03/10/2012 - SRO PServer Advertising - 6 Replies
Instruction:
1st:download the link
2nd:extract the aimbot 26.7 and the dll
3rdpen the aimbot 26.7
4th:+ Help Get Key Active--- click this link in the aimbot 26.7
|
Dekaron Fussion.... Vac , Skill , Wall , Skill Range ...... hack ? give me the links
04/13/2011 - Dekaron Private Server - 5 Replies
hey Guys im searching for Good Dekaron Fussion Hacks....
Please contact me or Give me links
Thx you very much.
:):D
|
[RELEASE]GCPH ELESIS, LIRE, ARME Skill Tree + AMY 4th job skill[UPDATED]
03/31/2010 - Grand Chase Hacks, Bots, Cheats & Exploits - 149 Replies
Hii guys because we are complaining that GCPH are late on major events and we are jealous that GC Thailand are on their season 3 already... here is something i want to share with all of you... and its free...
Note: Dont try using it in pvp if your opponent dont have the skill hack because they can only see normal skills if you want to play in pvp using this then better share it !
Screenshots:
http://img222.imageshack.us/img222/6369/75378761. jpg...
|
All times are GMT +2. The time now is 14:02.
|
|
![[FIX]Skill Bug](https://www.elitepvpers.com/forum/iconimages/4story/fix-skill-bug_ltr.gif){kind=small}
