[FIX] LacaBall

[Havelok]

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]

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]

Thanks Havelok have give you credits in my sql thread.

[KillEveryThing]

[MATTHIAS0397]

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]

on me the table is in newproject_db it is right there?

[Koko]

Yep

[Lythenica]

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]

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