AlliedModders - How do I create this MySQL table?

AlliedModders (https://forums.alliedmods.net/index.php)

- Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)

- - How do I create this MySQL table? (https://forums.alliedmods.net/showthread.php?t=221442)

proffs

07-22-2013 05:17

How do I create this MySQL table?

PHP Code:


		
			
formatex(szTemp,charsmax(szTemp), "SELECT (UNIX_TIMESTAMP(expire) - UNIX_TIMESTAMP()), expire FROM `hb_admin` WHERE `steamid` = '%s'", szSteamID)

All i know the table has to be named hb_admin and 2 columns in it on expire and on steamid.
But where should i the expire date and how? and where do i enter the steam ID?

YamiKaitou

07-24-2013 09:09

Re: How do I create this MySQL table?

Seek assistance from your MySQL Manual to learn how to create the table

Sylwester

07-24-2013 11:15

Re: How do I create this MySQL table?

PHP Code:


		
			
CREATE TABLE IF NOT EXISTS `hb_admin` (`steamid` VARCHAR(36) PRIMARY KEY, `expire` DATETIME);

All times are GMT -4. The time now is 18:41.