u cannot delete?
sure u do.
u cant delete it beuz u have all the accounts and shit
so i understand what u mean
Printable View
u cannot delete?
sure u do.
u cant delete it beuz u have all the accounts and shit
so i understand what u mean
its alright.Quote:
Originally Posted by phoenix_147
@topic
i'm very sorry but i gues this is a rare bug for you, this is the first time somebody have problems with the modded db of phoenix,i also had this and i just deleted the db but since you cant someway i gues your stuck at it till somebody will look at this more srsly then others.
F*** u Biat**. I was trying to help. On topic, just screw it. Make a new account or some shit. Why would you need to delete the character. And the least you could do is explain this shit a lil' better. Use pics and show what happens.Quote:
Originally Posted by gatsu
Sorry for the flame, and Phoenix if you think that this it 2 vulgar. Just delete it, and do not post back.
Learn to read before posting.Quote:
Originally Posted by iEmo
@Phoenix: This is a log:
Spoiler:
Execute this and try deleting the character:
Code:/****** Object: StoredProcedure [dbo].[spDeleteChar] Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* ??? ?? */
CREATE PROC [dbo].[spDeleteChar]
@AID int,
@CharNum smallint,
@CharName varchar(24)
AS
DECLARE @CID int
DECLARE @CashItemCount int
SELECT @CID=CID FROM Character WITH (nolock) WHERE AID=@AID and CharNum=@CharNum
IF (@CID IS NULL)
BEGIN
return (-1)
END
SELECT @CashItemCount=COUNT(*) FROM CharacterItem(nolock) WHERE CID=@CID AND ItemID>=500000
IF (@CashItemCount > 0) OR
(EXISTS (SELECT TOP 1 CLID FROM ClanMember WHERE CID=@CID))
BEGIN
return (-1)
END
BEGIN TRAN
UPDATE Character SET CharNum = -1, DeleteFlag = 1, Name='', DeleteName=@CharName
WHERE AID=@AID AND CharNum=@CharNum AND Name=@CharName
IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN
ROLLBACK TRAN
RETURN (-1)
END
INSERT INTO CharacterMakingLog(AID, CharName, Type, Date)
VALUES(@AID, @CharName, '??', GETDATE())
IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN
ROLLBACK TRAN
RETURN (-1)
END
COMMIT TRAN
SELECT 1 AS Ret
Same problem.
Why don't you use my fresh DB and copy all contents of the Account / Login / Character tables by just managing some AID's & CID's from your old database to get get it working?
phoenix.. I use your db, I only edited this line http://forum.ragezone.com/6015492-post4.html because before I didn't could move premiums items to storage.Quote:
Originally Posted by phoenix_147
So, if I use your db original, I will have again storage's problem.
Gimme your DB. I'll export the account tables to a new one.
Bump.
Bump!
Bump!
Bump!
Bump!
Any help?