Jump to content
  • 0

H>Rebirth System Debug,Error

chromus28

Asked by chromus28,

 Share

Question

chromus28 Poring

chromus28

Posted
Posted

guys what is the problem if im having this problem??

 

[Debug]: Source (NPC): Rebirth System at prontera (185,145)
: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
 
here is my script
 

/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}

 

5 answers to this question

Recommended Posts

Brynner Metaling

Brynner

Posted
Posted

 

guys what is the problem if im having this problem??

 

[Debug]: Source (NPC): Rebirth System at prontera (185,145)
: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
 
here is my script
 

/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}

 

the error is the missing ragnarok.rebirth_system on your sql.

 

try to run this on your sql query.

CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
chromus28 Poring

chromus28

Posted
  • Author
Posted

guys what is the problem if im having this problem??

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

: DB error - Table 'ragnarok.rebirth_system' doesn't exist

[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist

[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

here is my script


/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}
the error is the missing ragnarok.rebirth_system on your sql.

try to run this on your sql query.

CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;

sorry guide pls? noob here :(

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.

×
 Share
Go to question listing

  • Recently Browsing   0 members

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