Remove # in front off channel.

[T-Xorcist]

Hi all,

I want to execute an MySQL query with the channelname in the query, like join.php?chan=$chan.

All sounds pretty neat, but MySQL / PHP does not support the # sign.
My question is, how do I remove the # in front of the channel to execute the MySQL query:

Example
-----------
Bot is in #T-Xorcist
The query will be join.php?chan=#T-Xorcist
The query MUST be join.php?chan=T-Xorcist

Can anyone help me out with this issue?

Thanks in advance.

[DragnLord]

here is how to strip the # off:

Code: Select all

regsub {#} $chan {} chan

[T-Xorcist]

I got this solution JUST find out:

Code: Select all

regsub -all "#" $chan "" channelname

Bad, not safe or?

[Alchera]

Code: Select all

regsub {#} $chan {} chan

Would be faster. It is neater also

[De Kus]

what about a simple [string trimleft $chan #] or [string map {# ""} $chan]? No need for any always slow regex.

Code: Select all

% time {set chan [string trimleft #channel.name #]} 100
2 microseconds per iteration
% time {set chan [string map {# ""} #channel.name]} 100
4 microseconds per iteration
% time {regsub {#} #channel.name {} chan} 100
7 microseconds per iteration

First might make troubles when using with opnotices which target is @#channel, but if you want to strip then @# anyway, you will have no trouble with it.

[Alchera]

.. and a whole 2 microseconds is going to be a total disaster? Good grief! DragnLord's solution is not only neater but cuts code length. I prefer neat and short code.

[Sir_Fz]

If you want it to still be neat but faster:

Code: Select all

regsub {^#} $chan {} chan

This will save time since it will check only the first character if it matches '#' instead of the whole string.

[DragnLord]

If you want it to still be neat but faster:

Code: Select all

regsub {^#} $chan {} chan

This will save time since it will check only the first character if it matches '#' instead of the whole string.

I would have thought so as well, until I ran the time tests.

Code: Select all

% time {regsub {#} #chan {} chan} 100
4.9 microseconds per iteration
% time {regsub {^#} #chan {} chan} 100
5.05 microseconds per iteration

Maybe those time tests aren't really that accurate.

[Alchera]

Maybe those time tests aren't really that accurate.

They depend entirely on the efficiency of the computer they are being tested on.

[DragnLord]

They depend entirely on the efficiency of the computer they are being tested on.

And I really can't see where microseconds will matter terribly (nor can I imagine a script where the exact same command is given in a procedure a hundred times in a row).

[Sir_Fz]

Well, on my pc {^#} was faster

% time {regsub {^#} #chan chan} 10000
3.0633 microseconds per iteration
% time {regsub {#} #chan chan} 10000
3.2233 microseconds per iteration
% time {regsub {^#} #chan chan}
27 microseconds per iteration
% time {regsub {#} #chan chan}
28 microseconds per iteration

But, it doesn't really matter, the difference isn't that big or near to big

Interrestingly, on 100 iterations {#} is faster:

% time {regsub {^#} #chan chan} 100
3.53 microseconds per iteration
% time {regsub {#} #chan chan} 100
3.37 microseconds per iteration

[T-Xorcist]

Thank you all for giving me so much choice of doing it LoL!

Thnx!