[redlabour]

Originally Posted by nicedreams

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

Does not work :

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 :

<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_ ?