Show
Ignore:
Timestamp:
02/16/07 14:17:21 (2 years ago)
Author:
jm3
Message:
  • massive database refactor; renamed tables and columns logically
  • cleaned up more asp-style tags so that Vim? font-locks them correctly
  • we have clean URLs now! http://feedmelinks.com/u/pheezy/tags/cassettes
  • probably broke some stuff; just let me know.
Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • feedmelinks/modules/list-public-compact.inc.php

    r1304 r1334  
    3434 
    3535        $whereClause = $who ? "WHERE userid='$who'" : ""; 
    36         $qs = "SELECT * FROM linksGroups $whereClause ORDER BY name"; 
     36        $qs = "SELECT * FROM tags $whereClause ORDER BY name"; 
    3737        $q = mysql_query( $qs ); 
    3838 
    …… 
    7070                        if( $viewedByOwner || $isPublic )  { 
    7171                                $id = mysql_result($q,$i,"ID"); 
    72                                 $qs = "SELECT count(*) FROM linksCategoriesXRef WHERE catID = $id"; 
     72                                $qs = "SELECT count(*) FROM links_tags_xref WHERE tagID = $id"; 
    7373                                $q2 = mysql_query( $qs ); 
    7474                                $count = mysql_result($q2,0); 
    …… 
    8686 <%= $count %> links 
    8787</td> 
    88 <td <%= $bg %>><%= makeFolderLink( $id, $name ) %></td> 
     88<td <%= $bg %>><%= makeFolderLink( $id, $name, $who ) %></td> 
    8989<% if( ! $who ) { %> 
    9090        <td <%= $bg %>>