Различные вопросы по PHP и MySQL

Koenig (08.02.2012/20:13)
brendi, где вопрос? тебе нужен запрос в базу или код весь??

case "new":
            if (isset($_POST['submit'])) {


                $name = (trim($_POST['name']));
                $priz = (int)$_POST['priz'];
                $time = (int)$_POST['time'];
                $max_lvl = (int)$_POST['max_lvl'];

                if (!$name || !$priz || !$time || !$max_lvl) {
                    echo display_error('Пустые параметры!');
                    require_once ("../incfiles/end.php");
                    exit;
                }


                $handle = new upload($_FILES['imagefile']);
                if ($handle->uploaded) {
                    // Обрабатываем фото
                    $handle->file_new_name_body = $realtime;
                    //$handle->mime_check = false;
                    $handle->allowed = array('image/jpeg', 'image/gif', 'image/png');
                    $handle->file_max_size = 1024 * $set['flsz'];
                    $handle->file_overwrite = true;
                    $handle->image_resize = true;
                    $handle->image_x = 100;
                    $handle->image_ratio_y = true;
                    $handle->image_convert = 'jpg';
                    $handle->process('img/');
                    if ($handle->processed) {
                        // Обрабатываем превьюшку
                        $handle->file_new_name_body = $realtime . '_small';
                        $handle->file_overwrite = true;
                        $handle->image_resize = true;
                        $handle->image_x = 32;
                        $handle->image_ratio_y = true;
                        $handle->image_convert = 'jpg';
                        $handle->process('img/');
                        if ($handle->processed) {
		mysql_query("INSERT INTO fan_clubs SET id_lider='". $_POST['priz'] ."', img='". $realtime ."', name='".mysql_real_escape_string(mb_substr(trim($_POST['name']),0, 64))."', info='".$max_lvl."';");
                            header("Location: index.php");
                        } else {
                            echo display_error($handle->error);
                        }
                    } else {
                        echo display_error($handle->error);
                    }
                    $handle->clean();
                }
            } else {
                echo '<form enctype="multipart/form-data" action="?act=new" method="post">';
                echo '<div class="gmenu">';
                echo '<table cellpadding="2" cellspacing="0"><tr>';

                echo '<td><b>Имя</b></td><td><input type="text" name="name"  value="Кубок"/></td></tr><tr>';
                echo '<td><b>Дата</b></td><td><small>00.00.0000 00:00</small><br/><input type="text" name="time"  value="11.11.2011 10:00"/></td></tr><tr>';
                echo '<td><b>Приз</b></td><td><input type="text" name="priz"  value="5000"/></td></tr><tr>';
                echo '<td><b>Уровень</b></td><td><input type="text" name="max_lvl"  value="1"/></td></tr><tr>';
                echo '<td><b>Изображение</b></td><td><input type="file" name="imagefile" value="" /></td></tr><tr>';

                echo '</tr>';
                echo '</table>';

                echo '<p><input type="submit" name="submit" value="Добавить" /></p></div></form>';


            }


break;

$ipinf = !isset($arg['iphide']) && (self::$user_rights || ($user['id'] && $user['id'] == self::$user_id)) ? 1 : 0;  
        $lastvisit = time() > $user['lastdate'] + 300 && isset($arg['lastvisit']) ? self::display_date($user['lastdate']) : false;  
        if ($ipinf || $lastvisit || isset($arg['sub']) && !empty($arg['sub']) || isset($arg['footer'])) {  
            $out .= '<div class="sub">';  
            if (isset($arg['sub']))  
                $out .= '<div>' . $arg['sub'] . '</div>';  
            if ($lastvisit)  
                $out .= '<div><span class="gray">' . self::$lng['last_visit'] . ':</span> ' . $lastvisit . '</div>';  
            $iphist = '';  
            if ($ipinf) {  
                $out .= '<div><span class="gray">' . self::$lng['browser'] . ':</span> ' . $user['browser'] . '</div>' .  
                        '<div><span class="gray">' . self::$lng['ip_address'] . ':</span> ';  
                $hist = $mod == 'history' ? '&amp;mod=history' : '';  
                $ip = long2ip($user['ip']);  
                if (self::$user_rights && isset($user['ip_via_proxy']) && $user['ip_via_proxy']) {  
                    $out .= '<b class="red"><a href="' . self::$system_set['homeurl'] . '/' . self::$system_set['admp'] . '/index.php?act=search_ip&amp;ip=' . $ip . $hist . '">' . $ip . '</a></b> / ';  
                    $out .= '<a href="' . self::$system_set['homeurl'] . '/' . self::$system_set['admp'] . '/index.php?act=search_ip&amp;ip=' . long2ip($user['ip_via_proxy']) . $hist . '">' . long2ip($user['ip_via_proxy']) . '</a>';  
                } elseif (self::$user_rights) {  
                    $out .= '<a href="' . self::$system_set['homeurl'] . '/' . self::$system_set['admp'] . '/index.php?act=search_ip&amp;ip=' . $ip . $hist . '">' . $ip . '</a>';  
                } else {  
                    $out .= $ip . $iphist;  
                }  
                if (isset($arg['iphist'])) {  
                    $iptotal = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_users_iphistory` WHERE `user_id` = '" . $user['id'] . "'"), 0);  
                    $out .= '<div><span class="gray">' . self::$lng['ip_history'] . ':</span> <a href="' . self::$system_set['homeurl'] . '/users/profile.php?act=ip&amp;user=' . $user['id'] . '">[' . $iptotal . ']</a></div>';  
                }  
                $out .= '</div>';  
            }  
            if (isset($arg['footer']))  
                $out .= $arg['footer'];  
            $out .= '</div>';  
        }  
        return $out;  
    }