Go Back   EQEmulator Home > EQEmulator Forums > Search Forums

Showing results 1 to 18 of 18
Search took 0.00 seconds.
Search: Posts Made By: Gaflack
Forum: Development::Bots 02-28-2013, 09:36 AM
Replies: 19
Views: 6,083
Posted By Gaflack
1 final note. I did a dump with routines,...

1 final note.

I did a dump with routines, restored to clean server and bot's worked fine. All tables (and Views) appear to have been in the backup.

mysqldump --routines -u root -ppassword peq...
Forum: Development::Bots 02-26-2013, 07:10 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Bots are back to zoning. I still had some...

Bots are back to zoning.

I still had some issues getting the data sourced back in correctly. Finally I did a dump of the vwgroups table on the working server I then sourced in the 2 Creates as...
Forum: Development::Bots 02-26-2013, 10:17 AM
Replies: 19
Views: 6,083
Posted By Gaflack
Thanks Bad_Captain! Those 2 Creates were not...

Thanks Bad_Captain!

Those 2 Creates were not in my dump I made of my good server (did a --no-data dump). Made a full dump with --routines and grep'ed it out and see the function creates.
...
Forum: Development::Bots 02-25-2013, 09:14 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Just posting info as I can, maybe some will find...

Just posting info as I can, maybe some will find it useful.

mysqldump need to add --routines option to get the views dumped.

Did that to my working test server and get the 4 bot Views but have...
Forum: Development::Bots 02-25-2013, 04:35 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Compare between working server (bots zone) and...

Compare between working server (bots zone) and server where bots fail to zone shows the VIEW:

vwgroups

is missing from the server.

Time to get out in traffic and head home so plenty time for...
Forum: Development::Bots 02-25-2013, 04:16 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Thanks Lillu, my old memory thought that the...

Thanks Lillu, my old memory thought that the Views were just Temporary Tables created from physical tables in the database. I guess it is time to pull the book off the shelf and stop just poking...
Forum: Development::Bots 02-25-2013, 03:51 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Yea, I am just doing a full dump of the database...

Yea, I am just doing a full dump of the database and sourcing it back in, so I guess my process is not to screwed-up.

I will do a trial and error test sourcing the various tables to see which if...
Forum: Development::Bots 02-25-2013, 02:53 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Thanks for the post, I will hit the test server...

Thanks for the post, I will hit the test server this week and see if I can figure out what to re-source etc. to get the bots working.

I really want to make sure that my Backup-Restore process is...
Forum: Support::Windows Servers 02-25-2013, 09:51 AM
Replies: 1
Views: 1,913
Posted By Gaflack
Server Backup Restore Question

Backing up a working Server to move to new hardware, what is wrong with this process:

Mysqldump of peq database

Install Perl, Install Mysql

Copy Server Folder from old to new.

Create...
Forum: Development::Bots 02-22-2013, 05:19 PM
Replies: 19
Views: 6,083
Posted By Gaflack
Bots are in my group. Bot-groups and 2...

Bots are in my group.

Bot-groups and 2 client + Bots have never zoned for me either.

Bots in group did zone until I just re-did Server.

Nothing in logs.

Main question is: Am I missing...
Forum: Development::Bots 02-22-2013, 10:30 AM
Replies: 19
Views: 6,083
Posted By Gaflack
Another Bot Zoning question

I have been looking over the forums about a bot zoning issue and would love any input before I start playing with the database.

Windows Server works great.

Move to new hardware (dump database,...
Forum: Quests::Submissions 12-03-2012, 08:46 AM
Replies: 0
Views: 6,982
Posted By Gaflack
Poor Man's Tradeskill Trophy Quests

I could not find any information on the Tradeskill Trophy Quest line that was started in W. Freeport. My friends and I love Trade-skilling so I started creating a poor man's version of the old Trophy...
Forum: Quests::Q&A 11-28-2012, 11:21 AM
Replies: 10
Views: 2,869
Posted By Gaflack
Ran some more checks and zone is crashing,...

Ran some more checks and zone is crashing, clients in other zones ok. Check Processor during hails of npc with different quest items. Processor load goes from 1%, 10%, 12%, 13%, 100% (5sec), 100%...
Forum: Quests::Q&A 11-27-2012, 01:18 PM
Replies: 10
Views: 2,869
Posted By Gaflack
Thanks for the post sorvani. I really...

Thanks for the post sorvani.

I really appreciate that you took the time to not just say 'your code is lame' but to show where to improve. After 20+ years away from any coding any help is a...
Forum: Quests::Q&A 11-27-2012, 09:04 AM
Replies: 10
Views: 2,869
Posted By Gaflack
Thanks for the post Drajor. I did a little...

Thanks for the post Drajor.

I did a little testing last night and it seems that when I try the script it not only kills the client it kills any other client I have running. Very Strange.

Things...
Forum: Quests::Q&A 11-26-2012, 08:52 AM
Replies: 10
Views: 2,869
Posted By Gaflack
check_hasitem issue or just bad Perl Code

The below quest works but has issues.

Quest purpose: give info on updated a item and then take items and update.

The quest works fine taking turn-ins and giving the updated item. The issue is...
Forum: Support::Windows Servers 11-01-2012, 03:06 PM
Replies: 2
Views: 2,362
Posted By Gaflack
Thanks Chaos, I guess after reading all...

Thanks Chaos,

I guess after reading all those post I was in overload about how the other Lootdrop tables applied to the overall chance of an drop.

Michael
Forum: Support::Windows Servers 10-31-2012, 02:09 PM
Replies: 2
Views: 2,362
Posted By Gaflack
Loot Drop Percentage Question

Please go ahead and roll your eyes I will understand but my old brain just can not solve loot drop percentage. I have read tons of posts about it and still feel confused. Maybe this answer will help...
Showing results 1 to 18 of 18

 
Forum Jump
   

All times are GMT -4. The time now is 04:59 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3