竹貓星球

代碼: 選擇全部

   /* BETA WOG In Viewtopic BEGIN*/    
   //get wog data start 
   $sql ="select wog_player.p_name,p_at,p_df,p_mat,p_pk_s,p_bbsid,p_id 
   ,p_mdf,p_at,p_df,p_s,p_g_id,p_str,p_life,p_smart,p_agl,p_au,p_be 
   ,p_hp,p_hpmax,p_lv,p_exp,p_nextexp,p_win,p_lost,p_sex 
   ,wog_character.ch_name,a.d_name as a_name,s.ch_name as s_ch_name 
   ,b.d_name,e.d_name as e_name,d.d_name as dd_name,c.d_name as c_name,f.d_name as item_name 
   ,g.g_name,g.g_adm_id1,g.g_adm_id2 
   from wog_player left join wog_character on wog_player.ch_id=wog_character.ch_id 
   left join wog_group_main g on wog_player.p_g_id=g.g_id 
   left join wog_character s on wog_player.p_ch_s_id=s.ch_id 
   left join wog_df a on wog_player.a_id=a.d_id 
   left join wog_df b on wog_player.d_body_id=b.d_id 
   left join wog_df e on wog_player.d_head_id=e.d_id 
   left join wog_df d on wog_player.d_hand_id=d.d_id 
   left join wog_df c on wog_player.d_foot_id=c.d_id 
   left join wog_df f on wog_player.d_item_id=f.d_id 
   where wog_player.p_bbsid=".$postrow[$i]['user_id'].""; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
        message_die(GENERAL_ERROR, 'Could not query wog', '', __LINE__, __FILE__, $sql); 
   } 
   $getwog = $db->sql_fetchrow($result); 
   //get wog data end 
      $p_game = $getwog['g_name']; 
   if (isset($getwog['p_bbsid'])){ 
      $exptemp = 100*($getwog['p_exp'] / $getwog['p_nextexp']); 
      $hptemp = 100 *($getwog['p_hp'] / $getwog['p_hpmax']); 
      $physic = 50 *($getwog['p_at'] / 4500 + $getwog['p_mat'] / 4500); 
      $magic = 50 *($getwog['p_mat'] / 4500 + $getwog['p_mdf'] / 4500); 
   if ($physic >100){$physic=100;} 
      $exptemp = sprintf("%01.2f", $exptemp); 
      $hptemp = sprintf("%0.0f", $hptemp); 
      $physic = sprintf("%01.0f", $physic); 
      $magic = sprintf("%01.0f", $physic); 
   } 

   if ($getwog['p_lv'] < 10){$getwog['p_lv'] = '<font color=seagreen>'.$lang['LV_10'].'</font>';} 
   if ($getwog['p_pk_s'] == 0){$p_pk_s='<font color=royalblue>'.$lang['PK_OFF'].'</font>';}else{$p_pk_s='<font color=crimson>'.$lang['PK_ON'].'</font>';} 
   switch($getwog['p_id']) 
      { 
         case $getwog['g_adm_id1']: 
         $p_game = '<font color=crimson>'.$getwog['g_name'].'</font>'; 
         break; 
         case $getwog['g_adm_id2']: 
          $p_game = '<font color=royalblue>'.$getwog['g_name'].'</font>'; 
         break; 
      } 
   if ($getwog['p_g_id'] == 0){$p_game = '<font color=royalblue>'.$lang['NO_Group'].'</font>';} 
   switch($getwog['p_sex']) 
      { 
         case "1": 
          $fontcolor = '<font color=royalblue>'; 
         break; 
         case "2": 
          $fontcolor = '<font color=crimson>'; 
         break; 
      } 
   if ($getwog['p_sex'] != $postrow[$i]['user_gender']){$fontcolor = '<font color=pink>';} 
    
   if (isset($getwog['p_bbsid'])){    
   $viewstatus = '<span class="gensmall"> '.$lang['P_Job'].': ' . $getwog['ch_name'] . ' <font color=red>' . $getwog['s_ch_name'] . '</font><br />' . 
         ''.$lang['P_LV'].': ' . $getwog['p_lv'] . '<br />' . "
". 
         ''.$lang['P_Group'].': ' . $p_game . '<br />'. 
         '' . $p_pk_s . ' </span>' . "
".          
         '<table width="100" border="0" cellpadding="0" cellspacing="0">' . "
". 
         '<tr><td width="100%">' . "
". 
         '<table width="100%" border="0" cellspacing="0" cellpadding="0">' . "
".          
         '<tr><td><img src="images/level_mod/s_quality.gif" alt='.$lang['P_EXP'].'><span class="gensmall"><font color=royalblue>'.$lang['P_EXP'].':<font></span></td></tr>' . "
". 
         '<tr><td bgcolor=#BDBDBD><img src="images/level_mod/beg.gif" width=' . $exptemp . ' height="5" alt='.$exptemp.'% /><img src="images/level_mod/beg.gif" alt="" width="4" height="5" /></td></tr>' . "
". 
         '<tr><td><img src="images/level_mod/s_state.gif" alt='.$lang['P_HP'].'><span class="gensmall"><font color=crimson>'.$lang['P_HP'].':<font></span></td></tr>' . "
". 
         '<tr><td bgcolor=#BDBDBD><img src="images/level_mod/bhg.gif" width=' . $hptemp . ' height="5" alt='.$hptemp.'% /><img src="images/level_mod/bhg.gif" alt="" width="4" height="5" /></td></tr>' . "
". 
         '<tr><td><img src="images/level_mod/s_equipment.gif" alt='.$lang['P_physic'].'><span class="gensmall"><font color=seagreen>'.$lang['P_physic'].':</font></span></td></tr>' .  "
". 
         '<tr><td bgcolor=#BDBDBD><img src="images/level_mod/bmg.gif" width=' . $physic . ' height="5" alt='.$physic.'% /><img src="images/level_mod/bmg.gif" alt="" width="4" height="5" /></td></tr>' . "
". 
         '<tr><td><img src="images/level_mod/s_equipment.gif" alt='.$lang['P_magic'].'><span class="gensmall"><font color=royalblue>'.$lang['P_magic'].':</font></span></td></tr>' . "
". 
         '<tr><td bgcolor=#BDBDBD><img src="images/level_mod/bxg.gif" width=' . $physic . ' height="5" alt='.$physic.'% /><img src="images/level_mod/bxg.gif" alt="" width="4" height="5" /></td></tr>' . "
". 
         '<tr><td><img src="images/spacer.gif" alt="" width="20" height="8" /></td></tr></table>' . "
". 
         '</td></tr></table>' . 
         '<span class="gensmall">'.$fontcolor.''.$lang['P_Head'].': ' . $getwog['e_name'] . '<br />' . 
         ''.$lang['P_Body'].': ' . $getwog['d_name'] . '<br />' . 
         ''.$lang['P_Hand'].': ' . $getwog['dd_name'] . '<br />' . 
         ''.$lang['P_Weapon'].': ' . $getwog['a_name'] . '<br />' . 
         ''.$lang['P_Boot'].': ' . $getwog['c_name'] . '<br />' . 
         ''.$lang['P_Item'].': ' . $getwog['item_name'] . '</font></span><br />' . "
"; 
   } 
   else{ 
   $viewstatus='<span class="gensmall"><font color=royalblue>'.$lang['UNJoin'].'</font></span>'; 
   }    
   unset($getwog); 
   /* BETA WOG In Viewtopic END*/