vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   Post not displaying in showthred.php (https://vborg.vbsupport.ru/showthread.php?t=76023)

adrianna 02-09-2005 02:29 PM
Post not displaying in showthred.php
 
Hiya

I have a slight problem. The posts are not showing up at all. I have found that it is three lines in the showthread.php file that is causing this.

If I "comment" the lines out (ant move then aside), then the posts show up. However, if they are active, then the posts do not show up at all, only the "post reply" bottuns with a small bar between them.

There are the three lines of code:

Code:
//                FROM " . TABLE_PREFIX . "post AS post, ".TABLE_PREFIX."rpg_battle_options, ".TABLE_PREFIX."rpg_items_options
//                        user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,".TABLE_PREFIX."rpg_battle_options.namefield,".TABLE_PREFIX."rpg_battle_options.exprate,".TABLE_PREFIX."rpg_battle_options.privacy AS battleprivacy,".TABLE_PREFIX."rpg_items_user.*,".TABLE_PREFIX."rpg_battle_stats.*,".TABLE_PREFIX."rpg_rpg_race.name AS rpgracename,".TABLE_PREFIX."rpg_rpg_race.alignment AS rpgalignmentname,".TABLE_PREFIX."rpg_rpg_classf.name AS fclassname,
//                ".TABLE_PREFIX."rpg_rpg_classf.folder AS fclassfolder,".TABLE_PREFIX."rpg_rpg_classm.name AS mclassname,".TABLE_PREFIX."rpg_rpg_classm.folder AS mclassfolder,".TABLE_PREFIX."rpg_rpg_element.name AS elename,
What could possibility be wrong?

Marco van Herwaarden 02-09-2005 03:06 PM
Please post the whole block (10 line above and under this part)

Revan 02-09-2005 06:58 PM
I have absolutely no clue whatsoever why posts won't show.
Maybe seeing the entire query will help, I dunno.

adrianna 02-09-2005 08:58 PM
It is where I am supposed to replace (from the install instructions provided):

Code:
        $posts = $DB_site->query("
                SELECT
                        post.*, post.username AS postusername, post.ipaddress AS ip,
[......]
                WHERE $postids
                ORDER BY dateline $postorder
        ");
with:
Code:
        $totalcats = $DB_site->query_first("SELECT COUNT(*) AS countcats FROM ".TABLE_PREFIX."rpg_items_cats WHERE type='0'");
        $posts = $DB_site->query("
                SELECT
                        post.*, post.username AS postusername, post.ipaddress AS ip,
                        user.*, userfield.*, usertextfield.*,
                        user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,".TABLE_PREFIX."rpg_battle_options.namefield,".TABLE_PREFIX."rpg_battle_options.exprate,".TABLE_PREFIX."rpg_battle_options.privacy AS battleprivacy,".TABLE_PREFIX."rpg_items_user.*,".TABLE_PREFIX."rpg_battle_stats.*,".TABLE_PREFIX."rpg_rpg_race.name AS rpgracename,".TABLE_PREFIX."rpg_rpg_race.alignment AS rpgalignmentname,".TABLE_PREFIX."rpg_rpg_classf.name AS fclassname,
                ".TABLE_PREFIX."rpg_rpg_classf.folder AS fclassfolder,".TABLE_PREFIX."rpg_rpg_classm.name AS mclassname,".TABLE_PREFIX."rpg_rpg_classm.folder AS mclassfolder,".TABLE_PREFIX."rpg_rpg_element.name AS elename,
                        " . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
                        " . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
                        " . iif($vboptions['reputationenable'], 'level,') . "
                        " . iif(!$deljoin, 'NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,') . "
                        editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                        editlog.reason AS edit_reason,
                        post_parsed.pagetext_html, post_parsed.hasimages,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                        " . iif(!can_moderate(), $datastore['hidprofilecache']) . "
                FROM " . TABLE_PREFIX . "post AS post, ".TABLE_PREFIX."rpg_battle_options, ".TABLE_PREFIX."rpg_items_options
                LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
                LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN ".TABLE_PREFIX."rpg_items_user ON ".TABLE_PREFIX."rpg_items_user.userid=user.userid
                LEFT JOIN ".TABLE_PREFIX."rpg_battle_stats ON ".TABLE_PREFIX."rpg_battle_stats.userid=user.userid
                LEFT JOIN ".TABLE_PREFIX."rpg_rpg_classf ON ".TABLE_PREFIX."rpg_rpg_classf.id=user.rpgclass
                LEFT JOIN ".TABLE_PREFIX."rpg_rpg_classm ON ".TABLE_PREFIX."rpg_rpg_classm.id=user.rpgclass
                LEFT JOIN ".TABLE_PREFIX."rpg_rpg_element ON ".TABLE_PREFIX."rpg_rpg_element.elementid=user.element
                LEFT JOIN ".TABLE_PREFIX."rpg_rpg_race ON ".TABLE_PREFIX."rpg_rpg_race.raceid=user.rpgrace AND ".TABLE_PREFIX."rpg_rpg_race.alignmentid=user.alignment
                LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                " . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
                " . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
                        iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
                " . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
                LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
                LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
                WHERE $postids
                ORDER BY dateline $postorder
        ");
The following lines, if taken out, allow everything to work okay. However, if they are left in, they cause the posts to not show up at all.
Code:
              FROM " . TABLE_PREFIX . "post AS post, ".TABLE_PREFIX."rpg_battle_options, ".TABLE_PREFIX."rpg_items_options
                      user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,".TABLE_PREFIX."rpg_battle_options.namefield,".TABLE_PREFIX."rpg_battle_options.exprate,".TABLE_PREFIX."rpg_battle_options.privacy AS battleprivacy,".TABLE_PREFIX."rpg_items_user.*,".TABLE_PREFIX."rpg_battle_stats.*,".TABLE_PREFIX."rpg_rpg_race.name AS rpgracename,".TABLE_PREFIX."rpg_rpg_race.alignment AS rpgalignmentname,".TABLE_PREFIX."rpg_rpg_classf.name AS fclassname,
              ".TABLE_PREFIX."rpg_rpg_classf.folder AS fclassfolder,".TABLE_PREFIX."rpg_rpg_classm.name AS mclassname,".TABLE_PREFIX."rpg_rpg_classm.folder AS mclassfolder,".TABLE_PREFIX."rpg_rpg_element.name AS elename,

laeth 02-26-2005 08:23 PM
I have this same problem, running on 3.0.3

Revan 02-26-2005 09:59 PM
Well Im sorry, I have no idea whatsoever what's causing this.
All I know is that the incomplete v3 Im running on my live board on 3.0.7 works fine, so I guess you will have to either upgrade or wait.... :ermm:

laeth 02-26-2005 10:14 PM
If you upgrade to the newest version of vb, will I have to install all my hacks again? Slightly annoying if you have a load of hacks. heh.

Revan 02-27-2005 01:14 AM
Well you COULD of course reapply all file changes manually, or you could be smart and use a Compare program ;)
Look in the Hints and Tips forum for info on this :)

laeth 02-27-2005 01:46 AM
Quote:
Originally Posted by Revan
Well you COULD of course reapply all file changes manually, or you could be smart and use a Compare program ;)
Look in the Hints and Tips forum for info on this :)
Okies.

One more thing.

http://gothtopic.com/forum/lottery.php?

any ideas?

Thanks. :)

Revan 02-27-2005 10:49 AM
No, because I need to be registered to view the lottery.
And like F**K am I registering to a site where I risk having to see anything related to Marilyn Manson :mad:


All times are GMT. The time now is 08:48 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.01613 seconds
  • Memory Usage 1,753KB
  • 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
  • (4)bbcode_code_printable
  • (1)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