Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.218

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - A couple of things please help with

A couple of things please help with

7 Replies / 487 Views


www.clanthemes.com Forum Index » General Topics	View previous topic :: View next topic

Amazon.co.uk Widgets

daz226
Reputation: 505
Local time: 6:04 PM

Spammer

0.05 posts per day
Medals: 0

Joined: Feb 28, 2007
Last Visit: 21 Jun 2011
Posts: 85
Points: 18021

A couple of things please help with Posted: Sat Feb 20, 2010 4:24 pm
Shop Purchases:Clan Roster 2.0 · BattleField:Bad Company 2 Video splash · Battlefield: Bad Company 2 Xtreme Theme · Battlefield 3 Xtreme Theme

Ok Chaps
i am a noob to all this how ever i have completed my site with only a couple of issues that i would like some help on. I have tried on one and could not get it to work.

I would like the following on my forums i am running raven nuke

Advanced user colour i am stuck mega here
----[ SQL ]------------------------
-----------------------------------

CREATE TABLE `nuke_bbadvanced_username_color` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(255) NOT NULL default '',
`group_color` varchar(6) NOT NULL default '',
`group_weight` smallint(2) NOT NULL default '',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM ;

ALTER TABLE nuke_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE nuke_users ADD user_color_gi TEXT DEFAULT NULL;
not got a clue what to do here ??????????

next issue is on my forums i would like to show who has visited that day ....again cant get that going

and finally when on the forums i would like a green ONLINE status or a red OFFLINE status

i understand this is possibly simple to you cleaver code chaps but its a alien world to me and thisis all that stands in the way of my site being complete i will donate / pay for this to be done i have spent so many hours on this i now need help

so please if you can help i would be delighted in fact ill run down my street naked ...........lols

thanks for reading guys

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 3:04 AM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 10 Feb 2012
Posts: 2459
Points: 128885

Re: A couple of things please help with Posted: Sat Feb 20, 2010 4:41 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

yeah, okay, let's start with that SQL. What you need to do is go into your phpMyAdmin and get into your RN DB. Then once in there you will see a tab called SQL at the top center. Click that and you will see a box, in there copy and paster that SQL into there.

Code:

CREATE TABLE `nuke_bbadvanced_username_color` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(255) NOT NULL default '',
`group_color` varchar(6) NOT NULL default '',
`group_weight` smallint(2) NOT NULL default '',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM ;

ALTER TABLE nuke_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE nuke_users ADD user_color_gi TEXT DEFAULT NULL;

After you do that. to test that you have it working. here is a video tutorial on what you need to do to use it.

http://www.phpnukedownloads.com/sub-forum-using-the-simple-subforums-mod/

as for the visitors of the day, make sure you did all the edits correctly. I know I ran into that problem once before but it was on my end. I forgot to upload one of the files I edited, I think it was a theme file.

As for the color of there status, there is a way. I don't remember how i did it.

Allot of what your asking for is why I don't use RN and use Evo. because allot of this stuff is already there.

daz226
Reputation: 505
Local time: 6:04 PM

Spammer

0.05 posts per day
Medals: 0

Joined: Feb 28, 2007
Last Visit: 21 Jun 2011
Posts: 85
Points: 18021

A couple of things please help with Posted: Sat Feb 20, 2010 5:55 pm
Shop Purchases:Clan Roster 2.0 · BattleField:Bad Company 2 Video splash · Battlefield: Bad Company 2 Xtreme Theme · Battlefield 3 Xtreme Theme

i should have gone with evo then how easy would it be for me to change to evo

Ped
Reputation: 64
votes: 35
Local time: 9:04 AM
Location: Great British Empire

Site Founder

2.33 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 10 Feb 2012
Posts: 4467
Points: 181246

Re: A couple of things please help with Posted: Sat Feb 20, 2010 6:14 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Not that hard there is a very detailed upgrade folder with good instructions and help.

I will swap the theme from Standard to Evo Xtreme to help you for £10 so you don't have to buy it again.

Download Xtreme and look for the upgrade files

daz226
Reputation: 505
Local time: 6:04 PM

Spammer

0.05 posts per day
Medals: 0

Joined: Feb 28, 2007
Last Visit: 21 Jun 2011
Posts: 85
Points: 18021

A couple of things please help with Posted: Sat Feb 20, 2010 6:20 pm
Shop Purchases:Clan Roster 2.0 · BattleField:Bad Company 2 Video splash · Battlefield: Bad Company 2 Xtreme Theme · Battlefield 3 Xtreme Theme

Ped thank you this is all a massive learning curve for me here so do i completly empty my ftp and delete all the folders

is it evo xtreme i download ? then the theme sorry for the dumb questions
ill pay now also m8 thank you

Ped
Reputation: 64
votes: 35
Local time: 9:04 AM
Location: Great British Empire

Site Founder

2.33 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 10 Feb 2012
Posts: 4467
Points: 181246

Re: A couple of things please help with Posted: Sat Feb 20, 2010 6:28 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Wait till you upgrade first before buying theme

If you just want to save your forums and users then just save your database

if you want to save everything then I think you have to do a conversion first then upload the new site..

Been a while since I did a move from RN to Xtreme

daz226
Reputation: 505
Local time: 6:04 PM

Spammer

0.05 posts per day
Medals: 0

Joined: Feb 28, 2007
Last Visit: 21 Jun 2011
Posts: 85
Points: 18021

A couple of things please help with Posted: Sat Feb 20, 2010 6:35 pm
Shop Purchases:Clan Roster 2.0 · BattleField:Bad Company 2 Video splash · Battlefield: Bad Company 2 Xtreme Theme · Battlefield 3 Xtreme Theme

Ped i am upgrading now ( scarey) can you pm a link so as i can pay the the theme please and ill pay now

daz226
Reputation: 505
Local time: 6:04 PM

Spammer

0.05 posts per day
Medals: 0

Joined: Feb 28, 2007
Last Visit: 21 Jun 2011
Posts: 85
Points: 18021

A couple of things please help with Posted: Sat Feb 20, 2010 9:08 pm
Shop Purchases:Clan Roster 2.0 · BattleField:Bad Company 2 Video splash · Battlefield: Bad Company 2 Xtreme Theme · Battlefield 3 Xtreme Theme

Arrrrrr Ped come back on line i have now upgraded just need to download the theme

www.clanthemes.com Forum Index » General Topics

7 Replies / 487 Views
Page 1 of 1
All times are GMT

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work