grisouille_slith
Posts: 614
Joined: 6/7/2007 Status: offline
|
quote:
ORIGINAL: n01487477 quote:
ORIGINAL: grisouille quote:
ORIGINAL: n01487477 quote:
ORIGINAL: grisouille I've just bought a PC (Win7, 64 bits). Could you tell me the different steps to install witptracker on such computer. Thanks/ Basically the same, install 32 bit java, 32 bit C++ redist and you should be good to go ... http://sites.google.com/site/witptracker/support I've installed java and C++. When I lauch witptracker, the database are initialized and the script stops.. "Pause" "click to continue.." error message ? Using the beta ? I use ver 1.8. lots messages are displayed in the java windows, but impossible to read them, and finally the window is closed. I have that file.. CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE TURNINFO(TURN SMALLINT NOT NULL PRIMARY KEY,GAMEDATE VARCHAR(6),COMMENT VARCHAR(100),SAVEDATE VARCHAR(40)) CREATE CACHED TABLE DEVICES(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),TYPE TINYINT,LOADCOST SMALLINT,RANGE SMALLINT,EFFECTIVENESS SMALLINT,PENETRATION SMALLINT,ACCURACY SMALLINT,DUDRATE TINYINT,CEILING INTEGER,ARMOR SMALLINT,ANTIARMOR SMALLINT,ANTISOFT SMALLINT,UPGRADETO SMALLINT,BUILDRATE SMALLINT,AVAILYEAR TINYINT,AVAILMONTH TINYINT,SIDE TINYINT) CREATE CACHED TABLE ARMAMENTPOOL(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,INPOOL INTEGER,USEDFROMPOOL INTEGER,ACTIVEPOOL INTEGER,PRIMARY KEY(ID,TURN)) CREATE CACHED TABLE SHIPCLASSES(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(25),TYPE TINYINT,NATION TINYINT,CLASSNUMBER SMALLINT,TONNAGE INTEGER,MAXSPEED SMALLINT,CRUISESPEED SMALLINT,MANEUVERSPEED SMALLINT,ENDURANCE INTEGER,FUEL INTEGER,DURABILITY INTEGER,CAPACITY INTEGER,TROOPCAPACITY INTEGER,CARGOCAPACITY INTEGER,LIQUIDCAPACITY INTEGER,BELTARMOR SMALLINT,DECKARMOR SMALLINT,TOWERARMOR SMALLINT,UPGRADETO SMALLINT,BITMAP SMALLINT,AVAILYEAR TINYINT,AVAILMONTH TINYINT,UPGRADESHIPYARDSIZE TINYINT,CLASSCONVERTSET INTEGER,UPGRADEDAMAGE INTEGER,MINUPGRADEDELAY SMALLINT,MINCONVERSIONDELAY SMALLINT,REPAIRPOINTSPERDAMAGEPOINT SMALLINT,SPECIALATTRIBUTE TINYINT,NOTE VARCHAR(40)) CREATE CACHED TABLE SHIPCLASSWEAPONS(CLASSID SMALLINT NOT NULL,WEAPONINDEX TINYINT NOT NULL,WEAPONNUM SMALLINT NOT NULL,NUMBER SMALLINT,FACING TINYINT,AMMO SMALLINT,TURRET TINYINT,ARMOR SMALLINT,PRIMARY KEY(CLASSID,WEAPONINDEX)) CREATE CACHED TABLE BASES(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),TYPE TINYINT,NATION TINYINT,XPOS SMALLINT,YPOS SMALLINT,AIRFIELDSPS TINYINT,PORTSPS TINYINT,ALLIEDVP SMALLINT,JAPANVP SMALLINT,REGIONID SMALLINT,GARRISON SMALLINT,ISLANDSIZE TINYINT) CREATE CACHED TABLE BASEOBJECTS(ID SMALLINT NOT NULL,OBJECTINDEX TINYINT NOT NULL,TURN SMALLINT NOT NULL,OBJECTTYPE SMALLINT,NUMBER SMALLINT NOT NULL,DAMAGED SMALLINT,BUILDING TINYINT,REPAIRING TINYINT,FAILED TINYINT,PRIMARY KEY(ID,OBJECTINDEX,TURN)) CREATE CACHED TABLE BASESMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE TINYINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE BASELARGEDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE INTEGER,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE AIRCRAFT(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(25),NATION TINYINT,TYPE TINYINT,BITMAP SMALLINT,MAXALT INTEGER,MAXSPEED SMALLINT,CRUISESPEED SMALLINT,CLIMBRATE SMALLINT,MANEUVER TINYINT,ARMOR TINYINT,DURABILITY TINYINT,ENDURANCE SMALLINT,MAXLOAD INTEGER,BUILDRATE SMALLINT,AVAILMONTH TINYINT,AVAILYEAR TINYINT,UPGRADETO SMALLINT,SERVICERATING TINYINT,ATTRIBUTES TINYINT,MANEUVER10 TINYINT,MANEUVER15 TINYINT,MANEUVER20 TINYINT,MANEUVER31 TINYINT,MANEUVER32 TINYINT,NORMALRANGE TINYINT,EXTENDEDRANGE TINYINT,NORMALDTRANGE TINYINT,EXTENDEDDTRANGE TINYINT,MAXDTRANGE TINYINT,ENDMONTH TINYINT,ENDYEAR TINYINT) CREATE CACHED TABLE AIRCRAFTWEAPONS(AIRCRAFTID SMALLINT NOT NULL,WEAPONINDEX TINYINT NOT NULL,WEAPONID SMALLINT NOT NULL,WEAPONNUM TINYINT,WEAPONFACE TINYINT,PRIMARY KEY(AIRCRAFTID,WEAPONINDEX)) CREATE CACHED TABLE LCUS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),TYPE TINYINT,NATION TINYINT,SUFFIX TINYINT,HQTYPE TINYINT,RADIUS TINYINT,PARENTID SMALLINT,FRAGNUM TINYINT,ARRIVALBASE SMALLINT,TOE SMALLINT,NOTE VARCHAR(40),WITHDRAWAL SMALLINT,ATTRIBUTES SMALLINT,PRIMARYID SMALLINT) CREATE CACHED TABLE LCUOBJECTS(ID SMALLINT NOT NULL,OBJECTID TINYINT NOT NULL,TURN SMALLINT NOT NULL,OBJECTTYPE SMALLINT,NUMBER SMALLINT NOT NULL,DISABLED SMALLINT,PRIMARY KEY(ID,OBJECTID,TURN)) CREATE CACHED TABLE LCUSMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE LCULARGEDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE INTEGER,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE REGIONS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26)) CREATE CACHED TABLE SHIPS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),NATION TINYINT,NOTE VARCHAR(40)) CREATE CACHED TABLE SHIPSMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE LEADERS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(25),RANK TINYINT,NATION TINYINT,PP TINYINT,BESTUNIT TINYINT) CREATE CACHED TABLE LEADERSMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE TINYINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE LEADERLARGEDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE AIRGROUPS(ID SMALLINT NOT NULL PRIMARY KEY,GROUPNAME VARCHAR(30),FRAGNUM TINYINT,NATION SMALLINT,MAXPLANES SMALLINT,NOTE VARCHAR(40),WITHDRAW INTEGER,REINFDELAY TINYINT,CAP TINYINT,LRCAP TINYINT,TRAIN TINYINT,REST TINYINT) CREATE CACHED TABLE AIRGROUPSMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE AIRGROUPUPGRADES(AIRGROUPID SMALLINT NOT NULL,UPGRADEINDEX TINYINT NOT NULL,UPGRADEID SMALLINT NOT NULL,UPGRADENUM SMALLINT,PRIMARY KEY(AIRGROUPID,UPGRADEINDEX)) CREATE CACHED TABLE AIRPOOLLOSS(ID SMALLINT NOT NULL PRIMARY KEY,TURN SMALLINT,INPOOL INTEGER,TOTALLOSS INTEGER,TOTALUSED INTEGER) CREATE CACHED TABLE AIRPOOLLOSSLARGEDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,INPOOL INTEGER,TOTALLOSS INTEGER,TOTALUSED INTEGER,PRIMARY KEY(ID,TURN)) CREATE CACHED TABLE ENGINES(ID SMALLINT NOT NULL PRIMARY KEY,TURN SMALLINT NOT NULL) CREATE CACHED TABLE ENGINELARGEDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE PILOTS(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(22),NATION TINYINT,TYPE TINYINT) CREATE CACHED TABLE PILOTSMALLDELTA(ID INTEGER NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE TINYINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE PILOTLARGEDELTA(ID INTEGER NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE PILOTPOOL(NATION SMALLINT NOT NULL,TURN SMALLINT NOT NULL,PILOTAVAIL SMALLINT,PILOTEXP SMALLINT,PILOTRATE SMALLINT,PRIMARY KEY(NATION,TURN)) CREATE CACHED TABLE PILOTTRAININGPOOL(NATION SMALLINT NOT NULL,TURN SMALLINT NOT NULL,INTERVAL TINYINT NOT NULL,PILOTAVAIL SMALLINT,PILOTEXP SMALLINT,PRIMARY KEY(NATION,TURN,INTERVAL)) CREATE CACHED TABLE TFS(ID SMALLINT NOT NULL PRIMARY KEY,LABEL VARCHAR(25),NOTE VARCHAR(40)) CREATE CACHED TABLE TFSMALLDELTA(ID SMALLINT NOT NULL,TURN SMALLINT NOT NULL,ITEM TINYINT NOT NULL,VALUE SMALLINT,PRIMARY KEY(ID,TURN,ITEM)) CREATE CACHED TABLE ALERTS(TURN SMALLINT NOT NULL,OBJECTTYPE SMALLINT NOT NULL,OBJECTID SMALLINT NOT NULL,TYPE SMALLINT NOT NULL,VALUE INTEGER,SEVERITY SMALLINT,PRIMARY KEY(TURN,OBJECTTYPE,OBJECTID,TYPE)) CREATE CACHED TABLE PRODUCTIONGLOBAL(TURN SMALLINT NOT NULL PRIMARY KEY,MANPOWER INTEGER,HEAVYIND INTEGER,NAVY INTEGER,MERCHANT INTEGER,ARMAMENT INTEGER,VEHICLE INTEGER) CREATE CACHED TABLE VICTORYPOINTS(TURN SMALLINT NOT NULL PRIMARY KEY,JAPANVP INTEGER,ALLIEDVP INTEGER,POLPOINTS INTEGER,JAPANAIRLOSS INTEGER,ALLIEDAIRLOSS INTEGER,JAPANBASES INTEGER,JAPANBASEVP INTEGER,ALLIEDBASES INTEGER,ALLIEDBASEVP INTEGER,JAPANSHIPS INTEGER,JAPANSHIPVP INTEGER,ALLIEDSHIPS INTEGER,ALLIEDSHIPVP INTEGER,JAPANDAYAIRLOSS INTEGER,ALLIEDDAYAIRLOSS INTEGER,NOTE VARCHAR(60)) CREATE CACHED TABLE AIRCRAFTLOSSES(TURN SMALLINT NOT NULL,ID SMALLINT NOT NULL,DAYAIR SMALLINT,DAYFLAK SMALLINT,DAYGROUND SMALLINT,DAYOPS SMALLINT,TOTALAIR SMALLINT,TOTALFLAK SMALLINT,TOTALGROUND SMALLINT,TOTALOPS SMALLINT,PRIMARY KEY(TURN,ID)) CREATE CACHED TABLE SUNKSHIPS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),NATION TINYINT,SUNKX SMALLINT,SUNKY SMALLINT,SUNKBASE SMALLINT,SUNKDEVICE SMALLINT,SCUTTLED TINYINT,SUNKTURN SMALLINT,CLASS SMALLINT,NOTE VARCHAR(40),SUNKDATE INTEGER) CREATE CACHED TABLE SAVESUNKSHIPS(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),CLASS SMALLINT) CREATE CACHED TABLE TOES(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(26),TYPE TINYINT,NATION TINYINT,SUFFIX TINYINT,UPGRADE SMALLINT,UPGRADEDELAY SMALLINT) CREATE CACHED TABLE TOEOBJECTS(ID SMALLINT NOT NULL,OBJECTID TINYINT NOT NULL,OBJECTTYPE SMALLINT,NUMBER SMALLINT NOT NULL,PRIMARY KEY(ID,OBJECTID)) CREATE CACHED TABLE MINEFIELDS(XPOSITION SMALLINT NOT NULL,YPOSITION SMALLINT NOT NULL,TURN SMALLINT NOT NULL,AMOUNT SMALLINT,PRIMARY KEY(XPOSITION,YPOSITION,TURN)) CREATE CACHED TABLE SCENARIOINFO(ITEM TINYINT NOT NULL PRIMARY KEY,VALUE INTEGER) CREATE CACHED TABLE ENEMYHQS(ID SMALLINT NOT NULL PRIMARY KEY,NATION TINYINT) CREATE CACHED TABLE INTELREPORTS(TURN SMALLINT NOT NULL,TYPE TINYINT,XPOS SMALLINT,YPOS SMALLINT,AMOUNT INTEGER,UNITNAME VARCHAR(40),SHIPNAME VARCHAR(40)) SET TABLE AIRCRAFT INDEX'94072 0' SET TABLE AIRCRAFTWEAPONS INDEX'85512 0' SET TABLE SHIPS INDEX'1729400 0' SET TABLE SHIPSMALLDELTA INDEX'1726416 0' SET TABLE AIRCRAFTLOSSES INDEX'94360 0' SET TABLE SUNKSHIPS INDEX'1708576 0' CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10
|