Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #16  
Old 09-24-2013, 04:48 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default

Do you even have a database?? Also edit out user name and password...

peq.EVERYTHING does not exists...
Reply With Quote
  #17  
Old 09-24-2013, 05:05 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,603
Default

Quote:
Originally Posted by rencro View Post
Do you even have a database?? Also edit out user name and password...

peq.EVERYTHING does not exists...
He likely didn't source the database in correctly.
Reply With Quote
  #18  
Old 09-24-2013, 05:06 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

I followed them to the T and re checked ... looking at the log files it seems I have some PEQ files missing (from git??)part I believe?
Reply With Quote
  #19  
Old 09-24-2013, 05:10 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,603
Default

Did you get your database from here? Which guide did you use? Did you use this one?
Reply With Quote
  #20  
Old 09-24-2013, 05:17 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

ok downloading database from there... and yes I followed that wiki guide...

when I download data how do I install this one? I got the quest and maps sorted no problems
Reply With Quote
  #21  
Old 09-24-2013, 05:29 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,603
Default

There should be a file named "drop_system", this file drops all non-player-related tables allowing you to source in the new information. You'll then source in the peqbetaXXXXXXXX.sql then source in the special abilities .sql.
Reply With Quote
  #22  
Old 09-24-2013, 09:03 PM
HnathBST
Sarnak
 
Join Date: Feb 2007
Location: Sunset Home
Posts: 71
Default

The guys over at PEQ have recently switched from the SVN to a google drive with a daily dump. I don't think any of the guides have been updated to reflect this, so your DB is most likely out dated.

to source the new files like kingly said you simply put them in your C:\EQ\SQL folder, open a command prompt and navigate to that folder.

then type:
Code:
C:\EQ\SQL> mysql -u root -p peq
<it will ask your password, type it and press enter>
mysql> source drop_system.sql
<this will take a second>
mysql> source peqbeta_{date_time}.sql <this will change depending on when you d/l>
<this will take a minute, good time to get some coffee...>
mysql>source user_tables_{date_time}.sql <same date as above>
<this won't take as long>
mysql>source source_views.sql
Obvisiously ignoring my comments ^*

That SHOULD get you up and running with your DB, just let us know if you encounter any errors.
Reply With Quote
  #23  
Old 09-26-2013, 02:20 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

ok as far as im aware server is up and running could someone log in and check for me please (to see if outsiders can connect)?

server name is warville
Reply With Quote
  #24  
Old 10-23-2013, 01:33 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

now server is up and running perfectly (for me anyways) not sure about people outside of my i.p range.....time will tell

anyways how do I open up expansions? please this is racking my head to the stage blood comes out
Reply With Quote
  #25  
Old 10-28-2013, 05:17 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

What do you mean open up expansions? There are a lot of changes you can make in the rule_values tables. One is World:ExpansionSettings and that may have an impact, as far as zones that are closed, you can always open those up to players in the zones table with the minstatus column being changed.
Reply With Quote
  #26  
Old 10-29-2013, 07:47 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

like bastion of thunder... plane of time B etc and discord... cant zone into those and more.... ow and plane of disease comes to mind

i know those can be used in EQemu but not on my server
Reply With Quote
  #27  
Old 10-30-2013, 12:28 AM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,742
Default

Are you using the Underfoot client? It sounds like you are missing client files. http://www.eqemulator.net/wiki/wikka...ssingFilesList
Reply With Quote
  #28  
Old 10-30-2013, 02:50 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

i am using underfoot but yet i could enter riftseekers on someone elses server?

but still bastion of thunder dose not work and afew more? yet i can any tranquil?
Reply With Quote
  #29  
Old 10-30-2013, 03:02 PM
HnathBST
Sarnak
 
Join Date: Feb 2007
Location: Sunset Home
Posts: 71
Default

Quote:
Originally Posted by warkid View Post
i am using underfoot but yet i could enter riftseekers on someone elses server?

but still bastion of thunder dose not work and afew more? yet i can any tranquil?
I am not sure what zones PEQ has locked with Min status off the top of my head. Did you set your account as a GM account? I know some of the zones that PEQ are still working on are locked with a minimum status to enter.

you can run the mysql query to set your status:
Code:
update account set status = 200 where `name` like 'youraccountname'
obviously changing 'youraccountname' to the username you use to login to your server with.
Reply With Quote
  #30  
Old 10-30-2013, 03:21 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

im set as GM .... that command you gave me dose nothing?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:20 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3