get_results("SELECT `id`, `ads_name`, `ads_url`, `block_width`, `block_height`, `ads_link_url`, `new_window`, `trace_clicks`, `time_management`, `start_date`, `end_date`, `limit_clicks`, `click_amount`, `clicks_left`, `clicks_done` FROM `".$wpdb->prefix."adv_v_base`;"); foreach ($res as $res1){ echo '
Ads name: '.$res1->ads_name.'

Ads image url: '.$res1->ads_url.'

Ads size: '.$res1->block_width.' x '.$res1->block_height.'

Ads URL: '.$res1->ads_link_url.'

New Window: '; if($res1->new_window == 1) echo 'Turned On'; else echo 'Turned Off'; echo '

Trace clicks: '; if($res1->trace_clicks == 1) echo 'Turned On'; else echo 'Turned Off'; echo '

Time management: time_management == 1) echo ' class="turn_on" '; else echo ' class="turn_off" '; echo ' id="time_management_'.$res1->id.'">'; if($res1->time_management == 1) echo 'Turned On'; else echo 'Turned Off'; echo ' '.$res1->start_date.' - '.$res1->end_date.'

Click Limit: '; if($res1->limit_clicks == 1) echo 'Turned On'; else echo 'Turned off'; echo ' '.$res1->click_amount.'

Clicks Left : '.$res1->clicks_left.'

Clicks Done : '; if(!$res1->clicks_done) echo 'No clicks'; else echo ''.$res1->clicks_done.''; echo '

'; } ?>