LCKB › ** OLD LCKB DATABASE ** › Guides & Help Section › Tutorials & Guides › Ep2 Guides v
[SQL Codes] Usefull Codes for Ep2!

Threaded Mode
[SQL Codes] Usefull Codes for Ep2!
Lolek1PL Offline
Junior Member
**
Posts: 37
Threads: 6
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Oct 2012
Reputation: 0
#51
10-20-2013, 09:03 PM

quest SP:

UPDATE t_quest SET a_prize_data0 = a_prize_data0*1 WHERE a_prize_index0 = 0 and a_prize_type0 = 3 ;

UPDATE t_quest SET a_prize_data1 = a_prize_data1*1 WHERE a_prize_index1 = 0 and a_prize_type1 = 3 ;

UPDATE t_quest SET a_prize_data2 = a_prize_data2*1 WHERE a_prize_index2 = 0 and a_prize_type2 = 3 ;

just change the Type to whatever u want so u can even edit the gold and more.

Find
pv2_002 Offline
Member
***
Posts: 70
Threads: 2
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Dec 2011
Reputation: 0
#52
10-26-2013, 05:53 PM

Thxvm, can u update the code for activating MoonStone Statue1

 

Thank You

Find
Whazzert...♥ Offline
Member
***
Posts: 226
Threads: 30
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Oct 2012
Reputation: 0
#53
11-04-2013, 01:32 AM


Thxvm, can u update the code for activating MoonStone Statue1

 

Thank You

 
Try this:

 

 

 

INSERT INTO `t_moonstone_reward` VALUES (72, 2545, 485, 3, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (2, 2546, 44, 5, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (3, 723, 45, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (4, 2547, 45, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (5, 2548, 85, 3, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (17, 723, 2403, 10, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (19, 2545, 44, 3, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (21, 2545, 674, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (22, 2545, 973, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (23, 2545, 46, 3, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (24, 2546, 485, 5, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (25, 2546, 971, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (26, 2546, 671, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (27, 2546, 2403, 5, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (28, 2546, 47, 5, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (29, 723, 786, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (30, 723, 724, 5, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (31, 723, 85, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (32, 723, 672, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (33, 723, 2142, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (34, 2547, 786, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (35, 2547, 724, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (36, 2547, 972, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (37, 2547, 673, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (38, 2547, 85, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (39, 2547, 19, 0, 0.0054, 0);

INSERT INTO `t_moonstone_reward` VALUES (40, 2547, 2143, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (41, 2547, 2403, 1, 5, 0);

INSERT INTO `t_moonstone_reward` VALUES (42, 2548, 19, 0, 0.0108, 0);

INSERT INTO `t_moonstone_reward` VALUES (43, 2548, 779, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (44, 2548, 972, 3, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (45, 2548, 786, 3, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (46, 2545, 309, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (47, 2545, 607, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (48, 2545, 324, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (49, 2545, 616, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (50, 2545, 537, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (51, 2545, 642, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (52, 2545, 363, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (54, 2545, 634, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (55, 2545, 983, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (56, 2545, 995, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (57, 2545, 343, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (110, 2545, 625, 1, 1, 0);

INSERT INTO `t_moonstone_reward` VALUES (59, 2546, 793, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (60, 2546, 794, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (61, 2546, 800, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (62, 2546, 801, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (63, 2546, 822, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (64, 2546, 823, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (65, 2546, 815, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (66, 2546, 816, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (67, 2546, 987, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (69, 2546, 999, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (70, 2546, 808, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (71, 2546, 809, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (74, 723, 1321, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (75, 723, 1322, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (76, 723, 1319, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (77, 723, 1320, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (78, 723, 1327, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (79, 723, 1328, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (80, 723, 1326, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (81, 723, 1325, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (82, 723, 1329, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (83, 723, 1330, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (84, 723, 1323, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (85, 723, 1324, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (86, 2547, 1616, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (87, 2547, 1617, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (88, 2547, 1614, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (89, 2547, 1615, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (90, 2547, 1622, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (91, 2547, 1625, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (92, 2547, 1621, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (93, 2547, 1620, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (94, 2547, 1623, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (95, 2547, 1624, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (96, 2547, 1618, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (97, 2547, 1619, 1, 0.2, 0);

INSERT INTO `t_moonstone_reward` VALUES (98, 2548, 1847, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (99, 2548, 1848, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (100, 2548, 1845, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (101, 2548, 1846, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (102, 2548, 1853, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (103, 2548, 1854, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (104, 2548, 1852, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (105, 2548, 1851, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (106, 2548, 1855, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (107, 2548, 1856, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (108, 2548, 1849, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (109, 2548, 1850, 1, 0.1, 0);

INSERT INTO `t_moonstone_reward` VALUES (111, 2545, 19, 0, 0.001, 0);

INSERT INTO `t_moonstone_reward` VALUES (112, 2546, 19, 0, 0.0015, 0);

INSERT INTO `t_moonstone_reward` VALUES (113, 723, 19, 0, 0.0027, 0);

INSERT INTO `t_moonstone_reward` VALUES (115, 2545, 498, 3, 20, 3);

INSERT INTO `t_moonstone_reward` VALUES (116, 2545, 499, 3, 20, 3);

INSERT INTO `t_moonstone_reward` VALUES (117, 2545, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (118, 2546, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (119, 723, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (120, 2547, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (121, 2548, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (122, 2545, 500, 3, 20, 3);

INSERT INTO `t_moonstone_reward` VALUES (123, 2545, 501, 3, 20, 3);

INSERT INTO `t_moonstone_reward` VALUES (125, 2548, 2142, 5, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (126, 2548, 2143, 3, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (151, 2545, 2914, 1, 5, 0);

INSERT INTO `t_moonstone_reward` VALUES (128, 723, 498, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (129, 2546, 498, 3, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (130, 2546, 499, 3, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (131, 2546, 500, 3, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (132, 2546, 501, 3, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (133, 723, 499, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (134, 723, 500, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (135, 723, 501, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (136, 2547, 498, 3, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (137, 2547, 499, 3, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (138, 2547, 500, 3, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (139, 2547, 501, 3, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (140, 2548, 498, 5, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (141, 2548, 499, 5, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (142, 2548, 500, 5, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (143, 2548, 501, 5, 20, 12);

INSERT INTO `t_moonstone_reward` VALUES (144, 2548, 45, 20, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (145, 2548, 724, 20, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (146, 2548, 673, 3, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (150, 2546, 2914, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (149, 2548, 2914, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (148, 2547, 2914, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (147, 723, 2914, 1, 15, 0);

INSERT INTO `t_moonstone_reward` VALUES (204, 6092, 1320, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (203, 6092, 1319, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (202, 6092, 1322, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (201, 6092, 1321, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (200, 6092, 2142, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (199, 6092, 672, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (198, 6092, 85, 1, 0.5, 0);

INSERT INTO `t_moonstone_reward` VALUES (197, 6092, 724, 5, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (196, 6092, 786, 1, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (195, 6092, 2403, 10, 10, 0);

INSERT INTO `t_moonstone_reward` VALUES (194, 6092, 45, 1, 20, 0);

INSERT INTO `t_moonstone_reward` VALUES (205, 6092, 1327, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (206, 6092, 1328, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (207, 6092, 1326, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (208, 6092, 1325, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (209, 6092, 1329, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (210, 6092, 1330, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (211, 6092, 1323, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (212, 6092, 1324, 1, 0.3, 0);

INSERT INTO `t_moonstone_reward` VALUES (213, 6092, 19, 0, 0.0027, 0);

INSERT INTO `t_moonstone_reward` VALUES (214, 6092, 2544, 1, 30, 0);

INSERT INTO `t_moonstone_reward` VALUES (215, 6092, 498, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (216, 6092, 499, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (217, 6092, 500, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (218, 6092, 501, 5, 20, 6);

INSERT INTO `t_moonstone_reward` VALUES (219, 6092, 2914, 1, 15, 0);

 

 

Newproject_data

Find
federico99 Offline
Junior Member
**
Posts: 2
Threads: 1
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Nov 2013
Reputation: 0
#54
11-16-2013, 10:27 PM
Perfect, I was looking for! Thanks.

Find
myangel Offline
Junior Member
**
Posts: 38
Threads: 10
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Oct 2012
Reputation: 0
#55
12-09-2013, 03:57 PM
serach SQL code  for give  all accs   cash  everone have  this

Find
MrBuSta Offline
Senior Member
****
Posts: 301
Threads: 52
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Aug 2012
Reputation: 0
#56
12-09-2013, 05:04 PM

serach SQL code  for give  all accs   cash  everone have  this

UPDATE bg_user SET cash = cash + 5000;

Make this command in newproject_db_auth (In Console)

Its give +5000 Cash for all account.

Find
myangel Offline
Junior Member
**
Posts: 38
Threads: 10
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Oct 2012
Reputation: 0
#57
12-09-2013, 05:16 PM
thx

Find
BlackNight Offline
Junior Member
**
Posts: 29
Threads: 7
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Dec 2013
Reputation: 0
#58
01-29-2014, 07:40 PM
ty

Find


Forum Jump:


Users browsing this thread: 1 Guest(s)