add a field to the thread table

[pyro.699]

i would like to know how to add a field to the thread table... lol, as the title says...

i would also like to know, how to inflict that on my postbit!

[Andreas]

[sql]ALTER TABLE thread ADD foobar VARCHAR(20) NOT NULL DEFAULT ''[/sql]

[pyro.699]

what? lol

that makes the least of sence.. i know how 2 run the query.. ikd what its for, what files to edit...

(its for an rpg script, the user decideds what the requirements are for the rpg he wants to make, then based on his options, it adds them to the postbit...)

[Andreas]

Your question was

i would like to know how to add a field to the thread table

I've answered it. But it seems like you wanted to know smth. else.
So please state exactly what ou want to know.

[pyro.699]

Ok, (=D'')=D < Kirby with boxing gloves ^^

I would like to edit the appearance of forum id #26. Ifs goign to be made to fit a customized rpg script.

CURRENT OPTIONS:
look at my post ^^
Da Link

FEATURES:
User can choose what options he/she wants(in the thread posting area) (options are in link)

Depending on what the user has selected, thats what is displayed in the postbit

WHAT I HAVE DONE SO FAR:
added all current tables
added postbits
created the php file
made the querys


lme know if you need any more info

Kirby's sql query is correct

PHP Code:


ALTER TABLE thread ADD foobar VARCHAR(20) NOT NULL DEFAULT '' 


foobar is the new field name.

If you need to get that info in a postbit then you have to use a select query to get the info.

But, why not just use custom profile fields?

[pyro.699]

...

im more asking for a bit of help designing the script... not a request, like iming information i dont really like having people give me the scripts, id like to help build them.

I know that kirbys script is correct, im also asking, what else do i add?

[Andreas]

Originally Posted by Danny.VBT

If you need to get that info in a postbit then you have to use a select query to get the info.

$threadinfo['foobar'], no need for a query

Originally Posted by KirbyDE

$threadinfo['foobar'], no need for a query

Learn something new everyday.

[pyro.699]

ok, i need a bit mroe help... i need ot know how to tel the script to read what the user has selected...

-----
Help from AJ
-----

what i want is to be ale to specify a few things when i go to amke a post, then i want the postbit to be able to read those choices...

Originally Posted by AJ

[22:01] Aj - It's That Time of Year Again!: just explain what you did to me
[22:01] Aj - It's That Time of Year Again!: when you make a thread you want to specify some things
[22:01] Aj - It's That Time of Year Again!: thast the main part because you have to add the fields to the datamanager, and learn how to use it

---------------
---NEW POST---
---------------

Originally Posted by (=D'')=D

- Alter table thread to add your fields
- Adjust Template newthread
- Creae a Plugin for threadpfdata_start to add the fields to its validfields
- Create a Plugin for newthread_post_start to set the fields in $post to the cleaned form data
- Create a Plugin for newpost_process to set the values from $post to the Datamanager

This method does not cause additional queries

AJ helped me find this post, can you elaberate a bit more on this? more to my specifications?

like, do i add

PHP Code:

 if (thread id code == 26)
 {
 }; 


to every plugin? or what...

and how do i amke the postbit read what the user selected...

Thanks