Item Table Data SQL Scripts

[finito]

These SQL scripts re-create item tables with data.

The Price1, Price7, Price30, PriceP, GPrice1, GPrice7, GPrice30, and GPriceP columns are set to 1, 7, 30, 314, 11, 77, 3030, 3145 respectively.
They are just values i came up with they will need changing.
Some of the rows in Items_Attachments and Items_Gear have other values for these columns that was taken from excel files in AdminTools.

The tables are dropped and created again to remove the identity on the itemID column this is done because the data that gets inserted has holes (the itemIDs are not sequential).
If was to insert with the identity spec still there then the itemIDs will end up changing and not match
client data.

Files originally had .sql extension.
dbo.Items_Attachments.Table.txt

dbo.Items_Gear.Table.txt

dbo.Items_Generic.Table.txt

dbo.Items_Weapons.Table.txt

[MentaL]

[Dafkid]

i try to put this on my sql, but when this all is in i got high fps lag ingame... When i remove everything good. any idea?

sorry for my bad english!

[War Inc]

wow nice, work, but i cant buy the items :P

[ccleanerz]

That not a problem of these Tables.

[Ekemos]

wow nice, work, but i cant buy the items :P

The reason for that is I think because there is a value in both Gprice1 and GpriceP if you take one of those values out the price you see in the market should be right

[War Inc]

The reason for that is I think because there is a value in both Gprice1 and GpriceP if you take one of those values out the price you see in the market should be right

I edited table "dbo.UsersData" and work, i can buy items.

[bielz]

Nice work :D
Thanks *-*

[necryth]

Cara, Onde eu Coloco esses arquivos? essas .sql que vc passou ai?

This is an English forum! Respect and follow the thread rules or prepare to get a kick up the a$$! http://forum.ragezone.com/f788/remem...nglish-929279/