احلى هديا لى S4A عمل جروب لى الجى ام من اول Developer لى حد GM LV 5

[[Dev] Arshivel]

الموضوع ده فى كل التحكم فى العبه بى معنى انك تتحكم فى GM و اخ

اولاً الشرح من مجهودى الخاص
وى مش منقول من اح حد
بس كان فى واحد هنا عامل الموضوع ده بس فى ناس كتير مش عرفه تعملو

فا انا قولت اعمل شرح احسن وى اسهل من غير فديو ولا صور كل حاجه سهله جداً

نبداء بسم الله



او حاجه هتفتح SQL
تانى حاجه هتفتح DataBase
وى تختار SRO_VT_ACCOUNT

هتنزل تحت هتلقى
_SecurityDescription
_SecurityDescriptionGroup
_SecurityDescriptionGroupAssign

دول اهم حاجه فى التحكم فى / Developer Or GM Or SP/Or VIP OrOr




اول حاجه هتعلم على _SecurityDescription
وى تدوس كلك يمين وى تختار Delete
وى هتختار New Query عشان ترجع ال _SecurityDescription من جديد

بعد ما تمسح ال _SecurityDescription
New Query

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[_SecurityDescription] Script Date: 10/15/2012 20:28:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SecurityDescription](
[nID] [int] IDENTITY(1,1) NOT NULL,
[szName] [varchar](64) NOT NULL,
[szDesc] [varchar](256) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

بعد ما عملت ال New Query

اعمل refresh هشان ال _SecurityDescription ترجع تانى بعد ما ترجع اعمل كليك يمين على _SecurityDescription
ثم اختار Edit All Rows
هتحوط ده

1 SMC_Login SMC_Login
2 SMC_Plugin_ModulePatch SMC_Plugin_ModulePatch
3 SMC_Plugin_ServerControl SMC_Plugin_ServerControl
4 SMC_Plugin_UserControl SMC_Plugin_UserControl
5 SMC_Plugin_UserStatistics SMC_Plugin_UserStatistics
6 SMC_Plugin_SR_UserLog SMC_Plugin_SR_UserLog
7 SMC_Plugin_SR_UserPunishment SMC_Plugin_SR_UserPunishment
8 SMC_Plugin_Security SMC_Plugin_Security
9 SMC_Plugin_SR_UserData SMC_Plugin_SR_UserData
10 ServerProcess_Launch_Shutdown ServerProcess_Launch_Shutdown
11 Service_Start_Stop Service_Start_Stop
12 ConcurrentUser_BAN ConcurrentUser_BAN
13 SMC_Plugin_SR_Notice SMC_Plugin_SR_Notice
14 SR_GM SR_GM
15 Ignore_Shard_MaxUser Ignore_Shard_MaxUser
16 Detail_Statistics Detail_Statistics
17 Shard_Statistics Shard_Statistics
18 ServerProcess_All Launch/Shutdown All Server
19 Refresh Franchise IP refresh franchised ip list
20 Change Shard Data change shard name/max user
21 SMC_Plugin_Notice SMC_Plugin_Notice
22 Change Shard ServiceType Change Shard ServiceType
23 Punishment Punishment User
24 SMC_Plugin_CAS SMC_Plugin_CAS Executing Auth
25 SMC_Plugin_SR_UserEdit SMC_Plugin_SR_UserEdit Execute Auth
26 SMC_Plugin_ConcurrentUserLog SMC_Plugin_ConcurrentUserLog Exec Auth
27 CAS_Statistics CAS_Statistics Executing Auth
28 SR_GM_Lvl1 SR_GM_Lvl1 Auth
29 SR_GM_Lvl2 SR_GM_Lvl2 Auth
30 SR_GM_Lvl3 SR_GM_Lvl3 Auth
31 SR_GM_Lvl4 SR_GM_Lvl4 Auth
32 SR_GM_Lvl5 SR_GM_Lvl5 Auth
68 SMC_Plugin_SR_UserBlock SMC_Plugin_SR_UserBlock
69 SMC_Plugin_SR_Statistics SMC_Plugin_SR_Statistics
70 SMC_Plugin_SR_Scheduler ½ºÄÉÁÙ·¯ ¼³Á¤ ±ÇÇÑ
71 SMC_Plugin_IPBlock SMC_Plugin_IPBlock

نفس الخطوات هتعملها تانى ومعى

_SecurityDescriptionGroup And _SecurityDescriptionGroupAssign

بس فى حاجه ال Query هيختلف

انا قولت اعمل زاى ما انا عملت فى _SecurityDescription

هتعمل فى _SecurityDescriptionGroup
_SecurityDescriptionGroupAssign

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[_SecurityDescriptionGroup] Script Date: 10/15/2012 20:39:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SecurityDescriptionGroup](
[nID] [tinyint] IDENTITY(1,1) NOT NULL,
[szName] [varchar](32) NOT NULL,
[szDesc] [varchar](256) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

1 server developer server developer
2 content administrator content administrator
3 content user content user
4 content user vip content user vip
5 content marketer content marketer
6 content monitor content monitor
7 content GM Leader content GM Leader
8 content GM 1 content GM 1
9 content GM 2 content GM 2
10 content GM 3 content GM 3
11 content GM 4 content GM 4
12 content GM 5 content GM 5
NULL NULL NULL

_SecurityDescriptionGroupAssign

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[_SecurityDescriptionGroupAssign] Script Date: 10/15/2012 20:45:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_SecurityDescriptionGroupAssign](
[nGroupID] [tinyint] NOT NULL,
[nDescriptionID] [int] NOT NULL
) ON [PRIMARY]

GO

1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 10
1 11
1 12
1 13
1 14
1 15
1 16
1 17
1 18
1 19
1 20
1 21
1 22
1 23
1 24
1 25
1 26
1 27
1 28
1 29
1 30
1 31
1 32
1 68
1 69
1 70
1 71
2 1
2 3
2 4
2 5
2 6
2 7
2 9
2 10
2 12
2 13
2 15
2 21
2 23
2 25
2 26
2 68
2 69
2 70
3 10
4 10
4 15
5 1
5 5
5 16
5 17
5 21
6 1
6 5
6 16
6 17
6 3
6 11
7 1
7 4
7 5
7 6
7 7
7 9
7 13
7 14
7 15
7 23
7 28
7 29
7 30
7 31
7 32
7 68
7 69
8 14
8 28
9 14
9 29
10 14
10 30
11 14
11 31
12 14
12 32
8 15
9 15
10 15
11 15
12 15

انا عامل الموضوع عشان اعضاء S4A وى عملو عشان اخ F18
بس يا ريت الموضوع محدش ينقلو فى موقع اخر

تم تعديل الموضوع