UID to variable

[Raffis]

Hello, I tried UID to variable and I don't know what is wrong here. Somebody know maybe?

[@Main]
#ACT
mov D4 1 ;weapon UID
FormatStr "FLD_CHARACTER='%s',FLD_TYPE='%s'" %USERNAME %D4
ReadValueSql "TBL_ITEM" %A9 "FLD_MAKEINDEX" [@displayUID]

[@displayUID()]
#ACT
mov A1 %USERNAME
mov P1 %ARG(1)
#SAY
<$OUTPUT(A1)> UID your weapon is: <$OUTPUT(P1)>

 

[Axel]

I view this example:

FormatStr "FLD_CHARACTER='%s' AND FLD_TYPE='%s'" %A1 %D0
ReadValueSql "TBL_ITEM" %A9 "FLD_CHARACTER,FLD_TYPE,FLD_MAKEINDEX" [@function_1]

But dont work, have one syntax error.

Any expert for comment about it?

 

[Coly]

I view this example:

FormatStr "FLD_CHARACTER='%s' AND FLD_TYPE='%s'" %A1 %D0
ReadValueSql "TBL_ITEM" %A9 "FLD_CHARACTER,FLD_TYPE,FLD_MAKEINDEX" [@function_1]

But dont work, have one syntax error.

Any expert for comment about it?

Show me the point how you fill the A1 and D0 ...

 

[Coly]

Hello, I tried UID to variable and I don't know what is wrong here. Somebody know maybe?

[@Main]
#ACT
mov D4 1 ;weapon UID
FormatStr "FLD_CHARACTER='%s',FLD_TYPE='%s'" %USERNAME %D4
ReadValueSql "TBL_ITEM" %A9 "FLD_MAKEINDEX" [@displayUID]
 
[@displayUID()]
#ACT
mov A1 %USERNAME
mov P1 %ARG(1)
#SAY
<$OUTPUT(A1)> UID your weapon is: <$OUTPUT(P1)>

FormatStr "FLD_CHARACTER='%s' and FLD_TYPE='%s'" %USERNAME %D4

 

[Axel]

Ok thanks Coly.

 

[Raffis]

Thank you Coly, now it act. I searching another commands to item can't be remove from eq to bag, but I found only it:
HLSCRIPTCMD ITEMREMAKEADD 8 9 1
It is for right ring.
Somebody have maybe all list for armor,weapon,bracelets,etc.?

EDIT:
I found more commands, but for helmet,armor,weapon and boots I didn't find. If somebody know what numbers should be, so answer me. I wrote simple script for can't/can remove item from eq.

[@main]
#SAY
What do you want?\
\
<I want remove my item./@remove(-1)>\
<I won't remove my item./@remove(1)>\
<Exit./@exit>\\\

[@remove()]
#ACT
mov D1 %ARG(1)
#SAY
Choose item:\\
<Necklace./@remove1(3)>\
<Left bracelet./@remove1(5)>\
<Right bracelet./@remove1(6)>\
<Left ring./@remove1(7)>\
<Right ring./@remove1(8)>\
\
<Exit./@exit>\\\

[@remove1()]
#ACT
mov D2 %ARG(1)
HLSCRIPTCMD ITEMREMAKEADD %D2 9 %D1
#SAY
Done.\
<Exit./@exit>\\\

EDIT 2:
I found all numbers, thanks a lot...