EZ Server

General Category => General Discussion => Topic started by: brixu on March 27, 2012, 11:01:23 pm



Title: Attn: Hunter (port rings)
Post by: brixu on March 27, 2012, 11:01:23 pm
hunter is it possible to color code the port rings: ring or dragons,ring of abyss, ring of gods etc... so its easier to locate and maybe add a secondary ring to each vendor to port group like airplane?


Title: Re: Attn: Hunter (port rings)
Post by: Natedog on March 28, 2012, 02:34:53 am
hunter is it possible to color code the port rings: ring or dragons,ring of abyss, ring of gods etc... so its easier to locate and maybe add a secondary ring to each vendor to port group like airplane?

This would be a nice change just for convenience.


Title: Re: Attn: Hunter (port rings)
Post by: Fliker on March 28, 2012, 03:04:08 am
/agree
+1

hate ending up in wrong zone


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 01:26:10 pm
Do you mean change the graphic icon in your inventory window so you can tell which ring is which easier?

Yeah I could do that.


Title: Re: Attn: Hunter (port rings)
Post by: Duladian on March 28, 2012, 02:39:38 pm
I say +1 to the group port.  Even if the cost of the ring is say 1 mil I'd still take it over not having one.


Title: Re: Attn: Hunter (port rings)
Post by: hateborne on March 28, 2012, 05:16:35 pm
As for the ring graphic, I can probably write queries for that tonight.

As for self vs group, the new druid/wizard ports are to the tiered zones. If they go live, all rings should become self.

-Hate


Title: Re: Attn: Hunter (port rings)
Post by: Fliker on March 28, 2012, 07:56:57 pm
Awsome, thanks


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 09:45:21 pm
If you let me know which rings you want to have which graphics, then I can quickly manually edit that in the database.

For example, tell me that you want the Plane of Dragons ring to have the same icon as the Diamond Wedding Band ... etc


Title: Re: Attn: Hunter (port rings)
Post by: hateborne on March 28, 2012, 10:16:03 pm
Ring of Dragons
Code:
UPDATE items SET icon = 1060 where id = 100099;

Ring of Gods (hohonora)
Code:
UPDATE items SET icon = 872 WHERE id = 112600;

Ring of the Abyss
Code:
UPDATE items SET icon = 1045 WHERE id = 112598;

Ring of Anguish
Code:
UPDATE items SET icon = 1255 WHERE id = 113400;

And on a petty, pleading note...Guardian Charms
Code:
UPDATE items SET icon = 1503 WHERE name LIKE 'Guardian\'s Charm%';
UPDATE items SET icon = 1503 WHERE id = 113942;
UPDATE items SET icon = 1503 WHERE id = 99028;

-Hate


Title: Re: Attn: Hunter (port rings)
Post by: brixu on March 28, 2012, 10:25:06 pm
thank you hunter and hateborne appreciate it should make life a little easier on EZ!


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 10:38:12 pm
About 1/3 of players online right now still using Titanium. Need to know that at least Titanium players can see graphics of any items Pre-T6. Actually, I'll probably log on my Titanium client now and look at similar items, should give me an idea.


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 10:39:35 pm
Titanium is so painfully slow to load. I got spoiled by Underfoot.


Title: Re: Attn: Hunter (port rings)
Post by: hateborne on March 28, 2012, 10:41:32 pm
Yeah, I tested them all in Titanium. It is my test client since we still have a ton of users on it (myself included).

All the item icons loaded fine.

-Hate


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 10:42:58 pm
Ok, verified in Titanium all graphics show up.

My concern with an 'invisible' graphic is that I'd get spammed with emails about items disappearing / deleting when in reality they are invisible to the client.


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 28, 2012, 10:47:59 pm
You did a typo. Guardian's Upgrade v2 is 112942, not 113942. /shame!

Code:
[SQL] UPDATE items SET icon = 1060 where id = 100099;
Affected rows: 1
Time: 0.078ms

[SQL]
UPDATE items SET icon =  872 WHERE id = 112600;
Affected rows: 1
Time: 0.038ms

[SQL]
UPDATE items SET icon = 1045 WHERE id = 112598;
Affected rows: 1
Time: 0.038ms

[SQL]
UPDATE items SET icon = 1255 WHERE id = 113400;
Affected rows: 1
Time: 0.037ms

[SQL]
UPDATE items SET icon = 1503 WHERE name LIKE 'Guardian\'s Charm%';
Affected rows: 50
Time: 0.059ms

[SQL]
UPDATE items SET icon = 1503 WHERE id = 112942;
Affected rows: 1
Time: 0.059ms

[SQL]
UPDATE items SET icon = 1503 WHERE id = 99028;
Affected rows: 1
Time: 0.051ms


Title: Re: Attn: Hunter (port rings)
Post by: hateborne on March 28, 2012, 10:49:17 pm
*cast Gate*


Title: Re: Attn: Hunter (port rings)
Post by: Strix on March 30, 2012, 04:45:53 am
Hi Hunter

Any chance for a port ring into the "Crafter's Guild"? 

:D

Strix


Title: Re: Attn: Hunter (port rings)
Post by: Hunter on March 30, 2012, 09:43:28 am
Sure, didn't realize I forgot that one.