Trad

06:25.48 ( +Ch40sC0d3 ) anyone here know how to make sql patches for mangos?
06:25.56 ( +Valkirie ) umm
06:25.57 ( +Valkirie ) no ^^
06:26.10 ( +Ch40sC0d3 )
06:29.27 ( +valvet ) What do mean, SQL patches? Patch like you would source files? In that case use some .diff application rather than the SVN client.
06:30.07 ( +Ch40sC0d3 ) i ment how would i make a sql file that adds a mob
06:30.20 ( +Ch40sC0d3 ) im working on a convert for wowemu db files
06:30.27 ( +Valkirie ) INSERT INTO `playercreateinfo_spell` VALUES (52, 203, 0, '');
06:30.31 ( +Ch40sC0d3 ) i got wowemu down, i know crap about sql
06:30.33 ( +Valkirie ) Oups
06:30.34 ( +Valkirie ) INSERT INTO `playercreateinfo_spell` VALUES (52, 203, 0, '');
06:30.36 ( +Valkirie ) DAMN
06:30.39 ( +Ch40sC0d3 )
06:30.53 ( +Ch40sC0d3 ) i just posted the file if u wanna see it
06:31.07 ( +Ch40sC0d3 ) http://sdb.unix7.net/forums/index.php?showtopic=799
06:31.18 ( +Valkirie ) INSERT INTO `creature` VALUES ('1', '1563', '0', '-15019', '265.174', '7.52', '4.851', '1200', '1500', '0', '0', '-15019', '265.174', '7.52', '4.851', '2739', '1253', '0', '0', '0', '87', null);
06:31.32 ( +Valkirie ) `guid` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
06:31.33 ( +Valkirie ) `id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
06:31.33 ( +Valkirie ) `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
06:31.33 ( +Valkirie ) `position_x` float NOT NULL default '0',
06:31.33 ( +Valkirie ) `position_y` float NOT NULL default '0',
06:31.33 ( +Valkirie ) `position_z` float NOT NULL default '0',
06:31.33 ( +Valkirie ) `orientation` float NOT NULL default '0',
06:31.33 ( +Valkirie ) `spawntimemin` int(11) unsigned NOT NULL default '10',
06:31.33 ( +Valkirie ) `spawntimemax` int(11) unsigned NOT NULL default '10',
06:31.33 ( +Valkirie ) `spawndist` float NOT NULL default '5',
06:31.34 ( +Valkirie ) `currentwaypoint` int(11) unsigned NOT NULL default '0',
06:31.35 ( +Valkirie ) `spawn_position_x` float NOT NULL default '0',
06:31.36 ( +Valkirie ) `spawn_position_y` float NOT NULL default '0',
06:31.37 ( +Valkirie ) `spawn_position_z` float NOT NULL default '0',
06:31.38 ( +Valkirie ) `spawn_orientation` float NOT NULL default '0',
06:31.39 ( +Valkirie ) `curhealth` int(11) unsigned NOT NULL default '1',
06:31.41 ( +Valkirie ) `curmana` int(11) unsigned NOT NULL default '0',
06:31.42 ( +Valkirie ) `respawntimer` int(11) unsigned NOT NULL default '0',
06:31.43 ( +Valkirie ) `state` int(11) unsigned NOT NULL default '0',
06:31.44 ( +Valkirie ) `npcflags` int(11) unsigned NOT NULL default '0',
06:31.45 ( +Valkirie ) `faction` int(11) unsigned NOT NULL default '0',
06:31.46 ( +Valkirie ) `auras` longtext,
06:31.47 ( +Valkirie ) count the table
06:31.49 ( +Valkirie ) and identify what is what
06:31.54 ( +Valkirie ) then for exemple
06:31.58 ( +Ch40sC0d3 ) well this is just to convert to the creature_template right now
06:32.05 ( +Ch40sC0d3 ) then i have to convert the world save
06:32.09 ( +Ch40sC0d3 ) and add mobs
06:32.13 ( +Valkirie ) Oo
06:32.14 ( +Valkirie ) >>
06:32.17 ( +Valkirie ) ><*
06:32.22 ( +Valkirie ) without me lol
06:32.26 ( +Ch40sC0d3 ) this is for like AQ
06:32.32 ( +Valkirie ) my knowledge are not suffisent
06:32.33 ( +valvet ) Well.. there are various tables you'll need to add into. If you want the creature to be involved in quests for example. But first step would be to read up a bit on how SQL actually workes I guess. Then get some GUI application so you can see (in a graphical representation) what fields the tables contains and which information you need for said monster.
06:32.35 ( +Ch40sC0d3 ) converting the wowemu AQ db to mangos
06:32.41 ( +valvet ) Like above, positions, id, guid and so forth..
06:32.58 ( +Ch40sC0d3 ) valvet i made one
06:33.12 ( +Ch40sC0d3 ) like i said im writing a converter and it has a gui
06:33.19 ( +Ch40sC0d3 ) i just dont know how to make the sql files
06:33.25 ( +Ch40sC0d3 ) after i extract the info
06:33.44 ( +valvet ) Oh, so you just need the format/structure of the SQL to "import"?
06:33.50 ( +Ch40sC0d3 ) yes
06:34.13 ( +Ch40sC0d3 ) check that program i posted
06:34.20 ( +Ch40sC0d3 ) and load that file the other guy posted
06:34.24 ( +Ch40sC0d3 ) and u will see what im trying to do
06:34.27 ( +valvet ) I believe the WIKI has it's structure.. but I'm not sure if it's been updated lately. You could just download SDB and extract the "creature" table, that's how you would want to output your data aswell.
06:34.44 ( +Ch40sC0d3 ) well i ment for the raw format
06:34.56 ( +Ch40sC0d3 ) INSERT INTO `creature` VALUES
06:34.58 ( +Ch40sC0d3 ) like that
06:35.05 ( +Ch40sC0d3 ) the output file i need to make
06:35.21 ( +Ch40sC0d3 ) so it will add the values
06:36.14 ( +valvet ) Hold
06:38.37 ( +valvet ) Well.. first of all. I don't see any position information in the SCP file.
06:39.53 ( +valvet ) How do you intend to get these values?
06:40.36 .•• Haza ( Haza@h4x-2E38D5D2.tpgi.com.au ) joined #wow
06:40.37 .•• CrapMan sets #wow mode +ao Haza Haza
06:46.11 .•• Bot ( Bot@h4x-2E38D5D2.tpgi.com.au ) joined #wow
06:46.19 .•• __mad sets #wow mode +v Bot
06:46.26 .•• Haza sets #wow mode +o Bot
06:46.27 .•• CrapMan sets #wow mode -o Bot
06:46.37 ( +Ch40sC0d3 ) valvet the program loads and phases the info into a grid
06:46.59 ( +Ch40sC0d3 ) i need to take the info and add them to the creature_template
06:47.12 .•• Haza sets #wow mode +h Bot
06:48.17 ( +Ch40sC0d3 ) so i would like to output it to a sql file that will do that
06:49.33 .•• Peto ( Peto@h4x-978410B5.chello.sk ) joined #wow
06:49.33 .•• Bot sets #wow mode +v Peto
06:50.00 ( @__mad ) Ch40sC0d3 ppl mostly do it with php
06:50.54 ( +valvet ) Oh, right. Thought you were talking about the 'creature' table.. that's actually spawned creatures. Well.. Mangos needs a bit more data than the SCP files contains, but you might be able to pull it off. Take a look at the mySQL manual for "INSERT INTO" - http://dev.mysql.com/doc/refman/5.0/en/insert.html.
06:51.14 ( +valvet ) Just do a SVN checkout on Mangos, you'll find the structure for the table in the /sql folder inside Mangos.sql.
06:52.26 ( +Valkirie ) WTF !
06:52.30 ( +Valkirie ) Archimonde look so good !
06:55.47 ( +Ch40sC0d3 ) valvet thanks ill check
06:55.53 ( +Ch40sC0d3 ) see i have a world save also
06:56.01 ( +Ch40sC0d3 ) with more info like xyz mapid
06:56.03 ( +Ch40sC0d3 ) and so on
06:56.12 ( +Ch40sC0d3 ) but i have to do this part first
06:56.22 ( +Ch40sC0d3 ) other wise there is no creatureid to ref to
06:57.45 .•• Peto ( Peto@h4x-978410B5.chello.sk ) has quit IRC ( Quit: )
06:58.07 ( +Ch40sC0d3 ) wtf
06:58.14 ( +Ch40sC0d3 ) on wowstats it shows the wrong address