SQL help !!

[Mitron]

I want to release a SQL file for my town.
it should put the objects in the DB and then put the spawn where it should be. anyone tell me how to do this fast and easy ? ^^
btw im not on my computer so if anyone could give me the whole
INSERT INTO gameobject_names row so i can start with the objects it would be very nice. If you help me know the SQL probably will be uploaded tonight
BTW is there any way to copy many spawns from DB ??

[X-CON]

Umm i could maybe help u do you have vent and also are u LF a Dev and a website dev aswell?

[Mitron]

well i havent any working computer atm... this is my sisters computer because mine crashed of a virus yesterday and i reinstalling widows that seems to be very hard cuz of something now :S but if anyone could giv me the SQL row for put objects into DB like INSERT INTO Gameobject_names. i dunno how the full row is but i want it cuz i know the display ID's for the stuff im using. could create an sql for the stuff

[Algorithm]

I want to release a SQL file for my town.
it should put the objects in the DB and then put the spawn where it should be. anyone tell me how to do this fast and easy ? ^^
btw im not on my computer so if anyone could give me the whole
INSERT INTO gameobject_names row so i can start with the objects it would be very nice. If you help me know the SQL probably will be uploaded tonight
BTW is there any way to copy many spawns from DB ??

i can tell you away i do it.

Backup your gameobject_spawns...

then simply make a fresh gameobject_spawns table, load up your server and spawn your city, then after done save the new gamebject_spawns table and execute it to your original table.

[Mitron]

well okay :P ill try it when my computer works again :P wich may take a while >.> could anyone tell me the INSERT INTO gameobject_names row ??? i will start make the objects sql. plz anyone

[y2kss66]

this is for my server which runs aspire/hearthstone:

insert into `gameobject_names`(`entry`,`Type`,`DisplayID`,`Name`,`spellfocus`,`sound1`,`soun d2`,`sound3`,`sound4`,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unknown1`,`u nknown2`,`unknown3`,`unknown4`,`unknown5`,`unknown6`,`unknown7`,`unknown8`,`unkn own9`,`unknown10`,`unknown11`,`unknown12`,`unknown13`,`unknown14`) values

[Mitron]

thx man ^^ i just replace the name with the numbers right ?

[y2kss66]

yep!(fillerz)

[Mitron]

thx y2 when im finished with the text how i convert it to sql ?

[y2kss66]

insert into `gameobject_names`(`entry`,`Type`,`DisplayID`,`Name`,`spellfocus`,`sound1`,`soun d2`,`sound3`,`sound4`,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unknown1`,`u nknown2`,`unknown3`,`unknown4`,`unknown5`,`unknown6`,`unknown7`,`unknown8`,`unkn own9`,`unknown10`,`unknown11`,`unknown12`,`unknown13`,`unknown14`) values (`entry`,`Type`,`DisplayID`,`Name`,`spellfocus`,`sound1`,`soun d2`,`sound3`,`sound4`,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unknown1`,`u nknown2`,`unknown3`,`unknown4`,`unknown5`,`unknown6`,`unknown7`,`unknown8`,`unkn own9`,`unknown10`,`unknown11`,`unknown12`,`unknown13`,`unknown14`)

replace the second set of words with the info.

and then it is in sql format.

[Mitron]

okay but how i convert the file i saved to .SQL file ??

[y2kss66]

right click on the file.

select "rename"

and type "WHATEVER_YOU_CALL_IT.sql"

and it will say something like renaming the may cause it to become unusable click ok

and presto-chango you have a new sql file!

[Mitron]

ok thx y2 ^^ gimme a link i can +rep u on

[y2kss66]

here ya go:

http://www.mmowned.com/forums/emulat...c-website.html