Webwereld

.sql werkt niet

Gestart doorMilan19 reacties213 weergaven
Log in om mee te praten

20 berichten · pagina 1 van 2

Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hey,

Mijn game www.menatwar.nl.tt moet morgen online, alleen heb ik problemen met de .sql. Als ik hem upload krijg ik dat er een "onbekend teken" in het systeem zit, hierdoor kan ik met een account niet inloggen en krijg ik bovenaan een wit > tezien.

Wie kan me helpen?

Groetjes,
Milan
0
Jort

Lid

Berichten
524
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Misschien is het handig als je je de SQL hier post.
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[No message]
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
En op welke regel geeft hij de error ?
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Ja, dat heb je met die Russische dingen he. emo..

Haal overal die À‘òÀ°óêòóÀ°À òÀ áëèöû eens weg.
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Er schijnt een fout te zitten in uw SQL-query. Mocht de MySQL-server een foutmelding hebben terug gegeven, probeer dan of u hiermee uw fout kunt oplossen.

ERROR: Ongeldig herkenningsteken @ 55
STR: 2.5.
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
haal regel 1 eens weg, of zet er een # voor...
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
# db1663b  localhost 
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# : localhost
#  :  08 2004 ., 08:15
#  : 4.0.16
#  PHP: 4.3.3
# 
#  : `db1663b`
# 

# --------------------------------------------------------

#
# `AtackLog`
#

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 ;

#
# `AtackLog`
#


# --------------------------------------------------------

#
# `IPs`
#

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 ;

#
# `IPs`
#

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);

# --------------------------------------------------------

#
# `Mercenaries`
#

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;

#
# `Mercenaries`
#

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

# --------------------------------------------------------

#
# `Messages`
#

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 ;

#
# `Messages`
#


# --------------------------------------------------------

#
# `Ranks`
#

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 ;

#
# `Ranks`
#

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);

# --------------------------------------------------------

#
# `SpyLog`
#

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 ;

#
# `SpyLog`
#


# --------------------------------------------------------

#
# `UserDetails`
#

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 ;

#
# `UserDetails`
#

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);

# --------------------------------------------------------

#
# `Weapon`
#

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 ;

#
# `Weapon`
#

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

# --------------------------------------------------------

#
# `c_ban_users`
#

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;

#
# `c_ban_users`
#


# --------------------------------------------------------

#
# `c_messages`
#

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;

#
# `c_messages`
#

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>);

# --------------------------------------------------------

#
# `c_reg_users`
#

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;

#
# `c_reg_users`
#

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);

# --------------------------------------------------------

#
# `c_users`
#

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;

#
# `c_users`
#


# --------------------------------------------------------
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
post eens je code zonder de tekens
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Nieuwe error:

ERROR: Onbekende Punctuatie String @ 68
STR: ://
SQL: #?? db1663b ?? localhost
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
haal de bovenste 18 regels eens weg en post dan eens de fout =d
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
SQL-query:

# # `AtackLog` # 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 [...]

MySQL retourneerde:

#1046 - No database selected
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
...

Wel een database aanklikken voor je de SQL invoert he. emo
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ja maar dan heb ik weer een fout op regel 55
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
*bump*

Het is nog steeds niet opgelost, kan iemand me helpen?
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