Talenspec Icons for Deathknight missing in 2.0.1

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Talenspec Icons for Deathknight missing in 2.0.1

Postby 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
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Talenspec Icons for Deathknight missing in 2.0.1

Postby 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
maqjav
WR.net Journeyman
WR.net Journeyman
 
Posts: 100
Joined: Wed Oct 18, 2006 2:38 pm

Talenspec Icons for Deathknight missing in 2.0.1

Postby 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
Attachments
currency update.rar
open the file paths are allready set
(1.48 MiB) Downloaded 65 times
Last edited by Ulminia on Thu Dec 11, 2008 3:47 am, edited 2 times in total.
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Talenspec Icons for Deathknight missing in 2.0.1

Postby 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
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

Talenspec Icons for Deathknight missing in 2.0.1

Postby 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
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Previous

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron