walkden-high

Thanks for your replies guys, I have managed to do it now just by using a java script and a little modification in edit_entry.php with the drop down menu coding.

Thanks for your replies guys I appreciate it, So far I have managed to force the error please select your department by using a jquery script, but unfortunately I can only get it to work with a seperate save button. I some how have to figure out how to link my script with the original save button. Thanks

Hi all I was wondering if somebody could help me with a bit of code, we are currently using mrbs and I have a bit of an issue with it at the moment when staff book a room they are not selecting there department and just leave it as default, the default entry is A in a list array which I have set to please select your department. what I want to do is to force the them to select any entry apart from default by throwing up an error if not selected I have managed to get as far as getting the error on screen but I unable to link it with the entry type. please see attached jpegs Modification 1 I have made in edit_entry.php <?php if ($type2 == "$c")?> { alert ( "<?php echo get_vocab("you_have_not_selected") . '\n' . get_vocab("your_department") ?>"); return false; } Modification 2 I have made in edit_entry.php <?php echo get_vocab("type")?>: <?php for ($c = "A"; $c <= "A"; $c++) { if (!empty($typel2[$c])) { echo " $typel2[$c]\n"; } } for ($c = "B"; $c <= "Z"; $c++) { if (!empty($typel[$c])) { echo " $typel[$c]\n"; } } ?> Modification 2 I have made in config.inc.php $typel2["A"] = "Please Select your Department"; $typel["B"] = "Admin"; $typel["C"] = "Art"; $typel["D"] = "Careers"; $typel["E"] = "Child Development"; $typel["F"] = "Citizenship&RE"; $typel["G"] = "Diploma"; $typel["H"] = "Drama"; $typel["I"] = "English"; $typel["J"] = "Geography"; $typel["K"] = "History"; $typel["L"] = "ICT&Business Studies"; $typel["M"] = "ICT-Support"; $typel["N"] = "Maths"; $typel["O"] = "Media"; $typel["P"] = "MFL"; $typel["Q"] = "Music"; $typel["R"] = "PE&Dance"; $typel["S"] = "Science"; $typel["T"] = "SEN"; $typel["U"] = "SLT"; $typel["V"] = "Technology"; $typel["W"] = "All Staff"; Has any body had any similar issues or know where I am going wrong with my coding. Thanks J

Hi Guys Does anyone no if there is a way of setting mrbs to email you to remind you that you have a booked a room an hour before the slot or period. Any help or ideas will be appreciated. J

I hace reinstalled the app a few times now so I think I might try a newer version of PHP. what version are you using? I have got 5.2.4.

No Nothing happens it should write them to the database and also show them up in the main page like in the link below. http://sourceforge.net/dbimage.php?id=236714

It writes to the database and then the script uses the information stored in the database to check that a website is running.

Hi Guys I have recently installed PHP Server Monitor from sourceforge and was wondering wether there are any users on here that may be able to help, i have set it up and created the tables in the database and can access it my browser but everytime i try and add a server nothing happens. I know it is talking to the database because it lets me add users and the information is logged in the database but i get no error it just says server has been added, please see attached doc. I am currently testing this on my xp machine with apache mysql php5 and I have enabled Curl Any help or info will be greatly appreciated. PHP Server Monitor | Get PHP Server Monitor at SourceForge.net PHPservmon.doc

Hi Ben The only way we could fix the problem was to delete the users local profile, what operating system are yopu using?

Hi kearton I put the serif website for unlocking the video's in our our smoothwalls allowed list but the pupils still kept getting the error. The only way I have managed to solve the problem is to delete the users local profile. When a user opens serif for the very first time it creates a proxy.dat file in the following location C:\Documents and Settings\grahamj\Application Data\Serif\MoviePlus\6.0 that you cannot edit we deleted it from one machine but we still had the problem, Serif also creates a reg key somewhere the users registry that also references to the proxy settings. We had switched Internet provider recently so our default gateway had changed so Serif had the wrong proxy settings and wasn't allowing users to get out on the web. It was a bit of pain really but we have managed to find a working solution.

Hi Guys We are currently experiencing a problem with users trying to get on our school website and our room booking system staff can get out on the internet and go on google etc but not anything that has walkden in the address. For example the two links below work fine when staff are at home but as soon as they are in school they get a page cannot be displayed error. Home / Salford - Manchester - Walkden High School Resource Booking System We use smoothwall for our filtering system and as far as we are aware no one has changed any settings its a complete mystery and it only started happening on monday we tried to get on our website on one machine and got the error page cannot be displayed, smoothwall said it went to a completly different website as if its being hijacked we can't even ping the address. has any one had any similar problems like this before or any idea of what is happening, any help or feed back is greatly appreciated. Thanks Justin

I moved our Sophos setup to a new server and followed these steps which Sophos support sent to me. 1.Close Enterprise Console. 2.Export the registry key HKLM\SOFTWARE\sophos\CertificationManager to a file called SophosCertificates.reg, and back this up. 3.Stop the service 'Sophos Management Service'. (This should close the management service connection to the database, this may take a couple of seconds). 4.Detach the database 'Sophos' using SQL Enterprise Manager, where possible. (See below if you need to use osql instead.) 5.Backup the files: C:\program files\microsoft sql server\mssql$sophos\data\sophos.mdf (do If this was an Upgrade from Enterprise Console 1.0 at one point) C:\program files\microsoft sql server\mssql$sophos\data\sophos_log.ldf (do If this was an Upgrade from Enterprise Console 1.0 at one point) C:\program files\microsoft sql server\mssql$sophos\data\SOPHOS2.mdf (do If this was an Upgrade from Enterprise Console 2.0 at one point) C:\program files\microsoft sql server\mssql$sophos\data\SOPHOS2_log.LDF (do If this was an Upgrade from Enterprise Console 2.0 at one point) C:\program files\microsoft sql server\mssql$sophos\data\SOPHOS3.mdf C:\program files\microsoft sql server\mssql$sophos\data\SOPHOS3_log.LDF 6.Re-attach the database ‘Sophos’ to continue using it using SQL Enterprise Manager, where possible. (See below if you need to use osql instead.) 7.Export the EM Library config by issuing the EMLExp.exe command: {This command is in C:\Program Files\Sophos Enterprise Manager\Library\bin} "emlexp export "\\\sophosem" c:\emlexp.xml" 8.Restart 'Sophos Management Service' 9.Shut down the old server and over on the new server assuming you kept the same Name and IP, you will want to import the registry key you exported in Step 2 10.Download the lastest version of Enterprise Console from the Sophos website (currently 3.0 in a file named ES30SFX.EXE) and do a complete install (very important that the registry key be imported BEFORE you do this install). *** I actually used 3.1 *** 11.Stop the service 'Sophos Management Service'. (This should close the management service connection to the database, this may take a couple of seconds). 12. Once the complete install is done, detach the empty database that got created following the detach database instructions below and then move the database files you backed up in step 5 into the C:\program files\microsoft sql server\mssql$sophos\data\ directory 13.Re-attach the database ‘Sophos’ to continue using it using SQL Enterprise Manager, where possible. (See below if you need to use osql instead.) 14.Import the EM Library config by issuing the EMLExp.exe command: {This command is in C:\Program Files\Sophos Enterprise Manager\Library\bin} "emlexp import "\\\sophosem" c:\emlexp.xml" 15.Restart 'Sophos Management Service' All of this worked until step 15 as the service will not start. Clients are updating and the server is pulling down updates but the Management console will not work as the service is stopped. Sophos are now ignoring my emails. Brilliant!

Hi all A pupil in one of ICT suites was having problems with serif movieplus x3 today when she clicked on a saved project it through up an error saying that the video is locked then tries to connect to the internet do download the correct codec which I think is an mpeg4 then fails. I installed cole2k on the image for that room last year and never had any problems untill now because we now give the pupils the option of movie maker and serif, alot of the pupils are opting for the serif because its something new to them and I need a quick fix does anyone have ideas? I think its a permissions thing myself and I would imagine I need to edit the registry on each machine but I am not to sure where to start. I have attached screen shots of the error and would appreciate any thaughts. Thanks Justin Movieplus x3 error.doc

Hi J17 Sparky I never managed to get the script to work for me neither I do have a method of block booking rooms for up to 8 weeks if you are interested, I have attached 2 spreadsheets that uses a formula to put the correct time stamp in the periods once you have selected the date eg 05/01/10 the first day of term in Jan. You will have edit the formula in B-4 to match your periods it is currently setup to find the time stamp for our 5 periods then all you do is fill fill in the fields that are in yellow. our periods below before school period 1 period 2 break period 3 period 4 lunch period 5 after school once I have my spreadsheet filled in correctly I then save it as a tab delimited txt file then import in to mrbs_entry with php myadmin straight in to the database. unix time stamp finder UNIX Timestamp To Standard Time Calculator Hope this can help, let me know if you have any problems Justin Room Booking Template 8 Weeks-Summertime.xls Room Booking Template 8 Weeks-Winter.xls

Hi all Does anyone now how I can modify the automated email from mrbs I want to put a space between each field so it makes it easier to read rather than being all clunked together, I know it gets the info from functions_mail.inc but every time I try and modify it mrbs crashes. This is how I would like it to look This is an automated email to confirm your booking of the following room: Resource Booking System * Brief Description: test Description: Room: Meeting Spaces - Meeting Room Start Time: Before School, Saturday 14 November 2009 * Duration: 1 periods End Time: Before School, Saturday 14 November 2009 * Department: Admin Created By: grahamj Last Updated: 13:24:43 - Saturday 14 November 2009 Repeat Type: None Any help is always appreciated

Sounds like it may be a dodgy HDD, I have seen something like that before but I was using symantec ghost try running spinrite to see if there is any bad sectors on the disc. SpinRite v6 - hard disk recovery utility review

Hi Karldenton When you installed php did you install the Ldap extension during setup I had problems when I first started and thats what was letting me down. Here is my config hope this can be any help to you. // 'auth_ldap' configuration settings // Where is the LDAP server $ldap_host = "lh-whs-email.walkden.local"; // If you have a non-standard LDAP port, you can define it here $ldap_port = 389; // If you do not want to use LDAP v3, change the following to false $ldap_v3 = true; // If you want to use TLS, change the following to true $ldap_tls = false; // LDAP base distinguish name // See AUTHENTICATION for details of how check against multiple base dn's $ldap_base_dn = "ou=users,ou=walkden,dc=walkden,dc=local"; // Attribute within the base dn that contains the username $ldap_user_attrib = "sAMAccountName"; // If you need to search the directory to find the user's DN to bind // with, set the following to the attribute that holds the user's // "username". In Microsoft AD directories this is "sAMAccountName" $ldap_dn_search_attrib = "sAMAccountName"; // If you need to bind as a particular user to do the search described // above, specify the DN and password in the variables below $ldap_dn_search_dn = "cn=search, ou=ldap,ou=users,ou=walkden,dc=walkden,dc=local"; $ldap_dn_search_password = "*****";

Hi there Has anyone got an example of what the script should look like for importing in to edit_enty_handler.php everytime I fill in the form and press go nothing happens it just says results with a white screen. Below is what I have so far as a test for one period every monday I have saved it as rm10.csv ('ROOM10','MON:07','1','11E','SDW','EN4','I','0');

Thanks for your feedback Simon what you have done so far looks good, you have obviously put a lot of time and effort in to it.

Hi all I am trying to book periods into rooms with an SQL script into mrbs_entry for several different rooms for each term, so far I have managed to create scripts for each room that books the periods for the rooms for a whole week and that works great. The problem I am having is that when I created the script for repeating the bookings into mrbs_repeat is that the script inserts ok and shows up in the query browser in the mrbs_repeat but it does not populate the rooms on the web interface. I know that when you do repeat a booking on the web interface it makes two entries into the database one for mrbs_repeat and then in the mrbs_entry it creates entries depending on how many weeks you I have booked ahead. So my question is really, has any one managed to figure out how to to create repeat bookings with a script that will work. My setup is on a windows server 2003 I am not sure whether it will make any difference? Thanks J

It was my php set up that was stoppping mine from working I hadn't enabled the ldap extension in the php installation, I was kicking myself when it dawned on me that's what it was lol.. Just go in to add and remove programs and modify the php set up and make sure you add the extension for ldap. This link may help if that doesn't do the trick for you. Anonymous LDAP operations in Windows 2003 AD You can download the support tools kit here http://www.microsoft.com/downloads/details.aspx?FamilyId=6EC50B78-8BE1-4E81-B3BE-4E7AC4F0912D&displaylang=en Justin

I have made the changes to the language and functions files and it worked a treat Thanks for your help Simon

Yeah what you have shown me looks like what I would have to do are the tags in the mrbs.css style sheet I don't recall seeing anything like that. I have already changed type in the lang file to department and I can't believe I didn't see where I would of changed mrbs to $vocab["mrbs"] = " Dog Booking System"; bloody hell. Thanks for your help notsofast you are a star..

I think it would probably be in the mrbs.css style sheet but can't seem to find where I would change the setting so to speak. Thanks for your reply f21970

Hi I have set up mrbs recently on a server 2003 test bed, my test link is here http://84.19.35.82:1234 I was wondering whether any knows how to span the types array across the screen in to 10 rather rows of 5 so i will have my departments in to 2 rows spanned across the screen. Does any one know how to change the name as well, I want to get rid of the word meeting at the top left and just have room booking system. Can any one help Thanks in advance