vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   RPG Integration Hack /w Battle (BETA) (https://vborg.vbsupport.ru/showthread.php?t=46417)

VeoMorphine 01-28-2003 03:40 PM

Quote:

Originally posted by Riddel
Oh, another thing to ask: I don't know if this might help any in pinpointing the problems/errors I'm getting (item shop not working), but even though there are members with 1000+ posts, the itemshop only allows them to purchase level 0 item. However, when I tried to purchase a level 0 item, I received a databse error:


Database error in vBulletin 2.2.9:

Invalid SQL: SELECT userpostcount,levelfield,exprate FROM battle_options
mysql error: Unknown column 'userpostcount' in 'field list'

mysql error number: 1054

Date: Tuesday 28th of January 2003 08:54:20 AM
Script: /metropolis/itemshop.php?action=buy&cat=1&item=Javelin&itemtyp e=0
Referer: http://www.zanarkand.net/metropolis/...l=1&itemtype=0


I think this error might be contained only to the itemshop since members' stats are looking normal, so I'm guessing that I probably messed up the code somewhere. Would uploading a fresh copy of itemshop.php help, or are there other files I will need to upload?

Btw, thanks a lot for helping us out! This hack is really awesome.

It looks to me like one of the querys did not run on the install. Try re-running the install script and make it recreate the battle_options table. Make sure it creates it with the userpostcount, levelfield, and exprate collums.

VeoMorphine 01-28-2003 03:57 PM

Another Release.

This is just a getinfo template with everything in it allready for the member profile add-on. it's attached a zip, just replace the templates with the ones labled in the text files.

http://www.neurofreeze.net/forums/me...tinfo&userid=3

This should also work on ANY style.

There is an example/demo of the getinfo

VeoMorphine 01-28-2003 07:18 PM

I feel giving today :P

bitsys forgot to put this witht he postbit vars. So here is the code to put on the profile addon/postbit to let mods take and give money from bank/pocket.


For Pocket
PHP Code:

                    <a href="javascript:void(window.open('moderator.php?s=$session[sessionhash]&action=points&userid=$userinfo[userid]', '', 'toolbar=no,scrollbars=no,resizable=no,width=500,height=250'));">Money in Pocket:</a$rpgcash<br


For Bank
PHP Code:

                    <a href="javascript:void(window.open('moderator.php?s=$session[sessionhash]&action=bankmod&userid=$userinfo[userid]', '', 'toolbar=no,scrollbars=no,resizable=no,width=500,height=250'));">Money in Bank:</a$rpgbank<br


Darkwaltz4 01-29-2003 01:43 AM

heey--veomorphine, ur contributions are pretty good ^_^

i love the template setup for the profile, and the admin manual (while useless for me, since i long memorized how to set stuff up) will be great so i dont have to explain it all to my other admin. he probably wont read it all....

i have some stuff i did to the itemshop templates and added some code to it (lol, the itemshop is my favorite part of this)

first, when i tried to remove the link to buy a personal itemshop (i dont like them, and i intend to apply a link to my own hack soon in its area), the links that go to the item types dissappeared. and i dont know why since they did not appear to be variables, and i certainly did not take any out from the template. so, to go around that, i came up with lines to say to ppl, which explain which itemshop they are in, what type they are (it will display a link to their itemshop if they are in the wrong one), an 'edit your character link' (its a 'register' link when you are not logged in) a link to the itemshop faq i wrote, and links to the other itemshop. in addition, all of the buying messages that appear throughout the itemshop page, now dump you at your itemshop, instead of the plain itemshop.php. and the links from the homepage and postbits now has a link that will take you directly to your itemshop. all basically done by tacking ?itemtype=$bbuserinfo[rpgtype] to all itemshop.php urls. my members especially like not having to go through the before-complicating lists of types, and i didnt like how it displayed them either, and now im rambling...

anyway, yes...

saint_seiya 01-29-2003 01:45 AM

BitSys, I will tell you what the error is as soon as i see that noone is browsing the forums (so i can make the change and get the error again ;) )

mr e 01-29-2003 02:18 AM

Here's a hack I created by me, quite useful too.

Special Classes for Mod/Admin only - mr e

Basically this makes it so only mods/admins can see/use certain classes you upload, 1 for any user, 0 for only mods/admins, also puts an * by any that are mod/admin specific so you can distinguish them in the drop down list.

Edit: Fixed small error

mr e 01-29-2003 02:22 AM

Screenshot...I'll be releasing the hack to change the options to look like this, easier viewing for me at least, probably tomorrow at the latest.

mr e 01-29-2003 03:15 AM

Here's the hack to make your CP look like mine did with tables and such

Easier Labels - mr e
Basically makes the list's into tables instead with improved viewing, or at least for me it' much easier, this changes your edit classes/races/elements pages.

Screenshot 1 post up

VeoMorphine 01-29-2003 07:55 PM

looks like i started a trait to adding addons :P

ill be releasing a Manual for Users on how to do things in the RPG hack and i'll also be releaing a central panel for the RPG hack :)

Mystic Gohan 01-29-2003 08:26 PM

PHP Code:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQLALTER TABLE rpg_classf ADD visible SMALLINT(5NOT NULL DEFAULT=1
mysql error
You have an error in your SQL syntax near '=1' at line 1

mysql error number
1064

Date
Wednesday 29th of January 2003 05:16:13 PM
Script
: [url]http://www.gotdbz.com/forum/forum/admin/specclasses.php?action=yes[/url]
Referer: [url]http://www.gotdbz.com/forum/admin/specclasses.php[/url] 

i got that for when i tried to run specclassed? can u help me mr e?


All times are GMT. The time now is 04:12 AM.

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.03230 seconds
  • Memory Usage 1,756KB
  • 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_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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