vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Product Install/Uninstall XML Code (https://vborg.vbsupport.ru/showthread.php?t=107107)

Nullifi3d 02-04-2006 12:30 AM
Product Install/Uninstall XML Code
 
For some reason my install code is not creating the table in the db. I have tried the following two codes variations:
Code:
        <codes>
                <code version="1.0.0">
                        <installcode><![CDATA[$install[] = "CREATE TABLE " . TABLE_PREFIX . "banners (
        userid int(10) unsigned NOT NULL default '0',
        username varchar(100) NOT NULL default '',
        title varchar(250) NOT NULL default '',
        url varchar(250) NOT NULL default '',
        link varchar(250) NOT NULL default '',
        ext varchar(4) NOT NULL default '',
        width int(3) NOT NULL default '0',
        height int(3) NOT NULL default '0',
        clicks int(10) NOT NULL default '0',
        available int(10) NOT NULL default '0',
        impressions int(10) NOT NULL default '0',
        status varchar(8) NOT NULL default '',
        PRIMARY KEY  (`userid`)
) ENGINE=MyISAM";]]></installcode>
                        <uninstallcode><![CDATA[$uninstall[] = "DROP TABLE " . TABLE_PREFIX . "banners";]]></uninstallcode>
                </code>
        </codes>
&
Code:
        <codes>
                <code version="1.0.0">
                        <installcode><![CDATA[$db->query_write = "CREATE TABLE " . TABLE_PREFIX . "banners (
        userid int(10) unsigned NOT NULL default '0',
        username varchar(100) NOT NULL default '',
        title varchar(250) NOT NULL default '',
        url varchar(250) NOT NULL default '',
        link varchar(250) NOT NULL default '',
        ext varchar(4) NOT NULL default '',
        width int(3) NOT NULL default '0',
        height int(3) NOT NULL default '0',
        clicks int(10) NOT NULL default '0',
        available int(10) NOT NULL default '0',
        impressions int(10) NOT NULL default '0',
        status varchar(8) NOT NULL default '',
        PRIMARY KEY  (`userid`)
) ENGINE=MyISAM";]]></installcode>
                        <uninstallcode><![CDATA[$db->query_write = "DROP TABLE " . TABLE_PREFIX . "banners";]]></uninstallcode>
                </code>
        </codes>

Nullifi3d 02-06-2006 09:05 PM
Does anyone know why these would not work?

Andreas 02-06-2006 09:26 PM
I'd suggest to use proper codes

Install
PHP Code:
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "banners (
    userid int(10) unsigned NOT NULL default '0',
    username varchar(100) NOT NULL default '',
    title varchar(250) NOT NULL default '',
    url varchar(250) NOT NULL default '',
    link varchar(250) NOT NULL default '',
    ext varchar(4) NOT NULL default '',
    width int(3) NOT NULL default '0',
    height int(3) NOT NULL default '0',
    clicks int(10) NOT NULL default '0',
    available int(10) NOT NULL default '0',
    impressions int(10) NOT NULL default '0',
    status varchar(8) NOT NULL default '',
    PRIMARY KEY  (`userid`))
"); 
Uninstall
PHP Code:
$db->query_write("DROP TABLE " . TABLE_PREFIX . "banners"); 


All times are GMT. The time now is 12:51 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01009 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete