vb.org Archive - how can add new field by db code

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - how can add new field by db code (https://vborg.vbsupport.ru/showthread.php?t=205573)

al3bed

02-16-2009 02:17 PM

how can add new field by db code

hello,

I have this code in my plugin:

PHP Code:


		
			
$vbulletin->db->query_write(" 

            INSERT INTO `". TABLE_PREFIX ."profilefield` 

            (`profilefieldid` ,`profilefieldcategoryid` ,`required` ,`hidden` ,`maxlength` ,`size` ,`displayorder` ,`editable` ,`type` ,`data` ,`height` ,`def` ,`optional` ,`searchable` ,`memberlist` ,`regex` ,`form` ,`html` ,`perline`) 

            VALUES (NULL, '0', '0', '0', '16', '16', '', '1', 'input', NULL , '0', '0', '0', '0', '0', '', '0', '0', '0') 

        ")

this is work to bulid field but without title and desc.
and another thing : I want displayorder column = profilefieldid like when I add a field by admincp/profilefield.php

I try to insert phrase to be like this:
varname: fieldx_title (which x is field id but I don't know how to find it)
fieldname: cprofilefield

I need help please :)

Lynne

02-16-2009 03:41 PM

Did you try looking at the code that vb uses when creating a profile field?

After you insert the profilefield, you may grab the profilefield id:

PHP Code:


		
			
$id = $vbulletin->db->insert_id();

And then use $id.

al3bed

02-17-2009 01:32 AM

you are great Lynne

thanks a lot :)

--------------- Added [DATE]1234846546[/DATE] at [TIME]1234846546[/TIME] ---------------

I have another problem :o

if I want to delete these rows I will use this:

PHP Code:


		
			
$db->query_write("

            DELETE FROM " . TABLE_PREFIX . "profilefield 

            WHERE profilefieldid = " . $id

            );

        

$db->query_write("

            DELETE FROM " . TABLE_PREFIX . "phrase

            WHERE fieldname = 'cprofilefield' AND

            varname IN ('field" . $id . "_title', 'field" . $id . "_desc')

        ");

but it's not working?!

is that becuase $id is not recognized ? cause the first code in install code section and this one in uninstall code ?

Lynne

02-17-2009 04:02 AM

$id just grabs the id of the last row entered into the database. So, you can only use it if you just added a row into the database and then grabbed the id of that row. Install and Uninstall queries are not run one after the other. They are totally separate because you are either installing or uninstalling.

al3bed

02-17-2009 04:29 AM

ok, but I need that id to use it with other plugin in my product is there an method to save it?

like $myid = $id ?

Dismounted

02-17-2009 04:38 AM

The ID is usually provided by the user or another database field (e.g. a user clicking a link). Not sure what you're trying to achieve.

al3bed

02-17-2009 05:17 AM

hi Dismounted and thanx

I want to build a user field automaticly when my product is uploaded via plugins system. I success to build it gree Lynne.

Now I can't use the information inside the field if I don't know the id? you got it!

I succeed to build a full field with title and desc because id help me .. now I want that id to be with me all the time not just after added a row.. This is my problem. :D

Lynne

02-17-2009 02:03 PM

It sounds like you will have to do a query to ask what the field id is before you go and delete the fields.

All times are GMT. The time now is 07:04 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01007 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: