public function Load($loginId) { $success = TRUE; $sql = "select * from " . OpenSms::getTableName('usedCards') . " where cardId = '" . StringMethods::MakeSave($this->Id) . "';"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $success = FALSE; if ($loginId == $r->loginId) { $message = 'This card has already been used by you'; } else { $message = 'This card has already been used'; } } if ($success) { $sql = 'insert into ' . OpenSms::getTableName('usedCards') . ' (loginId, cardId) value("' . $loginId . '", "' . $this->Id . '");'; //die($sql); $inserted = OpenSms_Helper_Db::executeNonQuery($sql); if ($inserted) { $user = OpenSms::loadModel("OpenSms_Model_User", [0 => $loginId]); $user->Balance += $this->Unit; $user->Save(); $message = 'Your account has been credited with ' . $this->Unit . ' SMS unit'; } } return array('success' => $success, 'message' => $message); }
public function Delete() { $sql = "delete from " . OpenSms::getTableName('contact') . " where id = '" . StringMethods::MakeSave($this->Id) . "'"; //die($sql); if (OpenSms_Helper_Db::executeNonQuery($sql)) { return 'One number deleted'; } else { return 'Error in deleting number'; } }
public function Save() { $content = new OpenSms_Model_Content([0 => $this->Key]); if ($content->Id > 0) { $this->Id = $content->Id; } $sql = !$this->Id > 0 ? "insert into " . $this->getTableName() . "(`key`, `type`, `body`, `host`) value('" . StringMethods::MakeSave($this->Key) . "', '" . StringMethods::MakeSave($this->Type) . "', '" . StringMethods::MakeSave($this->Body) . "', '" . StringMethods::MakeSave($this->Host) . "');" : "update " . $this->getTableName() . " set `body` = '" . StringMethods::MakeSave($this->Body) . "'\r\n where `key` = '" . StringMethods::MakeSave($this->Key) . "';"; //die($sql); return OpenSms_Helper_Db::executeNonQuery($sql); }
public function Save() { $content = new OpenSms_Model_Page([0 => $this->Permalink]); if ($content->Id > 0) { return 'A page with the same permalink already exist'; } $sql = !$this->Id > 0 ? "insert into " . $this->getTableName() . "(`permalink`, `title`, `layout`, `role`, `description`) value('" . StringMethods::MakeSave($this->Permalink) . "', '" . StringMethods::MakeSave($this->Title) . "', '" . StringMethods::MakeSave($this->Layout) . "'\n , '" . StringMethods::MakeSave($this->Role) . "', '" . StringMethods::MakeSave($this->Description) . "');" : "update " . $this->getTableName() . " set `title` = '" . StringMethods::MakeSave($this->Title) . "',\n layout = '" . StringMethods::MakeSave($this->Layout) . "', description = '" . StringMethods::MakeSave($this->Description) . "\n where `permalink` = '" . StringMethods::MakeSave($this->Permalink) . "';"; //die($sql); return OpenSms_Helper_Db::executeNonQuery($sql); }
public function Save() { $sql = "insert into " . OpenSms::getTableName('sms') . "(bulkSMSId, number, message, sender, refId, Status)\r\n\t\t\t\t value('" . StringMethods::MakeSave($this->BulkSMSId) . "', '" . StringMethods::MakeSave($this->Number) . "', '" . StringMethods::MakeSave($this->Message) . "', '" . StringMethods::MakeSave($this->Sender) . "', '" . StringMethods::MakeSave($this->RefId) . "', '" . StringMethods::MakeSave($this->Status) . "');"; OpenSms_Helper_Db::executeNonQuery($sql); if ($this->Id == -1) { $sql = "select MAX(id) as no from `" . OpenSms::getTableName('sms') . "`"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $this->Id = $r->no; return $r->no; } } }
public function SaveMessages($messages) { $sql = 'insert into ' . OpenSms::getTableName('sms') . '(bulkSMSId, number, message, sender, refId, status) value'; $i = 0; foreach ($messages as $message) { $i += 1; $count = count($messages); $sql .= "('" . StringMethods::MakeSave($message->BulkSMSId) . "', '" . StringMethods::MakeSave($message->Number) . "', '" . StringMethods::MakeSave($message->Message) . "', '" . StringMethods::MakeSave($message->Sender) . "', '" . StringMethods::MakeSave($message->RefId) . "', '" . StringMethods::MakeSave($message->Status) . "')"; if ($i == $count) { $sql .= ';'; } else { $sql .= ','; } } OpenSms_Helper_Db::executeNonQuery($sql); }
public static function FindUserByEmail($emailId) { $sql = "select * from " . OpenSms::getTableName('users') . " where loginId = '" . StringMethods::MakeSave($emailId) . "';"; $u = new OpenSms_Model_User(); $result = OpenSms_Helper_Db::executeReader($sql); return isset($result[0]) ? self::copyFromPDO($result[0]) : new OpenSms_Model_User(); }
public function Delete() { unset($_COOKIE[$this->cookieName]); $sql = "delete from logins where id = '" . StringMethods::MakeSave($this->Id) . "'"; return OpenSms_Helper_Db::executeNonQuery($sql); }
public static function Encode($string) { return md5(StringMethods::MakeSave($string)); }
public function Delete() { $sql = "delete from draft where id = '" . StringMethods::MakeSave($this->Id) . "'"; return $this->db->SendQuery($sql); }