AVS Error menu

User Tag List

Thread: AVS Error

Results 1 to 1 of 1
  1. #1
    92eatos's Avatar Contributor
    Reputation
    104
    Join Date
    Aug 2009
    Posts
    220
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    AVS Error

    I spent over a 5 hours to find where is mistake for this vote system...
    It do every thing fine but when i press to spend vote points it says there is no realm, you dont have character and there is no rewards...But everything is setted right it worked before i instaled windows 7 and php 5.3.0
    So can any one try to update this script
    Code:
    <?php
    
    class Rewards
    {
    	function Title()
    	{
    		?>
            	Reward panel
    <?php
    	}
    
    	function GetRealmData()
    	{
    		//Get data to use in the form.
    		$Con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,true);
    		mysql_select_db(MYSQL_DB,$Con);
    		
    		$RealmInfo = "{";
    		//get each realm
    		$res = mysql_query("SELECT id,name,sqlhost,sqluser,sqlpass,chardb FROM realms",$Con);
    		echo mysql_error();
    		while($Row = mysql_fetch_array($res))
    		{
    			$RealmInfo .= $Row['id'].":{name:\"".$Row['name']."\"},";
    		}
    		if(strlen($RealmInfo) > 1)
    			$RealmInfo = substr($RealmInfo,0,strlen($RealmInfo)-1)."}";
    		else
    			$RealmInfo .='}';
    		mysql_close($Con);
    		return $RealmInfo;
    	}
    	
    	function GetCharData()
    	{
    		//get data that will be used to select the character.
    		$Con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,true);
    		mysql_select_db(MYSQL_DB,$Con);
    		
    		$CharInfo = "{";
    		$Index = 0;
    		$res = mysql_query("SELECT id,sqlhost,sqluser,sqlpass,chardb FROM realms");
    		while($Row = mysql_fetch_array($res))
    		{
    			$Con2 = mysql_connect($Row['sqlhost'],$Row['sqluser'],$Row['sqlpass'],true);
    			mysql_select_db($Row['chardb'],$Con2);
    			$res2 = mysql_query("SELECT guid,name FROM characters WHERE acct = '{$_SESSION['vcp']['id']}'",$Con2);
    			while($Row2 = mysql_fetch_array($res2))
    			{
    				$CharInfo .= $Index.":{guid:".$Row2['guid'].",realm:".$Row['id'].",name:\"".$Row2['name']."\"},";
    				$Index++;
    			}
    			mysql_close($Con2);
    		}
    		if(strlen($CharInfo) > 1)
    			$CharInfo = substr($CharInfo,0,strlen($CharInfo)-1)."}";
    		else
    			$CharInfo .='}';
    		mysql_close($Con);
    		return $CharInfo;
    	}
    	
    	function GetRewardData()
    	{
    		//rewards.. etc.
    		$Con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,true);
    		mysql_select_db(MYSQL_DB,$Con);
    		
    		$RewardInfo = "{";
    		
    		$res = mysql_query("SELECT id,realm,name,description,points,stack FROM voterewards");
    		while($Row = mysql_fetch_array($res))
    		{
    			$RewardInfo .= $Row['id'].":{realm:".$Row['realm'].",name:\"".$Row['name']."\",description:\"".$Row['description']."\",cost:".$Row['points'].",stack:".$Row['stack']."},";
    		}
    		if(strlen($RewardInfo) > 1)
    			$RewardInfo = substr($RewardInfo,0,strlen($RewardInfo)-1)."}";
    		else
    			$RewardInfo .='}';
    		$RewardInfo = str_replace("\r\n","<br />",$RewardInfo);
    		mysql_close($Con);
    		return $RewardInfo;
    	}
    
    	function Form()
    	{
    		?>
    			<table width="629" height="296" border="1" bordercolorlight="#FF0000" bordercolordark="#00FF00">
    <tr>
    					<td height="210" valign="top">
    		  <table cellspacing="2px">
    							<tr valign="top">                            </tr>
                                <div class="stijl1" style="margin-left:1px;"><h2>&bull; Select reward</h2></div>
    							<tr valign="top">
    								<td>You have:</td>
    								<td><span id="points"><?php echo $_SESSION['vcp']['points']; ?></span> rp</td>
    							</tr>
    							<tr valign="top">
    								<td width="75px">Realm:</td>
    								<td><select name="realm" id="realm" size="1" style="width:150px;" onchange="getCharacters(); getRewards();"><option value="0">There are no Realms found in the Database</option></select></td>
    							</tr>
    							<tr valign="top">
    								<td>Character:</td>
    								<td><select name="character" id="character" size="1" style="width:150px;"><option value="0">You dont have a character on this realm.</option></select></td>
    							</tr>
    							<tr valign="top">
    								<td>Reward:</td>
    								<td><select name="reward" size="1" id="reward" style="width:150px;" onchange="getInfo();"><option value="0">There are no rewards found in the Database</option></select></td>
    							</tr>
    							<tr valign="top">
    								<td>Cost:</td>
    								<td><span id="cost"></span> rp</td>
    							</tr>
    							<tr valign="top">
    								<td>Stack:</td>
    								<td><span id="stack"></span>x</td>
    							</tr>
    							<tr valign="top">
    								<td colspan="2" align="right"><input id="purchase" type="button" value="Purchase" onclick="onPurchase();" /></td>
    							</tr>
    						</table>
    					</td>
    					<td valign="top">
    						<div id="description" style="width:370px; height:280px; border:1px solid #000000; padding:2px">
    							&nbsp;<p>&nbsp;</p>
    							<address>
    &nbsp; </address>
    						</div>
    					</td>
    				</tr>
    			</table>
    <script type="text/javascript">
    				var Realm = document.getElementById("realm");
    				var Character = document.getElementById("character");
    				var Reward = document.getElementById("reward");
    				var Description = document.getElementById("description");
    				var Cost = document.getElementById("cost");
    				var Stack = document.getElementById("stack");
    				var Points = document.getElementById("points");
    				var Purchase = document.getElementById("purchase");
    				
    				var Realms = <?php echo $this->GetRealmData(); ?>;
    				var Characters = <?php echo $this->GetCharData(); ?>;
    				var Rewards = <?php echo $this->GetRewardData(); ?>;
    				
    				var PointCount = <?php echo $_SESSION['vcp']['points']; ?>;
    				
    				function getCharacters()
    				{
    					var i=0;
    					Character.options.length = 0;
    					for(var r in Characters)
    					{
    						if(Characters[r].realm == parseInt(Realm.value))
    						{
    							Character.options[i] = new Option(Characters[r].name,Characters[r].guid);
    							i++;
    						}
    					}
    				}
    				
    				function getRewards()
    				{
    					var i=0;
    					Reward.options.length = 0;
    					for(var r in Rewards)
    					{
    						if(Rewards[r].realm == parseInt(Realm.value))
    						{
    							Reward.options[i] = new Option(Rewards[r].name,r);
    							i++;
    						}
    					}
    					getInfo();
    				}
    				
    				function getInfo()
    				{
    					Description.innerHTML = Rewards[Reward.value].description;
    					Cost.innerHTML = Rewards[Reward.value].cost;
    					Stack.innerHTML = Rewards[Reward.value].stack;
    				}
    				
    				function onPurchase()
    				{
    					if(Character.options.length == 0)
    					{
    						alert("You don't have a character on that realm!");
    						return false;
    					}
    					if(Rewards[Reward.value].cost > PointCount)
    					{
    						alert("You don't have enough points for: \r"+Rewards[Reward.value].name+ "!");
    						return false;
    					}
    					if(!confirm("Are you sure you wish to spend\r\n"+Rewards[Reward.value].cost+" reward points for item: \r"+Rewards[Reward.value].name+ "?"))
    						return false;
    					Purchase.disabled = true;
    					
    					var R;
    					var Sub = Rewards[Reward.value].cost;
    					if(window.XMLHttpRequest)
    					{
    						R = new XMLHttpRequest();
    					}
    					else if(window.ActiveX)
    					{
    						R = new ActiveXObject("Microsoft.XMLHTTP");
    					}
    					R.onreadystatechange = function()
    					{
    						if(R.readyState == 4)
    						{
    							Purchase.disabled = false;
    							if(R.responseText != "1")
    							{
    								alert("Transaction failed:\r\n"+R.responseText);
    							}
    							else
    							{
    								PointCount -= Sub;
    								Points.innerHTML = PointCount;
    							}
    						}
    					}
    					R.open("POST","?act=spend",true);
    					var params = "realm="+Realm.value+"&reward="+Reward.value+"&character="+Character.value;
    					R.setRequestHeader("Content-type","application/x-www-form-urlencoded");
    					R.setRequestHeader("Content-length",params.length);
    					R.setRequestHeader("Connection","close");
    					R.send(params);
    				}
    				
    				function Initialize()
    				{
    					// Setup realm list, char list, etc.
    					var i = 0;
    					for(var r in Realms)
    					{
    						Realm.options[i] = new Option(Realms[r].name,r);
    						i++;
    					}
    					
    					i=0;
    					for(var r in Characters)
    					{
    						if(Characters[r].realm == parseInt(Realm.value))
    						{
    							Character.options[i] = new Option(Characters[r].name,Characters[r].guid);
    							i++;
    						}
    					}
    					
    					i=0;
    					for(var r in Rewards)
    					{
    						if(Rewards[r].realm == parseInt(Realm.value))
    						{
    							Reward.options[i] = new Option(Rewards[r].name,r);
    							i++;
    						}
    					}
    					getCharacters();
    					getRewards();
    					getInfo();
    				}
    				Initialize();
    				
    			</script>
    		<?php
    
    	}
    
    	function Content()
    	{
    		$this->Form();
    	}
    
    	function __construct()
    	{
    		include("html/main.php");
    	}
    
    }
    
    ?>

    AVS Error

Similar Threads

  1. Error In glider
    By hidebr in forum World of Warcraft General
    Replies: 4
    Last Post: 07-21-2006, 08:50 PM
  2. glider error :(
    By Ced in forum World of Warcraft General
    Replies: 2
    Last Post: 07-13-2006, 01:02 PM
  3. WoW Emu error
    By bezike in forum World of Warcraft General
    Replies: 1
    Last Post: 06-28-2006, 03:18 PM
  4. Site Error?
    By Amedis in forum Community Chat
    Replies: 8
    Last Post: 06-21-2006, 08:31 AM
  5. Error in checking WoW.exe CRC code hack?
    By Trichelieu in forum World of Warcraft General
    Replies: 0
    Last Post: 06-11-2006, 02:24 PM
All times are GMT -5. The time now is 03:43 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search