km error

[GmKinG]

hi, I have a problem:

when I kill WTKeyMaker add +1 to my FLD_WoomaTaurus but...
when I kill ZTKeyMaker add +1 to my FLD_ZumaTaurus and delete the WoomaTaurus key

i have this:

Z010 [0] 0 [MonDie] WTKeyMaker * [MapQuest\wtkm] [@Main]
Z010 [0] 0 [MonDie] ZTKeyMaker * [MapQuest\ztkm] [@Main]

in wtkm.txt i have:

[@Main]
#IF
#ACT
FormatStr "FLD_nume='%s'" %USERNAME
ReadValueSql "TBL_keymaker" %A9 "FLD_nume,FLD_WoomaTaurus" @LoadKeys

[@LoadKeys()]
#ACT
Mov A1 %ARG(1)
Mov D1 %ARG(2)

#IF
#ACT
FormatStr "'%s',%s" %USERNAME 0
Mov A8 %A9
FormatStr "FLD_nume='%s'" %USERNAME
Mov A2 %A9
WriteValueSql "TBL_keymaker" %A2 "FLD_nume,FLD_WoomaTaurus" %A8
goto @GiveWTKey

#elseact
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_WoomaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 WoomaTaurus Key for killing the WTKeymaker"
break

[@GiveWTKey]
#act
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_WoomaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 WoomaTaurus Key for killing the WTKeymaker"
break

in ztkm.txt i have:

[@Main]
#IF
#ACT
FormatStr "FLD_nume='%s'" %USERNAME
ReadValueSql "TBL_keymaker" %A9 "FLD_nume,FLD_ZumaTaurus" @LoadKeys2

[@LoadKeys2()]
#ACT
Mov A1 %ARG(1)
Mov D1 %ARG(2)

#IF
#ACT
FormatStr "'%s',%s" %USERNAME 0
Mov A8 %A9
FormatStr "FLD_nume='%s'" %USERNAME
Mov A2 %A9
WriteValueSql "TBL_keymaker" %A2 "FLD_nume,FLD_ZumaTaurus" %A8
goto @GiveZTKey

#elseact
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_ZumaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 ZumaTaurus Key for killing ZTKeymaker"
break

[@GiveZTKey]
#act
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_ZumaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 ZumaTaurus Key for killing ZTKeymaker"
break

in sql i have this:



some one know the solution for my error? :/

 

[GmKinG]

someone can help?

 

[GmKinG]

Bump....

 

[jonathan508]

why u dont try using update... ?

 

[GmKinG]

can you make an example?

 

[jonathan508]

Sure for example this:
#act
INC D1 1
FormatStr "nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_WoomaTaurus='%s'" %D1
UPDATEVALUESQL "TBL_keymaker" %A8 %A9

 

[GmKinG]

Sure for example this:
#act
INC D1 1
FormatStr "nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_WoomaTaurus='%s'" %D1
UPDATEVALUESQL "TBL_keymaker" %A8 %A9

im using it, look in my script the #elseact
#elseact
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_ZumaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 ZumaTaurus Key for killing ZTKeymaker"
break

 

[kyeron]

#IF
[COLOR="red"]????????????[/COLOR]
#ACT
FormatStr "'%s',%s" %USERNAME 0
Mov A8 %A9
FormatStr "FLD_nume='%s'" %USERNAME
Mov A2 %A9
WriteValueSql "TBL_keymaker" %A2 "FLD_nume,FLD_ZumaTaurus" %A8
goto @GiveZTKey

#elseact
INC D1 1
FormatStr "FLD_nume='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_ZumaTaurus='%s'" %D1
UpdateValueSql "TBL_keymaker" %A8 %A9
SysMsg "You received 1 ZumaTaurus Key for killing ZTKeymaker"
break

the elseact works when the "if" its false , u dont have any "if" there anymore

 

[GmKinG]

the elseact works when the "if" its false , u dont have any "if" there anymore

i delete the IF but my problem continues

when I kill WTKeyMaker add +1 to my FLD_WoomaTaurus but...
when I kill ZTKeyMaker add +1 to my FLD_ZumaTaurus and delete the WoomaTaurus key

 

[GmKinG]

Bump.......

 

[GmKinG]

Nobody can help me?

 

[Josiko]

please,any can help gm king?

 

[Josiko]

i dont know but ...

UpdateValueSql "TBL_keymaker" %A8 %A9 <--- %A8?? later u writte A8 %A9...

look new u script

 

[GmEmperor]

i have working the script 2 weeks ago, but thanks josiko

 

[stigmas]

when I kill WTKeyMaker add +1 to my FLD_WoomaTaurus but...
when I kill ZTKeyMaker add +1 to my FLD_ZumaTaurus and delete the WoomaTaurus key

How did you fixed it ? I have this problem too.

thanks

 

[GmEmperor]

i fixed using search "keymakers" and i found one post with the script

 

[Josiko]

sorry but i dont use this system, gm hasekura can help u .. hasekura have keymaker's