invites.php

   1 <?php
   2 // $Id$
   3
   4 $prefetch = array('`points`', '`invites`');
   5 require 'con.php';
   6 $page->title = 'User Invite List';
   7
   8 if ( ! ($user instanceof authuser) )
   9         $page->errorfooter('login');
  10
  11 $user->userheader();
  12
  13 echo '<h2>Invitation URLs</h2>',"\n";
  14
  15 $urllist = $DB->query('SELECT `code` FROM `invites` WHERE `userid` = @userid');
  16 if ( $urllist->num_rows ) {
  17         echo '<p>Spam these links everywhere to become popular:</p>',"\n",
  18                         "<ul>\n";
  19
  20         while ( list($code) = $urllist->fetch_row() )
  21                 printf('        <li><a href="register?user=%d;code=%s">http://%s%s/register?user=%1$d;code=%2$s</a></li>'."\n",
  22                            $user->userid, $code, $_SERVER['HTTP_HOST'], dirname($_SERVER['REQUEST_URI']));
  23
  24         echo "</ul>\n",
  25                  '<p>These links are good for a single registration each only.</p>',"\n";
  26 }
  27
  28 for ( $i = 0; $i <= floor(sqrt($user->points)) || $i <= $user->invites; $i++ );
  29
  30 echo
  31 '<p>You have '.$user->points.' points. Points to next invite: ',(pow($i, 2) - $user->points),'</p>
  32
  33 <h2>Users you\'ve invited</h2>
  34 <ol>',"\n";
  35
  36 $userlist = $DB->query('SELECT `userid`, `alias` FROM `users` WHERE `referrer` = @userid');
  37 while ( $user2 = $userlist->fetch_row() )
  38         echo '  <li>',$user->namelink($user2[0], $user2[1]),"</li>\n";
  39
  40 echo "</ol>\n";
  41
  42 $page->pagefooter();
  43 ?>