Screenshot by Lightshot
Сreate new account and Character..i enter the game, and i have -100 resets..
Who knows how to fix it?
Сreate new account and Character..i enter the game, and i have -100 resets..
Who knows how to fix it?
[Release] DarksTeam MuServer 0.99.60/62T (1.0M) Beta 15
- Thread starter DarkMaster
- Start date
use MuOnline
update character
set Resets = Resets + 10,Clevel = 400
where name ='Character's name'
This metod does not work...
I need your golden hand: D
https://darksteam.net/attachment.php?attachmentid=4149&stc=1&d=1489642828
I use Spiral slash, which can not move or fight monsters
He reviewed it not by the customer
Video 2017 03 19 124004 - YouTube
Video 2017 03 19 124004 - YouTube
He reviewed it not by the customer
Video 2017 03 19 124004 - YouTube
Video 2017 03 19 124004 - YouTube
Last edited:
- Joined
- Apr 8, 2008
- Messages
- 2,465
- Reaction score
- 11,167
If you'd like to save the score of Blood Castle, use the following procedure.
Code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_POINT_ACCM_BC]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP_POINT_ACCM_BC]
GO
CREATE PROCEDURE SP_POINT_ACCM_BC
@Server smallint,
@Bridge tinyint,
@AccountID varchar(10),
@CharacterName varchar(10),
@Class tinyint ,
@Point int,
@PCRoomGUID int
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT CharacterName FROM EVENT_INFO_BC WITH (READUNCOMMITTED)
WHERE Server = @Server AND AccountID = @AccountID AND CharacterName = @CharacterName )
Begin
DECLARE @iiiPoint int
SELECT @iiiPoint = Point FROM EVENT_INFO_BC
WHERE Server = @Server AND AccountID = @AccountID AND CharacterName = @CharacterName
IF (@iiiPoint + @Point < 0)
BEGIN
UPDATE EVENT_INFO_BC
SET Point = 0 , Bridge = @Bridge, PlayCount = PlayCount+1
WHERE Server = @Server AND AccountID = @AccountID AND CharacterName = @CharacterName
END
ELSE
BEGIN
UPDATE EVENT_INFO_BC
SET Point = Point + @Point , Bridge = @Bridge, PlayCount = PlayCount+1
WHERE Server = @Server AND AccountID = @AccountID AND CharacterName = @CharacterName
END
End
ELSE
Begin
INSERT INTO EVENT_INFO_BC ( Server, Bridge, AccountID, CharacterName, Class, Point, PlayCount ) VALUES (
@Server,
@Bridge,
@AccountID,
@CharacterName,
@Class,
@Point,
default
)
End
IF (@PCRoomGUID <> 0)
Begin
IF EXISTS (SELECT AccountID FROM T_BC_PCROOM_PLAYCOUNT WITH (READUNCOMMITTED)
WHERE PCROOM_GUID = @PCRoomGUID AND AccountID = @AccountID)
Begin
UPDATE T_BC_PCROOM_PLAYCOUNT
SET PlayCount = PlayCount + 1, Point = Point + @Point
WHERE PCROOM_GUID = @PCRoomGUID AND AccountID = @AccountID
End
ELSE
Begin
INSERT INTO T_BC_PCROOM_PLAYCOUNT
VALUES (@PCRoomGUID, @AccountID, default, @Point)
End
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO#DarksMaster
Item +13 can not be repaired
friend tell me for tutorial add new wings seaosn 1
DarkMaster why you dont give full client for this server files, more people write this post "need game client".
Shared please, me too need client i new for this season, and can't start game other client. Help me please, tnx. P.S sorry for my low english.
Shared please, me too need client i new for this season, and can't start game other client. Help me please, tnx. P.S sorry for my low english.
Last edited:
Similar threads
