vb.org Archive
Page 13 of 17 « First 31112 13 1415 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   vB Staff Titles (https://vborg.vbsupport.ru/showthread.php?t=93783)

scootman 01-05-2006 03:47 PM
Install great job :) Thanks

sinaluna 01-05-2006 11:11 PM
Quote:
Originally Posted by Breath
What would be the point of that are members can use custom titles anyway?
The same reason that staff need it. Custom titles are already being used and a separate line is needed for other purposes.

Xplorer4x4 01-19-2006 03:04 PM
Quote:
Originally Posted by Breath
Ok heres's a fix for it.

Open the xml file and change

Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')");
to

Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL)");
This does the trick on mysql5
Just a warning that I got a datbase error when I did this and now I get one when i try to add any product.

Here is the error:
Quote:
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-End Error Mess = 'a:4:{s:17:\"custom_link_added\";s:44:\"The custom link has su' at line 1
Error Number : 1064

Logikos 01-20-2006 02:10 AM
Quote:
Originally Posted by Xplorer4x4
I seemed to get this error when attemptin to use on my new server which makes me thinkg it is a PHP/MySQL conflict.

MySQL V5
PHP v4.4.1 & PHP v5.1.1

Not sure which is in effect.

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE user SET
        passworddate = FROM_UNIXTIME(1136455772),
        password = 'fb98a3830432d6ff9ad9ac5a5a1b7d4e',
        ### Bitfield: user.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 1024, options - 1024, options),
                options = IF(options & 16, options, options + 16),
                options = IF(options & 256, options - 256, options),
                options = IF(options & 512, options - 512, options),
                options = IF(options & 32, options - 32, options),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options - 4096, options),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 64, options, options + 64),
                options = IF(options & 128, options - 128, options),
                options = IF(options & 32768, options - 32768, options),
        usertitle = 'Administrator',
        customtitle = 0,
        username = 'Xplorer4x4',
        email = '',
        languageid = 0,
        homepage = '',
        birthday_search = '1984-10-22',
        birthday = '10-22-1984',
        showbirthday = 2,
        icq = '',
        aim = '',
        yahoo = '',
        msn = '',
        skype = '',
        parentemail = '',
        posts = 592,
        referrerid = 0,
        ipaddress = '',
        vbookie_cash = 500,
        ucash = '2230.54',
        isstaffrank = '0',
        staffrank = '',
        staffrank_opentag = '',
        staffrank_closetag = '',
        alerts = 0,
        warnings = 0,
        warning_level = 0,
        warning_bans = 0,
        usergroupid = 6,
        reputationlevelid = 5,
        reputation = 23,
        pmpopup = 1,
        autosubscribe = -1,
        threadedmode = 0,
        showvbcode = 2,
        styleid = 0,
        timezoneoffset = '-6',
        daysprune = 0,
        joindate = 1132099380,
        lastactivity = 1136455740,
        lastpost = 1136455620,
        membergroupids = ''
WHERE userid = 1;

MySQL Error  : Unknown column 'isstaffrank' in 'field list'
Error Number : 1054
Date                : Thursday, January 5th 2006 @ 10:09:32 AM
Script          : /admincp/user.php
Referrer        : /admincp/user.php?do=edit&u=1
IP Address  :
Username        : Xplorer4x4
Classname        : vb_database
hmmm, I've just installed on 3.5.3 and everything works fine.

Logikos 01-20-2006 02:15 AM
The only problem I saw was a incorrect phrase. Fixed and updated.

Guest210212002 01-20-2006 02:52 AM
/tag

LincolnForums 01-31-2006 08:59 PM
doesnt work on mysql5 or php5 not sure which

Xplorer4x4 02-03-2006 08:10 PM
Quote:
Originally Posted by Breath
Ok heres's a fix for it.

Open the xml file and change

Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')");
to

Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL)");
This does the trick on mysql5
Now I get a datbase error everytime i install ANY plug in. The error is to large to fit in this thread, so canb some one please help me repair the problem.
https://vborg.vbsupport.ru/attachmen...chmentid=42063

Dark s.s. Trunk 02-03-2006 09:47 PM
I like but i get one error it overrides the admin titles doesnt add a second.. and everything was dune to the instructions..

craiovaforum 02-04-2006 07:24 PM
can this be modified to do it per usergroup?


All times are GMT. The time now is 11:49 AM.
Page 13 of 17 « First 31112 13 1415 Last »
Show 40 post(s) from this thread on one page

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.01431 seconds
  • Memory Usage 1,749KB
  • 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
  • (5)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete