Miscellany

public switchChar(id){	new Authid[36],Data[1]	get_user_authid(id,Authid,35)	format(g_Query,511,"SELECT * FROM %s WHERE authid='%s'",g_AltJobsTable,Authid)	SQL_ThreadQuery(g_SqlHandle,"FetchClientData",g_Query,Data,1)	SaveUserData(id)		DPRP_SetUserBank(id, bankStorage[id])	DPRP_SetUserWallet(id, walletStorage[id])		DPRP_SetUserHunger(id,hungerStorage[id])	DPRP_SuckChubby(id,ChubbyInMouth[id])	DPRP_SetUserJobId(id, jobIDStorage[id])	//DPRP_SetUserAccess(id,accessStorage[id])}public FetchClientData(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {	if(FailState == TQUERY_CONNECT_FAILED)	{		format(g_Query,511,"Could not connect to SQL database.")		return DPRP_ThrowError(1,g_Query,0)	}	else if(FailState == TQUERY_QUERY_FAILED)	{		format(g_Query,511,"Internal error: consult developer.")		return DPRP_ThrowError(1,g_Query,0)	}		if(Errcode)	{		format(g_Query,511,"Error on query: %s",Error)		return DPRP_ThrowError(1,g_Query,0)	}	new id = Data[0]		if(SQL_NumResults(Query) < 1)		//If user is not in AltJobsTable	{		new Authid[36], StartMoney = get_cvar_num(StartMoneyCvar)		get_user_authid(id,Authid,35)				format(g_Query,511,"INSERT INTO %s VALUES('%s','Unemployed','%d','0','0','','')",g_AltJobsTable,Authid,StartMoney)		SQL_ThreadQuery(g_SqlHandle,"IgnoreHandle",g_Query)				new Results[1]		DPRP_FindJobId("Unemployed",Results,1)				Results[0] -= 1				if(!DPRP_ValidJobId(Results[0]))			Results[0] = DPRP_AddJob("Unemployed",5,0) - 1		bankStorage[id] = StartMoney		hungerStorage[id] = 0		walletStorage[id] = 0		jobIDStorage[id] = Results[0]		accessStorage[id] = 0		//	g_Access[id] = array_get_int(array_get_int(g_JobsArray,Results[0]),3)		//	g_AccessCache[id] = 0		//	g_Salary[id] = array_get_int(array_get_int(g_JobsArray,Results[0]),2)				//array_clear(g_UserItemArray[id])				return PLUGIN_CONTINUE	}	bankStorage[id] = SQL_ReadResult(Query,1)	walletStorage[id] = SQL_ReadResult(Query,2)		new Results[2], Temp[512]	SQL_ReadResult(Query,3,Temp,511)	DPRP_FindJobId(Temp,Results,2)	jobIDStorage[id] = Results[0]-1	if((Results[0] && Results[1]) || !Results[0])	{		//g_BadJob[id] = 1				DPRP_FindJobId("Unemployed",Results,1)		if(!DPRP_ValidJobId(Results[0] - 1))			Results[0] = DPRP_AddJob("Unemployed",5,0) - 1					jobIDStorage[id] = Results[0] - 1		//g_Salary[id] = 5		client_print(id,print_chat,"Error - Job + Unemployed can not be found.  Alert an admin!")	}	else if(DPRP_ValidJobId(jobIDStorage[id]))	{		//g_BadJob[id] = 0	}	else	{		//g_BadJob[id] = 1				DPRP_FindJobId("Unemployed",Results,1)		if(!DPRP_ValidJobId(Results[0] - 1))			Results[0] = DPRP_AddJob("Unemployed",5,0) - 1					jobIDStorage[id] = Results[0] - 1		//g_Salary[id] = 5				client_print(id,print_chat,"Error - Job can not be found.  Alert an admin!")	}	hungerStorage[id] = SQL_ReadResult(Query,4)		SQL_ReadResult(Query,5,Temp,511)	//accessStorage[id] = DPRP_AccessToInt(Temp)	//	g_AccessCache[id] = g_Access[id]	//	g_Salary[id] = array_get_int(array_get_int(g_JobsArray,g_JobId[id]),2)	//	g_Access[id] |= array_get_int(array_get_int(g_JobsArray,g_JobId[id]),3)				return PLUGIN_CONTINUE}