Accounter updater (updates expansion flags for users.)

**luc1f3rspalm** · 11-30-2008

Allows users to upgrade/downgrade their accounts to and from any expansion (original wow, bc, wotlk)

Example Here

Wrote it because i needed it, but figured others could use it too.

All work by me, feel free to change anything.

Upgrade.php

Code:

<head>
    <title>Upgrade Account</title>
    <meta http-equiv="Pragma" content="no-cache"/>
    <meta http-equiv="Cache-Control" content="no-cache"/>
    <style type="text/css" media="screen">
    @import url(stats/secondary_stats.css);.style1 {
	font-size: 24px;
	font-weight: bold;
	font-style: italic;
}
    </style>
    <!--[if lt IE 7.]>
    <script defer type="text/javascript" src="stats/pngfix.js"></script>
    <![endif]-->
</head>
<body>
    <center>
    <div class="logo"></div>
    <div style="width:300px">
        <form action="<?php echo $_SERVER[upgrade.php]; ?>" method="POST">
        <table width="100%" border="0" cellspacing="1" cellpadding="3">
            <tr class="head"><th colspan="2"><div class="heading"><span class="style1">Upgrade Account</span><br>
              <br></div>
            <br><br></th></tr>
            <tr>
                <th>Username: </th><td align="center"><input type="text" name="login" size="30" maxlength="16"/></td>
            </tr>
            <tr>
                <th>Password: </th><td align="center"><input type="password" name="password" size="30" maxlength="16"/></td>
            </tr>
           
<th>Account Type:</th><td align="center">
  <p>&nbsp;  </p>
  <p>
    <select name="set" type="select">
      <option value="0">Normal WoW</option>
      <option value="8">Burning Crusade</option>
      <option value="40" selected>Wrath of the Lich King</option>
    </select>
    <br>
    <br>
    <input type="reset" name="reset" value="Reset"/>
    <input type="submit" name="Update" value="Update" id="Update"/>
  </p></td>

        </table>
        
        </form>

		<?php
		include('config.php');
		$query = @mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
		mysql_query($query);
		mysql_select_db($db) or die (mysql_error());
        $login=$_POST['login'];
        $password=$_POST['password'];
        $set=$_POST['set'];
		$loginlen=strlen($login);
        $passwordlen=strlen($password);
        $query = "SELECT acct FROM accounts WHERE login = '".$login."' AND password = '".$password."'";
		$result = mysql_query($query) or die(mysql_error());
		$numrows = mysql_num_rows($result);
		if($loginlen < 1 or $passwordlen < 1)
						{
			  	        echo "Please fill in the fields";
				        }
	
	else{
		if($numrows == 1)
	{
			$query = "UPDATE accounts SET flags = '".$set."' WHERE login = '".$login."'";
	$result = mysql_query($query) or die(mysql_error());

	echo "".$login."'s Account successfully Updated!";
	} else {

     die("Invalid account name/password!");

	};		        
	};
		  
		   						        
?>

    </div>
    <div class="footer">
    </div>
    </center>
</body>
</html>

Config.php

Code:

<?php
$db="logon";
$dbuser="logon";
$dbpass="password";
$dbhost="127.0.0.1";
?>

Let me know if you have any questions or issues.

(I wrote this for arcemu so it should be compatible with both ascent and arc, as far as mangos i don't know.)

**Blackboy0** · 11-30-2008

Good job mate

+Rep from me!!

**~~R 3 A L 1 T Y~~** · 11-30-2008

Good job. Just what we needet.

+rep

**stoneharry** · 11-30-2008

Change the colour of the font you put on the script. Can barely make it out

**luc1f3rspalm** · 11-30-2008

Thanks, also any mod able to change my thread name, it's 430am and i managed to type accounter instead of account.

**luc1f3rspalm** · 11-30-2008

Originally Posted by stoneharry

Change the colour of the font you put on the script. Can barely make it out

do you mean the actual code on this page?, or the color the echo's print out the text in?

**Blackboy0** · 11-30-2008

I'm guessing on this page lol :P Very hard to see that blue...

**stoneharry** · 11-30-2008

I ment on the script and page for example:
<![endif]-->
I can barely see that, and the black was terrible to. To dark :P
or:
Password:
See what I mean?

Also put in a background and I'll probably use it :P Simple, and working. +Rep x2

**luc1f3rspalm** · 11-30-2008

Originally Posted by stoneharry

I ment on the script and page for example:
<![endif]-->
I can barely see that, and the black was terrible to. To dark :P
or:
Password:
See what I mean?

Changed it, should be a little better now.

Also if anyone is getting an error about a config3 missing from one of the includes it's because i forgot to remove that part (it was added so it wouldn't break any other includes on my website, and i forgot to remove it when i posted here, I went ahead and removed it though so no one should have to worry about it now.)

**y2kss66** · 11-30-2008

very nice +Rep

**bsod-staff14** · 11-30-2008

Looks an awful bit like the post from arcemu.org but w/e +Rep!

**Jrgamespot** · 11-30-2008

Good job. +2rep from me.

**Edude** · 11-30-2008

+Rep from me, nice contribution :P

**kyle102092** · 11-30-2008

Thanks

+Rep

**luc1f3rspalm** · 12-01-2008

Quick update, I've found that some emus use 40 and others use 32, so if you need to have it set to either or just change the value for the wotlk one and you should be fine. (I have left the script at 40.)

also a quick query that people could run if they want to update all accounts from one flag to another would be

UPDATE logon.accounts SET flags = '32' WHERE flags = '40';

thank you to those who rep'd

Any suggestions for features to be added would be great as well.

Shout-Out

User Tag List

Thread: Accounter updater (updates expansion flags for users.)

Thread Tools

Search Thread

Accounter updater (updates expansion flags for users.)

Similar Threads

[UPDATED] GM - Commands for Ascent Private Server

[Updated] JOANAS GUIDE for patch v.2.3

Updated Addons List for latest patch!

hacked account update

Warden Update - Glider offline for now...

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino