ragal
Member
You have Run http://127.0.0.1/install.php ?????
when not do this and u will able to log in
when not do this and u will able to log in
ty for blackdraft layout ;*
nice release, I like it.
// Vocation 10 settings.
elseif($vocin == 10) {
mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, lookaddons, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$voc[1]['hp']. "', '" .$voc[1]['hp']. "', '$startexp','95','95','95','95','3', '" .$voc[1]['mag']. "', '" .$voc[1]['mana']. "', '" .$voc[1]['mana']. "', '$townin', '0', '0', '0', '0', '" .$voc[1]['cap']. "', '" .$voc[1]['soul']. "', '$sexin')") or die(mysql_error());
if($sexin == 0)
{
mysql_query("UPDATE players SET looktype = '279' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($sexin == 1)
{
mysql_query("UPDATE players SET looktype = '278' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
if($townin == 1)
{
mysql_query("UPDATE players SET posx = '".$town[2]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[2]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[2]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 2)
{
mysql_query("UPDATE players SET posx = '".$town[2]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[2]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[2]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 3)
{
mysql_query("UPDATE players SET posx = '".$town[3]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[3]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[3]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 4)
{
mysql_query("UPDATE players SET posx = '".$town[4]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[4]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[4]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 5)
{
mysql_query("UPDATE players SET posx = '".$town[5]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[5]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[5]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 6)
{
mysql_query("UPDATE players SET posx = '".$town[6]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[6]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[6]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 7)
{
mysql_query("UPDATE players SET posx = '".$town[7]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[7]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[7]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 8)
{
mysql_query("UPDATE players SET posx = '".$town[8]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[8]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[8]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
}
elseif($townin == 9)
{
mysql_query("UPDATE players SET posx = '".$town[9]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posy = '".$town[9]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error());
mysql_query("UPDATE players SET posz = '".$town[9]['z']."' WHERE (`name` = '".$namein."') ") 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','" .$voc[1]['helmet']. "','1')";
$item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$voc[1]['necklace']. "','1')";
$item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$voc[1]['bag']. "','1')";
$item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$voc[1]['armor']. "','1')";
$item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$voc[1]['lhand']. "','1')";
$item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$voc[1]['rhand']. "','1')";
$item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$voc[1]['legs']. "','1')";
$item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$voc[1]['boots']. "','1')";
$item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$voc[1]['ammo']. "','" .$voc[1]['amount']. "')";
$skills1 = "UPDATE player_skills SET value = '".$voc[1]['fist']."' WHERE (player_id = '".$playerid."')";
$skills2 = "UPDATE player_skills SET value = '".$voc[1]['club']."' WHERE (player_id = '".$playerid."')";
$skills3 = "UPDATE player_skills SET value = '".$voc[1]['sword']."' WHERE (player_id = '".$playerid."')";
$skills4 = "UPDATE player_skills SET value = '".$voc[1]['axe']."' WHERE (player_id = '".$playerid."')";
$skills5 = "UPDATE player_skills SET value = '".$voc[1]['dist']."' WHERE (player_id = '".$playerid."')";
$skills6 = "UPDATE player_skills SET value = '".$voc[1]['shield']."' WHERE (player_id = '".$playerid."')";
$skills7 = "UPDATE player_skills SET value = '".$voc[1]['fish']."' WHERE (player_id = '".$playerid."')";
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());
mysql_query($skills1) or die(mysql_error());
mysql_query($skills2) or die(mysql_error());
mysql_query($skills3) or die(mysql_error());
mysql_query($skills4) or die(mysql_error());
mysql_query($skills5) or die(mysql_error());
mysql_query($skills6) or die(mysql_error());
mysql_query($skills7) or die(mysql_error());
}
Is there any way to increase the limit of vocations? I need 14 vocations, already set it up to be aviable in the character config and the vocation selecting menu, but when a player selects voc 10 he'll be voc 9
Code:// Vocation 10 settings. elseif($vocin == 10) { mysql_query("INSERT INTO players(name, account_id, level, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, lookaddons, maglevel, mana, manamax, town_id, posx, posy, posz, conditions, cap, soul, sex) values('$namein', '$acc_logged', '$startlvl', '3', '" .$voc[1]['hp']. "', '" .$voc[1]['hp']. "', '$startexp','95','95','95','95','3', '" .$voc[1]['mag']. "', '" .$voc[1]['mana']. "', '" .$voc[1]['mana']. "', '$townin', '0', '0', '0', '0', '" .$voc[1]['cap']. "', '" .$voc[1]['soul']. "', '$sexin')") or die(mysql_error()); if($sexin == 0) { mysql_query("UPDATE players SET looktype = '279' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($sexin == 1) { mysql_query("UPDATE players SET looktype = '278' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } if($townin == 1) { mysql_query("UPDATE players SET posx = '".$town[2]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[2]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[2]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 2) { mysql_query("UPDATE players SET posx = '".$town[2]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[2]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[2]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 3) { mysql_query("UPDATE players SET posx = '".$town[3]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[3]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[3]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 4) { mysql_query("UPDATE players SET posx = '".$town[4]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[4]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[4]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 5) { mysql_query("UPDATE players SET posx = '".$town[5]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[5]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[5]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 6) { mysql_query("UPDATE players SET posx = '".$town[6]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[6]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[6]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 7) { mysql_query("UPDATE players SET posx = '".$town[7]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[7]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[7]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 8) { mysql_query("UPDATE players SET posx = '".$town[8]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[8]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[8]['z']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); } elseif($townin == 9) { mysql_query("UPDATE players SET posx = '".$town[9]['x']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posy = '".$town[9]['y']."' WHERE (`name` = '".$namein."') ") or die(mysql_error()); mysql_query("UPDATE players SET posz = '".$town[9]['z']."' WHERE (`name` = '".$namein."') ") 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','" .$voc[1]['helmet']. "','1')"; $item2 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','2','2','" .$voc[1]['necklace']. "','1')"; $item3 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','3','3','" .$voc[1]['bag']. "','1')"; $item4 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','4','4','" .$voc[1]['armor']. "','1')"; $item5 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','5','5','" .$voc[1]['lhand']. "','1')"; $item6 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','6','6','" .$voc[1]['rhand']. "','1')"; $item7 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','7','7','" .$voc[1]['legs']. "','1')"; $item8 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','8','8','" .$voc[1]['boots']. "','1')"; $item10 = "INSERT INTO player_items(player_id, pid, sid, itemtype, count) values('$playerid','10','10','" .$voc[1]['ammo']. "','" .$voc[1]['amount']. "')"; $skills1 = "UPDATE player_skills SET value = '".$voc[1]['fist']."' WHERE (player_id = '".$playerid."')"; $skills2 = "UPDATE player_skills SET value = '".$voc[1]['club']."' WHERE (player_id = '".$playerid."')"; $skills3 = "UPDATE player_skills SET value = '".$voc[1]['sword']."' WHERE (player_id = '".$playerid."')"; $skills4 = "UPDATE player_skills SET value = '".$voc[1]['axe']."' WHERE (player_id = '".$playerid."')"; $skills5 = "UPDATE player_skills SET value = '".$voc[1]['dist']."' WHERE (player_id = '".$playerid."')"; $skills6 = "UPDATE player_skills SET value = '".$voc[1]['shield']."' WHERE (player_id = '".$playerid."')"; $skills7 = "UPDATE player_skills SET value = '".$voc[1]['fish']."' WHERE (player_id = '".$playerid."')"; 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()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); }
Hello Guys, I get this msg when i try to install.php
Could not add guildstory field!Duplicate column name 'guildstory'
and I started the server but cant log in with any chars
can someone please help me out ?
Yeah i like this alot Good Work
I installed and then tried to update it and it says, It can not be updated to 2.1.
Thanks for the fast reply also
I got an important question about your AAC.
I know there are 3 layouts. I tryed to add a new one. I downloaded it from freetemplates.org and pasted the folder in "Layouts" I also added the PHP Files from "thegathering" in the folder with my new skin. But it does not work. There comes a white site with "Home".
Avarian~ I cant update to this version because in sql_updater latest update is from 1.8... I got 1.6 xd
Please make for older version...
###
Correct the guild list because I must scroll down to see list..
I got an important question about your AAC.
I know there are 3 layouts. I tryed to add a new one. I downloaded it from freetemplates.org and pasted the folder in "Layouts" I also added the PHP Files from "thegathering" in the folder with my new skin. But it does not work. There comes a white site with "Home".