Greetings Developer..
Anyone please share your knowledge about anaka kruma how do i change ranking.php and what should i include in config.php..
thank you in Advance..
Anaka Kruma Ranking Script
Greetings Developer..
Anyone please share your knowledge about anaka kruma how do i change ranking.php and what should i include in config.php..
thank you in Advance..
What do you really want?Originally Posted by heinz1
I want to make a ranking for anaka Kruma sir...but i don't know the script ....
well...
PHP Code:<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyleft ©2011-2016 Amir Torrez # ||
|| # ---------------- Basic Rank ---------------- # ||
|| # amirtorrez@openmailbox.org # ||
|| #################################################################### ||
\*======================================================================*/
$sql['HOST'] = 'localhost'; // SQL hostname
$sql['USER'] = 'root'; // SQL username (without writing permissions)
$sql['PASS'] = '123'; // SQL user password
$sql['NAME'] = 'Tantra'; // SQL database name
$rank['TOPN'] = 50; // Max chars in top
$rank['ORD1'] = 'BrahmanPoint'; // Order by BrahmanPoint or CharacterLevel
$rank['ORD2'] = 'desc'; // Order by descending (desc) or ascending (asc)
?>
<table width="80%" align="center" border="0">
<thead>
<tr>
<td align="center"><b>Rank</b></td>
<td align="center"><b>Character</b></td>
<td align="center"><b>Level</b></td>
<td align="center"><b>Master Points</b></td>
<td align="center"><b>Guild</b></td>
<td align="center"><b>God</b></td>
<td align="center"><b>Tribe</b></td>
</tr>
</thead>
<tbody>
<?php
function FormatLevel($var){
if($var > 99 && $var < 140){ $ResulLevel = 'Amarah '.($var-99); }
elseif($var > 140 && $var < 180){ $ResulLevel = 'Eda '.($var-140); }
elseif($var > 179){ $ResulLevel = 'Astica '.($var-179);}
else { $ResulLevel = $var; }
return $ResulLevel;
};
function FormatGod($var){
if($var == 1){ $ResultGod = 'Brahma'; }
elseif($var == 2){ $ResultGod = 'Vishnu'; }
elseif($var == 4){ $ResultGod = 'Shiva'; }
else { $ResultGod = 'None'; }
return $ResultGod;
};
function FormatTribe($var){
if($var == 1){ $ResultTribe = 'Naga'; }
elseif($var == 2){ $ResultTribe = 'Kimnara'; }
elseif($var == 4){ $ResultTribe = 'Ashura'; }
elseif($var == 8){ $ResultTribe = 'Rakshasa'; }
elseif($var == 16){ $ResultTribe = 'Yaksa'; }
elseif($var == 32){ $ResultTribe = 'Gandharva'; }
elseif($var == 64){ $ResultTribe = 'Deva'; }
elseif($var == 128){ $ResultTribe = 'Garuda'; }
else{ $ResultTribe = 'GM'; }
return $ResultTribe;
};
$link = mssql_connect($sql['HOST'], $sql['USER'], $sql['PASS']);
mssql_select_db($sql['NAME'], $link);
$query = mssql_query("SELECT TOP ".$rank['TOPN']." * FROM TantraBackup00 ORDER BY ".$rank['ORD1']." ".$rank['ORD2']."");
$i = 0;
while($row = mssql_fetch_array($query)){
$rank = $i+1;
$i += 1;
?>
<tr>
<td align="center"><?php echo($rank);?></td>
<td align="center"><?php echo($row['CharacterName']);?></td>
<td align="center"><?php echo(FormatLevel($row['CharacterLevel']));?></td>
<td align="center"><?php echo($row['BrahmanPoint']);?></td>
<td align="center"><?php echo($row['GuildName']);?></td>
<td align="center"><?php echo(FormatGod($row['Trimurity']));?></td>
<td align="center"><?php echo(FormatTribe($row['Tribe'])); ?></td>
</tr>
<?php
};
mssql_close($link);
?>
</tbody>
</table>
Last edited by John; 19-03-16 at 07:44 PM.
Thank You so Much John....
By The Way this Is only for Config.php and I will create another Rank.php for Anaka Kruma Sir?
In top are the variables to connect to sql, if is only for anaka kruma then show chars between 30 level and the max level in anaka.
I've added two new variables to control the level of the chararacters to show, so, choose the levels depending the kruma. Show me your config.php to combinate the variables.PHP Code:<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyleft ©2011-2016 Amir Torrez # ||
|| # ---------------- Basic Rank ---------------- # ||
|| # amirtorrez@openmailbox.org # ||
|| #################################################################### ||
\*======================================================================*/
$sql['HOST'] = 'localhost'; // SQL hostname
$sql['USER'] = 'root'; // SQL username (without writing permissions)
$sql['PASS'] = '123'; // SQL user password
$sql['NAME'] = 'Tantra'; // SQL database name
$rank['TOPN'] = 50; // Max chars in top
$rank['ORD1'] = 'BrahmanPoint'; // Order by BrahmanPoint or CharacterLevel
$rank['ORD2'] = 'desc'; // Order by descending (desc) or ascending (asc)
$rank['LVL1'] = 30; // Minimum level of the chars to show
$rank['LVL2'] = 70; // Maximum level of the characters to show
?>
<table width="80%" align="center" border="0">
<thead>
<tr>
<td align="center"><b>Rank</b></td>
<td align="center"><b>Character</b></td>
<td align="center"><b>Level</b></td>
<td align="center"><b>Master Points</b></td>
<td align="center"><b>Guild</b></td>
<td align="center"><b>God</b></td>
<td align="center"><b>Tribe</b></td>
</tr>
</thead>
<tbody>
<?php
function FormatLevel($var){
if($var > 99 && $var < 140){ $ResulLevel = 'Amarah '.($var-99); }
elseif($var > 140 && $var < 180){ $ResulLevel = 'Eda '.($var-140); }
elseif($var > 179){ $ResulLevel = 'Astica '.($var-179);}
else { $ResulLevel = $var; }
return $ResulLevel;
};
function FormatGod($var){
if($var == 1){ $ResultGod = 'Brahma'; }
elseif($var == 2){ $ResultGod = 'Vishnu'; }
elseif($var == 4){ $ResultGod = 'Shiva'; }
else { $ResultGod = 'None'; }
return $ResultGod;
};
function FormatTribe($var){
if($var == 1){ $ResultTribe = 'Naga'; }
elseif($var == 2){ $ResultTribe = 'Kimnara'; }
elseif($var == 4){ $ResultTribe = 'Ashura'; }
elseif($var == 8){ $ResultTribe = 'Rakshasa'; }
elseif($var == 16){ $ResultTribe = 'Yaksa'; }
elseif($var == 32){ $ResultTribe = 'Gandharva'; }
elseif($var == 64){ $ResultTribe = 'Deva'; }
elseif($var == 128){ $ResultTribe = 'Garuda'; }
else{ $ResultTribe = 'GM'; }
return $ResultTribe;
};
$link = mssql_connect($sql['HOST'], $sql['USER'], $sql['PASS']);
mssql_select_db($sql['NAME'], $link);
$query = mssql_query("SELECT TOP ".$rank['TOPN']." * FROM TantraBackup00 WHERE CharacterLevel BETWEEN ".$rank['LVL1']." AND ".$rank['LVL2']." ORDER BY ".$rank['ORD1']." ".$rank['ORD2']."");
$i = 0;
while($row = mssql_fetch_array($query)){
$rank = $i+1;
$i += 1;
?>
<tr>
<td align="center"><?php echo($rank);?></td>
<td align="center"><?php echo($row['CharacterName']);?></td>
<td align="center"><?php echo(FormatLevel($row['CharacterLevel']));?></td>
<td align="center"><?php echo($row['BrahmanPoint']);?></td>
<td align="center"><?php echo($row['GuildName']);?></td>
<td align="center"><?php echo(FormatGod($row['Trimurity']));?></td>
<td align="center"><?php echo(FormatTribe($row['Tribe'])); ?></td>
</tr>
<?php
};
mssql_close($link);
?>
</tbody>
</table>
<?php
require_once "sql_inject.php";
$bDestroy_session = TRUE;
$url_redirect = 'index.php';
$sqlinject = new sql_inject('./log_file_sql.log',$bDestroy_session,$url_redirect);
function Conectarse()
{
global $link;
$link=mssql_pconnect("sdacaz\SQLEXPRESS","sa","qwers");
if (!$link) {
exit();
}
if (!mssql_select_db("UserLogin",$link)) {
exit();
}
return $link;
}
Conectarse();
$AccDir = "C:\SERVER\DBSRV\account";
$NameServer = "Tantra";
$TantraWebLink = "http://tantra.net/";
$TantraForumLink = "http://www.tantra.com/forums/";
$SupportLink = "http://www.tantra/support.php";
$SMTPHost = "mail.tantra.com";
$SMTPPort = "465";
$SMTPUser = "server@tantra.com";
$SMTPPass = "smtp";
$SMTPEmail = "server.com";
$SMTPName = "Tantra";
$GM1 = "";
$GM2 = "";
$GM3 = "";
$GM4 = "";
$LinkC1 = "#"; // Link Cliente Mediafire
$LinkC2 = "#"; // Link Cliente Mediafire
$LinkP1 = "#"; // Link Client GigaSize
$LinkP2 = "#"; // Link Parche GigaSize
$mantenimiento = "Off"; // Modo Mantenimiento On / Off
?>
Thank you sir John for Answering ..
Sir...John this is my Config.. By the way i want to create Two Ranking one is for higher Kruma anad One is for Anaka Kruma sir John..what should i change in ranking.php??
Your new config:
ranking for anaka:PHP Code:<?php
require_once "sql_inject.php";
$bDestroy_session = TRUE;
$url_redirect = 'index.php';
$sqlinject = new sql_inject('./log_file_sql.log',$bDestroy_session,$url_redirect);
/* sql connection data */
$sql['HOST'] = 'sdacaz\SQLEXPRESS'; // SQL hostname
$sql['USER'] = 'sa'; // SQL username
$sql['PASS'] = 'qwers'; // SQL user password
/* ranking configurations */
$rank['TOPN'] = 50; // Max chars in top
$rank['ORD1'] = 'BrahmanPoint'; // Order by BrahmanPoint or CharacterLevel
$rank['ORD2'] = 'desc'; // Order by descending (desc) or ascending (asc)
/* for anaka kruma */
$rank1['LVL1'] = 30; // Minimum level of the chars to show
$rank1['LVL2'] = 68; // Maximum level of the characters to show
/* for vedi kruma */
$rank2['LVL1'] = 69; // Minimum level of the chars to show
$rank2['LVL2'] = 99; // Maximum level of the characters to show
/* for kruma */
$rank3['LVL1'] = 100; // Minimum level of the chars to show
$rank3['LVL2'] = 200; // Maximum level of the characters to show
$AccDir = "C:\SERVER\DBSRV\account";
$NameServer = "Tantra";
$TantraWebLink = "http://tantra.net/";
$TantraForumLink = "http://www.tantra.com/forums/";
$SupportLink = "http://www.tantra/support.php";
$SMTPHost = "mail.tantra.com";
$SMTPPort = "465";
$SMTPUser = "server@tantra.com";
$SMTPPass = "smtp";
$SMTPEmail = "server.com";
$SMTPName = "Tantra";
$GM1 = "";
$GM2 = "";
$GM3 = "";
$GM4 = "";
$LinkC1 = "#"; // Link Cliente Mediafire
$LinkC2 = "#"; // Link Cliente Mediafire
$LinkP1 = "#"; // Link Client GigaSize
$LinkP2 = "#"; // Link Parche GigaSize
$mantenimiento = "Off"; // Modo Mantenimiento On / Off
function Conectarse(){
global $link;
$link=mssql_pconnect($sql['HOST'], $sql['USER'], $sql['PASS']);
if (!$link) {
exit();
};
if (!mssql_select_db("UserLogin",$link)) {
exit();
};
return $link;
};
Conectarse();
?>
ranking for vediPHP Code:<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyleft ©2011-2016 Amir Torrez # ||
|| # ---------------- Basic Rank ---------------- # ||
|| # amirtorrez@openmailbox.org # ||
|| #################################################################### ||
\*======================================================================*/
include('config.php');
?>
<table width="80%" align="center" border="0">
<thead>
<tr>
<td align="center"><b>Rank</b></td>
<td align="center"><b>Character</b></td>
<td align="center"><b>Level</b></td>
<td align="center"><b>Master Points</b></td>
<td align="center"><b>Guild</b></td>
<td align="center"><b>God</b></td>
<td align="center"><b>Tribe</b></td>
</tr>
</thead>
<tbody>
<?php
function FormatLevel($var){
if($var > 99 && $var < 140){ $ResulLevel = 'Amarah '.($var-99); }
elseif($var > 140 && $var < 180){ $ResulLevel = 'Eda '.($var-140); }
elseif($var > 179){ $ResulLevel = 'Astica '.($var-179);}
else { $ResulLevel = $var; }
return $ResulLevel;
};
function FormatGod($var){
if($var == 1){ $ResultGod = 'Brahma'; }
elseif($var == 2){ $ResultGod = 'Vishnu'; }
elseif($var == 4){ $ResultGod = 'Shiva'; }
else { $ResultGod = 'None'; }
return $ResultGod;
};
function FormatTribe($var){
if($var == 1){ $ResultTribe = 'Naga'; }
elseif($var == 2){ $ResultTribe = 'Kimnara'; }
elseif($var == 4){ $ResultTribe = 'Ashura'; }
elseif($var == 8){ $ResultTribe = 'Rakshasa'; }
elseif($var == 16){ $ResultTribe = 'Yaksa'; }
elseif($var == 32){ $ResultTribe = 'Gandharva'; }
elseif($var == 64){ $ResultTribe = 'Deva'; }
elseif($var == 128){ $ResultTribe = 'Garuda'; }
else{ $ResultTribe = 'GM'; }
return $ResultTribe;
};
$link = mssql_connect($sql['HOST'], $sql['USER'], $sql['PASS']);
mssql_select_db('Tantra', $link);
$query = mssql_query("SELECT TOP ".$rank['TOPN']." * FROM TantraBackup00 WHERE CharacterLevel BETWEEN ".$rank1['LVL1']." AND ".$rank1['LVL2']." ORDER BY ".$rank['ORD1']." ".$rank['ORD2']."");
$i = 0;
while($row = mssql_fetch_array($query)){
$rank = $i+1;
$i += 1;
?>
<tr>
<td align="center"><?php echo($rank);?></td>
<td align="center"><?php echo($row['CharacterName']);?></td>
<td align="center"><?php echo(FormatLevel($row['CharacterLevel']));?></td>
<td align="center"><?php echo($row['BrahmanPoint']);?></td>
<td align="center"><?php echo($row['GuildName']);?></td>
<td align="center"><?php echo(FormatGod($row['Trimurity']));?></td>
<td align="center"><?php echo(FormatTribe($row['Tribe'])); ?></td>
</tr>
<?php
};
mssql_close($link);
?>
</tbody>
</table>
for krumaPHP Code:<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyleft ©2011-2016 Amir Torrez # ||
|| # ---------------- Basic Rank ---------------- # ||
|| # amirtorrez@openmailbox.org # ||
|| #################################################################### ||
\*======================================================================*/
include('config.php');
?>
<table width="80%" align="center" border="0">
<thead>
<tr>
<td align="center"><b>Rank</b></td>
<td align="center"><b>Character</b></td>
<td align="center"><b>Level</b></td>
<td align="center"><b>Master Points</b></td>
<td align="center"><b>Guild</b></td>
<td align="center"><b>God</b></td>
<td align="center"><b>Tribe</b></td>
</tr>
</thead>
<tbody>
<?php
function FormatLevel($var){
if($var > 99 && $var < 140){ $ResulLevel = 'Amarah '.($var-99); }
elseif($var > 140 && $var < 180){ $ResulLevel = 'Eda '.($var-140); }
elseif($var > 179){ $ResulLevel = 'Astica '.($var-179);}
else { $ResulLevel = $var; }
return $ResulLevel;
};
function FormatGod($var){
if($var == 1){ $ResultGod = 'Brahma'; }
elseif($var == 2){ $ResultGod = 'Vishnu'; }
elseif($var == 4){ $ResultGod = 'Shiva'; }
else { $ResultGod = 'None'; }
return $ResultGod;
};
function FormatTribe($var){
if($var == 1){ $ResultTribe = 'Naga'; }
elseif($var == 2){ $ResultTribe = 'Kimnara'; }
elseif($var == 4){ $ResultTribe = 'Ashura'; }
elseif($var == 8){ $ResultTribe = 'Rakshasa'; }
elseif($var == 16){ $ResultTribe = 'Yaksa'; }
elseif($var == 32){ $ResultTribe = 'Gandharva'; }
elseif($var == 64){ $ResultTribe = 'Deva'; }
elseif($var == 128){ $ResultTribe = 'Garuda'; }
else{ $ResultTribe = 'GM'; }
return $ResultTribe;
};
$link = mssql_connect($sql['HOST'], $sql['USER'], $sql['PASS']);
mssql_select_db('Tantra', $link);
$query = mssql_query("SELECT TOP ".$rank['TOPN']." * FROM TantraBackup00 WHERE CharacterLevel BETWEEN ".$rank2['LVL1']." AND ".$rank2['LVL2']." ORDER BY ".$rank['ORD1']." ".$rank['ORD2']."");
$i = 0;
while($row = mssql_fetch_array($query)){
$rank = $i+1;
$i += 1;
?>
<tr>
<td align="center"><?php echo($rank);?></td>
<td align="center"><?php echo($row['CharacterName']);?></td>
<td align="center"><?php echo(FormatLevel($row['CharacterLevel']));?></td>
<td align="center"><?php echo($row['BrahmanPoint']);?></td>
<td align="center"><?php echo($row['GuildName']);?></td>
<td align="center"><?php echo(FormatGod($row['Trimurity']));?></td>
<td align="center"><?php echo(FormatTribe($row['Tribe'])); ?></td>
</tr>
<?php
};
mssql_close($link);
?>
</tbody>
</table>
in the config file edit the lines:PHP Code:<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyleft ©2011-2016 Amir Torrez # ||
|| # ---------------- Basic Rank ---------------- # ||
|| # amirtorrez@openmailbox.org # ||
|| #################################################################### ||
\*======================================================================*/
include('config.php');
?>
<table width="80%" align="center" border="0">
<thead>
<tr>
<td align="center"><b>Rank</b></td>
<td align="center"><b>Character</b></td>
<td align="center"><b>Level</b></td>
<td align="center"><b>Master Points</b></td>
<td align="center"><b>Guild</b></td>
<td align="center"><b>God</b></td>
<td align="center"><b>Tribe</b></td>
</tr>
</thead>
<tbody>
<?php
function FormatLevel($var){
if($var > 99 && $var < 140){ $ResulLevel = 'Amarah '.($var-99); }
elseif($var > 140 && $var < 180){ $ResulLevel = 'Eda '.($var-140); }
elseif($var > 179){ $ResulLevel = 'Astica '.($var-179);}
else { $ResulLevel = $var; }
return $ResulLevel;
};
function FormatGod($var){
if($var == 1){ $ResultGod = 'Brahma'; }
elseif($var == 2){ $ResultGod = 'Vishnu'; }
elseif($var == 4){ $ResultGod = 'Shiva'; }
else { $ResultGod = 'None'; }
return $ResultGod;
};
function FormatTribe($var){
if($var == 1){ $ResultTribe = 'Naga'; }
elseif($var == 2){ $ResultTribe = 'Kimnara'; }
elseif($var == 4){ $ResultTribe = 'Ashura'; }
elseif($var == 8){ $ResultTribe = 'Rakshasa'; }
elseif($var == 16){ $ResultTribe = 'Yaksa'; }
elseif($var == 32){ $ResultTribe = 'Gandharva'; }
elseif($var == 64){ $ResultTribe = 'Deva'; }
elseif($var == 128){ $ResultTribe = 'Garuda'; }
else{ $ResultTribe = 'GM'; }
return $ResultTribe;
};
$link = mssql_connect($sql['HOST'], $sql['USER'], $sql['PASS']);
mssql_select_db('Tantra', $link);
$query = mssql_query("SELECT TOP ".$rank['TOPN']." * FROM TantraBackup00 WHERE CharacterLevel BETWEEN ".$rank3['LVL1']." AND ".$rank3['LVL2']." ORDER BY ".$rank['ORD1']." ".$rank['ORD2']."");
$i = 0;
while($row = mssql_fetch_array($query)){
$rank = $i+1;
$i += 1;
?>
<tr>
<td align="center"><?php echo($rank);?></td>
<td align="center"><?php echo($row['CharacterName']);?></td>
<td align="center"><?php echo(FormatLevel($row['CharacterLevel']));?></td>
<td align="center"><?php echo($row['BrahmanPoint']);?></td>
<td align="center"><?php echo($row['GuildName']);?></td>
<td align="center"><?php echo(FormatGod($row['Trimurity']));?></td>
<td align="center"><?php echo(FormatTribe($row['Tribe'])); ?></td>
</tr>
<?php
};
mssql_close($link);
?>
</tbody>
</table>
according the level of the ranking (or the map), if you look, the 3 files are the same, only changed 2 variables, of the levels.PHP Code:/* for anaka kruma */
$rank1['LVL1'] = 30; // Minimum level of the chars to show
$rank1['LVL2'] = 68; // Maximum level of the characters to show
/* for vedi kruma */
$rank2['LVL1'] = 69; // Minimum level of the chars to show
$rank2['LVL2'] = 99; // Maximum level of the characters to show
/* for kruma */
$rank3['LVL1'] = 100; // Minimum level of the chars to show
$rank3['LVL2'] = 200; // Maximum level of the characters to show
already have the base, edit how you want
Re: Anaka Kruma Ranking Script
Sir.. John Thank you so much....
- - - Updated - - -
By the way Sir John.. Do you Have Any Video Tutorial for Making A New Set or Weapon...
- - - Updated - - -
By the way Sir John.. Do you Have Any Video Tutorial for Making A New Set or Weapon...
No, sorry, i don't haveSir.. John Thank you so much....
- - - Updated - - -
By the way Sir John.. Do you Have Any Video Tutorial for Making A New Set or Weapon...
- - - Updated - - -
By the way Sir John.. Do you Have Any Video Tutorial for Making A New Set or Weapon...
Sir John . do you have script for Instant Astica 20 ?
I don't understand
@John He is talking about the php script to make the character Astica 20 from the website.
sir Jbeitz Do you have Tutorial on making a Set ??
I have a colleague that has created tutorials for such things. If you are interested, he is asking $75 for the tutorials but, they are well worth it when you think about having someone that can answer your questions and also save you money on purchasing the sets without the tutorial. Anyhow let me know if you are interested. I don't get anything from this other than the satisfaction of helping others.
Reply With Quote