Sign in to follow this  
LastChime

Information on editing area names and in-game map

Recommended Posts

For custom generated maps like the ones made by the fabulous WGenerator.

Just not sure how gritty you have to get into the *barf* sql *barf* to do it.

Share this post


Link to post
Share on other sites

there is a file called insertwurmzones.sql in the sqlite folder of the server that runs when you start a new server.  Just edit that to make new zones you want.


 


You can also manually edit the focus zones in game with the wand.


 


 


This is what is in there now:


 


BEGIN TRANSACTION;

INSERT INTO `KINGDOMS` (KINGDOM,KINGDOMNAME,PASSWORD,TEMPLATE,SUFFIX,CHATNAME,FIRSTMOTTO,SECONDMOTTO,ACCEPTSTRANSFERS,WINPOINTS) VALUES (0,'no known kingdom','',0,'','none','Unknown','Unknown',0,0),

 (1,'Jenn-Kellon','',1,'jenn.','Jenn-Kellon','Noble','Protectors',1,0),

 (2,'Mol Rehan','',2,'molr.','Mol Rehan','Fire','Gold',1,0),

 (3,'Horde of the Summoned','',3,'hots.','HOTS','Hate','Vengeance',1,0),

 (4,'Freedom Isles','',4,'free.','Freedom','Peaceful','Friendly',1,0);

INSERT INTO `FOCUSZONES` (ID,STARTX,ENDX,STARTY,ENDY,TYPE,NAME,DESCRIPTION) VALUES (1,907,947,1402,1442,3,'The Meadow',''),

 (2,417,457,669,709,3,'West Lake',''),

 (3,1394,1434,558,598,3,'Soulfall East Beach',''),

 (4,1294,1374,584,664,3,'Soulfall Mountain',''),

 (5,1162,1202,1026,1066,3,'Central Lakes',''),

 (6,1124,1164,286,326,3,'Northern Shores','');

COMMIT;

Share this post


Link to post
Share on other sites

Oh ok, it looks a lot less ugly than the asperger's SQL I'm used to dealing with for my cad/cam forms and reports.

 

SELECT CxMaterial.Name, CxMaterial.DefaultCost, [Waste]/100 AS WastePercent, [CxExtraBoardInfo].[RoughThickness]/25.4 AS RThick, [CxExtraSizeInfo].[Thickness]/25.4 AS SThick, CxMaterial.UnitOfIssueID, Sum([Area]/144) AS SqFt, Sum([Area]/144+(([Area]/144)*[wastepercent])) AS SqFtWaste, [sqFtWaste]*[DefaultCost] AS SqFtCost, Sum([Area]*0.0254*0.0254) AS SqM, Sum(([Area]*0.0254*0.0254)+(([Area]*0.0254*0.0254)*[WastePercent])) AS SqMWaste, [sqmwaste]*[defaultcost] AS SqMCost, Sum([Parts].[Length]/12) AS LinFt, Sum([Parts].[Length]/12+(([Parts].[Length]/12)*[wastepercent])) AS LinFtWaste, [LinFtWaste]*[defaultcost] AS LinFtCost, Sum(([Area]*[rthick])/144) AS BdFt, Sum((([Area]*[rthick])/144)+((([Area]*[rthick])/144)*[WastePercent])) AS BdFtWaste, [bdFtWaste]*[DefaultCost] AS BdftCost, Sum([Parts].[Length]*0.0254) AS LinM, Sum([Parts].[Length]*0.0254+(([Parts].[Length]*0.0254)*[wastepercent])) AS LinMWaste, [LinMWaste]*[DefaultCost] AS LinMCost, Sum(([parts].[Area]*0.0254*0.0254)*([RThick]*0.0254)) AS BdM, Sum((([parts].[Area]*0.0254*0.0254)*([RThick]*0.0254))+((([parts].[Area]*0.0254*0.0254)*([RThick]*0.0254))*[WastePercent])) AS BdMWaste, [bdMWaste]*[DefaultCost] AS BdMCost, Sum(([parts].[Area]*0.0254*0.0254)*([sThick]*0.0254)) AS CubicM, Sum((([parts].[Area]*0.0254*0.0254)*([RThick]*0.0254))+((([parts].[Area]*0.0254*0.0254)*([RThick]*0.0254))*[WastePercent])) AS CubicMWaste, (([CxExtraSizeInfo].[Width]/25.4)*([CxExtraSizeInfo].[Length]/25.4))/144 AS SheetSize, Sum(([Area]/144)/[sheetSize]) AS NoOfSheets, Sum((([Area]/144)/[sheetSize])+((([Area]/144)/[sheetSize])*[WastePercent])) AS NoOfSheetsWaste, [NoOfSheetsWaste]*[DefaultCost] AS NoOfSheetsCost, Count(Parts.[Part ID]) AS Each, Fix(Count([Part ID])+(Count([Part ID])*[WastePercent])+0.999999999) AS EachWaste, [EachWaste]*[DefaultCost] AS EachCost, Sum(([Parts].[Width]/12)*([Parts].[Length]/12)*[sThick]) AS CubicFt, Sum((([Parts].[Width]/12)*([Parts].[Length]/12)*[sThick])+((([Parts].[Width]/12)*([Parts].[Length]/12)*[sThick])*[WastePercent])) AS CubicFtWaste, [CubicFtWaste]*[DefaultCost] AS CubicFtCost



FROM ((Parts LEFT JOIN CxMaterial ON Parts.[Material ID] = CxMaterial.ID) LEFT JOIN CxExtraBoardInfo ON CxMaterial.ID = CxExtraBoardInfo.MaterialID) LEFT JOIN CxExtraSizeInfo ON CxMaterial.ID = CxExtraSizeInfo.MaterialID

GROUP BY CxMaterial.Name, CxMaterial.DefaultCost, [Waste]/100, [CxExtraBoardInfo].[RoughThickness]/25.4, [CxExtraSizeInfo].[Thickness]/25.4, CxMaterial.UnitOfIssueID, (([CxExtraSizeInfo].[Width]/25.4)*([CxExtraSizeInfo].[Length]/25.4))/144

ORDER BY CxMaterial.Name

Edited by LastChime

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this