Search options

alright

you're right
now everything works fine
thanks a lot and sorry for this waste of time

that's it

# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generato il: 31 Gen, 2004 at 06:39 PM
# Versione MySQL: 4.00.17
# Versione PHP: 4.3.4
# Database : `my_zyklonb`
# --------------------------------------------------------

#
# Struttura della tabella `punbb_bans`
#

CREATE TABLE punbb_bans (
  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;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_categories`
#

CREATE TABLE punbb_categories (
  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;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_censoring`
#

CREATE TABLE punbb_censoring (
  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;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_config`
#

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

#
# Struttura della tabella `punbb_forums`
#

CREATE TABLE punbb_forums (
  id int(10) unsigned NOT NULL auto_increment,
  forum_name varchar(80) NOT NULL default 'New forum',
  forum_desc text,
  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,
  closed tinyint(1) NOT NULL default '0',
  admmod_only 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;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_online`
#

CREATE TABLE punbb_online (
  user_id int(10) unsigned NOT NULL default '0',
  ident varchar(200) NOT NULL default '',
  logged int(10) unsigned NOT NULL default '0'
) TYPE=HEAP;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_posts`
#

CREATE TABLE punbb_posts (
  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,
  smilies tinyint(1) NOT NULL default '1',
  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 punbb_posts_topic_id_idx (topic_id),
  KEY punbb_posts_poster_id_idx (poster_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_ranks`
#

CREATE TABLE punbb_ranks (
  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;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_reports`
#

CREATE TABLE punbb_reports (
  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 punbb_reports_zapped_idx (zapped)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_search_matches`
#

CREATE TABLE punbb_search_matches (
  post_id int(10) unsigned NOT NULL default '0',
  word_id int(10) unsigned NOT NULL default '0',
  subject_match tinyint(1) NOT NULL default '0',
  KEY punbb_search_matches_word_id_idx (word_id),
  KEY punbb_search_matches_post_id_idx (post_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_search_results`
#

CREATE TABLE punbb_search_results (
  id int(10) unsigned NOT NULL default '0',
  ident varchar(200) NOT NULL default '',
  search_data text NOT NULL,
  PRIMARY KEY  (id),
  KEY punbb_search_results_ident_idx (ident)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_search_words`
#

CREATE TABLE punbb_search_words (
  id int(10) unsigned NOT NULL auto_increment,
  word varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (word),
  KEY punbb_search_words_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_subscriptions`
#

CREATE TABLE punbb_subscriptions (
  user_id int(10) unsigned NOT NULL default '0',
  topic_id int(10) unsigned NOT NULL default '0',
  KEY punbb_subscriptions_user_id_idx (user_id),
  KEY punbb_subscriptions_topic_id_idx (topic_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_topics`
#

CREATE TABLE punbb_topics (
  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 punbb_topics_forum_id_idx (forum_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Struttura della tabella `punbb_users`
#

CREATE TABLE punbb_users (
  id int(10) unsigned NOT NULL auto_increment,
  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,
  icq varchar(12) default NULL,
  msn varchar(50) default NULL,
  aim varchar(20) default NULL,
  yahoo varchar(20) 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',
  smilies tinyint(1) NOT NULL default '1',
  show_img tinyint(1) NOT NULL default '1',
  show_avatars tinyint(1) NOT NULL default '1',
  show_sig tinyint(1) NOT NULL default '1',
  link_to_new_win tinyint(1) NOT NULL default '1',
  timezone tinyint(2) NOT NULL default '0',
  style varchar(25) NOT NULL default 'Oxygen',
  num_posts int(10) unsigned NOT NULL default '0',
  status tinyint(1) NOT NULL default '-1',
  last_post int(10) unsigned default NULL,
  registered int(10) unsigned NOT NULL default '0',
  last_visit int(10) unsigned NOT NULL default '0',
  last_action 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 punbb_users_registered_idx (registered),
  KEY punbb_users_username_idx (username(3))
) TYPE=MyISAM;

here's the whole db

Admin edit: Removed alot of text /chacmool