I've got this running on my site, and i really like it. I have alot of people involved so when I go to the availability table, it stretches far to the right of the screen. Is it possible to flip the table the other direction so that the date is on the top and the peoples names are on the side?

I had to modify the users.php because it was failing to add a new person.

You need to change:

$query = "INSERT INTO ". $Personnel;
$query.= " (UID, Name, PhoneAdd, Email, Password, AuthLevel) ";
$query.= " Values ('','$newName','$newPhoneAdd','$newEmail','$cryptpass','$newAuth')";
$result = mysql_query($query);

to read:

$query = "INSERT INTO ". $Personnel;
$query.= " (Name, PhoneAdd, Email, Password, AuthLevel) ";
$query.= " Values ('$newName','$newPhoneAdd','$newEmail','$cryptpass','$newAuth')";
$result = mysql_query($query);

You have to remove the UID and the respective '' to get the auto increment feature to work.

Thank you for that observation. Version 1.17beta should fix this problem.

Aaron, I have run this uing xxamp on my pc but have now tried to run it on a host server with problems. I have created tables and dates for mysql as you instructions say with success. However I get to errors running this online with NXserve.net. This is what I get :-

Warning: require_once(class.WorshipPlanner?.php) function.require-once?: failed to open stream: No such file or directory in /home2/planner/public_html/header.php on line 6

Fatal error: require_once() function.require?: Failed opening required 'class.WorshipPlanner?.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/planner/public_html/header.php on line 6

I don't understand both files header and worshipplanner are in the directory with everything else?

Hope you can help

James

As we discussed over email, make sure your FTP client did not force all the filenames to lower case.

Aaron, thanks for making this tool. I'm having a problem with the chmod 777 permissions. My hosting provider won't allow me to do 777 permissions without paying for my own dedicated server. Is there any way around this?

Thanks for a wonderful tool. I have a large song base,is there a way of uploading multiple files, then using a listing script to automatically list them. I know a download script from the community that lists everything in a given directory. The there would be no need to name each song that is uploaded, but instead use the filename for both song name and download link. I can give you a link to my site if it make it any clearer

I got this error when running createtables.php

Creating table Availability...Create table failedCreating table Dates...Create table failedCreating table Personnel... Notice: Undefined variable: tvhnEHSKDq0p in C:\wamp\www\WPQR\createtables.php on line 42 Create table failedCreating table SchedDates?...Create table failedCreating table Sheetmusic...Create table failedCreating table SongDates?...Create table failedCreating table Songs...Create table failedCreating table SongLinks?...Create table failedCreating table WorshipTeam?...Create table failedCreating default user Admin...Creation of Admin user failed

still don't have any idea what's wrong