Talenspec Icons for Deathknight missing in 2.0.1

by **Ulminia** » Wed Dec 10, 2008 5:50 pm

check the cp lua save file make sure they are in there but my updates should not have affected the talents in any way just made them display the new tree lengths

by **maqjav** » Thu Dec 11, 2008 1:38 am

I tried your update and when I try to upload my CP.lua I got this error:

1146: Table 'db215887549.roster_currency' doesn't exist
SQL:
SELECT * FROM `roster_currency` WHERE `member_id` = '47'
File: lib/dbal/mysql.php
Line: 234

by **Ulminia** » Thu Dec 11, 2008 3:32 am

..... RTF (read the forum) the fix for this was stated allready... in the inital post ....

but here is the table for currency

Code: Select all: CREATE TABLE IF NOT EXISTS `roster_currency` ( `member_id` int(10) unsigned NOT NULL default '0', `catagory` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `icon` varchar(255) default NULL, `tooltip` varchar(255) default NULL, `count` varchar(255) NOT NULL default '0', `type` varchar(255) default '', PRIMARY KEY (`member_id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and make sure

Code: Select all: function do_currency( $memberId, $data ) { global $roster; $currency = $data['Currency']; $messages = '<li>Updating Currency'; $querystr = "SELECT * FROM `" . $roster->db->table('currency') . "` WHERE `member_id` = '$memberId' "; //echo $querystr.'<br>'; $result = $roster->db->query($querystr); if( !$result ) { $this->setError('Cannot select Companion Data',$roster->db->error()); return; } if( $roster->db->num_rows( $result ) >= 1 ) { $update = true; } else { $update = false; } //$this->reset_values(); foreach ($currency as $type => $info) { foreach ($info as $inf => $in) { //echo ''.$type.' - '.$in['Type'].'- '.$in['Name'].'- '.$in['Tooltip'].'- '.$in['Count'].' (*)<br>'; $this->reset_values(); $querystr = "SELECT * FROM `" . $roster->db->table('currency') . "` WHERE `name` = '".addslashes($in['Name'])."' and `member_id` = '$memberId' "; //echo $querystr.'<br>'; $result = $roster->db->query($querystr); if( !$result ) { $this->setError('Cannot select Companion Data',$roster->db->error()); return; } if( $roster->db->num_rows( $result ) == 1 ) { $update = true; } else { $update = false; } $this->add_value( 'member_id', $memberId ); $this->add_value( 'type', $in['Type'] ); $this->add_value( 'catagory', $type ); $this->add_value( 'name', addslashes($in['Name']) ); //$this->add_value( '', $id ); $this->add_value( 'count', $in['Count'] ); if( !empty($in['Tooltip']) ) { $this->add_value( 'tooltip', $in['Tooltip'] ); } //$this->add_value( '', $data['CreatureID'] ); if( !empty($in['Icon']) ) { $this->add_value('icon', $this->fix_icon($in['Icon']) ); } $messages .= '.'; if( $update ) { $querystr = "UPDATE `" . $roster->db->table('currency') . "` SET " . $this->assignstr . " WHERE `member_id` = '$memberId' and `name` = '".addslashes($in['Name'])."'"; $result = $roster->db->query($querystr); } else { $querystr = "INSERT INTO `" . $roster->db->table('currency') . "` SET " . $this->assignstr; $result = $roster->db->query($querystr); } if( !$result ) { $this->setError('Cannot update Currency Data',$roster->db->error()); return; } } } $this->setMessage($messages . '</li>'); }

is in the update.lib.php and "$this->do_currency( $memberId, $data );" is uncommented at the bottom and it should display some icons maybe missing just copy them from the icons dir

by **cwpc** » Thu Dec 11, 2008 4:30 am

I get this error

Code: Select all: 1064: 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 's Shard' and `member_id` = '15'' at line 1 SQL: SELECT * FROM `roster_currency` WHERE `name` = 'Stone Keeper's Shard' and `member_id` = '15' File: lib/dbal/mysql.php Line: 234

After i have made those changes and im doing a profile upload

by **Ulminia** » Thu Dec 11, 2008 5:06 am

open the update.lib.php and make sure that the select line in the do_currency is $querystr = "SELECT * FROM `" . $roster->db->table('currency') . "` WHERE `name` = '".addslashes($in['Name'])."' and `member_id` = '$memberId' "; the $in['Name'] has to have addslashes on it because of ' in the names