الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**Spicoo** · 19-06-2015, 06:14 PM

مطلوب
1. كيوري يمسح الشخصيه
2.كيويري يغير اسم الشخصيه
3.كيويري يرجع ضربات الشخصيه

**™Shi6on** · 19-06-2015, 07:11 PM

كويري عشان يمسح الاكونتات

كود PHP:


			
USE [SRO_VT_ACCOUNT]

GO

TRUNCATE TABLE [dbo].[TB_User]

TRUNCATE TABLE [dbo].[TB_User_Bak]

TRUNCATE TABLE [dbo].[SK_CharRenameLog]

TRUNCATE TABLE [dbo].[_Punishment]

TRUNCATE TABLE [dbo].[_ServiceManagerLog]

TRUNCATE TABLE [dbo].[Test_HN]

TRUNCATE TABLE [dbo].[_BlockedUser]

TRUNCATE TABLE [dbo].[_CasGMChatLog]

TRUNCATE TABLE [dbo].[_Notice]

TRUNCATE TABLE [dbo].[_SMCLog]

TRUNCATE TABLE [dbo].[QuaySoEpoint]

TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]

TRUNCATE TABLE [dbo].[SK_ItemSaleLog]

TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]

TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]

TRUNCATE TABLE [dbo].[SK_ResetSkillLog]

TRUNCATE TABLE [dbo].[SK_Silk]

TRUNCATE TABLE [dbo].[SK_SilkBuyList]

TRUNCATE TABLE [dbo].[SK_SilkGoods]

TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]

TRUNCATE TABLE [dbo].[SR_ShardCharNames]

TRUNCATE TABLE [dbo].[TB_Net2e]

TRUNCATE TABLE [dbo].[TB_Net2e_Bak]

TRUNCATE TABLE [dbo].[tb_paygate_trans]

كويري عشـان يمسح الcharacters

كود PHP:


			
USE [SRO_VT_SHARD] 

    GO 

    TRUNCATE TABLE [dbo].[_Chest] 

    TRUNCATE TABLE [dbo].[_ChestInfo] 

    TRUNCATE TABLE [dbo].[_User] 

    TRUNCATE TABLE [dbo].[_OpenMarket] 

    DELETE FROM [dbo].[_AccountJID]  

    TRUNCATE TABLE [dbo].[_GuildWar] 

    TRUNCATE TABLE [dbo].[_GuildMember] 

    TRUNCATE TABLE [dbo].[_GuildChest] 

    TRUNCATE TABLE [dbo].[_SiegeFortressStruct] 

    TRUNCATE TABLE [dbo].[_SiegeFortressObject] 

    TRUNCATE TABLE [dbo].[_SiegeFortressItemForge] 

    DELETE FROM [dbo].[_SiegeFortress] 

    INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1) 

    INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3) 

    INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6) 

    UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0' 

    DELETE FROM [dbo].[_Guild] WHERE ID > 0 

    DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0 

    TRUNCATE TABLE [dbo].[_InventoryForAvatar] 

    TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint] 

    TRUNCATE TABLE [dbo].[_BlockedWhisperers] 

    TRUNCATE TABLE [dbo].[_TrainingCampMember] 

    TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade] 

    DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0 

    TRUNCATE TABLE [dbo].[_TimedJob] 

    TRUNCATE TABLE [dbo].[_StaticAvatar] 

    TRUNCATE TABLE [dbo].[_Inventory] 

    TRUNCATE TABLE [dbo].[_Memo] 

    TRUNCATE TABLE [dbo].[_FleaMarketNetwork] 

    TRUNCATE TABLE [dbo].[_Friend] 

    TRUNCATE TABLE [dbo].[_CharSkillMastery] 

    TRUNCATE TABLE [dbo].[_CharSkill] 

    TRUNCATE TABLE [dbo].[_InvCOS] 

    DELETE FROM [dbo].[_CharCOS] WHERE ID > 0 

    DELETE FROM [dbo].[_Char] WHERE CharID > 0 

    TRUNCATE TABLE [dbo].[_CharCollectionBook] 

    TRUNCATE TABLE [dbo].[_CharInstanceWorldData] 

    TRUNCATE TABLE [dbo].[_CharNameList] 

    TRUNCATE TABLE [dbo].[_CharNickNameList] 

    TRUNCATE TABLE [dbo].[_CharQuest] 

    TRUNCATE TABLE [dbo].[_ClientConfig] 

    TRUNCATE TABLE [dbo].[_DeletedChar] 

    TRUNCATE TABLE [dbo].[_GPHistory] 

    TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage] 

    TRUNCATE TABLE [dbo].[_ItemPool] 

    DELETE FROM [dbo].[_Items] WHERE ID64 > 0 

    TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET] 

    TRUNCATE TABLE [dbo].[_TimedJobForPet] 

    TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus] 

    TRUNCATE TABLE [dbo].[_TrainingCampHonorRank] 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49) 

    INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50) 

    EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] 

    DELETE FROM [dbo].[_TrainingCamp] 

    TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution] 

    TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution] 

    TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]

query Change Character Name.

كود PHP:


			
[sql] 

 /**edit there**/ 

 Declare @Oldcharname varchar(max) = 'OLDNICKOFCHAR' 

 Declare @Newcharname varchar(max) = 'NEWNICKOFCHAR' 

 /**donteditbellow**/ 



 declare @charid varchar(max) = (select CHARID from _Char where CharName16 = @oldcharname) 

 Update _CharNameList 

 Set CharName16 = @newcharname where CharID = @charid 

 Update _Char 

 Set Charname16 = @newcharname where charname16 = @oldcharname 

 Update _GuildMember 

 Set CharName = @newcharname where CharName = @oldcharname 

 Update _Friend 

 Set FriendCharName = @newcharname where FriendCharName = @oldcharname 





 Print @oldcharname+' changed to '+@newcharname 

 [/sq]

query to reset account skill ...

For China

كود PHP:


			
USE SRO_VT_SHARD

DECLARE @CharName varchar (64)

DECLARE  @CharID int

DECLARE @GiveSP int

SET @CharName = 'CharName' --Your Char Name

SET @GiveSP   = '10000000' --Write the amount of Skill Point

SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change



-- edit by InPanic Kev --

update _ClientConfig

set Data = '0'

where CharID = @CharID

-- edit by InPanic Kev --



--- Do Not Change Here ---

--- made by ModGift for RZ ---

DELETE [dbo].[_CharSkill]

   WHERE [CharID] = @CharID and [SkillID] > '2' and SkillID<'40' 



DELETE [dbo].[_CharSkill]

   WHERE [CharID] = @CharID and [SkillID] > '40' and SkillID<'70' 



DELETE [dbo].[_CharSkill]

   WHERE [CharID] = @CharID and [SkillID] > '70' 



UPDATE [dbo].[_CharSkillMastery]

   SET 

      [Level] = '0'

 WHERE CharID= @CharID



UPDATE [dbo].[_Char]

  SET RemainSkillPoint= @GiveSP

  WHERE CharName16 = @CharName

GO

For Europ

كود PHP:


			
USE SRO_VT_SHARD

DECLARE @CharName varchar (64)

DECLARE  @CharID int

DECLARE @GiveSP int

SET @CharName = 'CharName' --Your Char Name

SET @GiveSP   = '10000000' --Write the amount of Skill Point

SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change



-- edit by InPanic Kev --

update _ClientConfig

set Data = '0'

where CharID = @CharID

-- edit by InPanic Kev --



--- Do Not Change Here ---

--- made by ModGift for RZ  ---

DELETE [dbo].[_CharSkill]

   WHERE [CharID] = @CharID and [SkillID] > '2'



INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID

           ,'8421'

           ,'1')

INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID

           ,'8419'

           ,'1')



INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '8420'

           ,'1')



INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '9354'

           ,'1')



INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '9355'

           ,'1')



INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '9944'

           ,'1')

INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '10625'

           ,'1')

INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '11162'

           ,'1')

INSERT INTO [dbo].[_CharSkill]

           ([CharID]

           ,[SkillID]

           ,[Enable])

     VALUES

           (@CharID,

           '11526'

           ,'1')

UPDATE [dbo].[_CharSkillMastery]

   SET 

      [Level] = '0'

 WHERE CharID= @CharID

UPDATE [dbo].[_Char]

  SET RemainSkillPoint= @GiveSP

  WHERE CharName16 = @CharName

GO

For reset all chars

كود PHP:


			
USE [SRO_VT_SHARD]

GO

--Made by ModGift for RaGeZoNe 



-- edit by InPanic Kev --

update _ClientConfig

set Data = '0'

-- edit by InPanic Kev --



DELETE FROM [dbo].[_CharSkill]

      WHERE  SKillID NOT LIKE '1' and  SKillID NOT LIKE '2' and  SKillID NOT LIKE '40'

      and  SKillID NOT LIKE '70' and  SKillID NOT LIKE '8421' and  SKillID NOT LIKE '8419'

      and  SKillID NOT LIKE '8420' and  SKillID NOT LIKE '9354' and  SKillID NOT LIKE '9355'

      and  SKillID NOT LIKE '9944' and  SKillID NOT LIKE '10625' and  SKillID NOT LIKE '11162'

      and  SKillID NOT LIKE '11526'

GO 



UPDATE [dbo].[_CharSkillMastery]

   SET 

      [Level] = '0'

**Spicoo** · 21-06-2015, 12:32 AM

تمام ياباشا بس بلنسبه للكويري مسح الشخصيه انا عاوز مسح شخصيه واحد مش كل الي في الداتا يعني تكتب فيه اسم الشخصيه تتمسح

**MikrotikBody** · 21-06-2015, 03:36 PM

أتفضل لمسح أكونت واحد

كود:

DELETE from _BlockedWhisperers where OwnerID in (select CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Items where ID64 In (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) 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 CharName16 = 'Char Name')))) DELETE from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE from _Chest where UserJID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharSkill where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharSkillMastery where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharTrijobSafeTrade where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharTrijob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _ClientConfig where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _DeletedChar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharQuest where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharCollectionBook where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharNickNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Friend where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _InventoryForAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Memo where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _StaticAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _InvCOS where CosID in (SELECT ID FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TimedJob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TrainingCampSubMentorHonorPoint where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Friend where FriendCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _GuildMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TrainingCampMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _AccountJID WHERE JID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE FROM _Char where CharName16 = 'Char Name'

**Spicoo** · 21-06-2015, 11:00 PM

ودا اكتب اسم الشخصيه بدل Char Name الي في الكيوري كلو ؟

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Quere How To Clean Data Base ^_^	Hector_	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	8	31-07-2023 12:49 AM
طلب Quere	Spicoo	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	18	28-02-2015 11:06 PM
طلب Quere	resident	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	8	31-08-2014 12:25 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ