No OneTemporary
Actions

Size

8 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/objects/subscribe.php b/objects/subscribe.php
	index cce158a78..4b9a9b948 100644
	--- a/objects/subscribe.php
	+++ b/objects/subscribe.php
	@@ -1,212 +1,214 @@
	<?php
	if (empty($global['systemRootPath'])) {
	$global['systemRootPath'] = '../';
	}
	require_once $global['systemRootPath'] . 'videos/configuration.php';
	require_once $global['systemRootPath'] . 'objects/bootGrid.php';
	require_once $global['systemRootPath'] . 'objects/user.php';

	class Subscribe {

	private $id;
	private $email;
	private $status;
	private $ip;
	private $users_id;

	function __construct($id, $email = "", $user_id = "") {
	if (!empty($id)) {
	$this->load($id);
	}
	if (!empty($email)) {
	$this->email = $email;
	$this->users_id = $user_id;
	if (empty($this->id)) {
	$this->loadFromEmail($email, $user_id, "");
	}
	}
	}

	private function load($id) {
	$obj = self::getSubscribe($id);
	if (empty($obj))
	return false;
	foreach ($obj as $key => $value) {
	$this->$key = $value;
	}
	return true;
	}

	private function loadFromEmail($email, $user_id, $status = "a") {
	$obj = self::getSubscribeFromEmail($email, $user_id, $status);
	if (empty($obj))
	return false;
	foreach ($obj as $key => $value) {
	$this->$key = $value;
	}
	return true;
	}

	function save() {
	global $global;
	if (!empty($this->id)) {
	$sql = "UPDATE subscribes SET status = '{$this->status}',ip = '" . getRealIpAddr() . "', modified = now() WHERE id = {$this->id}";
	} else {
	$sql = "INSERT INTO subscribes ( users_id, email,status,ip, created, modified) VALUES ('{$this->users_id}','{$this->email}', 'a', '" . getRealIpAddr() . "',now(), now())";
	}
	$resp = $global['mysqli']->query($sql);
	if (empty($resp)) {
	die('Error : (' . $global['mysqli']->errno . ') ' . $global['mysqli']->error);
	}
	return $resp;
	}

	static function getSubscribe($id) {
	global $global;
	$id = intval($id);
	$sql = "SELECT * FROM subscribes WHERE id = $id LIMIT 1";
	$res = $global['mysqli']->query($sql);
	if ($res) {
	$subscribe = $res->fetch_assoc();
	} else {
	$subscribe = false;
	}
	return $subscribe;
	}

	static function getSubscribeFromEmail($email, $user_id, $status = "a") {
	global $global;
	$sql = "SELECT * FROM subscribes WHERE email = '$email' AND users_id = {$user_id} ";
	if (!empty($status)) {
	$sql .= " AND status = '{$status}' ";
	}
	$sql .= " LIMIT 1";
	$res = $global['mysqli']->query($sql);
	if ($res) {
	$subscribe = $res->fetch_assoc();
	} else {
	$subscribe = false;
	}
	return $subscribe;
	}

	static function getAllSubscribes($user_id = "") {
	global $global;
	$sql = "SELECT su.id as subscriber_id, s.* FROM subscribes as s "
	. " LEFT JOIN users as su ON s.email = su.email "
	. " LEFT JOIN users as u ON users_id = u.id WHERE 1=1 ";
	if (!empty($user_id)) {
	$sql .= " AND users_id = {$user_id} ";
	}
	$sql .= BootGrid::getSqlFromPost(array('email'));

	$res = $global['mysqli']->query($sql);
	$subscribe = array();
	if ($res) {
	while ($row = $res->fetch_assoc()) {
	$row['identification'] = User::getNameIdentificationById($row['subscriber_id']);
	if($row['identification'] === __("Unknown User")){
	$row['identification'] = $row['email'];
	}
	+ $row['backgroundURL'] = User::getBackground($row['users_id']);
	+ $row['photoURL'] = User::getPhoto($row['users_id']);

	$subscribe[] = $row;
	}
	//$subscribe = $res->fetch_all(MYSQLI_ASSOC);
	} else {
	$subscribe = false;
	die($sql . '\nError : (' . $global['mysqli']->errno . ') ' . $global['mysqli']->error);
	}
	return $subscribe;
	}

	static function getTotalSubscribes($user_id = "") {
	global $global;
	$sql = "SELECT id FROM subscribes WHERE status = 'a' ";
	if (!empty($user_id)) {
	$sql .= " AND users_id = {$user_id} ";
	}

	$sql .= BootGrid::getSqlSearchFromPost(array('email'));

	$res = $global['mysqli']->query($sql);


	return $res->num_rows;
	}

	function toggle() {
	if (empty($this->status) \|\| $this->status == "i") {
	$this->status = 'a';
	} else {
	$this->status = 'i';
	}
	$this->save();
	}

	function getStatus() {
	return $this->status;
	}

	static function getButton($user_id) {
	$total = static::getTotalSubscribes($user_id);

	$subscribe = "<div class=\"btn-group\">"
	. "<button class='btn btn-xs subsB subs{$user_id} subscribeButton{$user_id}'><span class='fa'></span> <b class='text'>" . __("Subscribe") . "</b></button>"
	. "<button class='btn btn-xs subsB subs{$user_id}'><b class='textTotal{$user_id}'>{$total}</b></button>"
	. "</div>";
	//show subscribe button with mail field
	$popover = "<div id=\"popover-content\" class=\"hide\">
	<div class=\"input-group\">
	<input type=\"text\" placeholder=\"E-mail\" class=\"form-control\" id=\"subscribeEmail\" style=\"min-width: 150px;\">
	<span class=\"input-group-btn\">
	<button class=\"btn btn-danger\" id=\"subscribeButton{$user_id}2\"><i class=\"fa fa-check\"></i></button>
	</span>
	</div>
	</div><script>
	$(document).ready(function () {
	$(\".subscribeButton{$user_id}\").popover({
	placement: 'bottom',
	trigger: 'manual',
	html: true,
	content: function() {
	return $('#popover-content').html();
	}
	});
	});
	</script>";
	$script = "<script>
	$(document).ready(function () {
	$(\".subscribeButton{$user_id}\").off(\"click\");
	$(\".subscribeButton{$user_id}\").click(function () {
	email = $('#subscribeEmail').val();
	console.log(email);
	if (validateEmail(email)) {
	subscribe(email, {$user_id});
	} else {
	$('.subscribeButton{$user_id}').popover(\"toggle\");
	$(\"#subscribeButton{$user_id}2\").click(function () {
	$(\".subscribeButton{$user_id}\").trigger(\"click\");
	});
	}
	});
	});
	</script>";
	if (User::isLogged()) {
	//check if the email is logged
	$email = User::getMail();
	if (!empty($email)) {
	$subs = Subscribe::getSubscribeFromEmail($email, $user_id);
	$popover = "<input type=\"hidden\" placeholder=\"E-mail\" class=\"form-control\" id=\"subscribeEmail\" value=\"{$email}\">";
	if (!empty($subs)) {
	// show unsubscribe Button
	$subscribe = "<div class=\"btn-group\">"
	. "<button class='btn btn-xs subsB subscribeButton{$user_id} subscribed subs{$user_id}'><span class='fa'></span> <b class='text'>" . __("Subscribed") . "</b></button>"
	. "<button class='btn btn-xs subsB subscribed subs{$user_id}'><b class='textTotal{$user_id}'>$total</b></button>"
	. "</div>";
	}
	}
	}
	return $subscribe.$popover.$script;
	}

	}

File Metadata

Mime Type: text/x-diff
Expires: Wed, Apr 22, 15:15 (1 d, 21 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1862800
Default Alt Text: (8 KB)

No OneTemporaryActions

View Options

File Metadata

Event Timeline

No OneTemporary
Actions