Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 09-22-2010, 05:43 PM
Mopar Rob Mopar Rob is offline
 
Join Date: Jul 2010
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default NEWB Quest: How to add a new Field to Table

Ok here is a real NEWB questions, I went through a whole MOD and edited all kinds of lines in .php files then to find out I need to add a new FIELD to an existing table. HOW DO I DO THAT?? I need to add a "rankorder" field to the RANKS table.

Any help will be greatful.
Reply With Quote
  #2  
Old 09-22-2010, 06:14 PM
betts02's Avatar
betts02 betts02 is offline
 
Join Date: Jun 2009
Posts: 910
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Admin -
User Profile Fields -
Add New User Profile Field

Fill it in and save

Whwn done it shall have the filed you have just created
Look what FIELD it has given you for this

Then that is the field id you need for your mod
Some mods are different so first try -

"Field(the number)"

if this does not work then try just the number
Reply With Quote
  #3  
Old 09-22-2010, 06:19 PM
Mopar Rob Mopar Rob is offline
 
Join Date: Jul 2010
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I thought the way the instructions were written it says I need to add a FIELD to the existing RANKS table. So by adding a custom user field wouldnt work I think. Here is the Mod I am doing. It starts with the second LINE on Post #20 The Quote from the coder is:>>>>> In theory, all we need to do is add a field to the "rank" table called "rankorder".<<<<<

https://vborg.vbsupport.ru/showthrea...NKORDER&page=2

I did all of teh Text edits to the .PHP files they reference. So now its looking for that "RANKORDER FIELD"

--------------- Added [DATE]1285183256[/DATE] at [TIME]1285183256[/TIME] ---------------

Here is the ERROR I am getting. I am assuming that the error is because I do not have the RANKORDER field added to the Rank database.

Database error in vBulletin 4.0.5:
Invalid SQL:
SELECT rankid, ranklevel, minposts, rankimg, ranks. usergroupid,title, type, display, stack, rankorder
FROM ranks AS ranks
LEFT JOIN usergroup AS usergroup USING(usergroupid)
ORDER BY rankorder, ranks.usergroupid, minposts;
MySQL Error : Unknown column 'rankorder' in 'field list'
Error Number : 1054
Reply With Quote
  #4  
Old 09-22-2010, 08:27 PM
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Posts: 1,630
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you shouldn't edit the php files,use the pluginsystem instead!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:21 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03788 seconds
  • Memory Usage 2,181KB
  • 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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (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_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
  • 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