Jump to content

Recommended Posts

Posted

ok, I decided to share the source code of my aio buffer creator script that I use at http://l2database.org/aiobuffer.php .

Because atm im a little busy I will share db sqls later or contact me

Thanks.

 

<?php
// Check If Is Integer Value
function is_int_val($data) {
if (is_int($data) === true) return true;
elseif (is_string($data) === true && is_numeric($data) === true) {
return (strpos($data, '.') === false);
}
return false;
}

// DB-CONNECT
$db_host = "localhost";										// DB-Host: Ex: localhost
$db_user = "root";									// DB-User: Ex: root
$db_pass = "root";									// DB-Pass: Ex: root
$db_name = "server";									// DB-Name: Ex: server

session_start();

mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$db_name");

echo "<b>Report bugs and suggestions at our forum!</b><br>
<table>
<tr><td><i>Latest 10 Configurations</i></td><td>    |    <td><i>Most 10 Viewed Configurations</i></td></tr>
";

$getlatest = mysql_query("SELECT id,name FROM aioconfiguration1 WHERE id >=1 ORDER by id desc limit 10;");

echo "<tr><td>";
$i = '1';
while($row=mysql_fetch_row($getlatest)){
$confid = $row[0];
echo "$i) <a href='?a=Load&confid=$confid&infos=1'>$row[1]</a><br>";

$i++;
}
echo "</td><td>         </td><td>";

$getmostviewed = mysql_query("SELECT id,name,views FROM aioconfiguration1 WHERE views >= 0 ORDER by views desc limit 10;");

$i = '1';
while($row=mysql_fetch_row($getmostviewed)){
$confid = $row[0];
echo "$i) <a href='?a=Load&confid=$confid&infos=1'>$row[1] ($row[2] views)</a><br>";

$i++;
}

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

if(isset($_GET['a']) && $_GET['a'] == 'Load' && isset($_GET['confid']) && is_int_val($_GET['confid'])){
$confid = $_GET['confid'];


$confinfo = mysql_query("SELECT id,name,chronicle,chartablename,charid,charname,charlevel,charexp,charclassid,charbaseclass,skillstablename,skillnamerow,buffstablename,hennastablename,views FROM aioconfiguration1 WHERE id = '$confid'");
$confcount = mysql_num_rows($confinfo);

if($confcount != '1'){
echo "<font color='red'>This configuration id it's not existing in our database!</font>";
}
else{

while($row=mysql_fetch_row($confinfo)){
$name = $row[1];
$chronicle = $row[2];
$chartable = $row[3];
$charid = $row[4];
$charname = $row[5];
$charlevel = $row[6];
$charexp = $row[7];
$charclass = $row[8];
$charbase = $row[9];
$skilltable = $row[10];
$skillname = $row[11];
$buffstable = $row[12];
$hennastable = $row[13];
$views = $row[14];
}



echo "<center><a href='?a=Load&confid=$confid&infos=1'>Configuration Informations</a><br>
<a href='?a=Load&confid=$confid&infos=2'>Custom Buffs Informations</a>
<br><br>
<a href='?a=Load&confid=$confid&create=1'>Create an aio buffer</a>
</center>";

if(isset($_GET['create']) && $_GET['create'] == '1' && isset($_GET['confid'])){
$confid = $_GET['confid'];

if(isset($_POST['confid']) &&isset($_POST['submit']) && isset($_POST['newcharclass']) && isset($_POST['newcharlevel']) && isset($_POST['newcharname']) && isset($_POST['charid']) && isset($_POST['method'])){
$confid = $_POST['confid'];
$method = $_POST['method'];
$newcharclass = $_POST['newcharclass'];
$newcharlevel = $_POST['newcharlevel'];
$newcharname = $_POST['newcharname'];
$newcharid = $_POST['charid'];

if(!is_int_val($newcharclass) || strlen($newcharclass) > '5' || !is_int_val($newcharlevel) || strlen($newcharlevel) > '3' || strlen($newcharname) > '30' || !is_int_val($newcharid) || strlen($newcharid) > '40'){
echo "<font color='red'>Fields incorrectly completed</font>";
}
elseif(!is_int_val($confid)){
echo "<font color='red'>Invalid Configuration Id</font>";
}
elseif($newcharlevel < '1' || $newcharlevel > '86'){
echo "<font color='red'>Char level must be between 1 and 86</font>";
}
else{

if($newcharlevel == '80'){
$newcharexp = '6299994998';
}
elseif($newcharlevel == '85'){
$newcharexp = '9299994998';
}
else{
$newcharexp = '0';
}

$getconfinformations = mysql_query("SELECT id,name,chronicle,chartablename,charid,charname,charlevel,charexp,charclassid,charbaseclass,skillstablename,skillnamerow,buffstablename,hennastablename FROM aioconfiguration1 WHERE id='$confid'");
$getconfcount = mysql_num_rows($getconfinformations);

if($getconfcount != '1'){
echo "<font color='red'>Invalid Configuration Id</font>";
}

else{

while($row=mysql_fetch_row($getconfinformations)){
$name = $row[1];
$chronicle = $row[2];
$chartablename = $row[3];
$charid = $row[4];
$charname = $row[5];
$charlevel = $row[6];
$charexp = $row[7];
$charclass = $row[8];
$charbase = $row[9];
$skillstable = $row[10];
$skillname = $row[11];
$buffstable = $row[12];
$hennastable = $row[13];

}

$aiobufferskillq = mysql_query("SELECT id,skillid,skillname,level,type FROM aiobuffs WHERE type <= '$chronicle'");

while($row=mysql_fetch_row($aiobufferskillq)){

if($skillname == '0'){
$aiobufferskills .= "INSERT INTO $skillstable VALUES ('$newcharid', '$row[1]', '$row[3]', '0');
";
}
elseif($skillname == '1'){
$aiobufferskills .= "INSERT INTO $skillstable VALUES ('$newcharid', '$row[1]', '$row[3]', '$row[2]', '0');
";

}

}


$customaiobufferskills = '';

$getcustom = mysql_query("SELECT id,confid,skillid,level,skillname FROM aioconfiguration2 WHERE confid='$confid'");
$getcustomcount = mysql_num_rows($getcustom);

if($getcustomcount != '0'){

$customaiobufferskills .= "
/* Add Custom Buff Skills
  To Aio Character /* 

";


while($row=mysql_fetch_row($getcustom)){

if($skillname == '0'){
$customaiobufferskills .= "INSERT INTO $skillstable VALUES ('$newcharid', '$row[2]', '$row[3]', '0');
";
}
elseif($skillname == '1'){
$customaiobufferskills .= "INSERT INTO $skillstable VALUES ('$newcharid', '$row[2]', '$row[3]', '$row[4]', '0');
";
}
}


}


if($chronicle == '1'){
$chronicle = 'Interlude';
}
elseif($chronicle == '2'){
$chronicle = 'Kamael';
}
elseif($chronicle == '3'){
$chronicle = 'Hellbound';
}
elseif($chronicle == '4'){
$chronicle = 'Gracia';
}
elseif($chronicle == '5'){
$chronicle = 'Gracia2';
}
elseif($chronicle == '6'){
$chronicle = 'Gracia Final';
}
elseif($chronicle == '7'){
$chronicle = 'Gracia Epilogue';
}
else{
$chronicle = 'None';
}


if($method == '1'){

echo "<br><br><b>To create an aio buffer with this function you have to follow the next steps:</b><br>
- Make sure that the character you want to make aio buffer it's logged out
<br>
- Visit characters table and take the character id (You can use 'Ctrl + F' to find it easy)
<br>
- Copy the next sql code and paste it in database query manager.<br><br>


<form name='sqlscript'>
<textarea id='query' rows='30' cols='70'>
/* Aio Buffer Creator By Puka.
  Contact me at michael9ufo@yahoo.co.uk for suggestions and others. */



/* Change Char Level, Name and Class.
  To $newcharlevel, $newcharname and $newcharclass. */

UPDATE characters SET $char='$newcharlevel', $charexp='$newcharexp', $charclass='$newcharclass', $charname='$newcharname', $charbase='$newcharclass' WHERE $charid='$newcharid';

/* Add All $chronicle Buff Skills To Character
  Custom skills are not included here! */

$aiobufferskills

$customaiobufferskills

/* Add Hennas To Character
  Casting speed dyes. /*

INSERT INTO $hennastable VALUES ($newcharid, 180, 1, 0);
INSERT INTO $hennastable VALUES ($newcharid, 144, 1, 1);
INSERT INTO $hennastable VALUES ($newcharid, 174, 1, 2);
INSERT INTO $hennastable VALUES ($newcharid, 180, 2, 0);
INSERT INTO $hennastable VALUES ($newcharid, 171, 2, 1);
INSERT INTO $hennastable VALUES ($newcharid, 180, 3, 1);

/* Buff Up The Character
  Buffs for castingspeed/speed /*

INSERT INTO $buffstable VALUES ($newcharid, 99, 2, 1, 505, 0, 0, 2, 26);
INSERT INTO $buffstable VALUES ($newcharid, 264, 1, 1, 165, 0, 0, 0, 17);
INSERT INTO $buffstable VALUES ($newcharid, 264, 1, 1, 850, 0, 0, 2, 19);
INSERT INTO $buffstable VALUES ($newcharid, 265, 1, 1, 163, 0, 0, 0, 19);
INSERT INTO $buffstable VALUES ($newcharid, 266, 1, 1, 848, 0, 0, 2, 22);
INSERT INTO $buffstable VALUES ($newcharid, 267, 1, 1, 167, 0, 0, 0, 16);
INSERT INTO $buffstable VALUES ($newcharid, 267, 1, 1, 850, 0, 0, 2, 20);
INSERT INTO $buffstable VALUES ($newcharid, 268, 1, 1, 198, 0, 0, 0, 2);
INSERT INTO $buffstable VALUES ($newcharid, 268, 1, 1, 6250, 0, 0, 1, 2);
INSERT INTO $buffstable VALUES ($newcharid, 268, 1, 1, 860, 0, 0, 2, 2);
INSERT INTO $buffstable VALUES ($newcharid, 269, 1, 1, 847, 0, 0, 2, 23);
INSERT INTO $buffstable VALUES ($newcharid, 271, 1, 1, 853, 0, 0, 2, 15);
INSERT INTO $buffstable VALUES ($newcharid, 272, 1, 1, 852, 0, 0, 2, 16);
INSERT INTO $buffstable VALUES ($newcharid, 273, 1, 1, 178, 0, 0, 0, 14);
INSERT INTO $buffstable VALUES ($newcharid, 274, 1, 1, 851, 0, 0, 2, 18);
INSERT INTO $buffstable VALUES ($newcharid, 275, 1, 1, 852, 0, 0, 2, 17);
INSERT INTO $buffstable VALUES ($newcharid, 276, 1, 1, 171, 0, 0, 0, 15);
INSERT INTO $buffstable VALUES ($newcharid, 304, 1, 1, 164, 0, 0, 0, 18);
INSERT INTO $buffstable VALUES ($newcharid, 304, 1, 1, 849, 0, 0, 2, 21);
INSERT INTO $buffstable VALUES ($newcharid, 1035, 4, 1, 184, 0, 0, 0, 5);
INSERT INTO $buffstable VALUES ($newcharid, 1035, 4, 1, 856, 0, 0, 2, 10);
INSERT INTO $buffstable VALUES ($newcharid, 1036, 2, 1, 182, 0, 0, 0, 9);
INSERT INTO $buffstable VALUES ($newcharid, 1036, 2, 1, 855, 0, 0, 2, 12);
INSERT INTO $buffstable VALUES ($newcharid, 1040, 3, 1, 189, 0, 0, 0, 3);
INSERT INTO $buffstable VALUES ($newcharid, 1040, 3, 1, 859, 0, 0, 2, 4);
INSERT INTO $buffstable VALUES ($newcharid, 1044, 3, 1, 183, 0, 0, 0, 8);
INSERT INTO $buffstable VALUES ($newcharid, 1044, 3, 1, 855, 0, 0, 2, 11);
INSERT INTO $buffstable VALUES ($newcharid, 1045, 6, 1, 186, 0, 0, 0, 4);
INSERT INTO $buffstable VALUES ($newcharid, 1045, 6, 1, 857, 0, 0, 2, 9);
INSERT INTO $buffstable VALUES ($newcharid, 1048, 6, 1, 179, 0, 0, 0, 12);
INSERT INTO $buffstable VALUES ($newcharid, 1059, 3, 1, 183, 0, 0, 0, 7);
INSERT INTO $buffstable VALUES ($newcharid, 1062, 2, 1, 182, 0, 0, 0, 10);
INSERT INTO $buffstable VALUES ($newcharid, 1062, 2, 1, 6244, 0, 0, 1, 3);
INSERT INTO $buffstable VALUES ($newcharid, 1062, 2, 1, 855, 0, 0, 2, 13);
INSERT INTO $buffstable VALUES ($newcharid, 1068, 3, 1, 859, 0, 0, 2, 3);
INSERT INTO $buffstable VALUES ($newcharid, 1077, 3, 1, 858, 0, 0, 2, 5);
INSERT INTO $buffstable VALUES ($newcharid, 1078, 6, 1, 179, 0, 0, 0, 13);
INSERT INTO $buffstable VALUES ($newcharid, 1085, 3, 1, 184, 0, 0, 0, 6);
INSERT INTO $buffstable VALUES ($newcharid, 1086, 2, 1, 857, 0, 0, 2, 8);
INSERT INTO $buffstable VALUES ($newcharid, 1087, 3, 1, 853, 0, 0, 2, 14);
INSERT INTO $buffstable VALUES ($newcharid, 1204, 2, 1, 200, 0, 0, 0, 1);
INSERT INTO $buffstable VALUES ($newcharid, 1204, 2, 1, 6252, 0, 0, 1, 1);
INSERT INTO $buffstable VALUES ($newcharid, 1204, 2, 1, 861, 0, 0, 2, 1);
INSERT INTO $buffstable VALUES ($newcharid, 1240, 3, 1, 858, 0, 0, 2, 6);
INSERT INTO $buffstable VALUES ($newcharid, 1242, 3, 1, 858, 0, 0, 2, 7);
INSERT INTO $buffstable VALUES ($newcharid, 1243, 6, 1, 180, 0, 0, 0, 11);
INSERT INTO $buffstable VALUES ($newcharid, 1323, 1, 1, 587, 0, 0, 2, 25);
INSERT INTO $buffstable VALUES ($newcharid, 1355, 1, 1, 4, 0, 0, 0, 20);
INSERT INTO $buffstable VALUES ($newcharid, 1363, 1, 1, 818, 0, 0, 2, 24);


/* Aio Buffer Created
  http://forum.l2database.org To Report Errors/*

</textarea>

</form>
";
}
elseif($method == '2'){
echo "Function Disabled For The Moment!";
}
else{
echo "<font color='red'>Invalid method</font>";
}
}
}}
else{
echo "<br><br><form action='?a=Load&confid=$confid&create=1' method='post'>
<input type='hidden' name='confid' value='$confid'>
<center>
<table>
<tr><td><b>Character Creation Method</b></td><td><select name='method'>
<option value='1'>SQL Query</option>
<option value='2'>Database Connection (Disabled for the moment)</option>
</select></td></tr>

<tr><td> </td></tr>
<tr><td><b>Character ID</b></td><td><input type='text' name='charid'></td></tr>
<tr><td><b>New Character Name</b></td><td><input type='text' name='newcharname'></td></tr>
<tr><td><b>New Character Level</b></td><td><select name='newcharlevel'><option value='80'>80</option><option value='85'>85</option></select></td></tr>
<tr><td><b>New Character Class</b></td><td><input type='text' name='newcharclass'></td></tr>
</table>
<input type='submit' name='submit' value='Create Aio Buffer'>
</center>
</form>
";
}
}

elseif(isset($_GET['infos']) && $_GET['infos'] == '2'){

$getcustombuffs = mysql_query("SELECT id,confid,skillid,level,skillname FROM aioconfiguration2 WHERE confid='$confid'");
$getcustomcount = mysql_num_rows($getcustombuffs);

if($getcustomcount > '0'){

echo "<br><br><table border='1'><tr><td><b>Skill Id</b></td><td><b>Skill Level</b></td><td><b>Skill name</b></td></tr>";

while($row=mysql_fetch_row($getcustombuffs)){
$id = $row[0];
$confid = $row[1];
$skillid = $row[2];
$level = $row[3];
$skillname = $row[4];

$custombuffs .= "<tr><td>$skillid</td><td>$level</td><td>$skillname</td></tr>";

}

echo $custombuffs;
echo "</table>";
}
else{
echo "<br><br><font color='red'>No custom skills!</font>";
}


}
elseif(isset($_GET['infos']) && $_GET['infos'] == '1'){

$ip = $_SERVER['REMOTE_ADDR'];
$checkip = mysql_query("SELECT * FROM configviews WHERE ip='$ip' and confid='$confid'");
$checkcount = mysql_num_rows($checkip);

if($checkcount == '0'){

$getviews = mysql_query("SELECT id,views FROM aioconfiguration1 WHERE id='$confid'");
while($row=mysql_fetch_row($getviews)){
$views = $row[1];
}

$views += '1';

$addview = mysql_query("UPDATE aioconfiguration1 SET views='$views' WHERE id='$confid'");
$blockview = mysql_query("INSERT INTO configviews (ip, confid) VALUES ('$ip', '$confid')");
}

if($skillname == '1'){
$skillname = "Yes";
}
elseif($skillname == '0'){
$skillname = "No";
}

if($chronicle == '1'){
$chronicle = 'Interlude';
}
elseif($chronicle == '2'){
$chronicle = 'Kamael';
}
elseif($chronicle == '3'){
$chronicle = 'Hellbound';
}
elseif($chronicle == '4'){
$chronicle = 'Gracia';
}
elseif($chronicle == '5'){
$chronicle = 'Gracia2';
}
elseif($chronicle == '6'){
$chronicle = 'Gracia Final';
}
elseif($chronicle == '7'){
$chronicle = 'Gracia Epilogue';
}
else{
$chronicle = 'None';
}

echo "<br>
<table border='1'><tr><td>
<table>
<tr><td><b>Configuration Id:</b></td><td>$confid</td></tr>
<tr><td><b>Configuration Name:</b></td><td>$name</td></tr>
<tr><td><b>Configuration Chronicle:</b></td><td>$chronicle</td></tr>
<tr><td><b>Configuration Char Table:</b></td><td>$chartable</td></tr>
<tr><td><b>Configuration Char Id:</b></td><td>$charid</td></tr>
<tr><td><b>Configuration Char Name:</b></td><td>$charname</td></tr>
<tr><td><b>Configuration Char Level:</b></td><td>$charlevel</td></tr>
<tr><td><b>Configuration Char Exp:</b></td><td>$charexp</td></tr>
<tr><td><b>Configuration Char Class:</b></td><td>$charclass</td></tr>
<tr><td><b>Configuration Char Base:</b></td><td>$charbase</td></tr>
<tr><td><b>Configuration Skill Table:</b></td><td>$skilltable</td></tr>
<tr><td><b>Configuration Skill Name:</b></td><td>$skillname</td></tr>
<tr><td><b>Configuration Buffs Table:</b></td><td>$buffstable</td></tr>
<tr><td><b>Configuration Hennas Table:</b></td><td>$hennastable</td></tr>
<tr><td><b>Configuration Views:</b></td><td>$views</td></tr>



</table>
</td></tr></table>

";
}





}

}
elseif(isset($_GET['submit']) && isset($_GET['confname']) && isset($_GET['chronicle']) && isset($_GET['tablechar']) && isset($_GET['charid']) && isset($_GET['charname']) && isset($_GET['charlevel']) && isset($_GET['charexp']) && isset($_GET['charclass']) && isset($_GET['charbase']) && isset($_GET['tableskills']) && isset($_GET['skillname']) && isset($_GET['tablebuffs']) && isset($_GET['tablehennas'])){
$confname = htmlspecialchars($_GET['confname']);
$chronicle = htmlspecialchars($_GET['chronicle']);
$tablechar = htmlspecialchars($_GET['tablechar']);
$charid = htmlspecialchars($_GET['charid']);
$charname = htmlspecialchars($_GET['charname']);
$charlevel = htmlspecialchars($_GET['charlevel']);
$charexp = htmlspecialchars($_GET['charexp']);
$charclass = htmlspecialchars($_GET['charclass']);
$charbase = htmlspecialchars($_GET['charbase']);
$tableskills = htmlspecialchars($_GET['tableskills']);
$skillname = htmlspecialchars($_GET['skillname']);
$tablebuffs = htmlspecialchars($_GET['tablebuffs']);
$tablehennas = htmlspecialchars($_GET['tablehennas']);


$testname = mysql_query("SELECT * FROM aioconfiguration1 WHERE name='$confname'");
$count = mysql_num_rows($testname);

if($confname == '' || $tablechar == '' || $charid == '' || $charname == '' || $charlevel == '' || $charexp == '' || $charclass == '' || $charbase == '' || $tableskills == '' || $skillname == '' || $tablebuffs == '' || $tablehennas == ''){
echo "<font color='red'>Please complete all fields!</font>";
}
elseif(strlen($confname) > '60' || strlen($chronicle) > '15' || strlen($chartablename) > '50' || strlen($charid) > '50' || strlen($charlevel) > '50' || strlen($charexp) > '50' || strlen($charclass) > '50' || strlen($charbase) > '50' || strlen($tableskills) > '50' || strlen($skillname) > '5' || strlen($tablebuffs) > '50' || strlen($tablehennas) > '50'){
echo "<font color='red'>Some fields are too long!</font>";
} 
elseif($count == '1'){
echo "<font color='red'>This configuration name '<b>$confname</b>' already exists!";
}

else{
$confinfos = mysql_query("INSERT INTO aioconfiguration1 (name, chronicle, chartablename, charid, charname, charlevel, charexp, charclassid, charbaseclass, skillstablename, skillnamerow, buffstablename, hennastablename, views) VALUES ('$confname', '$chronicle', '$tablechar', '$charid', '$charname', '$charlevel', '$charexp', '$charclass', '$charbase', '$tableskills', '$skillname', '$tablebuffs', '$tablehennas', '0')");

$getconfid = mysql_query("SELECT id FROM aioconfiguration1 WHERE name='$confname'");

while($row=mysql_fetch_row($getconfid)){
$confid = $row[0];
}

$newskills = $_SESSION['more'];

for($i = '1'; $i <= $newskills; $i++){
if($_GET["skillname$i"] != '' && strlen($_GET["skillid$i"]) < '58' && strlen($_GET["level$i"]) < '49' && strlen($_GET["skillname$i"]) < '65' && is_int_val($_GET["level$i"]) && is_int_val($_GET["skillid$i"]) && $_GET["skillid$i"] != '' && $_GET["level$i"] != ''){


$cskillid = $_GET["skillid$i"];
$cskillname = $_GET["skillname$i"];
$cskilllevel = $_GET["level$i"];

$customskills = mysql_query("INSERT INTO aioconfiguration2 (confid, skillid, level, skillname) VALUES ('$confid', '$cskillid', '$cskilllevel', '$cskillname')");

}
}

echo "Configuration created!<br>Id of configuration it's <b><font color='green'>$confid</font></b>";



}}
else{
echo "<form name='load' action='aiobuffer2.php' method='get'>";
echo "
<center>
Load Configuration
<br>
<hr>
<table>
<tr><td>ID:</td><td><input type='text' name='confid'></td></tr>
</table>
<input type='submit' name='a' value='Load'>
";
echo "</table></center>";
echo "</form>";
echo "<hr><br>";
echo "<center>Create Configuration<br>
<br><hr>

<form action='aiobuffer2.php' method='get'>
Configuration Name: <input type='text' name='confname'>
</center>
<i>Character Skills:</i>
<br>
<table>
<tr><td>Chronicle:</td><td><select name='chronicle'>
<option value='1'>Interlude</option>
<option value='2'>Kamael</option>
<option value='3'>Hellbound</option>
<option value='4'>Gracia</option>
<option value='5'>Gracia2</option>
<option value='6'>Gracia Final</option>
<option value='7'>Gracia Epilogue</option>
</select>
</td></tr>
</table>
<table>
<tr><td><u>Custom skills</u></td></tr>
<tr><td><b>#</b></td><td><b>Skill ID:</b></td><td><b>Skill Level:</b></td><td><b>Skill Name:</b></td></tr>
";

if(!isset($_SESSION['more'])){
$_SESSION['more'] = '3';
}

if(isset($_GET['more']) && $_GET['more'] == '1'){
$_SESSION['more'] += '1';
}
if(isset($_GET['more']) && $_GET['more'] == '0'){
$_SESSION['more'] -= '1';
}
if(isset($_GET['more']) && $_GET['more'] == '2'){
$_SESSION['more'] = '3';
}

$newsk = $_SESSION['more'];

if($newsk == '0'){
$_SESSION['more'] = '1';
$newsk = '1';
}
if($newsk == '31'){
$_SESSION['more'] = '30';
$newsk = '30';
}

for($i = '1'; $i <= $newsk; $i++){
echo "<tr><td>$i</td><td><input type='text' name='skillid$i'></td><td><input type='text' name='level$i'></td><td><input type='text' name='skillname$i'></td></tr>";
}

echo "</table>
<a href='?more=1'>Add one more new skill field</a>
<a href='?more=0'>Remove one new skill field</a>
<a href='?more=2'>Reset all skill fields</a>
</table>
<br><br>
<i>DataBase Structure:</i>
<br><br>
<table align='left'>
<tr><td><u>Character Table</u></td></tr>
<tr><td>Table Name:</td><td><input type='text' name='tablechar' value='characters'></td></tr>
<tr><td> </td><td> </td></tr>
<tr><td>Id:</td><td><input type='text' name='charid' value='obj_Id'></td></tr>
<tr><td>Name:</td><td><input type='text' name='charname' value='char_name'></td></tr>
<tr><td>Level:</td><td><input type='text' name='charlevel' value='level'></td></tr>
<tr><td>Exp:</td><td><input type='text' name='charexp' value='exp'></td></tr>
<tr><td>Class Id:</td><td><input type='text' name='charclass' value='classid'></td></tr>
<tr><td>Base Class:</td><td><input type='text' name='charbase' value='base_class'></td></tr>
</table>

<table align='right'>
<tr><td>
<table>
<tr><td><u>Char. Skills Table</u></td></tr>
<tr><td>Table Name:</td><td><input type='text' name='tableskills' value='character_skills'></td></tr>

<tr><td>Skill Name Row:</td><td><select name='skillname'><option value='1'>Yes</option><option value='0'>No</option></td></tr>
<tr><td><hr></td><td><hr></td></tr>
</table>

<table>
<tr><td><u>Character Buffs Table</u></td></tr>
<tr><td>Table Name:</td><td><input type='text' name='tablebuffs' value='character_skills_save'></td></tr>
<tr><td><hr></td><td><hr></td></tr>
</table>

<table>
<tr><td><u>Char. Hennas Table</u></td></tr>
<tr><td>Table Name:</td><td><input type='text' name='tablehennas' value='character_hennas'></td></tr>

</table>

</td></tr></table>

<center><input type='submit' name='submit' value='Create Configuration'></center>
</form>
";
}




mysql_close();
?>

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Posts

    • L2Avalon launches February 20 High Five project (Salvation client) focused on classic world progression — not instance spam and not “twink” metas. What is L2Avalon? L2Avalon is built around real Lineage 2 gameplay: farming spots, open world conflict, raids, epics, economy and competition. No Kamael Reduced instanced content **Discord:** https://discord.gg/NbM2cXmAem 🌐 **Website:** https://l2avalon.net Balance & Economy Every class is tuned to be viable in PvE and PvP Off-meta classes get buffed instead of adding power-creep garbage Adena-based economy Farming matters: boosted Drop/Spoil for each stage of progression Rates & Settings Dynamic XP: 50x (Lv 1–40) → 1x (Lv 78+) Staged progression with new content unlocking weekly Adena / Drop / Spoil: 3x / 5x / 5x NPC Buffer: 2 hours (Premium: 3 hours) Box limit: 2+1 windows per PC MP potion: 1000 MP, 10s cooldown Free2Play System (earn Donate Coins by playing) You don’t have to donate to progress. Donate Coins drop in-game, so everything is achievable through playtime and activity. Where Donate Coins drop: Mobs Lv 76+, Raid Bosses Lv 70+, Epic Bosses Auto-farm (controlled) Limit: only 1 window can use auto-farm at the same time Daily time: 1 hour/day without Premium Extra tickets: purchasable with PC Bang points (earned by being online) Disabled zones: CC / IT / FOG / VARKA / KETRA Equipment Changes Reworked set bonuses Reworked SA system Enchanted set bonuses Enchanted shirt bonuses Fake Epic jewelry (weakened alternative) Skills (High Five mechanics) New skills added Old skills updated New enchant branches + updated existing ones Subclass skills Clan skills Daily Activities (solo-friendly) Events / Missions / Instances Stages Soon — stage schedule and weekly unlocks will be published February 20 — we start. **Discord:** https://discord.gg/NbM2cXmAem 🌐 **Website:** https://l2avalon.net
    • Hello MxC community, i want to buy client dev / patch maker services for the client of salvation. Im using L2jeternity multiprotocol (h5-salvation 140). I want a Patch full optimized for the h5 content. Everything that is not needed must be removed, as well as some textures like maps for example should be also adjusted to h5 content. If you know anyone that can take the job feel free to contact me here or in Discord. Only professional work.   Discord: ch4osroxas   Thank you very much!
    • Hi dude, i`m in the same way of nawaro, leaning how to edit interfaces, could u help me too?
    • General Trackers :   IPTorrents invite IPTorrents account 1 tb TorrentLeech invite Torrentleech account 1 tb buffer  InTheShaDow ( ITS ) account Acid-lounge invite Torrentday invite Crnaberza account Abn.Lol account Limit-of-eden account Norbits account Xspeeds account Xspeeds invite Bemaniso invite Wigornot account Bithumen invite Filelist account Funfile invite AvistaZ invite Potuk.net invite ResurrectThe.Net invite GrabThe.Info invite Greek-Team invite LinkoManija invite Fano.in account tracker.czech-server.com Speed.cd invite Arab-torrents.net account Arabscene.me account Scenetime account 4thd.xyz invite Btarg.com.ar account Dedbit invite Estone.cc account Speedapp invite Finvip invite Fluxzone account GigaTorrents account Gimmepeers account Haidan.video invite Mojblink account Mycarpathians invite Newinsane.info account Oscarworld.xyz account Peers.FM invite Pt.msg.vg account Ransackedcrew account Redemption invite Scene-rush account Seedfile.io invite Teracod invite Torrent.ai account Torrentmasters invite Ttsweb invite X-files invite X-ite invite Ncore account TorrentHR account Rptorrents account BwTorrents account Superbits invite Krazyzone account Immortalseed account Tntracker invite Pt.eastgame.org account Bitturk account Rstorrent account Tracker.btnext invite Torrent-turk.de account BeiTai.PT account Pt.keepfrds account 52pt.site account Pthome account Torrentseeds account Aystorrent account Blues-brothers.biz invite Divteam account Thesceneplace invite CinemaMovies.pl account Brasiltracker account Patiodebutacas account Newheaven.nl account  Swarmazon.club invite Bc-reloaded account Crazyspirits account Silentground invite Omg.wtftrackr invite Milkie.cc invite Breathetheword invite Madsrevolution account Chilebt account Yubraca account Uniongang.tv account Frboard account Exvagos account Diablotorrent account Microbit account Carp-hunter.hu account Majomparade.eu account Theshinning.me account Youiv.info account Dragonworld-reloaded account Sharewood.tv account Partis.si account Digitalcore.club invite Fuzer.me account R3vuk.wtf invite Ztracker account 1 tb buffer 3changtrai account Best-core.info account Bitsite.us account Eliteunitedcrew invite Exitorrent.org account Tophos invite Torrent.lt account Sktorrent.eu account Oshen account Blackhattorrent account Pirata.digital account Esharenet account Ohmenarikgi.la Pirate-share account Immortuos account Kiesbits account Cliente.amigos-share.club account Broadcity invite Ilovetorzz account Torrentbytes account Polishsource account Portugas invite Shareisland account ArabaFenice account Hudbt.hust.edu.cn account Audiences account Nanyangpt account Pt.sjtu.edu.cn account Pt.zhixing.bjtu.edu.cn account Byr.pt invite Ptfiles invite Red-bits account Pt.hdpost.top account Irrenhaus.dyndns.dk (NewPropaganda) account Mnvv2.info (MaxNewVision V2) account 1ptba.com account Spidertk.top account Film-paleis account Generation-free account Aftershock-tracker account Twilightsdreams account Back-ups.me invite Sor-next.tk ( Spirit Of Revolution ) account Tfa.tf ( The Falling Angels ) account Hdmayi account S-f-p.dyndns.dk ( Share Friends Projekt ) account Unlimitz.biz account Pttime account St-tracker.eu account New-retro.eu account Zbbit account Tigers-dl.net account Jptvts.us account Lat-team account Club.hares.top account Falkonvision-team account Concen account Drugari account T.ceskeforum account Peeratiko.org account Zamunda.se account Central-torrent.eu account h-o-d.org account Torrentleech.pl account Demonoid invite Lst.gg account Fakedoor.store account LaidBackManor account Vrbsharezone.co.uk invite Torrenteros account Arenaelite account Datascene account Tracker.0day.community Tapochek.net invite Ptchina invite Lesaloon account Exyusubs account Therebels.tv account Ubits.club invite Zmpt.cc account Turktorrent.us account Dasunerwarte account Hawke.uno account Monikadesign account Fearnopeer account Alpharatio account Wukongwendao.top account Chinapyg account Azusa.wiki account Yggtorrent.top account Torrentdd account Cyanbug.net invite Hhanclub.top account Wintersakura.net account Xthor account Tctg.pm account Finelite invite Agsvpt.com account Pt.0ff.cc invite Qingwapt.com account Xingtan.one account Ptcafe.club invite Theoldschool.cc account W-o-t.pro account Coastal-crew.bounceme.net account Darkpeers.org account Pianyuan.org account Seedpool.org  account Tempelbox account Pt.itzmx.com account Capybarabr.com account Itatorrents.xyz  account Letseed.org account The-new-fun.com  account Malayabits.cc account Trellas.me account Yu-scene.net account Futuretorrent.org account Bitpt.cn account Tocashare.biz  account Videoteka.org  account White-angel.hu account Xbytesv2.li account   Movies Trackers :   Anthelion account Pixelhd account Cinemageddon account DVDSeed account Cinemageddon account Cinemaz account Retroflix account Classix-unlimited - invite Movie-Torrentz (m2g.link) invite Punck-tracker.net account Tmghub account Tb-asian account Cathode-ray.tube account Greatposterwall account Telly account Arabicsource.net account Upload.cx account Crabpt.vip invite Onlyencodes.cc account Exyusubs account Hellashut.net invite Nordichd.sytes.net invite Locadora.cc account   HD Trackers :   Blutopia buffered account Hd-olimpo buffered account Hdf.world account Torrentland.li account HdSky account Hdchina account Chdbits account Totheglory account Hdroute account Hdhome account TorrentCCF aka et8.org account 3DTorrents invite HD-Torrents account Bit-HDTV account HDME.eu invite Hdarea.co account Asiancinema.me account JoyHD invite HDSpace invite CrazyHD invite Bluebird-hd invite Htpt.cc account Hdtime invite Ourbits.club account Hd4fans account Siambit account Privatehd account Springsunday account Tjupt account Hdcity.leniter invite Ccfbits account Discfan account Pt.btschool.club account Ptsbao.club invite Hdzone.me invite Danishbytes account Zonaq.pw account Tracker.tekno3d account Arabp2p account Hd-united account Reelflix.xyz account Hdatmos.club account Anasch.cc invite Tigris-t account Nethd.org account Hd.ai invite Hitpt.com account Hdmonkey account Dragonhd.xyz account Hdclub.eu account Forum.bluraycd.com account Carpt account Hdfun.me invite Pt.hdupt invite Puntotorrent account Ultrahd account Rousi.zip account Bearbit account Hdturk.club account Asiandvdclub account Star-space.net account Nordicq.org account Hdkyl.in account Utp.to account Music Trackers : Dicmusic account Music-Vid account Open.cd account LzTr account ProAudioTorrents invite Jpopsuki invite TranceTraffic invite Audionews invite Kraytracker invite Libble.me invite Losslessclub invite Indietorrents.com invite Dimeadozen account Funkytorrents invite Karaokedl account zombtracker.the-zomb account Concertos account Sugoimusic account Satclubbing.club invite Metal.iplay invite Psyreactor invite Panda.cd account Adamsfile account Freehardmusic account Tracker.hqmusic.vn accouunt Twilightzoom account 3 tb buffer Hiresmusic account Metalguru account Musictorrents.org account Musebootlegs.com invite Zappateers.com account Jungleland.dnsalias.com account Naftamusic account   E-Learning Trackers :   Thevault account BitSpyder invite Brsociety account Learnbits invite Myanonamouse account Libranet account 420Project account Learnflakes account Pt.soulvoice.club account P2pelite account Aaaaarg.fail invite Ebooks-shares.org account Abtorrents account Pt.tu88.men invite Docspedia.world invite   TV-Trackers :   Skipthecommericals Cryptichaven account TV-Vault invite Shazbat.TV account Myspleen account Tasmanit.es invite Tvstore.me account Tvchaosuk account Jptv.club account Tvroad.info   XXX - Porn Trackers :   FemdomCult account Pornbay account Pussytorrents account Adult-cinema-network account Bootytape account 1 Tb buffer Exoticaz account Bitporn account Kufirc account Gaytorrent.ru invite Nicept account Gay-torrents.org invite Ourgtn account Pt.hdbd.us account BitSexy account Happyfappy.org account Kamept.com account Lesbians4u.org account   Gaming Trackers :   Mteam.fr account BitGamer invite Retrowithin invite Gamegamept account   Cartoon/Anime/Comic Trackers :   Animeworld account Oldtoons.world account U2.dmhy account CartoonChaos invite Animetorrents account Mononoke account Totallykids.tv account Bakabt.me invite Revanime account Ansktracker account Tracker.shakaw.com.br invite Bt.mdan.org account Skyey2.com account Animetracker.cc Adbt.it.cx invite Tracker.uniotaku.com account Mousebits.com account   Sports Trackers :   MMA-Tracker invite T3nnis.tv invite AcrossTheTasman account RacingForMe invite Sportscult invite Ultimatewrestlingtorrents account Worldboxingvideoarchive invite CyclingTorrents account Xtremewrestlingtorrents account Tc-boxing invite Mma-torrents account Aussierul invite Xwt-classics account Racing4everyone account Talk.tenyardtracker account Stalker.societyglitch invite Extremebits invite Rgfootball.net account F1carreras.xyz account   Software/Apps Trackers :   Brokenstones account Appzuniverse invite Teamos.xyz account Macbb.org account   Graphics Trackers:   Forum.Cgpersia account Gfxpeers account Forum.gfxdomain account   Documentary Trackers:   Forums.mvgroup account   Others   Fora.snahp.eu account Board4all.biz account Filewarez.tv account Makingoff.org/forum account Xrel.to account Undergunz.su account Corebay account Endoftheinter.net ( EOTI ) account Thismight.be invite Skull.facefromouter.space account Avxhm.se (AvaxHome) account Ssdforum account Notfake.vip account Intotheinter.net account Tildes.net invite Thetoonz account Usinavirtual account Hdclasico invite HispaShare account Valentine.wtf account Adit-hd account Forum-andr.net account Warezforums account Justanothermusic.site account Forbiddenlibrary.moe account Senturion.to account Movieparadise account Militaryzone account Dcdnet.ru account Sftdevils.net account Heavy-r.com account New-team.org account Ddl.tv account Filewarez.club account Hispamula.org account Hubwarez.tv account   NZB :   Ninjacentral.co.za account Tabula-rasa.pw account Drunkenslug account Drunkenslug invite Usenet-4all account Brothers-of-Usenet account Dognzb.cr invite Kleverig account Nzb.cat account Nzbplanet.net invite Ng4you.com account Nzbsa.co.za account Bd25.eu account NZB.to account Samuraiplace account Abhdtv.net account Abook.link account Comix.pw account House-of-usenet Secretbinaries.net account Vnext.to account Stockboxx.top account Sky-of-use.net account   Prices start from 3 $ to 100 $   Payment methods: Crypto, Neteller, Webmoney, Revolut   If you want to buy something send me a pm or contact me on:   Email: morrison2102@gmail.com   Discord: LFC4LIFE#4173   Telegram: https://t.me/LFC4LIFE4173   Skype: morrison2102@hotmail.com
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock