The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Table Field Inserts via query's
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:
Right now the profilefield show's this Quote:
Quote:
any help on this would be greatly appreciated. Hotwheels |
#2
|
||||
|
||||
you need to alter the database table first.
open up phpmyadmin, and add a new field to hold your data. |
#3
|
|||
|
|||
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:
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 |
#4
|
|||
|
|||
I figured it out........I have to make the new field table first, then run my query's..........thanks, hotwheels
|
#5
|
|||
|
|||
sorry man......I will get someone to move it.
|
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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:
PHP Code:
|
#8
|
|||
|
|||
Forum home activity mod
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|