Member.php File change from vbulletin.com

[hotwheels]

I am not sure if anyone else has noticed, but in vbulletin 3.6, there is a change in the member.php file that affect's how mod's are going to be written, and i am not sure if this is the case in 3.6.1 since i am not running that version.

Anyways, in the past our member.php and a few other file's had this:

PHP Code:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read("
 SELECT profilefieldid, required, title, type, data, def, height
 FROM " . TABLE_PREFIX . "profilefield
 WHERE form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
  AND hidden = 0") . "
 ORDER BY displayorder
"); 


This above example is from 3.5, 3.0, etc. (please notice the word title in the above query), now in 3.6

PHP Code:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
 SELECT profilefieldid, required, type, data, def, height
 FROM " . TABLE_PREFIX . "profilefield
 WHERE form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
  AND hidden = 0") . "
 ORDER BY displayorder
"); 


As you can see, the word "title" no longer exist's and therefore is not available to modify when it come's to running a query for your profilefield.

I asked over at vbulletin.com about how to go about reinstalling this word back into our Vbulletin 3.6 version's and this was the response i recieved:

Originally Posted by feldon23

This kind of question is reserved for vBulletin.org.

My response back:

Originally Posted by hotwheels

That is an interesting thought, but .org didn't write the member.php. The line used to be in our vbulletin 3.5, but i am not seeing it in 3.6. So i figured it was moved to a different php file and i was just overlooking something.

Final vbulletin.com response:

Originally Posted by feldon23

Modification or dependance upon the behavior of the vBulletin code, at an underlying level, such as database access, is the purview of vBulletin.org. The fact that it is affecting you means that you are writing a program, plug-in, or other module which depends upon this table to have certain columns. I certainly understand your plight.

vBulletin.org is all about modifying and leveraging the vBulletin source code to add functionality to vBulletin.

Anyone using vBulletin without plugins, products, or code changes would not even be aware of the database change.

So, here i am.......can anyone explain how we can go about adding custom fields via an .xml file, when the word "title" is no longer a fieldset? There have been a few mod's i have been looking to redo, but with no body at this point answering my question, i am at a loss on what to do.
If this can't be put back in, is there a new field set we look at writting when it come's to performing query write's (Insert Into)......?

Thanks, doug

[Colin F]

The title is now phrased, to allow translation into different languages, which is why it was removed from that query.
You'd have to adjust the appropriate phrase with the languageid 0 to change it.

[hotwheels]

could this please be moved to programming discussions? I believe i posted in the wrong spot. I posted an earlier request only to find the post deleted, instead of moving this one to that requested forum.

Originally Posted by peterska2

Hello hotwheels,

I have deleted your thread "Wonder if this post of mine should be here instead" due to:

=====================
cross-posting
=====================


Greetings,

peterska2

and i could not ask the person that removed it, to move this to the appropriate section

Originally Posted by peterska2

1. peterska2 has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

Thanks a million.

so colin, would that mean that any phrase's i add to the hack, would have to be set to languageid 0? Or is that somewhere within a class file?

Guess i am not really sure about all of the complete change's to 3.6 yet.

But in order to add "title" back to "// CUSTOM PROFILE FIELDS" in member.php or just to get this order in mysql database like so: profilefieldid, required, title, type, data, def, height. I was just hoping there would be an easier way to write an xml and have it preform it's "insert into" function.
I am sure there is just something i am not seeing.....or overlooking.

[Marco van Herwaarden]

Like Colin mentioned, the title is not stored in the profilefield table anymore. You could add a column with that name into the table again, but that column would nowhere within vBulletin be used, so that would be useless. Colin explained that the title text is now inserted into the phrases to allow translations.

Your other thread was removed for Cross-Posting: posting the same thread in 2 forums. It doesn't make sense to have the same question in 2 places.

[hotwheels]

It doesn't make sense to have the same question in 2 places.

I didn't have the same post in two area's, i made another post where i thought this post should be, asking to have the post moved to that spot, since i wasn't able to tell anyone that i needed it moved. I couldn't pm a mod, because they ask not to be pm'd....so i was kind of in a hard spot trying to get my post moved.
Which really doesn't matter, it is in the right spot now.......

So if i am understanding what you are saying, i would have to Insert a phrase, for what i want now, instead of the title of what i am wanting?

Say i want the title, "run"? That would now be a phrase? And it would become a custom field?

K, now if the title field is no longer available, that means' we can no longer make a query insert like this:

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 (00,'".addslashes($??)."','".addslashes($?)."',0,0,'20','20','50','1','input','','0','0','0','0','0','0','','0')"); 


We would now have to make the insert's manually in the Phrase section in the admin control panel, then go to the profilefield within the admin panel and manually set what we are calling for?