Clan Adverts

Sponsors

CT on Facebook

Latest Product

Battlefield 3 Stats Module
Battlefield 3 Stats Module

User Box

Anonymous
38.107.179.218
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ?This sh...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriousl...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - Sql help needed please
Sql help needed please

1 Replies / 713 Views
Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » PHPBB

View previous topic :: View next topic

Snype
Reputation: 305.5 Add RepSubtract Rep
votes: 8
Local time: 2:36 AM
Location: lincolshire
uk.gif

0.60 posts per day
Medals: 1 (View more...)
Site Supporter (Amount: 1)
Respected Member
Respected Member
Joined: May 20, 2008
Last Visit: 06 Nov 2011
Posts: 812
Points: 60742 
Post Sql help needed please Posted: Mon Jul 06, 2009 3:27 pm
Shop Purchases:Call of Duty 4 SAS Theme
hey guys so i have decided to bring back some old bbtonuke mods and update them to the latest RavenNuke now simple SQL i have no problem with the more advance SQL i do. Anyway i found a cool mod that i dont belive has been ported to nuke yet so i went ahead and done it the mod in question is a "custom user title hack" (if this has been done then oopps i wasted my time lol) it allows the users of your forum to choose there own title like vBulletin does anyway the mod all works no errors apart from it wont submit to the db cause the SQL is way over my head and i just cant figure it out , So if any one can help me with this SQL it will be a great help and i could use it for reference when/if the problems pops up again.


well attachment would not work so i have hosted it on my site

http://themeconversions.com/title_install.zip
 

WebSite > http://www.phpnukeblog.info Xfire > DDsnype MSN > ritchietaylor@live.co.uk Email > admin@phpnukeblog.info  
View user's profileSend private messageVisit poster's websiteMSN Messenger Reply with quote

clyde4210
Reputation: 395.3 Add RepSubtract Rep
Local time: 9:36 PM

blank.gif

 OMG
OMG

0.11 posts per day
Medals: 0
Joined: Oct 24, 2007
Last Visit: 24 Jul 2009
Posts: 167
Points: 7534 
Post Sql help needed please Posted: Mon Jul 06, 2009 4:58 pm
Well you haven't said what if any errors it is calling. No one could tell by simply looking at the php file. Due to the fact the files are missing and needed to run the installer properly.

also it should look like this in a way

example:
Code:
$sql[] = "ALTER TABLE " . USERS_TABLE . "
         ADD COLUMN user_custom_title varchar(255) NULL,


should look something like this:
Code:
$sql[] = "ALTER TABLE " .nuke_users . "
         ADD COLUMN ."`user_custom_title` varchar(255) NULL,";


Best way would be to use .prefix_users

and yes i believe this mod has been done, it's over at code wiz. can't remember though.

I do know unless you have recoded this mod, it will only allow for a custom rank to be added automatically. It was last used on PHPBB 2.0.4, Aexoden Custom title mod.

This actually just allows you as admin set custom title ranks that will be used after so many days and or posts. It does not allow for users to choose there own custom rank besides the ones you have set. You as the admin make custom rank titles. Of course reading the thread on this, there are two ways of showing and not showing the both ranks on forum.
 

 
View user's profileSend private messageVisit poster's website Reply with quote
Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » PHPBB


 
1 Replies / 713 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 can 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