B-2-O Web fixes

[Phoenix]

i have all these stuff working without editing a bit.
all i did is just execute his Sql thats it

Same here. I made a fresh DB by executing his script and then executed some DB fixes, July/Oct 08 DB, etc. And people think I lied about everything working for me <.<. Thanks.

[MicroManiacs]

Same here. I made a fresh DB by executing his script and then executed some DB fixes, July/Oct 08 DB, etc. And people think I lied about everything working for me <.<. Thanks.

that could be true, but there are people that already started a server and don't want to lose their old data.

[wesman2232]

Thanks Rodi, the problem was that when I added it via the web it sets them to Opened = 0 not sure how to fix that.

check the query, and put it to 1

[Larities]

I have no idea how to implement these mssql query's. I'm using b20's db and tried executing the query's, but they dont add on to the table thats already there and i can't delete the table already in the db, so i can execute these fixes o_O.

[MicroManiacs]

I have no idea how to implement these mssql query's. I'm using b20's db and tried executing the query's, but they dont add on to the table thats already there and i can't delete the table already in the db, so i can execute these fixes o_O.

Then you need to look at the columns in the querie i posted wich columns you dont have and the ones you dont have you add them with the value that is next to it.

[nanowarior]

Ok wtf is this a scam, mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1',100)");
Each time I regster on an new account a person gets 100 EUU COINS.

nice 1.

Full CoDE:
mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1',100)");

[NoobatGunz]

Upload the files?
Its easier than editing

[Military]

make it 0?

[Kanoru]

thanks i need this

[nanowarior]

Yes but what if nobody knew about it, tell now I just did. So wht if people keep registering and get free donators.
P.S User availability. Dosent work for me :/

[yurij13]

omg errors everywere example!!!!! on announcements box

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'IndexContent'. (severity 16) in C:\xampp\htdocs\modules\mod_index.php on line 56

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

Warning: mssql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\modules\mod_index.php on line 57
          

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'IndexContent'. (severity 16) in C:\xampp\htdocs\modules\mod_index.php on line 81

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

Warning: mssql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\modules\mod_index.php on line 82 

[RodiSR]

omg errors everywere example!!!!! on announcements box

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'IndexContent'. (severity 16) in C:\xampp\htdocs\modules\mod_index.php on line 56

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

Warning: mssql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\modules\mod_index.php on line 57
          

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'IndexContent'. (severity 16) in C:\xampp\htdocs\modules\mod_index.php on line 81

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

Warning: mssql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\modules\mod_index.php on line 82 

USE [GunzDB]
GO
/****** Object:  Table [dbo].[IndexContent]    Script Date: 08/30/2010 08:38:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[IndexContent](
    [ICID] [int] IDENTITY(1,1) NOT NULL,
    [Type] [tinyint] NULL,
    [Title] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [User] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Date] [datetime] NULL,
    [Text] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF 

[gatsu]

Thanks.

[vraj123]

need help! after applying these fixs still when i add item to shop it doesnt show up :(

[adminjoker]

I am getting this error while i access my website.

Warning: touch() [function.touch]: Unable to access logs/DoSlogs/8d6 in C:\AppServ\www\NighT\includes\shield.php on line 71 

"It show the error on the top!"

I hope you can find a way or you may know how to fix this error.



EDITED:
Never mind i fixed already xD.

Tutorial:
GO to logs folder and just create a folder called "DoSlogs".