PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'vbmusic_create_artist');
define('CSRF_PROTECTION', true);
// change this depending on your filename
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();
// get special data templates from the datastore
$specialtemplates = array();
// pre-cache templates used by all actions
$globaltemplates = array('vbmusic_create_artist',
);
// pre-cache templates used by specific actions
$actiontemplates = array();
// ######################### REQUIRE BACK-END ############################
// if your page is outside of your normal vb forums directory, you should change directories by uncommenting the next line
// chdir ('/path/to/your/forums');
require_once('./global.php');
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$navbits = construct_navbits(array('' => 'Create Artist'));
$navbar = render_navbar_template($navbits);
// ###### YOUR CUSTOM CODE GOES HERE #####
$pagetitle = 'Create Artist';
$artist = "artist";
$name = $_POST['name'];
$dbirth = $_POST['dbirth'];
$country = $_POST['country'];
$homepage = $_POST['homepage'];
if ($_REQUEST['do'] == "createartist")
{
$createartist = $vbulletin->input->clean_array_gpc('p', array(
'name' => TYPE_STR,
'dbirth' => TYPE_INT,
'country' => TYPE_STR,
'homepage' => TYPE_NOHTML
));
if ($name!='') {
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "" . $artist . "
(arname, dbirth, lbirth, homepage)
VALUES (" . $db->escape_string($vbulletin->GPC['name']) . "," . $db->escape_string($vbulletin->GPC['dbirth']) . "," . $db->escape_string($vbulletin->GPC['country']) . "," . $db->escape_string($vbulletin->GPC['homepage']) . ")
");
$id = $vbulletin->db->insert_id();
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "artdescr
(arid, ardescr)
VALUES (".$db->escape_string($vbulletin->GPC['id']).",".$db->escape_string($vbulletin[''])." ");
}
}
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('vbmusic_create_artist');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('name', $name);
$templater->register('dbirth', $dbirth);
$templater->register('artist', $artist);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());
?>
PHP Code:
<div class="audio_head"><h2>Create Artist</h2></div>
<div class="audio_body formcontrols">
<br />
<form action="vbmusic_create_artist.php?do=createartist" method="post" class="vbform block">
<div class="blockrow">
<label for="name">{vb:rawphrase artist_name}:</label>
<div>
<input type="text" class="primary textbox" name="name" id="name" value="{vb:raw name}" size="50" maxlength="85" tabindex="1" />
</div>
</div>
<div class="blockrow">
<label for="birthday">{vb:rawphrase artist_birthday}:</label>
<div>
<input name="birth" type="text" id="dbirth" class="textbox" size="40" maxlength="100" />
</div>
</div>
<div class="blockrow">
<label for="country">{vb:rawphrase artist_country}:</label>
<div>
<input name="country" type="text" id="country" class="textbox" size="40" maxlength="100" />
</div>
</div>
<div class="blockrow">
<label for="homepage">{vb:rawphrase artist_homepage}:</label>
<div>
<input name="homepage" type="text" id="homepage" class="textbox" size="40" maxlength="100" />
</div>
</div>
<div class="blockrow">
<label for="upload_url">{vb:rawphrase artist_upload_url}:</label>
<div>
<input name="name" type="text" id="name" class="textbox" size="40" maxlength="100" />
</div>
</div>
<div class="blockrow">
<label for="upload_pc">{vb:rawphrase artist_upload_pc}:</label>
<div>
<input name="covfil" size="35" tabindex="1" type="file" />
<input name="MAX_FILE_SIZE" value="999999999" type="hidden" />
</div>
</div>
<br /><br /><br /><br />
<div class="blockfoot actionbuttons">
<div class="group">
<input class="button" name="add" type="submit" id="submit0" value="{vb:rawphrase submit}" />
<input class="button" name="cancel" type="button" id="cancel" value="{vb:rawphrase cancel}" onclick="window.location.href='vbmusic.php?'" type="button" />
</div></div>
<input type="hidden" name="s" value="{vb:raw session.sessionhash}" />
<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />
<input type="hidden" name="do" value="createartist" />
</form>
</div></div>
Can anyone tell me what I'm doing wrong. I can't get the info to insert into the database.
More Information