Caracter

[Flavinho153]

People, I have a problem. My DB does not want to delete the characters that the individual excluded. How can I fix this?

[MentaL]

[Phoenix]

Thats good if you have a restore character script. Most of them don't but yeah, it's handy. I'm not solving your problem but the question is, why do you want it to delete the data? Is it due to the ranking page? If yes, refer to FRA 2010, Euro or No Life's MPOG web for the ranking query.

[alfredao]

Run this query, will delete all deleted chars.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1')

DELETE FROM Character WHERE CharNum = '-1' 

[Flavinho153]

Run this query, will delete all deleted chars.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1')

DELETE FROM Character WHERE CharNum = '-1' 

Look It :

[alfredao]

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1')

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1') 

DELETE FROM Character WHERE CharNum = '-1' 

[Flavinho153]

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1')

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE CharNum = '-1') 

DELETE FROM Character WHERE CharNum = '-1' 

Thanks for your help but still gives error, look it again:



And still have CID blank.

[alfredao]

Characters already deleteds.

[Flavinho153]

Characters already deleteds.

No :/
Look :

[wesman2232]

try adding a name to them and tell the users to see if they come up.
I'm pretty sure if they were deleted the script would need to go like.

DELETE * FROM Character WHERE Deleted = '1'

I'm pretty sure that column is in there but I don't have my SMSE up to check.

[Flavinho153]

I thought this happened. When a person deletes your character, the clothes are not excluded and remain in dbo.CaracterItem. Its when a person will delete the character, also excludes items?

[alfredao]

Try this.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE DeleteFlag != 0)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE DeleteFlag != 0) 

DELETE FROM Character WHERE DeleteFlag != 0 

[Flavinho153]

Try this.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE DeleteFlag != 0)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE DeleteFlag != 0) 

DELETE FROM Character WHERE DeleteFlag != 0 

Don't ahve effect :

[alfredao]

OGM, try this.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE Name = "")

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE Name = "") 

DELETE FROM Character WHERE Name = "" 

[Flavinho153]

OGM, try this.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE Name = "")

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE Name = "") 

DELETE FROM Character WHERE Name = "" 

:S



"Msg 1038, Level 15, State 4, Line 1
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
Msg 1038, Level 15, State 4, Line 3
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
Msg 1038, Level 15, State 4, Line 5
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
"

[alfredao]

My last try to help you.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE Name IS NULL)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE Name IS NULL) 

DELETE FROM Character WHERE Name IS NULL 

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE DeleteName IS NOT NULL)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE DeleteName IS NOT NULL) 

DELETE FROM Character WHERE DeleteName IS NOT NULL 

[Flavinho153]

My last try to help you.

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE Name IS NULL)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE Name IS NULL) 

DELETE FROM Character WHERE Name IS NULL 

DELETE FROM CharacterItem WHERE CID IN (SELECT CID FROM Character WHERE DeleteName IS NOT NULL)

DELETE FROM Friend WHERE CID IN (SELECT CID FROM Character WHERE DeleteName IS NOT NULL) 

DELETE FROM Character WHERE DeleteName IS NOT NULL 

0 affect :/
OMG ... Thanks more is not solved

[Flavinho153]

Alfredao , Can you give me your DBO.Caracter and dbo.CaracterItem please? =)