Menu
▾
▴
webschool-commit — Mailing list that describe new commits to the webschool project
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(183) |
Dec
(82) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(16) |
Feb
(3) |
Mar
|
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Matt M. <pro...@us...> - 2005-04-22 00:53:45
|
Update of /cvsroot/webschool/webschool2/lib/smarty_dir In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1698/lib/smarty_dir Log Message: Directory /cvsroot/webschool/webschool2/lib/smarty_dir added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:51:48
|
Update of /cvsroot/webschool/webschool2/theme/blugold/templates In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv587/theme/blugold/templates Log Message: Directory /cvsroot/webschool/webschool2/theme/blugold/templates added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:51:43
|
Update of /cvsroot/webschool/webschool2/theme/blugold/images In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv378/theme/blugold/images Log Message: Directory /cvsroot/webschool/webschool2/theme/blugold/images added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:51:19
|
Update of /cvsroot/webschool/webschool2/theme/blugold In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32670/theme/blugold Log Message: Directory /cvsroot/webschool/webschool2/theme/blugold added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:45:03
|
Update of /cvsroot/webschool/webschool2 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28118 Added Files: common.php index.php Log Message: More Files --- NEW FILE: common.php --- --- NEW FILE: index.php --- |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:41:08
|
Update of /cvsroot/webschool/webschool2/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26439/lib Log Message: Directory /cvsroot/webschool/webschool2/lib added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:41:03
|
Update of /cvsroot/webschool/webschool2/theme In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26439/theme Log Message: Directory /cvsroot/webschool/webschool2/theme added to the repository |
|
From: Matt M. <pro...@us...> - 2005-04-22 00:41:03
|
Update of /cvsroot/webschool/webschool2/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26439/admin Log Message: Directory /cvsroot/webschool/webschool2/admin added to the repository |
|
From: jsvoyager <jsv...@us...> - 2005-02-05 02:15:41
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24467/install Modified Files: step2.php Log Message: New Smart Feature Index: step2.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step2.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** step2.php 19 Jan 2005 03:04:32 -0000 1.10 --- step2.php 5 Feb 2005 02:15:13 -0000 1.11 *************** *** 1,3 **** ! <? /* Webschool --- 1,3 ---- ! <?php /* Webschool |
|
From: jsvoyager <jsv...@us...> - 2005-02-05 02:15:41
|
Update of /cvsroot/webschool/webschool/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24467/lib Modified Files: mainfile.php Log Message: New Smart Feature Index: mainfile.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/mainfile.php,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** mainfile.php 30 Jan 2005 01:56:13 -0000 1.16 --- mainfile.php 5 Feb 2005 02:15:14 -0000 1.17 *************** *** 106,109 **** --- 106,145 ---- } + function brackets2table ($data, &$smarty){ + + if (preg_match_all('/\[(\[.*?\])\]/s', $data, $matches)) { + $count = count($matches[0]); + for ($i = 0; $i < $count; $i++) { + + $workstr = $matches[1][$i]; + $tmp = ''; + while ($tmp != $workstr) { + $tmp = $workstr; + $workstr = preg_replace('/\[(([^\|]*)\|)?([^\]]*)\]/s', '<td \2>\3</td>', $workstr, 1); + }/* + if ($i == 0){ + $replacement = "\n<table width=\"100%\" border=\"0\" noatr=\"find\">\n<tr>$workstr</tr>\n"; + }elseif ($i == $count){ + $replacement = "<tr>$workstr</tr>\n</table>"; + }else{ + $replacement = "<tr>$workstr</tr>\n"; + }*/ + //If the code above is ever re-emplemented, be sure to change the second arg below + // to $replacement + $data = preg_replace('/\[\[.*?\]\]/s', "<tr>$workstr</tr>\n", $data, 1); + + } + + $data = str_replace('[+', "\n<table width=\"100%\" border=\"0\" noatr=\"find\">\n", + $data); + $data = str_replace('+]', "\n</table>\n", + $data); + + + } + + return $data; + } + $smarty->register_outputfilter("brackets2table"); ?> \ No newline at end of file |
|
From: jsvoyager <jsv...@us...> - 2005-02-04 04:00:19
|
Update of /cvsroot/webschool/webschool/docs In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18090/docs Modified Files: index.html Log Message: A test to see if the list is working Index: index.html =================================================================== RCS file: /cvsroot/webschool/webschool/docs/index.html,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** index.html 16 Oct 2004 21:31:19 -0000 1.3 --- index.html 4 Feb 2005 04:00:10 -0000 1.4 *************** *** 2,5 **** --- 2,6 ---- PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> + <!--Not really up to date that much anymore. Please contact an admin for questions --> <html> <head> |
|
From: Andybebad <and...@us...> - 2005-01-16 19:22:01
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7422/install Modified Files: step4.php Log Message: Adde Email Address Form Index: step4.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step4.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** step4.php 16 Jan 2005 04:38:31 -0000 1.10 --- step4.php 16 Jan 2005 19:21:48 -0000 1.11 *************** *** 22,25 **** --- 22,26 ---- $content .= "<form action=\"install.php?step=4\" method=\"post\">"; $content .= "Administrator's Username: <input type=\"text\" size=\"15\" name=\"uid\" id=\"uid\" /><br />"; // robertsim007: Hey, choosing a username is a good thing, in my opinion. + $content .= "Email Address: <input type=\"text\" size=\"15\" name=\"uemail\" id=\"uemail\" /><br />"; //andybebad:And the email address too, eh? $content .= "Administrator's Password: <input type=\"password\" size=\"15\" name=\"pass\" id=\"pass\" /><br />"; $content .= "Retype the Password:<input type=\"password\" size=\"15\" name=\"rpass\" id=\"rpass\" /><br />"; *************** *** 31,35 **** $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET username='".$_POST['uid']."',password='".md5($_POST['pass'])."' WHERE id='2'"); header("Location: install.php?step=5"); } else { --- 32,36 ---- $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET username='".$_POST['uid']."',password='".md5($_POST['pass'])."', email='"$POST_['uemail']."' WHERE id='2'"); header("Location: install.php?step=5"); } else { |
|
From: jsvoyager <jsv...@us...> - 2005-01-16 04:38:44
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12719/install Modified Files: step4.php Log Message: Did we change the encryption or something??? Index: step4.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step4.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** step4.php 5 Jan 2005 03:28:42 -0000 1.9 --- step4.php 16 Jan 2005 04:38:31 -0000 1.10 *************** *** 31,35 **** $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET username='".$_POST['uid']."',password='".sha1($_POST['pass'])."' WHERE id='2'"); header("Location: install.php?step=5"); } else { --- 31,35 ---- $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET username='".$_POST['uid']."',password='".md5($_POST['pass'])."' WHERE id='2'"); header("Location: install.php?step=5"); } else { |
|
From: jsvoyager <jsv...@us...> - 2005-01-16 02:03:30
|
Update of /cvsroot/webschool/webschool/docs In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17119/docs Modified Files: roadmap.html Log Message: Roadmap Index: roadmap.html =================================================================== RCS file: /cvsroot/webschool/webschool/docs/roadmap.html,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** roadmap.html 4 Dec 2004 02:31:52 -0000 1.5 --- roadmap.html 16 Jan 2005 02:03:20 -0000 1.6 *************** *** 7,67 **** WebSchool RoadMap </title> </head> <body> <h1>WebSchool RoadMap</h1> <br /> ! Current Version: <b>0.0.5</b> <br /> <br /> ! <h3>Version 0.0.6</h3> <ul> ! <li>Wrap up the the Academia Amod and Mod: <b>jsvoyager</b></li> ! <li>Begin work on the Sports Amod and Mod</li> ! <li>Begin work on the Calander Amod and Mod</li> ! <li><strike>Wrap up development on News Amod and Mod</strike></li> ! <li><strike>Wrap up development on Articles Amod and Mod</strike></li> ! <li>Implement features in the menu such as trees</li> ! <li>Continue development of Newsletter Amod and Mod</li> </ul> ! Projected Finish: November 30, 2004 <br /> ! <h3>Version 0.0.7</h3> <ul> ! <li>Wrap up Pages aMod and Mod</li> ! <li>Wrap up SOTM aMod and Mod</li> ! <li>Wrap up pictures aMod and Mod</li> ! <li>Continue work on Sports</li> ! <li>Continue work on Calander</li> </ul> ! Projected Finish: December 6, 2004 <br /> ! <h3>Version 0.0.8 *MILESTONE*</h3> <ul> ! <li>Begin searching through files for unimplemented language features</li> ! <li>Submit pages for XHTML validation and correct errors</li> ! <li>Implement 'Find User' Feature</li> ! <li>Implement Pagination in News, Users, Articles, Pictures</li> ! <li><strike>Begin file.php, similar function to pic.php, except files</strike</li> ! <li>Wrap up Sports</li> ! <li>Wrap up Calander</li> </ul> ! Projected Finish: December 15, 2004 <br /> ! <h3>Version 0.0.9</h3> <ul> ! <li>Last chance sweep for SQL injection holes</li> ! <li>Upgrade ADODB and SMARTY to latest versions</li> ! <li>Test for problems resulting from new versions of ADODB and SMARTY</li> ! <li>Wrap up file.php</li> ! <li>Tie up lose ends</li> </ul> ! Pojected finish: December 22, 2004 <br /> ! <h3>Version 1.0.0 *PRODUCTION RELEASE*</h3> <ul> ! <li>Make nicer notices in installation</li> ! <li>Confirm database structure</li> ! <li>Wrap up any noticed bugs.</li> </ul> ! Projected Finish: January 1, 2004 <br /> <br /> --- 7,137 ---- WebSchool RoadMap </title> + <style> + <!-- + h1 { + font-family: arial, helvetica, sans-serif; + font-size: 18pt; + border-bottom: solid 2px #94C49B; + } + + h2 { + font-family: arial, helvetica, sans-serif; + font-size: 14pt; + font-weight: normal; + padding: 3px; + padding-left: 10px; + background-color: #94C49B; + } + + p.milestone { + font-family: arial, helvetica, sans-serif; + font-size: 12pt; + font-weight: bold; + padding: 5px; + padding-left: 25px; + background-color: #B4E4FF; + } + + p.versionless { + font-family: arial, helvetica, sans-serif; + font-size: 11pt; + font-style: italic; + + + background-color: #94C49B; + padding: 3px; + padding-left: 25px; + margin: 30px; + margin-left: 15px; + margin-right: 0px; + } + + + a { + color: #64946B; + text-decoration: none; + } + + a:hover { + text-decoration: underline; + } + --> + </style> + + <body </head> <body> <h1>WebSchool RoadMap</h1> <br /> ! Current Version: <b>0.0.6</b> <br /> <br /> ! ! <h2>Version 0.0.7</h2> <ul> ! <li>Implement tree features in the menu</li> ! <li>Wrap up Pages aMod and Mod</li> ! <li>Wrap up Student Of The Month (SOTM) aMod</li> ! <li>Wrap up Pictures aMod and Displayer (in Core)</li> ! <li>Continue work on Sports aMod and create Sports Mod. Finish Sports module pair.</li> ! <li>Continue work on Calander aMod and create Calendar Mod. Finish Calendar module pair.</li> ! <li>Make templates visually appealing.</li> </ul> ! <b>Projected Finish:</b> January 29, 2005 <br /> ! <p class="milestone">End Of Major Developement</p> ! ! <h2>Version 0.0.8</h2> <ul> ! <li>Search Various aMods/Mods for unimplemented language features</li> ! <li>Submit for HTML Validation. Correct Errors</li> ! <li>Implement "Fild User" Feature</li> ! <li>Implement Pagination on News, Users, Articles, Pictures, etc... aMods/Mods</li> ! <li>[Project Admins Only:] Develop Generic Test Scripts for Module Paires.</li> ! <li>[Project Admins Only:] Develop Test Script for Core/DB/Hacking-Attempt/SQL-Injection.</li> </ul> ! <b>Projected Finish:</b> February 9, 2005 <br /> ! <p class="milestone">End Of All Developement. CVS Tree Frozen, less Bug Corrections.</p> ! ! <p class="versionless"><b>February 14-18, 2005: </b> Announcements and Sign-Ups for Open Beta</p> ! ! <h2>Version 0.0.9</h2> <ul> ! <li>Verify Database Schema</li> ! <li>Upgrade ADODB and SMART Engines to Latest Versions. Ensure no Conflicts from Upgrade.</li> ! <li>Follow Generic Module Pair Script for each Module Pair. Fix Errors.</li> ! <li>Follow Core/DB/Hacking-Attempt/SQL-Injection Script. Fix Errors.</li> ! <li>Shadow End User. Fix Errors.</li> </ul> ! <b>Projected Finish:</b> February 18, 2005 <br /> ! ! <p class="versionless"><b>February 19, 2005: </b> Open Beta Released as Version 0.1.0</p> ! ! <h2>Version 0.1.0</h2> <ul> ! <li>Continue Private Testing. Fix Errors.</li> ! <li>Fix Beta-Submited Errors.</li> ! <li>Request Beta Testers' Database Dump. Merge All Together to Create Stress-Test.</li> </ul> ! <b>Projected Finish:</b> March 5, 2005 <br /> ! ! <h2>Version 0.3.0</h2> <ul> ! <li>Give Beta Testers New Version.</li> ! <li>Follow Generic Module Pair Script for each Module Pair. Fix Errors.</li> ! <li>Follow Core/DB/Hacking-Attempt/SQL-Injection Script. Fix Errors.</li> ! <li>Continue Private Testing. Fix Errors.</li> ! <li>Fix Beta-Submited Errors.</li> ! <li>Prepare for big 1.0.0!</li> </ul> ! <b>Projected Finish:</b> March 12, 2005 ! <br /> ! ! <p class="versionless"><b>March 13, 2005: </b> CVS Tree Completely Forzen. Tag All Files as "1.0.0". Create ! "1.2.0" and "1.0.*" Branches. Prepare release packages.</p> ! ! <p class="versionless"><b>March 15, 2005: </b> Debuit Version 1.0.0.</p> <br /> <br /> |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:13:55
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv600/mysql Modified Files: webschool.sql Log Message: Fixed Some Stuff and Started Calendar Mod Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.70 retrieving revision 1.71 diff -C2 -d -r1.70 -r1.71 *** webschool.sql 1 Jan 2005 00:28:09 -0000 1.70 --- webschool.sql 11 Jan 2005 00:13:42 -0000 1.71 *************** *** 63,67 **** `tree` int(5) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ! ) TYPE=MyISAM AUTO_INCREMENT=9 ; INSERT INTO `table_menu` VALUES (1, 0, '<[TEXT]>', 'Home', 'index.php', 0); --- 63,67 ---- `tree` int(5) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ! ) TYPE=MyISAM AUTO_INCREMENT=10 ; INSERT INTO `table_menu` VALUES (1, 0, '<[TEXT]>', 'Home', 'index.php', 0); *************** *** 72,77 **** INSERT INTO `table_menu` VALUES (6, 5, '<[TEXT]>', 'Pages', 'mod.php?mod=Pages', 0); INSERT INTO `table_menu` VALUES (7, 6, '<[TEXT]>', 'Newsletters', 'mod.php?mod=Newsletters', 0); ! INSERT INTO `table_menu` VALUES (8, 7, '<[SEPERATOR]>', '', '', ''); ! INSERT INTO `table_menu` VALUES (9, 8, '<[TEXT]>', 'Admin', 'admin.php', 0); DROP TABLE IF EXISTS `table_menu_trees`; --- 72,78 ---- INSERT INTO `table_menu` VALUES (6, 5, '<[TEXT]>', 'Pages', 'mod.php?mod=Pages', 0); INSERT INTO `table_menu` VALUES (7, 6, '<[TEXT]>', 'Newsletters', 'mod.php?mod=Newsletters', 0); ! INSERT INTO `table_menu` VALUES (8, 8, '<[SEPERATOR]>', '', '', ''); ! INSERT INTO `table_menu` VALUES (9, 9, '<[TEXT]>', 'Admin', 'admin.php', 0); ! INSERT INTO `table_menu` VALUES (10, 7, '<[TEXT]>', 'Calendar', 'mod.php?mod=Calendar', 0); DROP TABLE IF EXISTS `table_menu_trees`; *************** *** 114,118 **** PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; ! c INSERT INTO `table_pages` VALUES (1, 'WebSchool Installed Successfully!', 2, '', '<span>Congratulations, WebSchool has been installed successfully!</span><br /><br />Welcome to WebSchool version 0.0.6. Please note that this version of WebSchool is a <b>alpha</b> and is accordingly not designed for production environments.<br /><br />Limited documentation is available from the <a href="mod.php?mod=Articles&op=view&id=1"><span style="font-style: italic;">Introduction to WebSchool</span> </a>article. Further documentation is planed for our full release, but until then, fell free to visit our <a href="http://dev.bluemavid.net" title="WebSchool Forums">forums</a> for support. Please also note the following important information:<br /><ul><li>The username to get into the administration area is <span style="font-weight: bold;">Administrator</span> and the password is what you set it to in the setup. Please change this as soon as possible.</li><li>Limited documentation is available from the <a href="mod.php?mod=Articles&op=view&id=1"><span style="font-style: italic;">Introduction to WebSchool</span></a> article. This includes basic features and how to administer them.</li><li>The debug information below can be turned off by changing the "debug" option in the <a href="admin.php?amod=Config">Config</a> area of the <a href="admin.php">Admin Control Panel.</a><br /></li></ul><br />We hope you enjoy this beta release of WebSchool.<br /><br /><span style="font-family: arial,helvetica,sans-serif;">The WebSchool Development Team</span>', '1099153213', '1099153213', '0', 1, ''); --- 115,119 ---- PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; ! INSERT INTO `table_pages` VALUES (1, 'WebSchool Installed Successfully!', 2, '', '<span>Congratulations, WebSchool has been installed successfully!</span><br /><br />Welcome to WebSchool version 0.0.6. Please note that this version of WebSchool is a <b>alpha</b> and is accordingly not designed for production environments.<br /><br />Limited documentation is available from the <a href="mod.php?mod=Articles&op=view&id=1"><span style="font-style: italic;">Introduction to WebSchool</span> </a>article. Further documentation is planed for our full release, but until then, fell free to visit our <a href="http://dev.bluemavid.net" title="WebSchool Forums">forums</a> for support. Please also note the following important information:<br /><ul><li>The username to get into the administration area is <span style="font-weight: bold;">Administrator</span> and the password is what you set it to in the setup. Please change this as soon as possible.</li><li>Limited documentation is available from the <a href="mod.php?mod=Articles&op=view&id=1"><span style="font-style: italic;">Introduction to WebSchool</span></a> article. This includes basic features and how to administer them.</li><li>The debug information below can be turned off by changing the "debug" option in the <a href="admin.php?amod=Config">Config</a> area of the <a href="admin.php">Admin Control Panel.</a><br /></li></ul><br />We hope you enjoy this beta release of WebSchool.<br /><br /><span style="font-family: arial,helvetica,sans-serif;">The WebSchool Development Team</span>', '1099153213', '1099153213', '0', 1, ''); *************** *** 305,309 **** PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ! ) TYPE=MyISAM AUTO_INCREMENT=9 ; INSERT INTO `table_mods` VALUES (1, 'Academia', 'The Academia Module', 'Academia', 0, 0); --- 306,310 ---- PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ! ) TYPE=MyISAM AUTO_INCREMENT=10 ; INSERT INTO `table_mods` VALUES (1, 'Academia', 'The Academia Module', 'Academia', 0, 0); *************** *** 315,319 **** INSERT INTO `table_mods` VALUES (7, 'SC', 'The StudentCenter Index AddOn Module', 'StudentCenter', 0, 0); INSERT INTO `table_mods` VALUES (8, 'TC', 'The TeacherCenter Index AddOn Module', 'TeacherCenter', 0, 0); ! DROP TABLE IF EXISTS `table_assignments`; --- 316,320 ---- INSERT INTO `table_mods` VALUES (7, 'SC', 'The StudentCenter Index AddOn Module', 'StudentCenter', 0, 0); INSERT INTO `table_mods` VALUES (8, 'TC', 'The TeacherCenter Index AddOn Module', 'TeacherCenter', 0, 0); ! INSERT INTO `table_mods` VALUES (9, 'Calendar', 'The Calendar Module', 'TeacherCenter', 0, 0); DROP TABLE IF EXISTS `table_assignments`; |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:13:55
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv600/install Modified Files: step3.php Log Message: Fixed Some Stuff and Started Calendar Mod Index: step3.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step3.php,v retrieving revision 1.30 retrieving revision 1.31 diff -C2 -d -r1.30 -r1.31 *** step3.php 1 Jan 2005 00:28:07 -0000 1.30 --- step3.php 11 Jan 2005 00:13:42 -0000 1.31 *************** *** 251,255 **** $query = eregi_replace("table_assignments", $_REQUEST['dbprefix']."assignments", $query); $query = eregi_replace("table_user_academia", $_REQUEST['dbprefix']."user_academia", $query); ! $query = eregi_replace("table_calender", $_REQUEST['dbprefix']."calender", $query); $query = eregi_replace("table_files", $_REQUEST['dbprefix']."files", $query); $query = eregi_replace("table_sports", $_REQUEST['dbprefix']."sports", $query); --- 251,255 ---- $query = eregi_replace("table_assignments", $_REQUEST['dbprefix']."assignments", $query); $query = eregi_replace("table_user_academia", $_REQUEST['dbprefix']."user_academia", $query); ! $query = eregi_replace("table_calendar", $_REQUEST['dbprefix']."calendar", $query); $query = eregi_replace("table_files", $_REQUEST['dbprefix']."files", $query); $query = eregi_replace("table_sports", $_REQUEST['dbprefix']."sports", $query); |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:13:54
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv600/admin Modified Files: calendar.php Log Message: Fixed Some Stuff and Started Calendar Mod Index: calendar.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/calendar.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** calendar.php 27 Dec 2004 02:57:19 -0000 1.2 --- calendar.php 11 Jan 2005 00:13:41 -0000 1.3 *************** *** 75,83 **** $where = " WHERE start_time >= '" . ! date("YmdHis", mktime(0,0,0,$_GET['filter'],1)) . "' AND start_time <='" . ! date("YmdHis", mktime(0,0,0,($_GET['filter'] + 1),0)) . "'"; - } --- 75,82 ---- $where = " WHERE start_time >= '" . ! mktime(0,0,0,$_GET['filter'],1) . "' AND start_time <='" . ! mktime(0,0,0,($_GET['filter'] + 1),0) . "'"; } |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:13:52
|
Update of /cvsroot/webschool/webschool/mods/Calendar In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv600/mods/Calendar Added Files: index.php Log Message: Fixed Some Stuff and Started Calendar Mod --- NEW FILE: index.php --- <?PHP /* Webschool Copyright (C) 2004 ProgrammerMatt Developers & Contributors: ProgrammerMatt Pro...@bl... jsvoyager Gen...@gm... This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. (license.txt) */ ?> |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:13:51
|
Update of /cvsroot/webschool/webschool/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv600/lib Modified Files: mainfile.php Log Message: Fixed Some Stuff and Started Calendar Mod Index: mainfile.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/mainfile.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** mainfile.php 4 Jan 2005 23:06:53 -0000 1.13 --- mainfile.php 11 Jan 2005 00:13:42 -0000 1.14 *************** *** 17,20 **** --- 17,23 ---- */ + ob_start(); + + if (eregi("mainfile.php", $_SERVER['PHP_SELF'])) { die (); |
|
From: jsvoyager <jsv...@us...> - 2005-01-11 00:07:48
|
Update of /cvsroot/webschool/webschool/mods/Calendar In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31816/mods/Calendar Log Message: Directory /cvsroot/webschool/webschool/mods/Calendar added to the repository |
|
From: Robert P. <rob...@us...> - 2005-01-05 03:28:53
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24294/install Modified Files: step4.php Log Message: Allows end-user to choose admin username during install. Index: step4.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step4.php,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** step4.php 7 Nov 2004 19:04:40 -0000 1.8 --- step4.php 5 Jan 2005 03:28:42 -0000 1.9 *************** *** 19,24 **** if( !isset($_POST['pass']) ) { ! $content .= "Your setup has almost been completed. Now you just need to set up your administrators password!"; $content .= "<form action=\"install.php?step=4\" method=\"post\">"; $content .= "Administrator's Password: <input type=\"password\" size=\"15\" name=\"pass\" id=\"pass\" /><br />"; $content .= "Retype the Password:<input type=\"password\" size=\"15\" name=\"rpass\" id=\"rpass\" /><br />"; --- 19,25 ---- if( !isset($_POST['pass']) ) { ! $content .= "Your setup has almost been completed. Now you just need to set up your administrators username and password!"; $content .= "<form action=\"install.php?step=4\" method=\"post\">"; + $content .= "Administrator's Username: <input type=\"text\" size=\"15\" name=\"uid\" id=\"uid\" /><br />"; // robertsim007: Hey, choosing a username is a good thing, in my opinion. $content .= "Administrator's Password: <input type=\"password\" size=\"15\" name=\"pass\" id=\"pass\" /><br />"; $content .= "Retype the Password:<input type=\"password\" size=\"15\" name=\"rpass\" id=\"rpass\" /><br />"; *************** *** 30,34 **** $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET password='".sha1($_POST['pass'])."' WHERE id='2'"); header("Location: install.php?step=5"); } else { --- 31,35 ---- $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or die();; ! dbn(__FILE__,__FILE__,"Update "._USERS_." SET username='".$_POST['uid']."',password='".sha1($_POST['pass'])."' WHERE id='2'"); header("Location: install.php?step=5"); } else { |
|
From: Robert P. <rob...@us...> - 2005-01-04 23:07:12
|
Update of /cvsroot/webschool/webschool/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11047/lib Modified Files: mainfile.php Log Message: Added "lib/" to lines 50 and 53. Without addition, would not display in my Linux or Windows server. Index: mainfile.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/mainfile.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** mainfile.php 1 Jan 2005 00:28:09 -0000 1.12 --- mainfile.php 4 Jan 2005 23:06:53 -0000 1.13 *************** *** 16,21 **** (license.txt) */ - // - ob_start(); if (eregi("mainfile.php", $_SERVER['PHP_SELF'])) { --- 16,19 ---- *************** *** 50,57 **** //connect to database ! require("db.php"); $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or systemmessage("Could not connect to database");; //load the very important Authentication library! ! require("auth.php"); //is the site disabled? --- 48,55 ---- //connect to database ! require("lib/db.php"); //robertsim007: added "lib/". without it, would not load mainpage $db = db_connect(_db_server_, _db_user_, _db_pass_, _db_, _db_type_, _db_perfmon_, _db_persistent_, _db_debug_) or systemmessage("Could not connect to database");; //load the very important Authentication library! ! require("lib/auth.php"); //robertsim007: added "lib/". without it, would not load mainpage //is the site disabled? |
|
From: Matt M. <pro...@us...> - 2005-01-01 00:28:21
|
Update of /cvsroot/webschool/webschool/lib/adodb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3811/lib/adodb Modified Files: adodb-time.inc.php adodb-xmlschema.inc.php Log Message: :) Index: adodb-time.inc.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/adodb/adodb-time.inc.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** adodb-time.inc.php 12 Aug 2004 19:49:24 -0000 1.1 --- adodb-time.inc.php 1 Jan 2005 00:28:07 -0000 1.2 *************** *** 56,61 **** COPYRIGHT ! (c) 2003 John Lim and released under BSD-style license except for code by jackbbs, ! which includes adodb_mktime, adodb_get_gmt_diff, adodb_is_leap_year and originally found at http://www.php.net/manual/en/function.mktime.php --- 56,61 ---- COPYRIGHT ! (c) 2003-2004 John Lim and released under BSD-style license except for code by ! jackbbs, which includes adodb_mktime, adodb_get_gmt_diff, adodb_is_leap_year and originally found at http://www.php.net/manual/en/function.mktime.php |
|
From: Matt M. <pro...@us...> - 2005-01-01 00:28:21
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3811/mysql Modified Files: webschool.sql Log Message: :) Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.69 retrieving revision 1.70 diff -C2 -d -r1.69 -r1.70 *** webschool.sql 27 Dec 2004 02:57:20 -0000 1.69 --- webschool.sql 1 Jan 2005 00:28:09 -0000 1.70 *************** *** 1,26 **** DROP TABLE IF EXISTS `table_academia`; CREATE TABLE `table_academia` ( ! `id` int(11) NOT NULL auto_increment, `classname` varchar(25) NOT NULL default '', ! `instructor` varchar(12) NOT NULL default '', ! `grades` int(11) NOT NULL default '0', `shortdescription` varchar(255) NOT NULL default '', ! `credits` tinyint(1) NOT NULL default '0', `longdescription` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; ! INSERT INTO `table_academia` VALUES (1,"Test1","4",9,"A Test Class",0,"A test class to see how all this works"); ! INSERT INTO `table_academia` VALUES (2,"Test2","4",9,"A Test Class",0,"A test class to see how all this works"); ! INSERT INTO `table_academia` VALUES (3,"Test3","4",9,"A Test Class",0,"A test class to see how all this works"); DROP TABLE IF EXISTS `table_articles`; CREATE TABLE `table_articles` ( ! `id` int(11) NOT NULL auto_increment, `prettytitle` varchar(25) NOT NULL default '', ! `owner` int(3) NOT NULL default '0', `content` longtext NOT NULL, ! `published` varchar(20) NOT NULL default '', ! `lastupdate` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; --- 1,26 ---- DROP TABLE IF EXISTS `table_academia`; CREATE TABLE `table_academia` ( ! `id` int(11) unsigned NOT NULL auto_increment, `classname` varchar(25) NOT NULL default '', ! `instructor` int(11) unsigned NOT NULL default 0, ! `grades` int(11) unsigned NOT NULL default '0', `shortdescription` varchar(255) NOT NULL default '', ! `credits` tinyint(1) unsigned NOT NULL default '0', `longdescription` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; ! INSERT INTO `table_academia` VALUES (1,"Test1",4,9,"A Test Class",0,"A test class to see how all this works"); ! INSERT INTO `table_academia` VALUES (2,"Test2",4,9,"A Test Class",0,"A test class to see how all this works"); ! INSERT INTO `table_academia` VALUES (3,"Test3",4,9,"A Test Class",0,"A test class to see how all this works"); DROP TABLE IF EXISTS `table_articles`; CREATE TABLE `table_articles` ( ! `id` int(11) unsigned NOT NULL auto_increment, `prettytitle` varchar(25) NOT NULL default '', ! `owner` int(11) unsigned NOT NULL default '0', `content` longtext NOT NULL, ! `published` int(11) unsigned NOT NULL default 0, ! `lastupdate` int(11) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; *************** *** 51,90 **** INSERT INTO `table_config` VALUES ('sitedisabled', 'false', 'bool', ''); INSERT INTO `table_config` VALUES ('files_maxsize', '250000', 'int', ''); ! INSERT INTO `table_config` VALUES ('files_allowedtypes', '', 'str', 'doc|txt|zip|tar.gz'); DROP TABLE IF EXISTS `table_menu`; CREATE TABLE `table_menu` ( ! `id` int(11) NOT NULL auto_increment, ! `place` int(11) default '0', `mode` varchar(25) NOT NULL default '', `prettytitle` varchar(16) NOT NULL default '', `url` varchar(100) NOT NULL default '', ! `tree` varchar(25) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; ! INSERT INTO `table_menu` VALUES (1, 0, '<[TEXT]>', 'Home', 'index.php', ''); ! INSERT INTO `table_menu` VALUES (2, 1, '<[TEXT]>', 'Academia', 'mod.php?mod=Academia', ''); ! INSERT INTO `table_menu` VALUES (3, 2, '<[TEXT]>', 'SOTM', 'mod.php?mod=SOTM', ''); ! INSERT INTO `table_menu` VALUES (4, 3, '<[TEXT]>', 'Articles', 'mod.php?mod=Articles', ''); ! INSERT INTO `table_menu` VALUES (5, 4, '<[TEXT]>', 'News', 'mod.php?mod=News', ''); ! INSERT INTO `table_menu` VALUES (6, 5, '<[TEXT]>', 'Pages', 'mod.php?mod=Pages', ''); ! INSERT INTO `table_menu` VALUES (7, 6, '<[TEXT]>', 'Newsletters', 'mod.php?mod=Newsletters', ''); INSERT INTO `table_menu` VALUES (8, 7, '<[SEPERATOR]>', '', '', ''); ! INSERT INTO `table_menu` VALUES (9, 8, '<[TEXT]>', 'Admin', 'admin.php', ''); ! DROP TABLE IF EXISTS `table_news`; CREATE TABLE `table_news` ( ! `id` int(11) NOT NULL auto_increment, `prettytitle` varchar(25) NOT NULL default '', ! `published` varchar(20) NOT NULL default '', ! `owner` tinyint(1) NOT NULL default '0', `content` longtext NOT NULL, ! `lastupdate` varchar(20) NOT NULL default '', ! `submitted` varchar(20) NOT NULL default '', ! `revisionof` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; --- 51,98 ---- INSERT INTO `table_config` VALUES ('sitedisabled', 'false', 'bool', ''); INSERT INTO `table_config` VALUES ('files_maxsize', '250000', 'int', ''); ! INSERT INTO `table_config` VALUES ('files_allowedtypes', 'doc|txt|zip|tar.gz', 'str', ''); DROP TABLE IF EXISTS `table_menu`; CREATE TABLE `table_menu` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `place` int(11) unsigned NOT NULL default 0, `mode` varchar(25) NOT NULL default '', `prettytitle` varchar(16) NOT NULL default '', `url` varchar(100) NOT NULL default '', ! `tree` int(5) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; ! INSERT INTO `table_menu` VALUES (1, 0, '<[TEXT]>', 'Home', 'index.php', 0); ! INSERT INTO `table_menu` VALUES (2, 1, '<[TEXT]>', 'Academia', 'mod.php?mod=Academia', 0); ! INSERT INTO `table_menu` VALUES (3, 2, '<[TEXT]>', 'SOTM', 'mod.php?mod=SOTM', 0); ! INSERT INTO `table_menu` VALUES (4, 3, '<[TEXT]>', 'Articles', 'mod.php?mod=Articles', 0); ! INSERT INTO `table_menu` VALUES (5, 4, '<[TEXT]>', 'News', 'mod.php?mod=News', 0); ! INSERT INTO `table_menu` VALUES (6, 5, '<[TEXT]>', 'Pages', 'mod.php?mod=Pages', 0); ! INSERT INTO `table_menu` VALUES (7, 6, '<[TEXT]>', 'Newsletters', 'mod.php?mod=Newsletters', 0); INSERT INTO `table_menu` VALUES (8, 7, '<[SEPERATOR]>', '', '', ''); ! INSERT INTO `table_menu` VALUES (9, 8, '<[TEXT]>', 'Admin', 'admin.php', 0); + DROP TABLE IF EXISTS `table_menu_trees`; + CREATE TABLE `table_menu_trees` ( + `id` int(5) unsigned NOT NULL auto_increment, + `place` int(11) unsigned NOT NULL default 0, + `mode` varchar(25) NOT NULL default '', + `prettytitle` varchar(16) NOT NULL default '', + `url` varchar(100) NOT NULL default '', + PRIMARY KEY (`id`) + ) TYPE=MyISAM AUTO_INCREMENT=0; DROP TABLE IF EXISTS `table_news`; CREATE TABLE `table_news` ( ! `id` int(11) unsigned NOT NULL auto_increment, `prettytitle` varchar(25) NOT NULL default '', ! `published` int(11) unsigned NOT NULL default 0, ! `owner` int(11) unsigned NOT NULL default 0, `content` longtext NOT NULL, ! `lastupdate` int(11) unsigned NOT NULL default 0, ! `submitted` int(11) unsigned NOT NULL default 0, ! `revisionof` int(11) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; *************** *** 94,107 **** DROP TABLE IF EXISTS `table_pages`; CREATE TABLE `table_pages` ( ! `id` int(11) NOT NULL auto_increment, `prettytitle` varchar(35) NOT NULL default '', ! `owner` int(11) NOT NULL default 0, `writeperm` varchar(55) NOT NULL default '', ! `content` longtext NOT NULL default '', ! `published` varchar(20) NOT NULL default '', ! `lastupdate` varchar(20) NOT NULL default '', ! `submitted` varchar(20) NOT NULL default '', ! `onindex` tinyint(4) NOT NULL default '0', ! `revisionof` varchar(35) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; --- 102,115 ---- DROP TABLE IF EXISTS `table_pages`; CREATE TABLE `table_pages` ( ! `id` int(11) unsigned NOT NULL auto_increment, `prettytitle` varchar(35) NOT NULL default '', ! `owner` int(11) unsigned NOT NULL default 0, `writeperm` varchar(55) NOT NULL default '', ! `content` longtext NOT NULL, ! `published` int(11) unsigned NOT NULL default 0, ! `lastupdate` int(11) unsigned NOT NULL default 0, ! `submitted` int(11) unsigned NOT NULL default 0, ! `onindex` tinyint(4) unsigned NOT NULL default 0, ! `revisionof` int(11) unsigned NOT NULL default 0, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; *************** *** 111,117 **** DROP TABLE IF EXISTS `table_pages_sub`; CREATE TABLE `table_pages_sub` ( ! `id` int(11) NOT NULL auto_increment, ! `childof` int(11) NOT NULL default 1, ! `owner` int(11) NOT NULL default 0, `writeperm` varchar(55) NOT NULL default '', `content` longtext NOT NULL default '', --- 119,125 ---- DROP TABLE IF EXISTS `table_pages_sub`; CREATE TABLE `table_pages_sub` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `childof` int(11) unsigned NOT NULL default 1, ! `owner` int(11) unsigned NOT NULL default 0, `writeperm` varchar(55) NOT NULL default '', `content` longtext NOT NULL default '', *************** *** 121,141 **** DROP TABLE IF EXISTS `table_permissions`; CREATE TABLE `table_permissions` ( ! `userid` int(11) NOT NULL default '', ! `academia` tinyint(1) NOT NULL default '0', ! `articles` tinyint(1) NOT NULL default '0', ! `calendar` tinyint(1) NOT NULL default '0', ! `config` tinyint(1) NOT NULL default '0', ! `files` tinyint(1) NOT NULL default '0', ! `modules` tinyint(1) NOT NULL default '0', ! `menu` tinyint(1) NOT NULL default '0', ! `news` tinyint(1) NOT NULL default '0', ! `newsletters` tinyint(1) NOT NULL default '0', ! `pages` tinyint(1) NOT NULL default '0', ! `pictures` tinyint(1) NOT NULL default '0', ! `profiles` tinyint(1) NOT NULL default '0', ! `sotm` tinyint(1) NOT NULL default '0', ! `sports` tinyint(1) NOT NULL default '0', ! `theater` tinyint(1) NOT NULL default '0', ! `users` tinyint(1) NOT NULL default '0', PRIMARY KEY (`userid`) ) TYPE=MyISAM; --- 129,149 ---- DROP TABLE IF EXISTS `table_permissions`; CREATE TABLE `table_permissions` ( ! `userid` int(11) unsigned NOT NULL default '', ! `academia` tinyint(1) unsigned NOT NULL default '0', ! `articles` tinyint(1) unsigned NOT NULL default '0', ! `calendar` tinyint(1) unsigned NOT NULL default '0', ! `config` tinyint(1) unsigned NOT NULL default '0', ! `files` tinyint(1) unsigned NOT NULL default '0', ! `modules` tinyint(1) unsigned NOT NULL default '0', ! `menu` tinyint(1) unsigned NOT NULL default '0', ! `news` tinyint(1) unsigned NOT NULL default '0', ! `newsletters` tinyint(1) unsigned NOT NULL default '0', ! `pages` tinyint(1) unsigned NOT NULL default '0', ! `pictures` tinyint(1) unsigned NOT NULL default '0', ! `profiles` tinyint(1) unsigned NOT NULL default '0', ! `sotm` tinyint(1) unsigned NOT NULL default '0', ! `sports` tinyint(1) unsigned NOT NULL default '0', ! `theater` tinyint(1) unsigned NOT NULL default '0', ! `users` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`) ) TYPE=MyISAM; *************** *** 148,161 **** DROP TABLE IF EXISTS `table_pics`; CREATE TABLE `table_pics` ( ! `id` int(11) NOT NULL auto_increment, ! `owner` int(11) NOT NULL default '', `description` varchar(255) NOT NULL default '', `type` varchar(25) NOT NULL default '', `name` varchar(25) NOT NULL default '', ! `approved` varchar(25) NOT NULL default '', ! `views` int(11) NOT NULL default '0', ! `x` int(11) NOT NULL default '0', ! `y` int(11) NOT NULL default '0', ! `size` int(11) NOT NULL default '0', `filename` varchar(255) NOT NULL default '', `category` varchar(255) NOT NULL default '', --- 156,169 ---- DROP TABLE IF EXISTS `table_pics`; CREATE TABLE `table_pics` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `owner` int(11) unsigned NOT NULL default '', `description` varchar(255) NOT NULL default '', `type` varchar(25) NOT NULL default '', `name` varchar(25) NOT NULL default '', ! `approved` int(11) unsigned NOT NULL default '', ! `views` int(11) unsigned NOT NULL default 0, ! `x` int(11) unsigned NOT NULL default 0, ! `y` int(11) unsigned NOT NULL default 0, ! `size` int(11) unsigned NOT NULL default 0, `filename` varchar(255) NOT NULL default '', `category` varchar(255) NOT NULL default '', *************** *** 166,178 **** DROP TABLE IF EXISTS `table_files`; CREATE TABLE `table_files` ( ! `id` int(11) NOT NULL auto_increment, ! `owner` int(11) NOT NULL default '', `description` varchar(255) NULL, `type` varchar(25) NOT NULL default '', `name` varchar(25) NOT NULL default '', `filename` varchar(45) NOT NULL default '', ! `approved` varchar(25) NOT NULL default '', ! `downloads` int(11) NOT NULL default '0', ! `size` int(11) NOT NULL default '0', `category` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) --- 174,186 ---- DROP TABLE IF EXISTS `table_files`; CREATE TABLE `table_files` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `owner` int(11) unsigned NOT NULL default 0, `description` varchar(255) NULL, `type` varchar(25) NOT NULL default '', `name` varchar(25) NOT NULL default '', `filename` varchar(45) NOT NULL default '', ! `approved` int(11) unsigned NOT NULL default 0, ! `downloads` int(11) unsigned NOT NULL default 0, ! `size` int(11) unsigned NOT NULL default 0, `category` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) *************** *** 182,187 **** DROP TABLE IF EXISTS `table_sotm`; CREATE TABLE `table_sotm` ( ! `id` int(11) NOT NULL auto_increment, ! `date` varchar(20) NOT NULL default '', `sepic` varchar(255) NOT NULL default '', `sename` varchar(25) NOT NULL default '', --- 190,195 ---- DROP TABLE IF EXISTS `table_sotm`; CREATE TABLE `table_sotm` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `date` int(11) unsigned NOT NULL default '', `sepic` varchar(255) NOT NULL default '', `sename` varchar(25) NOT NULL default '', *************** *** 203,213 **** DROP TABLE IF EXISTS `table_users`; CREATE TABLE `table_users` ( ! `id` int(11) NOT NULL auto_increment, `username` varchar(15) NOT NULL default '', `fname` varchar(16) NOT NULL default '', `lname` varchar(16) NOT NULL default '', ! `lastview` varchar(25) NOT NULL default '', `lastip` varchar(25) NOT NULL default '', ! `locked` tinyint(1) NOT NULL default '0', `email` varchar(100) NOT NULL default '', `role` enum('administrator','instructor','student','none') NOT NULL default 'none', --- 211,221 ---- DROP TABLE IF EXISTS `table_users`; CREATE TABLE `table_users` ( ! `id` int(11) unsigned NOT NULL auto_increment, `username` varchar(15) NOT NULL default '', `fname` varchar(16) NOT NULL default '', `lname` varchar(16) NOT NULL default '', ! `lastview` int(11) unsigned NOT NULL default '', `lastip` varchar(25) NOT NULL default '', ! `locked` tinyint(1) unsigned NOT NULL default '0', `email` varchar(100) NOT NULL default '', `role` enum('administrator','instructor','student','none') NOT NULL default 'none', *************** *** 226,232 **** DROP TABLE IF EXISTS `table_newsletters`; CREATE TABLE `table_newsletters` ( ! `id` int(11) NOT NULL auto_increment, `prettyname` varchar(15) NOT NULL default '', ! `moderator` int(11) NOT NULL default '0', `shortdescription` varchar(255) NOT NULL default '', `longdescription` longtext NOT NULL default '', --- 234,240 ---- DROP TABLE IF EXISTS `table_newsletters`; CREATE TABLE `table_newsletters` ( ! `id` int(11) unsigned NOT NULL auto_increment, `prettyname` varchar(15) NOT NULL default '', ! `moderator` int(11) unsigned NOT NULL default '0', `shortdescription` varchar(255) NOT NULL default '', `longdescription` longtext NOT NULL default '', *************** *** 239,245 **** DROP TABLE IF EXISTS `table_newsletters_archive`; CREATE TABLE `table_newsletters_archive` ( ! `id` int(11) NOT NULL auto_increment, ! `newsletter_id` tinyint(1) NOT NULL default '0', ! `date` varchar(15) NOT NULL default '', `content` longtext NOT NULL default '', PRIMARY KEY (`id`), --- 247,253 ---- DROP TABLE IF EXISTS `table_newsletters_archive`; CREATE TABLE `table_newsletters_archive` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `newsletter_id` tinyint(1) unsigned NOT NULL default '0', ! `date` int(11) unsigned NOT NULL default '', `content` longtext NOT NULL default '', PRIMARY KEY (`id`), *************** *** 253,257 **** `id` int(11) NOT NULL auto_increment, `email` varchar(30) NOT NULL default '', ! `subscription_id` varchar(25) NOT NULL default '', `actkey` varchar(75) NOT NULL default '', PRIMARY KEY (`id`), --- 261,265 ---- `id` int(11) NOT NULL auto_increment, `email` varchar(30) NOT NULL default '', ! `subscription_id` int(11) unsigned NOT NULL default '', `actkey` varchar(75) NOT NULL default '', PRIMARY KEY (`id`), *************** *** 262,267 **** DROP TABLE IF EXISTS `table_amods`; ! CREATE TABLE `table_aMods` ( ! `id` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `description` varchar(25) NOT NULL default '', --- 270,275 ---- DROP TABLE IF EXISTS `table_amods`; ! CREATE TABLE `table_amods` ( ! `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `description` varchar(25) NOT NULL default '', *************** *** 288,298 **** DROP TABLE IF EXISTS `table_mods`; ! CREATE TABLE `table_Mods` ( ! `id` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `description` varchar(25) NOT NULL default '', `dirname` varchar(25) NOT NULL default '', ! `disabled` tinyint(1) NOT NULL default '', ! `permission` tinyint(1) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) --- 296,306 ---- DROP TABLE IF EXISTS `table_mods`; ! CREATE TABLE `table_mods` ( ! `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `description` varchar(25) NOT NULL default '', `dirname` varchar(25) NOT NULL default '', ! `disabled` tinyint(1) unsigned NOT NULL default '', ! `permission` tinyint(1) unsigned NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) *************** *** 311,315 **** DROP TABLE IF EXISTS `table_assignments`; CREATE TABLE `table_assignments` ( ! `id` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `due` date NOT NULL default '0000-00-00', --- 319,323 ---- DROP TABLE IF EXISTS `table_assignments`; CREATE TABLE `table_assignments` ( ! `id` int(11) unsigned NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `due` date NOT NULL default '0000-00-00', *************** *** 333,339 **** DROP TABLE IF EXISTS `table_calendar`; CREATE TABLE `table_calendar` ( ! `id` int(11) NOT NULL auto_increment, ! `start_time` varchar(11) NOT NULL default '', ! `end_time` varchar(11) NULL default NULL, `event_type` varchar(15) NOT NULL default '', `title` varchar(15) NOT NULL default '', --- 341,347 ---- DROP TABLE IF EXISTS `table_calendar`; CREATE TABLE `table_calendar` ( ! `id` int(11) unsigned NOT NULL auto_increment, ! `start_time` int(11) unsigned NOT NULL default '', ! `end_time` int(11) unsigned NULL default NULL, `event_type` varchar(15) NOT NULL default '', `title` varchar(15) NOT NULL default '', *************** *** 344,348 **** DROP TABLE IF EXISTS `table_sports`; CREATE TABLE `table_sports` ( ! `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) --- 352,356 ---- DROP TABLE IF EXISTS `table_sports`; CREATE TABLE `table_sports` ( ! `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) *************** *** 351,355 **** DROP TABLE IF EXISTS `table_sports_roster`; CREATE TABLE `table_sports_roster` ( ! `sid` int(11) NOT NULL, `name` varchar(50) NOT NULL, `position` varchar(20) NOT NULL --- 359,363 ---- DROP TABLE IF EXISTS `table_sports_roster`; CREATE TABLE `table_sports_roster` ( ! `sid` int(11) unsigned NOT NULL, `name` varchar(50) NOT NULL, `position` varchar(20) NOT NULL *************** *** 358,362 **** DROP TABLE IF EXISTS `table_sports_game`; CREATE TABLE `table_sports_game` ( ! `id` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL UNIQUE, `sid` int(11) NOT NULL, --- 366,370 ---- DROP TABLE IF EXISTS `table_sports_game`; CREATE TABLE `table_sports_game` ( ! `id` int(11) unsigned NOT NULL auto_increment, `cid` int(11) NOT NULL UNIQUE, `sid` int(11) NOT NULL, |
|
From: Matt M. <pro...@us...> - 2005-01-01 00:28:18
|
Update of /cvsroot/webschool/webschool/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3811/lib Modified Files: mainfile.php Log Message: :) Index: mainfile.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/mainfile.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** mainfile.php 4 Dec 2004 01:47:37 -0000 1.11 --- mainfile.php 1 Jan 2005 00:28:09 -0000 1.12 *************** *** 99,102 **** --- 99,103 ---- } } + //replaces error() Function systemmessage($msg, $log=false) { *************** *** 114,156 **** } - ///This function, used in smarty, creates an option list with the names of user with given criteria - /* - ProgrammerMatt: Considering that production users may have well over 1000 users, this could be time consuming task and would - result in a huge select box, un-idealic for searching. I think that the "finduser" feature to-be-implemented in admin.php will - easily, and conviently replace this - */ - $smarty->register_function("html_option_users", "html_option_users"); - function html_option_users($args){ - //First get the users they wanted by getting the option they pased in the "where" arg - $query = "SELECT * FROM "._USERS_; - if (isset($args['where'])){ - $query .= " WHERE " . $args['where']; - } - db4(__FILE__,__LINE__,$query); - - $answer = "<select name=\"" . $args['name'] . "\" size=\"0\">"; - - - while ($curr_user = dbr4()){ - //See if this is supposed to be selected... - if ($args['selected'] == $curr_user['id']){ - $select = " selected=\"selected\""; - }else{ - $select = ""; - } - - $answer .= "<option value=\"" . $curr_user['id'] . $select . "\">" . $curr_user['fname'] . " " . - $curr_user['lname'] . "</option>"; - - } - $answer .= "</select>"; - echo $answer; - return $answer; - } - if( is_a($smarty, "Smarty")){ - $smarty->register_function("gzuncompress", "gzuncompress"); - $smarty->register_function("gzcompress", "gzcompress"); - } ?> \ No newline at end of file --- 115,119 ---- |
