Execute SQL and all that other stuff.

  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

I have a script I'm trying to install. PHP/MYSQL


I'm wondering if someone would be kind enough to assist me. I'd be like really really REALLY greatful.


This is what they're telling me to do:


If you have phpMyAdmin installed you can simply copy and paste the sql queries into the provided text area fields and submit the form.


And I have nooooo idea what they're talking about.


Anyone? :D :D :D :D
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • _Leo_
  • Proficient
  • Proficient
  • User avatar
  • Posts: 279
  • Loc: Buenos Aires, Argentina

Post 3+ Months Ago

Well, generic forums and content management systems usually are DataBase dependent for storing its data. MySQL is one of the most popular databases used in the net. If you are trying to install a forum or portal which requires MySQL, you need to create a database on a MySQL server. Once this database is created (empty) you need to populate it with the default data model. Usually provided as a text file in SQL langue.

phpMyAdmin is a front-end for managing MySQL databases, if your hosting provider uses it and gaves you access to such a control panel, you can populate the database copying the SQL to the phpMyAdmin query execution form.

Ok, now you have to provide a more detailed explanation here about your case.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

You're right. sorry for not providing a better explanation.


This is what they asked me to do. It's just that I don't know how to do it.



the database structure hasn't been
created. Please use the phpMyAdmin tool in the MySQL section
to execute the SQL dump

I have the sql file, but I don't know how to do the rest.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Also,

The script is a portal-like image rating script.



These are the errors I receive:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u5/nrevange/html/include/session.php on line 31

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/u5/nrevange/html/include/session.php:31) in /home/u5/nrevange/html/include/session.php on line 75

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/u5/nrevange/html/include/session.php:31) in /home/u5/nrevange/html/include/session.php on line 75

Warning: main(/home/u5/nrevange/html/include/): failed to open stream: Unknown error: 0 in /home/u5/nrevange/html/index.php on line 16

Warning: main(): Failed opening '/home/u5/nrevange/html/include/' for inclusion (include_path='.:') in /home/u5/nrevange/html/index.php on line 16

Fatal error: Call to undefined function: table() in /home/u5/nrevange/html/include/site_menu.php on line 36
Table 'nrevange.sessions' doesn't exist
  • _Leo_
  • Proficient
  • Proficient
  • User avatar
  • Posts: 279
  • Loc: Buenos Aires, Argentina

Post 3+ Months Ago

Ok, you need access to your database (creating it first if there is not database for you yet).

Where are you hosting? Does your service includes MySQL server?

Talk to your hosting provider. Ask him to create a database for you. He will give you a username and password. You will have to use it con configure your forum.

If you provider does not provides you with a MySQL control panel, you will like to use phpMyAdmin (download and install from the web, it is free)
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

It appears that you have the database already. In which case I assume you can see the name of it in the left frame in phpMyAdmin. At the bottom of that frame will be a link that says query window. Click that link. It will open a new window with a text field to execute the query. Copy and paste the contents of your sql file into the text field and click go. Close the window. Refresh your browser and your database structure should be there.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Quote:
Ok, you need access to your database (creating it first if there is not database for you yet).

Where are you hosting? Does your service includes MySQL server?

Talk to your hosting provider. Ask him to create a database for you. He will give you a username and password. You will have to use it con configure your forum.

If you provider does not provides you with a MySQL control panel, you will like to use phpMyAdmin (download and install from the web, it is free)



I created the database already, and my hosting services(aplus.net) allow me one database.


I called them for assistance, but they said they're not going to help me. They say all they can do is see if everything is working fine on their end.


The only think I have to do now(I think) is that sql thing.

I copy & pasted the whole file into the text area in phpmyadmin, but it says there's an error:


"You have an error in your SQL syntax near '; drop table if exists comments; drop table if exists pms; drop table if exis' at line 8"
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Elliminate all the lines that say drop table if exists and run the query again (That is assuming your database is currently empty.)
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Quote:
Elliminate all the lines that say drop table if exists and run the query again (That is assuming your database is currently empty.)




Hello,

I removed the lines, but I'm getting another error.


You have an error in your SQL syntax near '; # # Dumping data for table `admin` # INSERT INTO admin VALUES (1, 'adm' at line 14


I'm wondering if I should remove this those lines also?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

That may not be a good idea, given that it is related to admin stuff. I'm going to assume that the sql file is too large to copy and paste here. Send it to me at the email I gave you in PM and I'll review it so I can give you better instructions.
  • _Leo_
  • Proficient
  • Proficient
  • User avatar
  • Posts: 279
  • Loc: Buenos Aires, Argentina

Post 3+ Months Ago

Post the whole SQL file here, just as you are copying to the form.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Leo -- I would rather he not. This morning I just did a similar thing with phpBB at another site and that sql file is 15000+ lines long. I would seriously not have him post a sql dump at the board.

P.S. if you think you can assist him in solving his problem, give him your email addy in PM like I did so he can send it to you as well. Two eyes are better than one.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

I got your mail and am looking at the file. Not quite sure what you are doing, but I just installed it in like about 10 seconds as is. Give me a few minutes to think about the instructions so you can get it too. I'll post again shortly. For what it's worth your sql text file is perfect as is. (or at least as the one you sent me.)
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Let's start from ground zero. Log out of all your admin stuff. close your browser windows and start from scratch. Log in again and go to phpMyAdmin. By default, your database name will show in the left window. There should not be any tables in it. If there are, it's because some of your experimental queries were successful. If that's the case let's delete those to start with a clean database. If you click on the database name, you'll see a list of any tables that exist in the right frame. Beside those will be a set of "actions" click "drop" for each table. It will give you a warning. Just accept them and delete them all.

Click the database name again in the left frame. In the right frame you should have a fairly large field where you can copy and paste or write queries. Skip that one. Just below it will be a smaller field for the "location of the text file". Click the browse button and browse to the text file you sent me. Once you've selected it, click go. In less than a second your query should be executed perfectly and the left frame should update itself and show the table structure.

After that, I leave it to you to begin to learn how to really use this tool:

http://www.phpmyadmin.net/documentation/
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

I followed everything step by step. The only problem , there's no browse option, so my only option is to copy & paste. I do know what browse button you're talking about, because I've seen it in the other hosting service I was using.


I went ahead and copy & pasted and I'm still receiving errors.


I will just continue to try, as well as read the info in the link you provided.

Thank You so much for your help.

Nahdej
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

*lol -- no browse option? Are you kidding? Man what version of phpMyAdmin are they using? *sorry -- OK -- you conned me into it. Send me the link and access stuff to the email. Now I'm not doing it just to help you -- I'm curious as heck to see what kind of setup they have. If they have a screwed up version I'll let you know. Otherwise, I'll tell you how to do it however they have it set up.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Sorry -- I don't want you to think I'm laughing at you. I just want to see this. phpMyAdmin is about the easiest mySQL admin tool there is. I'm just curious to see what the heck they are doing. It shouldn't be this difficult for you.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Interesting. I get the same errors you do on a copy and paste.. And that is most definitely not phpMyAdmin -- at least not anyway I've ever seen it. Let me take a screen shot and post the link so others can see it in case some may be familiar with it. Theoretically your text file should work as is.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Here's the screen shot of what he/she sees and what I get too when running a text query (c&p)

http://atnopro.com/ozzu/screencap.jpg

I haven't seen this setup yet. Really odd. I used the exact same file and had the tables set up on my db in less than a second on the query with phpMyAdmin. Now I have to think about this one too.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Hmmm, Interesting!


Well, I may have to change host then, because I seriously need this script.


Bummer for me.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Maybe it's an old version....?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

The sql text file is not as large as I expected. I can't see anything wrong with it. I get exactly the same errors nunyaB does with this host, but had it executed in 1 second as expected on mine. Here's the dump:

Code: [ Select ]
# Database : `irater`
# --------------------------------------------------------

#
# Table structure for table `admin`
#

drop table if exists admin;
drop table if exists comments;
drop table if exists pms;
drop table if exists std_notify;
drop table if exists ratings;
drop table if exists sessions;
drop table if exists settings;
drop table if exists templates;
drop table if exists users;
drop table if exists image_types;
drop table if exists usersTemp;

CREATE TABLE admin (
 id tinyint(4) NOT NULL auto_increment,
 username char(16) NOT NULL default '',
 password char(32) NOT NULL default '',
 PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `admin`
#

INSERT INTO admin VALUES (1, 'admin', 'password');
# --------------------------------------------------------

#
# Table structure for table `comments`
#

CREATE TABLE comments (
 id int(7) unsigned NOT NULL auto_increment,
 user_id smallint(5) unsigned NOT NULL default '0',
 comment text NOT NULL,
 author_id smallint(5) NOT NULL default '0',
 author_ip varchar(15) NOT NULL default '',
 status varchar(16) NOT NULL default 'waiting',
 timestamp timestamp(14) NOT NULL,
 PRIMARY KEY (id),
 KEY timestamp (timestamp),
 KEY user_id (user_id)
) TYPE=MyISAM;

#
# Dumping data for table `comments`
#

#
# Table structure for table `image_types`
#

CREATE TABLE image_types (
 id tinyint(3) unsigned NOT NULL auto_increment,
 ext char(4) NOT NULL default '',
 PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `image_types`
#

INSERT INTO image_types VALUES (1, 'bmp');
INSERT INTO image_types VALUES (2, 'gif');
INSERT INTO image_types VALUES (3, 'jpg');
INSERT INTO image_types VALUES (4, 'jpeg');
INSERT INTO image_types VALUES (5, 'png');
# --------------------------------------------------------

#
# Table structure for table `pms`
#

CREATE TABLE pms (
 id int(7) unsigned NOT NULL auto_increment,
 user_id smallint(5) unsigned NOT NULL default '0',
 subject varchar(50) NOT NULL default '',
 message text NOT NULL,
 author_id smallint(5) NOT NULL default '0',
 author_ip varchar(15) NOT NULL default '',
 pm_status varchar(16) NOT NULL default 'unread',
 timestamp timestamp(14) NOT NULL,
 PRIMARY KEY (id),
 KEY timestamp (timestamp),
 KEY user_id (user_id)
) TYPE=MyISAM;

#
# Dumping data for table `pms`
#

#
# Table structure for table `ratings`
#

CREATE TABLE ratings (
 id int(7) unsigned NOT NULL auto_increment,
 user_id smallint(5) unsigned NOT NULL default '0',
 rating tinyint(1) unsigned NOT NULL default '0',
 rater_id smallint(5) NOT NULL default '0',
 rater_ip char(15) NOT NULL default '',
 timestamp timestamp(14) NOT NULL,
 PRIMARY KEY (id),
 KEY timestamp (timestamp),
 KEY user_id (user_id)
) TYPE=MyISAM;

#
# Dumping data for table `ratings`
#

#
# Table structure for table `sessions`
#

CREATE TABLE sessions (
 id varchar(32) NOT NULL default '',
 data text NOT NULL,
 expire int(11) unsigned NOT NULL default '0',
 PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `sessions`
#

#
# Table structure for table `settings`
#

CREATE TABLE settings (
 orderby tinyint(3) unsigned NOT NULL default '0',
 name varchar(24) NOT NULL default '',
 setting varchar(255) NOT NULL default '',
 descr varchar(255) NOT NULL default '',
 PRIMARY KEY (name)
) TYPE=MyISAM;

#
# Dumping data for table `settings`
#

INSERT INTO settings VALUES (105, 'max_image_size', '102400', 'This is the maximum size an image file can be, this applies to locally stored images only.');
INSERT INTO settings VALUES (160, 'np', '3', 'The number of navigation links you want dispayed on each side of the current member page. 3 or 4 is probably best.');
INSERT INTO settings VALUES (80, 'table_border_color', 'yellow', 'This affects the outer table border. See include/tables.php for more info.');
INSERT INTO settings VALUES (65, 'table_title_color', 'black', 'This affects the table title bar background color. See include/tables.php for more info.');
INSERT INTO settings VALUES (75, 'table_content_color', 'white', 'This affects the color of the table body. See include/tables.php for more info.');
INSERT INTO settings VALUES (85, 'page_bg_color', '#ffffff', 'Overall page background color.');
INSERT INTO settings VALUES (50, 'title_img', 'images/logo.jpg', 'This is the relative path to the main title image that appears on the main page.');
INSERT INTO settings VALUES (55, 'tb_header_img', 'images/bar.gif', 'This is the image used for the table header background. See also \'table_title_color\'.');
INSERT INTO settings VALUES (15, 'base_font', 'Tahoma, Verdana, sans-serif', 'General font face.');
INSERT INTO settings VALUES (20, 'base_font_size', '13', 'General font size in pixels, 11-15 is probably best.');
INSERT INTO settings VALUES (25, 'base_font_color', 'black', 'General site font color.');
INSERT INTO settings VALUES (30, 'base_link_color', 'black', 'General link color.');
INSERT INTO settings VALUES (35, 'hover_link_color', 'yellow', 'Hover link color.');
INSERT INTO settings VALUES (40, 'hover_link_bg_color', '#333366', 'Hover link background color.');
INSERT INTO settings VALUES (70, 'table_title_text_color', '#333366', 'This is the font color for the table headers.');
INSERT INTO settings VALUES (45, 'error_font_color', 'red', 'General error font color.');
INSERT INTO settings VALUES (10, 'site_title', 'irater', 'The name of your irater based site.');
INSERT INTO settings VALUES (165, 'speed_rate', '1', 'If set to yes, this adds a 2 second <meta> refresh to the rating thank you page. You probably want this.');
INSERT INTO settings VALUES (150, 'girl_count', '10', 'How many girls to list in the mini-list.');
INSERT INTO settings VALUES (155, 'guy_count', '10', 'How many guys to list in the mini-list.');
INSERT INTO settings VALUES (135, 'show_site_stats', '1', 'If set to yes, this causes the site stats to be shown. You probably want this. Site stats can be further customized by editing the proper template.');
INSERT INTO settings VALUES (140, 'girl_t', '1', 'If set to yes, this causes the girl\'s mini-list to be displayed.');
INSERT INTO settings VALUES (145, 'guy_t', '1', 'If set to yes, this causes the guy\'s mini-list to be displayed.');
INSERT INTO settings VALUES (60, 'table_file', 'tables.gray.php', 'What table theme you want to use.');
INSERT INTO settings VALUES (90, 'left_col_width', '156', 'This is the width of the left column in pixels.');
INSERT INTO settings VALUES (95, 'right_col_width', '156', 'This is the width of the right column in pixels.');
INSERT INTO settings VALUES (100, 'main_col_width', '658', 'This is the width of the main column in pixels.');
INSERT INTO settings VALUES (120, 'allow_local_image', '1', 'This setting controls whether or not you allow users to store their images locally on your server.');
INSERT INTO settings VALUES (125, 'allow_remote_image', '1', 'This setting controls whether or not you allow users to store their images on their own remote server.');
INSERT INTO settings VALUES (170, 'max_un_length', '14', 'This setting is for chopping the username\'s length down so it doesn\'t overrun the table width in the mini toplists at the top-right.');
INSERT INTO settings VALUES (130, 'comments_per_page', '10', 'This setting is for setting a maximum number of comments per page on your view comments page.');
INSERT INTO settings VALUES (110, 'max_image_width', '640', 'This is the maximum width an image file can be, this applies to locally stored images only.');
INSERT INTO settings VALUES (115, 'max_image_height', '640', 'This is the maximum height an image file can be, this applies to locally stored images only.');
INSERT INTO settings VALUES (180, 'is_free', 'yes', 'change this to "no" if you want to charge a subscription fee to your site. You will have to change the values in the /includes/signup.php file to your paypal account');
# --------------------------------------------------------

#
# Table structure for table `std_notify`
#

CREATE TABLE std_notify (
 ipn_id int(10) NOT NULL auto_increment,
 receiver_email varchar(75) NOT NULL default '',
 business varchar(75) NOT NULL default '',
 item_name varchar(127) default NULL,
 item_number varchar(127) default NULL,
 quantity int(10) default NULL,
 invoice varchar(64) default NULL,
 custom varchar(64) default NULL,
 option_name1 varchar(127) default NULL,
 option_selection1 varchar(127) default NULL,
 option_name2 varchar(127) default NULL,
 option_selection2 varchar(127) default NULL,
 num_cart_items int(10) default NULL,
 payment_status enum('Completed','Pending','Failed','Denied','Reversed') default NULL,
 pending_reason enum('echeck','intl','verify','address','upgrade','unilateral','other') default NULL,
 payment_date varchar(55) default NULL,
 settle_amount decimal(9,2) default NULL,
 settle_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
 exchange_rate varchar(15) default NULL,
 payment_gross decimal(9,2) default NULL,
 payment_fee decimal(9,2) default NULL,
 mc_gross decimal(9,2) default NULL,
 mc_fee decimal(9,2) default NULL,
 mc_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
 tax decimal(9,2) default NULL,
 txn_id varchar(50) default NULL,
 txn_type enum('web_accept','cart','send_money') default NULL,
 memo tinytext,
 first_name varchar(32) default NULL,
 last_name varchar(32) default NULL,
 address_street varchar(64) default NULL,
 address_city varchar(32) default NULL,
 address_state varchar(32) default NULL,
 address_zip varchar(25) default NULL,
 address_country varchar(32) default NULL,
 address_status enum('confirmed','unconfirmed') default NULL,
 payer_email varchar(75) default NULL,
 payer_id varchar(60) default NULL,
 payer_status enum('verified','unverified','intl_verified','intl_unverified') default NULL,
 payment_type enum('echeck','instant') default NULL,
 notify_version varchar(10) default NULL,
 verify_sign varchar(128) default NULL,
 status enum('VERIFIED','INVALID') default NULL,
 signed enum('SIGNEDUP','FREE') default NULL,
 user_ID int(10) default '0',
 PRIMARY KEY (ipn_id)
) TYPE=MyISAM;

#
# Dumping data for table `std_notify`
#

#
# Table structure for table `templates`
#

CREATE TABLE templates (
 id tinyint(4) unsigned NOT NULL auto_increment,
 name varchar(16) NOT NULL default '',
 template text NOT NULL,
 PRIMARY KEY (id),
 UNIQUE KEY name (name)
) TYPE=MyISAM;

#
# Dumping data for table `templates`
#

INSERT INTO templates VALUES (1, 'main_text', '<table border="0" cellpadding="5" cellspacing="0" width="100%">\r\n<tr>\r\n<td width="100%" class="regular"><img src="$base_url/$title_img" border="0" alt="$title" title="$title" /></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular">Welcome to <a href="$base_url/index.php?$sn=$sid">$site_title</a>.  Here you can upload your picture and have others view it and rate it.  It\'s a great way to meet new people too.  Not only can you rate other member\'s pictures, you can also leave private messages and comments too!  Best of all, membership is totally Free!  <a href="$base_url/index.php?$sn=$sid&show=signup">Signup now</a> and join the fun!\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"><span class="bold">How it works:</span> You <a href="$base_url/index.php?$sn=$sid&show=signup">signup</a> and become a member. Once signed up you can upload your image. You may also link to your image if you already have it on!
another server. Once your image is approved by us, it will begin to appear on the site. Visitors will view your image and rate it depending on their own personal opinion. Visitors may also leave public comments about you, and some may even decide to leave you a private message.</td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"><span class="bold">Rules:</span> No porn allowed! This means no "naked pictures" allowed. All images are approved by us before being shown on the site. If you upload porn we will delete it. If you link to porn we will delete it. This is an "all ages" site so keep it clean! To keep the site as fast as possible, all images must be smaller than $max_image_size bytes in filesize.<br /><br /><a href="$base_url/index.php?$sn=$sid&show=signup"><b>CLICK HERE TO SIGNUP NOW!</b></a><br><br></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="smallregular" align="right">Designed for 1024x76!
8 resolution, 24bit color or better</td>\r\n</tr>\r\n</table>');
INSERT INTO templates VALUES (2, 'image_rules', '<ul>\r\n<li class="regular">No porn allowed! This means no "naked pictures". All images are approved by us before being shown on the site. If you upload or link to porn we will delete it.</li>\r\n<li class="regular">To keep the site as fast as possible, all images must be smaller than $max_image_size bytes in filesize.</li>\r\n<li class="regular">Both new image uploads and new image URLs cause image statistics to be reset. Make sure you are ready to start over if you decide to update an already highly rated image. We can not recover accidentally overwritten images.</li>\r\n</ul>');
INSERT INTO templates VALUES (3, 'site_stats', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Points:</td>\n    <td align="right" class="smallregular">$pts_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points Today:</td>\n    <td align="right" class="smallregular">$pts_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points this Week:</td>\n    <td align="right" class="smallregular">$pts_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points this Month:</td>\n    <td align="right" class="smallregular">$pts_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Ratings:</td>\n    <td align="right" class="smallregular">$ra_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Ratings Today:</td>\n    <td align="right" class="smallregular">$ra_pd_count</td>\n</tr>\n<tr>\n    <td clas!
s="smallregular" nowrap="nowrap">Ratings this Week:</td>\n    <td align="right" class="smallregular">$ra_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Ratings this Month:</td>\n    <td align="right" class="smallregular">$ra_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Comments:</td>\n    <td align="right" class="smallregular">$cm_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments Today:</td>\n    <td align="right" class="smallregular">$cm_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments this Week:</td>\n    <td align="right" class="smallregular">$cm_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments this Month:</td>\n    <td align="right" class="smallregular">$cm_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Members:</td>\n    <td align="right" class="smallregular">$su_total_count</td>\n</!
tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups Today:</td>\n    <td align="right" class="smallregular">$su_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups this Week:</td>\n    <td align="right" class="smallregular">$su_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups this Month:</td>\n    <td align="right" class="smallregular">$su_pm_count</td>\n</tr>\n</table>');
INSERT INTO templates VALUES (4, 'visitors_online', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular">&nbsp;Visitors Online:</td>\n    <td align="right" class="regular">$uo_total&nbsp;</td>\n</tr>\n</table>');
INSERT INTO templates VALUES (5, 'logged_in', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\r\n<tr>\r\n    <td width="100%" class="regular" align="right">Welcome $username<br /><a href="$base_url/logout.php?$sn=$sid" target="_top">Logout</a></td>\r\n</tr>\r\n</table>');
INSERT INTO templates VALUES (6, 'logged_out', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\r\n<tr><form method="post" action="$base_url/login.php?$sn=$sid">\r\n    <td width="100%" class="regular" align="right">username:<br /><input type="text" name="UN" size="12" value="" /><br />password:<br /><input type="password" name="PW" size="12" value="" /><br />\r\n    <table cellpadding="0" cellspacing="1" border="0" width="100%">\r\n    <tr>\r\n        <td valign="bottom" nowrap="nowrap"><a href="$base_url/index.php?$sn=$sid&show=lost" target="_top" class="small">Lost<br />Password</a></td>\r\n        <td align="right" valign="bottom"><input class="button" type="submit" name="login" value="Go ->" /></td>\r\n    </tr>\r\n    </table>\r\n    </td>\r\n</form></tr>\r\n</table>');
INSERT INTO templates VALUES (7, 'about_member', '<table cellpadding="5" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular"><a name="profile" class="bold">Average Rating: </a>$array[average_rating]</td>\n    <td class="regular"><span class="bold">Total Points: </span>$array[total_points]</td>\n    <td class="regular" align="right"><span class="bold">Times Rated: </span>$array[total_ratings]</td>\n</tr>\n</table>\n<table cellpadding="5" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular" width="50%"><span class="bold">Name: </span>$array[user_name]</td>\n    <td class="regular" width="50%"><span class="bold">Age: </span>$array[age]</td>\n</tr>\n<tr>\n    <td class="regular" width="100%" colspan="2"><span class="bold">Description: </span>$array[description]</td>\n</tr>\n<tr>\n    <td class="regular" width="50%"><span class="bold">State/Province: </span>$array[state]</td>\n    <td class="regular" class="50%"><span class="bold">Country: </span><img align="top" b!
order="1" src="$base_url/images/flags/$array[country]" hspace="5" alt="$country title="$country" />$country</td>\n</tr>\n<tr>\n    <td class="regular" width=(%"><span class="bold">URL: </span><a href="$array[url]" target="_blank">$array[url]</a></td>\n    <td class="regular" width="50%"><span class="bold">Quote: </span><i>&quot;$array[quote]&quot;</i></td>\n</tr>\n</table>');
INSERT INTO templates VALUES (8, 'img_src', '<table cellpadding="1" cellspacing="0" border="0" bgcolor="black">\r\n<tr>\r\n    <td bgcolor="black"><img src="$image_src"></td>\r\n</tr>\r\n</table>');
INSERT INTO templates VALUES (9, 'comment', '<table cellpadding="2" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular" width="100%" colspan="2">On $d, $user_link wrote:</td>\n</tr>\n<tr>\n    <td width="1%">&nbsp;</td>\n    <td colspan="2" class="regular" width="99%">$gc_array[comment]</td>\n</tr>\n</table>');
INSERT INTO templates VALUES (10, 'copyright', 'Copyright © 2002 <a class="small" href="$base_url/index.php?$sn=$sid" target="_top">$site_title</a> - All Rights Reserved');
INSERT INTO templates VALUES (11, 'styles', '<style type="text/css">\nBODY {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:active {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:visited {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:hover {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background-color: $hover_link_bg_color;\n}\na.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:active.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:visited.small {\n    font-family: $base_font;\n    font!
-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:hover.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background-color: $hover_link_bg_color;\n}\na:il.hover {\n    background-color: transparent;\n}\n.title {\n    font-family: $base_font;\n    font-size: $large_font;\n    font-weight: bold;\n    color: $table_title_text_color;\n}\n.regular {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n.selectedNav {\n    font-family: $base_font_color;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background: $hover_link_bg_color;\n}\n.bold {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: bold;\n    color: $base_font_color;\n}\n.smallregular {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n.error {\n    font-family: $base_font;\n    font-size: $medium!
_font;\n    font-weight: normal;\n    color: $error_font_color;\n}\n.tb_header {\n    color: $table_title_text_color;\n    background-color: $table_title_color;\n    background: url("$base_url/$tb_header_img");\n    background-repeat: repeat-x;\n}\ninput, textarea, select {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n\n.gray_top_middle {\nbackground: url("$base_url/images/gray_top_middle.gif") repeat-x;\n    height: 18px;\n}\n.gray_middle_fill {\n    background: url("$base_url/images/gray_middle_fill.gif") repeat-x;\n    height: 1px;\n}\n.gray_title_left {\n    background: url("$base_url/images/gray_left_title.gif") repeat-y;\n}\n.gray_title_right {\n    background: url("$base_url/images/gray_right_title.gif") repeat-y;\n}\n.gray_left_body {\n    background: url("$base_url/images/gray_left_body.gif") repeat-y;\n}\n.gray_right_body {\n    background: url("$base_url/images/gray_right_body.gif") repeat-y;\n}\n.gray_bottom_middle {\n    background: url("$ba!
se_url/images/gray_bottom_middle.gif") repeat-x;\n}\n</style>');
INSERT INTO templates VALUES (12, 'doc_head', '<!DOCTYPE html \r\nPUBLIC "-//W3C//DTD XHTML 1.0\n    Transitional//EN"\r\n"DTD/xhtml1-transitional.dtd">\n<html>\n<head>\n<title> .: $site_title :.</title>\n<meta name="keywords" content="place,keywords,here" />\n<meta name="description" content="irater is a highly advanced PHP Script which allows you to enhance your site by adding an upload and rate me section." />\n<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />');
INSERT INTO templates VALUES (13, 'body_tag', '<body bgcolor="$page_bg_color">\r\n<center><img src="banner.jpg" width="468" height="60" border="0" alt="irater" title="irater" vspace="2"></a></center>');
INSERT INTO templates VALUES (14, 'lost_pass_form', '<table border="0" cellpadding="3" cellspacing="0" width="100%">\n<tr>\n    <td width="100%" class="regular" align="center"><br />Enter your Username or Email Address<br />and we will send you your Password Hint.<br /><br /></td>\n</tr>\n<form method="post" action="$base_url/index.php?$sn=$sid&amp;show=lost&amp;search=1">\n<tr>\n    <td width="100%" class="regular" align="center">Username: <input type="text" name="search_username" size="16" value="" />&nbsp;<input class="button" type="submit" name="lost_username" value="Search ->" /><br /></form><form method="post" action="$base_url/index.php?$sn=$sid&amp;show=lost&amp;search=1">Email Address: <input type="lost_email" name="search_email" size="24" value="" />&nbsp;<input class="button" type="submit" name="lost_email" value="Search ->" /><br /><br /></td>\n</tr>\n</form>\n</table>');
INSERT INTO templates VALUES (15, 'comment_list', '<table cellpadding="2" cellspacing="0" border="0" width="100%">\r\n<tr>\r\n    <td class="regular" width="100%" colspan="2">On $d, $user_link left a comment for $member_link:</td>\r\n</tr>\r\n<tr>\r\n    <td width="1%"> </td>\r\n    <td colspan="2" class="regular" width="99%">$gc_array[comment]</td>\r\n</tr>\r\n</table>');
INSERT INTO templates VALUES (16, 'direct_link', '<table cellpadding="2" cellspacing="0" border="0">\r\n<tr><form>\r\n<td class="regular">Link to this page: </td>\r\n<td class="regular"><input type="text" value="$base_url/?i=$array[id]" size="42" readonly onFocus="select()" onSelect="select()"></td>\r\n</form></tr>\r\n</table>');
# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE users (
 id smallint(5) unsigned NOT NULL auto_increment,
 username varchar(16) NOT NULL default '',
 password varchar(16) NOT NULL default '',
 hint varchar(100) NOT NULL default '',
 realname varchar(48) NOT NULL default '',
 description text NOT NULL,
 age tinyint(2) unsigned NOT NULL default '0',
 sex enum('m','f') NOT NULL default 'm',
 state varchar(32) NOT NULL default '',
 country varchar(32) NOT NULL default 'United_States.gif',
 email varchar(48) NOT NULL default '',
 url varchar(255) NOT NULL default '',
 quote varchar(255) NOT NULL default '',
 image enum('here','there') NOT NULL default 'there',
 image_url varchar(144) NOT NULL default '',
 image_ext varchar(4) NOT NULL default '',
 image_status enum('-1','0','1') NOT NULL default '-1',
 total_ratings smallint(5) unsigned NOT NULL default '0',
 total_points mediumint(9) unsigned NOT NULL default '0',
 average_rating decimal(6,4) NOT NULL default '0.0000',
 total_comments int(10) unsigned NOT NULL default '0',
 signup varchar(14) NOT NULL default '',
 timestamp timestamp(14) NOT NULL,
 PRIMARY KEY (id),
 KEY sex (sex),
 KEY timestamp (timestamp),
 KEY signup (signup),
 KEY username (username),
 KEY email (email)
) TYPE=MyISAM;

#
# Dumping data for table `users`
#

#
# Table structure for table `usersTemp`
#

CREATE TABLE usersTemp (
 id smallint(5) unsigned NOT NULL auto_increment,
 username varchar(16) NOT NULL default '',
 password varchar(16) NOT NULL default '',
 hint varchar(100) NOT NULL default '',
 realname varchar(48) NOT NULL default '',
 description text NOT NULL,
 age tinyint(2) unsigned NOT NULL default '0',
 sex enum('m','f') NOT NULL default 'm',
 state varchar(32) NOT NULL default '',
 country varchar(32) NOT NULL default 'United_States.gif',
 email varchar(48) NOT NULL default '',
 url varchar(255) NOT NULL default '',
 quote varchar(255) NOT NULL default '',
 image enum('here','there') NOT NULL default 'there',
 image_url varchar(144) NOT NULL default '',
 image_ext varchar(4) NOT NULL default '',
 image_status enum('-1','0','1') NOT NULL default '-1',
 total_ratings smallint(5) unsigned NOT NULL default '0',
 total_points mediumint(9) unsigned NOT NULL default '0',
 average_rating decimal(6,4) NOT NULL default '0.0000',
 total_comments int(10) unsigned NOT NULL default '0',
 signup varchar(14) NOT NULL default '',
 timestamp timestamp(14) NOT NULL,
 PRIMARY KEY (id),
 KEY sex (sex),
 KEY timestamp (timestamp),
 KEY signup (signup),
 KEY username (username),
 KEY email (email)
) TYPE=MyISAM;

#
# Dumping data for table `usersTemp`
#
  1. # Database : `irater`
  2. # --------------------------------------------------------
  3. #
  4. # Table structure for table `admin`
  5. #
  6. drop table if exists admin;
  7. drop table if exists comments;
  8. drop table if exists pms;
  9. drop table if exists std_notify;
  10. drop table if exists ratings;
  11. drop table if exists sessions;
  12. drop table if exists settings;
  13. drop table if exists templates;
  14. drop table if exists users;
  15. drop table if exists image_types;
  16. drop table if exists usersTemp;
  17. CREATE TABLE admin (
  18.  id tinyint(4) NOT NULL auto_increment,
  19.  username char(16) NOT NULL default '',
  20.  password char(32) NOT NULL default '',
  21.  PRIMARY KEY (id)
  22. ) TYPE=MyISAM;
  23. #
  24. # Dumping data for table `admin`
  25. #
  26. INSERT INTO admin VALUES (1, 'admin', 'password');
  27. # --------------------------------------------------------
  28. #
  29. # Table structure for table `comments`
  30. #
  31. CREATE TABLE comments (
  32.  id int(7) unsigned NOT NULL auto_increment,
  33.  user_id smallint(5) unsigned NOT NULL default '0',
  34.  comment text NOT NULL,
  35.  author_id smallint(5) NOT NULL default '0',
  36.  author_ip varchar(15) NOT NULL default '',
  37.  status varchar(16) NOT NULL default 'waiting',
  38.  timestamp timestamp(14) NOT NULL,
  39.  PRIMARY KEY (id),
  40.  KEY timestamp (timestamp),
  41.  KEY user_id (user_id)
  42. ) TYPE=MyISAM;
  43. #
  44. # Dumping data for table `comments`
  45. #
  46. #
  47. # Table structure for table `image_types`
  48. #
  49. CREATE TABLE image_types (
  50.  id tinyint(3) unsigned NOT NULL auto_increment,
  51.  ext char(4) NOT NULL default '',
  52.  PRIMARY KEY (id)
  53. ) TYPE=MyISAM;
  54. #
  55. # Dumping data for table `image_types`
  56. #
  57. INSERT INTO image_types VALUES (1, 'bmp');
  58. INSERT INTO image_types VALUES (2, 'gif');
  59. INSERT INTO image_types VALUES (3, 'jpg');
  60. INSERT INTO image_types VALUES (4, 'jpeg');
  61. INSERT INTO image_types VALUES (5, 'png');
  62. # --------------------------------------------------------
  63. #
  64. # Table structure for table `pms`
  65. #
  66. CREATE TABLE pms (
  67.  id int(7) unsigned NOT NULL auto_increment,
  68.  user_id smallint(5) unsigned NOT NULL default '0',
  69.  subject varchar(50) NOT NULL default '',
  70.  message text NOT NULL,
  71.  author_id smallint(5) NOT NULL default '0',
  72.  author_ip varchar(15) NOT NULL default '',
  73.  pm_status varchar(16) NOT NULL default 'unread',
  74.  timestamp timestamp(14) NOT NULL,
  75.  PRIMARY KEY (id),
  76.  KEY timestamp (timestamp),
  77.  KEY user_id (user_id)
  78. ) TYPE=MyISAM;
  79. #
  80. # Dumping data for table `pms`
  81. #
  82. #
  83. # Table structure for table `ratings`
  84. #
  85. CREATE TABLE ratings (
  86.  id int(7) unsigned NOT NULL auto_increment,
  87.  user_id smallint(5) unsigned NOT NULL default '0',
  88.  rating tinyint(1) unsigned NOT NULL default '0',
  89.  rater_id smallint(5) NOT NULL default '0',
  90.  rater_ip char(15) NOT NULL default '',
  91.  timestamp timestamp(14) NOT NULL,
  92.  PRIMARY KEY (id),
  93.  KEY timestamp (timestamp),
  94.  KEY user_id (user_id)
  95. ) TYPE=MyISAM;
  96. #
  97. # Dumping data for table `ratings`
  98. #
  99. #
  100. # Table structure for table `sessions`
  101. #
  102. CREATE TABLE sessions (
  103.  id varchar(32) NOT NULL default '',
  104.  data text NOT NULL,
  105.  expire int(11) unsigned NOT NULL default '0',
  106.  PRIMARY KEY (id)
  107. ) TYPE=MyISAM;
  108. #
  109. # Dumping data for table `sessions`
  110. #
  111. #
  112. # Table structure for table `settings`
  113. #
  114. CREATE TABLE settings (
  115.  orderby tinyint(3) unsigned NOT NULL default '0',
  116.  name varchar(24) NOT NULL default '',
  117.  setting varchar(255) NOT NULL default '',
  118.  descr varchar(255) NOT NULL default '',
  119.  PRIMARY KEY (name)
  120. ) TYPE=MyISAM;
  121. #
  122. # Dumping data for table `settings`
  123. #
  124. INSERT INTO settings VALUES (105, 'max_image_size', '102400', 'This is the maximum size an image file can be, this applies to locally stored images only.');
  125. INSERT INTO settings VALUES (160, 'np', '3', 'The number of navigation links you want dispayed on each side of the current member page. 3 or 4 is probably best.');
  126. INSERT INTO settings VALUES (80, 'table_border_color', 'yellow', 'This affects the outer table border. See include/tables.php for more info.');
  127. INSERT INTO settings VALUES (65, 'table_title_color', 'black', 'This affects the table title bar background color. See include/tables.php for more info.');
  128. INSERT INTO settings VALUES (75, 'table_content_color', 'white', 'This affects the color of the table body. See include/tables.php for more info.');
  129. INSERT INTO settings VALUES (85, 'page_bg_color', '#ffffff', 'Overall page background color.');
  130. INSERT INTO settings VALUES (50, 'title_img', 'images/logo.jpg', 'This is the relative path to the main title image that appears on the main page.');
  131. INSERT INTO settings VALUES (55, 'tb_header_img', 'images/bar.gif', 'This is the image used for the table header background. See also \'table_title_color\'.');
  132. INSERT INTO settings VALUES (15, 'base_font', 'Tahoma, Verdana, sans-serif', 'General font face.');
  133. INSERT INTO settings VALUES (20, 'base_font_size', '13', 'General font size in pixels, 11-15 is probably best.');
  134. INSERT INTO settings VALUES (25, 'base_font_color', 'black', 'General site font color.');
  135. INSERT INTO settings VALUES (30, 'base_link_color', 'black', 'General link color.');
  136. INSERT INTO settings VALUES (35, 'hover_link_color', 'yellow', 'Hover link color.');
  137. INSERT INTO settings VALUES (40, 'hover_link_bg_color', '#333366', 'Hover link background color.');
  138. INSERT INTO settings VALUES (70, 'table_title_text_color', '#333366', 'This is the font color for the table headers.');
  139. INSERT INTO settings VALUES (45, 'error_font_color', 'red', 'General error font color.');
  140. INSERT INTO settings VALUES (10, 'site_title', 'irater', 'The name of your irater based site.');
  141. INSERT INTO settings VALUES (165, 'speed_rate', '1', 'If set to yes, this adds a 2 second <meta> refresh to the rating thank you page. You probably want this.');
  142. INSERT INTO settings VALUES (150, 'girl_count', '10', 'How many girls to list in the mini-list.');
  143. INSERT INTO settings VALUES (155, 'guy_count', '10', 'How many guys to list in the mini-list.');
  144. INSERT INTO settings VALUES (135, 'show_site_stats', '1', 'If set to yes, this causes the site stats to be shown. You probably want this. Site stats can be further customized by editing the proper template.');
  145. INSERT INTO settings VALUES (140, 'girl_t', '1', 'If set to yes, this causes the girl\'s mini-list to be displayed.');
  146. INSERT INTO settings VALUES (145, 'guy_t', '1', 'If set to yes, this causes the guy\'s mini-list to be displayed.');
  147. INSERT INTO settings VALUES (60, 'table_file', 'tables.gray.php', 'What table theme you want to use.');
  148. INSERT INTO settings VALUES (90, 'left_col_width', '156', 'This is the width of the left column in pixels.');
  149. INSERT INTO settings VALUES (95, 'right_col_width', '156', 'This is the width of the right column in pixels.');
  150. INSERT INTO settings VALUES (100, 'main_col_width', '658', 'This is the width of the main column in pixels.');
  151. INSERT INTO settings VALUES (120, 'allow_local_image', '1', 'This setting controls whether or not you allow users to store their images locally on your server.');
  152. INSERT INTO settings VALUES (125, 'allow_remote_image', '1', 'This setting controls whether or not you allow users to store their images on their own remote server.');
  153. INSERT INTO settings VALUES (170, 'max_un_length', '14', 'This setting is for chopping the username\'s length down so it doesn\'t overrun the table width in the mini toplists at the top-right.');
  154. INSERT INTO settings VALUES (130, 'comments_per_page', '10', 'This setting is for setting a maximum number of comments per page on your view comments page.');
  155. INSERT INTO settings VALUES (110, 'max_image_width', '640', 'This is the maximum width an image file can be, this applies to locally stored images only.');
  156. INSERT INTO settings VALUES (115, 'max_image_height', '640', 'This is the maximum height an image file can be, this applies to locally stored images only.');
  157. INSERT INTO settings VALUES (180, 'is_free', 'yes', 'change this to "no" if you want to charge a subscription fee to your site. You will have to change the values in the /includes/signup.php file to your paypal account');
  158. # --------------------------------------------------------
  159. #
  160. # Table structure for table `std_notify`
  161. #
  162. CREATE TABLE std_notify (
  163.  ipn_id int(10) NOT NULL auto_increment,
  164.  receiver_email varchar(75) NOT NULL default '',
  165.  business varchar(75) NOT NULL default '',
  166.  item_name varchar(127) default NULL,
  167.  item_number varchar(127) default NULL,
  168.  quantity int(10) default NULL,
  169.  invoice varchar(64) default NULL,
  170.  custom varchar(64) default NULL,
  171.  option_name1 varchar(127) default NULL,
  172.  option_selection1 varchar(127) default NULL,
  173.  option_name2 varchar(127) default NULL,
  174.  option_selection2 varchar(127) default NULL,
  175.  num_cart_items int(10) default NULL,
  176.  payment_status enum('Completed','Pending','Failed','Denied','Reversed') default NULL,
  177.  pending_reason enum('echeck','intl','verify','address','upgrade','unilateral','other') default NULL,
  178.  payment_date varchar(55) default NULL,
  179.  settle_amount decimal(9,2) default NULL,
  180.  settle_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
  181.  exchange_rate varchar(15) default NULL,
  182.  payment_gross decimal(9,2) default NULL,
  183.  payment_fee decimal(9,2) default NULL,
  184.  mc_gross decimal(9,2) default NULL,
  185.  mc_fee decimal(9,2) default NULL,
  186.  mc_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
  187.  tax decimal(9,2) default NULL,
  188.  txn_id varchar(50) default NULL,
  189.  txn_type enum('web_accept','cart','send_money') default NULL,
  190.  memo tinytext,
  191.  first_name varchar(32) default NULL,
  192.  last_name varchar(32) default NULL,
  193.  address_street varchar(64) default NULL,
  194.  address_city varchar(32) default NULL,
  195.  address_state varchar(32) default NULL,
  196.  address_zip varchar(25) default NULL,
  197.  address_country varchar(32) default NULL,
  198.  address_status enum('confirmed','unconfirmed') default NULL,
  199.  payer_email varchar(75) default NULL,
  200.  payer_id varchar(60) default NULL,
  201.  payer_status enum('verified','unverified','intl_verified','intl_unverified') default NULL,
  202.  payment_type enum('echeck','instant') default NULL,
  203.  notify_version varchar(10) default NULL,
  204.  verify_sign varchar(128) default NULL,
  205.  status enum('VERIFIED','INVALID') default NULL,
  206.  signed enum('SIGNEDUP','FREE') default NULL,
  207.  user_ID int(10) default '0',
  208.  PRIMARY KEY (ipn_id)
  209. ) TYPE=MyISAM;
  210. #
  211. # Dumping data for table `std_notify`
  212. #
  213. #
  214. # Table structure for table `templates`
  215. #
  216. CREATE TABLE templates (
  217.  id tinyint(4) unsigned NOT NULL auto_increment,
  218.  name varchar(16) NOT NULL default '',
  219.  template text NOT NULL,
  220.  PRIMARY KEY (id),
  221.  UNIQUE KEY name (name)
  222. ) TYPE=MyISAM;
  223. #
  224. # Dumping data for table `templates`
  225. #
  226. INSERT INTO templates VALUES (1, 'main_text', '<table border="0" cellpadding="5" cellspacing="0" width="100%">\r\n<tr>\r\n<td width="100%" class="regular"><img src="$base_url/$title_img" border="0" alt="$title" title="$title" /></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular">Welcome to <a href="$base_url/index.php?$sn=$sid">$site_title</a>.  Here you can upload your picture and have others view it and rate it.  It\'s a great way to meet new people too.  Not only can you rate other member\'s pictures, you can also leave private messages and comments too!  Best of all, membership is totally Free!  <a href="$base_url/index.php?$sn=$sid&show=signup">Signup now</a> and join the fun!\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"><span class="bold">How it works:</span> You <a href="$base_url/index.php?$sn=$sid&show=signup">signup</a> and become a member. Once signed up you can upload your image. You may also link to your image if you already have it on!
  227. another server. Once your image is approved by us, it will begin to appear on the site. Visitors will view your image and rate it depending on their own personal opinion. Visitors may also leave public comments about you, and some may even decide to leave you a private message.</td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"><span class="bold">Rules:</span> No porn allowed! This means no "naked pictures" allowed. All images are approved by us before being shown on the site. If you upload porn we will delete it. If you link to porn we will delete it. This is an "all ages" site so keep it clean! To keep the site as fast as possible, all images must be smaller than $max_image_size bytes in filesize.<br /><br /><a href="$base_url/index.php?$sn=$sid&show=signup"><b>CLICK HERE TO SIGNUP NOW!</b></a><br><br></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="regular"></td>\r\n</tr>\r\n<tr>\r\n<td width="100%" class="smallregular" align="right">Designed for 1024x76!
  228. 8 resolution, 24bit color or better</td>\r\n</tr>\r\n</table>');
  229. INSERT INTO templates VALUES (2, 'image_rules', '<ul>\r\n<li class="regular">No porn allowed! This means no "naked pictures". All images are approved by us before being shown on the site. If you upload or link to porn we will delete it.</li>\r\n<li class="regular">To keep the site as fast as possible, all images must be smaller than $max_image_size bytes in filesize.</li>\r\n<li class="regular">Both new image uploads and new image URLs cause image statistics to be reset. Make sure you are ready to start over if you decide to update an already highly rated image. We can not recover accidentally overwritten images.</li>\r\n</ul>');
  230. INSERT INTO templates VALUES (3, 'site_stats', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Points:</td>\n    <td align="right" class="smallregular">$pts_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points Today:</td>\n    <td align="right" class="smallregular">$pts_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points this Week:</td>\n    <td align="right" class="smallregular">$pts_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Points this Month:</td>\n    <td align="right" class="smallregular">$pts_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Ratings:</td>\n    <td align="right" class="smallregular">$ra_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Ratings Today:</td>\n    <td align="right" class="smallregular">$ra_pd_count</td>\n</tr>\n<tr>\n    <td clas!
  231. s="smallregular" nowrap="nowrap">Ratings this Week:</td>\n    <td align="right" class="smallregular">$ra_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Ratings this Month:</td>\n    <td align="right" class="smallregular">$ra_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Comments:</td>\n    <td align="right" class="smallregular">$cm_total_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments Today:</td>\n    <td align="right" class="smallregular">$cm_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments this Week:</td>\n    <td align="right" class="smallregular">$cm_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Comments this Month:</td>\n    <td align="right" class="smallregular">$cm_pm_count</td>\n</tr>\n<tr bgcolor="#eeeeee">\n    <td class="smallregular" nowrap="nowrap">Total Members:</td>\n    <td align="right" class="smallregular">$su_total_count</td>\n</!
  232. tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups Today:</td>\n    <td align="right" class="smallregular">$su_pd_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups this Week:</td>\n    <td align="right" class="smallregular">$su_pw_count</td>\n</tr>\n<tr>\n    <td class="smallregular" nowrap="nowrap">Signups this Month:</td>\n    <td align="right" class="smallregular">$su_pm_count</td>\n</tr>\n</table>');
  233. INSERT INTO templates VALUES (4, 'visitors_online', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular">&nbsp;Visitors Online:</td>\n    <td align="right" class="regular">$uo_total&nbsp;</td>\n</tr>\n</table>');
  234. INSERT INTO templates VALUES (5, 'logged_in', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\r\n<tr>\r\n    <td width="100%" class="regular" align="right">Welcome $username<br /><a href="$base_url/logout.php?$sn=$sid" target="_top">Logout</a></td>\r\n</tr>\r\n</table>');
  235. INSERT INTO templates VALUES (6, 'logged_out', '<table cellpadding="0" cellspacing="0" border="0" width="100%">\r\n<tr><form method="post" action="$base_url/login.php?$sn=$sid">\r\n    <td width="100%" class="regular" align="right">username:<br /><input type="text" name="UN" size="12" value="" /><br />password:<br /><input type="password" name="PW" size="12" value="" /><br />\r\n    <table cellpadding="0" cellspacing="1" border="0" width="100%">\r\n    <tr>\r\n        <td valign="bottom" nowrap="nowrap"><a href="$base_url/index.php?$sn=$sid&show=lost" target="_top" class="small">Lost<br />Password</a></td>\r\n        <td align="right" valign="bottom"><input class="button" type="submit" name="login" value="Go ->" /></td>\r\n    </tr>\r\n    </table>\r\n    </td>\r\n</form></tr>\r\n</table>');
  236. INSERT INTO templates VALUES (7, 'about_member', '<table cellpadding="5" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular"><a name="profile" class="bold">Average Rating: </a>$array[average_rating]</td>\n    <td class="regular"><span class="bold">Total Points: </span>$array[total_points]</td>\n    <td class="regular" align="right"><span class="bold">Times Rated: </span>$array[total_ratings]</td>\n</tr>\n</table>\n<table cellpadding="5" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular" width="50%"><span class="bold">Name: </span>$array[user_name]</td>\n    <td class="regular" width="50%"><span class="bold">Age: </span>$array[age]</td>\n</tr>\n<tr>\n    <td class="regular" width="100%" colspan="2"><span class="bold">Description: </span>$array[description]</td>\n</tr>\n<tr>\n    <td class="regular" width="50%"><span class="bold">State/Province: </span>$array[state]</td>\n    <td class="regular" class="50%"><span class="bold">Country: </span><img align="top" b!
  237. order="1" src="$base_url/images/flags/$array[country]" hspace="5" alt="$country title="$country" />$country</td>\n</tr>\n<tr>\n    <td class="regular" width=(%"><span class="bold">URL: </span><a href="$array[url]" target="_blank">$array[url]</a></td>\n    <td class="regular" width="50%"><span class="bold">Quote: </span><i>&quot;$array[quote]&quot;</i></td>\n</tr>\n</table>');
  238. INSERT INTO templates VALUES (8, 'img_src', '<table cellpadding="1" cellspacing="0" border="0" bgcolor="black">\r\n<tr>\r\n    <td bgcolor="black"><img src="$image_src"></td>\r\n</tr>\r\n</table>');
  239. INSERT INTO templates VALUES (9, 'comment', '<table cellpadding="2" cellspacing="0" border="0" width="100%">\n<tr>\n    <td class="regular" width="100%" colspan="2">On $d, $user_link wrote:</td>\n</tr>\n<tr>\n    <td width="1%">&nbsp;</td>\n    <td colspan="2" class="regular" width="99%">$gc_array[comment]</td>\n</tr>\n</table>');
  240. INSERT INTO templates VALUES (10, 'copyright', 'Copyright © 2002 <a class="small" href="$base_url/index.php?$sn=$sid" target="_top">$site_title</a> - All Rights Reserved');
  241. INSERT INTO templates VALUES (11, 'styles', '<style type="text/css">\nBODY {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:active {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:visited {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_link_color;\n}\na:hover {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background-color: $hover_link_bg_color;\n}\na.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:active.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:visited.small {\n    font-family: $base_font;\n    font!
  242. -size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\na:hover.small {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background-color: $hover_link_bg_color;\n}\na:il.hover {\n    background-color: transparent;\n}\n.title {\n    font-family: $base_font;\n    font-size: $large_font;\n    font-weight: bold;\n    color: $table_title_text_color;\n}\n.regular {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n.selectedNav {\n    font-family: $base_font_color;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $hover_link_color;\n    background: $hover_link_bg_color;\n}\n.bold {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: bold;\n    color: $base_font_color;\n}\n.smallregular {\n    font-family: $base_font;\n    font-size: $small_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n.error {\n    font-family: $base_font;\n    font-size: $medium!
  243. _font;\n    font-weight: normal;\n    color: $error_font_color;\n}\n.tb_header {\n    color: $table_title_text_color;\n    background-color: $table_title_color;\n    background: url("$base_url/$tb_header_img");\n    background-repeat: repeat-x;\n}\ninput, textarea, select {\n    font-family: $base_font;\n    font-size: $medium_font;\n    font-weight: normal;\n    color: $base_font_color;\n}\n\n.gray_top_middle {\nbackground: url("$base_url/images/gray_top_middle.gif") repeat-x;\n    height: 18px;\n}\n.gray_middle_fill {\n    background: url("$base_url/images/gray_middle_fill.gif") repeat-x;\n    height: 1px;\n}\n.gray_title_left {\n    background: url("$base_url/images/gray_left_title.gif") repeat-y;\n}\n.gray_title_right {\n    background: url("$base_url/images/gray_right_title.gif") repeat-y;\n}\n.gray_left_body {\n    background: url("$base_url/images/gray_left_body.gif") repeat-y;\n}\n.gray_right_body {\n    background: url("$base_url/images/gray_right_body.gif") repeat-y;\n}\n.gray_bottom_middle {\n    background: url("$ba!
  244. se_url/images/gray_bottom_middle.gif") repeat-x;\n}\n</style>');
  245. INSERT INTO templates VALUES (12, 'doc_head', '<!DOCTYPE html \r\nPUBLIC "-//W3C//DTD XHTML 1.0\n    Transitional//EN"\r\n"DTD/xhtml1-transitional.dtd">\n<html>\n<head>\n<title> .: $site_title :.</title>\n<meta name="keywords" content="place,keywords,here" />\n<meta name="description" content="irater is a highly advanced PHP Script which allows you to enhance your site by adding an upload and rate me section." />\n<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />');
  246. INSERT INTO templates VALUES (13, 'body_tag', '<body bgcolor="$page_bg_color">\r\n<center><img src="banner.jpg" width="468" height="60" border="0" alt="irater" title="irater" vspace="2"></a></center>');
  247. INSERT INTO templates VALUES (14, 'lost_pass_form', '<table border="0" cellpadding="3" cellspacing="0" width="100%">\n<tr>\n    <td width="100%" class="regular" align="center"><br />Enter your Username or Email Address<br />and we will send you your Password Hint.<br /><br /></td>\n</tr>\n<form method="post" action="$base_url/index.php?$sn=$sid&amp;show=lost&amp;search=1">\n<tr>\n    <td width="100%" class="regular" align="center">Username: <input type="text" name="search_username" size="16" value="" />&nbsp;<input class="button" type="submit" name="lost_username" value="Search ->" /><br /></form><form method="post" action="$base_url/index.php?$sn=$sid&amp;show=lost&amp;search=1">Email Address: <input type="lost_email" name="search_email" size="24" value="" />&nbsp;<input class="button" type="submit" name="lost_email" value="Search ->" /><br /><br /></td>\n</tr>\n</form>\n</table>');
  248. INSERT INTO templates VALUES (15, 'comment_list', '<table cellpadding="2" cellspacing="0" border="0" width="100%">\r\n<tr>\r\n    <td class="regular" width="100%" colspan="2">On $d, $user_link left a comment for $member_link:</td>\r\n</tr>\r\n<tr>\r\n    <td width="1%"> </td>\r\n    <td colspan="2" class="regular" width="99%">$gc_array[comment]</td>\r\n</tr>\r\n</table>');
  249. INSERT INTO templates VALUES (16, 'direct_link', '<table cellpadding="2" cellspacing="0" border="0">\r\n<tr><form>\r\n<td class="regular">Link to this page: </td>\r\n<td class="regular"><input type="text" value="$base_url/?i=$array[id]" size="42" readonly onFocus="select()" onSelect="select()"></td>\r\n</form></tr>\r\n</table>');
  250. # --------------------------------------------------------
  251. #
  252. # Table structure for table `users`
  253. #
  254. CREATE TABLE users (
  255.  id smallint(5) unsigned NOT NULL auto_increment,
  256.  username varchar(16) NOT NULL default '',
  257.  password varchar(16) NOT NULL default '',
  258.  hint varchar(100) NOT NULL default '',
  259.  realname varchar(48) NOT NULL default '',
  260.  description text NOT NULL,
  261.  age tinyint(2) unsigned NOT NULL default '0',
  262.  sex enum('m','f') NOT NULL default 'm',
  263.  state varchar(32) NOT NULL default '',
  264.  country varchar(32) NOT NULL default 'United_States.gif',
  265.  email varchar(48) NOT NULL default '',
  266.  url varchar(255) NOT NULL default '',
  267.  quote varchar(255) NOT NULL default '',
  268.  image enum('here','there') NOT NULL default 'there',
  269.  image_url varchar(144) NOT NULL default '',
  270.  image_ext varchar(4) NOT NULL default '',
  271.  image_status enum('-1','0','1') NOT NULL default '-1',
  272.  total_ratings smallint(5) unsigned NOT NULL default '0',
  273.  total_points mediumint(9) unsigned NOT NULL default '0',
  274.  average_rating decimal(6,4) NOT NULL default '0.0000',
  275.  total_comments int(10) unsigned NOT NULL default '0',
  276.  signup varchar(14) NOT NULL default '',
  277.  timestamp timestamp(14) NOT NULL,
  278.  PRIMARY KEY (id),
  279.  KEY sex (sex),
  280.  KEY timestamp (timestamp),
  281.  KEY signup (signup),
  282.  KEY username (username),
  283.  KEY email (email)
  284. ) TYPE=MyISAM;
  285. #
  286. # Dumping data for table `users`
  287. #
  288. #
  289. # Table structure for table `usersTemp`
  290. #
  291. CREATE TABLE usersTemp (
  292.  id smallint(5) unsigned NOT NULL auto_increment,
  293.  username varchar(16) NOT NULL default '',
  294.  password varchar(16) NOT NULL default '',
  295.  hint varchar(100) NOT NULL default '',
  296.  realname varchar(48) NOT NULL default '',
  297.  description text NOT NULL,
  298.  age tinyint(2) unsigned NOT NULL default '0',
  299.  sex enum('m','f') NOT NULL default 'm',
  300.  state varchar(32) NOT NULL default '',
  301.  country varchar(32) NOT NULL default 'United_States.gif',
  302.  email varchar(48) NOT NULL default '',
  303.  url varchar(255) NOT NULL default '',
  304.  quote varchar(255) NOT NULL default '',
  305.  image enum('here','there') NOT NULL default 'there',
  306.  image_url varchar(144) NOT NULL default '',
  307.  image_ext varchar(4) NOT NULL default '',
  308.  image_status enum('-1','0','1') NOT NULL default '-1',
  309.  total_ratings smallint(5) unsigned NOT NULL default '0',
  310.  total_points mediumint(9) unsigned NOT NULL default '0',
  311.  average_rating decimal(6,4) NOT NULL default '0.0000',
  312.  total_comments int(10) unsigned NOT NULL default '0',
  313.  signup varchar(14) NOT NULL default '',
  314.  timestamp timestamp(14) NOT NULL,
  315.  PRIMARY KEY (id),
  316.  KEY sex (sex),
  317.  KEY timestamp (timestamp),
  318.  KEY signup (signup),
  319.  KEY username (username),
  320.  KEY email (email)
  321. ) TYPE=MyISAM;
  322. #
  323. # Dumping data for table `usersTemp`
  324. #
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

nunyaB --PM the site owner Bigwebmaster and/or Supermod UNFLUX about hosting. Either one of them can get you set up and make this work easily. UNFLUX is out of town for a few days, but Bigweb is here and will gladly assist you. IMHO your host sucks.
  • RichB
  • Guru
  • Guru
  • User avatar
  • Posts: 1121
  • Loc: Boston

Post 3+ Months Ago

I just tried it in phpmyadmin and it worked fine for me too. Maybe try removing the comments. I don't see how that would make a difference but it's worth a try - maybe remove the first batch of comments and see if the line that the error is being reported on changes and then if it does remove all the comments and see what happens.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Quote:
nunyaB --PM the site owner Bigwebmaster and/or Supermod UNFLUX about hosting. Either one of them can get you set up and make this work easily. UNFLUX is out of town for a few days, but Bigweb is here and will gladly assist you. IMHO your host sucks.



They have a hosting company? If so, what is the url? I'd like to check it out.


And yes, they suck hard. They'll go all out for you when it comes to sales, but their support is very minimum. I'm going to switch right away, because I need my script up and running.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Quote:
I just tried it in phpmyadmin and it worked fine for me too. Maybe try removing the comments. I don't see how that would make a difference but it's worth a try - maybe remove the first batch of comments and see if the line that the error is being reported on changes and then if it does remove all the comments and see what happens.




Hey,

Thanks for the suggestions, but everytime I try and remove something, i get another one. My best bet is to change hosts, and that's what I'm going to do.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Trust me...just PM Bigwebmaster. Since he's the owner here you'll find him. I don't know the details on his stuff but he'll explain it. All you have to do is find any post he made and click the PM button.
  • nunyaB
  • Newbie
  • Newbie
  • nunyaB
  • Posts: 12

Post 3+ Months Ago

Alrighty Then!




thnx
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Good luck. I did my best. I didn't realize at first how screwed up your host was.

Post Information

  • Total Posts in this topic: 29 posts
  • Users browsing this forum: No registered users and 116 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.