Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

[SHARE]Aio Buffer Creator PhP Source Code

michael9ufo
 Share

Recommended Posts

michael9ufo Newbie

michael9ufo

Posted
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...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing


×
×
  • Create New...

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