I have already done the exact same thing for my server.
in Common/database.cpp Replace THIS:
end += sprintf(end, "UPDATE character_ SET timelaston=0,guild=0, zonename=\'%s\', x=%f, y=%f, z=%f, profile=\'", GetZoneName(pp->zone_id), pp->x, pp->y, pp->z);
WITH:
end += sprintf(end, "UPDATE character_ SET timelaston=0,guild=0, zonename=\'arena\', x=468, y=-41, z=23, profile=\'", 77, 468, -41, 23);
assuming you have the latest code from the CVS.
|