Ghost PVP System

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.

 
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.


 
Last edited by a moderator:
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).

 
Last edited by a moderator:
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 

Code: 
CREATE TABLE IF NOT EXISTS 
 
Last edited by a moderator:
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:

Code: 
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;
 
I think yes but haven't tested. Same for if you simply omit the engine and the default charset.

 
You must log in or register to reply here.
Back
Top