+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 2 Releases (https://lckb.dev/forum/forumdisplay.php?fid=186)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=143)
+----- Thread: [FIX] LacaBall (/showthread.php?tid=1243)
Pages:
1
2
- Havelok - 11-18-2012
insert this in your t_lcball an you will have an 4. side with extra items.
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
(3, 6939, 0, 0, 5124, 15, 3, 3),
(3, 6939, 0, 1, 6921, 3, 10, 10),
(3, 6939, 0, 2, 882, 15, 30, 30),
(3, 6939, 0, 3, 85, 5, 50, 49),
(3, 6939, 0, 4, 19, 500000, 500, 499),
(3, 6939, 1, 0, 1416, 3, 1, 1),
(3, 6939, 1, 1, 2889, 3, 100, 96),
(3, 6939, 1, 2, 884, 5, 350, 346),
(3, 6939, 1, 3, 85, 5, 500, 497),
(3, 6939, 1, 4, 723, 5, 1000, 991),
(3, 6939, 2, 0, 974, 5, 1, 1),
(3, 6939, 2, 1, 2888, 3, 100, 99),
(3, 6939, 2, 2, 882, 5, 300, 297),
(3, 6939, 2, 3, 85, 5, 500, 496),
(3, 6939, 2, 4, 724, 10, 1000, 990);
- EiSyntax - 11-19-2012
insert this in your t_lcball an you will have an 4. side with extra items.
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
(3, 6939, 0, 0, 5124, 15, 3, 3),
(3, 6939, 0, 1, 6921, 3, 10, 10),
(3, 6939, 0, 2, 882, 15, 30, 30),
(3, 6939, 0, 3, 85, 5, 50, 49),
(3, 6939, 0, 4, 19, 500000, 500, 499),
(3, 6939, 1, 0, 1416, 3, 1, 1),
(3, 6939, 1, 1, 2889, 3, 100, 96),
(3, 6939, 1, 2, 884, 5, 350, 346),
(3, 6939, 1, 3, 85, 5, 500, 497),
(3, 6939, 1, 4, 723, 5, 1000, 991),
(3, 6939, 2, 0, 974, 5, 1, 1),
(3, 6939, 2, 1, 2888, 3, 100, 99),
(3, 6939, 2, 2, 882, 5, 300, 297),
(3, 6939, 2, 3, 85, 5, 500, 496),
(3, 6939, 2, 4, 724, 10, 1000, 990);
Welcome to lckb Havelok :3
- xNiceEinz - 11-20-2012
Thanks Havelok have give you credits in my sql thread.
- KillEveryThing - 12-07-2012
- MATTHIAS0397 - 02-09-2013
Hello
Unfortunately I have no table in my database with the names t_lcball.
If someone would be so kind to me once could enter the query I would be very grateful.
which I can then create the table once.
thank you in advance.
- deadlegend - 02-10-2013
on me the table is in newproject_db it is right there?
- Koko - 02-10-2013
Yep
- Lythenica - 02-10-2013
Hello,
I dont know i you know it already but you have max items per side 5 if you have more than you will get Send error.
You can make more sides for Laca or Golden Laca if you need it you can edit it in course_code (change value to 1 to have a second side, to 2 to have a third site etc) but be sure you wont have more than 5 Items per side and and dont have wrong values insert to the database, because its all causing send error reports with all clients.
For laca there is no server restard of need, you can update them live
Im still testing you to make item reduce if you have played a game
- Lythenica - 02-18-2013
Hello,
I have noticed many of the Private Servers uses LCBall but just the items which havelok released but idk why...
to set up the LCBall is quit easy just give a_item_order 1 if you use Nomal Laca ring,
give a_item_order 2 for Golden Laca ring and so on... You see adding new Items isnt hard
Example:
for normal Laca Ring:
INSERT INTO `t_lcball` VALUES (1, 5123, 0, 0, 85, 5, 50, 50);
this will add Heavenstones (5 per win) with max wins 50 and will reduce by 1 if play a game (so Normal LC ring has a:item_order 1 keep it !)
for Golden Laca Ring
INSERT INTO `t_lcball` VALUES (2, 5124, 0, 0, 1416, 1, 1, 1);
this will add PBI for an Golden Laca ring with item remain 1 and max item is 1 too. That means this Item Just can be won one Time, after that it has to wait till reset!
So now try it out, add new stuff in you LCBall and add maybe some custom stuff to it
Hope this helps you a bit