113 replies to this topic

[Kadelia]

Line 592 of classic's info.php I just changed the query

 

was

    dbQuery("SELECT id, name, category, subcat, visible2 FROM item_main ORDER BY id", "menuData");

 

 

now

 

    dbQuery("SELECT id, name, category, subcat, visible2 FROM item_main LEFT JOIN item_misc USING (id) WHERE version != 2 ORDER BY id", "menuData");

 

This has stopped it from listing renewal items in the dropdown menus like it was

[Kadelia]

Okay so at the end of the day it seems like I have it working now so that version=2 items stay outta the classic DB and version=3 items stay out of the renewal DB

[Kadelia]

I've updated my tools to allow classic-only to be set as the version

[Themes]

Thank you, you're a hero!

[Themes]

Thanks again for doing that, I just submitted an entry for ACAs, lets see if it breaks anything!

[AlmrOfAtlas]

Thanks again for doing that, I just submitted an entry for ACAs, lets see if it breaks anything!

 

For Classic? ACAs aren't yet visible to searches or the drop down under Usable > Item Giver. Just OCAs, MCAs, and CCAs which I don't believe we have on the server.

[Kadelia]

For Classic? ACAs aren't yet visible to searches or the drop down under Usable > Item Giver. Just OCAs, MCAs, and CCAs which I don't believe we have on the server.

He submitted it but I did not sign off on it yet. That is how my tool works. Its in now.

http://db.irowiki.or...tem-info/19468/

[Necrohealiac]

for some reason the description is doubling up on this item:

http://db.irowiki.or...tem-info/24062/

also the set bonus description is missing on the other piece:

http://db.irowiki.or...tem-info/24052/

[Kadelia]

I will take a look tonight

[Necrohealiac]

u da best jaye

[Kadelia]

I know :v

[Themes]

Cool!

 

It's not currently showing up on a search, but I think it's just adding the join to the search page, I'll do it in like 20 minutes. Actually looks like it's showing up in the Renewal search (not Classic) too, if you dont mind I'll add your join to that as well to make anything not the Renewal versions disappear from that.

[Themes]

Ok changed Classics search.php from

 

dbQuery("SELECT id, name, category, subcat FROM item_main LEFT JOIN item_adjective USING (id) JOIN item_misc USING (id) WHERE
($whereCon) AND visible=1 AND (version = 1 OR version = 0) ORDER BY name", "searchResults-item");

 

to

dbQuery("SELECT id, name, category, subcat FROM item_main LEFT JOIN item_adjective USING (id) JOIN item_misc USING (id) WHERE
($whereCon) AND visible=1 AND (version = 1 OR version = 0 OR version = 3) ORDER BY name", "searchResults-item");

 

and Renewals search.php from

dbQuery("SELECT id, name, category, subcat FROM item_main LEFT JOIN item_adjective USING (id) WHERE
($whereCon) AND visible2=1 ORDER BY name", "searchResults-item");

 

to

dbQuery("SELECT id, name, category, subcat FROM item_main LEFT JOIN item_adjective USING (id) JOIN item_misc USING (id) WHERE
($whereCon) AND visible2=1 AND version != 3 ORDER BY name", "searchResults-item");

 

The ACA now appears in the Classic search and isnt in the Renewal Search.

[Kadelia]

I think I just didn't edit the php for consumable seatch yet.

Edit: yup

Edited by Jaye, 02 September 2015 - 11:01 AM.

[Themes]

It's just the search page itself, it has its own query that needed to be changed. I think I ended up changing two queries to stop Renewal items appearing on Classic, the drop down menu which you did and the search page which I just did there, had to add version 3 for classic and filter anything but 3 for Renewal

Edited by Themes, 02 September 2015 - 11:03 AM.

[Kadelia]

I had already made the same chsnges for the weapon searches just not the consumable one

[Kadelia]

Athena Earring - http://db.irowiki.or...tem-info/24051/ - Now properly an earring.

 

All of the shadow shields and footgear -

Standardized their language with other DB items, e.g., "Reduces damage received from [Insect] race by 1%." and "Increases physical damage against [Insect] race monsters by an additional 1%"

Fixed all of their set effects

 

Bloody doesn't have doubled stuff anymore.

Edited by Jaye, 02 September 2015 - 07:46 PM.

[Necrohealiac]

yey

[beaupoem]

not sure what happened, but you can't search gears by their effects anymore. nothing shows up in the results

[Necrohealiac]

not at home so i cannot confirm but i swear that there was an additional set bonus for the hard shadow armor/champion shoes set that gives you sp/hp inc depending on the total refine of the set

http://db.irowiki.or...tem-info/24028/
http://db.irowiki.or...tem-info/24025/

divine-pride has it, incidentally

http://www.divine-pr...on-shoes-shadow
http://www.divine-pr...rd-shadow-armor

[Necrohealiac]

dunno where this -10% demi magic reduction effect came from but it doesn't look right.

https://forums.warpp...wing/?p=2273881

[Kadelia]

Fixed the shadow gear and faw.

Edit: also improved wing headphone entry: http://db.irowiki.or...item-info/5963/

The search results thing I still need to look into.

Edited by Jaye, 15 September 2015 - 11:09 AM.

[Kadelia]

I corrected some incorrect stuff about Wing Headphones [1]

 

It has 24 DEF and adds +3 INT, which aren't documented in the in-game desc for some reason (just like applicable job, what headgear slots...

It really does weigh 1 which is weird.

[Necrohealiac]

it's light as a feather, but it takes up A LOT of space on your face

[gozaru]

Rebel patch _{-add:12/19/15-}

Spoiler

Weapon - Bullet
Armor-Piercing Bullet _(13215)
Blazing Bullet _(13216)
Freezing Bullet _(13217)
Lightning Bullet _(13218)
Magic Stone Bullet _(13219)
Slug Shot L _(13210)
Slug Shot H _(13212)
Slug Shot M _(13211)
Slug Shot SH _{(13213) -add:12/19/15-}
Slug Shot XH _{(13214) -add:12/19/15-}

Misc - General
Full Metal Jacket ₍₇₆₆₃₎
Grenade Launcher ₍₇₆₆₄₎
Dragon Tail Missile ₍₇₆₆₅₎

Misc - Quest
Steel Artifact ₍₆₇₄₇₎
Steel Artifact ₍₆₇₄₆₎

not add yet

Spoiler

Weapon - Bullet
Surplus Silver Bullet _(13201)
Surplus Bloody Shell _(13202)
Surplus Incendiary Grenade _(13203)
Surplus Lightning Grenade _(13204)
Surplus Poison Grenade _(13205)
Surplus Flash Grenade _(13206)
Surplus Cryo Grenade _(13207)

Usable - Item Giver
Ammo AP Bullet Case _(22744)
Ammo Blazing Bullet Case _(22745)
Ammo Freezing Bullet Case _(22746)
Ammo Lightning Bullet Case _(22747)
Ammo Magic Stone Bullet Case _(22748)
Ammo Purifying Bullet Case _(22749)
Silver Bullet Case _(22738)
Bloody Bullet Case _(33737)

etc
13221#Silver_Bullet# _{id change? : 13201}
13222#Bloody_Shell# _{id change? : 13202}
13223#Incendiary_Grenade# _{id&name change? : 13203}
13224#Lightning_Grenade# _{id&name change? : 13204}
13225#Poison_Grenade# _{id&name change? : 13205}
13226#Flash_Grenade# _{id&name change? : 13206}
13227#Cryo_Grenade# _{id&name change? : 13207}

Edited by gozaru, 18 December 2015 - 06:37 AM.