[SQL Codes] Usefull Codes for Ep2!

[Havelok]

Full working customized Lacaball sql.

 

4 Pages, changed prizes. Only insert in DB, client will receive data ever from the server. No Serverreboot needed.

 

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);