Testing...

Testing account...

rewew

[Zachery]

NoOneTMC and Ergenekon,

You are both currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (vB-germany users click here) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

Thank you.

[Xenon]

testing something:

[sql]SELECT SUBSTRING('abcabcabcabc[pic]XXXX[/pic]abcabcabcabc', LOCATE('[pic]', 'abcabcabcabc[pic]XXXX[/pic]abcabcabcabc') + 5, LOCATE('[/pic]', 'abcabcabcabc[pic]XXXX[/pic]abcabcabcabc') - LOCATE('[pic]', 'abcabcabcabc[pic]XXXX[/pic]abcabcabcabc') -5) AS pic[/sql]

[Andreas]

This query looks familiar ^.^

[Xenon]

yeah i saw you posting with it's sql tag comment, that's why i tested your query ^^

[Xenon]

Test2:

[sql]SELECT MD5('abcabcabcabc[pic]XXXX[/pic]abcabcabcabc')[/sql]

[sql]SELECT MD5( 'abcabcabcabc[pic]XXXX[/pic]abcabcabcabc' )[/sql]

[sql]SELECT MD5('abcabcabcabc<pic]XXXX</pic]abcabcabcabc')[/sql]

[Xenon]

fixed ^^