Jump to content
GIGN Forum

[-pamaciba-]web-game


Dzests
 Share

Recommended Posts

Sakuma lejupladejam Appserv

ieinstalejam

Talak lejupladejam web-game skriptu

Ejam

C:\Appserv\www

izdzesam visu iznemot phpmyadmin

Lejupladeto skriptu arhivejam

C:\Appserv\www

Talak ejam SEIT ielogojamies un izveidojam datubazi.

Talak ejam

C:\AppServ\www\includes

un atveram ar notepad , connect.php , ejam uz 7 linijas un redigejam SQL Kategorija jaizskatas apmeram sadi

define('DB_NAME', 'web-game');

Talak ejam uz 8 liniju un redigejam

$conn=mysql_connect('localhost', 'root', 'Tava parole') or die("<table align=center width=400 style='border:1px solid black;' height=200><tr><td align=center><b>Mini Combats error , please contact support by email: <font color=red>info {at} wos.lv</font> :</b> ".mysql_error()."</td></tr></table>");

"Tava parole" vieta rakstam jusu Appserv paroli

Talak atliek tikai uzinstalet datubazi.

ejam SEIT ielogojamies panemam jusu izveidoto datubazi talak spiezam uz SQL un ievadam sekojoso kodu :

# ------------------------------------------------------
# Server version 4.0.23-nt

#
# Table structure for table admin
#

CREATE TABLE `admin` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(16) default NULL,
  `pass` varchar(100) default NULL,
  `admin_level` tinyint(1) default '1',
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

#
# Dumping data for table admin
#

INSERT INTO `admin` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e',1);

#
# Table structure for table arena
#

CREATE TABLE `arena` (
  `nick` varchar(16) default NULL,
  `whom` varchar(16) default 'n',
  `priv` char(1) default 'n',
  `send_text` varchar(255) default NULL,
  `koly` int(11) default NULL
) TYPE=MyISAM;

#
# Dumping data for table arena
#


#
# Table structure for table banned
#

CREATE TABLE `banned` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `uid` tinyint(6) unsigned NOT NULL default '1',
  `toTime` int(11) NOT NULL default '0',
  `btype` tinyint(1) NOT NULL default '0',
  `reason` varchar(100) NOT NULL default 'Bad conduct',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table banned
#


#
# Table structure for table fapply
#

CREATE TABLE `fapply` (
  `fid` int(6) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table fapply
#


#
# Table structure for table fendput
#

CREATE TABLE `fendput` (
  `uid` int(10) default NULL,
  `fightes` smallint(5) default '0',
  `wins` smallint(5) default '0',
  `looses` smallint(5) default '0',
  `many` int(11) default '0',
  `points` tinyint(5) unsigned default '0'
) TYPE=MyISAM;

#
# Dumping data for table fendput
#

INSERT INTO `fendput` VALUES (3,2,1,1,10,13);
INSERT INTO `fendput` VALUES (4,2,1,1,4,10);

#
# Table structure for table fhistory
#

CREATE TABLE `fhistory` (
  `fid` int(5) default NULL,
  `hnom` tinyint(3) default NULL,
  `fhid` text
) TYPE=MyISAM;

#
# Dumping data for table fhistory
#


#
# Table structure for table fhistoryall
#

CREATE TABLE `fhistoryall` (
  `id` int(10) unsigned NOT NULL default '0',
  `history` text
) TYPE=MyISAM;

#
# Dumping data for table fhistoryall
#

INSERT INTO `fhistoryall` VALUES (6,'');
INSERT INTO `fhistoryall` VALUES (7,'2*3 1.0 4 2 4\n4 0.0 3 2\n|1*3 1.0 4 2 5\n4 0.0 3 1\n|');
INSERT INTO `fhistoryall` VALUES (8,'3*3 1.2 4 2 5\n4 1.0 3 3 3\n|2*3 1.0 4 1 4\n4 1.0 3 2 3\n|1*3 1.0 4 3 5\n4 1.1 3 1 3\n|');

#
# Table structure for table fight
#

CREATE TABLE `fight` (
  `fid` int(5) unsigned NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `flife` tinyint(4) unsigned NOT NULL default '0',
  `fstrong` tinyint(4) unsigned NOT NULL default '0',
  `flike` tinyint(4) unsigned NOT NULL default '0',
  `fattack` tinyint(4) NOT NULL default '0',
  `fdefence` tinyint(4) unsigned NOT NULL default '0',
  `fspeed` tinyint(4) unsigned NOT NULL default '0',
  `foglush` tinyint(4) unsigned NOT NULL default '0',
  `frezh` tinyint(4) unsigned NOT NULL default '0',
  `biy` tinyint(1) unsigned NOT NULL default '0',
  `timeevent` int(11) unsigned NOT NULL default '0',
  `anamy` int(10) NOT NULL default '0',
  `hid11` tinyint(1) NOT NULL default '1',
  `hid12` tinyint(1) unsigned NOT NULL default '1',
  `hid2` tinyint(1) NOT NULL default '0',
  `fdroplife` tinyint(4) NOT NULL default '0',
  `fhistory` tinyint(1) unsigned NOT NULL default '0',
  `fpoints` tinyint(4) NOT NULL default '0',
  `fcom` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table fight
#

INSERT INTO `fight` VALUES (8,3,1,4,2,2,1,1,1,3,2,1120131410,4,2,2,0,0,0,14,0);
INSERT INTO `fight` VALUES (8,4,0,4,2,1,2,1,1,1,2,1120131410,3,1,3,1,0,0,9,0);

#
# Table structure for table flogs
#

CREATE TABLE `flogs` (
  `id` int(10) unsigned NOT NULL default '0',
  `flist` text,
  `fn` tinyint(2) default NULL,
  `manyup` tinyint(4) default NULL,
  `fcom` tinyint(2) default NULL,
  `timebegin` int(11) unsigned default NULL
) TYPE=MyISAM;

#
# Dumping data for table flogs
#


#
# Table structure for table flogsall
#

CREATE TABLE `flogsall` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fid` int(6) default NULL,
  `fstart` int(11) default '0',
  `fend` int(11) default '0',
  `plist` text,
  `winners` varchar(140) default NULL,
  `points` varchar(140) default NULL,
  `manyup` smallint(4) default '0',
  `fstatus` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table flogsall
#

INSERT INTO `flogsall` VALUES (1,6,1120119681,1120119864,'3\n4','4','10',3,1);
INSERT INTO `flogsall` VALUES (2,7,1120120762,1120121046,'3\n4','3','13',0,1);
INSERT INTO `flogsall` VALUES (3,8,1120131348,1120131410,'3\n4','3','14',0,1);

#
# Table structure for table fpropouse
#

CREATE TABLE `fpropouse` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `manyup` tinyint(4) unsigned NOT NULL default '0',
  `timepropouse` int(11) unsigned NOT NULL default '0',
  `flevel` tinyint(4) unsigned NOT NULL default '0',
  `fn` tinyint(4) NOT NULL default '0',
  `fm` tinyint(4) NOT NULL default '0',
  `fzbr` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM;

#
# Dumping data for table fpropouse
#


#
# Table structure for table garderob
#

CREATE TABLE `garderob` (
  `uid` int(10) default NULL,
  `slot1` tinyint(6) unsigned NOT NULL default '1',
  `slot2` tinyint(6) unsigned NOT NULL default '1',
  `slot3` tinyint(6) unsigned NOT NULL default '1',
  `slot4` tinyint(6) unsigned NOT NULL default '1',
  `slot5` tinyint(6) unsigned NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table garderob
#

INSERT INTO `garderob` VALUES (3,1,1,1,1,1);
INSERT INTO `garderob` VALUES (4,1,1,1,1,1);

#
# Table structure for table hospital
#

CREATE TABLE `hospital` (
  `uid` int(6) unsigned NOT NULL default '0',
  `rtype` tinyint(1) NOT NULL default '0',
  `timebegin` int(11) unsigned NOT NULL default '0',
  `timelen` smallint(6) unsigned NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table hospital
#

INSERT INTO `hospital` VALUES (3,2,1120131480,0);
INSERT INTO `hospital` VALUES (4,0,1120131444,240);

#
# Table structure for table inform
#

CREATE TABLE `inform` (
  `uid` int(10) NOT NULL auto_increment,
  `nick` varchar(16) NOT NULL default '',
  `passw` varchar(100) default NULL,
  `sex` char(1) default NULL,
  `rdata` int(11) default NULL,
  `ip` varchar(16) default NULL,
  `mail` char(1) default NULL,
  `rasa` char(1) default NULL,
  `moder` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;








CREATE TABLE `ochka` (
  `uid` int(10) NOT NULL default '0',
  `many` int(5) NOT NULL default '10',
  `points` smallint(5) unsigned NOT NULL default '0',
  `cpoints` tinyint(4) unsigned NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table ochka
#

INSERT INTO `ochka` VALUES (3,15,50,0);
INSERT INTO `ochka` VALUES (4,4,10,0);

#
# Table structure for table params
#

CREATE TABLE `params` (
  `uid` int(10) unsigned default NULL,
  `lifemax` tinyint(3) default '10',
  `life` smallint(3) unsigned default '10',
  `strong` smallint(3) unsigned NOT NULL default '3',
  `udacha` smallint(3) unsigned default '1',
  `attack` tinyint(3) NOT NULL default '1',
  `defence` smallint(3) unsigned default '1',
  `speed` smallint(3) unsigned default '1',
  `oglush` smallint(3) unsigned default '1',
  `rezh` smallint(3) unsigned default '1',
  `ulevel` tinyint(3) default '1'
) TYPE=MyISAM;

#
# Dumping data for table params
#

INSERT INTO `params` VALUES (3,14,14,3,2,1,1,1,1,1,2);
INSERT INTO `params` VALUES (4,10,2,3,1,1,1,1,1,1,1);

#
# Table structure for table plist
#

CREATE TABLE `plist` (
  `uid` int(10) default NULL,
  `nick` varchar(16) default NULL,
  `timeevent` int(11) unsigned default NULL,
  `place` tinyint(2) default NULL
) TYPE=MyISAM;

#
# Dumping data for table plist
#


#
# Table structure for table rechi
#

CREATE TABLE `rechi` (
  `uid` int(10) unsigned NOT NULL default '0',
  `slot1` tinyint(6) unsigned NOT NULL default '1',
  `slot2` tinyint(6) unsigned NOT NULL default '1',
  `slot3` tinyint(6) unsigned NOT NULL default '1',
  `slot4` tinyint(6) unsigned NOT NULL default '1',
  `slot5` tinyint(6) unsigned NOT NULL default '1',
  `slot6` tinyint(6) unsigned NOT NULL default '1',
  `slot7` tinyint(6) unsigned NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table rechi
#

INSERT INTO `rechi` VALUES (3,2,1,1,1,1,1,1);
INSERT INTO `rechi` VALUES (4,22,1,1,1,26,1,1);

#
# Table structure for table rechi_a
#

CREATE TABLE `rechi_a` (
  `uid` int(10) unsigned NOT NULL default '0',
  `slot1` tinyint(6) unsigned NOT NULL default '1',
  `last_use` int(11) default '0'
) TYPE=MyISAM;

#
# Dumping data for table rechi_a
#

INSERT INTO `rechi_a` VALUES (3,1,0);
INSERT INTO `rechi_a` VALUES (4,1,0);

#
# Table structure for table rechi_m
#

CREATE TABLE `rechi_m` (
  `uid` int(10) unsigned NOT NULL default '0',
  `slot1` tinyint(6) unsigned NOT NULL default '1',
  `slot2` tinyint(4) unsigned NOT NULL default '1',
  `slot3` tinyint(4) unsigned NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table rechi_m
#

INSERT INTO `rechi_m` VALUES (3,1,1,1);
INSERT INTO `rechi_m` VALUES (4,1,1,1);

#
# Table structure for table sp_guest_book
#

CREATE TABLE `sp_guest_book` (
  `uid` int(10) unsigned NOT NULL default '0',
  `mess_text` text,
  `mess_time` int(11) default NULL
) TYPE=MyISAM;

#
# Dumping data for table sp_guest_book
#


#
# Table structure for table statistika
#

CREATE TABLE `statistika` (
  `uid` int(10) default NULL,
  `fightes` smallint(5) unsigned default '0',
  `wins` smallint(5) unsigned default '0',
  `looses` smallint(5) unsigned default '0'
) TYPE=MyISAM;

#
# Dumping data for table statistika
#

INSERT INTO `statistika` VALUES (3,3,2,1);
INSERT INTO `statistika` VALUES (4,3,1,2);

#
# Table structure for table things
#

CREATE TABLE `things` (
  `thingid` smallint(6) NOT NULL auto_increment,
  `life` tinyint(3) unsigned NOT NULL default '0',
  `strong` tinyint(3) unsigned NOT NULL default '0',
  `udacha` tinyint(3) unsigned NOT NULL default '0',
  `attack` tinyint(3) NOT NULL default '0',
  `defence` tinyint(3) unsigned NOT NULL default '0',
  `speed` tinyint(3) unsigned NOT NULL default '0',
  `oglush` tinyint(3) unsigned NOT NULL default '0',
  `rezh` tinyint(3) unsigned NOT NULL default '0',
  `price` tinyint(4) unsigned NOT NULL default '1',
  `comment` varchar(20) NOT NULL default '-',
  `description` text NOT NULL,
  `thingtype` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`thingid`)
) TYPE=MyISAM;

#
# Dumping data for table things
#

INSERT INTO `things` VALUES (1,0,0,0,0,0,0,0,0,0,'empty','empty',0);
INSERT INTO `things` VALUES (2,0,1,1,1,0,0,0,2,6,'Nizh piroch','First description. First description. First description. First description. First description. First description. First description. First description. First description.',1);
INSERT INTO `things` VALUES (3,0,1,0,0,1,0,0,2,8,'Nizh kuhon','',1);
INSERT INTO `things` VALUES (4,0,4,1,0,0,3,0,5,18,'Nizh voen','a',1);
INSERT INTO `things` VALUES (5,0,2,0,0,2,2,3,0,10,'Palka','a',1);
INSERT INTO `things` VALUES (6,0,2,2,0,0,3,0,3,14,'Kinzhal','a',1);
INSERT INTO `things` VALUES (7,0,5,2,0,3,2,0,3,20,'Vyla','Verry good grabli.',1);
INSERT INTO `things` VALUES (8,0,2,2,0,0,0,2,0,10,'Pliashka Zhygulivsko','a',1);
INSERT INTO `things` VALUES (9,0,1,1,0,5,0,2,0,11,'Doska razdelochna','',2);
INSERT INTO `things` VALUES (10,1,0,1,0,1,0,0,0,5,'Plashka z mineralky','Laser for loosers.',1);
INSERT INTO `things` VALUES (11,0,0,1,0,5,0,0,0,8,'Shchyt z mineralky','a',2);
INSERT INTO `things` VALUES (12,0,3,1,0,2,2,3,3,18,'Lopata','a',1);
INSERT INTO `things` VALUES (13,0,0,0,0,8,0,2,0,10,'Kryshka z kastruli','a',2);
INSERT INTO `things` VALUES (14,0,2,0,0,2,0,2,0,8,'Skovorodka','a',1);
INSERT INTO `things` VALUES (15,0,0,0,0,2,0,0,0,1,'Vidro zalizne','Стойкое к внешним воздействиям, ведро из железа незаменимо в ближнем бою.',3);
INSERT INTO `things` VALUES (16,0,0,0,0,0,0,0,0,1,'Vidro zalizne','a',3);
INSERT INTO `things` VALUES (17,0,3,0,0,2,0,3,0,11,'Taburetka','a',1);
INSERT INTO `things` VALUES (18,0,3,1,0,3,1,3,2,17,'Grabli sadovi','a',1);
INSERT INTO `things` VALUES (19,1,0,1,0,2,2,0,0,8,'Pistolet na vodi','a',1);
INSERT INTO `things` VALUES (20,0,0,0,0,0,0,0,0,1,'Shapka ushanka','a',3);
INSERT INTO `things` VALUES (21,2,0,0,0,5,2,0,0,11,'Shapka oficera','a',3);
INSERT INTO `things` VALUES (22,0,1,1,0,1,0,0,0,5,'Vinyk','a',1);
INSERT INTO `things` VALUES (23,0,0,0,0,0,0,0,0,1,'Noski','a',6);
INSERT INTO `things` VALUES (24,2,1,2,0,0,0,0,0,8,'Ubor indeyca','a',3);
INSERT INTO `things` VALUES (25,0,0,0,0,0,0,0,0,1,'Valianki','a',6);
INSERT INTO `things` VALUES (26,0,0,0,0,0,0,0,0,1,'Shorty mini','a',5);
INSERT INTO `things` VALUES (27,0,0,0,0,0,0,0,0,1,'Trusy','a',5);
INSERT INTO `things` VALUES (28,0,0,0,0,0,0,0,0,1,'Galoshy','a',6);
INSERT INTO `things` VALUES (29,0,0,0,0,0,0,0,0,1,'Cheshki','a',6);
INSERT INTO `things` VALUES (30,0,0,0,0,0,0,0,0,1,'Sandali detski','a',6);
INSERT INTO `things` VALUES (31,0,0,0,0,0,0,0,0,1,'Vyetnamki','a',6);
INSERT INTO `things` VALUES (32,0,0,0,0,0,0,0,0,1,'Kovzany','a',6);
INSERT INTO `things` VALUES (33,0,0,0,0,0,0,0,0,1,'Lyzhy','a',6);
INSERT INTO `things` VALUES (34,10,0,0,0,0,0,0,0,1,'Life micsture','Add life in fight.',7);
INSERT INTO `things` VALUES (35,0,5,0,0,0,0,0,0,1,'Strong micsture','Very good',7);
INSERT INTO `things` VALUES (36,0,2,1,1,1,0,0,0,8,'Лезвие','Лезвие от бритвы. Основное преимущество этого оружия - внезапность. Когда враг не ожидает никаких сюрпризов можно быстро достать лезвие из потайного кармана и нанести серьезные ранения.',1);

Talak parbaudam vai strada : SEIT

Admina panelis : SEIT niks admin , pass 123456

Tas ari viss.

Bye Bye

combat.rar

Pamacibu rakstija TopGun

Ja kaut kas nesanak , rakstat uz skype : frager90

Bye Bye

Edited by Dzests
Link to comment
Share on other sites

  • 1 month later...

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...