Zitem 2 SQL tool

[spike2147]

Hello guys,
First tool since years.
This basically transforms your zitem.xml in to an sql file (which can be run on your database).
It also takes the strings out of strings.xml so the names and descriptions will be fine.

Two options in the tool:
1. Truncate table before query.
THIS IS NOT RECOMMENDED TO DO.
This option will clear your Item table to insert the new rows. You cannot have foreign keys in your database to use this option.
2. Simple compress
Will delete all new line characters.

The SQL file will be outputted as the following:

UPDATE [Item] SET [Name]='Rusty Dagger', [TotalPoint]='0', [ResSex]='3', [ResLevel]='0', [Slot]='1', [Weight]='5', [BountyPrice]='1', [Damage]='8', [Delay]='366', [Controllability]='0', [Magazine]='0', [ReloadTime]='0', [SlugOutput]='0', [Gadget]='0', [HP]='0', [AP]='0', [MAXWT]='0', [SF]='0', [FR]='0', [CR]='0', [PR]='0', [LR]='0', [BlendColor]='0', [ModelName]='dagger01', [Description]='It has some rust here and there. Once used, it'+CHAR(39)+'s sure to be difficult to sell.', [MaxBullet]='0', [LimitSpeed]='0', [IsCashItem]='0', [IsSpendableItem]='0' WHERE [ItemID]='1'
IF @@ROWCOUNT = 0 INSERT INTO [Item] ([ItemID], [Name], [TotalPoint], [ResSex], [ResLevel], [Slot], [Weight], [BountyPrice], [Damage], [Delay], [EffectID], [Controllability], [Magazine], [ReloadTime], [SlugOutput], [Gadget], [HP], [AP], [MAXWT], [SF], [FR], [CR], [PR], [LR], [BlendColor], [ModelName], [Description], [MaxBullet], [LimitSpeed], [IsCashItem], [IsSpendableItem]) VALUES ('1', 'Rusty Dagger', '0', '3', '0', '1', '5', '1', '8', '366', NULL, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'dagger01', 'It has some rust here and there. Once used, it'+CHAR(39)+'s sure to be difficult to sell.', '0', '0', '0', '0');

How to use:
1. Locate your system.mrs decompressed folder.
2. Edit your database name and tick the options you'd like to have.
3. Press generate and select a path to save it.
4. Execute it on your sql server.

Image:


Download: Zitem 2 SQL.zip
Vscan: https://www.virustotal.com/nl/file/e...is/1379451278/

Enjoy (or hate)

[MentaL]

[Anju]

Just so you know, the matchserver already does this.

[Olrac]

Looks cool :D

[spike2147]

Just so you know, the matchserver already does this.

I searched for it, didn't found anything.
I'm using jur13ns, and it didn't import them for me so that's why I made this.

[Anju]

One of my old Gunz files has something like this. Every time you start up the MatchServer, it creates/recreates a file named, "item.sql"

[TheCodeOfGunz]

One of my old Gunz files has something like this. Every time you start up the MatchServer, it creates/recreates a file named, "item.sql"

it's matchserverd w/e where the server build in debug mode and it will automatically create a item.sql etc.

[medotarek]

navicat better :D

[Forean]

navicat better :D

@Topic, 10/10 u good bro!

[Solaire]

navicat better :D

If you have no idea what you're talking about then refrain from posting.

[Rexo]

nice release, thank you.