ArcEmu: Revive And Hearth Function - 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

Revive And Hearth Function

#1 User is offline   Imacellist2 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 25-June 10
  • Gender:Male

Posted 06 August 2010 - 11:06 PM

I am trying to figure out how to make a revive and hearth button for my website. I am looking for someone that would at least help point me in the right direction. I understand what needs to happen in regards to the database, but I am unsure of how to code this in a php or something. Any help would be much appreciated. I saw this on epicwow.org a long time ago when I was on their server and it really helps when you are stuck and no gms are online. If I get help I will gladly post the final project here for everyone. Thanks in advance!
0

#2 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 07 August 2010 - 03:01 PM

Just make a php script that runs this query when requested (It'll bring the user to where he is hearthed and bring him alive, only if he is offline):

Quote

UPDATE characters SET positionX = bindpositionX, positionY = bindpositionY, positionZ = bindpositionZ, mapId = bindmapId, zoneId = bindzoneId, deathstate = '0' WHERE guid = '<ID OF CHARACTER HERE>' AND online = '0' LIMIT 1


One last thing - don't post for help in the goddamn release section. It's for releases only.
0

#3 User is offline   Navid 

  • Persian Prance of ArcEmu
  • Group: Super Moderator
  • Posts: 718
  • Joined: 30-June 09
  • IRC:Lurker-
  • Gender:Male
  • Location:Iran
  • Interests:PHP,C++,ArcEmu and exactly our lovely community and specially money xD
  • Server OS:Windows

Posted 07 August 2010 - 03:29 PM

---Topic Moved to the right Section.
I'm here to check,lurk and kill you so behave or you will be lurked

Posted Image
0

#4 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 07 August 2010 - 05:26 PM

This isn't tested, and I made this right here in the reply to topic box... soo it might be bugged. Anyways, good luck.

<?php
// This tool was made by Robert Herman (maverfax@gmail.com)

/**************************** CONFIGS ****************************/

$hostname = '127.0.0.1';
$username = 'root';
$password = 'root';
$database = 'characters';

/************************ END OF CONFIGS ************************/

mysql_connect($hostname, $username, $password) or die('Could not connect to server');
mysql_select_db($database) or die('Could not select DB');

$color  = 'red';
$error  = 'Please make sure you are logged off your character, ';
$error .= 'or else this will have no effect';

if(isset($_POST['reset']))
{
  if(is_numeric($_POST['char_id']))
  {
    $color = 'green';
    $error = 'Your character has  been reset successfully';
    $char_id = mysql_real_escape_string($_POST['char_id']);

    $q  = "UPDATE characters SET positionX = bindpositionX, positionY = bindpositionY, positionZ = bindpositionZ, mapId = bindmapId, zoneId = bindzoneId, deathstate = '0' ";
    $q .= "WHERE guid = '$char_id' AND online = '0' LIMIT 1";

    mysql_query($q);
  }

  else $error = 'You must submit a correct character';
}

function characters($acc_id)
{
  $return = array();
  $q = mysql_query("SELECT guid AS id, name FROM characters WHERE acct = '$acc_id'");

  if(mysql_num_rows($q) > 0)
  {
    while($row = mysql_fetch_assoc($q))
    {
      $return[] = $row;
    }
  }

  return $return;
}
?>

<h1>Character Reset</h1>
<hr>

<b style="color:<?php echo $color; ?>;"><?php echo $error; ?></b>

<form method="post" action="reset.php">
  <select name="character">
  <?php foreach(characters() as $c): ?>
    <option value="<?php echo $c['id']; ?>"><?php echo $c['name']; ?></option>
  <?php endforeach; ?>
  </select>
  <input type="submit" name="reset" value="Reset Character">
</form>

0

#5 User is offline   Imacellist2 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 25-June 10
  • Gender:Male

Posted 09 August 2010 - 04:05 PM

Thanks for the replys, and I am sorry for posting in the release section, that was an accident. I have just spent so much time in there lately I didn't even think, so sorry for that. I'll let you know if this stuff is working, and thanks you guys for the help.
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