egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2002-11-16T16:10:41-04:00 https://forum.eggheads.org/app.php/feed/topic/3028 2002-11-16T16:10:41-04:00 2002-11-16T16:10:41-04:00 https://forum.eggheads.org/viewtopic.php?p=13245#p13245 <![CDATA[Help with mysql syntax]]>
Also, use { } instead of " " so that you don't have to escape chars like $ and [.

Finally, it would help if you said what the syntax error actually is?

Statistics: Posted by stdragon — Sat Nov 16, 2002 4:10 pm

]]> 2002-11-16T08:08:02-04:00 2002-11-16T08:08:02-04:00 https://forum.eggheads.org/viewtopic.php?p=13227#p13227 <![CDATA[Help with mysql syntax]]> Im trying to run infobot.tcl by eruptor but since his installation of tables doesnt work i have built them myself but no comes the hard part.
There is something wrong with some of the syntax cause i cant add it to mysql.

Code: 

sql "insert into field_api VALUES('affils','insert','if {!\[regexp {\[02468\]} \[string index \[llength \[list %vars%\]\] \[expr \[llength \[list %vars%\]\] - 1\]\]\]} { set return -1 }','Groupnames must all have hq postitions paired with them.')"  sql "insert into field_api VALUES('affils','view','set count 0 \; while {\$count<\[llength \[list %vars%\]\]} { append return \[lindex \[list %vars%\] \$count\](\[lindex \[list %vars%\] \[expr \$count + 1\]\]) \; incr count 2 }','')"
Ive even tried to deleate all the \ infron of everything but icant make mysql to accept this code..

Any ideas?

Statistics: Posted by Guest — Sat Nov 16, 2002 8:08 am

]]>