[GUIDE]Making Joomla CMS for Rose

This is guide mostly for website tools and code, for example CMS or registration scripts.
There can also be tools.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

[GUIDE]Making Joomla CMS for Rose

Postby dbraders on Mon Jun 11, 2012 1:13 pm

This is my first threat, I am new member here, I still learning how to set and make server of rose online,I hope this threat can be usefull for this forum :)
this's step how to create Joomla CMS for Rose ( Basic ) :
1. Install Joomla
2. Synchronization Joomla User sql with database sql rose
3. Synchronization database server
4. Remove Salt function user password Joomla

Explanation:

1. Install Joomla
I use Joomla 1.5.26
- Extract Joomla_1.5.26-Stable-Full_Package.zip to your web root
here I use xampp so my web root in C:\xampp\htdocs
- Delete Joomla_1.5.26-Stable-Full_Package.zip after you extract it
- Open localhost on your web browser, you will bring to this address http://localhost/installation/index.php
- Choose language and Next - Next
- In database configuration, fill this ( configuration as like as your sql database ) :
Database Type : Mysql
Hostname : localhost ( your hostname, change if needed )
Username : root ( your sql database username )
Password : 01testrose01 ( your sql database password )
DatabaseName : roseon ( your rose database name )
- Next - Next ( FTP configuration choose NO )
- Main configuration
Site Name : Rose Test ( your rose site name )
Your Email : testrose@rose.com ( fill with what ever you want )
Admin Password : testrose01 ( used to login Back end as administrator on your web )
Confirm admin password : testrose01
( not need to install Sample Data )
- Next and OK
- in FINISH step you recommended to delete your Joomla installation folder
( Delete folder INSTALLATION in Joomla, ex : C:\Xampp\htdocs\Installation )
- Klik Admin to go Administrator login
- Type your username and password admin, in this case
Username : admin
Password : testrose01

2. Synchronization Joomla User sql with database sql rose
to synchron your user sql base ( accounts.sql ), you need syncron design table of accounts.sql with jos_users.sql ( sql created by Joomla, in this case is jos_users.sql ).
- add all table field on design table of accounts.sql to jos_users.sql
- or you can use my edit this one : http://www.mediafire.com/?4ahw58if69t6yvs

3. Synchronization database server
- Open LoginServer.cbp, CharServer.cbp and WorldServer.cbp in your database with CodeBlock, choose Search-Replace in Files ( use shortkey Ctrl-Shift-R )
- Replace accounts with jos_users
[img]
replace.png
[/img]
- You will get a replace warning, just klik ALL,
- Save and Rebuild your base

4. Remove SALT function user password Joomla
This needed to make a same password encryption jos_users like a encryption from rose cms accounts, ( if you didn't do this, you will only can login in web but in game login you will get "incorrect password" )
follow this link for tutor : http://forum.joomla.org/viewtopic.php?p=1882268


Ok, that's a basic guide to make Joomla Rose CMS, for Other development, Module etc
Please your share for advance
Sorry for my Bad Post and My bad English :D :lol:
I just wanna Share ;)


I am Newbie :D , Please your guide ;)
Attachments
replace.png
replace.png (23.21 KiB) Viewed 12306 times
dbraders
Jelly Bean
Jelly Bean
 
Posts: 12
Joined: Fri Mar 09, 2012 10:57 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby dbraders on Tue Jun 19, 2012 7:14 pm

do you have a comment for my post ?? :lol:
is this make confused or it's completely no problem ??
thre are 63 views for this post :shock: no one comment here :lol:


I am newbie :D , Please your guide ;)
dbraders
Jelly Bean
Jelly Bean
 
Posts: 12
Joined: Fri Mar 09, 2012 10:57 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby wolfwing on Tue Jun 19, 2012 9:32 pm

People are barely active, and the least views are in this forum.
wolfwing
Clown
Clown
 
Posts: 502
Joined: Tue Mar 03, 2009 9:50 am

Re: [GUIDE]Making Joomla CMS for Rose

Postby dbraders on Mon Jun 25, 2012 2:38 pm

:lol: Ok, it's fine ;)
dbraders
Jelly Bean
Jelly Bean
 
Posts: 12
Joined: Fri Mar 09, 2012 10:57 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby 5oregon5 on Sat Dec 29, 2012 11:49 pm

I'm sorry I didn't get it from the synchronizing part, i'm stuck there.
5oregon5
Pomic
Pomic
 
Posts: 74
Joined: Fri Jun 18, 2010 7:35 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby hoegarden31 on Sun Dec 30, 2012 12:17 am

The basic part of the one where you are stuck is just to add all the table fields that are required for that joomla thingy to work in the accounts table of the game.

I still don't understand why he is adding all the fields from accounts to his joomla table then replace all the accounts in the game exes to joomla.... Isn't just adding the missing fields in the account table good enough ? It saves you time to not recompile your exe's or make any mistakes while you change all the names. I would rater modifie all php files than mess the hole rose game just so it takes an other table for the users.

So to unstuck you, look at all the fields in that jos_users table, add them to the accounts table of the game. Then in all the joomla files, you replace "jos_users" by "accounts".
I'm the one and only. In heaven and on earth.
Image
hoegarden31
Rackie
Rackie
 
Posts: 150
Joined: Sun Nov 13, 2011 7:13 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby 5oregon5 on Sun Dec 30, 2012 1:56 am

okay thanks, now how do I take out my account sql from navicat? or edit it inside? And do you have any idea which php files I have do edit?
5oregon5
Pomic
Pomic
 
Posts: 74
Joined: Fri Jun 18, 2010 7:35 pm

Re: [GUIDE]Making Joomla CMS for Rose

Postby hoegarden31 on Sun Dec 30, 2012 11:32 am

just look in that "jos_users" table, and then create all the fields in your account table.
If you know sql then do it with a simple query. If not, then do it manually in navicat. You can design tables, just add the missing fields with that. About the files i don't know. You will have to search for it :)
I'm the one and only. In heaven and on earth.
Image
hoegarden31
Rackie
Rackie
 
Posts: 150
Joined: Sun Nov 13, 2011 7:13 pm


Return to PHP / Web Guides, Scripts and tools.

Who is online

Users browsing this forum: No registered users and 5 guests