// No voc settings.
if($vocin == 0) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '0', '" .$novoc['hp']. "', '" .$novoc['hp']. "', '$startexp', '" .$novoc['mag']. "', '" .$novoc['mana']. "', '" .$novoc['mana']. "', '$townin', '".$rook_spawn_x."', '".$rook_spawn_y."', '".$rook_spawn_z."', '0', '" .$novoc['cap']. "', '" .$novoc['lookbody']. "', '" .$novoc['lookfeet']. "', '" .$novoc['lookhead']. "', '" .$novoc['looklegs']. "', '" .$novoc['looktype']. "', '" .$novoc['lookaddons']. "', '" .$novoc['soul']. "', '$sexin')") or die(mysql_error());
$query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error());
while($sql2 = mysql_fetch_array($query2))
{
$playerid = $sql2['id'];
}
$item1 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','1','1','" .$novoc_helm['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$novoc_neck['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$novoc_bag['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$novoc_armor['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$novoc_lhand['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$novoc_rhand['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$novoc_legs['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$novoc_boots['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$novoc_ammo['ammo']. "','" .$novoc_amount['novoc_amount']. "')";
mysql_query($item1) or die(mysql_error());
mysql_query($item2) or die(mysql_error());
mysql_query($item3) or die(mysql_error());
mysql_query($item4) or die(mysql_error());
mysql_query($item5) or die(mysql_error());
mysql_query($item6) or die(mysql_error());
mysql_query($item7) or die(mysql_error());
mysql_query($item8) or die(mysql_error());
mysql_query($item10) or die(mysql_error());
}
// Sorcerer settings.
elseif($vocin == 1) {
if($townin == 1) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town1_spawn_x. "', '" .$town1_spawn_y. "', '" .$town1_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 2) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town2_spawn_x. "', '" .$town2_spawn_y. "', '" .$town2_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 3) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town3_spawn_x. "', '" .$town3_spawn_y. "', '" .$town3_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 4) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town4_spawn_x. "', '" .$town4_spawn_y. "', '" .$town4_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 5) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town5_spawn_x. "', '" .$town5_spawn_y. "', '" .$town5_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 6) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town6_spawn_x. "', '" .$town6_spawn_y. "', '" .$town6_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 7) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town7_spawn_x. "', '" .$town7_spawn_y. "', '" .$town7_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 8) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town8_spawn_x. "', '" .$town8_spawn_y. "', '" .$town8_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 9) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '1', '" .$sorc['hp']. "', '" .$sorc['hp']. "', '$startexp', '" .$sorc['mag']. "', '" .$sorc['mana']. "', '" .$sorc['mana']. "', '$townin', '" .$town9_spawn_x. "', '" .$town9_spawn_y. "', '" .$town9_spawn_z. "', '0', '" .$sorc['cap']. "', '" .$sorc['lookbody']. "', '" .$sorc['lookfeet']. "', '" .$sorc['lookhead']. "', '" .$sorc['looklegs']. "', '" .$sorc['looktype']. "', '" .$sorc['lookaddons']. "', '" .$sorc['soul']. "', '$sexin')") or die(mysql_error());
}
$query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error());
while($sql2 = mysql_fetch_array($query2))
{
$playerid = $sql2['id'];
}
$item1 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','1','1','" .$sorc_helm['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$sorc_neck['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$sorc_bag['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$sorc_armor['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$sorc_lhand['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$sorc_rhand['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$sorc_legs['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$sorc_boots['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$sorc_ammo['ammo']. "','" .$sorc_amount['sorc_amount']. "')";
mysql_query($item1) or die(mysql_error());
mysql_query($item2) or die(mysql_error());
mysql_query($item3) or die(mysql_error());
mysql_query($item4) or die(mysql_error());
mysql_query($item5) or die(mysql_error());
mysql_query($item6) or die(mysql_error());
mysql_query($item7) or die(mysql_error());
mysql_query($item8) or die(mysql_error());
mysql_query($item10) or die(mysql_error());
}
// Druid settings.
elseif($vocin == 2) {
if($townin == 1) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town1_spawn_x. "', '" .$town1_spawn_y. "', '" .$town1_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 2) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town2_spawn_x. "', '" .$town2_spawn_y. "', '" .$town2_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 3) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town3_spawn_x. "', '" .$town3_spawn_y. "', '" .$town3_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 4) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town4_spawn_x. "', '" .$town4_spawn_y. "', '" .$town4_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 5) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town5_spawn_x. "', '" .$town5_spawn_y. "', '" .$town5_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 6) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town6_spawn_x. "', '" .$town6_spawn_y. "', '" .$town6_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 7) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town7_spawn_x. "', '" .$town7_spawn_y. "', '" .$town7_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 8) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town8_spawn_x. "', '" .$town8_spawn_y. "', '" .$town8_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 9) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '2', '" .$druid['hp']. "', '" .$druid['hp']. "', '$startexp', '" .$druid['mag']. "', '" .$druid['mana']. "', '" .$druid['mana']. "', '$townin', '" .$town9_spawn_x. "', '" .$town9_spawn_y. "', '" .$town9_spawn_z. "', '0', '" .$druid['cap']. "', '" .$druid['lookbody']. "', '" .$druid['lookfeet']. "', '" .$druid['lookhead']. "', '" .$druid['looklegs']. "', '" .$druid['looktype']. "', '" .$druid['lookaddons']. "', '" .$druid['soul']. "', '$sexin')") or die(mysql_error());
}
$query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error());
while($sql2 = mysql_fetch_array($query2))
{
$playerid = $sql2['id'];
}
$item1 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','1','1','" .$druid_helm['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$druid_neck['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$druid_bag['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$druid_armor['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$druid_lhand['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$druid_rhand['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$druid_legs['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$druid_boots['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$druid_ammo['ammo']. "','" .$druid_amount['druid_amount']. "')";
mysql_query($item1) or die(mysql_error());
mysql_query($item2) or die(mysql_error());
mysql_query($item3) or die(mysql_error());
mysql_query($item4) or die(mysql_error());
mysql_query($item5) or die(mysql_error());
mysql_query($item6) or die(mysql_error());
mysql_query($item7) or die(mysql_error());
mysql_query($item8) or die(mysql_error());
mysql_query($item10) or die(mysql_error());
}
// Paladin settings.
elseif($vocin == 3) {
if($townin == 1) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town1_spawn_x. "', '" .$town1_spawn_y. "', '" .$town1_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 2) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town2_spawn_x. "', '" .$town2_spawn_y. "', '" .$town2_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 3) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town3_spawn_x. "', '" .$town3_spawn_y. "', '" .$town3_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 4) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town4_spawn_x. "', '" .$town4_spawn_y. "', '" .$town4_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 5) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town5_spawn_x. "', '" .$town5_spawn_y. "', '" .$town5_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 6) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town6_spawn_x. "', '" .$town6_spawn_y. "', '" .$town6_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 7) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town7_spawn_x. "', '" .$town7_spawn_y. "', '" .$town7_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 8) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town8_spawn_x. "', '" .$town8_spawn_y. "', '" .$town8_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 9) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$paladin['hp']. "', '" .$paladin['hp']. "', '$startexp', '" .$paladin['mag']. "', '" .$paladin['mana']. "', '" .$paladin['mana']. "', '$townin', '" .$town9_spawn_x. "', '" .$town9_spawn_y. "', '" .$town9_spawn_z. "', '0', '" .$paladin['cap']. "', '" .$paladin['lookbody']. "', '" .$paladin['lookfeet']. "', '" .$paladin['lookhead']. "', '" .$paladin['looklegs']. "', '" .$paladin['looktype']. "', '" .$paladin['lookaddons']. "', '" .$paladin['soul']. "', '$sexin')") or die(mysql_error());
}
$query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error());
while($sql2 = mysql_fetch_array($query2))
{
$playerid = $sql2['id'];
}
$item1 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','1','1','" .$paladin_helm['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$paladin_neck['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$paladin_bag['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$paladin_armor['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$paladin_lhand['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$paladin_rhand['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$paladin_legs['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$paladin_boots['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$paladin_ammo['ammo']. "','" .$paladin_amount['paladin_amount']. "')";
mysql_query($item1) or die(mysql_error());
mysql_query($item2) or die(mysql_error());
mysql_query($item3) or die(mysql_error());
mysql_query($item4) or die(mysql_error());
mysql_query($item5) or die(mysql_error());
mysql_query($item6) or die(mysql_error());
mysql_query($item7) or die(mysql_error());
mysql_query($item8) or die(mysql_error());
mysql_query($item10) or die(mysql_error());
}
// Knight settings.
elseif($vocin == 4) {
if($townin == 1) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town1_spawn_x. "', '" .$town1_spawn_y. "', '" .$town1_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 2) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town2_spawn_x. "', '" .$town2_spawn_y. "', '" .$town2_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 3) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town3_spawn_x. "', '" .$town3_spawn_y. "', '" .$town3_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 4) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town4_spawn_x. "', '" .$town4_spawn_y. "', '" .$town4_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 5) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town5_spawn_x. "', '" .$town5_spawn_y. "', '" .$town5_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 6) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town6_spawn_x. "', '" .$town6_spawn_y. "', '" .$town6_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 7) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town7_spawn_x. "', '" .$town7_spawn_y. "', '" .$town7_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 8) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town8_spawn_x. "', '" .$town8_spawn_y. "', '" .$town8_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
if($townin == 9) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, soul, sex) values('$namein', '$acc_logged', '$startlvl', '4', '" .$knight['hp']. "', '" .$knight['hp']. "', '$startexp', '" .$knight['mag']. "', '" .$knight['mana']. "', '" .$knight['mana']. "', '$townin', '" .$town9_spawn_x. "', '" .$town9_spawn_y. "', '" .$town9_spawn_z. "', '0', '" .$knight['cap']. "', '" .$knight['lookbody']. "', '" .$knight['lookfeet']. "', '" .$knight['lookhead']. "', '" .$knight['looklegs']. "', '" .$knight['looktype']. "', '" .$knight['lookaddons']. "', '" .$knight['soul']. "', '$sexin')") or die(mysql_error());
}
$query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error());
while($sql2 = mysql_fetch_array($query2))
{
$playerid = $sql2['id'];
}
$item1 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','1','1','" .$knight_helm['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$knight_neck['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$knight_bag['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$knight_armor['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$knight_lhand['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$knight_rhand['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$knight_legs['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$knight_boots['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$knight_ammo['ammo']. "','" .$knight_amount['knight_amount']. "')";
mysql_query($item1) or die(mysql_error());
mysql_query($item2) or die(mysql_error());
mysql_query($item3) or die(mysql_error());
mysql_query($item4) or die(mysql_error());
mysql_query($item5) or die(mysql_error());
mysql_query($item6) or die(mysql_error());
mysql_query($item7) or die(mysql_error());
mysql_query($item8) or die(mysql_error());
mysql_query($item10) or die(mysql_error());