Webwereld

.sql werkt niet

Gestart doorMilan19 reacties213 weergaven
Log in om mee te praten

20 berichten · pagina 2 van 2

Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
doe dit eens:

CREATE TABLE `AtackLog` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default 0,
  `toUserID` int(11) NOT NULL default 0,
  `atackTurns` int(11) NOT NULL default 0,
  `atackStrength` int(11) NOT NULL default 0,
  `defStrength` int(11) NOT NULL default 0,
  `gold` int(11) NOT NULL default 0,
  `phrase` varchar(255) NOT NULL default ,
  `atackUsersKilled` int(11) NOT NULL default 0,
  `defUsersKilled` int(11) NOT NULL default 0,
  `atackTrained` int(11) NOT NULL default 0,
  `atackUnTrained` int(11) NOT NULL default 0,
  `defTrained` int(11) NOT NULL default 0,
  `defUnTrained` int(11) NOT NULL default 0,
  `atackWeapons` varchar(255) NOT NULL default ,
  `defWeapons` varchar(255) NOT NULL default ,
  `atackWeaponWas` varchar(255) NOT NULL default ,
  `atackWeaponIs` varchar(255) NOT NULL default ,
  `time` int(11) NOT NULL default 0,
  `atackWeaponCount` varchar(255) NOT NULL default ,
  `defWeaponWas` varchar(255) NOT NULL default ,
  `defWeaponIs` varchar(255) NOT NULL default ,
  `defWeaponCount` varchar(255) NOT NULL default ,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=63 ;

CREATE TABLE `IPs` (
  `ID` int(11) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL default ,
  `userID` int(11) NOT NULL default 0,
  `time` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

INSERT INTO `IPs` (`ID`, `ip`, `userID`, `time`) VALUES (1, 67.67.147.81, 0, 1083710034),
(2, 194.146.134.4, 0, 1083709874),
(3, 67.67.147.81, 41, 1083711236),
(4, 67.67.147.81, 42, 1083711472),
(5, 67.67.147.81, 43, 1083711525),
(6, 67.67.147.81, 44, 1083711607),
(7, 24.55.128.133, 45, 1083764140),
(8, 24.55.128.133, 46, 1083764260),
(9, 66.139.248.248, 20, 1083987485),
(10, 66.139.248.248, 27, 1083987507),
(11, 66.139.248.248, 28, 1083987541),
(12, 194.146.134.4, 25, 1083987609),
(13, 194.146.134.4, 28, 1083987786);

CREATE TABLE `Mercenaries` (
  `attackSpecCount` int(11) NOT NULL default 0,
  `defSpecCount` int(11) NOT NULL default 0,
  `untrainedCount` int(11) NOT NULL default 0,
  `lastTurnTime` int(11) NOT NULL default 0
) TYPE=MyISAM;

INSERT INTO `Mercenaries` (`attackSpecCount`, `defSpecCount`, `untrainedCount`, `lastTurnTime`) VALUES (215, 215, 215, 1083963719);

CREATE TABLE `Messages` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default 0,
  `fromID` int(11) NOT NULL default 0,
  `subject` varchar(255) NOT NULL default ,
  `text` text NOT NULL,
  `date` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

CREATE TABLE `Ranks` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default 0,
  `rank` int(11) NOT NULL default 0,
  `strikeActionRank` int(11) NOT NULL default 0,
  `defenceActionRank` int(11) NOT NULL default 0,
  `covertActionRank` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

INSERT INTO `Ranks` (`ID`, `userID`, `rank`, `strikeActionRank`, `defenceActionRank`, `covertActionRank`) VALUES (11, 20, 3, 4, 3, 2),
(35, 44, 0, 0, 0, 0),
(15, 24, 0, 0, 0, 0),
(16, 25, 0, 0, 0, 0),
(18, 27, 5, 5, 5, 1),
(17, 26, 2, 2, 2, 4),
(19, 28, 4, 3, 4, 3),
(37, 46, 6, 6, 6, 6),
(34, 43, 0, 0, 0, 0),
(33, 42, 0, 0, 0, 0),
(32, 41, 0, 0, 0, 0);

CREATE TABLE `SpyLog` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default 0,
  `toUserID` int(11) NOT NULL default 0,
  `spyStrength` int(11) NOT NULL default 0,
  `spyDefStrength` int(11) NOT NULL default 0,
  `trainedAttackSold` varchar(15) NOT NULL default ,
  `trainedAttackMerc` varchar(15) NOT NULL default ,
  `trainedDefSold` varchar(15) NOT NULL default ,
  `trainedDefMerc` varchar(15) NOT NULL default ,
  `untrainedMerc` varchar(15) NOT NULL default ,
  `untrainedSold` varchar(15) NOT NULL default ,
  `strikeAction` varchar(15) NOT NULL default ,
  `defenceAction` varchar(15) NOT NULL default ,
  `covertSkill` varchar(15) NOT NULL default ,
  `covertOperatives` varchar(15) NOT NULL default ,
  `siegeLevel` varchar(15) NOT NULL default ,
  `atackTurns` varchar(15) NOT NULL default ,
  `unitProduction` varchar(15) NOT NULL default ,
  `weapons` varchar(255) NOT NULL default ,
  `types` varchar(255) NOT NULL default ,
  `types2` varchar(255) NOT NULL default ,
  `quantities` varchar(255) NOT NULL default ,
  `strengths` varchar(255) NOT NULL default ,
  `allStrengths` varchar(255) NOT NULL default ,
  `time` int(11) NOT NULL default 0,
  `spies` int(11) NOT NULL default 0,
  `isSuccess` tinyint(1) NOT NULL default 0,
  `race` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

CREATE TABLE `UserDetails` (
  `ID` int(11) NOT NULL auto_increment,
  `userName` varchar(100) NOT NULL default ,
  `race` tinyint(4) NOT NULL default 0,
  `e_mail` varchar(255) NOT NULL default ,
  `password` varchar(50) NOT NULL default ,
  `commander` int(11) NOT NULL default 0,
  `active` int(1) NOT NULL default 0,
  `uniqueLink` varchar(12) NOT NULL default ,
  `fortificationLevel` int(11) NOT NULL default 0,
  `siegeLevel` int(11) NOT NULL default 0,
  `gold` int(11) NOT NULL default 0,
  `attackTurns` int(11) NOT NULL default 0,
  `currentUnitProduction` int(11) default NULL,
  `currentSpySkill` int(11) default NULL,
  `trainedAttackSold` int(11) default NULL,
  `trainedAttackMerc` int(11) default NULL,
  `trainedDefSold` int(11) default NULL,
  `trainedDefMerc` int(11) default NULL,
  `untrainedSold` float default NULL,
  `untrainedMerc` int(11) default NULL,
  `spies` int(11) default NULL,
  `lastTurnTime` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

INSERT INTO `UserDetails` (`ID`, `userName`, `race`, `e_mail`, `password`, `commander`, `active`, `uniqueLink`, `fortificationLevel`, `siegeLevel`, `gold`, `attackTurns`, `currentUnitProduction`, `currentSpySkill`, `trainedAttackSold`, `trainedAttackMerc`, `trainedDefSold`, `trainedDefMerc`, `untrainedSold`, `untrainedMerc`, `spies`, `lastTurnTime`) VALUES (27, user13, 2, user13@email.ru, 1, 0, 1, uk4610829096, 1, 1, 2053218, 180, 24, 38, 21, 864, 490, 1831, 1580, 1049, 237, 1083987525),
(28, user5, 3, user14@email.ru, 1, 0, 1, uu3310829096, 3, 3, 1, 1, 80, 25, 1, 1, 1, 1, 1, 1, 223, 1083987973),
(44, xvxczcxddaa, 0, csmaster2005@hotmail.com, 32800635, 0, 0, sl1083711607, 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083711607),
(20, user6, 1, user6@email.ru, 1, 0, 1, yt2010829096, 1, 0, 7171076, 221, 55, 28, 1582, 1716, 719, 1084, 4264, 1365, 1237, 1089727410),
(46, jason, 0, webmaster@worldhatred.com, internet, 0, 1, ep1083764260, 0, 0, 3699, 46, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083764636),
(26, user12, 1, user12@email.ru, 1, 0, 1, ab6810829096, 3, 1, 9071948, 210, 91, 18, 1770, 912, 1850, 1959, 5651, 459, 808, 1090281246),
(25, user11, 1, user11@email.ru, 1, 0, 0, df8510829096, 2, 2, 83874, 98, 13, 0, 1670, 654, 1047, 979, 1273, 527, 207, 1083611939),
(24, user10, 2, user10@email.ru, 1, 0, 0, iu2421082909, 2, 2, 132483, 75, 92, 79, 1146, 1197, 1, 1881, 1998, 1881, 772, 1084659030),
(43, xvxczcxdd, 0, csmaster2005@hotmail.com, 40447503, 0, 0, ez1083711525, 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083711525),
(42, xvxczcx, 0, test@hotmail.com, 34349144, 0, 0, rg1083711472, 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083711472),
(41, sfdsfsfd, 2, myemail@hotmail.com, 33360663, 0, 0, ql1083711236, 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083711236),
(45, tsunami, 0, abuse@pimpkane.com, 65882608, 0, 0, pi1083764140, 0, 0, 806, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1083765813),
(48, admin, 0, admin@mail.com, 1, 0, 4, , 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

CREATE TABLE `Weapon` (
  `ID` int(11) NOT NULL auto_increment,
  `weaponID` int(11) NOT NULL default 0,
  `weaponStrength` int(11) NOT NULL default 0,
  `weaponCount` int(11) NOT NULL default 0,
  `isAtack` int(11) NOT NULL default 0,
  `userID` int(11) NOT NULL default 0,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

INSERT INTO `Weapon` (`ID`, `weaponID`, `weaponStrength`, `weaponCount`, `isAtack`, `userID`) VALUES (24, 0, 10, 1, 0, 45),
(23, 0, 5, 1, 1, 45);

CREATE TABLE `c_ban_users` (
  `username` varchar(30) NOT NULL default ,
  `latin1` tinyint(1) NOT NULL default 0,
  `ip` varchar(16) NOT NULL default ,
  `rooms` varchar(100) NOT NULL default ,
  `ban_until` int(11) NOT NULL default 0
) TYPE=MyISAM;

CREATE TABLE `c_messages` (
  `type` tinyint(1) NOT NULL default 0,
  `room` varchar(30) NOT NULL default ,
  `username` varchar(30) NOT NULL default ,
  `latin1` tinyint(1) NOT NULL default 0,
  `m_time` int(11) NOT NULL default 0,
  `address` varchar(30) NOT NULL default ,
  `message` text NOT NULL
) TYPE=MyISAM;

INSERT INTO `c_messages` (`type`, `room`, `username`, `latin1`, `m_time`, `address`, `message`) VALUES (1, Default, SYS enter, 0, 1080955692, , sprintf(L_ENTER_ROM, "vv")),
(1, Default, SYS welcome, 0, 1080956641, vv, sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")),
(1, Default, vv, 1, 1080955707, , <FONT COLOR="#000000">fuck</FONT>),
(1, Default, vv, 1, 1080955710, , <FONT COLOR="#000000">dfgdfg</FONT>),
(1, Default, vv, 1, 1080955715, , <FONT COLOR="#3ffc40">dsfsdf</FONT>),
(1, Default, vv, 1, 1080955718, , <FONT COLOR="#a503d3">sdfsdf</FONT>),
(1, Default, SYS enter, 0, 1080955950, , sprintf(L_ENTER_ROM, "rrrr")),
(1, Default, SYS welcome, 0, 1080955951, rrrr, sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")),
(1, Default, rrrr, 1, 1080955973, , <FONT COLOR="#000000">vv&gt; rrr</FONT>),
(1, Default, SYS enter, 0, 1080955995, , sprintf(L_ENTER_ROM, "ee")),
(1, Default, SYS welcome, 0, 1080956023, ee, sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")),
(1, Default, SYS exit, 0, 1080956012, , sprintf(L_EXIT_ROM, "ee")),
(1, MyRoom1, SYS enter, 0, 1080956012, , sprintf(L_ENTER_ROM, "ee")),
(1, MyRoom1, SYS exit, 0, 1080956016, , sprintf(L_EXIT_ROM, "ee")),
(1, MyRoom2, SYS enter, 0, 1080956017, , sprintf(L_ENTER_ROM, "ee")),
(1, MyRoom2, SYS exit, 0, 1080956022, , sprintf(L_EXIT_ROM, "ee")),
(1, Default, SYS enter, 0, 1080956022, , sprintf(L_ENTER_ROM, "ee")),
(1, Default, SYS enter, 0, 1080956640, , sprintf(L_ENTER_ROM, "vv")),
(1, Default, SYS enter, 0, 1080979836, , sprintf(L_ENTER_ROM, "iii")),
(1, Default, SYS welcome, 0, 1080979837, iii, sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")),
(1, Default, iii, 1, 1080979862, , <FONT COLOR="#000000">ghgfhg</FONT>);

CREATE TABLE `c_reg_users` (
  `username` varchar(30) NOT NULL default ,
  `latin1` tinyint(1) NOT NULL default 0,
  `password` varchar(32) NOT NULL default ,
  `firstname` varchar(64) NOT NULL default ,
  `lastname` varchar(64) NOT NULL default ,
  `country` varchar(64) NOT NULL default ,
  `website` varchar(64) NOT NULL default ,
  `email` varchar(64) NOT NULL default ,
  `showemail` tinyint(1) NOT NULL default 0,
  `perms` varchar(9) NOT NULL default ,
  `rooms` varchar(128) NOT NULL default ,
  `reg_time` int(11) NOT NULL default 0,
  `ip` varchar(16) NOT NULL default ,
  `gender` tinyint(1) NOT NULL default 0
) TYPE=MyISAM;

INSERT INTO `c_reg_users` (`username`, `latin1`, `password`, `firstname`, `lastname`, `country`, `website`, `email`, `showemail`, `perms`, `rooms`, `reg_time`, `ip`, `gender`) VALUES (admin, 0, 21232f297a57a5a743894a0e4a801fc3, , , , , , 0, admin, , 0, , 0),
(vv, 1, c4055e3a20b6b3af3d10590ea446ef6c, vv, vv, , , vv@vv.vv, 0, user, , 1080956640, 127.0.0.1, 0);

CREATE TABLE `c_users` (
  `room` varchar(30) NOT NULL default ,
  `username` varchar(30) NOT NULL default ,
  `latin1` tinyint(1) NOT NULL default 0,
  `u_time` int(11) NOT NULL default 0,
  `status` char(1) NOT NULL default ,
  `ip` varchar(16) NOT NULL default ,
  UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Lukt niet, krijg nog steeds een haakje tezien..
0
Erik

Lid

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Contact me op msn. biggrin
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Als ik goed inlog krijg ik weer deze error:

Warning: Cannot modify header information - headers already sent by (output started at /home/menatwar/domains/menatwar.one2xs.com/public_html/lib.php:363) in /home/menatwar/domains/menatwar.one2xs.com/public_html/vsys.php on line 53
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
je hebt al iets aan output gedaan voordat je de laatste header gedaan hebt ?
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren