Script Help

mirlin6 · Jun 23, 2008

I am making a script atm but i want to read something out of sql a username and then the script check it and it is ready for the next part
could anyone show me how this is done please im still a little unsure how sql works :S

mapadale · Jun 23, 2008

mirlin6 said:
I am making a script atm but i want to read something out of sql a username and then the script check it and it is ready for the next part
could anyone show me how this is done please im still a little unsure how sql works :S

<$USERNAME>

mirlin6 · Jun 23, 2008

Nope still doesent work i cant find the right comand to read sql and then check if the username is there

Heres what i have

[@Main]
#SAY
Hey {FCOLOR/2}<$USERNAME>{FCOLOR/0},
\
Have you voted? if you have you\
will be eligible for a reward\

< [Check for reward]/@Check>\

[@check]
#SAY
Please Wait a Second....\
#ACT
got @checking

[@checking]
#ACT
FormatStr "FLD_USERNAME='%s'" %USERNAME
ReadValueSql "TBL_VOTE" %A9 "FLD_USERNAME" - i want it to check if the username exist in the database and then goto the next stage

[@next1]
#SAY
We have found your Username!\
\
<[ Collect Junes Reward]/@Reward>\
\
#ELSESAY
Sorry we did not find your\
username!\

chimera · Jun 23, 2008

mirlin6 said:
Nope still doesent work i cant find the right comand to read sql and then check if the username is there

Heres what i have

[@Main]
#SAY
Hey {FCOLOR/2}<$USERNAME>{FCOLOR/0},
\
Have you voted? if you have you\
will be eligible for a reward\

< [Check for reward]/@Check>\

[@check]
#SAY
Please Wait a Second....\
#ACT
goto @checking

[@checking]
#ACT
FormatStr "FLD_USERNAME='%s'" %USERNAME
ReadValueSql "TBL_VOTE" %A9 "FLD_USERNAME" - i want it to check if the username exist in the database and then goto the next stage

This is just looking on tbl_vote for the username but I suggest you have a 3rd column being a yes/no column or add a column to the character table and interrogate that instead to see if the answer is yes/no 1/0 (whatever you choose to use).

What I would do - add a column to character_tbl called voted, values being 1 (voted) or 0 (not voted) and then

#ACT
FormatStr "FLD_USERNAME='%s'" %USERNAME
ReadValueSql "TBL_VOTE" %A9 "fld_voted" @votecheck

[@votecheck()]
#act
mov D1 %arg(1)

this will make the value in D1 = 0 or 1 which you can interrogate and use for the rest of the script.

[@next1]
#SAY
We have found your Username!\
\
<[ Collect Junes Reward]/@Reward>\
\
#ELSESAY
Sorry we did not find your\
username!\

Hope this helps

mirlin6 · Jun 23, 2008

would i need to do a check to see if the number is 1 or 0? like check D1 0 (not sure what the command is)

chimera · Jun 23, 2008

this will make the value in D1 = 0 or 1 which you can interrogate and use for the rest of the script.

so in other words you would do:

#IF
Equal D1 1
#SAY
We have found your Username!\\
<[ Collect Junes Reward]/@Reward>\\
#ELSESAY
Sorry we did not find your\\
username!\\

mirlin6 · Jun 23, 2008

thanks for the help chim

works great now

chimera · Jun 24, 2008

no problem

Amenovis · Jun 24, 2008

mhh i only ask me why never the ppl use flags ?? works same way and much easier

#if
something has done
#act
set [XXX] 0 or 1

and the other side check [XXX] 1

means

[@main]
#if
check [400] 1
#say
u had voted
#elsesay
Do u wanna vote?
<Yes/@flag1>\
<No/@flag2>\
<Exit/@exit>

[flag1]
#act
set [400] 1
#say
u have voted now!\
<Take/@take1> ur reward.

[@flag2]
#say
ok than maybe later\
<exit/@exit>

[@take1]
#act
give xyz
#say
good luck with it \
<exit/@exit>

or did i understand wrong what he wanna do ?

mirlin6 · Jun 24, 2008

what i want to do is reward people who vote for the server by doing this via the database i can add there name an they can get there reward each month.

chimera · Jun 24, 2008

It's possile with flags but it's a one-shot deal, with sql it's easier to change an entry and simpler to understand a script, imo

mirlin6 · Jun 24, 2008

Is there a way i can add a number to sql through a script chim?

so like verytime someone press it will add + 1 in the database and there will be 2 columbs like Yes \ No (example)

chimera · Jun 24, 2008

yup you read the accumulator column and call it a D number as above, then

inc D? 1

then

format your string with the same D number which has now increased by 1

followed by an
#act
updatevaluesql tbl_.... fld_.... string

not sure why you'd need 2 columns saying y/n...

mirlin6 · Jun 24, 2008

[@test1]
#ACT
INC D1 1
goto @test2

[@test2]
#ACT
UPDATEVALUESQL "TBL_VOTEHOST" "FLD_YES" %D1
goto @voteh

Like that? i tested but doesent seem to work :S

chimera · Jun 25, 2008

you forgot to format string....assuming your column you are storing number in is fld_yes...

#act
FormatStr "FLD_NAME='%s'" %USERNAME
MOV A1 %A9
FormatStr "FLD_YES='%s'" %D1
MOV A2 %A9
UPDATEVALUESQL "TBL_VOTEHOST" %A1 %A2

That looks in TBL_VOTED for the line that matches the username and makes the FLD_YES the new number.

mirlin6 · Jun 25, 2008

still doesent work for some reason :S heres my script on the script it adds +1 but not in sql theres nothing

[@voteh]
#IF
Check [401] 0
#SAY
Hello <$USERNAME>,\
I hold votes for the server\
\
Should i add more mob?\ - thats just an example
\
Yes: {FCOLOR/1}<$OUTPUT(D1)>{FCOLOR/12}\
\
No: {FCOLOR/1}<$OUTPUT(D2)>{FCOLOR/12}\
\
<[ Yes]/@Yes>\
\
<[ No]/@No>\
\
#IF
Check [401] 1
#SAY
You already voted\
\
Should i add more mobs?\
\
Yes: {FCOLOR/1}<$OUTPUT(D1)>{FCOLOR/12}\
\
No: {FCOLOR/1}<$OUTPUT(D2)>{FCOLOR/12}\
\

[@Yes]
#ACT
INC D1 1
SET [401] 1
FormatStr "FLD_USERNAME='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_YES='%s'" %D1
MOV A2 %A9
UPDATEVALUESQL "TBL_VOTEHOST" %A8 %A9
goto @voteh

[@No]
#ACT
INC D2 1
SET [401] 1
FormatStr "FLD_USERNAME='%s'" %USERNAME
MOV A1 %A9
FormatStr "FLD_NO='%s'" %D2
MOV A2 %A9
UPDATEVALUESQL "TBL_VOTEHOST" %A1 %A2
goto @voteh

chimera · Jun 25, 2008

mirlin6 said:
still doesent work for some reason :S heres my script on the script it adds +1 but not in sql theres nothing

[@voteh]
#IF
Check [401] 0
#SAY
Hello <$USERNAME>,\
I hold votes for the server\
\
Should i add more mob?\ - thats just an example
\
Yes: {FCOLOR/1}<$OUTPUT(D1)>{FCOLOR/12}\
\
No: {FCOLOR/1}<$OUTPUT(D2)>{FCOLOR/12}\
\
<[ Yes]/@Yes>\
\
<[ No]/@No>\
\
#ELSESAY
You already voted\
\
Should i add more mobs?\
\
Yes: {FCOLOR/1}<$OUTPUT(D1)>{FCOLOR/12}\
\
No: {FCOLOR/1}<$OUTPUT(D2)>{FCOLOR/12}\
\

[@Yes]
#ACT
INC D1 1
SET [401] 1
FormatStr "FLD_USERNAME='%s'" %USERNAME
Mov A8 %A9
FormatStr "FLD_YES='%s'" %D1
MOV A2 %A9
UPDATEVALUESQL "TBL_VOTEHOST" %A8 %A2
goto @voteh

[@No]
#ACT
INC D2 1
SET [401] 1
FormatStr "FLD_USERNAME='%s'" %USERNAME
MOV A1 %A9
FormatStr "FLD_NO='%s'" %D2
MOV A2 %A9
UPDATEVALUESQL "TBL_VOTEHOST" %A1 %A2
goto @voteh

see above for changes...
The way you've had it set up people could vote for oth yes and no.

mirlin6 · Jul 13, 2008

How can i stop people taking out 2 pets in a script?

mapadale · Jul 13, 2008

mirlin6 said:
How can i stop people taking out 2 pets in a script?

Add flags...

Geordiehc · Jul 13, 2008

mirlin6 said:
How can i stop people taking out 2 pets in a script?

#IF
CHECKMONRECALL 1
#SAY
You already have a pet\

Script Help

Golden Oldie

mapadale

Guest

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

mapadale

Guest

Mad Dog Geo