113 replies to this topic

[fuyukikun]

sorry it is not about irowiki db:

can someone do something about irowiki.org front page? omg, it is so outdated, and i guess only selected people able to edit it.

[AlmrOfAtlas]

bah, that has to do with the versioning....

 

 

Can you check to see if I have lessened the problem at all?

 

As of now, the only things appearing in the Classic DB are the recently added Renewal entries. Nothing else @_@

 

Seems to be across all categories. In Weapon > Dagger the only entry is TE WoE Knife. In Gear > Accessory it's just Advanced items, the Kvasir Rings and the TE Rings.

 

Searching for older items with keywords turns up blanks as well.

 

Edited by AlmrOfAtlas, 31 August 2015 - 06:35 AM.

[Kadelia]

@_@

[Kadelia]

I'll look into it when I get home

[NeoNilox]

sorry it is not about irowiki db:
can someone do something about irowiki.org front page? omg, it is so outdated, and i guess only selected people able to edit it.

Oh boi. I'm so out of the loop I don't know what's going on anymore. It doesn't help that I was incommunicado for 2 months almost in a row. Yes, I can edit the front page actually.

I know the spotlight is gonna be Lighthalzen next maint, if this thread is to be believed. But I'm not sure if there're any ongoing Event Quests or an Exp/Drop event.

Then again, I don't know which of these are active anymore.

Edited by NeoNilox, 31 August 2015 - 09:44 AM.

[Kadelia]

Pm resplendent and blueness on irowiki and ask for front page edit access fuyu

[Themes]

What changes are you making? A lot of things just disappeared from the Classic DB. I wrote a join in the query where it retrieves the items for search/dropdowns a few months ago to help prevent any Renewal items from showing up, anything that isnt given a proper version will show up in the Classic DB, but anything that is assigned a Renewal version should get filtered out.

[Kadelia]

OK OK OK
 
Almr
 
How does it look now
 
 

What changes are you making? A lot of things just disappeared from the Classic DB. I wrote a join in the query where it retrieves the items for search/dropdowns a few months ago to help prevent any Renewal items from showing up, anything that isnt given a proper version will show up in the Classic DB, but anything that is assigned a Renewal version should get filtered out.

 
A query I or another admin executed appeared to have replaced all VERSION of all item with 2, which is renewal, except for some of the renewal items added with my tool when my tool first came into being around january-february, which were defaulted to 0 for some reason. So those were the only items available.

 

I had to pinpoint the last item(s) added when it was pre-renewal, and overwrite all items prior to that point with a 0. I did this with a new query. This seems to have done sufficiently. I then corrected all the jan-feb items to be version 2, so they aren't showing up in the classic db (this is like the WoE TE items).

 

Any items added to wiki's DB for the custom classic server you'll need to identify for me and I can change their ID to '1' for classic only.

Edited by Jaye, 31 August 2015 - 05:50 PM.

[AlmrOfAtlas]

OK OK OK
 
Almr
 
How does it look now

 

Seems fine. There are only a few Renewal items showing up now and I believe they've been there since when the Classic DB was first created - mostly 13.3 stuff. The newly created entries for Renewal are no longer visible.

 

Interestingly, the BG/KvM (no KvM on Classic tho) gear - weapons, armours and accessories - all have duplicate entries.

 

I did a few searches for random items and was able to find them all successfully. The dropdowns are showing correctly too.

Edited by AlmrOfAtlas, 31 August 2015 - 06:40 PM.

[Kadelia]

if you can cite which items shouldn't be there I can fix them

 

UPDATE: I have removed all the duplicated battlegrounds gears

Edited by Jaye, 31 August 2015 - 07:06 PM.

[AlmrOfAtlas]

if you can cite which items shouldn't be there I can fix them

 

I'll add to this later. Stuff with a (?) needs confirmation.

 

Weapons

Spoiler

1144 Sashimi

1145 Holy Avenger(?)

1186 Death Guidance

1187 Glorious Claymore

1188 Veteran Sword

1191 Alca Bringer

1192 Eden Slayer I

1193 Eden Slayer II

1196 Two-Handed Chrome Metal Sword

1281 Glorious Bloody Roar

1282 Glorious Jamadhar

1287 Durga

1310 Glorious Cleaver

1382 Glorious Twohanded Axe

1384 Veteran Axe

1385 Bradium Stonehammer

1426 Glorious Spear

1433 Imperial Spear

1486 Glorious Lance

1544 Lunakaligo

1546 Glorious Morning Star

1548 Veteran Hammer

1549 Pile Bunker

1576 Glorious Tablet

1577 Glorious Apocalypse

1640 Glorious Arc Wand

1641 Glorious Cure Wand

1649 Laphine Staff

1650 Eden Staff I

1651 Eden Staff II

1654 Mental Stick

1740 Nepenthes Bow

1741 Cursed Lyre

1743 Glorious Hunter Bow

1746 Elven Bow

1747 Eden Bow I

1748 Eden Bow II

1825 Horn of Hillslion

1826 Glorious Claw

1827 Glorious Fist

1830 Sura's Rampage

1926 Harp of Nepenthes

1927 Glorious Guitar

1930 Green Whistle

1979 Stem of Nepenthes

1981 Glorious Lariat

1985 Rosevine

2002 Glorious Destruction Staff

2004 Kronos

13039 Ivory Knife

13042 Glorious Gladius

13050 Eden Dagger I

13051 Eden Dagger II

13061 Black Wing

13062 Ancient Dagger

13067 Keris

13110 Glorious Pistol

13112 Eden Revolver I

13113 Eden Revolver II

13176 Glorious Rifle

13177 Glorious Gatling Gun

13178 Glorious Shotgun

13179 Glorious Grenade Launcher

13307 Glorious Shuriken

13416 Glorious Flamberge

13417 Glorious Rapier

13418 Glorious Holy Avenger

13423 Eden Sabre I

13424 Eden Sabre II

13431 Chrome Metal Sword

16003 Carga Mace

16004 Eden Mace I

16005 Eden Mace II

16010 Red Ether Bag

18103 Mystic Bow

 

Armour

Spoiler

2387 Sprint Mail

2389 Armor of Naga

2391 Life Link(?)

2394 Glorious Suit

2395 Glorious Popularized Suit

2396 Glorious Mass-Production Suit

2399 Dragon Vest

15000 Bone Plate

15009 Eden Group Uniform I

15010 Eden Group Uniform II

15011 Eden Group Uniform III

15012 Puente Robe

15013 Claire Suits

15014 Ebone Armor

15032 Tidung

 

Shields

Spoiler

2133 Tournament Shield

2134 Shield of Naga

2138 Bradium Shield

2139 Flame Thrower

2140 Energy Rune Guard

2146 Siver Guard(?)

2148 Rosa Shield

2153 Imperial Guard

2168 Immune Shield

 

Garments

Spoiler

2544 Leather of Tendrilion

2549 Glorious Muffler

2553 Dragon Manteau

2560 Eden Group Manteau

2564 Feral Tail

 

Footgear

Spoiler

2440 Sprint Shoes

2444 Glorious Shoes

2445 Glorious Popularized Shoes

2446 Glorious Mass-Production Shoes

2456 Eden Group Boots I

2457 Eden Group Boots II

2458 Eden Group Boots III

2463 Feral Boots

2465 Dance Shoes

 

Accessories

Spoiler

2638 Sacred Incense

2639 Occult Incense

2642 Serin's Gold Ring

2743 Angelic Ring

2744 Sprint Ring

2745 Pinguicula Corsage

2746 Cold Heart

2747 Black Cat

2749 Linen Glove(?)

2772 Glorious Ring

2773 Glorious Popularized Ring

2774 Glorious Mass-Production Ring

2777 Shaman Ring

2778 Shaman Earrings

2779 Dark Knight Belt (Type 1)

2781 Aumdura's Benefit

2780 Dark Knight Glove (Type 1)

2782 Ring of the Ancient Wise King

2783 Eye Stone Ring

2787 Waterdrop Brooch

2788 Bradium Earring

2789 Bradium Ring

2790 Bradium Brooch

2795 Green Apple Ring

2800 Accelerator

2801 Hovering Booster

2802 Suicidal Device

2803 Shape Shifter

2804 Cooling Device

2805 Magnetic Field Generator

2806 Barrier Builder

2807 Repair Kit

2808 Camouflage Generator

2826 Dark Knight Belt (Type 2)

2827 Dark Knight Glove (Type 2)

2843 Golden Bell

2844 Light of El Dicastes

2853 Telekinetic Orb

2854 Alchemy Glove

Edited by AlmrOfAtlas, 31 August 2015 - 08:53 PM.

[Themes]

Thanks! I havent been putting much time into the DB lately, dragging my feet on getting up to date drops finished but it turned into being a bigger project than I thought.

 

Please dont remove a bunch of the New World/KVM things though (unless someone wants to take responsibility for putting them back in if/when they make it onto Classic), they're not in but useful to have available. Anything from after Renewal should probably get hidden though.

[AlmrOfAtlas]

Thanks! I havent been putting much time into the DB lately, dragging my feet on getting up to date drops finished but it turned into being a bigger project than I thought.

 

Please dont remove a bunch of the New World/KVM things though (unless someone wants to take responsibility for putting them back in if/when they make it onto Classic), they're not in but useful to have available. Anything from after Renewal should probably get hidden though.

 

If they're added they'll likely be modified to suit Classic, so it doesn't matter if they're kept in or not.

 

Either way though, they shouldn't be publicly visible.

 

People need a source of reference accurate to the server. If you want to add or retain things prospectively, start up something like Doddles' old Future Wiki or make a page on iW Classic Wiki for it.

Edited by AlmrOfAtlas, 31 August 2015 - 09:33 PM.

[ParkWonJae]

Wrong category Athena Earring.

[Kadelia]

classic doesn't have things that came out before renewal like kvm gear, armor of naga, sprint mail, etc...? Why not?

[Themes]

There's a few reasons, the lack of New World is basically that monsterIDs are hardcoded into Classic and the GMs have run out then repurposed the New World IDs for use in custom content for Classic (new 1.0 creations, events etc). I was hoping we would be able to get the content at some point, but it seems like we're just going to have to make the drops available to people through alternative means. 

 

As for KvM there has been a lot of people fighting its implementation, people have poor experiences with bugged/exploitable battlegrounds and badges showing up from the Kafra Shop. People have proposed imitating the jRO link system, but people are just fairly against KvM in general, despite the good things that it brings to end game balance for PvP/WoE.

 

But with regards to the Classic DB, I'm happy if someone wants to work with Jaye and see if her tool can get the Classic version flags added. I dont mind double checking and making sure it all interacts with the front end, from memory I think there's no Classic version for items (just the shared, pre-re and renewal versions, nothing classic specific) and it's part of why I shelved doing work on it. I have a rather large list of hats that need to be added/made visible specifically for Classic I can pass on to them.

[Kadelia]

Well I believe VERSION=1 is classic-only isn't it?

[Themes]

Not entirely, it's basically shared with the pre-renewal stuff.

 

I did some research when I was making myself familiar with the DBs and here's which version each page was looking for data from:

 

So basically Classic is supposed to be 3, but it hasnt really been changed for it all. For probably 99% of the items/monsters it's fine, but there's a few specific items that have been changed or modified where its effects are different from Pre-Re, Renewal and Classic.

 

When I'm done preparing drop data for Classic I'm going to be changing it to only 3 I think and add new entries for everything, which is partially why it's taking so long, so much double checking.

 

Also having the Renewal page pulling all item data stopped me from doing much and maybe worth looking into.

Edited by Themes, 01 September 2015 - 05:35 PM.

[Kadelia]

I thought

0 = both

1 = classic

2 =  renewal

 

[Themes]

From what I understand 0 is both (more like, everything from Pre-Renewal or Pre-DB split). 1 is shared between Classic/Pre-Re (with a separate version for monster spawns when they were customised hence the 3). 2 is Renewal.

 

Things that changed for Renewal or were added after the split ended up as 1 or 2, so both their effects could be shown in the two different sets of data while everything else was just left at 0.

 

I dont really know how many people actually use the Pre-Renewal DB and it's probably fine if Rideword Hat reflects the Classic modifications, but there's things like spawn/drops data where we're going to have three different sets of data and if you were going to start adding "new" items for Classic being able to separate them from the Pre-Renewal DB may prove useful.

 

It would also actually allow us to separate the actual differences between "normal" Pre-Renewal and Classic (New World/KVM etc) but right now they're all under the same thing, so removing KVM/New World drops from Classic removes it from the Pre-Renewal page too. It'd be an interesting project, but a lot of work and not something I have the time for right now.

Edited by Themes, 01 September 2015 - 06:10 PM.

[Kadelia]

I don't see the point of a pre-renewal data set. There is classic and there is renewal. We're not a p-server database...

[Kadelia]

So I just tested this, and a version 1 and 3 item both show up in the renewal database. So there is no way to exclude them. I even set the visible2 flag to 0 and it still is displayable...

 

I'm afraid I'll need to tweak the PHP page

Edited by Jaye, 01 September 2015 - 06:15 PM.

[Themes]

Uhh you can write a join similar to what I've done with the Classic pages, but it requires an entry in item_misc for each item I think?

 

In the middle of something atm so I cant look, I'll post some more about it when I'm done in a couple of hours.

[Kadelia]

I edited info.php

 

Was

 

    if (!dbQuery("SELECT name, description, unident, notes, category, subcat, weight, slots, reqlv, upgrade, damage,
        buyable, job, price, binding FROM item_main LEFT JOIN item_misc USING (id) WHERE id=$item AND $serverCon",
        "itemInfo-main")){

 

Now

    if (!dbQuery("SELECT name, description, unident, notes, category, subcat, weight, slots, reqlv, upgrade, damage,
        buyable, job, price, binding FROM item_main LEFT JOIN item_misc USING (id) WHERE id=$item AND version != 3 AND $serverCon",
        "itemInfo-main")){

 

 

It now won't show version 3 items when you link to them on renewal DB (it never searched for them. The searches query version=0 and version=2)

[Kadelia]

Edited classic info.php

 

Was

 

    if (!dbQuery("SELECT name, description, unident, notes, category, subcat, weight, slots, reqlv, upgrade, damage,
        job, price, binding FROM item_main LEFT JOIN item_misc USING (id) WHERE id=$item AND $serverCon "
        . "AND (version=0 OR version=1)",
        "itemInfo-main")){

 

Now

 

    if (!dbQuery("SELECT name, description, unident, notes, category, subcat, weight, slots, reqlv, upgrade, damage,
        job, price, binding FROM item_main LEFT JOIN item_misc USING (id) WHERE id=$item AND $serverCon "
        . "AND (version=0 OR version=1 OR version=3)",
        "itemInfo-main")){

 

http://db.irowiki.or...-info/16777214/

http://db.irowiki.or...-info/16777214/