vb.org Archive - Profile Enhancements - Gamefields Icons Xbox,Wii and Playstation userfields

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Profile Enhancements - Gamefields Icons Xbox,Wii and Playstation userfields (https://vborg.vbsupport.ru/showthread.php?t=196587)

Quote:

Originally Posted by MyCTaK (Post 1673957)

Good job! :up:
I am waiting for the final release and i hope it can take xbox live tag from "Xbox Live Gamercard Block in Profile" field and both mods can work together.
I think PS sign is not adequate for PSN ID - http://images.dudditz.com/ext/vb.org/gf_playstation.gif.
Best Regards

I would love this ability as well. Or actually, I would like to be able to have the gXboxLive mod pull from your field in the User table instead of being forced to choose a field ID from User Profile Fields.

I'm sure there is a way that you can change it. When it asks you to enter the flied id does it ask for just the number or fieldID. if asks you for fieldID then enter gf_xbox. I can't test it since I don't use that mod, but give it a try.

Unfortunately, the field types are different values between the two mods.
Gamefields is a text field and gxboxlive is an integer.
There may be a solution coming soon and updates are on hold temporarily.
Im researching the database interaction and attempting to create a simple id
to link the fields to Mods using user profile fields.
Also in development are database tools to import/export between tables
as well as admincp settings to allow image choices.

Sounds good can't wait to see what you come up with. Ya I wasn't sure about that since I haven't made a vBulletin modification since 2002, 2003 maybe. So everything I used to know means nothing now I have to relearn everything. I just really want to learn how to make the xml products files to make some modifications of my own without having to wait for someone to answer my request since most people are to busy.

Thanks for the update
Dragon

Quote:

Originally Posted by RayoVac (Post 1677517)

YES, plz..!!
I hate to have people type in their Gamertag twice.!

just wondering how I could interigate this with gXboxLive?

As it isn't a Profile Field yet I don't really wanna show both xbox live tags, but i still want the leaderboard, any ideas?

Quote:

Originally Posted by Steve-EFC (Post 1687921)

just wondering how I could interigate this with gXboxLive?

As it isn't a Profile Field yet I don't really wanna show both xbox live tags, but i still want the leaderboard, any ideas?

It is being discussed and the reason no further updates have been released.
I'll keep you posted when more details are available.

Hey, great mod!

+installed

I've modded your mod to include the Steam Network and it's working well..
Thanks again for the cool addition.

Yet another good mod --installed and i can wait for the new features like clan name and stuff .
thanks

Quote:

Originally Posted by pokesph (Post 1688260)

Hey, great mod!

+installed

I've modded your mod to include the Steam Network and it's working well..
Thanks again for the cool addition.

Care to share..?

I'd like to add a few different ones.
Steam
Xfire
Myspace/Facebook
Etc..

Sorry for the lack of updates.
I have decided it's not good to alter the user table and have been developing
a 3.8 version with its own table which will provide multiple field options.
It's coming along very slow since I have been busy on other projects
but I hope to have it out soon.
Feel free to hack away at this Mod though.

Quote:

Originally Posted by DragonMasterNYC (Post 1672175)

Here is something for the PSN

Add This to the PlayStation Network so that it's clickable and shows the card.

Code:

<td><a href="#" onclick="openWindow('http://pid.us.playstation.com/user/$userinfo[gf_playstation].jpg', 235, 149); return false;">$userinfo[gf_playstation]</a></td>

I'm sure this will help you out for next release Bilderback

Also here is an updated PSN Icon

Can anyone tell me how to add this code?

I am a complete newbie. But, i am good at following directions.

Thanks.

Quote:

Originally Posted by EyeintheSky57 (Post 1703730)

Can anyone tell me how to add this code?

I am a complete newbie. But, i am good at following directions.

Thanks.

Well I just mirrored the Xbox code and added the PS3 link instead.

Game Fields Icons Templates > gamefields_playstation

Code:

<input type="hidden" name="playstation code" value="$userinfo[gf_playstation]">

                <if condition="$userinfo[gf_playstation]"> <a href="#" onclick="openWindow('http://pid.us.playstation.com/user/$userinfo[gf_playstation].jpg', 255, 169); return false;"> <img src="$vboptions[bburl]/images/misc/gf_playstation.gif" alt="" title="$vbphrase[gf_playstation_network_id]: $userinfo[gf_playstation]" border="0"></a></if>

Also, I have found a way to make it work with gXboxLive, but it would mean that if you need to update this mod, you will have the change the info in the XML each time. Basically you will not be supported by the author if you make this change. PM me for details.

Quote:

Originally Posted by Bradley_Wint (Post 1716752)

I would like to do this. I PM'ed you.

Have anybody else done this?

The Mod isn't supported anyway and could use some improvement.
Feel free to hack away.

ok, with that note, I guess I'll post it here.

So after taking a look at both mods, I think that sharing the db information is the way to link the two. However, each mod writes entries into separate tables in the vB database. This mod adds information to the user table and the gXboxLive uses the userfield table.

Since this is a much smaller mod, I think it would be best to mod this since it's only one file of code, rather than over 10 different files for gXboxLive. With the gXboxLive, they ask you to make a new field (lets say your field id is 5). In the MySQL backend, the userfield will have a record called field5, where the gXboxLive usernames will be stored for each individual user.

My theory is, set up your gXboxLive mod first, get the code (once again we use 5). Now in this mod, there is a bit of MySQL you need to change.

Code:

                <code>

                        <installcode><![CDATA[

                        if (!field_exists('user', 'gf_xbox', 'gf_wii', 'gf_playstation'))

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD gf_xbox VARCHAR( 15 ) AFTER msn");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD gf_wii VARCHAR( 19 ) AFTER msn");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD gf_playstation VARCHAR( 16 ) AFTER msn");

                        function field_exists($table, $field)

                        {

                                global $db;

                                return ($db->num_rows($db->query_read("SHOW COLUMNS FROM `" . TABLE_PREFIX .$table."` LIKE '".$field."'"))> 0);

                        }

                        ]]></installcode>



                        <uninstallcode><![CDATA[$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP gf_xbox");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP gf_wii");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP gf_playstation");]]></uninstallcode>

                </code>

Now you will want to change it to something like this

Code:

                <code>

                        <installcode><![CDATA[

                        if (!field_exists('userfield', 'field5', 'field6', 'field7'))

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield ADD field5 VARCHAR( 15 ) AFTER field4");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield ADD field6 VARCHAR( 19 ) AFTER field4");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield ADD field7 VARCHAR( 16 ) AFTER field4");

                        function field_exists($table, $field)

                        {

                                global $db;

                                return ($db->num_rows($db->query_read("SHOW COLUMNS FROM `" . TABLE_PREFIX .$table."` LIKE '".$field."'"))> 0);

                        }

                        ]]></installcode>



                        <uninstallcode><![CDATA[$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP gf_xbox");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field6");

                        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field7");]]></uninstallcode>

                </code>

Basically I am replacing the variables.

user > userfield
gf_xbox > field5
gf_wii > field6
gf_playstation > field7

Please not these field numbers may vary depending on the number of fields you already have. So say you assigned field20 to gXboxLive, gf_xbox would be field21, gf_wii would be field22 and gf_playstation would be field23.

The excerpt above deals with only the initial set up of the tables and what not. I just highlighted that portion since it sets the stage for the entire code to function properly. Continue reading.

Now the confusing bit starts, because I didn't have time to sit down and figure what exactly was a MySQL function or a template function, even though I could pretty much tell by looking (just lazy to go through all honestly). So if you want to take the chance, remember what you assigned the initial MySQL entries as.

e.g.
user > userfield
gf_xbox > field5
gf_wii > field6
gf_playstation > field7

Now, basically it's about going into an editor and replacing all the variables in the XML document. Basically your MySQL entries will be renamed and aligned with the userfield data, so new data will be recorded there instead. However, your templates will also be renamed (e.g. field5_live_gamertag). So if you are prepared to remember how you assigned them, then in theory this should work. I haven't tested it out yet since I didn't get the time, but I think this is basic math here since the author wrote his code pretty straightforward, and replacing the vars shouldn't be a big issue, once it's done it unison.

However, please BACK UP YOUR DATABASE first before trying anything.

Then, install gXboxLive and then install this code. Im guessing if you had gXboxLive already installed, no biggie either.

I would pray that they both work simultaneously.

Thank you very much for this...I followed your instructions, and the 3 fields are there and labeled properly. I am getting this error when I try to update my gamer info in User CP...

MySQL Error : Unknown column 'field66' in 'field list'
Error Number : 1054

We shall talk more via PM

@MikesSite
Even if you change the database entries, the plugin code still uses the user table.

This was a theoretical view and I wouldnt advise attempting this quite yet.
I backed myself into a corner by releasing this Mod because if it is ever uninstalled,
all user data from the fields are deleted.
I really need to write a transfer tool which allows the data to be passed to custom
profile fields if ever it were to be uninstalled or get them into their own table which
could simply be left behind without issues.
On another note, a conditional could be used for gxboxlive detection in the plugins.
Alot could be done to enhance this but I am still new to vbulletin and cant get it from
my head into a text editor yet.

Instead of using the user table, another possiblility would be too query the fields for the
last entry and simply add three additional profile fields.
Its one of those "Why did I do that?" deals.
If anyone can enhance this or has suggestions, feel free to modify the code.
After researching the history, it appears that Datenpapst had used code from an author
who used code from another author who hasnt been around for many years and vb versions.

Yes, my thought is totally theoretical at the moment. I haven't sat down to actually try out the possibilities.

But wouldn't it work if you redefined the access table from user to userfield? Even if we left the vars as gf_xbox, etc, won't the userfield table be able to accept it successfully? Or does it have to be a fieldx titles record?

does this work for 3.8?

I am using it no problem on 3.8.

I'm actually looking to add things like SteamID or Battle.net info.

Quote:

Originally Posted by Bilderback (Post 1718539)

@MikesSite
On another note, a conditional could be used for gxboxlive detection in the plugins.
Alot could be done to enhance this but I am still new to vbulletin and cant get it from
my head into a text editor yet.

I actually connected your product to another mod which shows XBox Live Gamer cards in users profile. That mod is here:
https://vborg.vbsupport.ru/showthread.php?t=171157

Where he says to replace in his templates $userinfo[fieldX] where X = the gamercard, I replaced that to read $userinfo[gf_xbox]. Neat little way to have it display the gamer card in the users profile.

I haven't thought running it into gxboxlive mod though

Edit. Apon looking, it seems very simple to change the xml on the gXboxLive to pull from the user table or change your XML file to pull from the profilefield table.

Hello Bilderback,
do you work on your plug in and do you think it will have gold release soon?
As i said i found this mod very useful but i didn't download beta version and wait for improved, tested and stable release. :up:
Best Regards

Quote:

Originally Posted by MyCTaK (Post 1720970)

Currently there are no plans for new release except for maybe a small bugfix
since I have been in discussion with other coders and thinking of integration
with their Mod release.Sorry I cant give details right now.

So no official 3.8.x support then??

This would be excellent if you could make your own custom fields and icons. For instance, I'd like my members to be able to share a wealth of DS and Wii friend codes... but I'll have to edit the plugin manually to do that!

I'm bumping this...

Since I couldn't get this to integrate w. the gXboxLive hack, I decided to create my own using this Gamefields hack, for PS3 & Wii. I just started. Let me know if you guys would want something like this for your forum. http://newyorkmustangs.com/forums/ps3.php

It lists all the users' forum ID, and PS3 ID. It's very bare now, but I am adding more to it. If anybody has any suggestions or knows of any way to integrate the Playstation network into a site (such as easy way to add friends, etc. right from the web site) then please let me know!

MikesSite
can you plz send it to me ?

thanks so much in advance

Sure, I will create a new thread w/ the instructions and let you know.

thanks so much
I will wait for it

Yeah, i think i can use it as well.........thanks

Awesome! Worked Great. Thanks for the plugin.

how do stop guest from viewing my xbox icon.:confused: any help

Can somebody please make it campatible with gXboxLive - Xbox Live Leaderboard

https://vborg.vbsupport.ru/showthrea...highlight=xbox

Quote:

Originally Posted by DragonMasterNYC (Post 1672175)

Here is something for the PSN

Add This to the PlayStation Network so that it's clickable and shows the card.

Code:

<td><a href="#" onclick="openWindow('http://pid.us.playstation.com/user/$userinfo[gf_playstation].jpg', 235, 149); return false;">$userinfo[gf_playstation]</a></td>

I'm sure this will help you out for next release Bilderback

Also here is an updated PSN Icon

Where exactly do i put this code. No idea about coding. But can find my way if someone points me in the right direction

Ok, forget my last post, kind of. I found it i think. but it just brings up blank.

here's the link it brings up

http://pid.us.playstation.com/user/FloodIC.jpg

Quote:

Originally Posted by Playa82 (Post 1802651)

Can somebody please make it campatible with gXboxLive - Xbox Live Leaderboard

https://vborg.vbsupport.ru/showthrea...highlight=xbox

Anyone ? Please !

can you move where the icons are shown?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01452 seconds Memory Usage 1,854KB 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 (5)bbcode_code_printable (11)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 (40)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
Messages: