[Release] SRO Content/Data Management System

[defect]

After a lot of work I am happy to announce releasing :Emoji4:, 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

https://i.postimg.cc/DShTKSnv/Web-capture-24-10-2022-131932-localhost.jpg (https://postimg.cc/DShTKSnv)

https://i.postimg.cc/bskhMxXV/Web-capture-24-10-2022-132051-localhost.jpg (https://postimg.cc/bskhMxXV)

https://i.postimg.cc/hQ7BKxXj/Web-capture-24-10-2022-132152-localhost.jpg (https://postimg.cc/hQ7BKxXj)

https://i.postimg.cc/Sjw4DZPz/Web-capture-24-10-2022-132243-localhost.jpg (https://postimg.cc/Sjw4DZPz)

https://i.postimg.cc/Yj4kNcdH/Web-capture-24-10-2022-132318-localhost.jpg (https://postimg.cc/Yj4kNcdH)

https://i.postimg.cc/sQLzFKDq/Web-capture-24-10-2022-132439-localhost.jpg (https://postimg.cc/sQLzFKDq)

https://i.postimg.cc/vgTySCM5/Web-capture-24-10-2022-132547-localhost.jpg (https://postimg.cc/vgTySCM5)




How To Run



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>"
},

Run CrateDB.bat and make sure that DB called "SROCMS" Is created
Modify Application\appsettings.json and change the following values <DBServer> ,<DBUser>,<DBPassword>,<ShardDatabaseName>,<Port>,<DataFolderPath>,<MediaFolderPath>,<UpdateStagingFolderPath>,<MediaTextLanguageIndex>,<MediaTextKeyIndex>,<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>"
}
}
},

Run Start_SRO_CMS.bat and make wait until you see Now listening on: https://[::]:<port>
Open https://localhost:<Port> in the browser
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 (https://www.mediafire.com/file/av3dd2gbxjpi7cm/SRO_CRM.Alpha.0.1.rar/file)