Posted October 23, 2015 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
Posted October 23, 2015 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
Posted October 23, 2015 (edited) 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 CubicFtCostFROM ((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.MaterialIDGROUP 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))/144ORDER BY CxMaterial.Name Edited October 23, 2015 by LastChime Share this post Link to post Share on other sites