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/testing/ajax-test.php

    r852 r1334  
    1 <% 
     1<?php 
    22        include_once( "../modules/utils.inc.php" ); 
    33        require_once( "$modules/xajax.inc.php" ); 
    …… 
    2424                $u == $user ? $auth = 1 : $auth = 0; 
    2525                $u = $user ? $user : $u; 
    26                 $qs_max = "SELECT count(*) as num_links, ID as catID, name FROM linksGroups, linksCategoriesXRef WHERE linksGroups.ID = linksCategoriesXRef.catID AND linksGroups.userid = '$u' GROUP BY name ORDER BY num_links DESC LIMIT 1;"; 
     26                $qs_max = "SELECT count(*) as num_links, ID as tagID, name FROM tags, links_tags_xref WHERE tags.ID = links_tags_xref.tagID AND tags.userid = '$u' GROUP BY name ORDER BY num_links DESC LIMIT 1;"; 
    2727                 
    28                 $qs = "SELECT count(*) as num_links, ID as catID, name FROM linksGroups, linksCategoriesXRef WHERE linksGroups.ID = linksCategoriesXRef.catID AND linksGroups.userid = '$u' GROUP BY name ORDER BY name ASC;"; 
     28                $qs = "SELECT count(*) as num_links, ID as tagID, name FROM tags, links_tags_xref WHERE tags.ID = links_tags_xref.tagID AND tags.userid = '$u' GROUP BY name ORDER BY name ASC;"; 
    2929 
    3030                $con = mysql_connect(); 
    …… 
    4747                        $name = makePrettyFolderName( urldecode( mysql_result($q, $i, "name"))); 
    4848                        if( $auth || isPublic( mysql_result($q, $i, "name"))) { 
    49                                 $id = mysql_result($q, $i, "catID"); 
     49                                $id = mysql_result($q, $i, "tagID"); 
    5050                                ob_start(); 
    51         %> 
     51        ?> 
    5252        <a rel="tag" class="f<%= $size %>" href="/f/<%= $id %>"><nobr><%= $name %></nobr></a> 
    5353        <%