Any one can help with that they have No star Ranks i tried to fix but couldnt i think its cq_dyna_rank_type did it in it nothing happened
[Help]Star Rank on the NewMounts
08/22/2008 10:56
erreway#1
08/22/2008 12:59
Rawsteeey#2
o have the same problem
08/22/2008 15:04
DiobloSlayeR#3
Me too, the obsid and goldrag don't get ranks.. idk why
08/23/2008 06:22
Kradel#4
Try this. Change the ID value if you have pre-existing ranks that use these values.
Code:
INSERT INTO `cq_dyna_rank_type` VALUES ('10001', '1188010', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10002', '1188011', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10003', '1188014', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10004', '1188015', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10005', '1188016', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10006', '1188020', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10007', '1188021', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10008', '1188024', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10009', '1188025', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10010', '1188026', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10011', '1188040', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10012', '1189010', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10013', '1189011', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10014', '1189012', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10015', '1189013', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10016', '1189014', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10017', '1189015', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10018', '1189016', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10019', '1189020', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10020', '1189021', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10021', '1189022', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10022', '1189023', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10023', '1189024', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10024', '1189025', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10025', '1189026', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10026', '1189040', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10027', '2188010', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10028', '2188011', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10029', '2188014', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10030', '2188015', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10031', '2188016', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10032', '2188020', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10033', '2188021', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10034', '2188024', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10035', '2188025', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10036', '2188026', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10037', '2188040', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10038', '2189010', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10039', '2189011', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10040', '2189012', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10041', '2189013', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10042', '2189014', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10043', '2189015', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10044', '2189016', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10045', '2189020', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10046', '2189021', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10047', '2189022', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10048', '2189023', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10049', '2189024', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10050', '2189025', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10051', '2189026', '120');
INSERT INTO `cq_dyna_rank_type` VALUES ('10052', '2189040', '120');
08/23/2008 12:23
Rawsteeey#5
does it work at u?
08/23/2008 12:42
Kradel#6
Yep. If your tables aren't set right, funhacker's query won't work, but the code I posted is straight from my database, and the ranks work on my server.
08/23/2008 13:17
Memodark4sony#7
YEH ITS WORKING 1000000000000000000000000000000000000%
08/25/2008 02:50
funhacker#8
seriously dont use dumps they are ugly lolQuote:
Try this. Change the ID value if you have pre-existing ranks that use these values.
Code:INSERT INTO `cq_dyna_rank_type` VALUES ('10001', '1188010', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10002', '1188011', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10003', '1188014', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10004', '1188015', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10005', '1188016', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10006', '1188020', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10007', '1188021', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10008', '1188024', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10009', '1188025', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10010', '1188026', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10011', '1188040', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10012', '1189010', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10013', '1189011', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10014', '1189012', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10015', '1189013', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10016', '1189014', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10017', '1189015', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10018', '1189016', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10019', '1189020', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10020', '1189021', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10021', '1189022', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10022', '1189023', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10023', '1189024', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10024', '1189025', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10025', '1189026', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10026', '1189040', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10027', '2188010', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10028', '2188011', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10029', '2188014', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10030', '2188015', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10031', '2188016', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10032', '2188020', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10033', '2188021', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10034', '2188024', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10035', '2188025', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10036', '2188026', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10037', '2188040', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10038', '2189010', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10039', '2189011', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10040', '2189012', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10041', '2189013', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10042', '2189014', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10043', '2189015', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10044', '2189016', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10045', '2189020', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10046', '2189021', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10047', '2189022', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10048', '2189023', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10049', '2189024', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10050', '2189025', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10051', '2189026', '120'); INSERT INTO `cq_dyna_rank_type` VALUES ('10052', '2189040', '120');
Code:
insert into cq_dyna_rank_type
Values
('10001', '1188010', '120'),
('10002', '1188011', '120'),
('10003', '1188014', '120'),
('10004', '1188015', '120'),
('10005', '1188016', '120'),
('10006', '1188020', '120'),
('10007', '1188021', '120'),
('10008', '1188024', '120'),
('10009', '1188025', '120'),
('10010', '1188026', '120'),
('10011', '1188040', '120'),
('10012', '1189010', '120'),
('10013', '1189011', '120'),
('10014', '1189012', '120'),
('10015', '1189013', '120'),
('10016', '1189014', '120'),
('10017', '1189015', '120'),
('10018', '1189016', '120'),
('10019', '1189020', '120'),
('10020', '1189021', '120'),
('10021', '1189022', '120'),
('10022', '1189023', '120'),
('10023', '1189024', '120'),
('10024', '1189025', '120'),
('10025', '1189026', '120'),
('10026', '1189040', '120'),
('10027', '2188010', '120'),
('10028', '2188011', '120'),
('10029', '2188014', '120'),
('10030', '2188015', '120'),
('10031', '2188016', '120'),
('10032', '2188020', '120'),
('10033', '2188021', '120'),
('10034', '2188024', '120'),
('10035', '2188025', '120'),
('10036', '2188026', '120'),
('10037', '2188040', '120'),
('10038', '2189010', '120'),
('10039', '2189011', '120'),
('10040', '2189012', '120'),
('10041', '2189013', '120'),
('10042', '2189014', '120'),
('10043', '2189015', '120'),
('10044', '2189016', '120'),
('10045', '2189020', '120'),
('10046', '2189021', '120'),
('10047', '2189022', '120'),
('10048', '2189023', '120'),
('10049', '2189024', '120'),
('10050', '2189025', '120'),
('10051', '2189026', '120'),
('10052', '2189040', '120');
08/25/2008 06:47
erreway#9
ty Kradel and funhacker
08/25/2008 11:31
Kradel#10
Aesthetic value takes a back seat to simplicity and functionality. P:Quote:
I just started tampering with MySQL a month ago, give me a break. :[