phpwebapp-commits Mailing List for phpWebApp (Page 21)
Brought to you by:
dashohoxha
You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(15) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(2) |
Feb
|
Mar
|
Apr
(5) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2003 |
Jan
|
Feb
(43) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
(194) |
Sep
(60) |
Oct
(6) |
Nov
|
Dec
(16) |
2004 |
Jan
(73) |
Feb
(13) |
Mar
(5) |
Apr
|
May
(5) |
Jun
|
Jul
(183) |
Aug
|
Sep
(5) |
Oct
(30) |
Nov
|
Dec
|
2005 |
Jan
|
Feb
|
Mar
|
Apr
(9) |
May
(1) |
Jun
(35) |
Jul
(17) |
Aug
(2) |
Sep
(6) |
Oct
(19) |
Nov
(108) |
Dec
|
2006 |
Jan
(10) |
Feb
(1) |
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Dashamir H. <das...@us...> - 2004-01-13 14:30:29
|
Update of /cvsroot/phpwebapp/top10/templates/admin/users In directory sc8-pr-cvs1:/tmp/cvs-serv19152/templates/admin/users Log Message: Directory /cvsroot/phpwebapp/top10/templates/admin/users added to the repository --> Using per-directory sticky tag `maisp' |
From: Dashamir H. <das...@us...> - 2004-01-13 14:30:29
|
Update of /cvsroot/phpwebapp/top10/templates/admin/modify In directory sc8-pr-cvs1:/tmp/cvs-serv19152/templates/admin/modify Log Message: Directory /cvsroot/phpwebapp/top10/templates/admin/modify added to the repository --> Using per-directory sticky tag `maisp' |
From: Dashamir H. <das...@us...> - 2004-01-13 14:13:55
|
Update of /cvsroot/phpwebapp/top10/templates/proj_list/filter In directory sc8-pr-cvs1:/tmp/cvs-serv15147/templates/proj_list/filter Modified Files: Tag: maisp filter.html Log Message: Index: filter.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_list/filter/filter.html,v retrieving revision 1.3 retrieving revision 1.3.2.1 diff -C2 -d -r1.3 -r1.3.2.1 *** filter.html 2 Oct 2003 07:09:40 -0000 1.3 --- filter.html 13 Jan 2004 14:13:50 -0000 1.3.2.1 *************** *** 4,54 **** <form name="filter" onsubmit="return false;"> <tr> - <td align="right">Language:</td> - <td> - <WebObject Class="listbox" Name="language" - width="------" - onchange="set_language(this)" /> - </td> - <td align="right">License:</td> - <td> - <WebObject Class="listbox" Name="license" - width="------" - onchange="set_license(this)" /> - </td> - <td align="right">Search:</td> <td> ! <input type="text" size="10" ! name="search_term" value="{{search_term}}" ! onblur="set_search_term(this)"> ! </td> ! <td align="right">Category:</td> ! <td> ! <WebObject Class="listbox" Name="category" ! onchange="set_category(this)" /> ! </td> ! <td align="right">Order by:</td> ! <td> ! <select onchange="set_order(this)"> ! <option value="points" {{points_selected}}> ! Number of Points ! </option> ! <option value="nr_comments" {{nr_comments_selected}}> ! Nr of Comments ! </option> ! <option value="proj_id" {{proj_id_selected}}> ! SF id (alphabetically) ! </option> ! <option value="register_date" {{register_date_selected}}> ! SF Register Date ! </option> ! </select> ! </td> ! <td> ! <If condition="'{{ADMIN}}'=='true'"> ! New:<input type="checkbox" {{new_checked}} onclick="set_new(this)"> ! </If> </td> <td> ! <a class="button" href="javascript:SendEvent('filter','refresh')">Refresh</a> </td> </tr> --- 4,68 ---- <form name="filter" onsubmit="return false;"> <tr> <td> ! <table width="100%" border="0" cellspacing="0" cellpading="0"> ! <tr> ! <td align="right">Category:</td> ! <td> ! <WebObject Class="listbox" Name="category" ! onchange="set_category(this)" /> ! </td> ! <td align="right">License:</td> ! <td> ! <WebObject Class="listbox" Name="license" ! width="------" ! onchange="set_license(this)" /> ! </td> ! <td align="right">Language:</td> ! <td> ! <WebObject Class="listbox" Name="language" ! width="------" ! onchange="set_language(this)" /> ! </td> ! </tr> ! </table> </td> + </tr> + <tr> <td> ! <table width="100%" border="0" cellspacing="0" cellpading="0"> ! <tr> ! <td align="right">Search:</td> ! <td> ! <input type="text" size="10" ! name="search_term" value="{{search_term}}" ! onblur="set_search_term(this)"> ! </td> ! <td align="right">Order by:</td> ! <td> ! <select onchange="set_order(this)"> ! <option value="points" {{points_selected}}> ! Number of Points ! </option> ! <option value="nr_comments" {{nr_comments_selected}}> ! Nr of Comments ! </option> ! <option value="proj_id" {{proj_id_selected}}> ! Project id ! </option> ! <option value="register_date" {{register_date_selected}}> ! Register Date ! </option> ! </select> ! </td> ! <td> ! <If condition="'{{ADMIN}}'=='true'"> ! New:<input type="checkbox" {{new_checked}} onclick="set_new(this)"> ! </If> ! </td> ! <td> ! <a class="button" href="javascript:SendEvent('filter','refresh')">Refresh</a> ! </td> ! </tr> ! </table> </td> </tr> |
From: Dashamir H. <das...@us...> - 2004-01-13 14:13:53
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv15147/docs Modified Files: Tag: maisp ToDo.txt Log Message: Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.12.2.4 retrieving revision 1.12.2.5 diff -C2 -d -r1.12.2.4 -r1.12.2.5 *** ToDo.txt 12 Jan 2004 15:43:55 -0000 1.12.2.4 --- ToDo.txt 13 Jan 2004 14:13:50 -0000 1.12.2.5 *************** *** 8,12 **** the category with a listbox. ! - Improve the look of the filters. - For each developper add also his e-mail address. Each developper --- 8,15 ---- the category with a listbox. ! + Improve the look of the filters. ! ! - At the preference list display also the user details (name, email etc.) ! if the user wants to make them public. - For each developper add also his e-mail address. Each developper *************** *** 19,25 **** remove them, change their data(email), etc. - - At the preference list display also the user details (name, email etc.) - if the user wants to make them public. - - A user that is not registered yet as an evaluator can do so at the time that he tries to save his preference list. His registration should --- 22,25 ---- |
From: Dashamir H. <das...@us...> - 2004-01-12 15:45:31
|
Update of /cvsroot/phpwebapp/top10/templates/edit_project In directory sc8-pr-cvs1:/tmp/cvs-serv2760/templates/edit_project Modified Files: Tag: maisp edit_project.html Log Message: Index: edit_project.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.html,v retrieving revision 1.4.2.3 retrieving revision 1.4.2.4 diff -C2 -d -r1.4.2.3 -r1.4.2.4 *** edit_project.html 12 Jan 2004 15:43:55 -0000 1.4.2.3 --- edit_project.html 12 Jan 2004 15:45:24 -0000 1.4.2.4 *************** *** 66,73 **** <td bgcolor="eeeeee">License:</td> <td bgcolor="#ffffff"> - <!--# - <input type="text" size="70" name="license" value="{{license}}" - onfocus="select()"> - #--> <WebObject Class="listbox" Name="license" value="{{license}}" /> </td> --- 66,69 ---- *************** *** 76,82 **** <td bgcolor="eeeeee">Language:</td> <td bgcolor="#ffffff"> - <!--# - <input type="text" size="30" name="prog_lang" value="{{prog_lang}}"> - #--> <WebObject Class="listbox" Name="prog_lang" value="{{prog_lang}}" /> </td> --- 72,75 ---- *************** *** 85,92 **** <td bgcolor="eeeeee">Category:</td> <td bgcolor="#ffffff"> - <!--# - <input type="text" size="70" name="category" value="{{category}}" - onfocus="select()"> - #--> <WebObject Class="listbox" Name="category" value="{{category}}" /> </td> --- 78,81 ---- |
From: Dashamir H. <das...@us...> - 2004-01-12 15:43:58
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv2399/docs Modified Files: Tag: maisp ToDo.txt Log Message: When editing a project, select the license, the language and the category with a listbox. Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.12.2.3 retrieving revision 1.12.2.4 diff -C2 -d -r1.12.2.3 -r1.12.2.4 *** ToDo.txt 12 Jan 2004 15:21:26 -0000 1.12.2.3 --- ToDo.txt 12 Jan 2004 15:43:55 -0000 1.12.2.4 *************** *** 5,9 **** he should supply his e-mail address (instead of the username). ! - When editing a project, select the license, the language and the category with a listbox. --- 5,9 ---- he should supply his e-mail address (instead of the username). ! + When editing a project, select the license, the language and the category with a listbox. |
From: Dashamir H. <das...@us...> - 2004-01-12 15:43:58
|
Update of /cvsroot/phpwebapp/top10/templates/edit_project In directory sc8-pr-cvs1:/tmp/cvs-serv2399/templates/edit_project Modified Files: Tag: maisp edit_project.html edit_project.db Log Message: When editing a project, select the license, the language and the category with a listbox. Index: edit_project.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.html,v retrieving revision 1.4.2.2 retrieving revision 1.4.2.3 diff -C2 -d -r1.4.2.2 -r1.4.2.3 *** edit_project.html 12 Jan 2004 15:21:26 -0000 1.4.2.2 --- edit_project.html 12 Jan 2004 15:43:55 -0000 1.4.2.3 *************** *** 1,2 **** --- 1,4 ---- + <Include SRC="{{LISTBOX_PATH}}listbox.html" /> + <WebBox ID="edit_project"> <If condition="'{{mode}}'=='add'"> *************** *** 64,69 **** --- 66,74 ---- <td bgcolor="eeeeee">License:</td> <td bgcolor="#ffffff"> + <!--# <input type="text" size="70" name="license" value="{{license}}" onfocus="select()"> + #--> + <WebObject Class="listbox" Name="license" value="{{license}}" /> </td> </tr> *************** *** 71,75 **** --- 76,83 ---- <td bgcolor="eeeeee">Language:</td> <td bgcolor="#ffffff"> + <!--# <input type="text" size="30" name="prog_lang" value="{{prog_lang}}"> + #--> + <WebObject Class="listbox" Name="prog_lang" value="{{prog_lang}}" /> </td> </tr> *************** *** 77,82 **** --- 85,93 ---- <td bgcolor="eeeeee">Category:</td> <td bgcolor="#ffffff"> + <!--# <input type="text" size="70" name="category" value="{{category}}" onfocus="select()"> + #--> + <WebObject Class="listbox" Name="category" value="{{category}}" /> </td> </tr> Index: edit_project.db =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.db,v retrieving revision 1.4.2.1 retrieving revision 1.4.2.2 diff -C2 -d -r1.4.2.1 -r1.4.2.2 *** edit_project.db 9 Jan 2004 16:32:37 -0000 1.4.2.1 --- edit_project.db 12 Jan 2004 15:43:55 -0000 1.4.2.2 *************** *** 1,4 **** --- 1,23 ---- <!--# -*-SQL-*- #tell emacs to use SQL mode #--> + <Recordset ID="listbox::license"> + <Query> + SELECT license AS id, license AS label + FROM licenses + </Query> + </Recordset> + <Recordset ID="listbox::prog_lang"> + <Query> + SELECT prog_lang AS id, prog_lang AS label + FROM languages + </Query> + </Recordset> + <Recordset ID="listbox::category"> + <Query> + SELECT category AS id, category AS label + FROM categories + </Query> + </Recordset> + <Recordset ID="get_project"> <Query> |
From: Dashamir H. <das...@us...> - 2004-01-12 15:21:29
|
Update of /cvsroot/phpwebapp/top10/templates/edit_project In directory sc8-pr-cvs1:/tmp/cvs-serv28891/templates/edit_project Modified Files: Tag: maisp edit_project.php edit_project.js edit_project.html Log Message: Index: edit_project.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.php,v retrieving revision 1.5.2.1 retrieving revision 1.5.2.2 diff -C2 -d -r1.5.2.1 -r1.5.2.2 *** edit_project.php 9 Jan 2004 16:32:37 -0000 1.5.2.1 --- edit_project.php 12 Jan 2004 15:21:26 -0000 1.5.2.2 *************** *** 38,44 **** if (!$rs->EOF()) //there is another project with this id { ! $msg = "Another project with unix name '$proj_id' is already " . "registered.\n" ! . "Please change the unix name of the project, or, if you think " . "that there is \n" . "something wrong, contact the admin at '".ADMIN_EMAIL."'."; --- 38,44 ---- if (!$rs->EOF()) //there is another project with this id { ! $msg = "Another project with id '$proj_id' is already " . "registered.\n" ! . "Please change the id of the project, or, if you think " . "that there is \n" . "something wrong, contact the admin at '".ADMIN_EMAIL."'."; *************** *** 122,127 **** //send a notification e-mail to the user ! $to = "dasho"; ! //$to = $email; $subject = "Top10: Modify Project '$proj_id'"; $admin_mail = ADMIN_EMAIL; --- 122,127 ---- //send a notification e-mail to the user ! //$to = "dasho"; ! $to = $email; $subject = "Top10: Modify Project '$proj_id'"; $admin_mail = ADMIN_EMAIL; Index: edit_project.js =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.js,v retrieving revision 1.3 retrieving revision 1.3.2.1 diff -C2 -d -r1.3 -r1.3.2.1 *** edit_project.js 2 Oct 2003 07:09:40 -0000 1.3 --- edit_project.js 12 Jan 2004 15:21:26 -0000 1.3.2.1 *************** *** 49,55 **** function done_editing() { ! var msg = "This project will be added in the list\n" ! + "after it is approved by the admin.\n" ! + "You will not be able to modify it anymore."; if (!confirm(msg)) return; --- 49,55 ---- function done_editing() { ! var msg = "You will not be able to modify this project anymore.\n" ! + "If you are creating it for the first time, it will be added\n" ! + "in the list only after it is approved by the admin."; if (!confirm(msg)) return; *************** *** 70,73 **** --- 70,74 ---- { elem = form.elements[i]; + if (elem.name=='url2') continue; //this field can be empty if (elem.value=='') { Index: edit_project.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.html,v retrieving revision 1.4.2.1 retrieving revision 1.4.2.2 diff -C2 -d -r1.4.2.1 -r1.4.2.2 *** edit_project.html 9 Jan 2004 16:32:37 -0000 1.4.2.1 --- edit_project.html 12 Jan 2004 15:21:26 -0000 1.4.2.2 *************** *** 12,16 **** <table cellspacing="1" cellpadding="2" bgcolor="#dddddd"> <tr> ! <td bgcolor="eeeeee">Project Unix Name:</td> <td bgcolor="#ffffff"> <If condition="'{{mode}}'=='add'"> --- 12,16 ---- <table cellspacing="1" cellpadding="2" bgcolor="#dddddd"> <tr> ! <td bgcolor="eeeeee">Project ID:</td> <td bgcolor="#ffffff"> <If condition="'{{mode}}'=='add'"> |
From: Dashamir H. <das...@us...> - 2004-01-12 15:21:29
|
Update of /cvsroot/phpwebapp/top10/templates/proj_details In directory sc8-pr-cvs1:/tmp/cvs-serv28891/templates/proj_details Modified Files: Tag: maisp proj_details.html header.html Log Message: Index: proj_details.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/proj_details.html,v retrieving revision 1.4.2.1 retrieving revision 1.4.2.2 diff -C2 -d -r1.4.2.1 -r1.4.2.2 *** proj_details.html 9 Jan 2004 16:32:37 -0000 1.4.2.1 --- proj_details.html 12 Jan 2004 15:21:26 -0000 1.4.2.2 *************** *** 42,50 **** <tr> <td bgcolor="eeeeee">URL1:</td> ! <td bgcolor="#ffffff">{{url1}}</td> </tr> <tr> <td bgcolor="eeeeee">URL2:</td> ! <td bgcolor="#ffffff">{{url2}}</td> </tr> </table> --- 42,54 ---- <tr> <td bgcolor="eeeeee">URL1:</td> ! <td bgcolor="#ffffff"> ! <a href="{{url1}}" target="_blank">{{url1}}</a> ! </td> </tr> <tr> <td bgcolor="eeeeee">URL2:</td> ! <td bgcolor="#ffffff"> ! <a href="{{url2}}" target="_blank">{{url2}}</a> ! </td> </tr> </table> Index: header.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/header.html,v retrieving revision 1.2 retrieving revision 1.2.2.1 diff -C2 -d -r1.2 -r1.2.2.1 *** header.html 30 Sep 2003 06:59:29 -0000 1.2 --- header.html 12 Jan 2004 15:21:26 -0000 1.2.2.1 *************** *** 10,14 **** <If condition="'{{proj_id}}'<>'UNDEFINED'"> <td> ! <h2>Project: <a href="http://sourceforge.net/projects/{{proj_id}}" target="_blank">{{proj_name}}</a></h2> </td> </If> --- 10,14 ---- <If condition="'{{proj_id}}'<>'UNDEFINED'"> <td> ! <h2>Project: <a href="{{url1}}" target="_blank">{{proj_name}}</a></h2> </td> </If> *************** *** 16,20 **** <td align="right" valign="bottom" nowrap> <form name="change" onsubmit="change_project(); return false;"> ! Project unix name: <input id="proj_id" type="text" size="15" value="{{proj_id}}"> <a class="button" href="javascript:change_project()">Change</a> --- 16,20 ---- <td align="right" valign="bottom" nowrap> <form name="change" onsubmit="change_project(); return false;"> ! Project id: <input id="proj_id" type="text" size="15" value="{{proj_id}}"> <a class="button" href="javascript:change_project()">Change</a> |
From: Dashamir H. <das...@us...> - 2004-01-12 15:21:29
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv28891/docs Modified Files: Tag: maisp ToDo.txt Log Message: Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.12.2.2 retrieving revision 1.12.2.3 diff -C2 -d -r1.12.2.2 -r1.12.2.3 *** ToDo.txt 9 Jan 2004 16:32:37 -0000 1.12.2.2 --- ToDo.txt 12 Jan 2004 15:21:26 -0000 1.12.2.3 *************** *** 1,11 **** + Add to project details URL1, URL2, etc. - For each developper add also his e-mail address. Each developper of a new project is automatically registered as an evaluator (by sending them a confirmation e-mail, like an invitation). - - + When the admin sends the project for edit to another person - he should supply his e-mail address (instead of the username). - Add a module that can be accessed only by admin, where he can --- 1,16 ---- + Add to project details URL1, URL2, etc. + + + When the admin sends the project for edit to another person + he should supply his e-mail address (instead of the username). + + - When editing a project, select the license, the language and + the category with a listbox. + + - Improve the look of the filters. - For each developper add also his e-mail address. Each developper of a new project is automatically registered as an evaluator (by sending them a confirmation e-mail, like an invitation). - Add a module that can be accessed only by admin, where he can |
From: Dashamir H. <das...@us...> - 2004-01-09 16:32:41
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv27897/docs Modified Files: Tag: maisp ToDo.txt Log Message: Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.12.2.1 retrieving revision 1.12.2.2 diff -C2 -d -r1.12.2.1 -r1.12.2.2 *** ToDo.txt 9 Jan 2004 16:31:03 -0000 1.12.2.1 --- ToDo.txt 9 Jan 2004 16:32:37 -0000 1.12.2.2 *************** *** 1,4 **** ! - Add to project details URL1, URL2, etc. - For each developper add also his e-mail address. Each developper --- 1,4 ---- ! + Add to project details URL1, URL2, etc. - For each developper add also his e-mail address. Each developper *************** *** 6,10 **** sending them a confirmation e-mail, like an invitation). ! - When the admin sends the project for edit to another person he should supply his e-mail address (instead of the username). --- 6,10 ---- sending them a confirmation e-mail, like an invitation). ! + When the admin sends the project for edit to another person he should supply his e-mail address (instead of the username). |
From: Dashamir H. <das...@us...> - 2004-01-09 16:32:41
|
Update of /cvsroot/phpwebapp/top10/templates/edit_project In directory sc8-pr-cvs1:/tmp/cvs-serv27897/templates/edit_project Modified Files: Tag: maisp edit_project_adm.js edit_project.php edit_project.html edit_project.db Log Message: Index: edit_project_adm.js =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project_adm.js,v retrieving revision 1.1 retrieving revision 1.1.2.1 diff -C2 -d -r1.1 -r1.1.2.1 *** edit_project_adm.js 2 Oct 2003 07:09:40 -0000 1.1 --- edit_project_adm.js 9 Jan 2004 16:32:37 -0000 1.1.2.1 *************** *** 3,8 **** function send_to_user() { ! var username = prompt("Give the username to which you will send it:"); ! if (username==null) return; //canceled ! SendEvent("edit_project", "send_to_user", "username="+username); } --- 3,8 ---- function send_to_user() { ! var email = prompt("Give the e-mail to which you will send it:"); ! if (email==null) return; //canceled ! SendEvent("edit_project", "send_to_user", "email="+email); } Index: edit_project.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.php,v retrieving revision 1.5 retrieving revision 1.5.2.1 diff -C2 -d -r1.5 -r1.5.2.1 *** edit_project.php 5 Jan 2004 14:42:00 -0000 1.5 --- edit_project.php 9 Jan 2004 16:32:37 -0000 1.5.2.1 *************** *** 94,104 **** $this->setSVar("mode", "done"); ! //notification mesage to the user ! $msg = "Thank you for your submittion.\n" ! . "This project will be added in the list\n" ! . "after it is approved by the admin.\n" ! . "From now on it can be deleted or modified\n" ! . "only by admin: '".ADMIN_EMAIL."'."; ! WebApp::message($msg); } --- 94,107 ---- $this->setSVar("mode", "done"); ! if (ADMIN <> 'true') ! { ! //notification message to the user ! $msg = "Thank you for your submittion.\n" ! . "This project will be added in the list\n" ! . "after it is approved by the admin.\n" ! . "From now on it can be deleted or modified\n" ! . "only by admin: '".ADMIN_EMAIL."'."; ! WebApp::message($msg); ! } } *************** *** 107,111 **** if (ADMIN <> 'true') return; ! $username = $event_args["username"]; $proj_id = $this->getSVar("proj_id"); --- 110,114 ---- if (ADMIN <> 'true') return; ! $email = $event_args["email"]; $proj_id = $this->getSVar("proj_id"); *************** *** 115,124 **** //insert in DB a request with the same id as above $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "ip", "username", "proj_id"); WebApp::execDBCmd("insert_request", $params); //send a notification e-mail to the user $to = "dasho"; ! //$to = $username."@users.sourceforge.net"; $subject = "Top10: Modify Project '$proj_id'"; $admin_mail = ADMIN_EMAIL; --- 118,127 ---- //insert in DB a request with the same id as above $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "ip", "email", "proj_id"); WebApp::execDBCmd("insert_request", $params); //send a notification e-mail to the user $to = "dasho"; ! //$to = $email; $subject = "Top10: Modify Project '$proj_id'"; $admin_mail = ADMIN_EMAIL; *************** *** 139,143 **** //display a confirmation message $msg = "Project '$proj_id' has been sent for editing\n" ! . " to $use...@us... .\n"; WebApp::message($msg); } --- 142,146 ---- //display a confirmation message $msg = "Project '$proj_id' has been sent for editing\n" ! . " to $email .\n"; WebApp::message($msg); } *************** *** 175,184 **** "proj_id" => "", "proj_name" => "", ! "group_id" => "", ! "register_date" => date("Y-m-d"), "license" => "GPL", "prog_lang" => "PHP", "category" => "", ! "members" => "usr1,usr2,usr3", "proj_descr" => "" ); --- 178,189 ---- "proj_id" => "", "proj_name" => "", ! "url1" => "Project Homepage", ! "url2" => "Development Page", ! //"group_id" => "", ! //"register_date" => date("Y-m-d"), "license" => "GPL", "prog_lang" => "PHP", "category" => "", ! "members" => "email1,email2,email3", "proj_descr" => "" ); Index: edit_project.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.html,v retrieving revision 1.4 retrieving revision 1.4.2.1 diff -C2 -d -r1.4 -r1.4.2.1 *** edit_project.html 25 Dec 2003 15:35:46 -0000 1.4 --- edit_project.html 9 Jan 2004 16:32:37 -0000 1.4.2.1 *************** *** 30,33 **** --- 30,34 ---- </td> </tr> + <!--# <tr> <td bgcolor="eeeeee">SourceForge group id:</td> *************** *** 37,40 **** --- 38,55 ---- </td> </tr> + #--> + <tr> + <td bgcolor="eeeeee">URL1:</td> + <td bgcolor="#ffffff"> + <input type="text" size="70" name="url1" value="{{url1}}"> + </td> + </tr> + <tr> + <td bgcolor="eeeeee">URL2:</td> + <td bgcolor="#ffffff"> + <input type="text" size="70" name="url2" value="{{url2}}"> + </td> + </tr> + <!--# <tr> <td bgcolor="eeeeee">Register Date:</td> *************** *** 45,48 **** --- 60,64 ---- </td> </tr> + #--> <tr> <td bgcolor="eeeeee">License:</td> Index: edit_project.db =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.db,v retrieving revision 1.4 retrieving revision 1.4.2.1 diff -C2 -d -r1.4 -r1.4.2.1 *** edit_project.db 5 Jan 2004 14:42:00 -0000 1.4 --- edit_project.db 9 Jan 2004 16:32:37 -0000 1.4.2.1 *************** *** 29,39 **** proj_name = '{{proj_name}}', proj_descr = '{{proj_descr}}', category = '{{category}}', license = '{{license}}', prog_lang = '{{prog_lang}}', ! register_date = '{{register_date}}', ! group_id = '{{group_id}}', points = 0, nr_comments = 0, status = 'new' </Query> --- 29,41 ---- proj_name = '{{proj_name}}', proj_descr = '{{proj_descr}}', + url1 = '{{url1}}', + url2 = '{{url2}}', category = '{{category}}', license = '{{license}}', prog_lang = '{{prog_lang}}', ! -- group_id = '{{group_id}}', points = 0, nr_comments = 0, + register_date = NOW(), status = 'new' </Query> *************** *** 46,54 **** proj_name = '{{proj_name}}', proj_descr = '{{proj_descr}}', category = '{{category}}', license = '{{license}}', ! prog_lang = '{{prog_lang}}', ! register_date = '{{register_date}}', ! group_id = '{{group_id}}' WHERE proj_id = '{{edit_project->proj_id}}' </Query> --- 48,58 ---- proj_name = '{{proj_name}}', proj_descr = '{{proj_descr}}', + url1 = '{{url1}}', + url2 = '{{url2}}', category = '{{category}}', license = '{{license}}', ! prog_lang = '{{prog_lang}}' ! -- register_date = '{{register_date}}', ! -- group_id = '{{group_id}}' WHERE proj_id = '{{edit_project->proj_id}}' </Query> *************** *** 75,79 **** request_id = '{{request_id}}', time = NOW(), ! username = '{{username}}', ip = '{{ip}}', type = 'edit_proj_details', --- 79,83 ---- request_id = '{{request_id}}', time = NOW(), ! username = '{{email}}', ip = '{{ip}}', type = 'edit_proj_details', |
From: Dashamir H. <das...@us...> - 2004-01-09 16:32:41
|
Update of /cvsroot/phpwebapp/top10/templates/proj_details In directory sc8-pr-cvs1:/tmp/cvs-serv27897/templates/proj_details Modified Files: Tag: maisp proj_details.html Log Message: Index: proj_details.html =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/proj_details.html,v retrieving revision 1.4 retrieving revision 1.4.2.1 diff -C2 -d -r1.4 -r1.4.2.1 *** proj_details.html 26 Sep 2003 15:32:20 -0000 1.4 --- proj_details.html 9 Jan 2004 16:32:37 -0000 1.4.2.1 *************** *** 40,43 **** --- 40,51 ---- </td> </tr> + <tr> + <td bgcolor="eeeeee">URL1:</td> + <td bgcolor="#ffffff">{{url1}}</td> + </tr> + <tr> + <td bgcolor="eeeeee">URL2:</td> + <td bgcolor="#ffffff">{{url2}}</td> + </tr> </table> |
From: Dashamir H. <das...@us...> - 2004-01-09 16:32:41
|
Update of /cvsroot/phpwebapp/top10/config In directory sc8-pr-cvs1:/tmp/cvs-serv27897/config Modified Files: Tag: maisp const.Options.php Log Message: Index: const.Options.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/config/const.Options.php,v retrieving revision 1.1.1.1 retrieving revision 1.1.1.1.2.1 diff -C2 -d -r1.1.1.1 -r1.1.1.1.2.1 *** const.Options.php 23 Sep 2003 14:04:12 -0000 1.1.1.1 --- const.Options.php 9 Jan 2004 16:32:37 -0000 1.1.1.1.2.1 *************** *** 54,58 **** * "", "NULL", NULL, etc. */ ! define("NULL_VALUE", "NULL"); /** --- 54,58 ---- * "", "NULL", NULL, etc. */ ! define("NULL_VALUE", ""); /** |
From: Dashamir H. <das...@us...> - 2004-01-09 16:31:06
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv27592/docs Modified Files: Tag: maisp ToDo.txt Log Message: Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.12 retrieving revision 1.12.2.1 diff -C2 -d -r1.12 -r1.12.2.1 *** ToDo.txt 5 Jan 2004 14:42:00 -0000 1.12 --- ToDo.txt 9 Jan 2004 16:31:03 -0000 1.12.2.1 *************** *** 1,22 **** ! - Add a hierarchical menu for selecting the category. ! - Add a module for the admin where he can change the categories, ! languages, his password, etc. - Add a module that can be accessed only by admin, where he can ! manage the users of the application. ! ----- ! - Using browse.php everybody can read the password of the database ! and any other sensitive information. Find out how to fix this. ! ------------------------------------------------------------------ ! - Fill the database with the relevant data (also with the help of SF team). ! - Add a link from phpWebApp page to Top10 page. - - Send a notification message to SF users about it. --- 1,31 ---- ! - Add to project details URL1, URL2, etc. ! - For each developper add also his e-mail address. Each developper ! of a new project is automatically registered as an evaluator (by ! sending them a confirmation e-mail, like an invitation). ! ! - When the admin sends the project for edit to another person ! he should supply his e-mail address (instead of the username). - Add a module that can be accessed only by admin, where he can ! manage the users of the application (evaluators). He can add new ! evaluators (by sending them a confirmation email, like an invitation), ! remove them, change their data(email), etc. ! - At the preference list display also the user details (name, email etc.) ! if the user wants to make them public. ! - A user that is not registered yet as an evaluator can do so at the ! time that he tries to save his preference list. His registration should ! be approved by admin, and his preference list is saved only after he ! is approved by admin and the list confirmed (by email) by the user. ! --------------- ! - Add a hierarchical menu for selecting the category. ! - Add a module for the admin where he can change the categories, ! languages, his password, etc. |
From: Dashamir H. <das...@us...> - 2004-01-06 15:22:45
|
Update of /cvsroot/phpwebapp/top10/config In directory sc8-pr-cvs1:/tmp/cvs-serv21756/config Modified Files: Tag: maisp const.DB.php Log Message: Index: const.DB.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/config/const.DB.php,v retrieving revision 1.1.1.1 retrieving revision 1.1.1.1.2.1 diff -C2 -d -r1.1.1.1 -r1.1.1.1.2.1 *** const.DB.php 23 Sep 2003 14:04:12 -0000 1.1.1.1 --- const.DB.php 6 Jan 2004 15:22:42 -0000 1.1.1.1.2.1 *************** *** 3,8 **** define("DBHOST", "localhost"); ! define("DBUSER", "dasho"); ! define("DBPASS", "dasho"); ! define("DBNAME", "sf"); ! ?> \ No newline at end of file --- 3,8 ---- define("DBHOST", "localhost"); ! define("DBUSER", "inima_top10"); ! define("DBPASS", "inima_top10"); ! define("DBNAME", "inima_top10"); ! ?> |
From: Dashamir H. <das...@us...> - 2004-01-06 15:22:45
|
Update of /cvsroot/phpwebapp/top10/db In directory sc8-pr-cvs1:/tmp/cvs-serv21756/db Modified Files: Tag: maisp init_db.sh top10_tables.sql update_db.sh Log Message: Index: init_db.sh =================================================================== RCS file: /cvsroot/phpwebapp/top10/db/init_db.sh,v retrieving revision 1.1 retrieving revision 1.1.2.1 diff -C2 -d -r1.1 -r1.1.2.1 *** init_db.sh 5 Jan 2004 14:38:31 -0000 1.1 --- init_db.sh 6 Jan 2004 15:22:42 -0000 1.1.2.1 *************** *** 10,15 **** echo "" echo "Inserting some sample data:" ! echo "$ mysql -u $username -p top10_db < top10_data.sql" ! mysql -u $username -p top10_db < top10_data.sql echo "" --- 10,15 ---- echo "" echo "Inserting some sample data:" ! echo "$ mysql -u $username -p inima_top10 < top10_data.sql" ! mysql -u $username -p inima_top10 < top10_data.sql echo "" Index: top10_tables.sql =================================================================== RCS file: /cvsroot/phpwebapp/top10/db/top10_tables.sql,v retrieving revision 1.1 retrieving revision 1.1.2.1 diff -C2 -d -r1.1 -r1.1.2.1 *** top10_tables.sql 5 Jan 2004 14:38:31 -0000 1.1 --- top10_tables.sql 6 Jan 2004 15:22:42 -0000 1.1.2.1 *************** *** 4,12 **** -- ! -- Create the database top10_db -- ! CREATE DATABASE IF NOT EXISTS top10_db; ! USE top10_db; -- --- 4,12 ---- -- ! -- Create the database inima_top10 -- ! CREATE DATABASE IF NOT EXISTS inima_top10; ! USE inima_top10; -- Index: update_db.sh =================================================================== RCS file: /cvsroot/phpwebapp/top10/db/update_db.sh,v retrieving revision 1.1 retrieving revision 1.1.2.1 diff -C2 -d -r1.1 -r1.1.2.1 *** update_db.sh 5 Jan 2004 14:38:31 -0000 1.1 --- update_db.sh 6 Jan 2004 15:22:42 -0000 1.1.2.1 *************** *** 3,5 **** # This script must be executed periodically at least once a day ! mysql --user='root' --password='' top10_db < update_db.sql --- 3,5 ---- # This script must be executed periodically at least once a day ! mysql --user='root' --password='' inima_top10 < update_db.sql |
From: Dashamir H. <das...@us...> - 2004-01-06 15:22:45
|
Update of /cvsroot/phpwebapp/top10 In directory sc8-pr-cvs1:/tmp/cvs-serv21756 Modified Files: Tag: maisp browse.php Log Message: Index: browse.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/browse.php,v retrieving revision 1.1.1.1 retrieving revision 1.1.1.1.2.1 diff -C2 -d -r1.1.1.1 -r1.1.1.1.2.1 *** browse.php 23 Sep 2003 14:04:07 -0000 1.1.1.1 --- browse.php 6 Jan 2004 15:22:41 -0000 1.1.1.1.2.1 *************** *** 1,3 **** --- 1,4 ---- <?php + exit; /* Copyright 2001,2002,2003 Dashamir Hoxha, das...@us... *************** *** 28,31 **** --- 29,33 ---- */ /** */ + include "webapp.php"; *************** *** 40,42 **** WebApp::addVar("APP_STYLE", APP_URL."templates/styles.css"); WebApp::constructHtmlPage(BROWSER_PATH."fileBrowser.html"); ! ?> \ No newline at end of file --- 42,44 ---- WebApp::addVar("APP_STYLE", APP_URL."templates/styles.css"); WebApp::constructHtmlPage(BROWSER_PATH."fileBrowser.html"); ! ?> |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:04
|
Update of /cvsroot/phpwebapp/top10/docs In directory sc8-pr-cvs1:/tmp/cvs-serv31213/docs Modified Files: database.xmi ToDo.txt Log Message: Index: database.xmi =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/database.xmi,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** database.xmi 23 Sep 2003 14:52:40 -0000 1.1 --- database.xmi 5 Jan 2004 14:42:00 -0000 1.2 *************** *** 1,15 **** <?xml version="1.0" encoding="UTF-8"?> <XMI xmlns:UML="org.omg/standards/UML" verified="false" timestamp="" xmi.version="1.2" > ! <XMI.header> ! <XMI.documentation> ! <XMI.exporter>umbrello uml modeller http://uml.sf.net</XMI.exporter> ! <XMI.exporterVersion>1.1</XMI.exporterVersion> </XMI.documentation> ! <XMI.model xmi.name="database" href="/var/www/html/top10/docs/database.xmi" /> ! <XMI.metamodel xmi.name="UML" href="UML.xml" xmi.version="1.3" /> </XMI.header> <XMI.content> ! <docsettings viewid="1" documentation="" uniqueid="45" /> <umlobjects> ! <UML:Class stereotype="" package="" xmi.id="2" abstract="0" documentation="" name="proj_list" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="9" value="" type="string" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="10" value="" type="string" abstract="0" documentation="" name="proj_name" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="11" value="" type="string" abstract="0" documentation="" name="proj_descr" static="0" scope="200" /> --- 1,17 ---- <?xml version="1.0" encoding="UTF-8"?> <XMI xmlns:UML="org.omg/standards/UML" verified="false" timestamp="" xmi.version="1.2" > ! <XMI.header> ! <XMI.documentation> ! <XMI.exporter>umbrello uml modeller http://uml.sf.net</XMI.exporter> ! <XMI.exporterVersion>1.1</XMI.exporterVersion> ! </XMI.documentation> ! <XMI.model xmi.name="database" href="/var/www/html/phpwebapp/top10/docs/database.xmi" /> ! <XMI.metamodel xmi.name="UML" href="UML.xml" xmi.version="1.3" /> ! </XMI.header> <XMI.content> ! <docsettings viewid="1" documentation="" uniqueid="46" /> <umlobjects> ! <UML:Class stereotype="" package="" xmi.id="2" abstract="0" documentation="" name="proj_list" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="9" value="" type="string" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="10" value="" type="string" abstract="0" documentation="" name="proj_name" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="11" value="" type="string" abstract="0" documentation="" name="proj_descr" static="0" scope="200" /> *************** *** 20,39 **** <UML:Attribute stereotype="" package="" xmi.id="16" value="" type="int" abstract="0" documentation="" name="register_date" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="17" value="" type="int" abstract="0" documentation="" name="group_id" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="18" value="" type="int" abstract="0" documentation="" name="points" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="3" abstract="0" documentation="" name="preference_list" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="19" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="20" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="21" value="" type="int" abstract="0" documentation="" name="position" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="4" abstract="0" documentation="" name="proj_members" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="22" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="23" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="5" abstract="0" documentation="" name="categories" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="24" value="" type="int" abstract="0" documentation="" name="category" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="6" abstract="0" documentation="" name="languages" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="25" value="" type="int" abstract="0" documentation="" name="prog_lang" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="7" abstract="0" documentation="" name="licenses" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="26" value="" type="int" abstract="0" documentation="" name="license" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="8" abstract="0" documentation="" name="requests" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="27" value="" type="int" abstract="0" documentation="" name="request_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="28" value="" type="int" abstract="0" documentation="" name="time" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="29" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> --- 22,47 ---- <UML:Attribute stereotype="" package="" xmi.id="16" value="" type="int" abstract="0" documentation="" name="register_date" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="17" value="" type="int" abstract="0" documentation="" name="group_id" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="18" value="" type="int" abstract="0" documentation="" name="points" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="3" abstract="0" documentation="" name="preference_list" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="19" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="20" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="21" value="" type="int" abstract="0" documentation="" name="position" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="4" abstract="0" documentation="" name="proj_members" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="22" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="23" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="5" abstract="0" documentation="" name="categories" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="24" value="" type="int" abstract="0" documentation="" name="category" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="6" abstract="0" documentation="" name="languages" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="25" value="" type="int" abstract="0" documentation="" name="prog_lang" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="7" abstract="0" documentation="" name="licenses" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="26" value="" type="int" abstract="0" documentation="" name="license" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="8" abstract="0" documentation="" name="requests" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="27" value="" type="int" abstract="0" documentation="" name="request_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="28" value="" type="int" abstract="0" documentation="" name="time" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="29" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> *************** *** 41,56 **** <UML:Attribute stereotype="" package="" xmi.id="31" value="" type="int" abstract="0" documentation="" name="type" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="32" value="" type="int" abstract="0" documentation="" name="data" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="33" value="" type="int" abstract="0" documentation="" name="status" static="0" scope="200" /> </UML:Class> <UML:Class stereotype="" package="" xmi.id="34" abstract="0" documentation="" name="comments" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="35" value="" type="int" abstract="0" documentation="" name="comment_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="36" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="37" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="38" value="" type="int" abstract="0" documentation="" name="comment" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="39" value="" type="int" abstract="0" documentation="" name="date" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="40" value="" type="int" abstract="0" documentation="" name="ip" static="0" scope="200" /> </UML:Class> </umlobjects> <diagrams> ! <diagram snapgrid="0" showattsig="0" fillcolor="#ffffc0" showgrid="0" showopsig="0" usefillcolor="1" snapx="10" snapy="10" showatts="1" xmi.id="1" documentation="" type="402" showops="0" showpackage="0" name="database diagram" localid="30000" showstereotype="0" showscope="0" font="Sans,10,-1,5,50,0,0,0,0,0" linecolor="#ff0000" > ! <widgets> ! <UML:ConceptWidget usesdiagramfillcolour="0" width="94" showattsigs="603" usesdiagramusefillcolour="0" x="42" linecolour="#ff0000" y="93" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="187" usefillcolor="1" showattributes="1" xmi.id="2" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="105" showattsigs="603" usesdiagramusefillcolour="0" x="246" linecolour="#ff0000" y="183" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="68" usefillcolor="1" showattributes="1" xmi.id="3" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="104" showattsigs="603" usesdiagramusefillcolour="0" x="244" linecolour="#ff0000" y="96" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="51" usefillcolor="1" showattributes="1" xmi.id="4" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> --- 49,68 ---- <UML:Attribute stereotype="" package="" xmi.id="31" value="" type="int" abstract="0" documentation="" name="type" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="32" value="" type="int" abstract="0" documentation="" name="data" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="33" value="" type="int" abstract="0" documentation="" name="status" static="0" scope="200" /> ! </UML:Class> <UML:Class stereotype="" package="" xmi.id="34" abstract="0" documentation="" name="comments" static="0" scope="200" > ! <UML:Attribute stereotype="" package="" xmi.id="35" value="" type="int" abstract="0" documentation="" name="comment_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="36" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="37" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" /> + <UML:Attribute stereotype="" package="" xmi.id="46" value="" type="string" abstract="0" documentation="" name="title" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="38" value="" type="int" abstract="0" documentation="" name="comment" static="0" scope="200" /> <UML:Attribute stereotype="" package="" xmi.id="39" value="" type="int" abstract="0" documentation="" name="date" static="0" scope="200" /> ! <UML:Attribute stereotype="" package="" xmi.id="40" value="" type="int" abstract="0" documentation="" name="ip" static="0" scope="200" /> ! </UML:Class> ! </umlobjects> <diagrams> ! <diagram snapgrid="0" showattsig="0" fillcolor="#ffffc0" showgrid="0" showopsig="0" usefillcolor="1" snapx="10" snapy="10" showatts="1" xmi.id="1" documentation="" type="402" showops="0" showpackage="0" name="database diagram" localid="30000" showstereotype="0" showscope="0" font="Sans,10,-1,5,50,0,0,0,0,0" linecolor="#ff0000" > ! <widgets> ! <UML:ConceptWidget usesdiagramfillcolour="0" width="94" showattsigs="603" usesdiagramusefillcolour="0" x="42" linecolour="#ff0000" y="93" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="187" usefillcolor="1" showattributes="1" xmi.id="2" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="105" showattsigs="603" usesdiagramusefillcolour="0" x="246" linecolour="#ff0000" y="183" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="68" usefillcolor="1" showattributes="1" xmi.id="3" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="104" showattsigs="603" usesdiagramusefillcolour="0" x="244" linecolour="#ff0000" y="96" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="51" usefillcolor="1" showattributes="1" xmi.id="4" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> *************** *** 59,128 **** <UML:ConceptWidget usesdiagramfillcolour="1" width="65" showattsigs="603" usesdiagramusefillcolour="1" x="421" linecolour="none" y="237" showopsigs="603" usesdiagramlinecolour="1" fillcolour="none" height="34" usefillcolor="1" showattributes="1" xmi.id="7" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="79" showattsigs="603" usesdiagramusefillcolour="0" x="275" linecolour="#ff0000" y="335" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="8" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:ConceptWidget usesdiagramfillcolour="0" width="91" showattsigs="603" usesdiagramusefillcolour="0" x="44" linecolour="#ff0000" y="355" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="119" usefillcolor="1" showattributes="1" xmi.id="34" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:NoteWidget usesdiagramfillcolour="1" width="149" usesdiagramusefillcolour="1" x="573" linecolour="none" y="151" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="42" text="Helper tables used by listbox-es." font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:NoteWidget usesdiagramfillcolour="1" width="179" usesdiagramusefillcolour="1" x="443" linecolour="none" y="365" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="44" text="Keeps the requests that require confirmation." font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="285" usesdiagramusefillcolour="1" x="220" linecolour="none" y="26" operation="" usesdiagramlinecolour="1" role="700" fillcolour="none" height="28" usefillcolor="1" seqnum="" xmi.id="45" text="The database diagram of Top10" font="Sans,14,-1,5,50,0,0,0,0,0" /> </widgets> <messages/> <associations> ! <UML:AssocWidget totalcounta="3" indexa="1" totalcountb="2" indexb="1" widgetbid="4" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="132" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="212" linecolour="none" y="123" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="190" linecolour="none" y="138" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="136" starty="155" /> ! <endpoint endx="244" endy="121" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="3" indexa="2" totalcountb="2" indexb="1" widgetbid="3" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="214" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="191" linecolour="none" y="217" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="136" starty="217" /> ! <endpoint endx="246" endy="217" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="34" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="283" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="333" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="89" linecolour="none" y="318" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="89" starty="280" /> ! <endpoint endx="89" endy="355" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="1" widgetbid="42" widgetaid="5" documentation="" type="513" > ! <linepath> ! <startpoint startx="490" starty="116" /> ! <endpoint endx="573" endy="163" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="2" widgetbid="42" widgetaid="6" documentation="" type="513" > ! <linepath> ! <startpoint startx="494" starty="183" /> ! <endpoint endx="573" endy="176" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="3" widgetbid="42" widgetaid="7" documentation="" type="513" > ! <linepath> ! <startpoint startx="453" starty="237" /> ! <endpoint endx="573" endy="188" /> </linepath> </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="44" widgetaid="8" documentation="" type="513" > ! <linepath> ! <startpoint startx="354" starty="403" /> ! <endpoint endx="443" endy="390" /> </linepath> </UML:AssocWidget> </associations> </diagram> </diagrams> <listview> ! <listitem open="1" type="800" id="-1" label="Views" > ! <listitem open="1" type="801" id="-1" label="Logical View" > ! <listitem open="1" type="813" id="5" label="categories" > ! <listitem open="0" type="814" id="24" label="category" /> </listitem> <listitem open="0" type="807" id="1" label="class diagram" /> <listitem open="1" type="813" id="34" label="comments" > ! <listitem open="0" type="814" id="38" label="comment" /> <listitem open="0" type="814" id="35" label="comment_id" /> <listitem open="0" type="814" id="39" label="date" /> <listitem open="0" type="814" id="40" label="ip" /> <listitem open="0" type="814" id="36" label="proj_id" /> ! <listitem open="0" type="814" id="37" label="username" /> </listitem> <listitem open="1" type="813" id="6" label="languages" > ! <listitem open="0" type="814" id="25" label="prog_lang" /> </listitem> <listitem open="1" type="813" id="7" label="licenses" > ! <listitem open="0" type="814" id="26" label="license" /> </listitem> <listitem open="1" type="813" id="3" label="preference_list" > ! <listitem open="0" type="814" id="21" label="position" /> <listitem open="0" type="814" id="19" label="proj_id" /> ! <listitem open="0" type="814" id="20" label="username" /> </listitem> <listitem open="1" type="813" id="2" label="proj_list" > ! <listitem open="0" type="814" id="12" label="category" /> <listitem open="0" type="814" id="17" label="group_id" /> <listitem open="0" type="814" id="14" label="license" /> --- 71,164 ---- <UML:ConceptWidget usesdiagramfillcolour="1" width="65" showattsigs="603" usesdiagramusefillcolour="1" x="421" linecolour="none" y="237" showopsigs="603" usesdiagramlinecolour="1" fillcolour="none" height="34" usefillcolor="1" showattributes="1" xmi.id="7" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:ConceptWidget usesdiagramfillcolour="0" width="79" showattsigs="603" usesdiagramusefillcolour="0" x="275" linecolour="#ff0000" y="335" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="8" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:ConceptWidget usesdiagramfillcolour="0" width="91" showattsigs="603" usesdiagramusefillcolour="0" x="44" linecolour="#ff0000" y="354" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="34" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:NoteWidget usesdiagramfillcolour="1" width="149" usesdiagramusefillcolour="1" x="573" linecolour="none" y="151" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="42" text="Helper tables used by listbox-es." font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:NoteWidget usesdiagramfillcolour="1" width="179" usesdiagramusefillcolour="1" x="443" linecolour="none" y="365" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="44" text="Keeps the requests that require confirmation." font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="285" usesdiagramusefillcolour="1" x="220" linecolour="none" y="26" operation="" usesdiagramlinecolour="1" role="700" fillcolour="none" height="28" usefillcolor="1" seqnum="" xmi.id="45" text="The database diagram of Top10" font="Sans,14,-1,5,50,0,0,0,0,0" /> ! </widgets> <messages/> <associations> ! <UML:AssocWidget totalcounta="3" indexa="1" totalcountb="2" indexb="1" widgetbid="4" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="132" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="212" linecolour="none" y="123" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="190" linecolour="none" y="138" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="136" starty="155" /> ! <endpoint endx="244" endy="121" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="3" indexa="2" totalcountb="2" indexb="1" widgetbid="3" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="214" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="191" linecolour="none" y="217" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="136" starty="217" /> ! <endpoint endx="246" endy="217" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="34" widgetaid="2" documentation="" type="503" > ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="282" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="331" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" /> ! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="89" linecolour="none" y="317" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" /> <linepath> ! <startpoint startx="89" starty="280" /> ! <endpoint endx="89" endy="354" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="1" widgetbid="42" widgetaid="5" documentation="" type="513" > ! <linepath> ! <startpoint startx="490" starty="116" /> ! <endpoint endx="573" endy="163" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="2" widgetbid="42" widgetaid="6" documentation="" type="513" > ! <linepath> ! <startpoint startx="494" starty="183" /> ! <endpoint endx="573" endy="176" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="3" widgetbid="42" widgetaid="7" documentation="" type="513" > ! <linepath> ! <startpoint startx="453" starty="237" /> ! <endpoint endx="573" endy="188" /> ! </linepath> ! </UML:AssocWidget> <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="44" widgetaid="8" documentation="" type="513" > ! <linepath> ! <startpoint startx="354" starty="403" /> ! <endpoint endx="443" endy="390" /> ! </linepath> ! </UML:AssocWidget> ! </associations> ! </diagram> ! </diagrams> <listview> ! <listitem open="1" type="800" id="-1" label="Views" > ! <listitem open="1" type="801" id="-1" label="Logical View" > ! <listitem open="1" type="813" id="5" label="categories" > ! <listitem open="0" type="814" id="24" label="category" /> ! </listitem> <listitem open="0" type="807" id="1" label="class diagram" /> <listitem open="1" type="813" id="34" label="comments" > ! <listitem open="0" type="814" id="38" label="comment" /> <listitem open="0" type="814" id="35" label="comment_id" /> <listitem open="0" type="814" id="39" label="date" /> <listitem open="0" type="814" id="40" label="ip" /> <listitem open="0" type="814" id="36" label="proj_id" /> ! <listitem open="0" type="814" id="46" label="title" /> ! <listitem open="0" type="814" id="37" label="username" /> ! </listitem> <listitem open="1" type="813" id="6" label="languages" > ! <listitem open="0" type="814" id="25" label="prog_lang" /> ! </listitem> <listitem open="1" type="813" id="7" label="licenses" > ! <listitem open="0" type="814" id="26" label="license" /> ! </listitem> <listitem open="1" type="813" id="3" label="preference_list" > ! <listitem open="0" type="814" id="21" label="position" /> <listitem open="0" type="814" id="19" label="proj_id" /> ! <listitem open="0" type="814" id="20" label="username" /> ! </listitem> <listitem open="1" type="813" id="2" label="proj_list" > ! <listitem open="0" type="814" id="12" label="category" /> <listitem open="0" type="814" id="17" label="group_id" /> <listitem open="0" type="814" id="14" label="license" /> *************** *** 133,142 **** <listitem open="0" type="814" id="10" label="proj_name" /> <listitem open="0" type="814" id="16" label="register_date" /> ! <listitem open="0" type="814" id="13" label="status" /> </listitem> <listitem open="1" type="813" id="4" label="proj_members" > ! <listitem open="0" type="814" id="22" label="proj_id" /> ! <listitem open="0" type="814" id="23" label="username" /> </listitem> <listitem open="1" type="813" id="8" label="requests" > ! <listitem open="0" type="814" id="32" label="data" /> <listitem open="0" type="814" id="30" label="ip" /> <listitem open="0" type="814" id="27" label="request_id" /> --- 169,180 ---- <listitem open="0" type="814" id="10" label="proj_name" /> <listitem open="0" type="814" id="16" label="register_date" /> ! <listitem open="0" type="814" id="13" label="status" /> ! </listitem> <listitem open="1" type="813" id="4" label="proj_members" > ! <listitem open="0" type="814" id="22" label="proj_id" /> ! <listitem open="0" type="814" id="23" label="username" /> ! </listitem> <listitem open="1" type="813" id="8" label="requests" > ! <listitem open="0" type="814" id="32" label="data" /> <listitem open="0" type="814" id="30" label="ip" /> <listitem open="0" type="814" id="27" label="request_id" /> *************** *** 144,147 **** <listitem open="0" type="814" id="28" label="time" /> <listitem open="0" type="814" id="31" label="type" /> ! <listitem open="0" type="814" id="29" label="username" /> </listitem> </listitem> ! <listitem open="1" type="802" id="-1" label="Use Case View" /> </listitem> </listview> </XMI.content></XMI> \ No newline at end of file --- 182,191 ---- <listitem open="0" type="814" id="28" label="time" /> <listitem open="0" type="814" id="31" label="type" /> ! <listitem open="0" type="814" id="29" label="username" /> ! </listitem> ! </listitem> ! <listitem open="1" type="802" id="-1" label="Use Case View" /> ! </listitem> ! </listview> ! </XMI.content> ! </XMI> Index: ToDo.txt =================================================================== RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** ToDo.txt 29 Dec 2003 16:22:52 -0000 1.11 --- ToDo.txt 5 Jan 2004 14:42:00 -0000 1.12 *************** *** 1,14 **** ! - Check for malicious requests. Username is given by the user ! and sometimes the project id as well; check their values so ! that it is not possible for them to have a malicious value. ! - Using browse.php everybody can read the password of the database ! and any other sensitive information. Find out how to fix this. ! - Write a script that is executed periodically and updates the ! status of old pending requests to 'expired'. ! - Make periodic backups for the database. ------------------------------------------------------------------ --- 1,15 ---- ! - Add a hierarchical menu for selecting the category. ! - Add a module for the admin where he can change the categories, ! languages, his password, etc. ! - Add a module that can be accessed only by admin, where he can ! manage the users of the application. ! ----- ! ! - Using browse.php everybody can read the password of the database ! and any other sensitive information. Find out how to fix this. ------------------------------------------------------------------ |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates/confirm In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates/confirm Modified Files: confirm.php Log Message: Index: confirm.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/confirm/confirm.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** confirm.php 29 Dec 2003 15:56:38 -0000 1.6 --- confirm.php 5 Jan 2004 14:42:00 -0000 1.7 *************** *** 26,41 **** { $this->addSVar("file", "{{./}}blank.html"); ! $this->addSVar("request_id", $this->get_request_id()); $this->process_request(); - } - - function get_request_id() - { - $request_id = $_SERVER["QUERY_STRING"]; - - //ToDo: check for any possibility that a malicious request id - // can compromise the system; try to filter such requests - - return $request_id; } --- 26,31 ---- { $this->addSVar("file", "{{./}}blank.html"); ! $this->addSVar("request_id", $_SERVER["QUERY_STRING"]); $this->process_request(); } |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates Modified Files: module.php Log Message: Index: module.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/module.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** module.php 2 Oct 2003 07:09:40 -0000 1.4 --- module.php 5 Jan 2004 14:42:00 -0000 1.5 *************** *** 54,57 **** --- 54,59 ---- function on_edit_project($event_args) { + if (ADMIN <> 'true') return; + $proj_id = $event_args["proj_id"]; |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates/preference_list In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates/preference_list Modified Files: preference_list.php preference_list.db Log Message: Index: preference_list.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/preference_list/preference_list.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** preference_list.php 29 Dec 2003 14:14:50 -0000 1.4 --- preference_list.php 5 Jan 2004 14:42:00 -0000 1.5 *************** *** 77,83 **** //insert in DB a request with the same id as above - $time = time(); $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "time", "ip"); WebApp::execDBCmd("insert_request", $params); --- 77,82 ---- //insert in DB a request with the same id as above $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "ip"); WebApp::execDBCmd("insert_request", $params); Index: preference_list.db =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/preference_list/preference_list.db,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** preference_list.db 23 Sep 2003 14:04:14 -0000 1.1.1.1 --- preference_list.db 5 Jan 2004 14:42:00 -0000 1.2 *************** *** 29,33 **** SET request_id = '{{request_id}}', ! time = '{{time}}', username = '{{username}}', ip = '{{ip}}', --- 29,33 ---- SET request_id = '{{request_id}}', ! time = NOW(), username = '{{username}}', ip = '{{ip}}', |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates/edit_project In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates/edit_project Modified Files: edit_project.php edit_project.db Log Message: Index: edit_project.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** edit_project.php 25 Dec 2003 15:35:46 -0000 1.4 --- edit_project.php 5 Jan 2004 14:42:00 -0000 1.5 *************** *** 114,120 **** //insert in DB a request with the same id as above - $time = time(); $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "time", "ip", "username", "proj_id"); WebApp::execDBCmd("insert_request", $params); --- 114,119 ---- //insert in DB a request with the same id as above $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "ip", "username", "proj_id"); WebApp::execDBCmd("insert_request", $params); Index: edit_project.db =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/edit_project/edit_project.db,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** edit_project.db 25 Dec 2003 15:35:46 -0000 1.3 --- edit_project.db 5 Jan 2004 14:42:00 -0000 1.4 *************** *** 74,78 **** SET request_id = '{{request_id}}', ! time = '{{time}}', username = '{{username}}', ip = '{{ip}}', --- 74,78 ---- SET request_id = '{{request_id}}', ! time = NOW(), username = '{{username}}', ip = '{{ip}}', |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates/proj_details/comments In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates/proj_details/comments Modified Files: comments.php comments.db Log Message: Index: comments.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/comments/comments.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** comments.php 29 Dec 2003 15:56:37 -0000 1.5 --- comments.php 5 Jan 2004 14:41:59 -0000 1.6 *************** *** 50,56 **** //insert in DB a request with the same id as above - $time = time(); $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "time", "ip", "username", "comment_id"); WebApp::execDBCmd("insert_request", $params); --- 50,55 ---- //insert in DB a request with the same id as above $ip = $_SERVER["REMOTE_ADDR"]; ! $params = compact("request_id", "ip", "username", "comment_id"); WebApp::execDBCmd("insert_request", $params); Index: comments.db =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/comments/comments.db,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** comments.db 29 Dec 2003 15:56:37 -0000 1.5 --- comments.db 5 Jan 2004 14:41:59 -0000 1.6 *************** *** 49,53 **** SET request_id = '{{request_id}}', ! time = '{{time}}', username = '{{username}}', ip = '{{ip}}', --- 49,53 ---- SET request_id = '{{request_id}}', ! time = NOW(), username = '{{username}}', ip = '{{ip}}', |
From: Dashamir H. <das...@us...> - 2004-01-05 14:42:03
|
Update of /cvsroot/phpwebapp/top10/templates/proj_list/footer In directory sc8-pr-cvs1:/tmp/cvs-serv31213/templates/proj_list/footer Modified Files: list_footer.php Log Message: Index: list_footer.php =================================================================== RCS file: /cvsroot/phpwebapp/top10/templates/proj_list/footer/list_footer.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** list_footer.php 2 Oct 2003 07:09:40 -0000 1.3 --- list_footer.php 5 Jan 2004 14:41:59 -0000 1.4 *************** *** 29,42 **** } - function on_edit($event_args) - { - if (ADMIN <> 'true') return; - - $selected = $event_args["selected"]; - $params = array("selected_projects" => $this->reformat($selected)); - //ToDo: do editing of projects - //WebApp::execDBCmd("approve", $params); - } - function on_delete($event_args) { --- 29,32 ---- |