Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 09 Sep 2011, 20:55
RollaJedi's Avatar
RollaJedi RollaJedi is offline
 
Join Date: Apr 2007
Image Displayed from Specific Database Table

I am a noob to all this stuff, please go easy on me.

I have a mysql database on vbulletin. Within that database, i have a table for a card collecting mod that my users play on my site. The image i provided is of this table within phpmyadmin. What i hope to accomplish is to be able to put a code into each member's signature that shows an icon of each card they have. The p_userid column represents each member's id number and the p_card column represents each card's id number.

So, for example, Joe Blow is member number 23 at my site. So, his p_userid is 23. He has six cards in his possession, and they are cards 4, 8, 15, 16, 23, and 42. So, these numbers would be in the p_card column.

So, what will happen if the code is in the signature of Joe Blow, is there will be six images, one representing card 4, one representing card 8, etc.


Can someone please, please just point me in the right direction on this? I've literally been trying for many months to get help with no luck.

Thank you for your time!
Reply With Quote
  #2  
Old 09 Sep 2011, 23:45
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
It sounds to me like you need someone to actually write the modification for you since you have posted no code here. I can tell you in the most basic of terms what to do, but you would need to code it.

- do a query of the table to get all card ids for the user
- in a while loop, spit out the html code for each image: <img src="$variable['p_card'].png" alt='' /> and put it all into a variable like $mycards
- preregister the variable $mycards for use in the template you want to use it in
- spit out the variable $mycards where you want it in the template
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 03 Oct 2011, 18:17
RollaJedi's Avatar
RollaJedi RollaJedi is offline
 
Join Date: Apr 2007
thank you for this info. how or where do you pre register the variable?

--------------- Added 03 Oct 2011 at 18:20 ---------------

could i maybe hire your services for a small thing like this?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:35.

Layout Options | Width: Wide Color: