egghelp/eggheads community

Problem with mysql and wildcards

2005-12-20T00:02:15-04:00

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

Statistics: Posted by demond — Tue Dec 20, 2005 12:02 am

Problem with mysql and wildcards

2005-12-19T12:50:45-04:00

mysql use % as wildcard, not *

Statistics: Posted by greenbear — Mon Dec 19, 2005 12:50 pm

Problem with mysql and wildcards

2005-12-19T05:07:06-04:00

"[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

Statistics: Posted by S0nnY — Mon Dec 19, 2005 5:07 am

Problem with mysql and wildcards

2005-12-19T03:58:50-04:00

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]?

Statistics: Posted by demond — Mon Dec 19, 2005 3:58 am

Problem with mysql and wildcards

2005-12-19T03:05:35-04:00

Ok here is a split of the ignore check code

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

Code:

    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

Statistics: Posted by S0nnY — Mon Dec 19, 2005 3:05 am

Problem with mysql and wildcards

2005-12-19T02:29:11-04:00

post code & log

Statistics: Posted by demond — Mon Dec 19, 2005 2:29 am

Problem with mysql and wildcards

2005-12-19T00:43:00-04:00

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

Statistics: Posted by S0nnY — Mon Dec 19, 2005 12:43 am