Jump to content
The Web Section is Now Read-Only
  • 0

there's any guide how to install STARCP?

vans29

Asked by vans29,

 Share

Question

12 answers to this question

Recommended Posts

Mystery Poring

Mystery

Posted
Posted

Myself, I'm currently trying to update SGCP's code as you can see in my Repo. However, to answer your question, have you entered your account ID into your privilege table? https://github.com/Mysteries/StarGamesControlPanel/blob/master/install/sql-files/sgcp_database.sql

 

 

DROP TABLE IF EXISTS `privilege`;
CREATE TABLE `privilege` (
  `account_id` int(11) NOT NULL default '0',
  `privilege` int(11) NOT NULL default '0',
  PRIMARY KEY (`account_id`)
) TYPE=MyISAM;
INSERT INTO `privilege` VALUES (20000000,5);

 

There are currently 5 groups:

  • Guest
  • Member
  • Banned
  • Sub Admin
  • and Administrator

 

put 5 for administrator for your account.

vans29 Drops

vans29

Posted
  • Author
Posted

did you set your GM Level 99?

yeah i set

 

Myself, I'm currently trying to update SGCP's code as you can see in my Repo. However, to answer your question, have you entered your account ID into your privilege table? https://github.com/Mysteries/StarGamesControlPanel/blob/master/install/sql-files/sgcp_database.sql

 

 

DROP TABLE IF EXISTS `privilege`;
CREATE TABLE `privilege` (
  `account_id` int(11) NOT NULL default '0',
  `privilege` int(11) NOT NULL default '0',
  PRIMARY KEY (`account_id`)
) TYPE=MyISAM;
INSERT INTO `privilege` VALUES (20000000,5);

 

There are currently 5 groups:

  • Guest
  • Member
  • Banned
  • Sub Admin
  • and Administrator

 

put 5 for administrator for your account.

done but the player ranking still error!

and also how to make Vote for points in Star CP?

vans29 Drops

vans29

Posted
  • Author
Posted

How do you get an error in your player ranking? Mine doesn't error o_O http://sgcp.hostei.com/index.php?act=p_rank

 

Note: you need to login to view it since I've set it up like that in the config file.

 

Username: demo

Password: demo

omg why cant connect my SQL to SGCP account id and cant register

How do you get an error in your player ranking? Mine doesn't error o_O http://sgcp.hostei.com/index.php?act=p_rank

 

Note: you need to login to view it since I've set it up like that in the config file.

 

Username: demo

Password: demo

 

 nav_m.gif Searching Option Character name:                       Any words                     All words                  Sort by class:                      All Class                     Novice                     Swordman                     Mage                     Archer                     Acolyte                     Merchant                     Thief                     Knight                     Priest                     Wizard                     Blacksmith                     Hunter                     Assassin                     Kinght Peco                     Crusader                     Monk                     Sage                     Rogue                     Alchemist                     Bard                     Dancer                     Crusader Peco                     Wedding                     Super Novice                     Gunslinger                     Ninja                     Novice High                     Swordman High                     Mage High                     Archer High                     Acolyte High                     Merchant High                     Thief High                     Lord Knight                     High Priest                     High Wizard                     Mastersmith                     Sniper                     Assassin Cross                     Lord Knigh Peco                     Paladin                     Champion                     Scholar                     Stalker                     Biochemist                     Minstrel                     Gypsy                     Paladin Peco                     Baby                     Baby Swordman                     Baby Mage                     Baby Archer                     Baby Acolyte                     Baby Merchant                     Baby Thief                     Baby Knight                     Baby Priest                     Baby Wizard                     Baby Blacksmith                     Baby Hunter                     Baby Assassin                     Baby Knight Peco                     Baby Crusader                     Baby Monk                     Baby Sage                     Baby Rogue                     Baby Alchemist                     Baby Bard                     Baby Dancer                     Baby Crusader Peco                     Super Baby                     Taekwondo                     Star Gladiator                     Star Gladiator                     Soul Linker                  Type:                      Base Level                     Job Level                     Max HP                     Max SP                  Key:                      Descending                     Ascending                  Status:                      All                     Online                     Offline                  Row(s):   MySQL query['player_rank.php'] :

i got this

Checkmate Poring

Checkmate

Posted
Posted


Actually... About vote for point try to refer this section... Cuz im using SGCP too.. 

 



Before im using above script,im using below script...
 

prontera,156,168,5    script    Vote4Point    467,{
 
    setarray @vote_item[0],            5788, 5270, 5344, 5236, 5308, 5378, 5796; // Item ID
    setarray @vote_item_count[0],    1  , 1  , 1  , 1  , 1  , 1  , 1; // Item Count wich will be given
    setarray @vote_cost[0],            24  , 24  , 16  , 16  , 8  , 24  , 32; // Cost in Vote Points
    set @min_vote, 0; // minimum count on Vote Points to see the Item List
    set @npcname$,"[^ff0000VoteNpc^000000]";
 
    query_sql ("SELECT `point` FROM `vote_point` WHERE `loginname` = MD5('"+getcharid(3)+"')", @vote);
 
    mes @VoteNpc$;
    mes "You have ^ff0000"+@vote+"^000000 Vote Points!";
    if( @vote < @min_vote ) {
        mes "^ff0000You will need "+@min_vote+" or more Vote Points to trade them with me!^000000";
        close;
    }
    if (select("Trade my Points!","Cancel~") == 2) 
        close;
 
    next;
    mes "[^ff0000List^000000]";
    mes "^0000ffItem^000000 = ^00aa00Cost^000000";
    for( set .@i, 0; .@i < getarraysize(@vote_item); set .@i, .@i + 1 ) {
        mes "^0000ff"+@vote_item_count[.@i]+"x "+getitemname(@vote_item[.@i])+"^000000 = ^00aa00"+@vote_cost[.@i]+"^000000";
        if( .@i < 1 )
            set .@menu$, getitemname(@vote_item[.@i]);
        else
            set .@menu$, .@menu$+":"+getitemname(@vote_item[.@i]);
    }
 
    next;
    select(.@menu$);
    set @choice, @menu - 1;
 
    mes @VoteNpc$;
    if( @vote_cost[@choice] > @vote ) {
        mes "^ff0000You dont have enough Vote Point for "+@vote_item_count[@choice]+"x '"+getitemname(@vote_item[@choice])+"' :/^000000";
        close;
    }
    mes "Are u realy sure to trade "+@vote_item_count[@choice]+"x '^ff0000"+getitemname(@vote_item[@choice])+"^000000' for ^00aa00"+@vote_cost[@choice]+"^000000 Vote Points?";
    if(select("No! Cancel!:Yes, Trade me!") == 1 ) {
        mes "^ff0000Trade was canceled~^000000";
        close;
    }
 
    set .@new, @vote - @vote_cost[@choice];
    if( .@new < 0 ) // safty first..
        set .@new, 0;
    query_sql("UPDATE `vote_point` SET `point` = '"+.@new+"' WHERE `loginname` = MD5('"+getcharid(3)+"')");
    getitem @vote_item[@choice], @vote_item_count[@choice];
    mes "^00aa00Trade was Successfull ^_^ Hope to see u again =)!^000000";
    close;
 
    OnInit:
    waitingroom "Vote4Point Redeem",0;
    end;
}


About how to install Vote 4 Point you can refer old forum eAthena but today im while im trying to see that thread its was been FORBIDDEN...

Try to ask Sir Capuche more about this...

I try to figure out what i can help you about SGCP k... 
 

vans29 Drops

vans29

Posted
  • Author
Posted

Actually... About vote for point try to refer this section... Cuz im using SGCP too.. 

 

Before im using above script,im using below script...

 

> 

prontera,156,168,5    script    Vote4Point    467,{
 
    setarray @vote_item[0],            5788, 5270, 5344, 5236, 5308, 5378, 5796; // Item ID
    setarray @vote_item_count[0],    1  , 1  , 1  , 1  , 1  , 1  , 1; // Item Count wich will be given
    setarray @vote_cost[0],            24  , 24  , 16  , 16  , 8  , 24  , 32; // Cost in Vote Points
    set @min_vote, 0; // minimum count on Vote Points to see the Item List
    set @npcname$,"[^ff0000VoteNpc^000000]";
 
    query_sql ("SELECT `point` FROM `vote_point` WHERE `loginname` = MD5('"+getcharid(3)+"')", @vote);
 
    mes @VoteNpc$;
    mes "You have ^ff0000"+@vote+"^000000 Vote Points!";
    if( @vote < @min_vote ) {
        mes "^ff0000You will need "+@min_vote+" or more Vote Points to trade them with me!^000000";
        close;
    }
    if (select("Trade my Points!","Cancel~") == 2) 
        close;
 
    next;
    mes "[^ff0000List^000000]";
    mes "^0000ffItem^000000 = ^00aa00Cost^000000";
    for( set .@i, 0; .@i < getarraysize(@vote_item); set .@i, .@i + 1 ) {
        mes "^0000ff"+@vote_item_count[.@i]+"x "+getitemname(@vote_item[.@i])+"^000000 = ^00aa00"+@vote_cost[.@i]+"^000000";
        if( .@i < 1 )
            set .@menu$, getitemname(@vote_item[.@i]);
        else
            set .@menu$, .@menu$+":"+getitemname(@vote_item[.@i]);
    }
 
    next;
    select(.@menu$);
    set @choice, @menu - 1;
 
    mes @VoteNpc$;
    if( @vote_cost[@choice] > @vote ) {
        mes "^ff0000You dont have enough Vote Point for "+@vote_item_count[@choice]+"x '"+getitemname(@vote_item[@choice])+"' :/^000000";
        close;
    }
    mes "Are u realy sure to trade "+@vote_item_count[@choice]+"x '^ff0000"+getitemname(@vote_item[@choice])+"^000000' for ^00aa00"+@vote_cost[@choice]+"^000000 Vote Points?";
    if(select("No! Cancel!:Yes, Trade me!") == 1 ) {
        mes "^ff0000Trade was canceled~^000000";
        close;
    }
 
    set .@new, @vote - @vote_cost[@choice];
    if( .@new < 0 ) // safty first..
        set .@new, 0;
    query_sql("UPDATE `vote_point` SET `point` = '"+.@new+"' WHERE `loginname` = MD5('"+getcharid(3)+"')");
    getitem @vote_item[@choice], @vote_item_count[@choice];
    mes "^00aa00Trade was Successfull ^_^ Hope to see u again =)!^000000";
    close;
 
    OnInit:
    waitingroom "Vote4Point Redeem",0;
    end;
}

About how to install Vote 4 Point you can refer old forum eAthena but today im while im trying to see that thread its was been FORBIDDEN...

Try to ask Sir Capuche more about this...

I try to figure out what i can help you about SGCP k... 

 

this one need's Sql? and how to put in star CP i am new in StarCP

vans29 Drops

vans29

Posted
  • Author
Posted

Yap.. need sql.. I do what this site say...

But.. Unfortunately.. It is forbidden now...

I try to recall back and see what i can help you with it..

Btw in the same time try to asking help from the other's Mods and Community k.. ^ ^

owhhh thanks in advance and also i cant register and cant see the player ranking but the guilds is ok and i can log in also my problem is cant register and pvp rangking check this

 

http://waferro.crow-games.com/cp/index.php?act=p_rank

id: demo

pass: demo

Checkmate Poring

Checkmate

Posted
Posted
SELECT account_id FROM ROServer.login WHERE level>=""

It was you sql error.. since like there is not table create for that..

Or  the table already created but not compatible or on the right path..(Like  did not connect to your ro)..

I dont pro about this dude..

Try pm other more experienced staff about this... Im sorry

vans29 Drops

vans29

Posted
  • Author
Posted

 

SELECT account_id FROM ROServer.login WHERE level>=""

It was you sql error.. since like there is not table create for that..

Or  the table already created but not compatible or on the right path..(Like  did not connect to your ro)..

I dont pro about this dude..

Try pm other more experienced staff about this... Im sorry

okey thanks i think eamod not compatible with STARCP i will change to rathena now

 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...