View Single Post
  #1  
Old 10-24-2014, 10:37 PM
Figback65
Discordant
 
Join Date: Aug 2009
Location: 2131231231
Posts: 255
Default Mysql Query Help, Disable Fabled.

Well, another question. I tried to use georges tools to edit npcs and it now gives me errors with the new special attacks changes. After i noticed what it was doing, it had ruined my npc_types table and i had to restore from a backup. So here now I am tryen to figure out a simple query to run to help edit them w/o usen tools anymore. Sorry george :( Lovem tho!

Code:
SELECT
   npc_types.name AS NPC_Name,
   spawn2.enabled AS Enabled
FROM
   npc_types,
   spawn2
WHERE
   npc_types.name LIKE '%fabled%';
This errors out with out of memory error

and

Code:
SELECT
   npc_types.name AS NPC_Name,
   spawn2.enabled AS Enabled
FROM
   npc_types,
   spawn2
WHERE
   npc_types.name LIKE '%fabled%'
LIMIT 100;
Just repeats the 1st Fabled string it finds, which is 100 Fabled Fippys.

Any ideas or opinions? And yes i try try try and research like crazy, even stack overflow and forums before i bother you guys
__________________
Reply With Quote