Hey mate, you know the insert cmd for creatureloot?
i keep getting a error saying
Code:
Error Code: 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 'index, entryid, itemid, precentchanse, heroicprecentchanse, mincount, maxcount, ' at line 1
no matter what i do, thanks in advance.
Edit: This is my cmd
Code:
insert into `creatureloot` (index, entryid, itemid, percentchanse, heroicpercentchanse, mincount, maxcount, ffa_loot) values (700001, 60082, 50000, 100, 0, 1, 1, 0)
Edit: Alright, I fixed it by editng the cmd abit
Code:
insert into `creatureloot` (`index`, `entryid`, `itemid`, `percentchanse`, `heroicpercentchanse`, `mincount`, `maxcount`, `ffa_loot`) values('700001', '60082', '50000', '100', '0', '1', '1', '0');
Edit: hmm now it keeps saying
Code:
Error Code: 1054 - Unknown column 'percentchanse' in 'field list'
even though that column is suppose to be there.
Edit: LOL Figured it, it aint easy to be a Norwegianlander "Presentchance" - "Presentchanse" lol