vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Need info from database - MySQL/PHP (https://vborg.vbsupport.ru/showthread.php?t=240758)

King Justice 04-18-2010 08:52 PM

Need info from database - MySQL/PHP
 
Hello can anyone help me ?

I want to call & display certain info that I know is in my MySQL database of my forum.

I want the users with the most iTrader feedback to display. Can anyone help me by providing me a code to call this via MySQL/PHP? I'd like it to list the users in descending order, from highest feedback ratings to lowest.

Pandemikk 04-18-2010 10:37 PM

Read this: http://www.vbulletin.com/docs/html/m...ards_sql_query

If you still have questions you'll need to provide us with information on how your information is stored in your database. This can be found out in phpMyAdmin.

King Justice 04-19-2010 12:49 AM

Well it's vBulletin so I figured someone would easily be able to tell me how to list the users with the most iTrader ratings in decending order by username (I want it to display the username and the number of feedback they have in a list in descending order).

iTrader is a plugin for vbulletin. Anyone?

Lynne 04-19-2010 03:48 AM

You'll need to ask this in the modification thread. This is in regards to fields added to the database for a modification and so that is the place you need to ask your questions. (We certainly have no idea what fields were added by the mod - only those who have installed the mod would know that.)

Pandemikk 04-19-2010 08:48 AM

Quote:

Originally Posted by King Justice (Post 2023510)
Well it's vBulletin so I figured someone would easily be able to tell me how to list the users with the most iTrader ratings in decending order by username (I want it to display the username and the number of feedback they have in a list in descending order).

iTrader is a plugin for vbulletin. Anyone?

The problem is I am not familiar with iTrader thus I do not know what it alters or how it does so.

Lynne is correct, you should be asking for support at their offical website/thread. If they don't give support I'd be happy to assist you, provided I am allowed, but I will need more information.


All times are GMT. The time now is 07:18 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.01639 seconds
  • Memory Usage 1,719KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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