Jump to content
QUADMACHINE

Salut RST

Recommended Posts

Salut utilizatori ai comunitatii RSTForum, numele meu este Claudiu si sunt nou pe aici.Totusi am rugamintea

sa nu incepeti cu maimutareala prin acest subiect, daca aveti de gand asa ceva va sugerez un logout.

Imi place foarte mult sa lucrez in Adobe Photoshop, momentan nu detin cunostinte despre Adobe Illustrator desi

ar cam trebui.Am fost interesat si de programare(PHP mai exact), ultimel proiect personale a fost un forum

asemanator cu PHPBB deoarece vroiam si eu sa fac asa ceva, pe urma am fost contactat de cineva pentru alt proiect.

Era vorba despre un site de tip Concurs(gen Frags/Wars s.a.m.d), din cate tin minte am luat 90 euro atunci(Nu era

o suma mare dar totusi tinand cont ca era primul proiect/client m-am descurcat de minune).

Nu am gasit o categorie unde sa postez astea si am zis sa le pun aici:

Recent:

O16mINZ.jpg

Pentru un amic.

10y9dKr.png

Giuliano Masterchef

Tqe9nt8.png

cRtP6xR.png

Ellen's Fashion

ellen__s_fashion_house_by_xquadmachine-d5rlfc9.png

FxoRBx5.png

sz0xj.png

Logo D.Ciprian

nOt8s.png

KT3AICu.png

Zombie Logo

YpxCe.png

Tutsgod

bXM93.png

GCL Logo

pytdn.png

a6Jj71R.png

q3gasSZ.png

O0ixSKQ.png

5ZfivgG.png

Carrefour

8MRFT.png

HolyLight Entertainment

1FBJQ.png

1Y1ni.png

6gR6t.png

8CZkGNI.png

Minecraft Club Banner

IaOe1.png

RockHard CoffeCup

hJUbU.png

Diamond City Logo

WoEwL.png

CoolTV

cooltv_ro_logo_by_xquadmachine-d5ozugu.png

Dessole

dessole_lp_by_xquadmachine-d5qa9ei.png

WIP Hosting template

sLg8Yp9.png

Link to comment
Share on other sites

Un proiect facut de mine acum 5 ani cu putin ajutor de la cei de pe PHPROMANIA.Sa imi spuneti cum vi se pare tinand cont ca eram si incepator.

Simple File Sharing and Storage. - parola arhiva: claudiu

Database:

--
-- Table structure for table `atasamente`
--

CREATE TABLE IF NOT EXISTS `atasamente` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`size` int(11) NOT NULL,
`content` mediumblob NOT NULL,
`atasat_topic` int(10) DEFAULT NULL,
`post` int(11) NOT NULL,
`user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
`cat_id` int(8) NOT NULL AUTO_INCREMENT,
`cat_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`cat_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`last_user_posted` int(11) NOT NULL,
`cat_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`cat_id`),
UNIQUE KEY `cat_name_unique` (`cat_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
`fid` int(11) NOT NULL AUTO_INCREMENT,
`friend` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`friendid` int(11) NOT NULL,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`accepted` int(11) DEFAULT NULL,
`denied` int(11) DEFAULT NULL,
`date` date NOT NULL,
PRIMARY KEY (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci NOT NULL,
`from` int(11) NOT NULL,
`to` int(11) NOT NULL,
`from_viewed` tinyint(1) NOT NULL DEFAULT '0',
`to_viewed` tinyint(1) NOT NULL DEFAULT '0',
`from_deleted` tinyint(1) NOT NULL DEFAULT '0',
`to_deleted` tinyint(1) NOT NULL DEFAULT '0',
`from_vdate` datetime DEFAULT NULL,
`to_vdate` datetime DEFAULT NULL,
`from_ddate` datetime DEFAULT NULL,
`to_ddate` datetime DEFAULT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Table structure for table `mod_actions`
--

CREATE TABLE IF NOT EXISTS `mod_actions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mod_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`action` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
`topic` int(255) NOT NULL,
`post` int(255) NOT NULL,
`user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=33 ;

--
-- Table structure for table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
`post_id` int(8) NOT NULL AUTO_INCREMENT,
`post_content` longtext CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
`post_date` datetime NOT NULL,
`post_topic` int(8) NOT NULL,
`post_by` int(8) NOT NULL,
`locked` int(12) NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=85 ;

--
-- Table structure for table `topics`
--

CREATE TABLE IF NOT EXISTS `topics` (
`topic_id` int(8) NOT NULL AUTO_INCREMENT,
`topic_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`topic_date` datetime NOT NULL,
`topic_cat` int(8) NOT NULL,
`topic_by` int(8) NOT NULL,
`topic_last_user` varchar(11) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
`topic_views` int(11) DEFAULT NULL,
`likes` int(11) NOT NULL,
`newold` int(7) NOT NULL,
`locked` varchar(12) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL,
PRIMARY KEY (`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(8) NOT NULL AUTO_INCREMENT,
`user_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`user_pass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`dob` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`user_date` datetime NOT NULL,
`user_level` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
`avatar_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`signature` longtext COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`puncte` int(10) NOT NULL,
`avertizari` int(2) DEFAULT '0',
`banned` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`views_profil` int(30) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name_unique` (`user_name`),
UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=37 ;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   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.



×
×
  • Create New...