Changeset 689 for trunk/Common
- Timestamp:
- Sep 7, 2014, 6:15:54 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Common/Setup/Updates.php
r688 r689 889 889 // Convert monthly plus payment for consumption to regular service 890 890 $DbResult = $Manager->Execute('SELECT `MonthlyPlus`, `Member` FROM `MemberPayment` WHERE `MonthlyPlus` > 0'); 891 while($DbR esult->num_rows > 0)891 while($DbRow = $DbResult->fetch_assoc) 892 892 { 893 $DbRow = $DbResult->fetch_assoc();894 893 $Manager->Execute("INSERT INTO `Service` (`Id` ,`Name` ,`Category` ,`Price` ,`VAT`) ". 895 894 "VALUES (NULL , 'Spotřeba energie', 3, -".$DbRow['MonthlyPlus'].", 2);");
Note:
See TracChangeset
for help on using the changeset viewer.