11-20-2012, 11:15 PM
Full working customized Lacaball sql.
4 Pages, changed prizes. Only insert in DB, client will receive data ever from the server. No Serverreboot needed.
Here are an Better code, to prevent Send Error.
This code will clear your Lacaball DB and create an new and fill it with needed Data.
DROP TABLE IF EXISTS `t_lcball`;
CREATE TABLE IF NOT EXISTS `t_lcball` (
`a_item_order` int(10) NOT NULL DEFAULT '0',
`a_tocken_index` int(10) NOT NULL DEFAULT '0',
`a_course_code` tinyint(4) NOT NULL DEFAULT '0',
`a_order` tinyint(4) NOT NULL DEFAULT '0',
`a_item_index` int(10) NOT NULL DEFAULT '0',
`a_item_count` int(10) unsigned NOT NULL DEFAULT '1',
`a_item_max` int(10) unsigned NOT NULL DEFAULT '0',
`a_item_remain` int(10) unsigned NOT NULL DEFAULT '0',
KEY `Index` (`a_course_code`,`a_tocken_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `t_lcball`
--
INSERT INTO `t_lcball` (`a_item_order`, `a_tocken_index`, `a_course_code`, `a_order`, `a_item_index`, `a_item_count`, `a_item_max`, `a_item_remain`) VALUES
(1, 5124, 0, 0, 1416, 10, 1, 1),
(1, 5124, 0, 1, 2357, 5, 100, 97),
(1, 5124, 0, 2, 2356, 5, 200, 198),
(1, 5124, 0, 3, 2394, 1, 300, 293),
(1, 5124, 0, 4, 972, 1, 700, 683),
(1, 5124, 1, 0, 2844, 10, 1, 1),
(1, 5124, 1, 1, 2395, 5, 10, 10),
(1, 5124, 1, 2, 2845, 2, 20, 19),
(1, 5124, 1, 3, 2853, 1, 50, 50),
(1, 5124, 1, 4, 1284, 3, 500, 493),
(1, 5124, 2, 0, 6421, 1, 5, 5),
(1, 5124, 2, 1, 6227, 3, 100, 98),
(1, 5124, 2, 2, 2453, 2, 300, 298),
(1, 5124, 2, 3, 852, 10, 500, 500),
(1, 5124, 2, 4, 2858, 1, 700, 696),
(2, 6653, 0, 0, 5293, 1, 1, 1),
(2, 6653, 0, 1, 5292, 1, 5, 5),
(2, 6653, 0, 2, 5291, 1, 10, 10),
(2, 6653, 0, 3, 5290, 1, 300, 300),
(2, 6653, 0, 4, 5289, 1, 3000, 3000),
(2, 6653, 1, 0, 5268, 1, 1, 1),
(2, 6653, 1, 1, 5267, 1, 5, 5),
(2, 6653, 1, 2, 5266, 1, 10, 10),
(2, 6653, 1, 3, 5265, 1, 300, 300),
(2, 6653, 1, 4, 5264, 1, 3000, 3000),
(2, 6653, 2, 0, 5298, 1, 1, 1),
(2, 6653, 2, 1, 5297, 1, 5, 5),
(2, 6653, 2, 2, 5296, 1, 10, 10),
(2, 6653, 2, 3, 5295, 1, 300, 300),
(2, 6653, 2, 4, 5294, 1, 3000, 3000),
(0, 5123, 0, 0, 5124, 15, 3, 3),
(0, 5123, 0, 1, 6921, 3, 10, 10),
(0, 5123, 0, 2, 882, 15, 30, 30),
(0, 5123, 0, 3, 85, 5, 50, 48),
(0, 5123, 0, 4, 19, 50000, 500, 497),
(0, 5123, 1, 0, 1416, 3, 1, 1),
(0, 5123, 1, 1, 2889, 3, 100, 94),
(0, 5123, 1, 2, 883, 5, 350, 347),
(0, 5123, 1, 3, 85, 5, 500, 492),
(0, 5123, 1, 4, 723, 5, 1000, 978),
(0, 5123, 2, 0, 974, 5, 1, 1),
(0, 5123, 2, 1, 2888, 3, 100, 99),
(0, 5123, 2, 2, 882, 5, 300, 297),
(0, 5123, 2, 3, 85, 5, 500, 496),
(0, 5123, 2, 4, 724, 10, 1000, 990),
(3, 6939, 0, 0, 5124, 15, 1, 1),
(3, 6939, 0, 1, 2848, 10, 50, 50),
(3, 6939, 0, 2, 1419, 6, 100, 100),
(3, 6939, 0, 3, 1299, 1, 400, 399),
(3, 6939, 0, 4, 19, 500000, 1000, 996),
(3, 6939, 1, 0, 2968, 3, 1, 1),
(3, 6939, 1, 1, 4923, 1, 50, 49),
(3, 6939, 1, 2, 4924, 1, 50, 49),
(3, 6939, 1, 3, 5124, 1, 500, 488),
(3, 6939, 1, 4, 5123, 2, 1000, 971),
(3, 6939, 2, 0, 19, 5000000, 1, 1),
(3, 6939, 2, 1, 19, 500000, 1000, 1000),
(3, 6939, 2, 2, 19, 250000, 2000, 2000),
(3, 6939, 2, 3, 19, 100000, 3000, 3000),
(3, 6939, 2, 4, 19, 50000, 5000, 4999);