vb.org Archive - RPG Integration Hack /w Battle (BETA)

Not sure if anyone has had this, but when I try to donate to another member with out anonamyous setting set, I get the following error.

server info:
PHP Version 4.3.1
Mysql: Client API version 4.0.12
Linux Redhat 7.3

Code:



Database error in vBulletin 2.3.0:



Invalid SQL: SELECT field5 FROM userfield WHERE userid=

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1



mysql error number: 1064



Date: Thursday 17th of April 2003 12:10:44 AM

Script: http://www.xtremegames.ca/forum/forum/itemshop.php

Referer: http://www.xtremegames.ca/forum/item...n=donate&user=

sonic3d

04-17-2003 04:27 PM

also i was wondering if ne1 has cleaned up the templates cuz its all messed up looking in my new style.

l8er
sonic

Red Blaze

04-17-2003 05:16 PM

I had that problem but I'm not sure what my co-admin did that fixed it. ^^; It had something to do with a missing variable. Don't really remember since it happend a good time ago.

sonic3d

04-17-2003 08:59 PM

nevermind. i fixed it. i had to fix 3/4 of the battle templates. and heal

l8er
sonic

Jagang

04-18-2003 12:01 AM

Quote:

04-16-03 at 12:43 PM Bitsys said this in Post #1488
When you create a new battle, does the password get properly set in the database? Or is it blank?

In the Battle table, the field battlekey is blank even though I set a password. If it helps I am running MySQL 3.23.41

Moreliator

04-18-2003 05:57 PM

Bitsy,
I think I may have found a slight mistake in thh souce code in member.php for the stat updater

Code:

      if ($hpmulti > 7.5)

        $hpmulti = 3;

      if ($hpmulti > 2.5)

        $hpmulti = 1.5;

      if ($hpmulti < 1)

        $hpmulti = 1;

I think the last two need "else" statements:

Code:

      if ($hpmulti > 7.5)

        $hpmulti = 3;

      elseif ($hpmulti > 2.5)

        $hpmulti = 1.5;

      elseif ($hpmulti < 1)

        $hpmulti = 1;

The elseif probably isn't NECISARY on the last one.

ALSO, I seem to be having a problem with the item types in the admin panel. I recently added a new item Category. now, when I go to uncheck some of the boxes I checked in the "item type" page and press submit, it reloads the page as if i made no changes at all. any suggestions?

The problem is with the "two handed weapons" category. There are two specific columns that are being stubborn and that I can't uncheck. Every other column and item category checks and unchecks fine...

Koutaru

04-19-2003 01:01 AM

Just a quick question:

Can I make a user carry more than 3 items? I know it's possible but I'm not exactly sure where to start. Maybe if someone could point me in the right direction?

Jagang

04-19-2003 01:35 AM

Quote:

Today at 02:01 AM Koutaru said this in Post #1497
Just a quick question:

Can I make a user carry more than 3 items? I know it's possible but I'm not exactly sure where to start. Maybe if someone could point me in the right direction?

A user can carry 1 item from each Category. Starting off you only have 3 Categories, Weapons, Armor, and Items. Create a new Category and you will see another space open up in inventory.

Koutaru

04-19-2003 03:04 AM

Hmm I was thinking toward they can carry up to 10 items out of any categlory XD Can I do that? I'm a newbie in php but I'm sure if someone tells me what to look for to change, I'll figure it out

Zalastri

04-19-2003 04:22 AM

First off.. This is one hell of a hack. Good work. My members love it... hell.. my board is based on this hack now. I run a small RP community and this was a hell of a gift. Now then...

The whole user field/points system is a little wacky. You should make the VBhacker.php make a SET variable for money. Cauase for a while I had it displaying usernames as money >.>

Can you give me the code for your postbit that you had on that screenie?

For some reason my forum is very sluggish.. do you happen to have a database speedup php app?

Users should be able to have a whole inventory.. Not just one item. And you should make it so that on the home page you can just put something like $rpgnav and have a table with all the required RPG links on it.

Weapons should have spells that can sometimes cast.. Like poision effects.

Random encounters... Like.. If you view a post once out of every 70 tiems you get into a random battle with a wolf or something :D Happy coding and good job.

All times are GMT. The time now is 11:08 AM.

Page 150 of 251

150

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04237 seconds Memory Usage 1,747KB 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages: