vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   User Reset MySQL Errors & Issues (https://vborg.vbsupport.ru/showthread.php?t=120167)

DragoZERO 07-02-2006 08:37 PM
User Reset MySQL Errors & Issues
 
Whenever I try to reset user data, I am given an error message about the SQL syntax. It says there is an error in the syntax and the query cannot be completed.

Any solutions and/or help is much appreciated.

DragoZERO 07-13-2006 01:05 AM
Sorry for the double post:

Could I get the raw reset SQL code? I'll just do it manually through ACP or through phpMyAdmin.

Revan 07-13-2006 09:41 AM
I am fixing this atm, I didnt answer because theres already many posts about this.

DragoZERO 07-13-2006 09:48 PM
Yes.. I just got an e-mail about the update. Normally I would have searched, but I am very busy with work and such. Thanks tho Revan, props to you.

Okay, there are no SQL errors.. but its not work now. It goes through fine, but nothing changes. I've cleared and reset caches on the forum and my browser, also had someone else try and nothing.

And I get this if I reset it myself through headquarters.php:


http://img153.imageshack.us/img153/2...ror13ni.th.jpg

Code:
UPDATE vb_rpg_user SET
        ap = 0,
        maxhp = 25,
        maxmp = 4,
        maxpp = 0,
        hp = 19,
        mp = 0,
        pp = 0,
        hascharacter = 0,
        rpgname = 'N/A',
        battles = 0,
        wins = 0,
        losses = 0,
        draws = 0,
        retreats = 0,
        alignmentid = 1,
        classid = 1,
        genderid = 1,
        raceid = 1,
        typeid = 1
WHERE userid = 1

UPDATE `vb_user` SET `rpg` = 'a:30:{s:6:"userid";s:1:"1";s:11:"alignmentid";s:1:"1";s:7:"classid";s:1:"1";s:6:"clanid";s:1:"5";s:9:"elementid";s:0:"";s:8:"genderid";s:1:"1";s:6:"raceid";s:1:"1";s:6:"typeid";s:1:"1";s:2:"hp";s:2:"19";s:5:"maxhp";s:2:"25";s:2:"mp";s:1:"0";s:5:"maxmp";s:1:"4";s:2:"pp";s:1:"0";s:5:"maxpp";s:1:"0";s:2:"ap";s:1:"0";s:2:"xp";s:1:"0";s:7:"rpgname";s:3:"N/A";s:8:"dropdown";s:1:"0";s:12:"canchallenge";s:1:"0";s:10:"inputlevel";s:1:"1";s:5:"level";s:1:"1";s:8:"battleid";s:1:"0";s:15:"monsterbattleid";s:1:"0";s:7:"battles";s:1:"0";s:4:"wins";s:1:"0";s:6:"losses";s:1:"0";s:5:"draws";s:1:"0";s:8:"retreats";s:1:"0";s:12:"hascharacter";s:1:"0";s:13:"gmpermissions";s:0:"";}' WHERE `userid` = '1'
If I enter that code in manually, it does the trick.. so yeah.

Revan 07-14-2006 10:33 AM
ugh >_<

DragoZERO 07-15-2006 10:01 PM
Okay.. the update changed a few things. Now, once you click reset and all.. you get a blank screen, white - nothing more. Your money and items are the only thing that is reset.


All times are GMT. The time now is 05:36 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.00933 seconds
  • Memory Usage 1,725KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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