MAFIA Forums

April 25, 2024, 09:34:20 PM
Welcome, Guest

News:

Welcome back the Arcade! Play over 100+ games to get the high score and compete against other forum members.

http://www.mafiaowns.com/index.php?action=arcade;sa=list;sortby=a2z;

Profile Info
- Summary
- Show Stats
- Show Posts
Tinyportal
- Portal Summary
- Articles
  - Articles
  - Settings

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - MAFIA Capsloc

Pages: 1 [2] 3 4 ... 14

Flame / EXTRA EXTRA Read all about it..

« on: June 03, 2009, 07:58:45 PM »

During our merge with FPS, a Piece of Shit ex admin decided to send out a virus to all of our members.

Please DO NOT download any "Beta" hack from a rapidshare link, which is the following file: cryptedPI2.3.2 .exe

Thanks to "Brick" for being such a Prick....eat shit and die you fucking loser.

again DO NOT download any file from a rapidshare link, it is a VIRUS!!!

Regards,
The Game Anarchy Team.

lol that Brick....

Media / Vampire Weekend

« on: May 29, 2009, 12:49:52 AM »

Anyone else in here like this band?

http://www.youtube.com/watch?v=MAEjjRkHGdA

bonehead...... .get to work on a youtube bb code you lazy bum.

Media / Did anyone watch......

« on: May 27, 2009, 09:51:56 PM »

The match today?!?!?

BARCELONA VS. MCU

amazing....

Games / need name...

« on: May 13, 2009, 02:55:58 PM »

Anyone remember that game, it was like a 2D game. Little guys shooting guns and all kinds of stuff. I remember some guys that came on vent to play it too... name was Mark i believe? Think it was that same guy that gave milky a virus telling him it was a CS:S hack lol....

wait nvm it was SOLDAT

BF 1942 / who remembers.....

« on: May 11, 2009, 07:03:53 PM »

http://www.youtube.com/watch?v=28l5eZJsijU

Help / SQL Multiple Table Inner Join

« on: May 07, 2009, 11:48:39 AM »

Balth i'm sure you are the one for this one....here it goes

So i inserted all my data and stuff to some tables that were given to us...all goes fine until the Multiple Table Inner joins come in.

I have to get Student_ID, Last_Name, First_Name, Course_Name, Department_Nam e, Course_Number, Section_Letter for every student enrolled in every section. Order by Student_ID.

My 3 tables that i will pull this from are
dbo.Enroll dbo.Student dbo.Course

this was my join. Still trying to figure out how they fully work on multiple tables.

Code: [Select]

SELECT Student_ID, Last_Name, First_Name, Course_Name, Department_Name,
Course_Number, Section_Letter
FROM ((dbo.Student S
		INNER JOIN dbo.Enroll E
		ON E.Student_ID = S.Student_ID)
		(dbo.Student S
		INNER JOIN dbo.Course C
		ON S.Department_Name = C.Department_Name)

But that was pure fail:

Msg 207, Level 16, State 1, Line 11
Invalid column name 'Department_Nam e'.
Msg 209, Level 16, State 1, Line 5
Ambiguous column name 'Student_ID'.
Msg 209, Level 16, State 1, Line 5
Ambiguous column name 'Department_Nam e'.
Msg 209, Level 16, State 1, Line 6
Ambiguous column name 'Course_Number'.

Here is my SQL Script if you need it.

Code: [Select]

/* Step 0 
Filename: CS61_4_Tamayo_Chris.SQL
Date: 5/05/2009
Backup: Flash Drive
*/

USE CS61db_28

IF EXISTS (select * from dbo.sysobjects
	WHERE id = object_id(N'dbo.Enroll') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
	DROP TABLE dbo.Enroll
	GO	
	
IF EXISTS (select * from dbo.sysobjects
	WHERE id = object_id(N'dbo.Section') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
	DROP TABLE dbo.Section
	GO
	
IF EXISTS (select * from dbo.sysobjects
	WHERE id = object_id(N'dbo.Student') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
	DROP TABLE dbo.Student
	GO

IF EXISTS (select * from dbo.sysobjects
	WHERE id = object_id(N'dbo.Course') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
	DROP TABLE dbo.Course
	GO


/* Create tables now */	

CREATE TABLE dbo.Course (
	Department_Name varchar(20) NOT NULL,
	Course_Number int NOT NULL,
	Course_Name varchar(30) NOT NULL,
	Course_Description varchar(60) NOT NULL,
	Credit_Hours int NOT NULL DEFAULT 3
	)
	GO
	
CREATE TABLE dbo.Section (
	Course_Number int NOT NULL,
	Department_Name varchar(20) NOT NULL,
	Section_Letter char(1) NOT NULL DEFAULT 'A',
	Classroom varchar(10) NOT NULL,
	Instructor_ID int not null
	)
	GO
	
CREATE TABLE dbo.Student (
	Student_ID int IDENTITY (1000,10) not null,
	Last_Name varchar(20) NOT NULL,
	First_Name varchar(20) NOT NULL,
	City varchar(20) DEFAULT 'Santa Monica',
	State char(2) DEFAULT 'CA',
	)
	GO
	
CREATE TABLE dbo.Enroll (
	Department_Name varchar(20) NOT NULL,
	Course_Number int NOT NULL,
	Section_Letter char(1) NOT NULL DEFAULT 'A',
	Student_ID int NOT NULL
	)
	GO

/* Create Primary Keys */

ALTER TABLE dbo.Course       WITH NOCHECK ADD 
	CONSTRAINT PK_DptName_CourseName PRIMARY KEY  CLUSTERED 
	(Department_Name,Course_Number)  
GO	

ALTER TABLE dbo.Student       WITH NOCHECK ADD 
	CONSTRAINT PK_StudentID PRIMARY KEY  CLUSTERED 
	(Student_ID)  
GO	

/* Create Foreign Keys */

ALTER TABLE dbo.Enroll ADD 
	CONSTRAINT FK_Student_ID FOREIGN KEY 
	(Student_ID) REFERENCES dbo.Student (Student_ID)
GO

ALTER TABLE dbo.Section ADD 
	CONSTRAINT FK_DeptName_CNum_section FOREIGN KEY 
	(Department_Name,Course_Number) REFERENCES dbo.Course (Department_Name,Course_Number)
GO

ALTER TABLE dbo.Enroll ADD 
	CONSTRAINT FK_DptName_CourseNum FOREIGN KEY 
	(Department_Name,Course_Number) REFERENCES dbo.Course (Department_Name,Course_Number)
GO 


/*Insert Data Into Tables */

INSERT INTO dbo.Student
(Last_Name,First_Name,City,State)
VALUES
('Tamayo','Chris','Bell Gardens', 'CA')

INSERT INTO dbo.Student
(Last_Name,First_Name,City,State)
VALUES
('Doe','John','Las Vegas', 'NV')

INSERT INTO dbo.Student
(Last_Name,First_Name,City,State)
VALUES
('Smith','James','Los Angeles', 'CA')

INSERT INTO dbo.Student
(Last_Name,First_Name,City,State)
VALUES
('Mazon','Amy','Boise', 'ID')


/* Insert Courses */
INSERT INTO dbo.Course
(Department_Name,Course_Number,Course_Name,Course_Description,Credit_Hours)
VALUES
('Math','101','Beginning Math', 'Middle School Algebra','3')

INSERT INTO dbo.Course
(Department_Name,Course_Number,Course_Name,Course_Description,Credit_Hours)
VALUES
('Psychology','210','Human Behavior', 'Course explains human reactions','2')

INSERT INTO dbo.Course
(Department_Name,Course_Number,Course_Name,Course_Description,Credit_Hours)
VALUES
('English','400','Comtemporary Literature', 'Another English Class','3')


/*Insert Sections*/
INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('English','400','A', '215','15')

INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('English','400','B', '216','16')

INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('Math','101','B','75','10')

INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('Math','101','C','74','11')

INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('Psychology','210','A','220','2')

INSERT INTO dbo.Section
(Department_Name,Course_Number,Section_Letter,Classroom,Instructor_ID)
VALUES
('Psychology','210','D','225','1')


/* Insert Enrolls */
INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('Psychology','210','A','1010')

INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('Math','101','C','1010')

INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('English','400','B','1010')

INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('Math','101','B','1030')

INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('English','400','A','1030')

INSERT INTO dbo.Enroll
(Department_Name,Course_Number,Section_Letter,Student_ID)
VALUES
('Psychology','210','D','1000')

/* insert day and time rows*/
ALTER TABLE dbo.Section ADD
	Class_Day varchar(15) NULL
	
ALTER TABLE dbo.Section ADD
	Class_Time datetime	NULL
	
/* Insert Times */
	UPDATE dbo.Section
	SET Class_Day = 'Monday', Class_Time = '10:00AM'
	WHERE Department_Name = 'Math' AND Section_Letter = 'B'
	
		UPDATE dbo.Section
	SET Class_Day = 'Wednesday', Class_Time = '11:00AM'
	WHERE Department_Name = 'Math' AND Section_Letter = 'C'
	
		UPDATE dbo.Section
	SET Class_Day = 'Tuesday', Class_Time = '05:00PM'
	WHERE Department_Name = 'Psychology' AND Section_Letter = 'A'
	
		UPDATE dbo.Section
	SET Class_Day = 'Tuesday', Class_Time = '07:45AM'
	WHERE Department_Name = 'Psychology' AND Section_Letter = 'D'
	
		UPDATE dbo.Section
	SET Class_Day = 'Friday', Class_Time = '09:00AM'
	WHERE Department_Name = 'English' AND Section_Letter = 'B'
	
		UPDATE dbo.Section
	SET Class_Day = 'Saturday', Class_Time = '06:45AM'
	WHERE Department_Name = 'English' AND Section_Letter = 'A'

	SELECT * FROM dbo.Section


/* Step 2 */
SELECT Student_ID, Last_Name, First_Name, Course_Name, Department_Name,
Course_Number, Section_Letter
FROM ((dbo.Student S
		INNER JOIN dbo.Enroll E
		ON E.Student_ID = S.Student_ID)
		(dbo.Student S
		INNER JOIN dbo.Course C
		ON S.Department_Name = C.Department_Name)

Spam / @bunhead or balth

« on: April 08, 2009, 06:37:24 PM »

Ok, so i'm working on this web application for my pops....

Code: [Select]

<HTML><style type="text/css">
<!--
body {
	background-image: url(../background.png);
}
-->
</style>
<title>Uruapan Auto Management System</title><BODY>
<p align="center">Uruapan Auto Management System</p>
<p>&nbsp;</p>
 
<form action='add_insert.php' method='post'>
<table width="449" border="1" align="center">
 <tr>
    <td width="162" height="23"><div align="right">Vehicle Make:</div></td>
    <td width="271"><div align="left">
    
      
       <?php
*******************
all connection info here
*******************

$query = "SELECT make FROM vehicle_make ORDER BY make";
$result = mysql_query($query)
or die ("Couldn't execute query");

$options=""; 
while ($row=mysql_fetch_array($result)) { 
$make=$row["make"];
    $options.="<OPTION VALUE=\"$make\">".$make.'</option>';
} ?>
      <SELECT NAME="make"> 
      <OPTION VALUE=0>
<?php echo $options ?>
</select>


    </div></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Model</div></td>
    <td><label>
      <input name="model" type="text" id="model" maxlength="25">
    </label></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Year:</div></td>
    <td><input name="auto_year" type="text" id="auto_year" maxlength="4"></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Color:</div></td>
    <td><input name="color" type="text" id="color" maxlength="15"></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Miles:</div></td>
    <td><input name="miles" type="text" id="miles" maxlength="6"></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Price:</div></td>
    <td><input name="price" type="text" id="price" maxlength="5"></td>
  </tr>
  <tr>
    <td height="23"><div align="right">VIN</div></td>
    <td><input name="VIN" type="text" id="VIN" maxlength="17"></td>
  </tr>
  <tr>
    <td height="23"><div align="right">Approved:</div></td>
    <td>
    <input type="radio" name="approved" id="radio" value="1">
    Yes | 
    <input name="approved" type="radio" id="radio2" value="0" checked>
    No   </td>
  </tr>
  <tr>
    <td height="23">&nbsp;</td>
    <td><label>
      <input type="submit" name="Submit" id="Submit" value="Submit">
      <input type="reset" name="Reset" id="reset" value="Reset">
    </label></td>
  </tr>
</table>
</form>
</BODY>
</HTML>

Now all that works fine when inserting through my add_insert.php page. Thing is, I need to add an upload field there, that will insert an image of the vehicle into my mysql database. I was reading up and i saw lots of tutorials with an image upload form. But nothing about imageupload along with more data than just the image.

Any ideas on how this might work? Here is the code for my add_insert.php page

Code: [Select]

<?php
***********************
connection info here
***********************
$connection = mysql_connect($host, $username, $password)
	or die ("Couldn't connect to server!");
    $db = mysql_select_db($database,$connection)
	or die ("Couldn't connect to server!");
 //Replace with your MySQL DB Name
$make=mysql_real_escape_string($_POST['make']); //This value has to be the same as in the HTML form file
$model=mysql_real_escape_string($_POST['model']);
$auto_year=mysql_real_escape_string($_POST['auto_year']);
$color=mysql_real_escape_string($_POST['color']);
$miles=mysql_real_escape_string($_POST['miles']);
$price=mysql_real_escape_string($_POST['price']);
$VIN=mysql_real_escape_string($_POST['VIN']);
$approved=mysql_real_escape_string($_POST['approved']); //This value has to be the same as in the HTML form file

// the following inserts all new data stored in the variables above, that were taken from the previous form
$sql="INSERT INTO inventory (make,model,auto_year,color,miles,price,VIN,approved) VALUES ('$make','$model','$auto_year','$color','$miles','$price','$VIN','$approved')"; 
if (!mysql_query($sql,$connection)) {
 die('Error: ' . mysql_error());
}
echo "The form data was successfully added to your database.";
mysql_close($connection);
?>

<a href="index.php">Go Back</a>

Spam / a chat w/ phantom feat. balth talk

« on: March 20, 2009, 11:25:56 PM »

Vigy says:
no, there is this really cute girl in my art class though i've been talking to
she is total opposite of what i usually go for but she is just soo cute
chris says:
hah nice nice
Vigy says:
shes really short like 5 ft and she's kinda nerdy lookin but something about her is just really cute
and she has glasses too but idk man it must be the personality
lol
chris says:
yeah
short hair?
Vigy says:
yea like down to the shoulders
not long at all
chris says:
nice
she white?
Vigy says:
yea really really white lol like no tan
chris says:
LOL
balth white, i see
Vigy says:
yea lol that's probably why i like her!

reminds me of balth HAHA

chris says:
HAHAHAHA
Vigy says:
if balth was a girl, that's who she looks like
chris says:

haha
Vigy says:
no tits, little ass
but still i'd rape her
and go to prison for life
so worth it

Media / mr. blue sky

« on: March 09, 2009, 10:07:13 PM »

anyone ever heard the song?

http://www.youtube.com/watch?v=98P-gu_vMRc

good stuff

Games / COMBAT ARMS

« on: February 03, 2009, 09:14:44 AM »

Time to play it biznitches.

http://combatarms.nexon.net/Intro.aspx

It's free. Let me know if you guys decide to play. we can own some nagas.

General / @ BALTHY

« on: February 01, 2009, 10:12:40 PM »

Are you still alive broski?!?!?

I was hearing bout the bad icestorm over there in Kentucky!!!!

DON'T DIE ON ME.

THE REST OF YOU CAN DIE! Except MG cuz she did my taxes this year.

Graphics / Phantom's Comeback1!!!

« on: January 21, 2009, 08:18:54 PM »

Yep, he's starting to PS again..

Here is one of his latest creations. He made it for my guild.

http://www.lparguild.com/forum/images/wow/misc/header.jpg

BF 2 / uh.....

« on: January 21, 2009, 08:11:05 PM »

so i just re-installed bf2

for those i get along with....do u guys still play?

Media / LOL Bush LOL

« on: December 16, 2008, 10:49:38 PM »

http://www.liveleak.com/view?i=023_1229383665

enjoy the shoe

Media / JFK Assasination Vid

« on: August 09, 2008, 04:14:22 PM »

yes yes we've all seen it.

well this is the stabilized video along with some explanation of what kinda really happened. Seeing as to how the "original" government released video now doesn't add up at all. Very interesting. Please let this be a mature thread.

http://www.youtube.com/watch?v=w-rcdBNFnGs

Discuss.

Pages: 1 [2] 3 4 ... 14

BlackRain V3 by, Crip
XHTML
RSS
WAP2

Page created in 0.038 seconds with 28 queries.

*MAFIA* Forums

News:

Profile Info

Tinyportal

Show Posts

Topics - *MAFIA* Capsloc

Flame / EXTRA EXTRA Read all about it..

Media / Vampire Weekend

Media / Did anyone watch......

Games / need name...

BF 1942 / who remembers.....

Help / SQL Multiple Table Inner Join

Spam / @bunhead or balth

Spam / a chat w/ phantom feat. balth talk

Media / mr. blue sky

Games / COMBAT ARMS

General / @ BALTHY

Graphics / Phantom's Comeback1!!!

BF 2 / uh.....

Media / LOL Bush LOL

Media / JFK Assasination Vid

MAFIA Forums

Topics - MAFIA Capsloc