| 00:46.05 | *** join/#wowroster Synthesis (~Synthesis@c-107-2-69-3.hsd1.mn.comcast.net) |
| 00:46.17 | *** join/#wowroster Synthesis_ (~Synthesis@c-107-2-69-3.hsd1.mn.comcast.net) |
| 00:46.51 | Synthesis_ | Anyone in here and active? I'm looking for some assistance with some MySQL stuff on my WoWroster site. |
| 00:47.26 | Synthesis_ | I want to change the settings in WoWRoster to point to a different table for user information. |
| 01:49.02 | Synthesis | I guess I just need to know which files are being called by the server in order to read login info, etc |
| 04:10.34 | Zanix | I kind am Synthesis |
| 04:10.48 | Zanix | I dont watch this room all the time since it is hardly visited |
| 04:10.52 | Synthesis | :) |
| 04:10.56 | Synthesis | No worries. |
| 04:11.02 | Zanix | hmm |
| 04:11.10 | Synthesis | I am running the Roster in a subfolder underneath a Joomla install |
| 04:11.28 | Zanix | ok |
| 04:11.29 | Synthesis | I'd like Roster to use the Joomla logins. |
| 04:11.32 | Zanix | ah |
| 04:11.53 | Synthesis | I can add the necessary columns to the correct table in Joomla in the DB |
| 04:12.38 | Zanix | well, roster uses a function to call table names |
| 04:12.58 | Synthesis | Ok... I'm not a pro with PHP at all... |
| 04:13.02 | Zanix | trying to remember where |
| 04:13.12 | Zanix | I havent poked around the code in a very long itme |
| 04:13.14 | Synthesis | I assume I can just edit the function to change the table names |
| 04:13.21 | Zanix | ulminia mainly works on Roster now |
| 04:13.26 | Zanix | maybe |
| 04:14.18 | Zanix | is Roster and Joomla in the same database? |
| 04:14.23 | Zanix | or different databases |
| 04:14.30 | Synthesis | Same DB |
| 04:14.38 | Synthesis | Different table prefixes |
| 04:14.54 | Zanix | ok, in trunk/lib/dbal/mysql.php |
| 04:14.59 | Zanix | function table($table, $addon='', $type='addons') |
| 04:15.03 | Zanix | around line 534 |
| 04:15.11 | Zanix | that is where table names are translated |
| 04:15.16 | Synthesis | Ok |
| 04:15.34 | Synthesis | Give me a few please. |
| 04:15.44 | Zanix | I dont remember off the top of my head |
| 04:15.45 | Synthesis | I'll pull that up shortly |
| 04:15.46 | Zanix | lol |
| 04:16.00 | Synthesis | Playing WoW right now as well. |
| 04:16.18 | Zanix | http://www.wowroster.net/topic4874.html |
| 04:16.22 | Zanix | I wonder if this would work |
| 04:16.29 | Zanix | I remember someone already doing this before |
| 04:16.38 | Zanix | Joomla 1.0.15 |
| 04:16.41 | Zanix | oooold joomla |
| 04:18.01 | Synthesis | Joomla 2.7 here |
| 04:18.50 | Zanix | and wowroster.de is gone |
| 04:21.31 | Synthesis | That thread might work... If I can just point Roster at the right table and change the column names, I should be good to go I would think |
| 04:21.47 | Synthesis | Then I can just add the additional columns it is looking for to the DB |
| 04:21.53 | Zanix | which version of Roster are you on? |
| 04:22.26 | Synthesis | Latest |
| 04:22.27 | Synthesis | 2.3.0 |
| 04:22.54 | Synthesis | I was trying to find a way to integrate it into Joomla, but everything is so outdated |
| 04:23.41 | Synthesis | www.warparty.org and www.warparty.org/roster |
| 04:23.48 | Synthesis | That is what I am trying to get working |
| 04:24.32 | Zanix | yeah |
| 04:24.49 | Zanix | unfortunately there is not much work going on with Roster anymore |
| 04:25.00 | Zanix | kinda died out the the armory opened |
| 04:25.09 | Zanix | still looking at code htough |
| 04:25.47 | Synthesis | Yeah... I don't want to rely on anyone else's pages, or see ads... We want our own web presence independent of all others |
| 04:26.06 | Zanix | and that's who usually download and run roster |
| 04:26.42 | Synthesis | Yep. lol |
| 04:31.29 | Synthesis | Hmmm. |
| 04:31.36 | Synthesis | How does that function pull the right table name? |
| 04:32.00 | Synthesis | Isn't there something that specifically says "look in usr" tab? |
| 04:32.48 | Zanix | yeah, just cant recall which files do that |
| 04:32.52 | Zanix | I called ulminia in here |
| 04:32.59 | Synthesis | :) Thanks. |
| 04:38.28 | Zanix | he having issues with his IRC client |
| 04:38.35 | Synthesis | No worries. |
| 04:40.13 | Zanix | lib/login.php handles the user auth |
| 04:40.26 | Zanix | and we have code so that an addon can take it over |
| 04:40.33 | Zanix | http://www.wowroster.net/downloads/?id=134 |
| 04:40.41 | Zanix | this was a phpbb auth addon that did just this thing |
| 04:41.00 | Synthesis | Hmmmm. |
| 04:41.00 | *** join/#wowroster Ulminia (Ulminia@142.167.191.226) |
| 04:41.06 | Synthesis | Welcome Ulminia |
| 04:41.14 | Ulminia | ... i really hate getten in to a new irc client |
| 04:41.15 | Zanix | 'bout time! |
| 04:41.18 | Zanix | lol |
| 04:41.22 | Zanix | fix yer old one then |
| 04:41.30 | Synthesis | LOL |
| 04:41.36 | Zanix | sorry man |
| 04:41.42 | Zanix | @Zanix │ lib/login.php handles the user auth │ |
| 04:41.42 | Ulminia | i cant it wont maxamixe from the task bar... and it expired |
| 04:41.44 | Zanix | 214026 @Zanix │ and we have code so that an addon can take it over │ |
| 04:41.46 | Zanix | 214033 @Zanix │ http://www.wowroster.net/downloads/?id=134 │ |
| 04:41.48 | Zanix | 214041 @Zanix │ this was a phpbb auth addon that did just this thing |
| 04:41.58 | Zanix | expired? |
| 04:42.08 | Ulminia | trial |
| 04:42.12 | Zanix | http://www.silverex.org/download/ |
| 04:42.14 | Zanix | free version |
| 04:42.30 | Ulminia | what cms are you using? |
| 04:42.40 | Zanix | joomla |
| 04:42.47 | Synthesis | Joomla 2.7 |
| 04:42.48 | Zanix | which I have never used |
| 04:42.57 | Ulminia | ...... honestly ... i really wana so no.... |
| 04:42.57 | Zanix | Im a Drupal developer |
| 04:43.00 | Synthesis | Here's my thought... |
| 04:43.22 | Ulminia | joomla is one of the worse coded cms on the planet,.... |
| 04:43.30 | Synthesis | Tweak the file auth stuff for Roster to point to the Joomla user auth table... |
| 04:43.46 | Synthesis | And just add any required columns for extra stuff that Joomla does not already have |
| 04:43.52 | Ulminia | yes that"could" work |
| 04:44.00 | Zanix | I think you might be able to make tweaks to login.php and sessions.lib.php |
| 04:44.16 | Ulminia | and every other file that calls the user table |
| 04:44.20 | Zanix | but then the user addon might not work anymore |
| 04:44.27 | Synthesis | Yep... Just have to figure out which ones |
| 04:44.32 | Ulminia | ^ |
| 04:44.35 | Zanix | https://code.google.com/p/wowroster/source/search?q=user_members&origq=user_members&btnG=Search+Trunk |
| 04:44.44 | Zanix | that is a search of the user_members table name |
| 04:45.01 | Zanix | I would assume all those would have to be edited |
| 04:45.28 | Synthesis | Hmmm. |
| 04:45.46 | Synthesis | Damn, I wish I was a developer. lol |
| 04:45.53 | Synthesis | I'm a Systems Admin, this shit is over my head |
| 04:45.56 | Ulminia | <- thats my job |
| 04:46.09 | Synthesis | Hah |
| 04:46.16 | Zanix | my job is a web developer |
| 04:46.18 | Synthesis | I set up our domain this morning |
| 04:46.25 | Synthesis | www.warparty.org |
| 04:46.31 | Synthesis | www.warparty.org/roster |
| 04:46.32 | Zanix | and right now Im building a home file server |
| 04:46.33 | Zanix | lol |
| 04:46.38 | Synthesis | Zanix... :) I have one |
| 04:46.45 | Synthesis | 12TB of storage, running in VMWare ESXi |
| 04:46.54 | Synthesis | Linux router on the same VMWare server |
| 04:46.59 | Zanix | cool |
| 04:47.00 | Synthesis | Along with two or three game servers |
| 04:47.11 | Zanix | I just have ubuntu with 8TB of storage |
| 04:47.35 | Zanix | right now im rsyncing my files from my old NTFS drives |
| 04:47.50 | Zanix | I did have a windows home server box |
| 04:47.58 | Synthesis | That is what I use in VMWare. |
| 04:47.59 | Zanix | using driver extender |
| 04:48.09 | Zanix | *drive |
| 04:48.20 | Synthesis | Ulminia, I'll poke around a little bit more.. |
| 04:48.33 | Synthesis | Would love to be able to pick your brain as I do. |
| 04:48.53 | Zanix | yeah, he's more familiar with the code than I am anymore |
| 04:49.08 | Zanix | plus Im pre-occupied |
| 04:49.13 | Zanix | so that doesnt help |
| 04:49.53 | Ulminia | pick away but i dont know joomla |
| 04:50.10 | Synthesis | No, that is fine |
| 04:50.29 | Synthesis | Like I said, if I can just point it at the right table and field names, I'm pretty confident it will work |
| 04:50.36 | Synthesis | Not change anything in Joomla |
| 04:50.56 | Synthesis | Just change the tables/column names that Roster looks at, and add the additional columns roster needs to the Joomla auth username |
| 04:51.27 | Zanix | well, the search for the table name has all the files with that table |
| 04:51.34 | Synthesis | Yep |
| 04:51.46 | Synthesis | I'm just in Mogu'Shan Vaults right now lol |
| 04:51.49 | Zanix | you might be able to edit dbal/mysql.php to catch that table name and point it at joomla |
| 04:52.10 | Synthesis | Been fighting a boss during most of this conversation |
| 04:52.24 | Ulminia | yea im looking at the external auth feature for rostyer |
| 04:52.58 | Zanix | all it does is check the setting, and lets you pick the login.php from an addon |
| 04:53.19 | Zanix | pretty simple, include addon/login.php instead of roster/login.php |
| 04:53.27 | Zanix | but that's all it does |
| 04:55.44 | Synthesis | One more boss attempt |
| 04:56.24 | *** join/#wowroster WRUlminia (Ulminia@142.167.191.226) |
| 04:56.43 | WRUlminia | i dono wtf just happened |
| 04:57.00 | Synthesis | It doesn't like you lol |
| 04:57.03 | Zanix | lol |
| 04:59.49 | *** join/#wowroster Ulminia (Ulminia@142.167.191.226) |
| 05:00.05 | Ulminia | no it dosent |
| 05:02.58 | *** join/#wowroster WRUlminia (Ulminia@142.167.191.226) |
| 05:03.43 | WRUlminia | http://stackoverflow.com/questions/5176142/logging-in-to-joomla-1-5-using-external-form-not-within-joomla-folder-but-on-s/5207806#5207806 |
| 05:03.50 | WRUlminia | theres some good help[ |
| 05:04.06 | Synthesis | Thanks... |
| 05:04.14 | Synthesis | I closed WoW... So now I can look at this. |
| 05:04.26 | WRUlminia | just make a new login.php with the same functions |
| 05:04.43 | WRUlminia | maybe a lil more complicated then that ... |
| 05:04.58 | WRUlminia | but changing the table names to the joomla one in login should work |
| 05:05.12 | WRUlminia | as long as they are both in the same mysql database |
| 05:05.25 | Synthesis | Yep. They are |
| 05:05.35 | Synthesis | Also |
| 05:05.47 | Synthesis | The User tab in Roster CP |
| 05:05.55 | Synthesis | I should be able to add users there or change passwords, right? |
| 05:05.56 | WRUlminia | then change the table names to the exact joomla table names ex "joomla_users" |
| 05:06.17 | WRUlminia | no |
| 05:06.27 | Synthesis | Ok, seemed like it was missing some functions |
| 05:06.31 | WRUlminia | this would sever all roster usermanagement abiilitys |
| 05:06.43 | Synthesis | No, I know that... |
| 05:06.48 | Synthesis | I meant, unrelated to this issue |
| 05:06.54 | Synthesis | Should I be able to add users? |
| 05:07.03 | Synthesis | There is no function for that there. |
| 05:07.08 | Synthesis | Only delete and change access levels |
| 05:07.11 | WRUlminia | no users register |
| 05:07.12 | Synthesis | And disable |
| 05:07.24 | Zanix | i think that's the idea ulmin |
| 05:07.40 | Zanix | because he wants joomla to handle the user auth |
| 05:07.43 | WRUlminia | you want to manualy create users for roster? |
| 05:08.05 | Synthesis | No... I want users in Joomla to be able to access Roster after they have logged in to Joomla |
| 05:08.19 | Synthesis | I want Joomla and Roster to share the same User DB table |
| 05:08.33 | Synthesis | I want this to be one site, even though it is two "apps" |
| 05:09.26 | Synthesis | I understand that user uploads to the site for User profiles, etc are allowed/denied through the upload tab where you can block users or allow them, or allow the entire guild |
| 05:09.40 | Zanix | hmmm |
| 05:09.55 | WRUlminia | ud have to edit the user admin page too |
| 05:09.57 | Synthesis | I guess I just want to combine the auth for both |
| 05:10.12 | Zanix | you probably would just disable the user admin plugin |
| 05:10.15 | Synthesis | So that if you go from Joomla to the Roster, it sees you as already logged in. |
| 05:10.18 | Zanix | in roster |
| 05:10.24 | Synthesis | Most likely |
| 05:10.44 | WRUlminia | and change the roster cookie name to the joomla one |
| 05:11.27 | Synthesis | See, I honestly think that Roster is a great App.... I just see it as needing more of a true portal at the beginning (and yes, I have seen and tested the portal page)... |
| 05:11.33 | WRUlminia | and set the cookie fields to the joomla ones not the roster ones |
| 05:11.40 | Synthesis | So, if you add a content front end to allow blog style posts, screen shots, etc... |
| 05:11.52 | Synthesis | And then turn Roster into a full featured plugin in the backend... |
| 05:12.16 | Zanix | well |
| 05:12.26 | Zanix | there was the joomla integration |
| 05:12.35 | Synthesis | Yeah.. Sadly it is out of date. :( |
| 05:12.41 | Zanix | it did replace login and cms.link.php with hooks for joomla |
| 05:12.48 | Synthesis | And I don't know the first thing about how to update it |
| 05:13.15 | Zanix | I think it would be more than just replacing table names |
| 05:13.32 | Zanix | ulminia mentioned cookies |
| 05:13.38 | Synthesis | Yep |
| 05:13.40 | Zanix | if you just used the same tables |
| 05:13.43 | Zanix | they would have to log in again |
| 05:13.48 | Synthesis | Update the cookies, and it says "Oh, you are already here" |
| 05:16.37 | *** join/#wowroster Ulminia (Ulminia@142.167.191.226) |
| 05:16.52 | Ulminia | ... these disconects are getten anoying |
| 05:16.57 | Synthesis | I bet |
| 05:17.28 | Ulminia | basicly youd need to murge the roster use tabel with the joomla one |
| 05:17.34 | Ulminia | *user |
| 05:17.35 | Synthesis | Yep. |
| 05:17.40 | Synthesis | That was the plan. |
| 05:17.55 | Ulminia | then eddit the login.php and session to match joomla settings and it "should work" |
| 05:18.08 | Synthesis | Yes. And then just tweak the cookies. |
| 05:18.20 | Ulminia | cookie settings are in login.php |
| 05:18.25 | Synthesis | Ok |
| 05:19.02 | Zanix | what does session.php do? |
| 05:21.33 | *** join/#wowroster WRUlminia (Ulminia@142.167.191.226) |
| 05:21.44 | WRUlminia | tracks whos online |
| 05:21.47 | WRUlminia | thast all |
| 05:23.06 | Synthesis | I'm going to dig into this more tomorrow. :) Thank you both for your help. I think I can make it do what I want now that I know what files to parse |
| 05:23.24 | WRUlminia | cool |
| 05:26.10 | WRUlminia | im out for the night i need sleep |
| 11:38.55 | *** join/#wowroster apt (~apt@rikers.org) |
| 11:38.55 | *** topic/#wowroster is This room is for the support of WoWRoster.net programs and addons as well as general talk [WoWRoster v2.1.0 | Interface Image Pack v4.2.0 | WoWRoster Profiler v1.0.0RC | WoWRoster GuildProfiler v1.0.0RC | UniUploader v2.7.2.0 | UniAdmin v0.7.9] | The devs have lives, they're not monitoring 24/7, but they help when they can. |
| 16:18.08 | Synthesis | I have decided not to pursue the auth issue... I am going to just turn the very front page into a portal, and link to the Roster. |
| 22:29.15 | Zanix | certainly the easiest way to solve it |