Printable View
Going to add this in further updates, but since the *** called B1QB0SS is sabotages in RaGEZONE forums due to his fucking jealousy from other people. I hope moderators and even admins gets his right time to take a crucial decision for banning B1QB0SS and the same people.Quote:
Originally Posted by Nemo07Back
it's C# and it's taken from AIO, good stuff, but just be sure about one thing... "Account Delete" feature, be sure you have all related tables cleaned up on that one, i had personal messed experience on that and i messed my game :), reminding not only 3-4 tables needs cleaning during account deletion, too many relations. Be sure you have them all :)
@RenePunik Your link is dead. Could you please update it.
Updated download link. @Blacksheep25, Please delete all B1QB0SS posts.
By the way, @Witchy Moo. First of all this tool wasn't taken from AIO it's just similar to it. I can approve this as any shape if you want.
actually i don't care where you took the source from or if you wrote it from the scratch, thus i don't require any prove about anything. it's your right to do so and to release it anywhere you want. I'm not a person who cares about credits or fame.
I just wanna point out things that you might have missed (if there's any), so you can recheck and fix so it won't cause any damage to whoever use your tool.
MiniTools is updating, stay tuned for new version.
Changelog v6.0.0.0 ~ v10.0.0.0 (Last Version):
- Adding "Items Creator" feature.
- Adding "Items Remover" feature.
- Adding "Character Name Changer" feature, since all are lazy to change it from DB.
- Fixing a bug in "IP Privileged Inserter" Page.
- Fixing a bug making a little lag on modules.
- Updating "About MiniTools" Page.
- Updating some texts.
- Updating some codes to make tool features have a good performance.
- Optimizing performance and codes to be more stable.
- Changing somethings at "Notice Sender" Page.
I respect you before but now will not respect you anymoreQuote:
Originally Posted by RenePunik
- - - Updated - - -
and if you want to delete account with char and items etc etc etc
you can add it and edit it for your mind
and do not forget this is for if you make SR_shardmanger and sro_client Create (1) char not 4 in accountQuote:
DELETE from _BlockedWhisperers where OwnerID in (select CharID FROM _Char where CharID= )DELETE FROM _Items where ID64 In (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharID= )) and not ID64 = 0
DELETE FROM _Items where ID64 In (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharID= ))))
DELETE from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharID= ))
DELETE from _Chest where UserJID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharID= ))
DELETE from _Inventory where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharSkill where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharSkillMastery where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharTrijobSafeTrade where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharTrijob where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _ClientConfig where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _DeletedChar where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharQuest where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharCollectionBook where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharNickNameList where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _CharNameList where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _Friend where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _InventoryForAvatar where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _Memo where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _StaticAvatar where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _InvCOS where CosID in (SELECT ID FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharID= ))
DELETE FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _User where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _TimedJob where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _TrainingCampSubMentorHonorPoint where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _Friend where FriendCharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _GuildMember where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _TrainingCampMember where CharID in (SELECT CharID FROM _Char where CharID= )
DELETE FROM _AccountJID WHERE JID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharID= ))
DELETE FROM SRO_VT_ACCOUNT..TB_User where JID IN ( SELECT UserJID FROM SRO_VT_SHARD.._User WHERE CharID IN ( SELECT CharID FROM _Char WHERE CharID= )
DELETE FROM SRO_VT_ACCOUNT..SK_Silk where JID IN ( SELECT UserJID FROM SRO_VT_SHARD.._User WHERE CharID IN ( SELECT CharID FROM _Char WHERE CharID= )
DELETE FROM _ChestInfo WHERE JID IN ( SELECT UserJID FROM _User WHERE CharID IN ( SELECT CharID FROM _Char WHERE CharID= )
DELETE FROM _Char where CharID=
have nice baby
@MikroTekken,Why you are saying that?Quote:
I respect you before but now will not respect you anymore
I'll keep updating thread title based on your changelogs, @RenePunik
One more thing, your tools is using .NET 4.0 or 4.5 (whichever it was), perhaps you could compile in "standard unicode" format because it won't work with some Windows which has minimal unicode sets installed, the tools giving 'em "CLR20r3 System.Drawing" error. For example, a Core Version of W2K8 R2 SP1.
.NET Error:
Attachment 152548
As for account deletion, you could perform these steps: (But always better to refer to how "_DeleteCharPermanently" and "_DeleteCharPermanently_NoTX" works)
1) Check characters, prepare loop if more than 1 character in that account
2) perform deletion of stuff related to the character (inventory, pet, guild, etc) (Refer to both SP)
3) Delete the character (Refer to both SP)
4) If the account no longer have characters, delete the account.
Important note: I don't know if the member deletion in a guild will automatically refreshed at client side, because the original character deletion procedure won't allow character to be deleted if its still a member of a guild. So you must test this first. Who knows this could affect GS or Client.
With this I attach a modified "_DeleteCharPermanently_NoTX" SP from my SHARD database, perhaps you can take a look at it and make deletion query based on it.
SP: Attachment 152547
VirusTotal link: https://www.virustotal.com/en/file/2...is/1436224553/
create a stored proc to delete character it will be easier
Easier and safer to use what the game already provide :)
- Flag the char as "Deleted" in _Char table
- Insert the char to _DeletedChar table, set the DeletedDate to (GETDATE() - 8) (Some systems still want character deletion to 7 days)
- Call _DeleteCharPermanently.
;)
I'm still working on new version, it will take some time.
Stay tuned for the new version.
he could just use deleted = 1 but the character will still be rendered in the char selection screenQuote:
Originally Posted by Witchy Moo
