Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:
Database error in vBulletin 3.6.4:
Invalid SQL:
update vB_mp3playlist set
id='10',
url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',
url_product_stream='true',
url_product_buffer='2',
mp3name='Van Halen - Ain't Talkin' 'bout Love',
approvemp3='1'
where id='10';
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',
approvemp3='1'
where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10
Some other things that I'd like to note that could use improvement are:
- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.
So far that's all I can think of at the moment.