# Mysql

**URL:** <https://forum.kirupa.com/t/mysql/34046>\
**Category:** Uncategorized\
**Created:** [October 27, 2003, 2:26pm UTC](https://forum.kirupa.com/t/mysql/34046 "2003-10-27T14:26:32Z")\
**Posts on this page:** 16\
**Page:** 2

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 6:19am UTC](https://forum.kirupa.com/t/mysql/34046/21 "2003-10-30T06:19:43Z")

</div>

> 

# 

# Table structure for table `forumCatagories`

# 

CREATE TABLE forumCatagories (  
catagoryID int(11) NOT NULL auto\_increment,  
title varchar(50) default NULL,  
displayOrder int(11) default ‘0’,  
PRIMARY KEY (catagoryID)  
) TYPE=MyISAM;

# --------------------------------------------------------

# 

# Table structure for table `forumForums`

# 

CREATE TABLE forumForums (  
forumID int(11) NOT NULL auto\_increment,  
catagoryID int(11) default NULL,  
title varchar(40) default NULL,  
displayOrder int(11) default ‘0’,  
threadCount int(11) default ‘0’,  
lastPost int(11) default ‘0’,  
description varchar(100) default NULL,  
lastUserID int(11) default NULL,  
postNewLevel tinyint(4) default ‘0’,  
postReplyLevel tinyint(4) default ‘0’,  
PRIMARY KEY (forumID)  
) TYPE=MyISAM;

# --------------------------------------------------------

# 

# Table structure for table `forumPosts`

# 

CREATE TABLE forumPosts (  
postID int(11) NOT NULL auto\_increment,  
threadID int(11) default NULL,  
userID int(11) default NULL,  
message mediumtext,  
posted int(11) default NULL,  
notify tinyint(4) NOT NULL default ‘0’,  
addsig tinyint(4) NOT NULL default ‘0’,  
topic varchar(255) default NULL,  
PRIMARY KEY (postID),  
FULLTEXT KEY topic (topic,message)  
) TYPE=MyISAM;

# --------------------------------------------------------

# 

# Table structure for table `forumThreads`

# 

CREATE TABLE forumThreads (  
threadID int(11) NOT NULL auto\_increment,  
userID int(11) default NULL,  
topic varchar(100) default NULL,  
replies int(11) default ‘0’,  
lastPost int(11) default NULL,  
sticky tinyint(4) default ‘0’,  
forumID int(11) NOT NULL default ‘0’,  
announcement tinyint(4) default ‘0’,  
PRIMARY KEY (threadID)  
) TYPE=MyISAM;

# --------------------------------------------------------

# 

# Table structure for table `forumUsers`

# 

CREATE TABLE forumUsers (  
userID int(11) NOT NULL auto\_increment,  
username varchar(20) default NULL,  
password varchar(40) default NULL,  
title varchar(30) default NULL,  
email varchar(255) default NULL,  
userLevel tinyint(11) default ‘0’,  
signature tinytext,  
postCount int(11) default ‘0’,  
PRIMARY KEY (userID)  
) TYPE=MyISAM;

this is the one i used and paste so where do edit here or add command for the topics ?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 5:03pm UTC](https://forum.kirupa.com/t/mysql/34046/22 "2003-10-30T17:03:47Z")

</div>

> eyezberg where are you?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 6:11pm UTC](https://forum.kirupa.com/t/mysql/34046/23 "2003-10-30T18:11:44Z")

</div>

@ work, lol…  
get back to ya later…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 6:39pm UTC](https://forum.kirupa.com/t/mysql/34046/24 "2003-10-30T18:39:01Z")

</div>

```php
<?

// Include dBase file
include('common.php');

// Connect to database
$link = dbConnect();

// If connection failed...
if (!$link) {
    // Inform user of error and quit
    print "Couldn't connect to database server";
    exit;
}

// Attempt to select database
print "Attempting to select database $dbName <br>
";
if(!@mysql_select_db($dbName)) {
    // Inform user of error and exit
    print "# Couldn't select database <br>
";
    exit;
} else {
    // Inform user of success
    print "# Database selected successfully <br>
";
}

//create demo catagories ***********************
query = "INSERT INTO forumCatagories (catagoryID, title, displayOrder) VALUES (1, 'General [Read only!]', 1)";
$result = @mysql_query($query);
if (!$result) {
    // Inform user of error
    print "# Error inserting General<br>
";
    print mysql_error();
} else {
    // Inform user of success
    print "# General catagory created<br>
";
}
$query = "INSERT INTO forumCatagories (catagoryID, title, displayOrder) VALUES (2, 'Development Help', 2)";
$result = @mysql_query($query);
if (!$result) {
    // Inform user of error
    print "# Error inserting Development<br>
";
    print mysql_error();
} else {
    // Inform user of success
    print "# Development catagory created<br>
";

//etc..., change the title to what you want, add as many as needed, incrementing the catagoryID...

//create demo forums ******************************
//carefull to use the catID where you want the forum to show up!
//all you really need to change here is:
//-the number of forums/queries you want
//-the title
//-the description
//-the forumID

//catID 1 of 4
$query1 = "INSERT INTO forumForums (forumID, catagoryID, title, description, displayOrder, threadCount, lastPost, postNewLevel, postReplyLevel, lastUserID) VALUES (1, 1, 'Announcements', 'If I need to tell ya something, it\'ll be here!', 1, 0, 0, 0, 0, NULL)";
$result = @mysql_query($query1);
if (!$result) {
    // Inform user of error
    print "# Error inserting Announcements forum<br>
";
    print mysql_error();
} else {
    // Inform user of success
    print "# Announcements forum created -ID = 1<br>
";
}

//etc..as many for each catagory as you want...

//insert the admin user ***************
$pass = md5('YOURPASSWORDHERE');
$reginfo = time();

print "# Inserting admin user - ID=2<br>
";

$query15 = "INSERT INTO forumUsers (userID, username, password, title, email, userLevel, signature, postCount, reginfo) VALUES (2, bongbox, '".$pass."', 'admin', 'admin@YOURWEBSITE.com', 5, 'YOURSIGNATURE', 0, '".$reginfo."')";
$result = @mysql_query($query15);
if (!$result) {
    // Inform user of error
    print "# Error creating admin account<br>
";
    print mysql_error();
} else {
    // Inform user of success
    print "# admin user ready to go<br>
";
	print "# admin user is:<br>name:".$username."
";
	print "# End of default users<br>
";
}

// Close link to database server 
mysql_close($link);

print "End of setup / link closed";

?>

```

save as “setup.php”, read the //comments!!!, change the vars in CAPS for admin user (you), add desired catagories & forums queries, run in browser and you’re set…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 7:57pm UTC](https://forum.kirupa.com/t/mysql/34046/25 "2003-10-30T19:57:56Z")

</div>

so ill save it up setup.php and then change vars in CAPs  
what do you mean by vars in caps and how do i add categories  
sorry if i pick up to slow

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 8:11pm UTC](https://forum.kirupa.com/t/mysql/34046/26 "2003-10-30T20:11:19Z")

</div>

ok i get the admin user caps vars only the one to add categories

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 30, 2003, 10:18pm UTC](https://forum.kirupa.com/t/mysql/34046/27 "2003-10-30T22:18:42Z")

</div>

# categories inserted at beginning, 2 are ready, if you want more, copy this part

# query = “INSERT INTO forumCatagories (catagoryID, title, displayOrder) VALUES (1, ‘General [Read only!]’, 1)”; $result = @mysql\_query($query); if (!$result) { // Inform user of error print “# Error inserting General\<br\> ”; print mysql\_error(); } else { // Inform user of success print “# General catagory created\<br\> ”; }

# as many times as needed and change the values. Same with forums: add as many blocks of

# $query1 = “INSERT INTO forumForums (forumID, catagoryID, title, description, displayOrder, threadCount, lastPost, postNewLevel, postReplyLevel, lastUserID) VALUES (1, 1, ‘Announcements’, ‘If I need to tell ya something, it’ll be here!’, 1, 0, 0, 0, 0, NULL)”; $result = @mysql\_query($query1); if (!$result) { // Inform user of error print “# Error inserting Announcements forum\<br\> ”; print mysql\_error(); } else { // Inform user of success print “# Announcements forum created -ID = 1\<br\> ”; }

and change values as needed…read the comments…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 31, 2003, 2:31am UTC](https://forum.kirupa.com/t/mysql/34046/28 "2003-10-31T02:31:17Z")

</div>

where exactly in the beginning? lets say i wanna add general discusion as an example

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 31, 2003, 7:24am UTC](https://forum.kirupa.com/t/mysql/34046/29 "2003-10-31T07:24:36Z")

</div>

eyezberg did you get my email

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 31, 2003, 5:27pm UTC](https://forum.kirupa.com/t/mysql/34046/30 "2003-10-31T17:27:50Z")

</div>

yes, and replied…  
don’t forget i’m in europe, so there’s quite some time difference… 😉

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 31, 2003, 10:17pm UTC](https://forum.kirupa.com/t/mysql/34046/31 "2003-10-31T22:17:37Z")

</div>

lol ok

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [November 1, 2003, 11:51am UTC](https://forum.kirupa.com/t/mysql/34046/32 "2003-11-01T11:51:36Z")

</div>

all set up, check it out & your mail too…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [November 1, 2003, 1:07pm UTC](https://forum.kirupa.com/t/mysql/34046/33 "2003-11-01T13:07:18Z")

</div>

\*\*\*\* you, joke lol, your good tnx a lot

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [November 1, 2003, 6:27pm UTC](https://forum.kirupa.com/t/mysql/34046/34 "2003-11-01T18:27:17Z")

</div>

if you want to remove the dummy stuff i inserted, just display/browse the forumForums table, and check the ones you don’t want, click delete…

any other help, mail or post…  
😉

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [November 1, 2003, 11:44pm UTC](https://forum.kirupa.com/t/mysql/34046/35 "2003-11-01T23:44:55Z")

</div>

i am trying to register when i register it always giving a warning that the email is wrong…you could try it yourself try to register and see what happen

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [November 3, 2003, 12:27am UTC](https://forum.kirupa.com/t/mysql/34046/36 "2003-11-03T00:27:55Z")

</div>

i cant get the registration working always alerting the the email is invalid what seems to be the probles?

[Previous page](https://forum.kirupa.com/t/mysql/34046.md?page=1)