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...> - 2004-12-03 02:16:32
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11865/mysql Modified Files: webschool.sql Log Message: Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.60 retrieving revision 1.61 diff -C2 -d -r1.60 -r1.61 *** webschool.sql 3 Dec 2004 02:06:58 -0000 1.60 --- webschool.sql 3 Dec 2004 02:16:16 -0000 1.61 *************** *** 71,75 **** 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=Pics', ''); INSERT INTO `table_menu` VALUES (7, 6, '<[TEXT]>', 'Newsletters', 'mod.php?mod=Newsletters', ''); INSERT INTO `table_menu` VALUES (8, 7, '<[SEPERATOR]>', '', '', ''); --- 71,75 ---- 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]>', '', '', ''); |
|
From: Matt M. <pro...@us...> - 2004-12-03 02:07:11
|
Update of /cvsroot/webschool/webschool/theme/templates/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10034/theme/templates/admin Modified Files: articles.read.tpl files.tpl news.read.tpl news.tpl pages.tpl pictures.add.tpl users.tpl Log Message: more changes than i can count :) Index: pages.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/pages.tpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** pages.tpl 1 Dec 2004 03:31:51 -0000 1.4 --- pages.tpl 3 Dec 2004 02:06:59 -0000 1.5 *************** *** 29,36 **** <td>{ResolveUserID ID=$active[iv].owner pretty="true"}</td> {/if} ! <td>{$active[iv].published}</td> ! <td>{$active[iv].lastupdated}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$active[iv].id}">{$lang.pages.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.pages.delete_symbol}</a></td> <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.pages.remove_symbol}</a></td> {if $perm.pages >= 3} --- 29,36 ---- <td>{ResolveUserID ID=$active[iv].owner pretty="true"}</td> {/if} ! <td>{$active[iv].published|date_format}</td> ! <td>{$active[iv].lastupdated|date_format}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$active[iv].id}">{$lang.pages.modify_symbol}</a></td> ! <td><center><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.pages.delete_symbol}</a></center></td> <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.pages.remove_symbol}</a></td> {if $perm.pages >= 3} *************** *** 46,58 **** </table> ! <br><br> ! <center>{if $perm.articles == 1}{$lang.pages.your} {/if} {$lang.pages.pagespending} <center> <table width=100%> ! <tr> <td>{$lang.pages.title}</td> {if $perm.articles >= 2} --- 46,58 ---- </table> ! << PAGINATION >> <br><br> ! <center>{if $perm.articles == 1}{$lang.pages.your} {/if} {$lang.pages.pagespending} </center> <table width=100%> ! <tr class="title"> <td>{$lang.pages.title}</td> {if $perm.articles >= 2} *************** *** 83,99 **** </table> ! <br><br> ! <center>{$lang.pages.your} {$lang.pages.pagesprogress} <center> <table width=100%> ! <tr> <td>{$lang.pages.title}</td> <td>{$lang.pages.updated}</td> <td>{$lang.pages.modify}</td> ! <td>{$lang.pages.delete}</td> <td>{if $perm.pages >= 2}{$lang.pages.publish}{elseif $perm.pages == 1}{$lang.pages.submit}{/if}</td> </tr> --- 83,99 ---- </table> ! << PAGINATION >> <br><br> ! <center>{$lang.pages.your} {$lang.pages.pagesprogress} </center> <table width=100%> ! <tr class="title"> <td>{$lang.pages.title}</td> <td>{$lang.pages.updated}</td> <td>{$lang.pages.modify}</td> ! <td width="60">{$lang.pages.delete}</td> <td>{if $perm.pages >= 2}{$lang.pages.publish}{elseif $perm.pages == 1}{$lang.pages.submit}{/if}</td> </tr> *************** *** 102,109 **** <tr> ! <td>{$progress[iv].title}</td> ! <td>{$progress[iv].lastupdated}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$progress[iv].id}">{$lang.pages.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=delete&id={$progress[iv].id}">{$lang.pages.delete_symbol}</a></td> {if $perm.pages >= 2} <td><a href="{$AMOD}&op=publish&id={$progress[iv].id}">{$lang.pages.publish_symbol}</a></td> --- 102,109 ---- <tr> ! <td>{$progress[iv].prettytitle}</td> ! <td>{$progress[iv].lastupdate|date_format}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$progress[iv].id}">{$lang.pages.modify_symbol}</a></td> ! <td><center><a href="{$AMOD}&op=delete&id={$progress[iv].id}">{$lang.pages.delete_symbol}</a></center></td> {if $perm.pages >= 2} <td><a href="{$AMOD}&op=publish&id={$progress[iv].id}">{$lang.pages.publish_symbol}</a></td> *************** *** 115,119 **** {/section} ! </table> <a href="{$AMOD}&op=add&htmlarea=1"> {$lang.pages.addpages} </a> {/if} --- 115,121 ---- {/section} ! </table> ! << PAGINATION >> ! <br> <a href="{$AMOD}&op=add&htmlarea=1"> {$lang.pages.addpages} </a> {/if} Index: news.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/news.tpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** news.tpl 6 Nov 2004 01:16:36 -0000 1.4 --- news.tpl 3 Dec 2004 02:06:59 -0000 1.5 *************** *** 16,19 **** --- 16,20 ---- <td>{$lang.news.published}</td> <td>{$lang.news.updated}</td> + <td>{$lang.news.read}</td> <td>{$lang.news.modify}</td> <td>{$lang.news.delete}</td> *************** *** 24,35 **** <tr> ! <td>{$active[iv].title}</td> {if $perm.news >= 2} ! <td>{$active[iv].owner}</td> {/if} ! <td>{$active[iv].published}</td> ! <td>{$active[iv].lastupdated}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$active[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.news.delete_symbol}</a></td> <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.news.remove_symbol}</a></td> </tr> --- 25,37 ---- <tr> ! <td>{$active[iv].prettytitle}</td> {if $perm.news >= 2} ! <td>{ResolveUserID ID=$active[iv].owner}</td> {/if} ! <td>{$active[iv].published|date_format}</td> ! <td>{$active[iv].lastupdate|date_format}</td> ! <td><a href="{$AMOD}&op=read&id={$active[iv].id}">{$lang.news.read_symbol}</a></td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$active[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><center><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.news.delete_symbol}</a></center></td> <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.news.remove_symbol}</a></td> </tr> *************** *** 53,56 **** --- 55,59 ---- <td>{$lang.news.submitted}</td> <td>{$lang.news.updated}</td> + <td>{$lang.news.read}</td> <td>{$lang.news.modify}</td> <td>{$lang.news.delete}</td> *************** *** 63,74 **** <tr> ! <td>{$pending[iv].title}</td> {if $perm.news >= 2} ! <td>{$pending[iv].owner}</td> {/if} ! <td>{$pending[iv].submitted}</td> ! <td>{$pending[iv].lastupdated}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$pending[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=delete&id={$pending[iv].id}">{$lang.news.delete_symbol}</a></td> {if $perm.news >= 2}<td><a href="{$AMOD}&op=publish&id={$pending[iv].id}">{$lang.news.publish_symbol}</a></td>{/if} </tr> --- 66,78 ---- <tr> ! <td>{$pending[iv].prettytitle}</td> {if $perm.news >= 2} ! <td>{ResolveUserID ID=$pending[iv].owner}</td> {/if} ! <td>{$pending[iv].submitted|date_format}</td> ! <td>{$pending[iv].lastupdate|date_format}</td> ! <td><a href="{$AMOD}&op=read&id={$pending[iv].id}">{$lang.news.read_symbol}</a></td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$pending[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><center><a href="{$AMOD}&op=delete&id={$pending[iv].id}">{$lang.news.delete_symbol}</a></center></td> {if $perm.news >= 2}<td><a href="{$AMOD}&op=publish&id={$pending[iv].id}">{$lang.news.publish_symbol}</a></td>{/if} </tr> *************** *** 89,92 **** --- 93,97 ---- <td>{$lang.news.updated}</td> <td>{$lang.news.modify}</td> + <td>{$lang.news.read}</td> <td>{$lang.news.delete}</td> <td> *************** *** 101,108 **** <tr> ! <td>{$progress[iv].title}</td> ! <td>{$progress[iv].lastupdated}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$progress[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=delete&id={$progress[iv].id}">{$lang.news.delete_symbol}</a></td> {if $perm.news >= 2} <td><a href="{$AMOD}&op=publish&id={$progress[iv].id}">{$lang.news.publish_symbol}</a></td> --- 106,114 ---- <tr> ! <td>{$progress[iv].prettytitle}</td> ! <td>{$progress[iv].lastupdate|date_format}</td> <td><a href="{$AMOD}&op=modify&htmlarea=1&id={$progress[iv].id}">{$lang.news.modify_symbol}</a></td> ! <td><a href="{$AMOD}&op=read&id={$progress[iv].id}">{$lang.news.read_symbol}</a></td> ! <td><center><a href="{$AMOD}&op=delete&id={$progress[iv].id}">{$lang.news.delete_symbol}</a></center></td> {if $perm.news >= 2} <td><a href="{$AMOD}&op=publish&id={$progress[iv].id}">{$lang.news.publish_symbol}</a></td> Index: articles.read.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/articles.read.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** articles.read.tpl 24 Nov 2004 02:54:15 -0000 1.2 --- articles.read.tpl 3 Dec 2004 02:06:59 -0000 1.3 *************** *** 1,10 **** {include file="tablehead.tpl" tbtitle="Read an Article"} ! <br><br><center> {$read_prettytitle} </center><br><hr> ! {$lang.articles.read_author} {$read_author}<br> ! {$lang.articles.read_published} {$read_published}<br> ! {$lang.articles.read_updated} {$read_updated}<br> <br> ! {$read_content} {include file="tablefoot.tpl"} \ No newline at end of file --- 1,10 ---- {include file="tablehead.tpl" tbtitle="Read an Article"} ! <br><br><center> {$read.prettytitle} </center><br><hr> ! {$lang.articles.read_author} {ResolveUserID ID=$read.owner}<br> ! {$lang.articles.read_published} {$read.published|date_format}<br> ! {$lang.articles.read_updated} {$read.lastupdate|date_format}<br> <br> ! {$read.content} {include file="tablefoot.tpl"} \ No newline at end of file Index: files.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/files.tpl,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** files.tpl 26 Nov 2004 01:02:36 -0000 1.1 --- files.tpl 3 Dec 2004 02:06:59 -0000 1.2 *************** *** 3,25 **** ! {if $perm.pictures <= 0 || $denied == true} ! {$lang.auth_denied} ! {else} ! <p class="over-title">{if $perm.pictures == 1}{$lang.pictures.your} {/if} {$lang.pictures.activepictures} </p> <table width=100%> <tr class="title"> ! <td>{$lang.pictures.title}</td> ! <td>{$lang.pictures.id}</td> ! <td>{$lang.pictures.view}</td> ! <td>{$lang.pictures.views}</td> ! <td>{$lang.pictures.description}</td> {if $perm.articles >= 2} ! <td>{$lang.pictures.owner}</td> {/if} ! <td>{$lang.pictures.dimensions}</td> ! <td>{$lang.pictures.size}</td> ! <td>{$lang.pictures.delete}</td> ! <td>{$lang.pictures.remove_symbol}</td> </tr> --- 3,22 ---- ! <p class="over-title">{if $perm.files == 1}{$lang.files.your} {/if} {$lang.files.activefiles} </p> <table width=100%> <tr class="title"> ! <td>{$lang.files.title}</td> ! <td>{$lang.files.id}</td> ! <td>{$lang.files.view}</td> ! <td>{$lang.files.views}</td> ! <td>{$lang.files.description}</td> {if $perm.articles >= 2} ! <td>{$lang.files.owner}</td> {/if} ! <td>{$lang.files.dimensions}</td> ! <td>{$lang.files.size}</td> ! <td>{$lang.files.delete}</td> ! <td>{$lang.files.remove_symbol}</td> </tr> *************** *** 30,44 **** <td>{$active[iv].title}</td> <td>{$active[iv].id}</td> ! <td><a href="pic.php?id={$active[iv].id}">{$lang.pictures.view_symbol}</a> <td><center>{$active[iv].views}</center></td> <td>{$active[iv].description}</td> ! {if $perm.pictures >= 2} <td>{$active[iv].owner}</td> {/if} <td>{$active[iv].dimensions}</td> <td>{$active[iv].size} Kb</td> ! <td><center><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.pictures.delete_symbol}</a></center></td> ! <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.pictures.remove_symbol}</a></td> </tr> --- 27,41 ---- <td>{$active[iv].title}</td> <td>{$active[iv].id}</td> ! <td><a href="pic.php?id={$active[iv].id}">{$lang.files.view_symbol}</a> <td><center>{$active[iv].views}</center></td> <td>{$active[iv].description}</td> ! {if $perm.files >= 2} <td>{$active[iv].owner}</td> {/if} <td>{$active[iv].dimensions}</td> <td>{$active[iv].size} Kb</td> ! <td><center><a href="{$AMOD}&op=delete&id={$active[iv].id}">{$lang.files.delete_symbol}</a></center></td> ! <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.files.remove_symbol}</a></td> </tr> *************** *** 51,69 **** ! <p class="over-title">{if $perm.articles == 1}{$lang.pictures.your} {/if} {$lang.pictures.picturespending} </p> <table width=100%> <tr class="title"> ! <td>{$lang.pictures.title}</td> ! <td>{$lang.pictures.id}</td> ! <td>{$lang.pictures.view}</td> ! <td>{$lang.pictures.description}</td> {if $perm.articles >= 2} ! <td>{$lang.pictures.owner}</td> {/if} ! <td>{$lang.pictures.dimensions}</td> ! <td>{$lang.pictures.size}</td> ! <td>{$lang.pictures.delete}</td> ! <td>{$lang.pictures.approve}</td> </tr> --- 48,66 ---- ! <p class="over-title">{if $perm.articles == 1}{$lang.files.your} {/if} {$lang.files.filespending} </p> <table width=100%> <tr class="title"> ! <td>{$lang.files.title}</td> ! <td>{$lang.files.id}</td> ! <td>{$lang.files.view}</td> ! <td>{$lang.files.description}</td> {if $perm.articles >= 2} ! <td>{$lang.files.owner}</td> {/if} ! <td>{$lang.files.dimensions}</td> ! <td>{$lang.files.size}</td> ! <td>{$lang.files.delete}</td> ! <td>{$lang.files.approve}</td> </tr> *************** *** 74,87 **** <td>{$pending[iv].title}</td> <td>{$pending[iv].id}</td> ! <td><a href="pic.php?id={$pending[iv].id}">{$lang.pictures.view_symbol}</a> <td>{$pending[iv].description}</td> ! {if $perm.pictures >= 2} <td>{$pending[iv].owner}</td> {/if} <td>{$pending[iv].dimensions}</td> <td>{$pending[iv].size} Kb</td> ! <td><center><a href="{$AMOD}&op=delete&id={$pending[iv].id}">{$lang.pictures.delete_symbol}</a></center></td> ! <td><a href="{$AMOD}&op=approve&id={$pending[iv].id}">{$lang.pictures.approve_symbol}</a></td> </tr> --- 71,84 ---- <td>{$pending[iv].title}</td> <td>{$pending[iv].id}</td> ! <td><a href="pic.php?id={$pending[iv].id}">{$lang.files.view_symbol}</a> <td>{$pending[iv].description}</td> ! {if $perm.files >= 2} <td>{$pending[iv].owner}</td> {/if} <td>{$pending[iv].dimensions}</td> <td>{$pending[iv].size} Kb</td> ! <td><center><a href="{$AMOD}&op=delete&id={$pending[iv].id}">{$lang.files.delete_symbol}</a></center></td> ! <td><a href="{$AMOD}&op=approve&id={$pending[iv].id}">{$lang.files.approve_symbol}</a></td> </tr> *************** *** 91,96 **** <br><br> ! <a href="{$AMOD}&op=add&htmlarea=1"> {$lang.pictures.addpictures} </a> ! {/if} {include file=tablefoot.tpl} --- 88,92 ---- <br><br> ! <a href="{$AMOD}&op=add&htmlarea=1"> {$lang.files.addfiles} </a> {include file=tablefoot.tpl} Index: users.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/users.tpl,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** users.tpl 6 Nov 2004 19:09:22 -0000 1.5 --- users.tpl 3 Dec 2004 02:06:59 -0000 1.6 *************** *** 1,8 **** {include file=tablehead.tpl tbtitle="Users"} ! {if $perm.users == 0 || $denied === true} ! {$lang.auth_action_denied} ! {else} ! <table width="100%"> <tr class="title"> --- 1,10 ---- {include file=tablehead.tpl tbtitle="Users"} ! {if $perm.users >=2 } ! <form action="{$AMOD}&op=filter" method="POST"> ! {$lang.users.filter} {$lang.users.username}: <input type="text" name="fusername" id="fusername"> << SQL WILDCARDS ACCEPTED >> ! <input type="submit" value="{$lang.users.filter}"> ! </form> ! {/if} <table width="100%"> <tr class="title"> *************** *** 76,79 **** <a href="{$AMOD}&op=adduser">{$lang.users.adduser}</a> {/if} ! {/if} {include file=tablefoot.tpl} \ No newline at end of file --- 78,81 ---- <a href="{$AMOD}&op=adduser">{$lang.users.adduser}</a> {/if} ! {include file=tablefoot.tpl} \ No newline at end of file Index: pictures.add.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/pictures.add.tpl,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** pictures.add.tpl 24 Nov 2004 02:54:15 -0000 1.3 --- pictures.add.tpl 3 Dec 2004 02:06:59 -0000 1.4 *************** *** 8,14 **** <form action="{$AMOD}&op=add&upload=1" method="post" enctype="multipart/form-data"> ! <br>Picture Name:<input type='text' name="picname" id="picname"><br> <br>Description: <br> <textarea name="descrip" id="pic" cols="55" rows="4"> </textarea> ! <br>Picture: <input type="file" name="pic" id="pic"> <br><button type="submit">Submit</button> </form> --- 8,14 ---- <form action="{$AMOD}&op=add&upload=1" method="post" enctype="multipart/form-data"> ! <br>File Name:<input type='text' name="picname" id="picname"><br> <br>Description: <br> <textarea name="descrip" id="pic" cols="55" rows="4"> </textarea> ! <br>File: <input type="file" name="pic" id="pic"> <br><button type="submit">Submit</button> </form> Index: news.read.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/news.read.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** news.read.tpl 24 Nov 2004 02:54:15 -0000 1.2 --- news.read.tpl 3 Dec 2004 02:06:59 -0000 1.3 *************** *** 1,8 **** {include file="tablehead.tpl" tbtitle="Read an Article"} ! <br><br><center> {$read_prettytitle} </center><br><hr> ! {$lang.articles.read_author} {$read_author}<br> ! {$lang.articles.read_published} {$read_published}<br> ! {$lang.articles.read_updated} {$read_updated}<br> <br> {$read_content} --- 1,8 ---- {include file="tablehead.tpl" tbtitle="Read an Article"} ! <br><br><center> {$read.prettytitle} </center><br><hr> ! {$lang.news.read_author} {ResolveUserID ID=$read.owner}<br> ! {$lang.news.read_published} {$read.published}<br> ! {$lang.news.read_updated} {$read.lastupdated}<br> <br> {$read_content} |
|
From: Matt M. <pro...@us...> - 2004-12-03 02:07:09
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10034/mysql Modified Files: webschool.sql Log Message: more changes than i can count :) Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.59 retrieving revision 1.60 diff -C2 -d -r1.59 -r1.60 *** webschool.sql 1 Dec 2004 03:31:51 -0000 1.59 --- webschool.sql 3 Dec 2004 02:06:58 -0000 1.60 *************** *** 51,55 **** INSERT INTO `table_config` VALUES ('recentnews', '5', 'int', ''); INSERT INTO `table_config` VALUES ('sitedisabled', 'false', 'bool', ''); ! --- 51,56 ---- INSERT INTO `table_config` VALUES ('recentnews', '5', 'int', ''); INSERT INTO `table_config` VALUES ('sitedisabled', 'false', 'bool', ''); ! INSERT INTO `table_config` VALUES ('file_maxsize' '250000', 'int', ''); ! INSERT INTO `table_config` VALUES ('file_allowedtypes', '', 'str', ''); *************** *** 82,86 **** `prettytitle` varchar(25) NOT NULL default '', `published` varchar(20) NOT NULL default '', ! `owner` tinyihttp://nyphp.org/content/presentations/GDintro/gd18.phpnt(1) NOT NULL default '0', `content` longtext NOT NULL, `lastupdate` varchar(20) NOT NULL default '', --- 83,87 ---- `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 '', *************** *** 338,343 **** 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`) ) TYPE=MyISAM ; --- 339,344 ---- 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`) ) TYPE=MyISAM ; *************** *** 345,361 **** 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 ) TYPE=MyISAM ; 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, ! `location` enum('home','away') NOT NULL, ! `versus` varchar(20) NOT NULL, ! `score` varchar(10) NOT NULL default '-1', #-1 = TBD PRIMARY KEY (`id`) ) TYPE=MyISAM ; \ No newline at end of file --- 346,362 ---- 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 ) TYPE=MyISAM ; 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, ! `location` enum('home','away') NOT NULL, ! `versus` varchar(20) NOT NULL, ! `score` varchar(10) NOT NULL default '-1', #-1 = TBD PRIMARY KEY (`id`) ) TYPE=MyISAM ; \ No newline at end of file |
|
From: Matt M. <pro...@us...> - 2004-12-03 02:07:08
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10034/admin Modified Files: articles.php files.php news.php pages.php users.php Log Message: more changes than i can count :) Index: news.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/news.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** news.php 6 Nov 2004 01:16:19 -0000 1.3 --- news.php 3 Dec 2004 02:06:41 -0000 1.4 *************** *** 35,44 **** } while( $row = dbr2() ){ ! $active['title'] = $row['prettytitle']; ! $active['owner'] = ResolveUserID($row['owner'], false); ! $active['published'] = date("m/d/y", $row['published']); ! $active['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $active['id'] = $row['id']; ! $smarty->append("active", $active); } --- 35,39 ---- } while( $row = dbr2() ){ ! $smarty->append("active", $row); } *************** *** 50,59 **** } while( $row = dbr() ){ ! $pending['title'] = $row['prettytitle']; ! $pending['owner'] = ResolveUserID($row['owner'], false); ! $pending['submitted'] = date("m/d/y", $row['submitted']); ! $pending['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $pending['id'] = $row['id']; ! $smarty->append("pending", $pending); } --- 45,49 ---- } while( $row = dbr() ){ ! $smarty->append("pending", $row); } *************** *** 65,74 **** } while( $row = dbr3() ){ ! $progress['title'] = $row['prettytitle']; ! $progress['owner'] = ResolveUserID($row['owner'], false); ! $progress['published'] = date("m/d/y", $row['published']); ! $progress['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $progress['id'] = $row['id']; ! $smarty->append("progress", $progress); } --- 55,59 ---- } while( $row = dbr3() ){ ! $smarty->append("progress", $row); } *************** *** 78,81 **** --- 63,67 ---- //do they have permission to publish it? if( $perm['news'] >= 2 ) { + $time_lock = time(); //lets make sure it isn't a revision db(__FILE__,__LINE__,"SELECT * FROM "._NEWS_." WHERE id='".$_GET['id']."'"); *************** *** 84,96 **** if( $test['revisionof'] == "" ){ //nope! update to be published ! dbn(__FILE__,__LINE__,"UPDATE "._NEWS_." SET published='".time()."' WHERE id='".$_GET['id']."'"); }else { //yep, add new content and delete revision ! dbn(__FILE__,__LINE__,"UPDATE "._NEWS_." SET lastupdate='".time()."', content='".$test['content']."', prettytitle='".$test['prettytitle']."' WHERE id='".$test['revisionof']."'"); dbn(__FILE__,__LINE__,"DELETE FROM "._NEWS_." WHERE id='".$_GET['id']."'"); } Header("Location: "._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Publish</b>", "actioncanceled", true); } --- 70,82 ---- if( $test['revisionof'] == "" ){ //nope! update to be published ! dbn(__FILE__,__LINE__,"UPDATE "._NEWS_." SET published='".$time_lock."', lastupdate=".$time_lock." WHERE id='".$_GET['id']."'"); }else { //yep, add new content and delete revision ! dbn(__FILE__,__LINE__,"UPDATE "._NEWS_." SET lastupdate='".$time_lock."', content='".$test['content']."', prettytitle='".$test['prettytitle']."' WHERE id='".$test['revisionof']."'"); dbn(__FILE__,__LINE__,"DELETE FROM "._NEWS_." WHERE id='".$_GET['id']."'"); } Header("Location: "._AMOD_); } else { ! systemmessage("You do not have permission to <b>Publish</b>"); } *************** *** 103,107 **** Header("Location:"._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Delete</b>", "actioncanceled", true); } --- 89,93 ---- Header("Location:"._AMOD_); } else { ! systemmessage("You do not have permission to <b>Delete</b>"); } *************** *** 114,130 **** Header("Location:"._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Submit</b>", "actioncanceled", true); } }elseif ($_REQUEST['op'] == "read") { db(__FILE__,__LINE__, "SELECT * FROM "._NEWS_." WHERE id='".$_GET['id']."'"); ! $row = dbr(); ! $smarty->assign("read_prettytitle", $row['prettytitle']); ! $smarty->assign("read_author", ResolveUserID($row['owner'],true)); ! $smarty->assign("read_submitted", date("m/d/y", $row['submitted'])); ! $smarty->assign("read_published", date("m/d/y", $row['published'])); ! $smarty->assign("read_updated", date("m/d/y", $row['updated'])); ! $smarty->assign("read_content", $row['content']); ! $smarty->display("news.read.tpl"); }elseif ($_REQUEST['op'] == "remove") { db(__FILE__,__LINE__, "SELECT * FROM "._NEWS_." WHERE id='".$_GET['id']."'"); --- 100,110 ---- Header("Location:"._AMOD_); } else { ! systemmessage("You do not have permission to <b>Submit</b>"); } }elseif ($_REQUEST['op'] == "read") { db(__FILE__,__LINE__, "SELECT * FROM "._NEWS_." WHERE id='".$_GET['id']."'"); ! $smarty->assign("read", dbr()); ! $smarty->display("admin/news.read.tpl"); }elseif ($_REQUEST['op'] == "remove") { db(__FILE__,__LINE__, "SELECT * FROM "._NEWS_." WHERE id='".$_GET['id']."'"); *************** *** 134,138 **** Header("Location:"._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Remove</b>", "actioncanceled", true); } }elseif ($_REQUEST['op'] == "revise") { --- 114,118 ---- Header("Location:"._AMOD_); } else { ! systemmessage("You do not have permission to <b>Remove</b>"); } }elseif ($_REQUEST['op'] == "revise") { *************** *** 143,147 **** Header("Location: "._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Revise</b>", "actioncanceled", true); } }elseif ($_REQUEST['op'] == "add"){ --- 123,127 ---- Header("Location: "._AMOD_); } else { ! systemmessage("You do not have permission to <b>Revise</b>"); } }elseif ($_REQUEST['op'] == "add"){ *************** *** 154,158 **** } } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Add</b>", "actioncanceled", true); } }elseif ($_REQUEST['op'] == "modify"){ --- 134,138 ---- } } else { ! systemmessage("You do not have permission to <b>Add</b>"); } }elseif ($_REQUEST['op'] == "modify"){ *************** *** 169,173 **** } } else{ ! error(__FILE__,__LINE__,"You do not have permission to <b>Modify</b>", "actioncanceled", true); } } --- 149,153 ---- } } else{ ! systemmessage("You do not have permission to <b>Modify</b>"); } } Index: pages.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/pages.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** pages.php 1 Dec 2004 03:31:51 -0000 1.5 --- pages.php 3 Dec 2004 02:06:41 -0000 1.6 *************** *** 90,94 **** //If revision, update that too if( $page['revisionof'] == "" ){ ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET published='".time()."', pending='' WHERE id='".$_GET['id']."'"); }else { dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET lastupdate='".time()."', content='".$page['content']."', prettytitle='".$page['prettytitles']."' Where id='".$page['revisionof']."'"); --- 90,94 ---- //If revision, update that too if( $page['revisionof'] == "" ){ ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET published='".time()."', submitted='' WHERE id='".$_GET['id']."'"); }else { dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET lastupdate='".time()."', content='".$page['content']."', prettytitle='".$page['prettytitles']."' Where id='".$page['revisionof']."'"); *************** *** 148,152 **** if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { //this is special, it takes the pending and publish status off ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET submitted='' published='' WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); } --- 148,152 ---- if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { //this is special, it takes the pending and publish status off ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET submitted='', published='' WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); } *************** *** 187,194 **** } elseif ($_GET['op'] == "onindex"){ //Operation: Put page on Index ! //Special a3 perk if ($perm['pages'] >= 3){ ! //first, a check to see if someone else hasen't played with page order //that could really screw this up --- 187,194 ---- } elseif ($_GET['op'] == "onindex"){ //Operation: Put page on Index ! //Special a3 perk if ($perm['pages'] >= 3){ ! //first, a check to see if someone else hasen't played with page order //that could really screw this up *************** *** 200,218 **** } //no? well then we can initiate our change :P ! ! //zero? if( $_GET['newplace'] == 0 ) { ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='0' WHERE id='".$_GET['id']."'"); dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex - 1 WHERE onindex > '".$_GET['oldplace']."'"); ! } ! //up or down? ! elseif( $_GET['oldplace'] < $_GET['newplace'] ) { ! //up dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex + 1 WHERE onindex <= ".$_GET['newplace']." && onindex > ".$_GET['oldplace']." && id!='".$_GET['id']."'"); } else { ! //down dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex -1 WHERE onindex >= ".$_GET['newplace']." && id!='".$_GET['id']."'"); } header("Location: "._AMOD_); --- 200,216 ---- } //no? well then we can initiate our change :P ! ! //zero?up or down? if( $_GET['newplace'] == 0 ) { ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='0' WHERE id='".$_GET['id']."'"); dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex - 1 WHERE onindex > '".$_GET['oldplace']."'"); ! } elseif( $_GET['oldplace'] < $_GET['newplace'] ) { ! //down dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex-1 WHERE onindex <= ".$_GET['newplace']." && onindex > ".$_GET['oldplace']." && id!='".$_GET['id']."'"); } else { ! //up dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex+1 WHERE onindex >= ".$_GET['newplace']." && id!='".$_GET['id']."'"); } header("Location: "._AMOD_); Index: files.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/files.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** files.php 26 Nov 2004 01:02:25 -0000 1.1 --- files.php 3 Dec 2004 02:06:41 -0000 1.2 *************** *** 52,56 **** //files pending ! db(__FILE__,__LINE__,"SELECT * FROM "._PICS_." WHERE approved='' " . $QueryTag); while( $row = dbr() ){ $smarty->append("pending", $row); --- 52,56 ---- //files pending ! db(__FILE__,__LINE__,"SELECT * FROM "._FILES_." WHERE approved='' " . $QueryTag); while( $row = dbr() ){ $smarty->append("pending", $row); Index: users.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/users.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** users.php 6 Nov 2004 19:09:20 -0000 1.6 --- users.php 3 Dec 2004 02:06:41 -0000 1.7 *************** *** 30,35 **** if ($perm['users'] > 0) { if( $perm['users'] >= 2 ) { ! db(__FILE__,__LINE__,"SELECT * FROM "._USERS_." WHERE id != '1'"); } else { db(__FILE__,__LINE__,"SELECT * FROM "._USERS_." WHERE id='".$user['id']."' && id != '1'"); --- 30,39 ---- if ($perm['users'] > 0) { + if( $_GET['op'] = "filter" ) { + $filter_append = "and username LIKE '".$_POST['fusername']."'"; + } + if( $perm['users'] >= 2 ) { ! db(__FILE__,__LINE__,"SELECT * FROM "._USERS_." WHERE id != '1'".$filter_append); } else { db(__FILE__,__LINE__,"SELECT * FROM "._USERS_." WHERE id='".$user['id']."' && id != '1'"); Index: articles.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/articles.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** articles.php 28 Oct 2004 16:34:34 -0000 1.2 --- articles.php 3 Dec 2004 02:06:41 -0000 1.3 *************** *** 36,40 **** db2(__FILE__,__LINE__,"SSELECT * FROM "._ARTICLES_." WHERE published != '' && owner='".$user['id']."'"); } ! while( $row = dbr2() ){ $active['title'] = $row['prettytitle']; --- 36,40 ---- db2(__FILE__,__LINE__,"SSELECT * FROM "._ARTICLES_." WHERE published != '' && owner='".$user['id']."'"); } ! while( $row = dbr2() ){ $active['title'] = $row['prettytitle']; *************** *** 45,54 **** $smarty->append("active", $active); } ! //select articles in progress if( $perm['articles'] >= 0) { db2(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE published='' && owner='".$user['id']."'"); } ! while( $row = dbr2() ){ $progress['title'] = $row['prettytitle']; --- 45,54 ---- $smarty->append("active", $active); } ! //select articles in progress if( $perm['articles'] >= 0) { db2(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE published='' && owner='".$user['id']."'"); } ! while( $row = dbr2() ){ $progress['title'] = $row['prettytitle']; *************** *** 57,63 **** $smarty->append("progress", $progress); } ! ! ! if( $_GET['op'] == "add") { //do they have permission to add? --- 57,63 ---- $smarty->append("progress", $progress); } ! ! ! if( $_GET['op'] == "add") { //do they have permission to add? *************** *** 70,80 **** } } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Add</b>", "actioncanceled", true); } ! } elseif( $_GET['op'] == "modify") { db(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); $res = dbr(); ! //do they have permission to modify? if( $perm['articles'] > 0 && (($user['id'] == $res['owner']) || ($perm['articles'] >= 2)) ) { --- 70,80 ---- } } else { ! systemmessage("You do not have permission to <b>Add</b>"); } ! } elseif( $_GET['op'] == "modify") { db(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); $res = dbr(); ! //do they have permission to modify? if( $perm['articles'] > 0 && (($user['id'] == $res['owner']) || ($perm['articles'] >= 2)) ) { *************** *** 91,131 **** } } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Modify</b>", "actioncanceled", true); } ! } elseif ($_GET['op']=="publish") { ! if( $perm['articles'] > 0 ) { ! dbn(__FILE__,__LINE__,"UPDATE "._ARTICLES_." SET published='".time()."', lastupdate='' WHERE id='".$_GET['id']."'"); Header("Location: "._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Publish</b>", "actioncanceled", true); } ! } elseif ( $_GET['op'] == "delete" ) { ! db(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE id ='".$_GET['id']."'"); $row = dbr(); ! if( ($perm['articles'] >= 2) || ($row['owner'] == $user['id']) ) { dbn(__FILE__,__LINE__,"DELETE FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Delete</b>", "actioncanceled", true); } ! } elseif ( $_GET['op'] == "read" ){ db(__FILE__,__LINE__, "SELECT * FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); $row = dbr(); ! if( ($perm['articles'] >= 2) || ($row['owner'] == $user['id'])) { ! $smarty->assign("read_prettytitle", $row['prettytitle']); ! $smarty->assign("read_author", ResolveUserID($row['owner'],true)); ! $smarty->assign("read_published", date($lang['articles']['dateformat'], $row['published']) ); ! $smarty->assign("read_updated", date($lang['articles']['dateformat'], $row['lastupdate']) ); ! $smarty->assign("read_content", $row['content'] ); $smarty->display("admin/articles.read.tpl"); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Read</b>", "actioncanceled", true); } } elseif ( $_GET['op'] == "remove" ){ --- 91,128 ---- } } else { ! systemmessage("You do not have permission to <b>Modify</b>"); } ! } elseif ($_GET['op']=="publish") { ! if( $perm['articles'] > 0 ) { ! $time_lock = time(); ! dbn(__FILE__,__LINE__,"UPDATE "._ARTICLES_." SET published='".$time_lock."', lastupdate='$time_lock' WHERE id='".$_GET['id']."'"); Header("Location: "._AMOD_); } else { ! systemmessage("You do not have permission to <b>Publish</b>"); } ! } elseif ( $_GET['op'] == "delete" ) { ! db(__FILE__,__LINE__,"SELECT * FROM "._ARTICLES_." WHERE id ='".$_GET['id']."'"); $row = dbr(); ! if( ($perm['articles'] >= 2) || ($row['owner'] == $user['id']) ) { dbn(__FILE__,__LINE__,"DELETE FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { ! systemmessage("You do not have permission to <b>Delete</b>"); } ! } elseif ( $_GET['op'] == "read" ){ db(__FILE__,__LINE__, "SELECT * FROM "._ARTICLES_." WHERE id='".$_GET['id']."'"); $row = dbr(); ! if( ($perm['articles'] >= 2) || ($row['owner'] == $user['id'])) { ! $smarty->assign("read", $row); $smarty->display("admin/articles.read.tpl"); } else { ! systemmessage("You do not have permission to <b>Read</b>"); } } elseif ( $_GET['op'] == "remove" ){ *************** *** 134,138 **** header("Location: "._AMOD_); } else { ! error(__FILE__,__LINE__,"You do not have permission to <b>Remove</b>", "actioncanceled", true); } } --- 131,135 ---- header("Location: "._AMOD_); } else { ! systemmessage("You do not have permission to <b>Remove</b>"); } } |
|
From: Matt M. <pro...@us...> - 2004-12-03 02:07:07
|
Update of /cvsroot/webschool/webschool/lang/english/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10034/lang/english/admin Modified Files: files.lang.php news.lang.php user.lang.php Log Message: more changes than i can count :) Index: files.lang.php =================================================================== RCS file: /cvsroot/webschool/webschool/lang/english/admin/files.lang.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** files.lang.php 26 Nov 2004 01:02:36 -0000 1.1 --- files.lang.php 3 Dec 2004 02:06:58 -0000 1.2 *************** *** 1,3 **** --- 1,31 ---- <? + $lang['files']['dateformat'] = "m/d/y"; + + $lang['files']['activefiles'] = "Active files"; + $lang['files']['filespending'] = "Pending files"; + $lang['files']['your'] = "Your"; + + $lang['files']['tbtitle'] = "files"; + + $lang['files']['title'] = "Title"; + $lang['files']['owner'] = "Owner"; + $lang['files']['approved'] = "Approved"; + $lang['files']['delete'] = "Delete?"; + $lang['files']['delete_symbol'] = "X"; + $lang['files']['remove'] = "Remove?"; + $lang['files']['remove_symbol'] = "Remove"; + $lang['files']['download'] = "Download"; + $lang['files']['download_symbol'] = "Download"; + $lang['files']['downloads'] = "Downloads"; + $lang['files']['id'] = "ID"; + $lang['files']['description'] = "Description"; + $lang['files']['size'] = "Size"; + $lang['files']['approve'] = "Approve"; + $lang['files']['approve_symbol'] = "Approve"; + $lang['files']['remove'] = "Remove?"; + $lang['files']['remove_symbol'] = "Remove"; + + $lang['files']['addfiles'] = "Add file..."; + Index: news.lang.php =================================================================== RCS file: /cvsroot/webschool/webschool/lang/english/admin/news.lang.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** news.lang.php 6 Nov 2004 01:16:20 -0000 1.5 --- news.lang.php 3 Dec 2004 02:06:58 -0000 1.6 *************** *** 19,22 **** --- 19,23 ---- $lang['news']['remove'] = "Remove?"; $lang['news']['remove_symbol'] = "Remove"; + $lang['news']['read_symbol'] = "Read"; $lang['news']['read'] = "Read"; $lang['news']['publish'] = "Publish"; *************** *** 27,29 **** --- 28,33 ---- $lang['news']['addnews'] = "Add News..."; + $lang['news']['read_author'] = "Author: "; + $lang['news']['read_published'] = "Published: "; + $lang['news']['read_updated'] = "Updated: "; ?> \ No newline at end of file Index: user.lang.php =================================================================== RCS file: /cvsroot/webschool/webschool/lang/english/admin/user.lang.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** user.lang.php 6 Nov 2004 19:09:21 -0000 1.6 --- user.lang.php 3 Dec 2004 02:06:58 -0000 1.7 *************** *** 20,23 **** --- 20,26 ---- $lang['users']['profile_symbol'] = "Edit"; + //words + $lang['users']['filter'] = "Filter"; + //Roles $lang['users']['role'] = "Role"; |
|
From: Matt M. <pro...@us...> - 2004-12-01 03:32:01
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26544/mysql Modified Files: webschool.sql Log Message: Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.58 retrieving revision 1.59 diff -C2 -d -r1.58 -r1.59 *** webschool.sql 28 Nov 2004 22:49:13 -0000 1.58 --- webschool.sql 1 Dec 2004 03:31:51 -0000 1.59 *************** *** 26,30 **** ) TYPE=MyISAM AUTO_INCREMENT=2 ; ! INSERT INTO `table_articles` VALUES (1, 'Introduction to WebSchool', '2', 'I''m working on it.<br /><br />Comming soon.', '1095390146', '1097898346', 0); --- 26,30 ---- ) TYPE=MyISAM AUTO_INCREMENT=2 ; ! INSERT INTO `table_articles` VALUES (1, 'Introduction to WebSchool', 2, 'Im working on it.<br /><br />Comming soon.', '1095390146', '1097898346'); *************** *** 107,114 **** ) 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, ''); 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, --- 107,114 ---- ) 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, ''); 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, *************** *** 117,121 **** `content` longtext NOT NULL default '', PRIMARY KEY (`id`) ! } TYPE=MyISAM AUTO_INCREMENT=0; DROP TABLE IF EXISTS `table_permissions`; --- 117,121 ---- `content` longtext NOT NULL default '', PRIMARY KEY (`id`) ! ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `table_permissions`; |
|
From: Matt M. <pro...@us...> - 2004-12-01 03:32:00
|
Update of /cvsroot/webschool/webschool/theme/templates/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26544/theme/templates/admin Modified Files: pages.tpl Log Message: Index: pages.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/pages.tpl,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** pages.tpl 27 Nov 2004 21:38:40 -0000 1.3 --- pages.tpl 1 Dec 2004 03:31:51 -0000 1.4 *************** *** 36,40 **** {if $perm.pages >= 3} <td> ! <select name="{$active[iv].id}_indexloc" id="{$active[iv].id}_indexloc" onchange="location = '{$AMOD}&op=onindex&id={$active[iv].id}&newplace=' + this.options[this.selectedIndex].value;"> {html_options options=$onindex_options selected=$active[iv].onindex} </select> --- 36,40 ---- {if $perm.pages >= 3} <td> ! <select name="{$active[iv].id}_indexloc" id="{$active[iv].id}_indexloc" onchange="location = '{$AMOD}&op=onindex&id={$active[iv].id}&newplace=' + this.options[this.selectedIndex].value + '&oldplace={$active[iv].onindex}';"> {html_options options=$onindex_options selected=$active[iv].onindex} </select> |
|
From: Matt M. <pro...@us...> - 2004-12-01 03:31:59
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26544/admin Modified Files: pages.php Log Message: Index: pages.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/pages.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** pages.php 27 Nov 2004 21:38:39 -0000 1.4 --- pages.php 1 Dec 2004 03:31:51 -0000 1.5 *************** *** 185,193 **** } } ! } elseif ($GET['op'] == "onindex"){ //Operation: Put page on Index ! //Special a3 perk ! if ($perm['pages'] >= 3){ } } --- 185,221 ---- } } ! } elseif ($_GET['op'] == "onindex"){ //Operation: Put page on Index ! //Special a3 perk + if ($perm['pages'] >= 3){ + + //first, a check to see if someone else hasen't played with page order + //that could really screw this up + db(__FILE__,__LINE__,"SELECT onindex FROM "._PAGES_." WHERE id='".$_GET['id']."'"); + $test = dbr(); + if( $test['onindex'] != $_GET['oldplace'] ) { + //error, error. Someone else made a change + die("Terminated execution. **REPLACE THIS MESSAGE**"); + } + //no? well then we can initiate our change :P + + //zero? + if( $_GET['newplace'] == 0 ) { + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='0' WHERE id='".$_GET['id']."'"); + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex - 1 WHERE onindex > '".$_GET['oldplace']."'"); + } + //up or down? + elseif( $_GET['oldplace'] < $_GET['newplace'] ) { + //up + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex + 1 WHERE onindex <= ".$_GET['newplace']." && onindex > ".$_GET['oldplace']." && id!='".$_GET['id']."'"); + } else { + //down + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='".$_GET['newplace']."' WHERE id='".$_GET['id']."'"); + dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex= onindex -1 WHERE onindex >= ".$_GET['newplace']." && id!='".$_GET['id']."'"); + } + header("Location: "._AMOD_); + //wish i wrote the menu like what is above :P } } |
|
From: Matt M. <pro...@us...> - 2004-12-01 02:52:06
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17096/install Modified Files: install.php step2.php step3.php Log Message: Simple fixes Index: step2.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step2.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** step2.php 28 Oct 2004 16:35:11 -0000 1.7 --- step2.php 1 Dec 2004 02:51:57 -0000 1.8 *************** *** 16,20 **** (license.txt) */ ! if( _InInstall_ ){ $content .= "<center><h2>Setup<h3></center><br>"; chdir(".."); --- 16,21 ---- (license.txt) */ ! ! if( _InIstall_ == 1 ){ $content .= "<center><h2>Setup<h3></center><br>"; chdir(".."); Index: install.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/install.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** install.php 10 Nov 2004 05:15:15 -0000 1.12 --- install.php 1 Dec 2004 02:51:56 -0000 1.13 *************** *** 20,27 **** define("_InIstall_", true); //Make sure that someone is not malliciously trying to install over // an exsisting installation - if (!isset($_COOKIE['install_usr'])){ //They haven't verified yet...so let's do that --- 20,28 ---- define("_InIstall_", true); + //fixes an odd error in my linux distro. + $content = ""; //Make sure that someone is not malliciously trying to install over // an exsisting installation if (!isset($_COOKIE['install_usr'])){ //They haven't verified yet...so let's do that *************** *** 84,88 **** ."<tr><td>2</td><td><b>Setup</b></td></tr>" ."<tr><td>3</td><td><b>Install</b></td></tr>" ! ."<tr><td>4</td><td><b>WebSchool Config(TODO)</b></td></tr>" ."<tr><td>5</td><td><b>Summary (TODO)</b></td></tr>" ."</table>" --- 85,89 ---- ."<tr><td>2</td><td><b>Setup</b></td></tr>" ."<tr><td>3</td><td><b>Install</b></td></tr>" ! ."<tr><td>4</td><td><b>WebSchool Config</b></td></tr>" ."<tr><td>5</td><td><b>Summary (TODO)</b></td></tr>" ."</table>" Index: step3.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step3.php,v retrieving revision 1.26 retrieving revision 1.27 diff -C2 -d -r1.26 -r1.27 *** step3.php 28 Nov 2004 22:47:54 -0000 1.26 --- step3.php 1 Dec 2004 02:51:57 -0000 1.27 *************** *** 20,24 **** DEFINE("_WEBSCHOOLVERSION_", "0.0.6-CVS"); ! if( _InInstall_ && $_REQUEST['installtype'] == "install"){ $content .= "<center><h2>Installation<h3></center><br>" //[From jsvoyager:] I think it looks beter without borders. Feel free to change it back below --- 20,24 ---- DEFINE("_WEBSCHOOLVERSION_", "0.0.6-CVS"); ! if( _InIstall_ && $_REQUEST['installtype'] == "install"){ $content .= "<center><h2>Installation<h3></center><br>" //[From jsvoyager:] I think it looks beter without borders. Feel free to change it back below |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:49:21
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17642/mysql Modified Files: webschool.sql Log Message: Fixed sql conflict Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.57 retrieving revision 1.58 diff -C2 -d -r1.57 -r1.58 *** webschool.sql 28 Nov 2004 22:47:55 -0000 1.57 --- webschool.sql 28 Nov 2004 22:49:13 -0000 1.58 *************** *** 172,181 **** `approved` varchar(25) NOT NULL default '', `downloads` int(11) NOT NULL default '0', - <<<<<<< webschool.sql - `role` enum(`assign_sub`, `assign_attach`, `briefcase`, `general`) NOT NULL default `general`, - ======= `size` int(11) NOT NULL default '0', `category` varchar(255) NOT NULL default '', - >>>>>>> 1.56 PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; --- 172,177 ---- |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:06
|
Update of /cvsroot/webschool/webschool/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/lib Modified Files: db.php Log Message: Started sports aMod Index: db.php =================================================================== RCS file: /cvsroot/webschool/webschool/lib/db.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** db.php 23 Nov 2004 02:29:06 -0000 1.7 --- db.php 28 Nov 2004 22:47:54 -0000 1.8 *************** *** 39,42 **** --- 39,46 ---- DEFINE("_CALENDER_", _db_prefix_."calender"); DEFINE("_FILES_", _db_prefix_."files"); + DEFINE("_SPORTS_", _db_prefix_."sports"); + DEFINE("_SPORTS_GAME_", _db_prefix_."sports_game"); + DEFINE("_SPORTS_ROSTER_", _db_prefix_."sports_roster"); + |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:05
|
Update of /cvsroot/webschool/webschool/lang/english/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/lang/english/admin Added Files: sports.lang.php Log Message: Started sports aMod --- NEW FILE: sports.lang.php --- <? $lang['sports']['sports'] = "Sports"; $lang['sports']['none'] = "No Sports have been added"; $lang['sports']['playername'] = "Player's Name"; $lang['sports']['position'] = "Position"; $lang['sports']['noplayers'] = "No Players have been added to this sport"; $lang['sports']['versus'] = "Versus"; $lang['sports']['date'] = "Date"; $lang['sports']['score'] = "Final Score"; $lang['sports']['noschedule'] = "No Schedule Defined"; $lang['sports']['pictures'] = "Pictures"; $lang['sports']['edit'] = "Edit"; $lang['sports']['nopics'] = "No pictures added to this sport's album"; ?> |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:05
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/admin Modified Files: sports.php Log Message: Started sports aMod Index: sports.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/sports.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** sports.php 6 Nov 2004 19:09:20 -0000 1.3 --- sports.php 28 Nov 2004 22:47:53 -0000 1.4 *************** *** 25,38 **** //assign language file ! include(_fileroot_."/lang/".$config['lang']."/admin/sports.lang.php"); $smarty->assign("lang", $lang); //what? you shouldn't see this page! if($perm['sports'] > 0){ ! ! echo("Started....[jsvoyager:]AND ANCIENT!!!"); } ! ?> \ No newline at end of file --- 25,80 ---- //assign language file ! include(_fileroot_."lang/".$config['lang']."/admin/sports.lang.php"); $smarty->assign("lang", $lang); //what? you shouldn't see this page! if($perm['sports'] > 0){ ! ! ! ////////////////////////////////////// ! // Construct out super-variable ! // "sports" ! ///////////////////////////////////// ! $i=$j=0; ! ! $query = "SELECT * FROM "._SPORTS_; ! db2(__FILE__,__LINE__,$query); ! ! while ($row = dbr2()){ ! $sports[$i]['name'] = $row['name']; ! $sports[$i]['id'] = $row['id']; ! ! //Get the roster ! $query = "SELECT * FROM "._SPORTS_ROSTER_." WHERE sid={$row['id']}"; ! db3(__FILE__,__LINE__,$query); ! ! $j = 0; ! while ($roster = dbr3()){ ! $sports[$i]['roster'][$j]['name'] = $roster['name']; ! $sports[$i]['roster'][$j]['position'] = $roster['position']; ! ! $j++; ! } ! ! //Get the scehdule ! $query = "SELECT * FROM "._SPORTS_GAME_." WHERE sid={$row['id']}"; ! db4(__FILE__,__LINE__,$query); ! ! $j = 0; ! while ($schedule = dbr4()){ ! $sports[$i]['schedule'][$j]['versus'] = $schedule['versus']; ! $sports[$i]['schedule'][$j]['date'] = "Uh....wait a bit"; //Still thinking of a creative way to do this ! $sports[$i]['schedule'][$j]['score'] = $schedule['score']; ! $sports[$i]['schedule'][$j]['id'] = $schedule['id']; ! $sports[$i]['schedule'][$j]['cid'] = $schedule['cid']; ! } ! ! $i++; ! } ! ! $smarty->assign("sports", $sports); } ! $smarty->display("admin/sports.tpl"); ?> \ No newline at end of file |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:05
|
Update of /cvsroot/webschool/webschool/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/install Modified Files: step3.php Log Message: Started sports aMod Index: step3.php =================================================================== RCS file: /cvsroot/webschool/webschool/install/step3.php,v retrieving revision 1.25 retrieving revision 1.26 diff -C2 -d -r1.25 -r1.26 *** step3.php 23 Nov 2004 02:29:06 -0000 1.25 --- step3.php 28 Nov 2004 22:47:54 -0000 1.26 *************** *** 249,252 **** --- 249,255 ---- $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); + $query = eregi_replace("table_sports::roster", $_REQUEST['dbprefix']."sports_roster", $query); + $query = eregi_replace("table_sports::game", $_REQUEST['dbprefix']."sports_game", $query); return $query; } |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:05
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/mysql Modified Files: webschool.sql Log Message: Started sports aMod Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.56 retrieving revision 1.57 diff -C2 -d -r1.56 -r1.57 *** webschool.sql 27 Nov 2004 21:38:40 -0000 1.56 --- webschool.sql 28 Nov 2004 22:47:55 -0000 1.57 *************** *** 82,86 **** `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 '', --- 82,86 ---- `prettytitle` varchar(25) NOT NULL default '', `published` varchar(20) NOT NULL default '', ! `owner` tinyihttp://nyphp.org/content/presentations/GDintro/gd18.phpnt(1) NOT NULL default '0', `content` longtext NOT NULL, `lastupdate` varchar(20) NOT NULL default '', *************** *** 167,177 **** `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 '', `downloads` int(11) NOT NULL default '0', `size` int(11) NOT NULL default '0', `category` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; --- 167,181 ---- `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 '', `approved` varchar(25) NOT NULL default '', `downloads` int(11) NOT NULL default '0', + <<<<<<< webschool.sql + `role` enum(`assign_sub`, `assign_attach`, `briefcase`, `general`) NOT NULL default `general`, + ======= `size` int(11) NOT NULL default '0', `category` varchar(255) NOT NULL default '', + >>>>>>> 1.56 PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; *************** *** 335,336 **** --- 339,365 ---- PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; + + 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`) + ) TYPE=MyISAM ; + + 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 + ) TYPE=MyISAM ; + + 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, + `location` enum('home','away') NOT NULL, + `versus` varchar(20) NOT NULL, + `score` varchar(10) NOT NULL default '-1', #-1 = TBD + PRIMARY KEY (`id`) + ) TYPE=MyISAM ; \ No newline at end of file |
|
From: jsvoyager <jsv...@us...> - 2004-11-28 22:48:05
|
Update of /cvsroot/webschool/webschool/theme/templates/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17312/theme/templates/admin Modified Files: academia.tpl Added Files: sports.tpl Log Message: Started sports aMod Index: academia.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/academia.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** academia.tpl 10 Nov 2004 05:15:16 -0000 1.2 --- academia.tpl 28 Nov 2004 22:47:55 -0000 1.3 *************** *** 84,88 **** </table> ! <!-- Student's Submited Files --> <p class="over-title">{$lang.aca.studfiles}</p> --- 84,92 ---- </table> ! {* ! ************************************ ! * This will be implemented later ! ************************************ ! <!-- Student's Submited Files --> <p class="over-title">{$lang.aca.studfiles}</p> *************** *** 92,96 **** <p class="over-title">{$lang.aca.teachfiles}</p> Hey, guess what...we haven't even started file submiition yet! ! {/if} {include file="tablefoot.tpl"} \ No newline at end of file --- 96,100 ---- <p class="over-title">{$lang.aca.teachfiles}</p> Hey, guess what...we haven't even started file submiition yet! ! *} {/if} {include file="tablefoot.tpl"} \ No newline at end of file --- NEW FILE: sports.tpl --- {include file="tablehead.tpl" tbtitle=$lang.sports.sports} {if $perm.sports <= 0} <p>{$lang.accessdenied}</p> {else} {section name=i loop=$sports} <p class="over-title">{$sports[i].name}</p> <!-- Roster --> <table width="100%" border="0"> <tr class="title"> <td>{$lang.sports.playername}</td> <td>{$lang.sports.position}</td> </tr> {section name=p loop=$sports[i].players} <tr> <td>{$sports[i].players[p].name}</td> <td>{$sports[i].players[p].position}</td> </tr> {sectionelse} <tr><td colspan="2">{$lang.sports.noplayers}</td></tr> {/section} </table> <!-- Schedule --> <table width="100%" border="0"> <tr class="title"> <td>{$lang.sports.versus}</td> <td>{$lang.sports.date}</td> <td>{$lang.sports.location}</td> <td>{$lang.sports.score}</td> </tr> {section name=s loop=$sports[i].schedule} <tr> <td>{$sports[i].schedule[s].versus}</td> <td>{$sports[i].schedule[s].date}</td> <td>{$sports[i].schedule[s].location}</td> <td>{$sports[i].schedule[s].score}</td> </tr> {sectionelse} <tr><td colspan="4">{$lang.sports.noschedule}</td></tr> {/section} </table> <!-- Pictures --> <p class="title">{$lang.sports.pictures}</p> <ul> {section name=pic loop=$sports[i].pics} <li><a href="pic.php?id={$sports[i].pics[pic].id}">{$sports[i].pics[pic].caption}</a> [<a href="admin.php?amod=Pictures&op=modify&id={$sports[i].pics[pic].id}">{$lang.sports.edit}</a>]</li> {sectionelse} <li>{$lang.sports.nopics}</li> {/section} </ul> <br> {sectionelse} <p>{$lang.sports.none}</p> {/section} {/if} {include file="tablefoot.tpl"} |
|
From: Matt M. <pro...@us...> - 2004-11-28 00:24:05
|
Update of /cvsroot/webschool/webschool/theme/templates/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3512/theme/templates/admin Modified Files: pages.tpl Log Message: Index: pages.tpl =================================================================== RCS file: /cvsroot/webschool/webschool/theme/templates/admin/pages.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** pages.tpl 24 Nov 2004 02:54:15 -0000 1.2 --- pages.tpl 27 Nov 2004 21:38:40 -0000 1.3 *************** *** 6,13 **** {$lang.auth_denied} {else} ! <center>{if $perm.articles == 1}{$lang.pages.your} {/if} {$lang.pages.activepages} <center> <table width=100%> ! <tr> <td>{$lang.pages.title}</td> {if $perm.articles >= 2} --- 6,13 ---- {$lang.auth_denied} {else} ! <p class="over-title">{if $perm.articles == 1}{$lang.pages.your} {/if} {$lang.pages.activepages} </p> <table width=100%> ! <tr class="title"> <td>{$lang.pages.title}</td> {if $perm.articles >= 2} *************** *** 25,31 **** <tr> ! <td>{$active[iv].title}</td> ! {if $perm.articles == 2} ! <td>{ResolveUserID ID=$active[iv].owner pretty=true}</td> {/if} <td>{$active[iv].published}</td> --- 25,31 ---- <tr> ! <td><a href="mod.php?mod=pages&name=">{$active[iv].prettytitle}</a></td> ! {if $perm.articles >= 2} ! <td>{ResolveUserID ID=$active[iv].owner pretty="true"}</td> {/if} <td>{$active[iv].published}</td> *************** *** 35,45 **** <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.pages.remove_symbol}</a></td> {if $perm.pages >= 3} ! <td><a href="{$AMOD}&op=onindex&id={active[iv].id}"> ! {if $active[iv].onindex == 0} ! {$lang.pages.onindex_symbol_yes} ! {else} ! {$lang.pages.onindex_symbol_no} ! {/if} ! </a></td> {/if} </tr> --- 35,43 ---- <td><a href="{$AMOD}&op=remove&id={$active[iv].id}">{$lang.pages.remove_symbol}</a></td> {if $perm.pages >= 3} ! <td> ! <select name="{$active[iv].id}_indexloc" id="{$active[iv].id}_indexloc" onchange="location = '{$AMOD}&op=onindex&id={$active[iv].id}&newplace=' + this.options[this.selectedIndex].value;"> ! {html_options options=$onindex_options selected=$active[iv].onindex} ! </select> ! </td> {/if} </tr> |
|
From: Matt M. <pro...@us...> - 2004-11-28 00:10:48
|
Update of /cvsroot/webschool/webschool/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3512/mysql Modified Files: webschool.sql Log Message: Index: webschool.sql =================================================================== RCS file: /cvsroot/webschool/webschool/mysql/webschool.sql,v retrieving revision 1.55 retrieving revision 1.56 diff -C2 -d -r1.55 -r1.56 *** webschool.sql 26 Nov 2004 01:02:34 -0000 1.55 --- webschool.sql 27 Nov 2004 21:38:40 -0000 1.56 *************** *** 96,100 **** `id` int(11) NOT NULL auto_increment, `prettytitle` varchar(35) NOT NULL default '', ! `owner` tinyint(1) NOT NULL default '0', `content` longtext NOT NULL default '', `published` varchar(20) NOT NULL default '', --- 96,101 ---- `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 '', *************** *** 106,110 **** ) 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', 2, ''); DROP TABLE IF EXISTS `table_permissions`; --- 107,121 ---- ) 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, ''); ! ! 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 '', ! PRIMARY KEY (`id`) ! } TYPE=MyISAM AUTO_INCREMENT=0; DROP TABLE IF EXISTS `table_permissions`; |
|
From: Matt M. <pro...@us...> - 2004-11-27 22:28:35
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3512/admin Modified Files: pages.php Log Message: Index: pages.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/pages.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** pages.php 29 Oct 2004 23:08:33 -0000 1.3 --- pages.php 27 Nov 2004 21:38:39 -0000 1.4 *************** *** 31,45 **** if( $perm['pages'] == 1 ){ //Standard User ! //QueryTag(Line) is a little thing to add to the end of all standard user WHERE clauses $QueryTag = " AND owner='" . $user['id'] . "'"; ! } elseif ( $perm['pages'] >= 2 ) { //Admin User ! //No QueryTag for Admin } ! ///////////////////////////// // Get Pages --- 31,45 ---- if( $perm['pages'] == 1 ){ //Standard User ! //QueryTag(Line) is a little thing to add to the end of all standard user WHERE clauses $QueryTag = " AND owner='" . $user['id'] . "'"; ! } elseif ( $perm['pages'] >= 2 ) { //Admin User ! //No QueryTag for Admin } ! ///////////////////////////// // Get Pages *************** *** 48,101 **** // force a page onto the index), but the security assocated with each // var is handeled on the template page. ! //****active pages*** //No need for admin to get other people's pages in progress, so everyone gets only theirs ! db2(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published!='' AND owner='" . $user['id'] . "'"); while( $row = dbr2() ){ ! $active['title'] = $row['prettytitle']; ! $active['owner'] = ResolveUserID($row['owner'], true); ! $active['published'] = date("m/d/y", $row['published']); ! $active['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $active['id'] = $row['id']; ! $progress['onindex'] = $row['onindex']; ! $smarty->append("active", $active); } - //***pending pages*** ! db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published='' && submitted!=''" . $QueryTag); while( $row = dbr() ){ ! $pending['title'] = $row['prettytitle']; ! $pending['owner'] = ResolveUserID($row['owner'], true); ! $pending['published'] = date("m/d/y", $row['published']); ! $pending['submitted'] = date("m/d/y", $row['submitted']); ! $pending['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $pending['id'] = $row['id']; ! $smarty->append("pending", $pending); } //***pages in progress*** ! db3(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published='' && submitted=''" . $QueryTag); while( $row = dbr3() ){ ! $progress['title'] = $row['prettytitle']; ! $progress['owner'] = ResolveUserID($row['owner'], true); ! $progress['published'] = date("m/d/y", $row['published']); ! $progress['lastupdated'] = date("m/d/y",$row['lastupdate']); ! $progress['id'] = $row['id']; ! $smarty->append("progress", $progress); ! } ! ! //////////////////////// ! // My favotire and yours: // The Operations section!!! /////////////////////// ! if($_GET['op'] == "publish") { ! //Operation: Publish Page if( $perm['pages'] >= 2 ) { db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $page = dbr(); ! //If revision, update that too if( $page['revisionof'] == "" ){ --- 48,91 ---- // force a page onto the index), but the security assocated with each // var is handeled on the template page. ! //****active pages*** //No need for admin to get other people's pages in progress, so everyone gets only theirs ! db2(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published!=''". $QueryTag); while( $row = dbr2() ){ ! $smarty->append("active", $row); ! } ! db4(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published!='' and onindex!='0'"); ! $num = affected_rows(); ! $smarty->append("onindex_options", "Not"); ! $i = 1; ! while( $i < $num + 2) { ! $smarty->append("onindex_options", $i ); ! $i++; } //***pending pages*** ! db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published='' && submitted!='' && owner='".$user['id']."' "); while( $row = dbr() ){ ! $smarty->append("pending", $row); } //***pages in progress*** ! db3(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE published='' && submitted='' && owner='".$user['id']."' "); while( $row = dbr3() ){ ! $smarty->append("progress", $row); ! } ! ! //////////////////////// ! // My favotire and yours: // The Operations section!!! /////////////////////// ! if($_GET['op'] == "publish") { ! //Operation: Publish Page if( $perm['pages'] >= 2 ) { db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $page = dbr(); ! //If revision, update that too if( $page['revisionof'] == "" ){ *************** *** 105,109 **** dbn(__FILE__,__LINE__,"DELETE FROM "._PAGES_." WHERE id='".$_GET['id']."'"); } ! //If direct publish (no submit first, ie author is a2 or a3) put in the submit date too if ($page['submitted'] == ""){ --- 95,99 ---- dbn(__FILE__,__LINE__,"DELETE FROM "._PAGES_." WHERE id='".$_GET['id']."'"); } ! //If direct publish (no submit first, ie author is a2 or a3) put in the submit date too if ($page['submitted'] == ""){ *************** *** 115,145 **** } } elseif ($_GET['op'] == "delete") { ! //Operation: Delete Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $page = dbr(); ! if( ($perm['pages'] >= 2) || ($page['owner'] == $user['id']) ) { dbn(__FILE__,__LINE__,"DELETE FROM "._PAGES_." WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); } ! } elseif ( $_GET['op'] == "submit") { ! //Operation: Submit (for review) ! //NOTE: a2 and a3's should NOT be using this opperation (use publish instead). That is why the ! // the if statment below DENIES a2 and 3's access db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] <= 2) && ($test['owner'] == $user['id']) ) { ! dbn(__FILE__,__LINE__, "UPDATE "._PAGES_." SET submitted='".time()."' WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); }; ! } elseif ($_GET['op'] == "read") { ! //Operation: Read Article via Admin Mod db(__FILE__,__LINE__, "SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $row = dbr(); ! $readpage['prettyname'] = $row['prettyname']; $readpage['owner'] = ResolveUserID($row['owner'],true); --- 105,135 ---- } } elseif ($_GET['op'] == "delete") { ! //Operation: Delete Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $page = dbr(); ! if( ($perm['pages'] >= 2) || ($page['owner'] == $user['id']) ) { dbn(__FILE__,__LINE__,"DELETE FROM "._PAGES_." WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); } ! } elseif ( $_GET['op'] == "submit") { ! //Operation: Submit (for review) ! //NOTE: a2 and a3's should NOT be using this opperation (use publish instead). That is why the ! // the if statment below DENIES a2 and 3's access db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] <= 2) && ($test['owner'] == $user['id']) ) { ! dbn(__FILE__,__LINE__, "UPDATE "._PAGES_." SET submitted='".time()."' WHERE id='".$_GET['id']."'"); Header("Location:"._AMOD_); } else { die(); }; ! } elseif ($_GET['op'] == "read") { ! //Operation: Read Article via Admin Mod db(__FILE__,__LINE__, "SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $row = dbr(); ! $readpage['prettyname'] = $row['prettyname']; $readpage['owner'] = ResolveUserID($row['owner'],true); *************** *** 150,159 **** $smarty->assign("readpage", $readpage); $smarty->display("admin/pages.read.tpl"); ! }elseif( $_GET['op'] == "remove") { ! //Operation: Remove (ie, de-publish) page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { //this is special, it takes the pending and publish status off --- 140,149 ---- $smarty->assign("readpage", $readpage); $smarty->display("admin/pages.read.tpl"); ! }elseif( $_GET['op'] == "remove") { ! //Operation: Remove (ie, de-publish) page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { //this is special, it takes the pending and publish status off *************** *** 162,169 **** } else { die(); } }elseif($_GET['op'] == "revise") { ! //Operation: Revise Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { db(__FILE__,__LINE__, "SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); --- 152,159 ---- } else { die(); } }elseif($_GET['op'] == "revise") { ! //Operation: Revise Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id ='".$_GET['id']."'"); $test = dbr(); ! if( ($perm['pages'] >= 2) || ($test['owner'] == $user['id']) ) { db(__FILE__,__LINE__, "SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); *************** *** 173,177 **** } else { die(); } } elseif ( $_GET['op'] == "add" ){ ! //Operation: Add Page if( !isset($_POST['add']) ) { $smarty->display("admin/pages.add.tpl"); --- 163,167 ---- } else { die(); } } elseif ( $_GET['op'] == "add" ){ ! //Operation: Add Page if( !isset($_POST['add']) ) { $smarty->display("admin/pages.add.tpl"); *************** *** 181,188 **** } } elseif ( $_GET['op'] == "modify" ){ ! //Operation: Modify Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $res = dbr(); ! if( ($user['id'] == $res['owner']) || ($perm['pages'] >= 2)) { if( !isset($_POST['add']) ) { --- 171,178 ---- } } elseif ( $_GET['op'] == "modify" ){ ! //Operation: Modify Page db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id='".$_GET['id']."'"); $res = dbr(); ! if( ($user['id'] == $res['owner']) || ($perm['pages'] >= 2)) { if( !isset($_POST['add']) ) { *************** *** 196,209 **** } } elseif ($GET['op'] == "onindex"){ ! //Operation: Put page on Index //Special a3 perk if ($perm['pages'] >= 3){ ! db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE id='" . $_REQUEST['id'] . "'"); ! $page = drb(); ! $onindex = ($page['onindex'] == 1)?("0"):("1"); ! dbn(__FILE__,__LINE__,"UPDATE "._PAGES_." SET onindex='" . $onindex . "' WHERE id='" . $_REQUEST['id'] . "'"); } } } ! $smarty->display("admin/news.tpl"); ?> \ No newline at end of file --- 186,196 ---- } } elseif ($GET['op'] == "onindex"){ ! //Operation: Put page on Index //Special a3 perk if ($perm['pages'] >= 3){ ! } } } ! $smarty->display("admin/pages.tpl"); ?> \ No newline at end of file |
|
From: Matt M. <pro...@us...> - 2004-11-27 21:38:49
|
Update of /cvsroot/webschool/webschool/lang/english/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3512/lang/english/admin Modified Files: pages.lang.php Log Message: Index: pages.lang.php =================================================================== RCS file: /cvsroot/webschool/webschool/lang/english/admin/pages.lang.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** pages.lang.php 24 Oct 2004 03:36:35 -0000 1.4 --- pages.lang.php 27 Nov 2004 21:38:39 -0000 1.5 *************** *** 1,37 **** <? - //////////////////////////////////////////////////////////////////////////////////////////// - //[from jsvoyager:] Why do these all say ['news'] and not ['pages']? But it works... hun// - /////////////////////////////////////////////////////////////////////////////////////////// ! $lang['news']['dateformat'] = "m/d/y"; ! $lang['news']['activenews'] = "Active Pages"; ! $lang['news']['newsprogress'] = "Pages-In-Progress"; ! $lang['news']['newspending'] = "Pending Pages"; ! $lang['news']['your'] = "Your"; ! $lang['news']['tbtitle'] = "Pages"; ! $lang['news']['title'] = "Title"; ! $lang['news']['owner'] = "Owner"; ! $lang['news']['published'] = "Published"; ! $lang['news']['submitted'] = "Submitted"; ! $lang['news']['updated'] = "Updated"; ! $lang['news']['delete'] = "Delete?"; ! $lang['news']['delete_symbol'] = "X"; ! $lang['news']['modify'] = "Modify"; ! $lang['news']['modify_symbol'] = "Modify"; ! $lang['news']['remove'] = "Remove?"; ! $lang['news']['remove_symbol'] = "Remove"; ! $lang['news']['read'] = "Read"; ! $lang['news']['publish'] = "Publish"; ! $lang['news']['publish_symbol'] = "Publish"; ! $lang['news']['submit'] = "Submit"; ! $lang['news']['submit_symbol'] = "Submit"; ! $lang['news']['onindex'] = "Put On Index?"; ! $lang['news']['onindex_symbol_yes'] = "Yes"; ! $lang['news']['onindex_symbol_no'] = "No"; ! $lang['news']['addnews'] = "Add Page..."; ?> \ No newline at end of file --- 1,32 ---- <? ! $lang['pages']['dateformat'] = "m/d/y"; ! $lang['pages']['activepages'] = "Active pages"; ! $lang['pages']['pagesprogress'] = "pages-In-Progress"; ! $lang['pages']['pagespending'] = "Pending pages"; ! $lang['pages']['your'] = "Your"; ! $lang['pages']['tbtitle'] = "pages"; ! $lang['pages']['title'] = "Title"; ! $lang['pages']['owner'] = "Owner"; ! $lang['pages']['published'] = "Published"; ! $lang['pages']['submitted'] = "Submitted"; ! $lang['pages']['updated'] = "Updated"; ! $lang['pages']['delete'] = "Delete?"; ! $lang['pages']['delete_symbol'] = "X"; ! $lang['pages']['modify'] = "Modify"; ! $lang['pages']['modify_symbol'] = "Modify"; ! $lang['pages']['remove'] = "Remove?"; ! $lang['pages']['remove_symbol'] = "Remove"; ! $lang['pages']['read'] = "Read"; ! $lang['pages']['publish'] = "Publish"; ! $lang['pages']['publish_symbol'] = "Publish"; ! $lang['pages']['submit'] = "Submit"; ! $lang['pages']['submit_symbol'] = "Submit"; ! $lang['pages']['onindex'] = "OnIndex"; ! $lang['pages']['addpages'] = "Add Page..."; ?> \ No newline at end of file |
|
From: Matt M. <pro...@us...> - 2004-11-26 01:03:17
|
Update of /cvsroot/webschool/webschool/admin/images In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10259/admin/images Modified Files: Thumbs.db Added Files: files.panel.jpeg modules.panel.jpeg Log Message: Index: Thumbs.db =================================================================== RCS file: /cvsroot/webschool/webschool/admin/images/Thumbs.db,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 Binary files /tmp/cvs3a5sbb and /tmp/cvsNeMkP2 differ --- NEW FILE: files.panel.jpeg --- (This appears to be a binary file; contents omitted.) --- NEW FILE: modules.panel.jpeg --- (This appears to be a binary file; contents omitted.) |
|
From: Matt M. <pro...@us...> - 2004-11-26 01:03:16
|
Update of /cvsroot/webschool/webschool In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10259 Modified Files: index.php Log Message: Index: index.php =================================================================== RCS file: /cvsroot/webschool/webschool/index.php,v retrieving revision 1.28 retrieving revision 1.29 diff -C2 -d -r1.28 -r1.29 *** index.php 23 Nov 2004 01:24:01 -0000 1.28 --- index.php 26 Nov 2004 01:02:34 -0000 1.29 *************** *** 25,38 **** db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE onindex!='0' ORDER BY onindex DESC "); while ($row = dbr()) { ! $pages_title[] = $row['prettytitle']; ! $pages_content[] = $row['content']; ! $pages_owner[] = $row['owner']; ! $pages_lastupdate[] = $row['lastupdate']; ! } - $smarty->assign("pages_title", $pages_title); - $smarty->assign("pages_content", $pages_content); - $smarty->assign("pages_owner", $pages_owner); - $smarty->assign("pages_lastupdate", $pages_lastupdate); //recent news --- 25,30 ---- db(__FILE__,__LINE__,"SELECT * FROM "._PAGES_." WHERE onindex!='0' ORDER BY onindex DESC "); while ($row = dbr()) { ! $smarty->append("onindex", $row); } //recent news |
|
From: Matt M. <pro...@us...> - 2004-11-26 01:03:15
|
Update of /cvsroot/webschool/webschool/lang/english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10259/lang/english Modified Files: lang.php Log Message: Index: lang.php =================================================================== RCS file: /cvsroot/webschool/webschool/lang/english/lang.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** lang.php 23 Nov 2004 01:24:02 -0000 1.6 --- lang.php 26 Nov 2004 01:02:34 -0000 1.7 *************** *** 44,46 **** --- 44,53 ---- $lang['copyright'] = "is copyright individual authors"; + //menulang + $lang['menu']['caption'] = "Caption"; + $lang['menu']['logout'] = "Logout"; + $lang['menu']['login'] = "Login"; + $lang['menu']['username'] = "Username"; + $lang['menu']['password'] = "Password"; + $lang['menu']['welcome'] = "Welcome"; ?> \ No newline at end of file |
|
From: Matt M. <pro...@us...> - 2004-11-26 01:03:06
|
Update of /cvsroot/webschool/webschool/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10259/admin Modified Files: config.php Added Files: files.php Log Message: --- NEW FILE: files.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) */ if( !defined("_AUTHLOADED_") ){ die(); } define("_AMOD_", "admin.php?amod=Files"); $smarty->assign("AMOD", "admin.php?amod=Files"); include(_fileroot_."/lang/".$config['lang']."/admin/files.lang.php"); $smarty->assign("lang", $lang); if($perm > 0){ if($perm['files'] >= 2) { //admin user //No QueryTag } elseif($perm['files'] == 1) { //standard user //QueryTag is additional information $QueryTag = " AND owner='" . $user['id'] . "'"; } ///////////////////////////////// // Get Info FROM Database //////////////////////////////// //active files db2(__FILE__,__LINE__,"SELECT * FROM "._FILES_." WHERE approved!=''" . $QueryTag); while( $row = dbr2() ){ $smarty->append("active", $row); } //files pending db(__FILE__,__LINE__,"SELECT * FROM "._PICS_." WHERE approved='' " . $QueryTag); while( $row = dbr() ){ $smarty->append("pending", $row); } ////////////////////////////// // My favorite and yours: // The giant structure to figure out // what they want to do!!! ///////////////////////////// if( $_GET['op'] == "add" ){ //Operation: Add Picture if( !isset($_GET['upload']) ){ $smarty->display("admin/pictures.add.tpl"); } else { //make sure the picture follows the rules if ( $_FILES['file']['size'] <= $config['file_maxsize'] && trim($_POST['filename']) != "" && $_FILES['file']['size'] > 0) { //assign a name with the name they assigned with a number between 111&999999. Prevents linking by making a huge number they would have to guess, and reduces collisions $filename = $user['username'].".".$_POST['filename']."-".rand(111,9999999); //copy the file to the filename we just made copy($_FILES['file']['tmp_name'], _fileroot_."files/".$filename); //get info about the image (height/width) $info = getimagesize(_fileroot_."files/".$filename); //update db dbn(__FILE__,__LINE__,"INSERT INTO "._FILES_." SET owner='".$user['id']."', description='".$_POST['descrip']."', name='".$_POST['picname']."', filename='".$filename."', type='".$_FILES['pic']['type']."', approved='0', views='0', x='".$info[0]."', y='".$info[1]."', size='".$_FILES['pic']['size']."'"); //Header("Location: "._AMOD_); } else { systemmessage("Upload Unsucessful"); } } }elseif( $_GET['op'] == "approve" ) { //Operation: Approve Picture if( $perm['pictures'] >= 2 ) { dbn(__FILE__,__LINE__,"UPDATE "._FILES_." SET approved='".time()."' WHERE id='".$_GET['id']."'"); header("Location: "._AMOD_); }else{ die(); } }elseif( $_GET['op'] == "remove" ) { dbn(__FILE__,__LINE__,"UPDATE "._FILES_." SET approved='' WHERE id='".$_GET['id']."'"); header("Location: "._AMOD_); }elseif( $_GET['op'] == "delete" ) { //Operation: Delete Picture if( $perm['pictures'] >= 2 ) { db(__FILE__,__LINE__,"SELECT filename FROM "._FILES_." WHERE id='".$_GET['id']."'"); $res = dbr(); unlink(_fileroot_."images/".$res['filename']); dbn(__FILE__,__LINE__,"DELETE FROM "._FILES_." WHERE id='".$_GET['id']."'"); header("Location: "._AMOD_); } } } $smarty->display("admin/files.tpl"); ?> Index: config.php =================================================================== RCS file: /cvsroot/webschool/webschool/admin/config.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** config.php 24 Nov 2004 02:54:12 -0000 1.4 --- config.php 26 Nov 2004 01:02:25 -0000 1.5 *************** *** 40,43 **** --- 40,53 ---- $smarty->assign("fileroot", _fileroot_); + if ($handle = opendir(_fileroot_."lang/")) { + while (false !== ( $item = readdir($handle) ) ) { + + if( is_dir(_fileroot_."lang/".$item) && $item != "." && $item != "..") { + $smarty->append("langs", $item); + echo $item; + } + } + } + db(__FILE__,__LINE__, "SELECT * FROM "._CONFIG_); *************** *** 68,75 **** if (fwrite($handle, $configfile) == false) { $content .= "<font color=red>Failed</font>"; - $configwritable =false; } else { $content .= "<font color=green>Success</font>"; - $configwritable=true; } header("Location: "._AMOD_); --- 78,83 ---- |
|
From: Matt M. <pro...@us...> - 2004-11-26 01:02:48
|
Update of /cvsroot/webschool/webschool/lang/english/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10259/lang/english/admin Added Files: files.lang.php Log Message: --- NEW FILE: files.lang.php --- <? ?> |
