Problem with mysql and wildcards

[S0nnY]

Hello,

I have a small problem. I want to create an "global ignore function" for a game script.
All my code works fine but i want to add hosts in the database containing a wildcard "*!*@Test*.org" for example.
But when the bots connects to the database an gets the informations the check the user host the * isn't a wildcard anymore also "test!test@Test.users.quakenet.org" is not matched.

How can I convert the sign * back to a wildcard ?

greetz
S0nnY

[demond]

post code & log

[S0nnY]

Ok here is a split of the ignore check code

$host ==> examp@example.users.quakenet.org

Code: Select all

  
  set ign(hosts) "[hosts:get]" <== returns all added hosts in the database ("examp@*.org"  "*@test.users.quakenet.org" for example)
  foreach h0st $ign(hosts) {
    if {[string match -nocase "$h0st" $host]} {
      return 1
    } else {
      return 0
    }
  }


proc hosts:get { } {
  global ign
  set sqlhand [mysqlconnect -host $ign(ip) -user $ign(user) -password $ign(pass)]
  mysqluse $sqlhand $ign(tab)
  set return "[mysqlsel $sqlhand "SELECT host FROM $ign(ignoredb)" -list]"
  mysqlclose $sqlhand
  return $return
}

the * is not recognized as wildcard

[demond]

so what's the problem, you don't get *'s back from db? what did you put there and what did you get back using [hosts:get]?

[S0nnY]

"[hosts:get]" <== returns all added hosts in the database ("examp@*.org" "*@test.users.quakenet.org"

a * which is returned from the mysqdatabase is "marked" as "normal" sign and not as wildcard. this is my problem

[greenbear]

mysql use % as wildcard, not *

[demond]

what do you care about mySQL's interpretation of *? you don't have WHERE clause anyway

if *'s come back to you as you saved them, I fail to see the problem here