bool SpawnDB::NewSpawn(uint32 solarSystemID,GPoint loc,uint32 CorpID,int typeID)
{
	DBQueryResult res;
	char dbq[500];
	char buf[10];
	char buf2[10];
	dbq[0]=(char)0;
	sprintf(&buf[0],"%d",typeID);
	strcat(strcat(&dbq[0],"select * from spawngroupentries where npctypeID="),&buf[0]);
	strcat(&dbq[0],";");
	char tmpc[100];
	DBResultRow row;
	DBerror err;
	int cc;
	if(sDatabase.RunQuery(res,&dbq[0]))
	{res.GetRow(row);
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(&dbq[0],"CREATE TABLE tmp_spawngroupentries select * from spawngroupentries;"));
	if((cc=res.GetRowCount())==0){
	dbq[0]=(char)0;
	sprintf(&buf2[0],"%d",CorpID);
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(strcat(strcat(strcat(strcat(&dbq[0],"insert into spawngroupentries values((select spawngroupID from tmp_spawngroupentries where spawngroupID>0 order by spawngroupID desc limit 1)+1,"),&buf[0]),",1,1,1000044,"),&buf2[0]),");"));
	dbq[0]=(char)0;
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(strcat(strcat(strcat(strcat(strcat(strcat(&dbq[0],"insert into spawngroups values ((select spawngroupID from spawngroupentries where npctypeID="),&buf[0]),"),"),"(select typename from invtypes where typeid="),&buf[0]),"),0"),");"));
	}
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(&dbq[0],"CREATE TABLE tmp_spawns select * from spawns;"));
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,"Insert into spawns values ((select spawnID from tmp_spawns where spawnID>0 order by spawnID desc limit 1)+1,%i,(select spawngroupID from spawngroupentries where npctypeID= %i ),0,0,100,1000);",solarSystemID,typeID);
	dbq[0]=(char)0;
	int cc1,cc2,cc3;
	sDatabase.RunQuery(err,"Insert into spawnbounds values ((select spawnID from spawns where spawnID>0 order by spawnID desc limit 1),0, %f , %f , %f )" , loc.x , loc.y , loc.z);
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(&dbq[0],"drop table tmp_spawngroupentries;"));
	dbq[0]=(char)0;
	sDatabase.RunQuery(err,strcat(&dbq[0],"drop table tmp_spawns;"));

	 }
	 return true;
}