egghelp/eggheads community

SELECT 2 args instead of 1

2007-05-06T08:11:07-04:00

If you want to make sure that the 2 args exist before continuing, use this instead:

Code:

if {[scan $arg {%s %s} arg1 arg2]!=2} {return 0}# continue with $arg1 and $arg2

Statistics: Posted by Sir_Fz — Sun May 06, 2007 8:11 am

SELECT 2 args instead of 1

2007-05-06T07:23:25-04:00

Wow, really easy, thank you Sir

Statistics: Posted by Psyfire — Sun May 06, 2007 7:23 am

SELECT 2 args instead of 1

2007-05-04T13:15:43-04:00

Ok, so your problem is in getting arg1 and arg2? well if it's a pub bind then all you need is to add

Code:

foreach {arg1 arg2} [split $arg] {break}

after the 'global' line.

Statistics: Posted by Sir_Fz — Fri May 04, 2007 1:15 pm

SELECT 2 args instead of 1

2007-05-04T12:59:36-04:00

Hello,

this is my code:

Code:

proc amxx:db:info {nick host hand chan arg} {global sqlset sql(handle) [mysqlconnect -host $sql(host7) -user $sql(user7) -password $sql(pass7) -db $sql(db7)]set sma(qry) [mysqlsel $sql(handle) "SELECT blafield,blafield2 FROM blatable WHERE bla1 = '$arg1' AND bla2 = '$arg2'" -flatlist]mysqlclose $sql(handle)if {$sma(qry) != ""} {set gelesen(blafield) [lindex $sma(qry) 0]set gelesen(blafield2) [lindex $sma(qry) 1]putserv "PRIVMSG $chan :»» PlayerID: $gelesen(blafield) and $gelesen(blafield2)"}

I want there to select 2 args. Its like I write this into the channel:

Psyfire: !get arg1 arg2
Bot: Arg1=Test and Arg2=Bla

What do I have to modify, to search 2 args and output them correctly?

Statistics: Posted by Psyfire — Fri May 04, 2007 12:59 pm