You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 546 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
PHP-Nuke: Difference between 6.5b5 and 6.5b6 & Upgrade Script
PHP-NukeThe following tables are no longer in the nuke.sql generation script for PHP-Nuke Beta 6. Bye bye Splatt:
  1. nuke_words
  2. nuke_usersettings
  3. nuke_smiles
  4. nuke_ranks
  5. nuke_posts_text
  6. nuke_posts
  7. nuke_forumtopics
  8. nuke_forums
  9. nuke_forum_notifica
  10. nuke_forum_mods
  11. nuke_disallow
  12. nuke_catagories
  13. nuke_banlist
  14. nuke_access
Just a reminder that these versions are BETA so if you do now understand how to program or use PHP or MySQL then we highly recommend you wait for the production release.

The following tables were changed from (besides the CREATE TABLE lines to show which tables are affected, the only lines includes are the ones that were changed -- all others are the same):
CREATE TABLE nuke_chatusers (
alias char(20) NOT NULL default '',
color char(7) NOT NULL default '',
to
CREATE TABLE nuke_chatusers (
alias varchar(20) NOT NULL default '',
color varchar(7) NOT NULL default '',
From
CREATE TABLE nuke_users (
uid int(11) NOT NULL auto_increment,
uname varchar(25) NOT NULL default '',
email varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
user_intrest varchar(150) default NULL,
pass varchar(40) NOT NULL default '',
PRIMARY KEY (uid),
KEY uid (uid),
KEY uname (uname),
to
CREATE TABLE nuke_users (
user_id int(11) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_website varchar(255) NOT NULL default '',
user_interests varchar(150) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
PRIMARY KEY (user_id),
KEY uid (user_id),
KEY uname (username),
The following code will correctly "upgrade" your PHP-Nuke 6.5 Beta 5 database to Beta 6 for only the nuke_users and nuke_chatusers tables:
alter table nuke_users drop primary key;
alter table nuke_users change uid user_id INT(11) NOT NULL AUTO_INCREMENT;
alter table nuke_users change uname username VARCHAR(25) NOT NULL default'';
alter table nuke_users change email user_email VARCHAR(255) NOT NULL default'';
alter table nuke_users change url user_website VARCHAR(255) NOT NULL default'';
alter table nuke_users change user_intrest user_interests VARCHAR(150) NOT NULL default'';
alter table nuke_users change pass user_password VARCHAR(40) NOT NULL default'';
alter table nuke_users add primary key (user_id);
alter table nuke_chatusers change alias alias VARCHAR(20) NOT NULL default'';
alter table nuke_chatusers change color color VARCHAR(7) NOT NULL default'';
For those that would like to see the diff on nuke.sql between beta 6 (left arrow) and beta 5 (right arrow) see below:
diff sql/nuke.sql ../65b5/sql/nuke.sql
7a8,29
> -- Table structure for table 'nuke_access'
> --
>
> CREATE TABLE nuke_access (
> access_id int(10) NOT NULL auto_increment,
> access_title varchar(20) default NULL,
> PRIMARY KEY (access_id),
> KEY access_id (access_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_access'
> --
>
>
> INSERT INTO nuke_access VALUES (-1,'Deleted');
> INSERT INTO nuke_access VALUES (1,'User');
> INSERT INTO nuke_access VALUES (2,'Moderator');
> INSERT INTO nuke_access VALUES (3,'Super Moderator');
> INSERT INTO nuke_access VALUES (4,'Administrator');
>
> --
72a95,115
> -- Table structure for table 'nuke_banlist'
> --
>
> CREATE TABLE nuke_banlist (
> ban_id int(10) NOT NULL auto_increment,
> ban_userid int(10) default NULL,
> ban_ip varchar(16) default NULL,
> ban_start int(32) default NULL,
> ban_end int(50) default NULL,
> ban_time_type int(10) default NULL,
> PRIMARY KEY (ban_id),
> KEY ban_id (ban_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_banlist'
> --
>
>
>
> --
905a949,966
> -- Table structure for table 'nuke_catagories'
> --
>
> CREATE TABLE nuke_catagories (
> cat_id int(10) NOT NULL auto_increment,
> cat_title varchar(100) default NULL,
> cat_order varchar(10) default NULL,
> PRIMARY KEY (cat_id),
> KEY cat_id (cat_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_catagories'
> --
>
>
>
> --
1258,1259c1319,1320
< alias varchar(20) NOT NULL default '',
< color varchar(7) NOT NULL default '',
---
> alias char(20) NOT NULL default '',
> color char(7) NOT NULL default '',
1440a1502,1518
> -- Table structure for table 'nuke_disallow'
> --
>
> CREATE TABLE nuke_disallow (
> disallow_id int(10) NOT NULL auto_increment,
> disallow_username varchar(50) default NULL,
> PRIMARY KEY (disallow_id),
> KEY disallow_id (disallow_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_disallow'
> --
>
>
>
> --
1746a1825,1910
> -- Table structure for table 'nuke_forum_mods'
> --
>
> CREATE TABLE nuke_forum_mods (
> forum_id int(10) NOT NULL default '0',
> user_id int(10) NOT NULL default '0',
> KEY forum_id (forum_id),
> KEY user_id (user_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forum_mods'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forum_notifica'
> --
>
> CREATE TABLE nuke_forum_notifica (
> notifi_id int(11) NOT NULL auto_increment,
> topic_id int(11) NOT NULL default '0',
> username varchar(25) NOT NULL default '',
> PRIMARY KEY (notifi_id),
> KEY topic_id (topic_id,username)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forum_notifica'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forums'
> --
>
> CREATE TABLE nuke_forums (
> forum_id int(10) NOT NULL auto_increment,
> forum_name varchar(150) NOT NULL default '',
> forum_desc text,
> forum_access int(10) default '1',
> forum_moderator int(10) default NULL,
> cat_id int(10) default NULL,
> forum_type int(10) default '0',
> forum_pass varchar(60) default NULL,
> forum_notify_email varchar(30) default NULL,
> forum_atch int(2) NOT NULL default '0',
> forum_rules text,
> PRIMARY KEY (forum_id),
> KEY forum_id (forum_id),
> KEY forum_name (forum_name)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forums'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forumtopics'
> --
>
> CREATE TABLE nuke_forumtopics (
> topic_id int(10) NOT NULL auto_increment,
> topic_title varchar(100) default '',
> topic_poster int(10) default '0',
> topic_time varchar(20) default '',
> topic_views int(10) NOT NULL default '0',
> forum_id int(10) NOT NULL default '0',
> topic_status int(10) NOT NULL default '0',
> topic_notify int(2) default '0',
> PRIMARY KEY (topic_id),
> KEY topic_id (topic_id),
> KEY forum_id (forum_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forumtopics'
> --
>
>
>
> --
2289a2454,2496
> -- Table structure for table 'nuke_posts'
> --
>
> CREATE TABLE nuke_posts (
> post_id int(10) NOT NULL auto_increment,
> image varchar(100) default '',
> topic_id int(10) NOT NULL default '0',
> forum_id int(10) NOT NULL default '0',
> poster_id int(10) NOT NULL default '0',
> post_text text,
> post_time varchar(20) default '',
> poster_ip varchar(16) default '',
> PRIMARY KEY (post_id),
> KEY post_id (post_id),
> KEY topic_id (topic_id),
> KEY forum_id (forum_id),
> KEY poster_id (poster_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_posts'
> --
>
>
>
> --
> -- Table structure for table 'nuke_posts_text'
> --
>
> CREATE TABLE nuke_posts_text (
> post_id int(10) NOT NULL default '0',
> post_text text,
> PRIMARY KEY (post_id),
> KEY post_id (post_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_posts_text'
> --
>
>
>
> --
2377a2585,2606
> -- Table structure for table 'nuke_ranks'
> --
>
> CREATE TABLE nuke_ranks (
> rank_id int(10) NOT NULL auto_increment,
> rank_title varchar(50) NOT NULL default '',
> rank_min int(10) NOT NULL default '0',
> rank_max int(10) NOT NULL default '0',
> rank_special int(2) default '0',
> rank_image varchar(255) default NULL,
> PRIMARY KEY (rank_id),
> KEY rank_min (rank_min),
> KEY rank_max (rank_max)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_ranks'
> --
>
>
>
> --
2564a2794,2844
> -- Table structure for table 'nuke_smiles'
> --
>
> CREATE TABLE nuke_smiles (
> id int(10) NOT NULL auto_increment,
> code varchar(50) default NULL,
> smile_url varchar(100) default NULL,
> emotion varchar(75) default NULL,
> active tinyint(2) default '0',
> PRIMARY KEY (id),
> KEY id (id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_smiles'
> --
>
>
> INSERT INTO nuke_smiles VALUES (1,':D','icon_biggrin.gif','Very Happy',0);
> INSERT INTO nuke_smiles VALUES (2,':-D','icon_biggrin.gif','Very Happy',1);
> INSERT INTO nuke_smiles VALUES (3,':grin:','icon_biggrin.gif','Very Happy',0);
> INSERT INTO nuke_smiles VALUES (4,':)','icon_smile.gif','Smile',0);
> INSERT INTO nuke_smiles VALUES (5,':-)','icon_smile.gif','Smile',1);
> INSERT INTO nuke_smiles VALUES (6,':smile:','icon_smile.gif','Smile',0);
> INSERT INTO nuke_smiles VALUES (7,':(','icon_frown.gif','Sad',0);
> INSERT INTO nuke_smiles VALUES (8,':-(','icon_frown.gif','Sad',1);
> INSERT INTO nuke_smiles VALUES (9,':sad:','icon_frown.gif','Sad',0);
> INSERT INTO nuke_smiles VALUES (10,':o','icon_eek.gif','Surprised',0);
> INSERT INTO nuke_smiles VALUES (11,':-o','icon_eek.gif','Surprised',1);
> INSERT INTO nuke_smiles VALUES (12,':eek:','icon_eek.gif','Suprised',0);
> INSERT INTO nuke_smiles VALUES (13,':-?','icon_confused.gif','Confused',1);
> INSERT INTO nuke_smiles VALUES (14,':???:','icon_confused.gif','Confused',0);
> INSERT INTO nuke_smiles VALUES (15,'8)','icon_cool.gif','Cool',0);
> INSERT INTO nuke_smiles VALUES (16,'8-)','icon_cool.gif','Cool',1);
> INSERT INTO nuke_smiles VALUES (17,':cool:','icon_cool.gif','Cool',0);
> INSERT INTO nuke_smiles VALUES (18,':lol:','icon_lol.gif','Laughing',1);
> INSERT INTO nuke_smiles VALUES (19,':x','icon_mad.gif','Mad',0);
> INSERT INTO nuke_smiles VALUES (20,':-x','icon_mad.gif','Mad',1);
> INSERT INTO nuke_smiles VALUES (21,':mad:','icon_mad.gif','Mad',0);
> INSERT INTO nuke_smiles VALUES (22,':P','icon_razz.gif','Razz',0);
> INSERT INTO nuke_smiles VALUES (23,':-P','icon_razz.gif','Razz',1);
> INSERT INTO nuke_smiles VALUES (24,':razz:','icon_razz.gif','Razz',0);
> INSERT INTO nuke_smiles VALUES (25,':oops:','icon_redface.gif','Embaressed',1);
> INSERT INTO nuke_smiles VALUES (26,':cry:','icon_cry.gif','Crying (very sad)',1);
> INSERT INTO nuke_smiles VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad',1);
> INSERT INTO nuke_smiles VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes',1);
> INSERT INTO nuke_smiles VALUES (29,':wink:','icon_wink.gif','Wink',0);
> INSERT INTO nuke_smiles VALUES (30,';)','icon_wink.gif','Wink',0);
> INSERT INTO nuke_smiles VALUES (31,';-)','icon_wink.gif','Wink',1);
>
> --
2709c2989
< user_id int(11) NOT NULL auto_increment,
---
> uid int(11) NOT NULL auto_increment,
2711,2712c2991,2992
< username varchar(25) NOT NULL default '',
< user_email varchar(255) NOT NULL default '',
---
> uname varchar(25) NOT NULL default '',
> email varchar(255) NOT NULL default '',
2714c2994
< user_website varchar(255) NOT NULL default '',
---
> url varchar(255) NOT NULL default '',
2720c3000
< user_interests varchar(150) NOT NULL default '',
---
> user_intrest varchar(150) default NULL,
2727c3007
< user_password varchar(40) NOT NULL default '',
---
> pass varchar(40) NOT NULL default '',
2771,2773c3051,3053
< PRIMARY KEY (user_id),
< KEY uid (user_id),
< KEY uname (username),
---
> PRIMARY KEY (uid),
> KEY uid (uid),
> KEY uname (uname),
2782a3063,3096
>
> --
> -- Table structure for table 'nuke_usersettings'
> --
>
> CREATE TABLE nuke_usersettings (
> user_id bigint(20) unsigned NOT NULL default '0',
> chat_color varchar(7) NOT NULL default '',
> PRIMARY KEY (user_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_usersettings'
> --
>
>
>
> --
> -- Table structure for table 'nuke_words'
> --
>
> CREATE TABLE nuke_words (
> word_id int(10) NOT NULL auto_increment,
> word varchar(100) default NULL,
> replacement varchar(100) default NULL,
> PRIMARY KEY (word_id),
> KEY word_id (word_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_words'
> --
>
>
Posted on Thursday, January 23 @ 23:51:21 CET by Zhen-Xjell
 
Related Links
· More about PHP-Nuke
· News by Zhen-Xjell


Most read story about PHP-Nuke:
PHP-Nuke new development direction (part 2)

Article Rating
Average Score: 4.33
Votes: 6


Please take a second and vote for this article:

Excellent
Very Good
Good
Regular
Bad


Options

 Printer Friendly Page  Printer Friendly Page

 Send to a Friend  Send to a Friend

Threshold
The comments are owned by the poster. We aren't responsible for their content.

No Comments Allowed for Anonymous, please register

Re: Difference between 6.5b5 and 6.5b6 & Upgrade Script (Score: 1)
by Zhen-Xjell on Friday, January 24 @ 00:11:01 CET
(User Info | Send a Message) http://castlecops.com
Thanks to ArtificialIntel, a download of the upgrade script is available here: click me.



Re: Difference between 6.5b5 and 6.5b6 & Upgrade Script (Score: 1)
by spapoops on Friday, January 24 @ 08:29:18 CET
(User Info | Send a Message) http://www.spapoops.com
Outstanding job and much appreciated!

Where do we send donations :)

Bryan Horton


  • Re: by Anonymous on Friday, January 24 @ 10:51:37 CET
    • Re: by Zhen-Xjell on Friday, January 24 @ 11:55:54 CET
  • Re: by Anonymous on Friday, January 24 @ 10:52:21 CET
  • Re: by Zhen-Xjell on Friday, January 24 @ 11:56:45 CET
    • Re: by Anonymous on Friday, January 24 @ 12:19:09 CET
      • Re: by Zhen-Xjell on Friday, January 24 @ 12:21:42 CET
        • Re: by spapoops on Friday, January 24 @ 12:46:38 CET
          • Re: by Zhen-Xjell on Friday, January 24 @ 13:11:08 CET

Re: Difference between 6.5b5 and 6.5b6 & Upgrade Script (Score: 0)
by Anonymous on Friday, January 24 @ 10:53:04 CET
are those tables removed because of the fourm being removed?



Re: Difference between 6.5b5 and 6.5b6 & Upgrade Script (Score: 1)
by spapoops on Friday, January 24 @ 11:00:24 CET
(User Info | Send a Message) http://www.spapoops.com
The upgrade.sql work flawlessly!

I added the following from this Board (Bug Fixes)...

6.5 block-User_Info.php PM Fix
Surveys doesn't save votes (Beta 6) fix by FB
Avatar Display error in Nuke 6.5 beta 6
FAQ category gets wiped out when editing it

But found the post
Another Bug in your account from beta 6
on PHP-Nuke Bug Fix board did not work for me
I backed this "fix" out and all was well

Bryan


Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.106 Seconds - 201 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::