***************************    *****************************


1.   /sys/inc/user.php


-------------------------------------------
    ?> :

/////////////////////////// BY MIXANZA//////////////////////////

//  
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]'"), 0)==0)
{
mysql_query("INSERT INTO `dlist` (`id_user`) values('". intval($user['id']) ."')");
}

$dlist = mysql_fetch_assoc(mysql_query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1"));

//    
if ($dlist['anketa_ok'] == 0 && $user['ank_m_r'] > 0 && $user['ank_d_r'] > 0 && $user['ank_g_r'] > 0 && $user['ank_city'] > null && $user['ank_name'] > null){
mysql_query("UPDATE `dlist` SET `anketa_ok` = '1', `anketa` = '1' WHERE `id_user` = '".$user['id']."'");
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['anketa_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
}

//    
$a = mysql_fetch_array(mysql_query("SELECT id,id_gallery,ras FROM `gallery_foto` WHERE `id_user` = '".$user['id']."' AND `avatar` = '1' LIMIT 1"));
if (is_file(H . "sys/gallery/50/$a[id].$a[ras]") && $dlist['avatar_ok'] == 0 ) {
mysql_query("UPDATE `dlist` SET `avatar_ok` = '1', `avatar` = '1' WHERE `id_user` = '".$user['id']."'");
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['avatar_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
}

//    
if ($dlist['email_ok'] == 0 && $user['ank_mail'] > null){
mysql_query("UPDATE `dlist` SET `email_ok` = '1', `email` = '1' WHERE `id_user` = '".$user['id']."'");
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['email_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
}

------------------------------------------

2.   /plugins/notes/add.php


------------------------------------------


 : 
if (!isset($err)){


:
$dlist = mysql_fetch_assoc(mysql_query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1"));
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `blogs` = '3'"), 0)==0)
{
mysql_query("UPDATE `dlist` SET `blogs` = '" . ($dlist['blogs'] + 1) . "' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `blogs` = '3' AND `blogs_ok` = '0'"), 0))
{
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['blogs_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
mysql_query("UPDATE `dlist` SET `blogs_ok` = '1' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 

-------------------------------------------

3.   /news/news.php


 :
$set['title'] = ' - ' . text($news['title']);
include_once '../sys/inc/thead.php';
title();
aut();
err();


:
$dlist = mysql_fetch_assoc(mysql_query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1"));
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `news` < '10'"), 0))
{
mysql_query("UPDATE `dlist` SET `news` = '" . ($dlist['news'] + 1) . "' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `news` = '10' AND `news_ok` = '0'"), 0))
{
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['news_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
mysql_query("UPDATE `dlist` SET `news_ok` = '1' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 

--------------------------------------------

4.   /guest/index.php


 :
elseif(!isset($err))
{
//    
include_once H.'sys/add/user.active.php';





:
$dlist = mysql_fetch_assoc(mysql_query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1"));
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `guest` < '5'"), 0))
{
mysql_query("UPDATE `dlist` SET `guest` = '" . ($dlist['guest'] + 1) . "' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `guest` = '5' AND `guest_ok` = '0'"), 0))
{
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['guest_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
mysql_query("UPDATE `dlist` SET `guest_ok` = '1' WHERE `id_user` = '".$user['id']."' LIMIT 1");
}

--------------------------------------------



5.   /chat/inc/room.php



 :
mysql_query("INSERT INTO `chat_post` (`id_user`, `time`, `msg`, `room`, `privat`) values('$user[id]', '$time', '".my_esc($msg)."', '$room[id]', '$priv')");

:
$dlist = mysql_fetch_assoc(mysql_query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1"));
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `chat` < '5'"), 0))
{
mysql_query("UPDATE `dlist` SET `chat` = '" . ($dlist['chat'] + 1) . "' WHERE `id_user` = '".$user['id']."' LIMIT 1");
} 
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `chat` = '5' AND `chat_ok` = '0'"), 0))
{
mysql_query("UPDATE `user` SET `balls` = '" . ($user['balls'] + $dlist['chat_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
mysql_query("UPDATE `dlist` SET `chat_ok` = '1' WHERE `id_user` = '".$user['id']."' LIMIT 1");
}



--------------------------------------------


.
