Steps i took to make zmud access iwuvaard

1st thing todo is to get mysql-connector-odbc-3.51.17-win32.zip
Next unzip the setup file and install it, just accept the deafults
Now goto Control Panel, Administrative Tools, Data Sources (ODBC)
Goto the "System DSN" tab and click Add...

On the "Login" tab, enter the following:

Data Source Name: iwuvaard
Description: iwuvaard remote connect
Server: iwuvaard.ipdaily.net
User: guest
Password: iwuvaard
Database: (will be a pause when you select) iwuvaard
Click ok, and close everthing back to zMud
Now in zMud, go into settings editor and create a new alias named ifind

Put the following into the command:

#VARIABLE conn %comcreate( "ADODB.Connection")
#CALL @conn.open("iwuvaard")
#IF (@conn.ConnectionString ="") {
  #SHOW "could not open connection to database"
  #ABORT
  }
#VARIABLE rs @conn.Execute("SELECT * FROM iwuvaard.equipment WHERE %-1 ORDER BY equip_id ASC")
#SHOW {}
#SHOW {%ansi(white)Finding:%ansi(default) %proper(%-1) on iwuvaard}
#SHOW {----------------------------------------}
#IF (not @rs.BOF or not @rs.EOF) {
  #CALL @rs.MoveFirst
  Num_Records = 0
  #WHILE (not @rs.eof) {
    #MATH Num_Records @Num_Records+1
    #SHOW %ansi( white)Name:%ansi( default) @rs("name") %ansi( white)Type:%ansi( default) @rs("type")
    #SHOW %ansi( white)Keywords:%ansi( default) @rs("keywords")
    #SHOW %ansi( white)Area name:%ansi( default) @rs("area_name")
    #SHOW %ansi( white)Location:%ansi( default) @rs("location")
    #IF (@rs("flags") = "") {#SHOW %ansi( white)Flags:%ansi( default) none} {#SHOW %ansi( white)Flags:%ansi( default) @rs("flags")}
    #SHOW %ansi( white)Wear:%ansi( default) @rs("wear")
    #SHOW %ansi( white)Weight:%ansi( default) @rs("weight") %ansi( white)Value:%ansi( default) @rs("value") %ansi( white)Level:%ansi( default) @rs("level")
    #IF (@rs("avg_ac") != "") {#SHOW %ansi( white)Average AC:%ansi( default) @rs("avg_ac")}
    #IF (@rs("weapon_type") != "") {
      #SHOW %ansi( white)Weapon type:%ansi( default) @rs("weapon_type")
      #SHOW %ansi( white)Weapon flags:%ansi( default) @rs("weapon_flags")
      #SHOW %ansi( white)Damage:%ansi( default) @rs("damage")
      #SHOW %ansi( white)Average damage:%ansi( default) @rs("avg_damage")
      #SHOW %ansi( white)Damage type:%ansi( default) @rs("damage_type")
      }
    #SHOW %ansi( white)AC modifier:%ansi( default) @rs("ac_modifier")
    #IF (@rs("hr") !="0") {#SHOW %ansi( white)HR:%ansi( default) @rs("hr")}
    #IF (@rs("dr") !="0") {#SHOW %ansi( white)DR:%ansi( default) @rs("dr")}
    #IF (@rs("save") !="0") {#SHOW %ansi( white)Saves:%ansi( default) @rs("save")}
    #IF (@rs("intelligence") !="0") {#SHOW %ansi( white)INT:%ansi( default) @rs("intelligence")}
    #IF (@rs("wisdom") !="0") {#SHOW %ansi( white)WIS:%ansi( default) @rs("wisdom")}
    #IF (@rs("strength") !="0") {#SHOW %ansi( white)STR:%ansi( default) @rs("strength")}
    #IF (@rs("constitution") !="0") {#SHOW %ansi( white)CON:%ansi( default) @rs("constitution")}
    #IF (@rs("dexterity") !="0") {#SHOW %ansi( white)DEX:%ansi( default) @rs("dexterity")}
    #IF (@rs("luck") !="0") {#SHOW %ansi( white)LCK:%ansi( default) @rs("luck")}
    #IF (@rs("hp") !="0") {#SHOW %ansi( white)HP:%ansi( default) @rs("hp")}
    #IF (@rs("mana") !="0") {#SHOW %ansi( white)MA:%ansi( default) @rs("mana")}
    #IF (@rs("moves") !="0") {#SHOW %ansi( white)MV:%ansi( default) @rs("moves")}
    #IF (%len(@rs("extra_information")) > "1") {#SHOW %ansi( white)Extra info:%ansi( default) @rs("extra_information")}
    #SHOW {----------------------------------------}
    #CALL @rs.MoveNext
    }
  } {
  #SHOW {"                         "%ansi( white)No Matches%ansi( default)}
  Num_Records = 0
  }
#CALL @rs.Close
#CALL @conn.Close
conn = ""
rs = ""

save and close the editor

on the command line, enter "ifind strength = 1 AND level = 20"
You should see the following output:

Finding: Strength = 1 and level = 20 on iwuvaard
----------------------------------------
Name: Black Flowing Cape Type: armor
Keywords: black cape
Area name: Amusement Park
Location: vampire
Flags: 
Wear: body
Weight: 10 Value: 19 Level: 20
Average AC: 4
AC modifier: 0
STR: 1
DEX: 1
----------------------------------------
Name: Dragon's Ring Type: Treasure
Keywords: dragon ring
Area name: SIlver Volcano
Location: Dragon guard
Flags: 
Wear: finger
Weight: 4 Value: 0 Level: 20
Average AC: 0
AC modifier: 0
STR: 1
MA: 5
----------------------------------------
Name: dwarven gloves Type: Armor
Keywords: dwarven gloves
Area name: Dwarven Kingdom
Location: Reorx
Flags: 
Wear: hands
Weight: 2 Value: 20 Level: 20
Average AC: 6
AC modifier: 0
STR: 1
DEX: 1
----------------------------------------
Name: blind rage Type: Armor
Keywords: Blind Rage
Area name: Gallows Hill
Location: angry noble
Flags: none
Wear: eyes
Weight: 3 Value: 500 Level: 20
Average AC: 6
AC modifier: 0
HR: 2
DR: 2
STR: 1
----------------------------------------
Name: Dagger of Binding Type: Weapon
Keywords: Dagger of Binding
Area name: Gallows Hill
Location: priest
Flags: none
Wear: wield
Weight: 1 Value: 150 Level: 20
Average AC: 0
Weapon type: 
Weapon flags: 
Damage: 4d7
Average damage: 16
Damage type: pierce
AC modifier: 0
HR: 1
DR: 1
STR: 1
----------------------------------------
Name: pair of silken wings Type: Armor
Keywords: silken wings
Area name: Grand City of Aylor
Location: buzzing sprite
Flags: 
Wear: back
Weight: 2 Value: 50 Level: 20
Average AC: 3
AC modifier: 0
STR: 1
LCK: 1
----------------------------------------

That's it, just learn how to form a MySQL querry string and your all set :)

Ozzy