![]() |
|
|||||||||
|
|||||||||
|
| Attention Visitor: |
| You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
||||||
| PHP DB Discutii despre lucrul cu baze de date in PHP. |
![]() |
|
|
Thread Tools | Moduri de afișare |
|
|
#1 |
|
32-Bit Member
|
salut, am procurat un joc MMORPG, totul merge perfect dar cand incerc sa accesez jocul imi da aceasta eroare.
![]() Nu am fisier text readme... am uploadat toate fisierele pe serverul de hosting (lx), inafara de sql (baza de date). Nu stiu sa o pun. :| COntinutul sql-ului: Cod HTML:
ÁÄ db1663b í? localhost # phpMyAdmin SQL Dump # version 2.5.3 # [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] # # ?î??: 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); # -------------------------------------------------------- Multumesc anticipat. PC Troubleshooting Last edited by gaby; 31.07.2008 at 15:24:24. |
|
|
|
| Sponsored Links |
|
|
#2 |
|
8-Bit Member
Data înregistrării: 14.06.2005
Mesaje: 6
Rep Power: 7 ![]() |
Ai phpMyAdmin instalat?
Daca da, intra in phpMyAdmin, selecteaza SQL si ruleaza cate o instructiune pe rand. Cod:
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); |
|
|
|
|
|
#3 |
|
32-Bit Member
Data înregistrării: 26.01.2007
Locație: Galati
Mesaje: 67
Rep Power: 6 ![]() |
vezi in mail-ul cu datele de la lx ca trebuie sa ai si info pt bazele de date. Unde le accesezi si cum le accesezi.
Dupa ce ai intrat in phpmyadmin de la lx te duci pe SQL si dai paste la codul tau apoi executa. Asta ar fi ordinea logica acum eu stiu daca o poti si executa...
__________________
The best from the best |
|
|
|
|
|
#4 |
|
Beat in post!
|
Post de pe 07-30-2007 ...
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Moduri de afișare | |
|
|