Commit graph

67 commits

Author SHA1 Message Date
Ty Conner
890cc488b8
Update LandblockInstanceWriter.cs 2025-08-05 13:46:01 -04:00
Ty Conner
d62d926eb1
Update LandblockInstanceWriter.cs 2025-08-05 00:24:11 -04:00
OptimShi
53edc5b1c3
Added importsql/exportsql support for events. Added additional weenie info to landblock SQLWriter. (#4333)
Co-authored-by: OptimShi <26606778+OptimShi@users.noreply.github.com>
2025-07-16 00:34:45 -04:00
Mag-nus
5eea5154e1
Improve BiotaSQLWriter for ACLogView (#4071)
This also fixes the missing order column for BiotaPropertiesPalette
2023-12-17 20:14:42 +00:00
Ty Conner
77761f4f91
Update SQLWriter for InventoryTreasureType (#3971) 2023-04-08 14:43:43 -04:00
Ty Conner
6180872702
Fix SQLWriter for WieldedTreasureDID data (#3967)
* Update SQLWriter.cs

* Update TreasureWieldedSQLWriter.cs
2023-04-08 13:34:04 -04:00
Ty Conner
a27a07201e
Update SQL Writers (#3768) 2022-01-02 02:19:39 -05:00
Ty Conner
c380b6e442
Update Event SQL Writer (#3756) 2021-12-14 00:12:48 -05:00
Ty Conner
71dc02ed63
Fix issue with SQL writers in rounding and negative zeros (#3734) 2021-11-08 00:41:17 -05:00
Ty Conner
b29de8941d
Update SQL Writers (#3733) 2021-11-07 03:53:43 -05:00
Ty Conner
880c031102
Update SQL Writer output (#3694)
* Update SQL Writer output

* Update SQLWriter.cs

* Add PacketOpCodeNames

* Update PropertyInt.cs

* Update PropertyInt.cs
2021-10-18 21:33:27 -04:00
Ty Conner
5a55ec08ce
SQL Writer updates (#3637) 2021-08-02 14:24:10 -04:00
Ty Conner
82578fffb6
Some Appraisal changes (#3067)
* SQL Writer update

* Some Appraisal changes

Moving properties to runtime only
2020-07-12 18:40:05 -04:00
Ty Conner
f4ac60de26
Fix issue with spent xp verification (#3055)
* Fix issue with spent xp verification

* Update PropertyDataId.cs

* Update DeveloperFixCommands.cs

* Update DeveloperFixCommands.cs

* Update DeveloperFixCommands.cs

* Update DeveloperFixCommands.cs
2020-07-03 23:15:28 -04:00
Ty Conner
f4356a0b94
SQL Writer tweaks (#3032)
- Also corpse height bug fix
2020-06-19 22:26:17 -04:00
gmriggs
6d9ba2abc8
Revert "fixing shade=0, from optimshi (#2870)" (#2896)
This reverts commit 640847bf55.
2020-04-11 12:54:45 -04:00
gmriggs
640847bf55
fixing shade=0, from optimshi (#2870)
* fixing shade=0, from optimshi

* more shade references
2020-03-29 23:18:12 -04:00
Ty Conner
da3c56623d
LandblockInstanceWriter: InstanceNames -> WeenieNames (#2789)
* LandblockInstanceWriter: InstanceNames -> WeenieNames

* Revert "LandblockInstanceWriter: InstanceNames -> WeenieNames"

This reverts commit 77356feafa.

* Update DeveloperContentCommands.cs

* @gmriggs

* Update LandblockInstanceWriter.cs

* Update LandblockInstanceWriter.cs

* Update LandblockInstanceWriter.cs

* Update LandblockInstanceWriter.cs
2020-03-07 23:24:57 -05:00
gmriggs
6a35f6cfd5
adding support for landblock / recipe / quest to export-sql and export-json (#2739) 2020-02-26 23:54:17 -05:00
gmriggs
97ef273a73
add support for recipes to DeveloperContentCommands (#2664) 2020-02-12 03:31:38 -05:00
gmriggs
02505140ad
improving /createinst command for content dev (#2601)
* improving /createinst command for content dev

* .

* ..

* adding option to manually specify a start guid

* adding partial key handling, max static guid checks

* adding range check
2020-01-17 04:39:39 -05:00
Ty Conner
a02879b64c
PetClass commenting for SQL Writer (#2523) 2019-12-11 12:49:00 -06:00
Mag-nus
3589b61c60
CharacterExporter fixes (#2475)
Fix CharacterSQLWriter for CharacterPropertiesContractRegistry

PropertyInt, add comments for PlacementPosition and add InventoryOrder for future use.
2019-11-27 16:06:29 -06:00
Ty Conner
2d87ef74e3
Add full support for Contracts (#2150)
* Add full support for Contracts

* Update Commands

* Update ContractManager.cs

* Update DeveloperCommands.cs

* Update ContractManager.cs

Fix PackableHashTable stuff

* Update ContractTracker.cs

Add in vaguely used Stamped version

* Update ContractManager.cs

* Update ContractManager.cs

* Some tweaks

* More tweaking

* Create ContractId.cs

* Update PropertyInt.cs

* Update ContractId.cs

* Provide feedback for IsFull

* Update QM to prevent Update from writing more solves than max allows

* null catch

* .

* Update LifestonedConverter.cs

* Update Gem.cs

* Update changelog.md

* Update changelog.md
2019-07-28 22:25:22 -05:00
gmriggs
92dc48dbac
adding json import, live editing for content creators (#2042)
* adding json import, live editing for content creators

* using existing WriteOutput functions

* adding DeveloperContentCommands.cs

* adding import-sql

* adding sql2json

* adding try/catch to sql2json

* Add a null check to emote action writer

* Update SQL output

* Update DeveloperContentCommands.cs

* Update DeveloperContentCommands.cs
2019-07-01 03:36:56 -04:00
Mag-nus
094bdb9e20
Few more very minor things (#2046)
Also fixed an exception in WorldObject_Set when an wo didn't have an ItemLevel value
2019-06-25 22:17:04 -05:00
Mag-nus
901dc0b7da
Biota and Character SQL Writers (#2026) 2019-06-21 10:10:10 -05:00
Ty Conner
c620494863
Some Housing Changes (#1844)
* Changes to House Warning Messages filter

* Set HousePortal destinations based on data from database with fallback to SlumLord

* Init House from World DB if not found in Shard DB

* Update House SQL Writer
2019-05-02 11:24:58 -05:00
Ty Conner
5d4e721909
Change RecipeManager.ModifyX to follow rules of operation (#1837)
* Swap source and target in GetTargetMod

* Change ModifyOp.CopyTarget to copy sourceMod to target

* Adjust ModifyX functions to correct objects

* Update changelog.md

* Reorg Enums

* Update to Writers
2019-05-01 19:44:03 -05:00
Ty Conner
f9ee96a5c1
Fix Recipe Issue (#1721)
* Fix minor issue with scrolls

* Fix scoping issue with Recipe Requirements and Mods

* Update changelog and readme
2019-04-13 15:07:09 -05:00
Mag-nus
4dab146548
Code cleanup (#1681)
* Flags attribute

* empty statement

* Fix Formatting

* Fix OrderBy -> ThenBy

* use OfType

* Replace with asingle call to Count(...)

* Replace with a single call to FirstOrDefault

* Merge cast with type check

* use String.IsNullOrEmpty

* use collections count property

* use format specifier (results in shorter loc)

* use Any() instead of Count() > 0

* revert ThenBy with comment
2019-04-10 20:48:34 -05:00
Ty Conner
4c3809faa8
Add support for GDLe recipe conversions (#1691)
* Update Crafting SQL Writer

* Add support for GDLe recipe conversion

* cleanup
2019-04-10 12:42:33 -05:00
Ty Conner
dad9d900a7
Remove sorting on Generator list (#1669)
* Remove sorting on Generator list

* Disallow WeenieId on TryConvert

* Update LifestonedConverter.cs
2019-04-08 01:36:03 -05:00
Ty Conner
3dc023d200
Update LSD converter to support enum shifting (#1666)
* Update LSD converter to support enum shifting

* Add bool to Try Converts

* Update LSD DataModel

* Update Writer and Exporter
2019-04-07 19:56:56 -05:00
Ty Conner
a890c07b26
Update CreateList output to not sort by weenie class id (#1635) 2019-04-02 23:42:13 -05:00
Ty Conner
daeddf48a1 Changes to GenerateTreasure (#1428)
* Changes to GenerateTreasure

* writer update

* Update writers to finish deletes

* correct column issue
2019-02-11 12:35:18 -08:00
Ty Conner
bd5d7fc32d
Add LastModified to things (#1410)
* Add LastModified to things

* Create db-pr-override.txt

* Update changelog.md

* Update README.md
2019-02-04 11:55:13 -06:00
Ty Conner
2f34df8f3a
Add AiOptions, TargetingTactic and Tolerance enums to commented SQL output (#1382)
* Add AiOptions, TargetingTactic and Tolerance enums to commented output

* Hazarding a guess that CombatTactic, HomesickTargetingTactic and TargetingTactic share same enum

* Add ArmorType

* Output ArmorType in SQL comments

* update ArmorType
2019-01-26 19:19:06 -06:00
Mag-nus
616feed958
Assembly changes (#1369)
* Change child assemblies to AnyCPU. Ace.Server still x64

* Fix LifestonedConverter for > ushort.MaxValue weenies

* Allow DbContexts to be configured/used by other applications

* Make GetWeenie public

* SQLWriters should take IDictionary, not Dictionary

* Include links

* Keep tests as x64
2019-01-26 10:09:13 -06:00
Ty Conner
3dbf792591
Add and use DotDuration in Spells (#1331)
* Add DotDuration to Spell table

* Rename Emote Table script slightly

* Change to Double

* Update Duration to use DotDuration if it has a value

* Add DotDuration to SQL Writer
2019-01-20 22:15:12 -06:00
Ty Conner
350edddcf6
World DB Changes (#1295)
* Minor PCAP commenting fix

* Remove Duplicated Data from Spell Table

* Update MySqlInstall.bat

* Update Recipe Mods table column Unknown1 to Source

* Update SpellProperties.cs

* Add spell-export

* cleanup

* Update code

* delete spell-export

* remove data that was redunant from dat

* Update CreateList and Generator labels

* Change Emote.Display to Bool

* Change Emote.Display to Bool

* Fix script

* update changelog

* Add some null checks

* More null check

* syntax error

* cleanup

* more cleanup

* Create db-pr-override.txt
2019-01-19 19:55:26 -06:00
Ty Conner
5dbd24ef6d
Changes to support PCAP exported data being used in database (#1116)
* Add PCAPRecorded properties and enums

* Adjust CalculateObjDesc to read and use Biota data if present and no EquippedObjects are found

* Fix issue with telepoi command

* Update changelog.md
2018-12-07 13:49:17 -05:00
Ty Conner
13d68a0d5f
Update appveyor.yml for tests (#1114)
* Update appveyor.yml

* Update appveyor.yml

* Update appveyor.yml

* Update appveyor.yml

* Update appveyor.yml

* Update appveyor.yml

* Update appveyor.yml

* Update for appveyor logging

* Update appveyor.yml

* Update build order

Build source before setting up database and testing.. Faster notification of fail conditions

* Update batch files

* Add a delete to a writer
2018-12-04 00:26:05 -05:00
Ty Conner
a6e2308b68
remove redundant dictionary (#1080) 2018-11-01 02:54:42 -04:00
Ty Conner
7a239cd297
Some Writer tweaks (#1068) 2018-10-15 03:51:49 -04:00
Ty Conner
23f033fd0e
Add teleloc to writers (#1055) 2018-10-09 22:54:25 -04:00
Ty Conner
eac0370646
Fix Generator Ints (#1042)
* Add SQL update scripts

* Update Shard and World base scripts

* Update Shard Scaffolding

* Update World database Scaffolding
2018-10-02 21:34:58 -04:00
gmriggs
43d1373568
Adding Void magic (#1028)
* Adding Void magic

* Mapping BaseRangeConstant to SpellBase

* Fixing DoTs to only use the top layer enchantments

* Added limiter for switching between war and void magic
2018-09-28 03:55:32 -04:00
Ty Conner
c01d39b4bf
Changing Sort Order for Create List and Generators (#948) 2018-08-11 21:40:08 -04:00
Ty Conner
99c6385dab
Fix TargetType error in SQLWriter (#947) 2018-08-11 18:21:55 -04:00