Jump to content

SQL Clean Up


Nox

Recommended Posts

If you are using A Plot for Life v2+ then standard cleardown scripts used with Vanilla Epoch listed in this thread should work fine as it stores the characterID just as vanilla Epoch does along with saving the PlayersUID in a different field.

Link to comment
Share on other sites

  • 4 weeks later...

i tried using that,

delete FROM `Character_DATA`

USING character_data, character_data AS tmpcharacter_data

WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID

AND character_data.CharacterID<tmpcharacter_data.CharacterID

AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)

but it doesnt work, i get an error says  Unknown table 'Character_DATA' in MULTI DELETE

but my table is called Character_DATA, when i change it to character_data it wont give me an error

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...
  • 2 months later...

i tried using that,

delete FROM `Character_DATA`

USING character_data, character_data AS tmpcharacter_data

WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID

AND character_data.CharacterID<tmpcharacter_data.CharacterID

AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)

but it doesnt work, i get an error says  Unknown table 'Character_DATA' in MULTI DELETE

but my table is called Character_DATA, when i change it to character_data it wont give me an error

 

Using this if u have Character_DATA:

delete FROM `Character_DATA`

USING Character_DATA, Character_DATA AS tmpcharacter_data

WHERE NOT Character_DATA.CharacterID=tmpcharacter_data.CharacterID

AND Character_DATA.CharacterID<tmpcharacter_data.CharacterID

AND (Character_DATA.PlayerUID=tmpcharacter_data.PlayerUID)

or use this if u have character_data

delete FROM `character_data`

USING character_data, character_data AS tmpcharacter_data

WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID

AND character_data.CharacterID<tmpcharacter_data.CharacterID

AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)
Link to comment
Share on other sites

  • 1 year later...
On 3.12.2013 at 11:13 AM, MGT said:
On 3.12.2013 at 8:25 AM, Nasdero said:

If you believe or not, sometimes ppl go for vacation and then you reset their humanity? Take this and they will keep their humanity:

 

 


delete FROM `character_data`

USING character_data, character_data AS tmpcharacter_data

WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID

AND character_data.CharacterID<tmpcharacter_data.CharacterID

AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)[/php]

 

 

Nice work

It doesnt work for me... It says: Error 1064: You have an error in ur SQL syntax; check the manual that corresponds to your MsQL server for the right SQL syntax to use near

'[/php] RETURN 0; END' at line 12

SQL PREVIEW:

CREATE DEFINER = CURRENT_USER FUNCTION `NewProc`()
 RETURNS integer
BEGIN
    DELETE FROM `Character_DATA`

        USING Character_DATA, Character_DATA AS tmpcharacter_data

        WHERE NOT Character_DATA.CharacterID=tmpcharacter_data.CharacterID

        AND Character_DATA.CharacterID<tmpcharacter_data.CharacterID

        AND (Character_DATA.PlayerUID=tmpcharacter_data.PlayerUID)[/php]

    RETURN 0;
END;;

 

Defenition:

 

BEGIN
    DELETE FROM `Character_DATA`

        USING Character_DATA, Character_DATA AS tmpcharacter_data

        WHERE NOT Character_DATA.CharacterID=tmpcharacter_data.CharacterID

        AND Character_DATA.CharacterID<tmpcharacter_data.CharacterID

    AND (Character_DATA.PlayerUID=tmpcharacter_data.PlayerUID)[/php]

    RETURN 0;
END;

 

Any help (Using nitrado that is why i changed the name to "Charakter_DATA"

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
×
×
  • Create New...