EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   MYSQL help plz :D (https://www.eqemulator.org/forums/showthread.php?t=23692)

daryl 09-26-2007 01:19 AM
MYSQL help plz :D
 
high all i trying to update my database with

`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',


but am getting mysql> source test.sql;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'column add
`id` int(11) NOT NULL default '0',
`minstatus` sma
mysql>

anyone can help me fix it plz dont really know much/anything about mysql lol :D

also how can i get that danasoft crap below off plz ? :D

daryl 09-26-2007 02:31 AM
this is what i wanna do

alter table items add
`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`aagi` int(11) NOT NULL default '0',
`ac` int(11) NOT NULL default '0',
`accuracy` int(11) NOT NULL default '0',
`acha` int(11) NOT NULL default '0',
`adex` int(11) NOT NULL default '0',
`aint` int(11) NOT NULL default '0',
`artifactflag` tinyint(3) unsigned NOT NULL default '0',
`asta` int(11) NOT NULL default '0',
`astr` int(11) NOT NULL default '0',
`attack` int(11) NOT NULL default '0',
`augrestrict` int(11) NOT NULL default '0',
`augslot1type` tinyint(3) NOT NULL default '0',
`augslot1unk` int(11) NOT NULL default '0',
`augslot2type` tinyint(3) NOT NULL default '0',
`augslot2unk` int(11) NOT NULL default '0',
`augslot3type` tinyint(3) NOT NULL default '0',
`augslot3unk` int(11) NOT NULL default '0',
`augslot4type` tinyint(3) NOT NULL default '0',
`augslot4unk` int(11) NOT NULL default '0',
`augslot5type` tinyint(3) NOT NULL default '0',
`augslot5unk` int(11) NOT NULL default '0',
`augtype` int(11) NOT NULL default '0',
`avoidance` int(11) NOT NULL default '0',
`awis` int(11) NOT NULL default '0',
`bagsize` int(11) NOT NULL default '0',
`bagslots` int(11) NOT NULL default '0',
`bagtype` int(11) NOT NULL default '0',
`bagwr` int(11) NOT NULL default '0',
`banedmgamt` int(11) NOT NULL default '0',
`banedmgraceamt` int(11) NOT NULL default '0',
`banedmgbody` int(11) NOT NULL default '0',
`banedmgrace` int(11) NOT NULL default '0',
`bardtype` int(11) NOT NULL default '0',
`bardvalue` int(11) NOT NULL default '0',
`book` int(11) NOT NULL default '0',
`casttime` int(11) NOT NULL default '0',
`casttime_` int(11) NOT NULL default '0',
`charmfile` varchar(32) NOT NULL default '',
`charmfileid` varchar(32) NOT NULL default '',
`classes` int(11) NOT NULL default '0',
`color` int(10) unsigned NOT NULL default '0',
`combateffects` varchar(10) NOT NULL default '',
`extradmgskill` int(11) NOT NULL default '0',
`extradmgamt` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`cr` int(11) NOT NULL default '0',
`damage` int(11) NOT NULL default '0',
`damageshield` int(11) NOT NULL default '0',
`deity` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
`augdistiller` int(11) NOT NULL default '0',
`dotshielding` int(11) NOT NULL default '0',
`dr` int(11) NOT NULL default '0',
`clicktype` int(11) NOT NULL default '0',
`clicklevel2` int(11) NOT NULL default '0',
`elemdmgtype` int(11) NOT NULL default '0',
`elemdmgamt` int(11) NOT NULL default '0',
`endur` int(11) NOT NULL default '0',
`factionamt1` int(11) NOT NULL default '0',
`factionamt2` int(11) NOT NULL default '0',
`factionamt3` int(11) NOT NULL default '0',
`factionamt4` int(11) NOT NULL default '0',
`factionmod1` int(11) NOT NULL default '0',
`factionmod2` int(11) NOT NULL default '0',
`factionmod3` int(11) NOT NULL default '0',
`factionmod4` int(11) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`focuseffect` int(11) NOT NULL default '0',
`fr` int(11) NOT NULL default '0',
`fvnodrop` int(11) NOT NULL default '0',
`haste` int(11) NOT NULL default '0',
`clicklevel` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`regen` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`idfile` varchar(30) NOT NULL default '',
`itemclass` int(11) NOT NULL default '0',
`itemtype` int(11) NOT NULL default '0',
`ldonprice` int(11) NOT NULL default '0',
`ldontheme` int(11) NOT NULL default '0',
`ldonsold` int(11) NOT NULL default '0',
`light` int(11) NOT NULL default '0',
`lore` varchar(80) NOT NULL default '',
`loregroup` int(11) NOT NULL default '0',
`magic` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manaregen` int(11) NOT NULL default '0',
`enduranceregen` int(11) NOT NULL default '0',
`material` int(11) NOT NULL default '0',
`maxcharges` int(11) NOT NULL default '0',
`mr` int(11) NOT NULL default '0',
`nodrop` int(11) NOT NULL default '0',
`norent` int(11) NOT NULL default '0',
`pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
`pr` int(11) NOT NULL default '0',
`procrate` int(11) NOT NULL default '0',
`races` int(11) NOT NULL default '0',
`range` int(11) NOT NULL default '0',
`reclevel` int(11) NOT NULL default '0',
`recskill` int(11) NOT NULL default '0',
`reqlevel` int(11) NOT NULL default '0',
`sellrate` float NOT NULL default '0',
`shielding` int(11) NOT NULL default '0',
`size` int(11) NOT NULL default '0',
`skillmodtype` int(11) NOT NULL default '0',
`skillmodvalue` int(11) NOT NULL default '0',
`slots` int(11) NOT NULL default '0',
`clickeffect` int(11) NOT NULL default '0',
`spellshield` int(11) NOT NULL default '0',
`strikethrough` int(11) NOT NULL default '0',
`stunresist` int(11) NOT NULL default '0',
`summonedflag` tinyint(3) unsigned NOT NULL default '0',
`tradeskills` int(11) NOT NULL default '0',
`favor` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`unknown002` int(11) NOT NULL default '0',
`unknown003` int(11) NOT NULL default '0',
`unknown005` int(11) NOT NULL default '0',
`unknown007` int(11) NOT NULL default '0',
`unknown018` int(11) NOT NULL default '0',
`unknown019` int(11) NOT NULL default '0',
`unknown020` int(11) NOT NULL default '0',
`UNK012` int(11) NOT NULL default '0',
`UNK013` int(11) NOT NULL default '0',
`benefitflag` int(11) NOT NULL default '0',
`unknown061` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`unknown067` int(11) NOT NULL default '0',
`unknown069` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`UNK061` int(11) NOT NULL default '0',
`unknown081` int(11) NOT NULL default '0',
`unknown105` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`unknown122` int(11) NOT NULL default '0',
`unknown123` varchar(11) NOT NULL default '0',
`unknown124` varchar(11) NOT NULL default '0',
`recastdelay` int(11) NOT NULL default '0',
`recasttype` int(11) NOT NULL default '0',
`guildfavor` int(11) NOT NULL default '0',
`unknown128` varchar(11) NOT NULL default '0',
`UNK123` int(11) NOT NULL default '0',
`UNK124` int(11) NOT NULL default '0',
`attuneable` int(11) NOT NULL default '0',
`nopet` int(11) NOT NULL default '0',
`unknown133` varchar(11) NOT NULL default '0',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` varchar(255) NOT NULL default '',
`UNK127` int(11) NOT NULL default '0',
`pointtype` int(11) NOT NULL default '0',
`potionbelt` int(11) NOT NULL default '0',
`potionbeltslots` int(11) NOT NULL default '0',
`stacksize` int(11) NOT NULL default '0',
`notransfer` int(11) NOT NULL default '0',
`stackable` int(11) NOT NULL default '0',
`UNK134` varchar(255) NOT NULL default '',
`UNK137` int(11) NOT NULL default '0',
`proceffect` int(11) NOT NULL default '0',
`proctype` int(11) NOT NULL default '0',
`proclevel2` int(11) NOT NULL default '0',
`proclevel` int(11) NOT NULL default '0',
`UNK142` int(11) NOT NULL default '0',
`worneffect` int(11) NOT NULL default '0',
`worntype` int(11) NOT NULL default '0',
`wornlevel2` int(11) NOT NULL default '0',
`wornlevel` int(11) NOT NULL default '0',
`UNK147` int(11) NOT NULL default '0',
`focustype` int(11) NOT NULL default '0',
`focuslevel2` int(11) NOT NULL default '0',
`focuslevel` int(11) NOT NULL default '0',
`UNK152` int(11) NOT NULL default '0',
`scrolleffect` int(11) NOT NULL default '0',
`scrolltype` int(11) NOT NULL default '0',
`scrolllevel2` int(11) NOT NULL default '0',
`scrolllevel` int(11) NOT NULL default '0',
`UNK157` int(11) NOT NULL default '0',
`serialized` datetime default NULL,
`verified` datetime default NULL,
`serialization` text,
`source` varchar(20) NOT NULL default '',
`UNK033` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`id`),
KEY `name_idx` (`Name`),
KEY `lore_idx` (`lore`)


trying to get the missing columns in my database but i getting errors in mysql :(
anyone can help me figure whats wrong plz ?

Lalolyen 09-26-2007 11:03 AM
Quote:
Originally Posted by daryl (Post 138854)
high all i trying to update my database with

`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',


but am getting mysql> source test.sql;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'column add
`id` int(11) NOT NULL default '0',
`minstatus` sma
mysql>

anyone can help me fix it plz dont really know much/anything about mysql lol :D

also how can i get that danasoft crap below off plz ? :D
Remove either the "NOT NULL" or zero default and it should work.

Angelox 09-26-2007 12:54 PM
Quote:
Originally Posted by daryl (Post 138854)
also how can i get that danasoft crap below off plz ? :D
How'd you get it on? It's in your signature, just have to edit your settings and remove it.

Theeper 09-27-2007 12:50 AM
NOT NULL and zero default is ok, the problem is that you haven't specified that it's columns you are adding. The syntax should be like this ..

ALTER TABLE items ADD COLUMN `id` int(11) NOT NULL DEFAULT 0, ADD COLUMN `minstatus` int (11) NOT NULL DEFAULT 0 ... etc

daryl 09-28-2007 01:20 AM
thanks Theeper :D
had to change the '0', to just 0 lol but could only get one to work at a time took a while but its sorted now :D
thanks again man
now on to the rest of the db :D

daryl 09-28-2007 01:21 AM
Quote:
Originally Posted by Angelox (Post 138869)
How'd you get it on? It's in your signature, just have to edit your settings and remove it.


i did nothing lol its just appeared :( gonna go look if i can take it off :D

daryl 09-28-2007 01:27 AM
Quote:
Originally Posted by daryl (Post 138903)
i did nothing lol its just appeared :( gonna go look if i can take it off :D


guess i am wrong just noticed am logged in an old account lol must have put it on years ago lol :D


All times are GMT -4. The time now is 10:00 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.