Быстрый лёгкий надёжный форумный движок
Вы не вошли.
Страницы 1
Тема закрыта
Кто-нибудь может помочь создать конвектор?
Вот структура нужных кусков:
CREATE TABLE sed_forum_posts (
fp_id mediumint(8) unsigned NOT NULL auto_increment,
fp_topicid mediumint(8) NOT NULL default '0',
fp_sectionid smallint(5) NOT NULL default '0',
fp_posterid int(11) NOT NULL default '-1',
fp_postername varchar(24) NOT NULL default '',
fp_creation int(11) NOT NULL default '0',
fp_updated int(11) NOT NULL default '0',
fp_updater varchar(24) NOT NULL default '0',
fp_text text NOT NULL,
fp_posterip varchar(15) NOT NULL default '',
PRIMARY KEY (fp_id),
UNIQUE KEY fp_topicid (fp_topicid,fp_id),
KEY fp_updated (fp_creation)
) TYPE=MyISAM;
CREATE TABLE sed_forum_sections (
fs_id smallint(5) unsigned NOT NULL auto_increment,
fs_state tinyint(1) unsigned NOT NULL default '0',
fs_order smallint(5) unsigned NOT NULL default '0',
fs_title varchar(128) NOT NULL default '',
fs_category varchar(64) NOT NULL default '',
fs_desc varchar(255) NOT NULL default '',
fs_icon varchar(255) NOT NULL default '',
fs_lt_id int(11) NOT NULL default '0',
fs_lt_title varchar(64) NOT NULL default '',
fs_lt_date int(11) NOT NULL default '0',
fs_lt_posterid int(11) NOT NULL default '-1',
fs_lt_postername varchar(24) NOT NULL default '',
fs_autoprune int(11) NOT NULL default '0',
fs_allowusertext tinyint(1) NOT NULL default '1',
fs_allowbbcodes tinyint(1) NOT NULL default '1',
fs_allowsmilies tinyint(1) NOT NULL default '1',
fs_allowprvtopics tinyint(1) NOT NULL default '0',
fs_countposts tinyint(1) NOT NULL default '1',
fs_topiccount mediumint(8) NOT NULL default '0',
fs_topiccount_pruned int(11) default '0',
fs_postcount mediumint(8) NOT NULL default '0',
fs_postcount_pruned int(11) default '0',
fs_viewcount mediumint(8) NOT NULL default '0',
PRIMARY KEY (fs_id),
KEY fs_order (fs_order)
) TYPE=MyISAM;
CREATE TABLE sed_forum_topics (
ft_id mediumint(8) unsigned NOT NULL auto_increment,
ft_mode tinyint(1) unsigned NOT NULL default '0',
ft_state tinyint(1) unsigned NOT NULL default '0',
ft_sticky tinyint(1) unsigned NOT NULL default '0',
ft_sectionid mediumint(8) NOT NULL default '0',
ft_title varchar(64) NOT NULL default '',
ft_creationdate int(11) NOT NULL default '0',
ft_updated int(11) NOT NULL default '0',
ft_postcount mediumint(8) NOT NULL default '0',
ft_viewcount mediumint(8) NOT NULL default '0',
ft_lastposterid int(11) NOT NULL default '-1',
ft_lastpostername varchar(24) NOT NULL default '',
ft_firstposterid int(11) NOT NULL default '-1',
ft_firstpostername varchar(24) NOT NULL default '',
ft_poll int(11) default '0',
ft_movedto int(11) default '0',
PRIMARY KEY (ft_id),
KEY ft_updated (ft_updated),
KEY ft_mode (ft_mode),
KEY ft_state (ft_state),
KEY ft_sticky (ft_sticky),
KEY ft_sectionid (ft_sectionid)
) TYPE=MyISAM;
CREATE TABLE sed_users (
user_id int(11) unsigned NOT NULL auto_increment,
user_banexpire int(11) default '0',
user_name varchar(24) NOT NULL default '',
user_password varchar(32) NOT NULL default '',
user_maingrp int(11) unsigned NOT NULL default '4',
user_country char(2) NOT NULL default '',
user_text text NOT NULL,
user_avatar varchar(255) NOT NULL default '',
user_photo varchar(255) NOT NULL default '',
user_signature varchar(255) NOT NULL default '',
user_extra1 varchar(255) NOT NULL default '',
user_extra2 varchar(255) NOT NULL default '',
user_extra3 varchar(255) NOT NULL default '',
user_extra4 varchar(255) NOT NULL default '',
user_extra5 varchar(255) NOT NULL default '',
user_extra6 text,
user_extra7 text,
user_extra8 text,
user_extra9 text,
user_occupation varchar(64) NOT NULL default '',
user_location varchar(64) NOT NULL default '',
user_timezone decimal(2,0) NOT NULL default '0',
user_birthdate int(11) NOT NULL default '0',
user_gender char(1) NOT NULL default 'U',
user_irc varchar(128) NOT NULL default '',
user_msn varchar(64) NOT NULL default '',
user_icq varchar(16) NOT NULL default '',
user_website varchar(128) NOT NULL default '',
user_email varchar(64) NOT NULL default '',
user_hideemail tinyint(1) unsigned NOT NULL default '1',
user_pmnotify tinyint(1) unsigned NOT NULL default '0',
user_skin varchar(16) NOT NULL default '',
user_lang varchar(16) NOT NULL default '',
user_regdate int(11) NOT NULL default '0',
user_lastlog int(11) NOT NULL default '0',
user_lastvisit int(11) NOT NULL default '0',
user_lastip varchar(16) NOT NULL default '',
user_logcount int(11) unsigned NOT NULL default '0',
user_postcount int(11) default '0',
user_gallerycount mediumint(8) NOT NULL default '0',
user_jrnpagescount mediumint(8) NOT NULL default '0',
user_jrnupdated int(11) NOT NULL default '0',
user_sid char(32) NOT NULL default '',
user_lostpass char(32) NOT NULL default '',
user_auth text,
PRIMARY KEY (user_id)
) TYPE=MyISAM;
Если Вы сможете мне помочь с радостью объясню непонятные поля, если возникнут затруднения:
Страницы 1
Тема закрыта