Search
Latest topics
» DykeMS not being online.by Yves Mon Apr 14, 2014 5:16 am
» Hai o-o
by Pikachu Fri Apr 08, 2011 2:04 am
» HEY, I'M BACK HOES.
by Twiggah Mon Apr 04, 2011 9:12 am
» I'M BACK PEOPLES!
by Pikachu Sun Apr 03, 2011 7:10 pm
» HEY, I'M GONE HOES.
by Pikachu Sat Apr 02, 2011 7:51 pm
» Fuckin' magnets.
by Neko Sat Mar 26, 2011 2:39 am
» Mike's App. (v1.2 - Now with more words or something!(And, I guess, a variety of colors!))
by Mike Mon Mar 14, 2011 8:11 pm
» I blame Carrie.
by Yves Fri Mar 11, 2011 3:35 am
» Ban Appeal
by Mike Fri Mar 11, 2011 1:15 am
DykeMS is opening soon!
+7
Tim
DanielWojaTV
Swag
Vincent
Twiggah
Yves
Sarah
11 posters
DykeMS is opening soon!
by Sarah Tue Dec 21, 2010 2:43 am
I just have to make a few final adjustments then the server will be public. Most likely tomorrow morning everything will be ready. (: Thank you all for your patience.
Sarah- Admin
- Posts : 178
Points : 236
Reputation : 8
Join date : 2010-12-20
Age : 32
Location : your room. -
Re: DykeMS is opening soon!
by Yves Tue Dec 21, 2010 3:37 am
Current Revision
Revision 22 (Version 0.0.22.83)
LOLOL
Last edited by Yves on Tue Dec 21, 2010 3:38 am; edited 1 time in total
Yves- Posts : 300
Points : 333
Reputation : 6
Join date : 2010-12-20
Age : 28
Location : Toronto.
Re: DykeMS is opening soon!
by Sarah Tue Dec 21, 2010 3:38 am
Wow, screw you.Yves wrote:Current Revision
Revision 22 (Version 0.0.22.83)
LOLOL
Sarah- Admin
- Posts : 178
Points : 236
Reputation : 8
Join date : 2010-12-20
Age : 32
Location : your room. -
Yves- Posts : 300
Points : 333
Reputation : 6
Join date : 2010-12-20
Age : 28
Location : Toronto.
Re: DykeMS is opening soon!
by Twiggah Tue Dec 21, 2010 6:22 am
Hmm. I await the grand opening of LesbianMS.
Twiggah- Posts : 304
Points : 331
Reputation : 8
Join date : 2010-12-20
Age : 27
Location : Melbourne, Victoria.
Vincent- Posts : 20
Points : 24
Reputation : 0
Join date : 2010-12-20
Swag- Posts : 162
Points : 196
Reputation : 4
Join date : 2010-12-20
Location : Beside Spinel.
DanielWojaTV- Posts : 48
Points : 62
Reputation : 0
Join date : 2010-12-20
Re: DykeMS is opening soon!
by Tim Tue Dec 21, 2010 1:56 pm
Did you send her all of the revisions yet Yves, or did you not feel like scrapping your entire SQL table? LOL
Tim- Posts : 77
Points : 97
Reputation : 5
Join date : 2010-12-20
Age : 32
Location : Outside your window.....in San Angelo, TX
Chey- Posts : 53
Points : 57
Reputation : 0
Join date : 2010-12-21
Age : 27
Location : In chur heart.<3
Re: DykeMS is opening soon!
by Synthesist Tue Dec 21, 2010 2:19 pm
Didn't I tell you you were way behind Sarah?
Synthesist- Posts : 103
Points : 114
Reputation : 0
Join date : 2010-12-20
Age : 27
Location : Toronto
Re: DykeMS is opening soon!
by Yves Tue Dec 21, 2010 5:41 pm
LOL TIM.
Nah, I haven't yet. I plan on getting ring effects working first.
(For Tim:
Nah, I haven't yet. I plan on getting ring effects working first.
(For Tim:
- Spoiler:
- Code:
PreparedStatement pse = con.prepareStatement("INSERT INTO inventoryequipment (inventoryitemid, upgradeslots, `level`, str, dex, `int`, luk, hp, mp, watk, matk, wdef, mdef, acc, avoid, hands, speed, jump, hammers, ringid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
for (MapleInventory iv : inventory) {
ps.setInt(3, iv.getType().getType());
for (IItem item : iv.list()) {
ps.setInt(1, id);
ps.setInt(2, item.getItemId());
ps.setInt(4, item.getPosition());
ps.setInt(5, item.getQuantity());
ps.setString(6, item.getOwner());
ps.setInt(7, item.getPetId());
ps.executeUpdate();
ResultSet rs = ps.getGeneratedKeys();
int itemid;
if (rs.next()) {
itemid = rs.getInt(1);
} else {
throw new DatabaseException("Inserting char failed.");
}
if (iv.getType().equals(MapleInventoryType.EQUIP) || iv.getType().equals(MapleInventoryType.EQUIPPED)) {
pse.setInt(1, itemid);
IEquip equip = (IEquip) item;
pse.setInt(2, equip.getUpgradeSlots());
pse.setInt(3, equip.getLevel());
pse.setInt(4, equip.getStr());
pse.setInt(5, equip.getDex());
pse.setInt(6, equip.getInt());
pse.setInt(7, equip.getLuk());
pse.setInt(8, equip.getHp());
pse.setInt(9, equip.getMp());
pse.setInt(10, equip.getWatk());
pse.setInt(11, equip.getMatk());
pse.setInt(12, equip.getWdef());
pse.setInt(13, equip.getMdef());
pse.setInt(14, equip.getAcc());
pse.setInt(15, equip.getAvoid());
pse.setInt(16, equip.getHands());
pse.setInt(17, equip.getSpeed());
pse.setInt(18, equip.getJump());
pse.setInt(19, equip.getHammers());
pse.setInt(20, equip.getRingId());
pse.executeUpdate();
}
}
}
- Code:
public Equip(int id, byte position, int ringid) {
super(id, position, (short) 1);
this.ringid = ringid;
}
@Override
public int getRingId() {
return ringid;
}
- Code:
public static int createRing(int itemid, final MapleCharacter partner1, final MapleCharacter partner2, String message) {
try {
if (partner1 == null) {
return -2;
} else if (partner2 == null) {
return -1;
}
int[] ringID = new int[2];
Connection con = DatabaseConnection.getConnection();
PreparedStatement ps = con.prepareStatement("INSERT INTO rings (itemid, partnerChrId, partnername) VALUES (?, ?, ?)");
ps.setInt(1, itemid);
ps.setInt(2, partner2.getId());
ps.setString(3, partner2.getName());
ps.executeUpdate();
ResultSet rs = ps.getGeneratedKeys();
rs.next();
ringID[0] = rs.getInt(1); // ID.
rs.close();
ps.close();
ps = con.prepareStatement("INSERT INTO rings (itemid, partnerRingId, partnerChrId, partnername) VALUES (?, ?, ?, ?)");
ps.setInt(1, itemid);
ps.setInt(2, ringID[0]);
ps.setInt(3, partner1.getId());
ps.setString(4, partner1.getName());
ps.executeUpdate();
rs = ps.getGeneratedKeys();
rs.next();
ringID[1] = rs.getInt(1);
rs.close();
ps.close();
ps = con.prepareStatement("UPDATE rings SET partnerRingId = ? WHERE id = ?");
ps.setInt(1, ringID[1]);
ps.setInt(2, ringID[0]);
ps.executeUpdate();
ps.close();
MapleInventoryManipulator.addRing(partner1, itemid, ringID[0]);
MapleInventoryManipulator.addRing(partner2, itemid, ringID[1]);
<...>
- Code:
public static boolean addRing(MapleCharacter chr, int itemId, int ringId) {
MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
MapleInventoryType type = ii.getInventoryType(itemId);
IItem nEquip = ii.getEquipById(itemId, ringId);
byte newSlot = chr.getInventory(type).addItem(nEquip);
<...>
- Code:
public IItem getEquipById(int equipId, int ringId) {
Equip nEquip;
nEquip = new Equip(equipId, (byte) 0, ringId);
<...>
- Code:
id, partnerRingId, partnerChrId, itemid, partnername
7, 8, 30011, 1112801, 'Jenny'
8, 7, 30006, 1112801, 'Vivian'
Yves- Posts : 300
Points : 333
Reputation : 6
Join date : 2010-12-20
Age : 28
Location : Toronto.
Vincent- Posts : 20
Points : 24
Reputation : 0
Join date : 2010-12-20
Re: DykeMS is opening soon!
by XunXet Wed Dec 22, 2010 6:31 pm
Vincent wrote:SO WHEN'S IT DONE SARAH?!
Never.
XunXet- Posts : 68
Points : 79
Reputation : 8
Join date : 2010-12-20
Age : 29
Location : Under a Christmas tree.
Re: DykeMS is opening soon!
by Synthesist Sat Dec 25, 2010 3:17 pm
This thread should be closed. -hinthint-
Synthesist- Posts : 103
Points : 114
Reputation : 0
Join date : 2010-12-20
Age : 27
Location : Toronto
Re: DykeMS is opening soon!
by JeRRiE Sat Dec 25, 2010 9:26 pm
OOO (: It's already up ~ but she's working on making a few alterations ~<3
JeRRiE- Posts : 86
Points : 98
Reputation : 0
Join date : 2010-12-24
Age : 29
Location : Antarctica -
Similar topics» DykeMS rev 3.1
» DykeMS <33
» Donate to DykeMS!
» DykeMS...welcome to the world of top 50.
» DykeMS not being online.
» DykeMS <33
» Donate to DykeMS!
» DykeMS...welcome to the world of top 50.
» DykeMS not being online.
Permissions in this forum:
You cannot reply to topics in this forum|
|
|