Ooooops

[unprotectedtext]

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?

[lerxst2112]

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.

[unprotectedtext]

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 >.<

[lerxst2112]

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.

[unprotectedtext]

Originally Posted by lerxst2112

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