Date: April 15, 2005
Author: Blaine Lang  - blaine@portalparts.com
www.portalparts.com

Geeklog Custom Membership example with all needed code included.

This example will prompt a new user for additional fields when registering.
User Full Name and Graduation year

The Full Name is already a field that is maintained by Geeklog but not prompted for at registration time.
The Graduation Year is not and we will setup a new table to store this extra information.
Any new information should be maintained in a separate table and don't re-use or extend Core Geeklog tables.

Using the Custom Registration Feature requires some PHP and MySQL skills. This example in addition to
the notes and example functions in lib-custom should be sufficient to guide you in adding additional fields.

<<<<<<<<<<<<<<>>>>>>>>>>>>>

Steps to install

1) Create the new table that is used for the extra user info. In this case, there is only the one new field "grad_year".
Assuming your Geeklog Database prefix is 'gl_' execute the following SQL.
If you have phpMyAdmin - select the database and enter the SQL below.


CREATE TABLE `gl_localuserinfo` (
  `uid` mediumint(8) NOT NULL default '0',
  `grad_year` varchar(4) NOT NULL default '',
  KEY `uid` (`uid`)
) TYPE=MyISAM;

2) Tell Geeklog about your new database.
Add the following line to system/lib-database after the other database table defintions.

$_TABLES['localuserinfo']   = $_DB_table_prefix . 'localuserinfo';



3) Replace the example custom user-registration functions in system/lib-custom with the ones in the included file.


4) Update your theme templates
- See the files under the included "themefiles" directory

4.1) Add a new directory called "custom" to your theme(s) directory
Add the template memberdetail.thtml to this custom folder.
Example: layout/professional/custom/memberdetail.thtml

4.2) Update the User Profile templates to include the custom fields
In the included archive - under themefiles, there is a "users" and "preferences" folder.
They each contain one template that needs to replace the file already in the corresponding
Theme directory. Note: These updated template files don't include the PGP Key field for the
user profile - as it's most likly not wanted anyways. Add it from the existing one if required.

Edit the HTML as required in these template files

5) Enable the custom Registration mode. Edit the Geeklog main config.php

$_CONF['custom_registration'] = true;  // Set to true if you have custom code

Thats it - enjoy,
Blaine




 

<?php

/* Reminder: always indent with 4 spaces (no tabs). */
// +---------------------------------------------------------------------------+
// | Geeklog 1.3                                                               |
// +---------------------------------------------------------------------------+
// | lib-custom.php                                                            |
// | Your very own custom Geeklog library.                                     |
// |                                                                           |
// | This is the file where you should put all of your custom code.  When      |
// | possible you should not alter lib-common.php but, instead, put code here. |
// | This will make upgrading to future versions of Geeklog easier for you     |
// | because you will always be gauranteed that the Geeklog developers will    |
// | NOT add code to this file. NOTE: we have already gone through the trouble |
// | of making sure that we always include this file when lib-common.php is    |
// | included some place so you will have access to lib-common.php.  It        |
// | follows then that you should not include lib-common.php in this file      |
// |                                                                           |
// +---------------------------------------------------------------------------+
// | Copyright (C) 2000-2005 by the following authors:                         |
// |                                                                           |
// | Authors: Tony Bibbs       - tony AT tonybibbs DOT com                     |
// |          Blaine Lang      - blaine AT portalparts DOT com                 |
// |          Dirk Haun        - dirk AT haun-online DOT de                    |
// +---------------------------------------------------------------------------+
// |                                                                           |
// | This program is free software; you can redistribute it and/or             |
// | modify it under the terms of the GNU General Public License               |
// | as published by the Free Software Foundation; either version 2            |
// | of the License, or (at your option) any later version.                    |
// |                                                                           |
// | This program is distributed in the hope that it will be useful,           |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the             |
// | GNU General Public License for more details.                              |
// |                                                                           |
// | You should have received a copy of the GNU General Public License         |
// | along with this program; if not, write to the Free Software Foundation,   |
// | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
// |                                                                           |
// +---------------------------------------------------------------------------+
//
// $Id: lib-custom.php,v 1.11.2.1 2005/10/03 09:24:36 dhaun Exp $

// You can use this global variable to print useful messages to the errorlog
// using COM_errorLog().  To see an example of how to do this, look in
// lib-common.php and see how $_COM_VERBOSE was used throughout the code
$_CST_VERBOSE = false;

/**
* Sample PHP Block function
*
* this is a sample function used by a PHP block.  This will show the rights that
* a user has in the "What you have access to" block.
*
*/
function phpblock_showrights()
{
    global $_RIGHTS, $_CST_VERBOSE;

    if ($_CST_VERBOSE) {
        COM_errorLog('**** Inside phpblock_showrights in lib-custom.php ****', 1);
    }

    $retval .= ' ';

    for ($i = 0; $i < count($_RIGHTS); $i++) {
        $retval .=  '<li>' . $_RIGHTS[$i] . '</li>' . LB;
    }

    if ($_CST_VERBOSE) {
        COM_errorLog('**** Leaving phpblock_showrights in lib-custom.php ****', 1);
    }

    return $retval;
}


/***
*
* Get Bent()
*
* Php function to tell you how if your site is grossly insecure
*
**/
function phpblock_getBent()
{
    global $_CONF, $_TABLES;

    $secure = true;

    $retval = '';

    $secure_msg = 'Could not find any gross insecurities in your site.  Do not take this ';
    $secure_msg .= 'as meaning your site is 100% secure, as no site ever is.  I can only ';
    $secure_msg .= 'check things that should be blatantly obvious.';

    $insecure_msg = '';

    // we don't have the path to the admin directory, so try to figure it out
    // from $_CONF['site_admin_url']
    $adminurl = $_CONF['site_admin_url'];
    if (strrpos ($adminurl, '/') == strlen ($adminurl)) {
        $adminurl = substr ($adminurl, 0, -1);
    }
    $pos = strrpos ($adminurl, '/');
    if ($pos === false) {
        // only guessing ...
        $installdir = $_CONF['path_html'] . 'admin/install';
    } else {
        $installdir = $_CONF['path_html'] . substr ($adminurl, $pos + 1)
                    . '/install';
    }

    if (is_dir ($installdir)) {
        $insecure_msg .= '<p>You should really remove the install directory <b>' . $installdir .'</b> once you have your site up and running without any errors.';
        $insecure_msg .= ' Keeping it around would allow malicious users the ability to destroy your current install, take over your site, or retrieve sensitive information.';

        $secure = false;
    }

    // check to see if any account still has 'password' as its password.
    $count = DB_query("select count(*) as count from {$_TABLES['users']} where passwd='" . md5('password') . "'");
    $A = DB_fetchArray($count);
    if ( $A['count'] > 0 ) {
        $secure = false;
        $insecure_msg .= '<p>You still have not changed the default password from "password" on ' . $A['count'] . ' account(s). ';
        $insecure_msg .= 'This will allow people to do serious harm to your site!';
    }

    if ($secure) {
        $retval = $secure_msg;
    } else {
        $retval = $insecure_msg;
    }
    $retval = wordwrap($retval,20,' ',1);

    return $retval;
}


/* Create any new records in additional tables you may have added  */
/* Update any fields in the core GL tables for this user as needed */
/* Called when user is first created */
function custom_usercreate($uid) {
    global $_TABLES;

    $grad_year = COM_applyFilter($_POST['cust_gradyear'],true);
    $fullname  = COM_applyFilter($_POST['cust_fullname']);

    // Ensure all data is prepared correctly before inserts, quotes may need to be escaped with addslashes()
    DB_query("INSERT INTO {$_TABLES['localuserinfo']} (uid,grad_year) VALUES ('$uid', '$grad_year')");
    DB_query("UPDATE {$_TABLES['users']} SET fullname = '$fullname' WHERE uid='$uid'");
    return true;

}

// Delete user record from custom user info table
function custom_userdelete($uid) {
    global $_TABLES;

    DB_query("DELETE FROM {$_TABLES['localuserinfo']} WHERE uid='$uid'");
    return true;

}
/* Called from users.php - when user is displaying a member profile  */
/* This function will return any extra fields that need to be shown */
/* Output is then replaced in {customfields) -- This variable needs to be added to your templates */
/* Template: path_layout/users/profile/profile.thtml */

function custom_userdisplay($uid) {
    global $_CONF,$_TABLES;
    $grad_year = DB_getItem($_TABLES['localuserinfo'], "grad_year", "uid='$uid'");
    $fullname = DB_getItem($_TABLES['users'], "fullname", "uid='$uid'");
    $retval .= '<tr>
                    <td align="right"><b>Full Name:</b></td>
                    <td>' . $fullname .'</td>
                 </tr>';
    $retval .= '<tr>
                    <td align="right"><b>Graduation Year:</b></td>
                    <td>' . $grad_year .'</td>
                 </tr>';
    return $retval;

}


/* Function called when editing user profile. */
/* Called from usersettings.php - when user is eding their own profile  */
/* and from admin/user.php when admin is editing a member profile  */
/* This function will return any extra fields that need to be shown for editing */
/* Output is then replaced in {customfields} -- This variable needs to be added to your templates */
/* User: path_layout/preferences/profile.thtml and Admin: path_layout/admin/user/edituser.thtml */

function custom_useredit($uid) {
    global $_TABLES,$_CONF;

    $grad_year = DB_getItem($_TABLES['localuserinfo'], "grad_year", "uid='$uid'");
    $fullname = DB_getItem($_TABLES['users'], "fullname", "uid='$uid'");

    $retval .= '<tr>
        <td align="right"><b>Full Name:</b></td>
        <td><input type="text" name="cust_fullname" size="50" value="' . $fullname .'"></td>
     </tr>';
    $retval .= '<tr>
        <td align="right"><b>Graduation Year:</b></td>
        <td><input type="text" name="cust_gradyear" size="5" maxlength="4" value="' . $grad_year .'"></td>
     </tr>';
    $retval .= '<tr><td colspan="2"><hr></td></tr>';
   return $retval;
}

/* Function called when saving the user profile. */
function custom_usersave($uid) {
    global $_TABLES;

    $grad_year = COM_applyFilter($_POST['cust_gradyear'],true);
    $fullname  = COM_applyFilter($_POST['fullname']);

    DB_query("UPDATE {$_TABLES['users']} SET fullname='$fullname' WHERE uid='$uid'");
    if ($grad_year > 0) {
        DB_query("UPDATE {$_TABLES['localuserinfo']} SET grad_year='$grad_year' WHERE uid='$uid'");
    }

}


/* Main Form used for Custom membership when member is registering */
function custom_userform($uid="",$msg="") {
    global $_CONF,$_TABLES, $LANG04;

    if (!empty($msg)) {
        $retval .= COM_startBlock($LANG04[21]) . $msg . COM_endBlock();
    }

    $post_url = $_CONF['site_url']."/users.php";
    $postmode = "create";
    $submitbutton = '<input type="submit" value="Register Now!">';
    $passwd_input = "";
    $message = "<br><font color=black><b>Please complete the application below. Once you have completed the application, click the Submit button and the application will be processed immediately.</b></font>";
    $A=array();

    $user_templates = new Template ($_CONF['path_layout'] . 'custom');
    $user_templates->set_file('memberdetail', 'memberdetail.thtml');
    $user_templates->set_var('layout_url', $_CONF['layout_url']);
    $user_templates->set_var('post_url', $post_url);
    $user_templates->set_var('startblock', COM_startBlock("Custom Registration Example"));
    $user_templates->set_var('message', $message);    
    $user_templates->set_var('USERNAME', "Username");
    $user_templates->set_var('USERNAME_HELP', "Name to be used when accessing this site");
    $user_templates->set_var('username', $A['username']);
    $user_templates->set_var('passwd_input', $passwd_input);
    $user_templates->set_var('EMAIL', "Email Address");
    $user_templates->set_var('EMAIL_HELP', "Valid email address");
    $user_templates->set_var('email', $A['email']);
    $user_templates->set_var('FULLNAME', "Full Name");
    $user_templates->set_var('FULLNAME_HELP', "First and Last Name");
    $user_templates->set_var('fullname', $A['fullname']);
    $user_templates->set_var('GRADYEAR', "Graduation Year");
    $user_templates->set_var('GRADYEAR_HELP', "That big year!");
    $user_templates->set_var('grad_year', "");
    $user_templates->set_var('user_id', $user);
    $user_templates->set_var('postmode', $postmode);
    $user_templates->set_var('submitbutton', $submitbutton);
    $user_templates->set_var('endblock', COM_endBlock());
    $user_templates->parse('output', 'memberdetail');
    $retval .= $user_templates->finish($user_templates->get_var('output'));

    return $retval;
}

/**
* Check if it's okay to create a new user.
*
* Geeklog is about to create a new user with the given username and email
* address. This is the custom code's last chance to prevent that,
* e.g. to check if all required data has been entered.
*
* @param    string  $username   username that Geeklog would use for the new user* @param    string  $email      email address of that user
* @return   string              an error message or an empty string for "OK"
*
*/
function custom_usercheck ($username, $email)
{
    $msg = '';

    // Example, check that the full name has been entered
    // and complain if it's missing
    if (empty ($_POST['fullname'])) {
        $msg = 'Please enter your full name!';
    }

    return $msg;
}


/**
* Custom function to retrieve and return a formatted list of blocks
* Can be used when calling COM_siteHeader or COM_SiteFooter

* Example:
* 1: Setup an array of blocks to display
* 2: Call COM_siteHeader or COM_siteFooter
*
*  $myblocks = array ('site_menu','site_news','poll_block');

* COM_siteHeader( array('COM_showCustomBlocks',$myblocks) ) ;
* COM_siteFooter( true, array('COM_showCustomBlocks',$myblocks));

* @param   array   $showblocks    An array of block names to retrieve and format
* @return  string                 Formated HTML containing site footer and optionally right blocks
*/
function custom_showBlocks($showblocks)
{
    global $_CONF, $_TABLES;

    $retval = '';
    foreach($showblocks as $block) {
        $sql = "SELECT bid, name,type,title,content,rdfurl,phpblockfn,help FROM {$_TABLES['blocks']} WHERE name='$block'";
        $result = DB_query($sql);
        if (DB_numRows($result) == 1) {
            $A = DB_fetchArray($result);
            $retval .= COM_formatBlock($A);
        }
    }

    return $retval;
}


/**
* This is an example of a custom email function. When this function is NOT
* commented out, Geeklog would send all emails through this function
* instead of sending them through COM_mail in lib-common.php.
*
* This is basically a re-implementation of the way emails were sent
* prior to Geeklog 1.3.9 (Geeklog uses PEAR::Mail as of version 1.3.9).
*
*/
/*
function CUSTOM_mail($to, $subject, $message, $from = '', $html = false, $priority = 0)
{
    global $_CONF, $LANG_CHARSET;

    if (empty ($LANG_CHARSET)) {
        $charset = $_CONF['default_charset'];
        if (empty ($charset)) {
            $charset = 'iso-8859-1';
        }
    } else {
        $charset = $LANG_CHARSET;
    }

    if (empty ($from)) {
        $from = $_CONF['site_name'] . ' <' . $_CONF['site_mail'] . '>';
    }

    $headers  = 'From: ' . $from . "rn"
              . 'X-Mailer: Geeklog ' . VERSION . "rn";

    if ($priority > 0) {
        $headers .= 'X-Priority: ' . $priority . "rn";
    }

    if ($html) {
        $headers .= "Content-Type: text/html; charset={$charset}rn"
                 .  'Content-Transfer-Encoding: 8bit';
    } else {
        $headers .= "Content-Type: text/plain; charset={$charset}";
    }

    return mail ($to, $subject, $message, $headers);
}
*/

/**
* This is an example of a function that returns menu entries to be used for
* the 'custom' entry in $_CONF['menu_elements'] (see config.php).
*
*/
/*
function CUSTOM_menuEntries ()
{
    global $_CONF, $_USER;

    $myentries = array ();

    // Sample link #1: Link to Gallery
    $myentries[] = array ('url'   => $_CONF['site_url'] . '/gallery/',
                          'label' => 'Gallery');

    // Sample link #2: Link to the Personal Calendar - only visible for
    // logged-in users
    if (!empty ($_USER['uid']) && ($_USER['uid'] > 1)) {
        $myentries[] = array ('url'   => $_CONF['site_url']
                                         . '/calendar.php?mode=personal',
                              'label' => 'My Calendar');
    }

    return $myentries;
}
*/

?>




 

{start_block_userprofile}
    <table border="0" cellspacing="0" cellpadding="3">
        <tr valign="top">
            <td align="right"><b>{lang_username}:</b></td>
            <td>{username} ({user_fullname})<br> {user_photo}</td>
        </tr>
        <tr valign="top">
            <td align="right"><b>{lang_membersince}:</b></td>
            <td>{user_regdate}</td>
        </tr>
        <tr valign="top">
            <td align="right"><b>{lang_email}:</b></td>
            <td><a href="{site_url}/profiles.php?uid={user_id}">{lang_sendemail}</a></td>
        </tr>
        <tr valign="top">
            <td align="right"><b>{lang_homepage}:</b></td>
            <td><a href="{user_homepage}">{user_homepage}</a></td>
        </tr>
        <tr valign="top">
            <td align="right"><b>{lang_location}:</b></td>
            <td>{user_location}</td>
        </tr>
        {customfields}
        <tr valign="top">
            <td align="right"><b>{lang_bio}:</b></td>
            <td>{user_bio}</td>
        </tr>

    </table>
{end_block}
{start_block_last10stories}
    <table border="0" cellpadding="3" cellspacing="0" width="100%">
        <tr>
            <td>
                <table border="0" cellspacing="0" cellpadding="3">
                    {story_row}
                </table>
            </td>
        </tr>
    </table>
{end_block}
{start_block_last10comments}
    <table border="0" cellpadding="3" cellspacing="0" width="100%">
        <tr>
            <td>
                <table border="0" cellspacing="0" cellpadding="3">
                    {comment_row}
                </table>
            </td>
        </tr>
    </table>
{end_block}
{start_block_postingstats}
    <table border="0" cellpadding="3" cellspacing="0" width="100%">
        <tr>
            <td>
                <table border="0" cellspacing="0" cellpadding="3" width="100%">
                    <tr>
                        <td>{lang_number_stories}</td>
                        <td>{number_stories}</td>
                    </tr>
                    <tr>
                        <td>{lang_number_comments}</td>
                        <td>{number_comments}</td>
                    </tr>
                    <tr>
                        <td colspan="2"><a href="{site_url}/search.php?query=&datestart=&dateend=&topic=0&type=all&author={user_id}&mode=search">{lang_all_postings_by}</a></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
{end_block}




 

{start_block_profile}
<form action="{site_url}/usersettings.php" method="POST" {enctype}>
<table border="0" cellspacing="0" cellpadding="3">
  {username_option}
  <tr valign="top">
    <td align="right"><b>{lang_fullname}</b><br>
      <small>{lang_fullname_text}</small></td>
    <td><input type="text" name="fullname" size="60" maxlength="80"
      value="{fullname_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_password}</b><br>
      <small>{lang_password_text}</small></td>
    <td><input type="password" name="passwd" size="32" maxlength="32"
      value="{password_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_cooktime}</b><br>
      <small>{lang_cooktime_text}</small></td>
    <td>{cooktime_selector}</td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_email}</b><br>
      <small>{lang_email_text}</small></td>
    <td><input type="text" name="email" size="60" maxlength="96"
      value="{email_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_homepage}</b><br>
      <small>{lang_homepage_text}</small></td>
    <td><input type="text" name="homepage" size="60" maxlength="96"
      value="{homepage_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_location}</b><br>
      <small>{lang_location_text}</small></td>
    <td><input type="text" name="location" size="60" maxlength="96"
      value="{location_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_signature}</b><br>
      <small>{lang_signature_text}</small></td>
    <td><textarea name="sig" cols="60" rows="4">{signature_value}




 

-- MySQL dump 9.11
--
-- Host: localhost    Database: nameof_database
-- ------------------------------------------------------
-- Server version       4.0.25-standard

--
-- Table structure for table `gl_access`
--

CREATE TABLE `gl_access` (
  `acc_ft_id` mediumint(8) NOT NULL default '0',
  `acc_grp_id` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`acc_ft_id`,`acc_grp_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_access`
--

INSERT INTO `gl_access` VALUES (1,3);
INSERT INTO `gl_access` VALUES (2,3);
INSERT INTO `gl_access` VALUES (3,5);
INSERT INTO `gl_access` VALUES (4,5);
INSERT INTO `gl_access` VALUES (5,9);
INSERT INTO `gl_access` VALUES (5,11);
INSERT INTO `gl_access` VALUES (6,9);
INSERT INTO `gl_access` VALUES (6,11);
INSERT INTO `gl_access` VALUES (7,12);
INSERT INTO `gl_access` VALUES (8,7);
INSERT INTO `gl_access` VALUES (9,7);
INSERT INTO `gl_access` VALUES (10,4);
INSERT INTO `gl_access` VALUES (11,6);
INSERT INTO `gl_access` VALUES (12,8);
INSERT INTO `gl_access` VALUES (13,10);
INSERT INTO `gl_access` VALUES (14,11);
INSERT INTO `gl_access` VALUES (15,11);
INSERT INTO `gl_access` VALUES (16,4);
INSERT INTO `gl_access` VALUES (17,14);
INSERT INTO `gl_access` VALUES (18,14);
INSERT INTO `gl_access` VALUES (23,15);

--
-- Table structure for table `gl_article_images`
--

CREATE TABLE `gl_article_images` (
  `ai_sid` varchar(40) NOT NULL default '',
  `ai_img_num` tinyint(2) unsigned NOT NULL default '0',
  `ai_filename` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`ai_sid`,`ai_img_num`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_article_images`
--


--
-- Table structure for table `gl_blocks`
--

CREATE TABLE `gl_blocks` (
  `bid` smallint(5) unsigned NOT NULL auto_increment,
  `is_enabled` tinyint(1) unsigned NOT NULL default '1',
  `name` varchar(48) NOT NULL default '',
  `type` varchar(20) NOT NULL default 'normal',
  `title` varchar(48) default NULL,
  `tid` varchar(20) NOT NULL default 'All',
  `blockorder` smallint(5) unsigned NOT NULL default '1',
  `content` text,
  `rdfurl` varchar(255) default NULL,
  `rdfupdated` datetime NOT NULL default '0000-00-00 00:00:00',
  `onleft` tinyint(3) unsigned NOT NULL default '1',
  `phpblockfn` varchar(64) default '',
  `help` varchar(128) default '',
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY  (`bid`),
  KEY `blocks_bid` (`bid`),
  KEY `blocks_is_enabled` (`is_enabled`),
  KEY `blocks_tid` (`tid`),
  KEY `blocks_type` (`type`),
  KEY `blocks_name` (`name`),
  KEY `blocks_onleft` (`onleft`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_blocks`
--

INSERT INTO `gl_blocks` VALUES (1,1,'user_block','gldefault','User Functions','all',2,'','','0000-00-00 00:00:00',1,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (2,1,'admin_block','gldefault','Admins Only','all',1,'','','0000-00-00 00:00:00',1,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (3,1,'section_block','gldefault','Topics','all',0,'','','0000-00-00 00:00:00',1,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (4,1,'poll_block','gldefault','Poll','all',2,'','','0000-00-00 00:00:00',0,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (5,1,'events_block','gldefault','Events','all',4,'','','0000-00-00 00:00:00',1,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (6,1,'whats_new_block','gldefault','What\'s New','all',3,'','','0000-00-00 00:00:00',0,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (7,1,'first_block','normal','About GeekLog','homeonly',1,'<p><b>Welcome to GeekLog!</b><p>If you\'re already familiar with GeekLog - and especially if you\'re not: There have been many improvements to GeekLog since earlier versions that you might want to read up on. Please read the <a href=\"docs/changes.html\">release notes</a>. If you need help, please see the <a href=\"docs/support.html\">support options</a>.','','0000-00-00 00:00:00',0,'','',4,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (8,1,'whosonline_block','phpblock','Who\'s Online','all',0,'','','0000-00-00 00:00:00',0,'phpblock_whosonline','',4,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (9,1,'older_stories','gldefault','Older Stories','all',5,'','','0000-00-00 00:00:00',1,'','',1,2,3,3,2,2);
INSERT INTO `gl_blocks` VALUES (10,1,'security_check','phpblock','Are you secure?','homeonly',3,'','','0000-00-00 00:00:00',1,'phpblock_getBent','',1,2,3,3,0,0);
INSERT INTO `gl_blocks` VALUES (11,1,'latestphpbbposts','phpblock','Latest Forum Posts','all',0,NULL,NULL,'0000-00-00 00:00:00',0,'phpblock_phpbbbridge_newtopics','',2,2,3,3,2,2);

--
-- Table structure for table `gl_commentcodes`
--

CREATE TABLE `gl_commentcodes` (
  `code` tinyint(4) NOT NULL default '0',
  `name` varchar(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_commentcodes`
--

INSERT INTO `gl_commentcodes` VALUES (0,'Comments Enabled');
INSERT INTO `gl_commentcodes` VALUES (-1,'Comments Disabled');

--
-- Table structure for table `gl_commentmodes`
--

CREATE TABLE `gl_commentmodes` (
  `mode` varchar(10) NOT NULL default '',
  `name` varchar(32) default NULL,
  PRIMARY KEY  (`mode`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_commentmodes`
--

INSERT INTO `gl_commentmodes` VALUES ('flat','Flat');
INSERT INTO `gl_commentmodes` VALUES ('nested','Nested');
INSERT INTO `gl_commentmodes` VALUES ('threaded','Threaded');
INSERT INTO `gl_commentmodes` VALUES ('nocomment','No Comments');

--
-- Table structure for table `gl_comments`
--

CREATE TABLE `gl_comments` (
  `cid` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(30) NOT NULL default 'article',
  `sid` varchar(40) NOT NULL default '',
  `date` datetime default NULL,
  `title` varchar(128) default NULL,
  `comment` text,
  `score` tinyint(4) NOT NULL default '0',
  `reason` tinyint(4) NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `lft` mediumint(10) unsigned NOT NULL default '0',
  `rht` mediumint(10) unsigned NOT NULL default '0',
  `indent` mediumint(10) unsigned NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '1',
  `ipaddress` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`cid`),
  KEY `comments_sid` (`sid`),
  KEY `comments_uid` (`uid`),
  KEY `comments_lft` (`lft`),
  KEY `comments_rht` (`rht`),
  KEY `comments_date` (`date`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_comments`
--


--
-- Table structure for table `gl_cookiecodes`
--

CREATE TABLE `gl_cookiecodes` (
  `cc_value` int(8) unsigned NOT NULL default '0',
  `cc_descr` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`cc_value`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_cookiecodes`
--

INSERT INTO `gl_cookiecodes` VALUES (0,'(don\'t)');
INSERT INTO `gl_cookiecodes` VALUES (3600,'1 Hour');
INSERT INTO `gl_cookiecodes` VALUES (7200,'2 Hours');
INSERT INTO `gl_cookiecodes` VALUES (10800,'3 Hours');
INSERT INTO `gl_cookiecodes` VALUES (28800,'8 Hours');
INSERT INTO `gl_cookiecodes` VALUES (86400,'1 Day');
INSERT INTO `gl_cookiecodes` VALUES (604800,'1 Week');
INSERT INTO `gl_cookiecodes` VALUES (2678400,'1 Month');

--
-- Table structure for table `gl_dateformats`
--

CREATE TABLE `gl_dateformats` (
  `dfid` tinyint(4) NOT NULL default '0',
  `format` varchar(32) default NULL,
  `description` varchar(64) default NULL,
  PRIMARY KEY  (`dfid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_dateformats`
--

INSERT INTO `gl_dateformats` VALUES (0,'','System Default');
INSERT INTO `gl_dateformats` VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March 21, 1999 @10:00PM');
INSERT INTO `gl_dateformats` VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21, 1999 @22:00');
INSERT INTO `gl_dateformats` VALUES (4,'%A %b %d @%H:%M','Sunday March 21 @22:00');
INSERT INTO `gl_dateformats` VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999');
INSERT INTO `gl_dateformats` VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21 March 1999');
INSERT INTO `gl_dateformats` VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21 1999');
INSERT INTO `gl_dateformats` VALUES (8,'%a %B %d, %I:%M%p','Sun March 21, 10:00PM');
INSERT INTO `gl_dateformats` VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00');
INSERT INTO `gl_dateformats` VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00');
INSERT INTO `gl_dateformats` VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00');
INSERT INTO `gl_dateformats` VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM');
INSERT INTO `gl_dateformats` VALUES (13,'%I:%M%p  %B %D, %Y','10:00PM  March 21st, 1999');
INSERT INTO `gl_dateformats` VALUES (14,'%a %b %d, \'%y %I:%M%p','Sun Mar 21, \'99 10:00PM');
INSERT INTO `gl_dateformats` VALUES (15,'Day %j, %I ish','Day 80, 10 ish');
INSERT INTO `gl_dateformats` VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00');
INSERT INTO `gl_dateformats` VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00');
INSERT INTO `gl_dateformats` VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar 10:00PM');

--
-- Table structure for table `gl_events`
--

CREATE TABLE `gl_events` (
  `eid` varchar(20) NOT NULL default '',
  `title` varchar(128) default NULL,
  `description` text,
  `datestart` date default NULL,
  `dateend` date default NULL,
  `url` varchar(255) default NULL,
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  `address1` varchar(40) default NULL,
  `address2` varchar(40) default NULL,
  `city` varchar(60) default NULL,
  `state` char(2) default NULL,
  `zipcode` varchar(5) default NULL,
  `allday` tinyint(1) NOT NULL default '0',
  `event_type` varchar(40) NOT NULL default '',
  `location` varchar(128) default NULL,
  `timestart` time default NULL,
  `timeend` time default NULL,
  PRIMARY KEY  (`eid`),
  KEY `events_eid` (`eid`),
  KEY `events_event_type` (`event_type`),
  KEY `events_datestart` (`datestart`),
  KEY `events_dateend` (`dateend`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_events`
--


--
-- Table structure for table `gl_eventsubmission`
--

CREATE TABLE `gl_eventsubmission` (
  `eid` varchar(20) NOT NULL default '',
  `title` varchar(128) default NULL,
  `description` text,
  `location` varchar(128) default NULL,
  `datestart` date default NULL,
  `dateend` date default NULL,
  `url` varchar(255) default NULL,
  `allday` tinyint(1) NOT NULL default '0',
  `zipcode` varchar(5) default NULL,
  `state` char(2) default NULL,
  `city` varchar(60) default NULL,
  `address2` varchar(40) default NULL,
  `address1` varchar(40) default NULL,
  `event_type` varchar(40) NOT NULL default '',
  `timestart` time default NULL,
  `timeend` time default NULL,
  PRIMARY KEY  (`eid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_eventsubmission`
--

INSERT INTO `gl_eventsubmission` VALUES ('2004100114064662','Test event','test','Test','2004-10-02','2004-10-03','http://www.tonybibbs.com/',0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL);

--
-- Table structure for table `gl_featurecodes`
--

CREATE TABLE `gl_featurecodes` (
  `code` tinyint(4) NOT NULL default '0',
  `name` varchar(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_featurecodes`
--

INSERT INTO `gl_featurecodes` VALUES (0,'Not Featured');
INSERT INTO `gl_featurecodes` VALUES (1,'Featured');

--
-- Table structure for table `gl_features`
--

CREATE TABLE `gl_features` (
  `ft_id` mediumint(8) NOT NULL auto_increment,
  `ft_name` varchar(20) NOT NULL default '',
  `ft_descr` varchar(255) NOT NULL default '',
  `ft_gl_core` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ft_id`),
  KEY `ft_name` (`ft_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_features`
--

INSERT INTO `gl_features` VALUES (1,'story.edit','Access to story editor',1);
INSERT INTO `gl_features` VALUES (2,'story.moderate','Ablility to moderate pending stories',1);
INSERT INTO `gl_features` VALUES (3,'link.moderate','Ablility to moderate pending links',1);
INSERT INTO `gl_features` VALUES (4,'link.edit','Access to link editor',1);
INSERT INTO `gl_features` VALUES (5,'user.edit','Access to user editor',1);
INSERT INTO `gl_features` VALUES (6,'user.delete','Ablility to delete a user',1);
INSERT INTO `gl_features` VALUES (7,'user.mail','Ablility to send email to members',1);
INSERT INTO `gl_features` VALUES (8,'event.moderate','Ablility to moderate pending events',1);
INSERT INTO `gl_features` VALUES (9,'event.edit','Access to event editor',1);
INSERT INTO `gl_features` VALUES (10,'block.edit','Access to block editor',1);
INSERT INTO `gl_features` VALUES (11,'topic.edit','Access to topic editor',1);
INSERT INTO `gl_features` VALUES (12,'poll.edit','Access to poll editor',1);
INSERT INTO `gl_features` VALUES (13,'plugin.edit','Access to plugin editor',1);
INSERT INTO `gl_features` VALUES (14,'group.edit','Ability to edit groups',1);
INSERT INTO `gl_features` VALUES (15,'group.delete','Ability to delete groups',1);
INSERT INTO `gl_features` VALUES (16,'block.delete','Ability to delete a block',1);
INSERT INTO `gl_features` VALUES (17,'staticpages.edit','Ability to edit a static page',0);
INSERT INTO `gl_features` VALUES (18,'staticpages.delete','Ability to delete static pages',0);
INSERT INTO `gl_features` VALUES (19,'story.submit','May skip the story submission queue',1);
INSERT INTO `gl_features` VALUES (20,'link.submit','May skip the link submission queue',1);
INSERT INTO `gl_features` VALUES (21,'event.submit','May skip the event submission queue',1);
INSERT INTO `gl_features` VALUES (22,'staticpages.PHP','Ability use PHP in static pages',0);
INSERT INTO `gl_features` VALUES (23,'spamx.admin','spamx Admin',0);

--
-- Table structure for table `gl_frontpagecodes`
--

CREATE TABLE `gl_frontpagecodes` (
  `code` tinyint(4) NOT NULL default '0',
  `name` varchar(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_frontpagecodes`
--

INSERT INTO `gl_frontpagecodes` VALUES (0,'Show Only in Topic');
INSERT INTO `gl_frontpagecodes` VALUES (1,'Show on Front Page');

--
-- Table structure for table `gl_group_assignments`
--

CREATE TABLE `gl_group_assignments` (
  `ug_main_grp_id` mediumint(8) NOT NULL default '0',
  `ug_uid` mediumint(8) unsigned default NULL,
  `ug_grp_id` mediumint(8) unsigned default NULL,
  KEY `group_assignments_ug_main_grp_id` (`ug_main_grp_id`),
  KEY `ug_main_grp_id` (`ug_main_grp_id`),
  KEY `group_assignments_ug_uid` (`ug_uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_group_assignments`
--

INSERT INTO `gl_group_assignments` VALUES (2,1,NULL);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (3,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (4,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (5,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (6,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (7,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (8,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (9,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (10,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (11,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (13,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (12,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (11,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,12);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,10);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,9);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,8);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,7);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,6);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,5);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,4);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,3);
INSERT INTO `gl_group_assignments` VALUES (12,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (9,NULL,11);
INSERT INTO `gl_group_assignments` VALUES (2,NULL,11);
INSERT INTO `gl_group_assignments` VALUES (2,3,NULL);
INSERT INTO `gl_group_assignments` VALUES (3,3,NULL);
INSERT INTO `gl_group_assignments` VALUES (5,3,NULL);
INSERT INTO `gl_group_assignments` VALUES (7,3,NULL);
INSERT INTO `gl_group_assignments` VALUES (13,3,NULL);
INSERT INTO `gl_group_assignments` VALUES (10,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (9,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (8,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (7,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (6,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (5,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (4,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (3,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (2,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (1,2,NULL);
INSERT INTO `gl_group_assignments` VALUES (14,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (15,NULL,1);
INSERT INTO `gl_group_assignments` VALUES (2,5,NULL);
INSERT INTO `gl_group_assignments` VALUES (13,5,NULL);

--
-- Table structure for table `gl_groups`
--

CREATE TABLE `gl_groups` (
  `grp_id` mediumint(8) NOT NULL auto_increment,
  `grp_name` varchar(50) NOT NULL default '',
  `grp_descr` varchar(255) NOT NULL default '',
  `grp_gl_core` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`grp_id`),
  KEY `grp_name` (`grp_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_groups`
--

INSERT INTO `gl_groups` VALUES (1,'Root','Has full access to the site',1);
INSERT INTO `gl_groups` VALUES (2,'All Users','Group that a typical user is added to',1);
INSERT INTO `gl_groups` VALUES (3,'Story Admin','Has full access to story features',1);
INSERT INTO `gl_groups` VALUES (4,'Block Admin','Has full access to block features',1);
INSERT INTO `gl_groups` VALUES (5,'Link Admin','Has full access to link features',1);
INSERT INTO `gl_groups` VALUES (6,'Topic Admin','Has full access to topic features',1);
INSERT INTO `gl_groups` VALUES (7,'Event Admin','Has full access to event features',1);
INSERT INTO `gl_groups` VALUES (8,'Poll Admin','Has full access to poll features',1);
INSERT INTO `gl_groups` VALUES (9,'User Admin','Has full access to user features',1);
INSERT INTO `gl_groups` VALUES (10,'Plugin Admin','Has full access to plugin features',1);
INSERT INTO `gl_groups` VALUES (11,'Group Admin','Is a User Admin with access to groups, too',1);
INSERT INTO `gl_groups` VALUES (12,'Mail Admin','Can Use Mail Utility',1);
INSERT INTO `gl_groups` VALUES (13,'Logged-in Users','All Registered Members',1);
INSERT INTO `gl_groups` VALUES (14,'Static Page Admin','Can administer static pages',0);
INSERT INTO `gl_groups` VALUES (15,'spamx Admin','Users in this group can administer the Spam-X plugin',0);

--
-- Table structure for table `gl_links`
--

CREATE TABLE `gl_links` (
  `lid` varchar(20) NOT NULL default '',
  `category` varchar(32) default NULL,
  `url` varchar(255) default NULL,
  `description` text,
  `title` varchar(96) default NULL,
  `hits` int(11) NOT NULL default '0',
  `date` datetime default NULL,
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY  (`lid`),
  KEY `links_lid` (`lid`),
  KEY `links_category` (`category`),
  KEY `links_date` (`date`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_links`
--

INSERT INTO `gl_links` VALUES ('20040119095147683','Geeklog Sites','http://www.geeklog.net','All you ever need to know about GeekLog - and more ...','Geeklog Project Homepage',42,NULL,5,2,3,3,2,2);

--
-- Table structure for table `gl_linksubmission`
--

CREATE TABLE `gl_linksubmission` (
  `lid` varchar(20) NOT NULL default '',
  `category` varchar(32) default NULL,
  `url` varchar(255) default NULL,
  `description` text,
  `title` varchar(96) default NULL,
  `hits` int(11) default NULL,
  `date` datetime default NULL,
  PRIMARY KEY  (`lid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_linksubmission`
--


--
-- Table structure for table `gl_localuserinfo`
--

CREATE TABLE `gl_localuserinfo` (
  `uid` mediumint(8) NOT NULL default '0',
  `grad_year` varchar(4) NOT NULL default '',
  KEY `uid` (`uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_localuserinfo`
--

INSERT INTO `gl_localuserinfo` VALUES (5,'87');

--
-- Table structure for table `gl_maillist`
--

CREATE TABLE `gl_maillist` (
  `code` int(1) NOT NULL default '0',
  `name` char(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_maillist`
--

INSERT INTO `gl_maillist` VALUES (0,'Don\'t Email');
INSERT INTO `gl_maillist` VALUES (1,'Email Headlines Each Night');

--
-- Table structure for table `gl_personal_events`
--

CREATE TABLE `gl_personal_events` (
  `eid` varchar(20) NOT NULL default '',
  `title` varchar(128) default NULL,
  `event_type` varchar(40) NOT NULL default '',
  `datestart` date default NULL,
  `dateend` date default NULL,
  `address1` varchar(40) default NULL,
  `address2` varchar(40) default NULL,
  `city` varchar(60) default NULL,
  `state` char(2) default NULL,
  `zipcode` varchar(5) default NULL,
  `allday` tinyint(1) NOT NULL default '0',
  `url` varchar(255) default NULL,
  `description` text,
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  `uid` mediumint(8) NOT NULL default '0',
  `location` varchar(128) default NULL,
  `timestart` time default NULL,
  `timeend` time default NULL,
  PRIMARY KEY  (`eid`,`uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_personal_events`
--


--
-- Table structure for table `gl_plugins`
--

CREATE TABLE `gl_plugins` (
  `pi_name` varchar(30) NOT NULL default '',
  `pi_version` varchar(20) NOT NULL default '',
  `pi_gl_version` varchar(20) NOT NULL default '',
  `pi_enabled` tinyint(3) unsigned NOT NULL default '1',
  `pi_homepage` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`pi_name`),
  KEY `plugins_enabled` (`pi_enabled`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_plugins`
--

INSERT INTO `gl_plugins` VALUES ('staticpages','1.4.1','1.3.10',1,'http://www.tonybibbs.com');
INSERT INTO `gl_plugins` VALUES ('spamx','1.0.2','1.3.10',1,'http://www.pigstye.net/gplugs/staticpages/index.php/spamx');
INSERT INTO `gl_plugins` VALUES ('phpbbbridge','104','1.3.10',1,'http://demo.dogcows.net/');

--
-- Table structure for table `gl_pollanswers`
--

CREATE TABLE `gl_pollanswers` (
  `qid` varchar(20) NOT NULL default '',
  `aid` tinyint(3) unsigned NOT NULL default '0',
  `answer` varchar(255) default NULL,
  `votes` mediumint(8) unsigned default NULL,
  PRIMARY KEY  (`qid`,`aid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_pollanswers`
--

INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',1,'Professional theme',0);
INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',2,'Spam-X plugin included',0);
INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',3,'Story Archive feature',0);
INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',4,'Clickable links in text mode',0);
INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',5,'Autolinks / Autotags',0);
INSERT INTO `gl_pollanswers` VALUES ('geeklogfeaturepoll',6,'Other',0);

--
-- Table structure for table `gl_pollquestions`
--

CREATE TABLE `gl_pollquestions` (
  `qid` varchar(20) NOT NULL default '',
  `question` varchar(255) default NULL,
  `voters` mediumint(8) unsigned default NULL,
  `date` datetime default NULL,
  `display` tinyint(4) NOT NULL default '0',
  `commentcode` tinyint(4) NOT NULL default '0',
  `statuscode` tinyint(4) NOT NULL default '0',
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY  (`qid`),
  KEY `pollquestions_qid` (`qid`),
  KEY `pollquestions_display` (`display`),
  KEY `pollquestions_commentcode` (`commentcode`),
  KEY `pollquestions_statuscode` (`statuscode`),
  KEY `pollquestions_date` (`date`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_pollquestions`
--

INSERT INTO `gl_pollquestions` VALUES ('geeklogfeaturepoll','What is the best new feature of Geeklog?',0,'2004-01-01 12:43:20',1,0,0,8,2,3,3,2,2);

--
-- Table structure for table `gl_pollvoters`
--

CREATE TABLE `gl_pollvoters` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `qid` varchar(20) NOT NULL default '',
  `ipaddress` varchar(15) NOT NULL default '',
  `date` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_pollvoters`
--


--
-- Table structure for table `gl_postmodes`
--

CREATE TABLE `gl_postmodes` (
  `code` char(10) NOT NULL default '',
  `name` char(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_postmodes`
--

INSERT INTO `gl_postmodes` VALUES ('plaintext','Plain Old Text');
INSERT INTO `gl_postmodes` VALUES ('html','HTML Formatted');

--
-- Table structure for table `gl_sessions`
--

CREATE TABLE `gl_sessions` (
  `sess_id` int(10) unsigned NOT NULL default '0',
  `start_time` int(10) unsigned NOT NULL default '0',
  `remote_ip` varchar(15) NOT NULL default '',
  `uid` mediumint(8) NOT NULL default '1',
  `md5_sess_id` varchar(128) default NULL,
  PRIMARY KEY  (`sess_id`),
  KEY `sess_id` (`sess_id`),
  KEY `start_time` (`start_time`),
  KEY `remote_ip` (`remote_ip`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_sessions`
--

INSERT INTO `gl_sessions` VALUES (760927543,1134853739,'69.86.253.20',2,NULL);

--
-- Table structure for table `gl_sortcodes`
--

CREATE TABLE `gl_sortcodes` (
  `code` char(4) NOT NULL default '0',
  `name` char(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_sortcodes`
--

INSERT INTO `gl_sortcodes` VALUES ('ASC','Oldest First');
INSERT INTO `gl_sortcodes` VALUES ('DESC','Newest First');

--
-- Table structure for table `gl_spamx`
--

CREATE TABLE `gl_spamx` (
  `name` varchar(20) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  KEY `spamx_name` (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_spamx`
--


--
-- Table structure for table `gl_speedlimit`
--

CREATE TABLE `gl_speedlimit` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ipaddress` varchar(15) NOT NULL default '',
  `date` int(10) unsigned default NULL,
  `type` varchar(30) NOT NULL default 'submit',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_speedlimit`
--

INSERT INTO `gl_speedlimit` VALUES (13,'69.86.253.20',1134853712,'login');

--
-- Table structure for table `gl_staticpage`
--

CREATE TABLE `gl_staticpage` (
  `sp_id` varchar(40) NOT NULL default '',
  `sp_uid` mediumint(8) NOT NULL default '1',
  `sp_title` varchar(128) NOT NULL default '',
  `sp_content` text NOT NULL,
  `sp_hits` mediumint(8) unsigned NOT NULL default '0',
  `sp_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `sp_format` varchar(20) NOT NULL default '',
  `sp_onmenu` tinyint(1) unsigned NOT NULL default '0',
  `sp_label` varchar(64) default NULL,
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '2',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  `sp_centerblock` tinyint(1) unsigned NOT NULL default '0',
  `sp_tid` varchar(20) NOT NULL default 'none',
  `sp_where` tinyint(1) unsigned NOT NULL default '1',
  `sp_php` tinyint(1) unsigned NOT NULL default '0',
  `sp_nf` tinyint(1) unsigned default '0',
  `sp_inblock` tinyint(1) unsigned default '1',
  PRIMARY KEY  (`sp_id`),
  KEY `staticpage_sp_uid` (`sp_uid`),
  KEY `staticpage_sp_date` (`sp_date`),
  KEY `staticpage_sp_onmenu` (`sp_onmenu`),
  KEY `staticpage_sp_centerblock` (`sp_centerblock`),
  KEY `staticpage_sp_tid` (`sp_tid`),
  KEY `staticpage_sp_where` (`sp_where`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_staticpage`
--


--
-- Table structure for table `gl_statuscodes`
--

CREATE TABLE `gl_statuscodes` (
  `code` int(1) NOT NULL default '0',
  `name` char(32) default NULL,
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_statuscodes`
--

INSERT INTO `gl_statuscodes` VALUES (1,'Refreshing');
INSERT INTO `gl_statuscodes` VALUES (0,'Normal');
INSERT INTO `gl_statuscodes` VALUES (10,'Archive');

--
-- Table structure for table `gl_stories`
--

CREATE TABLE `gl_stories` (
  `sid` varchar(40) NOT NULL default '',
  `uid` mediumint(8) NOT NULL default '1',
  `draft_flag` tinyint(3) unsigned default '0',
  `tid` varchar(20) NOT NULL default 'General',
  `date` datetime default NULL,
  `title` varchar(128) default NULL,
  `introtext` text,
  `bodytext` text,
  `hits` mediumint(8) unsigned NOT NULL default '0',
  `numemails` mediumint(8) unsigned NOT NULL default '0',
  `comments` mediumint(8) unsigned NOT NULL default '0',
  `related` text,
  `featured` tinyint(3) unsigned NOT NULL default '0',
  `show_topic_icon` tinyint(1) unsigned NOT NULL default '1',
  `commentcode` tinyint(4) NOT NULL default '0',
  `statuscode` tinyint(4) NOT NULL default '0',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `postmode` varchar(10) NOT NULL default 'html',
  `frontpage` tinyint(3) unsigned default '1',
  `owner_id` mediumint(8) NOT NULL default '1',
  `group_id` mediumint(8) NOT NULL default '2',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY  (`sid`),
  KEY `stories_sid` (`sid`),
  KEY `stories_tid` (`tid`),
  KEY `stories_uid` (`uid`),
  KEY `stories_featured` (`featured`),
  KEY `stories_hits` (`hits`),
  KEY `stories_statuscode` (`statuscode`),
  KEY `stories_expire` (`expire`),
  KEY `stories_date` (`date`),
  KEY `stories_frontpage` (`frontpage`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_stories`
--

INSERT INTO `gl_stories` VALUES ('20040101093000103',2,0,'GeekLog','2004-01-01 09:30:00','Welcome to Geeklog!','<p>Welcome This site portion of the site is not opererational at this time.','',101,1,0,'',1,1,0,0,'1999-11-30 12:00:52','html',1,2,3,3,3,2,2);

--
-- Table structure for table `gl_storysubmission`
--

CREATE TABLE `gl_storysubmission` (
  `sid` varchar(20) NOT NULL default '',
  `uid` mediumint(8) NOT NULL default '1',
  `tid` varchar(20) NOT NULL default 'General',
  `title` varchar(128) default NULL,
  `introtext` text,
  `date` datetime default NULL,
  `postmode` varchar(10) NOT NULL default 'html',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_storysubmission`
--

INSERT INTO `gl_storysubmission` VALUES ('20040101120556538',2,'GeekLog','Are you secure?','<p>This is a reminder to secure your site once you have Geeklog up and running. What you should do:</p>\r\r<ol>\r<li>Change the default password for all Admin accounts.</li>\r<li>Remove the install directory (you won\'t need it any more).</li>\r</ol>','2004-01-01 12:05:56','html');

--
-- Table structure for table `gl_syndication`
--

CREATE TABLE `gl_syndication` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(30) NOT NULL default 'geeklog',
  `topic` varchar(48) NOT NULL default '::all',
  `format` varchar(20) NOT NULL default 'rss',
  `limits` varchar(5) NOT NULL default '10',
  `content_length` smallint(5) unsigned NOT NULL default '0',
  `title` varchar(40) NOT NULL default '',
  `description` text,
  `filename` varchar(40) NOT NULL default 'geeklog.rdf',
  `charset` varchar(20) NOT NULL default 'UTF-8',
  `language` varchar(20) NOT NULL default 'en-gb',
  `is_enabled` tinyint(1) unsigned NOT NULL default '1',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `update_info` text,
  PRIMARY KEY  (`fid`),
  KEY `syndication_type` (`type`),
  KEY `syndication_topic` (`topic`),
  KEY `syndication_is_enabled` (`is_enabled`),
  KEY `syndication_updated` (`updated`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_syndication`
--

INSERT INTO `gl_syndication` VALUES (1,'geeklog','::all','rss','10',0,'Geeklog Site','Another Nifty Geeklog Site','geeklog.rdf','UTF-8','en-gb',1,'2005-12-04 22:35:22','20040101093000103');

--
-- Table structure for table `gl_topics`
--

CREATE TABLE `gl_topics` (
  `tid` varchar(20) NOT NULL default '',
  `topic` varchar(48) default NULL,
  `imageurl` varchar(255) default NULL,
  `sortnum` tinyint(3) default NULL,
  `limitnews` tinyint(3) default NULL,
  `is_default` tinyint(1) unsigned NOT NULL default '0',
  `archive_flag` tinyint(1) unsigned NOT NULL default '0',
  `group_id` mediumint(8) unsigned NOT NULL default '1',
  `owner_id` mediumint(8) unsigned NOT NULL default '1',
  `perm_owner` tinyint(1) unsigned NOT NULL default '3',
  `perm_group` tinyint(1) unsigned NOT NULL default '3',
  `perm_members` tinyint(1) unsigned NOT NULL default '2',
  `perm_anon` tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY  (`tid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_topics`
--

INSERT INTO `gl_topics` VALUES ('General','General News','/images/topics/topic_news.gif',1,10,0,0,6,2,3,2,2,2);
INSERT INTO `gl_topics` VALUES ('GeekLog','GeekLog','/images/topics/topic_gl.gif',2,10,0,0,6,2,3,2,2,2);

--
-- Table structure for table `gl_tzcodes`
--

CREATE TABLE `gl_tzcodes` (
  `tz` char(3) NOT NULL default '',
  `offset` int(1) default NULL,
  `description` varchar(64) default NULL,
  PRIMARY KEY  (`tz`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_tzcodes`
--

INSERT INTO `gl_tzcodes` VALUES ('ndt',-9000,'Newfoundland Daylight');
INSERT INTO `gl_tzcodes` VALUES ('adt',-10800,'Atlantic Daylight');
INSERT INTO `gl_tzcodes` VALUES ('edt',-14400,'Eastern Daylight');
INSERT INTO `gl_tzcodes` VALUES ('cdt',-18000,'Central Daylight');
INSERT INTO `gl_tzcodes` VALUES ('mdt',-21600,'Mountain Daylight');
INSERT INTO `gl_tzcodes` VALUES ('pdt',-25200,'Pacific Daylight');
INSERT INTO `gl_tzcodes` VALUES ('ydt',-28800,'Yukon Daylight');
INSERT INTO `gl_tzcodes` VALUES ('hdt',-32400,'Hawaii Daylight');
INSERT INTO `gl_tzcodes` VALUES ('bst',3600,'British Summer');
INSERT INTO `gl_tzcodes` VALUES ('mes',7200,'Middle European Summer');
INSERT INTO `gl_tzcodes` VALUES ('sst',7200,'Swedish Summer');
INSERT INTO `gl_tzcodes` VALUES ('fst',7200,'French Summer');
INSERT INTO `gl_tzcodes` VALUES ('wad',28800,'West Australian Daylight');
INSERT INTO `gl_tzcodes` VALUES ('cad',37800,'Central Australian Daylight');
INSERT INTO `gl_tzcodes` VALUES ('ead',39600,'Eastern Australian Daylight');
INSERT INTO `gl_tzcodes` VALUES ('nzd',46800,'New Zealand Daylight');
INSERT INTO `gl_tzcodes` VALUES ('gmt',0,'Greenwich Mean');
INSERT INTO `gl_tzcodes` VALUES ('utc',0,'Universal (Coordinated)');
INSERT INTO `gl_tzcodes` VALUES ('wet',0,'Western European');
INSERT INTO `gl_tzcodes` VALUES ('wat',-3600,'West Africa');
INSERT INTO `gl_tzcodes` VALUES ('at',-7200,'Azores');
INSERT INTO `gl_tzcodes` VALUES ('gst',-10800,'Greenland Standard');
INSERT INTO `gl_tzcodes` VALUES ('nft',-12600,'Newfoundland');
INSERT INTO `gl_tzcodes` VALUES ('nst',-12600,'Newfoundland Standard');
INSERT INTO `gl_tzcodes` VALUES ('ast',-14400,'Atlantic Standard');
INSERT INTO `gl_tzcodes` VALUES ('est',-18000,'Eastern Standard');
INSERT INTO `gl_tzcodes` VALUES ('cst',-21600,'Central Standard');
INSERT INTO `gl_tzcodes` VALUES ('mst',-25200,'Mountain Standard');
INSERT INTO `gl_tzcodes` VALUES ('pst',-28800,'Pacific Standard');
INSERT INTO `gl_tzcodes` VALUES ('yst',-32400,'Yukon Standard');
INSERT INTO `gl_tzcodes` VALUES ('hst',-36000,'Hawaii Standard');
INSERT INTO `gl_tzcodes` VALUES ('cat',-36000,'Central Alaska');
INSERT INTO `gl_tzcodes` VALUES ('ahs',-36000,'Alaska-Hawaii Standard');
INSERT INTO `gl_tzcodes` VALUES ('nt',-39600,'Nome');
INSERT INTO `gl_tzcodes` VALUES ('idl',-43200,'International Date Line West');
INSERT INTO `gl_tzcodes` VALUES ('cet',3600,'Central European');
INSERT INTO `gl_tzcodes` VALUES ('met',3600,'Middle European');
INSERT INTO `gl_tzcodes` VALUES ('mew',3600,'Middle European Winter');
INSERT INTO `gl_tzcodes` VALUES ('swt',3600,'Swedish Winter');
INSERT INTO `gl_tzcodes` VALUES ('fwt',3600,'French Winter');
INSERT INTO `gl_tzcodes` VALUES ('eet',7200,'Eastern Europe, USSR Zone 1');
INSERT INTO `gl_tzcodes` VALUES ('bt',10800,'Baghdad, USSR Zone 2');
INSERT INTO `gl_tzcodes` VALUES ('it',12600,'Iran');
INSERT INTO `gl_tzcodes` VALUES ('zp4',14400,'USSR Zone 3');
INSERT INTO `gl_tzcodes` VALUES ('zp5',18000,'USSR Zone 4');
INSERT INTO `gl_tzcodes` VALUES ('ist',19800,'Indian Standard');
INSERT INTO `gl_tzcodes` VALUES ('zp6',21600,'USSR Zone 5');
INSERT INTO `gl_tzcodes` VALUES ('was',25200,'West Australian Standard');
INSERT INTO `gl_tzcodes` VALUES ('jt',27000,'Java (3pm in Cronusland!)');
INSERT INTO `gl_tzcodes` VALUES ('cct',28800,'China Coast, USSR Zone 7');
INSERT INTO `gl_tzcodes` VALUES ('jst',32400,'Japan Standard, USSR Zone 8');
INSERT INTO `gl_tzcodes` VALUES ('cas',34200,'Central Australian Standard');
INSERT INTO `gl_tzcodes` VALUES ('eas',36000,'Eastern Australian Standard');
INSERT INTO `gl_tzcodes` VALUES ('nzt',43200,'New Zealand');
INSERT INTO `gl_tzcodes` VALUES ('nzs',43200,'New Zealand Standard');
INSERT INTO `gl_tzcodes` VALUES ('id2',43200,'International Date Line East');
INSERT INTO `gl_tzcodes` VALUES ('idt',10800,'Israel Daylight');
INSERT INTO `gl_tzcodes` VALUES ('iss',7200,'Israel Standard');

--
-- Table structure for table `gl_usercomment`
--

CREATE TABLE `gl_usercomment` (
  `uid` mediumint(8) NOT NULL default '1',
  `commentmode` varchar(10) NOT NULL default 'threaded',
  `commentorder` varchar(4) NOT NULL default 'ASC',
  `commentlimit` mediumint(8) unsigned NOT NULL default '100',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_usercomment`
--

INSERT INTO `gl_usercomment` VALUES (1,'nested','ASC',100);
INSERT INTO `gl_usercomment` VALUES (2,'threaded','ASC',100);
INSERT INTO `gl_usercomment` VALUES (3,'threaded','ASC',100);
INSERT INTO `gl_usercomment` VALUES (5,'threaded','ASC',100);

--
-- Table structure for table `gl_userindex`
--

CREATE TABLE `gl_userindex` (
  `uid` mediumint(8) NOT NULL default '1',
  `tids` varchar(255) NOT NULL default '',
  `etids` varchar(255) NOT NULL default '',
  `aids` varchar(255) NOT NULL default '',
  `boxes` varchar(255) NOT NULL default '',
  `noboxes` tinyint(4) NOT NULL default '0',
  `maxstories` tinyint(4) default NULL,
  PRIMARY KEY  (`uid`),
  KEY `userindex_uid` (`uid`),
  KEY `userindex_noboxes` (`noboxes`),
  KEY `userindex_maxstories` (`maxstories`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_userindex`
--

INSERT INTO `gl_userindex` VALUES (1,'','-','','',0,NULL);
INSERT INTO `gl_userindex` VALUES (2,'','','','',0,NULL);
INSERT INTO `gl_userindex` VALUES (3,'','','','',0,NULL);
INSERT INTO `gl_userindex` VALUES (5,'','-','','',0,NULL);

--
-- Table structure for table `gl_userinfo`
--

CREATE TABLE `gl_userinfo` (
  `uid` mediumint(8) NOT NULL default '1',
  `about` text,
  `location` varchar(96) NOT NULL default '',
  `pgpkey` text,
  `userspace` varchar(255) NOT NULL default '',
  `tokens` tinyint(3) unsigned NOT NULL default '0',
  `totalcomments` mediumint(9) NOT NULL default '0',
  `lastgranted` int(10) unsigned NOT NULL default '0',
  `lastlogin` varchar(10) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_userinfo`
--

INSERT INTO `gl_userinfo` VALUES (1,NULL,'',NULL,'',0,0,0,'0');
INSERT INTO `gl_userinfo` VALUES (2,NULL,'',NULL,'',0,0,0,'1134853725');
INSERT INTO `gl_userinfo` VALUES (3,NULL,'',NULL,'',0,0,0,'1133757433');
INSERT INTO `gl_userinfo` VALUES (5,'','','','',0,0,0,'1133818193');

--
-- Table structure for table `gl_userprefs`
--

CREATE TABLE `gl_userprefs` (
  `uid` mediumint(8) NOT NULL default '1',
  `noicons` tinyint(3) unsigned NOT NULL default '0',
  `willing` tinyint(3) unsigned NOT NULL default '1',
  `dfid` tinyint(3) unsigned NOT NULL default '0',
  `tzid` char(3) NOT NULL default 'edt',
  `emailstories` tinyint(4) NOT NULL default '1',
  `emailfromadmin` tinyint(1) NOT NULL default '1',
  `emailfromuser` tinyint(1) NOT NULL default '1',
  `showonline` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_userprefs`
--

INSERT INTO `gl_userprefs` VALUES (1,0,0,0,'',0,1,1,1);
INSERT INTO `gl_userprefs` VALUES (2,0,1,0,'edt',1,1,1,1);
INSERT INTO `gl_userprefs` VALUES (3,0,1,0,'edt',1,1,1,1);
INSERT INTO `gl_userprefs` VALUES (5,0,1,0,'edt',1,1,1,1);

--
-- Table structure for table `gl_users`
--

CREATE TABLE `gl_users` (
  `uid` mediumint(8) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL default '',
  `fullname` varchar(80) default NULL,
  `passwd` varchar(32) NOT NULL default '',
  `email` varchar(96) default NULL,
  `homepage` varchar(96) default NULL,
  `sig` varchar(160) NOT NULL default '',
  `regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `photo` varchar(128) default NULL,
  `cookietimeout` int(8) unsigned default '28800',
  `theme` varchar(64) default NULL,
  `language` varchar(64) default NULL,
  `pwrequestid` varchar(16) default NULL,
  PRIMARY KEY  (`uid`),
  KEY `LOGIN` (`uid`,`passwd`,`username`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_users`
--

INSERT INTO `gl_users` VALUES (1,'Anonymous','Anonymous','',NULL,NULL,'','2004-01-01 00:00:01',NULL,0,NULL,NULL,NULL);
INSERT INTO `gl_users` VALUES (2,'Admin','Geeklog SuperUser','xxxx','root@localhost','http://www.geeklog.net','','2004-01-01 00:00:02',NULL,28800,NULL,NULL,'NULL');
INSERT INTO `gl_users` VALUES (3,'Moderator','Moderator','xxxx','moderator','http://www.geeklog.net','','2004-01-01 00:00:03',NULL,28800,NULL,NULL,'xxxxx');
INSERT INTO `gl_users` VALUES (5,'xxx','xxxk','34a83a90304cf74975873c86dd047294','xxx','','','2005-12-05 15:29:12','',28800,NULL,NULL,'xxxx3');

--
-- Table structure for table `gl_vars`
--

CREATE TABLE `gl_vars` (
  `name` varchar(20) NOT NULL default '',
  `value` varchar(128) default NULL,
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `gl_vars`
--

INSERT INTO `gl_vars` VALUES ('totalhits','249');
INSERT INTO `gl_vars` VALUES ('lastemailedstories','');

--
-- Table structure for table `phpbb_auth_access`
--

CREATE TABLE `phpbb_auth_access` (
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_auth_access`
--


--
-- Table structure for table `phpbb_banlist`
--

CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_banlist`
--


--
-- Table structure for table `phpbb_categories`
--

CREATE TABLE `phpbb_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_categories`
--

INSERT INTO `phpbb_categories` VALUES (1,'Test category 1',10);

--
-- Table structure for table `phpbb_config`
--

CREATE TABLE `phpbb_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_config`
--

INSERT INTO `phpbb_config` VALUES ('config_id','1');
INSERT INTO `phpbb_config` VALUES ('board_disable','0');
INSERT INTO `phpbb_config` VALUES ('sitename','yourdomain.com');
INSERT INTO `phpbb_config` VALUES ('site_desc','A _little_ text to describe your forum');
INSERT INTO `phpbb_config` VALUES ('cookie_name','phpbb2mysql');
INSERT INTO `phpbb_config` VALUES ('cookie_path','/');
INSERT INTO `phpbb_config` VALUES ('cookie_domain','');
INSERT INTO `phpbb_config` VALUES ('cookie_secure','0');
INSERT INTO `phpbb_config` VALUES ('session_length','3600');
INSERT INTO `phpbb_config` VALUES ('allow_html','0');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags','b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode','1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies','1');
INSERT INTO `phpbb_config` VALUES ('allow_sig','1');
INSERT INTO `phpbb_config` VALUES ('allow_namechange','0');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create','0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local','0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote','0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload','0');
INSERT INTO `phpbb_config` VALUES ('enable_confirm','0');
INSERT INTO `phpbb_config` VALUES ('allow_autologin','1');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time','0');
INSERT INTO `phpbb_config` VALUES ('override_user_style','0');
INSERT INTO `phpbb_config` VALUES ('posts_per_page','15');
INSERT INTO `phpbb_config` VALUES ('topics_per_page','50');
INSERT INTO `phpbb_config` VALUES ('hot_threshold','25');
INSERT INTO `phpbb_config` VALUES ('max_poll_options','10');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars','255');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs','50');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs','25');
INSERT INTO `phpbb_config` VALUES ('max_savebox_privmsgs','50');
INSERT INTO `phpbb_config` VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO `phpbb_config` VALUES ('board_email','webmaster@omegateencamp.org');
INSERT INTO `phpbb_config` VALUES ('smtp_delivery','0');
INSERT INTO `phpbb_config` VALUES ('smtp_host','');
INSERT INTO `phpbb_config` VALUES ('smtp_username','');
INSERT INTO `phpbb_config` VALUES ('smtp_password','');
INSERT INTO `phpbb_config` VALUES ('sendmail_fix','0');
INSERT INTO `phpbb_config` VALUES ('require_activation','0');
INSERT INTO `phpbb_config` VALUES ('flood_interval','15');
INSERT INTO `phpbb_config` VALUES ('board_email_form','0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize','6144');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width','80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height','80');
INSERT INTO `phpbb_config` VALUES ('avatar_path','images/avatars');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('smilies_path','images/smiles');
INSERT INTO `phpbb_config` VALUES ('default_style','1');
INSERT INTO `phpbb_config` VALUES ('default_dateformat','D M d, Y g:i a');
INSERT INTO `phpbb_config` VALUES ('board_timezone','0');
INSERT INTO `phpbb_config` VALUES ('prune_enable','1');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable','0');
INSERT INTO `phpbb_config` VALUES ('gzip_compress','0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax','');
INSERT INTO `phpbb_config` VALUES ('coppa_mail','');
INSERT INTO `phpbb_config` VALUES ('record_online_users','1');
INSERT INTO `phpbb_config` VALUES ('record_online_date','1133791815');
INSERT INTO `phpbb_config` VALUES ('server_name','omegateencamp.org');
INSERT INTO `phpbb_config` VALUES ('server_port','80');
INSERT INTO `phpbb_config` VALUES ('script_path','/phpBB2/');
INSERT INTO `phpbb_config` VALUES ('version','.0.18');
INSERT INTO `phpbb_config` VALUES ('board_startdate','1133791349');
INSERT INTO `phpbb_config` VALUES ('default_lang','english');
INSERT INTO `phpbb_config` VALUES ('allow_login_for_profile','1');

--
-- Table structure for table `phpbb_confirm`
--

CREATE TABLE `phpbb_confirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_confirm`
--


--
-- Table structure for table `phpbb_disallow`
--

CREATE TABLE `phpbb_disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`disallow_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_disallow`
--


--
-- Table structure for table `phpbb_forum_prune`
--

CREATE TABLE `phpbb_forum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `prune_days` smallint(5) unsigned NOT NULL default '0',
  `prune_freq` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_forum_prune`
--


--
-- Table structure for table `phpbb_forums`
--

CREATE TABLE `phpbb_forums` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_forums`
--

INSERT INTO `phpbb_forums` VALUES (1,1,'Test Forum 1','This is just a test forum.',0,10,1,1,1,NULL,0,0,0,0,0,1,1,3,3,1,1,3);

--
-- Table structure for table `phpbb_groups`
--

CREATE TABLE `phpbb_groups` (
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL default '',
  `group_description` varchar(255) NOT NULL default '',
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_groups`
--

INSERT INTO `phpbb_groups` VALUES (1,1,'Anonymous','Personal User',0,1);
INSERT INTO `phpbb_groups` VALUES (2,1,'Admin','Personal User',0,1);
INSERT INTO `phpbb_groups` VALUES (3,1,'','Personal User',0,1);
INSERT INTO `phpbb_groups` VALUES (5,1,'','Personal User',0,1);

--
-- Table structure for table `phpbb_posts`
--

CREATE TABLE `phpbb_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_posts`
--

INSERT INTO `phpbb_posts` VALUES (1,1,1,2,972086460,'7F000001',NULL,1,0,1,1,NULL,0);

--
-- Table structure for table `phpbb_posts_text`
--

CREATE TABLE `phpbb_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_posts_text`
--

INSERT INTO `phpbb_posts_text` VALUES (1,'',NULL,'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');

--
-- Table structure for table `phpbb_privmsgs`
--

CREATE TABLE `phpbb_privmsgs` (
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` varchar(8) NOT NULL default '',
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_privmsgs`
--


--
-- Table structure for table `phpbb_privmsgs_text`
--

CREATE TABLE `phpbb_privmsgs_text` (
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_privmsgs_text`
--


--
-- Table structure for table `phpbb_ranks`
--

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_ranks`
--

INSERT INTO `phpbb_ranks` VALUES (1,'Site Admin',-1,1,NULL);

--
-- Table structure for table `phpbb_search_results`
--

CREATE TABLE `phpbb_search_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_search_results`
--

INSERT INTO `phpbb_search_results` VALUES (1526261669,'328769abf50e0011e5bd7b254f92dcee','a:7:{s:14:\"search_results\";s:1:\"1\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:5:\"posts\";s:12:\"return_chars\";i:200;}');

--
-- Table structure for table `phpbb_search_wordlist`
--

CREATE TABLE `phpbb_search_wordlist` (
  `word_text` varchar(50) binary NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_search_wordlist`
--

INSERT INTO `phpbb_search_wordlist` VALUES ('example',1,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('post',2,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('phpbb',3,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('installation',4,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('delete',5,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('topic',6,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('forum',7,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('since',8,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('everything',9,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('seems',10,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('working',11,0);
INSERT INTO `phpbb_search_wordlist` VALUES ('welcome',12,0);

--
-- Table structure for table `phpbb_search_wordmatch`
--

CREATE TABLE `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_search_wordmatch`
--

INSERT INTO `phpbb_search_wordmatch` VALUES (1,1,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,2,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,3,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,4,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,5,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,6,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,7,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,8,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,9,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,10,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,11,0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,12,1);
INSERT INTO `phpbb_search_wordmatch` VALUES (1,3,1);

--
-- Table structure for table `phpbb_sessions`
--

CREATE TABLE `phpbb_sessions` (
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  `session_admin` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_sessions`
--

INSERT INTO `phpbb_sessions` VALUES ('fe5e98e6e77622839cadcca85f0cfbb4',2,1134853725,1134853725,'4556fd14',0,1,0);

--
-- Table structure for table `phpbb_sessions_keys`
--

CREATE TABLE `phpbb_sessions_keys` (
  `key_id` varchar(32) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `last_ip` varchar(8) NOT NULL default '0',
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`),
  KEY `last_login` (`last_login`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_sessions_keys`
--


--
-- Table structure for table `phpbb_smilies`
--

CREATE TABLE `phpbb_smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_smilies`
--

INSERT INTO `phpbb_smilies` VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (7,':(','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (8,':-(','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (9,':sad:','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (10,':o','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (11,':-o','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (12,':eek:','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (13,':shock:','icon_eek.gif','Shocked');
INSERT INTO `phpbb_smilies` VALUES (14,':?','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (15,':-?','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (16,':???:','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (17,'8)','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (18,'8-)','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (19,':cool:','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (20,':lol:','icon_lol.gif','Laughing');
INSERT INTO `phpbb_smilies` VALUES (21,':x','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (22,':-x','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (23,':mad:','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (24,':P','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (25,':-P','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (26,':razz:','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (27,':oops:','icon_redface.gif','Embarassed');
INSERT INTO `phpbb_smilies` VALUES (28,':cry:','icon_cry.gif','Crying or Very sad');
INSERT INTO `phpbb_smilies` VALUES (29,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO `phpbb_smilies` VALUES (30,':twisted:','icon_twisted.gif','Twisted Evil');
INSERT INTO `phpbb_smilies` VALUES (31,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO `phpbb_smilies` VALUES (32,':wink:','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (33,';)','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (34,';-)','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (35,':!:','icon_exclaim.gif','Exclamation');
INSERT INTO `phpbb_smilies` VALUES (36,':?:','icon_question.gif','Question');
INSERT INTO `phpbb_smilies` VALUES (37,':idea:','icon_idea.gif','Idea');
INSERT INTO `phpbb_smilies` VALUES (38,':arrow:','icon_arrow.gif','Arrow');
INSERT INTO `phpbb_smilies` VALUES (39,':|','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (40,':-|','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (41,':neutral:','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (42,':mrgreen:','icon_mrgreen.gif','Mr. Green');

--
-- Table structure for table `phpbb_themes`
--

CREATE TABLE `phpbb_themes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_themes`
--

INSERT INTO `phpbb_themes` VALUES (1,'subSilver','subSilver','subSilver.css','','E5E5E5','000000','0000FF','800080','FF0000','008000','EFEFEF','DEE3E7','D1D7DC','','','','98AAB1','002277','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',11,12,12,'444444','006600','FFA34F','','','',NULL,NULL);

--
-- Table structure for table `phpbb_themes_name`
--

CREATE TABLE `phpbb_themes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_themes_name`
--

INSERT INTO `phpbb_themes_name` VALUES (1,'The lightest row colour','The medium row color','The darkest row colour','','','','Border round the whole page','Outer table border','Inner table border','Silver gradient picture','Blue gradient picture','Fade-out gradient on index','Background for quote boxes','All white areas','','Background for topic posts','2nd background for topic posts','','Main fonts','Additional topic title font','Form fonts','Smallest font size','Medium font size','Normal font size (post body etc)','Quote & copyright text','Code text colour','Main table header text colour','','','');

--
-- Table structure for table `phpbb_topics`
--

CREATE TABLE `phpbb_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_topics`
--

INSERT INTO `phpbb_topics` VALUES (1,1,'Welcome to phpBB 2',2,972086460,13,0,0,0,0,1,1,0);

--
-- Table structure for table `phpbb_topics_watch`
--

CREATE TABLE `phpbb_topics_watch` (
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_topics_watch`
--


--
-- Table structure for table `phpbb_user_group`
--

CREATE TABLE `phpbb_user_group` (
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_user_group`
--

INSERT INTO `phpbb_user_group` VALUES (1,-1,0);
INSERT INTO `phpbb_user_group` VALUES (2,2,0);
INSERT INTO `phpbb_user_group` VALUES (3,3,0);
INSERT INTO `phpbb_user_group` VALUES (5,5,0);

--
-- Table structure for table `phpbb_users`
--

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_users`
--

INSERT INTO `phpbb_users` VALUES (-1,0,'Anonymous','',0,0,0,1133791349,0,0,'0.00',NULL,'','',0,0,0,NULL,0,0,1,1,1,1,0,1,0,1,0,NULL,'',0,'','','','','',NULL,'','','','','','','');
INSERT INTO `phpbb_users` VALUES (2,1,'Admin','ec130918e28b783c8689fd1ec51f73a9',1134853725,0,1134768991,1072936802,1,1,'0.00',1,'english','d M Y h:i a',0,0,0,NULL,0,0,0,1,1,1,1,1,0,1,1,1,'',0,'root@localhost','','http://www.geeklog.net','','',NULL,'','','','','','','');
INSERT INTO `phpbb_users` VALUES (3,1,'Moderator','ec130918e28b783c8689fd1ec51f73a9',0,0,0,1072936803,0,0,'0.00',1,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,0,1,0,'',0,'moderator','','http://www.geeklog.net','','','','','','','','','',NULL);
INSERT INTO `phpbb_users` VALUES (5,1,'jordydme','34a83a90304cf74975873c86dd047294',1133821203,0,1133818193,1133818152,0,0,'0.00',1,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,0,1,0,'',0,'jordandick@earthlink.net','','','','','','','','','','','',NULL);

--
-- Table structure for table `phpbb_vote_desc`
--

CREATE TABLE `phpbb_vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_vote_desc`
--


--
-- Table structure for table `phpbb_vote_results`
--

CREATE TABLE `phpbb_vote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_vote_results`
--


--
-- Table structure for table `phpbb_vote_voters`
--

CREATE TABLE `phpbb_vote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_vote_voters`
--


--
-- Table structure for table `phpbb_words`
--

CREATE TABLE `phpbb_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_words`
--


 

  <tr valign="top">
    <td align="right"><b>{lang_fullname}</b><br>
      <small>{lang_fullname_text}</small></td>
    <td><input type="text" name="fullname" size="60" maxlength="80"
      value="{fullname_value}"></td>
  </tr>
{customfields}
 

function custom_usercreate($uid) {
    global $_TABLES;

    $grad_year = addslashes(COM_applyFilter($_POST['cust_gradyear'],true));
    $fullname  = addslashes(COM_applyFilter($_POST['cust_fullname']));

 

Parse error: syntax error, unexpected ';' in /home/jordydme/geeklog_data/system/lib-custom.php on line 148
 

<?php

/* Reminder: always indent with 4 spaces (no tabs). */
// +---------------------------------------------------------------------------+
// | Geeklog 1.3                                                               |
// +---------------------------------------------------------------------------+
// | lib-custom.php                                                            |
// | Your very own custom Geeklog library.                                     |
// |                                                                           |
// | This is the file where you should put all of your custom code.  When      |
// | possible you should not alter lib-common.php but, instead, put code here. |
// | This will make upgrading to future versions of Geeklog easier for you     |
// | because you will always be gauranteed that the Geeklog developers will    |
// | NOT add code to this file. NOTE: we have already gone through the trouble |
// | of making sure that we always include this file when lib-common.php is    |
// | included some place so you will have access to lib-common.php.  It        |
// | follows then that you should not include lib-common.php in this file      |
// |                                                                           |
// +---------------------------------------------------------------------------+
// | Copyright (C) 2000-2005 by the following authors:                         |
// |                                                                           |
// | Authors: Tony Bibbs       - tony AT tonybibbs DOT com                     |
// |          Blaine Lang      - blaine AT portalparts DOT com                 |
// |          Dirk Haun        - dirk AT haun-online DOT de                    |
// +---------------------------------------------------------------------------+
// |                                                                           |
// | This program is free software; you can redistribute it and/or             |
// | modify it under the terms of the GNU General Public License               |
// | as published by the Free Software Foundation; either version 2            |
// | of the License, or (at your option) any later version.                    |
// |                                                                           |
// | This program is distributed in the hope that it will be useful,           |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the             |
// | GNU General Public License for more details.                              |
// |                                                                           |
// | You should have received a copy of the GNU General Public License         |
// | along with this program; if not, write to the Free Software Foundation,   |
// | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
// |                                                                           |
// +---------------------------------------------------------------------------+
//
// $Id: lib-custom.php,v 1.11.2.1 2005/10/03 09:24:36 dhaun Exp $

// You can use this global variable to print useful messages to the errorlog
// using COM_errorLog().  To see an example of how to do this, look in
// lib-common.php and see how $_COM_VERBOSE was used throughout the code
$_CST_VERBOSE = false;

/**
* Sample PHP Block function
*
* this is a sample function used by a PHP block.  This will show the rights that
* a user has in the "What you have access to" block.
*
*/
function phpblock_showrights()
{
    global $_RIGHTS, $_CST_VERBOSE;

    if ($_CST_VERBOSE) {
        COM_errorLog('**** Inside phpblock_showrights in lib-custom.php ****', 1);
    }

    $retval .= ' ';

    for ($i = 0; $i < count($_RIGHTS); $i++) {
        $retval .=  '<li>' . $_RIGHTS[$i] . '</li>' . LB;
    }

    if ($_CST_VERBOSE) {
        COM_errorLog('**** Leaving phpblock_showrights in lib-custom.php ****', 1);
    }

    return $retval;
}


/***
*
* Get Bent()
*
* Php function to tell you how if your site is grossly insecure
*
**/
function phpblock_getBent()
{
    global $_CONF, $_TABLES;

    $secure = true;

    $retval = '';

    $secure_msg = 'Could not find any gross insecurities in your site.  Do not take this ';
    $secure_msg .= 'as meaning your site is 100% secure, as no site ever is.  I can only ';
    $secure_msg .= 'check things that should be blatantly obvious.';

    $insecure_msg = '';

    // we don't have the path to the admin directory, so try to figure it out
    // from $_CONF['site_admin_url']
    $adminurl = $_CONF['site_admin_url'];
    if (strrpos ($adminurl, '/') == strlen ($adminurl)) {
        $adminurl = substr ($adminurl, 0, -1);
    }
    $pos = strrpos ($adminurl, '/');
    if ($pos === false) {
        // only guessing ...
        $installdir = $_CONF['path_html'] . 'admin/install';
    } else {
        $installdir = $_CONF['path_html'] . substr ($adminurl, $pos + 1)
                    . '/install';
    }

    if (is_dir ($installdir)) {
        $insecure_msg .= '<p>You should really remove the install directory <b>' . $installdir .'</b> once you have your site up and running without any errors.';
        $insecure_msg .= ' Keeping it around would allow malicious users the ability to destroy your current install, take over your site, or retrieve sensitive information.';

        $secure = false;
    }

    // check to see if any account still has 'password' as its password.
    $count = DB_query("select count(*) as count from {$_TABLES['users']} where passwd='" . md5('password') . "'");
    $A = DB_fetchArray($count);
    if ( $A['count'] > 0 ) {
        $secure = false;
        $insecure_msg .= '<p>You still have not changed the default password from "password" on ' . $A['count'] . ' account(s). ';
        $insecure_msg .= 'This will allow people to do serious harm to your site!';
    }

    if ($secure) {
        $retval = $secure_msg;
    } else {
        $retval = $insecure_msg;
    }
    $retval = wordwrap($retval,20,' ',1);

    return $retval;
}


/* Create any new records in additional tables you may have added  */
/* Update any fields in the core GL tables for this user as needed */
/* Called when user is first created */
function custom_usercreate($uid) {
    global $_TABLES;

    $grad_year = addslashes(COM_applyFilter($_POST['cust_gradyear'],true));
    $fullname  = addslashes(COM_applyFilter($_POST['cust_fullname']));


    // Ensure all data is prepared correctly before inserts, quotes may need to be escaped with addslashes()
    DB_query("INSERT INTO {$_TABLES['localuserinfo']} (uid,grad_year) VALUES ('$uid', '$grad_year')");
    DB_query("UPDATE {$_TABLES['users']} SET fullname = '$fullname' WHERE uid='$uid'");
    return true;

}

// Delete user record from custom user info table
function custom_userdelete($uid) {
    global $_TABLES;

    DB_query("DELETE FROM {$_TABLES['localuserinfo']} WHERE uid='$uid'");
    return true;

}
/* Called from users.php - when user is displaying a member profile  */
/* This function will return any extra fields that need to be shown */
/* Output is then replaced in {customfields) -- This variable needs to be added to your templates */
/* Template: path_layout/users/profile/profile.thtml */

function custom_userdisplay($uid) {
    global $_CONF,$_TABLES;
    $grad_year = DB_getItem($_TABLES['localuserinfo'], "grad_year", "uid='$uid'");
    $fullname = DB_getItem($_TABLES['users'], "fullname", "uid='$uid'");
    $retval .= '<tr>
                    <td align="right"><b>Full Name:</b></td>
                    <td>' . $fullname .'</td>
                 </tr>';
    $retval .= '<tr>
                    <td align="right"><b>Graduation Year:</b></td>
                    <td>' . $grad_year .'</td>
                 </tr>';
    return $retval;

}


/* Function called when editing user profile. */
/* Called from usersettings.php - when user is eding their own profile  */
/* and from admin/user.php when admin is editing a member profile  */
/* This function will return any extra fields that need to be shown for editing */
/* Output is then replaced in {customfields} -- This variable needs to be added to your templates */
/* User: path_layout/preferences/profile.thtml and Admin: path_layout/admin/user/edituser.thtml */

function custom_useredit($uid) {
    global $_TABLES,$_CONF;

    $grad_year = DB_getItem($_TABLES['localuserinfo'], "grad_year", "uid='$uid'");
    $fullname = DB_getItem($_TABLES['users'], "fullname", "uid='$uid'");

    $retval .= '<tr>
        <td align="right"><b>Full Name:</b></td>
        <td><input type="text" name="cust_fullname" size="50" value="' . $fullname .'"></td>
     </tr>';
    $retval .= '<tr>
        <td align="right"><b>Graduation Year:</b></td>
        <td><input type="text" name="cust_gradyear" size="5" maxlength="4" value="' . $grad_year .'"></td>
     </tr>';
    $retval .= '<tr><td colspan="2"><hr></td></tr>';
   return $retval;
}

/* Function called when saving the user profile. */
function custom_usersave($uid) {
    global $_TABLES;

    $grad_year = COM_applyFilter($_POST['cust_gradyear'],true);
    $fullname  = COM_applyFilter($_POST['fullname']);

    DB_query("UPDATE {$_TABLES['users']} SET fullname='$fullname' WHERE uid='$uid'");
    if ($grad_year > 0) {
        DB_query("UPDATE {$_TABLES['localuserinfo']} SET grad_year='$grad_year' WHERE uid='$uid'");
    }

}


/* Main Form used for Custom membership when member is registering */
function custom_userform($uid="",$msg="") {
    global $_CONF,$_TABLES, $LANG04;

    if (!empty($msg)) {
        $retval .= COM_startBlock($LANG04[21]) . $msg . COM_endBlock();
    }

    $post_url = $_CONF['site_url']."/users.php";
    $postmode = "create";
    $submitbutton = '<input type="submit" value="Register Now!">';
    $passwd_input = "";
    $message = "<br><font color=black><b>Please complete the application below. Once you have completed the application, click the Submit button and the application will be processed immediately.</b></font>";
    $A=array();

    $user_templates = new Template ($_CONF['path_layout'] . 'custom');
    $user_templates->set_file('memberdetail', 'memberdetail.thtml');
    $user_templates->set_var('layout_url', $_CONF['layout_url']);
    $user_templates->set_var('post_url', $post_url);
    $user_templates->set_var('startblock', COM_startBlock("Custom Registration Example"));
    $user_templates->set_var('message', $message);    
    $user_templates->set_var('USERNAME', "Username");
    $user_templates->set_var('USERNAME_HELP', "Name to be used when accessing this site");
    $user_templates->set_var('username', $A['username']);
    $user_templates->set_var('passwd_input', $passwd_input);
    $user_templates->set_var('EMAIL', "Email Address");
    $user_templates->set_var('EMAIL_HELP', "Valid email address");
    $user_templates->set_var('email', $A['email']);
    $user_templates->set_var('FULLNAME', "Full Name");
    $user_templates->set_var('FULLNAME_HELP', "First and Last Name");
    $user_templates->set_var('fullname', $A['fullname']);
    $user_templates->set_var('GRADYEAR', "Graduation Year");
    $user_templates->set_var('GRADYEAR_HELP', "That big year!");
    $user_templates->set_var('grad_year', "");
    $user_templates->set_var('user_id', $user);
    $user_templates->set_var('postmode', $postmode);
    $user_templates->set_var('submitbutton', $submitbutton);
    $user_templates->set_var('endblock', COM_endBlock());
    $user_templates->parse('output', 'memberdetail');
    $retval .= $user_templates->finish($user_templates->get_var('output'));

    return $retval;
}

/**
* Check if it's okay to create a new user.
*
* Geeklog is about to create a new user with the given username and email
* address. This is the custom code's last chance to prevent that,
* e.g. to check if all required data has been entered.
*
* @param    string  $username   username that Geeklog would use for the new user* @param    string  $email      email address of that user
* @return   string              an error message or an empty string for "OK"
*
*/
function custom_usercheck ($username, $email)
{
    $msg = '';

    // Example, check that the full name has been entered
    // and complain if it's missing
    if (empty ($_POST['fullname'])) {
        $msg = 'Please enter your full name!';
    }

    return $msg;
}


/**
* Custom function to retrieve and return a formatted list of blocks
* Can be used when calling COM_siteHeader or COM_SiteFooter

* Example:
* 1: Setup an array of blocks to display
* 2: Call COM_siteHeader or COM_siteFooter
*
*  $myblocks = array ('site_menu','site_news','poll_block');

* COM_siteHeader( array('COM_showCustomBlocks',$myblocks) ) ;
* COM_siteFooter( true, array('COM_showCustomBlocks',$myblocks));

* @param   array   $showblocks    An array of block names to retrieve and format
* @return  string                 Formated HTML containing site footer and optionally right blocks
*/
function custom_showBlocks($showblocks)
{
    global $_CONF, $_TABLES;

    $retval = '';
    foreach($showblocks as $block) {
        $sql = "SELECT bid, name,type,title,content,rdfurl,phpblockfn,help FROM {$_TABLES['blocks']} WHERE name='$block'";
        $result = DB_query($sql);
        if (DB_numRows($result) == 1) {
            $A = DB_fetchArray($result);
            $retval .= COM_formatBlock($A);
        }
    }

    return $retval;
}


/**
* This is an example of a custom email function. When this function is NOT
* commented out, Geeklog would send all emails through this function
* instead of sending them through COM_mail in lib-common.php.
*
* This is basically a re-implementation of the way emails were sent
* prior to Geeklog 1.3.9 (Geeklog uses PEAR::Mail as of version 1.3.9).
*
*/
/*
function CUSTOM_mail($to, $subject, $message, $from = '', $html = false, $priority = 0)
{
    global $_CONF, $LANG_CHARSET;

    if (empty ($LANG_CHARSET)) {
        $charset = $_CONF['default_charset'];
        if (empty ($charset)) {
            $charset = 'iso-8859-1';
        }
    } else {
        $charset = $LANG_CHARSET;
    }

    if (empty ($from)) {
        $from = $_CONF['site_name'] . ' <' . $_CONF['site_mail'] . '>';
    }

    $headers  = 'From: ' . $from . "\r\n"
              . 'X-Mailer: Geeklog ' . VERSION . "\r\n";

    if ($priority > 0) {
        $headers .= 'X-Priority: ' . $priority . "\r\n";
    }

    if ($html) {
        $headers .= "Content-Type: text/html; charset={$charset}\r\n"
                 .  'Content-Transfer-Encoding: 8bit';
    } else {
        $headers .= "Content-Type: text/plain; charset={$charset}";
    }

    return mail ($to, $subject, $message, $headers);
}
*/

/**
* This is an example of a function that returns menu entries to be used for
* the 'custom' entry in $_CONF['menu_elements'] (see config.php).
*
*/
/*
function CUSTOM_menuEntries ()
{
    global $_CONF, $_USER;

    $myentries = array ();

    // Sample link #1: Link to Gallery
    $myentries[] = array ('url'   => $_CONF['site_url'] . '/gallery/',
                          'label' => 'Gallery');

    // Sample link #2: Link to the Personal Calendar - only visible for
    // logged-in users
    if (!empty ($_USER['uid']) && ($_USER['uid'] > 1)) {
        $myentries[] = array ('url'   => $_CONF['site_url']
                                         . '/calendar.php?mode=personal',
                              'label' => 'My Calendar');
    }

    return $myentries;
}
*/

?>

 

{start_block_profile}
<form action="{site_url}/usersettings.php" method="POST" {enctype}>
<table border="0" cellspacing="0" cellpadding="3">
  {username_option}
  <tr valign="top">
    <td align="right"><b>{lang_fullname}</b><br>
      <small>{lang_fullname_text}</small></td>
    <td><input type="text" name="fullname" size="60" maxlength="80"
      value="{fullname_value}"></td>
  </tr>
  {customfields}
  <tr valign="top">
    <td align="right"><b>{lang_password}</b><br>
      <small>{lang_password_text}</small></td>
    <td><input type="password" name="passwd" size="32" maxlength="32"
      value="{password_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_cooktime}</b><br>
      <small>{lang_cooktime_text}</small></td>
    <td>{cooktime_selector}</td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_email}</b><br>
      <small>{lang_email_text}</small></td>
    <td><input type="text" name="email" size="60" maxlength="96"
      value="{email_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_homepage}</b><br>
      <small>{lang_homepage_text}</small></td>
    <td><input type="text" name="homepage" size="60" maxlength="96"
      value="{homepage_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_location}</b><br>
      <small>{lang_location_text}</small></td>
    <td><input type="text" name="location" size="60" maxlength="96"
      value="{location_value}"></td>
  </tr>
  <tr valign="top">
    <td align="right"><b>{lang_signature}</b><br>
      <small>{lang_signature_text}</small></td>
    <td><textarea name="sig" cols="60" rows="4">{signature_value}</textarea></td>
  </tr>
  {userphoto_option}
  <tr valign="top">
    <td align="right"><b>{lang_about}</b><br>
      <small>{lang_about_text}</small></td>
    <td><textarea name="about" cols="60" rows="6">{about_value}</textarea></td>
  </tr>
  {customfields}
  <tr valign="top">
    <td align="center" colspan="2">
      <input type="hidden" name="uid" value="{uid_value}">
      <input type="hidden" name="mode" value="saveuser">
      <input type="hidden" name="username" value="{username_value}">
      <input type="submit" value="{lang_submit}">
    </td>
  </tr>
</table>
</form>
{end_block}
{delete_account_option}

 

$grad_year = COM_applyFilter($_POST['cust_gradyear'],true);
    $fullname  = addslashes(COM_applyFilter($_POST['fullname']));