a few scripts for WEBSITES

**SupernovaHH** · 07-16-2009

ok so i have been searching around (not sure if i typed the right thing in exactly) on google and mmowned looking for a few scripts. heres the list of them i need if you can help me out it would be greatly appreciated (im using arcemu by the way)

GM Ticket script (Shows gm tickets on website with the name, time stamp and then the message)

Teleporter script (Allows players to teleport their character to areas of their faction *alliance > stormwind--Horde > Orgrimmar*)

Ban checker script (checks to see if your account is banned and how long it is banned for)

User control panel script (for voting and donating)

I have the ban and teleport scripts but they dont work and i dont know why. my log-in script works but i have to set up the control panel for it. unless you can fix the scripts below

Teleporter script

Code:

<?php
require_once "_config.php";
echo "<html><head>";
 
echo "</head><body>";
echo "<center><table>";
echo "<tr><td colspan=2 align=center><img src='../images/char_tra.jpg' alter=wow></td></tr>";
echo "<link href='style.css' type='text/css' rel='stylesheet'>"; 
if(isset($_POST['submit']))
{
	$character = $_POST['char'];
    $account = $_POST['account'];
	$location = $_POST['location'];
    mysql_select_db($chardb);
	$acct = "";							//acct id from db
	$race = "";							//characters race id
    $level = "";                        //Character Level
        
	//max players per account...is it 8? Change to whatever it is...
        $MAX_PLAYERS = 8;
 
        $con = mysql_connect($aHost.":".$aPort, $aUsername, $aPass) or die(mysql_error());
        mysql_select_db($aDatabase) or die(mysql_error());
	
	$account = mysql_real_escape_string($account);
	$password = mysql_real_escape_string($password);
	$character = mysql_real_escape_string($character);
	$location = mysql_real_escape_string($location);

	$query = "SELECT race, level, gold FROM characters WHERE  guid = '".$guid."'";

	$result = mysql_query($query);
	$numrows = mysql_num_rows($result);

	if ($numrows == 0)
	{
		die("<center>That character does not exist on that account!</center>");
	}

	$row = mysql_fetch_array($result);
	$race = $row[0];
    $level = $row[1];

	if($row[2] < (5 * 10000))
	{
		die("<center>Your character does not have enough gold to be teleported</center>");
	}
	$gold = $row[2];

	$map = "";
	$x = "";
	$y = "";
	$z = "";
	$place = "";

	switch($location)
	{
		//stormwind
		case 1:
			$map = "0";
			$x = "-8913.23";
			$y = "554.633";
			$z = "93.7944";
			$place = "Stormwind City";
			break;
		//ironforge
		case 2:
			$map = "0";
			$x = "-4981.25";
			$y = "-881.542";
			$z = "501.66";
			$place = "Ironforge";
			break;
		//darnassus
		case 3:
			$map = "1";
			$x = "9951.52";
			$y = "2280.32";
			$z = "1341.39";
			$place = "Darnassus";
			break;
		//exodar
		case 4:
			$map = "530";
			$x = "-3987.29";
			$y = "-11846.6";
			$z = "-2.01903";
			$place = "The Exodar";
			break;
		//orgrimmar
		case 5:
			$map = "1";
			$x = "1676.21";
			$y = "-4315.29";
			$z = "61.5293";
			$place = "Orgrimmar";
			break;
		//thunderbluff
		case 6:
			$map = "1";
			$x = "-1196.22";
			$y = "29.0941";
			$z = "176.949";
			$place = "Thunder Bluff";
			break;
		//undercity
		case 7:
			$map = "0";
			$x = "1586.48";
			$y = "239.562";
			$z = "-52.149";
			$place = "The Undercity";
			break;
		//silvermoon
		case 8:
			$map = "530";
			$x = "9473.03";
			$y = "-7279.67";
			$z = "14.2285";
			$place = "Silvermoon City";
			break;
		//shattrath
		case 9:
			$map = "530";
			$x = "-1863.03";
			$y = "4998.05";
			$z = "-21.1847";
			$place = "Shattrath";
			break;
		//for unknowness -> shattrath
		default:
			die("<center>That is an invalid location!</center>");
			break;
	}

	//disallows factions to use enemy portals
	switch($race)
	{
		//alliance
		case 1:
		case 3:
		case 4:
		case 7:
		case 11:
			if((($location >=5) && ($location <=8)) && ($location != 9))
			{
				die("<center>Alliance players can not teleport to horde areas!<br><br></center>");
			}
			break;
		//horde
		case 2:
		case 5:
		case 6:
		case 8:
		case 10:
			if ((($location >=1) && ($location <=4)) && ($location != 9))
			{
				die("<center>Horde players can not teleport to alliance areas!<br><br></center>");
			}
			break;
		default:
			die("<center>That is not a valid race!<br><br></center>");
			break;
	}

    if($level < 58 && $location == 9)
    {
    	die("<center>Require at least lvl 58!</center>");
    }

	$newGold = $gold - (5 * 10000);

	$query = "UPDATE characters SET positionX = ".$x.", positionY = ".$y.", positionZ = ".$z.", mapid = ".$map.", gold = ".$newGold." WHERE guid = '".$guid."'";
	$result = mysql_query($query) or die(mysql_error());
	echo "<center>After paying off 5g, with sad look on your face,<br></center>";
	echo "<center>you are entering goblin transpoder machine...<br><br></center>";
	echo "<center>Your character has been teleported to ".$place.",<br></center>";
	echo "<center>and now has ".($newGold / 10000)." gold left.</center>";

	echo "</td></tr>";

	mysql_close();	//kill connection to characters db
}
else
{
    
	echo "<form name='myform' method='post' action='tool.php?teleporter'>";
    echo "<center><br><span style='font-size: 18px; font-family:Century Gothic, Arial, Helvetica; color:#ffffff'>$lan[TELEPORTER]</span><br><br>";
	//***START DROPDOWN****(c)axe
	$user=$_SESSION['user'];
    $getuser="SELECT * from b_users a, b_templates b where b.templateid=a.templateclass and a.username='$user'";
    $getuser2=mysql_query($getuser) or die("Could not get user info");
    $getuser3=mysql_fetch_array($getuser2);
    mysql_select_db($chardb);
	$SQLwow ="SELECT * from accounts where login='$getuser3[username]'";
	$SQLwow2=mysql_query($SQLwow) or die("Could not get user char info".mysql_error());
	$SQLwow3=mysql_fetch_array($SQLwow2);
	$SQLawow ="SELECT * from characters where acct='$SQLwow3[acct]'";
	$char=mysql_query($SQLawow) or die("Could not get user char info");
	mysql_select_db($commondb);
	print "<table width='400px' border='0' cellspacing='0' cellpadding='0'><tr><td>";
	print "Teleport <select name='char' style=' background-color:#000033; color:#FFFFFF; border: 1px solid #333333'>";
	while ($char2=mysql_fetch_array($char))
		     {
			 if ($char2[guid]==$getuser3[charid]) {
			        print "<option selected='selected' value='$char2[guid]'>-> $char2[name]</option>";
		   } else  {
			        print "<option value='$char2[guid]'>$char2[name]</option>";
			       }
			 }
		  print "</select>";
		  print "</td><td>";
	
    //******END DROPDOWN********
	echo "<center>&nbsp;to ";
	echo "<select name=location style=' background-color:#000033; color:#FFFFFF; border: 1px solid #333333'>";
	echo "<option value='1'>Stormwind</option>";
	echo "<option value='2'>Ironforge</option>";
	echo "<option value='3'>Darnassus</option>";
	echo "<option value='4'>Exodar</option>";
	echo "<option value='---------'>------------------</option>";
	echo "<option value='5'>Orgrimmar</option>";
	echo "<option value='6'>Thunder Bluff</option>";
	echo "<option value='7'>Undercity</option>";
	echo "<option value='8'>Silvermoon</option>";
	echo "<option value='---------'>------------------</option>";
	echo "<option value='9'>Shattrath</option>";
	echo "</select></td></tr></table><br>";
	echo "(Warning: Cost is 5g for 1 teleport)<br><br>";

	echo "<input type=submit name=submit value=Teleport style='background-color:#000033; color:#FFFFFF; border: 1px solid #333333'><br><br>";
	
	echo "</form>";
	echo "You must be logged out of game so this can work.<br />";
}
?>

Ban checker

Code:

<?php
//if unstuck button is pressed, verify and query db if valid
if(isset($_POST['submit']))
{   $guid = $_POST['char'];
    $account = $_POST['username'];
    mysql_select_db($chardb);
	
	//get banned data
	$query = "select name,banned from characters where guid='$guid'";
	$ban=mysql_query($query) or die(mysql_error());
	$ban2=mysql_fetch_array($ban);
	if ($ban2[1]=="0") {$bann="<span style='color:lime'>Your character $ban2[0] is not banned.</span>";} 
	else {$bann="<span style='color:red'>Your character $ban2[0] is BANNED.</span>";}

   
	echo "<center><br><span style='font-size: 18px; font-family:Century Gothic, Arial, Helvetica; color:#ffffff' >$lan[BAN_CHECK]</span><br><br>$bann<br><br><a href='tool.php?bancheck'>Go Back</a><br><br></center>";

	//close mysql connection
	mysql_close();
}
//if page is loaded, display unstuck form
else
{
    echo "<form name='unstucker' method='post' action='tool.php?bancheck'>";
    echo "<center><br><span style='font-size: 18px; font-family:Century Gothic, Arial, Helvetica; color:#ffffff' >$lan[BAN_CHECK]</span><br><br>";
    
    
    //***START DROPDOWN****(c)axe
	$user=$_SESSION['user'];
    $getuser="SELECT * from b_users a, b_templates b where b.templateid=a.templateclass and a.username='$user'";
    $getuser2=mysql_query($getuser) or die("Could not get user info");
    $getuser3=mysql_fetch_array($getuser2);
    mysql_select_db($chardb);
	$SQLwow ="SELECT * from accounts where login='$getuser3[username]'";
	$SQLwow2=mysql_query($SQLwow) or die("Could not get user char info".mysql_error());
	$SQLwow3=mysql_fetch_array($SQLwow2);
	$SQLawow ="SELECT * from characters where acct='$SQLwow3[acct]'";
	$char=mysql_query($SQLawow) or die("Could not get user char info");
	mysql_select_db($commondb);
	
	print "<select name='char' style=' background-color:#000033; color:#FFFFFF; border: 1px solid #333333'>";
	while ($char2=mysql_fetch_array($char))
		     {
			 if ($char2[guid]==$getuser3[charid]) {
			        print "<option selected='selected' value='$char2[guid]'>-> $char2[name]</option><br>";
		   } else  {
			        print "<option value='$char2[guid]'>$char2[name]</option><br>";
			       }
			 }
		  print "</select><br><br>";
    //******END DROPDOWN********
	echo "<input name='username' type='hidden' value='$user' />";
	echo "<br><input type=submit name=submit value='Check if character is banned or not' style='background-color:#000033; color:#FFFFFF; border: 1px solid #333333'><br>";
	echo "</form><br><br>";
	echo "</center>";
}

//original script by bella, if thats real, modifyed by AXE

?>

and the _config.php (which doesnt go with these but i'd like to make them work with it if possible)

Code:

<?php

//account database info
$aHost = "localhost";
$aDatabase = "logon";
$aPort = "3306";
$aUsername = "root";
$aPass = "ascent";

//character database info
$cHost = "localhost";
$cDatabase = "logon";
$cPort = "3306";
$cUsername = "root";
$cPass = "ascent";

?>

I'm requesting these for my website wow-knights.25u.com so if you can help me i will +rep you.

**dirtaa** · 07-17-2009

i will edit my post when i find the links to the other stuff.
vote system : http://www.mmowned.com/forums/emulat...rd-system.html
edit: i never asked lol but what errors are u getting on thoes scripts

**SupernovaHH** · 07-17-2009

on the 2 i need im getting the Could not get user info error (ty for the vote script it works good

)

**dirtaa** · 07-17-2009

can i get the link to the 2 that didnt work i want to try it on my test server and see if i can help out some more

**SupernovaHH** · 07-17-2009

the link? you mean from my site? wow-knights.25u.com/images/temp/tools/teleporter.php

and wow-knights.25u.com/images/temp/tools/bancheck.php

if you mean the files themselves they are in the first post

**dirtaa** · 07-17-2009

the place where u downloaded it

**SupernovaHH** · 07-17-2009

i didnt download it from anywhere. my brother had them in a folder and sent them to me, he cant remember where he got them though (they didnt come with the config files)

Shout-Out

User Tag List

Thread: a few scripts for WEBSITES

Thread Tools

Search Thread

a few scripts for WEBSITES

Similar Threads

Where i can find a website script for sell gold??

[Question] Website Script for remote DB access?

[HELP] A few scripts for FreeBSD

[Me Need] Arthas Model + Scripts for a few bosses

A Few Places for Gold Farming

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino