[SQL Codes] Usefull Codes for Ep2!

[KillEveryThing]

Woot Nice.

[LikeToMove]

Nice tips, but you posting the same code for exp and events

[xNiceEinz]

edited. Lacabll fix from Elitepvpers added. Now you can have 4 pages!

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

[xNiceEinz]

Edited again!

 

Added:

 

 

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

 

 

[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.

 

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

[Paramount]

Mhhh, an error "Send error report" when i click to "Gold token"

[KaPaTeJIb777]

UPDATE t_eventsettings SET a_enable = 1; Unknown column 'a_enable' in 'field list

[xNiceEinz]

Mhhh, an error "Send error report" when i click to "Gold token"

 

Empty your Lacaball Tabell before you use it.

 

UPDATE t_eventsettings SET a_enable = 1; Unknown column 'a_enable' in 'field list

 

Use:

 

UPDATE t_eventsettings SET a_enable_ger

[reneh99]

"update t_exp set a_exp = a_exp / x;" is much better, as it take down the needed exp