TBL_STDITEMS Problem

[witty]

Sorry if i sound a little simple. I'm new to putting a server up.

Basicly i want to try new skins on weapons. armours and such. Now I'm not exactly sure how to do it, but i have a genral idea. The one thing that seems to be standing in my way (Apart from having no clue what I'm doing" Is when i try to edit my TBL_STDITEMS collums in SQL it says
"Transaction cannot Start in firehose mode"
Now there may be a button I'm missing and I'm going to sound stupid. But if anyone could inform me how to sort this it would be great!

I understand there may be guides and i have used the search button. But i'm looking for this sulution to this problem and possibly a little "OUTLINE" Guide as to how i change weapon skins. Like i said. I have a genral idea just need some of the gaps filling in.

Any help will be great.

Thanx
Dan

 

[samhag]

Sorry if i sound a little simple. I'm new to putting a server up.

Basicly i want to try new skins on weapons. armours and such. Now I'm not exactly sure how to do it, but i have a genral idea. The one thing that seems to be standing in my way (Apart from having no clue what I'm doing" Is when i try to edit my TBL_STDITEMS collums in SQL it says
"Transaction cannot Start in firehose mode"
Now there may be a button I'm missing and I'm going to sound stupid. But if anyone could inform me how to sort this it would be great!

Try scrolling the table right down to the end before editing and see if that helps.

 

[witty]

bah i knew it would be a simple answer that would make me look stupid. Thanx alot man!
Anyone give me a short guide on how to make weapons diffrent. Quick guide!

Thanx again

 

[excluded]

to change the looks of the armours and weaps u need to do following but if u have a h88 file it makes it a little easier:
u need to change the fld_shape to a number and the fld_imgindex to as number and everytime u change it u get a different shape on ur char and a different look on ur body , u got to keep number crunching and soon enough u will see an image that looks same on ur char and ur body hope that helps :P
dont forget in ur sql everytime u change numbers click on the sql at top with a tick on it and the ! button then in ur m2 diamond bit go to control and reload items , then go make item in game and see if its wrong or right once u mastered all that it takes a couple of mins to change each time so get the item way u want it BUT ITS ALL DOWN TO NUMBER CRUNCHING LOL gl though...
hope that helps :P

 

[Tom27]

Is there an easy way to match the shapes up?
Im sick of going through every number to find the simplest wep.

Anybody know anything what i can do to make this faster?

 

[Weikster]

Yeah, for weapons, divide the number of first image of what you want by 1200.(since each weap has 1200 frames per) (IN WEAPON.WIL)
Example, Jmace in weapon.wil starts at 28800. 28800/1200=24. So shape=24.

Its the same for armours too, but you gotta remember to only look for the Male armour to get your shape, since each male/female armour only has 600 frames per, but the shape number for male is used for female also. (IN HUM.WIL)
BaseDress(M) goes from 1200-1799, and (F) from 1800-2399.
So 1200/1200=1 Shape=1
LightArmour(M) starts at 2400. so shape=2

I forget how to figure them for hum2.wil.

 

[Tom27]

yeah i already knew that way, im trying to figure out a faster way