Tbl_stditems prob

[NoLife999]

hi
thought i do a post to see if anyone can help me with a prob i have on the above table, well what it is, when i do a item in the list say like id number 600 and the end number is 599 i close down the table and reopen it and i seem to be missing the item i have just put in only to find its like in between say 345 and 346, so instead of me having to redo all the id numbers again, how do i set sql so it will add it to the end after the 599 etc like we used to do in dbcommander, btw i,m not a beginer at this, but you would think i am lol

 

[ρяєα¢нєя]

I think i understand what you mean, when you enter a new Item it doesn't appear at the bottom of your list the next time you open the table, but instead it's located somewhere else in the table?

If so i get this with quite a few tables. No big deal really, will still work, but it can make working on the tables hard as your never really sure what number your on, there is a solution though. :P

Open the table by right clicking on the table and selecting: Open Table->Query. Then where is says:

SELECT     *
FROM         [dbo].[TBL_STDITEMS]

...replace it with:

SELECT     *
FROM         TBL_STDITEMS
ORDER BY FLD_ID

...and run the query (Alt+x or the "!" run button).

That should put the table in order of index number. Hope that was what you were after. If not, oh well...

p

 

[NoLife999]

great preacher that worked a treat :0 how do i save it so when i open it up they are in order has it works to a point but does not save ? hey i also have another prob that needs solving if you can how do you add a-speed or take it away in sql also same for adding/removing luck

 

[Zen2]

Its either 255 or 254 = 1

/Zen2

 

[ρяєα¢нєя]

great preacher that worked a treat :0 how do i save it so when i open it up they are in order has it works to a point but does not save ?

Unfortuantly i don't think it will save, i have to run that little SQL Querry everytime i open my tables with the intention of adding new fields. You get used to it though :P

hey i also have another prob that needs solving if you can how do you add a-speed or take it away in sql also same for adding/removing luck

FLD_AC/FLD_ACMAX/FLD_MAC/FLD_MACMAX - Thoes are the fields you need to play around with. Unfortuantly it's different for each STD Mode.

For example, if you wanted to add A.Speed+2 to a Weapon (STD mode 5) you would need:

FLD_MACMAX = 12

...but for a A.Speed+2 Necklace (STD mode 20) for example you would need:

FLD_AC = 2

The same is true for luck, different fields/techniques for different STD modes. For any stat like Luck/A.Speed/etc, just play around with FLD_AC/FLD_ACMAX/FLD_MAC/FLD_MACMAX, you'll get what you want in the end :P

p

 

[jasper]

you should be able to set up the stditem db to have the id as the pimary key, open up sql, find the stditem table, right click it, and click design, this will open up a table showing the field headings, right click the row showing the FLD_ID, and then click set primary key. i think this works, perhaps someone can test

 

[ρяєα¢нєя]

you should be able to set up the stditem db to have the id as the pimary key, open up sql, find the stditem table, right click it, and click design, this will open up a table showing the field headings, right click the row showing the FLD_ID, and then click set primary key. i think this works, perhaps someone can test

That the first thing i tried :P But unfortuantly on the files i'm using it wount allow it for some reason. It might work on TD's though, good idea.

p

 

[NoLife999]

thanks jasper that sorted the prob i had ) has for the a-speed preacher i cant see its that has its a mirsword and has no stats but i do notice that in FLD_SLOWDOWN it has 256 which i think is why its showing it has a-speed of +2 on just need to have a go at the luck thing about adding unless anyone knows

 

[NoLife999]

actually preacher m8ty u was right about the aspepd etc just need info on the luck if pos thanks for all your help so far guys

 

[jasper]

Posted by Akuma elsewhere

FLD_STDMODE
0=Pots(hp etc)
1=Jerk (????)
2=BreadNEgg (???)
3 = Drugs/Potions
4 = Spell books
5 = one handed weapon
6 = 2 handed weapon
7 =
8 =
9 =
10 = Male armour
11 = Female armour
12 =
13 =
14 =
15 = Helmets
19 - 21 = necklace(each number will make u able to add diff stats eg mode 20 u can add agil where 19 and 21 u cannot)
22 - 23 = ring.(each number will make u able to add diff stats eg mode 22 u can add agil where 23 u cannot)
24 -26 = Bracelet. (each number will make u able to add diff stats eb mode 24 u can add agil where 25 and 26 u cannot)
30 = candle slot
31=bundles/scrolls/EasterEggs etc
32= not sure
36=Normal Items (Logs chestnuts)
37 = orbs and gems
38 = Sewing Goods/BoneHammer
40 = Meat/Chicken
41= Quest items (BloodSwordChip)
43 = Ores
44 = quest items
45= Stackable Items (Webs Bones Etc)
46 = Random Items (Healer Letter Gamble Chip)
47 = Gold Bar - Gold Chest
48= Dream Pouch
50= Random Items
62 = boots
63 = stones
64 = Belts


Reserved
12 = then the item is cursed. (cannot be taken off)



Revesrved = 16 then the item stats will change with the level of the item.

eg.

Itemname = level 20

itemname1 = level 30

itemname2 = level 40

the item will give the user the stats of itemname at level 20 and the stats of itemname1 at level 30 etc.



Revesrved = 32 then the item stats will change with the class of the player.

eg.

Itemname = in bag stats

itemname1 = warrior

itemname2 = wizzard

itemname3 - taoist

depend on which classes where the item, depends on what stats the play gets.



Armours:- pretty straight forward really. Not sure how to add mp and mp recovery at the same time, or luck.
ac=ac
amc=amc
dc=dc
sc=sc
mc=mc
source=luck
anicount=wings
MGAVOID =magic resistance
HPADD=hpadd
MPADD=mp add
EXPADD=exp add
SLOWDOWN=slow
TOX=poison
TOXAVOID=poison resistance

Weapons:- FLC_macmax = A speed. 1-10 = minus a speed, 11-20 + Plus a speed

eg

FLD_macmax = 2 would mean a speed -2

FLD_macmax = 12 would mea a speed + 2



FLD_slowdown = acc by the power of 256 eg

FLD_slowdown = 256 = acc +1

FLD_slowdown = 512 = acc +2

FLD_slowdown = 1024 = acc +4 etc



Items:-

Bracelets and necklaces

FLD_slowdown = acc by the power of 256 eg

FLD_slowdown = 256 = acc +1

FLD_slowdown = 512 = acc +2

FLD_slowdown = 1024 = acc +4 etc


FLD_TOX = Agil by the power of 256 eg

FLD_TOX = 256 = agil +1

FLD_TOX = 512 = agil +2

FLD_TOX = 1024 = agil +4 etc

Rings

FLD_TOX = a speed by the power of 256 eg

FLD_TOX = 256 = a speed +1

FLD_TOX = 512 = a speed +2

FLD_TOX = 1024 = a speed +4 etc

Necklaces
FLD_AC = A.speed plus
FLD_ACMAX =A.Speed minus
FLD_AMC = Cruse
FLD_ACMMAX = Luck
FLD_MGAAVOID = MR
FLD_EXPADD = not sure how this works
FLD_SLOWDOWN = Slow
FLD_TOX = PA
FLD_TOXAVOID = Page Ranking
FLD_TOX = PA

FLD_slowdown = acc by the power of 256 eg
FLD_slowdown = 256 = acc +1
FLD_slowdown = 512 = acc +2
FLD_slowdown = 1024 = acc +4 etc

FLD_TOX = Agil by the power of 256 eg
FLD_TOX = 256 = agil +1
FLD_TOX = 512 = agil +2
FLD_TOX = 1024 = agil +4 etc

To add both slow and acc and
to add both pa and agil you need to do the following.

1st add the acc
adding 256 or 512 etc in the Slowdown FLD
u then need to add the amount of slow you want to add to the 1st number so 256 + 1 = 257 which =
acc + 1 slow +1

 

[NoLife999]

ty for the info i already have searched for this info what i req is when you put on mir sword since it comes with its own stats when you equip it how do i add the =aspeed to it when its equipped not when its just in your bag. any help would be greatly recived ty

 

[jasper]

put the stats on items mirsword1(warrior), mirsword2(wizard) and mirsword3(tao).. not mirsword,,,,, is that what you mean?

 

[Dazz]

Can't remember which, I'll update post if I can find it, but you have to have a certain STD mode so when the item is in your bag it doesn't have stats until you put it on.

I think you have a certain STD mode and then name your item, Example MirSword like this.

Mirsword1 - DC 0-0 SC 0-0 MC 50-50
MirSword2 - DC 5-10 SC 25-50 MC 0-0
MirSword3 - DC 50-50 SC 0-0 MC 0-0

STD Mode - 32

Like shown in the other post before, if you want it like most mirswords change stat on different level

STD Mode - 16

MirSword1 - Level 20 stats
MirSword2 - Level 40 stats
MirSword3 - Level 60 stats

/Daz

 

[NoLife999]

all sorted ty for all your help to sort it i added a very simple 12 in the FLD_MACMAX colomn to the mirsword1, 2, 3 and i have left the mirsword which my mirsword now has +aspeed of +2 now when equipped so ty all for your help

 

[Dazz]

No problem bud

Always happy to help.