Don't know how to remove inserted objects from mysql

[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);

[Angelox]

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]

Cool thanx for the info, been stuck for awhile lol

[Angelox]

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]

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]

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]

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]

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]

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]

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]

Thanx for all the info