View Single Post
  #1724  
Old 06-03-2003, 01:03 AM
Bitsys's Avatar
Bitsys Bitsys is offline
 
Join Date: Oct 2002
Posts: 444
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 04:46 PM v0id said this in Post #1737
Bytsis, I did a full RPG reset (I put YES to EVERYTHING) and it did not clear the battle_stats table (I tried twice, both times the data was not erased/dropped).
The data is not supposed to be dropped, it is only supposed to be reset. By reset, I mean that the fields should be set to 0 (all except the userid field). Did your members' battle stats get reset to 0-0-0-0? Or did they retain their old battle records?

To verify that the table has been reset, you can run this query
Code:
UPDATE battle_stats SET battles=0, wins=0, losses=0, draws=0, retreats=0
and compare the data in the table after running the query with the data in the table before running the query.

Quote:
Today at 05:28 PM PixelFx said this in Post #1738
bitsys,

for now just the word from gil to gold

then later the system you and I talked about... the above would be quick fix I hope
Hmm, I would assume you could do a mass template esit in the admin cp. Replace "gil" with "gold", right? I guess I could go make a list and location of each place where the word "gil" is used, but that seems like too much work for such a simple problem. Have you tried anything yet to switch it?

Quote:
Today at 05:28 PM PixelFx said this in Post #1738
Found Error,

When I setup a dual with someone and attack... I hit the attack button and it says the following..

Invalid SQL: SELECT field6 FROM userfield WHERE userid='13'
mysql error: Unknown column 'field6' in 'field list'
1. Go to your admin panel
2. Go to modify user profile fields
3. Find the RPG Name profile field
4. Right click over the edit link and go to copy shortcut
6. Copy it in your browser
7. Near the end there will be a number. Remember that number
8. Go to edit the battle options
9. In the top option put in field# and replace number with the number you recorded in step 7.

Let me know if that helps.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01260 seconds
  • Memory Usage 1,770KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete