Search found 33 matches

by fallen45078
Fri Jun 23, 2017 7:04 pm
Forum: Server Setup & Guides
Topic: Server Clustering
Replies: 4
Views: 4996

Re: Server Clustering

That's what I thought, Whasf. And I am aware of at least one other server that has this function working. I am going to play with it some more and see if I can come up with anything else. I just hit a block and basically wanted to vent and see if anyone else had had a similar problem. BTW, I'm not e...
by fallen45078
Fri Jun 23, 2017 8:31 am
Forum: Server Setup & Guides
Topic: Server Clustering
Replies: 4
Views: 4996

Server Clustering

I successfully separated my server onto multiple servers by region. They all start and I can log in. I can move from zone to zone, access the auction house, etc. I can NOT broadcast server messages, receive LS chat or send or receive party invites. What am I missing?
by fallen45078
Sat Jun 17, 2017 10:25 pm
Forum: Server Setup & Guides
Topic: Map Server and VM Clustering
Replies: 6
Views: 8417

Re: Map Server and VM Clustering

What about LS chat? it seems to break across multiple instances also.
by fallen45078
Tue Jul 12, 2016 12:42 pm
Forum: Scripting
Topic: Item flags for bazaar
Replies: 2
Views: 4024

Re: Item flags for bazaar

No one?
by fallen45078
Sun Jul 03, 2016 3:12 pm
Forum: Scripting
Topic: Item flags for bazaar
Replies: 2
Views: 4024

Item flags for bazaar

Which flag prevents an item from being put into a bazaar? EX? No sale? or No Auction?

If you wanted to allow any item to be put into a bazaar, what would be the best way to go about doing so?

Thanks!
by fallen45078
Mon May 09, 2016 8:19 pm
Forum: Server Setup & Guides
Topic: Item Monetary Values
Replies: 5
Views: 5888

Re: Item Monetary Values

You're correct, but setting the price was all I needed. My auction house was already populated at 100 gil per item.
by fallen45078
Sun May 08, 2016 3:45 pm
Forum: Server Setup & Guides
Topic: Item Monetary Values
Replies: 5
Views: 5888

Re: Item Monetary Values

Here's the solution. Posting this because no one ever posts how they solved their problem.. UPDATE auction_house SET price = (SELECT BaseSell FROM item_basic WHERE auction_house.itemid = item_basic.itemid) WHERE EXISTS (SELECT BaseSell FROM item_basic WHERE auction_house.itemid = item_basic.itemid);...
by fallen45078
Sun May 08, 2016 1:14 pm
Forum: Server Setup & Guides
Topic: Item Monetary Values
Replies: 5
Views: 5888

Re: Item Monetary Values

I found what I was looking for in the item_basic table. This table lists the sell value for each item.

What I need now is the SQL command that would set the price on item 123456 on the auction house to the value listed in the table item_basic for item 123456.
by fallen45078
Sun May 08, 2016 10:53 am
Forum: Server Setup & Guides
Topic: Item Monetary Values
Replies: 5
Views: 5888

Item Monetary Values

Where would one find the values of items? The short is that I want to completely fill the auction house, but I want to set each item's price to equal the buy back price at npc shops. Im trying to find a balance between item availability and the economy of my server. The idea is to stop someone from ...
by fallen45078
Thu Apr 21, 2016 7:33 pm
Forum: Public Servers
Topic: Realms of Jova
Replies: 0
Views: 5308

Realms of Jova

We're still here and more stable than ever before! IP address: 107.15.247.151 or realmsofjova.ddns.net (if ip address changes before we update this posting) 6x exp 10x fame 5x skillup rate 2x run speed Level cap 99 Limit break removed. No level caps on battlefields! All advanced jobs unlocked! Subjo...