salom dostlar, yangi mod tuzub turubman, faqat bitta joyi oxshamayabti... yani pul ishlash modi-da saytim.tm/1.go deb yoziganda ruscha perehod deb chiqmayabti. .hateccs faylga ham yoziladigon codini yozdim. umuman aytganda Click.php faylni johncmsga moslay olmayabman, shunga yordam berivoringlar demochi edim. mana mendagi click.php fayl:
$click=mysql_result(mysql_query("SELECT COUNT(*) FROM `click_db` WHERE `user_id`= '".$data['id']."' AND `ip` = '".$ip."' AND `browser` = '".$useragent."' AND `date` = '".date('d.m.Y')."' LIMIT "),0);
$clickip=mysql_result(mysql_query("SELECT COUNT(*) FROM `click_db` WHERE `user_id`= '".$data['id']."' AND `ip` = '".$ip."' AND `date` = '".date('d.m.Y')."' LIMIT 1"),0);
/*
if($click == 0 && $clickip == 0) {
if($user['id'] == $data['id']) {
$uid_click = 1;
} else {
$uid_click = 0;
}
*/
//$q = mysql_query("SELECT o.id_oper, o.oper, o.cena_rub, o.rusname FROM ips i LEFT JOIN operators o ON i.id_oper = o.id_oper WHERE INET_ATON('".$ip."') BETWEEN i.astart AND i.aend LIMIT 1");
$sites= DB ::run()->querySingle("SELECT COUNT(*) FROM `sites` WHERE `user_id`= ? AND `active` = '1' LIMIT 1;",array($data['id']));
if($sites>0){
$click= DB ::run()->querySingle("SELECT COUNT(*) FROM `click_db` WHERE `user_id`= ? AND `ip` = ? AND `browser` = ? AND `date` = ? LIMIT 1;",array($data['id'],$ip,$useragent,date('d.m.Y')));
$clickip= DB ::run()->querySingle("SELECT COUNT(*) FROM `click_db` WHERE `user_id`= ? AND `ip` = ? AND `date` = ? LIMIT 1;",array($data['id'],$ip,date('d.m.Y')));
if($click==0&&$clickip==0){
if($user['id']==$data['id']){
$uid_click=1;
}else{
$uid_click=0;
}
$q= DB ::run()->queryFetch("SELECT o.id_oper, o.oper, o.cena_rub, o.rusname FROM ips i
LEFT JOIN operators o ON i.id_oper=o.id_oper
WHERE INET_ATON('".$ip."') BETWEEN i.astart AND i.aend LIMIT 1");