[SHARE]Aio Buffer Creator PhP Source Code

michael9ufo · June 23, 2010

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();
?>

Lelouch · June 23, 2010

Sorry, buuuuuuuuuuut ....

What is this again ?

michael9ufo · June 23, 2010

the source code of http://l2database.org/aiobuffer.php page function

Zappu · June 24, 2010

I know this guy michael9ufo,

is very talented in scripting, php, html... e.t.c

deserve congratulations...

Good Job.

Grim. · June 25, 2010

usefull share

gj man

asdas123 · July 26, 2010

good share ty..

Stive · July 26, 2010

Great share bro!!!Thank you that you are sharing your work here!

Nosti21 · July 26, 2010

thats good..!! thnx very much and keep sharing..!!

[SHARE]Aio Buffer Creator PhP Source Code

Recommended Posts

michael9ufo

Lelouch

michael9ufo

Zappu

Grim.

asdas123

Stive

Nosti21

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store