These tips from abdelfattah's thread if you run first query then you must run second query too to connect SMC.Because first query delete gm accounts too.And you need gm account to login smc.Else you will get this error ;
"cannot connect to division manager (invalid user info)"
First query
Second query
If you need to create your own GM account:
Sorry if my english bad:mad:I wrote them quickly because havent time to thinking.Im busy:p
"cannot connect to division manager (invalid user info)"
First query
PHP Code:
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]
If you need to create your own GM account:
PHP Code:
1. You need a md5 hasher. (can google it)
2. Go to TB_Users table
3. Fill the form like this:
JID: Fills automatically
StrUserID: Username
password: password
status: can leave blank
GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader)
sec_primary - set it to 1 (3 is normal user)
sec_content - set it to 1 (3 is normal user)
4. You can fill in the other neccesary fields like email, adress so on, but theyre not really neccesary.
