<?
   

1.   clan.php
<div class='content'>
<a href='/clan_q.php'><img src='/images/icon/clan.png' alt='*'/>   </a>
</div><div class='line'></div>

2.
  arena.php
  // Place
    // 1 - 
    // Type
    // 0 -  n- -  (   )
    // 1 -  
    $q = mysql_query ('select * from `clan_q` WHERE (`clan`="'.$clan['id'].'") AND (`user`="'.$user['id'].'") AND (`user2`="'.$user['id'].'") AND (`complete`="0")');
    if (mysql_num_rows ($q) != 0) {
        
        while ($clan_q = mysql_fetch_array ($q)) {
                
            // 
            $q_ = mysql_query ('SELECT * FROM `clan_quest` WHERE (`id`="' . $clan_q['q'] . '")');
            $quest = mysql_fetch_array ($q_);
            
            if ($clan_q['c'] < $quest['c']) {
                if ($quest['place']=='1') {
                
                
                    if ($quest['type']=='0') {
                    
                        mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                    }
                
                    if ($quest['type']=='1') {
                        
                        if($dmg > $opponent_dmg) {
                        
                            mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                            
      }                   
     }                
    }                     
   }
  }
 }

    
    /////////////////////////////////////
3.
      coliseum.php
  // Place 
    // 2 - 
    // Type
    // 0 -  n- -  (   )
    // 1 -  
    $q = mysql_query ('select * from `clan_q` WHERE (`clan`="'.$clan['id'].'") AND (`user`="'.$user['id'].'") AND (`user2`="'.$user['id'].'") AND (`complete`="0")');
    if (mysql_num_rows ($q) != 0) {
        
        while ($clan_q = mysql_fetch_array ($q)) {
                
            // 
            $q_ = mysql_query ('SELECT * FROM `clan_quest` WHERE (`id`="' . $clan_q['q'] . '")');
            $quest = mysql_fetch_array ($q_);
            
            if ($clan_q['c'] < $quest['c']) {
                if ($quest['place']=='2') {
                
                
                    if ($quest['type']=='0') {
                    
                        mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                    }
                
                    if ($quest['type']=='1') {
                        
                        if($dmg > $opponent_dmg) {
                        
                            mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                            
      }                   
     }                
    }                     
   }
  }
 }
    /////////////////////////////////////////////////////////////
4.
      duel.php
  // Place
    // 1 - 
    // Type
    // 0 -  n- -  (   )
    // 1 -  
    $q = mysql_query ('select * from `clan_q` WHERE (`clan`="'.$clan['id'].'") AND (`user`="'.$user['id'].'") AND (`user2`="'.$user['id'].'") AND (`complete`="0")');
    if (mysql_num_rows ($q) != 0) {
        
        while ($clan_q = mysql_fetch_array ($q)) {
                
            // 
            $q_ = mysql_query ('SELECT * FROM `clan_quest` WHERE (`id`="' . $clan_q['q'] . '")');
            $quest = mysql_fetch_array ($q_);
            
            if ($clan_q['c'] < $quest['c']) {
                if ($quest['place']=='3') {
                
                
                    if ($quest['type']=='0') {
                    
                        mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                    }
                
                    if ($quest['type']=='1') {
                        
                        if($dmg > $opponent_dmg) {
                        
                            mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                            
      }                   
     }                
    }                     
   }
  }
 }

    ////////////////////////////////////////////////
    
      farm.php
5.
    // Place
    // 4 - 
    // Type
    // 0 -  n- -  (   )
    // 1 -  
    $q = mysql_query ('select * from `clan_q` WHERE (`clan`="'.$clan['id'].'") AND (`user`="'.$user['id'].'") AND (`user2`="'.$user['id'].'") AND (`complete`="0")');
    if (mysql_num_rows ($q) != 0) {
        
        while ($clan_q = mysql_fetch_array ($q)) {
                
            // 
            $q_ = mysql_query ('SELECT * FROM `clan_quest` WHERE (`id`="' . $clan_q['q'] . '")');
            $quest = mysql_fetch_array ($q_);
            
            if ($clan_q['c'] < $quest['c']) {
                if ($quest['place']=='4') {
                
                
                    if ($quest['type']=='0') {
                    
                        mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                    }
                
                    if ($quest['type']=='1') {
                        
                        if($dmg > $opponent_dmg) {
                        
                            mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                            
      }                   
     }                
    }                     
   }
  }
 }

    
    
   /////////////////////////////////////////////
6.    
      cave.php
  // Place
    // 5 - 
    // Type
    // 0 -  n- -  (   )
    // 1 -  
    $q = mysql_query ('select * from `clan_q` WHERE (`clan`="'.$clan['id'].'") AND (`user`="'.$user['id'].'") AND (`user2`="'.$user['id'].'") AND (`complete`="0")');
    if (mysql_num_rows ($q) != 0) {
        
        while ($clan_q = mysql_fetch_array ($q)) {
                
            // 
            $q_ = mysql_query ('SELECT * FROM `clan_quest` WHERE (`id`="' . $clan_q['q'] . '")');
            $quest = mysql_fetch_array ($q_);
            
            if ($clan_q['c'] < $quest['c']) {
                if ($quest['place']=='5') {
                
                
                    if ($quest['type']=='0') {
                    
                        mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                    }
                
                    if ($quest['type']=='1') {
                        
                        if($dmg > $opponent_dmg) {
                        
                            mysql_query ('UPDATE `clan_q` SET `c`=`c`+1 WHERE (`clan`="'.$clan['id'].'") AND (`user`="' . $user['id'] . '") AND (`q`="' . $quest['id'] . '")');
                            
      }                   
     }                
    }                     
   }
  }
 }

 //////////////////////////////////////////////////
7.      table.sql
8.   clan_quest_deleted.php      23.59 
    
    .................
    
    
?>  