EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Don't know how to remove inserted objects from mysql (https://www.eqemulator.org/forums/showthread.php?t=20884)

Runeblade 06-25-2006 02:42 PM
Don't know how to remove inserted objects from mysql
 
I inserted a forge with aug type capaibilties but i accidently placed it inside a wall and i dont know how to edit it or remove and replace it. Need some help :(.

Here was the code

NSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (5001, 152, '220', '90', '-55', '140', 17909, 0, 'IT66_ACTORDEF', 53, 1115);

Angelox 06-25-2006 03:09 PM
Quote:
Originally Posted by Runeblade
I inserted a forge with aug type capaibilties but i accidently placed it inside a wall and i dont know how to edit it or remove and replace it. Need some help :(.

Here was the code

NSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (5001, 152, '220', '90', '-55', '140', 17909, 0, 'IT66_ACTORDEF', 53, 1115);
would it be DROP ? Anyways , go to MySQL web site, download and install MySQL Query Browser, It also points out command options , and helps you into how to use them, on the bottom , right-hand corner in the Syntax window.

[~RD~ Sorry to butt into this post instead of posting my own reply but I felt this is important enough it should be said here. The DROP command is not the correct command to remove data from a table. The DROP command is used to remove tables entirely, and can also remove your database entirely if given the right syntax.]

Runeblade 06-25-2006 03:10 PM
thanx
 
Cool thanx for the info, been stuck for awhile lol

Angelox 06-25-2006 03:13 PM
Quote:
Originally Posted by Runeblade
Cool thanx for the info, been stuck for awhile lol
The best solution is to back up often - I have also installed "MySQL Administrator", it does back ups very well.

Runeblade 06-25-2006 05:22 PM
Navicat and now i have augs!
 
I downloaded Navicat for mysql found my entry ad edited the position a bit and now I can attach augs to my armor!!!!!!

WOOT WOOT

njlinus 06-26-2006 12:33 AM
Augs work now? i havent tried in a few weeks, as far as i got was the insert but the aug never got attached.

Angelox 06-26-2006 01:13 AM
Quote:
Originally Posted by Runeblade
I downloaded Navicat for mysql found my entry ad edited the position a bit and now I can attach augs to my armor!!!!!!

WOOT WOOT
could you explain to us how you did this? thanks.

farce 06-26-2006 03:38 AM
there are many mysql front ends that make editing a database easier. if you really wanna learn some basic sql though, read www.sqlcourse.com

Runeblade 06-26-2006 05:18 PM
Augments
 
Just got back on the boards, not quite sure how I got my augs but I Completely auged out my lvl 70 paladin with all effects attaching from the augs. Can't wait for the class aa's to work but the regular all class ones are good enough for now for my 0.7.0.

I'll look into the augs tommorow and see thecoding and stuff.

boscorillium 06-28-2006 03:50 AM
DELETE FROM [tablename] WHERE [column name] = [value]



On another note, learn SQL. You won't be sorry. This stuff will just continue to invade our lives. I personally love databases. :)

Runeblade 06-28-2006 10:09 AM
Thanx
 
Thanx for all the info :)


All times are GMT -4. The time now is 12:49 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.