function onUse() { global $db_prefix, $ID_MEMBER, $item_info; $result = db_query(" INSERT INTO `{$db_prefix}awards_members` VALUES (20003, 2, {$ID_MEMBER}, 2007-01-07, 0); "); return "Success!"; }
ID_AWARD_MEMBER int(8) unsigned NOT NULL DEFAULT '0', ID_AWARD BIGINT(10) UNSIGNED NOT NULL DEFAULT '0', ID_MEMBER INT(8) UNSIGNED NOT NULL DEFAULT '0', dateReceived DATE NOT NULL DEFAULT '0001-01-01', favorite TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', UNIQUE KEY ID_AWARD_MEMBER (ID_AWARD_MEMBER), KEY ID_AWARD (ID_AWARD)
INSERT INTO `{$db_prefix}awards_members` VALUES (20003, 2, {$ID_MEMBER}, 2007-01-07, 0);
INSERT INTO `{$db_prefix}awards_members` VALUES (20003, 2, {$ID_MEMBER}, 2007-01-07, 0)
<?php/**********************************************\| SMFSHOP (Shop MOD for Simple Machines Forum) || (c) 2005 DanSoft Australia || http://www.dansoftaustralia.com/ |\**********************************************///File: BuyMembergroup.php// Item//VERSION: 1.0 (Build 1)//DATE: Oct 22, 2006//Author Chadclass item_BuyMembergroup extends itemTemplate { function getItemDetails() { $this->authorName = "Chad"; $this->authorWeb = "http://www.aviary.info/"; $this->authorEmail = "generalchad@gmail.com"; $this->name = "Buy Membergroup"; $this->desc = "Allows you to buy your way into a membergroup!"; $this->price = 1500; $this->require_input = false; $this->can_use_item = true; } function getAddInput() { global $db_prefix, $item_info; $result = db_query("SELECT groupName FROM {$db_prefix}membergroups", __FILE__, __LINE__); $row = mysql_fetch_array($result, MYSQL_ASSOC);while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $groups.=("<OPTION id='x{$i}' value='{$row[0]}'>{$row[0]}"); $i++; } return "Which Membergroup ID do you want to grant users access to?: <SELECT name='info1'>{$groups}</SELECT>";} function onUse() { global $db_prefix, $ID_MEMBER, $item_info, $user, $sourcedir;/////////////NOTICE change the following ID or your item will fail.$shophistoryID=0;//Set this to 0 if you don't have a shop history forum//Begin Shop historyif ($shophistoryID) { require_once($sourcedir . '/Subs-Post.php'); $topicOptions['board'] = $shophistoryID; //SHOP history forum $topicOptions['id']=0; //NEW topic $msgOptions['subject'] = "I just bought my way into the {$item_info[1]} membergroup!"; //Subject $msgOptions['body'] = "Yep!"; $posterOptions['id']=$ID_MEMBER; //Current user's ID createPost(&$msgOptions, &$topicOptions, &$posterOptions); //create the post using the SMF posting function}//End Shop history$groupID = mysql_fetch_array(db_query("SELECT `ID_GROUP` FROM {$db_prefix}membergroups WHERE groupName = '{$item_info[1]}'", __FILE__, __LINE__),MYSQL_ASSOC);$additionalGroups = mysql_fetch_array(db_query("SELECT `additionalGroups` FROM {$db_prefix}members WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__),MYSQL_ASSOC);if($additionalGroups['additionalGroups']) { $additionalGroups['additionalGroups'] = $additionalGroups['additionalGroups'].", ".$groupID['ID_GROUP'];} else { $additionalGroups['additionalGroups'] = $groupID['ID_GROUP'];} echo $groupID['ID_GROUP'].":";echo $additionalGroups['additionalGroups']; $result = db_query("UPDATE {$db_prefix}members SET additionalGroups = '{$additionalGroups['additionalGroups']}' WHERE ID_MEMBER={$ID_MEMBER}",__FILE__, __LINE__);$result = db_query(" INSERT INTO `{$db_prefix}awards_members` VALUES (20003, 2, {$ID_MEMBER}, 2007-01-07, 0) "); return "You're in the new group, {$item_info[1]}!!"; }}?>