Alvin singco s at 16:57, 20 August 2019

2019-08-20T16:57:32Z

Alvin singco s at 16:37, 20 August 2019

2019-08-20T16:37:34Z

Alvin singco s: Created page with "

Download SQLite DB Browser

2019-07-23T10:56:45Z

Created page with "<div class="panel panel-default"> <div id="headingOne" class="panel-heading"> <h4 class="panel-title">Download SQLite DB Browser</h4> </div> <div id="collapseOne" class="panel..."

New page
<div class="panel panel-default">
<div id="headingOne" class="panel-heading">
<h4 class="panel-title">Download SQLite DB Browser</h4>
</div>
<div id="collapseOne" class="panel-collapse collapse">
<div style="text-align: center;"><div class="panel-body">Download the [http://sqlitebrowser.org/ SQLite DataBase Browser] for your operating system. We recommend using the portable app version<br /><br />[[File:SQLiteDBBrowser.png|720px|center]]</div>
<div style="text-align: center;"><br /><br /><br />Install the SQLite DB browser and run it<br /><br /></div>
</div>
</div>
<div class="panel panel-default">
<div id="headingTwo" class="panel-heading">
<h4 class="panel-title">Open Database from sqlite\wurmslogin.db</h4>
</div>
<div id="collapseTwo" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">In the top toolbar select Open Database<br /><br />
<div>Navigate to the sqlite folder in your database folder<br /><br /></div>
<div>Open the wurmlogin.db database file</div>
<br /><br />[[File:OpenDatabaseWurmsLogin.png]]<br /><br /></div>
<div style="text-align: center;"> </div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingThree" class="panel-heading">
<h4 class="panel-title">Browse Data Tab</h4>
</div>
<div id="collapseThree" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;"><br />Select the second tab from the left, the Browse Data tab<br /><br />[[File:BrowseDataTab.png]]<br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingFour" class="panel-heading">
<h4 class="panel-title">SERVERS Table</h4>
</div>
<div id="collapseFour" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;"><br /><br />In the dropdown Table menu select SERVERS<br /><br />[[File:SERVERSTable.png]]<br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingFive" class="panel-heading">
<h4 class="panel-title">New Record in SERVERS Table</h4>
</div>
<div id="collapseFive" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;"><br /><br />At the right hand side of this select New Record<br /><br /></div>
<div style="text-align: center;">The first thing to do is choose a unique Server ID under SERVER for the new record<br /><br />[[File:NewRecordSERVERID.png]]
<br /><br /><br /></div>
<div style="text-align: center;"><br />Remember the Server IDs for the existing server and the new server. They will be needed in the following step and further steps!<br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingSix" class="panel-heading">
<h4 class="panel-title">SERVERNEIGHBOURS Table</h4>
</div>
<div id="collapseSix" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">In the Table dropdown menu now select SERVERNEIGHBOURS<br /><br />[[File:SERVERNEIGHBOURS.png]]<br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingSeven" class="panel-heading">
<h4 class="panel-title">Add NEIGHBOUR and DIRECTION to SERVERNEIGHBOURS SERVER</h4>
</div>
<div id="collapseSeven" class="panel-collapse collapse">
<div class="panel-body">In the SERVERNEIGHBOURS table the records for your servers and which other servers they neighbour are kept<br /><br /></div>
<div style="text-align: center;">For the existing server enter the Server ID of the new server in the NEIGHBOUR attribute<br /><br /></div>
<div style="text-align: center;">In the DIRECTION attribute specify the direction you want this new neighbouring server to be in relation to the existing server<br />Example: EAST (all caps)<br /><br />
[[File:SERVERNEIGHBOURSFilled.png]]
<br /><br /><br /><br /></div>
</div>
</div>
<div class="panel panel-default">
<div id="headingEight" class="panel-heading">
<h4 class="panel-title">File - Write Changes</h4>
</div>
<div id="collapseEight" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">Press Ctrl+S or select Write Changes in the File menu to save the changes to the database<br /><br />
[[File:WriteChanges.png]]<br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingNine" class="panel-heading">
<h4 class="panel-title">Upload Database with FTP Client or File Manager</h4>
</div>
<div id="collapseNine" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">With a prefered FTP client or File Manager upload the whole database to your server<br /><br />A related guide for FTP and File Managers can be found here:</div>
<div style="text-align: center;"><a href="http://www.citadelservers.com/client/knowledgebase/2/How-to-Install-or-Set-up-FTP--UploadingorDownloading-Files-on-the-Server.html">FTP</a> or <a href="http://www.citadelservers.com/client/knowledgebase/115/How-To-Use-The-File-Manager.html">File Manager</a> Guide<br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingTen" class="panel-heading">
<h4 class="panel-title">Configuration Files</h4>
</div>
<div id="collapseTen" class="panel-collapse collapse">
<div class="panel-body">In the Wurm Unlimited game Control Panel select Configuration Files</div>
<div style="text-align: center;"><br />[[File:ConfigurationFiles.png]]<br /><br /><br /><br /></div>
<div style="text-align: center;"> </div>
</div>
</div>
<div class="panel panel-default">
<div id="headingEleven" class="panel-heading">
<h4 class="panel-title">Configuration Editor for Service Settings</h4>
</div>
<div id="collapseEleven" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">In Configuration Files select Text Editor under Actions for the ServiceSettings<br /><br />[[File:ServerSettings.png]]
<br /><br /><br /><br />Copy down the Internal Server Port, External Server Port, RMI Port, and RMI Reg Port.<br /><br />[[File:ServerInfo.png]]
<br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingTwelve" class="panel-heading">
<h4 class="panel-title">Neighbor Settings</h4>
</div>
<div id="collapseTwelve" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">Return to Configuration Files but now select Configuration Editor under Actions for the ServiceSettings.<br /><br />Find the corresponding Neighbour Settings for the DIRECTION you chose in the SERVERNEIGHBOURS Table<br />Example: Eastern Neighbor Settings<br /><br />[[File:ServiceSettingsConfigurationEditor.png]]<br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingThirteen" class="panel-heading">
<h4 class="panel-title">Enter Server Information</h4>
</div>
<div id="collapseThirteen" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">Enter the Server ID you chose for the new server from the SERVER table in the "Server ID of Eastern server:" field</div>
<div style="text-align: center;"><br />Enter the server name and the relevant port information of your second server into the rest of the Settings fields<br /><br /><br />
[[File:ServiceSettingsConfigurationEditorFilled.png]]</div>
<div style="text-align: center;"><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingFourteen" class="panel-heading">
<h4 class="panel-title">Update Database</h4>
</div>
<div id="collapseFourteen" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">Click Save and return to the Wurm Unlimited game Control Panel. Click the "Update Database (Click before Starting Server)" option<br /><br />
[[File:UpdateDatabase.png]]<br /><br /><br /><br /><br /></div>
</div>
</div>
</div>
<div class="panel panel-default">
<div id="headingFifteen" class="panel-heading">
<h4 class="panel-title">Configuration File</h4>
</div>
<div id="collapseFifteen" class="panel-collapse collapse">
<div class="panel-body">
<div style="text-align: center;">Find the folder of your Login server<br /><br /></div>
<div style="text-align: center;">Open the directory of the map you're playing (Example: Creative)<br /><br /></div>
<div style="text-align: center;">Open the Wurm.ini with notepad<br /><br /></div>
<div style="text-align: center;">Find the line named "USE_INCOMING_RMI=false" with Ctrl+F<br /><br /></div>
<div style="text-align: center;">Change it to "USE_INCOMING_RMI=true"<br /><br /></div>
<div style="text-align: center;">If the "USE_INCOMING_RMI=false" line does not exist in the file then add it<br /><br />
[[File:Wurmpedia.png]]</div>
</div>
</div>
</div>
</div>
</div>

[[Category:Wurm Unlimited]] [[Category:Wurm Unlimited Server Help Articles]]

@@ Line 95: / Line 95: @@
 <div class="panel-body">
 <div style="text-align: center;">With a prefered FTP client or File Manager upload the whole database to your server<br /><br />A related guide for FTP and File Managers can be found here:</div>
-<div style="text-align: center;">[[FTP_Set-up_Guide|FTP]] or <a href="http://www.citadelservers.com/client/knowledgebase/115/How-To-Use-The-File-Manager.html">File Manager</a> Guide<br /><br /><br /><br /></div>
+<div style="text-align: center;">[[FTP_Set-up_Guide|FTP]] or [[How_To_Use_The_File_Manager_in_the_game_panel|File Manager]] Guide<br /><br /><br /><br /></div>
 </div>
 </div>

Clustered multiple Wurm servers - Revision history

Alvin singco s at 16:57, 20 August 2019

Alvin singco s at 16:37, 20 August 2019

Download SQLite DB Browser