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
Afs-cms
- Thread starter Avarian
- Start date
- Status
OP
OP
Avarian
Bring Out Your Dead!
ragal
Member
Have starting to work on Namelock Feature + Advanced ban system ? 
OP
OP
Avarian
Bring Out Your Dead!
I put it on the back burner because TFS 0.2.9 ban system was bugged so I couldn't see how it worked, i'll start working on it again soon.
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());
}
OP
OP
Avarian
Bring Out Your Dead!
I'll create one that allows for 14 starting vocations and send it to you.
OP
OP
Avarian
Bring Out Your Dead!
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 ?
You only visit the installer if your a new user. If your trying to update from one version to another you need to use sql_updater.php
Yeah i like this alot
Thanks ^_^
OP
OP
Avarian
Bring Out Your Dead!
Released v0.2.2
Lol you dont install and then update, if your not using a previous release of AFS-CMS then you install, if you are then you use SQL-Updater.
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
Lol you dont install and then update, if your not using a previous release of AFS-CMS then you install, if you are then you use SQL-Updater.
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".
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".
Ronaldino
Esso Eh
- Joined
- Dec 25, 2007
- Messages
- 745
- Reaction score
- 0
Omg... xDDDD just forget about it because you cant add this.
btw. there are 4* layouts now.
OP
OP
Avarian
Bring Out Your Dead!
Your still using that old of a release o_o I'll throw something together later tonight so you can update..just try and stay more update from now on lol.
It's not that easy to add a new layout, send it to me and i'll work on adding it for you.
- Status
Similar threads
