Comming Soon:Accounts Addon

Adds complete user authorization to Roster

Moderator: mdeshane

Comming Soon:Accounts Addon

Postby Blueleaf » Tue Feb 03, 2009 12:21 pm

Getting the following on account creation..

Database Error0:
File: lib\dbal\mysql.php
Line: 234

any Idea's

BTW Great Mod this will be a great addition, I might be able to remove my CMS and strip down my server for faster access.

I might be doing somthing wrong but it seems straight forward enuff.

Here is the site if you need to check it out

http://bluesworld.game-host.org/roster
User avatar
Blueleaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Apr 26, 2007 12:06 am
Location: Minot, ND

Re: Comming Soon:Accounts Addon

Postby mdeshane » Fri Apr 03, 2009 10:45 pm

It could be a problem with changes between Roster 2.0.1 and 2.0.2. I have been busy with buying a house and have been neglecting the addon. I will update my server to Roster 2.0.2 and see if it has the same problem. In the mean time if there is any other information you could provide, such as whether you used the registration or application for account creation, as one uses the user class and the other uses the profile class, the later actually does the same as the first and then some. But it seems there is an error trying to save information to the database.
Image
Accounts Addon - Roster v2 User Account Addon

PKC Dev Site - http://dev.pkcomp.net
My Roster Dev Site - http://myroster.dontexist.net
User avatar
mdeshane
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 203
Joined: Sun Dec 10, 2006 4:54 am
Location: Grand Rapids, MI USA
Realm: Khadgar (PvE) - US

Re: Comming Soon:Accounts Addon

Postby reddragon010 » Thu Apr 30, 2009 12:52 am

ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!
reddragon010
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Apr 19, 2009 10:12 pm

Re: Comming Soon:Accounts Addon

Postby Lorkam » Tue May 12, 2009 5:55 am

reddragon010 wrote:ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!


Well I found the the svn and compiled the addon but seems to be some syntax error when you go to install it. I been looking it up for a few hours now in sql documentation. With no luck yet. The syntax error is somewhere in the underlining text I think INDEX KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;but that still wouldn't fix the database not being able to save properly like the author posted early last month.

Nvm if you look at the previous page of this thread you will find the answer to the syntax error and here I knew it all along when I read it in sql documentation :P

Code: Select all
Install error in query 64. MySQL said:
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 11
The query was:
CREATE TABLE `roster_addons_accounts_messaging` ( `msgid` int(11) NOT NULL auto_increment, `uid` smallint(6) NOT NULL, `title` varchar(255) NOT NULL default '', `body` text NOT NULL, `sender` int(11) NOT NULL, `senderLevel` int(11) NOT NULL, `read` int(11) NOT NULL default 0, `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`msgid`), INDEX KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Roster Version 2.0.2
Roster Guild Deathbringershttp://deathbringer.us/(a)roster/
Roster Guild Deathbringer(new roster template) http://deathbringer.us/(h)roster/
Guild site hosted and templated by WoWGuilds.ca (highly recommend) http://deathbringers.us/
Image
User avatar
Lorkam
WR.net Apprentice
WR.net Apprentice
 
Posts: 37
Joined: Mon Jul 10, 2006 12:21 pm

Re: Comming Soon:Accounts Addon

Postby Lorkam » Tue May 12, 2009 6:40 am

reddragon010 wrote:ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!


Sorry for the double post. let me answer this better. In order to install this addon you need to head over to wowroster's svn. Here is the link http://www.wowroster.net/websvn/listing.php?repname=roster_addons&path=%2Ftrunk%2Faccounts%2F&sc=1#_trunk_accounts_ or this one I like better because it is easier to view the code within each file http://www.wowroster.net/websvn/listing.php?repname=roster_addons&path=%2Ftrunk%2Faccounts%2F&sc=1#_trunk_accounts_

Now once your there go get a program called jEdit it i simply a free tool for programmers or in our case compilers :P All you do it create the file structure for the addon called accounts within a folder you create called accounts. You simply open each file in the svn copy the text into jEdit then save it to the folder it needs to go into it. A hint when saving your files click save as, then type the full name of the file for example install.def.php and hit save your all set. Make sure if the author use capital letters to name a file then you use capital letters to name that file. Strictly adhere to the naming conventions. So when your done you should have the exact file structure in your accounts folder as seen on the svn.

But then you have to edit the install.def.php file in accounts\inc\ in three spots once on line 158 use the search button in jEdit and search for INDEX KEY simply replace it with the word KEY and drop the INDEX part of it and do it at line 242 and line 313. You can view line numbers by checking the box line numbers under the view menu.
Roster Version 2.0.2
Roster Guild Deathbringershttp://deathbringer.us/(a)roster/
Roster Guild Deathbringer(new roster template) http://deathbringer.us/(h)roster/
Guild site hosted and templated by WoWGuilds.ca (highly recommend) http://deathbringers.us/
Image
User avatar
Lorkam
WR.net Apprentice
WR.net Apprentice
 
Posts: 37
Joined: Mon Jul 10, 2006 12:21 pm

Re: Comming Soon:Accounts Addon

Postby mdeshane » Tue May 19, 2009 11:26 pm

Hello all! Sorry I've been gone so long. I've been moving, so I've been pretty busy. Luckily I'm almost done getting my development server up and running better than ever! I had made the changes to the install.def.php file and have tried to send it to the SVN, unfortunately the SVN doesn't like my password. I will be setting up a new site where I'll have a link to my addons development versions. Otherwise, final and RC versions will be posted here in the download section. Please bear with me for a while longer while I finish re-organizing, and figure out what's wrong with my SVN access, so I can finally finish the Accounts addon.
Image
Accounts Addon - Roster v2 User Account Addon

PKC Dev Site - http://dev.pkcomp.net
My Roster Dev Site - http://myroster.dontexist.net
User avatar
mdeshane
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 203
Joined: Sun Dec 10, 2006 4:54 am
Location: Grand Rapids, MI USA
Realm: Khadgar (PvE) - US

Re: Comming Soon:Accounts Addon

Postby Anaxent » Wed May 20, 2009 2:33 am

Your svn access is based on your forums username and forums password. The first time I tried to reconnect to the svn after our move I was not able to until I made my username start with a capital letter (Anaxent rather than anaxent) hope this helps else let us know so that we can help you fix your access.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Re: Comming Soon:Accounts Addon

Postby zanix » Wed May 20, 2009 3:03 am

SVN access is kinda funky here
It updates only when you log-in or change your password

We implemented this method after we opened the site, so the password on the svn side might not have been updated
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Comming Soon:Accounts Addon

Postby mdeshane » Sat May 23, 2009 2:36 am

Woohoo! :glad: Logged out of the site, and back in, and voila! My SVN Commit went without so much as a prompt for my username! Thank you Anaxent and Zanix! As always you guys rock! On with the point of this post, I've committed the change to the install.lib.php for the addon. The commit/changelog now is below.

Accounts v1.9.9.941 [SVN]444:
- Fixed
-- MySQL error on messaging table in install.def.php

I'll try to see if I can get this into beta shortly as the popularity of this addon seems to be growing. For that I'll have to finish the admin stuff and check for loose ends (miscellaneous errors).
Image
Accounts Addon - Roster v2 User Account Addon

PKC Dev Site - http://dev.pkcomp.net
My Roster Dev Site - http://myroster.dontexist.net
User avatar
mdeshane
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 203
Joined: Sun Dec 10, 2006 4:54 am
Location: Grand Rapids, MI USA
Realm: Khadgar (PvE) - US

Re: Comming Soon:Accounts Addon

Postby Xcantion » Sat Jun 20, 2009 3:37 am

cooming soon?
May 23, 2009 now we have june 20... :-/
Xcantion
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Thu Apr 16, 2009 1:18 am

Re: Comming Soon:Accounts Addon

Postby mdeshane » Tue Jun 30, 2009 3:37 pm

Xcantion wrote:cooming soon?
May 23, 2009 now we have june 20... :-/


Well, if you'd like to complain, I can make sure it never comes out! I've had alot of IRL stuff happenning, and have been otherwise pre-occupied. I'm one person working on the addon, more people would make it go faster, but likely cause other problems, the addon is useable and in the SVN, most of what's left is fixing up the admin pages. I don't want to see anymore comments on how long the addon is taking! If you don't like it, WRITE YOUR OWN DAMN ADDON!!!
Image
Accounts Addon - Roster v2 User Account Addon

PKC Dev Site - http://dev.pkcomp.net
My Roster Dev Site - http://myroster.dontexist.net
User avatar
mdeshane
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 203
Joined: Sun Dec 10, 2006 4:54 am
Location: Grand Rapids, MI USA
Realm: Khadgar (PvE) - US

Re: Comming Soon:Accounts Addon

Postby zanix » Tue Jun 30, 2009 7:31 pm

Yeah!
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Comming Soon:Accounts Addon

Postby jessman » Tue Jun 30, 2009 10:19 pm

Ive got the Accounts module loaded well so the plugin section says yet I am getting a module does not exist error
http://eonsofstupidity.com/woster
jessman
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jun 30, 2009 7:37 am

Re: Comming Soon:Accounts Addon

Postby mdeshane » Fri Jul 03, 2009 1:30 am

When I enter in the url for the Accounts Main page it says that accounts is not installed. Please try re-uploading the files to your site and try to install the addon from the roster configuration Addon Management page. Ensure that the status is activated after install. Please note any errors it may report. Also be sure to set Roster Auth to Accounts in the main roster configuration, this will ensure the proper use of addon permissions and login with Accounts. After Accounts is installed and functioning, you will want to create an account, do this by clicking a registration link on the login screen, note that where it says group password, you should enter the roster admin group password for an admin account. Please also remember that Accounts is still pre-beta, though most of the bugs are out, some may still exist.
Image
Accounts Addon - Roster v2 User Account Addon

PKC Dev Site - http://dev.pkcomp.net
My Roster Dev Site - http://myroster.dontexist.net
User avatar
mdeshane
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 203
Joined: Sun Dec 10, 2006 4:54 am
Location: Grand Rapids, MI USA
Realm: Khadgar (PvE) - US

Re: Comming Soon:Accounts Addon

Postby jessman » Fri Jul 10, 2009 10:33 am

yea sorry about this I had to remove it to run the armorysync addon due to some weird error. However I did for a temporary time re-enable the addon just for you
http://www.eonsofstupidity.com/woster/
it says it installed properly through the addon. However I would like to make note the php I believe they were, when i went to save them from the SVN appeared blank so i created blank sheets with the exact file name. Anyways I pm'd you our admin password as well.
jessman
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jun 30, 2009 7:37 am

PreviousNext

Return to Accounts

Who is online

Users browsing this forum: No registered users and 0 guests

cron