ArcEmu: Scale Saved To Db - 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

Scale Saved To Db

#1 User is offline   jackpoz 

  • ArcEmu Lemon Priest
  • PipPipPipPipPipPipPipPip
  • Group: Developers
  • Posts: 2,153
  • Joined: 19-June 08
  • Gender:Male
  • Location:Italy
  • Server OS:Windows

Posted 29 March 2010 - 07:11 AM

This patch saves Characters' scale to Character Database. Remember to apply the required db update.
Index: sql/character_updates/32xx_scale.sql
===================================================================
--- sql/character_updates/32xx_scale.sql (revision 0)
+++ sql/character_updates/32xx_scale.sql (revision 0)
@@ -0,0 +1 @@
+ALTER TABLE `characters` ADD COLUMN `scale` FLOAT UNSIGNED DEFAULT '1.0' NOT NULL AFTER `data`;
\ No newline at end of file
Index: src/arcemu-world/Player.cpp
===================================================================
--- src/arcemu-world/Player.cpp (revision 3236)
+++ src/arcemu-world/Player.cpp (working copy)
@@ -2707,6 +2707,7 @@
    ss << uint32(m_uint32Values[ offset ]) << ";";
  }

+ ss << "', '" << GetScale();
  ss << "')";

  if(bNewCharacter)
@@ -2867,7 +2868,7 @@
   return;
  }

- const uint32 fieldcount = 93;
+ const uint32 fieldcount = 94;

  if( result->GetFieldCount() != fieldcount )
  {
@@ -3534,6 +3535,9 @@
  else
   m_XpGain = true;

+ get_next_field.GetString();
+ SetScale(get_next_field.GetFloat());
+
  HonorHandler::RecalculateHonorFields(this);

  for(uint32 x= 0;x<5;x++)

darkechibi said he would pay for this, i wanna be paid with true love.

Attached File(s)


Posted Image We develop dreams. Your dreams ;)
Posted ImagePosted Image
1

#2 User is offline   Darkechibi 

  • Newbie
  • Group: Members
  • Posts: 3
  • Joined: 06-March 10
  • Gender:Female

Posted 30 March 2010 - 12:38 PM

Well I'll be, Thank you, I mean it really. I will let you know if I can get it to work asap. If all you need is love then you got it. sorry I realize I can be a pain, but I am appreciative of the works everyone here does, and ashamed that I can do so little. Really thank you.

DC

I changed the characters scale in the mysql, worked great. Good work and again thanks!

DC

This post has been edited by Darkechibi: 30 March 2010 - 02:01 PM

0

#3 User is offline   Laerg619 

  • Member
  • Pip
  • Group: Members
  • Posts: 50
  • Joined: 08-June 08
  • Location:California, USA

Posted 25 May 2010 - 02:29 PM

Ohh, this is awesome! I had been fiddling with code to try and make something like this work, but I'm a n00b when it comes to new command functionality.

Thank you!
0

#4 User is offline   Laerg619 

  • Member
  • Pip
  • Group: Members
  • Posts: 50
  • Joined: 08-June 08
  • Location:California, USA

Posted 25 May 2010 - 03:37 PM

Sorry for the double-post, but there does seem to be a downside to this.

I presume this was made with the intent of retaining the .mod scale value. However, anytime someone uses a size-changing spell (like a potion, such as Elixir of Giant's Growth) and logs out, their altered scale will be saved. Logging back in will re-apply the buff to that saved value, making them even bigger. This could be repeated indefinitely, and once the buff is clicked off or expired, the scale only 'goes back' by the most recent scale mod, if that makes sense.

Is there a way to alter this code so it's similar to the .mod faction command? Where the value is saved only when .mod scale is used?

Edit: And wow, I just realized the date on this thread. I'm even more of a n00b than I thought!
0

#5 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 25 May 2010 - 04:52 PM

Quote

Edit: And wow, I just realized the date on this thread. I'm even more of a n00b than I thought!



Well, imo means no one noticed that issue you mentioned yet, so idk about the n00b part <_<
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#6 User is offline   jackpoz 

  • ArcEmu Lemon Priest
  • PipPipPipPipPipPipPipPip
  • Group: Developers
  • Posts: 2,153
  • Joined: 19-June 08
  • Gender:Male
  • Location:Italy
  • Server OS:Windows

Posted 26 May 2010 - 07:38 AM

View PostLaerg619, on 25 May 2010 - 03:37 PM, said:

However, anytime someone uses a size-changing spell (like a potion, such as Elixir of Giant's Growth) and logs out, their altered scale will be saved.


this is one of the main reasons i didn't commit it to the svn (and i'll never do it).
Posted Image We develop dreams. Your dreams ;)
Posted ImagePosted Image
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