vb.org Archive - Profile Fields in Postbits

Page 2 of 2

Show 40 post(s) from this thread on one page

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Profile Fields in Postbits (https://vborg.vbsupport.ru/showthread.php?t=108344)

dirtycrow

04-18-2006 03:58 PM

just updated to new version. when i click update the field "show in Postbit under username" goes blank and changes are not saved.

emin3m

04-18-2006 04:01 PM

Quote:

Originally Posted by dirtycrow

just updated to new version. when i click update the field "show in Postbit under username" goes blank and changes are not saved.

uninstall previous version
install new version
refresh your admin panel
try then
weird error btw

jazde86

04-18-2006 07:26 PM

Hey, why you don't have the version number increased?

Is it possible to change the order of fields? I mean the begin of the manuelly fields.

IceBurn3000

04-18-2006 09:33 PM

Quote:

Originally Posted by emin3m

uninstall previous version
install new version
refresh your admin panel
try then
weird error btw

I had the same problem, attempted to do this, but when I tried to unininstall the product i got this error:

Code:

Database error in vBulletin 3.5.4:



Invalid SQL:

delete from vBb_datastore where title='showinpostbit' title='showunderus';



MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title='showunderus'' at line 1

Error Number : 1064

jazde86

04-19-2006 07:14 AM

Overwrite the new version, with the old code - than the uninstallation works.

emin3m

04-19-2006 02:14 PM

those having problem while uninstalling product, please goto edit product and change the uninstall code to this

Code:

$Query = "delete from ".TABLE_PREFIX."datastore where title='showinpostbit' or title='showunderus'";

$Query_Res=$vbulletin->db->query($Query);

then save and uninstall this product
download new and install it
sorry about this :knockedout:

Reeftanksonline

04-24-2006 06:52 PM

I cant get mine working and also I get an error to uninstall it.

snakes1100

04-24-2006 07:05 PM

Thanx....

bada_bing

04-24-2006 07:11 PM

Does this work for vb 3.5.4 ?

jazde86

04-24-2006 09:55 PM

Sure, it works well on vB 3.5.4. Most Plugins for 3.5.x are going well on it.

bada_bing

04-25-2006 03:32 PM

Great Hack.. Clicked install

Hiranmanu

05-16-2006 06:08 PM

Superb hack, been trying to find out how to do this.

Thanks alot keep up the good work

Clicked install

Reolien01

05-31-2006 05:30 AM

In the 1st image it shows up top "Show profile fields in Postbits". I don't even have that menu in my admincp. All i have is the User profile fields.

In summary, I can make new fields, delete and edit them, but I cannot set which will be shows in the postbit. Can anyone help?

dlan	06-07-2006 09:33 AM

So any update on Multiple-Selection Checkboxs?

redlabour

06-08-2006 03:55 PM

Will it work in the Future with vBulletin 3.6 ?

gsipromotions

06-30-2006 03:33 AM

Very kewl, I like this one.

Anyone know how I can make a new field text display as a clickable link?

redlabour

08-04-2006 05:11 AM

This Product does not work with 3.6. Will there be a Update soon ?

Quote:

Invalid SQL:
select title from vb3_profilefield where profilefieldid=2;

MySQL-Fehler : Unknown column 'title' in 'field list'
Fehler-Nr. : 1054

redlabour

08-06-2006 02:22 PM

Anybody out there ? ;)

redlabour

08-08-2006 10:11 AM

Quote:

Originally Posted by redlabour

Invalid SQL:
select title from vb3_profilefield where profilefieldid=2;

MySQL-Fehler : Unknown column 'title' in 'field list'
Fehler-Nr. : 1054

Can nobody else fix this for 3.6 ?

nicedreams

08-08-2006 12:54 PM

Quote:

Originally Posted by redlabour

Can nobody else fix this for 3.6 ?

I fixed it for 3.6.0. This is what I did:

PHP Code:


		
			
                $Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);

                $row2=$GLOBALS['vbulletin']->db->query_first($Query);

 

                $phrasefield = "field".$row2[profilefieldid]."_title";

                $wherephrase = " varname LIKE '$phrasefield' LIMIT 1";

                $Query2 = "select text FROM phrase WHERE" . $wherephrase;

                $custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);



$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];

Changed the query line by dropping the title. Added the 4 lines to get the title of the custom field from the phrases.

Jimmy

Wired1

08-08-2006 01:08 PM

This is similar to my dropdown hack that I created before this one existed, in October 2005. Mine doesn't require an additional SQL table, although it does require another hack I did, as well as some manual editing.

redlabour

08-09-2006 12:30 PM

Quote:

Originally Posted by Wired1

Link ?

And is this a Answer to get this work for 3.6 ? :cross-eyed:

nicedreams

08-09-2006 02:03 PM

Quote:

Originally Posted by nicedreams

I fixed it for 3.6.0. This is what I did:

PHP Code:


		
			
                $Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);

                $row2=$GLOBALS['vbulletin']->db->query_first($Query);

 

                $phrasefield = "field".$row2[profilefieldid]."_title";

                $wherephrase = " varname LIKE '$phrasefield' LIMIT 1";

                $Query2 = "select text FROM phrase WHERE" . $wherephrase;

                $custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);



$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];

Changed the query line by dropping the title. Added the 4 lines to get the title of the custom field from the phrases.

Jimmy

Forgot to mention this is in the PB - Postbits plugin code under plugins.

redlabour

08-10-2006 05:09 AM

Sorry but i have to "search for" and "replace it with" in the *.xml ?

redlabour

08-10-2006 07:38 PM

Quote:

Originally Posted by nicedreams

Forgot to mention this is in the PB - Postbits plugin code under plugins.

Does not work :

Quote:

Datenbankfehler in vBulletin 3.6.0:

Invalid SQL:
select text FROM phrase WHERE varname LIKE 'field2_title' LIMIT 1;

MySQL-Fehler : Table 'usrdb_poltbofu.phrase' doesn't exist
Fehler-Nr. : 1146
Datum : Thursday, August 10th 2006 @ 10:38:07 PM
Skript : http://www.politikstube.de/forum/showthread.php?p=48675
Referrer : http://www.politikstube.de/forum/new...newthread&f=34
IP-Adresse : 88.130.109.124
Benutzername : redlabour
Klassenname : vb_database

Here is the edited code :

Quote:

<title>PB - Postbits</title>
<hookname>postbit_display_complete</hookname>
−
<phpcode>
$Query = "select data from ".TABLE_PREFIX."datastore where title='showinpostbit'";
$row=$GLOBALS['vbulletin']->db->query_first($Query);
$toshow=explode(',',$row['data']);
foreach($toshow as $value){
if($this->post[$value]!=''){
$Query = "select type, profilefieldid from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);

$phrasefield = "field".$row2[profilefieldid]."_title";
$wherephrase = " varname LIKE '$phrasefield' LIMIT 1";
$Query2 = "select text FROM phrase WHERE" . $wherephrase;
$custom_titles=$GLOBALS['vbulletin']->db->query_first($Query2);

$this->post['posts']=$this->post['posts'].'</div><div><strong>' . $custom_titles['text'] . ':</strong> '.$this->post[$value];
}
}
$Query = "select data from ".TABLE_PREFIX."datastore where title='showunderus'";
$row=$GLOBALS['vbulletin']->db->query_first($Query);
$toshow=explode(',',$row['data']);
foreach($toshow as $value){
if($this->post[$value]!=''){
$Query = "select title from ".TABLE_PREFIX."profilefield where profilefieldid=".substr($value, 5);
$row2=$GLOBALS['vbulletin']->db->query_first($Query);
$this->post['rank']=$this->post['rank'].'</div><div class="smallfont">'.$row2[title].': '.$this->post[$value];
}
}

Did you forget the Tableprefix vb3_ ?

nicedreams

08-10-2006 08:06 PM

Quote:

Originally Posted by redlabour

Did you forget the Tableprefix vb3_ ?

I don't have a table prefix. But change the line to:

PHP Code:


		
			
$Query2 = "select text FROM ".TABLE_PREFIX."phrase WHERE" . $wherephrase;

emin3m

08-10-2006 10:46 PM

thanks nicedreams,
added the 3.6.0 version here
https://vborg.vbsupport.ru/showthread.php?t=123619

All times are GMT. The time now is 01:31 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02063 seconds Memory Usage 1,806KB 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 (2)bbcode_code_printable (3)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (27)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: