- if(!DB->QExecute("INSERT INTO characters (account_name, char_name, face, hairStyle, sex) VALUES('%s','%s',%i,%i,%i)", thisclient->username, newname.c_str(), face, hairstyle, sex))
- return false;
- unsigned int mid = (unsigned)mysql_insert_id( DB->Mysql );
- MYSQL_ROW row;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,151,2,9,120,100,2,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,151,3,9,120,100,3,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,151,4,9,120,100,5,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,151,5,9,120,100,6,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,161,8,9,120,100,7,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,162,1,9,120,100,1,1,0,1,0,0)", mid))
- return false;
- if(!DB->QExecute("INSERT INTO items VALUES(%i,764,6,9,120,100,4,1,0,1,0,0)", mid))
- return false;
- if(sex==0)
- {
- if(!DB->QExecute("INSERT INTO items VALUES(%i,222,2,0,40,100,12,1,0,0,0,0)", mid))
- return false;
- }
- else
- {
- if(!DB->QExecute("INSERT INTO items VALUES(%i,221,2,0,40,100,12,1,0,0,0,0)", mid))
- return false;
- }
- STARTPACKET( pak, 0x0713, 8 );
- SETWORD ( pak, 0x00, 0 );
- thisclient->SendPacket( &pak );
- return true;
- }
So I'm pretty newb at this (rose development) so I was wondering how tho the stb files work over rose and how can I make my own items so I could add them to the server, I'm talking about jewels like rings because I suppose making a new "suit" could be really difficult.
Hope I made myself clear if not let me know