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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 06-21-2011, 10:00 AM
unprotectedtext
Fire Beetle
 
Join Date: Apr 2011
Posts: 7
Default Ooooops

tried and tried to fix this myself to no avail. when i was browsing thru the item list in the database i tried to sort the id in numerical order and i reset the sorting. whoa is me, even rebuilt the whole database twice, did i screw something up by doing this?
Reply With Quote
  #2  
Old 06-21-2011, 11:36 AM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,742
Default

You actually changed the IDs in the database, or you just clicked a column in whatever tool you use to sort the view differently? The first is a problem and you will probably need to drop the table and source it back in from the original PEQ version or a backup, the second is just a visual thing and didn't change your database at all.
Reply With Quote
  #3  
Old 06-21-2011, 12:27 PM
unprotectedtext
Fire Beetle
 
Join Date: Apr 2011
Posts: 7
Default

first off i was using heidisql, i right clicked in the column and clicked reset sorting thinking it would list it in numerical order, just as i clicked it i knew that i should of just clicked to top of the column but by then to late no undo to be heard of. backed up player data, world data and bot data to rebuild database, just deleted whole data base and rebuilt from scratch and checked befor i souced in my player/world/bot data and the items table still ended up with the same id's going from 1001 - 2117.

if i were to just source in the items table. how would i go about getting just the items table from and old backup? or if anyone would be so kind as to point me in the right direction of just the data table sql.

so sorry for bothering anyone with this i now just realized that it did exactly that, reset my sorting order, what i didn't see is that it only shows the first 1000 entries, clicked show all and everything was sorted numerically like i wanted >.<

Last edited by unprotectedtext; 06-21-2011 at 12:37 PM.. Reason: oh man i'ma dumbass.
Reply With Quote
  #4  
Old 06-21-2011, 12:40 PM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,742
Default

I'm not sure what you mean when you say you deleted the whole database. If you dropped the tables and recreated them from scratch, which I assume to mean you sourced the peq database, then it should be fine. I don't use Heidi SQL, so I don't know what the option you used does.

The peq database dump is just a bunch of create/insert statements, so if you only need part of it you can open the file in a text editor, find the part you need, and copy/paste it to a new file and source that.
Reply With Quote
  #5  
Old 06-21-2011, 12:48 PM
unprotectedtext
Fire Beetle
 
Join Date: Apr 2011
Posts: 7
Red face

Quote:
Originally Posted by lerxst2112 View Post
I'm not sure what you mean when you say you deleted the whole database. If you dropped the tables and recreated them from scratch, which I assume to mean you sourced the peq database, then it should be fine. I don't use Heidi SQL, so I don't know what the option you used does.

The peq database dump is just a bunch of create/insert statements, so if you only need part of it you can open the file in a text editor, find the part you need, and copy/paste it to a new file and source that.
thanks a lot for the reply, i normally can figure things out, but i must of been to frustrated to think straight. but i have it all figured out now just didn't think about it till i finally asked for help LOL. again thanks for the reply
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 05:24 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