vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   phpRPG integration (https://vborg.vbsupport.ru/showthread.php?t=41751)

ULTIMATESSJ 08-01-2002 02:38 AM
phpRPG integration
 
I am trying my luck at integrating phpRPG into my forums, all i need done is to integrate it so that the user table from vBulletin is used for phpRPG, how would i go about doing this???

Dark_Wizard 08-01-2002 01:44 PM
Quote:
Originally posted by ULTIMATESSJ
I am trying my luck at integrating phpRPG into my forums, all i need done is to integrate it so that the user table from vBulletin is used for phpRPG, how would i go about doing this???
It all depends on how the code was written for phpRPG. Do you have a url for us to view and download it?

ULTIMATESSJ 08-03-2002 10:06 AM
i looked in the scripts code and found this for how they make the users table

PHP Code:
        $sql = mysql_query($query) or die(mysql_error());
        echo '.';

        $query = "
CREATE TABLE " . PHPRPG_DB_PREFIX . "_users (
  user_id smallint(5) unsigned NOT NULL auto_increment,
  user_name char(20) NOT NULL default '',
  user_pass char(32) binary NOT NULL default '',
  email char(60) NOT NULL default '',
  name char(20) NOT NULL default '',
  status char(20) NOT NULL default '',
  HP mediumint(8) unsigned NOT NULL default '20',
  HP_MAX mediumint(8) unsigned NOT NULL default '20',
  MP mediumint(8) unsigned NOT NULL default '10',
  MP_MAX mediumint(8) unsigned NOT NULL default '10',
  STM mediumint(8) unsigned NOT NULL default '200',
  STM_MAX mediumint(8) unsigned NOT NULL default '200',
  EXP mediumint(8) unsigned NOT NULL default '0',
  GP mediumint(8) unsigned NOT NULL default '0',
  STR tinyint(3) unsigned NOT NULL default '4',
  NTL tinyint(3) unsigned NOT NULL default '4',
  PIE tinyint(3) unsigned NOT NULL default '4',
  VIT tinyint(3) unsigned NOT NULL default '4',
  DEX tinyint(3) unsigned NOT NULL default '4',
  SPD tinyint(3) unsigned NOT NULL default '4',
  CW mediumint(8) unsigned NOT NULL default '0',
  CC mediumint(8) unsigned NOT NULL default '80',
  map_name char(20) NOT NULL default '',
  map_xpos tinyint(3) unsigned NOT NULL default '0',
  map_ypos tinyint(3) unsigned NOT NULL default '0',
  last_active char(255) NOT NULL default '',
  delay char(255) NOT NULL default '',
  delay_reason char(255) NOT NULL default '',
  race char(10) NOT NULL default '',
  avatar char(10) NOT NULL default '',
  host char(255) NOT NULL default '',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM
        "; 
how could i bring that into the vBulletin users table???

Dark_Wizard 08-03-2002 04:32 PM
You have to update the RPG code to accept the differences in the vb user table like:
  • vb- userid RPG- user_id
    vb- username RPG- user_name
    etc...

and second would be to either add the fields that are unique to RPG into the vb user table or create another table and alter the RPG code.

ULTIMATESSJ 08-04-2002 01:20 AM
where would i find all the code for the vBulletin user table???

JulianD 08-04-2002 02:17 AM
What do you mean? You can view the database structure using phpMyAdmin.

ULTIMATESSJ 08-04-2002 03:17 PM
Quote:
Originally posted by JulianD
What do you mean? You can view the database structure using phpMyAdmin.
i mean in the vbulletin files

Erwin 08-28-2002 10:40 AM
I was having a long look at this... it is very doable, and should not be too hard to integrate - you only need to change a few lines of code here and there...

However, phpRPG is still BETA, and has lots of bugs. It's really a pre-released multiplayer RPG game based on php and mysql, and actually looks quite bad at the moment...

Also, the bugs are bad enough that you wouldn't want to use it anyway.

Refer to this review:

http://multiplayer.com/cgi-local/review.cgi?ID=1503

I would wait until they release an alpha version (it's still labeled as pre-alpha), at least a version 1.0 (it just became 0.5 from 0.3).

Erwin 08-28-2002 10:41 AM
However, if you REALLY want to run it on your site, I can look at integrating it... but I don't think it's worth the effort and database changes... (you would have to modify vB too so that you can show the stats on vB).

Now, if you want to modify phpRPG so that it is better, then that's different. However, it's probably easier to code your own RPG hack then.

g-force2k2 08-28-2002 02:03 PM
just taking a few looks at some of the coding i don't really like it that much... i really don't see anything special about it and i certainly wouldn't intergrate this into my vb.... (just my opinion) i haven't even seen it in action... but i can see that it does have a lot of bugs already :p regards...

g-force2k2


All times are GMT. The time now is 10:03 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.01012 seconds
  • Memory Usage 1,738KB
  • 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_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete