shared knowledge

Search This Blog

deleted by days sql server

on September 24, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

DELETE FROM registration WHERE datestamp < NOW() - INTERVAL 0 DAY

DELETE FROM registration WHERE datestamp < NOW() - INTERVAL -3 DAY

phprunner

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

phprunner custom page view

<?php ini_set("display_errors","0"); set_magic_quotes_runtime(0); header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); header("Pragma: no-cache"); header("Cache-Control: no-cache"); include("include/dbcommon.php"); if(!@$_SESSION["UserID"]) { header("Location: login.php"); return; } ?> <?php $idb = $_REQUEST['idb']; $sql = "SELECT * FROM badge WHERE idb='".$idb."'"; $results = CustomQuery($sql); $data = db_fetch_array($results); $Status = $data['Status']; $Idb = $data['Idb']; $Payment = $data['Payment']; $Amount = $data['Amount']; $DocNumber = $data['DocNumber']; $Name = $data['Person Name']; $Prof = $data['Profession']; $Comp = $data['Comp name']; $Issue = $data['Issuing Date'];

custom query case when sql phprunner

<?php ini_set("display_errors","0"); set_magic_quotes_runtime(0); header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); header("Pragma: no-cache"); header("Cache-Control: no-cache"); include("include/dbcommon.php"); if(!@$_SESSION["UserID"]) { header("Location: login.php"); return; } ?> <?php $idb = $_REQUEST['idb']; $sql = " SELECT (CASE WHEN Status IS NULL > '' THEN 'Not Review' WHEN Status = 1 THEN 'Printed' WHEN Status = 2 THEN 'Reject' END) AS Status, IF(Status IS NULL, 'N/A', Status) AS Status1, DocNumber FROM badge WHERE idb='".$idb."'"; $results = CustomQuery($sql); $data = db_fetch_array($results); $Status = $data['Status']; $Idb = $data['Idb']; $Payment =

Check off Encrypt password option in User login settings dialog on the Security tab in PHPRunner.

use BeforeLogin event to put your custom login procedure there. I recommend you to try the following. Check off Encrypt password option in User login settings dialog on the Security tab in PHPRunner. Then build the pages and open generated login.php file with a text editor. Find this line there: Quote $strPassword=md5($strPassword); try to replace it with: Quote $strPassword=sha1($strPassword); or with: Quote $strPassword=strtoupper(sha1($strPassword));

Powered by Blogger

deleted by days sql server

Comments

Post a Comment