View Single Post
grof
Member
Join Date: Jun 2017
Old 12-25-2017 , 14:16   Re: amx_match_deluxe
Reply With Quote #3

Quote:
Originally Posted by blood2k View Post
AMX_MATCH_DELUXE.SQL needs to be imported into your database that you're using and it will create those tables for you.

Go into your phpmyadmin for that database and IMPORT ---> AMX_MATCH_DELUXE.SQL

it will create those tables for u.
I SEE THIS EROR ON MYPHPADMIN

Code:
Error
SQL query:


# MySQL file for AMXMD's Stats
# --------------------------------------------------------

#
# Table structure for table `amx_match_main`
#
# half1 = half1; half2 = half2; half3 = ot1; half4 = ot2
# map2: half5 = half1; half6 = half2; half7 = ot1; half8 = ot2
# --------------------------------------------------------
#

CREATE TABLE IF NOT EXISTS `amx_match_main` (
  `match_id` int(10) NOT NULL auto_increment,
  `map1_id` int(10) NOT NULL default '-1',
  `map2_id` int(10) NOT NULL default '-1',  
  `half1_id` int(10) NOT NULL default '-1',
  `half2_id` int(10) NOT NULL default '-1',
  `half3_id` int(10) NOT NULL default '-1',
  `half4_id` int(10) NOT NULL default '-1',
  `half5_id` int(10) NOT NULL default '-1',
  `half6_id` int(10) NOT NULL default '-1',
  `half7_id` int(10) NOT NULL default '-1',
  `half8_id` int(10) NOT NULL default '-1',
  PRIMARY KEY  (`match_id`)
) TYPE=MyISAM
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 25
grof is offline