A PHP Error was encountered

Severity: 8192

Message: Function create_function() is deprecated

Filename: geshi/geshi.php

Line Number: 4698

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4698
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4621
Function: _optimize_regexp_list_tokens_to_string

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 1655
Function: optimize_regexp_list

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2029
Function: optimize_keyword_group

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2168
Function: build_parse_cache

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/Process.php
Line: 45
Function: parse_code

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/models/Pastes.php
Line: 517
Function: syntax

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 693
Function: getPaste

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

Re: Allocation data fix - Stikked
Stikked

Re: Allocation data fix

From fdghfgh, 12 Years ago, written in HTML5.
This paste is a reply to Allocation data fix from Troy - view diff
URL http://geopaste.scratchbook.ch/view/c45903ce
Embed
Download Paste or View Raw
  1. diff -r 6702e481d7df products/ctrader/v0/source/contracts/queries/contract_allocations.qry
  2. --- a/products/ctrader/v0/source/contracts/queries/contract_allocations.qry     Thu Nov 29 16:58:11 2012 +1030
  3. +++ b/products/ctrader/v0/source/contracts/queries/contract_allocations.qry     Fri Nov 30 15:03:35 2012 +1030
  4. @@ -22,7 +22,7 @@
  5.                                  trans_source.sup_or_pur) AS parent_sources ON (trans_source.trans_id = parent_sources.trans_id AND trans_source.sup_or_pur = parent_sources.sup_or_pur))
  6.               LEFT OUTER JOIN trans_freight_activity ON (trans_load.trans_load_uid = trans_freight_activity.trans_load_id))
  7.               LEFT OUTER JOIN contract ON (trans_source.contract_id = contract.contract_uid))
  8. -             LEFT OUTER JOIN contract_site ON (contract_site.contract_id IS NOT NULL AND trans_source.site_id = contract_site.contract_site_uid))
  9. +             LEFT OUTER JOIN contract_site ON (trans_source.contract_id IS NOT NULL AND trans_source.site_id = contract_site.contract_site_uid))
  10.               LEFT OUTER JOIN contract_site AS aliased_contract_site ON (contract_site.alias_of_site_id = aliased_contract_site.contract_site_uid))
  11.               ?DETAILED_FREIGHT?(LEFT OUTER JOIN
  12.                 (
  13. @@ -67,7 +67,7 @@
  14.                                  trans_source.sup_or_pur) AS parent_sources ON (trans_source.trans_id = parent_sources.trans_id AND trans_source.sup_or_pur <> parent_sources.sup_or_pur))
  15.               LEFT OUTER JOIN trans_freight_activity ON (trans_load.trans_load_uid = trans_freight_activity.trans_load_id))
  16.               LEFT OUTER JOIN contract AS child_contract ON (trans_source.contract_id = child_contract.contract_uid))
  17. -             LEFT OUTER JOIN contract_site AS child_contract_site ON (child_contract_site.contract_id IS NOT NULL AND trans_source.site_id = child_contract_site.contract_site_uid))
  18. +             LEFT OUTER JOIN contract_site AS child_contract_site ON (trans_source.contract_id IS NOT NULL AND trans_source.site_id = child_contract_site.contract_site_uid))
  19.               LEFT OUTER JOIN contract_site AS aliased_contract_site ON (child_contract_site.alias_of_site_id = aliased_contract_site.contract_site_uid))
  20.               LEFT OUTER JOIN storage_site ON (trans_source.site_id = storage_site.storage_site_uid))
  21.               LEFT OUTER JOIN trans_source_type ON (trans_source_type.trans_source_type_uid = trans_source.trans_source_type_id AND trans_source_type.sup_or_pur = trans_source.sup_or_pur))
  22. @@ -105,7 +105,7 @@
  23.               LEFT OUTER JOIN order_load AS order_load_sup ON (`order`.order_uid = order_load_sup.sup_order_id))
  24.               LEFT OUTER JOIN order_load AS order_load_pur ON (`order`.order_uid = order_load_pur.pur_order_id))
  25.               LEFT OUTER JOIN contract ON (order.contract_id = contract.contract_uid ))
  26. -             LEFT OUTER JOIN contract_site AS child_contract_site ON (child_contract_site.contract_id IS NOT NULL AND order.site_id = child_contract_site.contract_site_uid))
  27. +             LEFT OUTER JOIN contract_site AS child_contract_site ON (order.contract_id IS NOT NULL AND order.site_id = child_contract_site.contract_site_uid))
  28.               LEFT OUTER JOIN contract_site AS aliased_contract_site ON (child_contract_site.alias_of_site_id = aliased_contract_site.contract_site_uid))
  29.         WHERE `order`.order_archived = 0
  30.           AND `order`.contract_id  IN (~CONTRACT_FILTER~)
  31. @@ -139,7 +139,7 @@
  32.                            WHERE `order`.order_archived = 0
  33.                              AND `order`.contract_id  IN (~CONTRACT_FILTER~) ) AS parent_order_load ON (parent_order_load.order_load_uid = `order_load`.order_load_uid))
  34.               LEFT OUTER JOIN contract AS child_contract ON (order.contract_id = child_contract.contract_uid))
  35. -             LEFT OUTER JOIN contract_site AS child_contract_site ON (child_contract_site.contract_id IS NOT NULL AND order.site_id = child_contract_site.contract_site_uid))
  36. +             LEFT OUTER JOIN contract_site AS child_contract_site ON (order.contract_id IS NOT NULL AND order.site_id = child_contract_site.contract_site_uid))
  37.               LEFT OUTER JOIN contract_site AS aliased_contract_site ON (child_contract_site.alias_of_site_id = aliased_contract_site.contract_site_uid))
  38.               LEFT OUTER JOIN storage_site ON (order.site_id = storage_site.storage_site_uid))
  39.               LEFT OUTER JOIN trans_source_type ON (trans_source_type.trans_source_type_uid = order.trans_source_type_id))
  40.  

Reply to "Re: Allocation data fix"