Help me oh this script .

**mayurss786** · 19.09.11, 10:58

post full script

**something else** · 19.09.11, 16:39

change the int(2)id on chat_rooms SQL to a higher number

eg:
int(10)id

or what ever name you are using for your auto-increasement

P.s: Please Use [ PHP] [ /PHP] bb codes .... it makes it a lot easier to read

**arnage** · 19.09.11, 17:32

Its because unsigned. Change like this in both versions.

PHP Code:

$sql = mysql_query("CREATE TABLE `chat".$room."` 
 (
 `id` int(10) NOT NULL AUTO_INCREMENT,
 `aid` int(11) NOT NULL default '0',
 `nickname` tinytext NOT NULL,
 `msg` text NOT NULL,
 `to` int(11) NOT NULL default '0',
 `time` tinytext NOT NULL,
 `seconds` int(11) unsigned NOT NULL default '0',
 PRIMARY KEY (`id`)
 ) TYPE=MyISAM ;");

The rest is on your own bro.

**something else** · 19.09.11, 17:52

$room = mysql_insert_id();

gets the last sql insert id which is set to the auto-increation

so in this case its:
$sql = mysql_query("INSERT INTO `chat_rooms` VALUES('()', '".$name."', '".$position."', '".$name."', '".$type."', '".$mid."');");

so the chat_room sql for the auto-increation must be set to int(2) (99 being the last 2 digit number)

**arnage** · 19.09.11, 18:01

Nope, here is the table.

PHP Code:

CREATE TABLE `chat_rooms` ( 
 `id` int(11) NOT NULL AUTO_INCREMENT, 
 `name` text NOT NULL, 
 `position` int(6) NOT NULL DEFAULT '0', 
 `topic` text NOT NULL, 
 `type` text NOT NULL, 
 `mid` text NOT NULL, 
 `zakljucan` text NOT NULL, 
 `lv` text NOT NULL, 
 PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

Unsigned int is considered as smallint and it is two digits.

**martinzenica** · 20.09.11, 11:17

full php file with code with comant create room

Unsigned int jel possible to be more than 2 digits there its i think only problem

Added after 8 minutes:

PHP Code:

<?php
error_reporting(0);
require_once"./includes/functions/gzip.php";
include('start.php');
include("config.php");
include("./includes/".$ver."/banned");

list($msec, $sec) = explode(chr(32), microtime());
$headtime = $sec + $msec;
$nocache = rand(1000, 9999);

switch($ver)
{
case 'wml':
///////////////////////////////////////////////////////
//WML VERSION
///////////////////////////////////////////////////////

header("Content-type: text/vnd.wap.wml; charset=utf-8");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-revalidate");

//AUTH
$id = intval($_SESSION['id']);
$password = mysql_escape_string($_SESSION['password']);
$q = mysql_query("SELECT nickname FROM `chat_users` WHERE `id` = '".$id."' AND `password` = '".md5($password)."';");
    if(mysql_num_rows($q) == 0)
    {
    echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
    echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.3//EN\" \"http://www.wapforum.org/DTD/wml13.dtd\"><wml>\n";
    echo "<card title=\"ERROR\" ontimer=\"index.php?ver=wml\"><timer value=\"15\"/><p align=\"left\">\n";
    echo "<small>Authorization Failed!<br/>\n";
    list($msec, $sec) = explode(chr(32), microtime());
    echo "<br/>[".round(($sec+$msec)-$headtime,5)."] sec<br/>\n";
    echo "</small>";
    require_once "includes/functions/gzip_foot.php";
    echo "</p></card></wml>";
    ob_end_flush();
    exit();
    }

//END AUTH


echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.3//EN\" \"http://www.wapforum.org/DTD/wml13.dtd\">\n<wml>\n";

echo "<head><meta http-equiv=\"Cache-Control\" content=\"no-cache\" forua=\"true\"/></head>\n";
echo "<card id=\"index\" title=\"opcije\"><p align=\"left\">\n";

echo "<!-- Developed by martin suvalj -->\n";

$chat = file("chat.dat");
$logo = trim($chat[0]);
$message = trim($chat[1]);
if(!empty($logo)) echo "<img src=\"http://$logo\" alt=\"\" /><br/>\n";
if(!empty($message)) echo "$message<br/>\n";


///razglas
//razglas



$q = mysql_query("SELECT id,nickname,level,shoutbox,status,posts,time,ip,ua,security,fsize FROM `chat_users` WHERE `nickname` = '".$nickname."' AND `password` = '".md5($password)."' LIMIT 1;");
$user = mysql_fetch_array($q);
$uid = $user['id'];
$nickname = $user['nickname'];
$pass = $user['password'];
$ip = $user['ip'];
$ua = $user['ua'];
$kick = $user['kick'];
$moder = $user['moder'];
$reason = $user['reason'];
$name = $user['name'];
$site = $user['site'];
$sex = $user['sex'];
$from = $user['from'];
$mobile = $user['mobile'];
$email = $user['email'];
$birthday = $user['birthday'];
$about = $user['about'];
$posts = $user['posts'];
$lev = $user['level'];
$answers = $user['answers'];
$gbalans = $user['gbalans'];
$status = $user['status'];
$regdate = $user['regdate'];
$place = $user['place'];
$photo_type = $user['photo'];
$time = $user['time'];
$mood = $user['mood'];
$shoutbox= $user['message'];

        
echo "Room:<br/>\n";
echo "Obrati paznju na ime sobe, da soba sa takvim nazivom vec ne postoji i da ne krsi uslove koristenja chata<br/>\n";
echo "<br/>";

if(!isset($_POST['action']))
{
echo "ime sobe:<br/>\n";
echo "<input name=\"name$nocache\" maxlength=\"15\" title=\"name\"/><br/>\n";
echo "Position:<br/>\n";
echo "<input name=\"position$nocache\" format=\"*N\" size=\"2\" maxlength=\"2\" title=\"position\"/><br/>\n";
$type = '3';
echo "<anchor>[Kreiraj]<go href=\"create_my_room.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=addroom\" method=\"post\">\n";
echo "<postfield name=\"name\" value=\"$(name$nocache)\"/>\n";
echo "<postfield name=\"position\" value=\"$(position$nocache)\"/>\n";

echo "<postfield name=\"action\" value=\"$(add$nocache)\"/>\n";
echo "</go></anchor><br/>\n";
}
else
{
$type = '3';
$mid = $id;
$name = trim(mysql_escape_string(htmlspecialchars($_POST['name'])));
$name = str_replace('$', '$$', $name);
if(empty($name))
{
echo "Niste unijeli ime sobe!<br/>\n";
break;
}


$position = intval($_POST['position']);
if($postion < 0) $postion = 0;
if($postion > 10000) $postion = 10000;
$type = intval($_POST['type']);
if($type < 0) $type = 0;
if($type > 2) $type = 0;
$q = mysql_query("SELECT `name` FROM `chat_rooms` WHERE `name` = '".$name."';");

if(mysql_affected_rows() != 0)
{
echo "Soba sa takvim imenom vec postoji.<br/>\n";
break;
}

$q = mysql_query("SELECT COUNT(*) FROM `chat_rooms`;");
$result = mysql_result($q, 0);

if($result > 25)
{
echo "Too many established rooms!<br/>\n";
break;
}

$sql = mysql_query("INSERT INTO `chat_rooms` VALUES('()', '".$name."', '".$position."', '".$name."', '".$type."', '".$mid."');");
$room = mysql_insert_id();
$sql = mysql_query("CREATE TABLE `chat".$room."` 
(
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;");

    if($sql)
    {
    echo "Room successfully created!<br/>\n";

    if($type == 3) echo "<a href=\"mroom.php?".SID."&amp;ver=wml&amp;rid=$room\">The room</a><br/>\n";
    }
    else
    {
    echo "Error.<br/>\n";
    echo mysql_error();
    }
}echo "<br />\n";
echo "<a href=\"rooms.php?".SID."&amp;ver=wml\">Chat Sobe:</a><br/>\n";
echo "<a href=\"menu.php?".SID."&amp;ver=wml&amp;nocache=$nocache\">Livechat meni</a><br/>\n";
list($msec, $sec) = explode(chr(32), microtime());
echo "<small>[".round(($sec + $msec) - $headtime, 5)."]</small><br/>\n";
require_once "includes/functions/gzip_foot.php";
echo "</p></card></wml>";
ob_end_flush();
break;

case 'html':
///////////////////////////////////////////////////////
//HTML VERSION
///////////////////////////////////////////////////////

$my_title = "rom admin";
if(!isset($_COOKIE['theme'])) $_COOKIE['theme'] = 1;
include_once "themes/".intval($_COOKIE['theme'])."/index.php";
//AUTH
$id = intval($_SESSION['id']);
$password = mysql_escape_string($_SESSION['password']);
$q = mysql_query("SELECT nickname FROM `chat_users` WHERE `id` = '".$id."' AND `password` = '".md5($password)."';");
    if(mysql_num_rows($q) == 0)
    {
    echo "Authorization Failed!<br/>\n";
    include_once "themes/".intval($_COOKIE['theme'])."/foot.php";
    exit();
    }
//END AUTH
$nik = mysql_result($q, 0);
$user = mysql_fetch_array($q);
$mid = $user['id'];
$nickname = $user['nickname'];
$pass = $user['password'];
$ip = $user['ip'];
$ua = $user['ua'];
$kick = $user['kick'];
$moder = $user['moder'];
$reason = $user['reason'];
$name = $user['name'];
$site = $user['site'];
$sex = $user['sex'];
$from = $user['from'];
$mobile = $user['mobile'];
$email = $user['email'];
$birthday = $user['birthday'];
$about = $user['about'];
$posts = $user['posts'];
$lev = $user['level'];
$answers = $user['answers'];
$gbalans = $user['gbalans'];
$status = $user['status'];
$regdate = $user['regdate'];
$place = $user['place'];
$photo_type = $user['photo'];
$time = $user['time'];
$mood = $user['mood'];
$shoutbox= $user['message'];


echo "<!-- Developed by martin suvalj -->\n";

$chat = file("chat.dat");
$logo = trim($chat[0]);
$message = trim($chat[1]);
if(!empty($logo)) echo "<img src=\"http://$logo\" alt=\"\" /><br/>\n";
if(!empty($message)) echo "$message<br/>\n";

if(!isset($_POST['action']))
{
echo "<div class=\"form\">\n";
echo "<form method=\"post\" action=\"create_my_room.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=addroom\">\n";


echo "napravi svoju sobu , budi siguran da ime sobe vec ne postoji!<br/>\n";

echo "Title:<br/>\n";
echo "<input name=\"name\" maxlength=\"15\" title=\"name\"/><br/>\n";
echo "pozicija:<br/>\n";
echo "<input name=\"position\" size=\"2\" maxlength=\"2\" title=\"position\"/><br/>\n";
$type = '3';
$mid = $id;

echo "</select><br/>\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>\n";
echo "<input type=\"submit\" value=\"Create\"/></form></div><br/>\n";
}
else
{


$name = trim(mysql_escape_string(htmlspecialchars($_POST['name'])));
$name = str_replace('$', '$$', $name);
if(empty($name))
{
echo "Prazan naziv sobe!<br/>\n";
break;
}
$type = '3';
$mid = $id;
$position = intval($_POST['position']);
if($postion < 0) $postion = 0;
if($postion > 100) $postion = 100;
$type = intval($_POST['type']);
if($type < 0) $type = 0;
if($type > 12) $type = 0;
$q = mysql_query("SELECT `name` FROM `chat_rooms` WHERE `name` = '".$name."';");

if(mysql_affected_rows() != 0)
{
echo "Zao nam je  naziv sobe sa takvim imenom vec postoji!<br/>\n";
break;
}

$q = mysql_query("SELECT COUNT(*) FROM `chat_rooms`;");
$result = mysql_result($q, 0);

if($result > 1000)
{
echo "Zao nam je  trenutno ima Previse privatnih soba!<br/>\n";
break;
}

$sql = mysql_query("INSERT INTO `chat_rooms` VALUES('()', '".$name."', '".$position."', '".$name."', '".$type."', '".$mid."');");

$room = mysql_insert_id();

$sql = mysql_query("CREATE TABLE `chat".$room."` 
(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;");


    if($sql)
    {
    echo "Soba uspijesno kreirana!<br/>\n";
    if($type = 3) echo "<a href=\"room.php?".SID."&amp;ver=html&amp;rid=$room\">udji u sobu</a><br/>\n";

    }
    else
    {
    echo "Error. greska s bazama podataka (izvjestaj je dolje)<br/>\n";
    echo mysql_error();
    }
}


echo "<br />\n";
echo "<img src='ikone/line.jpg' alt='--'> <br/>\n";
echo " <img src='ikone/chat.gif' alt='chat'>  <a href=\"rooms.php?".SID."&amp;ver=html\">Chat Sobe:</a><br/>\n";
echo "<img src='ikone/calen.gif' alt='my'><a href=\"menu.php?".SID."&amp;ver=html&amp;nocache=$nocache\">LiveChat meni</a><br/>\n";
include_once "themes/".intval($_COOKIE['theme'])."/foot.php";
break;
}
?>
i try use int(11) but dont work :(

**martinzenica** · 20.09.11, 15:29

Thanks to all good people but I still I found a problem in the script. I really like the author forgot to define $ type = '3 ';
$ mid = $ id;
$ locked = '0 ';
$ lv = '0 ';
explanation of the problem here is PHP

PHP Code:

///those are missing .. for chat_rooms tabele
$type = '3';
$mid = $id;
$zakljucan = '0';
$lv = '0';

$sql = @mysql_query("INSERT INTO `chat_rooms` VALUES(0, '".$name."', '".$position."', '".$name."', '".$type."', '".$mid."', '".$zakljucan."', '".$lv."');");

While I have programmed a new chat options for master (owner of room) I forgot to define and add the php code as you can see .. So for now, and thank you all once again

Help me oh this script .

Help me oh this script .

Comment

Comment

Comment

Comment

Comment

Comment

Comment