Guest User

Untitled

a guest
May 4th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.73 KB | None | 0 0
  1. $schedule
  2. ->setExecutedAt(strftime('%Y-%m-%d %H:%M:%S', time()))
  3. ->save();
  4.  
  5. call_user_func_array($callback, $arguments);
  6.  
  7. $schedule
  8. ->setStatus(Mage_Cron_Model_Schedule::STATUS_SUCCESS)
  9. ->setFinishedAt(strftime('%Y-%m-%d %H:%M:%S', time()));
  10.  
  11. <?php
  12.  
  13. // Parse magento's local.xml to get db info, if local.xml is found
  14.  
  15. if (file_exists('app/etc/local.xml')) {
  16.  
  17. $xml = simplexml_load_file('app/etc/local.xml');
  18.  
  19. $tblprefix = $xml->global->resources->db->table_prefix;
  20. $dbhost = $xml->global->resources->default_setup->connection->host;
  21. $dbuser = $xml->global->resources->default_setup->connection->username;
  22. $dbpass = $xml->global->resources->default_setup->connection->password;
  23. $dbname = $xml->global->resources->default_setup->connection->dbname;
  24.  
  25. }
  26.  
  27. else {
  28. exit('Failed to open app/etc/local.xml');
  29. }
  30.  
  31. // DB Interaction
  32. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to <a class="HelpLink" onclick="showHelpTip(event, hint_id_7); return false;" href="javascript:void(0)">mysql</a>');
  33. mysql_select_db($dbname);
  34.  
  35. $result = mysql_query("SELECT * FROM " . $tblprefix . "cron_schedule") or die (mysql_error());
  36.  
  37.  
  38. // CSS for NexStyle
  39. echo '
  40. <html>
  41. <head>
  42. <title=Magento Cron <span style='background-color:#CCFF00;'>Status</span>>
  43. <style type="text/css">
  44. html {
  45. width: 100%;
  46. font-family: Helvetica, Arial, sans-serif;
  47. }
  48. body {
  49. background-color:#00AEEF;
  50. color:#FFFFFF;
  51. line-height:1.0em;
  52. font-size: 125%;
  53. }
  54. b {
  55. color: #FFFFFF;
  56. }
  57. table{
  58. border-spacing: 1px;
  59. border-collapse: collapse;
  60. width: 300px;
  61. }
  62. th {
  63. text-align: center;
  64. font-size: 125%;
  65. font-weight: bold;
  66. padding: 5px;
  67. border: 2px solid #FFFFFF;
  68. background: #00AEEF;
  69. color: #FFFFFF;
  70. }
  71. td {
  72. text-align: left;
  73. padding: 4px;
  74. border: 2px solid #FFFFFF;
  75. color: #FFFFFF;
  76. background: #666;
  77. }
  78. </style>
  79. </head>';
  80.  
  81. // DB info for user to see
  82. echo '
  83. <body>
  84. <a href="http://nexcess.net">
  85. <img src="https://smhttp-nex.nexcesscdn.net/803313/static/images/logoMainR2.gif" width="217" height="38" alt="Nexcess Beyond Hosting"></a>
  86.  
  87.  
  88.  
  89. <b>Table Prefix:</b> ' . $tblprefix . ''
  90. . '<b>DB Host:</b> ' . $dbhost . ''
  91. . '<b>DB User:</b> ' . $dbuser . ''
  92. . '<b>DB Name</b>: ' . $dbname . '</p>';
  93.  
  94. // Set up <span style="background-color:#CCFF00;">the</span> table
  95. echo "
  96. <table border='1'>
  97. <thread>
  98. <tr>
  99. <th>schedule_id</th>
  100. <th>job_code</th>
  101. <th><span style="background-color:#CCFF00;">status</span></th>
  102. <th>messages</th>
  103. <th>created_at</th>
  104. <th>scheduled_at</th>
  105. <th>executed_at</th>
  106. <th>finished_at</th>
  107. </tr>
  108. </thread>
  109. <tbody>";
  110.  
  111. // Display <span style="background-color:#CCFF00;">the</span> data from <span style="background-color:#CCFF00;">the</span> query
  112. while ($row = mysql_fetch_array($result)) {
  113. echo "<tr>";
  114. echo "<td>" . $row['schedule_id'] . "</td>";
  115. echo "<td>" . $row['job_code'] . "</td>";
  116. echo "<td>" . $row['<span style="background-color:#CCFF00;">status</span>'] . "</td>";
  117. echo "<td>" . $row['messages'] . "</td>";
  118. echo "<td>" . $row['created_at'] . "</td>";
  119. echo "<td>" . $row['scheduled_at'] . "</td>";
  120. echo "<td>" . $row['executed_at'] . "</td>";
  121. echo "<td>" . $row['finished_at'] . "</td>";
  122. echo "</tr>";
  123. }
  124.  
  125. // Close table and last few tags
  126. echo "</tbody></table></body></html>";
  127.  
  128. mysql_close($conn);
  129. ?>
  130.  
  131. protected function _generateJobs($jobs, $exists)
  132. {
  133. $scheduleAheadFor = Mage::getStoreConfig(self::XML_PATH_SCHEDULE_AHEAD_FOR)*60;
  134. $schedule = Mage::getModel('cron/schedule');
  135.  
  136. foreach ($jobs as $jobCode => $jobConfig) {
  137.  
  138. $cronExpr = null;
  139. if ($jobConfig->schedule->config_path) {
  140. $cronExpr = Mage::getStoreConfig((string)$jobConfig->schedule->config_path);
  141. }
  142. if (empty($cronExpr) && $jobConfig->schedule->cron_expr) {
  143. $cronExpr = (string)$jobConfig->schedule->cron_expr;
  144. }
  145. if (!$cronExpr || $cronExpr == 'always') {
  146. continue;
  147. }
  148. // this force catalog_product_alert to be schedule always
  149. if ($jobCode == 'catalog_product_alert') {
  150. $cronExpr='*/1 * * * *';
  151. }
Add Comment
Please, Sign In to add comment