The Forgotten Server v0.3 beta 1

ffriozi · Dec 6, 2008

hey and about promotion??

Atentador · Dec 6, 2008

Nothing is wrong with the promotions. :O

Endo · Dec 6, 2008

can someone help i cant change any character info on phpmyadmin
Error

SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` !=1 AND `type` !=2 AND `value` = OLD.`id` ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1

jo3bingham · Dec 6, 2008

Endo said:
can someone help i cant change any character info on phpmyadmin
Error

SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` !=1 AND `type` !=2 AND `value` = OLD.`id` ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1

Update your phpMyAdmin (http://otland.net/f258/updating-phpmyadmin-15801/).

Jo3

pierroth · Dec 6, 2008

some1 knows how to fix new quest system and addons?

AGS · Dec 6, 2008

Is it me or addons are not being saved?

When you logout you lose all your addons.

Also, for some reason the sparking rainbow shield doesn't increase speed:
Items.xml

Code:

>	<item id="8908" article="a" name="sparking rainbow shield">
		<attribute key="description" value="It has been temporarily imbued with energy magic and increases your speed."/>
		<attribute key="weight" value="6900"/>
		<attribute key="defense" value="36"/>
		<attribute key="weaponType" value="shield"/>
		<attribute key="speed" value="20"/>
		<attribute key="duration" value="1200"/>
		<attribute key="showduration" value="1"/>
		<attribute key="decayTo" value="8905"/>
	</item>

Movements.xml:

Code:

	<movevent event="Equip" itemid="8908" slot="hand" level="100" function="onEquipItem" > --rainbow shield(energy)
		<vocation name="Knight"/>
		<vocation name="Elite Knight" showInDescription="0"/>
		<vocation name="Crusader" showInDescription="0"/>
	</movevent>
	<movevent event="DeEquip" itemid="8908" slot="hand" function="onEquipItem" />

Skar · Dec 7, 2008

The addons no save =/
if the player logout addons delete =/

jo3bingham · Dec 7, 2008

Here's how to fix promotion bug. Go to data/npc/lib/npcsystem/, open modules.lua, then scroll down to the promotePlayer function (line 69~). *NOTE* - This is only a temporary fix, the server itself is supposed to edit the database but is missing the code for some reason.

after

Code:

setPlayerPromotionLevel(cid, parameters.promotion)

put

Code:

db.executeQuery("UPDATE `players` SET `promotion` = " .. parameters.promotion .. " WHERE `id` = " .. getPlayerGUID(cid) .. ";")

@AGS
Make sure you're testing it on a level 100-Knight+. If you have to, change the value to 90 and check if you can see a drastic increase in speed because it works for me.

Jo3

AzLaN · Dec 7, 2008

Nice

.

kermit · Dec 7, 2008

Jo3Bingham said:
Here's how to fix addon bug. Go to data/npc/lib/npcsystem/, open modules.lua, then scroll down to the promotePlayer function (line 69~). *NOTE* - This is only a temporary fix, the server itself is supposed to edit the database but is missing the code for some reason.

after

Code:

setPlayerPromotionLevel(cid, parameters.promotion)

put

Code:

db.executeQuery("UPDATE `players` SET `promotion` = " .. parameters.promotion .. " WHERE `id` = " .. getPlayerGUID(cid) .. ";")

Nice one elf... on the bug reporting section u said this was not a bug?

1. Is a bug.
2. LOL

Atentador · Dec 7, 2008

This was doesn't working for me. :S

elf · Dec 7, 2008

AGS said:

Is it me or addons are not being saved?

When you logout you lose all your addons.

Also, for some reason the sparking rainbow shield doesn't increase speed:
Items.xml

Code:

>	<item id="8908" article="a" name="sparking rainbow shield">
		<attribute key="description" value="It has been temporarily imbued with energy magic and increases your speed."/>
		<attribute key="weight" value="6900"/>
		<attribute key="defense" value="36"/>
		<attribute key="weaponType" value="shield"/>
		<attribute key="speed" value="20"/>
		<attribute key="duration" value="1200"/>
		<attribute key="showduration" value="1"/>
		<attribute key="decayTo" value="8905"/>
	</item>

Movements.xml:

Code:

	<movevent event="Equip" itemid="8908" slot="hand" level="100" function="onEquipItem" > --rainbow shield(energy)
		<vocation name="Knight"/>
		<vocation name="Elite Knight" showInDescription="0"/>
		<vocation name="Crusader" showInDescription="0"/>
	</movevent>
	<movevent event="DeEquip" itemid="8908" slot="hand" function="onEquipItem" />

Could you spy it a bit for me? Try removing quest="30015" from outfits.xml for Archdemon outfit and test again are they being removed.

Jo3Bingham said:
Here's how to fix addon bug. Go to data/npc/lib/npcsystem/, open modules.lua, then scroll down to the promotePlayer function (line 69~). *NOTE* - This is only a temporary fix, the server itself is supposed to edit the database but is missing the code for some reason.

after

Code:

setPlayerPromotionLevel(cid, parameters.promotion)

put

Code:

db.executeQuery("UPDATE `players` SET `promotion` = " .. parameters.promotion .. " WHERE `id` = " .. getPlayerGUID(cid) .. ";")

@AGS
Make sure you're testing it on a level 100-Knight+. If you have to, change the value to 90 and check if you can see a drastic increase in speed because it works for me.

Jo3

what does promotion has to addons?

Atentador · Dec 7, 2008

I noted this to. :S

But, good work Elf.

I'm waiting for the next update. ^^

mamon_2 · Dec 7, 2008

When server crashes says something about reportir te "report.txt", where to put that info?

jo3bingham · Dec 7, 2008

Elf said:
what does promotion has to addons?

Oops, I meant promotion lol. It was like 2-3AM when I posted that, I'll change it real quick, thanks.

Jo3

pierroth · Dec 7, 2008

hey im sorry for this question, but what is the command to give addons again?

Btw Rainbow Shield crashes the server whenever a player uses it. :s

AGS · Dec 7, 2008

Jo3Bingham said:
@AGS
Make sure you're testing it on a level 100-Knight+. If you have to, change the value to 90 and check if you can see a drastic increase in speed because it works for me.
Jo3

I tested it on a level 717,217 Knight, and I checked the speed with /info, and the speed was the same, but with boots of haste it changed. Plus it's not showing the speed in the description.
The fiery rainbow shield does work

Elf said:
Could you spy it a bit for me? Try removing quest="30015" from outfits.xml for Archdemon outfit and test again are they being removed.

Here's my outfits.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<outfits>
	<!-- Female outfits -->
	<outfit type="0" looktype="136" enabled="1" name="Citizen" premium="0"/>
	<outfit type="0" looktype="137" enabled="1" name="Hunter" premium="0"/>
	<outfit type="0" looktype="138" enabled="1" name="Summoner" premium="0"/>
	<outfit type="0" looktype="139" enabled="1" name="Knight" premium="0"/>
	<outfit type="0" looktype="140" enabled="1" name="Noblewoman" premium="1"/>
	<outfit type="0" looktype="141" enabled="1" name="Summoner" premium="1"/>
	<outfit type="0" looktype="142" enabled="1" name="Warrior" premium="1"/>
	<outfit type="0" looktype="147" enabled="1" name="Barbarian" premium="1"/>
	<outfit type="0" looktype="148" enabled="1" name="Druid" premium="1"/>
	<outfit type="0" looktype="149" enabled="1" name="Wizard" premium="1"/>
	<outfit type="0" looktype="150" enabled="1" name="Oriental" premium="1"/>
	<outfit type="0" looktype="155" enabled="1" name="Pirate" premium="1"/>
	<outfit type="0" looktype="156" enabled="1" name="Assassin" premium="1"/>
	<outfit type="0" looktype="157" enabled="1" name="Beggar" premium="1"/>
	<outfit type="0" looktype="158" enabled="1" name="Shaman" premium="1"/>
	<outfit type="0" looktype="252" enabled="1" name="Norsewoman" premium="1"/>
	<outfit type="0" looktype="269" enabled="1" name="Nightmare" premium="1"/>
	<outfit type="0" looktype="270" enabled="1" name="Jester" premium="1"/>
	<outfit type="0" looktype="279" enabled="1" name="Brotherhood" premium="1"/>
	<outfit type="0" looktype="288" enabled="1" name="Demonhunter" premium="1"/>
	<!-- Male outfits -->
	<outfit type="1" looktype="128" enabled="1" name="Citizen" premium="0"/>
	<outfit type="1" looktype="129" enabled="1" name="Hunter" premium="0"/>
	<outfit type="1" looktype="130" enabled="1" name="Mage" premium="0"/>
	<outfit type="1" looktype="131" enabled="1" name="Knight" premium="0"/>
	<outfit type="1" looktype="132" enabled="1" name="Nobleman" premium="1"/>
	<outfit type="1" looktype="133" enabled="1" name="Summoner" premium="1"/>
	<outfit type="1" looktype="134" enabled="1" name="Warrior" premium="1"/>
	<outfit type="1" looktype="143" enabled="1" name="Barbarian" premium="1"/>
	<outfit type="1" looktype="144" enabled="1" name="Druid" premium="1"/>
	<outfit type="1" looktype="145" enabled="1" name="Wizard" premium="1"/>
	<outfit type="1" looktype="146" enabled="1" name="Oriental" premium="1"/>
	<outfit type="1" looktype="151" enabled="1" name="Pirate" premium="1"/>
	<outfit type="1" looktype="152" enabled="1" name="Assassin" premium="1"/>
	<outfit type="1" looktype="153" enabled="1" name="Beggar" premium="1"/>
	<outfit type="1" looktype="154" enabled="1" name="Shaman" premium="1"/>
	<outfit type="1" looktype="251" enabled="1" name="Norseman" premium="1"/>
	<outfit type="1" looktype="268" enabled="1" name="Nightmare" premium="1"/>
	<outfit type="1" looktype="273" enabled="1" name="Jester" premium="1"/>
	<outfit type="1" looktype="278" enabled="1" name="Brotherhood" premium="1"/>
	<outfit type="1" looktype="289" enabled="1" name="Demonhunter" premium="1"/>
	<!-- GM outfits -->
	<outfit type="2" looktype="159" enabled="1" name="Elf" premium="1"/>
	<outfit type="2" looktype="160" enabled="1" name="Dwarf" premium="1"/>
	<outfit type="2" looktype="226" enabled="1" name="Frog" premium="1"/>
	<outfit type="2" looktype="194" enabled="1" name="Cult Member" premium="1"/>
	<outfit type="2" looktype="254" enabled="1" name="Barbarian Skullhunter" premium="1"/>
	<outfit type="2" looktype="264" enabled="1" name="Barbarian Brutetamer" premium="1"/>
	<outfit type="2" looktype="253" enabled="1" name="Barbarian Headsplitter" premium="1"/>
	<outfit type="2" looktype="255" enabled="1" name="Barbarian Bloodwalker" premium="1"/>
	<outfit type="2" looktype="12" enabled="1" name="Archdemon" premium="1"/>
	<outfit type="2" looktype="275" enabled="1" name="Sea Serpent" premium="1"/>
</outfits>

pierroth · Dec 8, 2008

Got this error.

Code:

[07/12/2008 17:34:43] Lua Script Error: [Action Interface] 
[07/12/2008 17:34:43] data/actions/scripts/quests/quests.lua:onUse

[07/12/2008 17:34:43] luaGetItemWeight(). Item not found

anybody?

@AGS
Did it work when u remove what elf said?

Addons still dont save :s

NilssoN · Dec 8, 2008

Where can I change how many % exp/skill you loose when you die?

Skar · Dec 8, 2008

@up: in your db in phpmyadmin
in players seacrh this:
loss skill: 10 << 10%

The Forgotten Server v0.3 beta 1

New User of Linux OS

New Member

New Member

Excellent OT User

Mar Co.

DeathSouls Owner

New Member

Excellent OT User

New Member

™Kermit™

New Member

Sing, sing blue silver

New Member

Banned User

Excellent OT User

Mar Co.

DeathSouls Owner

Mar Co.

¯\(º o)/¯

New Member