User avatar
zag
Site Admin
Site Admin
Posts: 1114
Joined: Wed Jun 06, 2012 9:19 am
Country: United Kingdom

Re: Matching album names containing invalid file path characters

Thu Mar 16, 2017 3:46 pm

I would like to test this before rolling it out fully to the new strAlbumStripped field.

Hows this for a example set of 500 albums:

http://www.theaudiodb.com/blank.php

currently removing these characters:

Code: Select all

array('!', '@', '#','$', '%', '^','&', '*', '(',')', '_', '-','+', '\'', '[',']','{','}',';',':','"','<','>','|');

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Sun Mar 26, 2017 12:05 pm

Just got back from abroad, I'll have some code ready for testing in a few days.

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Sun Mar 26, 2017 12:28 pm

How do I perform the actual search? Adding "&i=1" or something else?

User avatar
zag
Site Admin
Site Admin
Posts: 1114
Joined: Wed Jun 06, 2012 9:19 am
Country: United Kingdom

Re: Matching album names containing invalid file path characters

Tue Mar 28, 2017 8:17 am

You don't yet ;)

I was just checking the character removal is OK with you before I actually add it to a new database field.

Are the above examples what you want?

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Tue Mar 28, 2017 12:14 pm

Ah... :)

As far as I can tell, these characters missing :
1. "="
2. "~"
3. "?"
4. ","
5. "."
6. "`" (not " ' " which you already included)

User avatar
zag
Site Admin
Site Admin
Posts: 1114
Joined: Wed Jun 06, 2012 9:19 am
Country: United Kingdom

Re: Matching album names containing invalid file path characters

Thu Mar 30, 2017 2:10 pm

Problem with some of those is they really effect album names

Example

Deadmau5 - 4×4=12

Turns into:

Deadmau5 - 4412

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Thu Mar 30, 2017 6:12 pm

That's actually ok as the client (the player) will be stripping the same characters prior to querying the DB, from the user's point of view it will be transparent as they don't see the stripped strings.

And btw, the "×" isn't listed as one of the chars.

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Sun Apr 09, 2017 7:27 am

Has there been any progress on this front?

User avatar
zag
Site Admin
Site Admin
Posts: 1114
Joined: Wed Jun 06, 2012 9:19 am
Country: United Kingdom

Re: Matching album names containing invalid file path characters

Sun Apr 16, 2017 12:28 pm

Sorry I've been away snowboarding for a few weeks ;)

Will take a look next week.

bLight
Registered User
Registered User
Posts: 35
Joined: Wed Jan 11, 2017 2:42 pm

Re: Matching album names containing invalid file path characters

Mon Apr 24, 2017 12:15 pm

Any update?

Return to “Developers”