[Release] SRO Content/Data Management System

[defect]

After a lot of work I am happy to announce releasing , A tool to manage all Silkroad data include the following

• Item Management (Done)
• Skills Management
• Monsters Management
• NPCs Management
• Shops Management
• Quests Management
• Region and Portals Management

[YOUTUBE HD]https://www.youtube.com/watch?v=TWfgUYDNoHw[/YOUTUBE HD]
Screenshots


















How To Run

1. Modify Migrator\appsettings.json and change the following values <DBServer> ,<DBUser>,<DBPassword>,<Port>
   

     "ConnectionStrings": {
       "Default": "Server=<DBServer>;Database=SROCMS;UID=<DBUser>;PWD=<DBPassword>"
     }

     "ConnectionStrings": {
       "Default": "Server=<DBServer>;Database=SROCMS;UID=<DBUser>;PWD=<DBPassword>"
     }

    "SRO_CMS_Swagger": {
           "ClientId": "SRO_CMS_Swagger",
           "RootUrl": "https://localhost:<Port>"
         }

    "SRO_CMS_Web": {
           "ClientId": "SRO_CMS_Web",
           "ClientSecret": "1q2w3e*",
           "RootUrl": "https://localhost:<port>"
         },

2. Run CrateDB.bat and make sure that DB called "SROCMS" Is created
3. Modify Application\appsettings.json and change the following values <DBServer> ,<DBUser>,<DBPassword>,<ShardDatabaseName>,<Port>, <DataFolderPath>,<MediaFolderPath>,<UpdateStagingF olderPath>,<MediaTextLanguageIndex>,<MediaTextKeyI ndex>,<MediaTextIdIndex>
   

     "ConnectionStrings": {
       "Default": "Server=<DBServer>;Database=SROCMS;UID=<DBUser>;PWD=<DBPassword>",
       "VSRO_SHARD": "Server=<DBServer>;Database=<ShardDatabaseName>;UID=<DBUser>;PWD=<DBPassword>"
     }

    "Settings": {
       "DataPath": "<DataFolderPath>",
       "MediaPath": "<MediaFolderPath>",
       "UpdateStagingFolder": "<UpdateStagingFolderPath>",
       "MediaTextLanguageIndex": <MediaTextLanguageIndex>,
       "MediaTextKeyIndex": <MediaTextKeyIndex>,
       "MediaTextIdIndex": <MediaTextIdIndex>
     }

    "Kestrel": {
       "Endpoints": {
         "Http": {
           "Url": "http://*:44359"
         },
         "Https": {
           "Url": "https://*:<port>"
         }
       }
     },

4. Run Start_SRO_CMS.bat and make wait until you see Now listening on: https://[::]:<port>
5. Open https://localhost:<Port> in the browser
6. Use "Admin" , "1q2w3E*" as admin username and password (you may change it later)

Settings Desc

• <DBServer> : Your Database Server address ex. "localhost\\SQLEXPRESS"
• <DBUser> : Your Database user ex. "sa"
• <DBPassword> : Your Database username password
• <ShardDatabaseName> : Your Shard Database name ex. "SRO_VT_SHARD"
• <port> : Your preferred port to run SRO CMS ex. "44358"
• <DataFolderPath> : Path of extracted Data folder from Data.pk2 exist the same machine where SRO CMS is running
• <MediaFolderPath> : Path of extracted Media folder from Media.pk2 exist the same machine where SRO CMS is running
• <UpdateStagingFolder> : Path of folder where all data/media file changes will be copied so that you can update client with it later (MediaFolderPath and DataFolderPath) will have the same updates
• <MediaTextLanguageIndex> : Index of language in your text files default for Vsro 8
• <MediaTextKeyIndex> : Index of code128 in your text files default for Vsro 1
• <MediaTextIdIndex> : Index of id in your text files not exist fpr Vsro

VSRO

    "MediaTextLanguageIndex": 8,
    "MediaTextKeyIndex": 1,
    "MediaTextIdIndex": -1

ISRO

    "MediaTextLanguageIndex": 9,
    "MediaTextKeyIndex": 2,
    "MediaTextIdIndex": 1

Download