Hello! I'm hoping someone could point me in the direction of some more updated & accurate tutorials for the information I'm looking for.
I would just like to give a huge thank you to Groxy101 for the amazing setup tutorial. Very informative and detailed! Also another huge thank you to Ketchup for providing the files used in the guide.
First question how do I even go about creating a website for my server? As in the kind that I can let players register and all the jaz. After looking at the help section and googling It appears Xampp is used? I could not find a clear guide on that one, I'm hoping I've missed it and someone could link me it. Or is Xampp no longer used? Any nudge in the right direction would be appreciated.
My second question i solved after tinkering with Spec_item.txt.
Thank you in advance for the help!
Thank you both n0tso1ee7 and Ketchup. I have gone with IIS and I have also used the Sapphire website you have provided. My follow up question is this now.
My next question is, this: I know my DB structure should be Account/Character/Logging/Ranking then website. When looking at Sapphire's SQL folder, I see quite a few SQL query files. Do I excite them all? Do I do something similar to what was in Groxy101's setup guide when creating the initial DBs?
Again thank you in for the help you all have already given!
Thank you Ketchup.
That leaves the four other sql files outside of the website_dbf folder. I tired to run them and was met with errors. Is there something special I must do?
I also added the website to the ODBC (following in the footsteps of the server set up guide), was this the correct thing to do?
After google translating the readme file, it mentioned giving the read/write permissions to the security folder. Is this what it means by the permissions?
You must be registered to see links
At this point I still cannot see my site (localhost not live)and I'm a little unsure as to why. Any insight or thinks I can double check would be appreciated.
You must be registered to see links
Note: I am using IIS, I added the website and it's path to the files. Anything else I need to do?
Changed over to WAMP and the website appears to be online now. Wamp feels easier to navigate and I think I wound up missing a dependency to install for IIS.
EDIT: After reading http://forum.ragezone.com/f724/wamp-mssql-673301/index3.html it appears you made the post at the end with how dated it is. My new question is what would you recommend to use? I've searched thru the tut and help section for something concrete and all I really get is what appears to be dated information and vague ideas.
I getYou must be registered to see linkswhen trying to open the SQL file ACCOUNT_TBL then executing it. However, everything else works and executed just fine. I've also tried swapping out the sapphire for one of your other websites. Still the same error, no matter what it seems.
What can I double check to see if I made a mistake anywhere along the way?
Thank you for taking the time to help me out Ketchup.
Msg 4901, Level 16, State 1, Line 24
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'votepoints' cannot be added to non-empty table 'ACCOUNT_TBL' because it does not satisfy these conditions.
Msg 1752, Level 16, State 0, Line 31
Column 'votepoints' in table 'ACCOUNT_TBL' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 31
Could not create constraint or index. See previous errors
SET QUOTED_IDENTIFIER ON
GO