Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
PVP ranks PHP script problem PVP ranks PHP script problem
You last visited: Today at 17:15

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

PVP ranks PHP script problem

Discussion on PVP ranks PHP script problem within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Sep 2009
Posts: 74
Received Thanks: 64
PVP ranks PHP script problem

Hello ,i use xampp 1.7.3 ,db from Svinselladen and when i try to put the PVP ranks.php script on my site it gives this error
Code:
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\scripts\pvp\pvp.php on line 13
So i checked the the line 13 and looks like this
Code:
$pvp		= 4;
Idk i replaced user db and password.If someone know how to fix



Here is the full script

Code:
<?php


//initialize variables
$page		= 1;
$persite	= 25;
$cssicon	= 0;
$cssjob		= 0;
$where		= '';
$addlink	= '';
$maxlevel	= 70; //just for a html output
$scripturl	= $_SERVER['PHP_SELF'];
$pvp		= 4;

//change to your timezone
date_default_timezone_set('America/Los_Angeles');

//function for showing next pages
function pages($seite, $maxseite, $url = "", $anzahl = 4, $get_name = "page"){ 
	if (preg_match("/\?/", $url))
		$anhang = "&";
	else
		$anhang = "?";

	if (substr($url, -1, 1) == "&")
		$url = substr_replace($url, "", -1, 1);
	else if (substr($url, -1, 1) == "?") {
		$anhang	= "?";
		$url	= substr_replace($url, "" , -1, 1);
	}

	if ($anzahl%2 != 0)
		$anzahl++; //Wenn $anzahl ungeraden, dann $anzahl++ 

	$a			= $seite - ($anzahl/2);
	$b			= 0;
	$blaetter	= array();
	
	while ($b <= $anzahl){ 
		if ($a > 0 && $a <= $maxseite){ 
			$blaetter[] = $a; 
			$b++; 
		} 
		else if ($a > $maxseite && ($a-$anzahl-2)>=0){ 
			$blaetter = array(); 
			$a -= ($anzahl+2); 
			$b = 0; 
		} 
		else if ($a > $maxseite && ($a-$anzahl-2)<0) { 
			break; 
		} 

		$a++; 
	}
	
	$return = ""; 
	
	if (!in_array(1, $blaetter) && count($blaetter) > 1){ 
		if (!in_array(2, $blaetter)) 
			$return .= "&nbsp;<div style=\"display: inline; position: relative; top: 5px;\"><a href=\"{$url}{$anhang}{$get_name}=1\"><img src=\"left.png\" alt=\"\"></a></div>"; 
		else 
			$return .= "&nbsp;<a href=\"{$url}{$anhang}{$get_name}=1\">1</a>&nbsp;"; 
	} 

	foreach ($blaetter as $blatt){ 
		if ($blatt == $seite) 
			$return .= "&nbsp;<b>$blatt</b>&nbsp;"; 
		else
			$return .= "&nbsp;<a href=\"{$url}{$anhang}{$get_name}=$blatt\">$blatt</a>&nbsp;"; 
	} 

	if (!in_array($maxseite, $blaetter) && count($blaetter) > 1) { 
		if (!in_array(($maxseite-1), $blaetter)) 
			$return .= "&nbsp;<div style=\"display: inline; position: relative; top: 5px;\"><a href=\"{$url}{$anhang}{$get_name}=$maxseite\"><img src=\"next.png\" alt=\"\"></a></div>&nbsp;"; 
		else
			$return .= "&nbsp;<a href=\"{$url}{$anhang}{$get_name}=$maxseite\">$maxseite</a>&nbsp;"; 
	} 

	if (empty($return)) 
		return  "&nbsp;<b>1</b>&nbsp;"; 
	else 
		return $return; 
} 

//include guild class


//connect to database
if (!$link = @mssql_connect('127.0.0.1', 'Shaiya', 'Shaiya123'))
	die ("Couln't connect to Database.");

//check level area
if (isset($_GET['pvp']) && !empty($_GET['pvp']) && preg_match('#^[0-9]*$#', $_GET['pvp'])){
	$pvp = $_GET['pvp'];
	
	if ($pvp == 1)
		$where = 'AND [c].[Level] BETWEEN 1 AND 15';
	else if ($pvp == 2)
		$where = 'AND [c].[Level] BETWEEN 16 AND 30';
	else if ($pvp == 3)
		$where = 'AND [c].[Level] > 31';
}

//check current page
if (isset($_GET['page']) && !empty($_GET['page']) && preg_match('#^[0-9]*$#', $_GET['page'])){
	$page		= $_GET['page'];
	$addlink	= '&page='.$page;
}

//calculate begin and end
$begin	= ($page - 1) * $persite;
$max	= $page * $persite;

//output HTML
echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
		"http://www.w3.org/TR/html4/loose.dtd">
	  <html>
	  <head>
		<title>PvP Ranking</title>
		<link rel="stylesheet" type="text/css" href="pvp.css">
	  </head>
	  <body>
		<script type="text/javascript" src="wz_tooltip.js"></script>
		<center>';

//output links for level area
echo '<a href="'.$scripturl.'?pvp=1'.$addlink.'">1-15</a>';
echo '<div style="padding-left: 30px; display: inline;"></div>';
echo '<a href="'.$scripturl.'?pvp=2'.$addlink.'">16-30</a>';
echo '<div style="padding-left: 30px; display: inline;"></div>';
echo '<a href="'.$scripturl.'?pvp=3'.$addlink.'">31-'.$maxlevel.'</a>';
echo '<div style="padding-left: 30px; display: inline;"></div>';
echo '<a href="'.$scripturl.'?pvp=4'.$addlink.'">All</a>';
echo "\n<br>\n";
echo "<br>\n";

//output table header
echo '<table border=0 cellspacing=5 cellpadding=1>
		<tr>
			<th>Rank</th>
			<th>Name</th>
			<th>Job</th>
			<th>Level</th>
			<th>Faction</th>
			<th></th>
			<th>Status</th>
			<th></th>
			<th>Kills</th>
			<th>Death</th>
			<th>Icon</th>
			<th></th>
		</tr>';
	  
//sql query
$sql = "SELECT top $max [c].* FROM [PS_GameData].[dbo].[Chars] AS [c]
		INNER JOIN [PS_UserData].[dbo].[Users_Master] AS [u] ON [u].[UserUID] = [c].[UserUID]
		WHERE [c].[Del] = 0 AND [u].[Status] = 0 $where
		ORDER BY [c].[K1] DESC, [c].[K2] ASC, [c].[CharName] ASC";

$res = mssql_query($sql);

for ($i = 1; $char = mssql_fetch_array($res); $i++){
	if ($i >= $begin) {
		$cssjob = $char['Job'] + 17;
		
		//light or dark
		if ($char['Family'] < 2)
			$faction = '<font color="#8a8a8a">Light</font>';
		else
			$faction = '<font color="#212121">Dark</font>';
		
		
		
			
		//online status
		if (isset($char['LoginStatus'])){
			if ($char['LoginStatus'] == 0)
				$online = '<font color="#014b9d">Offline</font>';
			else
				$online = '<font color="#43c3ff">Online</font>';
		}
		else
			$online = '<font color="#014b9d">Unknown</font>';
		
		//map
		$maps = array();
		
		if ($char['Map'] > (count($maps) - 1))
			$map = '';
		else
			$map = $maps[$char['Map']];
		
		//KDR
		if ($char['K2'] == 0)
			$kdr = $char['K1'];
		else
			$kdr = number_format($char['K1']/$char['K2'], 2, '.', '');
		
		if ($char['K1'] >= 200000)
			$cssicon = 16;
		else if ($char['K1'] >= 150000)
			$cssicon = 15;
		else if ($char['K1'] >= 130000)
			$cssicon = 14;
		else if ($char['K1'] >= 110000)
			$cssicon = 13;
		else if ($char['K1'] >= 90000)
			$cssicon = 12;
		else if ($char['K1'] >= 70000)
			$cssicon = 11;
		else if ($char['K1'] >= 50000)
			$cssicon = 10;
		else if ($char['K1'] >= 40000)
			$cssicon = 9;
		else if ($char['K1'] >= 30000)
			$cssicon = 8;
		else if ($char['K1'] >= 20000)
			$cssicon = 7;
		else if ($char['K1'] >= 10000)
			$cssicon = 6;
		else if ($char['K1'] >= 5000)
			$cssicon = 5;
		else if ($char['K1'] >= 1000)
			$cssicon = 4;
		else if ($char['K1'] >= 300)
			$cssicon = 3;
		else if ($char['K1'] >= 50)
			$cssicon = 2;
		else if ($char['K1'] >= 1)
			$cssicon = 1;
		else
			$cssicon = 0;
		
		//output
		echo '<tr>';
		echo '<td class="center">'.$i.'</td>';
		echo '<td class="center">'.$char['CharName'].'</td>';
		echo '<td class="i'.$cssjob.'"></td>';
		echo '<td class="center">'.$char['Level'].'</td>';
		echo '<td class="center">'.$faction.'</td>';
		
		
			echo '<td></td>';
		echo '<td class="center">'.$online.'</td>';
		echo '<td class="center">'.$map.'</td>';
		echo '<td class="center">'.$char['K1'].'</td>';
		echo '<td class="center">'.$char['K2'].'</td>';
		
		echo '<td class="i'.$cssicon.'"></td>';
		echo '</tr>'."\n";
	}
}

echo '</table>';

//show next pages
$csql = "SELECT Count([c].[CharID]) FROM [PS_GameData].[dbo].[Chars] AS [c]
		 INNER JOIN [PS_UserData].[dbo].[Users_Master] AS [u] ON [u].[UserUID] = [c].[UserUID]
		 WHERE [c].[Del] = 0 AND [u].[Status] = 0 $where";
$cres = mssql_query($csql);
$cfet = mssql_fetch_array($cres);

$ccount = $cfet[0];
$cpages = $ccount/$persite;

echo pages($page,  ceil($cpages), $url=$scripturl.'?pvp='.$pvp);

?>
<script language="JavaScript">
      // on right click appear this message
      var DisplayMsg="Right Click Disabled";
      //return message
      function clickBYIE()
      {
          if(document.all)
          {
              alert(DisplayMsg);
              return false;
          }
      }
      //return message
      function clickBYNS(e)
      {
          if (document.layers||(document.getElementById&&!document.all))
          {
              if (e.which==2||e.which==3)
              {
               alert(DisplayMsg);
               return false;
              }
          }
      }

     //set the function as per browser
      if (document.layers)
      {
          document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickBYNS;
      }
      else
      {
          document.onmouseup=clickBYNS;document.oncontextmenu=clickBYIE;
      }
      //disabled the right click on the browser
       document.oncontextmenu=new Function("return false")
  </script>



Solved the error but now when i refresh is a blank page and i dont see any ranks..
Iulian01 is offline  
Thanks
1 User
Old 08/28/2012, 10:52   #2
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Sep 2009
Posts: 74
Received Thanks: 64
I might solved a part of this problem . but why it refuses the sql connection ? port problems ?
Iulian01 is offline  
Thanks
1 User
Old 08/28/2012, 23:34   #3
 
TeddyBear94's Avatar
 
elite*gold: 10
The Black Market: 2/0/0
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
yh might be the ports, i had no probs at all and i used the same stuff from svinseladden...
TeddyBear94 is offline  
Thanks
1 User
Reply

« Looking For Shaiya Web Site Designer ! | [Request/Buying]Sortable Drop Table (for website) »

Similar Threads Similar Threads
Problem VB 10 Patcher Script Problem
09/20/2010 - .NET Languages - 8 Replies
Hayho liebe Com. ich habe mal wieder einen ganz netten Patcher gescriptet, für einen metin2 P Server, da es nicht mein erster is, hab ich echt kp was da vorliegt, Hier der Script an sich: Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEv entArgs) Handles...
Fan-Ranks für LC USA?
09/19/2010 - Last Chaos - 7 Replies
Moin zusammen, weiss hier jemand ob es für die USA-Version auch sowas wie die Fan-Ranks gibt? Ich hab schon gegooglet, aber irgendwie nix gefunden. MfG
[HOW-TO]Hp-Script+Admin-script (weekly-updatet) problem!
06/21/2010 - Metin2 Private Server - 11 Replies
hallo leute ich hab ein problem und zwar bei dem hp script von masterboss kommt der fehler : http://img541.imageshack.us/img541/8140/24955249. png und wenn ich dann die datei öffne und in die zeile gehe kommt: while($row = mysql_fetch_array($ergebnis)) kann mir jmd helfen?
question about skill ranks and class ranks
01/10/2010 - Cabal Online - 0 Replies
take look. my sword rank is apprentice and i have 40/41 skill points and i cant get to next rank, it requires class rank 4. is there any way to get next sword rank without getting required class rank ?
ranks
07/27/2007 - Main - 1 Replies
dumme frage zu den ranks... manche haben so komische ranks sehen by default aus... kann man die irgendwie selber schreiben oder so, und wenn ja, wo?



All times are GMT +2. The time now is 17:15.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.