Есть вот такой запрос Код (PHP): $sql = $db->super_query("SELECT user_referals, user_ref_count FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $sqls = $db->super_query("SELECT user_id FROM `".PREFIX."_users` WHERE user_id IN ({$sql['user_referals']}) AND user_subscription_!='' ",1); $allId = sql_IN($sqls, 'user_id'); Прочитал, что новый mysql не использует "IN" и у меня выводит ошибку Код (PHP): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND user_subscription_!=''' at line 1 -----SELECT user_id FROM `vii_users` WHERE user_id IN () AND user_subscription_!='' Чем могу заменить IN? PHP, JavaScript, SQL и другой код пишите внутри тегов Код ( (Unknown Language)): [b]php][/b]Тут код[b][/[/b][b]code][/b][/color]
Где такую чушь прочитали? Ошибка - потому что после in скобки пустые, должно быть хотя бы одно значение
на ответах мейла прочитал, так и знал, там ничего путного не напишут) Добавлено спустя 1 минуту 4 секунды: т.е тут Код (Text): {$sql['user_referals']} запрос не выводит значения?
https://dev.mysql.com/doc/refman/5.7/en/func-op-summary-ref.html https://dev.mysql.com/doc/refman/5.7/en/comparison-operator ... unction_in Читай http://phpfaq.ru/debug
Спасибо, прочитал) Но почему не могу использовать два запроса в одном? Код (Text): $sqls = $db->super_query("SELECT user_id FROM `".PREFIX."_users` WHERE user_id IN (SELECT user_referals, user_ref_count FROM `".PREFIX."_users` WHERE user_id='{$user_id}') AND user_subscription_!='' ",1);
raikage какие два запроса? Там под запрос, читай debug и выводи текст sql запроса, проверь его на правильность, если не сможешь, то напиши его сюда. Код который ты дал, это формирования запроса, но не он сам.
Все таки не разобрался почему user_id IN ({$sql['user_referals']}) выводит пустую строку.. Вроде выше написан запрос на вывод из базы Код (Text): if(!defined('MOZG')) die('Haking'); $act = $_GET['act']; $user_id = $user_info['user_id']; switch($act){ case"ref_calc": $tpl->load_template('referals/calc.tpl'); $tpl->compile('content'); break; case"ref_search": $tpl->load_template('referals/search.tpl'); $tpl->compile('content'); break; case"send": $v = intval($_POST['v']); $count = intval($_POST['count']); $sql = $db->super_query("SELECT user_referals, user_ref_count FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $sqls = $db->super_query("SELECT user_id FROM `".PREFIX."_users` WHERE user_id IN ({$sql['user_referals']}) AND user_subscription_!='' ",1); $allId = sql_IN($sqls, 'user_id'); if($count <= total_active($allId) ){ $db->query("INSERT INTO `".PREFIX."_admin_pay` SET pay_usid='{$user_id}',pay_count='{$count}',pay_version='{$v}'"); die('ok'); }else die('err'); break; case"ref_search_ajax": $query = textFilter($_POST['query']); $sql = $db->super_query("SELECT tb1.reflist_us_id,tb2.user_id, user_search_pref, user_photo FROM `".PREFIX."_ref_list` tb1,`".PREFIX."_users` tb2 WHERE tb2.user_search_pref LIKE '%{$query}%' AND tb2.user_id=tb1.reflist_us_id ORDER BY user_id DESC LIMIT 20",1); $tpl->load_template('referals/users.tpl'); foreach($sql as $row) { $tpl->set('{user_id}', $row['user_id']); $tpl->set('{user_search_pref}', $row['user_search_pref']); $tpl->set('{user_photo}', user_avatar($row['user_photo'], $row['user_id'], 50)); $tpl->compile('content'); } die($tpl->result['content']); break; //############ Вывод не оплативших пользователей ############// case"ajax_people": $post = intval($_POST['i']); if($post < 0 || $post > 5) die(); $sql = $db->super_query("SELECT user_referals FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $queryArray = array(); if($sql) { $queryArray[0] = json_decode(circles($sql['user_referals'],1), true); if($one_circle['refs'] != ''){ $queryArray[1] = json_decode(circles( $one_circle['refs'],1 ), true); if($two_circle['refs'] != ''){ $queryArray[2] = json_decode(circles( $two_circle['refs'],1 ), true); if($three_circle['refs'] != ''){ $queryArray[3] = json_decode(circles( $three_circle['refs'],1 ), true); if($four_circle['refs'] != ''){ $queryArray[4] = json_decode(circles( $four_circle['refs'],1 ), true); } } } } } die($queryArray[$post]['tpl']); break; case"ref_history": $s = $db->super_query("SELECT user_referals FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $sql = $db->super_query("SELECT user_id, user_search_pref, user_photo, user_referals FROM `".PREFIX."_users` WHERE user_id IN ({$s['user_referals']})",1); $tpl->load_template('referals/friend.tpl'); foreach($sql as $row){ $tpl->set('{user-id}', $row['user_id']); $tpl->set('{name}', $row['user_search_pref']); $tpl->set('{ava}', user_avatar($row['user_photo'], $row['user_id'], 50)); $tpl->compile('users'); } $tpl->load_template('referals/history.tpl'); $tpl->set('{users}', $tpl->result['users']); $tpl->compile('content'); break; //############# Страница вывода приглашенных ############// case"ref_people": $sql = $db->super_query("SELECT user_referals, user_ref_count FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $sqls = $db->super_query("SELECT user_id FROM `".PREFIX."_users` WHERE user_id IN ({$sql['user_referals']}) AND user_subscription_!='' ",1); $allId = sql_IN($sqls, 'user_id'); $zero_circle = array('count' => count(explode(',', $allId)), 'refs' => $allId); if($sql) { $one_circle = json_decode(circles($sql['user_referals']), true); if($one_circle['refs'] != ''){ $two_circle = json_decode(circles( $one_circle['refs'] ), true); if($two_circle['refs'] != ''){ $three_circle = json_decode(circles( $two_circle['refs'] ), true); if($three_circle['refs'] != ''){ $four_circle = json_decode(circles( $three_circle['refs'] ), true); if($four_circle['refs'] != ''){ $five_circle = json_decode(circles( $four_circle['refs'] ), true); } } } } } $tpl->load_template('referals/peoples.tpl'); $tpl->set('{all_people}',$sql['user_ref_count']); $tpl->set('{active_people}', $zero_circle['count']); $tpl->set('{all_people2}',$two_circle['countAll'] ? $two_circle['countAll'] : 0); $tpl->set('{active_people2}', $two_circle['countAlls'] ? $two_circle['countAlls'] : 0); $tpl->set('{all_people3}',$three_circle['countAll'] ? $three_circle['countAll'] : 0); $tpl->set('{active_people3}', $three_circle['countAlls'] ? $three_circle['countAlls'] : 0); $tpl->set('{all_people4}',$four_circle['countAll'] ? $four_circle['countAll'] : 0); $tpl->set('{active_people4}', $four_circle['countAlls'] ? $four_circle['countAlls'] : 0); $tpl->set('{all_people5}', $five_circle['countAll'] ? $five_circle['countAll'] : 0); $tpl->set('{active_people5}', $five_circle['countAlls'] ? $five_circle['countAlls'] : 0); $tpl->set('{one_circle}', $one_circle['tpl'] ? $one_circle['tpl'] : ''); $tpl->set('{two_circle}', $two_circle['tpl'] ? $two_circle['tpl'] : ''); $tpl->set('{three_circle}', $three_circle['tpl'] ? $three_circle['tpl'] : ''); $tpl->set('{four_circle}', $four_circle['tpl'] ? $four_circle['tpl'] : ''); $tpl->set('{five_circle}', $five_circle['tpl'] ? $five_circle['tpl'] : ''); $tpl->compile('content'); break; default: $ref = $db->super_query("SELECT ref_balance, ref_count_people, ref_referer FROM `".PREFIX."_referals` WHERE ref_user_id='{$user_id}'"); $sql = $db->super_query("SELECT user_referals, user_ref_count FROM `".PREFIX."_users` WHERE user_id='{$user_id}'"); $sqls = $db->super_query("SELECT user_id FROM `".PREFIX."_users` WHERE user_id IN ({$sql['user_referals']}) AND user_subscription_!='' ",1); $allId = sql_IN($sqls, 'user_id'); if($ref['ref_referer']) { $us = $db->super_query("SELECT user_search_pref, user_photo FROM`".PREFIX."_users` WHERE user_id='{$ref['ref_referer']}'"); } $tpl->load_template('referals/referals.tpl'); $tpl->set('{count}', total_active($allId)); $tpl->set('{all_count}', $sql['user_ref_count']); $tpl->set('{ref_balance}', $ref['ref_balance']); $tpl->set('{ref_count_people}', $ref['ref_count_people']); $tpl->set('{ref_referer}', $ref['ref_referer']); $tpl->set('{user_search_pref}', $us['user_search_pref']); $tpl->set('{user_photo}', user_avatar($us['user_photo'],$us['ref_referer'],50)); $tpl->compile('content'); }
Вот все нужные таблицы.. Я все еще не могу решить проблему, помогите плиз, в долгу не останусь Код (Text): -- -- Структура таблицы `vii_admin_pay` -- CREATE TABLE IF NOT EXISTS `vii_admin_pay` ( `pay_id` int(11) NOT NULL AUTO_INCREMENT, `pay_usid` int(11) NOT NULL, `pay_count` int(11) NOT NULL, `pay_version` int(11) NOT NULL, `pay_type` int(11) NOT NULL, PRIMARY KEY (`pay_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Структура таблицы `vii_payments` -- CREATE TABLE IF NOT EXISTS `vii_payments` ( `pay_id` int(11) NOT NULL AUTO_INCREMENT, `pay_user_id` int(11) NOT NULL, `pay_date` int(11) NOT NULL, `pay_prefix` int(11) NOT NULL, `pay_total` varchar(255) NOT NULL, `pay_type` int(11) NOT NULL, `pay_count_month` int(11) NOT NULL, PRIMARY KEY (`pay_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ; -- -- Структура таблицы `vii_referals` -- CREATE TABLE IF NOT EXISTS `vii_referals` ( `ref_referer` int(11) NOT NULL, `ref_user_id` int(11) NOT NULL, `ref_count_people` int(11) NOT NULL, `ref_balance` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Структура таблицы `vii_ref_list` -- CREATE TABLE IF NOT EXISTS `vii_ref_list` ( `reflist_id` int(11) NOT NULL, `reflist_us_id` int(11) NOT NULL, `reflist_fr_id` int(11) NOT NULL, `ref_date` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Структура таблицы `vii_users` -- CREATE TABLE IF NOT EXISTS `vii_users` ( `user_id` mediumint(11) NOT NULL AUTO_INCREMENT, `user_email` varchar(50) NOT NULL, `user_password` varchar(32) NOT NULL, `user_name` varchar(30) NOT NULL, `user_lastname` varchar(30) NOT NULL, `user_photo` varchar(255) NOT NULL, `user_wall_id` int(11) NOT NULL, `user_birthday` varchar(30) NOT NULL, `user_sex` varchar(3) NOT NULL, `user_day` varchar(3) NOT NULL, `user_month` varchar(3) NOT NULL, `user_year` varchar(4) NOT NULL, `user_country` varchar(6) NOT NULL, `user_city` varchar(6) NOT NULL, `user_reg_date` varchar(20) NOT NULL, `user_lastdate` varchar(20) NOT NULL, `user_group` varchar(1) NOT NULL, `user_hid` varchar(64) NOT NULL, `user_country_city_name` varchar(100) NOT NULL, `user_search_pref` varchar(60) NOT NULL, `user_xfields` text NOT NULL, `xfields` text NOT NULL, `user_xfields_all` text NOT NULL, `user_albums_num` smallint(6) NOT NULL, `user_friends_demands` int(11) NOT NULL, `user_friends_num` mediumint(8) NOT NULL, `user_last_visit` varchar(15) NOT NULL, `user_fave_num` mediumint(8) NOT NULL, `user_pm_num` mediumint(8) NOT NULL, `user_notes_num` mediumint(8) NOT NULL, `user_subscriptions_num` mediumint(8) NOT NULL, `user_videos_num` mediumint(8) NOT NULL, `user_wall_num` int(11) NOT NULL, `user_status` varchar(255) NOT NULL, `user_privacy` varchar(250) NOT NULL, `user_blacklist_num` mediumint(8) NOT NULL, `user_blacklist` text NOT NULL, `user_sp` varchar(10) NOT NULL, `user_support` smallint(6) NOT NULL, `user_balance` mediumint(8) NOT NULL, `user_lastupdate` varchar(10) NOT NULL, `user_gifts` mediumint(8) NOT NULL, `user_public_num` mediumint(8) NOT NULL, `user_audio` int(11) NOT NULL, `user_msg_type` tinyint(2) NOT NULL, `user_delet` tinyint(3) NOT NULL, `user_ban` tinyint(3) NOT NULL, `user_ban_date` varchar(10) NOT NULL, `user_new_mark_photos` mediumint(8) NOT NULL, `user_doc_num` mediumint(8) NOT NULL, `user_logged_mobile` tinyint(1) NOT NULL, `user_subscription_` int(11) NOT NULL, `user_referals` text NOT NULL, `user_ref_count` int(11) NOT NULL, `user_webmoney` varchar(255) NOT NULL, `user_qiwi` varchar(255) NOT NULL, PRIMARY KEY (`user_id`), KEY `user_logged_hash` (`user_hid`), KEY `user_password` (`user_password`), KEY `user_email` (`user_email`), KEY `user_country` (`user_country`), KEY `user_city` (`user_city`), KEY `user_photo` (`user_photo`), KEY `user_sex` (`user_sex`), KEY `user_day` (`user_day`), KEY `user_month` (`user_month`), KEY `user_year` (`user_year`), KEY `user_delet` (`user_delet`), KEY `user_ban` (`user_ban`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;