[Dev] Arshivel
15-10-2012, 09:50 PM
http://imageshack.us/a/img338/7545/gif1302156586680.gif
http://imageshack.us/a/img263/9779/salamy.gif
الموضوع ده فى كل التحكم فى العبه بى معنى انك تتحكم فى GM و اخ
اولاً الشرح من مجهودى الخاص
وى مش منقول من اح حد
بس كان فى واحد هنا عامل الموضوع ده بس فى ناس كتير مش عرفه تعملو
فا انا قولت اعمل شرح احسن وى اسهل من غير فديو ولا صور كل حاجه سهله جداً
نبداء بسم الله
http://imageshack.us/a/img827/3250/88728653.gif
او حاجه هتفتح SQL
تانى حاجه هتفتح DataBase
وى تختار SRO_VT_ACCOUNT
هتنزل تحت هتلقى
_SecurityDescription
_SecurityDescriptionGroup
_SecurityDescriptionGroupAssign
دول اهم حاجه فى التحكم فى / Developer Or GM Or SP/Or VIP OrOr
http://imageshack.us/a/img827/3250/88728653.gif
اول حاجه هتعلم على _SecurityDescription
وى تدوس كلك يمين وى تختار Delete
وى هتختار New Query عشان ترجع ال _SecurityDescription من جديد
بعد ما تمسح ال _SecurityDescription
New Query
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
بعد ما عملت ال 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
http://imageshack.us/a/img827/3250/88728653.gif
نفس الخطوات هتعملها تانى ومعى
_SecurityDescriptionGroup And _SecurityDescriptionGroupAssign
بس فى حاجه ال Query هيختلف
انا قولت اعمل زاى ما انا عملت فى _SecurityDescription
هتعمل فى _SecurityDescriptionGroup
_SecurityDescriptionGroupAssign
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
_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
http://imageshack.us/a/img827/3250/88728653.gif
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
بس يا ريت الموضوع محدش ينقلو فى موقع اخر
تم تعديل الموضوع
http://imageshack.us/a/img263/9779/salamy.gif
الموضوع ده فى كل التحكم فى العبه بى معنى انك تتحكم فى GM و اخ
اولاً الشرح من مجهودى الخاص
وى مش منقول من اح حد
بس كان فى واحد هنا عامل الموضوع ده بس فى ناس كتير مش عرفه تعملو
فا انا قولت اعمل شرح احسن وى اسهل من غير فديو ولا صور كل حاجه سهله جداً
نبداء بسم الله
http://imageshack.us/a/img827/3250/88728653.gif
او حاجه هتفتح SQL
تانى حاجه هتفتح DataBase
وى تختار SRO_VT_ACCOUNT
هتنزل تحت هتلقى
_SecurityDescription
_SecurityDescriptionGroup
_SecurityDescriptionGroupAssign
دول اهم حاجه فى التحكم فى / Developer Or GM Or SP/Or VIP OrOr
http://imageshack.us/a/img827/3250/88728653.gif
اول حاجه هتعلم على _SecurityDescription
وى تدوس كلك يمين وى تختار Delete
وى هتختار New Query عشان ترجع ال _SecurityDescription من جديد
بعد ما تمسح ال _SecurityDescription
New Query
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
بعد ما عملت ال 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
http://imageshack.us/a/img827/3250/88728653.gif
نفس الخطوات هتعملها تانى ومعى
_SecurityDescriptionGroup And _SecurityDescriptionGroupAssign
بس فى حاجه ال Query هيختلف
انا قولت اعمل زاى ما انا عملت فى _SecurityDescription
هتعمل فى _SecurityDescriptionGroup
_SecurityDescriptionGroupAssign
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
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
http://imageshack.us/a/img827/3250/88728653.gif
_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
http://imageshack.us/a/img827/3250/88728653.gif
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
بس يا ريت الموضوع محدش ينقلو فى موقع اخر
تم تعديل الموضوع