Jump to content
MakeWebGames

Recommended Posts

  • 8 months later...
Posted

Yeah just downloaded to have a nosy, and they say MCCodes user table is flooded? Jeez....

On logging in I get just over a page worth of errors, all linked to functions file. Maybe its just my server that hates it, I dunno... it's almost 3am, I'll take a closer inspection in the morning.

Posted

How's mine?

 

CREATE TABLE `users` (
 `userID` int(11) NOT NULL AUTO_INCREMENT,
 `userName` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `userPass` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `userRank` int(1) NOT NULL DEFAULT '0',
 `userEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `userRef` int(11) NOT NULL DEFAULT '0',
 `userRefs` int(5) NOT NULL DEFAULT '0',
 `userLogins` int(5) NOT NULL DEFAULT '0',
 `userLastIP` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `userRegDate` int(13) NOT NULL DEFAULT '0',
 `userActCode` int(5) NOT NULL DEFAULT '0',
 `userLastActive` int(12) NOT NULL DEFAULT '0',
 `userLocation` int(11) NOT NULL DEFAULT '0',
 `userGender` enum('Male','Female') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Male',
 `userCredits` int(10) NOT NULL DEFAULT '0',
 `userCharSel` int(10) NOT NULL DEFAULT '0',
 `userPartySel` int(10) NOT NULL DEFAULT '0',
 `userTheme` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 PRIMARY KEY (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE `chars` (
 `charID` int(11) NOT NULL AUTO_INCREMENT,
 `charUserID` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `charPartyID` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `charDunID` int(11) NOT NULL DEFAULT '0',
 `charDunMapID` int(11) NOT NULL DEFAULT '0',
 `charName` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 `charStr` int(5) NOT NULL DEFAULT '0',
 `charInt` int(5) NOT NULL DEFAULT '0',
 `charDex` int(5) NOT NULL DEFAULT '0',
 `charConst` int(5) NOT NULL DEFAULT '0',
 `charLabour` int(5) NOT NULL DEFAULT '0',
 `charHP` int(5) NOT NULL DEFAULT '0',
 `charMP` int(5) NOT NULL DEFAULT '0',
 `charHunting` int(2) NOT NULL DEFAULT '10',
 `charFishing` int(2) NOT NULL DEFAULT '10',
 `charMining` int(2) NOT NULL DEFAULT '10',
 `charWoodCut` int(2) NOT NULL DEFAULT '10',
 `charFarming` int(2) NOT NULL DEFAULT '10',
 `charAlchemy` int(2) NOT NULL DEFAULT '10',
 `charHerbalism` int(2) NOT NULL DEFAULT '10',
 `charCrafting` int(2) NOT NULL DEFAULT '10',
 `charMaxStr` int(5) NOT NULL DEFAULT '0',
 `charMaxInt` int(5) NOT NULL DEFAULT '0',
 `charMaxDex` int(5) NOT NULL DEFAULT '0',
 `charMaxConst` int(5) NOT NULL DEFAULT '0',
 `charMaxLabour` int(5) NOT NULL DEFAULT '0',
 `charMaxHP` int(5) NOT NULL DEFAULT '0',
 `charMaxMP` int(5) NOT NULL DEFAULT '0',
 `charMaxHunting` int(2) NOT NULL DEFAULT '10',
 `charMaxFishing` int(2) NOT NULL DEFAULT '10',
 `charMaxMining` int(2) NOT NULL DEFAULT '10',
 `charMaxWoodCut` int(2) NOT NULL DEFAULT '10',
 `charMaxFarming` int(2) NOT NULL DEFAULT '10',
 `charMaxAlchemy` int(2) NOT NULL DEFAULT '10',
 `charMaxHerbalism` int(2) NOT NULL DEFAULT '10',
 `charMaxCrafting` int(2) NOT NULL DEFAULT '10',
 PRIMARY KEY (`charID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...