vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Confused about this query (https://vborg.vbsupport.ru/showthread.php?t=266511)

HMBeaty 07-09-2011 12:20 AM
Confused about this query
 
Hello again :D

So, I'm finally starting to learn how to add custom usergroup permissions, and have been somewhat successful (I think), however, in the install code for my modification, I first tried:
Code:
$db->hide_errors();

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup
    ADD usmlsaperms int(10) unsigned NOT NULL default '0',
    ADD staffappminpostreq int(10) NOT NULL default '100',
    ADD staffappminrepreq int(10) NOT NULL default '100',
    ADD staffappminregreq int(10) NOT NULL default '100'
");

$db->show_errors();
...which didn't work. So, I went the long way and tried:
Code:
$db->hide_errors();

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup
    ADD usmlsaperms int(10) unsigned NOT NULL default '0'
");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup
    ADD staffappminpostreq int(10) NOT NULL default '100'
");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup
    ADD staffappminrepreq int(10) NOT NULL default '100'
");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup
    ADD staffappminregreq int(10) NOT NULL default '100'
");

$db->show_errors();
....which seems to work so far.

So, my question is, why didn't the first code work? :confused:

LifesGreatestGift 07-09-2011 01:23 AM
maybe this

Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD
    (usmlsaperms int(10) unsigned NOT NULL default '0',
    staffappminpostreq int(10) NOT NULL default '100',
    staffappminrepreq int(10) NOT NULL default '100',
    staffappminregreq int(10) NOT NULL default '100')
");


All times are GMT. The time now is 10:00 PM.

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.01090 seconds
  • Memory Usage 1,709KB
  • 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
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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