Table Field Inserts via query's

[hotwheels]

When writting an INSERT INTO, and the table doesn't exist for your query, how can you go about forcing a new table into a certain field?

Example:

PHP Code:

    $db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid,title,description,required,hidden,maxlength,size,displayorder,editable,type,data,height,def,optional,searchable,memberlist,regex,form,html) VALUES 


In the above INSERT, i am trying to install a title in the table, but the title will not insert.

Right now the profilefield show's this

profilefieldid,description,required,hidden,maxleng th,size,displayorder,editable,type,data,height,def ,optional,searchable,memberlist,regex,form,html

and i need to put title in to this section, so that right after profile field, it says "title" like this

profilefieldid,title,description,required,hidden,m axlength,size,displayorder,editable,type,data,heig ht,def,optional,searchable,memberlist,regex,form,h tml

.......Is this even possible in 3.6, or do i need to try to write this for another table? I would really like this to be a profile addition, but i am not sure how to go about changing fields.

any help on this would be greatly appreciated. Hotwheels

[briansol]

you need to alter the database table first.

open up phpmyadmin, and add a new field to hold your data.

[hotwheels]

Please understand i am very new to this and i am trying very hard to read and write code. Any help is greatly appreciated.

K, i have one more table question real quick. It took my db query write, but i am not getting the name's of my custom profilefields, as seen in the picture below.

Let's say you have custom profilefields built in, and you want the title to be
$aa= 'Dog';

$a= 'What kind of dog?';

This is my query write

PHP Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid,title,description,required,hidden,maxlength,size,displayorder,editable,type,data,height,def,optional,searchable,memberlist,regex,form,html) VALUES (50,'".addslashes($aa)."','".addslashes($a)."',0,0,'20','20','50','1','input','','0','0','0','0','0','0','','0')"); 


So Now i have gone into mysql database and manually want to add 'title' and 'description' but i need these two new fields to understand that they are to pull the title and descrition from my custom profilefield.
Now,
Field would = title
Type would = ? ( i don't understand how to get this to pull my different characters/title's)
Length/Values1 would = 6 would be my guess on this one. (dog has only 3 characters) right?
Collation would = ? utf8 (i would guess)
Attributes would = UNSIGNED (again, that is just a guess on my part.)
Null would = NOT NULL
Default2 would = ? (no idea since i am trying to get this to pull from custom profile fields.)
Extra would = leave blank

I am not sure if i am asking this right at all, but i attached a picture of what it is starting to look like on my page, and what i am confused about.

Thanks, doug

[hotwheels]

I figured it out........I have to make the new field table first, then run my query's..........thanks, hotwheels

[hotwheels]

sorry man......I will get someone to move it.

[hotwheels]

Had my thread moved here.

And here is my new instructions text for timeslips3.6.......

For those that are going to use these instructions, please feel free to ask any questions you may have. I will support what i have written inside the instructions.

And once you are inside your phpmyadmin, when you go to set your new fields, you will basically be looking for this This is where you are going to put in the new "title" and "description" fields.

Peace, hotwheels

[hotwheels]

K, instead of making the actual field edit's in your phpmyadmin, just run these 2 queries one at a time, and then follow deathemperors how too......These 2 queries, will add the correct fields....(My database has the fields set as "vbprofilefield", your's may be set as "profilefield" or "vb3profilefield", so just change the below to which ever your database field is.) If you have profilefield, then change the `vbprofilefield` to `profilefield` and run the query.....

PHP Code:

ALTER TABLE `vbprofilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ; 


PHP Code:

ALTER TABLE `vbprofilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ; 


(Thanks for the update friends, hopefully the instruction's will now help others when installing on 3.6)

[hotwheels]

Forum home activity mod