Retour à Forum de programmation

Exécutez SQL et tout ce que d'autres choses.

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 6:57 pm

* lol - pas de navigation option? Are you kidding? Man quelle version de phpMyAdmin sont-ils utiliser? * Désolé - OK - vous me faire entrer en elle. Envoyez-moi le lien et l'accès matériel à l'adresse e-mail. Maintenant Im ne le fais pas juste pour vous aider - Im diable curieux de voir ce type de configuration dont ils disposent. Si elles ont un foutu mauvais version que vous sachiez. Sinon, mauvais vous dire comment le faire mais ils lui ont mis en place.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Anonymous
  • Bot
  • No Avatar
  • Inscription: 25 Feb 2008
  • Messages: ?
  • Loc: Ozzuland
  • Status: Online

Message Février 22nd, 2004, 6:57 pm

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 7:00 pm

Désolé - je ne veux pas que vous pensiez Im rire de vous. Je veux juste voir ça. phpMyAdmin est le plus facile mySQL admin outil qui soit. Im juste curieux de voir ce que le diable qu'ils font. Il ne devrait pas être difficile pour vous.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 7:42 pm

Intéressant. Je obtenir les mêmes erreurs que vous faire un copier-coller .. Et ce n'est certainement pas phpMyAdmin - au moins pas de toute façon Ive jamais vu. Permettez-moi de prendre une capture d'écran et d'après le lien que les autres puissent le voir dans certains cas, mai se familiariser avec elle. Théoriquement, votre fichier texte devrait fonctionner comme il est.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 7:51 pm

Voici la capture d'écran de ce qu'il voit et ce que j'ai trop de texte lors de l'exécution d'une requête (c & p)

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

Je n'ai pas vu cette configuration pour le moment. Vraiment étrange. J'ai utilisé le même fichier et les tableaux mis en place sur ma db en moins d'une seconde sur la requête avec phpMyAdmin. Maintenant je dois penser à celle-ci également.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • nunyaB
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Fév 22, 2004
  • Messages: 12
  • Status: Offline

Message Février 22nd, 2004, 8:09 pm

Hmmm, intéressant!


Eh bien, je mai à accueillir le changement ensuite, parce que j'ai sérieusement besoin de ce script.


Bummer pour moi.
  • nunyaB
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Fév 22, 2004
  • Messages: 12
  • Status: Offline

Message Février 22nd, 2004, 8:10 pm

Peut-être une ancienne version....?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 8:14 pm

Le fichier texte SQL n'est pas aussi grand que je m'y attendais. Je ne vois rien de mal avec elle. Je obtenir exactement les mêmes erreurs nunyaB fait avec cet hôte, mais il l'avait exécutée en 1 seconde comme prévu sur la mienne. Heres 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. # --------------------------------------------------------
  4. #
  5. # Table structure for table `admin`
  6. #
  8. drop table if exists admin;
  9. drop table if exists comments;
  10. drop table if exists pms;
  11. drop table if exists std_notify;
  12. drop table if exists ratings;
  13. drop table if exists sessions;
  14. drop table if exists settings;
  15. drop table if exists templates;
  16. drop table if exists users;
  17. drop table if exists image_types;
  18. drop table if exists usersTemp;
  20. CREATE TABLE admin (
  21.  id tinyint(4) NOT NULL auto_increment,
  22.  username char(16) NOT NULL default '',
  23.  password char(32) NOT NULL default '',
  24.  PRIMARY KEY (id)
  25. ) TYPE=MyISAM;
  27. #
  28. # Dumping data for table `admin`
  29. #
  31. INSERT INTO admin VALUES (1, 'admin', 'password');
  32. # --------------------------------------------------------
  34. #
  35. # Table structure for table `comments`
  36. #
  38. CREATE TABLE comments (
  39.  id int(7) unsigned NOT NULL auto_increment,
  40.  user_id smallint(5) unsigned NOT NULL default '0',
  41.  comment text NOT NULL,
  42.  author_id smallint(5) NOT NULL default '0',
  43.  author_ip varchar(15) NOT NULL default '',
  44.  status varchar(16) NOT NULL default 'waiting',
  45.  timestamp timestamp(14) NOT NULL,
  46.  PRIMARY KEY (id),
  47.  KEY timestamp (timestamp),
  48.  KEY user_id (user_id)
  49. ) TYPE=MyISAM;
  51. #
  52. # Dumping data for table `comments`
  53. #
  55. #
  56. # Table structure for table `image_types`
  57. #
  59. CREATE TABLE image_types (
  60.  id tinyint(3) unsigned NOT NULL auto_increment,
  61.  ext char(4) NOT NULL default '',
  62.  PRIMARY KEY (id)
  63. ) TYPE=MyISAM;
  65. #
  66. # Dumping data for table `image_types`
  67. #
  69. INSERT INTO image_types VALUES (1, 'bmp');
  70. INSERT INTO image_types VALUES (2, 'gif');
  71. INSERT INTO image_types VALUES (3, 'jpg');
  72. INSERT INTO image_types VALUES (4, 'jpeg');
  73. INSERT INTO image_types VALUES (5, 'png');
  74. # --------------------------------------------------------
  76. #
  77. # Table structure for table `pms`
  78. #
  80. CREATE TABLE pms (
  81.  id int(7) unsigned NOT NULL auto_increment,
  82.  user_id smallint(5) unsigned NOT NULL default '0',
  83.  subject varchar(50) NOT NULL default '',
  84.  message text NOT NULL,
  85.  author_id smallint(5) NOT NULL default '0',
  86.  author_ip varchar(15) NOT NULL default '',
  87.  pm_status varchar(16) NOT NULL default 'unread',
  88.  timestamp timestamp(14) NOT NULL,
  89.  PRIMARY KEY (id),
  90.  KEY timestamp (timestamp),
  91.  KEY user_id (user_id)
  92. ) TYPE=MyISAM;
  94. #
  95. # Dumping data for table `pms`
  96. #
  98. #
  99. # Table structure for table `ratings`
  100. #
  102. CREATE TABLE ratings (
  103.  id int(7) unsigned NOT NULL auto_increment,
  104.  user_id smallint(5) unsigned NOT NULL default '0',
  105.  rating tinyint(1) unsigned NOT NULL default '0',
  106.  rater_id smallint(5) NOT NULL default '0',
  107.  rater_ip char(15) NOT NULL default '',
  108.  timestamp timestamp(14) NOT NULL,
  109.  PRIMARY KEY (id),
  110.  KEY timestamp (timestamp),
  111.  KEY user_id (user_id)
  112. ) TYPE=MyISAM;
  114. #
  115. # Dumping data for table `ratings`
  116. #
  118. #
  119. # Table structure for table `sessions`
  120. #
  122. CREATE TABLE sessions (
  123.  id varchar(32) NOT NULL default '',
  124.  data text NOT NULL,
  125.  expire int(11) unsigned NOT NULL default '0',
  126.  PRIMARY KEY (id)
  127. ) TYPE=MyISAM;
  129. #
  130. # Dumping data for table `sessions`
  131. #
  133. #
  134. # Table structure for table `settings`
  135. #
  137. CREATE TABLE settings (
  138.  orderby tinyint(3) unsigned NOT NULL default '0',
  139.  name varchar(24) NOT NULL default '',
  140.  setting varchar(255) NOT NULL default '',
  141.  descr varchar(255) NOT NULL default '',
  142.  PRIMARY KEY (name)
  143. ) TYPE=MyISAM;
  145. #
  146. # Dumping data for table `settings`
  147. #
  149. 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.');
  150. 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.');
  151. INSERT INTO settings VALUES (80, 'table_border_color', 'yellow', 'This affects the outer table border. See include/tables.php for more info.');
  152. INSERT INTO settings VALUES (65, 'table_title_color', 'black', 'This affects the table title bar background color. See include/tables.php for more info.');
  153. INSERT INTO settings VALUES (75, 'table_content_color', 'white', 'This affects the color of the table body. See include/tables.php for more info.');
  154. INSERT INTO settings VALUES (85, 'page_bg_color', '#ffffff', 'Overall page background color.');
  155. 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.');
  156. 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\'.');
  157. INSERT INTO settings VALUES (15, 'base_font', 'Tahoma, Verdana, sans-serif', 'General font face.');
  158. INSERT INTO settings VALUES (20, 'base_font_size', '13', 'General font size in pixels, 11-15 is probably best.');
  159. INSERT INTO settings VALUES (25, 'base_font_color', 'black', 'General site font color.');
  160. INSERT INTO settings VALUES (30, 'base_link_color', 'black', 'General link color.');
  161. INSERT INTO settings VALUES (35, 'hover_link_color', 'yellow', 'Hover link color.');
  162. INSERT INTO settings VALUES (40, 'hover_link_bg_color', '#333366', 'Hover link background color.');
  163. INSERT INTO settings VALUES (70, 'table_title_text_color', '#333366', 'This is the font color for the table headers.');
  164. INSERT INTO settings VALUES (45, 'error_font_color', 'red', 'General error font color.');
  165. INSERT INTO settings VALUES (10, 'site_title', 'irater', 'The name of your irater based site.');
  166. 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.');
  167. INSERT INTO settings VALUES (150, 'girl_count', '10', 'How many girls to list in the mini-list.');
  168. INSERT INTO settings VALUES (155, 'guy_count', '10', 'How many guys to list in the mini-list.');
  169. 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.');
  170. INSERT INTO settings VALUES (140, 'girl_t', '1', 'If set to yes, this causes the girl\'s mini-list to be displayed.');
  171. INSERT INTO settings VALUES (145, 'guy_t', '1', 'If set to yes, this causes the guy\'s mini-list to be displayed.');
  172. INSERT INTO settings VALUES (60, 'table_file', 'tables.gray.php', 'What table theme you want to use.');
  173. INSERT INTO settings VALUES (90, 'left_col_width', '156', 'This is the width of the left column in pixels.');
  174. INSERT INTO settings VALUES (95, 'right_col_width', '156', 'This is the width of the right column in pixels.');
  175. INSERT INTO settings VALUES (100, 'main_col_width', '658', 'This is the width of the main column in pixels.');
  176. 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.');
  177. 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.');
  178. 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.');
  179. 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.');
  180. 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.');
  181. 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.');
  182. 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');
  183. # --------------------------------------------------------
  185. #
  186. # Table structure for table `std_notify`
  187. #
  189. CREATE TABLE std_notify (
  190.  ipn_id int(10) NOT NULL auto_increment,
  191.  receiver_email varchar(75) NOT NULL default '',
  192.  business varchar(75) NOT NULL default '',
  193.  item_name varchar(127) default NULL,
  194.  item_number varchar(127) default NULL,
  195.  quantity int(10) default NULL,
  196.  invoice varchar(64) default NULL,
  197.  custom varchar(64) default NULL,
  198.  option_name1 varchar(127) default NULL,
  199.  option_selection1 varchar(127) default NULL,
  200.  option_name2 varchar(127) default NULL,
  201.  option_selection2 varchar(127) default NULL,
  202.  num_cart_items int(10) default NULL,
  203.  payment_status enum('Completed','Pending','Failed','Denied','Reversed') default NULL,
  204.  pending_reason enum('echeck','intl','verify','address','upgrade','unilateral','other') default NULL,
  205.  payment_date varchar(55) default NULL,
  206.  settle_amount decimal(9,2) default NULL,
  207.  settle_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
  208.  exchange_rate varchar(15) default NULL,
  209.  payment_gross decimal(9,2) default NULL,
  210.  payment_fee decimal(9,2) default NULL,
  211.  mc_gross decimal(9,2) default NULL,
  212.  mc_fee decimal(9,2) default NULL,
  213.  mc_currency enum('USD','CAD','GBP','EUR','JPY') default NULL,
  214.  tax decimal(9,2) default NULL,
  215.  txn_id varchar(50) default NULL,
  216.  txn_type enum('web_accept','cart','send_money') default NULL,
  217.  memo tinytext,
  218.  first_name varchar(32) default NULL,
  219.  last_name varchar(32) default NULL,
  220.  address_street varchar(64) default NULL,
  221.  address_city varchar(32) default NULL,
  222.  address_state varchar(32) default NULL,
  223.  address_zip varchar(25) default NULL,
  224.  address_country varchar(32) default NULL,
  225.  address_status enum('confirmed','unconfirmed') default NULL,
  226.  payer_email varchar(75) default NULL,
  227.  payer_id varchar(60) default NULL,
  228.  payer_status enum('verified','unverified','intl_verified','intl_unverified') default NULL,
  229.  payment_type enum('echeck','instant') default NULL,
  230.  notify_version varchar(10) default NULL,
  231.  verify_sign varchar(128) default NULL,
  232.  status enum('VERIFIED','INVALID') default NULL,
  233.  signed enum('SIGNEDUP','FREE') default NULL,
  234.  user_ID int(10) default '0',
  235.  PRIMARY KEY (ipn_id)
  236. ) TYPE=MyISAM;
  238. #
  239. # Dumping data for table `std_notify`
  240. #
  242. #
  243. # Table structure for table `templates`
  244. #
  246. CREATE TABLE templates (
  247.  id tinyint(4) unsigned NOT NULL auto_increment,
  248.  name varchar(16) NOT NULL default '',
  249.  template text NOT NULL,
  250.  PRIMARY KEY (id),
  251.  UNIQUE KEY name (name)
  252. ) TYPE=MyISAM;
  254. #
  255. # Dumping data for table `templates`
  256. #
  258. 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!
  259. 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!
  260. 8 resolution, 24bit color or better</td>\r\n</tr>\r\n</table>');
  261. 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>');
  262. 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!
  263. 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</!
  264. 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>');
  265. 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>');
  266. 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>');
  267. 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>');
  268. 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!
  269. 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>');
  270. 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>');
  271. 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>');
  272. 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');
  273. 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!
  274. -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!
  275. _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!
  276. se_url/images/gray_bottom_middle.gif") repeat-x;\n}\n</style>');
  277. 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" />');
  278. 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>');
  279. 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>');
  280. 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>');
  281. 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>');
  282. # --------------------------------------------------------
  284. #
  285. # Table structure for table `users`
  286. #
  288. CREATE TABLE users (
  289.  id smallint(5) unsigned NOT NULL auto_increment,
  290.  username varchar(16) NOT NULL default '',
  291.  password varchar(16) NOT NULL default '',
  292.  hint varchar(100) NOT NULL default '',
  293.  realname varchar(48) NOT NULL default '',
  294.  description text NOT NULL,
  295.  age tinyint(2) unsigned NOT NULL default '0',
  296.  sex enum('m','f') NOT NULL default 'm',
  297.  state varchar(32) NOT NULL default '',
  298.  country varchar(32) NOT NULL default 'United_States.gif',
  299.  email varchar(48) NOT NULL default '',
  300.  url varchar(255) NOT NULL default '',
  301.  quote varchar(255) NOT NULL default '',
  302.  image enum('here','there') NOT NULL default 'there',
  303.  image_url varchar(144) NOT NULL default '',
  304.  image_ext varchar(4) NOT NULL default '',
  305.  image_status enum('-1','0','1') NOT NULL default '-1',
  306.  total_ratings smallint(5) unsigned NOT NULL default '0',
  307.  total_points mediumint(9) unsigned NOT NULL default '0',
  308.  average_rating decimal(6,4) NOT NULL default '0.0000',
  309.  total_comments int(10) unsigned NOT NULL default '0',
  310.  signup varchar(14) NOT NULL default '',
  311.  timestamp timestamp(14) NOT NULL,
  312.  PRIMARY KEY (id),
  313.  KEY sex (sex),
  314.  KEY timestamp (timestamp),
  315.  KEY signup (signup),
  316.  KEY username (username),
  317.  KEY email (email)
  318. ) TYPE=MyISAM;
  320. #
  321. # Dumping data for table `users`
  322. #
  324. #
  325. # Table structure for table `usersTemp`
  326. #
  328. CREATE TABLE usersTemp (
  329.  id smallint(5) unsigned NOT NULL auto_increment,
  330.  username varchar(16) NOT NULL default '',
  331.  password varchar(16) NOT NULL default '',
  332.  hint varchar(100) NOT NULL default '',
  333.  realname varchar(48) NOT NULL default '',
  334.  description text NOT NULL,
  335.  age tinyint(2) unsigned NOT NULL default '0',
  336.  sex enum('m','f') NOT NULL default 'm',
  337.  state varchar(32) NOT NULL default '',
  338.  country varchar(32) NOT NULL default 'United_States.gif',
  339.  email varchar(48) NOT NULL default '',
  340.  url varchar(255) NOT NULL default '',
  341.  quote varchar(255) NOT NULL default '',
  342.  image enum('here','there') NOT NULL default 'there',
  343.  image_url varchar(144) NOT NULL default '',
  344.  image_ext varchar(4) NOT NULL default '',
  345.  image_status enum('-1','0','1') NOT NULL default '-1',
  346.  total_ratings smallint(5) unsigned NOT NULL default '0',
  347.  total_points mediumint(9) unsigned NOT NULL default '0',
  348.  average_rating decimal(6,4) NOT NULL default '0.0000',
  349.  total_comments int(10) unsigned NOT NULL default '0',
  350.  signup varchar(14) NOT NULL default '',
  351.  timestamp timestamp(14) NOT NULL,
  352.  PRIMARY KEY (id),
  353.  KEY sex (sex),
  354.  KEY timestamp (timestamp),
  355.  KEY signup (signup),
  356.  KEY username (username),
  357.  KEY email (email)
  358. ) TYPE=MyISAM;
  360. #
  361. # Dumping data for table `usersTemp`
  362. #
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 8:25 pm

nunyaB - PM Bigwebmaster le propriétaire du site et / ou Supermod UNFLUX sur l'hébergement. Soit l'un d'entre eux peut vous mettre en place et de faire ce travail facilement. UNFLUX est hors de la ville pour quelques jours, mais Bigweb est ici et se fera un plaisir de vous aider. IMHO votre hôte sucks.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • RichB
  • Guru
  • Guru
  • Avatar de l’utilisateur
  • Inscription: Mai 17, 2003
  • Messages: 1121
  • Loc: Boston
  • Status: Offline

Message Février 22nd, 2004, 8:28 pm

Je viens d'essayer dans phpmyadmin, et il a bien fonctionné pour moi aussi. Peut-être essayer de supprimer les commentaires. Je ne vois pas comment cela ferait une différence, mais sa vaut la peine d'essayer - peut-être supprimer le premier lot d'observations et de voir si la ligne que l'erreur est signalée sur les changements et ensuite si elle ne fait supprimer tous les commentaires et voir ce qui se passe.
Free Programming Resources
  • nunyaB
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Fév 22, 2004
  • Messages: 12
  • Status: Offline

Message Février 22nd, 2004, 8:39 pm

Quote:
nunyaB - PM Bigwebmaster le propriétaire du site et / ou Supermod UNFLUX sur l'hébergement. Soit l'un d'entre eux peut vous mettre en place et de faire ce travail facilement. UNFLUX est hors de la ville pour quelques jours, mais Bigweb est ici et se fera un plaisir de vous aider. IMHO votre hôte sucks.



Ils ont une entreprise d'hébergement? Si oui, quelle est l'url? Jaimerais vérifier.


Et oui, ils sucent dur. Theyll aller pour vous quand il s'agit de la vente, mais leur soutien est très minimale. Im allons passer tout de suite, parce que j'ai besoin de mon script en place et fonctionne.
  • nunyaB
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Fév 22, 2004
  • Messages: 12
  • Status: Offline

Message Février 22nd, 2004, 8:42 pm

Quote:
Je viens d'essayer dans phpmyadmin, et il a bien fonctionné pour moi aussi. Peut-être essayer de supprimer les commentaires. Je ne vois pas comment cela ferait une différence, mais sa vaut la peine d'essayer - peut-être supprimer le premier lot d'observations et de voir si la ligne que l'erreur est signalée sur les changements et ensuite si elle ne fait supprimer tous les commentaires et voir ce qui se passe.




Hé,

Merci pour les suggestions, mais à chaque fois que je tente de supprimer quelque chose, je obtenir un autre. Mon meilleur pari est de changer les hôtes, et Im thats ce que va faire.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 8:45 pm

Trust me...PM Bigwebmaster juste. Depuis hes le propriétaire vous y retrouver. Je ne connais pas les détails sur son affaire, mais l'enfer expliquer. Tout ce que vous avez à faire est de trouver un poste qu'il a faites et de cliquer sur le bouton PM.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • nunyaB
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Fév 22, 2004
  • Messages: 12
  • Status: Offline

Message Février 22nd, 2004, 8:54 pm

Parfait alors!




thnx
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • Avatar de l’utilisateur
  • Inscription: Mai 28, 2003
  • Messages: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Message Février 22nd, 2004, 9:20 pm

Bonne chance. J'ai fait de mon mieux. Je ne savais pas comment au premier baiser de votre accueil a été.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.

1, 2

Afficher de l'information

  • Total des messages de ce sujet: 29 messages
  • Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 230 invités
  • Vous ne pouvez pas poster de nouveaux sujets
  • Vous ne pouvez pas répondre aux sujets
  • Vous ne pouvez pas éditer vos messages
  • Vous ne pouvez pas supprimer vos messages
  • Vous ne pouvez pas joindre des fichiers
 
 

© 2011 Unmelted, LLC. Ozzu® est une marque déposée de Unmelted, LLC