GEIA SAS PEDIA...EXO ENA PROBLHMATAKI SXETIKA ME TO NAVICAT...OTAN PAW NA PERASO TA SQL ARXEIA ITEM ME TO BAT ARXEIO ITE XEIROKINITA....PERNO AUTO TO PROBLIMA....
[Err] 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 'TYPE=MyISAM' at line 22
Hello.
This code works well. It removes buff with double click, but If you preffer remove buff with ALT + mouse click, place this code in AbnormalStatusWnd.uc
function OnLButtonDown(WindowHandle a_WindowHandle, int X, int Y)
{
local Rect windowBounds;
local int targetRow;
local int targetCol;
local StatusIconInfo info;
local SkillInfo skillInfo;
if (IsKeyDown(IK_alt) == false)
return;
// Find window position
windowBounds = Me.GetRect();
// Process clicks outside of window frame only
if (X > (windowBounds.nX + NSTATUSICON_FRAMESIZE))
{
// Calc row and col of targeted icon
targetRow = (Y - windowBounds.nY) / NSTATUSICON_SIZE;
targetCol = (X - windowBounds.nX - NSTATUSICON_FRAMESIZE) / NSTATUSICON_SIZE;
// Store status info of targeted icon
StatusIcon.GetItem(targetRow, targetCol, info);
// Store actual skill info and make sure it is exists
if (GetSkillInfo(info.ClassID, info.Level, skillInfo))
{
// Request server to stop skill effect
// Usage: _dispel:<int:skill_id>,<int :skill_level>
// Example: _dispel:313,8
RequestBypassToServer ( "_dispel:" $ string ( skillInfo. SkillID ) $ "," $ string ( skillInfo. SkillLevel ) ) ) ;
}
}
}
Question
oykas1996
GEIA SAS PEDIA...EXO ENA PROBLHMATAKI SXETIKA ME TO NAVICAT...OTAN PAW NA PERASO TA SQL ARXEIA ITEM ME TO BAT ARXEIO ITE XEIROKINITA....PERNO AUTO TO PROBLIMA....
[Err] 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 'TYPE=MyISAM' at line 22
[Err] CREATE TABLE `armor` (
`item_id` int(11) NOT NULL default '0',
`name` varchar(70) default NULL,
`bodypart` varchar(15) NOT NULL default '',
`crystallizable` varchar(5) NOT NULL default '',
`armor_type` varchar(5) NOT NULL default '',
`weight` int(5) NOT NULL default '0',
`material` varchar(15) NOT NULL default '',
`crystal_type` varchar(4) NOT NULL default '',
`avoid_modify` int(1) NOT NULL default '0',
`durability` int(3) NOT NULL default '0',
`p_def` int(3) NOT NULL default '0',
`m_def` int(2) NOT NULL default '0',
`mp_bonus` int(3) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`crystal_count` int(4) default NULL,
`sellable` varchar(5) default NULL,
`dropable` varchar(5) default NULL,
`destroyable` varchar(5) default NULL,
`tradeable` varchar(5) default NULL,
PRIMARY KEY (`item_id`)
) TYPE=MyISAM;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
NA YPEN8IMISO POS EXO TO MYSQL 5.5 KAI TO NAVICAT 8.0
EUXARISTO EKPROTERON FILIKA,
OYKAS1996.
8 answers to this question
Recommended Posts