+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: [SQL Codes] Usefull Codes for Ep2! (/showthread.php?tid=1244)
- KillEveryThing - 11-18-2012
Woot Nice.
- LikeToMove - 11-19-2012
Nice tips, but you posting the same code for exp and events
- xNiceEinz - 11-20-2012
edited. Lacabll fix from Elitepvpers added. Now you can have 4 pages!
- Havelok - 11-20-2012
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 - 11-20-2012
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 - 11-20-2012
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 - 11-21-2012
Mhhh, an error "Send error report" when i click to "Gold token"
- KaPaTeJIb777 - 11-21-2012
UPDATE t_eventsettings SET a_enable = 1; Unknown column 'a_enable' in 'field list
- xNiceEinz - 11-21-2012
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 - 11-23-2012
"update t_exp set a_exp = a_exp / x;" is much better, as it take down the needed exp