Myacc-Uniserver-Possting

[Qumora]

tried to search this in Otland couldnt find please help.


Exception class: PDOException()

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'body' at row 1

File: C:\UniServerZ\www\system\libs\pot\OTS_Base_DB.php
Line: 188


Backtrace:

#0 C:\UniServerZ\www\system\libs\pot\OTS_Base_DB.php(188): PDO->exec()
#1 C:\UniServerZ\www\admin\pages\pages.php(168): OTS_Base_DB->update()
#2 C:\UniServerZ\www\admin\pages\pages.php(73): Pages::update()
#3 C:\UniServerZ\www\admin\index.php(62): include('C:\\UniServerZ\\w...')
#4 {main}

 

[slaw]

The field is of type TEXT - it allows to store up to 65,535 characters.

Do you try to store a book there?

 

[Qumora]

just this post


Magic Items - Randomized Item Stats

Magic Items - What is it?

We have an advanced item system which allows regular items to have additional stats. This system is called 'Magic Items' or 'Randomized Item Stats'. If you kill ANY monster, all wearable loot dropped has a chance to have improved stats; however only 1 item per monster can become magical.

Magic Items - How does it work?
All equipment dropped by any monster has an equal chance to get magical stat bonuses. You can only find certain attributes on items, for example.. a wand cannot get bonus armor and paladin armor cannot get bonus attack. When an item becomes magical it can get a prefix, suffix or both. The maximum amount of attribute bonuses an item can receive is two. Here are some examples below..
Prefix	quick emerald sword	15% ATTACKSPEED
Suffix	emerald sword of slaughter	+2 DAMAGE
Double	quick emerald sword of slaughter	+2 DMG, 15% ATKSPD

Item Rarity Chart
Common	Very common, low item stats... not very impressive. (5% Chance)
Uncommon	More rare then common items but still easily obtainable. (3% Chance)
Rare	Rare quality items have impressive stats, harder to find. (2% Chance)
Epic	Epic quality items are very useful, very hard to find. (1% Chance)
Legendary	The absolute best items you can loot, very difficult to find. (0.5% Chance)

Item Attributes
	Common	Uncommon	Rare	Epic	Legendary
Max Health	10-20	21-25	26-40	41-60	61-80
Max Mana	20-49	50-69	70-99	100-129	130-160
Regen HP/MP	2-5 (8 sec)	6-8 (7 sec)	9-12 (6 sec)	13-16 (4 sec)	17-22 (2 sec)
Attack	1	2-3	4	5-6	7-8
Armor	1-2	3-4	5	6-7	8-10
Defense	2-4	5-6	7-9	10-12	13-14
Magic Level	1	2	3	4	5-8
Melee Skills	1	2	3	4	5
Shielding Skill	1	2	3	4	5-6
Distance Skill	1	2	3	4	5
Hit Chance	1%-2%	3%-4%	5%-6%	7%-8%	9%-10%
Attack Speed	5%-10%	10%-15%	15%-18%	18%-27%	27%-40%
Walk Speed	4-8	9-14	15-20	21-30	31-50
Absorb Elements	1%	1%	2%	2%	3%
Extra Charges	30-45	52-69	75-95	100-125	126-145
Extra Duration	15%-39%	45%-55%	60%-75%	90%-110%	115%-140%
Life Steal (PVP)	1-5 @ 3%	2-7 @ 5%	4-9 @ 6%	8-12 @ 7%	12-18 @ 8%
Mana Steal (PVP)	1-5 @ 3%	2-7 @ 5%	4-9 @ 6%	8-12 @ 7%	12-18 @ 8%
[Update]:	The	attributes	below	are	new.
Physical Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Energy Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Terra Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Fire Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Ice Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Holy Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Death Strike	1-15 @ 2%	15-25 @ 3%	25-40 @ 4%	40-55 @ 5%	55-70 @ 7%
Increase Damage	1%	2%	3%	4%	5%
Critical Chance	1-2%	3-4%	5-6%	7-8%	9-10%
Dodge	1-2%	3-4%	5-6%	7-8%	9-10%
Stun Chance	1% (1 sec)	2% (1 sec)	3% (1 sec)	4% (1-1.5 sec)	5% (1.5-2 sec)
Multi-Shot	1-2% [1 Hit]	3-4% [1 Hit]	4-6% [1 Hit]	7-8% [1 Hit]	8-10% [2 Hits]
Magic Finder	1-2%	3-4%	4-6%	7-8%	8-10%
XP Bonus	1%	2%	3%	4%	5-8%

Vocation Limitations
Mage	Mages can gain a maximum bonus of 40 magic level, 15 melee/shield skills, 5% melee skills boost, 250 health, 1000 mana, 75 points of regeneration, 100% walking speed, 25% hit chance, 100% attack speed, 35% absorbtion of elements, 100 life steal (50% chance), 100 mana steal (50% chance), 10% chance @ 50-100 damage for each element strike, 50% xp boost, 10% damage increase, 10% critical chance, 10% dodge chance, 5% chance to stun for a maxium of 3 seconds, 5% chance to multi-shot for a maximum of 3 creatures.
Paladin	Paladins can gain a maximum bonus of 30 distance/shield skills, 15 magic level, 5% melee skills boost, 400 health, 500 mana, 75 points of regeneration, 100% walking speed, 50% hit chance, 100% attack speed, 30% absorbtion of elements, 100 life steal (50% chance), 100 mana steal (50% chance), 10% chance @ 50-100 damage for each element strike, 50% xp boost, 10% damage increase, 10% critical chance, 10% dodge chance, 5% chance to stun for a maxium of 3 seconds, 5% chance to multi-shot for a maximum of 3 creatures.
Knight	Knights can gain a maximum bonus of 40 melee/shield skills, 6 magic level, 5% melee skills boost, 600 health, 300 mana, 75 points of regeneration, 100% walking speed, 25% hit chance, 100% attack speed, 20% absorbtion of elements, 100 life steal (50% chance), 100 mana steal (50% chance), 10% chance @ 50-100 damage for each element strike, 50% xp boost, 10% damage increase, 10% critical chance, 10% dodge chance, 5% chance to stun for a maxium of 3 seconds, 5% chance to multi-shot for a maximum of 3 creatures.

Talk Actions
Magic Find Percent	!mf displays your current magic find percent + absorbed magic find boxes.
Current/Max Limits	!stats displays all current stats, max stats limits and max absorb limits.

Excluded Items
Extra Charges	Stone Skin Amulet.

Item Limitations
Attack [Deadly]	MELEE, DISTANCE
Armor [Strong]	BODY, SHIELD, HEAD, LEGS, AMULET Vocational Items Excluded: Sorcerer, Druid
Defence [Fortified]	MELEE, SHIELD Vocational Items Excluded: Sorcerer, Druid
Shielding Skill [Defensive]	ARMOR, SHIELD, BACKPACK
Club Skill [Studded]	CLUBS, ARMOR, SHIELD, BACKPACK Vocational Items Excluded: Sorcerer, Druid, Paladin
Sword Skill [Bladed]	SWORDS, ARMOR, SHIELD, BACKPACK Vocational Items Excluded: Sorcerer, Druid, Paladin
Axe Skill [Sharpened]	AXES, ARMOR, SHIELD, BACKPACK Vocational Items Excluded: Sorcerer, Druid, Paladin
Distance Skill [Sharp Shooter]	BOWS/CROSSBOWS, ARMOR, SHIELD, BACKPACK Vocational Items Excluded: Sorcerer, Druid, Knight
Magic Level [Mystical]	WAND, BODY, SHIELD, HEAD, LEGS, TRINKET, BACKPACK, RING, AMULET Vocational Items Excluded: Knight, Paladin
Hit Chance [Hawkeye's]	BOWS/CROSSBOWS
Attack Speed [Swift]	MELEE WEAPONS, DISTANCE, WAND
Player Speed [Pathfinding]	FEET, TRINKET, BACKPACK, AMULET, RING
Regen [Health/Mana]	BODY, SHIELD, HEAD, LEGS
Max Health/Mana [Pure/Serpent]	TRINKET, BACKPACK, RING, AMULET, FEET
Charges/Duration [Charged/Divine]	Any items that use charges/duration can gain extra charges and duration points.
Absorb Elements [All Elements]	BODY, SHIELD, HEAD, LEGS, TRINKET, BACKPACK, RING, AMULET
Increase Damage [Powerful]	MELEE, DISTANCE, WAND, TRINKET, BACKPACK, RING, AMULET
Dodge Attacks [Avoid Damage]	BODY, SHIELD, HEAD, LEGS, FEET
Critical Attack [Double Damage]	MELEE, DISTANCE, WAND, TRINKET, BACKPACK, RING, AMULET
Stun [Stunner]	MELEE, DISTANCE, WAND, TRINKET, BACKPACK, RING, AMULET
Life/Mana Steal [Vampiric/Spirtual]	MELEE, DISTANCE, WAND, TRINKET, BACKPACK, RING, AMULET
Elemental Strikes [Striker]	TRINKET, BACKPACK, RING, AMULET
Multi-Shots [Shooter]	MELEE, DISTANCE, WAND, TRINKET, BACKPACK, RING, AMULET
XP Bonus [Boosted]	TRINKET, BACKPACK, RING, AMULET
MF Bonus [Finder/of Finding]	TRINKET, BACKPACK, RING, AMULET

 

[slaw]

Go to phpmyadmin, choose your database -> choose "myaac_pages" table



Click on Change


Change it to MEDIUMTEXT, which is 16 MB, and should be far enough for anything.



Then click Save.

 

[Qumora]

worked! thank you bro much love <3