Changeset 993

Timestamp:

08/19/06 19:33:47 (2 years ago)

Author:

jm3

Message:

basic FUQery groundwork

Files:

• feedmelinks/admin/.htaccess (modified) (1 diff)
• feedmelinks/admin/FUQ/index.php (modified) (1 diff)
• feedmelinks/admin/index.php (modified) (1 diff)
• feedmelinks/modules/utils.inc.php (modified) (6 diffs)
• feedmelinks/portal-uncached.php (modified) (2 diffs)

feedmelinks/admin/.htaccess

@@ -1 +1 @@
-AuthName "FML Admin Area"
-AuthType Basic
-# BrittanySCarter
-AuthUserFile /home/fml/public_html/.htpasswd
-<Limit GET POST>

feedmelinks/admin/FUQ/index.php

@@ +1 @@
+<%
+        # $Id: index.php 989 2006-08-19 22:40:58Z jm3 $
+
+        $page = "admin";
+        $mesg = "input options:";
+        include_once( "../../modules/utils.inc.php" );
+
+        if( isSuperUser( $u ) && $tok && $tok == md5( getPasswdForUser( $u )))  { 
+                $title = "Admin : FUQ management &amp; testing";
+                include( "$modules/header.inc.php" ); 
+                $bg = " bgcolor='#888888' ";
+%>
+<h1><%= $title %></h1>
+
+
+<style type="text/css">
+        table{
+                border: 1px solid gray;
+        }
+        thead {
+                font-weight: bold;
+        }
+        .tr1 > td {
+                background-color: #dddddd;
+        }
+        td {
+                padding: 0.2em;
+                font-size: 1.4em;
+        }
+</style>
+
+<a href="http://toolstomaketools.svnrepository.com/codepot/trac.cgi/ticket/42">the FUQ roadmap</a>
+
+<table>
+        <thead>
+                <tr>
+                        <td>
+                                USER
+                        </td>
+                        <td>
+                                FUQ
+                        </td>
+                        <td>
+                                recalc'd FUQ
+                        </td>
+                </tr>
+        </thead>
+        <tbody>
+<% 
+        $gp = $guinea_pigs = array( "BrittanySCarter", "pheezy", "gus", "TheFaction", "Cashak", "ahhsum4", "ina", "jm3", "scordero", "testuser1", "knormile", "heathleah", "Kruther1934");
+        $flip = 0;
+        foreach( $gp as $g ) {
+%>
+        <tr <%= ($flip % 2) == 0 ? "class='tr1'" : "" %>>
+                <td>
+                        <a href="/u/<%= $g %>"><%= $g %></a>
+                </td>
+                <td>
+                        <%= get_fuq( $g ) %>
+                </td>
+                <td>
+                        <%= recalculate_fuq( $g ) %>
+                </td>
+        </tr>
+<%
+                $flip += 1;
+        }
+%>
+        <tbody>
+</table>
+
+<% include( "$modules/footer.inc.php" ); %>
+<% } else {  %>
+<meta http-equiv=Refresh content="1; URL=/login?bounceToPage=<%= urlencode( 'admin' ) %>" />
+<% } %>

feedmelinks/admin/index.php

@@ -22 +22 @@
-<br />
-
-
+
+
+
+
+
+
+
+
-        <b>TOOLS</b>:<br />
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
-
-<br />

feedmelinks/modules/utils.inc.php

@@ -4 +4 @@
-        include_once( "env.inc.php" );
-        include( get_root() . "/modules/prep-cache.inc.php" );
+
+        function get_fuq( $u ) {
+    $con = mysql_connect();
+    mysql_selectdb( getDBName() );
+    $qs = getQuery( "get_fuq", $u );
+        
+    $q = mysql_query( $qs );
+    $num_rows = mysql_affected_rows($con);
+        
+    if( $num_rows == 1 )
+                        return mysql_result($q, 0, "FUQ" );
+                else 
+                        return 2;
+        }
+
+        function recalculate_fuq( $u ) {
+                run_query( getQuery( "update_fuq", $u, $retval = get_fuq( $u )+0));
+                return $retval;
+        }
+
+        function run_query( $qs ) {
+    $con = mysql_connect();
+    mysql_selectdb( getDBName() );
+    $q = mysql_query( $qs );
+    return mysql_affected_rows($con);
+        }
-
-        # usr dirs are of the path /usr/u/username
@@ -1205 +1231 @@
-                        WHERE linksCategoriesXRef.linkID IS NULL ";
-
+        } else if( $argWhichQuery  == "get_fuq" ) {
+                return "SELECT FUQ from linksUsers WHERE userid = '" . urlencode( $args[1] ) . "';";
+
-        } else if( $argWhichQuery  == "tag" ) {
-                return "
@@ -1223 +1252 @@
-          return "
-                        INSERT INTO linksMetrics (linkID, date, user, source ) VALUES ( " . $args[1] . ", NULL, '" . $args[2] . "', 'unused' ) ";
+
+        } else if( $argWhichQuery  == "update_fuq" ) {
+                return "
+                UPDATE linksUsers SET FUQ = '" . $args[2] . "' WHERE userid = '" . urlencode($args[1]) . "';";
-
-        } else if( $argWhichQuery  == "edit_name" ) {
@@ -1317 +1350 @@
-        $q = mysql_query( $qs );
-        if( $q )
-mysql_result($q,0
+number_format( mysql_result($q,0)
-        
-        $qs = "SELECT COUNT(*) FROM links;";
-        $q = mysql_query( $qs );
-        if( $q )
-mysql_result($q,0
-
-$qs = "SELECT COUNT(*) FROM links WHERE createDate LIKE DATE_FORMAT( NOW
-
-if( $q 
-
+number_format( mysql_result($q,0)
+
+#$qs = "SELECT COUNT(*) FROM links WHERE createDate LIKE DATE_FORMAT( now
+#
+#if( $q && mysql_result($q, 0) != 0
+#
-
-        conClose( $con_getStatsLine );
-
-<b>$linksToday</b> new links today
+and counting
-}
-
@@ -1711 +1744 @@
-                        if( is_file( $f )) {
-%>
-height="<%= $pxl_size %>" 
+
-<%
-                                return;
@@ -1717 +1750 @@
-                } # end foreach
-%>
-jpg
+gif
-<%
-        $ret = ob_get_clean();

feedmelinks/portal-uncached.php

@@ -34 +34 @@
-
-        <div class="title box center" style="border: inherit;">
+                <img src="http://msig.info/web2v2/(reflect)FeedMeLinksBETA.png" border="0" alt="Feed Me Links" />
-                <span class="header"><small>Social Bookmarking</small>
-                </span>
@@ -98 +99 @@
-
-        <div id="stats" class="box">
-stats: 
+
-        </div>
-