[Sommaire] [Imprimer]

   1  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   2      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   3  
   4  <html xmlns="http://www.w3.org/1999/xhtml">
   5  <head>
   6    <title>PunBB Docs - fr : Infos développeurs</title>
   7    <meta http-equiv="Content-Type" content=
   8    "text/html; charset=iso-8859-1" />
   9    <link rel="stylesheet" type="text/css" href="style/docs.css" />
  10  </head>
  11  
  12  <body>
  13    <ul id="navigation">
  14      <li><a href="index.html">Index</a></li>
  15  
  16      <li><a href="about.html">A propos</a></li>
  17  
  18      <li><a href="install.html">Installation</a></li>
  19  
  20      <li><a href="faq.html">FAQ</a></li>
  21  
  22      <li><a href="dev.html">Infos développeurs</a></li>
  23    </ul>
  24  
  25    <h1>Infos développeurs</h1>
  26  
  27    <p>Informations pour les développeurs pour profiter de votre installation existante de PunBB.</p>
  28    <hr />
  29  
  30    <h2>Table des matières</h2>
  31  
  32    <ul>
  33      <li><a href="#syndication">Syndication</a></li>
  34  
  35      <li><a href="#integration">Intégration dans un site web</a></li>
  36  
  37      <li><a href="#plugins">Plugins</a></li>
  38  
  39      <li><a href="#dbtables">Références tables de la base de données</a></li>
  40    </ul>
  41    <hr />
  42  
  43    <h2>Syndication<a name="syndication" id="syndication"></a></h2>
  44  
  45    <p>Le script extern.php est utiliser pour inclure des informations à propos
  46        de vos forums sur des pages externes aux forums et pour syndiquer les discussions
  47        récentes via RSS. Le script peut afficher une liste de discussions récentes
  48        (triée par messages, dates ou derniers messages), une liste d’utilisateurs
  49        actifs ou une collection de statistiques générales. Le script peut être
  50        appeler directement par l’intermédiaire d’une URL (pour RSS), de la commande
  51        inclue de PHP ou par l’utilisation du Server Side Includes (SSI).</p>
  52  
  53    <p>Le comportement du script est commandé par l’intermédiaire de variables
  54        fournies au script dans l’URL. Les différentes variables sont : action
  55        (que faut-il afficher), show (combien de discussions afficher), forum (l’ID
  56        du forum à sonder pour récupèrer les discussions) et type (sortie comme
  57        HTML ou RSS). La seule variable obligatoire est action.</p>
  58  
  59    <p>Les valeurs de possibles (par defaut) sont :</p>
  60  
  61    <ul>
  62      <li><strong>action :</strong> active (affiche les discussions le plus récemment
  63        actives) (HTML ou RSS)<br />
  64        new (afficher les plus récentes discussions) (HTML ou RSS)<br />
  65        online (afficher les utilisateurs en ligne) (HTML)<br />
  66        online_full (comme ci-dessus, mais inclut une liste complète) (HTML)<br />
  67        stats (afficher les statistiques des forums) (HTML)</li>
  68      <li><strong>show :</strong> N’importe qu’elle valeur, nombre entier entre
  69          1 et 50. Cette variable est ignorées pour la sortie RSS. 15 par défaut.</li>
  70  
  71      <li><strong>fid :</strong> Un ou plusieurs ID de forum (séparés par des virgules).
  72          Si ignorée, des discussions de tous les forums lisibles par les invités
  73          seront récupérées.</li>
  74  
  75      <li><strong>type :</strong> RSS. Toute autre chose signifie une sortie en
  76          HTML.</li>
  77    </ul>
  78  
  79    <p>Voici quelques exemples en utilisant la fonction include() de PHP.</p>
  80  
  81    <ul>
  82      <li>Afficher les 15 discussions les plus récemment actives depuis tous les forums :<br />
  83      include('http://host.com/forums/extern.php?action=active');</li>
  84  
  85      <li>Afficher les 10 discussions les plus récentes depuis les forums d’ID 5, 6 et 7 :<br />
  86      include('http://host.com/forums/extern.php?action=new&amp;show=10&amp;fid=5,6,7');</li>
  87  
  88      <li>Afficher les utilisateurs en ligne :<br />
  89      include('http://host.com/forums/extern.php?action=online');</li>
  90  
  91      <li>Afficher les utilisateurs en ligne avec une liste complète :<br />
  92      include('http://host.com/forums/extern.php?action=online_full');</li>
  93  
  94      <li>Afficher les statistiques des forums :<br />
  95      include('http://host.com/forums/extern.php?action=stats');</li>
  96    </ul>
  97  
  98    <p>Voici quelques exemples en utilisant SSI.</p>
  99  
 100    <ul>
 101      <li>Afficher les 5 discussions les plus récentes depuis les forums d’ID 11 et 22 :<br />
 102      &lt;!--#include
 103      virtual="forums/extern.php?action=new&amp;show=5&amp;fid=11,22"
 104      --&gt;</li>
 105  
 106      <li>Afficher les statistiques des forums :<br />
 107      &lt;!--#include virtual="forums/extern.php?action=stats"
 108      --&gt;</li>
 109    </ul>
 110  
 111    <p>Et enfin quelques exemples en utilisant extern.php pour produire un fil RSS 0.91</p>
 112  
 113    <ul>
 114      <li>Afficher les 15 discussions les plus récemment actives :<br />
 115      http://host.com/extern.php?action=active&amp;type=RSS</li>
 116  
 117      <li>Afficher les 15 discussions les plus récemment actives depuis le forum d’ID 2 :<br />
 118      http://host.com/extern.php?action=active&amp;type=RSS&amp;fid=2</li>
 119    </ul>
 120    <hr />
 121  
 122    <h2>Intégration dans un site web<a name="integration"
 123    id="integration"></a></h2>
 124  
 125    <p>Intégrer PunBB dans le code de votre site web est facile si vous connaissez
 126        un petit peu PHP. En incluant le script common.php de PunBB, vous accédez à toutes
 127        les variables globales de PunBB comme $db et $pun_user. Cependant, afin
 128        d’inclure ce fichier, vous devez définir une constante appelée PUN_ROOT.
 129        Cette constante devra fixer le chemin relatif vers votre répertoire de
 130        forums PunBB. Par exemple, si votre page d’accueil de votre site est localisé dans
 131        /home/user/public_html/ et vos forum sont dans /home/user/public_html/forums/,
 132        votre PUN_ROOT devrait alrs être ./forums/<br />
 133    Le code PHP pour accomplir ceci pourrait ressembler à quelque chose comme ça :</p>
 134  
 135    <pre>define('PUN_ROOT', './forums/');
 136  require  PUN_ROOT.'include/common.php';</pre>
 137  
 138    <p>Une fois que vous avez inclus common.php, vous pouvez accéder et utiliser
 139        toutes les variables globales et fonctions de PunBB. Typiquement, vous
 140        serez le plus intéressé par le tableau $pun_user. Ce tableau contient des
 141        informations sur l’utilisateur courant. Une autre variable intéressante
 142        est l’objet de base de données $db. Comment employer ces variables dans
 143        vos propres scripts est hors du propos de ce document, mais voici un petit
 144        exemple vous montrant comment afficher un message simple saluant l’utilisateur
 145        courant sur votre page d’accueil : </p>
 146  
 147    <pre>Bonjour &lt;?php echo pun_htmlspecialchars($pun_user['username']); ?&gt;!</pre>
 148  
 149    <p>En plus de définir PUN_ROOT, vous pouvez définir un certain nombre d’autres
 150        constantes pour changer le comportement de PunBB en incluant common.php.
 151        Les deux les plus intéressantes de ces constantes sont PUN_TURN_OFF_MAINT
 152        et PUN_QUIET_VISIT. Si PUN_TURN_OFF_MAINT est défini en incluant common.php,
 153        si les forums sont en mode maintenance, PunBB ne bloquera pas pour afficher
 154        le message de maintenance. Vous ne voulez généralement pas que ce message
 155        s’affiche sur votre page d’accueil, pour cela définir cette constante est
 156        une bonne idée. L’autre constante, PUN_QUIET_VISIT, empêche PunBB de mettre à jour
 157        les données de dernières visite de l’utilisateur courant dans la base de
 158        données de sorte qu’une visite à la page d’accueil ne compte pas comme
 159        visite dans les forums. C’est également un comportement souhaitable dans
 160        la plupart des cas. La valeur à laquelle vous placez ces constantes n’importe
 161        pas, mais les régler à une valeur de 1 est probablement une bonne idée.
 162        Exemple : </p>
 163  
 164    <pre>define('PUN_TURN_OFF_MAINT', 1);
 165  define('PUN_QUIET_VISIT', 1);</pre>
 166  
 167    <p>Veuillez noter que ces constantes doivent être définies avant que common.php soit inclus.</p>
 168    <hr />
 169  
 170    <h2>Plugins<a name="plugins" id="plugins"></a></h2>
 171  
 172    <p>Les plugins admin Les plugins Admin sont des modules pour l’interface d’administration
 173        de PunBB qui peuvent êtres installés en placant simplement le script plugin
 174        dans le répertoire plugins. Voyez le plugin exemple pour des informations
 175        sur la façon d’écrire votre propre plugin. Voici quelques notes d’intérêssantes
 176        pour les aspirants auteurs de plugin : </p>
 177  
 178    <ul>
 179      <li>Si vous voulez afficher un message par l’intermédiaire de la fonction
 180          message(), vous devez le faire avant d’appeler generate_admin_menu($plugin).</li>
 181  
 182      <li>Les plugins sont chargés par admin_loader.php et ne doivent pas être
 183          terminés (par exemple en appelant exit()). Après que le script du plugin
 184          ait fini, le script du chargeur affiche le pied de page, ainsi inutil
 185          de vous souciez de cela. Cependant veuillez noter que terminer un plugin
 186          en appelant message() ou redirect() est très bien.</li>
 187  
 188      <li>L’attribut action de toute balise &lt;form&gt; et l’URL cible pour la
 189          fonction redirect() doit être placé à la valeur de $_SERVER[’REQUEST_URI’].
 190          Cette URL peut cependant être étendue pour inclure des variables supplémentaires
 191          (comme l’ajout de &amp;foo=bar dans le plugin exemple).</li>
 192  
 193      <li>Si votre plugin est pour les administrateurs seulement, le nom de fichier
 194          doit avoir le préfixe AP_. S’il est pour les administrateurs et les modérateurs,
 195          utilisez le préfixe AMP_. Le plugin exemple a le préfixe AMP_ et est
 196          donc disponible dans le menu de navigation aux administrateurs et aux
 197          modérateurs.</li>
 198  
 199      <li>Utilisez _ au lieu des espaces dans le nom de fichier.</li>
 200  
 201      <li>Tant que les scripts de plugin sont inclus depuis le scripts admin_loader.php
 202          de PunBB, vous avez accès toutes les fonctions et variables globales
 203          de PunBB (par exemple $db, $pun_config, $pun_user etc.).</li>
 204  
 205      <li>Faites de votre mieux pour garder l’aspect et l’ergonomie de votre interface
 206          utilisateur de plugins semblable au reste des scripts d’administration.
 207          N’hésitez pas à emprunter le marquage et le code aux scripts d’admin
 208          pour l’employer dans vos plugins.</li>
 209  
 210      <li>Les plugins doivent êtres délivrés sous la licence d’utilisation GNU/GPL
 211          ou une licence compatible. Recopiez le préambule GPL (situé en haut des
 212          scripts de PunBB) dans votre script de plugin et changez l e copyright
 213          pour qu’il corresponde à l’auteur du plugin (c’est à dire vous).</li>
 214    </ul>
 215    <hr />
 216  
 217    <h2>Références tables de la base de données<a name="dbtables" id=
 218    "dbtables"></a></h2>
 219  
 220    <p>Ce qui suit est une liste complète de toutes les tables de base de données
 221        de PunBB avec leurs champs respectifs. Les clés primaire sont soulignées.</p>
 222  
 223    <h3>bans<a id="bans" name="bans"></a></h3>
 224  
 225    <table summary="Banned users">
 226      <thead>
 227        <tr>
 228          <th class="tc1">Field</th>
 229  
 230          <th class="tc2">Type</th>
 231  
 232          <th class="tc3">Default</th>
 233  
 234          <th class="tc4">Description</th>
 235        </tr>
 236      </thead>
 237  
 238      <tbody>
 239        <tr>
 240          <td class="primary">id</td>
 241  
 242          <td>int</td>
 243  
 244          <td> </td>
 245  
 246          <td>The auto-incrementing (identity) primary key identifier
 247          for this table.</td>
 248        </tr>
 249  
 250        <tr>
 251          <td>username</td>
 252  
 253          <td>varchar(200)</td>
 254  
 255          <td><em>NULL</em></td>
 256  
 257          <td>The username this ban applies to.</td>
 258        </tr>
 259  
 260        <tr>
 261          <td>ip</td>
 262  
 263          <td>varchar(255)</td>
 264  
 265          <td><em>NULL</em></td>
 266  
 267          <td>The IP address(es) or partial IP address(es) this ban
 268          applies to.</td>
 269        </tr>
 270  
 271        <tr>
 272          <td>email</td>
 273  
 274          <td>varchar(50)</td>
 275  
 276          <td><em>NULL</em></td>
 277  
 278          <td>The e-mail address or e-mail address domain name this
 279          ban applies to.</td>
 280        </tr>
 281  
 282        <tr>
 283          <td>message</td>
 284  
 285          <td>varchar(255)</td>
 286  
 287          <td><em>NULL</em></td>
 288  
 289          <td>A message that is displayed for the banned user.</td>
 290        </tr>
 291  
 292        <tr>
 293          <td>expire</td>
 294  
 295          <td>int</td>
 296  
 297          <td><em>NULL</em></td>
 298  
 299          <td>A UNIX timestamp representing the day when the ban
 300          expires.</td>
 301        </tr>
 302      </tbody>
 303    </table>
 304  
 305    <h3>categories<a id="categories" name="categories"></a></h3>
 306  
 307    <table summary="Categories that envelop forums">
 308      <thead>
 309        <tr>
 310          <th class="tc1">Field</th>
 311  
 312          <th class="tc2">Type</th>
 313  
 314          <th class="tc3">Default</th>
 315  
 316          <th>Description</th>
 317        </tr>
 318      </thead>
 319  
 320      <tbody>
 321        <tr>
 322          <td class="primary">id</td>
 323  
 324          <td>int</td>
 325  
 326          <td> </td>
 327  
 328          <td>The auto-incrementing (identity) primary key identifier
 329          for this table.</td>
 330        </tr>
 331  
 332        <tr>
 333          <td>cat_name</td>
 334  
 335          <td>varchar(80)</td>
 336  
 337          <td>'New Category'</td>
 338  
 339          <td>The name of the category.</td>
 340        </tr>
 341  
 342        <tr>
 343          <td>disp_position</td>
 344  
 345          <td>int</td>
 346  
 347          <td>0</td>
 348  
 349          <td>The vertical display position of the category (relative
 350          to other categories).</td>
 351        </tr>
 352      </tbody>
 353    </table>
 354  
 355    <h3>censoring<a id="censoring" name="censoring"></a></h3>
 356  
 357    <table summary="Words to censor in posts">
 358      <thead>
 359        <tr>
 360          <th class="tc1">Field</th>
 361  
 362          <th class="tc2">Type</th>
 363  
 364          <th class="tc3">Default</th>
 365  
 366          <th>Description</th>
 367        </tr>
 368      </thead>
 369  
 370      <tbody>
 371        <tr>
 372          <td class="primary">id</td>
 373  
 374          <td>int</td>
 375  
 376          <td> </td>
 377  
 378          <td>The auto-incrementing (identity) primary key identifier
 379          for this table.</td>
 380        </tr>
 381  
 382        <tr>
 383          <td>search_for</td>
 384  
 385          <td>varchar(60)</td>
 386  
 387          <td> </td>
 388  
 389          <td>The term to search for.</td>
 390        </tr>
 391  
 392        <tr>
 393          <td>replace_with</td>
 394  
 395          <td>varchar(60)</td>
 396  
 397          <td> </td>
 398  
 399          <td>The term to replace <em>search_for</em> with.</td>
 400        </tr>
 401      </tbody>
 402    </table>
 403  
 404    <h3>config<a id="config" name="config"></a></h3>
 405  
 406    <table summary="Configuration settings">
 407      <thead>
 408        <tr>
 409          <th class="tc1">Field</th>
 410  
 411          <th class="tc2">Type</th>
 412  
 413          <th class="tc3">Default</th>
 414  
 415          <th>Description</th>
 416        </tr>
 417      </thead>
 418  
 419      <tbody>
 420        <tr>
 421          <td class="primary">conf_name</td>
 422  
 423          <td>varchar(255)</td>
 424  
 425          <td> </td>
 426  
 427          <td>The name of a configuration variable. General
 428          configuration options start with the prefix o_ and general
 429          permission options start with p_.</td>
 430        </tr>
 431  
 432        <tr>
 433          <td>conf_value</td>
 434  
 435          <td>text</td>
 436  
 437          <td><em>NULL</em></td>
 438  
 439          <td>The value of the configuration variable
 440          <em>conf_name</em>.</td>
 441        </tr>
 442      </tbody>
 443    </table>
 444  
 445    <h3>forum_perms<a id="forum_perms" name="forum_perms"></a></h3>
 446  
 447    <table summary="Group forum permissions">
 448      <thead>
 449        <tr>
 450          <th class="tc1">Field</th>
 451  
 452          <th class="tc2">Type</th>
 453  
 454          <th class="tc3">Default</th>
 455  
 456          <th>Description</th>
 457        </tr>
 458      </thead>
 459  
 460      <tbody>
 461        <tr>
 462          <td class="primary">group_id</td>
 463  
 464          <td>int</td>
 465  
 466          <td> </td>
 467  
 468          <td>The user group for which these permissions apply.
 469          Primary key identifier together with forum_id for this
 470          table.</td>
 471        </tr>
 472  
 473        <tr>
 474          <td class="primary">forum_id</td>
 475  
 476          <td>int</td>
 477  
 478          <td> </td>
 479  
 480          <td>The forum in which these permissions apply. Primary key
 481          identifier together with group_id for this table.</td>
 482        </tr>
 483  
 484        <tr>
 485          <td>read_forum</td>
 486  
 487          <td>tinyint/smallint</td>
 488  
 489          <td>1</td>
 490  
 491          <td>0 = Deny. 1 = Allow.</td>
 492        </tr>
 493  
 494        <tr>
 495          <td>post_replies</td>
 496  
 497          <td>tinyint/smallint</td>
 498  
 499          <td>1</td>
 500  
 501          <td>0 = Deny. 1 = Allow.</td>
 502        </tr>
 503  
 504        <tr>
 505          <td>post_topics</td>
 506  
 507          <td>tinyint/smallint</td>
 508  
 509          <td>1</td>
 510  
 511          <td>0 = Deny. 1 = Allow.</td>
 512        </tr>
 513      </tbody>
 514    </table>
 515  
 516    <h3>forums<a id="forums" name="forums"></a></h3>
 517  
 518    <table summary="Forums">
 519      <thead>
 520        <tr>
 521          <th class="tc1">Field</th>
 522  
 523          <th class="tc2">Type</th>
 524  
 525          <th class="tc3">Default</th>
 526  
 527          <th>Description</th>
 528        </tr>
 529      </thead>
 530  
 531      <tbody>
 532        <tr>
 533          <td class="primary">id</td>
 534  
 535          <td>int</td>
 536  
 537          <td> </td>
 538  
 539          <td>The auto-incrementing (identity) primary key identifier
 540          for this table.</td>
 541        </tr>
 542  
 543        <tr>
 544          <td>forum_name</td>
 545  
 546          <td>varchar(80)</td>
 547  
 548          <td>'New forum'</td>
 549  
 550          <td>The name of the forum.</td>
 551        </tr>
 552  
 553        <tr>
 554          <td>forum_desc</td>
 555  
 556          <td>text</td>
 557  
 558          <td><em>NULL</em></td>
 559  
 560          <td>A description of the forum.</td>
 561        </tr>
 562  
 563        <tr>
 564          <td>redirect_url</td>
 565  
 566          <td>varchar(100)</td>
 567  
 568          <td><em>NULL</em></td>
 569  
 570          <td>The URL to redirect users to upon clicking the forum
 571          link on the index page.</td>
 572        </tr>
 573  
 574        <tr>
 575          <td>moderators</td>
 576  
 577          <td>text</td>
 578  
 579          <td><em>NULL</em></td>
 580  
 581          <td>A serialized PHP array of moderators.</td>
 582        </tr>
 583  
 584        <tr>
 585          <td>num_topics</td>
 586  
 587          <td>mediumint/int</td>
 588  
 589          <td>0</td>
 590  
 591          <td>The number of topics the forum contains.</td>
 592        </tr>
 593  
 594        <tr>
 595          <td>num_posts</td>
 596  
 597          <td>mediumint/int</td>
 598  
 599          <td>0</td>
 600  
 601          <td>The number of posts the forum contains.</td>
 602        </tr>
 603  
 604        <tr>
 605          <td>last_post</td>
 606  
 607          <td>int</td>
 608  
 609          <td><em>NULL</em></td>
 610  
 611          <td>A UNIX timestamp representing the date/time the last
 612          post was made in the forum.</td>
 613        </tr>
 614  
 615        <tr>
 616          <td>last_post_id</td>
 617  
 618          <td>int</td>
 619  
 620          <td><em>NULL</em></td>
 621  
 622          <td>The ID of the last post that was made in the
 623          forum.</td>
 624        </tr>
 625  
 626        <tr>
 627          <td>last_poster</td>
 628  
 629          <td>varchar(200)</td>
 630  
 631          <td><em>NULL</em></td>
 632  
 633          <td>The username (or guest name) of the user that made the
 634          last post in the forum.</td>
 635        </tr>
 636  
 637        <tr>
 638          <td>sort_by</td>
 639  
 640          <td>tinyint/smallint</td>
 641  
 642          <td>0</td>
 643  
 644          <td>0 = Display topics sorted by last post. 1 = Display topics sorted by topic start.</td>
 645        </tr>
 646  
 647        <tr>
 648          <td>disp_position</td>
 649  
 650          <td>int</td>
 651  
 652          <td>0</td>
 653  
 654          <td>The vertical display position of the forum (relative to
 655          other forums in the same category).</td>
 656        </tr>
 657  
 658        <tr>
 659          <td>cat_id</td>
 660  
 661          <td>int</td>
 662  
 663          <td>0</td>
 664  
 665          <td>The category in which the forum resides.</td>
 666        </tr>
 667      </tbody>
 668    </table>
 669  
 670    <h3>groups<a id="groups" name="groups"></a></h3>
 671  
 672    <table summary="User groups">
 673      <thead>
 674        <tr>
 675          <th class="tc1">Field</th>
 676  
 677          <th class="tc2">Type</th>
 678  
 679          <th class="tc3">Default</th>
 680  
 681          <th>Description</th>
 682        </tr>
 683      </thead>
 684  
 685      <tbody>
 686        <tr>
 687          <td class="primary">g_id</td>
 688  
 689          <td>int</td>
 690  
 691          <td> </td>
 692  
 693          <td>The auto-incrementing (identity) primary key identifier
 694          for this table.</td>
 695        </tr>
 696  
 697        <tr>
 698          <td>g_title</td>
 699  
 700          <td>varchar(50)</td>
 701  
 702          <td> </td>
 703  
 704          <td>The name of the group.</td>
 705        </tr>
 706  
 707        <tr>
 708          <td>g_user_title</td>
 709  
 710          <td>varchar(50)</td>
 711  
 712          <td><em>NULL</em></td>
 713  
 714          <td>The title of users in this group.</td>
 715        </tr>
 716  
 717        <tr>
 718          <td>g_read_board</td>
 719  
 720          <td>tinyint/smallint</td>
 721  
 722          <td>1</td>
 723  
 724          <td>0 = Deny. 1 = Allow.</td>
 725        </tr>
 726  
 727        <tr>
 728          <td>g_post_replies</td>
 729  
 730          <td>tinyint/smallint</td>
 731  
 732          <td>1</td>
 733  
 734          <td>0 = Deny. 1 = Allow.</td>
 735        </tr>
 736  
 737        <tr>
 738          <td>g_post_topics</td>
 739  
 740          <td>tinyint/smallint</td>
 741  
 742          <td>1</td>
 743  
 744          <td>0 = Deny. 1 = Allow.</td>
 745        </tr>
 746  
 747        <tr>
 748          <td>g_post_polls</td>
 749  
 750          <td>tinyint/smallint</td>
 751  
 752          <td>1</td>
 753  
 754          <td>0 = Deny. 1 = Allow.</td>
 755        </tr>
 756  
 757        <tr>
 758          <td>g_edit_posts</td>
 759  
 760          <td>tinyint/smallint</td>
 761  
 762          <td>1</td>
 763  
 764          <td>0 = Deny. 1 = Allow.</td>
 765        </tr>
 766  
 767        <tr>
 768          <td>g_delete_posts</td>
 769  
 770          <td>tinyint/smallint</td>
 771  
 772          <td>1</td>
 773  
 774          <td>0 = Deny. 1 = Allow.</td>
 775        </tr>
 776  
 777        <tr>
 778          <td>g_delete_topics</td>
 779  
 780          <td>tinyint/smallint</td>
 781  
 782          <td>1</td>
 783  
 784          <td>0 = Deny. 1 = Allow.</td>
 785        </tr>
 786  
 787        <tr>
 788          <td>g_set_title</td>
 789  
 790          <td>tinyint/smallint</td>
 791  
 792          <td>1</td>
 793  
 794          <td>0 = Deny. 1 = Allow.</td>
 795        </tr>
 796  
 797        <tr>
 798          <td>g_search</td>
 799  
 800          <td>tinyint/smallint</td>
 801  
 802          <td>1</td>
 803  
 804          <td>0 = Deny. 1 = Allow.</td>
 805        </tr>
 806  
 807        <tr>
 808          <td>g_search_users</td>
 809  
 810          <td>tinyint/smallint</td>
 811  
 812          <td>1</td>
 813  
 814          <td>0 = Deny. 1 = Allow.</td>
 815        </tr>
 816  
 817        <tr>
 818          <td>g_edit_subjects_<br />
 819          interval</td>
 820  
 821          <td>smallint</td>
 822  
 823          <td>300</td>
 824  
 825          <td>Number of seconds after post time that users in this
 826          group may edit the subject of topics they've posted.</td>
 827        </tr>
 828  
 829        <tr>
 830          <td>g_post_flood</td>
 831  
 832          <td>smallint</td>
 833  
 834          <td>30</td>
 835  
 836          <td>Number of seconds that users in this group have to wait
 837          between posts.</td>
 838        </tr>
 839  
 840        <tr>
 841          <td>g_search_flood</td>
 842  
 843          <td>smallint</td>
 844  
 845          <td>30</td>
 846  
 847          <td>Number of seconds that users in this group have to wait
 848          between searches.</td>
 849        </tr>
 850      </tbody>
 851    </table>
 852  
 853    <h3>online<a id="online" name="online"></a></h3>
 854  
 855    <table summary="Users currently online">
 856      <thead>
 857        <tr>
 858          <th class="tc1">Field</th>
 859  
 860          <th class="tc2">Type</th>
 861  
 862          <th class="tc3">Default</th>
 863  
 864          <th>Description</th>
 865        </tr>
 866      </thead>
 867  
 868      <tbody>
 869        <tr>
 870          <td>user_id</td>
 871  
 872          <td>int</td>
 873  
 874          <td>1</td>
 875  
 876          <td>ID of the user (always 1 for guests).</td>
 877        </tr>
 878  
 879        <tr>
 880          <td>ident</td>
 881  
 882          <td>varchar(200)</td>
 883  
 884          <td> </td>
 885  
 886          <td>Identification string for the user. Username for logged
 887          in users and IP address for guests.</td>
 888        </tr>
 889  
 890        <tr>
 891          <td>logged</td>
 892  
 893          <td>int</td>
 894  
 895          <td>0</td>
 896  
 897          <td>A UNIX timestamp representing the date/time for the
 898          user's last activity.</td>
 899        </tr>
 900  
 901        <tr>
 902          <td>idle</td>
 903  
 904          <td>tinyint/smallint</td>
 905  
 906          <td>0</td>
 907  
 908          <td>0 = User has been active within the last "Online
 909          timeout" seconds. 1 = User has timed out.</td>
 910        </tr>
 911      </tbody>
 912    </table>
 913  
 914    <h3>posts<a id="posts" name="posts"></a></h3>
 915  
 916    <table summary="Posts">
 917      <thead>
 918        <tr>
 919          <th class="tc1">Field</th>
 920  
 921          <th class="tc2">Type</th>
 922  
 923          <th class="tc3">Default</th>
 924  
 925          <th>Description</th>
 926        </tr>
 927      </thead>
 928  
 929      <tbody>
 930        <tr>
 931          <td class="primary">id</td>
 932  
 933          <td>int</td>
 934  
 935          <td> </td>
 936  
 937          <td>The auto-incrementing (identity) primary key identifier
 938          for this table.</td>
 939        </tr>
 940  
 941        <tr>
 942          <td>poster</td>
 943  
 944          <td>varchar(200)</td>
 945  
 946          <td> </td>
 947  
 948          <td>The username (or guest name) of the user that made the
 949          post.</td>
 950        </tr>
 951  
 952        <tr>
 953          <td>poster_id</td>
 954  
 955          <td>int</td>
 956  
 957          <td>1</td>
 958  
 959          <td>The user ID of the user that made the post (always 1
 960          for guests).</td>
 961        </tr>
 962  
 963        <tr>
 964          <td>poster_ip</td>
 965  
 966          <td>varchar(15)</td>
 967  
 968          <td><em>NULL</em></td>
 969  
 970          <td>The IP address the post was made from.</td>
 971        </tr>
 972  
 973        <tr>
 974          <td>poster_email</td>
 975  
 976          <td>varchar(50)</td>
 977  
 978          <td><em>NULL</em></td>
 979  
 980          <td>The guest e-mail address (if supplied).</td>
 981        </tr>
 982  
 983        <tr>
 984          <td>message</td>
 985  
 986          <td>text</td>
 987  
 988          <td> </td>
 989  
 990          <td>The actual message contents.</td>
 991        </tr>
 992  
 993        <tr>
 994          <td>hide_smilies</td>
 995  
 996          <td>tinyint/smallint</td>
 997  
 998          <td>0</td>
 999  
1000          <td>0 = Let users decide whether to show smilies as images
1001          or not in this post. 1 = Never show smilies as images in
1002          this post.</td>
1003        </tr>
1004  
1005        <tr>
1006          <td>posted</td>
1007  
1008          <td>int</td>
1009  
1010          <td>0</td>
1011  
1012          <td>A UNIX timestamp representing the date/time the post
1013          was made.</td>
1014        </tr>
1015  
1016        <tr>
1017          <td>edited</td>
1018  
1019          <td>int</td>
1020  
1021          <td><em>NULL</em></td>
1022  
1023          <td>A UNIX timestamp representing the date/time the post
1024          was last edited.</td>
1025        </tr>
1026  
1027        <tr>
1028          <td>edited_by</td>
1029  
1030          <td>varchar(200)</td>
1031  
1032          <td><em>NULL</em></td>
1033  
1034          <td>The username of the user that last edited the
1035          post.</td>
1036        </tr>
1037  
1038        <tr>
1039          <td>topic_id</td>
1040  
1041          <td>int</td>
1042  
1043          <td>0</td>
1044  
1045          <td>The topic ID in which the post resides.</td>
1046        </tr>
1047      </tbody>
1048    </table>
1049  
1050    <h3>ranks<a id="ranks" name="ranks"></a></h3>
1051  
1052    <table summary="Ranking of users">
1053      <thead>
1054        <tr>
1055          <th class="tc1">Field</th>
1056  
1057          <th class="tc2">Type</th>
1058  
1059          <th class="tc3">Default</th>
1060  
1061          <th>Description</th>
1062        </tr>
1063      </thead>
1064  
1065      <tbody>
1066        <tr>
1067          <td class="primary">id</td>
1068  
1069          <td>int</td>
1070  
1071          <td> </td>
1072  
1073          <td>The auto-incrementing (identity) primary key identifier
1074          for this table.</td>
1075        </tr>
1076  
1077        <tr>
1078          <td>rank</td>
1079  
1080          <td>varchar(50)</td>
1081  
1082          <td> </td>
1083  
1084          <td>The rank title.</td>
1085        </tr>
1086  
1087        <tr>
1088          <td>min_posts</td>
1089  
1090          <td>mediumint/int</td>
1091  
1092          <td>0</td>
1093  
1094          <td>The number of posts a user must attain in order to
1095          reach the rank.</td>
1096        </tr>
1097      </tbody>
1098    </table>
1099  
1100    <h3>reports<a id="reports" name="reports"></a></h3>
1101  
1102    <table summary="Reported topics/posts">
1103      <thead>
1104        <tr>
1105          <th class="tc1">Field</th>
1106  
1107          <th class="tc2">Type</th>
1108  
1109          <th class="tc3">Default</th>
1110  
1111          <th>Description</th>
1112        </tr>
1113      </thead>
1114  
1115      <tbody>
1116        <tr>
1117          <td class="primary">id</td>
1118  
1119          <td>int</td>
1120  
1121          <td> </td>
1122  
1123          <td>The auto-incrementing (identity) primary key identifier
1124          for this table.</td>
1125        </tr>
1126  
1127        <tr>
1128          <td>post_id</td>
1129  
1130          <td>int</td>
1131  
1132          <td>0</td>
1133  
1134          <td>The post the report relates to.</td>
1135        </tr>
1136  
1137        <tr>
1138          <td>topic_id</td>
1139  
1140          <td>int</td>
1141  
1142          <td>0</td>
1143  
1144          <td>The topic in which the reported post resides in.</td>
1145        </tr>
1146  
1147        <tr>
1148          <td>forum_id</td>
1149  
1150          <td>int</td>
1151  
1152          <td>0</td>
1153  
1154          <td>The forum in which the reported post resides in.</td>
1155        </tr>
1156  
1157        <tr>
1158          <td>reported_by</td>
1159  
1160          <td>int</td>
1161  
1162          <td>0</td>
1163  
1164          <td>The user ID of the user that reported the post.</td>
1165        </tr>
1166  
1167        <tr>
1168          <td>created</td>
1169  
1170          <td>int</td>
1171  
1172          <td>0</td>
1173  
1174          <td>A UNIX timestamp representing the date/time the post
1175          was last edited.</td>
1176        </tr>
1177  
1178        <tr>
1179          <td>message</td>
1180  
1181          <td>text</td>
1182  
1183          <td> </td>
1184  
1185          <td>The report message.</td>
1186        </tr>
1187  
1188        <tr>
1189          <td>zapped</td>
1190  
1191          <td>int</td>
1192  
1193          <td><em>NULL</em></td>
1194  
1195          <td>A UNIX timestamp representing the date/time the report
1196          was zapped (marked as read).</td>
1197        </tr>
1198  
1199        <tr>
1200          <td>zapped_by</td>
1201  
1202          <td>int</td>
1203  
1204          <td><em>NULL</em></td>
1205  
1206          <td>The username of the administrator or moderator that
1207          zapped the report.</td>
1208        </tr>
1209      </tbody>
1210    </table>
1211  
1212    <h3>search_cache<a id="search_cache" name=
1213    "search_cache"></a></h3>
1214  
1215    <table summary="Search cache">
1216      <thead>
1217        <tr>
1218          <th class="tc1">Field</th>
1219  
1220          <th class="tc2">Type</th>
1221  
1222          <th class="tc3">Default</th>
1223  
1224          <th>Description</th>
1225        </tr>
1226      </thead>
1227  
1228      <tbody>
1229        <tr>
1230          <td class="primary">id</td>
1231  
1232          <td>int</td>
1233  
1234          <td>0</td>
1235  
1236          <td>The primary key identifier for this table.</td>
1237        </tr>
1238  
1239        <tr>
1240          <td>ident</td>
1241  
1242          <td>varchar(200)</td>
1243  
1244          <td> </td>
1245  
1246          <td>Identification string for the searcher. Username for
1247          logged in users and IP address for guests.</td>
1248        </tr>
1249  
1250        <tr>
1251          <td>search_data</td>
1252  
1253          <td>text</td>
1254  
1255          <td> </td>
1256  
1257          <td>A serialized PHP array of search data (e.g. post ID's,
1258          sort direction etc.).</td>
1259        </tr>
1260      </tbody>
1261    </table>
1262  
1263    <h3>search_matches<a id="search_matches" name=
1264    "search_matches"></a></h3>
1265  
1266    <table summary="Posts matching search words">
1267      <thead>
1268        <tr>
1269          <th class="tc1">Field</th>
1270  
1271          <th class="tc2">Type</th>
1272  
1273          <th class="tc3">Default</th>
1274  
1275          <th>Description</th>
1276        </tr>
1277      </thead>
1278  
1279      <tbody>
1280        <tr>
1281          <td>post_id</td>
1282  
1283          <td>int</td>
1284  
1285          <td>0</td>
1286  
1287          <td>The post this match relates to.</td>
1288        </tr>
1289  
1290        <tr>
1291          <td>word_id</td>
1292  
1293          <td>mediumint/int</td>
1294  
1295          <td>0</td>
1296  
1297          <td>The word this match relates to.</td>
1298        </tr>
1299  
1300        <tr>
1301          <td>subject_match</td>
1302  
1303          <td>tinyint/smallint</td>
1304  
1305          <td>0</td>
1306  
1307          <td>0 = Match is in the post message. 1 = Match is in the
1308          topic subject.</td>
1309        </tr>
1310      </tbody>
1311    </table>
1312  
1313    <h3>search_words<a id="search_words" name=
1314    "search_words"></a></h3>
1315  
1316    <table summary="Words used in posts">
1317      <thead>
1318        <tr>
1319          <th class="tc1">Field</th>
1320  
1321          <th class="tc2">Type</th>
1322  
1323          <th class="tc3">Default</th>
1324  
1325          <th>Description</th>
1326        </tr>
1327      </thead>
1328  
1329      <tbody>
1330        <tr>
1331          <td>id</td>
1332  
1333          <td>mediumint/int</td>
1334  
1335          <td> </td>
1336  
1337          <td>An integer identifier for this table.</td>
1338        </tr>
1339  
1340        <tr>
1341          <td class="primary">word</td>
1342  
1343          <td>varchar(20)</td>
1344  
1345          <td> </td>
1346  
1347          <td>The indexed word (primary key).</td>
1348        </tr>
1349      </tbody>
1350    </table>
1351  
1352    <h3>subscriptions<a id="subscriptions" name=
1353    "subscriptions"></a></h3>
1354  
1355    <table summary="E-mail subscriptions to topics">
1356      <thead>
1357        <tr>
1358          <th class="tc1">Field</th>
1359  
1360          <th class="tc2">Type</th>
1361  
1362          <th class="tc3">Default</th>
1363  
1364          <th>Description</th>
1365        </tr>
1366      </thead>
1367  
1368      <tbody>
1369        <tr>
1370          <td class="primary">user_id</td>
1371  
1372          <td>int</td>
1373  
1374          <td>0</td>
1375  
1376          <td>The user that subscribes to <em>topic_id</em>. Primary
1377          key identifier together with <em>topic_id</em> for this
1378          table.</td>
1379        </tr>
1380  
1381        <tr>
1382          <td class="primary">topic_id</td>
1383  
1384          <td>int</td>
1385  
1386          <td>0</td>
1387  
1388          <td>The topic <em>user_id</em> subscribes to. Primary key
1389          identifier together with <em>user_id</em> for this
1390          table.</td>
1391        </tr>
1392      </tbody>
1393    </table>
1394  
1395    <h3>topics<a id="topics" name="topics"></a></h3>
1396  
1397    <table summary="Topics">
1398      <thead>
1399        <tr>
1400          <th class="tc1">Field</th>
1401  
1402          <th class="tc2">Type</th>
1403  
1404          <th class="tc3">Default</th>
1405  
1406          <th>Description</th>
1407        </tr>
1408      </thead>
1409  
1410      <tbody>
1411        <tr>
1412          <td class="primary">id</td>
1413  
1414          <td>int</td>
1415  
1416          <td> </td>
1417  
1418          <td>The auto-incrementing (identity) primary key identifier
1419          for this table.</td>
1420        </tr>
1421  
1422        <tr>
1423          <td>poster</td>
1424  
1425          <td>varchar(200)</td>
1426  
1427          <td> </td>
1428  
1429          <td>The username (or guest name) of the user that posted
1430          the topic.</td>
1431        </tr>
1432  
1433        <tr>
1434          <td>subject</td>
1435  
1436          <td>varchar(255)</td>
1437  
1438          <td> </td>
1439  
1440          <td>The topic subject.</td>
1441        </tr>
1442  
1443        <tr>
1444          <td>posted</td>
1445  
1446          <td>int</td>
1447  
1448          <td>0</td>
1449  
1450          <td>A UNIX timestamp representing the date/time the topic
1451          was posted.</td>
1452        </tr>
1453  
1454        <tr>
1455          <td>last_post</td>
1456  
1457          <td>int</td>
1458  
1459          <td><em>NULL</em></td>
1460  
1461          <td>A UNIX timestamp representing the date/time the last
1462          post was made in the topic.</td>
1463        </tr>
1464  
1465        <tr>
1466          <td>last_post_id</td>
1467  
1468          <td>int</td>
1469  
1470          <td><em>NULL</em></td>
1471  
1472          <td>The ID of the last post that was made in the
1473          topic.</td>
1474        </tr>
1475  
1476        <tr>
1477          <td>last_poster</td>
1478  
1479          <td>varchar(200)</td>
1480  
1481          <td><em>NULL</em></td>
1482  
1483          <td>The username (or guest name) of the user that made the
1484          last post in the topic.</td>
1485        </tr>
1486  
1487        <tr>
1488          <td>num_views</td>
1489  
1490          <td>mediumint/int</td>
1491  
1492          <td>0</td>
1493  
1494          <td>The number of times the topic has been viewed.</td>
1495        </tr>
1496  
1497        <tr>
1498          <td>num_replies</td>
1499  
1500          <td>mediumint/int</td>
1501  
1502          <td>0</td>
1503  
1504          <td>The number of replies that have been posted in the
1505          topic.</td>
1506        </tr>
1507  
1508        <tr>
1509          <td>closed</td>
1510  
1511          <td>tinyint/smallint</td>
1512  
1513          <td>0</td>
1514  
1515          <td>0 = Topic is open. 1 = Topic is closed.</td>
1516        </tr>
1517  
1518        <tr>
1519          <td>sticky</td>
1520  
1521          <td>tinyint/smallint</td>
1522  
1523          <td>0</td>
1524  
1525          <td>0 = Topic is a regular topic. 1 = Topic is a sticky
1526          topic.</td>
1527        </tr>
1528  
1529        <tr>
1530          <td>moved_to</td>
1531  
1532          <td>int</td>
1533  
1534          <td><em>NULL</em></td>
1535  
1536          <td>The forum to which the topic has been moved.</td>
1537        </tr>
1538  
1539        <tr>
1540          <td>forum_id</td>
1541  
1542          <td>int</td>
1543  
1544          <td>0</td>
1545  
1546          <td>The forum in which the topic resides.</td>
1547        </tr>
1548      </tbody>
1549    </table>
1550  
1551    <h3>users<a id="users" name="users"></a></h3>
1552  
1553    <table summary="Users">
1554      <thead>
1555        <tr>
1556          <th class="tc1">Field</th>
1557  
1558          <th class="tc2">Type</th>
1559  
1560          <th class="tc3">Default</th>
1561  
1562          <th>Description</th>
1563        </tr>
1564      </thead>
1565  
1566      <tbody>
1567        <tr>
1568          <td class="primary">id</td>
1569  
1570          <td>int</td>
1571  
1572          <td> </td>
1573  
1574          <td>The auto-incrementing (identity) primary key identifier
1575          for this table.</td>
1576        </tr>
1577  
1578        <tr>
1579          <td>group_id</td>
1580  
1581          <td>int</td>
1582  
1583          <td>4</td>
1584  
1585          <td>The user group to which this user belongs.</td>
1586        </tr>
1587  
1588        <tr>
1589          <td>username</td>
1590  
1591          <td>varchar(200)</td>
1592  
1593          <td> </td>
1594  
1595          <td>The user's username.</td>
1596        </tr>
1597  
1598        <tr>
1599          <td>password</td>
1600  
1601          <td>varchar(40)</td>
1602  
1603          <td> </td>
1604  
1605          <td>The user password as an 40 byte SHA1 hash or an 32 byte
1606          MD5 hash.</td>
1607        </tr>
1608  
1609        <tr>
1610          <td>email</td>
1611  
1612          <td>varchar(50)</td>
1613  
1614          <td> </td>
1615  
1616          <td>The user e-mail address.</td>
1617        </tr>
1618  
1619        <tr>
1620          <td>title</td>
1621  
1622          <td>varchar(50)</td>
1623  
1624          <td><em>NULL</em></td>
1625  
1626          <td>The user custom title.</td>
1627        </tr>
1628  
1629        <tr>
1630          <td>realname</td>
1631  
1632          <td>varchar(40)</td>
1633  
1634          <td><em>NULL</em></td>
1635  
1636          <td>The user's name.</td>
1637        </tr>
1638  
1639        <tr>
1640          <td>url</td>
1641  
1642          <td>varchar(100)</td>
1643  
1644          <td><em>NULL</em></td>
1645  
1646          <td>A link to the user's website.</td>
1647        </tr>
1648  
1649        <tr>
1650          <td>jabber</td>
1651  
1652          <td>varchar(75)</td>
1653  
1654          <td><em>NULL</em></td>
1655  
1656          <td>The user's Jabber address.</td>
1657        </tr>
1658  
1659        <tr>
1660          <td>icq</td>
1661  
1662          <td>varchar(12)</td>
1663  
1664          <td><em>NULL</em></td>
1665  
1666          <td>The user's ICQ UIN.</td>
1667        </tr>
1668  
1669        <tr>
1670          <td>msn</td>
1671  
1672          <td>varchar(50)</td>
1673  
1674          <td><em>NULL</em></td>
1675  
1676          <td>The user's MSN Messenger e-mail address.</td>
1677        </tr>
1678  
1679        <tr>
1680          <td>aim</td>
1681  
1682          <td>varchar(30)</td>
1683  
1684          <td><em>NULL</em></td>
1685  
1686          <td>The user's AOL Instant Messenger username.</td>
1687        </tr>
1688  
1689        <tr>
1690          <td>yahoo</td>
1691  
1692          <td>varchar(30)</td>
1693  
1694          <td><em>NULL</em></td>
1695  
1696          <td>The user's Yahoo Messenger username.</td>
1697        </tr>
1698  
1699        <tr>
1700          <td>location</td>
1701  
1702          <td>varchar(30)</td>
1703  
1704          <td><em>NULL</em></td>
1705  
1706          <td>The user's geographical location.</td>
1707        </tr>
1708  
1709        <tr>
1710          <td>use_avatar</td>
1711  
1712          <td>tinyint/smallint</td>
1713  
1714          <td>0</td>
1715  
1716          <td>0 = Don't show avatar to other users. 1 = Show avatar
1717          to other users.</td>
1718        </tr>
1719  
1720        <tr>
1721          <td>signature</td>
1722  
1723          <td>text</td>
1724  
1725          <td><em>NULL</em></td>
1726  
1727          <td>The user's signature.</td>
1728        </tr>
1729  
1730        <tr>
1731          <td>disp_topics</td>
1732  
1733          <td>tinyint/smallint</td>
1734  
1735          <td><em>NULL</em></td>
1736  
1737          <td>The number of topics to display on forum page (uses
1738          forum default if left blank).</td>
1739        </tr>
1740  
1741        <tr>
1742          <td>disp_posts</td>
1743  
1744          <td>tinyint/smallint</td>
1745  
1746          <td><em>NULL</em></td>
1747  
1748          <td>The number of posts to display on topic page (uses
1749          forum default if left blank).</td>
1750        </tr>
1751  
1752        <tr>
1753          <td>email_setting</td>
1754  
1755          <td>tinyint/smallint</td>
1756  
1757          <td>1</td>
1758  
1759          <td>0 = Show e-mail address to other users. 1 = Hide e-mail
1760          address, but allow form e-mail. 2 = Hide e-mail address and
1761          disallow form e-mail.</td>
1762        </tr>
1763  
1764        <tr>
1765          <td>save_pass</td>
1766  
1767          <td>tinyint/smallint</td>
1768  
1769          <td>1</td>
1770  
1771          <td>0 = Don't remember user between visits. 1 = Remember
1772          user between visits.</td>
1773        </tr>
1774  
1775        <tr>
1776          <td>notify_with_post</td>
1777  
1778          <td>tinyint/smallint</td>
1779  
1780          <td>0</td>
1781  
1782          <td>0 = Include only topic subject in subscription
1783          notification e-mails. 1 = Include both topic subject and
1784          post content in subscription notification e-mails.</td>
1785        </tr>
1786  
1787        <tr>
1788          <td>show_smilies</td>
1789  
1790          <td>tinyint/smallint</td>
1791  
1792          <td>1</td>
1793  
1794          <td>Show smilies as images.</td>
1795        </tr>
1796  
1797        <tr>
1798          <td>show_img</td>
1799  
1800          <td>tinyint/smallint</td>
1801  
1802          <td>1</td>
1803  
1804          <td>Show images in posts.</td>
1805        </tr>
1806  
1807        <tr>
1808          <td>show_img_sig</td>
1809  
1810          <td>tinyint/smallint</td>
1811  
1812          <td>1</td>
1813  
1814          <td>Show images in signatures.</td>
1815        </tr>
1816  
1817        <tr>
1818          <td>show_avatars</td>
1819  
1820          <td>tinyint/smallint</td>
1821  
1822          <td>1</td>
1823  
1824          <td>Show avatars.</td>
1825        </tr>
1826  
1827        <tr>
1828          <td>show_sig</td>
1829  
1830          <td>tinyint/smallint</td>
1831  
1832          <td>1</td>
1833  
1834          <td>Show signatures.</td>
1835        </tr>
1836  
1837        <tr>
1838          <td>timezone</td>
1839  
1840          <td>float</td>
1841  
1842          <td>0</td>
1843  
1844          <td>The user's timezone.</td>
1845        </tr>
1846  
1847        <tr>
1848          <td>language</td>
1849  
1850          <td>varchar(25)</td>
1851  
1852          <td>'English'</td>
1853  
1854          <td>The user's preferred language for the forum UI.</td>
1855        </tr>
1856  
1857        <tr>
1858          <td>style</td>
1859  
1860          <td>varchar(25)</td>
1861  
1862          <td>'Oxygen'</td>
1863  
1864          <td>The user's preferred style.</td>
1865        </tr>
1866  
1867        <tr>
1868          <td>num_posts</td>
1869  
1870          <td>int</td>
1871  
1872          <td>0</td>
1873  
1874          <td>The number of posts the user has made.</td>
1875        </tr>
1876  
1877        <tr>
1878          <td>last_post</td>
1879  
1880          <td>int</td>
1881  
1882          <td><em>NULL</em></td>
1883  
1884          <td>A UNIX timestamp representing the date/time the last
1885          post by the user was made.</td>
1886        </tr>
1887  
1888        <tr>
1889          <td>registered</td>
1890  
1891          <td>int</td>
1892  
1893          <td>0</td>
1894  
1895          <td>A UNIX timestamp representing the date the user
1896          registered.</td>
1897        </tr>
1898  
1899        <tr>
1900          <td>registration_ip</td>
1901  
1902          <td>varchar(15)</td>
1903  
1904          <td>0.0.0.0</td>
1905  
1906          <td>The IP address used when registering.</td>
1907        </tr>
1908  
1909        <tr>
1910          <td>last_visit</td>
1911  
1912          <td>int</td>
1913  
1914          <td>0</td>
1915  
1916          <td>A UNIX timestamp representing the date/time the last
1917          visit by the user commenced.</td>
1918        </tr>
1919  
1920        <tr>
1921          <td>admin_note</td>
1922  
1923          <td>varchar(30)</td>
1924  
1925          <td><em>NULL</em></td>
1926  
1927          <td>A user note only viewable and editable by
1928          administrators and moderators.</td>
1929        </tr>
1930  
1931        <tr>
1932          <td>activate_string</td>
1933  
1934          <td>varchar(50)</td>
1935  
1936          <td><em>NULL</em></td>
1937  
1938          <td>A temporary storage string for new passwords and new
1939          e-mail addresses.</td>
1940        </tr>
1941  
1942        <tr>
1943          <td>activate_key</td>
1944  
1945          <td>varchar(8)</td>
1946  
1947          <td><em>NULL</em></td>
1948  
1949          <td>A temporary storage string for new password and new
1950          e-mail address activation keys.</td>
1951        </tr>
1952      </tbody>
1953    </table>
1954  </body>
1955  </html>