{ if($_POST ['pol' ]== 0) $pol = '0' ;else $pol ='1' ; mysql_query ("INSERT INTO `kolhoz_user` SET `nick` = '" . my_esc( $_POST ['nick' ])."', `password`= '" . md5( $_POST ['password' ]). "', `pol`= ' $pol ', `email` = '" . my_esc (strtolower ($_POST ['email' ])). "', `money`= '3000000', `rubies` ='50000', `status` = '".(mysql_result ( mysql_query ("SELECT COUNT(*) FROM `kolhoz_user`" ), 0 )== 0? 3: 0 ). "'"); $_SESSION ['id_user' ]=mysql_insert_id(); $_SESSION ['pass' ]=md5( $_POST ['password' ]); $text= "Добро пожаловать вигру Лучший колхоз.Хорошей игры!" ; mysql_query ("INSERT INTO `kolhoz_mail` SET `id_user` = ' $_SESSION [id_user ] ', `id_kont` ='0', `msg` = ' $text ', `time` = '" .time ()."', `type` = 'to'" ) or die ( mysql_error ()); if(isset( $_SESSION [refer ])){ $control = mysql_fetch_array( mysql_query ("SELECT * FROM `kolhoz_user` WHERE `id` = '" . intval ( $_SESSION ['refer' ]). " ' " )); if($control ['ip' ]!== $_SERVER [ 'REMOTE_ADDR' ]){ mysql_query ("UPDATE `kolhoz_user` SET `count_ref` = ' $control [count_ref ] ' +'1' WHERE`id` = '" .intval ($_SESSION ['refer' ]). "' " ) or die(mysql_error ()); mysql_query ("UPDATE `kolhoz_user` SET `refi` = ' $control [id] ' WHERE `id` = ' $_SESSION [id_user ] ' " ) or die ( mysql_error ()); } } redirect( '?myfarm' ); }