fishing SQL db error ?

[joshr45]

tried with different rods and lures, happens when "you didn't catch anything" pops up

[00:29:02][SQL] DB error - You have an error in your SQL syntax; check the manua
l that corresponds to your MySQL server version for the right syntax to use near
'.luck,FROM fishing_zone AS zone INNER JOIN fishing_rod AS rod USING (fishid)
I' at line 1

[joshr45]

i knew it looked familiar in fishingutils.cpp

Code: Select all

		const int8* Query = 
            "SELECT "
                "fish.fishid,"      // 0
                "fish.min,"         // 1
                "fish.max,"         // 2
                "fish.size,"        // 3
                "fish.stamina,"     // 4
                "fish.watertype,"   // 5
                "rod.flag "         // 6
                "lure.luck,"        // 7
            "FROM fishing_zone AS zone "
            "INNER JOIN fishing_rod  AS rod  USING (fishid) "
			"INNER JOIN fishing_lure AS lure USING (fishid) "
			"INNER JOIN fishing_fish AS fish USING (fishid) "
			"WHERE zone.zoneid = %u AND rod.rodid = %u AND lure.lureid = %u AND lure.luck != 0 "
			"ORDER BY luck"; 

[bluekirby0]

Thanks, fixed: https://code.google.com/p/onetimexi/sou ... ail?r=3013