ArcEmu: More SQL Updates by me :) - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

More SQL Updates by me :)

#1 User is offline   Shauren 

  • Helper
  • Group: Contributor
  • Posts: 808
  • Joined: 04-November 08
  • Gender:Male
  • Location:Poland
  • Interests:hmm, wow?

Posted 10 March 2009 - 03:03 PM

What bug does this patch fix: Fixes structure of event SQLs (currently only Winter Veil, Noblegarden and Harvest Festival)
Detailed Explanation: Tables in database have had their structure changed and event SQLs got outdated.
How to reproduce: Try applying event SQLs before my patch

Patch:

Sorry, no content in [diff ] because its too big :)
And this is also why its zipped.

[attachment=1306:SQLs_update.zip]
0

#2 User is offline   Magissia 

  • Member
  • Pip
  • Group: Members
  • Posts: 13
  • Joined: 24-August 08

Posted 13 March 2009 - 08:44 PM

thanks !
0

#3 User is offline   SB@L 

  • ArcEmu lover
  • PipPipPipPip
  • Group: Developers
  • Posts: 616
  • Joined: 12-June 08
  • Gender:Male
  • Location:Slovakia

Posted 14 March 2009 - 03:36 AM

- Applied.
- Moved to applied patches.
SQL scripts: To remove pet spells from player
CRASH REPORTING TUTORIAL
TIP: If your core crashes on startup, its probably an outdated DB, apply recent sql updates.
0

#4 User is offline   panduit 

  • Member
  • Pip
  • Group: Members
  • Posts: 21
  • Joined: 24-September 08

Posted 14 March 2009 - 10:34 AM

View PostSB@L, on Mar 14 2009, 04:36 AM, said:

- Applied.
- Moved to applied patches.



You guys might wanna check this. It doesn't match the current structure.

At least not in gameobjects_names when trying to apply the NobleGarden Sql

Current structure only has the name column once.

The sql that is in the svn for this as of this morning is got name1 name2 name 3 columns in the gameobject_names structure. as follows ....

[Err] 1054 - Unknown column 'Name2' in 'field list'
[Err] /*
===============================
Event: Noblegarden
Author: Nexis
Updated by: Krzysiek
Event Date: Easter Sunday - 12:00am to 11:59pm
===============================
*/

/* Brightly Colored Egg */
INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, Name2, Name3, Name4, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(113768, 3, 1410, 'Brightly Colored Egg', '', '', '', '', '', '', 43, 4984, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------


Current structure is as follows

`gameobject_names` (
`entry` int(10) unsigned NOT NULL default '0',
`Type` int(10) unsigned NOT NULL default '0',
`DisplayID` int(10) unsigned NOT NULL default '0',
`Name` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
`spellfocus` int(10) unsigned NOT NULL default '0',
`sound1` int(10) unsigned NOT NULL default '0',
`sound2` int(10) unsigned NOT NULL default '0',
`sound3` int(10) unsigned NOT NULL default '0',
`sound4` int(10) unsigned NOT NULL default '0',
`sound5` int(10) unsigned NOT NULL default '0',
`sound6` int(10) unsigned NOT NULL default '0',
`sound7` int(10) unsigned NOT NULL default '0',
`sound8` int(10) unsigned NOT NULL default '0',
`sound9` int(10) unsigned NOT NULL default '0',
`unknown1` int(10) unsigned NOT NULL default '0',
`unknown2` int(10) unsigned NOT NULL default '0',
`unknown3` int(10) unsigned NOT NULL default '0',
`unknown4` int(10) unsigned NOT NULL default '0',
`unknown5` int(10) unsigned NOT NULL default '0',
`unknown6` int(10) unsigned NOT NULL default '0',
`unknown7` int(10) unsigned NOT NULL default '0',
`unknown8` int(10) unsigned NOT NULL default '0',
`unknown9` int(10) unsigned NOT NULL default '0',
`unknown10` int(10) unsigned NOT NULL default '0',
`unknown11` int(10) unsigned NOT NULL default '0',
`unknown12` int(10) unsigned NOT NULL default '0',
`unknown13` int(10) unsigned NOT NULL default '0',
`unknown14` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Gameobject System';
0

#5 User is offline   Shauren 

  • Helper
  • Group: Contributor
  • Posts: 808
  • Joined: 04-November 08
  • Gender:Male
  • Location:Poland
  • Interests:hmm, wow?

Posted 14 March 2009 - 12:15 PM

panduit you obviously didnt apply 2199_gosandquests.sql
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users