#bot saveraid

nosfentora · #4 05-05-2009, 08:48 AM

looking at the table, if you leave it as is and only update based on charid?
on a #bot saveraid
delete * from botgroups where charid=<current charid>
then save the new raid info

the on a #bot spawnraid pull data based on the current char id.

the sql to change the table is pretty simple

Code:

alter table botgroups drop primary key

if you really want to have a primary key somewhere you could do

Code:

alter table botgroups add column `entry` int(11) not null  auto_increment primary key

it won't add it at the beginning (couldn't figure out how/why) but it'll be there.