| 1056 | | Set<Integer> gzlliste = new HashSet<Integer>(); |
|---|
| 1057 | | |
|---|
| 1058 | | SQLQuery aentry = db.query("SELECT * FROM gtu_zwischenlager WHERE user1=",user.getID()," OR user2=",user.getID()); |
|---|
| 1059 | | while( aentry.next() ) { |
|---|
| 1060 | | String owncargoneed = aentry.getString("cargo1need"); |
|---|
| 1061 | | if( aentry.getInt("user2") == user.getID() ) { |
|---|
| 1062 | | owncargoneed = aentry.getString("cargo2need"); |
|---|
| 1063 | | } |
|---|
| 1064 | | |
|---|
| 1065 | | if( new Cargo(Cargo.Type.STRING, owncargoneed).isEmpty() ) { |
|---|
| 1066 | | gzlliste.add(aentry.getInt("posten")); |
|---|
| 1067 | | } |
|---|
| 1068 | | } |
|---|
| 1069 | | aentry.free(); |
|---|
| 1070 | | |
|---|
| 1071 | | for( Integer postenid : gzlliste ) { |
|---|
| 1072 | | SQLResultRow aposten = db.first("SELECT name,x,y,system FROM ships WHERE id=",postenid); |
|---|
| 1073 | | t.set_var( "gtuzwischenlager.name", Common._plaintitle(aposten.getString("name")), |
|---|
| 1074 | | "gtuzwischenlager.x", aposten.getInt("x"), |
|---|
| 1075 | | "gtuzwischenlager.y", aposten.getInt("y"), |
|---|
| 1076 | | "gtuzwischenlager.system", aposten.getInt("system") ); |
|---|
| | 1059 | Set<Ship> gzlliste = new HashSet<Ship>(); |
|---|
| | 1060 | |
|---|
| | 1061 | List entries = db.createQuery("from GtuZwischenlager where user1= :user or user2= :user") |
|---|
| | 1062 | .setEntity("user", user) |
|---|
| | 1063 | .list(); |
|---|
| | 1064 | |
|---|
| | 1065 | for( Iterator iter=entries.iterator(); iter.hasNext(); ) { |
|---|
| | 1066 | GtuZwischenlager aentry = (GtuZwischenlager)iter.next(); |
|---|
| | 1067 | |
|---|
| | 1068 | Cargo owncargoneed = aentry.getCargo1Need(); |
|---|
| | 1069 | if( aentry.getUser2() == user ) { |
|---|
| | 1070 | owncargoneed = aentry.getCargo2Need(); |
|---|
| | 1071 | } |
|---|
| | 1072 | |
|---|
| | 1073 | if( owncargoneed.isEmpty() ) { |
|---|
| | 1074 | gzlliste.add(aentry.getPosten()); |
|---|
| | 1075 | } |
|---|
| | 1076 | } |
|---|
| | 1077 | |
|---|
| | 1078 | for( Ship aposten : gzlliste ) { |
|---|
| | 1079 | t.set_var( "gtuzwischenlager.name", Common._plaintitle(aposten.getName()), |
|---|
| | 1080 | "gtuzwischenlager.x", aposten.getX(), |
|---|
| | 1081 | "gtuzwischenlager.y", aposten.getY(), |
|---|
| | 1082 | "gtuzwischenlager.system", aposten.getSystem() ); |
|---|
| 1085 | | SQLQuery entry = db.query("SELECT * FROM versteigerungen ORDER BY id DESC"); |
|---|
| 1086 | | while( entry.next() ) { |
|---|
| 1087 | | User bieter = (User)getDB().get(User.class, entry.getInt("bieter")); |
|---|
| 1088 | | |
|---|
| 1089 | | String entryname = ""; |
|---|
| 1090 | | String entryimage = ""; |
|---|
| 1091 | | String entrylink = ""; |
|---|
| 1092 | | int entrywidth = 0; |
|---|
| 1093 | | int entryheight = 0; |
|---|
| 1094 | | long entrycount = 1; |
|---|
| 1095 | | |
|---|
| 1096 | | if( entry.getInt("mtype") == 1 ) { //Schiff |
|---|
| 1097 | | ShipTypeData shiptype = Ship.getShipType(entry.getInt("type"), false); |
|---|
| 1098 | | entryname = shiptype.getNickname(); |
|---|
| 1099 | | entryimage = shiptype.getPicture(); |
|---|
| 1100 | | entrylink = Common.buildUrl(getContext(), "default", "module", "schiffinfo", "ship", entry.getInt("type") ); |
|---|
| 1101 | | } |
|---|
| 1102 | | else if( entry.getInt("mtype") == 2 ) { // Cargo |
|---|
| 1103 | | Cargo cargo = new Cargo( Cargo.Type.STRING, entry.getString("type") ); |
|---|
| 1104 | | cargo.setOption( Cargo.Option.SHOWMASS, false ); |
|---|
| 1105 | | cargo.setOption( Cargo.Option.LARGEIMAGES, true ); |
|---|
| 1106 | | ResourceList reslist = cargo.getResourceList(); |
|---|
| 1107 | | ResourceEntry resource = reslist.iterator().next(); |
|---|
| 1108 | | |
|---|
| 1109 | | entryname = Cargo.getResourceName( resource.getId() ); |
|---|
| 1110 | | entryimage = resource.getImage(); |
|---|
| 1111 | | |
|---|
| 1112 | | if( resource.getId().isItem() ) { |
|---|
| 1113 | | entrylink = Common.buildUrl(getContext(), "details", "module", "iteminfo", "item", resource.getId().getItemID() ); |
|---|
| 1114 | | } |
|---|
| 1115 | | else { |
|---|
| 1116 | | entrylink = "#"; |
|---|
| 1117 | | } |
|---|
| 1118 | | |
|---|
| 1119 | | if( !resource.showLargeImages() ) { |
|---|
| 1120 | | entrywidth = 50; |
|---|
| 1121 | | entryheight = 50; |
|---|
| 1122 | | } |
|---|
| 1123 | | |
|---|
| 1124 | | if( resource.getCount1() > 1 ) { |
|---|
| 1125 | | entrycount = resource.getCount1(); |
|---|
| 1126 | | } |
|---|
| 1127 | | } |
|---|
| | 1091 | List versteigerungen = db.createQuery("from Versteigerung order by id desc").list(); |
|---|
| | 1092 | for( Iterator iter=versteigerungen.iterator(); iter.hasNext(); ) { |
|---|
| | 1093 | Versteigerung entry = (Versteigerung)iter.next(); |
|---|
| | 1094 | User bieter = entry.getBieter(); |
|---|
| | 1095 | |
|---|
| | 1096 | String entryname = StringEscapeUtils.escapeJavaScript(StringUtils.replaceChars(entry.getObjectName(), '"', '\'')); |
|---|
| | 1097 | int entrywidth = entry.isObjectFixedImageSize() ? 50 : 0; |
|---|
| | 1098 | |
|---|
| 1147 | | if( (user.getAccessLevel() >= 20) && (entry.getInt("owner") != faction) && (entry.getInt("owner") != user.getID()) ) { |
|---|
| 1148 | | User ownerobject = (User)getDB().get(User.class, entry.getInt("owner")); |
|---|
| 1149 | | ownername = Common._title(ownerobject.getName()); |
|---|
| 1150 | | } |
|---|
| 1151 | | |
|---|
| 1152 | | t.set_var( "entry.link", entrylink, |
|---|
| 1153 | | "entry.type.name", StringEscapeUtils.escapeJavaScript(StringUtils.replaceChars(entryname, '"', '\'')), |
|---|
| 1154 | | "entry.type.image", entryimage, |
|---|
| 1155 | | "entry.preis", Common.ln(entry.getLong("preis")), |
|---|
| | 1118 | if( (user.getAccessLevel() >= 20) && (entry.getOwner().getID() != faction) && (entry.getOwner() != user) ) { |
|---|
| | 1119 | ownername = Common._title(entry.getOwner().getName()); |
|---|
| | 1120 | } |
|---|
| | 1121 | |
|---|
| | 1122 | t.set_var( "entry.link", entry.getObjectUrl(), |
|---|
| | 1123 | "entry.type.name", entryname, |
|---|
| | 1124 | "entry.type.image", entry.getObjectPicture(), |
|---|
| | 1125 | "entry.preis", Common.ln(entry.getPreis()), |
|---|
| 1157 | | "entry.bieter.id", entry.getInt("bieter"), |
|---|
| 1158 | | "entry.dauer", entry.getInt("tick") - this.ticks, |
|---|
| 1159 | | "entry.aukid", entry.getInt("id"), |
|---|
| | 1127 | "entry.bieter.id", entry.getBieter().getID(), |
|---|
| | 1128 | "entry.dauer", entry.getTick() - this.ticks, |
|---|
| | 1129 | "entry.aukid", entry.getId(), |
|---|
| 1164 | | "entry.user.id", entry.getInt("owner"), |
|---|
| 1165 | | "entry.user", (entry.getInt("owner") != faction), |
|---|
| 1166 | | "entry.ownauction", (entry.getInt("owner") == user.getID()) ); |
|---|
| | 1134 | "entry.user.id", entry.getOwner().getID(), |
|---|
| | 1135 | "entry.user", (entry.getOwner().getID() != faction), |
|---|
| | 1136 | "entry.ownauction", (entry.getOwner() == user) ); |
|---|