robecks
Beginner
Joined: 22 Jun 2010
Posts: 17
|
 Posted: Thu Jul 15, 2010 12:44 am
trigger help
|
my fault i set my mysql db to the wrong thing
i have this trigger set up to capture the name of a mob from a skill on my mud
| Code: |
<trigger priority="1" id="75">
<pattern>Mob Short Name : (*)</pattern>
<value>#local $mobname
mob_short_name=%1
$mobname = %1
#VAR dbconn %comcreate( "ADODB.Connection")
#CALL @dbconn.open("taomob")
#IF (@dbconn.ConnectionString ="") {
#SHOW "could not open connection to database"
#ABORT
}
#VARIABLE dbrs @dbconn.Execute("INSERT INTO mobs (mob_short_name) VALUES ("'$mobname'")")
dbrs=""
dbconn=""</value>
</trigger>
|
when it gets to the value it puts in 0 and i cant seem to figure out why, maybe someone can shed some light on this for me
ps. i have tried for the value using "'%1'" and just ended up trying with the local same thing no matter what |
|
