Working SQL Bot file

[ionhsmith]

I tried to do this and i get an error ... Says FUNCTION peq.GetMobType does not exist ... i was trying to do this fix as well

[Riklin]

Originally Posted by ionhsmith

I tried to do this and i get an error ... Says FUNCTION peq.GetMobType does not exist ... i was trying to do this fix as well

I ran into this issue. What I did to fix it was to create a peqtest database instance and source the September 2014 data, then source in the bots, then source in the mercs. After all that, I copied the GetMobType function in the peqtest database and pasted it in the real database. Worked perfectly for me.

[werebat]

Here is the issue. I fixed it in on my build.

In the load_bots.sql there are two lines that need to be corrected.

197 DELIMTER \\
212 END \\

The problem is that you cannot use a backslash as a delimiter. Change the \\ to $$ and rerun it. You may need to run drop_bots first so you dont hit a bunch of duplicate errors.

197 DELIMTER $$
212 END $$