Exp/Drop rate

[wtvelocity]

Ok, I know I've been asking alot of questions, but I'm just learning MySQL (Ironic really, I know HTML, CSS, some Javascript and C++, you'd think I'd know this at least a little before now XP).
So anyhow, thanks to the people who answered my questions, and I always try to remember to click "thanks" on your helpful posts

So anyhow, I'm at I believe the final part of setup that I can't even find the guides for: How do I change exp/drop rates?

I wanted to play this as a small server with my friends, but like the original settings more or less, but I get out of town, there is a giant spider, and before I even think "WTF", I am level 6 and have 83457490257498075459084735 gold (ok exaggerated) gold. So ummm..... how do I make it mostly like the original?

[magewarior2]

there are lots of guide`s to change the droprate.


for an example =>

an all things guide

or a:

and leveling is at cq_levexp

just change the numbers of type "1" to change it. raise the numbers, you need more exp.

lower the number, you need less exp to level....

type 2 is for PdefMdef only.


good luck.

ps. i recommend to use second link

[wtvelocity]

Thanks! Now to figure out what the spider was that popped up :P

That will take a while to do though, I was serving it on localhost, now I'm trying to figure out why MsgServer wont connect after putting in my online IP lol XD

Ok, ummmm..... I dont have a CLUE what I'm looking at on the exp tables, except the requirements.... how do I lower how much is obtained?

Better yet, anyone have a table or script i could import with the original, or close to original, exp rates?

Anybody have an exp table close to original settings, with YM or MSN that I could IM to send me a copy of their exp table please?

I have been looking online, and can't find access to any: only servers who have standard settings. Any way to copy from theirs, if it's unpublished?

[magewarior2]

use it of the paladin version!

[wtvelocity]

Thanks for the tip, I'm assuming the paladin version has mostly original databases?

I did some research, and finally found a drop table for command to set it, fixed a bug in it and it works!:

ET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cq_levexp`
-- ----------------------------
DROP TABLE IF EXISTS `my.cq_levexp`;
CREATE TABLE `cq_levexp` (
  `level` int(4) unsigned zerofill NOT NULL default '0000',
  `exp` bigint(4) NOT NULL default '0',
  `up_lev_time` int(4) NOT NULL default '0',
  PRIMARY KEY  (`level`)
) TYPE=MyISAM;

-- ----------------------------
-- Records of cq_levexp
-- ----------------------------
INSERT INTO `cq_levexp` VALUES ('0001', '120', '2');
INSERT INTO `cq_levexp` VALUES ('0002', '180', '2');
INSERT INTO `cq_levexp` VALUES ('0003', '240', '1');
INSERT INTO `cq_levexp` VALUES ('0004', '360', '2');
INSERT INTO `cq_levexp` VALUES ('0005', '600', '2');
INSERT INTO `cq_levexp` VALUES ('0006', '960', '3');
INSERT INTO `cq_levexp` VALUES ('0007', '1200', '3');
INSERT INTO `cq_levexp` VALUES ('0008', '2400', '5');
INSERT INTO `cq_levexp` VALUES ('0009', '3600', '7');
INSERT INTO `cq_levexp` VALUES ('0010', '8400', '14');
INSERT INTO `cq_levexp` VALUES ('0011', '12000', '18');
INSERT INTO `cq_levexp` VALUES ('0012', '14400', '20');
INSERT INTO `cq_levexp` VALUES ('0013', '18000', '23');
INSERT INTO `cq_levexp` VALUES ('0014', '21600', '26');
INSERT INTO `cq_levexp` VALUES ('0015', '22646', '25');
INSERT INTO `cq_levexp` VALUES ('0016', '32203', '34');
INSERT INTO `cq_levexp` VALUES ('0017', '37433', '37');
INSERT INTO `cq_levexp` VALUES ('0018', '47556', '44');
INSERT INTO `cq_levexp` VALUES ('0019', '56609', '50');
INSERT INTO `cq_levexp` VALUES ('0020', '68772', '57');
INSERT INTO `cq_levexp` VALUES ('0021', '70515', '56');
INSERT INTO `cq_levexp` VALUES ('0022', '75936', '58');
INSERT INTO `cq_levexp` VALUES ('0023', '97733', '59');
INSERT INTO `cq_levexp` VALUES ('0024', '114836', '66');
INSERT INTO `cq_levexp` VALUES ('0025', '120853', '67');
INSERT INTO `cq_levexp` VALUES ('0026', '123981', '66');
INSERT INTO `cq_levexp` VALUES ('0027', '126720', '65');
INSERT INTO `cq_levexp` VALUES ('0028', '145878', '72');
INSERT INTO `cq_levexp` VALUES ('0029', '173436', '83');
INSERT INTO `cq_levexp` VALUES ('0030', '197646', '92');
INSERT INTO `cq_levexp` VALUES ('0031', '202451', '91');
INSERT INTO `cq_levexp` VALUES ('0032', '212160', '92');
INSERT INTO `cq_levexp` VALUES ('0033', '244190', '103');
INSERT INTO `cq_levexp` VALUES ('0034', '285823', '117');
INSERT INTO `cq_levexp` VALUES ('0035', '305986', '121');
INSERT INTO `cq_levexp` VALUES ('0036', '312864', '121');
INSERT INTO `cq_levexp` VALUES ('0037', '324480', '122');
INSERT INTO `cq_levexp` VALUES ('0038', '366168', '134');
INSERT INTO `cq_levexp` VALUES ('0039', '433959', '155');
INSERT INTO `cq_levexp` VALUES ('0040', '460590', '160');
INSERT INTO `cq_levexp` VALUES ('0041', '506738', '172');
INSERT INTO `cq_levexp` VALUES ('0042', '569994', '188');
INSERT INTO `cq_levexp` VALUES ('0043', '728527', '235');
INSERT INTO `cq_levexp` VALUES ('0044', '850829', '269');
INSERT INTO `cq_levexp` VALUES ('0045', '916479', '283');
INSERT INTO `cq_levexp` VALUES ('0046', '935118', '282');
INSERT INTO `cq_levexp` VALUES ('0047', '940800', '278');
INSERT INTO `cq_levexp` VALUES ('0048', '1076593', '312');
INSERT INTO `cq_levexp` VALUES ('0049', '1272780', '361');
INSERT INTO `cq_levexp` VALUES ('0050', '1357994', '302');
INSERT INTO `cq_levexp` VALUES ('0051', '1384861', '302');
INSERT INTO `cq_levexp` VALUES ('0052', '1478400', '316');
INSERT INTO `cq_levexp` VALUES ('0053', '1632438', '342');
INSERT INTO `cq_levexp` VALUES ('0054', '1903104', '392');
INSERT INTO `cq_levexp` VALUES ('0055', '2066042', '417');
INSERT INTO `cq_levexp` VALUES ('0056', '2104924', '418');
INSERT INTO `cq_levexp` VALUES ('0057', '1921085', '374');
INSERT INTO `cq_levexp` VALUES ('0058', '2417202', '463');
INSERT INTO `cq_levexp` VALUES ('0059', '2853462', '537');
INSERT INTO `cq_levexp` VALUES ('0060', '3054574', '566');
INSERT INTO `cq_levexp` VALUES ('0061', '3111217', '567');
INSERT INTO `cq_levexp` VALUES ('0062', '3225600', '578');
INSERT INTO `cq_levexp` VALUES ('0063', '3810962', '672');
INSERT INTO `cq_levexp` VALUES ('0064', '4437896', '770');
INSERT INTO `cq_levexp` VALUES ('0065', '4880605', '834');
INSERT INTO `cq_levexp` VALUES ('0066', '4970962', '837');
INSERT INTO `cq_levexp` VALUES ('0067', '5107200', '847');
INSERT INTO `cq_levexp` VALUES ('0068', '5652518', '924');
INSERT INTO `cq_levexp` VALUES ('0069', '6579162', '1059');
INSERT INTO `cq_levexp` VALUES ('0070', '6877991', '819');
INSERT INTO `cq_levexp` VALUES ('0071', '7100700', '833');
INSERT INTO `cq_levexp` VALUES ('0072', '7157657', '828');
INSERT INTO `cq_levexp` VALUES ('0073', '9106860', '1040');
INSERT INTO `cq_levexp` VALUES ('0074', '10596398', '1193');
INSERT INTO `cq_levexp` VALUES ('0075', '11220549', '831');
INSERT INTO `cq_levexp` VALUES ('0076', '11409192', '834');
INSERT INTO `cq_levexp` VALUES ('0077', '11424000', '824');
INSERT INTO `cq_levexp` VALUES ('0078', '12882952', '918');
INSERT INTO `cq_levexp` VALUES ('0079', '15172807', '1067');
INSERT INTO `cq_levexp` VALUES ('0080', '15896990', '1104');
INSERT INTO `cq_levexp` VALUES ('0081', '16163799', '1109');
INSERT INTO `cq_levexp` VALUES ('0082', '16800000', '1138');
INSERT INTO `cq_levexp` VALUES ('0083', '19230280', '1287');
INSERT INTO `cq_levexp` VALUES ('0084', '22365208', '1479');
INSERT INTO `cq_levexp` VALUES ('0085', '23819312', '1557');
INSERT INTO `cq_levexp` VALUES ('0086', '24219528', '1565');
INSERT INTO `cq_levexp` VALUES ('0087', '24864000', '1588');
INSERT INTO `cq_levexp` VALUES ('0088', '27200077', '1717');
INSERT INTO `cq_levexp` VALUES ('0089', '32033165', '2000');
INSERT INTO `cq_levexp` VALUES ('0090', '33723801', '2082');
INSERT INTO `cq_levexp` VALUES ('0091', '34291317', '2093');
INSERT INTO `cq_levexp` VALUES ('0092', '34944000', '1662');
INSERT INTO `cq_levexp` VALUES ('0093', '39463523', '1877');
INSERT INTO `cq_levexp` VALUES ('0094', '45878567', '2182');
INSERT INTO `cq_levexp` VALUES ('0095', '48924236', '2326');
INSERT INTO `cq_levexp` VALUES ('0096', '49729220', '2365');
INSERT INTO `cq_levexp` VALUES ('0097', '51072000', '2429');
INSERT INTO `cq_levexp` VALUES ('0098', '55808379', '2654');
INSERT INTO `cq_levexp` VALUES ('0099', '64870058', '3085');
INSERT INTO `cq_levexp` VALUES ('0100', '68391931', '3252');
INSERT INTO `cq_levexp` VALUES ('0101', '69537026', '3307');
INSERT INTO `cq_levexp` VALUES ('0102', '76422968', '3634');
INSERT INTO `cq_levexp` VALUES ('0103', '96950789', '4610');
INSERT INTO `cq_levexp` VALUES ('0104', '112676755', '5358');
INSERT INTO `cq_levexp` VALUES ('0105', '120090482', '5710');
INSERT INTO `cq_levexp` VALUES ('0106', '121798280', '5792');
INSERT INTO `cq_levexp` VALUES ('0107', '127680000', '6071');
INSERT INTO `cq_levexp` VALUES ('0108', '137446887', '6536');
INSERT INTO `cq_levexp` VALUES ('0109', '193715970', '9211');
INSERT INTO `cq_levexp` VALUES ('0110', '408832150', '9720');
INSERT INTO `cq_levexp` VALUES ('0111', '454674685', '10810');
INSERT INTO `cq_levexp` VALUES ('0112', '461125885', '10964');
INSERT INTO `cq_levexp` VALUES ('0113', '469189885', '11155');
INSERT INTO `cq_levexp` VALUES ('0114', '477253885', '11347');
INSERT INTO `cq_levexp` VALUES ('0115', '480479485', '11424');
INSERT INTO `cq_levexp` VALUES ('0116', '485317885', '11539');
INSERT INTO `cq_levexp` VALUES ('0117', '493381885', '11730');
INSERT INTO `cq_levexp` VALUES ('0118', '580580046', '13804');
INSERT INTO `cq_levexp` VALUES ('0119', '717424987', '17057');
INSERT INTO `cq_levexp` VALUES ('0120', '282274058', '6711');
INSERT INTO `cq_levexp` VALUES ('0121', '338728870', '8054');
INSERT INTO `cq_levexp` VALUES ('0122', '406474644', '9664');
INSERT INTO `cq_levexp` VALUES ('0123', '487769572', '11597');
INSERT INTO `cq_levexp` VALUES ('0124', '585323487', '13917');
INSERT INTO `cq_levexp` VALUES ('0125', '702388184', '16700');
INSERT INTO `cq_levexp` VALUES ('0126', '842865821', '20040');
INSERT INTO `cq_levexp` VALUES ('0127', '1011438985', '24048');
INSERT INTO `cq_levexp` VALUES ('0128', '1073741823', '25527');
INSERT INTO `cq_levexp` VALUES ('0129', '1073741823', '25527');
INSERT INTO `cq_levexp` VALUES ('0130', '8589134588', '102106');
INSERT INTO `cq_levexp` VALUES ('0131', '25767403764', '153159');
INSERT INTO `cq_levexp` VALUES ('0132', '77302211292', '229739');
INSERT INTO `cq_levexp` VALUES ('0133', '231906633876', '344608');
INSERT INTO `cq_levexp` VALUES ('0134', '347859950814', '516912');
INSERT INTO `cq_levexp` VALUES ('0135', '521789926221', '775368');
INSERT INTO `cq_levexp` VALUES ('0136', '782684889332', '1163052');
INSERT INTO `cq_levexp` VALUES ('0137', '0', '0');

But I may go and use the paladin database anyhow, because I prefer mostly like the original server, if that's what it is