30 replies to this topic

[Detail]

Just a note, every MySQL on game-mod.net will look like this:

HOST: localhost
DB: gamemod_site
USER: gamemod_site
PASS: pass

[Stino]

Detail did u already put the tables in the db?

[Mastermind]

fred (acutal username), one of the people working on the TFH site, would like to be moved to hosted. If someone could take care of that, that would be great.

[Detail]

He's not hosted and he's not a moderator, so:
Any reason?
Whats his position?
What does he do?
Why does he know about this forum?

[Stino]

He's makin our site! So he need some codes for banner, ads, bars etc!

[Detail]

{like n00b, only diffrent}

Why you using "!"'s ?

[fred]

Hello,
I have a request for some database help.
I tried to create a table in the our (tfh) database. For some reason, it won't let me do it though php.
Could someone (i heard Detail could do this) insert two tables into the database so that we could make our site functional. I have the sql files and commands that would be needed to insert them.

thanks,
fred

[Detail]

-_-

First:
Table name?
Number of fields?

and:
Field Type?
Length/Values?
Attributes?
Null?
Default?
Extra?
Primary?
Index?
Unique?
Fulltext?

then:
Table type?




I'd rather you just send an sql script that i can run in phpMyAdmin.
example:

CREATE TABLE conversationlog (
  id int(11) NOT NULL auto_increment,
  input text,
  response text,
  thatresponse text,
  uid varchar(255) default NULL,
  enteredtime timestamp(14) not null,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

[Detail]

All done.
Tables look fine.

[fred]

thanks

everything works now

[Daz]

Detail, I think this will need setting up on game-mod.
I don't know how to do it so can you sort it please?

[fred]

if you make a new database for tfh, could you please use the following (some minor changes to the original):

CREATE TABLE news (
id int(25) NOT NULL AUTO_INCREMENT,
title varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
username varchar(25) NOT NULL default '',
type varchar(25) NOT NULL default 'news',
body text NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE users (
id int(25) NOT NULL AUTO_INCREMENT,
email_address varchar(255) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
country varchar(255) NOT NULL,
work varchar(255) NOT NULL,
sides varchar(255) NOT NULL,
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') default '1',
decrypted_password varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY username (username)
);

CREATE TABLE vars (
variable varchar(255) NOT NULL default '',
value varchar(255) NOT NULL default '',
UNIQUE KEY variable (variable)
);

INSERT INTO vars VALUES('newsid','0');
INSERT INTO vars VALUES('userid','0');
INSERT INTO vars VALUES('users','0');
INSERT INTO vars VALUES('visits','0');

thanks
fred

[Mastermind]

I added the DB, but I can't seem to get to the phpMyAdmin. Detail, can you do that?

[Detail]

*looks* The DNS has updated, so i now can.

SQL done


Fred, i found a way to make the drop downs change without having to refresh the page (thanks to deviantART ;)2 ).

We can think about another one of those scripts on the list now.

[Stino]

I still get an error: http://tfh.game-mod.net/test/
So did u make the db?

[Detail]

The username and database name have changed.
I also wounder what Mastermind set the password as.


This server move has caused alot of mess, but it will all settel out soon.

[Mastermind]

I told Fred, but I think I can still find it somewhere. I can PM it to whoever needs it. I don't think it needs to be posted here though.

[Detail]

Mastermind made the database and user yesterday.
I added the tables to the database yesterday.

If theres still a problem i'll have another look when i get home.

[Stino]

I get still an error: http://tfh.game-mod.net/test/

[Mastermind]

Fred probably hasn't updated the stuff yet to link to the new database. I don't know beyond that.