TerraNet Database Revision 8

Unbanned all your ips from AP.org, you can feel free to post tn there if you so wish to (not that it matters site is dead :P)

Leeching is a crappy thing, but basically it happens regardless of what we try to do, thanks for offering help intel wise, I can return the same back to you or any devs at any db's for that matter, I know most of the structure, there are few tables that I haven't worked on (maybe 1 or 2) but other then that any questions at all db wise I should be able to answer.

About the meeting on msn, honestly I think that was at a time that things were to heated was a little to soon to try to work things out, recently I've been disconnected from the db world (managing a server, aswell as other things) seemed neither one of us was really ready to drop our respective arguments and or views.

@Lemon

remove the portals in next release pls. Isnt that the transports work just fine?

as long as the orb of translocation is missing, the portal to silvermoon in Undercity needs to be there.

THe problem i'm having is that prospecting doesn't work. NO loot window opens. The prospecting SQL from SVN didn't help when i ran it.

PS: Lemon, I think the word you are looking for is "trust" not "thrust"...

I think its understood that Lemon doesn't speak English as a first language.

Prospecting isnt in rev8, look at our rev9 changelog.

can some one upload this database in seperate sql file cuz this database last forever to install thanz

here is a prospecting table;

Code:

---

/*
MySQL Data Transfer
Source Host: localhost
Source Database: wow.rockon.no
Target Host: localhost
Target Database: wow.rockon.no
Date: 16.08.2007 14:06:17
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for prospectingloot
-- ----------------------------
CREATE TABLE `prospectingloot` (
  `index` int(11) NOT NULL auto_increment,
  `entryid` int(11) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '25',
  `percentchance` float NOT NULL default '0',
  `heroicpercentchance` float NOT NULL default '0',
  `mincount` int(30) NOT NULL default '1',
  `maxcount` int(30) NOT NULL default '1',
  PRIMARY KEY  (`index`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `prospectingloot` VALUES ('2', '2770', '24186', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('3', '2770', '774', '50.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('4', '2770', '818', '49.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('5', '2770', '1210', '9.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('6', '2771', '24188', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('7', '2771', '1206', '38.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('8', '2771', '1206', '38.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('9', '2771', '1705', '37.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('10', '2771', '1705', '37.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('11', '2771', '1210', '36.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('12', '2771', '1210', '36.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('13', '2771', '1529', '3.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('14', '2771', '3864', '3.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('15', '2771', '7909', '3.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('16', '2772', '24190', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('17', '2772', '1529', '32.2', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('18', '2772', '1529', '32.2', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('19', '2772', '3864', '31.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('20', '2772', '3864', '31.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('21', '2772', '1705', '30.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('22', '2772', '1705', '30.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('23', '2772', '7910', '5.2', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('24', '2772', '7909', '5.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('25', '3858', '24234', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('26', '3858', '7910', '32.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('27', '3858', '7910', '32.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('28', '3858', '7919', '31.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('29', '3858', '7909', '31.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('30', '3858', '7909', '31.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('31', '3858', '3864', '30.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('32', '3858', '3864', '30.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('33', '3858', '12799', '2.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('34', '3858', '12361', '2.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('35', '3858', '12364', '2.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('36', '3858', '12800', '2.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('37', '10620', '24235', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('38', '10620', '7910', '28.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('39', '10620', '7910', '28.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('40', '10620', '12361', '17.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('41', '10620', '12361', '17.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('42', '10620', '12364', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('43', '10620', '12364', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('44', '10620', '12800', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('45', '10620', '12800', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('46', '10620', '12799', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('47', '10620', '12799', '17.1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('48', '10620', '21929', '1.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('49', '10620', '23112', '1.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('50', '10620', '23107', '1.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('51', '10620', '23079', '1.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('52', '10620', '23077', '1.3', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('53', '10620', '23117', '1.2', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('54', '10620', '24235', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('55', '23424', '24243', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('56', '23424', '23079', '16.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('57', '23424', '23079', '16.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('58', '23424', '23112', '16.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('59', '23424', '23112', '16.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('60', '23424', '21929', '16.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('61', '23424', '21929', '16.5', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('62', '23424', '23077', '16.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('63', '23424', '23077', '16.4', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('64', '23424', '23107', '16.2', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('65', '23424', '23117', '15.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('66', '23424', '23117', '15.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('67', '23424', '23439', '1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('68', '23424', '23437', '1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('69', '23424', '23436', '1', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('70', '23424', '23438', '0.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('71', '23424', '23440', '0.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('72', '23424', '3864', '0.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('73', '23425', '24243', '100', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('74', '23425', '21929', '18.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('75', '23425', '23079', '18.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('76', '23425', '23117', '18.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('77', '23425', '23112', '18.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('78', '23425', '23077', '18.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('79', '23425', '23107', '18.6', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('80', '23425', '23437', '2.9', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('81', '23425', '23439', '2.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('82', '23425', '23440', '2.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('83', '23425', '23436', '2.8', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('84', '23425', '23441', '2.7', '0', '1', '1');
INSERT INTO `prospectingloot` VALUES ('85', '23425', '23438', '2.7', '0', '1', '1');

---

This is well and good....look at the changelog for rev 9 but how do I go about getting rev 9. It appears rev 9 is not publically available.

I have a prospectingloot table, and the loot window still doesn't even open up. any other tricks to turn on prospecting?