Ghost PVP System

[karazu 33]

Can anyone convert this to Hercules please?

http://rathena.org/board/topic/58222-ghosts-scripts-latest-ghosts-pvp-system-v13/page-6#entry229828

[jaBote 438]

After a quick parse, it seems this script is still working on Hercules without any problem. Please try that script on your server along with all of its requirements to see how that goes.

[Brynner 34]

that script works fine for Hercules.

[karazu 33]

Thank you for both of you!

been busy for the last few days, didn't manage to try it. But I will now.

will update you later guys.

EDIT:
One stupid question.

What line should i remove in this code before running the query? 

 

 

 

//SQL Table for Ghost's PvP SystemCREATE 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=M 

Because I am getting some error in running it.

Edited November 1, 2013 by karazu

[jaBote 438]

First one. Comments in SQL start with -- (double dash), not // (double slash), so the commented line (in C) is what is giving you the error.

 

Anyways, you could simply avoid copying that line, since comments are made for better programmer's understanding, compilers and parsers just ignore them (if they can parse them as comments).

[karazu 33]

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=M 

Is this correct?

 

just want to make sure

 

 

EDIT:

 

or still need to remove the 

 

CREATE TABLE IF NOT EXISTS 

Edited November 1, 2013 by karazu

[jaBote 438]

Oh, I just realised you're missing the end on your code.

 

Either run it without stating anything about this: ENGINE=MyISAM DEFAULT CHARSET=latin1

 

Or run the whole table query:

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;

[Zezicla 2]

can it also be

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

??

[jaBote 438]

I think yes but haven't tested. Same for if you simply omit the engine and the default charset.