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)

Strider Xero 02-09-2003 03:32 AM

The big thing i dont like about this hack is that you have to update your stats from the profile all the time. I got tired of it that's why i dont use it anymore. I dont understand why there cant be an option where it updates your bars automatically...it's so much more convenient. This is the only rpg hack that i know of you need to do this with(php&mysql boards in general, not just vB)

Dribbles 02-09-2003 02:48 PM

Quote:

Originally posted by mr e
what happens when a level 20 challenges a level 2?
Either the level two needs to join a group or become someone's prag, or he's dead meat :dead:

Bitsys 02-09-2003 03:31 PM

Solice:
All I can suggest now is to wait for the next version. It will tell you specifically what you need to do in order to be eligible for battle.

Graphics (first post):
Random battles are not very feasible at this time.

Graphics (second post):
A long time ago (back when I was first working on this hack), I tried to add the limit break hack. I tried all sorts of things to add it in. Eventually, I realized that the limit break hack is not a very easy thing to implement using the mysql database and admin control panel. In fact, due to the large amounts of data involved, I was very enthusiastic about adding 5 separate limit breaks per class, since there are 30+ classes. Not to mention the balancing issues that span different classes. Maybe someone will make an add-on for it.

Rufus69:
Did you read https://vborg.vbsupport.ru/showthrea...014#post329014 yet?

Dribbles:
That's how I originally had this hack, before I released it here. However, my members complained quite a bit. In short, allowing it would create too much griefing. That's why I made the confirmation part of the battle.

Strider Xero:
It takes a minimal amount of hacking to do what you want. However, it also adds to the server load. There is always a trade-off and I never felt like it was worth it.


I don't think the next version will be released today. I have decided to add some more features. These additions will delay the release. However, I think you will be pleased with the new additions.

Dribbles 02-09-2003 03:33 PM

Quote:

Originally posted by Bitsys
Dribbles:
That's how I originally had this hack, before I released it here. However, my members complained quite a bit. In short, allowing it would create too much griefing. That's why I made the confirmation part of the battle.

Thanks, it's a great hack either way. Would it be possible to make this an option you can turn on and off in the admin cp? (ie- "Turn on/off battle confirmation from both users before attacks are allowed")

Graphics 02-10-2003 07:10 AM

So when is this version out I cant open my forum till the bugs are fixed :S

Dribbles 02-10-2003 12:45 PM

Why not?

SHoeSTeR 02-10-2003 03:46 PM

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,items_options.lesanes tore,battle_options.namefield,battle_options.expra te,battle_options.privacy AS battleprivacy,items_user.*,battle_stats.*,rpg_race .name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,battle_options.namefi eld,battle_options.usepostcount,battle_options.exp rate,battle_options.levelfield,battle_options.priv acy AS battleprivacy,items_user.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post, battle_options, items_options
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,9689,9690,9691,9745,10038)
ORDER BY dateline

mysql error: Unknown table 'battle_stats'

mysql error number: 1051

Date: Monday 10th of February 2003 11:43:13 AM
Script: http://64.191.17.37/~gosuleet/forums...p?threadid=787
Referer:


Please help.

Bitsys 02-10-2003 04:23 PM

Dribbles:
I am not sure if that is possible. There are several places that deal with the confirmation. I have to check and see if they can just be ignored and the battle continues.


Quote:

Originally posted by SHoeSTeR
Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,items_options.lesanes tore,battle_options.namefield,battle_options.expra te,battle_options.privacy AS battleprivacy,items_user.*,battle_stats.*,rpg_race .name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,battle_options.namefi eld,battle_options.usepostcount,battle_options.exp rate,battle_options.levelfield,battle_options.priv acy AS battleprivacy,items_user.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post, battle_options, items_options
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,9689,9690,9691,9745,10038)
ORDER BY dateline

mysql error: Unknown table 'battle_stats'

mysql error number: 1051

Date: Monday 10th of February 2003 11:43:13 AM
Script: http://64.191.17.37/~gosuleet/forums...p?threadid=787
Referer:


Please help.

In showthread.php, find both instances of
PHP Code:

LEFT JOIN items_user ON items_user.userid=user.userid 

and after it, put:
PHP Code:

LEFT JOIN battle_stats ON battle_stats.userid=user.userid 

Let me know if that works.

Dribbles 02-10-2003 05:54 PM

well, you're already doing a lot of great work for this hack ... so if it is a problem, don't worry about it man :) Just focus on the important stuff :) Will the next version be out soon?

Darkwaltz4 02-10-2003 08:04 PM

bitsys i have two suggestions::

keep in mind real quick that you never post template changes in the manual update mode -_- (so im not sure if these have been done yet)

anyway:

whenever a person submits information about their character in their profile, it updates them automatically...

2,
whenever you set element stat increases, how about making decreases available as well? my other admin thought this would be cool, and i think so too--i think it would mainly just be signing the column in the database (to accept negatives) and _maybe_ a stat checking system which would include making sure stats stay above zero even if the element shoves it below (like 10 hp total if a element drops you below)

just some ideas-


All times are GMT. The time now is 04:36 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.05602 seconds
  • Memory Usage 1,759KB
  • 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
  • (2)bbcode_php_printable
  • (3)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