michael9ufo

brainless guy, just don't make me to cross the Danube river and beat you like a chicken!

I think you must be punished. so many bumps

1 system sold already.

if you want auto donate/auto vote/full secured register with change/recover functions + map castle control/top pvp/online players and soon armorry system just pm me. ( very cheap ) . Ps: script it's fully configurable, multi-language option and much more.

are you sure? get lost

Updated.

How the title says I sell license of an automatically vote reward system.(Item auto send in game after the player reach an amount of votes) Note*: Everything easy configurable. Price: 15 euros with source. Contact me. For Demo pm me.

create a file ex: index.php then add inside: you can add html code here <?php php code here echo " YOU CAN ADD HTML CODE HERE "; // html code must not include "" , it must include '' ?> YOU CAN ADD HTML CODE HERE ETC <?php PHP CODE HERE ?> this is the format... no limits... or inside you can include another page like: <?php include 'pagelink.html'; ?>

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

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

when you change level in npcdata you must change exp=xx too

dami add pe michael9ufo@yahoo.co.uk si iti explic eu mai multe:)

no, you need an windows server x64 to make l2off server work.

share your armor table design to help you:)

try user ' sa ' w/o quotes or/and database host: localhost

contact me at michael9ufo@yahoo.co.uk :)

pretty nice forum design for a l2j project.Keep up and I wish you GL

why are you guys trying to steal other work?You think the one who make scripts it's noob/retard and you guys are smart? Take a life...

C4 really rullz but an Interlude would attract more ppls. ( noobs don't even have c4 client ). About rates Low ( 10-15x ) because so much customs means a fastly boredom on players brain. So a server with less noobs means much more fun, like on official(there are some noobs too) but the difference between noobs and pro players it's like 80% pro 20% noobs not 20% pro 80% noobs like on so many servers. I know that some ppls will gonna flame me but if you don't played official you better shut up. This is my opinion. Thanks!

I can help the server with: - Server Sripter - Client Editor - Web Developer - Romanian Translator Pm me if interested.

I know but for that persons who don't know how to create & set privileges to a user what they do? and btw someday while I was searching on a forum(I don't tell the name) I found a top pk/pvp script , specially made to be vulnerable at sql inject.so..

ofc this is why I don't inserted www.hetzner.de in the list ( which it's almost the best/cheap company for l2java servers )

Updated: Face Direction Possible Values: - North(N) : 49152 - South(S) : 16384 - West(W) : 32768 - East(E) : 65536 - NE = (N + E)/2 = (49152 + 65536)/2 = 57344 - NW = (N + W)/2 = (49152 + 32768)/2 = 40960 - WS = (W + S)/2 = (32768 + 16384)/2 = 24576 - SE = (S + E)/2 = (16384 + 65536)/2 = 40960

Here it's a list where you can find some good hosting companies for your own server. - www.serverloft.com - www.worldstream.nl (Intel Xeon Servers) - www.ovh.com - www.ovh.co.uk - www.ngz-server.de (Root Server Medium Intel) If you know other good hosting companies don't hesitate to reply them here.

After you're done with this guide [Guide]How To Make PHP Ready For Mssql Connection , create a file on your webserver with php extension then insert the next code inside: <?php // Credits to me // Sript Configuration $type = "1"; // 1 for top PVP, 2 for top PK $count = "10"; // Top Limit Players( Ex Top 10 PvP/Pk) // DataBase Connection Informations $host = "localhost"; // DataBase Host: Default: localhost $user = "sa"; // DataBase User: Default: sa $password = "yourpassword"; // DataBase Password $database = "lin2world"; // Database Name: Default: lin2world if($type == "1"){ $type = "Duel"; } elseif($type == "2"){ $type = "PK"; } else{ echo "<font color='red'>Invalid Type!</font>"; } if($type == '1' || $type == '2'){ $dbconn = mssql_connect($host, $user, $password) or die("Connection to $host cannot be reached."); $dbslect = mssql_select_db($database, $dbconn) or die("The database $database can't be opened."); 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; } if(!is_int_val($count) || $count < '1'){ echo "<font color='red'>Invalid Count Data</font>"; } else{ $select = "SELECT Duel,PK,char_name FROM user_data WHERE $type >='0' ORDER BY $type DESC LIMIT $count;"; $query = mssql_query($select); if($type == '1'){ $type = "PvP's"; $type2 = '0'; } elseif($type == '2'){ $type = "PK's"; $type2 = '1'; } echo "<table align='center' border='1'><tr><td><b>#</b></td><td><b>Name</b></td><td><b>$type</b></td></tr>"; $i = '1'; while($row=mssql_fetch_row($query)){ $charname = htmlspecialchars($row[2]); echo "<tr><td>$i</td><td>$row[2]</td><td>$row[$type2]</td></tr>"; $i++; } echo "</table>"; } mssql_close($dbconn); } ?>