<?php

/* prepared */

$del_downloads = $connect->prepare("delete from `downloads` where `did` = ? and `type` = ?");
$num_downloads = $connect->prepare("select count(*) from `downloads` where `did` = ? and `type` = ?");
$email_s = $connect->prepare("select count(*) from `users` where `email` = ?");
$active_user = $connect->prepare("update `users` set `active` = ? where `id` = ?");
$authlog = $connect->prepare("insert into `authlog` set `time` = ?, `uid` = ?, `ip` = ?, `ua` = ?, `key` = ?, `attempts` = ?");
$stmt_auth = $connect->prepare("select count(*) from `authlog` where `uid` = ?");
$stmt_black = $connect->prepare("select count(*) from `blacklist` where `uid` = ?");
$stmt_friends = $connect->prepare("select count(*) from `friend` where `status` = '1' and (`from` = :user or `to` = :user)");
$stmt_ref = $connect->prepare("select count(*) from `users` where `ref` = ?");
$stmt_user_payment = $connect->prepare("select sum(`money`) from `payment` where `status` = '1' and `uid` = ?");
$stmt_count_up = $connect->prepare("select count(*) from `payment` where `uid` = ?");
$stmt_user_plus = $connect->prepare("select sum(`sum`) from `plus` where `status` = '1' and `type` = ? and `uid` = ?");
$stmt_user_donats = $connect->prepare("select sum(`sum`) from `plus` where `status` = '1' and `type` = '1' and `donater` = ?");
$stmt_count_upl = $connect->prepare("select count(*) from `plus` where `status` = '1' and `type` = ? and `uid` = ?");
$del_friend = $connect->prepare("delete from `friend` where `from` = :from and `to` = :to or `from` = :to and `to` = :from");
$stmt_hud = $connect->prepare("select count(*) from `plus` where `status` = '1' and `type` = '1' and (`donater` = :user or `uid` = :user)");
$stmt_user_shop = $connect->prepare("select count(*) from `shop` where `seller` = ?");