- Joined
- Jul 27, 2010
- Messages
- 902
- Reaction score
- 31
Hello Everyone
iam going make Full Guide about how to Make GM Acc working 100%
without any problem
ok Lets Start!
First:Open MMSQL>>>>SRO_VT_ACCOUNT>>>>Right Click on it>>>> Choose New Query>>>>Write This
DONT FORGET TO MAKE SMC ACC
LIKE THIS
Open TB_User>>>
do like this
Close MSSQL after you done from this part!
-------------------------------------------------
Second:
After your Close the MSSQL>>>>Go open (SMC with the user we just made in TB_User)(but ofc you have to open the others .exe so your can open SMC)>>>>Choose Security>>>Choose User Security>>>>Right Click on the Write Page in SMC>>>>Click on Add User>>>>User Property will Appear(it will be like this)
if you using Hamachi ip then you going write it in Granted IP Adress
if you using 192.168.x.x then you going write it in Granted IP Adress
we done From this Part
----------------------------------------------------------------
Three:
After you done from Second Part
go open MSSQL>>>TB_User>>>>you going find the acc we just created>>>>Look what you going do
After you done from TB_User>>>Open _PrivilegedIP>>>put the IP you write in Granted IP Adress
it would be like this
hope you understand this part ^^
Now all you going do is Close MSSQL and Restart your Server >>>then you can Log on Game with the GM Acc
this Guide Credit to me(iam same one who posted it there at epvp)
Hope so it helpfull for you guys
Have Fun!
iam going make Full Guide about how to Make GM Acc working 100%
without any problem
ok Lets Start!
First:Open MMSQL>>>>SRO_VT_ACCOUNT>>>>Right Click on it>>>> Choose New Query>>>>Write This
PHP:
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]LIKE THIS
Open TB_User>>>
do like this
PHP:
JID:leave it
StrUserID:Username of SMC
Password:go to any MD5 Site and wirte any word you want then you will get the MD5 Code....go to Password table and put it
Sec_primary:1
sec_content:1-------------------------------------------------
Second:
After your Close the MSSQL>>>>Go open (SMC with the user we just made in TB_User)(but ofc you have to open the others .exe so your can open SMC)>>>>Choose Security>>>Choose User Security>>>>Right Click on the Write Page in SMC>>>>Click on Add User>>>>User Property will Appear(it will be like this)
PHP:
UserID=Username
Password=your Acc Password
Retype Password=Just type your password again
Name=you can write any name you want
SSNumber=write in the first table(1) and the 2nd table write(1)
Organiztion=write anything you want
Role=write anything you want
PrimarySecurityGroup=Choose Content GM
ContentSecurityGroup=Choose Content GM
Granted IP Adress=abit Complexif you using Hamachi ip then you going write it in Granted IP Adress
if you using 192.168.x.x then you going write it in Granted IP Adress
we done From this Part
----------------------------------------------------------------
Three:
After you done from Second Part
go open MSSQL>>>TB_User>>>>you going find the acc we just created>>>>Look what you going do
PHP:
Status:1
GMrank:1
Sec_Primary:Change it from 6 to 1
Sec_Content:Change it From 6 to 1it would be like this
PHP:
IP1:192
IP2:168
IP3:x
IP4:x
IP5:192
IP6:168
IP7:x
IP8:x
or the ip you put at Granted IP AdressNow all you going do is Close MSSQL and Restart your Server >>>then you can Log on Game with the GM Acc
this Guide Credit to me(iam same one who posted it there at epvp)
Hope so it helpfull for you guys
Have Fun!
