Don't delete character

[gatsu]

Hello,

when I click on delete char, I got this error: "Your char has got cash item or is in a clan".

I haven't cash item or clan, wtf.


Server files 2008 repack 3.

 

[Phoenix]

That's your solution?

Players can't access the admin panel to delete their own characters.

 

[Rain]

its proble the script you did or your db is screwd up so you have to start with the clean modded db again.if that doesnt work then i dont have a clue.

 

[gatsu]

its proble the script you did or your db is screwd up so you have to start with the clean modded db again.if that doesnt work then i dont have a clue.

I can't delete my db again.

Some script are preferred.

 

[gatsu]

Who can help me?

 

[Phoenix]

Sigh, just use a fresh database and don't execute any scripts on it.

 

[Rain]

Sigh, just use a fresh database and don't execute any scripts on it.

said the same thing,but thanks for saying it again * cough*

 

[Phoenix]

said the same thing,but thanks for saying it again * cough*

Can't help it if he keeps repeating his questions. Also, I didn't read the previous posts. Sorry.

 

[iEmo]

Dude, they are right. It's not too hard to delete a db. It's pretty simple.

If you need a small tut:
Right-Click > Delete database
>Delete ODBC
>Make the DB again
>Make the ODBC Back

Simple though.

 

[gatsu]

Dude, they are right. It's not too hard to delete a db. It's pretty simple.

If you need a small tut:
Right-Click > Delete database
>Delete ODBC
>Make the DB again
>Make the ODBC Back

Simple though.

WTF, are you idiot or what?

I use a fresh db by phoenix, I only edited the storage line because before I could not move premiums items to storage so I had applied that script (see the oldest posts).

I cannot delete DB, oke?....

I want to know another solution for that problem.

 

[Phoenix]

Try deleting a character and then check the MatchServer's logs. Let's see if any errors shows up there.

 

[skywind]

u cannot delete?
sure u do.

u cant delete it beuz u have all the accounts and poop

so i understand what u mean

 

[Rain]

Can't help it if he keeps repeating his questions. Also, I didn't read the previous posts. Sorry.

its alright.

@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.

 

[iEmo]

WTF, are you idiot or what?

I use a fresh db by phoenix, I only edited the storage line because before I could not move premiums items to storage so I had applied that script (see the oldest posts).

I cannot delete DB, oke?....

I want to know another solution for that problem.

F*** u Biat**. I was trying to help. On topic, just screw it. Make a new account or some poop. Why would you need to delete the character. And the least you could do is explain this poop a lil' better. Use pics and show what happens.

Sorry for the flame, and Phoenix if you think that this it 2 vulgar. Just delete it, and do not post back.

 

[gatsu]

F*** u Biat**. I was trying to help. On topic, just screw it. Make a new account or some poop. Why would you need to delete the character. And the least you could do is explain this poop a lil' better. Use pics and show what happens.

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.

@Phoenix: This is a log:

Spoiler

MMatchDBMgr::DeleteCharacter - Invalid cursor state

[06:09:08] Async DB Query(DeleteChar) Failed
MMatchDBMgr::DeleteCharacter - Invalid cursor state

[06:10:02] Async DB Query(DeleteChar) Failed

 

[Phoenix]

Execute this and try deleting the character:

/****** 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

 

[gatsu]

Same problem.

 

[Phoenix]

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?

 

[gatsu]

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.

So, if I use your db original, I will have again storage's problem.

 

[Arcelor]

Gimme your DB. I'll export the account tables to a new one.

 

[gatsu]

Bump.