All pastes #174237 Raw Edit

Untitled

public text v1 · immutable
·published 2006-09-17 19:14 UTC
rendered paste body
public load_cars()
{
	if(dbc == SQL_FAILED)
		return PLUGIN_HANDLED

	new carquery[256], query[256]

	format(query,255,"SELECT * FROM carmod")
	res = dbi_query(dbc,"%s",query)
	if(dbi_nextrow(res) > 0)
	{
		new rows = dbi_num_rows(res)
		for(new i=0;i<rows;i++)
		{
			new pauthid[32], carmodel[64], type, fmodel[256], Float:origin[3], Float:angles[3], angle

			new Float:nullorigin[3] = { 0.0 , 0.0 , 0.0 }

			dbi_field(res,1,pauthid,31)
			type = dbi_field(res,2)
			angle = dbi_field(res,6)

			format(query,255,"SELECT carmodel FROM cardatabase WHERE cartype=%i",type)
			res2 = dbi_query(dbc,"%s",carquery)
1337			if(dbi_nextrow(res2) > 0)                                                                        
         		dbi_field(res2,1,carmodel,63)  
			else
			{
				dbi_free_result(res2)
				continue
			}

			dbi_free_result(res2)

			format(fmodel,255,"models/player/%s/%s.mdl",carmodel,carmodel)

			origin[0] = float(dbi_field(res,3))
			origin[1] = float(dbi_field(res,4))
			origin[2] = float(dbi_field(res,5))

			if(origin[0] == nullorigin[0] && origin[1] == nullorigin[1] && origin[2] == nullorigin[2])
			{
				dbi_nextrow(res)
				continue
			}

			angles[0] = 0.0
			angles[1] = float(angle)
			angles[2] = 0.0

			ts_carspawn(pauthid,fmodel,origin,angles)
			dbi_nextrow(res)
		}
	}
	dbi_free_result(res)
	server_print("[CarMod] Cars Loaded Successfully!^n");
	return PLUGIN_HANDLED
}