Jump to content
  • 0

can some teach me how to put sql in vps


minx123

Question


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  02/10/15
  • Last Seen:  

teach me how to use code to put inside sql?

//SQL Table for Ghost's PvP System
CREATE TABLE IF NOT EXISTS `pvp_rank` (
 `char_id` int(11) NOT NULL,
 `account_id` int(11) NOT NULL,
 `char` varchar(30) NOT NULL,
 `kill` int(11) NOT NULL,
 `death` int(11) NOT NULL,
 `kdr` varchar(30) NOT NULL,
 `killingstreak` int(11) NOT NULL,
 `multikill` int(11) NOT NULL,
 `killingspree` int(11) NOT NULL,
 `dominating` int(11) NOT NULL,
 `megakill` int(11) NOT NULL,
 `unstoppable` int(11) NOT NULL,
 `wickedsick` int(11) NOT NULL,
 `monsterkill` int(11) NOT NULL,
 `godlike` int(11) NOT NULL,
 `beyondgodlike` int(11) NOT NULL,
 `doublekill` int(11) NOT NULL,
 `triplekill` int(11) NOT NULL,
 `ultrakill` int(11) NOT NULL,
 `rampage` int(11) NOT NULL,
 `ownage` int(11) NOT NULL,
 `nemesiskill` int(11) NOT NULL,
 `feedcount` int(11) NOT NULL,
 PRIMARY KEY (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Link to comment
Share on other sites

2 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   5
  • Joined:  05/02/15
  • Last Seen:  

Import attached file.

 

If you would like to know how I did it. Just removed this line

//SQL Table for Ghost's PvP System

Save as SQL file and import.

ghostpvp.sql

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  02/10/15
  • Last Seen:  

Import attached file.

 

If you would like to know how I did it. Just removed this line

//SQL Table for Ghost's PvP System

Save as SQL file and import.

oh.. thank you..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...