[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/www/snippet browse.php, 1.8, 1.9 detail.php, 1.
From: |
tom |
Subject: |
[Gforge-commits] gforge/www/snippet browse.php, 1.8, 1.9 detail.php, 1.7, 1.8 |
Date: |
Fri, 12 Mar 2004 09:02:53 -0600 |
Update of /cvsroot/gforge/gforge/www/snippet
In directory db.perdue.net:/tmp/cvs-serv11761/www/snippet
Modified Files:
browse.php detail.php
Log Message:
Now the user names are linked
Index: browse.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/snippet/browse.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- browse.php 12 Mar 2004 14:47:14 -0000 1.8
+++ browse.php 12 Mar 2004 15:02:51 -0000 1.9
@@ -19,11 +19,11 @@
if ($by=='lang') {
- $sql="SELECT
users.realname,snippet.description,snippet.snippet_id,snippet.name ".
+ $sql="SELECT
users.realname,users.user_name,snippet.description,snippet.snippet_id,snippet.name
".
"FROM snippet,users ".
"WHERE users.user_id=snippet.created_by AND
snippet.language='$lang'";
- $sql2="SELECT
users.realname,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name
".
+ $sql2="SELECT
users.realname,users.user_name,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name
".
"FROM snippet_package,users ".
"WHERE users.user_id=snippet_package.created_by AND
snippet_package.language='$lang'";
@@ -31,20 +31,18 @@
} else if ($by=='cat') {
- $sql="SELECT
users.realname,snippet.description,snippet.snippet_id,snippet.name ".
+ $sql="SELECT
users.realname,users.user_name,snippet.description,snippet.snippet_id,snippet.name
".
"FROM snippet,users ".
"WHERE users.user_id=snippet.created_by AND
snippet.category='$cat'";
- $sql2="SELECT
users.realname,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name
".
+ $sql2="SELECT
users.realname,users.user_name,snippet_package.description,snippet_package.snippet_package_id,snippet_package.name
".
"FROM snippet_package,users ".
"WHERE users.user_id=snippet_package.created_by AND
snippet_package.category='$cat'";
echo '<h2>' .$Language->getText('snippet_browse','snippet_by_category',
array($SCRIPT_CATEGORY[$cat])).'</h2>';
} else {
-
exit_error($Language->getText('general','error'),$Language->getText('snippet_browse','error_bad_url'));
-
}
$result=db_query($sql);
@@ -77,7 +75,7 @@
db_result($result2,$i,'snippet_package_id').'"><strong>'.
db_result($result2,$i,'snippet_package_id').'</strong></a></td><td><strong>'.
db_result($result2,$i,'name').'</td><td>'.
- db_result($result2,$i,'realname').'</td></tr>';
+ '<a href="/users/'.db_result($result2, $i,
'user_name').'/">'.db_result($result2, $i, 'realname').'</a></td></tr>';
echo '
<tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td
colspan="2">'.util_make_links(nl2br(db_result($result2,$i,'description'))).'</td></tr>';
}
@@ -97,7 +95,7 @@
db_result($result,$i,'snippet_id').'"><strong>'.
db_result($result,$i,'snippet_id').'</strong></a></td><td><strong><a
href="/snippet/detail.php?type=snippet&id='.
db_result($result,$i,'snippet_id').'">'.db_result($result,$i,'name').'</a></td><td>'.
- db_result($result,$i,'realname').'</td></tr>';
+ '<a href="/users/'.db_result($result, $i,
'user_name').'/">'.db_result($result, $i, 'realname').'</a></td></tr>';
echo '
<tr '. $GLOBALS['HTML']->boxGetAltRowStyle($i) .'><td
colspan="2">'.util_make_links(nl2br(db_result($result,$i,'description'))).'</td></tr>';
}
Index: detail.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/snippet/detail.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- detail.php 12 Mar 2004 14:47:14 -0000 1.7
+++ detail.php 12 Mar 2004 15:02:51 -0000 1.8
@@ -39,7 +39,7 @@
/*
Get all the versions of this snippet
*/
- $sql="SELECT
users.realname,snippet_version.snippet_version_id,snippet_version.version,snippet_version.post_date,snippet_version.changes
".
+ $sql="SELECT
users.realname,users.user_name,snippet_version.snippet_version_id,snippet_version.version,snippet_version.post_date,snippet_version.changes
".
"FROM snippet_version,users ".
"WHERE users.user_id=snippet_version.submitted_by AND
snippet_id='$id' ".
"ORDER BY snippet_version.snippet_version_id DESC";
@@ -73,7 +73,8 @@
db_result($result,$i,'snippet_version_id').'"><strong>'.
db_result($result,$i,'version').'</strong></a></td><td>'.
date($sys_datefmt,db_result($result,$i,'post_date')).'</td><td>'.
- db_result($result,$i,'realname').'</td><td
align="center"><a
href="/snippet/delete.php?type=snippet&snippet_version_id='.
+ '<a href="/users/'.db_result($result, $i,
'user_name').'/">'.db_result($result, $i, 'realname').'</a></td>'.
+ '<td align="center"><a
href="/snippet/delete.php?type=snippet&snippet_version_id='.
db_result($result,$i,'snippet_version_id').
'">' .
html_image("ic/trash.png","16","16",array("border"=>"0")) . '</a></td></tr>';
@@ -129,7 +130,7 @@
/*
Get all the versions of this package
*/
- $sql="SELECT
users.realname,snippet_package_version.snippet_package_version_id,".
+ $sql="SELECT
users.realname,users.user_name,snippet_package_version.snippet_package_version_id,".
"snippet_package_version.version,snippet_package_version.post_date ".
"FROM snippet_package_version,users ".
"WHERE users.user_id=snippet_package_version.submitted_by AND
snippet_package_id='$id' ".
@@ -163,8 +164,8 @@
db_result($result,$i,'snippet_package_version_id').'"><strong>'.
db_result($result,$i,'version').'</strong></a></td><td>'.
date($sys_datefmt,db_result($result,$i,'post_date')).'</td><td>'.
- db_result($result,$i,'realname').
- '</td><td align="center"><a
href="/snippet/add_snippet_to_package.php?snippet_package_version_id='.
+ '<a href="/users/'.db_result($result, $i,
'user_name').'/">'.db_result($result, $i, 'realname').'</a></td>'.
+ '<td align="center"><a
href="/snippet/add_snippet_to_package.php?snippet_package_version_id='.
db_result($result,$i,'snippet_package_version_id').
'">' .
html_image("ic/pencil.png","20","25",array("border"=>"0")) .
'</a> <a
href="/snippet/delete.php?type=package&snippet_package_version_id='.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/www/snippet browse.php, 1.8, 1.9 detail.php, 1.7, 1.8,
tom <=