/**
* @param $transactionId
* @param $post
* @return mixed
*/
public function updateTransactionStatus($transactionId, $status)
{
$sql = 'UPDATE ' . self::TRANSACTIONS_TABLE_NAME . ' SET payment_status = ? WHERE txn_id = ?';
$params = [&$status, $transactionId];
$db = new DatabaseService();
$data = $db->execSQL($sql, $params, 'ss');
return count($data) ? $data[0] : null;
}
public function __construct()
{
// get db connection
$db = new DatabaseService();
$this->sql_con = $db->getConnection();
if (!$this->sql_con) {
HttpService::return_service_unavailable();
}
}
function insert($fname, $lname, $email, $pass)
{
$DatabaseService = new DatabaseService();
$DatabaseService->connect();
$con = $DatabaseService->con;
$con->query("insert into users (f-name,l-name,email,password) values ('{$fname}','{$lname}','{$email}','{$pass}')");
echo json_encode(array("OK" => "signup sucess"));
exit;
}
/**
* Returns default driver name.
*
* @return string
* @since 0.1.0
*/
protected static function getDefaultDriver()
{
if (self::$driver === null) {
self::$driver = \Yii::app()->db->getDriverName();
}
return self::$driver;
}
public static function getDatabaseService()
{
if (!self::$databaseService) {
self::$databaseService = new DatabaseService();
}
return self::$databaseService;
}
static function getSpecificOrAllKetegories()
{
$kategorien = DatabaseService::getDatabaseService()->findAllKategorie();
$output = "";
foreach ($kategorien as $key => $value) {
$output .= "<li><a href=\"produkte.php?kategorieid=" . $value->getKategorieid() . "\">" . $value->getKategoriename() . "</a></li>";
}
return $output;
}
public function delete()
{
$statement1 = 'DELETE FROM thread WHERE id=:id';
//To delete all messages posted to thread
$statement2 = 'DELETE FROM message WHERE thread_id=:id';
$statement3 = 'DELETE FROM thread_user WHERE thread_id=:id';
$values = array('id' => $this->id);
DatabaseService::execute($statement3, $values);
DatabaseService::execute($statement2, $values);
DatabaseService::execute($statement1, $values);
}
/**
* @param $data
* @param null $myPost
*/
public static function log($data, $myPost = null)
{
//@TODO refactor
if ($myPost) {
if (!isset($data['txn_id'])) {
$data['txn_id'] = $myPost['txn_id'];
}
if (!isset($data['subscr_id'])) {
$data['subscr_id'] = isset($myPost['subscr_id']) ? $myPost['subscr_id'] : null;
}
if (!isset($data['user_id'])) {
$data['user_id'] = (string) $myPost['customData']['user_id'];
}
if (!isset($data['data'])) {
$data['data'] = json_encode($myPost);
}
}
$data['created'] = date('Y-m-d H:i:s');
$db = new DatabaseService();
$db->insertData(self::LOG_TABLE_NAME, $data);
}
/**
* @return array
* @throws Exception
*/
public function getSubscriptionPlanOptions()
{
$planId = $this->id;
$db = new DatabaseService();
$sql = 'SELECT * FROM ' . self::TABLE_NAME_OPTIONS . ' WHERE plan_id = ? ';
$params = [&$planId];
$data = $db->execSQL($sql, $params, 'i');
$res = [];
foreach ($data as $option) {
$res[$option['name']] = $option['value'];
}
return $res;
}
/**
* login
* @param $username string
* @param $password string
*/
public static function login($username, $password)
{
// Delete Mocking behavior
// get db connection
$db = new DatabaseService();
$sql_con = $db->getConnection();
//connection failed
if (!$sql_con) {
HttpService::return_service_unavailable();
}
//get hash algos
$algos = hash_algos();
//take the 3rd algo
$algo = $algos[2];
$pw_hash = hash($algo, $password);
//get user from db
$query = "SELECT * FROM user WHERE alias = '{$username}' AND password = '******'";
$result = $sql_con->query($query);
$row = mysqli_fetch_assoc($result);
//login data correct?
if (!isset($row)) {
HttpService::redirect_to('/login/fail');
}
//add alias to session
$_SESSION['username'] = $row['alias'];
$_SESSION['user_id'] = $row['id'];
$roles = array();
//add user role
switch ($row['role']) {
case 1:
array_push($roles, 'admin');
break;
case 2:
array_push($roles, 'author');
break;
case 3:
array_push($roles, 'user');
break;
}
//add roles to session
$_SESSION['roles'] = $roles;
}
$result->dispose();
} catch (MySQLQuerierException $e) {
$tpl->assign_block_vars('line', array());
$tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => ''));
}
} elseif (substr($lower_query, 0, 11) == 'insert into' || substr($lower_query, 0, 6) == 'update' || substr($lower_query, 0, 11) == 'delete from' || substr($lower_query, 0, 11) == 'alter table' || substr($lower_query, 0, 8) == 'truncate' || substr($lower_query, 0, 10) == 'drop table') {
try {
$result = PersistenceContext::get_querier()->inject(str_replace('phpboost_', PREFIX, $query));
$affected_rows = $result->get_affected_rows();
} catch (MySQLQuerierException $e) {
$tpl->assign_block_vars('line', array());
$tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => ''));
}
}
}
$tpl->put_all(array('QUERY' => DatabaseService::indent_query($query), 'QUERY_HIGHLIGHT' => DatabaseService::highlight_query(str_replace('phpboost_', PREFIX, $query)), 'L_REQUIRE' => LangLoader::get_message('form.explain_required_fields', 'status-messages-common'), 'L_EXPLAIN_QUERY' => $LANG['db_query_explain'], 'L_CONFIRM_QUERY' => $LANG['db_confirm_query'], 'L_EXECUTE' => $LANG['db_submit_query'], 'L_RESULT' => $LANG['db_query_result'], 'L_EXECUTED_QUERY' => $LANG['db_executed_query']));
} elseif ($action == 'restore') {
//Suppression d'un fichier
if (!empty($del)) {
AppContext::get_session()->csrf_get_protect();
//Protection csrf
$file = TextHelper::strprotect($del);
$file_path = PATH_TO_ROOT . '/cache/backup/' . $file;
//Si le fichier existe
if (preg_match('`[^/]+\\.sql$`', $file) && is_file($file_path)) {
if (@unlink($file_path)) {
AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_success', '', '&'));
} else {
AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_failure', '', '&'));
}
} else {
public function delete()
{
$statement = 'DELETE FROM message WHERE id=:id';
$values = array('id' => $this->id);
DatabaseService::execute($statement, $values);
}
<?php
require_once 'include/class.database.php';
$DatabaseService = new DatabaseService();
$DatabaseService->connect();
$con = $DatabaseService->con;
$result = $con->query("SELECT * FROM ourserv ");
while ($row = mysqli_fetch_array($result)) {
$title = $row['title'];
$des = $row['description'];
}
/**
* @return array
*/
public function getUsers()
{
$db = new DatabaseService();
$data = $db->getTableData(self::TABLE_NAME, '*', '');
return $data;
}
private static function deleteParticipation($user_id, $thread_id)
{
$statement = 'DELETE FROM thread_user WHERE user_id = :user_id AND thread_id = :thread_id';
$values = array('user_id' => $user_id, 'thread_id' => $thread_id);
DatabaseService::execute($statement, $values);
}
public function checkModuleRestrictions($action)
{
$restrictionError = -1;
$tf = new DatabaseService();
if (isset($_SESSION['subscriptionPlanOptions'])) {
$subscriptionPlanOptions = $_SESSION['subscriptionPlanOptions'];
} else {
$subscriptionPlanOptions = $this->getOptions();
$_SESSION['subscriptionPlanOptions'] = $subscriptionPlanOptions;
}
$records = $tf->getTableData($action, '*', '');
if (isset($subscriptionPlanOptions['options'][$action]) && $subscriptionPlanOptions['options'][$action] !== '-1' && count($records) >= $subscriptionPlanOptions['options'][$action]) {
echo $restrictionError;
die;
}
}
/**
* @param $userId
* @param $serviceProvider
* @return bool|mixed|mysqli_result
* @throws Exception
*/
public static function getSubscriptionsArchive($userId, $serviceProvider)
{
$db = new DatabaseService();
$sql = 'SELECT *,s.id as subId FROM ' . self::TABLE_NAME . ' s INNER JOIN ' . SubscriptionPlan::TABLE_NAME . ' sp ON sp.id = s.plan_id WHERE sp.service_provider = ? AND s.user_id = ?';
$params = [&$serviceProvider, &$userId];
$data = $db->execSQL($sql, $params, 'ss');
return $data;
}
/**
* @param $id
* @return mixed
* @throws Exception
*/
public function getLastActiveTransactionBySubscription($id)
{
//@TODO refactor it
$db = new DatabaseService();
$relationType = PaypalTransaction::TRANSACTION_RELATION_SUBSCRIPTION;
$paymentStatus = 'Completed';
$sql = 'SELECT * FROM ' . PaypalTransaction::TRANSACTIONS_TABLE_NAME . ' WHERE relation_id = ? AND relation_type = ? AND payment_status = ? ORDER BY created_date';
$params = [&$id, &$relationType, &$paymentStatus];
$data = $db->execSQL($sql, $params, 'sss');
return $data[0];
}
/**
* @param $userId
* @return bool|mixed|mysqli_result
* @throws Exception
*/
public static function getPaymentHistory($userId)
{
$db = new DatabaseService();
$sql = 'SELECT * FROM ' . self::TABLE_NAME . ' eu
INNER JOIN ' . PaypalTransaction::TRANSACTIONS_TABLE_NAME . ' pt
ON eu.id = pt.relation_id
INNER JOIN ' . ExtraService::TABLE_NAME . ' es
ON es.id = eu.service_id
WHERE eu.user_id = ? AND pt.relation_type = ?
ORDER BY pt.payment_date';
$relationType = PaypalTransaction::TRANSACTION_RELATION_EXTRA_SERVICE;
$params = [&$userId, &$relationType];
$data = $db->execSQL($sql, $params, 'is');
return $data;
}
/**
* Tests failures on incorrect driver names.
*
* @param string $incorrectDriver Invalid driver name.
*
* @dataProvider invalidDriverNamesProvider
* @expectedException \BadMethodCallException
*
* @return void
* @since 0.1.0
*/
public function testInvalidDriverNameException($incorrectDriver)
{
\DatabaseService::getNowExpression($incorrectDriver);
}
