vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Retrive The Field Info (https://vborg.vbsupport.ru/showthread.php?t=258270)

Lynne 02-23-2011 11:13 PM

Try a query more like:
PHP Code:

$getrepx $db->query_read("SELECT userfield.field8, user.userid, user.username 
FROM " 
TABLE_PREFIX "userfield 
LEFT JOIN " 
TABLE_PREFIX "user
ON (user.userid = userfield.userid)
ORDER BY userfield.field8 DESC LIMIT 10"
); 

Not knowing how you are putting this into the page though doesn't help us figure out why nothing is displaying. You really need to post the part where you add it to the template - both the php page and what is in the template.

3amalah 02-24-2011 06:23 AM

Quote:

Originally Posted by Lynne (Post 2166038)
Try a query more like:
PHP Code:

$getrepx $db->query_read("SELECT userfield.field8, user.userid, user.username 
FROM " 
TABLE_PREFIX "userfield 
LEFT JOIN " 
TABLE_PREFIX "user
ON (user.userid = userfield.userid)
ORDER BY userfield.field8 DESC LIMIT 10"
); 

Not knowing how you are putting this into the page though doesn't help us figure out why nothing is displaying. You really need to post the part where you add it to the template - both the php page and what is in the template.

Hello Lynne Thanks So Much For Your Answer Look

https://vborg.vbsupport.ru/attachmen...1&d=1298535707

Thats The Product

I Edited It With The Code You Provided Me

All I Need It To Do Is Just Show The Highest Member In Field 8

I Dont Need More Features Or Anything

Or Just Write Me The Php Code And I Will try For It

And Special Thanks For You

Lynne 02-24-2011 02:22 PM

I don't want to know what the original looks like, I am only interested in what you are doing with the code for your site. You need to post about *your* product.

3amalah 02-24-2011 04:14 PM

Quote:

Originally Posted by Lynne (Post 2166291)
I don't want to know what the original looks like, I am only interested in what you are doing with the code for your site. You need to post about *your* product.

Ok Lynne I Made Field Show Every User Level

Everyone Has A Level

I Need The Top Users In Field X That Show Levels In Forumhome

To Become Like That

Lynne : Level 10
3amalah : Level 5
xxx : Level 2

Lynne 02-24-2011 04:54 PM

I understand what you *want*. I want to see all your current code. Please post your plugin, telling us the hook location, and put code tags around it. And post any template, giving us the template name, and put code tags around it. If you insert something into an existing template, tell us what template and give us about 10 lines from it. We cannot help if we cannot see what your code currently looks like.

3amalah 02-24-2011 05:02 PM

Quote:

Originally Posted by Lynne (Post 2166383)
I understand what you *want*. I want to see all your current code. Please post your plugin, telling us the hook location, and put code tags around it. And post any template, giving us the template name, and put code tags around it. If you insert something into an existing template, tell us what template and give us about 10 lines from it. We cannot help if we cannot see what your code currently looks like.

Iam Sorry I Dont Have A Code Right Now I Just Was Installing The Top Rep Product

And I Found It The Same Idea That Iam Searching For

So I posted It But Iam Currently Dont Have A Code

I Just Need To Show This Data In Forumhome Template

The Field Number Is Field 8

Lynne 02-24-2011 06:48 PM

If you aren't writing any code for this, then I would suggest hiring someone to do it. We are trying to help you write it here, but if you aren't actually trying to write it, then we can't help you.

3amalah 02-24-2011 08:02 PM

Quote:

Originally Posted by Lynne (Post 2166430)
If you aren't writing any code for this, then I would suggest hiring someone to do it. We are trying to help you write it here, but if you aren't actually trying to write it, then we can't help you.

Ok Lynne One Last Question

I WIll Do The Same As The Product I Showed You

Could You Provided Me With The Code That Get The Data From Database

From Userfield ---> Field X

And I Will make The Variable And Plugin

And Thanks So Much

Lynne 02-24-2011 09:18 PM

I already provided you with the query to get the data from the database on the last page.

3amalah 02-25-2011 10:58 AM

Quote:

Originally Posted by Lynne (Post 2166489)
I already provided you with the query to get the data from the database on the last page.

Aha I Saw It Now Thank You Lynne I Will Try It Myself With Your Code

And Thanks For Your Help

And Sorry For Wasting Your Time :)


All times are GMT. The time now is 10:12 PM.

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