PHP script to list and correct errors in cue-points

[rogiermaas]

I've made a script that lists, identifies and optionally corrects errors in cue-points.
To install, extract the three files from the zip-archive to any directory on your webserver. The MySQL-server doesn't have to run on the same server, but the webserver needs to have access to the MySQL-server in order to work.

DISCLAIMER: This program is provided as-is, without ANY warranty. Please BACKUP your database before use.

I would like to hear any thoughts..

Have fun!

- Rogier

[attachment deleted by admin]

[Filip83]

Does it work?

[Jhonny]

Yes, test it.

Jh.

[Filip83]

This is how it looks like.

Is this right?

[attachment deleted by admin]

[ChristophePE22]

I also had this error
the appeal has the php form

Replace <? with <?php

Replace <? echo with <?php echo

[Jhonny]

No, it looks like.

Did the script changed a bit.

Jh.

Ps. edit the index.php file to connect to the database.

[attachment deleted by admin]

[Jhonny]

If there is a error you see fix this.
In this case, it deletes the intro
This is too small.

see the pic

jh.

[attachment deleted by admin]

[rogiermaas]

I also had this error
the appeal has the php form

Replace <? with <?php

Replace <? echo with <?php echo

I think that is due to the fact that you aren't running PHP5 or you run this on an IIS-server?
I run Linux CentOS with Apache, MySQL and PHP (LAMP).

- Rogier

[rogiermaas]

By the way,

How about you all comment your findings/errors here so I can modify the script. Thus avoiding having various versions where in version 'Jhonny 2' has the <php tags and version 'Mike 5' has listings for the newest tracks but not the <php tags?

- Rogier (working on a newer version as we speak)

[Pegbars]

I've made a script that lists, identifies and optionally corrects errors in cue-points.

That's great, Rogier!  What do you mean, though, by cue point errors?  Do you mean cues disappearing or errors in timing accuracy?  I don't think I've ever noticed cues becoming inaccurate in RDJ.  Not like they are with, for example, DirEttore (MixTime).

[rogiermaas]

That's great, Rogier!  What do you mean, though, by cue point errors?  Do you mean cues disappearing or errors in timing accuracy?  I don't think I've ever noticed cues becoming inaccurate in RDJ.  Not like they are with, for example, DirEttore (MixTime).

On our station, we have certain rules in regard to the timing of cuepoints. For instance, a track with an intro of less than 2 seconds is too short for a sweeper; a time between 'Start Next' and 'End' of more than 6 seconds is unwanted, because the current track would be audible through the newly started track.

To check tracks for these kinds of 'errors', I have made this script. 

- Rogier

[Jhonny]

- Rogier (working on a newer version as we speak)

Hi, Rogier is it posseble to select a column so you can turn it off like Hooks not everyone uses this option.

Jh.

[rogiermaas]

Working on it!

- Rogier

[rogiermaas]

Okay, here is the new script 

Version 1.2 Changes:

- Added possibility of disabling columns/checks
- Added possibility of reversing sort order (as to display latest added tracks first)
- Added separate configfile
- Some minor bug fixes

Have fun!

- Rogier

[attachment deleted by admin]

[Jhonny]

I Have fun. 

My question is what happens if I use fix?
Removed the settings or adjustments are made?

Made 2 pic. Standard and hooks of.

Jh.


[attachment deleted by admin]