XML-RPC memory leak question..

[eluser]ArcticZero[/eluser]

Code:

CREATE TABLE `sales` (
  `date` date NOT NULL default '0000-00-00',
  `customer_id` int(8) NOT NULL default '0',
  `sale_sub_total` varchar(12) NOT NULL default '',
  `sale_total_cost` varchar(30) NOT NULL default '',
  `paid_with` varchar(25) NOT NULL default '',
  `items_purchased` int(8) NOT NULL default '0',
  `percent_discount` varchar(5) NOT NULL default '0',
  `sold_by` int(8) NOT NULL default '0',
  `comment` varchar(100) NOT NULL default '',
  `id` int(8) NOT NULL auto_increment,
  `amount_tendered` varchar(15) default NULL,
  `change` varchar(15) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Contains overall sale details' AUTO_INCREMENT=11 ;

CREATE TABLE `sales_items` (
  `sale_id` int(8) NOT NULL default '0',
  `item_id` int(8) NOT NULL default '0',
  `quantity_purchased` int(8) NOT NULL default '0',
  `item_unit_price` varchar(15) NOT NULL default '0',
  `item_buy_price` varchar(30) NOT NULL default '0',
  `item_tax_percent` varchar(10) NOT NULL default '0',
  `item_total_tax` varchar(12) NOT NULL default '0',
  `item_total_cost` varchar(12) NOT NULL default '0',
  `id` int(8) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table that holds item information for sales' AUTO_INCREMENT=1 ;

Just did an export of the sales/sales_items table structures for reference. I do appreciate the time you're putting into this.

Also, here is a sample script I use to insert lots of data for testing purposes:

Code:

<?php
    $sql = mysql_connect("localhost", "root", "");
    $db = mysql_select_db("clientdatabase", $sql);
    
    $sales = 10000;
    $items_per_sale = 10;
    
    for($i = 0; $i < $sales; $i++)
    {
        $last_id = false;
        $query = mysql_query("INSERT INTO sales (`date`, customer_id, sale_sub_total, sale_total_cost, paid_with, items_purchased, percent_discount, sold_by, amount_tendered, `change`, `status`) VALUES ('2008-02-19', 7, '4000.50', '4000.50', 'Cash', '20', '0', 1, '4001', '0.50', 0)", $sql);
        
        $last_id = mysql_insert_id($sql);
        
        for($z = 0; $z < $items_per_sale; $z++)
        {
            $query = mysql_query("INSERT INTO sales_items (sale_id, item_id, quantity_purchased, item_unit_price, item_buy_price, item_tax_percent, item_total_tax, item_total_cost) VALUES (" . $last_id . ", 1, 5, 110, 100, 10, 10, 550)", $sql);
        }
    }
    
    if($query)
    {
        echo "$sales records inserted.";
    }
    else
    {
        echo mysql_error($sql);
    }
?&gt;

Again, thank you very much!