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

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.

×
×
  • Create New...