Character Wipe Asking

[Ecrypter]

Hi epvpers limme know how to fully wipe the character in flyff.,?
because i try to wipe in database in CHARACTER_TBL, will its wipe but when i create character and the same name of the old character that i wipe., they comes up again and have the item before.,

thanks in advance to your answer!!

[Myths of Soul]

Use the Sedrikas Aio and all Changes and Charakters + Accounts removt :3

[GentrosOne]

you can use this skript

Delete Normaly Players:

Use [CHARACTER_01_DBF]
GO
delete from [CHARACTER_TBL] where m_chAUTHORITY = 'F'
Go

and wen you edit the m_chAUTHORITY to "Z" can you delet all Administrators.

sorry for my bad english.

[Drabur]

Originally Posted by GentrosOne

you can use this skript

Delete Normaly Players:

Use [CHARACTER_01_DBF]
GO
delete from [CHARACTER_TBL] where m_chAUTHORITY = 'F'
Go

and wen you edit the m_chAUTHORITY to "Z" can you delet all Administrators.

sorry for my bad english.

This will just delete the character not the inventory of them

[xTwiLightx]

TRUNCATE every table, except the BASE_VALUE_TBL.

[Ecrypter]

even i delete the character when i create same name they say character name is already created., and i press back and enter again to the login character, all item and char has back,

[Zeljian]

how to truncate?

[Razzer~]

Thats why the Databaseserver sets the status of the character in CHARACTER_TBL isBlock to D . The D signals that the character is going to be deleted.

in DBManager.cpp :: CDbManager::RemovePlayer(

PHP Code:

DBQryCharacter( szQuery, "D1", idPlayer, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, szNo);
    
    if( FALSE == qry->Exec(szQuery) )
    {
        WriteLog( "%s, %d\t%s\r\n\t%s, %s", __FILE__, __LINE__, szQuery, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPassword );
        FreeRequest( lpDbOverlappedPlus );
        return;
    } 


Here you can see that the Database sets the isBlock of the character to D . But the point is that the character is never going to be deleted, it will be just blocked. Because of that there are still the values of the character in INVENTORY_TBL and others.

Hint: Look at the procedure CHARACTER_DEL_STR, try to understand it and write a new one for your purpose. The CHARACTER_DEL_STR never gets called in FlyFF (When you find it tell me), but you can do it.

Greetz

Maybe i am going to release the procedure later.

[xTwiLightx]

Originally Posted by Razzer~

Thats why the Databaseserver sets the status of the character in CHARACTER_TBL isBlock to D . The D signals that the character is going to be deleted.

in DBManager.cpp :: CDbManager::RemovePlayer(

PHP Code:

DBQryCharacter( szQuery, "D1", idPlayer, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, szNo);
    
    if( FALSE == qry->Exec(szQuery) )
    {
        WriteLog( "%s, %d\t%s\r\n\t%s, %s", __FILE__, __LINE__, szQuery, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPassword );
        FreeRequest( lpDbOverlappedPlus );
        return;
    } 


Here you can see that the Database sets the isBlock of the character to D . But the point is that the character is never going to be deleted, it will be just blocked. Because of that there are still the values of the character in INVENTORY_TBL and others.

Hint: Look at the procedure CHARACTER_DEL_STR, try to understand it and write a new one for your purpose. The CHARACTER_DEL_STR never gets called in FlyFF (When you find it tell me), but you can do it.

Greetz

Maybe i am going to release the procedure later.

It gets called via Server Agent Job

[Razzer~]

Gibt es da eine gewisse Zeit wo er die Query ausführt?
Edit: Der Job muss von der Datenbank selber ausgeführt werden, in der AiO als auch in deiner ist kein Job geschrieben. Also wird die Prozedur wirklich nicht aufgerufen, ausser ich finde noch irgendwo in der Source etwas.

[xTwiLightx]

Originally Posted by Razzer~

Gibt es da eine gewisse Zeit wo er die Query ausführt?
Edit: Der Job muss von der Datenbank selber ausgeführt werden, in der AiO als auch in deiner ist kein Job geschrieben. Also wird die Prozedur wirklich nicht aufgerufen, ausser ich finde noch irgendwo in der Source etwas.

Server Agent ist auch nicht bei den Express Versionen von SQL Server dabei, da brauche ich auch nicht den Code der Jobs dazupacken ;p



Offi ruft die Prozedur täglich um 04:00 Uhr auf.