Search options (Page 13 of 21)

2005-03-02 13:55

I do not want it below the footer. I want it before the footer.

2005-03-02 13:08

Huuum,

I put that in main.tpl:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html 

dir="<pun_content_direction>">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<pun_char_encoding>" 

/>
<pun_head>
</head>
<body>

<div id="punwrap">
<div id="pun<pun_page>" class="pun">

<div id="brdheader" 

class="block">
    <div class="box">
        <div id="brdtitle" class="inbox">
            <pun_title>
        

    <pun_desc>
        </div>
        <pun_navlinks>
        <pun_status>
    </div>
</div>

<pun_announcement>

<pun_main>

<pun_include _google.php><pun_footer>

</div>
</div>

</body>
</html>

and this is my _google.php file:

<?php

switch ($pun_user['style'])
{
    case 'Cobalt':
        $bg_color = '2A2A2A';
        $link_color = '60A0DC';
        $text_color = 'D4D4D4';
        break;

    case 'Mercury':
        $bg_color = '2A2A2A';
        $link_color = 'F6B620';
        $text_color = 'D4D4D4';
        break;

    case 'Radium':
        $bg_color = '2A2A2A';
        $link_color = '60C860';
        $text_color = 'D4D4D4';
        break;

    case 'Sulfur':
        $bg_color = 'FFFFFF';
        $link_color = '822100';
        $text_color = '333333';
        break;

    case 'Lithium':
        $bg_color = 'FFFFFF';
        $link_color = '638137';
        $text_color = '333333';
        break;

    case 'Oxygen':
        $bg_color = 'FFFFFF';
        $link_color = '005CB1';
        $text_color = '333333';
        break;
    
    default:
        $bg_color = '383838';
        $link_color = '426b94';
        $text_color = 'FFFFFF';
        break;
}

?>
<div style="TEXT-ALIGN: center">
    <script type="text/javascript">
    <!--
        google_ad_client = "pub-2756180042206854";
        google_ad_width = 728;
        google_ad_height = 90;
        google_ad_format = "728x90_as";
        google_ad_channel ="";
        google_ad_type = "text_image";
        google_color_border = "<?php echo $bg_color ?>";
        google_color_bg = "<?php echo $bg_color ?>";
        google_color_link = "<?php echo $link_color ?>";
        google_color_url = "<?php echo $link_color ?>";
        google_color_text = "<?php echo $text_color ?>";
        google_alternate_color = "<?php echo $bg_color ?>";
    //-->
    </script>
    <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
</div>

but it has no effect

2005-03-02 10:17

Connorhd wrote:

and its not a mod

What is it?

You said a few weeks ago that it will be released in 1 or 2 weeks...

Ludo,

2005-03-02 09:57

Connorhd, are you always working on punCMS ?
We'll have it soon?

Ludo,

2005-03-02 09:36

Tuf wrote:

rester a la version 1.1.5, ne pose pas de problème de sécurité, hein ?

Malheureusement pour vous, 1.1.5 pose de problèmes de sécurité, tout comme 1.2
1.2.2 permet de corriger ces erreurs.
Sinon, si vous voulez rester à 1.1.5 vous devez editer le code manuellement http://dev.punbb.org/changeset/101

Rickard wrote:

It should be noted that PunBB 1.1.* might very well be affected by some of these vulnerabilities as well, so if you're still running PunBB 1.1.*, I recommend that you at least apply the fixes in changeset 101.

Ludo,

2005-03-01 20:10

seems to have worked.

This is what I got now:

Structure de la table `forumbans`
-- 

CREATE TABLE `forumbans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcategories`
-- 

CREATE TABLE `forumcategories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcensoring`
-- 

CREATE TABLE `forumcensoring` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `search_for` varchar(60) NOT NULL default '',
  `replace_with` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumconfig`
-- 

CREATE TABLE `forumconfig` (
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text,
  PRIMARY KEY  (`conf_name`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforum_perms`
-- 

CREATE TABLE `forumforum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`,`forum_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforums`
-- 

CREATE TABLE `forumforums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `redirect_url` varchar(100) default NULL,
  `moderators` text,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `last_post_id` int(10) unsigned default NULL,
  `last_poster` varchar(200) default NULL,
  `sort_by` tinyint(1) NOT NULL default '0',
  `disp_position` int(10) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumgroups`
-- 

CREATE TABLE `forumgroups` (
  `g_id` int(10) unsigned NOT NULL auto_increment,
  `g_title` varchar(50) NOT NULL default '',
  `g_user_title` varchar(50) default NULL,
  `g_read_board` tinyint(1) NOT NULL default '1',
  `g_post_replies` tinyint(1) NOT NULL default '1',
  `g_post_topics` tinyint(1) NOT NULL default '1',
  `g_post_polls` tinyint(1) NOT NULL default '1',
  `g_edit_posts` tinyint(1) NOT NULL default '1',
  `g_delete_posts` tinyint(1) NOT NULL default '1',
  `g_delete_topics` tinyint(1) NOT NULL default '1',
  `g_set_title` tinyint(1) NOT NULL default '1',
  `g_search` tinyint(1) NOT NULL default '1',
  `g_search_users` tinyint(1) NOT NULL default '1',
  `g_edit_subjects_interval` smallint(6) NOT NULL default '300',
  `g_post_flood` smallint(6) NOT NULL default '30',
  `g_search_flood` smallint(6) NOT NULL default '30',
  PRIMARY KEY  (`g_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumonline`
-- 

CREATE TABLE `forumonline` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0',
  `idle` tinyint(1) NOT NULL default '0',
  KEY `forumonline_user_id_idx` (`user_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumposts`
-- 

CREATE TABLE `forumposts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `poster_id` int(10) unsigned NOT NULL default '1',
  `poster_ip` varchar(15) default NULL,
  `poster_email` varchar(50) default NULL,
  `message` text NOT NULL,
  `hide_smilies` tinyint(1) NOT NULL default '0',
  `posted` int(10) unsigned NOT NULL default '0',
  `edited` int(10) unsigned default NULL,
  `edited_by` varchar(200) default NULL,
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumposts_multi_idx` (`poster_id`,`topic_id`),
  KEY `forumposts_topic_id_idx` (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=1887 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumranks`
-- 

CREATE TABLE `forumranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rank` varchar(50) NOT NULL default '',
  `min_posts` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumreports`
-- 

CREATE TABLE `forumreports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `post_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `reported_by` int(10) unsigned NOT NULL default '0',
  `created` int(10) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `zapped` int(10) unsigned default NULL,
  `zapped_by` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `forumreports_zapped_idx` (`zapped`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_cache`
-- 

CREATE TABLE `forumsearch_cache` (
  `id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `search_data` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `forumsearch_cache_ident_idx` (`ident`(8))
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_matches`
-- 

CREATE TABLE `forumsearch_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0',
  KEY `forumsearch_matches_word_id_idx` (`word_id`),
  KEY `forumsearch_matches_post_id_idx` (`post_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_words`
-- 

CREATE TABLE `forumsearch_words` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `forumsearch_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10919 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsubscriptions`
-- 

CREATE TABLE `forumsubscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`topic_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumtopics`
-- 

CREATE TABLE `forumtopics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `posted` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned NOT NULL default '0',
  `last_post_id` int(10) unsigned NOT NULL default '0',
  `last_poster` varchar(200) default NULL,
  `num_views` mediumint(8) unsigned NOT NULL default '0',
  `num_replies` mediumint(8) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  `moved_to` int(10) unsigned default NULL,
  `forum_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumtopics_moved_to_idx` (`moved_to`)
) TYPE=MyISAM AUTO_INCREMENT=302 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumusers`
-- 

CREATE TABLE `forumusers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `group_id` int(10) NOT NULL default '4',
  `username` varchar(200) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(50) default NULL,
  `realname` varchar(40) default NULL,
  `url` varchar(100) default NULL,
  `jabber` varchar(75) default NULL,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(30) default NULL,
  `yahoo` varchar(30) default NULL,
  `location` varchar(30) default NULL,
  `use_avatar` tinyint(1) NOT NULL default '0',
  `signature` text,
  `disp_topics` tinyint(3) unsigned default NULL,
  `disp_posts` tinyint(3) unsigned default NULL,
  `email_setting` tinyint(1) NOT NULL default '1',
  `save_pass` tinyint(1) NOT NULL default '1',
  `notify_with_post` tinyint(1) NOT NULL default '0',
  `show_smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_img_sig` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `timezone` float NOT NULL default '0',
  `language` varchar(25) NOT NULL default 'English',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `registration_ip` varchar(15) NOT NULL default '0.0.0.0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `admin_note` varchar(30) default NULL,
  `activate_string` varchar(50) default NULL,
  `activate_key` varchar(8) default NULL,
  PRIMARY KEY  (`id`),
  KEY `forumusers_registered_idx` (`registered`),
  KEY `forumusers_username_idx` (`username`(8))
) TYPE=MyISAM AUTO_INCREMENT=291 ;

All is ok?

Thanks,

Ludo,

2005-03-01 19:45

after a fresh install, which did not give me any error, on a another hoster, I got this:

Structure de la table `forumbans`
-- 

CREATE TABLE `forumbans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcategories`
-- 

CREATE TABLE `forumcategories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcensoring`
-- 

CREATE TABLE `forumcensoring` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `search_for` varchar(60) NOT NULL default '',
  `replace_with` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumconfig`
-- 

CREATE TABLE `forumconfig` (
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text,
  PRIMARY KEY  (`conf_name`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforum_perms`
-- 

CREATE TABLE `forumforum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`,`forum_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforums`
-- 

CREATE TABLE `forumforums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `redirect_url` varchar(100) default NULL,
  `moderators` text,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `last_post_id` int(10) unsigned default NULL,
  `last_poster` varchar(200) default NULL,
  `sort_by` tinyint(1) NOT NULL default '0',
  `disp_position` int(10) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumgroups`
-- 

CREATE TABLE `forumgroups` (
  `g_id` int(10) unsigned NOT NULL auto_increment,
  `g_title` varchar(50) NOT NULL default '',
  `g_user_title` varchar(50) default NULL,
  `g_read_board` tinyint(1) NOT NULL default '1',
  `g_post_replies` tinyint(1) NOT NULL default '1',
  `g_post_topics` tinyint(1) NOT NULL default '1',
  `g_post_polls` tinyint(1) NOT NULL default '1',
  `g_edit_posts` tinyint(1) NOT NULL default '1',
  `g_delete_posts` tinyint(1) NOT NULL default '1',
  `g_delete_topics` tinyint(1) NOT NULL default '1',
  `g_set_title` tinyint(1) NOT NULL default '1',
  `g_search` tinyint(1) NOT NULL default '1',
  `g_search_users` tinyint(1) NOT NULL default '1',
  `g_edit_subjects_interval` smallint(6) NOT NULL default '300',
  `g_post_flood` smallint(6) NOT NULL default '30',
  `g_search_flood` smallint(6) NOT NULL default '30',
  PRIMARY KEY  (`g_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumonline`
-- 

CREATE TABLE `forumonline` (
  `user_id` int(10) unsigned NOT NULL default '1',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0',
  `idle` tinyint(1) NOT NULL default '0',
  KEY `forumonline_user_id_idx` (`user_id`)
) TYPE=HEAP;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumposts`
-- 

CREATE TABLE `forumposts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `poster_id` int(10) unsigned NOT NULL default '1',
  `poster_ip` varchar(15) default NULL,
  `poster_email` varchar(50) default NULL,
  `message` text NOT NULL,
  `hide_smilies` tinyint(1) NOT NULL default '0',
  `posted` int(10) unsigned NOT NULL default '0',
  `edited` int(10) unsigned default NULL,
  `edited_by` varchar(200) default NULL,
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumposts_topic_id_idx` (`topic_id`),
  KEY `forumposts_multi_idx` (`poster_id`,`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumranks`
-- 

CREATE TABLE `forumranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rank` varchar(50) NOT NULL default '',
  `min_posts` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumreports`
-- 

CREATE TABLE `forumreports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `post_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `reported_by` int(10) unsigned NOT NULL default '0',
  `created` int(10) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `zapped` int(10) unsigned default NULL,
  `zapped_by` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `forumreports_zapped_idx` (`zapped`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_cache`
-- 

CREATE TABLE `forumsearch_cache` (
  `id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `search_data` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `forumsearch_cache_ident_idx` (`ident`(8))
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_matches`
-- 

CREATE TABLE `forumsearch_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0',
  KEY `forumsearch_matches_word_id_idx` (`word_id`),
  KEY `forumsearch_matches_post_id_idx` (`post_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_words`
-- 

CREATE TABLE `forumsearch_words` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `forumsearch_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsubscriptions`
-- 

CREATE TABLE `forumsubscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`topic_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumtopics`
-- 

CREATE TABLE `forumtopics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `posted` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned NOT NULL default '0',
  `last_post_id` int(10) unsigned NOT NULL default '0',
  `last_poster` varchar(200) default NULL,
  `num_views` mediumint(8) unsigned NOT NULL default '0',
  `num_replies` mediumint(8) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  `moved_to` int(10) unsigned default NULL,
  `forum_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumtopics_forum_id_idx` (`forum_id`),
  KEY `forumtopics_moved_to_idx` (`moved_to`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumusers`
-- 

CREATE TABLE `forumusers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `group_id` int(10) unsigned NOT NULL default '4',
  `username` varchar(200) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(50) default NULL,
  `realname` varchar(40) default NULL,
  `url` varchar(100) default NULL,
  `jabber` varchar(75) default NULL,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(30) default NULL,
  `yahoo` varchar(30) default NULL,
  `location` varchar(30) default NULL,
  `use_avatar` tinyint(1) NOT NULL default '0',
  `signature` text,
  `disp_topics` tinyint(3) unsigned default NULL,
  `disp_posts` tinyint(3) unsigned default NULL,
  `email_setting` tinyint(1) NOT NULL default '1',
  `save_pass` tinyint(1) NOT NULL default '1',
  `notify_with_post` tinyint(1) NOT NULL default '0',
  `show_smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_img_sig` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `timezone` float NOT NULL default '0',
  `language` varchar(25) NOT NULL default 'English',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `registration_ip` varchar(15) NOT NULL default '0.0.0.0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `admin_note` varchar(30) default NULL,
  `activate_string` varchar(50) default NULL,
  `activate_key` varchar(8) default NULL,
  PRIMARY KEY  (`id`),
  KEY `forumusers_registered_idx` (`registered`),
  KEY `forumusers_username_idx` (`username`(8))
) TYPE=MyISAM AUTO_INCREMENT=3 ;

2005-03-01 18:34

Hi,

I'm really sorry to ask this question. I saw a few days/weeks ago Rickard explaining how he customisez the google ads. But I don't refind it.
Can you tell me where the post is.
Event with a search I do not got what I'm lookin for.

Ludo,

2005-03-01 17:37

aren't there any simple sql queries I could do which could create missing indexes?

This is my db structure

-- 
-- Structure de la table `forumbans`
-- 

CREATE TABLE `forumbans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcategories`
-- 

CREATE TABLE `forumcategories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcensoring`
-- 

CREATE TABLE `forumcensoring` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `search_for` varchar(60) NOT NULL default '',
  `replace_with` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumconfig`
-- 

CREATE TABLE `forumconfig` (
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text,
  PRIMARY KEY  (`conf_name`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforum_perms`
-- 

CREATE TABLE `forumforum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`,`forum_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforums`
-- 

CREATE TABLE `forumforums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `redirect_url` varchar(100) default NULL,
  `moderators` text,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `last_post_id` int(10) unsigned default NULL,
  `last_poster` varchar(200) default NULL,
  `sort_by` tinyint(1) NOT NULL default '0',
  `disp_position` int(10) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumgroups`
-- 

CREATE TABLE `forumgroups` (
  `g_id` int(10) unsigned NOT NULL auto_increment,
  `g_title` varchar(50) NOT NULL default '',
  `g_user_title` varchar(50) default NULL,
  `g_read_board` tinyint(1) NOT NULL default '1',
  `g_post_replies` tinyint(1) NOT NULL default '1',
  `g_post_topics` tinyint(1) NOT NULL default '1',
  `g_post_polls` tinyint(1) NOT NULL default '1',
  `g_edit_posts` tinyint(1) NOT NULL default '1',
  `g_delete_posts` tinyint(1) NOT NULL default '1',
  `g_delete_topics` tinyint(1) NOT NULL default '1',
  `g_set_title` tinyint(1) NOT NULL default '1',
  `g_search` tinyint(1) NOT NULL default '1',
  `g_search_users` tinyint(1) NOT NULL default '1',
  `g_edit_subjects_interval` smallint(6) NOT NULL default '300',
  `g_post_flood` smallint(6) NOT NULL default '30',
  `g_search_flood` smallint(6) NOT NULL default '30',
  PRIMARY KEY  (`g_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumonline`
-- 

CREATE TABLE `forumonline` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0',
  `idle` tinyint(1) NOT NULL default '0',
  KEY `forumonline_user_id_idx` (`user_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumposts`
-- 

CREATE TABLE `forumposts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `poster_id` int(10) unsigned NOT NULL default '1',
  `poster_ip` varchar(15) default NULL,
  `poster_email` varchar(50) default NULL,
  `message` text NOT NULL,
  `hide_smilies` tinyint(1) NOT NULL default '0',
  `posted` int(10) unsigned NOT NULL default '0',
  `edited` int(10) unsigned default NULL,
  `edited_by` varchar(200) default NULL,
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumposts_multi_idx` (`poster_id`,`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=1886 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumranks`
-- 

CREATE TABLE `forumranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rank` varchar(50) NOT NULL default '',
  `min_posts` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumreports`
-- 

CREATE TABLE `forumreports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `post_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `reported_by` int(10) unsigned NOT NULL default '0',
  `created` int(10) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `zapped` int(10) unsigned default NULL,
  `zapped_by` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_cache`
-- 

CREATE TABLE `forumsearch_cache` (
  `id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `search_data` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `forumsearch_cache_ident_idx` (`ident`(8))
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_matches`
-- 

CREATE TABLE `forumsearch_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_words`
-- 

CREATE TABLE `forumsearch_words` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `forumsearch_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10919 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsubscriptions`
-- 

CREATE TABLE `forumsubscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`topic_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumtopics`
-- 

CREATE TABLE `forumtopics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `posted` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned NOT NULL default '0',
  `last_post_id` int(10) unsigned NOT NULL default '0',
  `last_poster` varchar(200) default NULL,
  `num_views` mediumint(8) unsigned NOT NULL default '0',
  `num_replies` mediumint(8) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  `moved_to` int(10) unsigned default NULL,
  `forum_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `forumtopics_moved_to_idx` (`moved_to`)
) TYPE=MyISAM AUTO_INCREMENT=302 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumusers`
-- 

CREATE TABLE `forumusers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `group_id` int(10) NOT NULL default '4',
  `username` varchar(200) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(50) default NULL,
  `realname` varchar(40) default NULL,
  `url` varchar(100) default NULL,
  `jabber` varchar(75) default NULL,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(30) default NULL,
  `yahoo` varchar(30) default NULL,
  `location` varchar(30) default NULL,
  `use_avatar` tinyint(1) NOT NULL default '0',
  `signature` text,
  `disp_topics` tinyint(3) unsigned default NULL,
  `disp_posts` tinyint(3) unsigned default NULL,
  `email_setting` tinyint(1) NOT NULL default '1',
  `save_pass` tinyint(1) NOT NULL default '1',
  `notify_with_post` tinyint(1) NOT NULL default '0',
  `show_smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_img_sig` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `timezone` float NOT NULL default '0',
  `language` varchar(25) NOT NULL default 'English',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `registration_ip` varchar(15) NOT NULL default '0.0.0.0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `admin_note` varchar(30) default NULL,
  `activate_string` varchar(50) default NULL,
  `activate_key` varchar(8) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=291 ;

Ludo,

2005-03-01 16:50

I'm looking forward this mod to be released...

Ludo,

2005-02-28 19:05

Hi Rickard,

A few weeks ago, I had a problem with the migration from 1.1.5 to 1.2.
As you know, there were missing indexes which caused error mesages.
However, the forum works without these indexes.
You told me that you could tell me the method to create the missing indexes. Can you now tell me this method?

Ludo,

2005-02-26 18:09

Are theses modifications so important that you would advice me to customize my stylesheet from 0?

thanks,

Ludo,

2005-02-26 16:13

the problem does not occured with new stylesheets. It only occures with my customised stylesheet which worked good with 1.2. That's why I want to know what has been modified between 1.2 and 1.2.2 and which could cause this kind of problem.

Ludo,

2005-02-26 14:51

Hi,

After having upgraded form 1.2 to 1.2.2 I've got a small problem with the height of some text.
See here for example: http://www.oyre.net/forum/viewforum.php?id=2
"Accueil » Aide à l'utilisation du forum" is at one time smaller that the over one.
I had not this problem with 1.2.
Has something been modified in css which could cause this problem?

Thanks,

Ludo

2005-02-26 14:48

fixed.

2005-02-26 14:00

Hi,

I'm trying to update from 1.2 to 1.2.2
My forum is installed in oyre.net/forum
I've made all is said in install.html
I try to execute oyre.net/forum/12_to_122_update.php
It gives me an error: "This file must be run from the forum root directory."

what's the problem?

Thanks,

Ludo,

2005-02-16 12:54

est ce que le problème se produit également quand vous avez choisi la langue anglaise par défaut?
Quoi qu'il en soit, essayez de telecharger la dernière version du pack français car je me souviens que j'obtenais ce genre d'erreur au début.

cordialement,

2005-02-03 10:23

Rickard wrote:

I will look into creating a script that tries to remedy the situation.

Thanks

2005-02-02 23:06

What you gave me is very interesting. It works very good with http://www.freenews.fr/feeds/rss.php which uses rss 1.
I also want to use a feed in RSS 2 for example that one : http://www.liberation.fr/rss.php . Have you got a similar example with RSS 2?

Thanks a lot,

Ludo,

2005-02-02 23:04

You're right. This one works good.

Thanks a lot Paul.

Ludo,

2005-02-02 23:02

it's strange that several persons have exactly the same problem. I think Rod has the same problem with indexes missing. I got exactly the same problem. My 1.2 works without indexes so it's slower.
A method to create missing indexes would be appreciated.

Ludo,

2005-02-02 16:15

does the migration tool create indexes missing from the former migration tool?

Ludo,

2005-02-01 21:21

Well, I've certainly spoken too fatsly. The problem is solved but not in the whole
See here for example http://www.pluriservices.net/forum/profile.php?id=208
It means I have to modify something else?

Ludo,

2005-02-01 17:47

la question vient d'etre posée en anglais http://punbb.org/forums/viewtopic.php?id=6159
La réponse ne devrait donc pas tarder...

Ludo,

2005-02-01 17:41

The best notice I can tell you is to make a dump of you DB

Ludo,

Search options (Page 13 of 21)

Posts found: 301 to 325 of 525

301 Reply by Ludo 2005-03-02 13:55

Re: google customisation (9 replies, posted in PunBB 1.2 troubleshooting)

302 Reply by Ludo 2005-03-02 13:08

Re: google customisation (9 replies, posted in PunBB 1.2 troubleshooting)

303 Reply by Ludo 2005-03-02 10:17

Re: PunCMS (146 replies, posted in PunBB 1.2 modifications, plugins and integrations)

304 Reply by Ludo 2005-03-02 09:57

Re: PunCMS (146 replies, posted in PunBB 1.2 modifications, plugins and integrations)

305 Reply by Ludo 2005-03-02 09:36

Re: nouveau PunBB 1.2.2 (15 replies, posted in Archive)

306 Reply by Ludo 2005-03-01 20:10

Re: missing indexes (6 replies, posted in PunBB 1.2 troubleshooting)

307 Reply by Ludo 2005-03-01 19:45

Re: missing indexes (6 replies, posted in PunBB 1.2 troubleshooting)

308 Topic by Ludo 2005-03-01 18:34

Topic: google customisation (9 replies, posted in PunBB 1.2 troubleshooting)

309 Reply by Ludo 2005-03-01 17:37

Re: missing indexes (6 replies, posted in PunBB 1.2 troubleshooting)

310 Reply by Ludo 2005-03-01 16:50

Re: PunCMS (146 replies, posted in PunBB 1.2 modifications, plugins and integrations)

311 Topic by Ludo 2005-02-28 19:05

Topic: missing indexes (6 replies, posted in PunBB 1.2 troubleshooting)

312 Reply by Ludo 2005-02-26 18:09

Re: css problem (4 replies, posted in PunBB 1.2 troubleshooting)

313 Reply by Ludo 2005-02-26 16:13

Re: css problem (4 replies, posted in PunBB 1.2 troubleshooting)

314 Topic by Ludo 2005-02-26 14:51

Topic: css problem (4 replies, posted in PunBB 1.2 troubleshooting)

315 Reply by Ludo 2005-02-26 14:48

Re: 1.2 to 1.2.2 problem (2 replies, posted in PunBB 1.2 troubleshooting)

316 Topic by Ludo 2005-02-26 14:00

Topic: 1.2 to 1.2.2 problem (2 replies, posted in PunBB 1.2 troubleshooting)

317 Reply by Ludo 2005-02-16 12:54

Re: Error in profile.php (10 replies, posted in Archive)

318 Reply by Ludo 2005-02-03 10:23

Re: 1.1.5 -> 1.2 update problems... (39 replies, posted in PunBB 1.2 troubleshooting)

319 Reply by Ludo 2005-02-02 23:06

Re: using rss to import news on my site (4 replies, posted in Programming)

320 Reply by Ludo 2005-02-02 23:04

Re: .pun BLOCKQUOTE (6 replies, posted in PunBB 1.2 troubleshooting)

321 Reply by Ludo 2005-02-02 23:02

Re: 1.1.5 -> 1.2 update problems... (39 replies, posted in PunBB 1.2 troubleshooting)

322 Reply by Ludo 2005-02-02 16:15

Re: PunBB 1.2.1 (76 replies, posted in News)

323 Reply by Ludo 2005-02-01 21:21

Re: .pun BLOCKQUOTE (6 replies, posted in PunBB 1.2 troubleshooting)

324 Reply by Ludo 2005-02-01 17:47

Re: Désactiver la Liste des Utilisateurs (3 replies, posted in Archive)

325 Reply by Ludo 2005-02-01 17:41

Re: migrating from 1.1.5 to 1.2 (2 replies, posted in PunBB 1.2 troubleshooting)

Posts found: 301 to 325 of 525