The Arcive of Official vBulletin Modifications Site.

vietfancy · #1 01-14-2010, 11:10 AM

I'm not sure what causes it. The first time it go though, but when i re-imported the code, it gives me error , but if I change the productid to something else then it will go through.

Here is the database error message.

Code:

			UPDATE template SET
				styleid = -10
			WHERE product = 'ese_scholarship' AND styleid = -1;

MySQL Error   : Duplicate entry 'ese_scholarship--10-template' for key 'title'

and here is the product code:

PHP Code:


			
<?xml version="4.0" encoding="utf-8"?>

<product productid="ese_scholarship" active="1">

    <title>ESE Scholarship</title>

    <description>ESE scholarship</description>

    <version>4.0</version>

    <url />

    <versioncheckurl />

    <dependencies>

    </dependencies>

    <codes>

        <code version="4.0">

            <installcode><![CDATA[$db->query("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "ese_scholarship` (                                               `id` int(4) unsigned NOT NULL AUTO_INCREMENT,

                          `donor` varchar(120) NOT NULL,

                          `amount` varchar(100) NOT NULL,

                          `fee` varchar(10) NOT NULL,

                          `month` varchar(10) NOT NULL,

                          `date` varchar(20) NOT NULL,

                          `year` varchar(4) NOT NULL,

                          PRIMARY KEY (`id`)

                          ) ENGINE=MyISAM");

$db->show_errors();]]></installcode>

            <uninstallcode><![CDATA[$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "ese_scholarship`");

$db->show_errors();]]></uninstallcode>

        </code>

    </codes>

    <templates>

    <template name="ese_scholarship" templatetype="template" date="1260504996" username="JK" version="1.0">

    <![CDATA[{vb:stylevar htmldoctype}

<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">

  <head>

    <title>ESE Scholarship - {vb:raw vboptions.bbtitle}</title>

    {vb:raw headinclude}

    <style type="text/css">

.ese_extra_top{

    width:100%;

    font-weight:bolder;

        text-align:center;

}

.ese_extra{

    width:100%;

    height:30px;

}

    .tname{

        width:20%;

        text-align:center;

    }

    .tfee{

        width:15%;

        text-align:center;

    }

    .tamount{

        width:17%;

        text-align:center;    

    }

    .tdate{

        width:15%;

        text-align:center;    

    }

    .ttotal{

        width:15%;

        text-align:center;

    }

    .sname{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;

    }

    .sfee{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;

    }

    .samount{

    border-bottom: 1px solid #5a7f97;

        width:17%;

        text-align:center;    

    }

    .sdate{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;    

    }

    .stotal{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;

        color:#C00;

    }





    .atname{

        width:20%;

        text-align:center;

    }

    .atdate{

        width:20%;

        text-align:center;    

    }

    .atfee, .atamount, .attotal, .atcp{

        width:12%;

        text-align:center;

    }





    .aname{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;

    }

    .adate{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;    

    }

    .afee{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

    }

    .aamount{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;    

    }



    .atotal{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

        color:#C00;

    }

    .acp{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

    }

    </style>

  </head>

  <body>

    {vb:raw header}

    {vb:raw navbar}

<!-- Custom Code -->

<div style="padding:10px;"></div>

<vb:if condition="$ese_scholarship['do'] == 'add'">

    <h2 class="blockhead">Add A Donor to the Database</h2>

    <div class="blockbody"><div class="blockrow">

<vb:if condition="is_member_of($bbuserinfo, 6)"> 

<!-- start add form -->

<form action="scholarship.php?do=added"  method="post">

<input type="hidden" name="s" value="value" />

<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />

<table class="tborder" cellpadding="0" cellspacing="6" border="0" width="100%" align="center">

    <tr valign="top">

        <td class="alt1" width="120" align="left" nowrap="nowrap">

        <div style="padding:4px;">Month / Date / Year:</div>

        <div style="padding:4px;">Donor:</div>

        <div style="padding:4px;">Base Amount:</div>

        <div style="padding:4px;">Transfer Fee:</div>

        </td>

        <td class="alt2" width="35%">

        <div style="padding:3px;"><SELECT  name="month">

                <option disabled selected>Month</option>

                <OPTION value="Jan">January</OPTION>

                <OPTION value="Feb">February</OPTION>

                <OPTION value="Mar">March</OPTION>

                <OPTION value="Apr">April</OPTION>

                <OPTION value="May">May</OPTION>

                <OPTION value="Jun">June</OPTION>

                <OPTION value="Jul">July</OPTION>

                <OPTION value="Aug">August</OPTION>

                <OPTION value="Sept">September</OPTION>

                <OPTION value="Oct">Octorber</OPTION>

                <OPTION value="Nov">November</OPTION>

                <OPTION value="Dec">December</OPTION>

                </SELECT> / 

                <SELECT  name="date">

                <option disabled selected>Date</option>

                <OPTION value="01">01</OPTION>

                <OPTION value="02">02</OPTION>

                <OPTION value="03">03</OPTION>

                <OPTION value="04">04</OPTION>

                <OPTION value="05">05</OPTION>

                <OPTION value="06">06</OPTION>

                <OPTION value="07">07</OPTION>

                <OPTION value="08">08</OPTION>

                <OPTION value="09">09</OPTION>

                <OPTION value="10">10</OPTION>

                <OPTION value="11">11</OPTION>

                <OPTION value="12">12</OPTION>

                <OPTION value="13">13</OPTION>

                <OPTION value="14">14</OPTION>

                <OPTION value="15">15</OPTION>

                <OPTION value="16">16</OPTION>

                <OPTION value="17">17</OPTION>

                <OPTION value="18">18</OPTION>

                <OPTION value="19">19</OPTION>

                <OPTION value="20">20</OPTION>

                <OPTION value="21">21</OPTION>

                <OPTION value="22">22</OPTION>

                <OPTION value="23">23</OPTION>

                <OPTION value="24">24</OPTION>

                <OPTION value="25">25</OPTION>

                <OPTION value="26">26</OPTION>

                <OPTION value="27">27</OPTION>

                <OPTION value="28">28</OPTION>

                <OPTION value="29">29</OPTION>

                <OPTION value="30">30</OPTION>

                <OPTION value="31">31</OPTION>

                </SELECT> / 

                <SELECT  name="year">

                <option disabled selected>Year</option>

                <OPTION value="2010">2010</OPTION>

                <OPTION value="2011">2011</OPTION>

                <OPTION value="2012">2012</OPTION>

                <OPTION value="2013">2013</OPTION>

                <OPTION value="2014">2014</OPTION>

                <OPTION value="2016">2015</OPTION>

                <OPTION value="2016">2016</OPTION>

                </SELECT></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="donor" autocomplete="off" /></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="amount" autocomplete="off" /></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="fee" autocomplete="off" /></div>

        </td>

        <td class="alt1" width="65%" align="left" nowrap="nowrap">

        <div style="padding:3px;">text go here</div>



        </td>

    </tr>

    <tr valign="top">

        <td class="alt2" colspan="3" width="100%" align="center" style="padding-top:20px;">

        <input type="submit" class="button" value="Submit" accesskey="s" />

        <input type="reset" class="button" value="Reset" accesskey="s" />

        </td>

    </tr>

</table>

</form>

<!-- end add form -->

<!-- End Custom Code -->

<vb:else />

     <div class="alert">You don't have permission to access this page.</div>

</vb:if>

      </div></div>

<vb:else />

<!-- START ESE DONATE -->

<h2 class="blockhead"><b>Donation Options</b></h2>

<div class="blockbody"><div class="blockbody">

<table class="ese_extra"><tr>

<td style="padding:10px;" width="50%" ><ul>

  <li><strong>Using Paypal:</strong><br/>

    1. You must have a paypal account to use this option.<br/>

    2. Paypal home page: <a href="http://www.paypal.com"> www.paypal.com</a><br/>

    <br/>

  </li></ul>

    <hr>

    1. You can go to <a href="http://www.paypal.com"> Paypal</a> and make a donation to <strong><font color="#FF0000">ESE.Scholarship@gmail.com</font></strong><br/>

    or<br/>

    2. You can just click on the button below to go to the donation page.<br/><br/>

    <div align="center">

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="cmd" value="_donations">

<input type="hidden" name="business" value="ESE.Scholarship@gmail.com">

<input type="hidden" name="item_name" value="Make a donation to support ESE scholarship.">

<input type="hidden" name="no_shipping" value="0">

<input type="hidden" name="no_note" value="1">

<input type="hidden" name="currency_code" value="USD">

<input type="hidden" name="tax" value="0">

<input type="hidden" name="lc" value="US">

<input type="hidden" name="bn" value="PP-DonationsBF">

<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but21.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">

<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">

</form>



    </div>

    </td>     

<td style="padding:10px;" width="50%">



<ul>

  <li><strong>By Mail:</strong><br/>

    1. Attach a note to inform us of who you are. Please use nick on Paltalk and/or in this forum. Please include your email address.<br/>

    2. If you wish to be anonymous, please state that in your note.<br/>

    <br/>

  </li></ul>



  <hr>



Mail a check or money order to the address given below:<br/>

<br/>

<strong>    <font color="#FF0000">ESE Scholarship<br/>

    c/o Nguyen<br/>

    P.O. BOX 90481<br/>

    San Jose, Ca 95109, USA</font><br/>

</strong></td>     

</tr>  

</table></div></div>

<!-- /END ESE DONATE -->



{vb:raw current_total}

<h2 class="blockhead"><b>ESE Scholarship Fund</b></h2>

<vb:if condition="$bbuserinfo[userid] == 1">

<div class="blocksubhead">{vb:raw ese_admin_fund_top}</div>

<div class="blockbody"><div class="blockrow">

{vb:raw ese_admin_fund}

</div></div>

<vb:else />

<div class="blocksubhead">{vb:raw ese_fund_top}</div>

<div class="blockbody"><div class="blockrow">

{vb:raw ese_fund}

</div></div>

</vb:if>

<!-- End Custom Code -->

</vb:if>

    {vb:raw footer}

  </body>

</html>]]>

    </template>

    </templates>

</product>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05234 seconds Memory Usage 2,303KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)showthread_list (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_threadedmode.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids_threaded showthread_threaded_construct_link showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!