Uutiset:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu
Advertisement:

Problem With MOD Invite

Aloittaja FeDe.RuLeZ, helmikuu 01, 2008, 12:19:04 IP

« edellinen - seuraava »

FeDe.RuLeZ

I have try the Invite Mod. I cant install it automatically on my server, so i've try to install it manually.. I must create the tables for the mysql but i dont know how i can do!!

This is the file db.php that is into the archive .zip

<?php

if (!defined('SMF'))
die('Hacking attempt...');

db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}invites (
  ID_INVITE mediumint(8) unsigned NOT NULL auto_increment,
  ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
  ID_REGISTRATION mediumint(8) unsigned NOT NULL default '0',
  inviteTime int(10) unsigned NOT NULL default '0',
  inviteKey varchar(64) NOT NULL default '',
  PRIMARY KEY  (ID_INVITE),
  KEY ID_MEMBER (ID_MEMBER),
  KEY inviteTime (inviteTime),
  KEY inviteKey (inviteKey)
)"
__FILE____LINE__);



$request db_query("
SHOW COLUMNS
FROM 
{$db_prefix}invites
"
__FILE____LINE__);

$columns = array();
while (
$row mysql_fetch_assoc($request))
$columns[] = $row['Field'];

if (!
in_array('inviteEmail'$columns))
db_query("ALTER TABLE {$db_prefix}invites ADD inviteEmail TINYTEXT NOT NULL"__FILE____LINE__);

?>


Please help me!!

EDIT:

I've resolve  ;)

~ Forum Support  ~ News  ~ Download Center  ~ Media Center  ~ Link Directory  ~ Arcade  ~ Anche Supporto SMF!

Advertisement: