triggers Account/Characters

Sherif Number of posts : 305 Registration date : 2006-11-28

Jo,

I've added some triggers to account & characters tables.
This to make renumbering easier.
Now when you change account number (or characters guid), all underlaying data will be changed accordingly.

https://opensvn.csie.org/traccgi/kobold_py/browser/sql_templ/Table_Accounts.sql
https://opensvn.csie.org/traccgi/kobold_py/browser/sql_templ/Table_Characters.sql

Developer Number of posts : 462 Registration date : 2006-11-28

very very good ace verry needed also

Number of posts : 38 Registration date : 2006-12-11

the trigger Renumber_acc will delete all send mail after char is loged out.

Ace already nows.

Subject: Re: triggers Account/Characters Thu Dec 28, 2006 3:18 am

aceindy wrote:: Jo,

I've added some triggers to account & characters tables.
This to make renumbering easier.
Now when you change account number (or characters guid), all underlaying data will be changed accordingly.

https://opensvn.csie.org/traccgi/kobold_py/browser/sql_templ/Table_Accounts.sql
https://opensvn.csie.org/traccgi/kobold_py/browser/sql_templ/Table_Characters.sql

good one so after wipe there will be no data left behind by guid?

Sherif Number of posts : 305 Registration date : 2006-11-28

Temporaray on hold;
Released a bit too soon; I noticed I miss some fields Sad

But, yes, the idea is to:
- Renumber any account/character (f.e. an import in a free slot)
- Delete any account/character data after deletion of account.

Want a clean up script?

Subject: Re: triggers Account/Characters Thu Dec 28, 2006 4:26 pm

most funny of bugs emerging with guid is whan go to stable master and previours palyer that had ur guid had pets there welll u can take them out its fixed by scripts bvut always those bugs are kinda funny