Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2007
Posts: 329
Yarp™
Yarp™
Offline
Joined: Feb 2007
Posts: 329
Same here, and http://themepark.nl/ubb/ubbthreads.php?ubb=links_admin&op=create_tables doesn't work also.

The queries in the script are wrong also, atleast I had to rework them manually to be able to create the databases.

For those who want to play, I executed this in phpmyadmin (I did change the table prefix to ubbt_:

Code
			CREATE TABLE ubbt_links_links
(
lid int(11) NOT NULL auto_increment,
cat_id int(11) default NULL,
approved tinyint(4) NOT NULL default '1',
title varchar(100) NOT NULL default '',
url varchar(100) NOT NULL default '',
description text NOT NULL,
date_added int(11) unsigned NOT NULL default '0',
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
hits int(11) NOT NULL default '0',
user_number int( 11 ) NOT NULL default '0',
member char(2) NOT NULL default '',
linkratingsummary double(6,4) NOT NULL default '0.0000',
totalvotes int(11) NOT NULL default '0',
PRIMARY KEY (lid)
)


CREATE TABLE ubbt_links_categories
(

cat_id int(11) NOT NULL auto_increment,
parent_id int(11) default NULL,
title varchar(50) NOT NULL default '',
cat_desc varchar(60) default NULL,
cat_order tinyint(10) NOT NULL default '0',
PRIMARY KEY (cat_id)
)


CREATE TABLE ubbt_links_favorites
(
num int(9) unsigned NOT NULL auto_increment,
lid int(9) unsigned NOT NULL default '0',
uid int(9) unsigned NOT NULL default '0',
PRIMARY KEY (num),
KEY FAV_indx1 (uid)
)

Last edited by blaaskaak; 08/08/2007 5:31 PM.
Sponsored Links
Entire Thread
Subject Posted By Posted
TLD 7.2 - Link Directory JoshPet 08/08/2007 6:34 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/08/2007 5:23 PM
Re: TLD 7.2 - Link Directory AllenAyres 08/08/2007 5:39 PM
Re: TLD 7.2 - Link Directory AllenAyres 08/08/2007 5:49 PM
Re: TLD 7.2 - Link Directory Stephen G 08/08/2007 11:12 PM
Re: TLD 7.2 - Link Directory blaaskaak 08/09/2007 12:29 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/09/2007 5:50 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/09/2007 5:56 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/09/2007 6:03 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/09/2007 6:30 AM
Re: TLD 7.2 - Link Directory JoshPet 08/09/2007 7:25 AM
Re: TLD 7.2 - Link Directory AllenAyres 08/09/2007 7:50 AM
Re: TLD 7.2 - Link Directory Carte Blanche 09/06/2007 1:57 PM
Re: TLD 7.2 - Link Directory Gizmo 09/06/2007 5:14 PM
Re: TLD 7.2 - Link Directory blaaskaak 09/06/2007 9:36 PM
Re: TLD 7.2 - Link Directory Gizmo 09/07/2007 1:44 AM
Re: TLD 7.2 - Link Directory blaaskaak 09/07/2007 9:48 AM
Re: TLD 7.2 - Link Directory Gizmo 09/07/2007 10:16 AM
Re: TLD 7.2 - Link Directory Zarzal 09/17/2007 4:22 PM
Re: TLD 7.2 - Link Directory Stephen G 09/17/2007 8:59 PM
Re: TLD 7.2 - Link Directory Zarzal 09/17/2007 9:22 PM
Re: TLD 7.2 - Link Directory Stephen G 09/17/2007 10:54 PM
Re: TLD 7.2 - Link Directory Stephen G 09/24/2007 10:02 PM
Re: TLD 7.2 - Link Directory AllenAyres 09/25/2007 6:55 AM
Re: TLD 7.2 - Link Directory AllenAyres 09/25/2007 7:06 AM
Re: TLD 7.2 - Link Directory Stephen G 09/25/2007 7:18 PM
Re: TLD 7.2 - Link Directory mikey81 09/25/2007 8:21 PM
Re: TLD 7.2 - Link Directory AllenAyres 09/25/2007 10:13 PM
Re: TLD 7.2 - Link Directory mikey81 09/26/2007 10:00 AM
Re: TLD 7.2 - Link Directory Stephen G 09/26/2007 10:20 AM
Re: TLD 7.2 - Link Directory AllenAyres 09/26/2007 2:49 PM
Re: TLD 7.2 - Link Directory Stephen G 09/26/2007 3:16 PM
Re: TLD 7.2 - Link Directory blaaskaak 09/26/2007 5:20 PM
Re: TLD 7.2 - Link Directory Zarzal 09/26/2007 10:39 PM
Re: TLD 7.2 - Link Directory Micky 09/29/2007 3:18 AM
Re: TLD 7.2 - Link Directory blaaskaak 09/25/2007 10:30 PM
Re: TLD 7.2 - Link Directory AllenAyres 09/26/2007 12:37 AM
Re: TLD 7.2 - Link Directory blaaskaak 09/26/2007 12:39 AM
Re: TLD 7.2 - Link Directory AllenAyres 09/25/2007 6:54 AM
Re: TLD 7.2 - Link Directory Deejay23 01/25/2009 5:38 AM
Re: TLD 7.2 - Link Directory AllenAyres 01/25/2009 5:56 AM
Re: TLD 7.2 - Link Directory Zarzal 02/24/2009 10:53 PM
Re: TLD 7.2 - Link Directory AllenAyres 02/25/2009 2:15 AM
Re: TLD 7.2 - Link Directory Zarzal 02/25/2009 1:10 PM
Re: TLD 7.2 - Link Directory Zarzal 02/25/2009 1:18 PM
Re: TLD 7.2 - Link Directory badfrog 10/04/2009 11:49 PM
Re: TLD 7.2 - Link Directory Ruben Rocha 10/05/2009 12:18 AM
Re: TLD 7.2 - Link Directory AllenAyres 10/05/2009 6:56 AM
Re: TLD 7.2 - Link Directory badfrog 10/05/2009 3:01 PM
Re: TLD 7.2 - Link Directory AllenAyres 10/05/2009 4:22 PM
Re: TLD 7.2 - Link Directory AllenAyres 10/05/2009 4:23 PM
Re: TLD 7.2 - Link Directory Ruben Rocha 10/05/2009 11:35 PM
Re: TLD 7.2 - Link Directory AllenAyres 10/05/2009 11:53 PM
Re: TLD 7.2 - Link Directory Ruben Rocha 10/05/2009 11:59 PM
Re: TLD 7.2 - Link Directory Zarzal 02/17/2008 1:32 PM
Re: TLD 7.2 - Link Directory Micky 02/17/2008 8:16 PM
Re: TLD 7.2 - Link Directory Zarzal 02/18/2008 1:29 AM
Re: TLD 7.2 - Link Directory Zarzal 05/18/2008 4:38 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/11/2008 6:23 PM
Re: TLD 7.2 - Link Directory Zarzal 06/11/2008 8:24 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/13/2008 6:53 AM
Re: TLD 7.2 - Link Directory Zarzal 06/13/2008 8:42 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/13/2008 10:32 PM
Re: TLD 7.2 - Link Directory Zarzal 06/13/2008 10:46 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/13/2008 10:52 PM
Re: TLD 7.2 - Link Directory Zarzal 06/13/2008 11:40 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/14/2008 5:36 AM
Re: TLD 7.2 - Link Directory AllenAyres 06/14/2008 6:21 AM
Re: TLD 7.2 - Link Directory Zarzal 06/14/2008 11:08 AM
Re: TLD 7.2 - Link Directory AllenAyres 06/15/2008 10:35 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/15/2008 10:54 PM
Re: TLD 7.2 - Link Directory AllenAyres 06/16/2008 6:17 AM
Re: TLD 7.2 - Link Directory Zarzal 06/16/2008 7:45 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)