When it rain it pours...

Valdis01 · #1 01-27-2012, 02:10 AM

When it rains it pours with my server, apparently... My guild windows worked a while ago, since my DB change to starting zones using the cmd prompt, my guild windows now DO NOT display who is online in the guild... Hell who am I kidding, it doesn't show ANYONE in the guild with Alt G...

I mean... Really, when it rains it pours with my server... Rofl.

On the up hand, everything is going great!

Valdis01 · #2 01-28-2012, 02:23 AM

Sorry for necro bump, buuuut need to know, getting old not seeing people in guild window.

**trevius** · #3 01-28-2012, 01:28 PM

LOL, never heard a day old post bump referred to as necro'ing a thread :P

Anyway, you didn't provide any useful information to help with your issue. What source code revision and Database were you running before, and which ones are you running now?

Most likely, you forgot to run some of the required SQL when updating, but there haven't been any related to guilds in quite a while that I can think of offhand.

Valdis01 · #4 01-28-2012, 03:37 PM

Eh I don't have this off of my forum click, so I thought there was a possibility it was lower on the list, so I felt like it was necro-bumping.

So the PEQ DB - 2092 (With bots) - Haven't changed it or updated it, I did a MQSQL prompt to change peoples bind points to QRG and my Guild Window stopped working...

Could it be that instead of the green check mark showing everything checks out, I have a Red (!) on my source? Changed an option in there that was said to believe would let me spawn in QRG when I found out I just had to do a server restart.

**trevius** · #5 01-28-2012, 04:23 PM

If you changed people bind points, then I think that means you had to use a query that adjusts the fields for it in the Player Profile blob in the character_ table. If so, maybe you messed something up while trying to do that, as it is not a simple change to make.

What exactly was the query you used to make the changes you are talking about?

I have no idea about the green or red stuff you are talking about unless you mean the SVN folder for your database files from PEQ or on the Source code SVN folder. If you see any in red, that means you edited them and they don't match the trunk of the SVN.

Valdis01 · #6 01-28-2012, 04:49 PM

All I did was update the start_zone table located via Navicat. The command... Escapes me of fthe top of my head, I'll get back to you on that.

Valdis01 · #7 01-29-2012, 02:31 PM

The command I did was;

UPDATE start_zone SET zone_id=3 X=-34.1, Y=-1, Z=2.1, start_zone=3 bind_x=-34.1, bind_y=-1, bind_z=2.1

I believe that was it, it was done at the start of my server a month ago... rofl.

EQstarr · #8 01-29-2012, 06:35 PM

Quote:

Originally Posted by Valdis01

The command I did was;

UPDATE start_zone SET zone_id=3 X=-34.1, Y=-1, Z=2.1, start_zone=3 bind_x=-34.1, bind_y=-1, bind_z=2.1

I believe that was it, it was done at the start of my server a month ago... rofl.

Is this how you change the bind points for new characters that are made? I've been changing some items on my table, and it doesn't work for me. I've got their "landing point" working, but they seem to bind at that point and not where I want them. Here's an example of one line for the Dark Elves:

Code:

INSERT INTO `start_zones` (`id`, `x`, `y`, `z`, `zone_id`, `bind_id`, `player_choice`, `player_class`, `player_deity`, `player_race`, `start_zone`, `bind_x`, `bind_y`, `bind_z`, `select_rank`) VALUES (198, -558.75, -56.75, -38.84, 41, 25, 5, 1, 211, 9, 41, -701, 2055, 47, 50);

At first I had the "bind id" at "0". Then I changed it to "25" for Nektulos Forest, which is where I want it. It didn't take my "bind_xyz" coordinates, but rather it binded new characters to the Safe Zone coordinates of Nektulos.

I thought I tried changing the "Start_Zone" to 25 and it didn't work, but maybe I missed that. What is the "bind_id" for?

Valdis01 · #9 01-29-2012, 10:52 PM

I don't know about the bind ID everyone starts in the correct places now.. .I had everything right, just when I locked the zones there were a few people NOT in the correct places and ended up in TutorialB by forced reasons... Opps.

kalua · #10 02-02-2012, 04:59 PM

Quote:

Originally Posted by Valdis01

Sorry for necro bump, buuuut need to know, getting old not seeing people in guild window.

Here are the notes I wrote down regarding this issue which occurs for me when using bots:

Quote:

A few years ago, the guild members table was updated to include a way to indicate if a character was an alt or not.

The bot guild members table never received the same update.

When bots are used, there is a view that builds the guild member list from both the real players and the bots (as you can guild invite bots).

To fix the issue I had to give bot guild members table the same alt column, and adjust the view to include the alt column from both real players and bots.

I've found a few posts here and there referring to this as the fix for other servers as well.

Good luck,