News - Features - Downloads - Forum - Team - Support - Switch View: Screen
Login - Registrierung - Passwort vergessen

Antworten: 15
Seite [1]
MajorHitSquad


Beginner




Beiträge: 9
# Thema - 11.05.2013 um 16:12 Uhr
I am doing a bit of a migration from different CMS modules and integrating them to Clansphere. If I needed to rename the database tables in ClanSphere, what files would need to be changed and where are they located?
Inaktiv
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 1 - 11.05.2013 um 16:41 Uhr
all files of that specific module need to be changed then at least, maybe a few files of other modules, too (depends on the usage of the module in other modules). we tried to seperate modules as good as possible, but there are overcuttings, sometimes even a bit hidden ones.

if you have more specific questions it might be easier to give a better answer. beware that your renamings may need more work then expected. might be a good idea to instead create or copy + rename modules to not cause problems with changed and already existing or unmodified source code.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 2 - 11.05.2013 um 18:54 Uhr
Ye I guessed there would be many conflicts with other mods and I am actually coding-in my changes to a live site so I don't really want to test with it. (I know, not a wise thing to do but I trust my coding skills)

Maybe I would be better making a login module instead? I think this might be easier, with a little bit of parsing, pointing the new login form to the current user/pass in the SQL tables, and then pass them details including the seasons keys to the old login form module so I can be logged in to multiple systems simultaneously, if you understand what I mean?

Is there any news on the new ClanSphere system you are releasing. Is there a release date?


Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 3 - 11.05.2013 um 20:29 Uhr
well clansphere was not designed to have a login bridge with other systems, but that might be possible with some changes in the core dir and maybe also some user synchronisation with the other systems.

the basic clansphere system is already around 9 years old, but got many enhancements over time. we try to have a successor cms since 2007, so for quiet a while now. if we have new information about it we'll release them, but we had to pause the latest try. there will be nothing new before this fall i guess, sorry.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 4 - 12.05.2013 um 16:55 Uhr
No problem. I will be looking forward to any future developments you might release.

I do have one more question for you. Do you know of any current modules which allow you to use the shoutbox as a RSS feed? Basically, it will submit info received from an rss feed. How would you recommend I should implement this since you are more familiar with its systems.


Zuletzt editiert von MajorHitSquad am 12.05.2013 um 16:55 Uhr (2x Editiert)
Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 5 - 12.05.2013 um 17:20 Uhr
the rss module in clansphere can be used by other modules then the news, too. there is a file in the news module that is included on news changes to update the rss content:

https://github.com/ClanSphere/ClanSphere/blob/master/mods/news/rss.php

hope that helps


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 6 - 12.05.2013 um 18:35 Uhr
Sorry hajo, I didn't quiet explain that clearly. I would be looking for a rss parser which will take feeds from other sites and the shoutbox would receive these feeds and automatically post them as posts from a testuser or botuser account and post them on the shoutbox. What I am doing is making use of the shoutbox module and turning the whole thing into an activity feed to display everything that is happening on the site.


Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 7 - 12.05.2013 um 20:12 Uhr
oh ok so its the other way round. be sure to use caching so that remote sites are not checked more than once every minute or even less often as page loads might be very slow without such a thing. the caching functionality should help a bit with this using ttl in seconds for a refresh.

i've build a rss parser some years ago for esport news. that module might exist somewhere, but needs to be altered and extended with the cache thing then.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 8 - 13.05.2013 um 01:15 Uhr
Did you create that module as part of ClanSphere or was it for another project? Thanks for the tip with ttl. I got the rss feed synced into an external page for now parsing all the activity, (Similar to how I done the activity page mentioned on another post). Now, I just need to workout a good method to import it to the shoutbox tables in the phpmyadmin database.


Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 9 - 13.05.2013 um 12:40 Uhr
i've done it for clansphere and it was called ergebnisticker. the main reason i mention that is the xml parsing in that module which might be easy to copy and paste with small changes.

import to the shoutbox from where, another sql table? if so: why not directly use that one?

in the long run a scheduled cronjob might be better for remote checks then simple caching if you plan to check many remote sites.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 10 - 13.05.2013 um 18:04 Uhr
Well, when I mentioned, "sites" it was for example purpose to be clear in my explanation, but all "sites" would be pages within Clansphere. I just explained it like that so I wouldn't confuse you.

"import to the shoutbox from where, another sql table? if so: why not directly use that one?"


Not really, basically, what I need to do now is; when the rss parser receives its "updates" via a php file, it will then send the received updates (line for line -- update per update as a separate "shout") Remember, I duplicated the shoutbox mod which I've now created and I've updated the Database tables at this stage to have separate tables for the RSS feed to store its feeds and posts.)

This way; the shoutbox still has its own database tables and it is not effected by the RSS feed in any way. The shoutbox remains the shoutbox.

BUT, with the duplicate shoutbox module I've now created, It will store all the sites activity, in this module, including the RSS feeds, screenshot uploads (VIA the image gallery -- Also converted it to a screen capture feature, as I failed to mention, that I am creating an actual C++ application for clansphere to work while users are ingame). I'm also dropping the "replay module" and recoding a video capture for the C++ application to record ingame videos and store them in the clansphere sites "new improved video gallery".

At the current time, this is what I've done. The C++ application is in Alpha stages at present and I am still testing it.


Zuletzt editiert von MajorHitSquad am 13.05.2013 um 18:06 Uhr (1x Editiert)
Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 11 - 13.05.2013 um 19:24 Uhr
next thing i got wrong it seems, so with sites you meant local content of your website, sorry. it sounds now like an audit log of new content of the website that other users should notice while viewing the "new shoutbox" or better called site-news. what i still don't got is how i and maybe others can help you now. maybe it would be helpful if you provide a list from 1 to X with the steps and mark the one you are currently working at.

the c++ app sounds nice, would be nice to hear / see something of it at a later time.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 12 - 13.05.2013 um 19:57 Uhr
2013-05-13 at 7:24 PM - hajo:
next thing i got wrong it seems, so with sites you meant local content of your website, sorry. it sounds now like an audit log of new content of the website that other users should notice while viewing the "new shoutbox" or better called site-news. what i still don't got is how i and maybe others can help you now. maybe it would be helpful if you provide a list from 1 to X with the steps and mark the one you are currently working at.

the c++ app sounds nice, would be nice to hear / see something of it at a later time.


I will try get a screenshot of the C++ application uploaded in a day or so.

The second shootbox I created is more of an "Recent Activity" Like a "Facebook wall" of content.

The part, I'm kinda having issues with is the receiving the RSS feed, and then submitting it with php to insert into the SQL tables, basically I just duplicated the SQL tables and renamed them:

1 shoutbox1_id
2 shoutbox2_name
3 shoutbox3_text
4 shoutbox4_date
5 shoutbox5_ip

What is the shoutbox file and location of the file that submits the form to the database, so I can see an example? I'm not sure what I'm doing wrong, maybe I'm just overtired or something..


Zuletzt editiert von MajorHitSquad am 13.05.2013 um 20:01 Uhr (2x Editiert)
Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 13 - 13.05.2013 um 21:32 Uhr
the tpl files are containing the layout and forms, the php files are containing the application logic. the shoutbox module has the create and navlist with such functionality (regarding the creation of new entries). tpl files are stored inside the themes/[theme-set-name]/[module-name]/ directory.

excuse that i ask again, but where is the rss content coming from, remote or local sites? recent activity is what i meant with audit log, seems i'm getting closer to your questions. i hope to not confuse you too much


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
MajorHitSquad
Thread-Ersteller


Beginner




Beiträge: 9
# Antwort: 14 - 15.05.2013 um 20:27 Uhr
"excuse that i ask again, but where is the rss content coming from, remote or local sites? recent activity is what i meant with audit log, seems i'm getting closer to your questions. i hope to not confuse you too much"

lol The activity is coming from pages and modules from within clansphere (not external sites). See, because of the functionality of how it was designed, It was rather time consuming to go sniffing for all the navs for all the different modules, so I thought it would be easier to syndicate the content from all modules and place it on one big activity page by using RSS. Hope this answers your question.


Inaktiv
|
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 15 - 15.05.2013 um 21:49 Uhr
sounds still strange, rss was made to contain a few or maybe a bit more entries, but not hundreds or thousands. why not directly insert / update the site-activity copied from the shoutbox when something happens in other modules? a hook with some exceptions inside the cs_sql insert and update functions should do the job, maybe also delete to remove things that have gone away later on.


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
Antworten: 15
Seite [1]


Sie müssen sich registrieren, um zu antworten.


ClanSphere Project - Mailus - Imprint - Disclaimer - Scriptinfo