B-2-0 Website error

[daniel131605]

Alright im using the B-2-0 website and i found the fixes and what not someone else posted but there are still some errors i need help fixing if someone wouldn't mind if they've already set it up before.


this is at the top of every page and im not sure how to fix it

Warning: touch() [function.touch]: Unable to create file logs/DoSlogs/f8d because No such file or directory in C:\xampp\htdocs\secondwebsite\includes\shield.php on line 71

When i click on items gallery i get this error i ran the .dbo file but i guess these didn't work? i opened things like account.dbo and tried to replace the .dbo with the one that was included but it wouldn't let me change it because i couldn't delete the .dbo file and replace it or just edit it and replace it because it already existed

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Slot'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

Fatal error: Call to undefined function mssql_error() in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

this is also what happens after you log in

[MentaL]

[Drkidvictor]

May i have the link to the Web you are using please?

[ThunderZ]

the error is exactly what it says...the header was already sent o-o

and also that the directory in your shield.php its trying to create logs in a folder that does not exsist.

[Dave]

- "No such file or directory in C:\xampp\htdocs\secondwebsite\includes\shield.php on line 71". Check which file/directory it is in includes/shield.php and create it.

- "Invalid column name 'Slot'." The column Slot obviously does not exist. Maybe you didn't import the SQL file correctly.

[Ronny786]

Read the error carefully...read the addresses and create log file in .php files..just delete the "touch()" function in shield.php
the place where u get 'SLOT' error. Just go to mssql and add new column or if u cant add , delete the 'slot' value in .php files..

bout Loging in, please check your config.php in includes folder and check login.php too..check whether u have entered your MSSQL information( id pass server name) correct..
THATS ALL.. Minor mistakes. :)

[daniel131605]

i re-read the first error i put um there and went into logs and made a folder called DoSlogs and that error went away. i can't get the item gallery error fixed but whatever

[Vusion]

post the query that is causing the error?

[daniel131605]

warning: Mssql_query() [function.mssql-query]: Message: Invalid column name 'slot'. (severity 16) in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

warning: Mssql_query() [function.mssql-query]: Query failed in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

fatal error: Call to undefined function mssql_error() in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

here is just part of it when i run gunzdb that is included with the website:

msg 15023, level 16, state 1, line 12
-------user, group, or role 'gunz' already exists in the current database.
Msg 2714, level 16, state 6, line 6
-------there is already an object named 'account' in the database.
Msg 1913, level 16, state 1, line 2
-------the operation failed because an index or statistics with name -------'ix_account_regdate' already exists on table 'dbo.account'.
Msg 1913, level 16, state 1, line 2
--------the operation failed because an index or statistics with name --------'ix_account_userid' already exists on table 'dbo.account'.
Msg 2714, level 16, state 6, line 6
--------there is already an object named 'accountitem' in the database.
Msg 1913, level 16, state 1, line 2
---------the operation failed because an index or statistics with name --------'ix_accountitem_aid' already exists on table 'dbo.accountitem'.
Msg 1913, level 16, state 1, line 2
----------the operation failed because an index or statistics with name ------'ix_accountitem_rentdate' already exists on table 'dbo.accountitem'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'accountpenaltylog' in the database.
Msg 1913, level 16, state 1, line 2
-------the operation failed because an index or statistics with name -------'ix_accountpenaltylog_aid' already exists on table -------'dbo.accountpenaltylog'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'accountpenaltyperiod' in the database.
Msg 2714, level 16, state 6, line 6
--------there is already an object named 'billingmethod' in the database.
Msg 2714, level 16, state 6, line 6
----------there is already an object named 'blockcountrycode' in the database.
Msg 1913, level 16, state 1, line 2
--------the operation failed because an index or statistics with name ---------'ix_blockcountrycode_isblock' already exists on table 'dbo.blockcountrycode'.
Msg 2714, level 16, state 6, line 6
-------there is already an object named 'bringaccountitemlog' in the database.
Msg 1913, level 16, state 1, line 2
----------the operation failed because an index or statistics with name ------'ix_bringaccoutitem_aid' already exists on table --------'dbo.bringaccountitemlog'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'cashitempresentlog' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_date' already exists on table 'dbo.cashitempresentlog'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_receiveraid' already exists on table 'dbo.cashitempresentlog'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_senderuserid' already exists on table 'dbo.cashitempresentlog'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashsetitem' in the database.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashsetshop' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashsetshop_newitemorder' already exists on table 'dbo.cashsetshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashsetshop_opened' already exists on table 'dbo.cashsetshop'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshop' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_itemid_opened' already exists on table 'dbo.cashshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_newitemorder' already exists on table 'dbo.cashshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_opened' already exists on table 'dbo.cashshop'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshopnewitem' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshopnewitem_neworder' already exists on table 'dbo.cashshopnewitem'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshopnewitemcategory' in the database.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshoprank' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshoprank_category' already exists on table 'dbo.cashshoprank'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshoprank_rank' already exists on table 'dbo.cashshoprank'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'character' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_character_aid' already exists on table 'dbo.character'.

if(!function_exists("ListAllItems")){
function ListAllItems(){
    if(!isset($_GET['type'])){
        $type = "";
    }else{
        $type = "Slot = '".antisql($_GET['type'])."' AND";
    }
    if(($_GET['type']) == 10){
        msgbox ("Press Ok to go to Change Character Name page","index.php?do=ccn");
    }
if ((!isset($_GET['pagenum'])) || (!is_numeric($_GET['pagenum'])) || ($_GET['pagenum'] < 1)) { $pagenum = 1; }
else { $pagenum = $_GET['pagenum']; }
$result = mssql_query ("SELECT * FROM CashShop WHERE ".$type." Opened = '1'") or die(mssql_error());
$rows = mssql_num_rows($result);

this is were the error is in the php i guess

[Vusion]

UPDATE CashShop ADD slot varchar(50)

[daniel131605]

UPDATE CashShop ADD slot varchar(50)

what do you mean? i clicked design cashshop to "add" something but idk what you want me to add....

[jur13n]

why not create the column yourself.
just as test use Varchar(100) as key or something.
most of the time it will work.

[daniel131605]

why not create the column yourself.
just as test use Varchar(100) as key or something.
most of the time it will work.

what do you mean, in the database?

i also just came across another error

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'sa'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'sq'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'captcha_code'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'euCoins'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 189

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 189



The Account 'monk' has been created successfully.
To edit your profile, login and click Profile "Edit my account"

when i try and register an account this happens but the account is never made. please help me

[Vusion]

my code was an sql query.

ALTER TABLE CashShop ADD slot varchar(50) 
ALTER TABLE Account ADD sa varchar(500)
ALTER TABLE Account ADD sq varchar(500)
ALTER TABLE Account ADD captcha_code varchar(50)
ALTER TABLE Login Add euCoins int

[daniel131605]

thank you that fixed the cash shop error i've been getting also another error when im trying to create or edit my account's "sex" "zip code" and "address" it get an error after click update and it doesn't work.

Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Male' to data type tinyint. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185



The Account 'daniel13605' has been created successfully.
To edit your profile, login and click Profile "Edit my account"

im not very good with database edits but can you do the same thing for this for me please? if im correct by how you did it would it be
ALTER TABLE Account ADD male varchar(500) ?

After filling out the register data and click submit it still doesn't create the account

[Vusion]

change sex's datatype to varchar(50) OR, you change the register to insert 1 or 0. why do you need to know his gender anyway..

[daniel131605]

change sex's datatype to varchar(50) OR, you change the register to insert 1 or 0. why do you need to know his gender anyway..

i don't its just part of the register page if they want to fill it out and

when i click on the people to see their game information i get this

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Views'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_charinfo.php on line 36

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_charinfo.php on line 36

Signature

Image Link- b2ogunz.co.in - это наилучший источник информации по теме b2ogunz. Этот веб-сайт продается

with a broken image, can you tell me any good signature makers? i saw the skygunz one and tried to edit it to my needs but the odbc thing kept failing

[jur13n]

my code was an sql query.

ALTER TABLE CashShop ADD slot varchar(50) 
ALTER TABLE Account ADD sa varchar(500)
ALTER TABLE Account ADD sq varchar(500)
ALTER TABLE Account ADD captcha_code varchar(50)
ALTER TABLE Login Add euCoins int

this was what i ment, varchar mostly works on everything.

[Vusion]

god.

ALTER Character ADD Views int

[daniel131605]

god.

ALTER Character ADD Views int

Msg 343, Level 15, State 1, Line 1
Unknown object type 'Character' used in a CREATE, DROP, or ALTER statement.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'Views'.

database error? o.o

never mind i just added the TABLE in front of it

vusion you seem to be helping a lot so can you do me another favor? when i try and create a clan in game my game crashes can you help me with that please? also when i try and do the prison quest it crashes, i have all of the files for the prison quest in the client and server files thanks ^_^