Need Help. Newbie on SQL stuffs. Adding PvP Ladder

[patz1495]

Well, not sure if this is the correct place to post this. Sorry in advance if it is in the wrong place. Anyway. I'm kinda new in the SQL stuff. I wanna add Ghost's pvp ladder script on my server. Where should I put the .sql file for it to be read. I get the other parts of the procedures of installing the PvP Ladder. It's just the SQL part I'm getting confused with. Need help please. Replies would be greatly appreciated. Thanks in advance!

[Emistry]

[michaelsoftman]

Depends on what you use to edit your SQL database.

 

You'd open the SQL file, copy the code, and paste it into a query for the database.  You can do this in mySQL workbench, or phpmyadmin, etc.

[patz1495]

So I'll just copy then paste it into a query? Btw, I'm using phpmyadmin.

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

[Patskie]

You can directly import the .sql file on your database instead of copying the query command and executing it.