Abdullah Imran FlavaSava7

My gists: https://gist.github.com/FlavaSava7

FlavaSava7 / cities_countriesId_english.sql

Created October 8, 2017 13:11

This list is connected to https://gist.github.com/FlavaSava7/3c0f7f630d0cce5abaf0ad2e0c8e88df countries list.

	CREATE TABLE `cities` (
	`id` int NOT NULL ,
	`city_name` varchar(100) NOT NULL default '',
	`country_id` varchar(3) NOT NULL,

	PRIMARY KEY (`id`),
	FOREIGN KEY (`country_id`) REFERENCES countries(`country_code`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	--
	-- Dumping data for table `countries`

FlavaSava7 / countries_nationalities_arabic_english.sql

Last active October 13, 2024 09:52

SQL Countries & Nationalities List : English and Arabic

	CREATE TABLE `countries` (
	`country_code` varchar(2) NOT NULL default '',
	`country_enName` varchar(100) NOT NULL default '',
	`country_arName` varchar(100) NOT NULL default '',
	`country_enNationality` varchar(100) NOT NULL default '',
	`country_arNationality` varchar(100) NOT NULL default '',
	PRIMARY KEY (`country_code`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	--
	-- Dumping data for table `countries`

unitycoder / UI2World.cs

Last active July 17, 2024 18:55

Move UI element to world gameobject position

	// https://forum.unity.com/threads/overlay-canvas-and-world-space-coordinates.291108/#post-9627593
	// translating between overlay canvas and world space coordinates
	uiObject.transform.position = RectTransformUtility.WorldToScreenPoint(Camera.main, worldObject.transform.TransformPoint(Vector3.zero));

	--------


	// http://answers.unity3d.com/questions/799616/unity-46-beta-19-how-to-convert-from-world-space-t.html

	//this is your object that you want to have the UI element hovering over