CMS Made Simple Forums

Code: Select all

function executeuser()
{
code
function dome()
{
code
}
function notme()
{
code
}
}

Code: Select all

function executeuser()
{
code
}
function dome()
{
code
}
function notme()
{
code
}

Code: Select all

$query = "SELECT * FROM ".cms_db_prefix()."module_poll WHERE active='yes'";
$dbresult = $db->Execute($query);

Code: Select all

$questionquery = "SELECT * FROM ".cms_db_prefix()."module_poll WHERE active='yes'";
$dbresult = $db->Execute($questionquery);

Code: Select all

function poll_module_install($cms) {
	//This function should install the database functions and do other basic init stuff for first time use.
	$db = $cms->db;
	$dict = NewDataDictionary($db);
	$flds = "
    pollid I9 DEF '0' NOTNULL AUTO, 
    question TINYTEXT NOTNULL,
	lastip TEXT,
    active C(3) DEF 'no' NOTNULL, KEY (poll_id) 
	";
	$taboptarray = array('mysql' => 'TYPE=MyISAM');
	$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_poll", $flds, $taboptarray);
	$dict->ExecuteSQLArray($sqlarray);

	$db->CreateSequence(cms_db_prefix()."module_poll_seq");
	
	$flds = "
	answerid I9 DEF '0' NOTNULL AUTO, 
    pollid I9, 
	answers C(20) NOTNULL,
	votes I9 DEF '0',
	result I9 DEF '0', KEY (poll_answer_id)
	";
	$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_poll_answers", $flds, $taboptarray);
	$dict->ExecuteSQLArray($sqlarray);
	
	$db->CreateSequence(cms_db_prefix()."module_poll_answers_seq");


	cms_mapi_create_permission($cms, 'Modify Poll', 'Modify Poll');
}