Fantastic (free) gallery script ...

[Robert9]

could be found here: http://www.4homepages.de
I have merged all the needed tables to use the ones from vb for this script. ow my problems are only the session + cookie-management. Maybe someone else is interested in fixing this together with me.

Robert

[Dark_Wizard]

I'd be happy to take a look....let me know via PM...

[Robert9]

Im still work on it; the problem is e.g. that vb uses the same names for a row in diff. tables.
So i have to search tru the whole galeryscript where something the selects have to done manually.

Search and replace does a lot but its still a lot of work.

Hope to finish it the next days and will send an url to show.

Robert

[Mr_P]

just like to say cheers m8 you had a good find here

this installed first go and is real easy to use - but only prob i find with it is getting the mass thumbnails to work ???????

oh yeah download the lanuage pak and just copy it over to get English Lanuage

[Robert9]

Sorry, haven´t played around with all the features yet.
Yesterday the final 1.5 comes out and i have to do the whole work again to integrate it with vb.
As far as tested i got all things to run without the connect to the imagesizer program, think the installation under linux was wrong, but i will fix it next week.

Robert

[X-Fan]

Just wondering how the integration of 4images with vBulletin is coming along?

It's a great image gallery, perfect for my site, but I really need it to be integrated with vB so that they both run off the same user database!

[Birdie501]

Hi,
i hope you will release this thing quickly! :-)
looks pretty good!

[german]
Das Teil gefällt mir sehr, wenn es dann auch noch mit vb läuft echt klasse! Freu mich schon und bedanke mich schonmal für die Arbeit die du damit hast!
Wäre toll wenn Du es auch in deutsch veröffentlichst???

[Cyburbia]

I just installed 4Images too, and I'm learning to play around with it. I don't have the MySQL skills that you all have, but count me as eager for a hack.

[Konqueror]

Hi there!
I've been working on integrating this thing myself as well, I'll have the template integration finished today. :) I'll also start the session/cookie integration today. :)

I've also contacted the creater of 4images for permission to distribute the altered version and he has agreed to distribute it from his site. :)

[Dark_Wizard]

Originally posted by Konqueror
Hi there!
I've been working on integrating this thing myself as well, I'll have the template integration finished today. :) I'll also start the session/cookie integration today. :)

I've also contacted the creater of 4images for permission to distribute the altered version and he has agreed to distribute it from his site. :)

Very nice!

[Birdie501]

Hi,

what do you think, when will it be released? :-)

Can't wait.

[Konqueror]

As developers often say: "When it's done". ;)
To be honest though, the weather was just to fine to work today, hehe. My guess would be done in 2 days, but don't quote me on that. ;)

[Birdie501]

Thanks!

I know that ths is a bad question but anyway I wanted to know if it takes days or month :-))
Hope it will rain again :-))

[Birdie501]

Hi,

just wanted to know when it will be released! I would be really happy to have it! Thanks!

[Robert9]

Hi all, have done it. The problem now is that the autor of the script dont allow to offer the code here or elsewhere so im not allowed to publish it.

What now?

I can help you fix the things, if you want.
You should have "Beyond compare" or with more headaches an text editor.

Then create all the needed tables for the script and see which tables from gallery could erased while use the one of vb;
next step is to compare all the fields especially from users and user and the sessions stuff; remark which fields must be changed inside the script, which ones must be added to the usertable.

I show here my tables to give a hint, how i do that.
(Remark that some tables here are without use !!!


CREATE TABLE CatLinks (
LinkID int(10) unsigned NOT NULL default '0',
CategoryID int(10) unsigned NOT NULL default '0',
KEY catlnndx(CategoryID),
KEY lndx(LinkID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `CatRelations`
#

CREATE TABLE CatRelations (
CategoryID int(10) unsigned NOT NULL default '0',
RelatedID int(10) unsigned NOT NULL default '0',
RelationName varchar(255) default NULL,
KEY catid(CategoryID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Category`
#

CREATE TABLE Category (
ID int(10) unsigned NOT NULL auto_increment,
Name varchar(255) NOT NULL default '',
FatherID int(10) unsigned NOT NULL default '0',
Full_Name varchar(255) NOT NULL default '',
Description text,
Meta_Description text,
Meta_Keywords text,
Header text,
Footer text,
Category_Template varchar(20) default NULL,
Number_of_Links int(11) NOT NULL default '0',
Has_New_Links enum('No','Yes') NOT NULL default 'No',
Has_Changed_Links enum('No','Yes') NOT NULL default 'No',
Newest_Link date default '0000-00-00',
Timestmp timestamp(14) NOT NULL,
Forum text,
CatPic varchar(50) default NULL,
Links_Template varchar(30) default NULL,
Sorter varchar(4) default NULL,
Sorting enum('isNew ESC,isPopular DESC,Title','ID DESC','Add_Date DESC,Title','Mod_Date DESC,Title','Sorter,Title') default NULL,
LinksPerPage int(11) default NULL,
SpaltenSubCats int(11) default '2',
LinksPP int(11) default NULL,
DirName varchar(40) default NULL,
Reihenfolge int(11) default NULL,
PRIMARY KEY (ID),
KEY fthrindex(FatherID),
KEY namndx(Full_Name),
KEY catndx(Name)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Category_Files`
#

CREATE TABLE Category_Files (
ID int(10) unsigned NOT NULL auto_increment,
ForeignColName char(50) default NULL,
ForeignColKey char(50) default NULL,
File_Name char(255) default NULL,
File_Directory char(255) default NULL,
File_MimeType char(50) default NULL,
File_Size int(10) unsigned NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Changes`
#

CREATE TABLE Changes (
LinkID int(10) unsigned NOT NULL default '0',
Username varchar(50) NOT NULL default 'admin',
ChgRequest text,
Timestmp timestamp(14) NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `ClickTrack`
#

CREATE TABLE ClickTrack (
LinkID int(11) NOT NULL default '0',
IP char(25) NOT NULL default '',
ClickType enum('Rate','Hits','Review') NOT NULL default 'Rate',
ReviewID int(11) NOT NULL default '0',
Created timestamp(14) NOT NULL,
PRIMARY KEY (LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType, ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,Cl ickType,ReviewID),
KEY cndx(Created)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Editors`
#

CREATE TABLE Editors (
Username char(50) NOT NULL default '',
CategoryID int(10) unsigned NOT NULL default '0',
CanAddCat enum('No','Yes') NOT NULL default 'No',
CanModCat enum('No','Yes') NOT NULL default 'No',
CanDelCat enum('No','Yes') NOT NULL default 'No',
CanMoveCat enum('No','Yes') NOT NULL default 'No',
CanAddLink enum('No','Yes') NOT NULL default 'No',
CanDelLink enum('No','Yes') NOT NULL default 'No',
CanModLink enum('No','Yes') NOT NULL default 'No',
CanCopyLink enum('No','Yes') NOT NULL default 'No',
CanMoveLink enum('No','Yes') NOT NULL default 'No',
CanValLink enum('No','Yes') NOT NULL default 'No',
CanAddRel enum('No','Yes') NOT NULL default 'No',
CanAddEdit enum('No','Yes') NOT NULL default 'No',
PRIMARY KEY (Username,CategoryID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `EmailMailings`
#

CREATE TABLE EmailMailings (
ID int(10) unsigned NOT NULL auto_increment,
Mailing int(10) unsigned NOT NULL default '0',
Email text NOT NULL,
Sent tinyint(4) NOT NULL default '0',
LinkID int(10) unsigned default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `EmailTemplates`
#

CREATE TABLE EmailTemplates (
Name varchar(50) NOT NULL default '',
MsgFrom text NOT NULL,
MsgFromName text NOT NULL,
Subject text NOT NULL,
Message mediumtext NOT NULL,
MessageFormat enum('text','html') NOT NULL default 'text',
LinkTemplate mediumtext,
PRIMARY KEY (Name)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Links`
#

CREATE TABLE Links (
ID int(10) unsigned NOT NULL auto_increment,
Title varchar(100) NOT NULL default '',
URL varchar(255) NOT NULL default 'http://',
LinkOwner varchar(50) NOT NULL default 'admin',
Add_Date date NOT NULL default '0000-00-00',
Mod_Date date NOT NULL default '0000-00-00',
Description text,
Contact_Name varchar(255) default NULL,
Contact_Email varchar(255) default NULL,
Hits int(11) NOT NULL default '0',
isNew enum('No','Yes') NOT NULL default 'No',
isChanged enum('No','Yes') NOT NULL default 'No',
isPopular enum('No','Yes') NOT NULL default 'No',
isValidated enum('No','Yes') NOT NULL default 'Yes',
Rating float(12,2) NOT NULL default '0.00',
Votes smallint(5) unsigned NOT NULL default '0',
Status smallint(6) NOT NULL default '0',
Date_Checked datetime default '0000-00-00 00:00:00',
Timestmp timestamp(14) NOT NULL,
Aufmacher varchar(80) default NULL,
Text text,
Link varchar(255) default 'Lesen ...',
HTML text,
Comment text,
Priority enum('1','2','3','4','5') default NULL,
Wertung enum('1','2','3','4','5','6','7','8','9','10') default NULL,
Detailed enum('Yes','No') default 'No',
Logo varchar(50) default NULL,
LogoG varchar(50) default NULL,
Bild01 varchar(50) default NULL,
Bild02 varchar(50) default NULL,
Bild03 varchar(50) default NULL,
Bild04 varchar(50) default NULL,
Bild05 varchar(50) default NULL,
Media enum('Video','Sound','PDF') default NULL,
Stern char(1) default NULL,
UserIDvbul varchar(10) default NULL,
Kommentar text,
Passwort varchar(10) default NULL,
Build char(3) default 'No',
Reviews varchar(4) default NULL,
Text1 text,
Tipp varchar(9) default NULL,
Text2 text,
PLZ char(2) default NULL,
Text3 text,
EMail varchar(80) default NULL,
Stadt varchar(60) default NULL,
Age char(3) default NULL,
PRIMARY KEY (ID),
KEY userndx(LinkOwner),
KEY popndx(isPopular),
KEY stndx(Status),
KEY urlndx(URL),
KEY newndx(isNew),
KEY valndx(isValidated)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Links_Files`
#

CREATE TABLE Links_Files (
ID int(10) unsigned NOT NULL auto_increment,
ForeignColName char(50) default NULL,
ForeignColKey char(50) default NULL,
File_Name char(255) default NULL,
File_Directory char(255) default NULL,
File_MimeType char(50) default NULL,
File_Size int(10) unsigned NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `MailingIndex`
#

CREATE TABLE MailingIndex (
Mailing int(10) unsigned NOT NULL auto_increment,
extra tinytext NOT NULL,
done int(11) default NULL,
mailfrom text NOT NULL,
name text NOT NULL,
subject text NOT NULL,
message mediumtext NOT NULL,
messageformat enum('text','html') NOT NULL default 'text',
PRIMARY KEY (Mailing)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `MailingList`
#

CREATE TABLE MailingList (
ID int(11) NOT NULL default '0',
Email char(255) NOT NULL default '',
KEY maillistndx(Email)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `MailingListIndex`
#

CREATE TABLE MailingListIndex (
ID int(10) unsigned NOT NULL auto_increment,
Name text NOT NULL,
DateModified int(11) NOT NULL default '0',
DateCreated int(11) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Reviews`
#

CREATE TABLE Reviews (
ReviewID int(10) unsigned NOT NULL auto_increment,
Review_LinkID int(10) unsigned NOT NULL default '0',
Review_Owner varchar(50) NOT NULL default '',
Review_Rating smallint(5) unsigned NOT NULL default '0',
Review_Date date NOT NULL default '0000-00-00',
Review_Subject varchar(100) NOT NULL default '',
Review_Contents text NOT NULL,
Review_ByLine varchar(50) default NULL,
Review_WasHelpful int(10) unsigned default NULL,
Review_WasNotHelpful int(10) unsigned default NULL,
Review_Validated enum('No','Yes') NOT NULL default 'No',
Review_GuestName varchar(75) default NULL,
Review_GuestEmail varchar(75) default NULL,
PRIMARY KEY (ReviewID),
KEY rlinkndx(Review_LinkID),
KEY rownerndx(Review_Owner),
KEY rdatendx(Review_Date)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Users`
#

CREATE TABLE Users (
Username char(50) NOT NULL default '',
Password char(25) binary NOT NULL default '',
Email char(75) NOT NULL default '',
Name char(75) default NULL,
Validation char(20) default NULL,
Status enum('Not Validated','Registered','Administrator') NOT NULL default 'Registered',
ReceiveMail enum('No','Yes') NOT NULL default 'Yes',
Newsletter enum('No','Yes') NOT NULL default 'Yes',
PRIMARY KEY (Username),
KEY emailndx(Email)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `Verify`
#

CREATE TABLE Verify (
LinkID int(10) unsigned NOT NULL default '0',
Status smallint(6) NOT NULL default '0',
Date_Checked date default NULL,
KEY veriflndx(LinkID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `access`
#

CREATE TABLE access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `adminlog`
#

CREATE TABLE adminlog (
adminlogid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
script varchar(20) NOT NULL default '',
action varchar(20) NOT NULL default '',
extrainfo varchar(200) NOT NULL default '',
ipaddress varchar(15) NOT NULL default '',
PRIMARY KEY (adminlogid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `adminutil`
#

CREATE TABLE adminutil (
title varchar(10) NOT NULL default '',
text mediumtext NOT NULL,
KEY title(title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `announcement`
#

CREATE TABLE announcement (
announcementid smallint(5) unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
startdate int(10) unsigned NOT NULL default '0',
enddate int(10) unsigned NOT NULL default '0',
pagetext mediumtext NOT NULL,
forumid smallint(6) NOT NULL default '0',
PRIMARY KEY (announcementid),
KEY forumid(forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `attachment`
#

CREATE TABLE attachment (
attachmentid smallint(5) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
filedata mediumtext NOT NULL,
visible smallint(5) unsigned NOT NULL default '0',
counter smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (attachmentid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `avatar`
#

CREATE TABLE avatar (
avatarid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
minimumposts smallint(6) NOT NULL default '0',
avatarpath char(100) NOT NULL default '',
PRIMARY KEY (avatarid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `bCatLinks`
#

CREATE TABLE bCatLinks (
LinkID int(10) unsigned NOT NULL default '0',
CategoryID int(10) unsigned NOT NULL default '0',
KEY catlnndx(CategoryID),
KEY lndx(LinkID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `bbcode`
#

CREATE TABLE bbcode (
bbcodeid smallint(5) unsigned NOT NULL auto_increment,
bbcodetag varchar(200) NOT NULL default '',
bbcodereplacement varchar(200) NOT NULL default '',
bbcodeexample varchar(200) NOT NULL default '',
bbcodeexplanation mediumtext NOT NULL,
twoparams smallint(6) NOT NULL default '0',
PRIMARY KEY (bbcodeid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `calendar_events`
#

CREATE TABLE calendar_events (
eventid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
event mediumtext NOT NULL,
eventdate date NOT NULL default '0000-00-00',
public smallint(5) unsigned NOT NULL default '0',
subject varchar(254) NOT NULL default '',
allowsmilies smallint(6) NOT NULL default '1',
PRIMARY KEY (eventid),
KEY userid(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `categories`
#

CREATE TABLE categories (
cat_id mediumint(8) NOT NULL auto_increment,
cat_name varchar(255) NOT NULL default '',
cat_description text NOT NULL,
cat_parent_id mediumint(8) NOT NULL default '0',
cat_hits smallint(6) NOT NULL default '0',
cat_order mediumint(8) unsigned NOT NULL default '0',
auth_viewcat tinyint(2) NOT NULL default '0',
auth_viewimage tinyint(2) NOT NULL default '0',
auth_download tinyint(2) NOT NULL default '0',
auth_upload tinyint(2) NOT NULL default '0',
auth_directupload tinyint(2) NOT NULL default '0',
auth_vote tinyint(2) NOT NULL default '0',
auth_sendpostcard tinyint(2) NOT NULL default '0',
auth_readcomment tinyint(2) NOT NULL default '0',
auth_postcomment tinyint(2) NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_parent_id(cat_parent_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `comments`
#

CREATE TABLE comments (
comment_id mediumint(8) NOT NULL auto_increment,
image_id mediumint(8) NOT NULL default '0',
userid mediumint(8) NOT NULL default '0',
username varchar(100) NOT NULL default '',
comment_headline varchar(255) NOT NULL default '',
comment_text text NOT NULL,
comment_ip varchar(20) NOT NULL default '',
comment_date int(10) unsigned NOT NULL default '0',
PRIMARY KEY (comment_id),
KEY image_id(image_id),
KEY user_id(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `customavatar`
#

CREATE TABLE customavatar (
userid int(10) unsigned NOT NULL default '0',
avatardata mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
PRIMARY KEY (userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `forum`
#

CREATE TABLE forum (
forumid smallint(5) unsigned NOT NULL auto_increment,
styleid smallint(5) unsigned NOT NULL default '0',
title char(100) NOT NULL default '',
description char(250) NOT NULL default '',
active smallint(6) NOT NULL default '0',
displayorder smallint(6) NOT NULL default '0',
replycount int(10) unsigned NOT NULL default '0',
lastpost int(11) NOT NULL default '0',
lastposter char(50) NOT NULL default '',
threadcount mediumint(8) unsigned NOT NULL default '0',
allowposting tinyint(4) NOT NULL default '0',
cancontainthreads smallint(6) NOT NULL default '0',
daysprune smallint(5) unsigned NOT NULL default '0',
newpostemail char(250) NOT NULL default '',
newthreademail char(250) NOT NULL default '',
moderatenew smallint(6) NOT NULL default '0',
moderateattach smallint(6) NOT NULL default '0',
allowbbcode smallint(6) NOT NULL default '0',
allowimages smallint(6) NOT NULL default '0',
allowhtml smallint(6) NOT NULL default '0',
allowsmilies smallint(6) NOT NULL default '0',
allowicons smallint(6) NOT NULL default '0',
parentid smallint(6) NOT NULL default '0',
parentlist char(250) NOT NULL default '',
allowratings smallint(6) NOT NULL default '0',
countposts smallint(6) NOT NULL default '1',
styleoverride smallint(5) NOT NULL default '0',
PRIMARY KEY (forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `forumpermission`
#

CREATE TABLE forumpermission (
forumpermissionid smallint(5) unsigned NOT NULL auto_increment,
forumid smallint(5) unsigned NOT NULL default '0',
usergroupid smallint(5) unsigned NOT NULL default '0',
canview smallint(6) NOT NULL default '0',
cansearch smallint(6) NOT NULL default '0',
canemail smallint(6) NOT NULL default '0',
canpostnew smallint(6) NOT NULL default '0',
canmove smallint(6) NOT NULL default '0',
canopenclose smallint(6) NOT NULL default '0',
candeletethread smallint(6) NOT NULL default '0',
canreplyown smallint(6) NOT NULL default '0',
canreplyothers smallint(6) NOT NULL default '0',
canviewothers smallint(6) NOT NULL default '0',
caneditpost smallint(6) NOT NULL default '0',
candeletepost smallint(6) NOT NULL default '0',
canpostattachment smallint(6) NOT NULL default '0',
canpostpoll smallint(6) NOT NULL default '0',
canvote smallint(6) NOT NULL default '0',
cangetattachment smallint(6) NOT NULL default '1',
PRIMARY KEY (forumpermissionid),
KEY ugid_fid(usergroupid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `groupaccess`
#

CREATE TABLE groupaccess (
group_id mediumint(8) NOT NULL default '0',
cat_id mediumint(8) unsigned NOT NULL default '0',
auth_viewcat tinyint(1) NOT NULL default '0',
auth_viewimage tinyint(1) NOT NULL default '0',
auth_download tinyint(1) NOT NULL default '0',
auth_upload tinyint(1) NOT NULL default '0',
auth_directupload tinyint(1) NOT NULL default '0',
auth_vote tinyint(1) NOT NULL default '0',
auth_sendpostcard tinyint(1) NOT NULL default '0',
auth_readcomment tinyint(1) NOT NULL default '0',
auth_postcomment tinyint(1) NOT NULL default '0',
KEY group_id(group_id),
KEY forum_id(cat_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `groupmatch`
#

CREATE TABLE groupmatch (
group_id mediumint(8) NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
groupmatch_startdate int(11) unsigned NOT NULL default '0',
groupmatch_enddate int(11) unsigned NOT NULL default '0',
KEY group_id(group_id),
KEY user_id(user_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `groups`
#

CREATE TABLE groups (
group_id mediumint(8) NOT NULL auto_increment,
group_name varchar(100) NOT NULL default '',
PRIMARY KEY (group_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `icon`
#

CREATE TABLE icon (
iconid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
iconpath char(100) NOT NULL default '',
PRIMARY KEY (iconid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `images`
#

CREATE TABLE images (
image_id mediumint(8) NOT NULL auto_increment,
cat_id mediumint(8) NOT NULL default '0',
userid mediumint(8) NOT NULL default '0',
image_name varchar(255) NOT NULL default '',
image_description text NOT NULL,
image_keywords text NOT NULL,
image_date int(11) unsigned NOT NULL default '0',
image_active tinyint(1) NOT NULL default '1',
image_media_file varchar(255) NOT NULL default '',
image_thumb_file varchar(255) NOT NULL default '',
image_download_url varchar(255) NOT NULL default '',
image_allow_comments tinyint(1) NOT NULL default '1',
image_comments smallint(6) NOT NULL default '0',
image_downloads smallint(6) NOT NULL default '0',
image_votes smallint(6) NOT NULL default '0',
image_rating decimal(4,2) NOT NULL default '0.00',
image_hits mediumint(8) NOT NULL default '0',
PRIMARY KEY (image_id),
KEY cat_id(cat_id),
KEY user_id(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `images_temp`
#

CREATE TABLE images_temp (
image_id mediumint(8) NOT NULL auto_increment,
cat_id mediumint(8) NOT NULL default '0',
userid mediumint(8) NOT NULL default '0',
image_name varchar(255) NOT NULL default '',
image_description text NOT NULL,
image_keywords text NOT NULL,
image_date int(11) unsigned NOT NULL default '0',
image_media_file varchar(255) NOT NULL default '',
image_thumb_file varchar(255) NOT NULL default '',
image_download_url varchar(255) NOT NULL default '',
PRIMARY KEY (image_id),
KEY cat_id(cat_id),
KEY user_id(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `lightboxes`
#

CREATE TABLE lightboxes (
lightbox_id varchar(32) NOT NULL default '',
userid mediumint(8) NOT NULL default '0',
lightbox_lastaction int(11) unsigned NOT NULL default '0',
lightbox_image_ids text,
PRIMARY KEY (lightbox_id),
KEY user_id(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `moderator`
#

CREATE TABLE moderator (
moderatorid smallint(5) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
forumid smallint(6) NOT NULL default '0',
newthreademail smallint(6) NOT NULL default '0',
newpostemail smallint(6) NOT NULL default '0',
caneditposts smallint(6) NOT NULL default '0',
candeleteposts smallint(6) NOT NULL default '0',
canviewips smallint(6) NOT NULL default '0',
canmanagethreads smallint(6) NOT NULL default '0',
canopenclose smallint(6) NOT NULL default '0',
caneditthreads smallint(6) NOT NULL default '0',
caneditstyles smallint(6) NOT NULL default '0',
canbanusers smallint(6) NOT NULL default '0',
canviewprofile smallint(6) NOT NULL default '0',
canannounce smallint(6) NOT NULL default '0',
canmassmove smallint(6) NOT NULL default '0',
canmassprune smallint(6) NOT NULL default '0',
canmoderateposts smallint(6) NOT NULL default '0',
canmoderateattachments smallint(6) NOT NULL default '0',
PRIMARY KEY (moderatorid),
KEY userid(userid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `poll`
#

CREATE TABLE poll (
pollid int(10) unsigned NOT NULL auto_increment,
question varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
options text NOT NULL,
votes text NOT NULL,
active smallint(6) NOT NULL default '1',
numberoptions smallint(5) unsigned NOT NULL default '0',
timeout smallint(5) unsigned NOT NULL default '0',
multiple smallint(5) unsigned NOT NULL default '0',
voters smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (pollid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `pollvote`
#

CREATE TABLE pollvote (
pollvoteid int(10) unsigned NOT NULL auto_increment,
pollid int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
votedate int(10) unsigned NOT NULL default '0',
voteoption int(10) unsigned NOT NULL default '0',
PRIMARY KEY (pollvoteid),
KEY userid(userid,pollid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `post`
#

CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
attachmentid smallint(5) unsigned NOT NULL default '0',
pagetext mediumtext NOT NULL,
allowsmilie smallint(6) NOT NULL default '0',
showsignature smallint(6) NOT NULL default '0',
ipaddress varchar(16) NOT NULL default '',
iconid smallint(5) unsigned NOT NULL default '0',
visible smallint(6) NOT NULL default '0',
edituserid int(10) unsigned NOT NULL default '0',
editdate int(10) unsigned NOT NULL default '0',
topic int(3) NOT NULL default '0',
PRIMARY KEY (postid),
KEY iconid(iconid),
KEY userid(userid),
KEY threadid(threadid,userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `postcards`
#

CREATE TABLE postcards (
postcard_id varchar(32) NOT NULL default '',
image_id mediumint(8) NOT NULL default '0',
postcard_date int(11) unsigned NOT NULL default '0',
postcard_bg_color varchar(100) NOT NULL default '',
postcard_border_color varchar(100) NOT NULL default '',
postcard_font_color varchar(100) NOT NULL default '',
postcard_font_face varchar(100) NOT NULL default '',
postcard_sender_name varchar(255) NOT NULL default '',
postcard_sender_email varchar(255) NOT NULL default '',
postcard_recipient_name varchar(255) NOT NULL default '',
postcard_recipient_email varchar(255) NOT NULL default '',
postcard_headline varchar(255) NOT NULL default '',
postcard_message text NOT NULL,
PRIMARY KEY (postcard_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `privatemessage`
#

CREATE TABLE privatemessage (
privatemessageid int(10) unsigned NOT NULL auto_increment,
folderid smallint(6) NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
touserid int(10) unsigned NOT NULL default '0',
fromuserid int(10) unsigned NOT NULL default '0',
title varchar(250) NOT NULL default '',
message mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
showsignature smallint(6) NOT NULL default '0',
iconid smallint(5) unsigned NOT NULL default '0',
messageread smallint(6) NOT NULL default '0',
readtime int(10) unsigned NOT NULL default '0',
receipt smallint(6) unsigned NOT NULL default '0',
deleteprompt smallint(6) unsigned NOT NULL default '0',
multiplerecipients smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (privatemessageid),
KEY userid(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `profilefield`
#

CREATE TABLE profilefield (
profilefieldid smallint(5) unsigned NOT NULL auto_increment,
title char(50) NOT NULL default '',
description char(250) NOT NULL default '',
required smallint(6) NOT NULL default '0',
hidden smallint(6) NOT NULL default '0',
maxlength smallint(6) NOT NULL default '250',
size smallint(6) NOT NULL default '25',
displayorder smallint(6) NOT NULL default '0',
editable smallint(6) NOT NULL default '1',
PRIMARY KEY (profilefieldid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `replacement`
#

CREATE TABLE replacement (
replacementid smallint(5) unsigned NOT NULL auto_increment,
replacementsetid smallint(6) NOT NULL default '0',
findword text NOT NULL,
replaceword text NOT NULL,
PRIMARY KEY (replacementid),
KEY replacementsetid(replacementsetid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `replacementset`
#

CREATE TABLE replacementset (
replacementsetid smallint(5) unsigned NOT NULL auto_increment,
title char(250) NOT NULL default '',
PRIMARY KEY (replacementsetid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `search`
#

CREATE TABLE search (
searchid int(10) unsigned NOT NULL auto_increment,
query mediumtext NOT NULL,
postids mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
querystring varchar(200) NOT NULL default '',
showposts smallint(6) NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
topic int(3) NOT NULL default '0',
PRIMARY KEY (searchid),
KEY querystring(querystring),
KEY userid(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `searchindex`
#

CREATE TABLE searchindex (
wordid int(10) unsigned NOT NULL default '0',
postid int(10) unsigned NOT NULL default '0',
intitle smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (wordid,postid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `session`
#

CREATE TABLE session (
sessionhash varchar(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host varchar(50) NOT NULL default '',
useragent varchar(50) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
styleid smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (sessionhash)
) TYPE=HEAP;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `sessionvars`
#

CREATE TABLE sessionvars (
sessionhash varchar(32) NOT NULL default '',
sessionvars_name varchar(30) NOT NULL default '',
sessionvars_value text,
KEY session_id(sessionhash)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `setting`
#

CREATE TABLE setting (
settingid smallint(5) unsigned NOT NULL auto_increment,
settinggroupid smallint(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
varname varchar(100) NOT NULL default '',
value mediumtext NOT NULL,
description mediumtext NOT NULL,
optioncode mediumtext NOT NULL,
displayorder smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (settingid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `settinggroup`
#

CREATE TABLE settinggroup (
settinggroupid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
displayorder smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (settinggroupid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `settings`
#

CREATE TABLE settings (
setting_name varchar(255) NOT NULL default '',
setting_value mediumtext NOT NULL,
PRIMARY KEY (setting_name)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `smilie`
#

CREATE TABLE smilie (
smilieid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
smilietext char(10) NOT NULL default '',
smiliepath char(100) NOT NULL default '',
PRIMARY KEY (smilieid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `style`
#

CREATE TABLE style (
styleid smallint(5) unsigned NOT NULL auto_increment,
replacementsetid smallint(5) unsigned NOT NULL default '0',
templatesetid smallint(5) unsigned NOT NULL default '0',
title char(250) NOT NULL default '',
userselect smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (styleid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `subscribeforum`
#

CREATE TABLE subscribeforum (
subscribeforumid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
emailupdate smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (subscribeforumid),
KEY userid(userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `subscribethread`
#

CREATE TABLE subscribethread (
subscribethreadid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
threadid int(10) unsigned NOT NULL default '0',
emailupdate smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (subscribethreadid),
KEY threadid(threadid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `template`
#

CREATE TABLE template (
templateid smallint(5) unsigned NOT NULL auto_increment,
templatesetid smallint(6) NOT NULL default '0',
title varchar(100) NOT NULL default '',
template mediumtext NOT NULL,
PRIMARY KEY (templateid),
KEY title(title(30),templatesetid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `templateset`
#

CREATE TABLE templateset (
templatesetid smallint(5) unsigned NOT NULL auto_increment,
title char(250) NOT NULL default '',
PRIMARY KEY (templatesetid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `thread`
#

CREATE TABLE thread (
threadid int(10) unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
lastpost int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
pollid int(10) unsigned NOT NULL default '0',
open tinyint(4) NOT NULL default '0',
replycount int(10) unsigned NOT NULL default '0',
postusername varchar(50) NOT NULL default '',
postuserid int(10) unsigned NOT NULL default '0',
lastposter varchar(50) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
views int(10) unsigned NOT NULL default '0',
iconid smallint(5) unsigned NOT NULL default '0',
notes varchar(250) NOT NULL default '',
visible smallint(6) NOT NULL default '0',
sticky smallint(6) NOT NULL default '0',
votenum smallint(5) unsigned NOT NULL default '0',
votetotal smallint(5) unsigned NOT NULL default '0',
attach smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (threadid),
KEY iconid(iconid),
KEY forumid(forumid,visible,sticky,lastpost),
KEY pollid(pollid),
KEY pollid_2(pollid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `threadrate`
#

CREATE TABLE threadrate (
threadrateid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
vote smallint(6) NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (threadrateid),
KEY threadid(threadid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `user`
#

CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(50) NOT NULL default '',
genus enum('Mann','Frau','Paar') NOT NULL default 'Mann',
styleid smallint(5) unsigned NOT NULL default '1',
parentemail varchar(50) NOT NULL default '',
coppauser smallint(6) NOT NULL default '0',
homepage varchar(100) NOT NULL default '',
icq varchar(20) NOT NULL default '',
aim varchar(20) NOT NULL default '',
yahoo varchar(20) NOT NULL default '',
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL default '0',
showemail smallint(6) NOT NULL default '0',
invisible smallint(6) NOT NULL default '0',
usertitle varchar(250) NOT NULL default '',
customtitle smallint(6) NOT NULL default '0',
joindate int(10) unsigned NOT NULL default '0',
cookieuser smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
posts smallint(5) unsigned NOT NULL default '0',
timezoneoffset varchar(4) NOT NULL default '',
emailnotification smallint(6) NOT NULL default '0',
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL default '0',
emailonpm smallint(6) NOT NULL default '0',
pmpopup smallint(6) NOT NULL default '0',
avatarid smallint(6) NOT NULL default '0',
options smallint(6) NOT NULL default '15',
birthday date NOT NULL default '0000-00-00',
maxposts smallint(6) NOT NULL default '-1',
startofweek smallint(6) NOT NULL default '1',
ipaddress varchar(20) NOT NULL default '',
referrerid int(10) unsigned NOT NULL default '0',
nosessionhash smallint(6) NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
picname varchar(50) NOT NULL default '',
picdesc varchar(255) NOT NULL default '',
pictime int(10) NOT NULL default '0',
comments smallint(6) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
activationkey varchar(32) NOT NULL default '',
RealName varchar(255) default NULL,
ReceiveMail enum('Yes','No') NOT NULL default 'Yes',
Newsletter enum('Yes','No') NOT NULL default 'No',
PRIMARY KEY (userid),
KEY username(username),
KEY usergroupid(usergroupid),
KEY inforum(inforum)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `useractivation`
#

CREATE TABLE useractivation (
useractivationid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
activationid char(20) NOT NULL default '',
type smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (useractivationid),
KEY userid(userid,type)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `userfield`
#

CREATE TABLE userfield (
userid int(10) unsigned NOT NULL default '0',
field1 text NOT NULL,
field2 text NOT NULL,
field3 text NOT NULL,
field4 text NOT NULL,
PRIMARY KEY (userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `userfield_s`
#

CREATE TABLE userfield_s (
userid int(10) unsigned NOT NULL default '0',
field1 text NOT NULL,
field2 text NOT NULL,
field3 text NOT NULL,
field4 text NOT NULL,
PRIMARY KEY (userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `usergroup`
#

CREATE TABLE usergroup (
usergroupid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
usertitle char(100) NOT NULL default '',
cancontrolpanel smallint(6) NOT NULL default '0',
canmodifyprofile smallint(6) NOT NULL default '0',
canviewmembers smallint(6) NOT NULL default '0',
canview smallint(6) NOT NULL default '0',
cansearch smallint(6) NOT NULL default '0',
canemail smallint(6) NOT NULL default '0',
canpostnew smallint(6) NOT NULL default '0',
canmove smallint(6) NOT NULL default '0',
canopenclose smallint(6) NOT NULL default '0',
candeletethread smallint(6) NOT NULL default '0',
canreplyown smallint(6) NOT NULL default '0',
canreplyothers smallint(6) NOT NULL default '0',
canviewothers smallint(6) NOT NULL default '0',
caneditpost smallint(6) NOT NULL default '0',
candeletepost smallint(6) NOT NULL default '0',
canusepm smallint(6) NOT NULL default '0',
canpostpoll smallint(6) NOT NULL default '0',
canvote smallint(6) NOT NULL default '0',
canpostattachment smallint(6) NOT NULL default '0',
canpublicevent smallint(6) NOT NULL default '0',
canpublicedit smallint(6) NOT NULL default '0',
canthreadrate smallint(6) NOT NULL default '1',
maxbuddypm smallint(6) unsigned NOT NULL default '5',
maxforwardpm smallint(6) unsigned NOT NULL default '5',
cantrackpm smallint(6) NOT NULL default '1',
candenypmreceipts smallint(6) NOT NULL default '1',
canwhosonline smallint(6) NOT NULL default '1',
canwhosonlineip smallint(6) NOT NULL default '0',
ismoderator smallint(6) NOT NULL default '0',
showgroup smallint(5) unsigned NOT NULL default '0',
cangetattachment smallint(5) NOT NULL default '1',
PRIMARY KEY (usergroupid),
KEY showgroup(showgroup)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `users`
#

CREATE TABLE users (
user_id mediumint(8) NOT NULL auto_increment,
user_level smallint(6) NOT NULL default '1',
user_name varchar(255) NOT NULL default '',
user_password varchar(255) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_showemail tinyint(1) NOT NULL default '0',
user_invisible tinyint(1) NOT NULL default '0',
user_joindate int(11) NOT NULL default '0',
user_activationkey varchar(32) NOT NULL default '',
user_lastaction int(11) NOT NULL default '0',
user_location varchar(255) NOT NULL default '',
user_lastvisit int(11) NOT NULL default '0',
comments smallint(6) unsigned NOT NULL default '0',
user_homepage varchar(255) NOT NULL default '',
user_icq varchar(20) NOT NULL default '',
PRIMARY KEY (user_id),
KEY user_lastaction(user_lastaction)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `usertitle`
#

CREATE TABLE usertitle (
usertitleid smallint(5) unsigned NOT NULL auto_increment,
minposts smallint(5) unsigned NOT NULL default '0',
title char(250) NOT NULL default '',
PRIMARY KEY (usertitleid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `word`
#

CREATE TABLE word (
wordid int(10) unsigned NOT NULL auto_increment,
title char(50) NOT NULL default '',
PRIMARY KEY (wordid),
UNIQUE KEY title(title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f?r Tabelle `wordlist`
#

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

#
# Tabellenstruktur f?r Tabelle `wordmatch`
#

CREATE TABLE wordmatch (
image_id mediumint(8) unsigned NOT NULL default '0',
word_id mediumint(8) unsigned NOT NULL default '0',
name_match tinyint(1) NOT NULL default '0',
desc_match tinyint(1) NOT NULL default '0',
keys_match tinyint(1) NOT NULL default '0',
KEY word_id(word_id)
) TYPE=MyISAM;

[Robert9]

Sorry for that unconvience ;-)
I have write the autor and suggest to work together to bring out a vb version of his script, but he isn´t interested in.

Robert

[Jadelit]

any updates on this?

[Konqueror]

Yep: http://www.4homepages.de/forum/viewtopic.php?t=807
At the moment I'm converting it to the new version that came out a few days ago.

[Jadelit]

check for details

[JoshFink]

How is this coming? Looks very promising.. (well from what little german I can understand. :D )

Thanks

Josh

[Low Tek]

Have anyone heard of Photopost.com (http://www.photopost.com) ? It does the same thing as 4images, plus it already integrates with VB and UBB. Only problem is that it costs $149 dollars.
=/

[X-Fan]

Yep, heard of PhotoPost, but the US$149 cost put me off as it translates to almost AU$300! :(

[Birdie501]

well i tried to contact konqueror but he seems to be unavailable. He told me that he will finish it in 2 weeks. But that was 4 weeks ago :)

[Kars10]

Hello Guys!!
Is this Project still alive?? This script is very good.
But what must i do to integrate it in my vb?? :confused:
Is there a script i cant use without modification (i know about Photopost) for free??

[DraX]

This project was brought to life by the folks over at 4images.
check this thread: https://vborg.vbsupport.ru/showthread.php?s=&threadid=43803

Supposedly they are working on making integration simpler and automatic for the next release of 4images