This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP PROCEDURE IF EXISTS curupdate; | |
delimiter // | |
CREATE PROCEDURE curupdate() | |
BEGIN | |
DECLARE done INT DEFAULT 0; | |
DECLARE a INT; | |
DECLARE b CHAR(16); | |
DECLARE cur1 CURSOR FOR SELECT id,vantive_id FROM customer; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TRIGGER IF EXISTS `visitor_insert_t`; | |
DELIMITER ;; | |
CREATE TRIGGER `visitor_insert_t` AFTER INSERT ON `visitor` FOR EACH ROW BEGIN | |
IF NEW.arrival_date IS NOT NULL THEN | |
INSERT INTO `visit`( | |
`visitor_id`, | |
`location_id`, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<pre><?php | |
print_r(apache_request_headers()); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$ip_keys = array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR'); | |
foreach ($ip_keys as $key) { | |
foreach (explode(',', $_SERVER[$key]) as $ip) { | |
$ip = trim($ip); | |
sfContext::getInstance()->getLogger()->err(sprintf('%s %s', $key, $ip)); | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$crit0 = $c->getNewCriterion(TicketRelatedPeer::A_ID, $id); | |
$crit1 = $c->getNewCriterion(TicketRelatedPeer::B_ID, $id); | |
$crit0->addOr($crit1); | |
$c->add($crit0); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
protected function executeModalFormAjax(sfWebRequest $request) | |
{ | |
eval(sprintf | |
( | |
'$form = new %sForm();', | |
$request->getParameter('form') | |
)); | |
return (string) $form.' <script>'.$form['user_id']->renderJS().'</script>'; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$request->setParameter('widget_user', array_merge( | |
$request->getParameter('widget_user'), | |
array( | |
'row' => $request->getParameter('row'), | |
'col' => $request->getParameter('col') | |
) | |
)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
date_default_timezone_set('America/New_York'); | |
error_reporting(E_ALL); | |
ini_set("display_errors", "1"); | |
$username = ''; | |
$password = ''; | |
$request = array( | |
"state" => "open", |
NewerOlder