⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 maplecustomquest.java.svn-base

📁 冒险岛私服Java版服务端(Odinms)源代码。学习JAVA开发的朋友
💻 SVN-BASE
📖 第 1 页 / 共 3 页
字号:
🔍
123 
		psa.executeUpdate();

		psr.close();
		psa.close();
		con.close();

		// MAGICIAN
		int questid = 100008;

		Properties dbProps = new Properties();
		dbProps.load(new FileReader("db.properties"));
		DatabaseConnection.setProps(dbProps);
		Connection con = DatabaseConnection.getConnection();
		PreparedStatement psr = con.prepareStatement("INSERT INTO questrequirements VALUES (DEFAULT, ?, ?, ?)");
		PreparedStatement psa = con.prepareStatement("INSERT INTO questactions VALUES (DEFAULT, ?, ?, ?)");
		psr.setInt(1, questid);
		psa.setInt(1, questid);
		MapleCustomQuestData data;
		MapleCustomQuestData dataEntry;
		ByteArrayOutputStream bos = new ByteArrayOutputStream();
		ObjectOutputStream oos = new ObjectOutputStream(bos);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100007, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();
		
		questid = 100007;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100006, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 30, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, null);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -30, dataEntry));
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		questid = 100006;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("job", null, null);
		data.addChild(new MapleCustomQuestData("0", MapleJob.MAGICIAN.getId(), data));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("lvmin", 30, null);
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031009, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031009, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		psr.close();
		psa.close();
		con.close();*/
		
		// 3rd job
		int questid = 100100;

		Properties dbProps = new Properties();
		dbProps.load(new FileReader("db.properties"));
		DatabaseConnection.setProps(dbProps);
		Connection con = DatabaseConnection.getConnection();
		PreparedStatement psr = con.prepareStatement("INSERT INTO questrequirements VALUES (DEFAULT, ?, ?, ?)");
		PreparedStatement psa = con.prepareStatement("INSERT INTO questactions VALUES (DEFAULT, ?, ?, ?)");
		psr.setInt(1, questid);
		psa.setInt(1, questid);
		MapleCustomQuestData data;
		MapleCustomQuestData dataEntry;
		ByteArrayOutputStream bos = new ByteArrayOutputStream();
		ObjectOutputStream oos = new ObjectOutputStream(bos);

		data = new MapleCustomQuestData("lvmin", 70, null);
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());		
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031057, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031057, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();
		
		// clone quest (still 3rd job)
		questid = 100101;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100100, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.STARTED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031059, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, null);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031059, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031057, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		// quiz quest (still 3rd job)
		questid = 100102;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("lvmin", 70, null);
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());		
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031058, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031058, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		psr.close();
		psa.close();
		con.close();

	}

}
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -